SUMMARY:

• A Data Engineer, Solution Architect, Designer and Developer of data management projects with a mission to turn mountains of data into actionable, tactical business decisions.
• I am a hands - on designer and developer of challenging "data centric" applications.
• My focus includes mentoring team members while designing and creating an automated global claims scoring and processing system spanning 61 Countries; designing and building relational and hybrid data warehouses; populating “mastered data” to an ODS or Data Lake; transforming data into a new CRM; standardizing, merging and matching “person”, “address” and related data across large financial datasets for the Confidential ; migrating data from relational to hybrid big data platforms or in the Cloud to facilitate advanced analytics and machine learning tool access - I thrive on creating innovative data solutions for my company and clients.
• My efforts are guided by the principle that our work together needs to be highly focused, driven by the highest standards of personal and professional integrity, respect for each other and for our commitments to our project, company and self.
• I am a creative, precision minded designer and builder of data centric applications.
• Working in research and development mid-career, I have learned the exceptional results we achieve when we work together with a singular focus, with respect for each other and our shared goals.
• Informatica and AWS are my primary focus for all things data - using today’s Informatica Big Data Platform, using Informatica Big Data, PowerCenter, PowerExchange and Developer to perform data migrations, using Data Quality to profile and to standardize data for maximum payback in today’s analytics and machine learning applications.
• I have spent many years working with flat file, mainframe and relational data, and have been working with Big Data table and file types over the past 4 years, including a focus with AWS.
• My project designs have spanned Microsoft SQL Server to Oracle and Netezza, as well as Teradata, DB2, Hive, HBase, Redshift and other Big Data sources and targets.
• My work has included some minor work with Python and Spark scripting technologies but not as my career focus.
• To deliver and present data to our end users, I have spent many years creating reporting and analysis application using IBM Cognos.
• Its range of tools, from data reporting to very fine geolocation maps to highly complex charts help us communicate many details on a single page for the end user. I have also used MicroStrategy, Tableau and BusinessObjects, a well as other tools such as Tableau for painting data in a way that makes it easily read and understood by our target audiences.
• My data architecture experience originates in designing high performance OLTP and OLAP designs using the methods of Inmon, Kimball, Adamson to create dimensional, relational, and hybrid solutions.
• I have focused my spare time during the past two years on learning the AWS Cloud Platform and seen the cost savings we can achieve by the many new technologies offered today in the Cloud.
• My goal is to work with other creative, dynamic team members to produce data centric business solutions to help drive decisions in today’s fast changing business and technology landscape. Creating tomorrow through innovation, teamwork and technology.

EXPERIENCE PORTFOLIO:

Confidential

Responsibilities:

• Working as a Sr Data Quality and ETL Engineer leading initiatives to create multiple data quality projects for a large healthcare organization to uncover and discover patterns and relationships in critical business data.
• Projects include producing a reusable data quality framework and then implement it across multiple data discovery projects in the areas of data assessment and data lake discovery. Windows platforms.
• Projects involve training staff in data governance and data quality, and driving well defined “quick win” projects to prove the usefulness of Data Governance at the organization, such as:
• Data Lake Architecture planning and entity merge design - Healthcare
• Application Upgrades - ETL and Data Quality Upgrade from 9.6.1 to 10.2.

Confidential

Responsibilities:

• Data-driven, results-oriented, data integration expert with 25+ years of successfully building data systems using best practices and standards to drive the rapid deployment of data integration, data warehousing, data quality and bigdata tactical solutions to meet today’s challenging analytics and business intelligence information needs.
• Experience includes development, design, deployment as well as systems maintenance and installation, upgrading of databases and systems.
• Work includes increasing focus on AWS, Python and Spark technologies to expand my Oracle, MS SQL Server, Teradata work to S3, RedShift and DynamoDB.
• Using my 19 years of experience as a hands-on team lead working with Informatica and other ETL products, including PowerCenter, Developer, Infa BigData, Data Quality, and Master Data Management.
• I am trained on MDM hub technology, and have used one of the MDM Hub Designs (Identity Resolution) in a project spanning five years.

Confidential

Responsibilities:

• Lead initiative to form Supplier Master at a worldwide retail distributor.
• Performed project remediation as I joined the project, and then established a clear MDM Framework (process and methodology), and then performed data mastering of supply chain to establish the start for this data governance program. Windows. Oracle DB.
• Provided data transformation design and development to prepare analytics datastores by moving them onto client’s Big Data platform using Talend for Big Data.
• Developed individual SQL scripts and Talend jobs to be used in complex table transformations performed across Relational and Hive Hybrid platforms.
• Work also included minor transformation work with basic Python and deployment with simple Spark scripts. Oracle, AWS, Talend, Unix.
• Provided data quality assessment and SAS scripts reengineering work to convert processes to MS SQL schemas and codebase.
• Worked on a team to migrate the existing data store used for reporting into a more formalized data warehouse with industry standard schema design. Linux.
• Lead multiple data quality initiatives for a regional Healthcare and Medicare Provider
• Established a baseline of Data Quality Metrics to provide inter - project collaboration for multiple teams working concurrently across Finance, Pharmacy, Disease Management, Population Health Management data domains.
• Surveyed all corporate systems for potential Data Governance Business Rules and produced a template of standardized expressions in a common data language.
• Created an expansive Asset Inventory for IT spanning 10+ major data and system classifications and 60+ subgroups of 60,000+ items to form a reference database for ongoing and future I.T. Application and Data Governance planning.
• Developed and maintained project dashboards and weekly reporting.
• MS SQL Server

