SUMMARY

• Over 8+ years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing, and Implementing of Data Warehouse development in various domains such as Banking, Insurance, Medical, Health Care, Telecom and Wireless.
• Over 8+years of experience in dealing with SQL and PL/SQL.
• Over 8+ years of Data Warehousing experience using Informatica Power center 9.x/8.x/7.x/6.x, Informatica Power Mart 7.x/6.x, Power Connect, Power Exchange, Power Analyzer.
• Expertise in Database development skills using Oracle 11g/10g/9i/8i, SQL, PL/SQL stored procedures, Functions, Packages, Triggers, Cursors, Programming and TOAD.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client/Server.
• Experienced in complete life cycle Implementation of data warehouse.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• 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).
• Extensively worked on various Data warehouse projects using Informatica Client Tools - Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Server Manager, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Expert knowledge in Trouble shooting and performance tuning at various levels such as source, mappings, target and sessions.
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager.
• Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Expertise in designing and Developing complex Mappings using Informatica Power Center Transformations - Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Slowly Changing Dimensions.
• Working experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets, Developing complex Mapplets, Worklets, Re-usable Tasks, Re-usable Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings & Workflows, Backup & Recovery.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Data loading using UNIX Shell scripts, SQL*Loader.
• Experience in dealing with various databases like Oracle 11x/10g/9i/8x/7x, SQL Server 2005/2003/2000, Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase and XML files.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Good exposure to development, testing, debugging, implementation, documentation and production support.
• Expertise in developing reporting applications using Cognos 8.x/6.x Components like Framework Manager, Report Studio, Query Studio, Analysis Studio, and Data Manager.
• Expertise in developing web service applications using .NET and related technologies.
• Experience in handling initial and incremental loads in target database using mapping variables.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.
• Excellent written, communication skills and possessed analytic problem skills in evaluating business and technical processes and issues, develops and implements system enhancements to facilitate overall operations.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1/8.6/8.1/7.1/6.2/5.1, Informatica Power Mart 7.x/6.x, Informatica Power Exchange 8.x/7.x, Repository Admin console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.

Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star schema, Snowflake schema, Dimensional data modeling, Snowflake modeling, Fact Tables, Dimension Tables.

Databases/Files: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, Teradata V2R6, DB2,Sales Force.com,Sybase,Web services,XML and Flat files.

Oracle Utilities: Oracle SQL Developer, SQL * Plus.

Operating Systems: Windows 7/vista/NT/2000/XP, MS-Dos, UNIX/ Linux.

Reporting Tools: Informatica Power Analyzer, Cognos 8.x/6.x, Business Objects XI R3 and OBIEE.

Modeling Tools: Erwin 4.1/4.0, TOAD 9.x/8.x/7.x, SQL Loader 11g/10g, ER-Studio.

Scheduling Tools: Tidal, Autosys, Control-M and Maestro.

Office Tools: MS PowerPoint, MS Word, MS Excel.

Programming: SQL, PL/SQL, T-SQL, C, C++, C# (.NET), HTML, ASP.NET.

Scripting: UNIX Shell Scripting, Java-Scripting, Korn Shell Scripting, Perl Scripting.

PROFESSIONAL EXPERIENCE

Confidential, Cambridge, MA

Sr.Informatica Developer

Responsibilities:

• Involved in Data modeling design, Designing specifications and Documentation of Data Warehouse using ETL (Extraction, Transformation and Load) tool Informatica Power Center 9.1.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Upgraded informatica power center 8.6.1 to informatica power center 9.1.
• Extensively used Informatica Power Center 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
• Finding the Informatica mappings bottlenecks and optimizing the mappings to get the best performance and tuning the SQL queries as well.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading the data from Sources to RST (Raw Staging Tables) using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed mapplets and worklets for reusability.
• Implemented daily error tracking and correction process using Informatica and Tidal.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process.
• Extensively used cognos 8.4 frame work studio to create reports relative to corporate business planning.
• Extensive hands on Schema design, XML import/export, Scheduling, System management using Informatica.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power center 8.6.1/9.1(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor), oracle 11g, Sales Force.com, TOAD 10.6 for oracle, PL/SQL, ER-studio, Tidal, DB2,IBM iseries interface, XML, Flat Files, Windows 7, Linux, Cognos 8.4.

Confidential, Norwood, MA

Sr. Informatica Developer

Responsibilities:

• Involved in the requirement analysis, database design and modeling Techniques.
• Preparation of strategy for Data Conversion as per the business rules.
• Collection of data source information from all the legacy systems and existing data stores.
• Configured and Installed Informatica power center 8.6 on Oracle database in Windows 2008 Environment.
• Created repositories and folders as per the client requirement.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• New attributes/columns were introduced in the dimension tables by slowly changing dimensions.
• Used Workflow Manager to create Worklets and workflows and Workflow Monitor to monitor the workflows.
• Used Workflow Manager to create connections, sessions, tasks, workflows and created Event Wait, Event Raise, Timer and Control Events in a single master workflow according to the business requirements.
• Applied performance tuning on targets, sources, mappings and sessions to improve system performance.
• Writing Oracle Stored Procedures, SQL scripts and calling them by using Perl shell and Korn shell scripts at pre and post session.
• Developed PL/SQL, T-SQL stored procedures for pre and post session commands and used indicator files to run tasks in workflows.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Created Breakpoints for debugging the mappings using Debugger.
• Extensive use of Persistent cache to reduce session processing time.
• Created partitions for concurrent loading and processing of data.
• Implemented XML and UML web services using C #.NET and ASP.NET.
• Deployment of Informatica jobs into testing, Validation and production environments.
• Preparing deployment documents, user guides, coding standards, and other technical documents.
• 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.
• Involved in the creation of new users and controlling and administering the access privileges to Informatica Power Analyzer.
• Reports were generated using power analyzer for analysis.

