SUMMARY

• 12 years of overall experience working in the Information Technology Industry.
• 11 years of experience in Data warehouse projects involving Informatica.
• 10+ years of experience in data warehousing using various ETL tools (Informatica 10/9/8/7).
• Experience in working with data warehouses and data marts using Informatica Powercenter (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
• Experienced with Informatica Data Exchange / Informatica Data Quality tools for Data Analysis / Data Profiling and Data Governance.
• Understanding & Working knowledge of Informatica CDC (Change Data Capture).
• Understanding and Working experience in Crystal Reports and SAS Business Objects
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables.
• Extensive work with PL/SQL, performance tuning of Oracle.
• Experienced with Informatica Power Exchange (8.x/9.x) for Loading / Retrieving data from mainframe systems.
• Knowledge of Oracle Apps (Oracle E - Business Suite).
• 3+ years of Data Modeling experience using ERWIN 3.x
• Extensive Unix Shell Scripting knowledge.
• Extensive experience with relational databases (Oracle 8i/9i/10g/11g, Teradata v2 R6, SSIS, Sql Server 2000/2005).
• Experience in working with COBOL, XML, Flat Files.
• Experience in creating complex models (dimensions/hierarchies/categories) in Transformer.
• Experience in Load balancing /optimizing resource usage and defining Environment Variables for performance tuning.
• Proficient in Developing / Designing BO Universe.
• Proficient in developing various types of reports (Web Intelligence Report, Lists, Crosstab, Drill through/up/ down, master-detail)
• Generating and deploying Powerplay cubes and reports in Unix and windows environments
• Proficient in network installations and troubleshooting.
• Reliable, responsible, hard working and good team player

TECHNICAL SKILLS

ETL Tools: Informatica 10.x, 9.x, 8.x, SSIS

RDBMS: Oracle 8.x-12.x, Teradata v2 R6, DB2, Sql Server 2000/2010

Database skills: Stored Procedures, Database Triggers, and Packages

BI / OLAP tools: Business Objects Suite /Tableau/ Crystal Reports.

Languages: Java, SQL, PL/SQL, HTML/DHTML, UNIX

Web Servers: IIS v4.0/5.0/6.0, Apache Tomcat

OS: UNIX/Solaris, Red Hat Linux, AIX, Windows 2003/2012/XP/Vista

Version Control: Visual Source Safe 6.0, CVS, Documentum SmartSpace

Tools: Erwin 3.x, MS Project, MS Visio, Make, Auto sys, Toad, WinScp

PROFESSIONAL EXPERIENCE

Confidential, New York NY

Informatica Developer

Environment: Informatica Power Center 9.x, Oracle 12c, Main Frame DB2, Windows Server 2008, Control M, Serena Dimension, UNIX.

Responsibilities:

• Understand the Requirement and profile data for various Line of Business to source in MDM (Master Data).
• Developed numerous Informatica Powercenter 9.6 Mappings using various Complex business rules to load Party and Policy data.
• Apply Standardization rule on raw Party Data using Informatica Mapping
• Implement Type 2 Dimension capture to history using Transformations like expressions, filters, lookups, router, update strategy transformations and many more.
• Responsible in Data Analysis and Validation on Data load in MDM Repository.
• Work closely with Data Architect on the Rule for Mastering the Party records using various Matching Algorithms
• Write complex SQL to unit test the code and deploy the code for ESQA team.
• Involved in numerous Brainstorming session and provide best solution possible.
• Heavily working on Performance Tuning for existing Informatica interfaces.
• Enhancement on existing interface with mapping variables, mapping parameters and parameter files for handling audit strategies and making the mapping dynamic.
• Documenting the changes and new requirements in Serena Dimension.
• Configuring Control M Jobs based on the dependency on Source Systems.
• Coordinating with ETL Support team for Maintenance Activities

Confidential, Roseland NJ

Sr. ETL Informatica Developer

Environment: Informatica Power Center 10.x/9.x, Oracle 12g/11g/10g, Main Frame, IBM DB2, AIX, Autosys, Jira (Scrum), Jenkins (Automation).

Responsibilities:

• Develop the interface from ADB (Agency Database) and DSS (Distribution Support System) to load into CCMS (Consolidated Compensation Management System)
• Also, developed the interface from CCMS to downstream system to generate statements and check/EFT files
• Developed numerous Informatica Powercenter Mappings using various Complex business rules to load daily transaction on Polices.
• Implement Type 2 Dimension capture to history using Transformations like expressions, filters, lookups, router, update strategy transformations and many more.
• Perform Data Analysis and Validation on Agency data and Distribution transaction
• Involved in Supporting and developing automation framework to deploy code to production every 2 weeks
• Developed the complex interface with downstream system to provide Cobol files and XML Files.
• Perform impact analysis as per Business Requirements changes on overall system.
• Worked on numerous Unix scripts that are used to schedule in Autosys
• Performed Informatica software Upgrade from 9.0 to 10.1.

Confidential, New York NY

Sr. ETL Informatica Developer

Environment: Informatica Power Center 9.x, Oracle 12g/11g/10g, Main Frame DB2, Toad 11.5, Windows Server 2008, Control M, Serena Dimension, UNIX.

Responsibilities:

• Develop the interface from Underwriter Issue System STP (Straight Through Processing) and Admin System LCS (Life Computer System) and UNITY to ILDR (Individual Life Data Repository) Data Mart
• Developed numerous Informatica Powercenter 9.6 Mappings using various Complex business rules to load daily transaction on Polices, Insured and Owner.
• Implement Type 2 Dimension capture to history using Transformations like expressions, filters, lookups, router, update strategy transformations and many more.
• Responsible in Data Analysis and Validation on Daily Transaction that occurs on Admin System.
• Involved in Supporting and developing Customer web Portal called MAM
• Developed the complex interface by switching from Main Frame DB2 to File.
• Constantly Enhancing the Data Mart as per Business Requirements.
• Worked on numerous Data Patches using SQL Loader and PL SQL Script to source new columns in ILDR (Data Mart)
• Involved in gathering Business Requirement and developing new interface for same.
• Heavily working on Performance Tuning for existing Informatica interfaces.
• Enhancement on existing interface with mapping variables, mapping parameters and parameter files for handling audit strategies and making the mapping dynamic.
• Documenting the changes and new requirements in Serena Dimension.
• Monitoring and Configuring Daily Control M Jobs based on the dependency on Source Systems.
• Coordinating with ETL Support team for Failures and Maintenance Activities

Confidential, Kennett Square PA

Sr. Informatica Consultant

Environment: Informatica Power Center 9.1, SSIS 2008, Oracle 11g/10g, Toad 11.5, Custom made ETL scheduler, .Net Application for Data Quality app, Windows Server 2003 SP2, UNIX.

Responsibilities:

• Development of new interfaces using Informatica Powercenter 9.1, testing the interface, entering & exiting QA lab and finally promoting code to production
• Developed numerous Informatica Mappings using various Transformations like expressions, filters, lookups, router, update strategy transformations and many more.
• Creating production control tickets, implementation packets
• Enhancement and Production support of existing 12 interfaces
• Applying/Executing Ad-Hoc scripts based on the user business
• Performing month beginning and month end activities, expiring partitions.
• Set up critical Data Quality checks to identify new deals, changed deals and dropped deals using home grown .Net Application for DQ software called Genie.
• Creating design and operation support documents for existing interfaces.
• Optimizing existing mappings (estimating statistics, drop and create required indexes, look up tuning, enable/disable CONSTRAINTS, ENABLE/DISABLE global and local indexes) to make them run faster.
• Running parallel Development and test environment with production data every week.
• Set up jobs to Back-up repository every weekend using PMREP.
• Admin work like 90 day password change in oracle application accounts, Informatica relational connections, sql server, Informatica repository, Informatica domain account, updating Informatica gateway node using Infasetup Command.
• Converting existing interfaces from Informatica to SSIS.
• Performing Yearly Disaster Recover Drill
• Exporting folders by forming object queries in repository manager.
• Expiring Partitions in database tables as part of retirement of Data Warehouse.
• Experience working with ZAINET and ALLEGRO financial systems.
• Involved in server patching activities and restarting Informatica services after server reboot.

Confidential, Wilmington DE

Data warehouse Consultant

Environment: Informatica Power Center 9.1/8.6, Netezza Appliance, Oracle 10g, MS SQL Server 2000/2005, Business Objects/ Crystal Reports, MS Microstrategy 9, Windows Server 2003, UNIX, Toad.

Responsibilities:

• Analyze, Design, Develop, Tested, Install, and Configure the Data Warehousing applications, which supports the need of Aggregate Spend Solution.
• Involved in various level of project as an ETL expert, starting from requirement specifications to deploying the tested product in Production.
• Worked extensively with Data Modeler Team/Architect to engineer Logical model and engineered the physical model with Erwin
• Engaged with DBA Team while deploying Data Warehouse inclusive Masters, ODS, DDS, ADS & reporting Layer.
• Designed & Developed various Source system interface using Informatica Powercenter 9.1/8.6 Suite.
• Developed numerous Informatica Mappings using various Transformations like expressions, filters, lookups, router, update strategy transformations and many more.
• Developed Worked on CLM (CDW Load Management) Framework, which automate the data load processes with minimal intervention.
• CLM Framework developed using Complex UNIX Scripts, Oracle Packages and Job Schedulers (Autosys).
• Worked with PL/SQL Stored Procedure/Function/Packages to develop CLM Framework
• Worked with XML files and Flat files.
• Extensively worked with Web Development team to design and developed Front End Application
• Worked in designing and developing Business Object Universe that meets Reporting Requirement.
• Developed several Web Intelligence Reports that allow Users to perform Quality Check.
• Worked on Crystal Report development which are used to Submit Federal & State Reports.
• Currently engaged in Operation team that supports & Maintain Aggregate Spend Application.
• Also working on Service Enhancements which fits Users needs.

Confidential, Portland, ME

Informatica Consultant

Environment: Informatica Power Center 8, Oracle 10g, Teradata v2 R6, MS SQL Server 2000/2005, MS Share Point, Windows Server 2003, Cognos8 v8.4, UNIX, Control-M

Responsibilities:

• Working as an ETL expert to develop & execute BTEQ scripts to implement business logic into Teradata SQL and export data into flat files.
• Working with COBOL, XML and flat files
• Designing MLOAD scripts to load data into multiple tables based on Multiload Layout Labels.
• Developing Informatica scripts to load flat files into Teradata for Transformations.
• Working with mappings using expressions, filters, lookups, router, update strategy transformations to implement Type 2 dimensions.
• Working with technical team to plan Informatica Roll-out Plan for other corporate divisions
• Designed Distributed Architecture for new Teradata Datamart for HR.
• Worked in UNIX to create several UNIX shell scripts and executed in Informatica Pre/Post Sessions.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using PMCMD on UNIX Environment.
• Understanding business requirements & writing Technical Design Documentation.
• Designing & developing Interactive Dashboards for IT Board of Directors using Cognos 8.4 for Forecasting & Planning decisions.
• Designed & developed TCM v2.0 Automated Migration Utility for Teradata components to migrate through environments seamlessly using Batch scripting and Environment Variables.
• Worked with various Relational Databases including Oracle, MS SQL Server, UDB/DB2
• Run Queries on the Oracle Database for Unit Testing and Data Profiling.
• Currently involved in mentoring the Junior Teradata developers.

Confidential, Pittsburgh, PA

Informatica developer

Environment: Informatica Power Center 8,TOAD 8, INFORM 4.5,MS SQL Server 2000/2005, Oracle 8/9, Teradata, Cognos8 v8.3,Cognos Series 7 v3, Windows Server 2003,UNIX, Control-M, Documentum SmartSpace, FogBugz

Responsibilities:

• Worked as Data warehouse Developer on Actuarial Data mart project.
• Worked on complete data warehouse development life cycle, from requirement specifications to delivering the test product.
• Responsible for designing Data extraction and transformation routines for loading into the warehouse.
• Designed and developed several ETL scripts using Informatica / UNIX shell scripts.
• Part of upgrade team for Informatica Power Center 8.1.1
• Installed, configured and upgraded from Informatica 7.1.3 to 8.1.1 SP3 64bit on AIX platform.
• Managed Informatica Repositories, including performing backups, managing users/groups and folders, managing relational connections etc.
• Developing consistency guidelines for work between different components
• Unit testing of newly developed ETL transformations.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, update strategy, normalizer and stored procedures transformations.
• Backup resource for server administration.
• Upgrading and maintenance for data warehouse tools.
• Proficient with Visual Source Safe for version control for Informatica objects, Oracle views and packages and test scripts.
• Created medium to complex PL/SQL stored procedures for integration with Informatica using Oracle 10g.

Confidential, Charlotte, NC

Informatica developer

Environment: Informatica Power Center 6.1/7.1, 8.x, Cognos 8, Report NET Version 1.1 MR3, Power Play Transformation Server Version 7.3, Report NET SDK, Unix, Oracle 8i, 10g, PL/SQL, SQL*Plus, SQL*Loader, MS-Sql Server, Erwin 4.0, Win CVS, Windows 2000, Toad, Tidal

Responsibilities:

• Extensively used Informatica tools, Designer, Workflow manager, Repository Manager.
• Expert in Informatica 7 and 8 administration.
• Developed complex queries, PL/SQL packages, control tables, Fine tuned queries using Hints and Explain Plan.
• Created flexible mappings/sessions using parameters, variables and parameter files.
• Upgraded ETL mappings in Informatica from version 6.x to 7.x and to 8.x.
• Modeled a conceptual / logical database, Designed tables, indexes and defined relations using Erwin.
• Used Cursors and Stored Procedures for ETL Control tables and aggregate tables.
• Migrated the solution among different environments, QA and Production. Expert with Release Manuals.
• Extensively used UNIX Shell scripting, Crown and Tidal for Automation. Manually updated UNIX .profile for all the projects to make scripts environment independent.
• Provided Production support.
• Was heavily involved in fine tuning the database creating indexes, stored procedures, partitioning the stage and DM tables, analyzing the queries, tuned the mappings and sessions by using session level partitioning.
• Used Win CVS for Version Controlling.
• Extensive data cleansing knowledge, developed different data handling processes.

Confidential, Tarrytown, NY

Data warehouse/BI consultant

Environment: Informatica Power Center 6.1/7.1,ERWIN 3.5, Oracle 8i, Windows NT 4.0, PL/SQL, SQL*Plus, CognosSeries7, Powerplay/Transformer, ReportNet, Impromptu AdministratorDescription:

Responsibilities:

• Maintained projects using CVS as the version control mechanism
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on UNIX Environment. Conversant with the Informatica API calls.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Improved session run times by partitioning the sessions. Was also involved into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.
• Setting up Batches and Sessions to schedule the loads at required frequency using Power Center Server manager.
• Worked on several data mart projects as a senior data warehouse architect, was involved in complete system development life cycle, starting from requirement specifications to delivering the tested product.
• Participated in Design, Development and Implementation of a Reporting system for Business management using Cognos impromptu and powerplay and configured various components(Transformer/Powerplay)
• Implemented Filters, Calculations, Conditions, and Graphs & Prompts in Impromptu reports
• Developing reports in ReportNet1.1 using Report Studio & Query Studio.
• Creating ad-hoc reports/ Migrating reports from Cognos Impromptu
• Used prompts in ReportNet.