SUMMARY:

• An experienced data professional whose excels at earning and keeping customers trust by utilizing my extensive problem solving, communication, technical and leadership skills demonstrated below.

TECHNICAL SKILLS:

Integration/ETL: Informatica - PowerCenter, Data Quality, Metadata Manager, Web Services, Oracle DAC, SAS Dataflux, Hadoop, Informatica Cloud

Languages: SQL, PYTHON, HTML, XML, UNIX Shell Scripting, SAS, COBOL, JCL, UML

Database Management: PowerDesigner, Erwin Data Modeler, ER Studio Data Architect

Platforms, Databases and Connections: UNIX, RHEL, Oracle, MS Windows, DB2, ODBC, MVS, MS SQL Server, Sybase, Big Data, MS Azure, AWS

Principles and Methodologies: Kimball Data Warehouse, Zachman Framework, Inmon DW 2.0, MIT Big Data and Social Analytics (Certified)

WORK EXPERIENCE:

Confidential

Principal/Independent Consultant

Responsibilities:

• Identified and created partnerships that enabled a consistent revenue stream.
• Managed client engagements by consulting management on specific strategic data needs.
• Mastered art of influencing without authority while consulting key business partners, senior leadership and technology teams.
• Specializing in Corporate IT ETL Assessments - SDRI has a proven methodology to help executive level managers gather key insights to their current Data Integration practices including the following: Infrastructure/Licensing Health Check, Data Integration Center of Excellence, Data Security, and Product/Tool Usage Guidelines.
• Continuously Providing Data Management solutions around data for the cloud, big data, real-time and streaming.
• Help businesses to collect customer and market data in order to improve customer experiences and drive business growth.

Technical Management Consultant Informatica Infrastructure and Architecture

Responsibilities:

• Conducted a 10 week ETL assessment for large commercial insurance company. Artifacts produced recommendations to CIO and CDO surrounding defining Data Integration Center of Excellence, infrastructure, licensing recommendation to match their long term strategy.
• Acted as Informatica Architect for the entire IT organization. Defined and implemented hands on administration, architectural and development guidelines for the usage of the Informatica Tool Suite based upon artifacts produced.
• Defined data governance best practices including the beginning of a formal committee and business line engagement.
• Introduced and defined best practice for usage of Informatica Cloud and Meta Data Manager products as well as infrastructure architecture to optimize both on premise and cloud resources.

Senior Data Warehouse Architect/ ETL and Database Architecture

Responsibilities:

• Identified infrastructure needs for implementation of a new Data Warehouse environment in order to facilitate concurrent development during Accounts Receivable source system replacement by defining Server, Database and Software requirements based upon sizing and performance demands.
• Defined data integration/ETL strategy for newly defined data services based business intelligence platform. Including change data capture methodologies, real-time latency requirements and robust error/exception handling.
• Performed gap analysis between Business Rules and Data Rules. Making recommendations for a major redesign of current Data Model.
• Acted as Technical lead for major Accounts Receivable replacement project. Established reusable ETL design patterns within Data Warehouse team as well as reviewed other application development teams need to access a newly implemented zero latency ODS.
• Worked closely with vended application design team to verify requirements in order to establish all architectural decisions that related to the Enterprise Data Warehouse.
• Helped defined data strategy on an enterprise level by successfully collaborating with Enterprise Architects and individual technical leads within multiple departments.
• Maintained conceptual and logical data models as part of a data strategy aligned with the business unit’s 2018 corporate strategy.
• Lead selection process to add several new resources for the roles of Data Architect, ETL Lead and ETL Developers.
• Designed and developed all initial ETL Code thus allowing remainder of the Development team to follow standards set by the code implemented and formally establishing a reoccurring pattern for implementation including multiple reusable objects.
• Lead implementation of Informatica Meta Data Manager - including defining System Requirements, installation and configuration of products and working hands on with Data Governance committee to define and implement the automated workflow process.

BI Strategy Consultant

Responsibilities:

• Identified infrastructure needs for implementation of the new environment including the latest greatest Informatica Tool releases.
• Defined data integration/ETL strategy for newly defined data services based business intelligence platform. Including change data capture methodologies, real-time latency requirements and robust error/exception handling.
• Fostered strong relationships with data architecture, database administration and data consumers including designs for both OLTP and Data Warehouse/BI structures.
• Lead POC efforts for the following Informatica Products: PowerCenter Real-time web services, Release management and Metadata Manager. Documented results and demonstrated functionality to upper management.

Senior Informatica Lead Consultant

Responsibilities:

• Analyzed current ETL processes and Data Model, recommending and implementing enhancements to current code, standards and processes in order to reduce runtime and maintenance activities.
• Documented best practices for tool use strategy, repository backup/recovery, development standards, metadata management and code migration.
• Worked with Ecommerce team, successfully integrating several new data feeds between the front end web applications and the Enterprise Data Warehouse.
• Managed SOW with client manager, ensuring agreed upon work was completed to the clients satisfaction prior to rolling off.

Senior ETL Architect/Data Warehouse Architect

Responsibilities:

• Provided Informatica Expertise for Legacy Procurement to SAP middleware development. Recommending standards, best practices and mentoring junior developers.
• Developed several middleware interfaces for Legacy to SAP conversion.
• Provided emergency resource for the Corporate HR Hyperion project. Redesigning processes, developing Informatica objects and creating a test plan in a shortened time frame in order to successfully meet the projects timelines and quality assurance standards.
• Worked with Program Management and Solutions Architect to successfully review and gather requirements for Interface and Reporting solutions. Meeting organizational needs and goals for the implementation of the Maintenance Data Service application.
• Successfully documented adhoc reporting requirements for Production Support team. Providing cost benefit analysis to help determine scope and priority of project.
• Implemented use of Web Service Hub for a Data Service Product. Allowing the Web Service XML application to effectively communicate with the internal data warehouse applications.
• Managed offshore ETL team by assigning tasks, setting deadlines and performing quality control checks on work provided.
• Implemented Non Supported version of JD Edwards, creating customized data maps for all source feeds including Chinese and Japanese language sets during OBIA implementation.
• Translated business requirements and data model into detailed data warehouse ETL specifications for Informatica development team.
• Lead ETL Architect for several projects including a MS SQL Server to Oracle data conversion, a major maintenance release and implementation of a new reporting data mart.
• Managed group of offshore developers: Created timelines, performed code reviews and reported to senior management about effectiveness of off shore team.
• Performed conceptual, logic and physical design analysis to build ODS for conversion data prior to moving to SAP

Programmer Analyst/Data Conversion Specialist

Responsibilities:

• Designed and developed application code and user interface components for firm wide data conversion software.
• Managed several associates while Manager was on leave. Handling Performance reviews and pay increases on an interim basis.
• Created Informatica mappings that covered over 200 edit scenarios and the auto correction process to cleanse bad data using SAS and Informatica PowerCenter.
• Provided individual and group training regarding the data conversion process and the conversion models created by the enterprise conversion team.