PROFESSIONAL SUMMARY

• 7+ Years of IT Experience in Designing, Development and Implementation of Data Warehouses & Datamarts with ETL & OLAP Tools using Informatica Power Center
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, testing, implementation and post - implementation review
• Possess wide range of IT industry experience with Banking / Finance, Insurance, Retail Store, Pharmaceutical, Cable Operators/Internet Service Providers, Healthcare
• Good experience working on ETL Customization and scheduling ETL using Data warehouse Administration Console (DAC) for OBIEE reports in Siebel CRM project.
• Good knowledge of XML mappings, xsd schema definitions and xml sources and targets.
• Very good knowledge of both Star Schema and Snow Flake Schema
• Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.1/8.6/8.5/8.1.1/7.1/7.1.4
• Have good experience in integration of various data sources like DB2, Oracle, Teradata, SQL Server, Flat Files, XML files and Mainframe files into the staging area and then into the Warehouse and Marts
• Proficient in Extracting, Cleaning, Transforming and Loading the data using all the Transformations in the ETL tool Informatica
• Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Involved in debugging and Performance tuning of targets, sources, mappings and sessions
• Extensive experience in developing reusable transformations and mapplets embedding the business logic
• Good Knowledge on creating and executing Unit and Integration test plan
• Installed different IDQ services in Informatica 91
• Good experience in maintaining Oracle, ODBC connections and installing and maintaining various new database connectivity software and Informatica plugins for respective softwares.
• Experience in user accepting testing with business clients
• Closely worked with the DBA in creating tables, migrating tables to different environments and obtaining permissions on various tables, Actively worked with Unix teams and Sys admins in rolling out the updates and hotfixes.
• Have good experience as informatica administrator in creating domains, repositories and folders, applying hotfixes and updating to new versions
• Familiar with Informatica Data Quality and Informatica Data Explorer tools
• Involved in preparing migration documents to move the mappings from development to production repositories
• Good Knowledge on using scheduling tools to automate running of Informatica workflows
• Worked on-call and Production Support
• Involved in UNIX shell scripting, FTP and file management in various UNIX environments
• Team player and self-starter with good communication skills and ability to work independently and as part of a team
• Data Modeling: 7 years of Data Modeling using ERwin, ER Studio, Oracle Designer 2000 and SQL Designer. Solid experience in Relational Modeling, Dimensional Modeling, Conceptual, Logical Modeling, Physical Modeling, Star Schema, Snowflakes Schema, ERD(IDEF1X and IE notation) ER Diagrams, Granularity, Cardinality and Database Reengineering

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.6/8.5/8.1.1/7.1/7.1.4, SQL*Loader

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Business Intelligence: OBIEE, Cognos, Crystal Reports, SAS, MS Access Reports

Data Bases: Oracle7.x/8.1/8i/9i/10g, MS SQL Server 2000/2005/2008, Sybase, DB2

Tools: Mercury Quality Center, Toad, Erwin, Trillium, DAC

Languages: SQL, PL/SQL, HTML, XML, Unix Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Pennsylvania

Senior DW ETL Informatica Admin/Dev

Roles & Responsibilities:

• Extracted data from different sources like Flat files, SQL Server, Cache database, applied several business logics using Informatica PowerCenter 9.1 and loaded data to the Enterprise Data Warehouse
• Migrated the Enterprise Data Warehouse which was on Oracle database to Netezza
• Developing Informatica mappings & tuning them for better performance
• Maintained Address Doctor license, and address doctor files for IDQ
• Installed ODBC connection to connect to several different databases like netezza, vertica and greenplum
• Responsible for Informatica services while performing server upgrades or patches on the operating system(RHEL 64 Bit)
• Implemented Informatica services on grid as well as made the ones on single nodes High Available on VERITAS cluster environment, Also implemented 9.1 on a single server and both with a grid and highly available environment
• Installed PowerExchange for Netezza, which helped us to use the Netezza bulk reader/writer utility for reading and writing data using Informatica and Netezza external tables
• Used Informatica as an ETL tool and Migrated Datawarehouse from Oracle database to Netezza database, and developed several new processes to load data directly to Netezza
• Created complex stored Procedures on Netezza and Oracle, to implement several business requirements
• Actively developed ETL customizations for Siebel CRM project (OBIEE), rolled out for deployment, kicked off and scheduled daily ETL’s using DAC
• Involved in production deployment and responsible for deploying Informatica mappings, and dac metadata changes for Obiee
• Created documentation on mapping designs and ETL processes and Informatica domain administration
• Collected Informatica logs from server and administrator tool and analyzed them along with Informatica technical support to determine the root causes in the cases of Informatica outages
• Upgraded informatica environment from 9.1.0 Hotfix 4 to 9.1.0 Hotfix 5
• Planned all the installation steps and documented the checklist during every hotfix/patch installs on Informatica servers
• Actively involved in technical discussions and served as an informatica SME for most of the informatica related issues
• Created new Informatica users for all the groups using PowerCenter and IDQ services, managed their permissions on different objects like relational connections and repository folders
• Expereienced in working closely with DBA’s and Unix System engineers for fixing Production issues related to Informatica
• Working on a POC for installing informatica 9.5

