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 all software lifecycle phases including design, development and implementation.
• Highly experienced in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• 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 and proven technical proficiency of Informatica (Siperian) MDM including batch based and real-time processing.
• Performed loading of data into Informatica Hub by working closely with Informatica Data Quality Developers.
• Performed Data standardization of addresses using Address Doctor, Trillium and Informatica Data Quality and Data integration in real-time using SIF API’s.
• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• 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 extensively 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 Framework Manager.
• Expert in working with Framework Manager, Transformer, Report Studio, Power Play, Analysis Studio, Cognos Administration, Cognos Insight, Business Insight.
• Worked with facts and dimensions and designed dimensional model utilizing star/snow flaked schemas for use in BI reporting.
• Exceptional communication and cross-group collaboration skills.
• Team player, have experience working in larger matrix project groups.

TECHNICAL SKILLS

EIM TOOLS: Informatica MDM 9.x,10 Edition, Siperian Master Reference Management XU, IDD, SIF Cleanse Adapter, Address Doctor

BI TOOLS: Cognos 10/8.x(Business Insight, Report Studio, Framework Manager, Transformer, Cognos Series 7.x (Impromptu, Power Play, Access Manager, IWR)

ETL: Informatica Power Center 9.0/8.0(Designer, Workflow Manager)

Databases: Oracle 10g/9i,SQL Server 2000/2005/2008 , MS Access

Application Servers: JBoss, WebLogic

Web Servers: Microsoft Internet Information Server (IIS) 5.0/4.0/3.0 & Tomcat

Operating Systems: Windows NT/2000/Server 2003/XP, Windows 7

Programming Skills: SQL, PL/SQL, MDX, HTML, Front page, Java Script and VB

Tools: TOAD,PL/SQL Developer, MS Excel, MS Project, MS Power Point, MS Word.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

MDM &IDD Developer

Responsibilities:

• 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
• Recommended configurations on how to improve performance
• Focused primarily inside hub and parameters
• Worked in a Scaled Agile Framework 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 for HPI.
• 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 from Virtual Image to various environments namely DEV, ITG(SIT), STG(UAT) and PROD under tight deadlines
• Troubleshooted 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 code and data from MDM 9.5 to Informatica MDM 10.

Environment: Informatica Multidomain MDM 9.5,Oracle 10g,SQL Developer, IDD, Toad, Erwin, Eclipse Kepler Service Release 2

Confidential, Irving, TX

Informatica MDM &IDD Developer

Responsibilities:

• Participated in Design and Build for Supply Chain domains namely Supplier, Manufacture, Location, Product and Contract
• Configured 7 source systems and prepared Source to Target Mapping document for ETL load in Landing Tables.
• Configured Landing Tables, Base Objects,Relationships,Staging Tables,Mappings,custom cleanse functions, Match and Merge settings, Trust and Validation Rule.
• Identified issues in the ETL load to reflect the current data model relationships.
• Configured Entity Objects, Entity Types, Hierarchy and Relationship Types for Contract,Product,Party Hierarchical view in IDD
• Configured Supply Chain IDD Application for use by Data Stewards
• Configured Queries and Packages for all the domains for use in IDD
• Configured Subject Area Groups for Supplier,Manufacture,Product and Contract
• Configured Roles for Read Only, Approver and IDD specialist for respective domains.
• Created Task Assignment in IDD for Supplier and Manufacture domains.
• Worked with ETL team to schedule Batch Groups for all the domains and are called via ETL workflows which calls corresponding MDM SIF API’s.
• Used SOAP UI to perform SIF API calls like clean tables etc.
• Installed and configured Jboss, Hub, Cleanse server, Address Doctor on Production.
• Participated in making the Data Stewards familiarize with the IDD functionality.
• Cleansed US address using Address Doctor with US license.
• Ability to coordinate across teams, working closely with peers to ensure the appropriate focus and sense of urgency is applied to all MDM issues
• Worked with Informatica Support for MDM issues and upgrades.
• Configured External Authentication using LDAP configuration for Users Authentication.
• Documented the application and teach/share with others as necessary

Environment: Informatica Multidomain MDM 9.7.1 HF1, SQL Server 2012, IDD, Erwin, Address Doctor 5, SOAP UI 5.0.0

Confidential, Austin, TX

Lead MDM &IDD Developer

Responsibilities:

• Configured Source Systems of Confidential, Configured MDM tables in the following sequence: Base Objects, Relationships, Landing Tables, Staging Tables, Mappings
• Performed data loads using batch capabilities in the Hub
• Performed deployments using Metadata Manager for validation, exports, promotions and change lists
• Worked on IDD UI configuring subject areas like Customer, Partner, Competitor, Geographic facts, Site etc. that assisted customers and partners to search and edit master records that enabled client with their sales process transformation
• Implemented Hierarchy for Organization by converting Organization base object to Entity base object and created Entity type, Relationship base object and Relationship types.
• Created queries and packages for ORG hierarchy and created and validated the profile.
• Worked on high priority production issue on Hierarchies for World Region, Country which can be accessed in IDD by business users.
• Resolved the hierarchy issue in User Acceptance Testing (UAT) environment and replicated the same on Stage (pre-prod) and Production environment.
• Resolved the hierarchy relationship issue in IDD when business users were not able to create relationship between the entities.
• Deployed IDD Configuration by importing BDD Configuration files, Message bundles, Error code bundles and User Exits by clearing cache and redeploying the applications
• Worked closely with Data modelers to change the data model when required in IDD.
• Worked closely with Business Users to understand their requirements and incorporated cleanse functions and User Exits to utilize the validation requirements that were discussed
• As a Lead worked closely with offshore test team and helped in closing the SIT defects.
• Designed data loader in IDD UI by using import functionality and templates. It’s first of its kind at Confidential .
• Involved in granting access to Business users on the User testing and Production environment based on the objects they were working on.
• Worked closely with Informatica support to solve various defects and got it resolved.
• Worked in a global delivery team with teams working in six different geographic locations.

Environment: Informatica Multidomain MDM 9.5,Oracle 10g,SQL Developer, IDD, Toad, Erwin, Eclipse Kepler Service Release 2

Confidential, Durham, NC

Informatica MDM Specialist

Responsibilities:

• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor5 in Dev, QA, Pre-prod and Prod Environments.
• Led effort for gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Implemented IDD for Pharma R&D model as per the Business requirements
• Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in Dev, QA, Pre-prod and Prod environment.

Environment: Informatica Multidomain MDM 9.1.0, Informatica Power Center 9.1.0, Oracle Web Logic, Oracle 10g,SQL Developer, Address Doctor, IDD, SIF, Toad, SQL*Loader, Windows Server 2003, Erwin, Cognos.

Confidential - Bellevue, WA

Informatica MDM (Siperian) Consultant

Responsibilities:

• Interacted with business customers, business/systems analysts, and other application developers in the design, development and maintenance MDM solutions.
• Defined and configured landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Enabled Hard Data Deletion and verified it is working correctly in MDM
• Defined the security such that MDM ORS schema will be secured with access only granted for specific integration uses, using users created for those specific integrations
• Configured Address Doctor and developed the source-target mappings for address standardization.
• Applied trust and validation rules as per the business needs and performed match tune process and loaded into base objects.
• Identified Golden Record for Customer Data by analyzing the data cleansing and merging duplicate records coming from different source systems.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Dev, QA, Pre-prod and prod environment.
• For importing the changes made to IDD application used import to existing application button and for exporting the entire application used export button
• Used packages workbench tool for creating packages which are required by SIF.
• Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
• Developed and managed Relationships between data domains for the data models.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Created Unit Test Case Document, Technical Design Document, Informatica MDM Hub batch process, Informatica Hub and IDD Migration Request Document.

Environment: Siperian MDM, Informatica MDM Multi-domain9.1, WebLogic, Informatica Power center/Analyst, Oracle 11g, Microsoft Project, Erwin

Confidential, Durham, NC

Data Warehouse Consultant

Responsibilities:

• Involved with ETL developers, for developing complex mappings, Mapplets, reusable transformations using
• Used Informatica components extensively Repository, Designer, Workflow Manager & Workflow Monitor .
• Fixinginvalid Mappings,Debuggingthe mappings in designer,Unit and Integration Testingof Informatica Sessions, Worklets and Workflows.
• For loading business logic successfully to database used different transformations like Router, Expression, Source Qualifier, Aggregator, Filter and Sequence Generator transformations extensively.
• Created workflows and used various tasks like Email, Event-wait and raise, decision in workflow manager.
• Involved in Interaction with DBA team for creation of primary and secondary indexes on Data warehouse tables.
• Created Session and Batches using server manager to execute mappings.
• Involved in the development and testing of individualdata marts, Informatica mappings and update processes.
• Designed relational and dimensional models using Framework Manager and generated reports from the data marts usingcognos Report Studio.

Environment: Informatica8.0(Designer, Repository Manager, Workflow Manager, Mapping Designer), Cognos 8.4(Framework Manager, Power play Transformer, Report Studio, Analysis Studio, Query Studio),Cognos Report Net1.1(Migration), SQL SERVER 2008, SSIS/SSAS, PL/SQL

Coleman Company, Wichita, KS Cognos Developer

The Coleman Company, Inc. (Coleman) is a worldwide leader in the outdoor recreation industry, providing products for a wide array of markets, including family and extreme camping, backyard recreation, hiking and tailgating. The project involved developing business views, reports, and templates and dashboards in Cognos 8.3

Responsibilities:

• Actively involved in discussions with business users to better understand business requirements
• Analyzed the business requirements and created a two tier model by defining cardinality between query subjects and prevented unambiguous relationships like loop joins and double counting.
• Troubleshooted the models and optimized for better performance.
• Created best practices document that helps user to create error free and effective reports.
• Developed reports that have dynamic column and page layers in report studio.
• Used cascading prompts, drill-through, summaries, and conditional formats to improve report structure.
• Created weekly email burst reports to deliver PDF formatted growth figures to Executives.
• Utilized the Cognos Copy Tool to transfer files between users’ folders.
• Created a FM model for different data marts, so that users can develop ad-hoc reports.
• Added prompts and filters to modify existing reports to accommodate change in user requirements.
• Improvised reports with the results from User Acceptance Testing.
• Created tasks and agents to notify users in Event Studio.
• Managed scheduling of the reports and set up security for individual entries.
• Developed drill through reports to provide attention to product related details and analyze the business data.
• Create authored drill through in Cognos Connection.
• Performed synchronization of Transformer model when the data sources changed.
• Assisted new users in familiarizing with Report Studio and its functionality. Provided knowledge transition and created documentation.
• Extensively used prompts, drill-through, mater-detail query relationships, summaries, conditional formats, grouping and sorting features of ReportNet to generate efficient and user-friendly reports
• Provided end user training and support for Cognos8 environment

Environment: Cognos 8.3 (Report Studio, Query Studio, Analysis Studio, Framework Manager), Cognos Connection, Transformer, Oracle 10g, MS SQL Server 2005, Windows Server 2003.

Polaris Software, India Java Developer

Polaris is a leading financial technology company that offers state-of-the-art solutions for Core Banking, Corporate Banking, Wealth & Asset Management and Insurance. As java developer, I developed XML file interchange for LOC for retail customers. The system generates the XML output file to be delivered to client. The system processes the input XML file and updates the data related to LOC.

Responsibilities:

• Requirement Analysis, Design, Implementation, Testing, Deployment, Support and Documentation.
• Designed and developed 3-tier architecture for the system requirements.
• UsedWSAD framework and deployed the application.
• Documented the System Test Plan for Import Financial System

Environment: J2EE, ATG Dynamo 5.6, WSAD, SQL Repositories, VSS, IntelliJ IDEA 4.5, SOAP, TOAD, Oracle 8i.