SUMMARY:

• Software Engineer with over 6 years of successful professional experience in development areas of Information Technology.
• Her value add is her strong grasp of technology, business needs and implementation experience using Informatica ETL, Informatica MDM and IDQ
• She is knowledgeable about several Data Management disciplines like Data Architecture, MDM, Data Governance, Data Quality and Data Modeling, Data warehousing and Business Intelligence.
• Extensive experience in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center 9.x/8.x/7.x/6.x in Windows and UNIX environment.
• Developed complex mappings using Informatica Power Center Transformations - Lookup Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Extensively used Mapping Variables, Mapping Parameters, and Dynamic Parameter Files for improved performance and increased flexibility and also worked with XML Sources & Targets.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• She can provide MDM and Data Quality implementation expertise in support of business operations. She has driven MDM solution design, development, business rules, and master data migration processes.
• Knowledgeable about Operational, Analytical MDM solutions and Registry, Repository and Hybrid MDM Approaches
• She is a quick learner and an adaptive individual with good communication, analytical and inter-personal skills who can resolve problems in a professional manner, create consensus and deliver results

COMPUTER SKILLS:

Oracle: SQL, PL/SQL

Languages: C, Java

Operating Systems: Unix, Windows

Database: Oracle, SQL Server, MS Access

Servers: JBoss, WebLogic, WebSphere

Tools: Visio, Erwin, Informatica MDM, Data Quality - IDQ, Power Center, Address Doctor,

ETL Tools: Informatica 7.1/ 8.5.1/9.6.1

Methodologies: RUP, SDLC, DAMA

PROFESSIONAL EXPERIENCE:

Confidential, California

ETL/ MDM Developer

Responsibilities:

• Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, Informatica development, and administration and mentoring other team members.
• Developed mapping parameters and variables to support SQL override.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Informatica Designer.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, Workflow Manager, Workflow Monitor.
• Worked on Slowly Changing Dimensions - Type 1, Type 2 and Type 3 in different mappings as per the requirements.
• Good exposure in Informatica MDM where data Cleansing, De-duping and Address correction were performed
• Using various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developing as well as modifying existing mappings for enhancements of new business requirements mappings to load into staging tables and then to target tables in EDW. Also created mapplets to use them in different mappings.
• Working on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets and scheduling of the workflow.
• Involved in Performance tuning at source, target, mappings, sessions and system levels. Exhaustive testing of developed components.
• Worked on the various enhancements activities, involved in process improvement.

Environment: Informatica 9.1(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Informatica 8x, Oracle 10G, UNIX, PL/SQL Developer, UNIX AIX 5.1.

Confidential, Chicago, IL

Sr. Consultant

Responsibilities:

• Responsible for Analysis, Design, Installation, Development, Deployment of master data solution of a key data domains
• Participated in the requirements gathering sessions along with business and technical stake holders
• Responsible for MDM Hub development including Data Profiling, Data modeling & Data Mappings (Landing, staging and Base Objects), data validation, match and merge rules, queries and packages
• Configured entity objects, entity types, hierarchies, relationship base objects, relationship types, and profiles in the Hierarchy Manager.
• Configured Informatica Data Director (IDD) subject area groups, child subject areas, workflows, validation and deployment, among other tasks
• Used Informatica Data Quality (IDQ) profiler and developer tool to analyze source system data and discover underlying issues
• Configured address doctor tool to be used as part of the MDM solution for validating customer and vendor addresses
• Worked with Java developers in setting up SIF for real-time integration with MDM Hub
• Worked with ETL developers in integrating MDM Hub with source and target systems
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Assisted in testing of the MDM solution including unit, integration, regression testing
• Migrated the MDM code using repository manager to different environments, administered MDM and IDD users

Environment: Informatica 9.1(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Oracle 10G, UNIX, PL/SQL Developer, UNIX AIX 5.1, Informatica Data Director, Informatica Data Quality

Confidential, Princeton, NJ

MDM Consultant

Responsibilities:

• Involved in the design and assistance in the enhancement of existing MDM implementation to support Sunshine Act regarding physician spend analysis
• Provided assistance in requirements gathering for domains such as physician, customer, address among other covering interface design, data stewardship processes, data services, data standardization and workflows
• Involved in Informatica MDM design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Developed customer cleanse functions, cleanse lists and mappings for MDM Hub
• Analyzed IDD user interface requirements and recommended enhancements
• Assisted in testing, code migration and application bug fixes

Environment: Informatica MDM hub( Mappings, Cleanse Lists), Informatica Data Director, Oracle 10G, UNIX, PL/SQL Developer.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehouse efforts.
• Investigated source systems to locate and understand existing subject areas across the enterprise
• Developed ETL mappings, transformations using Informatica Power Center
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Created ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Developed Informatica Mappings and Workflows for Data Integration.
• Organized the Workflows and Sessions for the Initial and Incremental Data load runs.
• Prepared the Schedules for the Initial Load runs and Incremental Load runs.
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
• Assisted in the developing for processes flows for data stewardship with focus on consolidating common data domains like customer, vendor, product & financial data across company divisions
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Helped in documenting in data standards for customers, products, vendors and other subject areas by studying the current state business processes and analyzing data

Environment: Informatica 9.1(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Informatica 8x, Oracle 10G, UNIX, PL/SQL Developer, DB2.

Confidential

Software Developer

Responsibilities:

• Wrote the computer programs used for everything from the systems that allow computers to run properly to the latest software applications for mobile devices.
• Analyzed the needs of clients and then designing a system to meet those needs. Also recommend software upgrades to existing systems.
• Detailed work comes in the form of designing the step-by-step flowcharts for computing systems that show how program code must be written in order for it to work properly.
• Documented all of their tasks to ensure that subsequent users can diagnose and fix any problems that might arise in a system, as well perform any maintenance
• Reviewing current systems
• Presenting ideas for system improvements,
• Working closely with analysts, designers and staff
• Producing detailed specifications and writing the program codes
• Testing the product in controlled, real situations before going live
• Maintaining the systems once they are up and running.