SUMMARY

• Around 7 years of experience in analysis, design, development and implementation of Client/Server and Data warehouse applications using Oracle, MS SQL server on Windows and UNIX platforms.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems using ETL tools, Informatica PowerCenter 9.1/8.6.1/8.5/8.1/7.1 , OLTP, OLAP.
• Data Modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling, and Oracle Designer.
• Experience in documenting Design specs, Unit test plan and deployment plan.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 9.1/8.x/7.x/6.x and Power Mart 5.x/6.x Client, Server.
• Experience in Repository Configuration, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Created data stores, project, jobs, and data flows using Data Integrator.
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat - files, CSV files, COBOL and XML files.
• Experience in Oracle as Pl/SQL Developer.
• Extensively worked on both Windows (Batch and Power shell) and Unix Scripting.
• Extensively worked on Data Services proactively and iteratively collaborate in the profiling and cleansing of data across the heterogeneous sources.
• Experience in creation and customization of ETL extracts and load process using Informatica.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Worked on data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

ETL Tool: Informatica 9.1/8.6.1/8.1//7.1/6.2/6.1

Data Modeling: Toad, Star-Schema, Snowflake-Schema, Erwin.

DBMS: Oracle 8i/9i/10g/11g, MS Access, SQL Server 2003/2005/2008 , Teradata, IBM DB2, Siebel.

Languages& Scripting: SQL, PL/SQL, Java, XML, HTML, Perl, Batch Scripting, Power Shell, Korn Scripting, C, C++.

Operating Systems: Windows 95/98/00/NT/XP/7/8, Sun Solaris, Red Hat, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, TAMPA, FL

Sr. Informatica Developer/OBIEE Developer

Responsibilities:

• Extracted data as flat file from Oracle database, applied business logic to load them in the Standardization area, Central Repository and all the way to data marts and flat files.
• Interview the Business users Data architects in gathering the requirements and finding the data needs.
• Retrieved data from the Oracle CDC Staging tables.
• Participate in the discussions with the business solutions team in creating and implementing the plans for the designs like Flow Chart diagrams, Conceptual and Logical Diagrams, and defining the terms on the needs of the project.
• Helps in getting the potential data sources.
• Create the data results through techniques and tools such as basic SQL queries, data mining, and multidimensional analysis.
• Installed and configured Informatica Power Center Server and client 9.1.
• Designed the mappings and workflows and implemented the logic using the transformations.
• Extensively written Shell scripting to take repository backup and archiving the logs.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner
• Integrated Informatica workflows into OBIEE
• Recreated connections for OBIEE
• Acquired Working knowledge of Repository (RPD) and Datawarehouse Application Console (DAC).
• Designed logical and physical folders of OBIEE.
• Created subject area containers in OBIEE.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Maintained Sequential load through AUTOSYS job scheduler.
• Tuning the SQL queries as required. Created the PL/SQL Stored procedures, Indexes, Views.
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported
• Designed the Build Docs of the entire release/ project for the production support.

Environment: Informatica PowerCenter 9.1/8.6.1, DB2 4 (iSeries Navigator, TOAD for DB2), Oracle 11g, Oracle CDC, Oracle Business Intelligence Enterprise Edition (OBIEE 11g), AS400, Cognos, UNIX, MS ACCESS, MS EXCEL 2010, Autosys.

Confidential, HOUSTON, TX

Sr. Informatica Developer

Responsibilities:

• Extracted data as flat file from Sales Connect, SFDC and oracle database, applied business logic to load them in the Standardization area, Central Repository and all the way to data marts.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.6.1.
• Knowledge in upgrading from Informatica version 8.6.1 to 9.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings
• Involved in creation of Folders, Users, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Built Autosys boxes which schedules the Informatica jobs Confidential very frequent.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers for implementing business rules and transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Retrieved data from SAP BW, SAP Idocs.
• Transformed data from unstructured data sources (XML, Mainframe etc), Applications (SAP Idocs, PS, Sales Vision, Sales Force etc)
• Maintained Full and Incremental loads through Autosys on different environments like Development, Stage, Production and Test environment.
• Created deployment groups, migrated the code into different environments.
• Written ETL Specs and documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in managing the UNIX servers and defining the file systems/directory structures on the UNIX box for various parameters and deciding the disk space and memory requirements.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents and error logics.

Environment: Informatica PowerCenter 8.6.1, Informatica PowerExchange, Oracle 11g (TOAD and SQL Developer), PL/SQL, Teradata, Cognos & Tableau, UNIX, MS ACCESS, MS EXCEL 2007, Autosys SAP BW.

