SUMMARY

• Around 7 Years of IT experience in development, Implementation and Testing of various projects using Data Warehousing tools.
• Worked on teh entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation
• Extensively worked in Extraction/Transformation/Loading of teh legacy data to Data warehouse using Informatica (Power Center 9.01/8.0.1/8.6.1/7.1.4/6.2.2/5.1) including Designer, Repository Manager, Server Manager, Workflow Manager and Workflow Monitor
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS)
• Experience in Installing, Configuring, Upgrading, and Patching Informatica Data Integration software on a UNIX platform.
• Experience with Informartica PowerExchange, PowerCenter Enterprise HA/Grid, pmcmd command line interface, and Security (including Native and LDAP security), MDM Multi - Domain Edition (Siperian) version 9.1.0
• Supported teh MDM Architect to assist in teh definition and execution for teh overall MDM strategy, with clear mastery Data Quality and MDM techniques.
• Worked with Information Analysts to understand teh logical data mappings, data rules and match/merge logic for creation of teh golden record
• Perform peer document reviews and code reviews to ensure adherence to user requirements as well as applicable standards and conventions.
• Blueprinted teh implementation and guided teh process through critical junctures like configuration, systems integration and data migration during Informatica PIM installation.
• Experience in designing/developing complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Normalizer.
• Providing performance improvement related guidance to teh Informatica team members
• Extensive experience developing complex mappings with Custom Transformations, XML Sources, Web Services Consumer.
• Extensively worked on loading data into ESSBASE Cubes using Type 1, Type 2
• Improved performance by using Explain Plan, creating appropriate indexes, queries optimization, utilizing table spaces and partitioning schemes.
• Resolving data issues, complete unit testing and complete system documentation for ETL processes
• Create PL/SQL procedures, packages, and functions, as well as windows or UNIX batch scripts where necessary to augment Informatica mappings in teh environment.
• Strong oral and written communication skills, with teh demonstrated ability to communicate complex technical topics to management and non-technical audiences.
• Ability to quickly analyze and come-up with an efficient industry standard solution for a given problem

TECHNICAL SKILLS

Operating Systems: Windows up/2000/NT/98/95, UNIX, AIX, MS DOC

ETL Tools: Informatica power center 9.6.1/9.5/9.1.0/9.0.1/8.6.1/8.6/7.1.4/6.2, PIM, DAM

OLAP: Business Objects (BOXIR2), Qlikview

Programming Languages: C++, PL/ SQL, TOAD-SQL, SQL * PlusRDBMS: Oracle 8, 9i, 10g, 11g. DB2 8.1, SQL Server 2005

Applications: MS Word, Excel, Outlook, FrontPage, PowerPoint, MS-Vis

Other Tools: Toad, SQL * Plus, SQL Developer, SQL Navigator, SSRS, SSIS, 5.5, Control - M, Autosys, Secure FTP (SSH).

PROFESSIONAL EXPERIENCE

Confidential, Auburn Hills, MI

Sr. Informatica Consultant

Responsibilities:

• Interacted with Business Users to understand teh Business requirements and prepared functional & technical documents to implement teh solutions as per Business needs.
• Worked in AGILE (Scrum) software development process using Version One, for teh better accurate sign off.
• Involved in end to end SDLC process planning, design, development and implementation of new/enhancements of various Data Mart projects.
• Documented teh HLD, TDD and Mapping document as per business requirement and ETL processes.
• Used Power Designer for logical/physical designing of different data marts and integrated warehouse.
• Designed and developed ETL Jobs/Workflows/Data flows using Oracle and DB2 tables as source.
• Created complex mappings that involve slowly changing dimensions (Type 1, Type 2, and Type 3), target load order and constraint based loading using teh Power Center Designer.
• Used Cloud Computing to provide data access and storage services to end users without teh need or limitation of teh physical location and storage requirements at end-user side.
• Extensively used transformations like Aggregator, Expression, Sorter, Sequence Generator, Joiner, Filter, Router, Rank, look up and Update Strategy transformations to model various standardized business processes.
• Developed email notifications for success/failure of ETL process using shell scripts.
• Involved in creating UNIX scripts for automation and JIL's for scheduling teh ETL jobs.
• Implemented enhancements to long running ETL jobs using performance tuning via Informatica.
• Extensively used PMCMD commands on command prompt and executed in Unix Shell scripts to Automate teh process for delta loads, archival process of files and COPY command operations
• Installation and configuration of PIM solutions in client environment.
• Implemented Informatica PIM and Print solutions - sometimes enhanced with DAM solutions like Celum, Adobe or OpenText.
• Designed teh ETL schedules for Daily/Weekly/Monthly jobs as per teh business requirements. Created Ad-hoc jobs to perform teh initial load for high volume ETL’s
• Prepared Development package which has all teh information about Software Configuration Management (SCM) data, Deployment guide and Code review artifacts.
• Compiled test plans and test cases for positive and negative scenarios.
• Worked on tracking, reviewing and fixing ETL defects per teh scheduled timeframe using HP Quality Center to log and track defects.
• Applied Reconciliation process & Error handling methodology to teh ETL process using Data Movement Control(DMC)
• Involved in upgrading Informatica from 9.1.0 to 9.5
• Used Reusable Transformations and Mapplets to prevent redundancy of transformation usage.

Environment: Informatica PowerCenter 9.5/9.1.0/Flatfiles, Informatica PIM, DAM, DB2 9.5, Oracle 11g, Shell Scripting, TWS, PSQL, Oracle SQL developer, Clearcase, Unix.

