PROFESSIONAL SUMMARY:

• 7+ years in the IT industry with experience in providing information management consulting services on Master Data Management, Data Integration, BI Reporting and Data warehousing applications.
• Experience with Software lifecycle phases including design, development and implementation.
• 7+ years of experience as a software professional in Informatica MDM, ETL, Cognos.
• Expert in Enterprise Information Management, Data Warehousing with Analysis, Design.
• Over 2 years of experience in Informatica MDM Hub development in HUB and IDD area.
• Involved in L1 and L2 level production support. Generating Change requests and Service requests based on the severity of the problem.
• Strong expertise in installing and configuring the core Informatica MDM components (Informatica MDM Hub Server and Hub Cleanse).
• Involved with team to upgrade Informatica MDM from 9.6 to 9.7 and 9.7 to 10.
• Extensive knowledge and experience in Oracle, PL/SQL, Stored Procedures/ Functions/Cursors/ Packages& Triggers.
• Worked on TIBCO (Enterprise application integration (EAI) technologies) as middleware with SIF.
• Used the access protocols SOAP, to communicate with the MDM Hub. Worked on Data Integration using Informatica Power center Data Integration Platform.
• Highly Skilled in MDM Hub configurations - Data modeling&Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica/Business Data Director.
• Demonstrated hands-on experience of Informatica MDM including batch and real-time processing.
• Performed loading of data into Informatica Hub by working closely with Informatica ETL Developers.
• Performed Data standardization of addresses using AddressDoctor4 and AddressDoctor5, Trillium.
• Data integration in real-time using SIF API’s, Modifying existing code for User Exits.
• Ability to Design, document data content, relationships, structure and flow, processes that manage, transform data, business rules that govern data and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data
• Experience in Informatica Power Center tools such as Repository Manger, Designer, and Workflow Manager.
• Worked on OLAP tools such as Power Play, Power Play Transformer and also on reporting tools such as Report Studio, Impromptu and Impromptu Web Reports and Modeling tools like FrameworkManager.
• Worked with facts and dimensions and designed dimensional model utilizing star/snowflaked schemas for use in BI reporting.
• Experience with Agile Framework SCRUM. Involved in Bi-weekly release with sprint models.
• Excellent experience in using and writing LINUX Shell Scripts.
• Great understanding and experience of DB2, Oracle and SQL Server.
• Worked with various SQL developer tools such as TOAD, SQL Plus, and SQL Developer
• Expertise in IBM Cognos BI Author with immense experience in the area of Report Studio, Framework Manager, Query Studio and Cognos Connection
• Strong experience in Installing, Configuring, Monitoring and Management of Cognos on Windows Platform.
• Result oriented team player and able to handle crisis situation effectively and efficiently.

TECHNICAL SKILLS:

EIM Tools: Informatica MDM Multi-domain 10.0/9.7, Informatica Data Director (IDD), Informatica Power Center.

Databases: Oracle 8i/ 10g,11g, MySQL, SQL Server 2012/2008/2005, MS Access, DB2

Programming Skills: SQL, PL/SQL,Unix Shell Scripting, JAVA, HTML, XML

RDBMS Tools: TOAD (Oracle), Oracle SQL Developer, SQL*Loader (Oracle), SQL*Plus

OLAP/ Reporting Tools: IBM Cognos Report Studio 8.x, IBM Cognos Query Studio 8.x, IBM Cognos Framework Manager 8.

Modeling Tools: ERWIN

Environment: Windows 2000/ XP, Unix, Windows 7, Windows Server 2003, 2008

Packages: MS Office (MS Outlook, MS Excel, MS PowerPoint, MS Word)

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

MDM Developer

• Interacted with Business & Data Architects Leads to understand/clarify the business requirements.
• Assigned to Initial Data Conversion Project in the Development of ETL SQL Scripts and MDM Hub tables landing/staging/mapping and the batch group that support data flow .
• Performed MDM related Trust Score setting, Validation Rules Setting, Match Rule Setting and Merge Setting.
• Recommended different approaches to improving performance and reduce the process time.
• Worked in a Scaled Agile Framework SCRUM that included the Program Increment - Biweekly Sprint deliverable model interacting directly with Business Product Owners for visibility and delivery
• Executed Ongoing synchronization until BD1 IT Migration for Customer and Competitor Accounts from HPE to HPI and performed data validity checks.
• Communicated to SFDC on data sync
• Developed IDD applications for Customer, Competitor,Partner,Other Party Object and time line object Other Party Object Association.
• Interacted with the Business for the various validations to be incorporated in the IDD applications and implemented the same using cleanse functions in HUB.
• Reworked on hub configuration by creating new match paths to reflect the company split.
• Migrated code to various environments namely DEV, ITG(SIT), STG(UAT) and PROD under tight deadlines.
• Troubleshooting various issues during migrations between environments.
• Worked on Message Triggers for Production Defect by manually assigning Target message queue and updated Event triggers with change list.
• Participated in the analysis of migrating ORS from Informatica MDM 9.7 to Informatica MDM 10.
• Job scheduling using third party software Tidal Enterprise Scheduler(TES).
• Used TIBCO (Enterprise application integration (EAI) technologies) middleware with SIF.
• Used the access protocols SOAP, to communicate with the MDM Hub. Creating Web Services in TIBCO.

