James Nicholson Email and Phone Number

• Develops new dashboards in Power BI to enhance data reporting, which includes gathering key metrics and transforming raw data into actionable insights• Leads complex projects and data analytics efforts in coordination with senior leadership, technical teams, and C-level executives• Conducts training sessions for the Data Services Team on practical applications of Power BI, SQL queries, and report-building techniques.

• Worked as a technical expert with clients, analysts, programmers, and other team members to develop technological solutions to complex business problems.• Spearheaded data flow improvement to increase efficiency in the entire department by 25% using Python Scripts, SSIS packages, and Stonebranch workflows.• Collected, cleaned, and provided modeling and analyses of structured and unstructured data used for major business initiatives.• Created extensive monthly, bi-annual, and annual SSRS reports, maintaining 95% deadline adherence.• Creates custom scripts to ensure proper data access, manipulation, and reporting functions with R, Python, and SAS programming languages.• Organized training for research department employees in the practical use of Python Scripts, SQL queries, and report-building methodologies.• Optimized SQL script performance, boosting efficiency and reducing report load times.

• Successfully managed a hiring program with Indeed.com that increased application volume from July 2019 to December 2019 by 38%.• Developed and updated content on the CarMax career website via Phenom People CSM• Implemented internal brand engagement activities• Collaborated with the company's appointed Media Agency and monitor the effectiveness of media • Managed and developed the CarMax Talent Acquisition budget• Informed vital stakeholders on all Talent Acquisition CRM (Customer Relation Management) Key Performance Indicators (e.g., open/click-through/conversion rates, Omniture trends, ROI, etc.)• Developed reports and dashboards using various Business Intelligence tools using Tableau, Teradata, and Workday• Assisted with a business plan, purchase, branding, advertising, remodeling, and marketing, increasing employer brand awareness with various job boards• Engaged with business partners to gather software requirements/business rules and ensure alignment with development teams and to maximize the effectiveness of analytics• Spearheaded dataflow improvement for the CarMax Talent Acquisition team• Used Tableau Prep Builder and Tableau software to track and analyze data.

• Proficient in data mining methods, extracting relevant information for reports and presentations• Develops reports and dashboards using various Business Intelligence tools including Tableau and Microsoft Reporting Services• Produces financial reports identifying current trends and evaluating variances that resulted in 1 million dollars in recoveries in April 2018 • Maintains SQL scripts and complex queries for analysis and extraction.• Experience and Familiarity working with Waterfall, agile and scrum methodologies. • Designs and implements stored procedures, views, and other application database code objects to aid complex mappings. • Creates database objects like tables, indexes, stored procedures, database triggers, and views.• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, CSV to MS SQL Server by using SSIS services and Python Scripts.• Experience working with the Centers for Medicare and Medicaid Services (CMS), the Healthcare Common Procedure Coding System (HCPCS), Electronic Data Interchange (EDI), Medicare Part D Services, and State Pharmaceutical Assistance Program (SPAP) services.• Medical Claims experience in Process Documentation, Analysis, and Implementation in 835/837/834/270/271/277/997(X12 Standards) processes of Medical Claims Industry from the Provider/Payer side.• Experience in Creation and Documentation of Test Plans, Test Cases, Test Scripts based on the Design and User Requirement Documents for - Unit, Integration, Regression, Functional, Performance, and User Acceptance Testing with QA and UAT teams.• Excellent troubleshooting, tracking bugs and issue resolution skills.

Virginia Premier Health Plan, Inc.’s Analyst Development Program, EMERGE, allows college graduates to gain valuable experience in the health and managed care industry. EMERGE participants will accelerate their knowledge and experience through hands-on mentorships, and working in operational analytics in a collaborative environment.

• Created and executed software test plans, cases, and scripts to uncover, identify and document software problems and their causes• Identified data needs and data requirements for test cases• Reported software defects using bug tracking system and reported errors involving program functionality, output, online screen and content to software developers• Assisted with user-acceptance testing and defect tracking for new software releases• Produced Tables, Stored Procedures, Views, Functions, Triggers, and User profiles in SQL Server 2012• Collaborated with project managers, product owners, and other team members to gather data for projects• Diagnosed and addressed operational data issues using Tableau • Provided Helpdesk and Technical Support via Team Foundation Server• Wrote scripts to extract data in SQL

• Produced Tables, Stored Procedures, Views, Functions, Triggers, and User profiles in SQL Server• Identified, recommends, and implements all new database technologies• Developed ETL packages using SSIS SQL Server Integrated Services• Performed and managed data migration for various business departments• Generated interactive dashboards by using Power BI• Collaborated with project managers, product owners, and other team members to gather data for projects• Wrote scripts to extract data in SQL

• Focused on the installation and delivery of new car stock to rental locations• Hired, trained and managed driver staff on a daily basis • Developed and applied safety procedures for various process in day-to-day operation• Assessed Group level requests and communicated with other teams to ensure needs are met• Managed day-to-day operations in manager’s absence with a team of 90+ employees

• Managed everyday business of assigned branch with a focus on Customer Service Operations, Human Resources, Sales and Marketing, Financial Performance, and Fleet management and maintenance of 20+ employees• Resolved customer service issues in a timely manner• Managed rental counter customer flow and telephone service• Supervised, mentored, trained, coached, evaluated and developed employees to increase branch sales and accomplish customer service results• Developed, planned, and participated in branch sales and marketing efforts

• Focused on enhancing the experience of customers and driving sales• Provided proactive support to customers and associates• Executed merchandise and visual presentation standards for the sales floor• Facilitated efficient flow of merchandise to the sales floor from inventory• Managed team of 15+ employees