JANE HAINES
Houston,TX
Summary
Experienced business intelligence professional well-versed in translating complex mandates into actionable plans, developing databases and generating reports. Detail-oriented and systematic with excellent follow-through and a superior work ethic. Excellent communication, project management and problem-solving abilities. Ready to bring 10 years of related experience to a challenging new role.
Overview
12
12
years of professional experience
Work History
Business Intelligence Developer
Kiewit Oil and Gas Construction
Houston, TX
07.2019 - Current
- Collaborated with stakeholders to establish scope of data projects and act as liaison between SMEs, data and analytics teams
- Developed Power BI dashboards utilizing DAX and PowerQuery in order to provide data-driven insights for projects ranging from enterprise resource planning, material quantity counts, estimations and forecasting, and data quality assurance
- Reverse engineered existing Tableau and Excel dashboards to be utilized in Power BI
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Developed complex data transformations across multiple sources in Python for the purposes of cleaning and comparing data from different stages of engineering projects
- Designed, tested and implemented various data processing automation tasks in Power Automate, Python, and Azure Data Factory based on the scale and needs of the customer
- Routinely wrote, collaborated and maintained accurate documentation of stakeholder requests, current processes, planned processes and user guides
- Responded to specific BI requests from all levels of personnel, creating data packets with requested information in easily understandable formats.
- Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
Analytics Manager
Envoy Mortgage
Houston, TX
07.2017 - 07.2019
- Regularly met with executives to assess current data and analytics needs
- Updated C-Level executives on statuses regarding current projects and fielded questions for IT regarding technical needs and priorities
- Organized small teams as large as 5 people consisting of managers, IT, and other analysts in order to complete a variety of projects in operations, HR, servicing and compliance
- Developed custom SQL queries for Tableau when querying multiple tables were not optimal for our server’s processing capabilities
- Wrote complex, custom Tableau calculations on the front end and communicated with developers to create scalable calculations on the back end to increase speed and accuracy on Tableau reports
- Managed datasets and user permissions to allow for privacy for our borrowers and our current employees
- Consistently performed and documented quality control on newly developed datasets
- Created custom dashboards and interfaces designed specifically to suit customer needs and priorities for optimal performance.
- Integrated third-party analytics solutions into ongoing projects.
- Derived forward-looking insights from ongoing analytics projects to offer predictive intelligence for ongoing business decision-making.
Digital Analytics Manager
Envoy Mortgage
Austin, TX
07.2015 - 07.2017
- Created custom reports in Tableau that were visually pleasing to the eye, accurate, informative and actionable Documented as-is end-to-end data warehousing architecture for lead acquisition and distribution
- Developed forecasting reports based on lead score, sales performance, and other historical data
- Updated custom Tableau reports to shift focus on timely status reports, outliers, and “data storytelling”
- Customized Tableau reports for executives, shareholders, department heads, shareholders, and sales agents on an ad-hoc and scheduled basis
- Gathered requirements from a variety of key stakeholders to create multiple Tableau data sources for purposes including but not limited to finance, inventory management, employee performance, and vendor performance
- Simultaneously ran ad-hoc data requests from executive staff in simplified formats while collaborating with engineers on developing and testing custom data sources
- Regularly met with stakeholders from all departments on shifting KPIs, project statuses, data driven trends, and deliverables
- Modeled proposed database architecture for company’s ERP system and oversaw implementation with engineers
- Used various levels of data mining to extract leads from internal and external sources
- Migrated company's leads and tracking systems from client side machines to cloud AWS servers
- Worked with overseas developers to test speed and accuracy of Hadoop and Spark implementations
- Managed massive overhaul of legacy employee permissions hierarchy for the entire company
Operations Analyst/OTRS Developer
GE/Wayne
Austin, TX
01.2014 - 05.2015
- Documented database architecture in Visio for product owner
- Lead team to import customer database into a backend system
- Generated a variety of reports for manager using Excel and Crystal Reports upon request
- Maintained communication with engineering team in order to keep up to date with software changes that would affect media presentation and distribution to other sites
Junior Business Analyst
Christie Digital
Cypress, CA
01.2010 - 01.2014
- Assisted in maintaining Amdocs ticketing system by creating custom reports utilizing SQL language JDE Oracle database system
- Consulted by supervisor of managed services to document and analyze workflow patterns in order to improve speed and ease of use of Amdocs ticketing and dispatching system
Education
BBA - Management Information Systems
University of Houston
Houston05.2009
Skills
- MSBI Suite
- SQL Server Reporting Services (SSRS)
- SQL Server Analytics Services (SSIS)
- Power Platform
- Power BI
- PowerQuery, DAX, Tabular Editor
- Power Automate
- Power Apps
- Tableau
- Tableau Desktop
- Tableau Server
- Tableau Prep
- Oracle
- Snowflake
- Alteryx
- Domo
- Looker
- Qlik
- MS-SQL
- T-SQL
- PL/SQL
- Excel
- Excel VBA
- Pivot Tables
- Office Scripts
- Anaconda
- Visual Studio
- SQL Server Integration Services (SSIS)
- Python
- Pandas, Dataframes
- API
- RESTful, HTTP
- JSON
- Batch scripting
- Azure
- Azure Data Factory
- Azure Databricks
- Azure CosmosDB
- Database Management
- Business Intelligence Analysis
- Data Analysis Tool Design
- Performance metrics analysis
- VBScript
- Software applications
- Technical Analysis
- HTML and XML
- API design knowledge
- Operational analysis
Timeline
Business Intelligence Developer
Kiewit Oil and Gas Construction
07.2019 - Current
Analytics Manager
Envoy Mortgage
07.2017 - 07.2019
Digital Analytics Manager
Envoy Mortgage
07.2015 - 07.2017
Operations Analyst/OTRS Developer
GE/Wayne
01.2014 - 05.2015
Junior Business Analyst
Christie Digital
01.2010 - 01.2014
BBA - Management Information Systems
University of Houston
Similar Profiles
Selma GunerSelma Guner
Project Control Engineer at Enprode Engineering & Construction Inc.(Oil & Gas)Project Control Engineer at Enprode Engineering & Construction Inc.(Oil & Gas)
Omolola AkinpeluOmolola Akinpelu
Project Scheduler at Oil And Gas Construction CompanyProject Scheduler at Oil And Gas Construction Company
Shady Hussein Fouad KhalilShady Hussein Fouad Khalil
QA/Senior QC Officer at Petrojet For Oil & Gas ConstructionQA/Senior QC Officer at Petrojet For Oil & Gas Construction
Chukwunyereze EneChukwunyereze Ene
Chart Retrieval Specialist at EpisourceChart Retrieval Specialist at Episource
Daniel PerezDaniel Perez
Medical Lab Technician (Lead Tech) at HCA Clear Lake Regional Medical CenterMedical Lab Technician (Lead Tech) at HCA Clear Lake Regional Medical Center