Crystal Reports Data

Alexander Schulman

**** **** ******* ***** – Atlanta, Georgia 30360 – ***********@*****.*** – 404-***-****

DATA/BUSINESS INTELLIGENCE REPORTS ANALYST/DEVELOPER

Highlights of Qualifications

Programming – Software Development – Reporting Development - Consulting

Expert Systems Development Life Cycle (SDLC) – Data /Business Analysis –

Business Requirements Gathering – Systems Data Analysis – System Migrations and Enhancements.

Rewrote 1,800+ SQL statement with report output in the 12 – 14 minute range to 75 lines of SQL with a sub 30 second response, Competency in complicated joins, views, pivot tables and stored procedure logic used throughout

Created Missing timesheets series of reports to address projects being off budget due to timesheets not being entered on time

Remediated numerous Crystal Reports for Home Depot, under budget and brought response time down by over 90%

Root cause analysis of slow reporting system due to poorly written code - improved output by 200%

Reporting tools – SAP BusinessObjects BI Platform 4.1, Business Objects Web Intelligence, Crystal Reports 2008 v 12, SQL Server Reporting Services 2008/2012/2014(SSRS) CA-IDEAL, RPGII, COBOL

Database platforms – Teradata (Big Data analysis) v 14.11, Epic Cadence, Epic Workbench, Microsoft SQL Server, Oracle SQL

Database tool sets – Netezza, SQL Server 2008 Management Studio, TOAD & TOAD Oracle Optimizer Agent, Business Objects Developer

Database Utilities – SQL, Dell Boomi Atmosphere, JCL, PVCS, MS Office Suite (Word, Excel, PowerPoint, Access, Visio), Erwin, SAP Business Objects

Professional Experience

CDC, Atlanta, Ga June 2016 – Oct, 2016

Crystal Reports/BI reports/Data/ Developer – Contractor

Handled all Report requests for Crystal Reports and/or SQL based reporting needs. Included the following:

Converted numerous SQL statements with hardcoded Physical TEMP tables to Logical TEMP tables to be imbedded in Crystal Reports Command statements.

Data extracted from multiple sources for reporting purposes via SQL extracts to Excel spreadsheets and pivot tables for validation

Created 15+ Crystal Reports for the StarLims system (Laboratory Information Management System)

Modified numerous SQL statements for efficient output and speed of processing.

Established a standard report format for all Crystal Reports for department and updated over 20+ reports to adhere to this departmental reports standard.

Kaiser Permanente, Atlanta, Ga Jan 2016 – May 2016

Epic Consultant Reporting Contractor

Handled all Analytical and Clinical requests for Crystal Reports and/or SQL based reporting needs. Included the following:

Converted over 30 Teradata SQL statements with hardcoded Physical TEMP tables to Logical TEMP tables to be imbedded in Crystal Reports Command statements.

