PROFESSIONAL SUMMARY:

• Around nine years of combined Industry Experience as a Data Warehousing Expert and ETL Developer in designing, developing and implementing ETL processes for business applications.
• Extensive experience in analysis, design, development & migration of data warehouse applications.
• Worked on Development, Maintenance, enhancement and support related projects.
• Diversified domain experience in banking domain.
• Working in banking domain for over 4 yrs.
• Demonstrated understanding of Dimensional modeling (Star & Snow flake schema) and other data warehousing concepts.
• Worked on Informatica versions of INFORMATICA 8.1.1 & INFORMATICA 9.0.1
• Worked on Mainframe ETL Process using Z/OS
• Extensive experience in implementing the ETL processes which include developing the data model, designing the change capture and disaster recovery strategies.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Experience in Data Warehouse development working with Extraction/Transformation/Loading using Informatica PowerMart/PowerCenter with Teradata, DB2 & Oracle databases.
• Experience in automating of the ETL processes for migration and patching Informatica objects.
• Worked with various Power Center/Power Mart components like Informatica Server and Client tools e.g.) Designer, Workflow Manager, and Repository Manager & Workflow Monitor.
• Strong experience with star and snowflake schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions.
• Developed shell scripts for invoking Informatica workflows.
• Involved in Informatica Performance tuning of the ETL process and SQL tuning.
• Extensive experience in designing the architecture for Extract, Transform, Load environment and development of mappings and process using Informatica Power Center.
• Extensive experience in formulating error handling mechanism.
• Experience in integration of various data sources like Teradata and Oracle.
• Worked extensively on Teradata Utilities like MLOAD, TPUMP, FASTLOAD, TPT & FASTEXPORT and also Oracle Stored Procedures, Table Partitions SQL queries and loading data into Data Warehouse/Data Marts using Informatica/Mainframe.
• Extensively used third party tools which include Autosys, Maximo, CA7, IBM Clearquest, HP Service center tool for ticket management & Quality center etc.
• Used various third party version control tools like Sub Version, Changemen, Endevor tools.
• Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

Technical Skills:

ETL Tools: Informatica Power Center 8.x/9.x, Mainframe

Databases: Teradata V2R5 & V2R6, 12/13/14 Oracle 8.i/9.i/10g & IBM DB2

Data Modeling Tools: Erwin 4.1.

Version Control Tools: Sub Version, Changemen & Endevor

Languages: SQL, PL/SQL

Scripting Languages: Korn Shell, Bash shell scripting

Business Intelligence Tools: Had training on Informatica Power Exchange, Hadoop, DMX

Scheduling tools: Autosys and Tivoli

Special Tools: Autosys, Maximo, CA7, HP Quality center, Changemen, NDM & File-Aid, IBM Clearquest, HP Service center and Core FTP tool.

Operating Systems: Windows, Sun Solaris, Z/OS

Professional Experience

Confidential

Senior Teradata ETL Developer

Responsibilities:

• Handling Project Meetings & Perform analysis of the existing W data to understand the mapping rules in the current environment.
• Finalize design, Model and High Level Design and Low Level Design Documents.
• Perform analysis of existing code in mainframes or in ETL tools like Informatica to understand the mapping logics
• Used utilities like MLOAD,FAST LOAD,TPUMP, BTEQ & FAST EXPORT
• Coordinating with offshore for Coding Testing and Deployment in prod.
• Developing the mapping documents including System of Record field names, Mapping Rules and W Target field names.
• Transmission of the System of Record files from mainframes / UNIX to new environment.
• Coding in new environment as per the mapping documents.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Validation of the test cases and Defect tracking using Quality Center tool.

Environment: Informatica 9.1, Teradata 13.10, UNIX, F-SECURE, Teradata SQL Assistant, Autosys Scheduler, CA7,

Confidential

Account Management

Responsibilities:

