• Partnered with business analysts, data architects, and DBAs to build and maintain ETL framework using Informatica technology.• Collaborated with project managers, developers, testing, and DevOps engineers to deliver robust solutions to satisfy clients’ functionality, scalability, and performance requirements. • Continuously reviewed ETL process to enact proactive changes for maintenance efficiency. Routinely developed mappings, mapplets, and workflows. • Worked with our offshore technical center to monitor and support ETL and address quality applications 24/7. Automated error detection and job scheduling tasks ensured reliable performance.• Planned and executed our lift and shift strategy to move to AWS Private Cloud. Built and deployed more than 30 systems to AWS without impacting business operations.• Replaced a third-party data quality software with a new integration written in Python and utilizing Docker containers. Reduced the existing rules set by more than 40% by reviewing all rules with the business owners. • Worked closely with DBA team to plan, verify, and migrate 20+ application databases to RDS efficiently with zero downtime to production services.• Administered Informatica PowerCenter major version upgrades, as well as several minor version upgrades. Uncovered multiple bugs resulting in Emergency Bug Fixes from the vendor. Utilized Chef and Jenkins to manage run books, recipes, and environments.• Identified and managed client-specific deduplication and matching rules for materials in SAP MDM. Worked directly with outside clients regularly to enable streamlined global fulfillment.

• Using Trillium Discovery and SQL, profiled more than 5,000 data attributes across nine source systems as part of an ERP implementation. Worked with business and IT owners to identify more than 800 business rules for data quality and harmonization.• Created more than 30 Trillium Quality projects for ERP data cleansing, all fully integrated within Informatica process flows. Trillium touches all transactional data feeds for our ERP system.• Developed a real-time Trillium Director address cleansing web service, deployed across 3 data centers. This solution services global e-commerce systems and includes address cleansing for US, Canada, EU, & Korea (double-byte). Additionally, built a custom Brazil address lookup solution to satisfy Brazil tax reporting requirements, enabling the company to expand its commerce operations in Brazil by 10 times. • Provide daily production support for all Trillium production functions, both batch and real-time.• Work with several business units (Accounting, Reporting, and Marketing) to create ad hoc Trillium projects. These projects address specific business needs such as data profiling, address quality, and data matching.

• Team Lead of the Data Management group. Primary focus of the group is the accurate extraction, analysis, and manipulation of data within all production data environments.• Perform data management, reporting, and testing primarily within several relational databases, primarily Oracle 10g.• Analyze and refine data extraction – How data is gathered, optimize and verify queries, confirming the correct data is selected with a high degree of accuracy. This requires numerous high priority ad hoc queries and development of stored procedures.• Work directly with several business departments responding to how data records look and why.• 2006 Reach for Excellence Award winner (employee of the year program)