SUMMARY

• Over 6 years of total IT experience in software analysis, design and development for various softwareapplications in client - server environment with expertise in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems.
• Excellent hands on experience in OLAP and ETL processing usingInformatica Power Center 6.x, 7.x, 8.x, Oracle8i/9i/10g.
• Experience in ETL process using ETL Tools, creating and maintaining Repository, Source systems, Target Databases and developing strategies for ETL mechanisms using ETL tools like Informatica PowerCenter.
• Gathering and analysis, design, development, testing, performance tuning, and production support.
• Extensive experience in Data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
• Designed and developed complex mapping logic from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union and more.
• Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer and Worklet Designer
• Experience in integration of various data sources with Multiple Relational Databases like OracleDB2 UDB, SQL Server, MS Access, and XML System.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
• Involved in Data Warehouse QA Process. Good experience in Analyzing and Validating Large Volumes of Data from different systems.
• Experienced in developing applications in Oracle and writing Stored Procedures, Triggers and Functions in PL/SQL. Used SQL*loader to load data from Flat files into Oracle database.
• Good in writing shell scripts in UNIX to automate the process of loading and pulling data from different servers.
• Hands-on in migrating Informatica maps versioned with releases maintained properly.
• Expertise In data analysis

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0.1/8.6.1/8.1.1/7.1.2/6.3

BI Tools: Micro strategy, Business Objects

Databases: Oracle 10g/9i/8i, SQL Server 2000/2005, DB2 7.x/8.x, My SQL.

Database Tools: Oracle SQL*Plus, SQL Navigator, Toad 7.4

Languages: C, C++, SQL, PL/ SQL, UNIX Shell Script (Bash, ksh),HTML

Office Suite: MS Word, MS Power Point, MS Excel, MS Access

Operating Systems: Windows XP/2000/NT/95/98, UNIX (Solaris 7/8/9, HP-UX, AIX)

PROFESSIONAL EXPERIENCE

Confidential, Norwalk, CT

Informatica Developer

Responsibilities:

• Responsible for preparing the technical specifications from the business requirements
• Analyze the requirement, work out with the solution. Develop and maintain the detailed project documentation.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Configured the workflows for recovery and restartability.
• Worked on parameter files and variables to allow for reusability of the ETLs
• Provide overall direction and guidance to ETL development and support for the Prescription Solutions’ Data Mart.
• Used the Shell Scripts for running the session.
• Used Update strategy and Target load plans to load data into Type-2 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica Power Center.
• Created Snapshots, Summary tables and materialized views in Database to reduce the system overhead.
• Executed several sessions and created batches to automate the loading process.
• Worked and developed extensively on Autosys job scheduling tool to schedule the Informatica Workflows.
• Ensure integrity and availability of DBMS and reporting applications per service level agreements.

Environment: Windows,Informatica 9.0.1,Oracle 10g, DB2 UDB,Autosys, Unix ShellScripts, Windows 2008 advance server.

Confidential, NYC, NY

Informatica Developer

Responsibilities:

• Created Informatica mappings to build business rules to load data.
• Analyzed and Created Fact and Dimension Tables.
• Developed mappings using InformaticaPowerCenter Designer to load data from various source systems to target database.
• Created complex mappings using transformations like Source qualifier, Aggregators, Connected & Unconnected Lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter etc.
• Responsible to design, develop and unit test the mappings.
• Created Mapplets with the halp of Mapplet Designer and used those Mapplets in the Mappings.
• Used Task developer in the Workflow manager to define sessions
• Written design documentation for the ETL maps.
• Unit tested the maps by running SQL queries on source and target.
• Used heterogeneous files, flat files, Spreadsheets, Oracle stored procedures as sources
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Worked with source teams to resolve data quality issues raised by end users
• Used different Data Warehouse techniques like Star-Schema,Snowflake Schema.
• Loaded data into target database from source database using Workflow Manager.
• Created and Scheduled Sessions based on demand, run on time, run only once using Informatica workflow Manager
• Was responsible for preparation and review of Solution Design Documents.
• Provided technical assistance during development and testing.
• Coordinated between the client and the other developers.
• Was involved in Raising and Resolving Issues.
• Prepared project documentation.

Environment: Oracle 9i, ERWIN4.0, Power-Center 7.1, 8.1.3 (Designer, Repository Manager, Workflow Manager andWorkflow Monitor), PL/SQL, DB2, Solaris 9, AIX/HPUX 10.20 and 11.0.

Confidential, Cherry Hill, NJ

ETL Developer

Responsibilities:

• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto data warehouse
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Used the Informatica Designer, Source Analyzer, Warehouse Designer and Mapping Designer.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Implemented Type 1 and Type 2 slowly changing dimensions.
• Used the update strategy to effectively migrate data from source to target.
• Designed several mappings to extract the data from the Flat file sources and Relational Sources. Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Maintained stored definitions, transformation rules and targets definitions usingInformatica repository manager.
• Used Informatica as an ETL tool to extract data from Oracle manufacturing applications to Target system.
• Created and scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Used Informatica repository manager to backup and migrate metadata in development, test and production systems.

Environment: Informatica Power Center 6.2, Oracle 9i, DB2, PL/SQL, TOAD, SQL* Plus, SQL*Loader, SQL Server 2000, Erwin 4.5, Windows Server 2000.

Confidential

Datawarehouse Developer

Responsibilities:

• Interfaced with users and business analysts to gather information and requirements.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SAS, Ms Excel, Ms Access, SQL, PL/SQL AND UNIX.
• Extracted data from existing data source and performed ad-hoc queries by using SQL, PL/SQL, Ms Access and UNIX.
• Understood basic business analysis concepts for logical data modeling, data flow processing and data base design.
• Utilized skills for problem solving. Developed databases and data warehouse.
• Assisting with the Design and coding and implementation of new production and data storage systems.
• Performing in-depth quantitative analysis or data analysis.
• Extensive system study, design, development and testing were carried out in the Oracle environment tomeet the customer requirements.
• Performed various SQL queries for business analysts.
• Analyzed the data & build data warehouses by using SQL, PL/SQL, and SAS.
• Assisted in the analysis, design, coding and development of building a new schema (staging tables, views, SQL files).

Environment: Oracle 9i, MS SQL Server 2005, UNIX, PL/SQL,UNIX shell scripting, SQL*PLUS, SQL, TOAD, Reports.