PROFESSIONAL SUMMARY:

• 7+ years of IT experience, in Data warehousing and various technologies, with domain knowledge of Banking and Finance, Insurance, Pharmacy & Health Care, and Retail Industries.
• Six plus (6+) Years of strong Data Warehousing ETL experience of using Informatica Power Center 8.6/8.5/8.1/7.1 Informatica Power Mart, Power Connect, Power Analyzer, Power Exchange MS SQL Server 2000 Analysis Services.
• Six Plus years of Database experience using Oracle, MS SQL Server.
• Strong experience in Data warehousing concepts, Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling and multidimensional modeling, Data Profiling and Data cleansing.
• Extensive experience in using Informatica tool, SSIS package for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.
• Widely used Informatica designer tools – Source Analyzer, Transformation Developer, Mapplet designer and Mapping designer.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator transformation, Active andPassive transformations ,Joiner and Update Strategy transformations.
• Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer and Worklet Designer.
• Actively involved in Performance Tuning, Error handling, Product support on various Platforms.
• Experience in UNIX working environment, writing UNIX shell scriptsfor Informatica pre & post session operations.
• Strong experience in writing UNIX Shell scripts, SQL Scripts for Development, Automation of ETL process, error handling and reporting purposes.
• Involved in various stages of testing Unit testing, Integration, and User Acceptance Test).
• Excellent analytical and problem solving skills.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6/8.5/7.x, Informatica Power Exchange, SSIS, Reporting Service, Metadata Manager.

Databases: Oracle 10g/9i/8i, DB2 8.0/7.0, MS SQL Server2000/05, Teradata, MS Access 7.0/97/2000.

Data Modeling : Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling Fact and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.5.2/3.x.

GUI : TOAD, Visual Basic 5.0/6.0, FrontPage 97/98/2000.

Programming: Visual Basic 6.0/5.0, PowerBuilder 6.0, C, PL/SQL, JavaScript, PERL, VBScript, HTML, XML, DHTML.

Design Tools : Erwin 4.0/3.5, Oracle Designer 2000.

BI/OLAP: MicroStrategy 8.0.1, Crystal Reports 8.0/7.0, Business Objects, Cognos.

Environment : Windows95/98/2000/XP/VISTA, UNIX AIX 5.2/5.3, LINUX, WinNT 4.0, MSDOS.

EDUCATION BACKGROUND:

• Bachelor’s degree in Computer Science and Engineering, Confidential University

PROJECTS PROFILE:

Client: Confidential, Oregon Dec 2010 - Till dateRole: Informatica Developer

A brand new product of Confidential calculates Fuel points based on the activities of an individual in a day. The fuel points accumulated are synced to 1 Confidential + web application for the user to retain their history for analysis. This project is targeted towards testing all the web applications supporting Crimson.

Responsibilities:

• Upgraded Informatica Power center 9.0.1 from 8.6 on Linux servers on all the environments and applying Patches/Hot fixes. Upgraded Netezza databases from version 4.3 to 6.0.
• Performed Upgrading Informatica Power center Version 8.6 to Informatica Power center 9.0.1 with Hot fix 2 in all DEV, QA and Production.
• Responsible for investigation, characterization, and communication of build and release problems, implementing corrective and preventive actions. Resolved all the issues with JIRA tickets on priority basis.
• Analyzed Change request (CR) as per requests from team track/JIRA. Creating SR to Informatica Inc- related to any Power center product issues.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Ensures proper configuration of the Power Center Domain components. Experience in nodes, Repository services, Integration services, and Reporting Services.
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using JIRA ticketing system.
• Ensures proper application of the licensing files. Creating Folders and manages user and user group access to objects based on LDAP settings.
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Creates and maintains all databases required for development, testing, education and production usage. Performs the capacity planning required to create and maintain the databases. Work with UNIX / DBA team related to OS and Database related issues.
• Used UC4 to schedule Informatica workflows, Perl script and shell script to automate jobs.
• Monitoring all Informatica Jobs and file transfer Jobs with UC4 and sever space availability and CPU Process. Involved in FTP and SFTP with UC4.

Environment: Informatica Power Center 9.0.1, 8.6.0, HP Linux Servers, Windows -2000 Servers and Netezza 6. Oracle 10g, Toad 8.6, win SQL, Win SCP, UC4 6.0.

Client: Confidential, Portland, ME July 2010 - Dec 2010
Role: Informatica developer 
Confidential is one of the 15 largest commercial banks in the United States, and provides Customers with a full range of financial products and services in locations from Maine to Florida Assigned as ETL Developer at Confidential on Mortgage Project (Construction Loan Control System-CLCS) to design, develop, and implement the ETL process to load the Products Data Mart, which helped generate Business Intelligence and Performance Management reports.

