Christopher Buck Email & Phone Number

Pittsburgh, Pennsylvania, Us

Saint Louis, Mo, Us

• Led and managed development, delivery and automation of monthly, quarterly and adhoc internal, provider and state reporting• Incorporated financial Hyperion functionality to produce ongoing actual vs restated med cost analysis for Autism, ESRD, medical cost analysis and Behavioral Health • Developed, automated and scheduled Teradata stored procedures for operational reporting/programs• Added additional internal and external reporting for Outpatient, Behavioral Health, Risk Adjustment related topics• Expanded on reporting acumen by implementing advanced Risk-Adjusted Medical Loss Ratio reporting and high-priority state operational reporting• Led team in grooming technical acumen of data analysts and Implemented a weekly SQL training class for all employees at the GA healthplan• Increased proficiency in Excel Powerpivot reporting functionality, obtained Microstrategy ANL certification, and competed Python coding bootcamp

Saint Louis, Mo, Us

• Served as the Finance team POC for adhoc reporting, and monthly state and medcost reporting• Developed an Excel Powerpivot solution to provide drill-down functionality and automated member/provider/claim level medical cost analysis.• Led internal and external (i.e. provider, financial close & forecast) reporting for Primary Care claims and Medical Loss Ratio (MLR) • Improved processes to help eliminate manual error and reduce runtime of reporting

Seattle, Wa, Us

• Gathered weekly contingent worker updates from client and maitained contingent worker db• Reported on member and agency statuses• Leveraged Amazon Redshift to develop complex operational report solutions• Developed and managed contingent workforce (member and agency) data model and weekly report

Paris, France, Fr

• Main contact for designing and documenting technical solutions for federal interfaces for a multi-state consortium. • Gathering requirements of all existing federal interfaces and related technologies• Developing functional and technical spec documentation detailing data mappings and SOA design• Proficient in data analysis and reporting (via Oracle SQL)• Designed and led a "SQL Essentials" weekly course to provide coworkers with SQL skills and a platform to install their own sample Oracle database to sharpen skills.• Successfully developed an automated SQL+PL/SQL Data Reconciliation Process that leverages reverse engineered conversion code and captures counts and reasons for all source file fallout (spanning each stage of the conversion process). Ultimately, the reconciliation solution provides the client with macro micro views of reconciliation to provide functional and technical reasons for any fallout records.

Paris, France, Fr

• Successfully developed an automated SQL+PL/SQL Data Reconciliation Process that leverages reverse engineered conversion code and captures counts and reasons for all source file fallout (spanning each stage of the conversion process). Ultimately, the reconciliation solution provides the client with macro micro views of reconciliation to provide functional and technical reasons for any fallout records.• Responsible for leading a comprehensive series of technical and functional reviews of fallout with client leaders and business users. Throughout the process of developing the data reconciliation process, I worked with the client to gather requirements, incorporate their functionality into the overall solution and present the solution design to the users and business leaders.• Responsible for completing critical and comprehensive documentation for the Data Conversion team. I was also responsible for leading detailed reviews of each document with client leadership, satisfying and achieving sign-off for each document.• Main contact for developing federal reports for client. Owning this deliverable made me a technical/functional SME for federal reports. Accuracy of each report was imperative and each report was reviewed by Department of Labor (DOL).• Proficient in data analysis and fallout analysis (via code/process reverse-engineering)• Developed an end-to-end data conversion plan and coordinated/managed each data conversion to completion. The overall benefit would allow the conversion team to effectively understand opportunities to improve processes and minimize the conversion duration leading up to the production conversion.• Learned Oracle ODI developing ETL programs to transfer data to Data Warehouse environment.• Created a high school professional development program (incl workshops) to provide high school students with awareness and skills pertaining to IT. Also, have been a leader of Atlanta "Professional Development" ERG efforts since 2011.

Paris, France, Fr

---Leadership---• Led Company ERG "Professional Development Committee". In this group, I created and led a series of events designed to encourage mentoring, leadership, and ability to leverage advice/experience among one’s peers and mangers/+. ---Data Analysis and Database Development---• Creating detailed queries and scripts (via SQL) to identify/correct data issues affecting the production database(s), or cross-system dbs/etc, and creating custom SQL scripts to correct the root cause.• Performed as a team leader to manage onshore and offshore resources for solution approach and deployment.• Experienced with PL/SQL concepts, development and related db objects. ---System Architecture (SOA)---• Understanding of how external systems interact with each other via interfaces, messages, transformation layers, and JIA(s).• Ability to triage transactions between multiple systems.---Data Analysis and Reporting---• Skilled in analyzing database architecture and data (of applications in SOA architecture) to resolve all architecture/data limitations and or data inconsistencies.• Provided detailed reports to clients using SQL (e.g. End user billing account financial analysis for large business accounts, product workbook structure, etc).

Python Programming

Bachelor Of Science, Mathematics