Validated data extracted from converted statements referred to above (converted from HardCoded Physical tables to logical tables from multiple sources by utilizing Excel spreadsheets and pivot tables for validation

Created 20+ Crystal Reports for the Referral module of Epic Clarity

Modified numerous SQL statements for efficient output and speed of processing using Teradata.

Established a standard report format for all Crystal Reports for department and updated over 75+ reports to adhere to this departmental reports standard.

Cox Automotive/Make My Deal.com, Atlanta, GA Sept 2015 –Dec 2015

Business Intelligence Reports Developer/Data Analyst Contractor

Hired as a contractor for a Cox start-up; responsibilities included the following:

Modified Stored Procedures ‘On the Fly’ as data environment was changing on a daily basis to take into account changes to the schema.

Worked in creating 15- 20 SSRS reports from scratch.

Validated all data extracted from schema for data analysis purposes via SQL extracts to Excel spreadsheets and pivot tables for validation

Migrated all reports from a local environment to a cloud based database schema on Amazon Web Services and validated that all reports ‘mirrored’ the existing Legacy reports output.

Modified numerous reports/stored procedures that were not performing properly (slow response time, inconsistent results, poor format of the actual report)

Home Depot, Atlanta, GA,

Senior Crystal Reports/Data Analyst Contractor June 2015 –July 2015

Hired as a contractor for a (1) month job to correct numerous reports/stored procedures that were not performing properly (slow response time, inconsistent results, poor format of the actual report)

Remediated numerous Crystal Reports to improve processing time; Rewrote SQL Stored Procedure to improve processing time from initial pass of 12 – 14 minutes to 45+ seconds.

Improved format by adhering to the company/department standards.

Independent Study – Learning Tableau January 2015 – January 2016

Volunteer work – Berman Commons Retirement Home January 2015 - July 2015

AT & T, Atlanta, GA,

Web Analytics Business Intelligence Analyst Contractor July 2014 – Dec 2014

Handle all Ad-Hoc Query requests for Consumer Digital Experience data reporting needs. Primary point of contact for all requests from all departments dealing with web traffic unique counts, views and chat analysis. Supporting a multitude of user requests for all analysis of web traffic via Business Objects Reporting and Business Objects Web Intelligence reports. Created numerous Business Objects Intelligence reports to adhere to department standards. Design SQL code to extract data as needed for all Ad-Hoc data requests.

Created multitude of SQL extracts to help drive analysis of web traffic.(Big Data)

Validated all data extracted from schema for data analysis purposes via SQL extracts to Excel spreadsheets and pivot tables for validation

Increased throughput of Legacy reports by 25% (average) by optimizing existing code to industry standards

Working with AT&T data warehouse in Teradata to pull customer experience data for analysis.(Big Data analysis)

Dell Secureworks, Atlanta, GA, Sales Analyst Consultant January 2014 – April, 2014

Handle all requests for Global department sales reporting needs. Primary point of contact for all new and updated Salesforce.com SQL Service Reporting Service (SSRS) reports Support multitude of user requests for all SSRS and all Ad-Hoc Query report requests. Create/Modify numerous SSRS reports to adhere to departmental standards. Design SQL code with multiple join statements to extract data.

Created multitude of SSRS SQL code for Ad-Hoc/data requests; SQL Service SQL generated was optimized for performance

Increased throughput of existing reports by 25% (average) by optimizing existing code to industry standards

Used Visio to chart out dependencies and work flows

Self- taught Dell Boomi and ETL tool, to correct a long errored out ETL process and corrected and validated over a million row extract from source DB to target DB via SQL code written for just this error.

Worked with Dell Boomi interface (ETL) tool to streamline numerous processes and extract data from Salesforce DB to Sales Operations DB which improved throughput of data by 50%.

Created multiple Vlookup and Pivot Tables for Excel reports, resulting in a 10% improvement in sales being retained.

Service achievement award for outstanding service – 1st Quarter of 2014

InterContinental Hotels Group, Atlanta, GA July, 2010 – July 2013

Business Intelligence/Senior Applications Consultant

Global Technology Portfolio Management

Handled all requests for Global department reporting needs. Primary point of contact for all new and updated Clarity PPM tool report requests. Supported multitude of user requests for all Crystal Reports and all Ad-Hoc report requests. Modified over 40 + Crystal Reports to bring those all up to departmental standards. Wrote SQL code of a very complex nature with multiple join statements to extract the data needed. Used Business Objects Universes and created hundreds of derived tables.

Created multitude of Oracle SQL code for Ad-Hoc/data requests; Oracle SQL generated was optimized for performance and written in Oracle SQL format using TOAD to help optimize SQL code which increased reporting output by 25% (on average).

Created numerous Clarity PPM reports to drive down cost related to the Portfolio management arena which created savings of 10% off departmental budget

Used Visio to chart out Clarity dependencies and work flows

Created numerous ‘On the Fly’ Crystal Reports for Clarity user community, on time and under budget.

Managed Clarity Business Objects Universe Designer (SAP BO) for numerous derived tables, managed and written by me.

Created numerous Excel pivot tables with Vlookups used throughout.

Improved throughput for all inherited Legacy Clarity offshore developed reports/SQL by 55%.

Debugged/did analysis of numerous Clarity BO WEBI reports. Mostly converted to Crystal Reports.

Initiated numerous ‘deep dive’ data endeavors to assess the nature of the data to remedy Clarity data requests from user community to rationalize data on reports.

Completed many detailed business analysis for all Clarity report requests received.

Georgia Institute of Technology, Atlanta, GA October 2009 – July 2010

Business Intelligence/Database Report Writer Analyst

Parking and Transportation Department

Numerous other positons prior to 2009

EDUCATION

University Of New Orleans, New Orleans, LA

Bachelor of Science in Business Administration with minor in Computer Science

Company Sponsored TrainingUNIX Administrator 1.0, ORACLE Express Foundation, Introduction to PL/SQL, Introduction to Business Objects, multiple PowerBuilder courses; Crystal Reports 8.5, 9.0 & 11 courses; Advanced Query Functions in Crystal Reports; Advanced SQL Tuning

BRD Documentation skills

Contact this candidate