SUMMARY:

• 10+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server and Teradata
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Strong experience with unformatted files or XML sources and targets.
• Strong experience in developing real time solutions with Informatica Webservice.
• Strong with relational database design concepts.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Independently perform complex troubleshooting, root - cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS:

BI Tools: Informatica, Business Objects, Cognos and Unix Shell Scripts

Databases: Teradata and Oracle

Scheduling Tools: Autosys, ESP

Tools: TOAD, SQL Developer, SQL Assistance and ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr Informatica Developer

Responsibilities:

• Designed and developed ETL components based on the System Requirements.
• Participate in User requirements review sessions and identify the functional and non-functional system requirements.
• Participate in Architecture discussions and identify the non-functional system requirements.
• Participate in leadership meetings and provide regular build status.
• Coordinate with cross commit teams for any dependency.
• Coordinate with offshore team in sharing the project and build status.
• Build ETL components to access the Mainframe source files through Power Exchange.
• Build ETL components to access the XML sources and create XML targets for few front-end applications.
• Build ETL components to enable the web services for few business manager-facing applications, to access the data from SQL SERVER databases.
• Perform impact analysis on any changes to existing applications.
• Prepare mapping documents as per the System Requirements.
• Perform performance impact analysis for high volume data flows.

Confidential, St Louis Park, MN

Lead Developer and Onsite Coordinator

• Responsible for project end to end Technical DWH solution delivery and provide Warranty.
• Participate in Project Business Scope meetings and provide technical assumptions and Estimations. Co-ordinate with offshore team and evaluate Scope, assumptions and estimations.
• Prepare SAS and LLD Documents and review with Project Teams.
• Design and develop project solution with Informatica as per the Data Mapping Document / FSD.
• Evaluate Business Requirements with provided Data Mapping Document.
• Reverse Engineering on providing the existing application mapping document for enhancements.
• Plan and execute Performance Test in DEV and QAT environments with all participating partners.
• Plan and execute Unit and Integrations Testing in Development with all participating partners.
• Handling various technical aspects like project documentation, system design & integration, coding of modules, monitoring critical paths & taking appropriate actions for multiple projects.
• Designing and executing test plans, test cases and test scripts/procedures, gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.
• Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.
• Analyzing business needs & spearheading initiatives to enhance business by building case studies.
• Mapping client/business requirements and providing customized software solutions involving finalization of product specifications and selection of appropriate techniques.
• Conducting system study and coordinating with team members for System Design & Integration, Application Maintenance, etc.
• Handling various technical aspects like software design, coding of modules, monitoring critical paths & taking appropriate actions.

Sr Informatica Developer and Onsite Coordinator

• Responsible for project end to end Technical DWH solution delivery and provide Warranty.
• Participate in Project Business Scope meetings and provide technical assumptions and Estimations. Co-ordinate with offshore team and evaluate Scope, assumptions and estimations.
• Prepare HLD and LLD Documents and review with Project Teams.
• Design and develop project solution with Informatica as per the Data Mapping Document / FSD.
• Evaluate Business Requirements with provided Data Mapping Document.
• Reverse Engineering on providing the existing application mapping document for enhancements.
• Plan and execute Performance Test in DEV and QAT environments with all participating partners.
• Plan and execute Unit and Integrations Testing in Development with all participating partners.
• Handling various technical aspects like project documentation, system design & integration, coding of modules, monitoring critical paths & taking appropriate actions for multiple projects.
• Designing and executing test plans, test cases and test scripts/procedures, gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.
• Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.
• Analyzing business needs & spearheading initiatives to enhance business by building case studies.
• Mapping client/business requirements and providing customized software solutions involving finalization of product specifications and selection of appropriate techniques.
• Conducting system study and coordinating with team members for System Design & Integration, Application Maintenance, etc.
• Handling various technical aspects like software design, coding of modules, monitoring critical paths & taking appropriate actions.

Confidential, Cincinnati, OH

Teradata Developer

Responsibilities:

• Enhancement of existing production applications that has less than 120 Person days Development efforts.
• Design and develop the solutions for any enhancements in RDW module of BI DWH.
• Coordinate with the Release teams / Development Teams for any conflict releases on same applications.
• Monitoring Production Jobs, identifying recursive failures and providing Permanent Fixes.
• Monitoring Production jobs, identifying SLA impacting jobs and initiating WR’s for enhancements.
• Participate in Business requirement meetings with onsite coordinator.
• Provide Daily and Bi-Weekly Reports to the Managers.
• Ensuing the proper communications and Status shared to business teams.

Confidential, Atlanta, Georgia

Informatica Developer

Responsibilities:

• Enhancement of existing production applications that has less than 120 Person days Development efforts.
• Design and develop informatica mappings as per the requirements received from onsite leads.
• Perform impact analysis to the onsite coordinates as a day to day activities.
• Identify and provide the informatica performance related bottlenecks and its resolutions.
• Participate in Business requirement meetings with onsite coordinator.
• Provide Daily and Bi-Weekly Reports to the Managers.
• Ensuing the proper communications and Status shared to Business teams.