• Leading the projects from Onsite/Offshore, which includes a daily interaction with clients, and Business Analysts for requirements gathering, clarifications and suggestions in data integration
• Participate in dispatch meeting , analyze the requirements and work with users to generate require data for reporting
• Preparing all necessary documents like Low Level Design, Deployment Sheets and Delivery packages
• Creating/updating eProducts data model using Erwin designer
• Work with bank privacy application team to generate the privacy related views
• Design and development SQL queries as per the business requirement
• Extensively used Changemen ,Endevor tools
• Used utilities like MLOAD,FAST LOAD,TPUMP, BTEQ & FAST EXPORT
• Created a RTAS (Rules, Trends, Alerts system) generic data validation driven by control tables which has been made as standard for data validation across the project
• Preparing Unit/SIT/UAT Test Cases and Test Results documents
• Coordinating with testing team for fixing QA and UAT Defects
• Scheduling the jobs in CA-7 and monitoring its daily run in Production
• Support the Application and users until completion of warranty

Environment: Teradata R12/R13.11.11, Teradata SQL Assistant, SQL, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TPT,

Confidential

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation
• Wrote, tested and implemented Teradata Fastload, Multiload and BTEQ scripts, DML and DDL
• Wrote views based on user and/or reporting requirements
• Wrote Teradata Macros and used various Teradata analytic functions
• Performance tuned and optimized various complex SQL queries
• Good knowledge on Teradata Manager, SQL assistant and BTEQ
• Gathered system design requirements, design and write system specifications
• Coordinated with the business analysts and upstream to discuss issues in interpreting the requirements
• Worked on conversion of existing customer data to new intuit platform

Environment: Teradata R12/13.11, Teradata SQL Assistant, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TPT, BTEQ.

Confidential

Responsibilities:

• Requirements analysis, data assessment, business process reengineering
• Provide analysis with expertise in different technologies ,business areas ,application wide analysis and proposal of solutions
• Responsible for high level work breakdown structure, review the project requests describing user needs to estimate time and cost required to accomplish the project
• Query and Indexing optimization and fine tuning
• Coding using Teradata Analytical functions, BTEQ SQL of Teradata, format and execute the SQLs on Mainframe environment
• Propose, and negotiate performance enhancement changes into data models, ETL workflows and BI reporting, by working with Data, ETL & BI architects
• Developed mainframe Jobs to automate redundant tasks
• Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Multiload, Fastload, Fast export, and BTEQ
• Automatic Email generation process once the stream completes and send the reports on

Environment:Teradata R12/R13.11, Teradata SQL Assistant, SQL, VSS, Outlook, MLOAD, TPUMP, TPT, FAST LOAD, FAST EXPORT.

Confidential

System Engineer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop data models, requirements document, and ETL specifications.
• Involved in designing the system and designing the logical database design using ER Studio.
• Involved in designing the physical database system.
• Involved in data quality and cleansing of data source.
• Involved in creation of database schema and capacity planning of schema for the warehouse.
• Coding as per the mapping/D953 documents.
• Unit testing of the mappings.
• Responsible for migration of applications from dev environment to Test and finally to Production.
• Developed UNIX scripting for data feed files for making ready to processing as per System.
• Scheduled jobs in Autosys scheduler.
• Developing the mapping documents including System of Record field names, Mapping Rules and BI Target field names.
• Discussion of the mapping document with Architects and mapping team to appropriately map Source elements to SCMBI target model and create a D953 design document.
• Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
• Transmission of the System of Record files from UNIX to SCMBI environment.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Validation of the test cases using Quality Center tool.
• Defect tracking through Quality Center and SharePoint portal.

Environment: Informatica 8.1.1/8.6, Oracle, UNIX, Autosys Scheduler, Sub Version Control Tool

Confidential

Responsibilities:

• Understanding the requirements and Business Functionality.
• Gathered system design requirements, design and write system specifications.
• Preparation of Detail Design document and Unit Test Plans & Test results
• Coding as per project standards.
• Defect fixing in each stages like Unit, Integration, UAT, Regression and system testing
• The project is executed based on an Onsite/Offshore model.
• Effective communication and co-ordination with onsite members is involved. Also, communication with the Client as and when required
• Coordinating the team activities and Reviewing the tasks done by the team

Environment: Teradata V2R3/V2R5, COBOL, JCL, CA7