SUMMARY:

• Over 7 years of IT experience in the Data Warehousing design, development, testing and support.
• Extensive experience in Business Analysis, Application Design, Development, Implementation for Health Care, Insurance, Manufacturing, Commercial and Financial Services.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Extensive experience in Programming, Database design, development and Data Warehousing using Informatica, PLSQL for Extraction, Transformation, Loading (ETL) of data from multiple database sources for medium to large enterprise data warehouses
• Experience in Dimensional Data modeling, Fact & Dimensions tables and Physical & Logical data modelling using Erwin.
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1, SCD2(Flagging, Time Stamping and Version), and SCD3. Implemented the complex business rules by creating reusable transformations and Mappings / Maplets.
• Extensively used Informatica Client tools - Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Maplet Designer and Mapping Designer), Repository Manager, Server Manager, Repository Server Administration Console, Workflow Manager and Workflow Monitor.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio. Experience in debugging and performance tuning of targets, sources, mappings and Sessions.
• Strong Database experience in using Stored Procedures, Functions, Triggers, Joins, Views and Packages in PL/SQL and Oracle and Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2012/2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Hands on experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Experience in using SQL Server Reporting Services (SSRS) for generating various invoices and cover pages of the application.
• Designed and implemented reports using Active Reports, SSRS for .NET.
• Good work experience in Unit testing, Functional, Performance, User Acceptance Testing.
• Experience in OLAP Tools Business Objects, Webfocus, Cognos, Microstrategy used for developing Reports.
• Experience in UNIX Shell scripting and Job Scheduling on Multiple platforms using Autosys.
• Experience working with Teradata,Oracle,SQL Server databases for retrieving data.
• Strong knowledge of complete System Software Development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Experience in preparing project documents, installation documents.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implementedslowly changing dimensionmethodology for accessing the full history of accounts.
• Write Shell script running workflows in unix environment.
• Optimizing performance tuning at source, target,mapping and session level
• Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica 8.6 .1,Oracle 11g, SQL Server 2005, HP-UX.

Confidential

Informatica Developer

Responsibilities:

• Analysis, Design, Development, Testing of ETL applications
• Involved in the various stages of Data warehousing life cycle development, database logical and physical design, ETL processes and Performance Tuning.
• Extensively worked on the Informatica Power Center 9.0 tools - Repository Manager, Designer, Workflow Manager, Workflow monitor.
• Worked in upgradation of Web-focus project to test the reports as a part of internal project in the company.
• Involved in Informatica Administration such as creating and configuring Repository, folders, users and groups using Informatica Power Center Repository Manager.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager. Scheduled jobs in TWC/ Maestro Scheduler.
• Worked on Web Focus reports analysis.
• Experience in using different ETL tools like SSIS - created Packages based on business requirement.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Developed UNIX shell scripts to move source files to archive directory.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visual C# in script component of SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Worked with development teams on the Web Focus reports in the production support team.
• Work with testing team to resolve defects raised in Quality Center.
• Developed and tested Informatica mapping to extract data from different source systems (like Oracle, SQL Server, Fixed Width and Delimited Flat Files) and load into Teradata data warehouse.
• Implemented SCD Type 1, Type 2 changes to keep track of historical data.
• Extensively worked on transformations like Lookup (Connected and Unconnected), Aggregator, Expression, Router, Filter, Update Strategy and Sequence Generator, Sorter, Joiner, Expression, Union.
• Used Repository Manager for moving the mappings and sessions from one environment to another, such as from a development environment to Test and UAT environments.
• Analyzed session Log files in case the session failed to resolve errors in mapping or session configurations. Created stored procedures, packages, triggers, tables, views and synonyms in Oracle.
• Involved in trouble shooting work flow failures by checking session log files.
• Used debugger to test the mapping and fixed the bugs.
• Involved in Unit testing, SIT, UAT as part of projects, Wrote test scripts as part of testing.
• Maintained extensive documentation for design, implementation and testing informatica mappings.

