TECHNICAL SKILLS:

• Crystal Reports Professional 6.5 - 2016. 15 Years.
• Bartender Label Creation. Bartender Commander. 4 years.
• Crystal Reports Expert at Converting Older versions of Crystal Report to new version with SQL commands or Stored Procedures.
• Crystal Reports Server BOXI. V3r3. V4.2 BO Views, Universes, LOV’s. Webi, Desk . Infoview.
• CMC, Import Wizard, Life Cycle Manager
• Microsoft SQL Server DBA 2000, 2005, 2008, 2014, 2016. 10 years.
• Oracle Database SQL and stored procedures version 8i - 11g. Oracle Stored Procedures. TOAD, AQT.
• MS Office SharePoint for Report Documentation, Ticketing, Project Tracking, Project Documentation
• SQL Server 2000-2008 Business Intelligence, SSIS, DTS, Stored Procedures, Backup/Restore, Performance Tuning. Database Design, Stored Procedures, Views, Table Index Creation.
• Microsoft NT Server 2000, 2003, 2008. 5 years.
• AS400 Database Administration. Query 400. 7 years.
• Data Analyst and Data Migration Specialist from all database platforms. 20 years.
• Office 95,97,2000, 2003, 2008 XP Windows 7, 8, 10. 15 years.
• MS Access developer 2000, 2003, 2008. 12 years.
• AS400 Administration. AS400 reporting for Manhattan and Associates PKMS.
• Technical documentation and specifications for all reports. 15 years.
• Production support of all Crystal and BO related issues. 15 years.

GENERAL EXPERIENCE:

Confidential, Columbus, OH

Crystal Report Developer

Responsibilities:

• Crystal Reports upgrade from XI to Version 2013 and 2016.
• Conversion of MS Access Database Applications to Crystal Reports.
• Radius and Progress Database Stored Procedures and SQL Coding for new reports.
• Crystal Reports Labels.
• Replace existing table joins with Progress SQL.
• Design technical specifications for all existing Crystal Reports.
• Route reports changes through appropriate channels.
• Data Analyst/Tester/Business Analyst as required.

Confidential, Bradley, IL

Crystal Reports Developer

Responsibilities:

• Crystal Report upgrade and modification. V4BRR, V4BREXR, V4MBR and V4CRITICALPARAMETER report from Werum MES PAS 4.x system.
• Modify V4BRR report containing 35 subreports.
• Replace existing table joins with Oracle SQL. Oracle 11i. stored procedures.
• Design technical specifications for all new reports.
• Design technical specifications for all existing Version 4 reports.
• Route reports changes through appropriate channels.
• Data Analyst/Tester/Business Analyst as required.

Confidential, Peoria, IL

Crystal Reports Developer

Responsibilities:

• Configuration Synergy Insurance System.
• SQL Server 2014 Creation of Stored Procedures and Views for reporting.
• 2016 Visual Studio Source Control using Microsoft Visual Studio Dot Net platform.
• Configuration of C# Application for reporting.
• Data Analyst/Tester/Business Analyst as required.
• Current Contract ended on 02/15/2017. Project completed.

Confidential, Reynoldsburg, OH

Sr Crystal Report Developer, SQL Server Database Analysis, Business Analyst

Responsibilities:

• MS Office SharePoint for Report Documentation, Ticketing, Project Tracking, Project Documentation
• SAP BO Versions 3.1. Infoview. CMC. Report Publishing and Scheduling.
• SQL Server 2012. Stored Procedures. Materialized View Creation.
• AS400 reporting for COINS warehouse system.
• Senior Report designer for HIGHJUMP WMS Implementation.
• HIGHJUMP SQL Servers/IIS/Application Servers.
• 20 Crystal Reports designed from scratch.
• Bartender Label Software Expert. 12 Labels designed from scratch.
• Business Analyst, Data Analyst, Tester.

Confidential, Columbus, OH

Sr Crystal Report Developer

Responsibilities:

• MS Office SharePoint for Report Documentation, Ticketing, Project Tracking, Project Documentation
• SAP BO Version 4.0. Infoview. CMC. Report Publishing and Scheduling.
• Oracle 11G databases. Stored Procedures. Materialized View Creation.
• Senior Report designer for FileNet Upgrade project.
• 20 Crystal Reports designed and optimized.

Confidential, Kansas City, MO

Business Analyst/ Data Analyst/ Crystal Reports Developer

Responsibilities:

• Started my own company doing short term reporting projects and remote support.
• Crystal Reports 2008/2012.
• Created and Modified Crystal Reports for Facets 5.0.
• SAP BO Versions 3.X and 4.X Infoview. Report Publishing.
• MS Office SharePoint for Report Documentation, Ticketing, Project Tracking, Project Documentation

