SUMMARY

• 8 yrs of IT experience in Software Analysis, Development, and Implementation of Data Warehousing and Mainframe Applications for Insurance, Finance verticals.
• Proficient in Informatica Power Center 9.0.1/8.x/7.x / 6.2 / 5.1 Informatica Power Mart 5.1 / 4.7, Informatica Power Connect
• Having strong application development skills, and mainframe and DW technical experience in Informatica, COBOL, DB2, CICS, VSAM, JCL, Maestro, CA7
• Experience working in Onsite/Offshore model.
• Extensive experience in Dimensional Data modelling using Star and Snow Flake schema.
• Experience in Databases like Oracle 11i/10g/9i/8i, MS SQL Server 2000/7.0/6.5 , IBM UDB DB2 8.0/7.0 and MS Access 2000.
• Experience in writing UNIX shellscriptings.
• Good in understanding Business process/requirements and translating them into technical requirements.
• Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, and Workflow Monitor).
• Experience in integration of various data sources like SQL Server, MS Access, Oracle, DB2, Cobol Files and Flat files.
• Extensively used Power exchange to import source files from Mainframe systems
• Experience in PL/SQL stored procedures along wif tools like TOAD, Rapid SQL
• Extensively used Teradata (BTEQ scripts).
• Extensively used Bteq scripts to update the status and loading Landing zone tables of the load for Audit purposes
• Sound noledge in understanding of Star Schema, Snowflake Schema using Data Modeling Tool Erwin.
• Knowledge in Teradata and its utilities.
• Proficient in all phases of the System Development Lifecycle (SDLC) - Analysis, Design and Modeling, System Implementation, System Testing, Acceptance and Maintenance
• Ability to work wif team as well as independently.
• Team player wif Analytical, Problem-Solving and Excellent Communication Skills. Good Learn ability. A fast learner wif an open mind to learning new technologies.
• High level of Self-Motivation and an ability to motivate others.

TECHNICAL SKILLS

ETL Tool: Informatica PowerCenter 8.6.1/8.5.1/8.3/8.1.1/7.1.3/6 , COBOL,JCL

Languages: SQL, PL/SQL, UNIX shell scripting.

Databases: Teradata, Mload, Fast load, Oracle 11i/10g/9i/8i, SQL Server, MS AccessVSAM, IMS

Operating Systems: Windows NT/2K/XP, UNIX shell Scripting.

Other Tools: TOAD, PL/SQL, edit plus, SSH, VSS and Putty.

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Programmer analyst/onsite co-ordinator

Responsibilities:

• Schedule meetings wif Confidential business teams to gather Confidential Data warehousing Business requirements for Maintenance requirements.
• Schedule meetings wif Technical reference architecture teams/DBA/Informatica admin to finalize on the design aspects of the project
• Preparing design documents and Technical design documents for the extract, transform and loading data portion of the Project·
• Meetings wif Offshore team to provide details of the design and project requirements·
• Reviewing the test case documents, test plans, coding and deliverables from offshore team to ensure they meet the project requirements and are delivered on time·
• Reviewing the ETL design documents prepared by offshore teams, reviewing Informatica and Teradata components to load the data to Data warehouse for reporting purposes.
• Extensively used Transformation to load the data into Landing zone and .dat files.
• Extensively used Teradata SQL Assistant 12.0
• Extensively used IpswitchWS FTP12 for file transfer.
• Extensively Used Work Load Manager (WLM) scheduler to load the data to Landing zone table and to create .dat files for different source systems.
• Responsible for Unit Testing and Integration testing of mappings and workflows, Bteq and Unix Scripts.
• Extensively used Bteq scripts to update the status and loading Landing zone tables of the load for Audit purposes.
• Utilizing a host of Cognizant’s internal tools dat include: MCAT - To validate the components between source and target environments. It will generate a report in a spread sheet indicating if the migration is successful or done wif errors.
• Q-View for quality assurance and Q-Smart to automate quality assurance through powerful built in workflow mechanisms

Environment: Informatica 8.6.1/9.0.1 , WLM scheduler,DB2, SQL, TOAD, IBM Rapid Sql, UNIX, Erwin 8.0, Teradata, IpswitchWS FTP12,TeradataSqlAssistant 12.0

Confidential, MN

Programmer analyst/onsite co-ordinator

Responsibilities:

• Worked in Onsite/Offshore model.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards
• Extensively used Power exchange to import source files from Mainframe systems
• Worked on flat file and mainframe sources
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Extensively used Power Exchange to convert mainframe source.
• Extensively worked wif History and Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters
• Developed Informatica parameter files to filter the daily data from the source system
• Extensively worked wif the Debugger for handling the data errors in the mapping designer
• Responsible for determining the bottlenecks and fixing the bottlenecks wif performance tuning.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor
• Worked wif Shortcuts across Shared and Non Shared Folders
• Performance tuning on sources, targets, mappings and SQL queries in the transformations. Worked on flat files as sources, targets and lookups
• Extensively used SQL tool TOAD,RapidSql to execute SQL queries
• Extensively used ClearQuest to log the Incidents and tracking, Fix the Incident
• Involved in SQL Performance Tunning
• Used Workflow manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Created Test Data and executed SQL queriesin IBM DB2 to validate and test the data
• Unit Testing TEMPhas been extensively done at development level
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Extensively Used CA-7 scheduling

Environment: Informatica 8.6.1/9.0.1 , IMS, CA-7, Oracle, DB2, SQL, TOAD, IBM Rapid Sql, UNIX, Erwin 8.0, Teradata