Environment: Informatica Power Center 9.1/10, Web Focus 7.66, Murex 2.11, Oracle 11g, Teradata 13/12, SQL Server 2005, Toad, SQL Plus, PL/SQL, UNIX (reflection Win SCP) Shell Scripting, TWs/Maestro scheduler, Windows XP, MS Visio.

Confidential, NY

Informatica Developer

Responsibilities:

• Provide two tier supports to all applications and provide assistance to all end users and identify any issues in production.
• Maintain schedule jobs in Batch control-M and performed troubleshooting processes and resolve issues by finding root cause.
• Analyze all vendor applications and provide operational support and perform reviews.
• Administer and implement all new systems and ensure transition of plans to production.
• Provide to various new employees and assist with expert knowledge on all production processes.
• Document all production applications and resolve all application issues and answer all requests.
• Monitor all performance metrics for various production systems and identify root cause for all technical issues and recommend solutions.
• Maintain knowledge on all hardware and operating system and update security associate technology.
• Analyze all applications and recommend necessary upgrades and patches on servers and perform troubleshoot on all issues.
• Maintain effective relationships with various system administrators and development teams.
• Prepare all project requirements and develop all associated projects for various applications.
• Participate in periodic meetings and maintain all applications for productions and plan appropriate various strategies.
• Creating/running scripts to purge log files for maintaining disk space on server for daily jobs on a weekly basis. Patching the prod and non-prod server for monthly maintenance.
• Installing and maintaining the application software and server applications.
• Work with the users on SLA basis to assist on resolving the issues with PS Query/SSRS/SSAS/BOBJ reports/Crystal reports.
• Creating jobs and migrating projects to Production environment for new projects.
• Maintaining the Cognos 8 cube refresh jobs and work with users on the issues related to data.
• Maintaining the report refresh jobs on the Control M and Business Objects.
• Worked extensively in SSRS reports development and support. Worked on user issues related to data.

Environment: Informatica 9.1/9.5, Cognos 8/10, BOBJ XI3.1, Crystal reports XI R2, SSIS(2016/ 2012/2008/2005 ), SSRS, SSAS(2106/ 2012/2008/2005 ), PS EPM Query(HR), Ascential Data Stage, windows 2003, Oracle 9i/11g, MS SQL Server 2008/2012, SSMS, Microsoft Visual Studio 2008(BIDS), Microsoft Data tools 2010/2015.

Confidential, Issaquah, WA

Informatica Developer

Responsibilities:

• Involving in all phases of SDLC from requirement, design, development, testing, and rollout to the field user and support for production environment
• Converted functional specifications into technical specifications design of mapping documents (TDD).
• Created Mapplets with the help of Mapplet Designer and used this Mapplets in the Mappings.
• Used different Transformations like Address Validation Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Rank, Update Strategy in IDQ and exported to Power Center as a Mapplets and used in the mapping.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Used SQL Server Reporting Services (SSRS) for generating various invoices and cover pages of the application.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Used Pmcmd commands to run the Informatica mappings using Unix Scripts.
• Created UNIX Scripts for creating the indexes, altering the default table spaces and analyzing the tables.
• Created mapping in Informatica data quality center and defined rules and imported this mapping to power center.
• Developed complex mappings to load data from multiple source systems like Oracle, flat files and XML files to data mart in Oracle database.
• Created Type 2 mapping to maintain history data in Dimensional tables.
• Used Control-M for schedule jobs and used Table Load scripts to load tables.
• Responsible for design and implementation needed for loading and updating the warehouse.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Informatica workflow manager was used to create, schedule, execute Sessions, Worklets, Command, E-Mail Tasks and Workflows. Performed validation and loading of the Flat files received from business users.
• Worked on PL/SQL database writing stored procedures, triggers, views, indexes to extract the data as per requirements.
• Writing PL/SQL Procedures, Functions and Packages to meet the module requirements.
• Fixed invalid Mapping's, tested Stored Procedures and Functions, Unit Testing of Informatica Sessions, Workflows.
• Used Parameter files to reuse the mapping with different criteria to decrease manual maintenance.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing and worked with QA teams regarding fixing bugs.
• Involved extensively in Unit testing, integration testing, system testing and UAT.

