Summary:

• 7+ years of software development and sustenance experience which includes design and development of data warehousing projects as ETL Developer/Designer using Informatica, Oracle and UNIX.
• Strong Skills in Data Warehousing Concepts, Informatica, Oracle, SQL, PL/SQL.
• Well conversant in Software Development Methodology, analysis, business process, designs, coding and participated in all phases of Software Development Life Cycle.
• Experience in requirement gathering from business users and provide designing approach to reviewers.
• Exposure to Health care and financial domains.
• Capability of deploying projects from development environment into Production.
• Strong skills in defect resolution.
• Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
• Strong knowledge on Audit Balance Framework.
• Proficient in creating accurate and comprehensive code to meet the business requirements.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Skilled to provide out-of-the-box approaches to fulfill design requirements within existing technology and process constraints.
• Provide technical leadership, mentorship, and coaching to team members.

TECHNICAL SKILLS

Technology Tools: Data Warehousing Informatica 7.1.2, 8. 1.1,8.6,9.5

Databases : Oracle 10g /11g(Exadata),MS SQL Server 2005/2008/2012

Languages : SQL, PL/SQL, UNIX Shell Scripting

Verticals: He alth care and Financing

PROFESSIONAL EXPERIENCE

Confidential, NY

Role : Sr Developer / Designer

Responsibilities:

• Gather requirements and provide efficient designs.
• Design end-to-end flow to meet LFGD requirements .
• Develope reusable Informatica mappings, mapplets and sessions for audit balance framework.
• Worked closely with business for DMD changes.
• Develop ETLs, Unit Test , Assembly Test and provide support during QA and UAT.
• Build reusable components wherever possible for better reusability and reduce complexity.
• Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
• Prepare Unit test documents , Assembly Test Documents and LLD Documents.
• For Assembly testing, worked with business to provide and validate the data for business test cases
• For Assembly testing, create the list of jobs to be executed and the order of execution in Dev to simulate it in Production for Autosys.
• Co-ordinate with other source systems to load the data for Assembly Testing.

Role : Sr Developer / Designer

Responsibilities:

• Gather requirements and provide efficient designs.
• Design end-to-end flow to meet Geneva requirements .
• Develop ETLs, Unit Test , provide UAT /Prod support and handle production release.
• Deployment of ETL changes to higher environments.
• Create UNIX scripts for ftp’ing the target files.
• Build reusable components wherever possible for better reusability and reduce complexity.
• Use pushdown optimization concept for better performance.
• Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
• Leading the ETL Development team

Confidential

Role: Developer/Designer

Responsibilities:

• Design end-to-end flow for GSL .
• Develop ETLs, Unit Test and provide UAT /Prod support and handle production release.
• Deployment of ETL changes to higher environments.
• Create UNIX scripts for ftp’ing the target files.
• Build reusable components wherever possible for better reusability and reduce complexity.
• Used pushdown optimization for better performance.

Confidential, New York

Role : Developer/Designer

Responsibilities:

• Redesign CRC ABC architecture to fit GSL project.
• Design end-to-end flow for GSL .
• Develop ETLs, Unit Test cases and provide UAT /Prod support and handle production release.
• Deployment of ETL changes to higher environments.
• Create UNIX scripts for ftp’ing the target files.
• Build reusable components wherever possible for better reusability and reduce complexity.

Confidential

Role : Developer/Designer

Responsibilities:

• Involved in all phases of the cycle(Requirement gathering to Production deployment)
• Design and develop the mappings using different sources like XML, COBOL, Flat files, Oracle, SQL Server, and Message Queues etc.
• Design and develop reusable components.
• Automate some of the processes in the project.
• Design, Cod e, Unit Test , provide UAT /Prod support and handle production release.
• Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
• Deployment of ETL changes and DB changes to higher environments.

Role : Informatica Developer

Responsibilities:

• Analyse the Business Requirements Documents.
• Design and d evelop the mappings/workflows as per the high level ETL architecture.
• Prepare unit test cases.
• Design and develop reusable components to reduce complexity and encourage reusability.
• Involved in Unit Testing and Performance tuning of both Informatica mappings
• and database queries.
• Writing stored procedures and shell scripts.