SUMMARY

• Extensively involved in different phases of Software Development Life Cycle (SDLC) such as business requirement gathering, analysis, developing applications, debugging, testing and support.
• Defining and configuring Base Objects, Staging Tables, Landing Tables, and Look ups, Foreign Key Relationship, Hierarchies, Queries, Query Groups and Update/Display Packages.
• Expertise in mapping data from Loading Tables to Staging Tables.
• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Designed & developed multiple cleansing and standardization scenarios using Cleanse Functions
• Expert in importing ORS data source in the application server environment for Informatica MDM Hub.
• Well versed with importing and exporting the ORS repositories from different environments.
• Expert in configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.
• Hands on Experience in Extracting, Transforming, and Loading (ETL) data for data warehouse, data migration and other data conversion.
• Strong experience in designing and developing complex mappings to extract data from different sources including flat files and RDBMS tables.
• Designed Mappings and Workflows in Informatica PowerCenter 9.5
• Experienced with utilizing ETL transformations like Source and Target Definition, Source Qualifier, Lookup Procedures, Expression, SQL Transform, Transaction Control and Router in PowerCenter mappings
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions, Joins, Sub - Queries and Packages to implement business rules and validations.
• Extensive experience in design of Multi-Dimensional modeling concepts like Star and Snowflakes schema.
• Exposure in preparation of Technical Design document, Test cases and Unit test documents.
• Strong experience in resolving SIT, UAT and Post Production issues within the SLA
• Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Master Data Management: Informatica MDM 9.x Multi Domain Edition, Siperian MRM

ETL: Informatica PowerCenter 9.5

ERP: Oracle E-Business Suite 11i and R12

Database Management: Oracle 10g/9i/8i, SQL Developer, TOAD

Languages: PL/SQL, SQL, XML/BI Publisher, VB.net, HTML

Operating Systems: Windows XP / 9X, Windows Server 2008, VMWare, Linux Redhat Enterprise and Linux CentOS 5

PROFESSIONAL EXPERIENCE

Technical lead

Confidential, Houston, TX

Responsibilities:

• Coordinating with business users, enterprise data architects and data modelers in finalizing Downstream Clients requirements.
• Creating Technical Specs to be used by Development and SIT teams.
• Defining User Stories in HP Application Lifecycle Management (ALM) and MS Visual Studio.
• Defining Acceptance Criteria of User Stories, Tasks and Story Points
• Scrum Master for multiple projects
• Defining Mappings and Workflow for Informatica PowerCenter 9.5/9.6 to access MDM’s Landing, BOs and Dimension tables.
• Defining PowerCenter Mapplets for Downstream systems.
• Utilizing ETL transformations like Source and Target Definition, Source Qualifier, Lookup Procedures, Expression, SQL Transform, Transaction Control and Router in PowerCenter mappings.
• Defining job schedules in Integration and production environments using Tidal Job Scheduler.
• Monitoring daily loads from Reltio and load to Dimension tables on SQL Server.
• Supporting UAT and SIT data requirements for Downstream Systems.
• Resolving the Defects and Change Request via HP Service Manager, GitHub and Jira.
• Coordinating with offshore and onshore team for Planned and Emergency Releases.
• Providing Production Support for exiting Downstream Systems.

Environment: Reltio Master Data Management, Informatica Multi Domain MDM 9.5, Informatica ETL PowerCenter 9.5, Tidal Enterprise Scheduler, WinSCP, Oracle 11g, MS SQL Server

MDM Specialist

Confidential, Houston, TX

Responsibilities:

• Coordinated with project leads, business users, enterprise data architects and data modelers in finalizing the master data-model.
• Utilized ERWIN data modeler to define entities, attributes and relationships.
• Configured Base Objects, Staging Tables, Landing Tables and columns in the tables.
• Involved in setting up Foundation Objects for Datamodels like Organizations, Business Relationships, Person and Person Privacy data models in MDM Hub.
• Defined the Foreign Key Relationship between Base Objects.
• Defined Mapping data from Loading Tables to Staging Tables.
• Standardized the data using cleanse functions.
• Created Queries and Query Groups to be used in Packages for IDD and Data Manager Tools.
• Inserted and Updated records using Data Manager tools under Data Steward
• Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
• Defined Put / Update and Display Packages to be used in Hierarchy Manager.
• Experienced in code deployment using Metadata Manager for Import and Export of Metadata and Promotion between environments from development to production.
• Defined job schedules in Integration and production environments using Tidal Job Scheduler.
• Troubleshooting the rejected records during the Landing, Staging and Loading process.
• Resolving SIT and production support tickets using ALM.
• Created Outbound Workflows to extract records from MDM tables to be used by Marketing and Privacy teams.
• Coordinated with Informatica Support team for any Vendor issues.

Environment: Informatica Multi Domain MDM 9.5, Informatica ETL PowerCenter 9.5, Erwin Data-modeler Tidal Enterprise Scheduler, WinSCP, Oracle 11g, TOAD, SQL

Informatica MDM Consultant

Confidential, Chicago, IL

Responsibilities:

• Defined the source systems in Systems and Trust model workbench.
• Configured Base Objects, Staging Tables, Landing Tables and columns in the tables.
• Defined the Foreign Key Relationship between Base Objects.
• Defined Mapping data from Loading Tables to Staging Tables.
• Designed and developed validation rules and match/merge rules and data cleansing using Informatica MDM Hub.
• Standardized the data using cleanse functions.
• Created Queries and Query Groups to be used by Packages, Data Manager and Merge Manager Tools.
• Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
• Defined Put / Update and Display Packages to be used in Hierarchy Manager.
• Improved the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function and match rules.
• Experienced in Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase.
• Created user groups, privileges and roles to the users using Security Access Manager (SAM).

