SUMMARY

• 8 Years of IT experience wif expertise in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) involving RDBMS like Oracle, MS SQL server, Netezza, DB2 and Teradata databases on Windows and UNIX platforms.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Expertise in Dimensional and Relational Physical & logical data modeling using Erwin and ER/Studio.
• Extensively worked on Informatica Components like, Admin console, Repository manager, Designer, Workflow manager, Workflow monitor.
• Extensive Experience in designing and developing various complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center experience in platform configuration, code development, best practices, design patterns and use cases of MDM, Data Virtualization, Data Services.
• Strong experience in implementing CDC using Informatica Power Exchange 8.x/7.x.
• Proficient in delivering the high data quality by designing, developing and automation of audit process and implementation the reconcile process accordingly.
• Experience in active data ware housing on the Teradata platform, extended use of Teradata Parallel Transport, TPump, FastLoad, BTEQ and migrating legacy systems into Teradata.
• Experience in using the Informatica command line utilities like PMCMD to execute workflows in non - windows environments
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies.
• Extensively worked wif Oracle PL/SQL Stored Procedures, Functions and Triggers and involved in Query Optimization.
• Excellent technical and professional client interaction skills. Interacted wif both Technical, functional and business audiences across different phases of the project life cycle.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5/9.0/8.6 (Power Mart/ Power Center), Informatica Power Exchange 7.x/8.x, Informatica Power Connect, Data stage 7.5x

Reporting Tools: Business Objects XI r2/r 1/6.5/6.1/5.1 , Cognos, SSRS(SQL Reporting Services)

Databases: Oracle 11g, Netezza, IBM DB2 UDB 8.0/7.0, Teradata V2R6/V2R5, MS SQL Server 2005/2000/7.0/6.0 , MS Access

DataModeling/Methodology: MSVisio, ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inman MethodologyStar Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling.

Programming Skills: Java, SQL, PL/SQL.

Scripting Languages: Unix Shell Scripting, Java Script, Bash Scripting.

Tools: Toad 7.4, Oracle designer, OBIEE 10.1.3.2, Business Objects.

Operating Systems: UNIX Sun Solaris 2.x, Win Vista/NT/2000/XP/7, MAC (10.4/10.5/10.6 ).

Utilities: SQL* PLUS, PVCS, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Sr. Informatica Developer

Responsibilities:

• Prioritized Business requirements and translated those requirements into functional requirements.
• Worked wif business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN.
• Extensively used ETL to load data from heterogeneous sources like flat files (Fixed Width and Delimited), Oracle tables, and DB2 tables
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various complex mappings using Mapping Designer and worked wif Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Optimized and Tuned SQL queries used in the source qualifier of certain mappings to eliminate Full Table scans.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Designed and developed several Mapplets and worklets for reusability.
• Used Informatica Power center workflow manager to create sessions, batches to run wif the logic embedded in the mappings.
• Created various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Validated all loaded data on Netezza by creating and running Netezza SQL.
• Creating connection to databases like SQL Server, Oracle, Netezza and application connections.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Created deployment groups in one environment for the Workflows, Worklets, Sessions, Mappings, Source definitions, Target definitions and imported them to other environments.
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Involved in the administration of the Informatica Repository and also in the design and architecture of multiple repositories to support multiple application development areas.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Developed of PL/SQL blocks and multi-thread Pro*C programs for ETL purposes
• Involved in collection of statistics on original query and analyze them to set up a test environment.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules, security efficiently and test cases for the project.
• Developed UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Created scripts for Batch test and set the required options for overnight, automated execution of test scripts.
• Setting up Batches and sessions to schedule the loads at required frequency using Power center Workflow manager
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Expertise in UNIX shell scripting and automation of ETL processes using scheduling tool Autosys.
• Recommended physical tuning strategies for overall better performance of database, queries and load process by suggesting vertical and horizontal partitioning of existing tables and changes in data types where possible for saving space.
• Prepared Run book for the daily batch loads giving the job dependencies and how to restart a job when it fails for ease of handling job failures during loads.
• Utilized QC (Quality center Defect Tracking Tool) for communication wif the production personnel, developers and team members.
• Handled the dead lock errors that occurred due to dependency of jobs running simultaneously
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards
• Involved in production support working wif various mitigation tickets created while the users working to retrieve the database

Environment: - Informatica 9.5, Netezza, Oracle 11g, DB2, FLATFILES (Fixed width and Delimited), SQL, TOAD, PUTTY, UNIX, Autosys r11

Confidential, Ramsay, NJ

Sr ETL Developer

Responsibilities:

• Involved in gathering the business requirements and create the detailed module specifications and source to target mapping and writing test cases and also identifying the mapping between databases and data items from source systems to target systems and designing the process diagram.
• Involved in the analysis & design of the Data Warehouse model wif Facts and Dimension Tables using Erwin Data Modeler and created logical and physical data models using Erwin Created Entity Relationship (ER) diagrams based on requirements.
• Designed and developed various complex ETL mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator to load the data from source to target.
• Created various worklets, workflows (Concurrent and Sequential) and used other tasks like event wait, event raise, email, command for efficient execution of mappings.
• Used session partitions, dynamic cache memory, and index cache to improve the performance.
• Created and scheduled Session, jobs based on demand, run on time using Workflow Manager.
• Developed BTEQ scripts to load data from Teradata Staging area to Data warehouse, Data warehouse to data marts for specific reporting requirements.
• Creating connection to databases like SQL Server, Oracle, Netezza and application connections.
• Creating Netezza DB Objects using Best practices of Netezza in order to avoid data skews on the Netezza Objects
• Designed and Developed the Netezza SQL Scripts as per the Customer requirements.
• Performance tuning of Netezza SQL scripts.
• Provided technical guidance for re-engineering functions of Oracle warehouse operations into Netezza.
• Involved in optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts
• Optimized high volume tables (Including collection tables) in Teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.
• Automated the load process using UNIX shell scripts.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Provided support in handling file validation errors and database down and connectivity errors.
• Responsible for daily internal and external SLA, communicating in advance of any SLA miss to both technical and functional audience
• Used Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Created scripts for Batch test and set the required options for overnight, automated execution of test scripts.
• Responsible for regression testing ETL jobs before test to production migration.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Handled the dead lock errors that occurred due to dependency of jobs running simultaneously.
• Provided support for daily and weekly batch loads.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• Troubleshooting the data and performance issues raised by user community, designed, developed and deployed the code to fix them.

Environment: Informatica Power Center 9.0, Netezza, Teradata V2R6, Oracle 11g, FLAT FILES, XML Files, TOAD, SQL, PL/SQL, Windows XP, UNIX

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Evaluated and documented Business processes to accurately reflect the current and future state of the process
• Analyzed new applications as they relate to Business and existing applications
• Developed prototypes of a new application to be used wif customers to confirm requirements.
• Identified and tracked the slowly changing dimensions from heterogeneous sources and determined the hierarchies in dimensions.
• Implemented audit process to ensure Data warehouse is matching wif the source systems in all reporting perspectives.
• Experience wif Client/Account data management systems
• Extensively used Stored Procedures, Functions and Packages using PL/SQL.
• Created maestro schedules/jobs for automation of ETL load process.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Written UNIX shell Scripts for getting data from systems to Data Warehousing system
• Implemented weekly error tracking and correction process using Informatica
• Involved in developing test data/cases to verify accuracy and completeness of ETL process.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Actively involved in the production support and also transferred noledge to the other team members.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica PowerCenter 8.6, PowerExchange, Power Analyzer, Erwin, Oracle 11g, SQL, PL/SQL, SQL Server 2005, Windows XP, MS Access, UNIX Shell Scripting, Maestro, Sql*Loader, TOAD 8.6.1.0

Confidential, Madison, WI

ETL Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application noledge from Business Managers & Application Owners.
• Prepared Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Involved in designing the process flow for extracting the data across various systems interacting
• Extracted data from the flat files, relational databases and transformed the data according to the target Teradata database and performed loading using Informatica PowerCenter 7.1.4
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Created Mapping and Session Variables.
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Designed and developed UNIX shell scripts as part of the pre-session and post-session commands to automate the process of loading, pulling, renaming and pushing data from and to different servers.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Responsible for daily internal and external SLA, communicating in advance of any SLA miss to both technical and functional audience.
• Maintaining issue log of the issues during the UAT phase for future reference
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Actively involved in the production support and also transferred noledge to the other team members.
• Co-ordinate between different teams across circle and organization to resolve release related issues

Environment: Informatica 8.6, Teradata V2R5, Oracle11g, Autosys, UNIX, Erwin, Windows XP.

Confidential

PL/SQL Programmer / ETL Developer

Responsibilities:

• Involved in interacting wif users to gather requirements, understand business needs and ensure applications met the required changes.
• Implemented logical and physical data modeling wif Star and snowflake schema.
• Data is extracted from different source systems using Informatica.
• Responsible for creating the Repository and analyzing the various sources through data needed to be extracted.
• Created complex mappings using various Informatica transformations such as Rank, Lookup, Filter, Stored Procedure, Update Strategy, Aggregators, and Expression.
• Created Stored Procedures for populating the Data into Summary Tables in the OLAP Database for better performance or for the fast retrieving of the Data.
• Developed and optimized outlines by grouping and positioning, developed rules files for dimension building and data loads
• Developed new database Outlines, Business Rules, setting up dimensions, users, user groups and their security rights.
• Developed complex formulas and calc scripts reflecting the business users requirements on the cube
• Used various types of Calculations such as Dynamic calc, Two-Pass Calc, Intelligent calc for application outlines.
• Conducted Essbase performance tuning and troubleshooting activities such as periodic export and Data load, re-arranging the Dimensions for optimized performance.

Environment: Oracle PL/SQL, Flat files, ORACLE 11g, UNIX, XML, and Informatica Power Mart 8.6

Confidential 

PL/SQL Programmer

Responsibilities:

• Created, monitored and maintained Oracle databases.
• Created Table spaces for Data and Indexes.
• Created Tables, Indexes, Sequences, Clusters, Triggers, Procedures, Functions and Packages.
• Re-organization of databases and managing the databases for optimum performance levels.
• Writing database scripts for user management and roles.
• Configuring ODBC connectivity for new instances and clients.
• Formulating optimization strategies based on performance cost and rules.
• Performing SQL query optimization using hints, Indexes and Explain plan.
• Wrote PL/SQL Scripts for DDL operations such as to create alter and drop database objects likes tables, views, sequences, procedures and functions.
• Written stored procedures and functions to retrieve the data from database using PL/SQL.
• Different database triggers containing PL/SQL were created and stored in the database and fired off when contents of database were changed

Environment: Visual Basic, Oracle 11g, PL/SQL, Crystal Report 6, Erwin, Windows NT