SUMMARY:

• Having 12 years of professional experience on various roles in Data warehousing, Informatica PowerCenter, MDM, Business Intelligence technologies using Tableau and development of web - based applications using Microsoft Technologies.
• Performing requirement gathering, analysis, design, development, implementation, support and maintenance phases of Data Warehouses and Business Intelligence projects.
• Experience of leading various team at onsite and offshore. Ensuring timely and effective delivery of all tasks.
• Experience in end to end process of Informatica PowerCenter and Informatica MDM requirements and its transformations.
• Expertise in design and configuration of Landing tables, Staging tables, Base objects and creating Mappings, Trust and Validation rules, Match rules, Merge properties and Batch Group creation in Informatica MDM.
• Developed Tableau visualizations and dashboards using Tableau Desktop and Developed workbooks from multiple data sources using Data Blending.
• Extensive knowledge in various reporting objects in Tableau like Facts, Dimensions, Attributes, quick filters, context filter, Calculated fields, Sets, Groups, Bins, Parameters, Joins etc. in Tableau.
• Experience in Data modeling concepts, forward and reverse engineering in ERwin.
• Good understanding of database development, Stored Procedures and Functions using SQL Server, Oracle11g and Teradata (BTEQ, FAST LOAD and M-LOAD scripts).
• Knowledge and expertise in .NET framework1.1, 2.0, 3.5 encompassing ASP.NET, Web Services, WCF, ADO.NET, C#, MVC, Entity Framework and Enterprise Library.
• Understanding of Microsoft Project Plan, ITIL concepts and Incident Management.
• Worked on different client locations at UK (Swindon), PERU (Lima), ECUADOR (Quito) and USA.

TECHNICAL SKILLS:

Database: SQL, PL/SQL, SQL Server, Oracle11g and Teradata.

ETL & Reporting Tools: Informatica Powercenter 9.5/9.6.1/10.1, Informatica MDM, SSIS, Tableau, ERwin Data Modeler, SQL Developer, Teradata SQL Assistant & Tidal scheduler.

Languages: Classic ASP, ASP.Net.1.1/2.0/3.5, C#, VB.Net, Web Service, WCF, MVC, JAVA.

Scripting Languages: Java Script, XML, XSD, LINQ, BTEQ and Shell Script.

Operating Systems: Linux, Windows 95/98/NT/2000/XP.

Project Planning: Microsoft Project Plan, Excel and PowerPoint

Configuration Tools: Team Foundation Server 2010 and VSS

Management Methodology: Agile and Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Technology Lead

Responsibility:

• Working to technical team to develop data warehouse solution for various business processes and meet specific client requirements.
• Created Landing tables, Stages and Base Tables based on the data model and number of source systems.
• Involve in creating complex mappings, sessions and workflow in Informatica powercenter.
• Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements.
• Perform data quality and profiling activities, advice on data quality issues and provide analysis on data collection.
• Supported rapid turnaround for ad-hoc analysis, developed use cases, researched and resolved issues
• Translating the requirement into design document like Mapping sheets, HLD and LLD.
• Use Data Validation Option to test the workflow and respective data flow from source and target.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.

Technologies: INFORMATICA PowerCenter9.6.1, Teradata, Oracle11g, Tableau, UNIX, XML.

Confidential, Indianapolis, Indiana

Informatica Lead

Responsibility:

• Coordinating with the business stakeholders to understand the business requirements and working with SME to design the best possible solutions to meet the requirements.
• Working to technical team to develop custom solution for automating various business processes and meet specific client requirements.
• Review data mart/warehouse deliverables and suggest and co-create standards and guidelines.
• Perform data quality and profiling activities, advice on data quality issues and provide analysis on data collection.
• Develop mappings; define workflows and tasks, monitor sessions, export and import mappings and workflows in Development, QA and Production environment.
• Translating the requirement into design document like Mapping sheets, HLD and LLD.
• Use Data Validation Option to test the workflow and respective data flow from source and target.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.

Technologies: INFORMATICA MDM 10.1, INFORMATICA Power center9.5.1, ORACLE11g, XML, XSD.

Confidential

Informatica Lead.

Responsibility:

• Coordinating with the business stakeholders to understand the business requirements and working with SME to design the best possible solutions to meet the requirements.
• Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas.
• Created Landing tables, Stages tables and Base Tables based on the data model and number of source systems
• Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas
• Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching
• Defining Trust Score Validation rules, Match rules and Merge settings.
• Build out best practices regarding data staging, data cleansing and data transformation routines within the Informatica MDM solution.
• Developing mappings using various cleanse functions and Address doctor functions to move data into Stage tables.
• Created complex transformations and mappings and workflows, sessions in Informatica powercenter
• Involved in creating, monitoring, modifying, & communicating project plan with team members.