Environment: Informatica Power center 8.6.1, SAP R/3, oracle 11g, SQL server 05, Toad for oracle 8.1, ER-studio, Maestro, DB2, Sybase, XML, Flat Files, Windows 7, Linux, Power Analyzer.

Confidential, Irving, TX

Informatica Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Prepared the High-level 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.
• Implemented dimension model (logical and physical data modeling) in the existing architecture using Erwin.
• Designed data model structure and E-R Modeling with all the related entities and relationship with each entities based on the rules provided by the business manager using Erwin.
• Used workflow manager for session management, database connection management and scheduled the jobs to run in the batch process.
• Developed Slowly Changing Dimensions for Type 2 SCD.
• Troubleshoot the issues by checking sessions and workflow logs.
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Involved in the performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.

Environment: Informatica Power Center 8.6.1, Oracle 11g, PL/SQL, SQL Server 2005, T-SQL, SQL*Loader, Erwin 4.0, SQL Loader 11g, Win 2008, Perl & Korn scripts, SAP R3, Flat files, SAS Data, Toad, Solaris 10, Autosys, ODBC, Power Analyzer.

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Extensively worked with the data modelers to implement logical and physical data modeling to create an enterprise level data warehousing.
• Extensively worked on creating Facts and Dimensions tables
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Created and Modified T-SQL stored procedures for data retrieval from MS SQL SERVER database.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Extensively used Informatica Power Center 8.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Involved in data cleansing, mapping transformations and loading activities.
• Developed Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Implemented Slowly Changing Dimension methodology for Historical data.
• Wrote BTEQ Scripts for extracting data.
• Establish Loading process using MLOAD, FLOAD, and BTEQ.
• Exporting Data using BTEQ and Fast Export.
• Generated reports using Teradata BTEQ.
• Fine-tuning of PL/SQL Stored Procedures.
• Designing mapping templates to specify high level approach.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Provided production support for Business Users and documented problems and solutions for running the work flow.
• Extensively worked on unit testing and implemented on transformations, mappings.
• Involved in production support and stabilizations.
• Worked on Migration of Data warehouse in between different versions.
• Coordinated between Development, QA and production migration teams.
• Extensively involved in documentation of the project.
• Reports were generated using Business Objects for analysis.

Environment: Informatica Power Center 8.1, Teradata V2R5/V2R6, Oracle 10g, PL/SQL, Hyperion, SQL SERVER 2005, UNIX Shell scripting, Business Objects XI R3, Control-M, TOAD, Win 03.

Confidential, Bloomington, Illinois

ETL Analyst/Developer

Responsibilities:

• Involved in understanding the business requirements and translate them to technical solutions.
• Worked for preparing design documents and interacted with the data modelers to understand the data model and design.
• Created new mappings and updating old mappings according to changes in Business logic.
• Involved in migrating project from UAT to Production.
• Created XML targets based on various non XML sources.
• Generated sequence numbers using Informatica logic without using the sequence generator.
• Used SQL override to perform certain tasks essential for the business.
• Worked with flat file, xml file and SQL server tables as targets.
• Implemented XML web services using C #.NET and ASP.NET.
• Implemented Performance tuning in Mappings and Sources.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and modularity.
• Created and Modified PL/SQL, T-SQL stored procedures for data retrieval.
• Defined Target Load Order Plan for loading data into Target Tables.
• Used mapping variables to achieve certain goals like creating file names dynamically.
• Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Unit testing of mappings and testing of various conditions.
• Developed Unix Shell scripts for customizing the delivery of Flat files to the customer.
• Involved in the documentation of the ETL process with information about the various mappings, the order of execution for them and the dependencies.

Environment: Informatica Power center 7.1, Oracle 9i, TOAD, SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Autosys, Windows 2003, SQL Server 2005 and XML.

Confidential

ETL Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.
• Cleanse the source data, Standardize the Vendors address, Extract and Transform data with business rules, and built Mapplets using Informatica Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Created universe and reports.
• Extensively involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Written SQL overrides in Source Qualifier and Lookups according to business requirements.
• Involved in creating desktop intelligence and web intelligence reports.

Environment: Informatica Power Center 6.2, Oracle 9i, TOAD, Windows 2000, PL/SQL, MS Excel, DB2, Erwin, UNIX, Business Objects 5.1, Autosys.

Confidential

Database/ETL Developer

Responsibilities:

• Involved in analyzing and development of the Data Warehouse.
• Translation of Business Processes into Informatica mappings for building Data Marts.
• Designed database, logical and physical (relationships, referential integrities, keys capacity planning, object creation) as per business requirements.
• Created Physical, Logical side of the data warehouse which includes adding tables, fields and creating relationships.
• Developed and maintained stored procedures for reading and dropping indexes, converting columns into rows and setting failure emails in tasks.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets, and Transformations.
• Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Created mappings with PL/SQL procedures/functions to build business rules to load data.
• Extensively used ETL to load data from different databases and flat files to Oracle.
• Creating and running sessions and batches using Server Manager to load the data into the Target Database.
• Testing for Data Integrity and Consistency.

Environment: Informatica Power center 5.1, Oracle 8i, SQL plus, Erwin, Windows 2000, Linux, SQL, PL/SQL.