Business Intelligence Manager Resume Samples

Description :

1. Manage the deployment of a data warehouse and business intelligence platform that integrate and transform healthcare data (Practice Management, Revenue Cycle Management, and Clinical Outcome) into meaningful, actionable solutions.
2. Manage the design, development, testing and deployment of the company's dashboards.
3. Develop business requirements, assess current reporting capabilities, and make recommendations regarding enhancement of our BI analytical tools.
4. Lead developer, architect, and administer of the MicroStrategy and Distribution Services environment.
5. Develop and maintain the logical business model in MicroStrategy Architect.
6. Support, troubleshoot, and maintain MicroStrategy foundation on a daily basis.
7. Work closely with various functional teams to translate business requirements into optimized semantic layers, reports and dashboards.
8. Continuously build a strong relationship with internal business and technical stakeholders including presenting technical solutions while showing a strong understanding of business activities and objectives.
9. These efforts have greatly increased data availability and provided patient and practice level analysis for operational, tactical, and strategic decision-making.

Experience

10+ Years

Level

Senior

Education

BS In Graphic Communications

Description :

1. System owner of the Financial ERP system called PeopleSoft Enterprise Performance Management (EPM).
2. Duties included: a.
3. Troubleshot any issues related to data flow from Data Warehouse into the PeopleSoft EPM application b.
4. Created data requirements for PeopleSoft EPM for any system upgrades c.
5. Participated in bringing data from front end application into Data Warehouse and ending at PeopleSoft Enterprise Performance Management tool.
6. Migrated monthly profitability data from PeopleSoft Enterprise Performance Management (EPM) to Access database to be used for reporting by the FP&A team Supported Product teams via creation of Business Objects reports to increase product offerings Performed through profitability analysis by comparing monthly accounting results from Hyperion Essbase and PeopleSoft EPM Explored databases using different data mining techniques and contribute towards designing a data model required for consistent reporting as well as deeper analytics Identified appropriate information/report dissemination tools (such as Tableau) and designing the reports to share insights/results Accomplishments 1.
7. Created Sales Dashboards in Xcelsius containing daily data of loan and deposit balances as well as profitability, product usage and pipeline information.
8. This dashboard is ran automatically daily for each Sales Manager to save 4 hours running individual daily reports and 2 days running month end reports for profitability, product usage and pipeline reports.
9. Managed Activity Based Costing (SaaS software) Implementation project through: a.

Experience

7-10 Years

Level

Consultant

Education

Master Of Business Administration

Description :