Confidential, Kansas City, MO

Business Analyst/ Crystal Reports Developer

Responsibilities:

• Liaison between marketing team, financial teams and Crystal Reports developers.
• Business Analysis including Report Specification Creation and Technical Documentation.
• Technical Support of all outstanding Crystal Reports related tickets. Closed approximately 100 tickets and help desk requests
• MS Office SharePoint for Report Documentation, Ticketing, Project Tracking, Project Documentation/
• Created technical solutions for end user requests and documented project assignments.
• Provided technical solutions for specific projects requiring business solutions.
• Report Testing, Evaluation and Change Coordination.
• Created Crystal Reports for Facets 5.0. Blue Q. and Direct Pay Marketing Application.
• 4DX training.
• EDW Data Warehouse and PeopleSoft Crystal reporting.
• Crystal Reports 2008/2012.
• Crystal Reports development including sub reports, selection formulas, conditional formatting and command Objects.
• SAP BO Versions 3.X and 4.0. Infoview. Report Publishing.
• MS SSIS 2008 package creation to increase reporting efficiency.
• Webi and Deski report conversion.

Confidential, Marysville, OH

Business Analyst/ Crystal Reports Developer

Responsibilities:

• Liaison between production teams, financial teams and Crystal Reports developers.
• MS Office, Share-point for Report Documentation, Ticketing, Project Tracking
• Business Analysis including Report Specification Creation and Technical Documentation.
• Technical Support of all outstanding Crystal Reports related tickets.
• Created technical solutions for end user requests and documented project assignments.
• Business Objects 3.X and 4.1.
• Report Testing, Evaluation and Change Coordination.
• Report Development for Clarity and SRM Software.
• Life Cycle Manager and Import Wizard.
• Clarity Project for Accounting and Finance Department.
• Assisted Java developers with report testing for newly created application.
• SQL Server 2005-2008 DTS to SSIS Migration. Maximo Project. HR Project.
• Crystal Reports 2008-2012. Infoview. CMC.
• Crystal Reports development including sub reports, selection formulas, conditional formatting and Command Objects.
• Project evaluations for contract bidding.
• Crystal Reports and Business Objects. Training of L&T staff and Confidential Project Managers.
• Crystal reports training and training documentation.

Confidential, Milwaukee, WI

Business Analyst/ Crystal Reports Developer

Responsibilities:

• Liaison between production team and Crystal Reports developers.
• Business Analysis including Report Specification Creation and Technical Documentation.
• Technical Support of all outstanding Crystal Reports related tickets.
• Created technical solutions for end user requests and documented project assignments.
• Provided technical solutions for specific projects requiring business solutions.
• SAP ME Integration Project. ODS Database Tables.
• SQL Server 2005-2008 SSIS Packages.
• Crystal Reports 2012 SAP.
• Business Objects 3.2. Views, Universes, Dynamic Prompts.
• Crystal Reports development including sub reports, selection formulas, conditional formatting and Command Objects. Business Analyst including Report Specification Creation. Report Testing.
• Evaluation and Coordination with End Users. MS SSIS 2005 package creation for report testing.

Confidential, Columbus, OH

Business Analyst/ Senior Crystal Report Developer

Responsibilities:

• Liaison between warehouse teams and SEDLAC contractors.
• Business Analysis including Report Specification Creation and Technical Documentation.
• Technical Support of all outstanding Crystal Reports related defects.
• Created technical solutions for end user requests and documented project assignments.
• Provided technical solutions for specific projects requiring business solutions.
• WM (Manhattan and Associates) Warehouse Software.
• PM Reporting off of Oracle 10G Database.
• Crystal Reports 2008 development including sub reports, selection formulas, conditional formatting and Command Objects.
• Business Objects 3.2. Views, Universes, Dynamic Prompts.
• PL/SQL Oracle 10G queries and stored procedures.
• Business Analyst including Report Specification Creation. Report Testing, Evaluation and Coordination with End Users.

Confidential, Sarasota, FL

Business Analyst/ Senior Crystal Report Developer

Responsibilities:

• Senior Crystal Report Developer.
• Liaison between application design teams and Crystal Reports developers.
• Business Analysis including Report Specification Creation and Technical Documentation.
• Technical Support of all outstanding Crystal Reports related tickets.
• Created technical solutions for end user requests and documented project assignments.
• Provided technical solutions for specific projects requiring business solutions.
• Crystal Reports development including sub reports, selection formulas, conditional formatting and Command Objects. PL/SQL Oracle 10G queries and stored procedures.
• Extensive optimization and creation of Oracle Stored Procedures.
• Oracle Scripts and Function creation.
• Report Testing, Evaluation and Coordination with End Users.