Environment: Informatica Power Center 9.x, Informatica Data Quality(IDQ), Oracle 10g, SQL server 2008, PL/SQL Procedures, TOAD, Perl scripts, Rational Clear case, Control-M, MKS Integrity Client, Sybase, MS Visio, ALM, UNIX, PUTTY.

Confidential, Durham, NC

Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering
• Involved in Analysis phase of the business requirement and design of the Informatica mappings using low level documents.
• Analyzed Bloomberg marked data and loaded into Citi Financials data warehouse
• Extracted data feeds from Murex and loaded into the Warehouse..
• Creating the design and technical specifications for the ETL process of the project.
• Extensively used Informatica PowerCenter for extraction, transformation and loading process.
• Extracted data from various sources like Oracle, flat files and SQL Server
• Used various Transformations of Informatica, such as Source Qualifier, Expression, Look-up, Update Strategy, Filter & Router, Joiner transformation etc for developing Informatica mappings.
• Worked on all the SCD like Type 1, 2, 3.
• Used Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008) to Extract transform and load into different DB’s from flat file and relational sources.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Designed, Developed and migrated mappings using Power center repository and successfully migrated mappings from development environment to Production environment.
• Developed Mappings using Transformations like Expression, Filter, Joiner and Lookups for better data messaging and to migrate clean and consistent data as a part of Data Migration procedure using Informatica Power center.
• Created UNIX shell scripts for data cleaning.
• Transformed data from raw forms into structures that are more suited to your application using Data Migrator IBI
• Involved in loading of data into a target database through the automatic invocation of bulk loaders or row-at-a-time inserts using Data Migrator IBI.
• Extensively used Tools like IBM Infosphere, Power center Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors.
• Moved data from one database to other database, Used SQL*Loader for data migration.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Creating sessions and work-flows for the Informatica mappings.
• Involved in Installation and configuration of PowerCenter 8.6.1 client tools and ODBC connections.
• Creating mappings with different look-ups like connected look-up, unconnected look-up, Dynamic look-up with different caches such as persistent cache etc.
• Writing Oracle stored procedures and functions for calling during the execution of Informatica mapping for dropping and recreating indexes on target tables.
• Extensively worked on the Performance Tuning of mappings and sessions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Extensively involved in testing by writing some QA procedures, for testing the target data against source data.
• Worked on Teradata SQL assistant and analyzed the data by writing SQL queries.
• Involved in design phase of Business Objects Universe, Classes and Objects. Generating and Validating Reports.

Environment: Informatica PowerCenter (PowerCenter Designer, workflow manager, workflow monitor), Oracle, Murex, Windows XP professional, PL/SQL Developer, Teradata, Teradata SQL Assistant, Business Objects.

Confidential, NJ

ETL Developer

Responsibilities:

• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Interacted with the business analysts to understand user requirements and gather inputs for creating the Test Plan.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Worked on the various ETL Transformations to ensure that the target data is in consistent with the source data.
• Extracted the data from Oracle, Flat files and load into data warehouse.
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expression, sequence Generator and aggregator transformations to pipeline data to Data Warehouse.
• Used Data transformation libraries like HIPAA, HL7 as a part of B2B Data Exchange using Informatica.
• Created Tasks, Workflows, Sessions to move the data at using workflow manager and workflow monitor.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Involved in Designing of the database and the tables and the relationship between the tables.
• Wrote stored procedure to clean the existing data and created tables, views and indexes.
• Involved in coding of database Triggers, Stored Procedures and Maintaining Integrity Constraints.
• Involved in modifying the existing Stored Procedures.
• Worked on improving the SQL Query performances.

Environment: Oracle, TestDirector, ETL, Informatica, SQL, MS Office, Visual Basic, UNIX, Java, RUP, Rational Rose.