SUMMARY

• 8 Years of IT experience including Data Warehouse Design, Analysis, Architecture, Dimension Modeling, Business Intelligence strategy, Development, Testing, Implementation, and Documentation.
• Expertise in entire life cycle of DWH with project scope, Analysis, requirements gathering, data modeling, ETL Design, development, Unit / System testing and production support.
• Strong ETL experience of using Informatica 9.6.1/9.5.1/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Repository manager, Workflow Manager/Monitor.
• Have done POC on otherInformaticaProducts likeB2BData Exchange,B2BData Transformation, Metadata Manager, Data Quality, Data Explorer, and Data Validation Option.
• Developed complex mappings using Informatica Power Center Transformations - Lookup Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Extensive Knowledge in requirement gathering, analysis, design, development, implementation, testing, integration deployment, documentation and maintenance of Mainframeapplications.
• Having strong hands on experience in extraction of the data from various source systems like DB2, Oracle, My Sql, Flat Files, SFDC, XML and Teradata.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in Understanding Data Warehouse Design & Model.
• Acquired experience with full life cycle of Software Development (Planning, Analysis Design, Deployment, Testing, Integration and Support).
• Extensively worked with Netezza database to implement data cleanup, performance tuning techniques.
• Extensive experience in developing Stored Procedures, Packages, Functions, Views and Triggers, Complex SQL queries and Oracle PL/SQL.
• Proficiency in data warehousing techniques for Change Data Capture, Data Cleansing, Slowly changing dimensions types (1 and 2).
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Solid analytical and dynamic troubleshooting skills.
• Self-motivated and enjoy working in a technically challenging environment.
• Experience in work allocation, status tracking and Coordinating with teams to keep them focused on the deliverables.
• Expertise in using both Agile & Waterfall Methodologies effectively.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5.6/9.5.1/9.1.0/8.6.1/8.5.1/7.1.2 , Informatica PowerMart 6.2/5.1/4.7, Informatica Power Exchange, B2B DX/DT v 8.0, Metadata, Data Mining, Datamart, OLAP, OLTP, SQL* Plus and SQL*Loader

Data Modeling: Dimensional Data Modeling (Star Schema Modeling, Snowflake Schema Modeling), FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer, Erwin 4.5/4.0/3.0

Databases: Oracle 11g/10g/9i/8i,Teradata v14/15, MS SQL Server 2012/2008/2005 , IBM DB2,IBM Informix, MySQL, MS Access.

Business Intelligence: OBIEE, Oracle BI Publisher

Programming: SQL, UNIX Shell Scripting, PL/SQL, Java, Batch Scripting, XML,XSL, Autosys, TOAD, HTML, DHTML, C, Java, Jira.

Environment: UNIX, Windows XP/Vista, Linux, Windows 2007 Professional, DOS.

PROFESSIONAL EXPERIENCE

Confidential, Marlborough, MA

Sr. ETL/Informatica Developer

Responsibilities:

• Worked with Business analysts and users to gather, clarify and finalize functional requirements
• Involved in Project planning and implementation throughout the project life cycle
• Conducted meetings with Business users & SME for requirement clarifications
• Prepared FR (Functional Requirements) and high/low level design document and estimates
• Created technical design document that meets the business requirements following all Industry defined standards
• Created of database objects like Tables, Views, Materialized views, Stored Procedures, Functions, Packages, DB triggers, Indexes using oracle tools like Toad, PL/SQL Developer and SQL* plus
• Created Pl/Sql packages and procedures to automatically drop and create table indexes and constraints
• Extracted data from different data sources such as Flat files, XML, Excel, oracle and SQL Server
• Extensively designed XSD data model and wroteXSLtemplates to transform original xml data to required formats.
• Designed Complex Informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, Union Transformation, connected/unconnected Lookups, Update Strategy, Stored Procedure, Web services, HTTP, Router, Normalizer and Java Transformations to transform and load the data from and to flat files and relational tables.
• Designed Mappings using B2B Data Transformation Studio.
• UsedInformaticaB2BData Exchange to Structured data like XML.
• Extensively worked inInformaticaB2BDT to extract the data from unstructured files and on line streaming sources.
• Worked on Power Exchange for change data capture (CDC).
• Developed UNIX shell scripts for handling the execution of workflows and pre validation scripts that checks Informatica repository connection, database connection, table level locks and record count in source data files before triggering Informatica workflows
• Developed ETL mappings, sessions and workflows using Informatica 9.5 to extract the data from source systems (Oracle 11g, Teradata & flat files), apply business logic and load into target system (Oracle database 11g)
• Used Debugger within Mapping Designer to test the data flow between source and target and to troubleshoot the issues with Mappings
• Developed Power Exchange data maps that were used to pull the data from files on the Mainframe.
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Data masking sensitive customer data on monthly/Adhoc basis using Informatica ILM tool.
• Created reports using the Pivot Tables, View Selectors, Column selectors, Guided Navigations, In-place drills in the reports, Embedding HTML links in the report columns for Dashboards.
• Creating reports and publishing them in the dashboards using answers
• Customized and developed repository, configured metadata objects(Subject area table column)and Web Catalog Objects(Dashboards, Pages, Folders, Reports)
• Simplified Informatica mappings using Mapplets and reusable transformations
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes using AutoSys
• Extensively involved in the performance tuning at the Source, Target, Mapping and Session Level
• Reviewed offshore activities and allocate tasks to the teams on day to day basis

