Database Programmer

• Jul 2021 - Present

Technical Consultant

• Sep 2010 - Aug 2014

• Implemented reusable objects in Teradata and Informatica effectively. • Extensively worked on complex stored procedure migration from SQL server to Teradata and worked on optimization of long running procedures. • Worked on Impact analysis and implementation of change in requirement • Designed ETL High and Low level design documents. Also developed ETL Mappings based on requirement and prepared them for deployment into test and production environments. • Designed template for SP creation using reverse engineering, UAT sheet, issue and defect tracker and migration document. Also maintained defect and issue log every day to report it to business using QC. • Provided estimation of sql procedure migration to Business. Also reviewed code implementation and ensure that all solutions are aligned to pre-defined architectural specifications. • Report generation based on source systems using reverse engineering. • Involved in scheduling of jobs and UAT/Production support and implementation. • Played key role in solving production critical defects within timeline. • Framing project documents like Informatica Standards code checklists for Development team, Informatica run book which will help the production support team to maintain the code moved into production environment • Involved in estimation of new deliverables • Mentored newly joined associates in project teams Show less

Senior Software Engineer

• Oct 2007 - Sep 2010

• Work closely with Project Manager to assess goals and provide time and effort estimation of task assigned to offshore team • Interaction with the Client Solution architect to get sign off on development requirement and design document. • Extensively worked on understanding the requirements given by the Business Analyst and provide design and solution to those requirements. Creation of low and high level design documents for that. • Involved in creation of the new data flow to satisfy the application requirement and future need to create OBIEE reports. • Trained and mentored newly boarded associates on project • Involved in regular ETL’s creation, Self and Peer to peer Review of Code • Baseline Unit/Integration Test Specification Requirements, ETL code checklist, Review checklist. • Successful completion of POC to complete the data load within 2hours for large data volume • Study functionality of the existing reports created on Java platform and documentation of it. • GAP analysis for the report’s, understood the existing DW and also mapped the existing system with new requirements; provide the solution for the same • Validated existing system with newly implemented system in Production Show less