SUMMARY:

• Informatica Master Data Management (IDQ 10.0/MDM 10.1/PC 10.0) Business Intelligence(SSIS, Dataflux, SSRS
• Versatile information technology professional with over 16 years experience in leading teams, coding, testing, requirements gathering, championing new technologies.
• Most recent experience includes successful implementation of Informatica Data Quality 10.0, Master Data Management 10.1 and PowerCenter 10.0.
• Technical lead for Informatica/MDM administration and development tasks.
• Prior to Informatica, led a team of 5 programmers (4 off - shore and 1 on-prem) for SSIS/SQL projects.
• Possess a good understanding of SDLC and have proven record in solving complex business problems.
• Demonstrated ability to learn and teach new concepts, easily adapt to change and manage multiple concurrent tasks.

CORE COMPETENCIES INCLUDE:

Master Data Management(10.1) Informatica Data Quality(10.0) PowerCenter (10.0) Data Mapping Data Modeling Process Improvement Development Managing KPI metrics for MDM Quality Assurance Mentoring Problem Resolution Campioning BI tools

TECHNICAL SKILLS:

Data Management: MDM, IDQ, PC, SSIS, SSRS, Dataflux

Languages: SQL(stored procs, views, functions), COBOL, MS Access, SOAP

Operating Systems: Windows 7, Vista

Browsers: Mozilla, Firebox, Internet Explorer, Google Chrome

PROFESSIONAL EXPERIENCE:

Confidential

Senior MDM Engineer

Responsibilities:

• Implemented multiple SORs in MDM 10.2, configured match rules, hierarchies, cleanse functions, IDD subject areas
• Led performance tuning effort for match rules, custom jobs on large data volumes, cut down MDM match/merge run time from 2 hours to 15 mins.
• Tweaked several configurations to optimize job performance for e.g. reduce delays withby altering CTAS configuration, also configured automerge threads in cmxserver.properties file based on cores/CPU, increased match cycle volume etc.

Confidential, Spartanburg, SC

Technical Lead/Architect

Responsibilities:

• Routinely train developers on Informatica and MDM administrative duties (security, roles, access, code migration, debugging failed workflows/sessions using Administrator console, starting/stopping Informatica Services).
• Regularly help team with debugging IDQ mapping issues, handling MDM rejects (dup keys, orphaned records etc.).
• Lead experienced team of programmers for MDM/Informatica project work.
• Work with Project Managers on allocations, prioritization conflicts etc. for team.
• Prepared source to target mapping documents (CRM→ MDM → downstream systems).
• Created Data Model in MDM Hub and defined relationships between child and parent tables to enforce referential integrity
• Led effort to successfully implement Master Data Management 10.1 (MDM), Informatica Data Quality (IDQ 10.0) and PowerCenter. Fixed IDQ 10.0 mapping issues (Lookup Joins, Expression transformations Reject Records etc. and deployed to Production.
• Programmed product enhancements in IDQ using Java Transformations, Routers, Normalizer transformations etc.
• Routinely work with configuring MDM hub 10.1 (Schema/Mappings/Delta Detection/Batch jobs, Repository validation, Hub migration).
• Led implementation of workflows/sessions in PowerCenter 10.0 to extract data from MDM and feed downstream systems.
• Worked with Scheduling jobs in PowerCenter to successively run IDQ/MDM and PowerCenter jobs using watch files.
• Identified bugs relating to Informatica 10.0 (Synchronization functionality in IDQ, workflow scheduler for PowerCenter, Enable Distinct functionality in MDM) and continue to work with Informatica Global Support to rectify issues and deploy to Production.
• Helped Lumen Data Consultants and Data Architect to identify and correct issues with source (CRM) to MDM mappings to ensure data integrity while populating downstream systems.
• Dynamics CRM (.Net/DHTML) and AdminPortal (.Net framework) to understand data issues and inconsistencies and implemented data cleansing routines in IDQ (Address doctor, rejecting bad data like badly formatted phone numbers etc.).
• Then utilized delta loads, match/merge, trust, validation functionality in MDM to produce golden record in base tables and used PowerCenter to load data from MDM base tables to downstream SQL tables for consuming applications.
• Debugged issues relating to Delta Load detection, validating source feeds vs PRL feeds from staging, and then validating Staging feeds vs.
• X-Ref feeds in the Base layer.
• Work with Informatica Data Director to merge/unmerge records.
• Expert knowledge in job scheduling, monitoring using PowerCenter.
• Expert knowledge of Informatica and MDM Administrator tasks such as setting up user groups and linking Active Directory using LDAP configuration, granting user access.
• Also very experienced with debugging workflow failures using Informatica Administrator console.
• Led ‘Initiatives’ team: Led a team of 5 programmers for Initiatives effort.
• Tools utilized were SSIS(DataFlow, Script task etc.), SQL (stored proc’s, views, cte’s etc). Increased closure rate by 50% on a monthly basis (avg of 10 issues in 2015 vs. avg of 4-5 issues per month in 2014), which was appreciated by management at the executive level.

Confidential, Cleveland, OH

Business Intelligence Developer Lead

Responsibilities:

• Slashed audit time by 30% and improved quality by 50% by leading the effort to gather requirements, develop reports (SQL, SSIS and SSRS) and design functional test cases.
• Led effort to rollout data quality tool in Personal Lines space.
• Met with senior business and technology leaders to highlight speed to market and quality benefits resulting in uptake in customer retention (approx. 5 points).
• Had great success with promotion effort, evidenced by close to 100% utilization in Personal Lines group.
• Lead effort to continuously evolve data quality tool based on evolving business needs.
• Unit Test Plan has good user growth and improves quality by 20%.

Confidential, Cleveland, OH

IT Applications Programmer Senior

Responsibilities:

• Led effort to introduce Code Reviews in Rate Revision Space, set up weekly code walkthroughs, introduced outline for discussions and signoffs.
• Documented coding best practices.
• Introduced re-usability via modular programming in Rating space, eliminated 90% of manual efforts related to rollout work, which provided 60% efficiency gains in speed to market and 40% quality gains due to automation.
• Prepared training materials and mentored peers on using modules. automated test plans based on root cause analysis of test issues/system review, test plans improved quality by 50% and improved test coverage.
• Ensured that high priority project was delivered successfully on time with no production issues, worked with Business Sponsor to draft business requirements, thereafter worked relentlessly with developers and testers to communicate business requirements and review system design, code review/testing documents.
• Ensured that interim milestones were met within budget.