PROFESSIONAL SUMMARY:

• 9 years of experience in the IT industry with specialization in Data Warehousing
• Experience in Insurance, Healthcare and Banking domains
• Experience in all facets of software development life cycle (SDLC) with earned reputation for quality deliverables
• Have worked on various ETL tools like Datastage, Informatica and also have knowledge on SSIS tool
• Have worked on Cognos Report Studio; familiar with Query Studio and Analysis Studio
• Strong knowledge in Oracle, SQL programming
• Proficient client interfacing skills; have acted as an interface between the client and the offshore team
• Highly motivated to work with team as well as an individual

TECHNICAL SKILLS:

Operating Systems: Windows XP/7, Windows 2003

ETL/Reporting Tools: DataStage 8.7, Informatica 9.6.1, Cognos 10.1.1

Databases: Oracle 11g, SQL Server 2008/2014

PROFESSIONAL EXPERIENCE:

Confidential, Tennessee

Senior ETL Developer

Technologies: Informatica 9.6.1, Teradata 15.10.13, Cognos 10.1.1

Responsibilities:

• Examine the business requirement and prepare the ETL specification document
• Develop new mappings in Informatica based on business requirement
• Perform unit testing, system and integration testing.
• Fix defects that are reported in UAT
• Participate in status meetings to discuss the issues/status of day - to-day tasks

Confidential, New Jersey

Team Lead / ETL Developer

Technologies: Datastage v 8.7, Cognos 10.1.1, SQL Server 2014, UNIX

Responsibilities:

• Gathered requirements, analyzed and prepared Functional Specification Document
• Participated in design and development of the application using Datastage ETL tool/UNIX scripts to calculate reserves from premiums and losses
• Developed/Enhanceed Cognos reports to achieve business goals
• Prepared and reviewed Unit Test Plans/System Test Plans and result documents
• Performed self/peer review of code and delivered quality code
• Worked with users during User Acceptance Testing and provided assistance to perform UAT and validate the test cases.
• Acted as an interface between the client and the offshore team
• Participated in daily and weekly status meetings to discuss the proceedings and prepared minutes of meeting

Confidential, New Jersey

ETL Developer

Technologies: Datastage v 8.7, Cognos 10.1.1, SQL Server 2014, UNIX

Responsibilities:

• Interacted with users to gather requirements and develop the application
• Analyzed the business requirement and prepared Functional Specification Document to streamline the process
• Ensured data integrity and compliance to standards by performing data validation and cleansing
• Involved in defining source to target data mapping, business rules and data definitions
• Transitioned business knowledge to offshore team to help understand the functionalities involved
• Developed Datastage jobs to perform ETL for Actuals/Budget/Forecast processing for North America
• Extensively used Cognos Analysis Studio to reconcile the Actuals/Budget/Forecast figures that are loaded to datawarehouse
• Prepared Unit Test Plans/System Test Plans and reviewed test result documents
• Performed self/peer reviews of code

Confidential

ETL Developer

Technologies: Datastage v8.7, Cognos 10.1.1, Oracle 10g, UNIX, Windows XP

Responsibilities:

• Evaluated business requirements & performed impact analysis
• Designed and developed Datastage jobs based on the business requirement. Followed best practices in the development phase and also fines tuned/optimized queries.
• Developed/Enhanced Cognos Reports as per requirement
• Prepared test cases and performed testing to ensured that all business logics are implemented
• Performed root cause analysis for user requests and provided solutions
• Attended weekly requirement/status meetings with onsite/client

Confidential

ETL Developer

Technologies: Datastage v8.1, Oracle 9i, Unix, Windows XP

Responsibilities:

• Analyzed the Business Requirements.
• Developed jobs in Datastage based on client’s requirement.
• Performed self and peer reviews.
• Performed Unit testing.
• Involved in fixing defects raised in SIT Environment

Confidential

ETL Developer

Technologies: Datastage v8.1, Oracle 9i, DB2, Teradata, Windows XP

Responsibilities:

• Analyzed the Business Requirements
• Developed jobs in Datastage based on business requirement
• Performed self and peer reviews
• Prepared test cases and performed Unit testing

Confidential

ETL Developer

Technologies: Data Stage 8.1, Informatica 8.0.1, Oracle 9i, DB2, Windows XP,UNIX

Responsibilities:

• Analyzed the existing Informatica mappings
• Prepared source to target mapping
• Migrated Informatica mappings to Datastage by developing equivalent Datastage jobs.
• Performed Peer reviews
• Performed Unit Testing

Confidential

ETL Developer

Technologies: Informatica 8.0.1, DB2, Windows XP,UNIX

Responsibilities:

• Analyzed the existing system / Requirements gathering.
• Prepared source to target mapping with transformations/business rules
• Developed Informatica mappings equivalent to the Stored Procedures created in DB2 using various transformations like Expression, Filter, Lookup etc.
• Performed Self and Peer Reviews.
• Performed Unit Testing and prepared test results document