Christopher Karpowicz Email & Phone Number

Charlotte, NC, US

San Francisco, California, US

Detroit, MI, US

• Lead analyst for migration of legacy Deposits data from on-prem hadoop databases to Snowflake on AWS
• Documented existing critical processes and reporting to ensure consistency across old and new platforms
• Helped set prioritization of data movement based tech team data availability and Use Case importance
• Piloted use of Alation for Metadata management for new Snowflake data elements, highlighting critical elements for each LOB process and reporting
• Determined Data Quality rules for critical data elements highlighting accuracy, completeness, reliability, relevance, and timeliness for Collibra
• . Coached Analytics Org on finer points of Agile (Scrum vs. Kanban) and revamped JIRA boards to improve interactions between stakeholders

Detroit, MI, US

• . Lead analyst for Deposits Product Application and Onboarding modernization effort to incorporate new 3rd party data sources for KYC and Fraud detection.
• . This required running existing and proposed system in Parallel for 6 months to ensure the Pended Applications went down 50 percent, automatically approved and denied applications went up by 20 percent with overall.
• Created manual AWS S3 file transfer process between Ally and 3rd Party company to expedite data hand offs and validation
• Created all new logic and Power BI dashboarding to ensure new system had 100pct availability and metrics stayed witin acceptable ranges- quickly identifying any potential Fraud rings.
• . Piloted and Rolled out Organization wide use of Confluence for Knowledge Sharing and Collaboration, focusing on best practices
• . Automated legacy processes in Cloudera Data Science Workbench using Python

Mclean, VA, US

• 8 week bootcamp with Revature learning how to program Java, Spring, SQL, AWS, Python, Angular JS, Chef, Jenkins, Go-lang.
• Created expense reimbursement system using Java, SQL, HTML, CSS
• Created a classifieds website for Capital One using Java, Spring MVC, Angular 1.5, AWS
• 1 week ISRM training learning ins and outs of using open source software legally at Capital One

Mclean, VA, US

• . Leveraged analytic and technical skills to innovate, build, and maintain well-managed data modeling solutions and capabilities to tackle business problems.
• Automated a Data Migration pipeline, using Python, moving from a cloud Salesforce database to an internal data warehouse increasing analytical ability.
• Collaborated with internal SharePoint team designing a form workflow that automates notifications for tasks surrounding a key annual audit by an external agency.
• Created a Unix process that checks for all daily data loads to be finished ensuring reporting would be 100% accurate and complete.

Mclean, VA, US

• . Using Information Technology best practices, translated business needs to design and develop tools, techniques, metrics, and dashboards for insights and data visualization. As a team member or working independently.
• Redesigned a manual process that monitors the response rate of every solicitation and validates the next month’s assumptions against historical data. The new process adds transparency and insight into a previously.
• Performed segmentations identifying customer accounts impacted by process break-downs and calculated refunds amounts making the customers whole.
• Pioneered the adoption of Agile work methodology in US Card changing the way work happens, increasing speed to market with added transparency.
• Led a team of contractors building out Controls identifying process breakdowns for a newly acquired
• HSBC portfolio of card accounts.

Mclean, VA, US

• . Designed SQL queries and data integration ETL for multiple database formats while documenting Metadata. Created robust data quality standards and checks for new databases.
• Performed customer behavior analysis on www.CapitalOne.com website identifying where customers had issues and then called Capital One with questions; analysis aided in a 10% reduction in phone calls and resulted in a.
• Fine-tuned an outbound dialer script that called approximately 3 thousand people a day with delinquent accounts, resulting in a claw-back increase of 5%.
• Partnered on the rollout of a new Online Payment system for Charged-Off customers and created the controls and monitoring ensuring the system requirements were met. This payment method which was previously unavailable.
• Investigated data issues as a member of the Production Support team for new Online Payment system.

• Generated and maintained all system components vital to the life of the loans
• Secured the bank’s interest by overhauling its collateral information system
• Opened and serviced all types of new and existing accounts
• Maintained detailed financial records and performed monthly reconciliation
• Enhanced the operation of the loan department by implementing advances in bank software

Mba, Finance

Bachelors Of Arts, Economics