Senior Business Intelligence Analyst Resume
SUMMARY
- Highly skilled and experienced Business Systems Analyst with a demonstrated success of completing seventy - plus projects at fortune 500 companies. Conversant in modeling, diagramming and business analysis methodologies including Agile and scalable Agile workflows.
- Work focus for the past seventeen years has been concentrated around the systems, business and technical analysis of entertainment applications in the areas of: TV Distribution/Sales, TV Production, TV Legal and Business Affairs, Option tracking, Motion Picture music tracking, Brand Development/CPG, Product Development and Royalty Payment Finance systems.
- In all work experience, I have consistently performed as a process leader in training, innovation and implementation throughout the systems development life cycle.
PROFESSIONAL EXCELLENCE
Confidential
Senior Business Intelligence Analyst
Responsibilities:
- Interview and work with Brand Dev/CPG business partners to gather requirements and design business process documents used to develop new MicroStrategy reports.
- Gathered existing SQL Server report code, decomposed the code to create POC datasets and user acceptance test cases.
- QA test and organize UAT business testing for twenty new MicroStrategy reports.
- Perform Microstrategy, SQL (Oracle, Teradata) validation using SQL.
- Troubleshoot third party upstream application data flows to discover root causes of MicroStrategy report variances and implement mitigation procedures.
- Discover and advise on process flow improvements.
Confidential
Senior Technical Business System Analyst
Responsibilities:
- Completed functional and technical analysis of Brand Dev/CPG forecasting workflows.
- Modeled, created and developed the new WB Consumer Products forecasting database and related reports using Microsoft SQL Server and SQL Server Business Intelligence tools (SSRS, SSIS).
- Performed analysis, diagramming and process re-mapping of royalty systems. Specific tasks involved improving accuracy and tuning of Oracle PL/SQL stored procedures in a complex ETL contract revenue workflow. Oracle stored procedures and revenue accounting efficiency was improved by 50%.
- Followed Agile workflow methodology
Confidential
Senior Business analyst
Responsibilities:
- Created detailed functional specifications from BRD documents and business partner interviews. Identified PSI’s and linked business requirements to specific functional and technical requirements while prioritizing workflows to meet MVP estimates.
- Created user stories and linked documentation in Microsoft Team Foundation Server using Agile methodology stack.
- Participated in daily standups, sprint planning, sprint scope, backlog grooming and retrospectives.
- Created SharePoint organizational structure and repository methodologies for all Business process artifacts.
- Write the detailed functional specification for multiple complex Salesforce.com conversions/integrations covering Business Process Re-engineering, Workflows, UI changes, use cases, mockups, Wireframes, data mapping and middleware processes.
- Create the detailed functional specifications for a custom C#, SQL Server application covering Business Process Re-engineering, Workflows, Object modeling, Package Diagrams, Use cases, Activity Diagrams, Sequence Diagrams, UI changes, mockups, Wireframes, data mapping and middleware processes.
- Supported three fast moving development teams and acted as the source of truth for the requirements specified in the Functional Design Specification.
- Technologies used in the Business analyst role: .net, JSON, AWS/Cloud, SOAP, REST, SQL, COTS, UML, SharePoint, Salesforce.com, Win Server 2012, Visio.
- Completed the functional decomposition and re-factor design of the Film Asset, Talent and Scheduling application. Responsibilities included; extracting and documenting specific computer language code, data elements and UI visual mapping to a new format suitable for re-factoring in a different computer language and technology.
- New SQL Server stored procedures were written so that database elements could be transferred to a format acceptable to any new technology.
Confidential
Senior Technical analyst
Responsibilities:
- Performed analysis, diagramming and process re-mapping of consumer products royalty system. Specific tasks involved improving accuracy and tuning of a complex “real-time” ETL contract revenue workflow.
- Gathered business partner requirements and created SQL Stored Procedures and Queries in SQL Server 2008 and Oracle 11. Created complex Oracle stored procedures that increased accounting business productivity for CPG royalties. Worked with the business to thoroughly test the newly created Oracle stored procedures in Dev., QA and UAT environments
- Created detailed and Overview diagrams in Visio using a modified UML/Flowchart methodology to document 100,000 lines of custom Oracle PL SQL code.
- Compiled user stories, designed specific development solutions addressing user stories and worked with the business partners through QA, UAT and post implementation testing to arrive at business sign-off for a custom CPG product development application.
- Assisted offshore development team in optimizing and tuning SQL Queries (Oracle and MS SQL Server). For example, I eliminated a Cartesian join in Oracle, which reduced an accounting process run time by 23 hours.
- Created a process and Oracle package to improve production support.
- All job responsibilities were carried out using Agile methodology.
Confidential
Senior Systems Analyst/PM
Responsibilities:
- Completed the business systems analysis and performed Monthly and Year-end closings of a large vendor supported filmed entertainment contract revenue system. Modules included GL, AR, INV, Billing, Contracts, Availability, and Intellectual Property.
- Completed the assessment of customer needs and determined which IT services were most strategic to the Contract Finance monthly and year-end closing process.
- Setup the Contract Finance application change management in HP Service Manager and created new service level agreements (SLA) for user requests, service (application) failures, day to day operations and all mission critical fixes. Changed the level 1 support from the external consultant to the internal FTE (myself).
- Performed Business Analysis and modeled all elements of the TV and Filmed entertainment contract finance management system using Rational Rose/Architect UML tools.
- Troubleshoot revenue recognition and month-end close processes and make correcting journal entries to enable contract Finance account to close the books.
- Set up a service transition plan from an external consultancy to an internal NBCU managed process. Root cause analysis was to be performed by the internal FTE in conjunction with the external consultancy for six months or until it was determined that the external consultancy was no longer needed. Managed the knowledge transfer of all vendor-supported functions to the company application support team. The in-house move of the application support resulted in a 50% cost savings to the company over the lifetime of the application
- Improved the design of Identity management to fully comply with the Sarbanes-Oxley act (SOX).
- Completed a FMEA project which Improved the application failure rate of 100% monthly to 0% monthly within one year. Planned the operational sun setting of the application using contract revenue recognition as a baseline.
- Responsible for all application and server production support.
- Managed the TV distribution finance production support software development team. As manager of the production support team, I effected a sixty percent year over year increase in completed development enhancements and bug fixes.
- Departmental processes were designed and put into place that allowed development cadence to deliver on demand, which led to a ninety percent reduction in application build rollbacks during my tenure on this project.
- As team manager I lead daily standups, sprint planning, sprint scope and backlog grooming in association with the international business partner.
- Managed release planning, sprint demos, retrospectives and performed opportunity cost analysis to assist in the burn down of technical debt.
- The project and change management software used in all phases of the project was HP Service Manager.
- As a Systems Analyst Developer I Managed the Digitalization and enhancements of the SYFY/NBC Legal affairs Director/Writer talent payment application.
TECHNICAL SKILLS
Accounting systems: Oracle Financials, Oracle E-Business Suite, Jaguar, RSS, SBT, Excalibur, Solomon, Great Plains, Custom
As IT Developer: SQL Server, Oracle, Visual FoxPro, .net, VBA, Active-X, MS Office Automation, Filemaker Pro, WSH
As IT Business Analyst: Cloud/AWS, SharePoint, Teradata, MicroStrategy, .net, T-SQL, PL SQL,VB, VBA, MS Office automation, knowledge engineering, standard flowcharting, use case, wire frames, business object design, application framework design, functional decomposition, BPR, RUP, Six Sigma, SharePoint and more. WSH, Visual FoxPro, Java, JavaFX, JavaScript, PPMC, Clarity, HTML, Six Sigma Green Belt training, project/Service management (HP Service Manager), Service Now, LEAN, UML, BPR, CASE, RAD, Agile, Scalable Agile, Rational, SOW, SOAP, Full SDLC, COTS, AS/400.