Technologies: INFORMATICA MDM, INFORMATICA PowerCenter9.5.1, Tableau, ORACLE11g, XML, XSD, DB2, INFORMATICA Power Exchange.

Confidential

Associate Consultant

Responsibility:

• Worked with Business users in gathering the requirements and created Functional and ETL specification documents.
• Created mappings document and performed analysis between source and target
• Worked on PowerCenter Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Worked on Tableau to create data visualization reports.
• Used various transformations like Filter, Aggregator, Source Qualifier, Router, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop mappings
• Implemented slowly changing dimensions (SCD) Type 1 and Type 2 for some of the Tables as per user requirement.
• Developed mapping parameters and variables to support SQL override and ongoing requirements
• Load the transformed and aggregated data into downstream.
• Involved in Performance tuning at source, target, mappings and sessions by finding the performance bottlenecks.
• Provide end to end support to business users to correct any post implementation issues.
• Managed and lead the offshore team singlehandedly.
• Generated and validated the reports in Tableau.
• Performed data validation between sources to target systems.
• Monitor the scheduled batch jobs for the execution of the workflows for any issues/failure
• Designed complex SQLs against source systems and supported unit testing and QA validation
• Prepared validation scripts and validated the data against source system

Technologies: INFORMATICA Powercenter 9.5.1, Web Services, ASP.Net, C#, Tableau, SQL, PL/SQL, SQL Server, XML, XSD and ORACLE11g.

Lead Developer

Responsibility:

• Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Using Informatica PowerCenter Designer analysed the source data to Extract & Transform from various source systems (oracle 10 g and flat files s) by incorporating business rules using different objects and functions that the tool supports
• Worked with data modeling team to design data model using ERwin.
• Designed mappings between source systems to ODS.
• Monitor the scheduled batch jobs for the execution of the workflows for any issues/failure
• Responsible for efforts estimation and allocation of activities to the offshore team members
• Involved in use cases and unit testing, Production support
• Prepared validation scripts and validated the data against source system
• Supporting the System testing and User Acceptance Testing.
• Coordination with offshore and onsite teams for status reporting.

Technologies: Informatica PowerCenter, SQL, PL/SQL, Oracle SQL Developer, ERwin tool, Oracle, SQL Server and UNIX.

Confidential

Assistant Consultant

Responsibility:

• Connect with BAs and come up with high level design documents
• Designed mappings between source systems to ODS
• Created Tables, Keys (Unique and Primary) and Indexes in the MS SQL server database.
• Extracted data from SQL Server (source) to build an Operation Data Source. Applied business logic to load the data into local operational Data Warehouse.
• Worked on Source Analyzer, Target Designer, Mapping Designer and Transformation Designer.
• Worked on Tableau to validate data visualization reports.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop the mappings.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.
• Responsible for efforts estimation and allocation of activities to the offshore team members
• Monitor the scheduled batch jobs for the execution of the workflows for any issues/failure
• Involved in use cases and unit testing, Production support

Technologies: Informatica PowerCenter, PL/SQL, SQL server, Oracle, flat files, MS Access.

Confidential

Assistant Consultant

Responsibility:

• Analysed design documents for informatica mappings.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files (Fixed width and Delimiter),SQL server loading to Oracle target database.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Filter, Aggregation, Lookup (Connected and Unconnected) to load the data
• Efficiently Used mapping parameters and parameter files on different mappings and sessions, based on various business requirements.
• Implemented complex mapping such as Slowly Changing Dimensions (Type II) using current Flag, Effective Date Range.
• Effectively used various tasks (Reusable & Non Reusable), Command, Session, Decision, Event Raise, Event wait, Email, etc.
• Effectively Performed in Unit testing and Peer testing
• Participated in the technical discussions with client and senior management
• Regularly interacting with the client and attend the status call on daily basis

Technologies: Informatica PowerCenter, Flat Files, ORACLE, SQL Server, UNIX, Windows NT.

Confidential

Sr. Software Engineer

Responsibility:

• Understanding workflow rules, system requirements. Designing logical & Physical system flows.
• Responsible for producing a reproducible build from the files placed in the software configuration management system.
• Incorporated enhancements and change requests.
• Involved in system/integration testing.
• Development in ASP.Net, C#, HTML, JavaScript and Unit testing
• Unit testing, debugging and deployment of the system.
• Documenting the processes as per standards.

Technologies: ASP.net 2.0/3.5, C#, TFS, Web Service, WCF, SQL Server 2005 etc.