SKILLS:

• Total report writing experience (SQL, Crystal Reports, Business Objects, Confidential, MS Excel, MS Access, Confidential / AS/400)
• Microsoft SQL Server 2000 - 2012
• Crystal Reports 9 - XI report development
• Executives level reporting
• Business Objects report development
• Budgeting
• Confidential / AS400 report writing
• Business Objects Universe Design
• Business Objects 4.1 report development
• Dashboards - Confidential
• MicroStrategy report development
• Centricity Practice Solution 12 reporting

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, AZ

Business Intelligence Developer

Responsibilities:

• Visualize data via Dashboards using Confidential, Universe Design and Report development.
• Develop complex reports utilizing Salesforce Einstein, SAP Business Objects.
• Collaborate with multiple business leaders and the external client to define the business requirements.

Tools: Utilized: SAP Business Objects Information Design Tool (IDE), Business Objects 4.2, Confidential, Oracle SQL, T - SQL, Salesforce, Salesforce Einstein

Confidential, Tonopah, AZ

Business System Analyst Objects Report /Universe Designer

Responsibilities:

• Develop complex reports with drill downs utilizing SAP Business Objects Information Design Tool (IDE), WEBI, and Confidential .
• Collaborate with multiple business leaders to define the business requirements.

Tools: Utilized: SAP Business Objects Information Design Tool (IDE), Business Objects 4.1, Confidential, Informatica, Oracle SQL

Confidential, Phoenix, AZ

Sr. Financial Analyst

Responsibilities:

• Compile a customer hierarchy and assigned a unique value to each in-order to reconcile accounts across multiple platforms (QuickBooks, Salesforce, Facebook, and Google).
• Utilized excel pivot tables, macros, and access databases to automatically generate monthly reports.
• Prepare, validate and Distribute Month End reports, in addition to customer invoices.

Tools: Office 360, Excel, Access, and Share Point

Confidential, Tempe, AZ

Business Analyst

Responsibilities:

• Utilized MicroStrategy, Oracle SQL, Access, Excel, and Automate 10 in-order to re-create both daily and month end reports.
• I had to write stored procedures in Oracle SQL, use windows batch files to Confidential the data, create Macros in Automate 10 to update access databases, create access databases to prepare the data for reporting and finally setup excel to pull the data from access because customer had a specific excel templets that they just wanted updated for reporting purposes.
• Develop Standard Operating Procedures (SOP) for both Finance and Manufacturing departments.
• Participated in multiple audits and supplied reports as requested.
• I also prepare, validated, and distribute both daily and month end reports.

Tools: Utilized: MicroStrategy, Oracle SQL, Access, Excel, and Automate 10, and Windows Batch Files.

Confidential, Phoenix, AZ

Sr. Revenue Analyst

Responsibilities:

• Prepare, validated, and distribute daily and month end reports. Create ad-hoc reports as request for senior executives.
• Recreate current report from Cognos to Crystal reports. Write TSQL stored procedures for Month End Reports.
• Train both senior executives (1 on 1) and other departments (group and via WebEx) on using new reporting tools.
• Develop Standard Operating Procedures (SOP) for reporting team.

Tools: Utilized: Crystal Reports XI (11), SQL server 2012, Excel 2010, Cognos 8, Centricity Practice Solution 12

Confidential, Scottsdale, Arizona

Business Intelligence Report Developer

Responsibilities:

• Upgrade from Business Objects XIR2 to Business Objects 4.1
• Upgrade from Crystal Reports XI (11) to Crystal Reports 2013 (version 14)
• Gather requirements for senior executive reporting projects
• Gather requirements for field manager reporting projects
• Conduct meetings with executives and senior management to determine the data that they need to see in reports (Executive Metrics reports)
• Work as the liaison between the technical team and the executives
• Manage projects relating to reporting
• Create executive metrics reports that pulls information from various sources ( Confidential AS/400 Billing System, Confidential 2008, SQL Databases (2005, 2008 & 2012) writing T-SQL, Crystal Reports 11, Business Objects 4.1, Business Objects XIR2, MS Excel Live Office, ETL - both batch files and SQL Data Transformation Services (DTS), data warehousing)
• Combine data from various sources into a single executive report
• Create executive reports that include but is not limited to the following:

Confidential

Responsibilities:

• Perform QA and UAT testing on Business Objects Universes (4.1 and XIR2)
• Create complex reports that test each dimension, measure, filter, prompt, and join in newly created Business Objects Universes
• Document QA and UAT testing results
• Work with the Business Objects Universe designers and explain how the data links to each table to ensure that the joins are created properly (inner vs. outer, one-to-many vs. one-to-one, etc.)
• Perform detail analysis all reports to ensure quality and consistency of data
• Participate in all internal and external audit requests from both upper management and state and federal government (SOX) while supplying reports as needed
• Gather requirements from end users and create new reports in Business Objects 4.1 and Crystal Reports XI (11)
• Edit existing Business Objects reports and Crystal Reports
• Create reports using SQL Server Reporting Services (SSRS) for SharePoint
• Create and edit existing stored procedures in MS SQL Server 2005 &2008 using temp tables, unions, joins, and case statements; work with 7 million + records
• Create, modify, and export reports in Confidential
• Setup, maintain, run, reconcile, and distribute all month end reports for the finance department and upper management executives

Tools: Utilized: Confidential 2008, Crystal Reports 9 - XI (11), SQL server 2000 - 2008, MS Excel 2010, MS Access 2010, Business Objects 4.1, MS Excel, Confidential / AS/400, SQL Data Transformation Services (DTS)