Wipro InfotechAssociate Consultant
Sep. 2011 - Jul. 2015Gurgaon, IndiaWorked as Oracle Apps Technical Consultant on module iRecruitment and also performed Functional Activities for our client Genpact. I was involved in direct client interaction for requirement gathering, analysis, project plan, effort estimation, cost estimation, designing and delivery of products. I ensured proper coding standards & error handling as per Oracle standards and migration of application/product from test environment to live environment. I was required to code and review the PLSQL code for performance. Extensively I have worked on Oracle SQL, PL/SQL, Query performance tuning, creating DDL scripts, database objects like Tables, Views Indexes, Synonyms and Sequences. I also needed to create all the documents that were required for the code changes done, such as MD 50 - 70, BR 100. I have worked on modules like iRec and SSHR. Before this i was a part of two major support projects - Videocon ADMS(IND) and Atheeb Telecom(KSA). Here my job was to daily generate reports. I had to analyze business problems and translate it to effective technical solutions. I had to attend meetings for capturing customer details and also give the solutions to them. I developed complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.