Senior Data & BI Reporting Analyst

SUMMARY

Insightful Senior Data Analyst with over 25 years of experience in data

analysis and BI reporting across various industries. Proven expertise in SQL, Cognos, and developing strategic reporting dashboards that enhanced operational efficiency. Achievements include creating automated reporting systems leading to a 20% decrease in manual reporting time. Equipped to leverage strong analytical skills and detailed-oriented approach to support data-driven decision-making in any organization.

WORK EXPERIENCE

03/2014 – 07/12/2022

Web Developer, VEBA LLC

New York, NY

• Collaborated with clients to gather and evaluate project requirements, goals, and expectations. Formulated objectives and ensured the Business Requirement Document was duly signed.

• Engineered eCommerce platforms within WordPress environments, enhancing user experience and accessibility.

• Conducted quality assurance tests to identify errors and optimize usability.

• Spearheaded multiple client projects as the Lead Web Developer, maintaining daily synchronization with Marketing and Art Directors to ensure that all stakeholders were aligned and that projects were completed on time and within budget.

• Oversaw all stages of website creation, from initial design to deployment and ongoing maintenance.

• Demonstrated proficiency across all stages of the development cycle for dynamic web projects.

02/2011 – 02/2014

BI Reporting Analyst,

Time Warner Cable

New York, NY

• Engaged with Business Clients and User stakeholders for project initiatives, gathering business requirements, ensuring the completion of development tasks, and overseeing unit and user acceptance testing (UAT) to promote stakeholder satisfaction with project deliverables.

• Authored comprehensive charts and reports in Cognos Report Studio, utilizing multiple databases and automation tools for creating a corporate strategic reporting dashboard.

• Developed and executed Tech-Ops Management Reports according to FCC mandates including Sam Knows and Lifeline initiatives, integrating reporting data from both ICOMS and CSG billing systems.

• Managed the design, development, implementation, and administration of Data Integrity for the Cognos Reporting tool across the organization for the Engineering/Technical Operations Department.

• Aided internal Report/Data Analysts by providing ad-hoc, recurring reports, data analysis, manual SQL queries, and expertise in report authoring using Cognos Report Studio.

07/2004 – 02/2011

BI Developer,

Time Warner Cable

New York, NY

• Delivered daily ad-hoc reports for the Operations, Accounting, Marketing, and Sales Departments.

• Provided Level 3 support for the Production Cognos System, diagnosing and resolving complex query issues reported to the Help Desk.

• Mentored team members on best practices for Cognos Reporting, fostering skills development and collaboration across the organization.

• Executed SQL queries for data validation within Oracle schema- architected data warehouses.

• Designed and authored comprehensive daily, weekly, and monthly reports, facilitating informed decision-making.

09/2003 – 07/2004

Programmer/Analyst,

Time Warner Cable

New York, NY

• Conceived and implemented a Financial Tracking System on the AS400 for the ICOMS Database, enhancing tracking capabilities.

• Acted as the Lead Resource for the S.I. IT Department during the Billing System Conversion from DB2 to Oracle Database, encompassing project management, needs assessment, data cleansing, exception reporting configuration, and deployment.

• Facilitated deployment of multiple functions of the AS400 Client Access, including setting up ODBC communications on local machines for automatic data updates.

02/2000 – 08/2003

Programmer/Analyst,

Best Mfg. Group LLC

New York, NY

• Engineered and maintained the Budget Sales Vs Actual Sales Reporting System for the VP, driving visibility into financial performance.

• Developed and implemented a back-office tracking system on the AS400, which effectively tracked and stored daily customer, invoice, inventory, and accounts receivable details to a local data warehouse for management analytics reporting.

• Supported Sales Department Managers with ad-hoc reports and addressed dynamic requests through direct SQL querying on either the SQL Server or AS400.

• Created ODB procedures within Excel for automatic data refreshes from the DB2 database.

• Coordinated and presented technical cross-training sessions to enhance team capabilities.

• Maintained and supported both manufacturing software packages on the AS400, specifically ABS and RLM.

• Configured, tested, and deployed The Hawkeye Software Package on the AS400, providing training and support for end users. 11/1998 – 02/2000

Programmer/Analyst,

ABC Carpet & Home

New York, NY

• Designed and customized store receipts for ABC Carpet & Home, optimizing the user experience and operational efficiency.

• Configured and programmed Anzac and Fargo printers for barcode printing using TLAshford Software, improving inventory tracking accuracy.

• Developed and maintained The Interactive SKU Inquiry application for Inventory Control, streamlining inventory management processes.

• Rewrote and migrated legacy programs from AS400 to an upgraded AS400 system during the Y2K conversion, ensuring continuity and system integrity.

• Conducted daily maintenance and support for the JDA Retail Software Package on the AS400, enhancing operational reliability. EDUCATION

09/1988 – 05/1990

Technion

Computer Science

HAIFA, Israel

SKILLS

Cognos Report Studio

SQL - RPG

WordPress

Project management

Customer Relations

Problem Solving

Data Analysis

Critical Problem Solving

Project Requirements Analysis

Interface Design

Photo Editing

Copywriting

ETL

Data Cleaning

Data Mining

Data Visualization

Data Quality Assurance

Data Validation

Tableau

Power BI

Analytical Thinking

Extraordinary Communication

Teamwork

Detail Oriented

Database Design

Stakeholder Management

Writing Project Documentation

Interpersonal

Proactive

• Reference is available upon request

Contact this candidate