Environment: Informatica Multidomain MDM 9.7,Oracle 11g,Toad, Erwin, Eclipse Kepler Service Release 2 CISCO Tidal Enterprise Scheduler 6.0.Linux, JBOSS Server, Version Control TortoiseSVN.

Confidential, Indianapolis, IN

Informatica MDM Developer

• Gathering requirements from the Business and preparing the functional documents.
• Worked on Data Profiling and corresponding documentation, data validation, pre-landing process.
• Performing requirement gathering, analysis, design, development, testing, implementation, support and maintenance phases of both MDM and Data Integration Projects
• Master Data Management (MDM) & Data Integration concepts in large-scale implementation environments.
• Creating landing tables, Staging tables, Base Tables as per the data model and data sources.
• Defining Trust Score, Validation rules, Match rules and Merge settings.
• Closely worked with other IT team members, business partners, data stewards, stakeholders, steering committee members and executive sponsors for all MDM and data governance related activities
• Working with PowerCenter Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Created complex transformations and mappings, processing tasks, scheduling sessions, importing/exporting repositories
• Performed all Informatica administration functions such as user access accounts, roles, setting standards and associated privileges and folders
• Good experience in Data Warehousing methodologies/Dimensional Data modeling techniques such as Star/Snowflake schema using ERWIN
• Extensively implemented Slowly Changing Dimensions: Type1, Type2, Type3
• Hands on experience with advanced optimization techniques such as concurrent caching, auto memory calculations and pushdown optimization
• Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center, Power Mart (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Worked with Roche Production Support in fixing IDD and Hub related issues
• Working with tools like TOAD, SQL Developer and SQL plus for development and customization.
• Configuring, performance tuning, installation of Informatica mappings, sessions, workflows, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects.
• Team player and self-starter with good communication skills and ability to work independently and as part of a team.
• Involved in upgrading of Informatica MDM 9.6. Upgrade to 9.7. Was actively involved with cloning of ORS in new schema.
• Closely worked with Downstream consumers like Sales Force.com, SAP, USSAS.
• Involved Data Integration process using Informatica Data Integration Platform.

Environment: Informatica MDM 9.6/9.7, Informatica Data Director 9.5.1, JBOSS 5.1, Oracle, TOAD for Oracle11g LINUX, Address Doctor 5, Informatica PowerCenter(9.0) Job Scheduler AUTOSYS, Informatica Version Control.

Confidential, Atlanta, GA

ETL Consultant

Responsibilities:

• Analyzing the data warehouse layers of the existing ETL process.
• Document the level of effort for all Stages of ETL process.
• Modifying the PL/SQL packages which do various data load processes.
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of modified Functional Requirements.
• Coordinating with onsite Functional and Technical team and being a senior developer coordinated with the team members and suggested the development strategies.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions and at database.
• Developed Slowly Changing Dimension for Type 1, Type 2 and Type 3.
• Designed several mappings to extract the data from the Flat file sources and Relational Sources
• Prepared the technical documentations for all the Informatica mappings, process flows.
• Extensively used Most of the transformations in Informatica Power center
• Developed and documented Mappings/Transformations and sessions as per the business requirement.
• Developed complex mappings using Lookups connected and unconnected, Rank, Sorter, Joiner, Aggregator, Filter, Router transformations to transform the data per the target requirements.
• Wrote complex SQL queries involving multi table joins and outer joins using Toad
• Coordinated the Business Intelligence team in developing web reports.
• Created test cases for unit test and performed unit test once mapping is complete
• Worked closely with testing team to resolve bugs.

Environment: Oracle(11g), TOAD for Oracle, LINUX, Informatica Power Center(9.0), Visual SourceSafe.

Confidential, Charleston, SC

Consultant - Analyst

Responsibilities:

• Worked on different projects like CAPEX(Capital Expenses), TOMS(Telesales Order Management), Inventory Management, Financial Reporting, Payment Analysis, NCR and SourceTEK(Old and new Kiosk machines used by the company).
• Modify existing Crystal reports with COGNOS.
• Replacing Stored Procedures with new model in Framework Manager.
• Conversion of existing ENTRICOM System (third party software) into COGNOS.
• Building views, synonyms on Oracle and SQL database.
• Building different reports with Charts and drill through, Prompts.
• Maintaining existing system like Inventory Management, NCR, E-Commerce, Call Center, Payment Analysis, Financial Reporting.
• Generating reports using Query, Join, Union, Intersect, Except, for pulling data from different tables those are not part of the model for generating some exception reports.
• Also involved in publishing package, bursting reports, granting permission to different groups, scheduling jobs.
• Worked on building Views and writing stored procedures as per the requirements.
• Optimizing the Framework Manger model and reports.

Environment: Cognos 8 (Framework Manager, Report Studio, Query Studio), SQL Server 2000, Oracle(10i/9i), Toad(9i/8i), Windows XP, Crystal Reports(9), Visual Sourcesafe.