Sr. Manager Consultant - Data Insights And Analysis Resume
Columbus, OH
OBJECTIVE:
Lead developer and data management expert looking to design and build effective and scalable Business Intelligence solutions, including Metadata modeling, building data marts, designing reports and dashboards, performance tuning and application security that will all contribute to improved decision making through enhanced data management processes.
SUMMARY:
- Twenty years of experience at Confidential that create and manage large data sets that enhance the EDW and data reporting processes.
- Create and document data requirements and streamline data consumption and analysis processes.
- Liaison between Business and IT teams to develop SQL code that solves complex problems and identify insightful patterns that drive actionable solutions.
- Identify how data models can be best utilized to assist in solving the business objectives and drive continuous improvement.
- Lead teams that create and manage the data models used to solve complex problems.
- Solicit and define master data management best practices throughout the business.
- Create performance reporting used to identify and analyze trends.
- Project management experience.
TECHNICAL SKILLS:
- Experienced with Microsoft BI
- SSAS
- SSRS
- SSIS
- SQL
- T - SQL
- PL/SQL
- VB/VBA
- Visio
- XML
- Access
- Powerpoint
- Hyperion
- Essbase
- Cognos
- ServiceNow
- HP Quality Center
- Sharepoint
- Oracle R11
- R12 & MDM
- Omniture
- Informatica
- SAS
- Tableau and Alteryx.
PROFESSIONAL EXPERIENCE:
Confidential - Columbus, OH
Sr. Manager Consultant - Data Insights and Analysis
- Project roles that partnered with Business and IT teams to migrate data from source to target environments of SQL datasets, stored procedures and SSIS packages.
- Led both onshore and offshore teams that identified enhancements and migrated ETL scripts from SQL 2008 to SQL 2016.
- Converted Alteryx and Access data sets to SQL 2016 and created stored procs to enhance efficiencies.
Confidential - Columbus, OH
Sr. Consultant - Data Process
- Agile project role focused on feature-based enhancements within the middleware space.
- Led JAD sessions to communicate project plans, elicit requirements and create, test and implement system enhancements on a variety of in-house applications.
Confidential - Columbus, OH
Sr. Consultant - MDM - Data Migration & Analysis
- Project role focused on data mapping, analysis and management within the IT Operations area for the Oracle MDM migration project.
- Create, test and manage SQL scripts used for in system testing and validation.
Confidential - Columbus, OH
Sr. Consultant - Financial Data Management
- Project role focused on Data profiling, data mining, and management within the IT Operations.
Confidential - Columbus, OH
Sr. Consultant - Data Mapping/MDM
- Built data models that profiled and validated time-based usage data from multiple sources.
- Manage multiple Oracle reference tables to improve data integrity and systematically audit the data management processes to ensure data quality and requirements exceed expectations.
Confidential - Atlanta, GA
Sr. Manager - Data Analysis
- Led staff on the defining, designing, modeling, and profiling of data for analytical processes, starting with Business requirements and working backwards to the mapping, management and storage of the data within the IT infrastructure.
- Manage the creation of automated FP&A and Sales metrics reporting for executive management via SQL scripting and MSBI processes.
- Partner with Business and IT to research and resolve data inconsistency issues, implement data controls and validation processes to improve data integrity.
- Accountable for building, validating and analyzing of all sales data in EDW.
- Automate dash boards using ETL and stored procedures.
- Led analytical and reporting requirements and testing plans on Oracle R12 implementation.
Confidential - Atlanta, GA
Sr. Analytics Manager - E-Commerce
- Develop testing, validating and reporting around provisional transactions, showing gross and net amounts.
- Optimize paid search returns by vertical, improve overall paid search ROI by continuously optimizing lower cost higher converting keywords.
- Reduce direct costs of marketing campaigns by 20% through negotiations with new vendor.
- Improve the click-through rates on email marketing campaigns by 15%.
- Develop and communicate core KPI metrics for and for all channels of e-commerce.
Confidential - Fort Myers, FL
Manager - Financial Data Analysis
- Accountable for the creation, monitoring, and reporting of the Divisions’ $75M operating budget and the departmental level reporting to Senior Management.
- Project lead on the Precision Network implementation and reporting processes. Funneled premium web traffic to the top Advertisers, driving higher pay per click bids. The Precision network accounted for 50% of the corporate revenue within the first 6 months of operation.
- Develop a scorecard to monitor online traffic by net revenue and by source to assist with contract negotiations and produce greater insight to traffic profitability.
Confidential - Columbus, OH
Project Manager - Data Analysis
- Research, develop and test predictive financial models, which built the foundation of proprietary investment management program.
- Develop and maintain data warehouse with 10+ years of historical data.
- Create and implement all facets of a small business, financial modeling, marketing, and working with investors, while handling all day to day activities.