Responsibilities:

• Involved in the design and development of Data Warehousing project, construction loan control system for commercial real estate loan servicing system (CLCS) project which involves in the loan construction based on the Budget and Unit for an Corporative company.
• Involved in gathering requirements from business users. Participated in the detailed requirement analysis for the design of data marts and star schemas.
• Extracting data from several source systems like Oracle, XML files, etc. and loading data into DDM (Enterprise Data ware house). Designed many Multi Source Single Target mappings and vice versa.
• Worked on Power Center Designer client tools like Source Analyzer, Target Analyzer, Mapping Designer and Mapplet Designer.
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs.
• 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 Wrote UNIX Shell scripts for Informatica ETL Tool and Developed complex Procedures, Functions, and Triggers etc to implement ETL solution through PL/SQL.
• Created an infrastructure to ensure data quality and appropriate data linkage and deliver self service reporting to business and speeding and improving the decision making.
• Involved with the data modular in creating the dimensions and fact tables in different schemas
• Used Parameter files to reuse the mapping with different criteria to decrease the maintenance.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing.
• Used Tivoli (Maestro Scheduling tool) to schedule Informatica, SQL script and shell script jobs.

Environment: Informatica 8.6.1, Flat Files, Oracle 10G/9i,TOAD, ERWIN 7.2, SQL Server 2008, XML, PL/SQL, Maestro, Unix.

Client: Confidential, Los Angeles CA. Dec 2009 - July 2010
Role: Informatica developer 
Confidential the Leading provider of insurance for Retirement specialist and other financial services to individual and group customer’s .Leading international provider of protection and wealth accumulation products and services to individual and corporate customers.

Responsibilities:

• The project is to analyze, design and implement complex database and data integration solutions to support a variety of products of our Rating Compliance business.
• Proficiently worked together with management (end users) as well as development team.
• Design, develop and unit test ETL objects like mappings, sessions and workflows.
• Data model changes/maintenance over the period of the requirement changes.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created scripts in PL/SQL to automate the process of creating and dropping indices before and after the ETL process.
• Extensively worked in operational support and deployment to Test, DR and Production.
• Created static and dynamic deployment groups to deploy the ETL objects from Dev to test and from test to production.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Actively involved in import and export of XML files, code migration of the folders, Linux files, flat files and database objects.
• Daily Data Validation and data quality checks at database level using SQL scripts.
• Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed using AutoSys. Debugged the mapping of the failed session.
• Improved the overall performance by tuning the whole ETL process.

Environment: Oracle 10g, Informatica Power Center 8.6.1, TOAD 8.0, XML, XSD, XBRL, AutoSys (JIL Scripts), UNIX Shell Scripting, Windows XP Client and UNIX Server.

Client: Confidential, San Antonio, Texas Apr 2009 - Nov 2009
Role: ETL/ Informatica Developer
Confidential is one the largest company offering banking, investing, and insurance to people and families that serve in theUnited States military. The CRM operations of the company involved channeling of various offers. The customer data is imported from various sources into Customer management system (CMD), which is a data warehousing system where information is brought into and processed. CMD is used by reporting and marketing teams in collecting relevant customer information, and creating the selective offers for the customers. Informatica Power Center tool was used to load strategic source data into CMD.

Responsibilities:

• Responsible for Power Center 8.6 and Power Exchange 7.0, installations, configuring Power Center domain, nodes and integration services.
• Created repository services and repository contents. Restored the repository contents from the backups using Admin console.
• Extensive experience working with repository manager. Was responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders etc.
• Responsible for creating repository folders and giving access to the users.
• Played a role of Informatica Architect, Developer & Administrator.
• Upgraded Informatica power center 8.1 to version 8.6 on servers and Database upgrade from oracle 9i (9.2.0.6) to 10g.
• Created mappings for various sources like Oracle, SQL server, flat files and XML files to load and integrate data to warehouse.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Worked on SQL server integration services, analytical services and reporting services.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Managed the privileges of users and folders using Repository Manager and used Informatica Administration Console for Admin activities such as starting / stopping server, upgrading the repository etc.
• Created target definition in oracle which was the target database.
• Responsible for maintaining repository backups and their restorations.
• Implemented lookups and different transformations in the mappings.
• Created ODBC connection for importing the source and target definitions. Scheduled sessions and work flows using AutoSys. Informatica scheduler and PMCMD command.
• Developed unit test cases and did unit testing for all the developed mappings.
• Developed Unix Shell scripts and Perl Scripts to Migrate data from different legacy systems in databases.
• Provided production support by monitoring the processes running daily.
• Worked closely with reporting team and helped them whenever they had any ETL issues.