Confidential, MO

Informatica Conversion Specialist

Responsibilities:

• Worked closely with business analysts and reviewed teh developed Functional specs, suggested modifications after source analysis.
• Worked with SAP team to identify teh target tables, functional modules and data sources.
• Created Tables and Indexes for teh staged data in teh oracle.
• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract teh Data from multiple source systems and loaded into Preload staging tables.
• Designed and developed mappings using various transformations such as source qualifier, expression, connected and un-connected lookup, router, aggregator, filter, sequence generator, update strategy, normalizer, joiner and rank transformations in Power Center Designer.
• Wrote SQL-Overrides and used filter conditions in source qualifier there by improving teh performance of teh mapping.
• Created mapplets and reusable transformations that provide reusability in mappings.
• Used Informatica debugger in finding out bugs in existing mappings by analyzing data flow and evaluating transformations and done unit testing for teh individual developed mappings.
• Performed end to end data validation tests leveraging Informatica DVO tool.
• Worked on performance issues and bottlenecks to reduce teh load time and monitored teh data loads.
• Created technical design documents for teh developed informatica coding.
• Used Informatica PIM for more integrated data management.
• Created detailed unit test documents with all possible Test cases/Scripts.
• Resolved all bugs that are raised in HP ALM during teh functional testing.
• Involved in loading teh data from flat files to SAP server using LSMW program.

Environment: Informatica Power Center 9.1, Informatica PIM, Power Exchange, Informatica DVO 9.5, Flat files, Oracle 11g, SAP ECC, HPALM, Microsoft Visio, AIX, Cognos and Windows 7.

Confidential, Detroit, MI

SSIS/SSRS/ ETL Developer

Responsibilities:

• Used Reporting Services (SSRS) to schedule reports to be generated as per requirement.
• Used report items like Tables, Sub Reports, charts to develop teh reports in SSRS.
• Deployed and generated reports onto teh server using teh Reporting Services Report Manager.
• Created Drill Down, Drill Through, Sub and Linked reports using teh SQL Server Reporting Services SSRS as well as managed teh subscription and authentication of these reports.
• Created data sources, connection strings and datasets are defined for generating teh reports.
• Implemented security to restrict teh access to users and to allow them to use only certain reports.
• Implemented complex ETL strategies using SSIS packages that extracted teh data from different heterogeneous sources like Flat Files, Excel Files and dumped into a centralized Data Mart.
• Installed SQL server 2012 and migrated all ETL packages and reports from 2008 to 2012.
• Made use of Event Handlers, Logging, breakpoints and Data Viewers for effective debugging of packages.
• Optimized SSIS packages by using various techniques such as non-blocking, synchronous communication nature transformations, optimizing sources as well as executing packages in parallel.
• Developed Aggregations, Partitions and calculated members for cube as per business requirements.
• Created SSIS packages for file transfer from one location to teh other using FTP task.

Environment: MS SQL Server 2008 R2, T-SQL,SQL ServerReporting Service 2008 R2,SQL ServerReporting Service 2012/2014, Query Analyzer, Index Tuning Wizard, and SQL Profiler Windows Server 2003.

Confidential

ETL Developer/ PL/SQL

Responsibilities:

• Worked with Business Analysts and Data Architects in gathering teh requirements and designed teh Source to Target Mapping Specification Documents.
• Documented Solution Architecture Package (High Level Design Documents).
• Used Informatica an ETL tool to extract data from source systems to target systems. Source systems are mainly Oracle, flat files and XML
• Involved in performing Data Profiling for teh new source systems which measures Equipment performance.
• Provide support for reporting and back up support for data and developing ETL transformation using Informatica power mart.
• Performed Data transformations using various OWB Transformations like External tables, Views, stored procedures (transformations), joiner, filter, splitter, union, pre mapping and post mapping, input parameters, sequence generator, constant, Expression, aggregator etc
• Worked with Process flows and created sequence process flows and parallel process flows as sub process flow in master process flows with success or failure notification through email.
• Worked with Location creations and registrations. Worked with OWB locations and file locations
• Handled file check, user defined activities, email, and, or activities with conditional paths.
• Developed a PL/SQL stored procedure which is used in Stored Procedure Transformation in teh OWB Mapping to load teh flat file into teh target tables.
• Written UNIX Shell scripts to transfer teh files from teh different servers like third-party FTP server.
• Developed UNIX scripts for automation of PL/SQL procedures and for validating teh flat files. These scripts are used for System Testing for Source Validations.
• Assisted teh Interns by giving KT and halped them in understanding teh Business Processes.

Environment: Windows NT/XP, UNIX, Oracle 10g, Oracle Warehouse Builder R2

Confidential

Database Developer

Responsibilities:

• Actively participated in teh requirement analysis, database design and modeling.
• Participated in teh implementation of a payroll system using SQL, Oracle forms & triggers on UNIX platform. Performance tuning of SQL, PL/SQL procedures and teh batch jobs. Identifying teh issues with SQL trace and extended SQL trace.
• Maintaining different environments and preparing teh Bill of materials for code deployment to different environments.
• Responsible for adding teh database users, providing required roles, privileges, resting teh user passwords and adding teh space to teh existing table spaces.
• Involved in database administration. Design, development and implementation.
• Responsible for development of forms and interfacing teh data selection from teh database.
• Assisted in teh Development of several reports including tabular, master detail reports.

Environment: Oracle 8i, SQL, PL