PROFESSIONAL SUMMARY

• Over Twelve (12+) years of technically sophisticated & business savvy software professional with strong leadership qualifications and hands - on experience in Data warehouse and Business Intelligence.
• Expertise in Informatica 9.x/8.x including development, designing, performance tuning, administration and Support as software development activities.
• Expertise in Informatica administration, designing, developing and implementing technology to support large user groups, supporting users.
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 9.x/8.x, MDM, IDQ, IDR and Patch installation.
• An effective communicator with exceptional analytical, technical and client relationship management skills with the ability to relate to people at any level of business and management.
• Expertise in Dimensional Modelling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modelling using ERWIN 4.x/3.x
• Worked with  Informatica  Data Quality 9.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.1.
• Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Standardizer and other significant transformations.
• Good understanding in entity relationship and Data Models.
• Expertise in Application Development using Oracle SQL, PL/SQL and Oracle Developer Suits.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints and table partitioning.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management in Tableau

TECHNICAL SKILLS

Business Tools: Informatica PowerCenter9.x/8.x, PowerExchange, MDM, IDQ, IDD, Metadata Manager, IDR, Tableau, Horton Works Hadoop Ecosystem, Rational Clear Case, Rational Clear Quest, Agile Development Methodology, Erwin 4.0, Tableau

Project Management Tools: Microsoft Project, Microsoft Office, MS PowerPoint, MS Visio, VSS, AutoSys, Control-M, HPSA (Opsware), CA7, Op-Con, Tivoli workload scheduler

Operating Systems: Windows 7,8,10, Windows NT, Windows2000, UNIX, AIX 6.1, Linux, Z/OS

Languages: SQL, PL/SQL, Shell Scripting, TOAD, Developer2000, Pig & Hive

Databases: DB2, Oracle 10g, SQL Server, Mainframes, Teradata, MS Access

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Informatica Developer

Responsibilities:

• Interacting with business owners for requirement gathering and analysis to define functional specs
• Prepared Solution specification document which contains the details functionality to get the MDM database tables and functionality to extraction and load into IDS tables.
• Developed Informatica Mappings, Sessions and Workflows by implementing the enumeration logic.
• Generate the transaction bus event and Integration business event for each transaction for party tables.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM
• Involved in migration of the maps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data
• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Performance analysis of long running jobs.
• Extensively worked with third party database tools like TOAD & SQL Developer.
• Developed standard and reusable mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.

Confidential, Woonsocket, RI

Sr. Informatica Developer

Responsibilities:

• Interacting with business owners for requirement gathering and analysis to define functional specs
• Prepared High level and Low level design documents.
• Created Informatica mappings for batch load jobs.
• Performance analysis of long running batches.
• Done Installation, Configuration and Administration of Informatica. 
• Configure and Install Informatica MDM 9 5 Hub Server In UNIX Red Hat with the middleware JBOSS 5 1 GA
• Configured cleanse server and address doctor
• Worked with  Informatica  Data Quality 9.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, Parsing and Standardizer.
• Utilized of Informatica   IDQ to complete initial  data profiling and matching/removing duplicate data.
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD
• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Extensively worked with third party database tools like TOAD & SQL Developer.

Confidential, Delaware

Sr. ETL Consultant

Responsibilities:

• Participating in User meetings, gathering requirements, discussing the issues to be resolved, translating the user inputs into ETL technical design documents.
• Using ETL tools like Informatica Designer, Repository Manager, Administration console and Workflow Manager. Also created PowerExchange CDC.
• Involved in Development, Code review, Functional and Integration testing for all the mappings with change data capture (CDC) and workflows and in Performance Tuning.
• Prepared L2 design documents, Technical Object documents, Business Scenario documents.
• Developed shell scripts to validate Headers and Footers of a file, automation of execution and sending the reports through mail to required persons.
• Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality(IDQ).
• Extensively worked with third party database tools like TOAD & SQL Developer.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, SQL and PL/SQL
• Upgrade PowerCenter to version 9.1 from 8.6.
• Developed standard and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in Production Support and Informatica administrator and change management.
• Involved in administration activities like user creation, folder creation, configuring DB connections.
• Understanding the business, functional specification and preparation of Application design document.
• Participation in knowledge sharing sessions with the customer.
• Worked on PowerExchange CDC
• Preparing/reviewing the component design documents
• Discussion with client about the derivations rule for each item and prepare the data.
• Extract the Data from Source (DB2, SQL Server Tables) Landing Area to Staging and Loaded into Data Warehouse
• Developed the mappings and workflows as per the Component design documents.
• Perform the Unit testing and preparing/reviewing the test plan.
• Debugging and rectification of test case statements.
• Involved in Performance Tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• To coordinate the smooth functioning of the module, status reporting, progress reports, resource allocation, planning, organizing project related trainings and holding team meetings.

Confidential

Senior Informatica Developer

Responsibilities:

• Understanding the business specifications and functional specification.
• Understanding the subject areas such as Accounts, Trades, Transactions, Clients, Security Master.
• Prepared the Technical design document which includes design, conceptual and logical architecture.
• Analyzing the tables by capturing the index, partition, category, DCLGEN, copybooks, load jobs, load files and backup files.
• Analyzing the Files by capturing the DCLGEN, copybooks, creator jobs, receiver jobs. Load jobs, load files and backup files using mainframe.
• Preparation of understanding documents as per the business functionality.
• Developed workflows, mappings with extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator.
• To coordinate the smooth functioning of the module, status reporting, progress reports, resource allocation, planning, organizing project related trainings and holding team meetings.

Confidential, Miami, Florida

Sr. Informatica Developer

Responsibilities:

• Analysing the existing system and understanding the business specifications and preparation of Low level design as per the business specifications.
• Developed workflows, mappings with extensively used Transformations like CDC, Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator.  
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Installed PowerCenter software, administer repositories and provide application support
• Involved in Performance Tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Analyzed the client requirements and create design document.
• Preparation of understanding documents as per the business functionality.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Debugging and rectification of test case statements.
• Involved in production support to make sure all issues are fixed in the respective turn-around times.
• Experienced in Informatica administrator, change management and Production Support.

Confidential, Cupertino, California

Developer

Responsibilities:

• Generate the Reports by running the jobs as per the COB each country.
• Changes the coding as per new geo code includes for new region retail stores.
• Monitored the Autosys jobs.
• Experience in deploying forms and reports on the web.
• Experience in writing SQL queries, stored procedure for data analysis and data validation.
• Experience in developing forms based on views, tables and procedures in tabular & form layouts.
• Wrote shell scripts to run the session
• Designing test cases and obtaining the test results.
• Involved in preparation and execution of unit test cases.
• Status report meetings with onsite/team members.
• Tracking the tasks and issues in the project.

Confidential

Developer

Responsibilities:

• Received Involved in the analysis, coding and implementation of Change Requests sent by Confidential
• Worked on Type 2 Slowly Changing Dimension.
• Developed ETL mappings using Informatica Powercenter8.6 to load data from flat files, Oracle to Staging Oracle and from Staging Oracle to Teradata.
• Created mappings using transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Sequence generator, Rank and Joiner transformations.
• Created sessions from Workflow Manager for the mappings developed
• Wrote shell scripts to run the session and Monitored the Autosys jobs.
• Designing test cases and obtaining the test results.
• Involved in preparation and execution of unit test cases.