SUMMARY

• 8.5+ Years of IT experience with 6+ years of Manufacturing and Logistics BI & ETL Developer (IT) experience in all phases of project execution.
• Hands on experience in Requirement Management, Design, Development, Implementation and Project Management.
• 1.5+ years of experience in IBM InfoSphere MDM in development, planning and execution, unit and integration testing.
• 1.5 years of experiencing in configuring maintenance, testing and troubleshooting on Informatica Master Data Management.
• Expertise in Installing, Managing and configuring Informatica MDM Hub Server, Informatica MDM Hub Cleanse Server, Cleanse Adapters (Address Doctor), Hub Resource Kit.
• Experience in creating Base objects, Staging tables, foreign key relationships, queries, packages, query groups and custom functions in Informatica MDM.
• Expertise in Informatica Power Centre 9.1.0/8.6.1 using components like Source Analyzer, Warehouse Designer, Transformation Developer,, Mapping Designer, Workflow Manager and Workflow Monitor
• Strong knowledge and rich experience in BI tools Actuate, SSRS, Hyperion IR and SQR.
• Strong knowledge in PL/SQL and Informatica Power Centre 9.x/8.x tool.
• Rich experience in Redwood 6.0 scheduling tool
• Excellent knowledge of data warehousing and business intelligence concepts, design principles
• Lead BI teams onsite and Offshore in delivering BI Solutions
• Implemented Actuate 9 to Hyperion 9.3 and SSRS 2005 migration project
• Involved in POC in conversion of Actuate report to BI Publisher
• Skilled in developing complex and structured queries
• Involved in Actuate Expert Group for doing new Proof of Concepts.
• Involved in Data Modeling using Erwin and Data Modeler tool

TECHNICAL SKILLS

EIM Tool: IBM Infosphere MDM v9/v11, Informatica Multidomain MDM 9.1/9.5, Informatica Power Center 9.1.0/8.6.1 BI Tools Actuate 9, Hyperion IR and SQR 9.3.3, SQL Server Reporting 2005

Scheduling Tools: Redwood 6.0

Database: ORACLE 11g/10g/9i//8i, SQL Server 2005

DB Tools: TOAD, SQL Navigator, SQL Developer.

Data Modeling: ERWIN 4.0, SQL Developer Data Modeler 2.0

Languages: C, C++, SQL, PL/SQL, Visual Basic 6.0, UNIX Shell Scripting

Operating Systems: MS Window (XP), Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

IBM MDM Developer

Responsibilities:

• Installation of IBM MDM workspace v9/v11 and WAS 8.5
• Develop, build and test Custom Code based on the client requirements
• Involved in development of Business Proxies
• Extended OOB MDM implementation with Data additions and Data extensions based on client’s requirements
• Involved in development of Response Handler Framework
• Involved in Suspect Duplicate Processing (SDP) match rules
• Involved in Production Support related incidents
• Unit testing and integration testing in DEV, QA and PStage environment
• Migration of code to various environment from local machine
• Developed complex SQL queries required for data cleansing and utility jobs
• Responsible for all the issues and concerns related to MDM reference data
• Involved in Sprint and PSI planning

Environment: IBM RAD 8.5.1, Websphere Application Server 8.5, IBM RTC 4.0.1, Oracle 11g, SQL Developer 4.0.0.13, SoapUI Pro 4.6.2.

Confidential, Indianapolis, IN

Informatica MDM Consultant

Responsibilities:

• Designed, documented and configured Informatica MDM Hub to load, cleanse, match, merge, and publish the MDM data
• Presented hub solutions for a Multi - Domain Party model MDM for customers and reps and products.
• Configured Landing Tables, Staging Tables and Base objects
• Developed the mappings and used the necessary cleanse functions by analyzing the data using the Data Quality Tool
• Developed complex hierarchies in the Hub by configuring the entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages
• Configured IDD for Customer and Product centric Hub schemas
• Defined Trust and Validation rules and Configured Match set Rules for getting the matches in order to eliminate the duplicate records
• Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.

Environment: Informatica Multi Domain MDM 9.5,9.1, Informatica Power Center9.1, JBOSS, Oracle 10g/11g, SQL Developer, Address Doctor5, Toad, Erwin

Confidential, Frazer, PA

Informatica MDM Specialist

Responsibilities:

• Installed & Configured Multi-server MDM Hub on a weblogic cluster on Dev, Test and Prod Servers
• Developed comprehensive models for managing and communicating the relationships between Performed the ETL process for loading the data into MRM hub.
• Worked with Informatica Support in troubleshooting MDM Hub and IDD issues
• Define Trust and Validation rules and used STR tables to re-run the trust and Validation rules
• Helped Business Leads in understanding Match & Merge and incorporated their requirements and ideas
• Worked with users in defining Match Rules and conducted workshops to discuss over and under matching
• Reviewed IQ and Run book as part of configuration
• Worked with middleware team and DBAs to resolve issues as an MDM single point of contact
• Conducted high level brainstorming sessions with Address Doctor and IPS teams for effective usage of Infa MDM
• Developed and Defined queries which can be used for over and under Matching
• Analyzed the data by running the queries and provided the stats after Initial data and Incremental Loads
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Defined Roles and privileges for each environments according to the platform requirements
• Defined the security such that schema will be secured with access only granted for specific downstream integration uses, using users created for those specific integrations
• Scheduled MDM Batch jobs through Active Batch scheduling tool

