PROFESSIONAL SUMMARY:

• About 7 years of IT experience in Software Analysis, Design and Development for various software applications in client - server environment in providing Business Intelligence Solutions in Data Warehousing for Decision Support Systems, OLAP and OLTP Application Development and worked on the Database Application Development.
• Six years plus experience in the Implementation of full lifecycle in Data warehouse, ODS and Data marts with Dimensional modeling techniques Star Schema and Snow flake Schema using Kimball and Inmon.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse and DSS using Informatica Power Center 9.1.0/8.6.1/8.1.1/7.1/6.2 - Designer, IDQ(Informatica Data Quality), IDE(Informatica Data Explorer), Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor
• Hands on experience in handling data from various source systems such as Flat Files, XMLSource, Oracle, MS SQLServer, Confidential DB2, Teradata and Excel Files
• Expert Developer skills in TeradataRDBMS, initial TeradataDBMS environment setup, development and production DBA support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities
• Experience involved in Performance Tuning, Error Handling, Production Support and debugging mappings.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Different databases.
• Extensively worked on Monitoring and Scheduling of Jobs using UNIX Shell Script and BTEQ Scripts.
• Expertise on tools like Toad, SQL*Plus and SQL Server Management Studio.
• Involved in Manual and Automated Testing of applications on UNIX and Windows Environment.
• Good knowledge on ER Data Modeling tools like Erwin, MS Office Suite and Visio.
• Good exposure to the Software Development Life Cycle (SDLC) and OOAD Techniques.
• Have a clear understanding of Business Intelligence and Data Warehousing Concepts.
• Experience in integrating data from various databases Oracle, SQL,DB2UDB and Teradata.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.1.0/8.6.0/8.1.1/7.1.1/6.2 , PowerMart6.2/5.1/4.7, Informatica Data Quality 8.5, Power Exchange 9.1

Data Modeling: Erwin 7.2/4.0/3.5

Databases: Oracle10g/9i/8i, Teradata 12, MS SQL Server 2010/2008/2005/2000 , Confidential DB2/UDB

Languages: SQL, PL/SQL, SQL*Plus, HTML, UNIX, DBMS

Tools: SQL plus, TOAD, Autosys, CRONTAB, Confidential InfoSphere

Operating Systems: UNIX, Windows (XP, NT/95/98/2000),WinNT4.0, MSDOS6.22

WORK EXPERIENCE:

Confidential, Dublin, Ohio

ETL/ Informatica Developer

Responsibilities:

• Involved in review and finalizing the technical specifications of source-target mapping documents
• Responsible for Data Extraction and Transformation from disparate sources like Oracle and XML files and loading in to XML files using Informatica Power Center 9.1.
• Extensively worked with Target XSD’s in order to generate the output XML files
• Performed various Informatica administrative tasks and managed Informatica repository.
• Addressed critical areas of impact in terms of performance, data integrity, runtime errors, user interface, application maintenance and development.
• Involved in designing Error Handling strategy using Error detection/Notification/Re-Processing processes
• Created source to target mappings according to business requirements.
• Worked on the transformations like Source Qualifier, Expression, Router, Sequence Generator, Aggregator, Filter, Joiner, and Lookup.
• Extensively used auto memory settings and concurrent lookup caches for fine tuning the Informatica processes.
• Worked on performance tuning of various mappings and session.
• Written shell scripts to create header and footer with records counts of the delta file in the trailer.
• Involved in Setting up Environments for Development, Test and UAT, which involved Configuring Informatica, Rep Server and running full loads in all the three environments.
• Involved in fine-tuning the ETL mapping by studying the session logs and coming up with a better strategy to deal with bottlenecks such as time involved in building the cache.
• Mentoring other developers in technical and business aspects.
• Used flat files source files and loaded the data into target XML.

Environment: Informatica 9.1, Oracle 10g, PL/SQL, DB2, TOAD and Windows NT/2000, XML, UNIX

Confidential, Fort Worth, Texas

ETL/ Informatica Developer

Responsibilities:

• Worked heavily with Business Analyst to understand the business and to design the HLD'S ans LLD'S.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Designed the metadata tables and created mappings to populate the same. These tables were used to generate the parameter files.
• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the DataMart with only required information.
• Created reusable transformations to clean the data, which were used in several mappings.
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area.
• Developed and tested stored procedures, functions and packages in PL/SQL
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Designed and implemented stored procedures and triggers for automating tasks in SQL Server 2008/ Oracle 10g.
• Developed flowcharts for complex stored procedures..
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Oracle Database.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Worked with Informatica Administrator to setup project folders in development, test and production environments.
• Wrote UNIX Shell Scripts for InformaticaPre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows)
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment: Informatica Power Center 9.1.0, Power Exchange 9.1, IDQ, Oracle 11g/10g, SQL Server 2008, PL/SQL, SQL, DB2, UNIX, Shell scripts

Confidential, Tallahassee, FL

Sr. Informatica Developer

Responsibilities:

• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Developed strategies for Incremental data extractions as well data migration to load into the Teradata. And also assisted in designing Logical/Physical Data Models.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the PowerCenter, Power exchange.
• Created SSIS Packages to migrate slowly changing dimensions. Expert knowledge SQL Queries, Triggers, PL/SQL Procedures, Packages to apply and maintain the Business Rules.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts, Wrote PL/SQL scripts for dropping, rebuilding indexes.
• Performed Configuration Management to Migrate Informatica mappings/sessions/workflows from Development to Test to production environment.
• Wrote UNIX shell scripts to automate the process of renaming the Flat files with a timestamp extension, Compressing, Archiving, the Workflows, File Manipulations and automatic email notifications to the data owners (Success / Failure) and FTP to the desired locations.
• Worked as Teradata developer, implementation and usage of tools and utilities such as Fast load, Fast Export, Multi load, TPump, Teradata Parallel Transporter (TPT)
• Collaborated with Informatica Admin in process of Informatica Upgradation from PowerCenter 8.1 to PowerCenter 8.6.
• Worked closely with the business analyst’s team in order to solve the Problem Tickets, Service Requests.

Environment: Informatica PowerCenter 8.6/8.1, SQL Server 2005/2008,DB2, IDQ, Teradata 12, Oracle 10g, SQL, PL/SQL,T-SQL,TOAD 9.0, Mainframes, Autosys.

Confidential, Cleveland, TN

ETL/Data warehousing Developer

Responsibilities:

• Major involvement in creating and tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in Work flow monitor
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator and Router Transformations.
• Created update strategy and stored procedure transformations to populate targets based on business requirements.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values
• Used Informatica to create and organize various Metadata types, including legacy Source and Data warehouse Target data definitions and ETL jobs.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Loaded operational data from Oracle, Sql server, flat files, Excel Worksheets into various data marts.
• Created Tasks and Workflows using Task Manager and Workflow Designer
• Also developed numerous Stored Procedures, Triggers and common functions using PL/SQL.

Environment: Informatica Power Center 8.1, Work Flow Manager, Oracle 10g, SQL Server 2005, DB2, Erwin, TOAD, UNIX Shell script.

Confidential, Deerfield, IL

Sr. ETL Developer

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Developed mapping parameters and variables to support SQL override.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Created sessions, database connections and batches using Informatica WorkflowManager. Developed mappings to load data in slowly changing dimension.
• Created mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle database
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.

Environment: Informatica Power Center 8.1, Oracle 8i/9i, MS SQL Server 2005/2000, XML

Confidential

ETL Developer

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed the Data models for Data mart. Created Logical and Physical Data models.
• Extensively used ETL to transform data from different source systems and load the data into the Target database.
• Extensively used Source Qualifier, Aggregator, Filter, Expression, Lookup, Update Strategy, Router and Joiner transformation.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Responsible for Performance Tuning of sources, targets, mappings and sessions.
• Scheduled and ran Extraction, Loading processes and monitored sessions using Informatica Workflow Manager.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and developed Oracle PL/SQL Procedures.
• Generated reports using Business Objects Report Designer.
• Developed views necessary for structured and ad-hoc reporting.
• Designed testing procedure and test plans. Assisted in Production support.

Environment: Informatica Power Center 6.1, Data modeling, Oracle 8i, SQL, PL/SQL, MS SQL Server 2000, Flat Files, Windows 2000.