Confidential, MORRISTOWN, NJ

Sr. Informatica Developer

Responsibilities:

• Interacting with business representatives for requirement analysis and to define business and functional specifications.
• Designing and building data marts for Disability, Life, Accident, and underwriting divisions.
• Loading Data to the Interface tables from multiple data sources such as SQL server, Text files and Excel Spreadsheets using SQL Loader, Informatica and ODBC connections.
• Creating necessary repositories to handle the metadata in the ETL process.
• Designing the target warehouse using Star Schema.
• Even involved in some tasks like Development and setting up the new environments and Generating Microsoft sqlserver Reports(SSIS).
• Designing and introducing new FACT or Dimension Tables to the existing Model and deciding the granularity of Fact Tables.
• Installed and configured Informatica Power Center and Server 8.6.
• Designing different regional data marts and loaded subset of warehouse data.
• Writing Unix Shell Scripts to load data from different sources.
• Implementing Aggregate, Filter, Join, and Expression, Lookup, Sequence generator and Update Strategy transformations.
• Implementing Variables and Parameters in Transformations to calculate billing data in billing Domain.
• Used Java Transformations to invoke web services and Java Servlets.
• Used Java Transformations as both active and passive for calling java web services and generating the output data for updating the backend database.
• Tuning performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Simplified the data flow by using a Router transformation to check multiple conditions Confidential the same time.
• Creating sessions, sequential and concurrent batches for proper execution of mappings using workflow manager.
• Retrieved data from Siebel CRM.
• Optimizing Query Performance, Session Performance and Reliability.
• Designing Database schemas using Erwin Design Tool.
• Using Informatica Designer designed and developed Source Entities and Target warehouse Entity for Oracle.
• Involving in versioning the whole process and retiring the old records using the built-in’s DD UPDATE, DD DELETE, and DD INSERT.
• Developing Mapplets using corresponding Source, Targets and Transformations.
• Testing all the applications and transport the data to target Warehouse Oracle tables on the server, Schedule and Run Extraction and Load process and monitor sessions by using Informatica Workflow Manager.

Environment: Informatica PowerCenter 8.6/8.5, Oracle 9i (TOAD), Siebel CRM, MS SQL SERVER 2005, MS SQL Reporting Services (SSIS), MS ACCESS, MS EXCEL 2007(PIVOT tables), Autosys.

Confidential, ATLANTA, GA

Sr. Informatica Developer

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Identification of various Data Sources and Development Environment.
• Data modeling and design of for data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Prepared user requirement documentation for mapping and additional functionality. Extensively used ETL to load data using PowerCenter/PowerConnect from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Created PL/SQL packages, Stored Procedures and Triggers for data transformation on the data warehouse.
• Design and Development of data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, SQL.
• Used Update strategy and Target load plans to load data into Type-2/Type1 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica Power Center.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Design and Development of ETL routines, using Informatica Power Center Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Stored procedures, functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Developed Joiner transformation for extracting data from multiple sources.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Design and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Documented the complete Mappings.

Environment: Informatica Power Center 6.2, Oracle 9i, Teradata, SQL, PL/SQL,TOAD, Unix shell scripting.

Confidential

ETL Developer

Responsibilities:

• Designed and created a multi-dimensional schema.
• Installed and Configured Informatica Server and Power Center, Repository and Server Manager.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer and Mapplet, and Transformations for ETL Processes to load operational data into multi-dimensional database.
• Worked closely with various DW Analyst/Developers working on specific data marts, multiple business units to identify key information that will enhance business decision-making.
• Responsible for tuning ETL procedures and STAR Schema and SNOWFLAKE Schema to optimize load and query Performance.
• Created and Monitored Batches and Sessions using Server Manager.
• Wrote UNIX scripts and PL/SQL scripts for implementing business rules.
• Informatica Server Manager was used to do the loading of the transformed data on to the multi-dimensional schema.
• Generated Unix Scripts for Data warehouse applications and maintaining batch processing.
• Developed Database Triggers and Stored Procedures in Oracle.
• Involved in creating STAR Schema for OLAP cubes.
• Responsible for training end users in installing and Configuring Informatica, creating sessions, batches and browses through repository.
• Involved in organizing production and documentation of complete project

Environment: Informatica PowerCenter 7.1 (Repository Manager, Designer, Server Manager), Business Objects 5.1.1, Oracle 8i, SQL Server, Shell Scripting, UNIX.