1. Plan, design, and implement application database objects, including tables, stored procedures, functions, and views, to support material business decisions in a rapidly changing, high competitive market sector.
2. Manage a team of 6 Data Analysts.
3. Build and maintain SQL scripts and complex queries for data analysis and extraction.
4. Design impressive SSRS reporting solutions to meet user specifications and bring meaning to the data and in order to solve complex business requirements using maps, spark lines, data bars, drill downs, sub reports, indicators, and gauges.
5. Design Tableau dashboards to meet the business needs for interactive reporting.
6. Set up TFS for Version Control of all production SQL scripts as well as SSRS reports.
7. Use TFS to manage SCRUMS and team tasks.
8. Perform quality assurance and testing of other developers SQL scripts and reports.
9. Lead on SSRS migration of reports (approx.

Experience

10+ Years

Level

Senior

Education

MBA In Accounting

Description :

1. Collaborated with end user, business partners and engineering team to identify and analyzed BI information needs and opportunities for improved data management and delivery.
2. Improved and streamlined processes of data flow and data quality to improve data accuracy, viability and value.
3. The streamline process has improved department efficiency by up to 70%.
4. Designed and developed analysis methodology to ensure data quality, reporting dashboard, and visualization via Tableau/Microstrategy to propose innovative ideas and eliminated hidden risk.
5. Developed statistical models to data mining to best practices in data visualization, self-service BI and anomaly-detection, and presented story to assist upper management decision.
6. Designed and built visually rich applications and dashboards to measure, track, and display key business metric Designed and built tools and automations that scale critical business processes.
7. Managed the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation by various tools i.e.
8. data extraction from Teradata and Oracle by SQL, ran analysis through Python and SAS, and report and dashboard through Hadoop, MircoStrategy, and Tableau.
9. Monitored and analyzed key findings by approaching statistical models (regression analysis) to eliminate anomalies and streamline department efficiency.

Experience

7-10 Years

Level

Management

Education

BS In Business

Description :

1. Head of BI COE in the $52 Million SAP implementation.
2. Lead a global 20 member team of analysts and SAP BW/BI/EPM developers to create various BI applications, including dashboards, TAT reports and operational reports.
3. Lead Enterprise SAP BW, SAP BI and SAP EPM through multiple M&As (Keane, Intelligroup, MISI, Optimal Solutions, Centerstance, Carlisle and Gallagher.) Collaborated with SAP to identify the areas of improvement of the current system and their roadmap strategy so as to align NTT Data's roadmap and to identify the need to upgrade or apply patches to the systems.
4. o Led the effort to migrate SAP BW from IBM AIX to Sun Solaris o Led pre-upgrade assessment of SAP BW 7.x features for upgrade and the upgrade and redesign of the BW objects Change request and incident management process ownership.
5. Implemented improvements to the Critical Incident Management response (CIM) process and ensure 100% adherence to the process, improving internal and customer communications, speed to recovery and better RCA.
6. Talent acquisition, training and performance management.
7. Partner with business users to improve efficiencies through self-service BI.
8. Increased utilization of SAP BI by providing timely and actionable information: o Delivered a WIP reporting solution which eliminated manual storage and evaluation of the WIP amounts, which reduced month end closing by 4 days.
9. o Delivered Project and Employee performance reports which gave visibility into gaps in Billing and AR recovery.

Experience

7-10 Years

Level

Management

Education

MBA In Strategy

Description :

1. New York, NY May 2014 - November 2014 Award-winning global Hispanic media content/communications network.
2. Business Intelligence Manager Manager of business intelligence vertical for Univision Sales, Traffic, and Research department.
3. Provide support for Tableau and Business Objects reports focusing primarily on linear advertising revenue, research and traffic reports.
4. Key Software: Tableau, Business Objects, Teradata, Oracle 11, SQL Server 2012, Kalido, Informatica, SFDC Key Accomplishments: Responsible for data marts, ETL architecture, Business Intelligence design, Cubes and database applications development within a matrix model.
5. Developed roadmaps for all levels of management which incorporate OPEX and CAPEX tracking for short term and long term projects.
6. Partner effectively with key business sponsors within a matrix organization to identify their pain points and proactively deliver a solution.
7. Establish design sessions with the business to identify canned reports vs.
8. ad-hoc reports and dashboards, measures and dimension, and calculated fields for Adsales and Finance reports.
9. Project management concerns such as ease of use of the toolset, in-scope & out of scope deliverables, pros & cons of visual vs.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor Of Science

Description :

1. Overview: Earned multiple promotions in this fast-track leadership position.
2. Initially hired as a Programmer, advanced to the application side, and then accepted leadership accountability as the organization launched its first BI group.
3. Built the enterprise-wide BI infrastructure and created systems on a single, robust, and scalable platform.
4. Led the development of MicroStrategy solutions for the entire organization.
5. Presented business cases and analyses to the senior executive team.
6. Knowledge of Technology (from the bottom up) - Gained experience and knowledge of the challenges that exist at all levels of technology operations and leadership by entering the field at the ground level, tackling coding and application development projects, and then progressing to supervisory roles.
7. IT Leadership - Served as exclusive IT representative for the market's Strategic Assessment team.
8. Assisted in creating methods to leverage technology and data to exploit untapped market potential.
9. Project Planning & Management - Defined requirements and scope, developed project specifications and work plans, determined risk/contingency plans, and directed project planning and execution (as well as training programs for clients) - with exceptional on-time, within-budget results.

Experience

7-10 Years

Level

Management

Education

MBA

Description :

1. Configured and maintained network management and monitoring system for global company network of over 400 servers, routers and switches.
2. Programmed combination of Whatsup Gold, Micromuse Netcool and Sitescope platforms to detect via custom thresholds to monitor all protocols, detect and restart services, determine up status of html, .asp and cold fusion web pages, monitor of disk space, CPU utilization, all event errors and any other custom monitors needed with custom scripts.
3. Set alerts via email pager for instant attention and auto up alerts to determine up status of all nodes.
4. Provided detailed SLA reporting by customer on all nodes monitored.
5. Managed all client web statistical analysis reporting on over 40 client web sites.
6. Programmed custom sections per client needs.
7. Created and programmed ftp info across network for log generation and analysis by Accrue HitList.
8. Created programmed scripts to access and archive logs across network.
9. Managed systems administration on over 50 World Wrestling Federation web sites.

Experience

5-7 Years

Level

Executive

Education

BS In Communications

Description :

1. Developed, tested, tuned, and rolled out three new Essbase cubes for the financial and HR communities at Siemens.
2. These databases capture data from both the newly implemented SAP ERP system and PeopleSoft HR warehouse.
3. Automated the loading, calculation, and standardized reporting distribution procedures for financial closes and reporting deadlines.
4. Formalized a monthly forecast procedure for Financial Analysts to load, calculate, and report revenue, costs, and gross profit out of Essbase.
5. The results of these forecasts are then submitted to company headquarters in Germany.
6. Introduced web-based reportingdashboarding for Accounting and Finance VP's, Controllers, Directors, and Analysts using Hyperion System 9.
7. All previous P&L, Balance Sheet, and HR reporting was performed using Excel and then distributed via email or shared network drives.
8. Streamlining the reporting processes localized all corporate reporting, automated month end deliverables, provided greater end user flexibility, and increased the number of outputdisbursement options.
9. Tuned both calc scripts and outline metadata dimensionality to considerably decrease processing times for full database restructures, data loads, calculations, and reporting.

Experience

7-10 Years

Level

Consultant

Education

Bachelor Of Arts

Description :

1. Responsible for BI/DW methodologies development, processes governance, and tools selection; acting as a solution consultant to upper management for data driven insights and recommendation.
2. Accountable for the delivery of project capabilities and business results.
3. Ensuring successful closure and completion of all aspects of projects.
4. Developing information and object-based data warehouse to support Business Intelligence infrastructure and scalability.
5. Advancing BI features to support executive management teams in information gathering and business performance tracking in real time.
6. Building and managing Information System, Technical Support, Production; supervising staff and managed budgets.
7. Designing automation processes to improve responsiveness and maintain high level of information systems service to all business functions across organization, continuously.
8. Establishing data file back up and control procedures to enforce security policies.
9. Leading information system enhancement implementation, user communication, training, and business specifications.

Experience

7-10 Years

Level

Consultant

Education

Doctor Of Executive