Home

VVKarri - Oracle EBS Architect

[email protected]

Location: Dallas, Texas, USA

Relocation: Yes

Visa: H1B

[email protected] 864-406-9445 [email protected] __________________________________________________________________________________________ PROFESSIONAL SUMMARY Over 12+ years of experience in Software development Worked in Onshore/offshore model. Experienced in different roles of Sr Developer/Developer Extensive experience in designing applications which would give less/no production issues. Extensive experience in managing full software development lifecycle - requirement, mapping, design, development, testing, deployment code to from SIT to till production, Implementation, and post-production. Experience in development of D2K (Forms, Reports)/Packages/Stores Procedures/XML/BI Reports/Shell scripts/Workflow/Custom.pll/Form personalization/OAF. Creation of Packages/ procedures/Functions. Writing complex SQL queries Developed collections, Bulk Binds, Ref cursors. Developed data conversions/Interfaces and API s of Oracle Applications System in GL, AP, AR, CM Experienced in ETL processes from legacy to Oracle apps. Experienced in troubleshoot prod issues like performance, code debugging. Experienced in resolve the performance issues and improve performance of the application. Well versed with business processes ofP2P( Inv,PO, iProc, AP), O2C( OM, Shipping, Tax, Pricing, AR) ,GL Experienced in BR100,MD50, MD70, TE20 using AIM Experienced as L1 & L2 Support Lead(Hypercare & Post production) Experienced in Middleware technologies Oracle SOA and Adept with development tools like JDeveloper and Eclipse. Involved in four full implementations/upgrades/Rollouts/Enhancement projects of Oracle Applications System. Expertise in Full development as well as Production Support. Excellent communicator, a Strong information analyst and a Continuous learner SKILLS ERP : Oracle Applications 11i (11.5.0, 11.5.8, 11.5.9 and 11.5.10) and R12(12.1.3,12.2+) Fun Modules : GL, AP, AR, CM, FA,iProc, PO, Sourcing,OM,Shipping, Pricing, Inv,HRMS Oracle FMW : Oracle SOA Suite (10.1.3), BPEL, ESB,OSB GUI : Oracle Forms 4.5, 6i and 9i, Reports 2.5 & 6i,Visual Basic 6.0, JDeveloper 10g 11g,, workflow Builder 2.5,XML PUBLISHER Languages : Pl/Sql,Sql,C, C++, Java, XML, XSD, XSLT, XPATH, XQUERY Database : Oracle 8i, 9i, 10g,11i and MS-Access Tools : HP Quality Center (QC), Toad, PVCS, Kintana, SVN,MPP, power point. OS : DOS, Windows NT / 2000/ 95/ 98 /XP PROFESSIONAL TRAINING & CERTIFICATIONS Certified CMMI Training. Certified Six Sigma Training. Oracle Fusion Middleware training, Cognizant. Oracle fusion apps financials,SCM training. PROFESSIONAL EXPERIENCE Technical Architect/Sr Developer, UnitedIT Inc Mar-22 - Present Technical Lead/ Sr Developer, IVC , UnitedIT Inc IVC is International Vitamin Corporation which is US based company, they have oracle applications (EBS -12.2.2) being implemented to Oracle EBS(12.2.10) in areas of Oracle Financials, SCM, Manufacturing modules. Worked on conversions (Sales orders, Customers, Open PO, Suppliers, Items, AP, AR invoices, GL )/ /Interfaces from other systems to oracle Apps and deploy/move code from one instance to other instance till production. As Tech Lead/ Sr Developer, Understands the business requirements. Prepare technical design and get it approved with IT Lead Develop sql Loader, sql scripts, pl/sql scripts for conversions/ interfaces, Oracle/BI/XML reports. Create new form by using standard TEMPLATE.fmb, Oracle Reports. Register concurrent programs in system. Prepare TE20 test cases, MD70 technical docs and provide KT to support teams. Laisse with Functional analyst for testing technical objects Liaise with DBA s to coordinate deployment of objects in different env. Guide junior resources and code reviews. Raise Oracle SR and follow up till resolution of the issues. Prepare test cases and capture the results for reference. Participate in SIT,SIT1,2, UAT Participate in Project deployment strategy for functional and technical deployments with sequence and dependence of objects/Setups. Troubleshoot the issues after deployment in new env and make instance stable. Support Hypercare. Environment Oracle Erp R12 e-Business Suite(12.2), PL/SQL, business objects, workflow, OAF, Custom.pll, AP,AR, GL,CM,FA, WIP,BOM, INV, OM, PO. Manager, Capgemini Sep 14 Feb-22 Hypercare Lead/Support Lead/Sr Developer, Sr Developer/Support Lead, Lendlease , Australia Lendlease which is located in Australia implemented Oracle ERP R12 in Financials, SCM, HCM modules. This project is aimed to develop new solutions for existing functionality and take up new functionality and develop the system. Develop components and release code monthly. Provide warranty support after release. As Developer, Understand functional requirements. Do the technical analysis and provide estimates Conduct daily status calls with onsite team. Finalize design before coding starts. Write code and unit test Conduct Code walk-through. Guide team in day to day activities. Review test cases. Conduct and participate in SIT, UAT. Conduct Rifleshots and render post production support. Environment: Oracle Erp R12 e-Business Suite (iProc, PO, AP, GL,AR,CM,HCM,SCM), Oracle 11g Database, Pl/sql Developer, Sql Developer Tools,Ms excel, visio, MS PPT. Functional Developer, Client: General Electrical, across globe. The PMO projects is aimed to automate/Implement ORACLE 12i P2P process for GE corporate across all Geographies which will include North America, South America, ASIA , EUROPE, RUSSIA and Australia.. These PMO projects will consist of I-procurement, Purchasing, Accounts payables and General Ledger modules. These PMO projects will be implemented in two ways, one is fresh implementation and other one is Re-implementation from Oracle 11i to Oracle 12i. These projects will follow GE typical in-house custom tools as part of Oracle R12 implementations for setups and AP invoice validation etc. There will be data flow from third party systems to Oracle 12i and Outbound flow from Oracle 12i to other systems in GE. Responsibilities: Analyze business requirements and provide solutions to business. Setup modules of Iproc, PO,AP Load CVR rules Setup security rules. Gatekeeper s setup for req approvals. Setup accounting generator. Bank setups Intercompany and intracompany setups. Participate in SLA setups. Analyze and freeze tax requirements and implement in Sabrix system. EB-tax configuration Data migration from legacy system to Oracle E-biz system. Creating payment templates and payment calender. Conduct and participate in UAT. Conduct Rifleshots and render post production support. Conduct meetings with business Environment: Oracle apps R12 Senior Associate, Cognizant Technology May 09 Jul-14 Sr Developer Client: VMWARE, USA. This project is aimed to support ERP system in production. The implementation project was aimed to automate the process in VMWARE by E-business suite (Oracle apps 11i) technology. This project covers Oracle CRM. The project activities include BME (Bug fix and minor enhancements in production). Responsibilities: Worked as L2 Lead/Developer.. Worked on requirements gathering and its analysis. Worked on converting functional documents into technical documents. Developed reports/Forms/Interfaces/Function/Procedures/Shell/ Scripts/Form personalization/CUSTOM pll across modules of P2P. To register objects in Oracle applications and to prepare test cases. Worked on production tickets and resolution. Worked on performance tuning of application. Worked extensively on post production maintenance work (Tickets handling, Bug Fixes, and Minor Enhancements). Responsible for timely quality deliverables. Environment: Windows,Oracle Applications 11i CRM(IB,SA),OM, Forms 6i, Sun Solaris, Oracle 11g Database Developer Client: ADNIC, ABU DHABI, UAE. This project is aimed to support ERP system in production. The implementation project was aimed to automate the process in ADNIC by E-business suite (Oracle apps 12i) technology. This project covers Oracle financials 12i. The project activities include BME (Bug fix , minor and major enhancements in production). Responsibilities: Leading a team of 3 people. Worked on requirements gathering and its analysis. Worked on converting functional documents into technical documents. Developed reports/Forms/Interfaces/Function/Procedures/Shell/ Scripts/Form personalization/CUSTOM pll. To register objects in Oracle applications and to prepare test cases. Worked on performance tuning of application. Worked extensively on post production maintenance work (Tickets handling, Bug Fixes, and Minor Enhancements). Responsible for timely quality deliverables. Environment: Windows,Oracle Applications 12(12.1.3(AR, AP, PO, FA, GL, CM)),HR,PAYROLL, Forms 6i, Sun Solaris, Oracle 10g Database Sr Developer Client : Hartford Insurance, USA. National Account Database (NADB) division of The Hartford caters to the underwriting and loss sensitive billing needs of large Commercial lines of business. Key business segments include RMD, IR, Construction, Middle Market, Key accounts, Alternate Market (Captive programs) & Specialty Risk Services (SRS). NADB has requested Cognizant to implement and provide MSM services that includes production support activities (MPS), maintenance services (MAS), invest services (strategic major enhancements and projects) to support their business. End to end scope of this MSM project/engagement includes knowledge acquisition, document the application details and execute above mentioned MSM services. Responsibilities: Communicate with business / BA to get requirements and clarifications if necessary and pass it to the offshore team and perform the design and code review. Interact with other interface teams and BAs. Perform design and coding review. Review project estimates with offshore and also with client tech lead. Perform initial analysis for any major issues and provide direction to the offshore team. Participate in QA, UAT testing and fix the issues timely manner. Conduct performance testing and tune the system wherever required. Coordinate with client tech lead for design/code reviews. Support business and BA s to run jobs and provide reports for testing. Ensure timeliness and quality of deliverables. Environment: HP,Unix ,Windows,Pl/sql, Unix shell scripts, Oracle forms 6i, Reports 6i,ppm. SOA Devloper Client: T-Mobile, USA. Enterprise Service Modernization project is implemented at T-mobile to trim costs of existing TIBCO middleware and its maintenance. This project is aimed to bring down no of interfaces from existing 800 in TIBCO to 150 and integrate the process with different systems HSOS,UPS . This project is to provide unified integration platform using Oracle Fusion to communicate with internal and external systems. The production support Level1 covers monitoring system health, handling tickets in Oracle fusion middle ware stack (SOA, BPEL, OSB, and JMS). I have been working in this project as senior analyst to troubleshoot the tickets, monitoring system health 24/7 rotation. Responsibilities: 24 x 7 support of multiple complicated J2EE environments that utilize Oracle WebLogic Server, Weblogic Portal, Oracle Service Bus, and Oracle SOA Suite. Implemented processes and scripts to automate deployment of SOA components. Perform crisis management when necessary including root cause analysis. Design and implement support standards for new and complicated web based environments. Designed and implemented solutions to report health and stats on deployed services. Installed and configured Weblogic Admin server and Node manager. Installed and Configured SOA governance to secure services and to monitor services health Setup HA environment for development, QA and Prod with clustered OSB, BPEL servers and LB. Migrated OSB,BPEL to Prod, identified and resolved many deployment and configuration issues Cleaned codes and setup best practice for SOA Governance. Designed and developed monitoring and alert system to keep track of SOA HA health. Involved in vigorous testing and training of new SOA environment. Designed and developed many OSB and BPEL processes to meet complex requirements. Production support of High availability SOA servers and BPEL/OSB applications. Tuned many long running BPEL and OSB processes for better performance. Environment: Web logic 10.3.3, J2EE, Struts, Oracle 11g, XML, Oracle SOA (OSB, BPEL), TIBCO, CVS, JSP, Test Director, HTML, SQL, Windows NT/2000/2003, Java, JavaScript, MS Office, PL/SQL developer, SQL server 2005. , UNIX, HP Quality center (QC), Wiley, BMC Remedy User, BAC, Retail Operation Center of Service ROCS, JRocket and Toad. Developer, Quest Project (Oracle E-business Suite) Client: Schneider National, USA. Team size: Environment: Oracle Applications 12(12.0.5(AR, AP, PO, FA, GL, CM)), Oracle Hyperion,Oracle ESSBASE, SOA, BPEL, ESB, Forms 6i, Sun Solaris, Oracle 10g This project is aimed to automate the process in Schneider national by Oracle Apps 12 technology. This project is totally a new implementation which involves - Requirement Analysis, Design, Build and Manual testing, Post-production support. This project is integrated with Oracle Essbase, Siebel, Oracle OTM products, ODI, Oracle Hyperion. The manual testing in this project covers Oracle financials, Oracle Hyperion and Oracle Essbase. Responsibilities: Document and execute test plans, scenarios and scripts, and manage test artifacts / deliverables. Log software defects in the HP Quality Center (QC) defect tracking tool and track to closure Review requirement documentation to ensure technical accuracy, compliance or completeness or to mitigate risks. Participate in design reviews to provide input on functional requirements, product designs, schedules, or potential problems. Document and review plans, schedules, data needs and scenarios for end-to-end integration testing including areas such as database impacts, software scenarios, or usability. Manage QA environments and perform application deployment and troubleshooting. Develop close working relationships with members of teams within the organization. Coordinate with offshore development and test teams and facilitate issues resolution. Become knowledgeable of core technology, infrastructure and standards. Interface with other groups to test and implement solutions. Support and maintain Risk Web, Risk Services and batch jobs critical to the day-to-day functions of business units. Proactively identify QA risks and escalate as needed, and collaborate with PMO, QA and Dev teams to identify mitigation. Provide regular, up-to-date status reports for the Risk area and overall status reports for the project covering progress and state of end-to-end integration testing activities. EDUCATIONAL QUALIFICATIONS Msc (Computer Science) from Andhra University. B.Sc (Computer Science) from Andhra University. Keywords: cprogramm cplusplus quality analyst business analyst business intelligence information technology hewlett packard purchase order microsoft procedural language Arkansas South Carolina