Quality Assurance Professional Experience

E: ******@*****.*** M: 917-***-****

*** ***** ***, ********, ** 11520

Lorraine M. Dewar

Summary

Highly motivated Business Intelligence Professional with 13 years of experience in Report Development and Analytics. Over 10 years of experience with progressive IT Business Intelligence solution implementation. 10+ years’ experience in Project implementation using Agile PM Methodologies. Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks.

Professional Experience

Manager- Campaign Business Intelligence–Cablevision, Bethpage, NY 01/14– Present

Identify BI solutions of each department through one-to-one communications with key power users and Implement those recommendations.

Develop high-profile report and dashboards for a wide variety of end-user.

Provide strong leadership talents towards leveraging technical expertise for clients and managing projects, including promoting initial contact through implementation, training and follow up with one-on-one training sessions.

Coordinate efforts with corporate executives to plan and execute productivity enhancements and cost reduction solutions, along with assessing and defining current requirements by interviewing end-users

Lead and successfully executed complete life cycle (SDLC) in project implementation to allow for continuous schema enhancements, which includes scope, requirement gathering, architecting, design, development, implementation, quality assurance, support for end-to-end IT solution offerings in business intelligence

Change management and documented the requirements for the changes

Worked closely with DBA’s to conduct any data model, data profiling, or database design & development changes required to support BI projects

Monitor and report out on website traffic utilizing both adobe analytics and google analytics

Managed team of 4 Microstrategy developers responsible for business analytics, including one offshore resource utilized to assist in re-designing of the internal Optimum Marketing landing page.

Understanding the ETL Lifecycle process and impact of data warehouse changes on programs. Supports in selecting the proper design solutions with user request.

MicroStrategy Developer/Analyst –Cablevision, Bethpage, NY 09/06– 01/14

Design and develop front end MicroStrategy reports, documents and dashboards for various business groups

Creation of MicroStrategy Schema Objects (Table, Attributes, Facts, Hierarchies)

Perform quality assurance analysis for all development.

Generate reporting business requirements and feasibility analysis in regards to business unit request.

Coordination and deployment of Microstrategy changes to QA and Production

Utilize SQL for assignments related to the investigation data anomalies

Support to the Narrowcast Administrator and Microstrategy Distribution Services.

Optimization of slow running, Reports, Documents and Dashboards

Junior Developer/Reporting Analyst –Realty Data Corp, Garden City, NY 05/05– 09/06

Developed the new accounting invoicing system utilizing Oracle sql and Visual Basic for Excel and Access

Perform parallel test comparisons between existing and new accounting reporting tools.

Gather functional specification and develop new reporting schema utilizing Access reporting tool.

Financial Analyst –Retirement System Group, New York, NY 09/04 – 05/05

Utilized Visual Basic to maintain financial reporting system.

Develop and analyze financial information for business activities, spreadsheets and presentations.

Generated fund performance and prepared data for annual reporting

Software Skills

Proficient in Microsoft Access, Word, Excel, Power point, Work-front and Microstrategy 10.3 / 9.4

Exposure to Visual Basic for Applications, Crystal Report 9, Visio, MS Project, Tableau, Google Analytics, Adobe analytics and PL/SQL

Quality work Experience in PMI (Agile project management). Knowledge of SQL

Education

Masters of Science – Management Engineering- Long Island University, Brookville, NY 2006

Bachelors of Science– Information Systems - Long Island University, Brookville, NY 2003

Associates of Science– Computer Science - Long Island University, Brookville, NY 2001

CDD – Certified Document Developer (version 10), Microstrategy University

Contact this candidate