Environment: Informatica 9.1hotfix 6, oracle 10g/11g, Cognos, OBIEE 10.4.3/11.1.1.5, DAC, Red hat enterprise Linux, open suise Linux, SSH secure shell, VERITAS cluster file system.

Confidential, King of Prussia, Pennsylvania

Senior DW ETL Informatica Admin/Dev

Roles & Responsibilities:

• Maintained a set of 16 to 18 servers of which most where Linux based(either red hat or open suise)
• Installed and Upgraded Informatica from 8.6 to 9.1 on all three environments
• Installed repository service, integration services, web services, reporting services, model repository service, data integration, analyst service and content management services on Informatica v9.1
• Implemented Informatica services on grid as well as made the ones on single nodes High Available on VERITAS cluster environment, Also implemented Informatica 8.6 and 9.1 on a single server and both with a grid and highly available environment
• Registered different plug-in on Informatica repository for functionality of SAP PowerExchange
• Maintained ODBC and Oracle TNS files on Informatica servers for connectivity to different databases like oracle, sql server, cache database, netezza, greenplum and vertica
• Installed integration services, repository services for OBIEE and installed the repository with Customizations from Oracle BIAPPS. Installed and maintained DAC server and client on all three environments
• Actively developed ETL customizations for Siebel CRM project (OBIEE), rolled out for deployment, kicked off and scheduled daily ETL’s using DAC
• Involved in testing and migrating between different versions as well as different environments, came up with a strategy to upgrade the Informatica 86 repository and club it with a actively working 91 repository without deleting or moving any working objects in 91 repository
• Involved in backing up and restoring Domain, repository content and exporting content from repository to repository. Also involved in backing up the DAC repository contents before every critical migration on release
• Worked with Informatica technical support on several Informatica related technical issues and resolved them
• Developed Informatica mappings, sessions, worklets and workflows, for one of the projects in which we brought in the data from different countries from different source system into the data warehouse
• Extensively used xml sources, DTD schema files as xml parser transformation and xml generator transformations for reading from clob datatypes in oracle, read xml files from clobs and write to other relational sources
• Good knowledge of web-service mappings (and address content) created on model repository and their migration from developer tool to powercenter and also from one repository to other within the developer tool
• Worked with shell scripts, to test ODBC connectivity from Informatica server to databases

Environment: Informatica 8.6/9.1, oracle 10g/11g, Cognos, OBIEE 10.4.3/11.1.1.5, DAC, Red hat enterprise Linux, open suise Linux, SSH secure shell, VERITAS cluster file system.

Confidential, Los Angeles, California

Senior DW ETL Informatica Developer/Administrator

Roles & Responsibilities:

• Extracted the data from the centralized data warehouse in Union Bank to perform the transformations
• All the transformation logics are applied in two staging areas and loaded into Fermat (A third party tool)
• Fermat is used to calculate Risk Weight Assets(RWA)
• Involved in full life cycle design and development of Data warehouse
• Interacted with business analysts, data architects and application developer to develop a data model
• Installed Powercenter 8.6 on HP-Unix, windows and also implemented hotfixes
• Used repository manager for object migrations
• Ensured proper configuration of power center domain components, IDQ and MDM
• Created folders and managed user and user groups access to various objects
• Involved in Informatica administration activities using admin console
• Maintained updated and patches for ETL environment
• Worked with Unix team to sort various operating system and data base related issues
• Extracted Data from Data sources Oracle, SAS, SQL Server, Flat files
• Used Informatica Designer to create complex mappings, transformations, source and target tables
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases
• Query Optimization for improving the performance of the data warehouse
• Developed standard and re-usable mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, filter, Normalizer and pre/post SQL
• Involved in performance tuning of the mappings, sessions and workflows
• Used session parameters and parameter files to reuse sessions for different relational sources or targets
• Used UNIX Shell Scripts to automate daily and weekly runs and execute post session commands
• Created sessions & workflows using workflow Manager to load the data into the Target Database
• Created documentation on mapping designs and ETL processes
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database
• Reporting defect to developers/management using the tool MQC

Environment: Informatica Power Center 8.5/8.6, Sybase, Oracle 10g, Business Objects 6.5, SQL Server, PL/SQL, MQC 9.0, TOAD, Erwin, Shell Script.

Confidential, Dallas, Texas

DW ETL Informatica Admin/Developer

Roles & Responsibilities:

