Senior Data Architect
Resume:
Richard M. Karpel
Contact Information
***** ******* ***** ******** *****, Lake Worth FL 33449
*******.*.******@******.***
LinkedIn Profile: Richard (Rick) Karpel
Profile
Principal Information Systems professional with over twenty years of experience in Database Software Development and Systems Integration. Specialized in full life cycle design and development of n-tier database design with a strong understanding of corporate issues and concerns. Expertise in creating, designing, and implementing solutions for diverse environments ranging from microcomputers to mainframes to cloud architectures.
Security Clearance
Public Trust Position Level 5C: Investigation completed 6/2001 (Expired)
Secret: Investigation completed 10/1995 (Expired)
Professional Experience
Independent Consultant South Florida
Data/Data Warehouse/ETL/BI Architect
03/2002 - Present
Designed and developed conceptual, logical, and physical data models for various clients.
Created and maintained data dictionaries and metadata repositories.
Ensured data models complied with organizational data standards and best practices.
Collaborated with data architects, data engineers, and business analysts to understand data requirements and translate them into data models.
Conducted data analysis to support data modeling activities.
Implemented and enforced data governance policies to ensure data quality.
Optimized data models for performance and scalability.
Monitored and tuned database performance.
Documented data models, data flows, and data transformations.
Architected, designed, built, migrated, and stabilized Data Warehouse and Data Lake platforms.
Analyzed raw, structured, and unstructured data to optimize data sets and entities of interest.
Ensured alignment between engineering and analytical activities and shared information about datasets and their contents.
Developed and optimized queries for product insights, dashboards, and reporting.
Reviewed and troubleshooted reported issues and guided code deployment and tooling.
Collette Tours Pawtucket, RI
Senior ETL Developer/DBA
04/2023 - 12/2023
Developed SSIS pipelines to load data from various sources into SQL Server and Pivotal CRM.
Managed SQL Server performance, optimized queries, and administrated SSISDB.
Used Atlassian tools for ticketing and documentation, and migrated projects to Bitbucket.
MUFG Union Bank NA Raleigh, NC
Senior AWS Data Platform Engineer
10/2022 - 01/2023
Remediated vulnerabilities for business unit sale using Qualys reports.
Verified encryption for AWS and On-Prem servers and ensured secure data protocols.
Used Atlassian tools Jira, Confluence, and Service Now for ticketing and documentation.
BitBucket was used for SCM.
American Credit Acceptance Spartanburg, SC
Senior ETL/Data Engineer
05/2020 - 07/2022
Developed SQL-based solutions and assisted in migration to AWS Redshift.
Used AWS services like Glue, S3, Lambda, and managed CI/CD processes with CodeCommit.
Mentored developers in CI/CD pipeline processes.
Used Atlassian tools Jira, Confluence, and Service Now for ticketing and documentation.
The original SCM was BitBucket. Migrated from BitBucket to AWS Code Commit to automate the build, code and deploy process.
Lambda and Glue were coded using python v3.x and Boto3.
Magic Leap Plantation, FL
Senior SQL Engineer/DBA
10/2019 - 04/2020
Developed SQL solutions and managed multiple SQL Server instances.
Maintained vendor relationships, identified tools for data modeling and monitoring.
Developed models, solutions on AWS, GCP, and implemented graphDB Neo4j.
Lambda and Glue were coded with python v3.x and Boto3.
Ryder Miami, FL
Senior Developer
09/2018 - 10/2019
Developed and maintained solutions using Netezza, SQL Server, DB2, and Informatica.
Performed code and solution reviews and created Source-to-Target-Mappings.
Freddie Mac McLean, VA
Senior Developer
03/2016 - 03/2018
Developed solutions for Treasury Department’s compliance requirements using SQL Server and SSIS.
Designed new data dictionary, logical and physical models with ER/Studio for new sampling database.
Created new sampling system, managed Data Model, and provided development support.
Florida Power & Light Juno Beach, FL
ETL Developer
03/2015 - 12/2015
Developed ETL solutions using Informatica and supported data analysis and modeling.
Used ER/Win for managing the data model.
Momentum Consulting Corporation Miami Lakes, FL
BI Architect
10/2013 - 12/2014
Led multiple data integration and ETL projects for clients, improving data workflows and reporting accuracy.
Provided technical leadership and guidance on best practices for data management and integration.
Identified and created relationships with tool vendors like Embarcadero and ER/Studio/
Developed and implemented solutions using Informatica PowerCenter and other ETL tools.
JM Family
oWas the ETL Architect, Senior ETL Developer, and PL/SQL Developer for the Southeast Toyota Pathway Project.
oCreated High Level Design documents to document the ETL strategy for the project.
oCreated PL/SQL packages, stored procedures, functions and scripts to facilitate data extraction where use of the ETL tools were not warranted.
oWorked with Power Exchange Change Data Capture, laying out infrastructure requirements, configuring dbMover.cfg files for DB2, VSAM, Oracle, and SQL Server tables and files.
oParticipated as part of the team to create a fail-over strategy for Power Exchange, Oracle and SQL Server.
oUsed Web Services like the Rest API to extract data.
Ryder
oWorked with team from MCC to identify the tasks to support the VA/SAM replacement system.
oInterviewed and identified data migration/modernization vendors/partners. Identified In-Com Data Systems as the best of breed for the VA/SAM project.
ADT
oParticipated in the design and scope of the SM2K conversion project.
oDocumented meetings with clients and identified tasks and milestones for MCC participation.
oWorked with senior management in costing out the project.
Nationwide Investments Columbus, OH
Senior Informatica Developer
01/2013 - 09/2013
Developed ETL solutions using Informatica and Agile development methodologies.
Cigna Dental Sunrise, FL
Informatica Architect/Data Architect
03/2011 - 12/2012
Analyzed data models, reviewed ETL procedures, and developed solutions in SSIS and Informatica.
Updated and maintained the data model with ER/Win.
Confidential Client FL
Senior PostgreSQL Developer
11/2010 - 12/2010
Developed database solutions using PL/PGSQL for a startup.
Harris Corporation Palm Bay, FL
Senior Cognos Report Developer
10/2010 - 11/2010
Provided database and Cognos expertise for report migration and development.
Bayview Financial Coral Gables, FL
Data Architect/Engineer
11/2009 - 10/2010
Developed ETL jobs, T-SQL and PL/SQL batches, and BI reports for SQL Server and Oracle platforms.
Florida Department of Transportation Boca Raton, FL
Business Analyst
04/2007 - 09/2009
Developed ETL scripts, custom reports, and participated in the creation of a new reference architecture.
Hospice for the Palm Beaches West Palm Beach, FL
Sr. PL/SQL Developer
10/2006 - 03/2007
Supported the IT department’s Web Development group in maintaining and enhancing their web-based application system.
Developed and maintained the web-based application using Oracle Internet Application Server, Oracle Gateway Services, PL/SQL, the PL/SQL Web Toolkit, and Oracle Reports.
Became the main developer supporting the fiscal (accounting) departments remittance processing, patient accounts, adjustments and write-offs and provided technical support to the other developers.
Education
Westminster College; New Wilmington, PA 16172-0001; 1980 – 1983; Bachelor of Arts, Accounting
University of Maryland, Baltimore County; 1000 Hilltop Circle; Baltimore, Maryland 21250; 1983 – 1984; Bachelor of Science, Information Systems Management
Certifications
Microsoft Certified Systems Engineer, 1998
Microsoft Certified Professional, 1993
Certified NetWare Engineer, 1992
Oracle OCP Candidate: Passed SQL and PL/SQL exam, 2001
AWS Certified Solutions Architect (in progress)
AWS Certified Big Data – Specialty (in progress)
Skills
Cloud Platform: AWS
AWS Services: Experience with AWS data warehousing services including Redshift, S3, and RDS.
Data Warehousing: Expertise in developing and maintaining SQL Server, Oracle, DB2, and Redshift data warehousing solutions.
ETL Processes: Extensive experience creating and managing ETL pipelines using tools like Informatica PowerCenter, SSIS, and AWS Glue.
Programming Languages: Proficient in Python, PL/SQL, T-SQL, and VBScript.
Database Management: Strong background with SQL Server, Oracle, SQL Data Warehouse and Netezza.
Reporting Tools: Proficient in Cognos 8 BI Suite, Crystal Reports, SQL Server Reporting Services (SSRS), and Framework Manager.
Data Modeling and Development: Experienced in using tools like Embarcadero ER/Studio, ER/Win, Toad for Oracle, Rapid SQL Pro, Visio.
SQL Proficiency: Advanced skills in SQL for data querying, optimization, and manipulation.
Requirement Gathering: Proven experience in gathering and analyzing requirements for data integration projects.
Enterprise Systems: Experience with enterprise systems such as Workday, Jira, Kanban, or Service Now.
Project Management: Skilled in using Microsoft Project for project planning and management.
Communication Skills: Excellent verbal and written communication
Source Control Management: Experienced in using tools like BitBucket, Code Commit, Git, SVN, and older source code tools.
Documentation: Source-to-Target-Mapping, Data Models, Entity-Relationship Diagrams, Data Dictionary, Governance, Data Stewardship, Specifications, and User Requirements.
Contact this candidate