Data Analyst Power
Resume:
C H R I S T O P H E R
C A R B Y
PROJECT EXPERIENCE SUMMARY
Established professional with extensive experience in Data Mining and Dynamic Dashboard Building. Easily adaptable to new systems and industries offering expert Excel automation and Coding Solutions
Lead and coordinate key reporting tasks related to the strategic procurement initiatives in different areas of focus such as: Professional Services, Real Estate, Technology
SELECT STRENGTHS AND SKILL SETS
MS Excel (Power user) VBA Power Query Power Pivot
Python (Pandas, Seaborne, Numpy, Matplotlib) R Power BI SQL
MS Access (Power user) MS PowerPoint
Outlook HTML
EDUCATION & CERTIFICATES
B.A. in Economics, Queens College, New York, NY; May 2012
Basic Project Management, New York University, New York, NY
PROFESSIONAL EXPERIENCE
Calvin Klein 12/19 – Present
Business Intelligence Analyst
Use VBA / SQL / Python to create Dynamic Dashboards, Data Modeling and Visualizations for Global Strategy Leaders, offering real time analysis and portfolio optimization solutions
Use SQL Query and Advanced Excel Functions to Aggregate Calvin Klein’s Internal data with 3rd Party (Google) sources
A&E Networks 9/19 – 12/19
Excel Specialist
Manage a pilot program launch of A& E’s Performance Review process using Business Intelligence Tools, communicate process gaps and incorporate all changes into SOP and Excel automation
Develop macros to consolidate all Ad Sales data into shareable Sharepoint uploads for use across multiple platforms, capture all changes into Dashboards for statistical analysis
Use Python / R scripts in Power BI to create Dynamic Data Visualizations
International Refugee Crisis 8/19 - 09/19
VBA Developer
Create Macros / Use Advanced Excel Functions to data mine and map new Learning Pathways to build out newly created Management Learning Systems
Create unique identifiers in order to consolidate and gain key insights among large and disparate data sets
Present trends, insights and data mapping analysis to Leadership groups and their teams
Signature Bank 11/18- 04/19
Excel Specialist
Use Macros / Advanced Excel Text Functions ((LEN, Concat) to document and execute Sarbane Oxley Compliance Procedures
Support Leadership Team using Excel to merge data from various sources, write formulas to summarize data, translate data to user friendly reports and data mine for necessary drill down metrics
Testing, documenting websites, software changes that occur during Interim to Final stages to ensure consistency with SOX Compliance.
Assist with Build out of business glossary and data dictionary in coordination with IT and business teams
Burson Marsteller 2/17- 01/18
Business Research Analyst
Use Advanced Functions (SumProduct, Nested IF, Index/Match) to filter and integrate large datasets for client reporting and distribution
Create Frequency Distribution Tables, Charts for Key influencers, tracking industries, business ratings, and levels of influence
Create a PowerPoint deck with research notes, top storylines, product mentions for multiple brands and campaigns
iHeart Media / Horizon Media 10/16- 2/17
Data Analyst
Prepared competitive spend reports using Advanced Excel allowing companies to track industry trends.
Use VLookups, pivots tables to extract and integrate data into budget reporting
Mercedes Benz 4/16- 9/16
Data Mining Analyst (Contract)
Facilitate resolution of data issues with IT and perform data validation for new reporting database and other ad hoc data projects
Led the process of organizing a disparate data set (internal and external) into a set of source data to create automated reports in Excel using advanced formulas including pivot tables, macros and VBA coding
Provided trends analysis and actionable insights for general manager
Viacom 8/15 - 11/15
Data Analyst (Contract)
Performed data entry and management reporting using internal databases and MS Excel (Pivot tables)
Used pivot tables and lookup formulas to track advertising campaigns by cost, revenue and competitors
Ran reports and analyzed ecommerce activity using reporting tools. Identified and tracked trends in metrics to identify improvements to Website based on usage and traffic patterns
JP Morgan Chase 1/15 - 7/15
Project Coordinator (Contract)
Transported large amount of data from Sharepoint and PeopleSoft into Excel for template and macro creation
Served as the key technical point person for department for all ad hoc requests involving Excel, Sharepoint, PeopleSoft
NEW YORK CITY SCHOOL CONSTRUCTION AUTHORITY 1/13 - 3/14
Business Analyst //Database Analyst (Contract)
Established and administered an integrated system for monitoring and tracking project execution; oversaw authority database to ensure accuracy of information provided and resolved issues related to Target, Capacity and Enrollment Information
Recommended policies, procedures and execution control for database from design inception through completion
In conjunction with other Division staff, reviewed and updated periodic reports as mandated by Authority enabling legislation, including, but not limited to, the Line Project Status Report (Trustee's Report), External Completion Report and the Yearly Commitment Plan
ROSS STORES 2/12 – 9/12
Bussniess Reporting Analyst (Contract)
Used vlookups, pivots tables to extract and integrate data to create exceptional quality reports for budget and metrics
Ensured proper documentation and consistency of data used in reporting
Contact this candidate