SUMMARY:

• Around 9 years of total IT experience in the Analysis, Design, Modeling, Development Implementation and deployment of Data Warehouses/Data Marts, Client/Server Applications, Multidimensional Analysis and OLAP Reporting.
• Incorporated various data sources like Oracle, DB2, XML and Flat files into the staging area.
• Experience in Data Warehouse development working with Extraction/Transformation/Loading using Informatica PowerCenter/Power Mart with Oracle, SQL Server and Heterogeneous Sources
• Expertise in Application Development with full lifecycle experience of implementing large Client/Server Applications
• Experience in different fields which includes Financial, Insurance, Pharmaceutical, sales and understanding of Motor Vehicle Business
• Knowledge of full life cycle development for building a Data Warehouse
• Experience in Data Modeling, Multi Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional data marts
• Experience in creating Repository, Source systems, Target Databases and developing strategies for ETL mechanisms using Informatica
• Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, shortcuts and reusable transformations
• Experience in Coding, Integration Testing, System Testing, Performance Testing on Warehouse Applications, Desktop Applications, and Web Applications.
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager.
• Working experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets
• Experience in using Oracle 11g/10g/9i/8i/7.x, MS SQL Server, PL/SQL, SQL Loader, TOAD, Erwin 4.0/3.5.2, Unix Shell Scripts, and HTML 4.0
• Experience in UNIX systems such as HP, SUN SOLARIS.
• Excellent Interpersonal communication, Documentation skills and experience coordinating with project managers, business Analyst, Architects, DBAs and Developers
• Ability to work independently as well as in a team, fun - filled and challenging environment.

TECHNICAL SKILS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x.

OLAP Tools: Hyperion 11.1.1.3/9.1.3.

Data Modeling: Erwin, Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005, DB2, MS Access, TeraData.

Programming: PL/SQL, SQL, Toad, UNIX Shell Scripting, C, C++, Java

Web technologies: HTML, DHTML, XML, ASP, ASP.NET

Applications: MS Word, Excel, Outlook, FrontPage, PowerPoint, MS-Visual Studio.Net, Java, MS Project Report.

Operating systems: Windows 95/98/00/NT/XP, Windows Server 2003, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. ETL Developer

Responsibilities:

• Working as a Sr. ETL Developer on multiple projects, implemented using Informatica PowerCenter 9.1, Teradata, Oracle 11g and Cognos 10/8 as the core technologies.
• Involved in the Study of the business logic and coordinate with the client to gather user requirements and understanding the physical system and the terms and conditions for the Datamarts.
• Provide guidance to inputs to architecture and design.
• Designed and coded the application components in an Agile/Scrum environment.
• Informatica mappings and workflows are developed to extract data from multiple databases, flat files, Mainframe files and load into the Teradata warehouse.
• Created mappings using the Informatica transformations and also implemented JAVA transformation to get the multiple error codes and error descriptions for each complaint.
• Experience in Integration of various data sources like Teradata, Oracle, DB2, SQL Server, XML and Flat Files.
• Teradata jobs like MultiLoad, FastLoad and BTEQ programs are developed to cleanse, transform and load data into Teradata warehouse.
• Created technical specification documents like system design and detail design documents for the development of ETL mappings to load data into various tables in Data Marts.
• Created Mapping Specification document to explain how to process the data from source to the target tables.
• Produce clearly articulated functionality documentation in data integration.
• Responsible for migrating ETL and Unix Objects from one environment to the other using MKS Integration Client.
• Extensively Worked with Autosys Scheduling tool like creating, uploading JIL files, creating dependencies on other Jobs and also developed calendars for scheduling.

Environment: Informatica PowerCenter 9.1, Teradata 13.10, Oracle 11g, SQL Server, UNIX, WinSCP, Agile, Cognos 10/8, Autosys.

Confidential, Dublin, OH

Sr. ETL Developer

Responsibilities:

• Worked as a Sr. ETL Developer on multiple projects, implemented using Informatica PowerCenter 9.1.0/ 8.6.1 , Oracle 11g/10g and Cognos 10/8 as the core technologies.
• Involved in analysis, design, development, integration, performance and user acceptance testing and Production implementation of the projects.
• Involved in creating Oracle scripts to create fact and dimension tables, views, and synonyms.
• Involved in enhancing the data model for new additions of dimension and reference tables.
• Implemented Informatica best practices as part of the projects and prepared handy documents for the same.
• Developed ETL design for error detection and handling by performing necessary validations.
• Developed ETL mappings to extract, stage, cleanse, transform, integrate and load data from data mart to Enterprise Data Warehouse.
• Extensively worked on file processing, file validations and error handling.
• Created mappings using the transformations such as the Normalizer, Sorter, Aggregator, Union, Filter, Lookup, Joiner, Java, Update strategy and Expression, to transform & load the data.
• Involved in creating Maestro Jobs and Schedules to execute ETL Workflows.
• Good knowledge in creating UNIX Shell Scripts to automate ETL processes and used Maestro (TWS) to schedule ETL Workflows.
• Assessed data to understand its quality challenges using data profiler
• Implemented ETL Best Practices and improved maintainability, performance and data quality
• Involved migrating Informatica code across environments as a part of release.
• Involved in Performance tuning Informatica Mappings and Sessions by eliminating the bottlenecks.
• Troubleshooted complex ETL mappings using Logs, Informatica debugger.
• Involved in Design reviews / Code reviews / Test Plan reviews with the project teams as appropriated throughout project lifecycle.
• Created Technical designs, Test Case documents and Data Validation Scripts.