Environment: Informatica Power Center 8.6, SQL*Plus, PL/SQL, Oracle 9i/10g, DB2, Teradata, SQL Server 2005, Erwin 4.0 , Flat files(delimited, fixed width, XML).

Confidential is one of the world’s premier providers of wealth management, securities trading and sales, corporate finance and investment banking services. Merrill Lynch Working with clients as strategic partners, create and execute winning solutions, which address clients’ most pressing strategic, financial and investment needs—anywhere in the world.

Responsibilities:

• Informatica Power Center 8.6 was used to extract, transform and load data from different operational data sources like Oracle, SQL server, DB2, Flat files in to Data staging area (Oracle).
• Developed complex mappings with various Informatica transformations like Aggregator, Lookup (Connected, Unconnected), Source Qualifier, Update Strategy, Router, Joiner, Filter and Expression.
• Involved in admin tasks like analyzing Table Space requirement, load balancing and Performance.
• Wrote the complex SQL queries to retrieve the data from different sources to validate.
• Debugged mappings with Informatica debugger and performed unit testing to run the test session.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange.
• Experienced with Dimensional Data Modeling Techniques like Star Schema, Snowflake Schema, Surrogate Keys, Conformed dimensions and slowly changing dimensions modeling design.
• Used Informatica Tool, Business Objects Data Integrator to integrate Data from Excel files, UDB, Legacy Data providers and third party vendors for the large volumes of data.
• Prepared test data for data driven tests for testing the application dynamically.
• Reviewed computer logs (UNIX logs & Shell Scripts), reported program-processing errors.
• Used AutoSys to schedule the jobs.
• Assisted in updating the logical model with all related entities, attributes and relationship with each entities based on the rules provided by the business manager using Erwin 4.0.

Environment: Windows XP/NT, Informatica PowerCenter 8.6, UNIX, Oracle 11g, SQL, PL/SQL, XML, XSD, Metadata Manager, Oracle Designer, ERWIN, Toad.

Client: Confidential, IL Jan 2007 - Feb 2008 
Role: Informatica Developer 
Confidential is nation\'s largest electric and gas utility company. Confidential distributes electricity to approximately 5.4 million customers in Illinois(ComEd) and Pennsylvania(PECO), and gas to 4,80,000 customers in the Philadelphiaarea.

Responsibilities:

• Involved in the design and development of Data Warehousing project for the improvement of Financial System.
• Involved in analyzing existing logical and physical Data modeling using Erwin.
• Responsible for creating & running SQL scripts for DDL, DML operations on Oracle DB.
• Involved in data migration to import legacy data from one system to the other.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Used Informatica Power Exchange, which scales effectively to support high volume batches to low latency complex data.
• Extracted data from multiple relational databases, i.e. Oracle 10g, Teradata to implement the business requirement.
• Widely used Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used Transformations like look up, Router, Filter, Joiner, Stored procedure, Source Qualifier, Aggregator and Update strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval. Performed Pipeline partitioning to optimize the performance of mappings.
• Created mapplets and used them in different Mappings.
• Partitioned Sessions for concurrent loading of data in to the target tables.
• Performed incremental aggregation to load incremental data into Aggregate tables.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created Sessions and batches to move data at specific intervals & on demand using Workflow Manager.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Effectively monitored daily production jobs and solved the issues related to their failed/abort state.
• Used PMCMD to run workflows and cron tab to automate their schedules.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Performed Unit testing and code testing to insure the codes developed meet the business requirement.

Environment: Informatica Power Center 8.6/8.1.1/7.1.3, Informatica Power Exchange, Oracle 10g, Teradata 12, SQL*Plus, Toad, Erwin 4.0, Flat files, UNIX Shell scripting.

Role: Informatica Developer 
The project was aimed at building an Investment DW, which provides Financial Statement, Capital Gain Analysis, Performance Measurement Analysis, and Portfolio Management to Business Managers. Informatica Power center 6.2 was used as ETL tool to extract data from source systems and to load data in to target systems.

Responsibilities:

• Involved in Systems Study and Analysis and understand the business needs and implement the same into a functional database design.
• Defined the ETL strategy for Data Warehouse population.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized City Data from various sources.
• Installed, Maintained and Documented the Informatica Power Center setup on multiple environments.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Worked on Informatica Power Center 6.2 and created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations used were like the Source qualifier, Aggregators, lookups, Filters & Sequence generators.
• Created sessions and batches to move data at specific intervals & on demand using Workflow Manager.
• Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources.
• Performed Database Migration from sources to the Data Warehousing database. Worked closely with Oracle DBA for migration support.
• Created UNIX shell scripts (Scheduler utilities) for automating the backup of Database/ Transaction log.

Environment: Informatica Power Center 7.1, Oracle 9i, DB2, Teradata, TOAD, SQL Navigator, SQL Server 2000, Windows NT 4.0.