James

Provides insights into the Talent Acquisition Organization of the company.  Leads a team in acquiring market research and market developments.

• Conducted data analysis, and validation, developed scorecards and dashboards and identified trends to inform business strategy with supportive action planning to be presented to senior leadership.
• Transformed data into readable Trendlines to gather insights and actionable results; delivered actionable insights into recruiter KPI performance, job market analysis, stimulus, marketing effectiveness, applicant flow, candidate conversion, labor market data, and training participation rates and training effectiveness.
• Collaborated with key stakeholders to identify business questions, gather data, run analysis, and develop ad-hoc reports on recruitment and training leveraging the Applicant Tracking System (ATS), Learning Management System (LMS), and Oracle.

Served as a trusted advisor to one Power BI project. Leveraged business analytics tools to analyze data and share insights. Successfully built data models and relational databases to power an HR Benefits Reconciliation project in Power BI.

• Reconciled election alignment via ADP and vendor systems.
• Developed and optimized correlations and relationships between 20+ tables in Power BI.
• Automated extractions from SharePoint into Power BI and wrote technical documentation for the Power BI file.
• Achieved project business requirements by collaborating with management and administrative staff.

Assessed the performance of the sales organization and ranked associates within various KPI realms and the value that each brings to the company. Also, performed Business Intelligence functions within HR, Operations, and Finance.  Streamlined the TriSMART Solar Proposal tool to reduce maintenance effort by 500 hours per year.

• Developed sales performance KPIs ranking 100 sales representatives and spotlighting top performers in appointment setting
• Created a Business Intelligence process for operating expenses to categorize spending accounts; enabled COO visibility.
• Executed the implementation of a custom solar project management software.
• Successfully extracted 100K+ customer rows and 50 tables from the SMARTboard in MySQL for Business Intelligence analytics to leverage predictive analytics and benchmark data to optimize operations.

Continuously improved Data Analytical processes within Microsoft Excel that increased the production time of Data Analytics products. Supported Principal Analysts in conducting Market Research in Oil & Gas space.  Surveyed a portfolio of market segments and suppliers, and presented key findings in the form of reports, presentations, and through the online news service.

• Facilitated direct contact with clients and presented papers at IHS and client events.
• Leveraged structures and dynamics of defined market segments, estimated and forecasted cost trends, and market values.
• Ensured continued client satisfaction across the global customer base.
• Managed three upstream oil and gas product data, Methanol, EOFG, and Acetone.