Environment: Informatica PowerCenter 9.1/8.6.1, Oracle 11g, UNIX, Cognos 10/8, Maestro.

Confidential, Indianapolis, IN

Sr. Informatica Consultant

Responsibilities:

• Involved in business requirement gathering with ETL Lead, data Architect, data modelers in developing ETL extraction logic.
• Prepared pre-system Data migration using excel spread sheet and flat files (CSV) data, into Darwin data warehouse using ETL informatica.
• Developed Informatica mappings, re-usable transformations and procedures to get the data from the multiple sources like DB2, Oracle, and mainframe legacy systems to the Staging and to Data Warehouse system.
• Worked on a complex Query based on the session start time to pull the data from Darwin database based on typical business scenarios.
• Added PL/SQL packages, functions, triggers to develop the interface.
• Experience in writing shell scripts in a UNIX environment for cleansing source files and preparing them for the load process and scripts for starting Informatica sessions and Workflows.
• Identified and solved numerous technical and operational problems in the Data mart design and ETL implementations.
• Involved in developing Logical and Physical Data Models.
• Performed the History and Incremental ETL process to populate the Data Warehouse.
• Extensively involved in performance tuning of the Informatica ETL mappings like increasing the caching size, overriding the existing SQL.
• Developed the mappings for slowly changing dimensions for loading history data.
• Performed Unit & regression testing for the Application and documented test cases. Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Upgraded the Informatica maps from version 7.1.3 to 8.6 in different environments and also changed the scripts accordingly.
• Used TOAD front-end tools to issue SQL commands matching the business requirements to Oracle RDBMS.
• Worked with Remedy to generate Tickets, if any of the informatica process fails like moving the files, running the workflows, or when unprocessed files are created, or problems with session logs, or unable to run informatica workflow ftp fails a Ticket is generated.
• Involved in QA testing in Unit Testing and Integration Testing of the Application.
• Provided offshore and onshore support when ever required.

Environment: Informatica PowerCenter 8.x/7.x, Oracle 10g/9i, SQL*Plus, PL/SQL, TOAD, DB2, mainframe, SQL Server 2005, Erwin, HP-UNIX, Clear Case, Documentum, ARS.

Confidential, Newark, NJ

Sr. Informatica Consultant

Responsibilities:

• Gathering requirements from functional teams for ETL jobs, requirement analysis and project planning
• Participation in Database Design and Database Architecture
• Worked on Data migration using excel spread sheet and flat files (CSV) data into target database using ETL inforamtica.
• Design Informatica mappings, sessions and workflows to implement the business rules during the data extraction, transformation and loading
• Build complex logics using different transformations viz., Filter, Router, Expression, Lookup (Static and Dynamic), Aggregator, External stored procedure, Update Strategy, etc. in Informatica mappings
• Use variables and parameters in mappings, sessions, worklets and workflows
• Extensively used external loaders like TPUMP, MLOAD which enhanced the performance of the jobs.
• Writing Unix scripts for file watch, to create file list, to move the file after loads and call these scripts in Informatica pre session and post session commands
• Writing PL/SQL stored procedures and call them through Informatica mappings
• Code development, prepare unit and integration test plans, code review, testing, debugging, deployment of Informatica Jobs into production environment
• Deployment of Informatica jobs into testing, Validation and production environments
• Preparing deployment documents, user guides, coding standards, and other technical documents
• Designing the error handling and test strategy of the mappings and documenting the Informatica mappings
• Co-coordinating with India based team in the onsite-offshore team model.

Environment: Informatica PowerCenter, Teradata, UNIX, Oracle, SQL, PL/SQL, DB2.

Confidential

Software Developer

Responsibilities:

• Responsible for coding, Screen designs and layouts.
• Designed and developed user friendly screens using Oracle Forms 4.5 for all modules.
• Generated numerous reports using Oracle Reports 2.5 based on the specifications of the required output. Reports generated include Sales Invoices, Sales Performance, Receipts and Stock Position etc.
• Prepared the test plan and test cases document.

Environment: Oracle 7, PL/SQL, ASP, HTML, SQL PLUS, Windows NT, UNIX.