Confidential, Bloomington, IL

ETL/Informatica Developer

Responsibilities:

• Involved in meetings wif Business System Analysts to understand the functionality
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Responsible for testing and validating the Informatica mappings against the Pre-defined ETL design standards
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected),Expression,Aggregator,Updatestrategy&storedprocedure transformations.
• Developed ETL mappings in Informatica Power Center Designer using various transformations like Source Qualifier, Normalizer, Expression, Connected and Unconnected Lookup, Update Strategy, Java Transformation, Joiner etc
• Developed SQL’s to extract the data from Siebel as per requirements
• Developed Java Transformation to send email, to call Java and Siebel web services
• Developed Java Transformation to create Unique ID instead of Sequence generator
• Developed complex mapping for Scrubbing the data based on contact method i.e.(email,phone,address) and used web service to get Request and Response from Siebel
• Developed ETL scripts using BTEQ, MLOAD and UNIX.
• Extensively used Web service to call Siebel and to Update the Siebel based on the Requirements
• Extensively used PL/SQL and SQL
• Extensively used Informatica 8.6.1 to load data from source tables i.e. DB2,oracle and tan loaded the data into target table i.e., flat files,DB2,oracle
• Involved in source code management using Version Control option in Informatica
• ETL experience using Informatica 8.6.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager
• Used Workflow manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Created reusable transformations and Mapplets and used them to reduce the development time and complexity of mappings and better maintenance
• Created Test Data and executed SQL queriesin SQL Squirrel to validate and test Siebel data
• Unit and Integration testing TEMPhas been extensively done at development level
• Involved in SQL Performance Tunning
• Tuned performance of Informatica mappings using components using Parameter files, Variables and Dynamic Cache

Environment: Informatica 8.5.1/8.6.1 , Oracle, DB2, Control-M, Windows XP, Sql Squirrel, Siebel,XML,Java

Confidential

Informatica/Mainframe Programmer Analyst

Responsibilities:

• Performed requirements analysis, design, coding and testing of mainframe programs including maintaining the existing programs.
• ETL experience using Informatica 8.5.1/8.6.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Created new JCL's and Modified existing JCL's. Created new and modified existing programs using COBOL, CICS, DB2 and VSAM.
• Worked on File Aid, Endeavor.
• Worked on Quality center 9.2 to Track the status
• Verified defects and Perform database functional, integration and regression testing as needed to minimize defects
• Extensively used Power Exchange.
• Created and executed SQL queriesin EMbarcadero Rapid SQL 7.4.2to validate and test data
• Created mappings, workflows and Shell Scripts to extract, validate, transform data according to the business rules.
• Worked on Maestro scheduling, UNIX Scripting.
• Performed Unit,Functional and System Testing.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards
• ETL experience using Informatica 8.5.1/8.6.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Involved in performance testing, functional testing and integration testing.
• Retrieve the latest version of programs from ENDEVOR, Which was the change management tool.
• Used Maestro for Informatica batch scheduling.

Environment: COBOL, VSAM, DB2, JCL, Maestro, UNIX shell Scripting, Embarcadero RapidSql, Quality Center 9.2, CICS, File-Aid, Endeavor, Informatica 8.5.1

Confidential

Software Engineer

Responsibilities:

• Gathering user Requirement Specification
• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Prepared the ETL Design Documents as per the Business Specifications.
• Translated business requirements into Informatica mappings/workflows.
• Created reusable transformations and Mapplets.
• Created High level/detailed level design documents and also involved in creating ETL specifications.
• Created mappings, workflows and Shell Scripts to extract, validate, transform data according to the business rules.
• Involved in writing the PL/SQL Packages, Stored Procedures, Functions to accomplish the business rules and tuning the SQL queries using EXPLAIN Plan in Toad.
• Designed and developed the sessions for the relevant mappings or Informatica jobs and organized as sequential / concurrent Scheduled the main workflows as per the business rules using the Informatica scheduler using UNIX shellscriptinging for some of the existing data jobs.
• Used Informatica to extract and transform the data from existing, new and modified sources and finally loaded into the Staging area, Data Mart, Target databases and Data warehouse depending upon the requirements.
• Informatica will be used for job scheduling and session/job level monitoring and Notification.
• Used Informatica debugger for Unit Testing the mappings.
• Performed Unit, Systems and Regression testing of the mappings. Involved in writing the test cases and also assisted the users in performing UAT.

Environment: Informatica PowerCenter 6, UNIX shell scripting, Oracle 8i, SQL, PL/SQL, Toad, Windows NT.

Confidential

Software Engineer

Responsibilities:

• Types of Policies
• Information about the policy holder
• Policy covered item details
• Premium payment details.
• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Worked wif Informatica Power Mart client tools like Source Analyzer, Warehouse Designer, and Mapping Designer.
• Developed ETL mappings in Informatica PowerCenter Designer using various transformations like Source Qualifier, Normalizer, Expression, Connected and Unconnected Lookup, Update Strategy, Sequence Generator etc.
• Implemented Slowly Changing Dimensions using PowerCenter to insert/update the dimensions
• Implemented delta loading for data loading from source to target.
• Created Mapplets and used them in different Mappings for maintaining the standards.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Developed and scheduled Workflows using workflow designer in Workflow manager.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Data marts.
• Scheduled sessions for pulling the data from transactional databases in order to maintain the Daily and weekly based loads.

Environment: Informatica PowerCenter 6, UNIX shell scripting, Oracle 8i, SQL, PL/SQL