• Upgraded to Informatica PowerCenter 8.6.1 from version 8.1.1. Installed Hot fixes, utilities, and patches released from Informatica Corporation.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Installed and configured Informatica Support Console 1.5 to proactively monitor the environment
• Involved in building a common Customer Data Mart (CDM) from the data coming from 34 divisions
• Involved in the analysis of the end user requirements and identifying the sources
• Used Informatica Admin Console to manage domain
• Designed and developed various kinds of maps using transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML
• Created mappings accessing data from DB2 mainframes using Informatica PowerConnect
• Created technical specification documents based on the requirements
• Involved in configuring IDQ
• Involved in the design and development of Stage, ODS and CDM layers for the CVC program
• Involved in design, analysis, Implementation and support of ETL processes for Stage, ODS and CDM layers
• Involved in production support activities with Installation and Configuration of Informatica PowerCenter 7.1 version, both Client, and Server
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and CDM layers
• Involved in Shell scripts to start/stop workflows which would be invoked by TIDAL scheduler
• Extensively used pmcmd to invoke the workflows from UNIX shell scripts
• Job Scheduling and Monitoring using Tidal Software
• Prepared Run books providing guide lines to trouble shoot the errors occurred during the run time
• Used Informatica Workflow Monitor, Workflow Manager, and Designer to monitor and control jobs
• Analyze Informatica Session logs for failed processes and accordingly create and assign Defects in Test Director
• Creation on status reports for various daily jobs and reporting any mismatches
• Capturing the process timings of scheduled jobs and maintaining the records
• Writing SQL / PL SQL scripts as required checking various jobs status
• Created UNIX shell scripts to invoke the stored procedures for the control process for the parameter file generation
• Wrote PL/SQL stored procedures/functions to read and write data for the Control Processes at Stage, ODS and CDM levels
• Helped the Tuning team in tuning the existing mappings and sessions to improve the performance
• Involved in preparing test plans and testing all the ETL process
• Wrote stored procedures, functions, database triggers and UNIX shell scripts to support and Automate the ETL process
• Prepared migration documents to move the mappings from development to production repositories

Environment: Informatica power centre 8.6, Cognos 8.4, Teradata, oracle 10g, MS SQL Server 2005 PL/SQL, trillium 7.6, DB2, Erwin 4.0, Mercury Quality center 8.0,UNIX Shell scripting, XML,TOAD.

Confidential, Tampa

Informatica Developer

Roles & Responsibilities:

• Designed and Developed mappings needed for enhancement of project
• Worked with Informatica Powercenter Mapping Designer, Workflow Manager, Workflow Monitor
• Created Informatica Mappings to populate the data into dimension and Fact tables
• Exported and Imported mappings between different Informatica folders and also Repositories
• Used different transformations like Aggregator, Lookup, Filter, Expression, Router, Update Strategy and Sequence Generator
• Informatica Debugger is used to test the mappings and fixing the bugs
• Provided Production Support for IDS, DSS and created Unix Shell Scripts to delete data that is older than 3 years from fact tables
• Experience in working with Informatica Service and Repository Service
• Familiar with Data Warehouse Architecture, design methodologies and best practices
• Experience with server log files, editing UNIX scripts, FTP ing files and checking space on server
• Scheduled Informatica sessions and workflows using Informatica Scheduler
• Performance and fine tuning of Informatica mappings
• Loaded data into datamarts on a daily basis
• Created new repositories and new folders within the repositories using Repository Manager
• Experience with Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Involved in System testing and User Acceptance Testing

Environment: Informatica Power Center 8.x, Oracle 9i, DB2, TOAD, Erwin, SQL, PL/SQL, XML, Windows XP, HP UNIX

Confidential, Chicago, IL

Informatica Developer

Roles & Responsibilities:

• Business Analysis and Requirement Collection
• Understanding business needs and implement the same into a functional database design
• Creating the physical & logical design using ERWIN
• Working on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet, and Transformations
• Developing Informatica mappings & tuning them for better performance
• Designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables
• Creating Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Used most of the transformations such as the Source qualifier, Aggregators, Connected & Unconnected Lookups, Filters & Sequence Generator
• Creating the reports for different regions and demands for future forecasting
• Creating Models based on the dimensions, levels and measures required for the analysis
• Extracted data from various sources like relational databases Oracle, Teradata and flat files
• Designing and creating Fact tables and Dimensions
• Designing and developing Informatica mappings for data loads and data cleansing. Tuning the Informatica Repository and Mappings for optimum performance
• Suggesting changes to the Physical Data Warehouse Model based on the ETL and Referential Integrity gap requirements
• Scheduling and monitoring automated weekly jobs
• Optimizing Query Performance, Session Performance and Reliability
• Involved in creation of schema objects like indexes, views, stored procedures, functions, Packages and synonyms
• Involved in the analysis of how the purchase order process is organized
• Involved in developing Triggers which internally call procedures and functions
• Involved in testing the database for the queries that are generated and handled the performance issues effectively
• Involved in documenting the entire process

Environment: Oracle 7.X, SQL, PL/SQL, Windows