Environment: Informatica Multi Domain MDM 9.1, IDD, SIF, Weblogic 10, OBIEE, Oracle 11g, SOAPUI, SQL Developer, Address Doctor 5, Toad, SQL*Loader, Active Batch, Windows server 2003, Erwin

Confidential

Data Quality/ Informatica Developer

Responsibilities:

• To support and resolve all ETL Informatica related tickets for this application.
• To play role of onsite coordinator for all Informatica related development activities.
• Meeting with clients and understand the Requirements related to Informatica mapping development.
• To identify issues in data as a part of Data Quality by executing different Business Rules.
• To under different business scenario and convert them to Business Rule as a preventive check for the data.
• To analyze and provide a root cause to the business in case of any data related issues.

Environment: Informatica PowerCenter 9.1, Oracle 11g, Windows XP professional, SQL Developer, Redwood

Confidential

Informatica Developer

Responsibilities:

• To analyze and gather the requirements of different data sources.
• To develop the data model to hold all the required tables.
• Designed and developed ETL process using Informatica tool to load data from wide range of sources such as Oracle, Flat files.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them using Informatica Scheduler to run at specified time with required frequency.
• Used various Transformations like Lookup, Filter, Joiner, Expression, Router, Sequence generator in the mappings.
• Involved in unit testing of the data with the clients.

Environment: Informatica PowerCenter 9.1, Oracle 11g, Windows 7,TOAD

Confidential

Informatica Developer

Responsibilities:

• To analyze and gather the requirements of different data sources.
• To develop the data model to hold all the required tables.
• To create the packages and procedures in PL/SQL needed to populate the tables
• To build a summarize table holding the final data
• Involved in unit testing of the data with the clients.

Environment: Informatica PowerCenter 9.1, Oracle 11g, Windows 7,TOAD

Confidential 

Hyperion/SQR Developer

Responsibilities:

• Actively communicate with customers to gather complete business requirements.
• Worked as a data modeling and data analyst which includes designing of DB schema
• Worked on the POC to implement the detailed level Hyperion report and Data loading
• Involved in developing UNIX scripts for Redwood to control the flow of files and scheduling ETL jobs

Environment: Windows XP professional, Oracle 11i/10g, Hyperion 9.3.3, SQR, SQL Developer, Redwood

Confidential 

Hyperion/SQR Developer

Responsibilities:

• Complete analysis of Actuate report and preparing requirement document after understanding business requirement
• Proactively communicate with customers to analyze information needs and functional requirements.
• Work closely with development team to review technical specifications to ensure developers have a complete understanding of business requirements.
• Analyze the structural changes and update Hyperion metadata catalog. Coordinate the reporting changes with offshore team.

Environment: Windows XP professional, Oracle 11i/10g, Hyperion 9.3.3, SQR, SQL Developer, Redwood, Actuate 9

Confidential

Responsibilities:

• Promptly analyzing the existing Hyperion reports and understanding and solving the issue
• Understanding the completed data model and business need of the report
• Delivery lead for the Hyperion enhancements on IR and SQR
• SLA lead for all the production support tickets related to Hyperion and Redwood
• Reviewing the deliverables before handing it to business
• Communication with customers in order to understand their need
• Monitoring and recovering in case of failure jobs scheduled in Redwood
• Developing UNIX script to control the JAVA batch processing through Redwood.
• Involved in exchange of Keys (File Encryption and Decryption Key) with external vendors

Environment: Windows XP professional, Oracle 11i/10g, Hyperion 9.3.3, SQR, SQL Developer, Redwood, Actuate 9

Confidential

Responsibilities:

• Understanding the complete business requirement and need of the report
• Developing the complex SQL needed for the SQR
• Developing IR dashboard within built controls.
• Communicating with Onsite counterpart for better understanding the requirements.

Environment: Windows XP professional, Oracle 11i/10g, Hyperion 9.3.3, SQR, SQL Developer, Redwood, Actuate 9

Confidential

Actuate Developer

Responsibilities:

• Involved in design and development of Reports using SQL Server Reporting Services.
• Complete analysis of Actuate report and its functionality.
• Involved in writing test cases, reviewing and testing of reports
• Involved in resolving technical issues faced during development

Environment: Windows XP, Oracle 9i/10g, Actuate 9, SSRS, TOAD, SQL Server 2000