SUMMARY:

• 11+ years of experience in the Information Technology, Gained knowledge in Requirement Analysis, Design, Development and Maintenance of Business Applications. Worked extensively in Data warehousing methodologies, project estimation & project planning activities
• Strong expertise in data warehouse applications and Reports, Testing methodology
• Worked on DW projects using technologies like Informatica, Teradata, SQL Server and Oracle
• OCA (Oracle Certified Associate) & Oracle Certified Expert
• Strong knowledge in ETL techniques including Data Modeling, Partitioning & Performance Tuning
• Have Good Exposure in data base queries and RDBMS Concepts
• Flexibility and Adaptability in regards with new Technologies and environments
• Expertise in SQL activities such as business rules validation, referential integrity validation, ETL Audit process validation
• Experienced in interacting and working with Business Analyst, Development Team, QA Team, Production Support Team

TECHNICAL SKILLS:

ETL Tools: Informatica, Datastage

Databases: Teradata, Netezza, Oracle, MS - Access, SQL Server

Utilities: SQL Assistant, Toad

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Analyze the Requirements/CRs from Analyst
• Prepare EDD & Mapping document for all the Development / Enhancement Changes
• Build & Unit testing will be done & share the results to GC Customer for Sign off & moving the codes to higher Environments
• Deliver the code, Validate the check list
• Do code sanity check in system testing environment.
• Fixing for defects raised during Dev, QA and UAT Validation, promote the codes to PRODUCTION Environment.

Confidential

Responsibilities:

• Analyze the Requirements/CRs from Analyst
• Solution Documents & Test cases will prepared & presented to leads for the requirements and approvals
• Build & Unit testing will be done & share the results to HN for moving the codes to higher Environments
• Deliver the code, Validate the check list
• Do code sanity check in system testing environment.
• Fixing for defects raised during Dev, QA and UAT Validation, promote the codes to PRODUCTION Environment.

Confidential

Responsibilities:

• Analyze the Requirements/CRs from KP Analyst
• DoU will prepared & presented to KP leads for the requirements
• Deliver the code, Validate the check list & move the codes to higher environment
• Do code sanity check in system testing environment.
• Fixing for defects raised during QA and UAT Validation, promote the codes to PRODUCTION Environment.

Confidential

Responsibilities:

• Code Validation for deployed components in QA & UAT Environments
• Co-ordination with Dev team, SCRM & DBA team for the code validation process.
• Deliver code migration check-lists, Validate & move the codes to higher environment
• Do code sanity check in system testing environment.
• Analyze, figure out root causes, fixes for defects raised during QA and UAT Validation.
• Re-assigning the failed deployments to Dev/SCRM/DBA team for the next deployments.

Confidential

Responsibilities:

• Understand the functional requirements, and come up with Informatica mapping Design.
• Participated in technical design reviews, presenting Informatica mapping designs
• Developed mappings that extracts data from source tables, transformed source columns using various transformations such as aggregator, expression etc., and loaded them into target tables
• Prepare Unit test case and unit test logs.
• Deliver code migration check-lists, Validate & move the codes to higher environment
• Do code sanity check in system testing environment
• Analyzed, figured out root causes, fixes for defects raised during system testing and UAT

Confidential

Responsibilities:

• Involved in design and development for transformations that are common across mappings
• Translate the business requirements into technical specifications and prepared Technical Design Document (TDD).
• Prepare the Test cases & Review for Unit testing
• Involved in the writing SQL and performance tuning.
• Involved in Release Activities like preparing Release Notes and Moving objects into the testing server and production server.
• Validate the infa components, SQL Scripts & promote the codes to higher environment

Confidential

Responsibilities:

• Translate the business requirements into technical specifications and prepared Technical Design Document (TDD).
• Prepared the database objects like tables & views.
• Analyze the data quality issues during load & Involved in testing and Performance tuning.
• Development & Review of Informatica codes & SQL Scripts
• Prepared the Unit Test Case, Maintenance document and executed the UTC.
• Involved in Release Activities like preparing Release Notes and Moving objects into the testing server and production server.

Confidential

Responsibilities:

• Involved in the development of SQL scripts.
• Creation/modification of new/existing database objects and their corresponding loading scripts as per requirements.
• Involved in Unit Test and analyzed the test results.
• Coordinating with on-site teams during development.
• Validating the target data with the source data.
• Participating in project weekly status meetings.

Confidential

Responsibilities:

• Review the SQL scripts.
• Creation/modification of new/existing database objects and their corresponding loading scripts as per requirements.
• Review the test cases and analyzed the test results.
• Coordinating with on-site teams during development.
• Participating in project weekly status meetings.

Confidential

Responsibilities:

• Development of SQL Scripts
• Prepare the unit test cases & fixing the issues.

Confidential

Responsibilities:

• Development of SQL Scripts
• Involved in the development of packages and unit testing, and maintenance.
• Involved in Understanding Customer requirements/Functional requirements.

Confidential

Responsibilities:

• Involved in the development and maintenance of the application.
• Implemented Business Logic through VB Code & SQL Scripts.
• Migration of Tables & Other objects from one server to another server