TECHNICAL SKILLS:

• Microsoft SQL Server DBA 2000, 2005, 2008. 7 years.
• SQL Server 2005 - 2008 Business Intelligence, SSIS, DTS, Stored Procedures, Backup/Restore, Performance Tuning. Database Design, Stored Procedures, Views, Table Index Creation.
• Microsoft NT Server 2000 and 2003. 5 years.
• AS400 Database Administration. Query 400. 7years.
• Data Analyst and Data Migration Specialist from all database platforms. 20 years.
• Office 95,97,2000, 2003, 2008 XP Windows 7. 15 years.
• MS Access developer 2000, 2003, 2008. 12 years.
• Crystal Report Professional 8.5 - 2013 . 15 Years.
• Crystal Report Server XI. V3r3. V4.0 BO Views, Universes, LOV’s.
• Webi, Deski. CMC. Infoview. 6 years.
• Code, test and debug reports. Test java and dot.net applications to verify reports. 2 years.
• Technical documentation and specifications for all reports. 10 years.
• Production support of all Crystal and BO related issues. 10 years.

PROFESSIONAL EXPERIENCE

Confidential OH

Sr Crystal Report Developer

Responsibilities:

• Crystal Report - 2014 SAP BO Versions 4.0. Infoview. CMC. Report Publishing and Scheduling.
• Oracle 11G databases. Stored Procedures. Materialized View Creation.
• Senior Report designer for Filnet Upgrade project. 20 Crystal Reports
• Started my own company doing short term reporting projects and remote support.
• 2 month Crystal Report Development C2C contract with Vyshnavi Infotech Inc.
• Crystal Reports 2008/2012.
• Created and Modified Crystal Reports for Facets 5.0.
• SAP BO Versions 3.X and 4.0. Infoview. Report Publishing.

Confidential 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
• 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, OH

Business Analyst/ Crystal Reports Developer

Responsibilities:

• Liaison between production teams, financial 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.
• Report Testing, Evaluation and Change Coordination.
• Report Development for Clarity and SRM Software.
• Life Cycle Manager and Import Wizard.
• 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.
• 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 Honda Project Managers.
• Crystal reports training and training documentation.

Confidential, 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, 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.

Confidential NJ.

Business Analyst/ Senior Crystal Report Developer

Responsibilities:

• WMS Implementation Project. Senior Crystal Reports 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 XI development for Manhattan and Associates WM open series software product. Crystal Reports development including sub reports, selection formulas, conditional formatting and Command Objects.
• Optimization of Crystal Reports using SQL Server 2000-2005 DTS/SSIS packages.
• Creation of complex SQL Queries against relational or dimensional databases.
• Crystal report XI server administration including Manhattan and Associates PM product. Extensive use Oracle 10G and SQL Server tables and views for Report Development.
• PM and LM reporting.
• Achievement Created 20 DataMart Report using SQL Server BI SSIS packages that were critical for end of year processing.
• Debugged Manhattan ETL packages for nightly transfer of data for PM Analytics

Confidential, Joseph, MI

Business Analyst/ Senior Crystal Report Developer.

Responsibilities:

• Business Objects 3.2 Installation and Administration. Views, Universes, Dynamic Prompts.
• Senior GIS Developer.Crystal Reports XI development for Manhattan and Associates WM open series software product.
• Crystal Reports development including sub reports, selection formulas, conditional formatting and Command Objects. Optimization of Crystal Reports.
• Creation of complex SQL Queries against relational or dimensional databases.
• Crystal report XI server administration including Manhattan and Associates PM product.
• Extensive use Oracle 10G and SQL Server tables and views for Report Development. PM and LM reporting.
• WM Implementation Project. Crystal Reports XI development for Manhattan and Associates WM open series software.
• Crystal Reports development including sub reports, selection formulas, conditional formatting and writing Command Objects.
• Optimization of Crystal Reports. Business Objects Universe Design, Web Intelligence, and / or OLAP Intelligence.
• Creation of complex SQL Queries against relational or dimensional databases.
• Crystal report XI server administration including Manhattan and Associates PM product.
• Extensive use of DB2, SQL Server 2000 tables and views for Report Development. Implementation of Data Marts and Star Schema Models.