Environment: Informatica Multi Domain MDM 9.5, Oracle 11g, TOAD, SQL Developer, WinSCP

Informatica MDM Consultant

Confidential, Minneapolis, MN

Responsibilities:

• Performed Business Analysis and Requirement gathering
• Configured Informatica Data Director (IDD) in reference to the Data Governance of users, IT Managers & Data Stewards.
• Defined Base objects, staging tables loading tables and foreign key relationships.
• Defined Trust Columns and Trust Scores for source system columns.
• Standardized the data by validating, correcting, completing, or enriching it.
• Created packages in MDM Hub for displaying/updating the data.
• Created subject area groups, subject areas, subject area child, IDD display packages and search queries.
• Migrated the code between different environments using Metadata Manager.
• Created Match Paths, Match Columns for Match and Merge Process.
• Performed Data Steward activities like manual updating and inserting data.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
• Involved in performance tuning of the existing SQL queries.
• Provided status reporting to the Higher Management and partnered withTesting, Business Information and Configuration Management/Support teams to ensure quality implementations and the rollout of standardized and supportable code.

Environment: Informatica Multi Domain MDM 9.1 (Formerly Siperian), Informatica Data Director (IDD) Oracle 11g, TOAD

Demographic Data Analyst

Confidential, Springfield, IL

Responsibilities:

• Organized, analyzed and created reports for 2010 census data based on various attributes and factors to facilitate government policy decisions.
• Supported Lead Poisoning Program with data reports using Teradata SQL in making policy decisions.
• Compared the number of Lead Poisoning cases registered for the children under 36 months and 84 months in the year 2009 and 2010 by using Teradata SQL.
• Utilized SPSS to process and generate reports from National Center for Health Statistics 2008 and 2009 raw data for enabling Community Transformation grant policy.
• Retrieved and analyzed 97 participating Illinois Counties demographic census data based on race and ethnicity to facilitate information necessary for grant decision making.
• Standardized and documented the process to use American FactFinder2, SPSS.
• Supported development of IQUERY a public data access web portal though GUI design evaluations.

Environment: Census 2010, ACS 5-year estimate, Teradata SQL, MS Excel

Summer Intern

Confidential, Houston, TX

Responsibilities:

• Strategized and implemented security measures on IT platforms to enhance information assurance across company systems.
• Assessed Network security concerns and implemented programs like password vault to protect confidential information.
• Rolled out the security measures in different departments of Linux, Windows and PeopleSoft.
• Monitored for unsecure access, database entries in communication and infrastructure systems using Solarwinds.
• Enhancing and ensuring security by monitoring systems for improper changes and addressing them manually or cross checking statistics between databases.

IT Analyst

Confidential

Responsibilities:

• Carried out configuration and implementing Oracle Advanced Collections.
• Fit Gap Analysis and provided CEMLI mapping.
• Defined Invoice Batch Source for Auto invoice process of Sales Adjustment.
• Designed custom logic for Credit Memo Amortization using Oracle Subledger Accounting.
• Debugged Auto Invoice lines stuck in AR interface.
• Performed cross-flow coordination including Tax/OM/SalesCredit.
• Coordinated with the onshore team on daily basis.
• Supported QA team for testing.
• Supported QA team during transition phase for smoke test.
• Documented and Tested the functionality using tests scripts (TE040) for multiple operating units.
• Prepared Functional Specification document.
• Responsible for preparing and maintaining BR100.
• Documented the Workflow process for Sales adjustment.

Environment: Oracle E-Business Suite 11i and R12, TOAD, HP Quality Center

PL/SQL Developer

Confidential

Responsibilities:

• Created the Database objects such as tables, views indexes, constraints and database links in Oracle 8i.
• Developed Data Conversion Scripts using PL/SQL stored procedures for Open Sales Orders.
• Created Stored Procedures, Functions, Packages, and Triggers.
• Used Loader program to load the data into the staging table, PL/SQL to validate and load the data into the interface tables.
• Involved in Unit testing and Peer reviews of Codes, Technical design documents.
• Developed Auto Invoice Interface which imports invoices into the Oracle Receivables module using SQL*Loader and PL/SQL validations.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables for all the conversions.
• Analyzed requirements and prepared documentation for projects in Gulf Coast countries.
• Developed code for customization, testing and analysis.

Environment: Oracle E-Business Suite R12, TOAD

Jr. Software Engineer

Confidential

Responsibilities:

• Team member in the Unilog Management systems project and ISO Visualizer Application project.
• Unilog Management System UMS is an In-House application intended to integrate the functionality of all departments and automating processes such as task assignments, leave sanctions, project and performance metrics tracking.
• ISO Visualizer Application keep track of the companies ISO standardization requirements their expiry and renewal.
• Involved with requirements and specifications Analysis.
• Designed a GUI for the application with .net framework for front end.
• Designed and developed the Oracle schema that accommodates all the areas of the functionality.
• Developed search logic to provide intuitive data retrieval.
• Extraction, Transformation and data loading were performed using stored procedures into the database.
• Conducted validation checks and Regression testing.
• Created product documentation and provided customer support after implementation.

Environment: Dot Net Framework, VB.NET, Oracle 8i, SQL Server, Windows 2000