Solution Architect, Designer, Developer, Reporting, Big Data Engineer

Confidential

Responsibilities:

• Due to nature of our onshore/offshore model, my roles included everything from user interviews, architecture, design, development of all initial code, and training of offshore developers, as well as final quality assurance, testing and product launch.
• Lead nightly Mentoring Sessions for offshore team members to enable the knowledge and skills needed for our current projects.
• Developed methods and standards for expanding Data Integration onto the IBM BigInsights Big Data platform using Informatica data integration, data quality and data profiling projects. Included alternatives/workarounds for current versions of HDFS, HIVE and other technologies in the big data environment.
• Provided upgrade guidance and testing also from v95 to v9.6.1 for our client.
• Also provided Project Management and Data Quality guidance to another project team in which I helped design the master data, data governance, and data quality application around which the program was then built and constructed.

Staff Data Architect for Reporting

Confidential

Responsibilities:

• Supplemented multi-platform DW and BI skills and manpower to existing teams as a 3rd data architect to handle application workloads on existing project work.
• Short term assignment while in transition from East Coast to home back in Colorado. Unix, Oracle, DB2.

Data Quality Designer, Developer

Confidential

Responsibilities:

• Performed Informatica PowerCenter, Informatica Data Quality and PL/SQL development with this Denver based consulting company for a first phase of a hospitality application.
• Short term assignment while in transition from East Coast to home back in Colorado. Linux, Informatica, Oracle.

Solution Architect - Data Warehousing and Reporting

Confidential

Responsibilities:

• I was a solution architect working on multiple, very large OLTP and OLAP projects - designing, building and leading multiple data transformation, reporting and analysis, data integration, data quality, data profiling, data governance, geocoding, identity resolution and consulting tasks to multiple end clients using best practices, products and methodologies of industry leading toolsets and databases.
• Many different and diverse assignments including FINCEN tasks.
• Lead efforts to help our team evaluate and acquire new technologies as assigned.
• Lead multiple data warehousing, reporting and other projects as assigned.

Solution Architect and ETL Developer (Teradata)

Confidential

Responsibilities:

• Architected, developed and trained client on state-of-the-art profiling and data quality solution.
• Began by troubleshooting and solving complex coding issues involving real-time Informatica Data Quality in a large real-time computing environment.
• Invited to perform short term triage by Teradata Professional Services, and then asked to stay on through several contract extensions to implement corrections and new data quality handling solutions, tightly integrated with customized package code
• Environment was PowerCenter real-time implementation of PowerExchange, PowerCenter, Data Quality and Profiling and Teradata to drive customer recognition and new marketing initiatives. Streaming data was cleansed and standardized as it was received from the host system. Windows Server, Windows, Teradata, Informatica.

Solution Architect and Data Quality Developer

Confidential

Responsibilities:

• Designed and managed a short-term 30-day project to design, develop and implement a Data Quality business application to better identify duplicate personnel, client, prospect and provider information. Implemented solution on-time, on-budget. Second contract for VIP. Oracle.

Data and Data Quality Architect Designer Developer

Confidential

Responsibilities:

• Helped implement data governance and quality initiatives for international SAP manufacturing client.
• Platform Unix/Linux.
• Developed and delivered training on Informatica team-based development, Informatica PowerCenter GRID, and Informatica Metadata Manager, as well as Informatica Data Explorer (data profiling) and Informatica Data Quality. Platform Unix/Linux.

Data Engineer / Data Warehousing

Confidential

Responsibilities:

• With this system, the client was enabled to automate the intake of over 300 digital sources of data from all over the world. Platform Windows.
• Roles including designing project plan, designing technical solution and developing and implementing XML to relational data model in Microsoft SQL Server. Automated ETL was developed by the team using Microsoft SSIS.
• Developed Informatica PowerCenter upgrade guidelines and then guided and supported a team of ten Informatica developers upgrading over 167 separate financial ETL systems from PowerCenter v7.1.2 to PowerCenter 8.1.1. Platform Linux.
• Used Metadata Manager and SharePoint to automate project completion reporting.
• Exeros Discovery Studio Proof-Of-Concept for an international financial services firm in White Plains NY, 12/2007. IBM AIX/UNIX.
• Helped show methods to quickly identify data file and field content and quality.

Contractor / Data Warehouse Solution Architect

Confidential

Responsibilities:

• Helped a team designing financial credit scoring data warehouse application.
• Solution was implemented very quickly using Sybase PowerDesigner 12 and Oracle. Mixed OS.

Data Warehouse Quality Assurance Consultant

Confidential

Responsibilities:

• Ensured a complete, quality data warehouse solution be delivered by the Prime Contractor for the Confidential on this initial Financial, Payroll and Human Resources Data Warehouse implementation for the Finance Division.
• Broadened scope of work to include a role dedicated to quality assurance improved my skills as a project manager and data warehouse architect. Identified and alerted client of several pending design issues and suggest potential changes, thereby saving all parties time and money.
• My focus was in the hands-on design of projects to help jumpstart Data Governance and Data Quality projects through data profiling and data quality initiatives.
• Initial clients included Major League Baseball Advanced Media, Affymetrix, and other leading firms; before rollout I also developed internal Change Data Capture (CDC) training for Professional Services staff. Multiple platforms - IBM AIX/UNIX., Linux, Windows.