Environment: Informatica Power Centre 9.5, B2B DX/DT v 8.0 Flat files, Oracle 11g, Oracle Business Intelligence 11g,Teradata, SQL scripts, Unix scripting, Flat files, AutoSys.

Confidential, WI

ETL Developer

Responsibilities:

• Gathered requirements from business analysts for designing and development of the system.
• Assessed data to understand its quality challenges using data profiler.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Created complex mappings using java transformation to extract data from Flat files .
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Extensively used the capabilities of Power Center such as File List, pmcmd, Target Load Order, Constraint Based Loading, Concurrent Lookup Caches etc.
• Extracted data from different data sources such as Flat files, XML, Excel, oracle 10g and SQL Server.
• Exposure toInformaticaB2BData Transformation that supports transformation of structured, unstructured, and semi-structured data types while complying with the multiple standards which govern the data formats.
• UsesInformaticaB2Band Autosys to create jobs to run the workflows.
• Exported the workflows inB2Band created end points inB2Bto trigger the workflows.
• Good Knowledge onapplying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformationand loading into targets.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Creating Reports and dashboards for the Marketing and Logistics Teams.
• Working on the support and enhancement tickets for the BI support.
• Hands on the creating new mappings, Maplets, workflows using Informatica (ETL tool).
• Data Quality Analysis to determine cleansing requirements.
• Created post-session and pre-session shell scripts and mail-notifications.
• Used debugger to test the mapping and fixed the bugs.
• Used Shell Scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from the log files on Unix server.
• Worked with the presentation layer, business layer and data layer. Used Dataset to get data in XML format and usedXSL/XSLT to transform it before presenting to the user.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets, and Transformation objects.
• Involved in moving Mappings, Sessions and Workflows between development and production environments.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Scheduling batch jobs usingTIDAL, testing and debugging its components, and monitoring the resulting executable versions
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Actively involved in the production support and also transferred knowledge to the other team members.

Environment: Informatica Power Center 9.1/ 8.6.1, B2B DX/DT v 8.0, Oracle Business Intelligence 10.1.3.4.1 , Data Masking, Flat Files, Oracle 10g, Tidal, Toad 9.1, SQL, PL/SQL, Unix Shell Scripting, XML,XSL.

Confidential, Idaho

Informatica Developer

Responsibilities:

• Interacted with SMEs and analysts to understand the Business requirements
• Created the Source to Target mapping specifications to document the transformation rules
• Developed Mappings as per specifications to load alignments and employee assignments data into Alignment Master database
• Worked on Debugging and fixing the defects in Informatica Mappings
• Worked extensively on performance improvement of Informatica ETL at source, target, session and Mapping level
• Designed and implemented Error and Exception Handling framework in Informatica PowerCenter 9.1
• Lead a team of developers to Build, Test and Deploy ETL code for Alignment Master
• Simplified the Informatica mappings using Mapplets and reusable transformations
• Conducted ETL design and code reviews with the developers
• Translated Business requirements to technical/system requirements and communicated it to team members
• Trained and assisted team members on technical and domain to ensure timely delivery
• Involved in Project planning and implementation throughout the life cycle of the project
• Prepared functional requirement and high/low level design document and estimates
• Designed ETL Load Strategy that would perform better on the Oracle Exadata Database
• Created Technical Design Document that meets the business requirements following all Industry defined standards
• Conducted meeting with Business Users & SME for requirement clarifications
• Reviewed designs with teams and act as a lead for a team of 5 members.
• Extensively worked in scheduling server and parallel jobs using scheduler tools likeTIDAL, Control M, AutoSys.
• Conduct Daily meetings with development and testing teams to clarify the questions and provide guidance
• Developed/Modified ETL Mappings using Informatica Powercenter 9.1 and assisted team members
• Reviewed Code developed by team to make sure the function requirements are met and code meets all the standards
• Reviewed Unit Test Case, DB Scripts and Migration Document
• Worked closely with ETL Team and Senior management to report on the Project Status, Timelines and Escalations
• Worked with QA Team in the QA Testing phase and Resolve issues/bugs raised during QA Phase
• Worked with Business users and assist/answer questions during UAT phase

Environment: Informatica Power Center 8.6, Sql Server 2005, Tidal 5.2, MS Access, SQL Server Management Studio, Windows XP Professional, PL/SQL, Oracle 9i, Flat Files,UNIX

Confidential, Bridgewater, NJ

ETL/Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, and rollout to the field user and support for production environment.
• Migrated Informatica from version 7.3 to 8.6.
• Implemented Slowly Changing Dimensions using PowerCenter to insert/update the dimensions.
• Implemented delta loading for data loading from source to target.
• Created parameter files using mappings.
• Used debugger to test the mapping and fixed the bugs.
• Extracted data from Siebel to oracle using EIM tables.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Data marts.
• Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program (Functions, Procedures) for data extracting, transforming and loading.
• Scheduled sessions for pulling the data from transactional databases in order to maintain the Daily and weekly based loads.
• Involved in Performance tuning for better performance.

Environment: Informatica PowerCenter 8.6, 7.3, Oracle10g/ 9i, Control-M, PL/SQL Developer, Informatica Power Connect for Mainframes, DB2, Erwin 4.5.

Confidential

Responsibilities:

• Analyzed the existing system functionality, screens, and database structure of existing application.
• Involved in requirement gathering meetings and created design and demo documents.
• Involved in creating new database objects like Tables, Indexes, Types, Views, Functions, Procedures, and Packages.
• Writing complex PL/SQL code and SQL queries
• Develop backend procedures by using PL/SQL.
• Maintained the data integrity and security using integrity constraints and database triggers. Also used instead of triggers and Pragma Autonomous transaction trigger.
• Created records and nested tables in the procedures for handling data.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors thoroughly on Performance issues.
• Involved in creating Sequences (to generate consequence numbers) and Constraints (to limit the type of data).
• Wrote triggers and packages by using PL/SQL for giving security privileges.
• Prepared the Test conditions and test scripts using standard templates.
• Reviewed and modified the programs to ensure technical accuracy & reliability of programs.
• Analyzed and documented various components which are customized as per customer requirement.

Environment: Windows XP,Oracle9i, Pl/Sqldeveloper, VSS

SQL Server DBA/Developer

Confidential

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL. Server … on windows … Servers. Installation of SQL Server Service Packs & hot fixes.
• Maintain MS SQL Server 2005 and 2008, including security, configuration and install service packs upgrades.
• Migrated databases from SQL Server 2000 to SQL Server 2005.
• Migrated DTS packages to SSIS packages.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Performed Database full Backup, Transaction log backup & differential backup on a daily basis.
• Scheduled automated jobs using SQL Server Agent.
• Used Index tuning wizard and rebuilt indexes for faster query response.
• Used Performance Monitor/SQL Profiler to resolve Dead Locks/Long running queries on 32 bit and 64 bit clustered and standalone server environments.
• Update statistics, database integrity check and Backup operations.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user-defined functions
• Implemented High availability solution (Replication, Clustering, Log shipping, DB Mirroring).
• Involved in logical and physical modeling using Erwin tool in the Design phase.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Data migration (import & export/BCP) from Text to SQL Server.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Coordinating post-implementation events such as testing.

Environment: SQL Server Enterprise, Windows Enterprise Server 2003, Server 2004, IIS