SUMMARY:

• Profound knowledge of Crystal Reports products, all versions
• In - depth knowledge of research methodology and the ability to manage complex data requests
• Sound knowledge of SQL, relational database and advanced SQL queries
• Excellent analytical and troubleshooting skills
• Ability to trace report performance issues to root cause
• Strong project management skills
• Proven skills to properly evaluate and interpret user requirements
• Programming and design skills
• Troubleshooting proficiency
• Vast technical knowledge
• Excellent verbal, written, and presentation skills
• Excellent problem solving skills
• Strong analytical skills
• Technical help desk experience
• Microsoft Office expert

WORK EXPERIENCE:

Production Support - Crystal Report Developer \ SQL Support TTI

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Review of Report with End User for functional testing.
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Supported Crystal report developers by assisting with login issues, connectivity issues and .
• Fundamental SQL proficiency with working knowledge of Stored procedure development and maintenance
• Performed Adhoc queries, reporting and data load functions in SQL Server 2005 and SQL Server 2008
• Development of Tables, SQL/Stored-Procedures, triggers, functions and views.
• Performed data analysis and complex database queries for data validation against systems.
• Monitored batch files and system processes to ensure data integrity.
• Assigned User permissions on SQL server
• Supported application Trading software in production environment.
• Monitor ticket queues and resolve technical operations issues in development, testing, UAT and Production environments.
• Investigated issues with production Trading applications.
• Evaluated and identified data, user and system operating problems.
• Performed production implementations and work with development teams to resolve production issues.
• Responsible for coordinating and executing Disaster Recovery testing.
• Creation of testing scripts for Disaster Recovery Testing.
• Created testing systems for development and testing teams for use in SDLC.

Crystal Report Developer

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Fundamental SQL proficiency with working knowledge of Stored procedure development and maintenance
• Performed data queries, reporting and data load functions in SQL Server 2005
• Development of Scheme, Tables, SQL/Stored-Procedures, triggers, functions.
• Performed data analysis and complex database queries for data validation against systems.
• Review of Report with End User for functional testing.
• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Fundamental SQL proficiency with working knowledge of Stored procedure development and maintenance
• Performed data queries, reporting and data load functions in SQL Server
• Development of Scheme, Tables, SQL/Stored-Procedures, triggers, functions.
• Assigned User permissions on SQL server
• Performed data analysis and complex database queries for data validation against systems.
• Review of Report with End User for functional testing.
• Trained Information Technology Staff on Advanced Crystal Report Writing version 2008.

  Advanced Parameter Use

  Advance Formula Use

  SQL Expressions

  SQL Commands

  Sub Reports

  Cross Tab Reports

  End User Specification Assistance.

  Stored Procedure Development .

  Documentation Procedures.

• System Administrator for LAWSON BUSINESS INTELLIGENCE. Published reports to the Report Server and Scheduled reports.

Crystal Report Developer

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Fundamental SQL proficiency with working knowledge of Stored procedure development and maintenance
• Assisted in developing and designing reports through SSRS.
• Performed data queries, reporting and data load functions in SQL Server
• Development of Scheme, Tables, SQL/Stored-Procedures, triggers, functions.
• Performed data analysis and complex database queries for data validation against systems.
• Review of Report with End User for functional testing.
• Creation of Procedures to move files from development environment to testing environment to production environment.
• Documented processes related to data movement and integration using Visio, and other tools.
• Trained Information Technology Staff on process of moving files from development environment to testing environment to production environment.

Crystal Report Developer \ Trainer

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files and XML data sets.
• Created Custom Report Templates for Use in Crystal Reports version 2008 for improved productivity in report design.
• Utilized Custom Template fields for standard formatting on specific data types for Custom Report Template.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports for use in Elite System 3E.
• Developed Elite System 3E Dashboard Reports using the 3E Application Studio.
• Performed data analysis and complex database queries
• Documented database architecture.
• Review of Report with End User for functional testing.
• Creation of End User Documentation and Materials.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated requirements into design and programming specifications.
• Performed report development following standard Development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Documented processes related to data movement and integration using Visio, and other tools.
• Trained Information Technology Staff on Advanced Crystal Report Writing version 2008.

  Advanced Parameter Use

  Advance Formula Use

  SQL Expressions

  SQL Commands

  Sub Reports

  Cross Tab Reports

  End User Specification Assistance.

  Stored Procedure Development .

  Documentation Procedures.

• Tested System Process flows for QA testing.
• Created end user instructions from system process flows.
• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Fundamental SQL proficiency with working knowledge of Stored procedure development and maintenance
• Designed and developed reports through SSRS.
• Performed data queries, reporting and data load functions in SQL Server
• Development of Scheme, Tables, SQL/Stored-Procedures, triggers, functions.
• Performed data analysis and complex database queries for data validation against systems.
• Review of Report with End User for functional testing.
• of Crystal report running on a Web based application for plant staff
• Business-Objects Administration which consisted of Planning, Administration and Maintaining Business Objects folder hierarchy and security.

  Defining security configuration settings such as the Primary Authentication System and security integration

  Configuring and initiating user imports from Active Directory

  Defining password administration rules

• Documented processes related to data movement and integration using Visio, and other tools.
• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Review of Report with End User for functional testing.
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Created Custom Report Templates for Use in Crystal Reports version 2008 for improved productivity in report design.
• Utilized Custom Template fields for standard formatting on specific data types for Custom Report Template.
• Trained Information Technology Staff on Advanced Crystal Report Writing version 2008.

  Advanced Parameter Use

  Advance Formula Use

  SQL Expressions

  SQL Commands

  Sub Reports

  Cross Tab Reports

  End User Specification Assistance.

  Stored Procedure Development .

  Documentation Procedures.

  Utilizing SAP Business One with Crystal Reports.

Crystal Report Developer \ SQL Development

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Created Custom Report Templates for Use in Crystal Reports version 8.5 for improved productivity in report design.
• Utilized Custom Template fields for standard formatting on specific data types for Custom Report Template.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Creation of ASP pages
• Performed data queries, reporting and data load functions in SQL Server
• Development of Scheme, Tables, SQL/Stored-Procedures, triggers, functions.
• Assisted in developing and designing reports through SSRS.
• Performed data analysis and complex database queries
• Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated requirements into design and programming specifications.
• Obtained and documented reporting requirements for various departments
• Review of Report with End User for functional testing.
• Creation of End User Documentation and Materials.
• Created Documentation which consisted of application requirements, specification and testing documents.

Crystal Report Developer \ SQL Development Robert Half Technology Consulting

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Created Custom Report Templates for Use in Crystal Reports version 8.5 for improved productivity in report design.
• Utilized Custom Template fields for standard formatting on specific data types for Custom Report Template.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Creation of ASP pages
• Performed data queries, reporting and data load functions in SQL Server
• Development of Scheme, Tables, SQL/Stored-Procedures, triggers, functions.
• Assisted in developing and designing reports through SSRS.
• Performed data analysis and complex database queries
• Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Review of Report with End User for functional testing.
• Tested Radio Beacon System prior to going live using testing documentation and working with end users for stringent testing.
• of Company staff on MAS500 and Radio Beacon systems.

Crystal Report Developer \ SQL Development\ QA Sedna Consulting Group Consulting

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, and graphical reports, formula based, drill-down reports, analysis reports and data reports.
• Created Custom Report Templates for Use in Crystal Reports version 10 for improved productivity in report design.
• Utilized Custom Template fields for standard formatting on specific data types for Custom Report Template.
• Performed report development following standard development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Expert analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Proven skills to properly evaluate and interpret user requirements.
• Translated end user reporting requirements into technical design documents.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Creation of End User Documentation and Materials.
• Creation of ASP pages
• Performed data queries, reporting and data load functions in SQL Server
• Development of Scheme, Tables, SQL/Stored-Procedures, triggers, functions.
• Assisted in developing and designing reports through SSRS.
• Performed data analysis and complex database queries
• Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Review of Report with End User for functional testing.
• Creation of Oracle Stored Procedures
• Validation of Oracle Stored Procedures
• Worked with Testing team for validation of reports in the user interface
• Maintenance and support of reporting solutions using Crystal reports and Crystal Reports Enterprise Manager
• Interfaced with IS department to resolve system issues
• Trained in house staff on Crystal Enterprise and Crystal Reports
• Crystal Enterprise Administration which consisted of Planning, Administration and Maintaining Crystal Enterprise folder hierarchy and security.
• Crystal Enterprise Security Concepts
• Managing User Accounts and Groups, Folder Objects, Report Objects, Instances and Events
• Configuring Servers and Server Groups
• Publishing Objects to Crystal Enterprise
• Importing Objects to Crystal Enterprise
• Working with the Crystal Repository

Crystal Report Developer

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions using Crystal Reports version 8.5 for reporting module in software application ASSET POINT
• Created Custom Report Templates for Use in Crystal Reports version 8.5 for improved productivity in report design.
• Utilized Custom Template fields for standard formatting on specific data types for Custom Report Template.
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, graphical reports, formula based, drill-down reports, analysis reports and data reports
• Performed report development following standard Development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Performed data queries, reporting and data load functions in SQL Server 2005
• Development of Scheme, Tables, SQL/Stored-Procedures, triggers, functions.
• Performed data analysis and complex database queries
• Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Obtained and documented reporting requirements for various departments
• Translated requirements into design and programming specifications.
• Defined test plans and coordinating user acceptance testing of deliverables.
• Review of Report with End User for functional testing.
• Creation of End User Documentation and Materials.
• Created Documentation which consisted of application requirements, specification and testing documents.
• Performance tuning of stored procedures and reports.
• Worked with Testing team for validation of reports in the user interface
• Crystal Enterprise Administration which consisted of Planning, Administration and Maintaining Crystal Enterprise folder hierarchy and security.
• Crystal Enterprise Security Concepts
• Managing User Accounts and Groups, Folder Objects, Report Objects, Instances and Events
• Configuring Servers and Server Groups
• Publishing Objects to Crystal Enterprise
• Importing Objects to Crystal Enterprise
• Working with the Crystal Repository
• Interfaced with IS department to resolve system issues
• Trained in house staff on Crystal Enterprise and Crystal Reports

Report Writer \ Corporate Trainer

Confidential

Responsibilities:

• Creation of New reports utilizing crystal command files, stored procedures, views, custom tables and functions .
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, graphical reports, formula based, drill-down reports, analysis reports and data reports using Business Objects Crystal Reports
• Obtained and documented reporting requirements for various departments
• Project Lead on implementation of software applications.
• Technical Support for software application.
• Identified system opportunities and issues. Performed root cause analysis to determine best corrective action.
• Interfaced with IS department to resolve system issues
• Developed Microsoft Access Database's, queries, forms, reports, and macros to be utilized by site.
• Technical writing for end user instructions, software specifications, and application layout(s).
• Data Analysis. Testing of software applications for software upgrades and rollouts.
• Trained corporate staff on SOP's, Job Aids and software applications.

Report Writer / Analyst Kforce--Consulting

Confidential

Responsibilities:

• Created Custom Report Templates for Use in Crystal Reports version 7 for improved productivity in report design.
• Relational database experience utilizing SQL, Oracle Data Analysis
• Creation of SQL Views, Tables and Stored Procedures
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, graphical reports, formula based, drill-down reports, analysis reports and data reports
• Performed data analysis and complex database queries
• Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated requirements into design and programming specifications.
• Performed report development following standard Development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Obtained and documented reporting requirements for various departments

Report Writer / Analyst

Confidential

Responsibilities:

• Created Custom Report Templates for Use in Crystal Reports version 7 for improved productivity in report design.
• Relational database experience utilizing SQL, Oracle Data Analysis
• Creation of SQL Views, Tables and Stored Procedures
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, graphical reports, formula based, drill-down reports, analysis reports and data reports
• Performed data analysis and complex database queries
• Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated requirements into design and programming specifications.
• Performed report development following standard Development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Obtained and documented reporting requirements for various departments
• Designed Intranet reporting structure using Front Page
• Published reports to Intranet Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Converted, ongoing maintenance and enhancements to previously established reports
• Performed data analysis and complex database queries
• Utilized Seagate Info to automate report distribution to various departments
• Created Access databases, reports and forms for Customer Service

Report Writer / Desktop Support MODIS-Consulting

Confidential

Responsibilities:

• Created Custom Report Templates for Use in Crystal Reports version 6 for multiple client sites.
• Relational database experience utilizing SQL, Oracle Data Analysis
• Creation of SQL Views, Tables and Stored Procedures
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, graphical reports, formula based, drill-down reports, analysis reports and data reports
• Performed data analysis and complex database queries
• Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated requirements into design and programming specifications.
• Performed report development following standard Development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Obtained and documented reporting requirements for various departments
• Usability testing on multiple applications
• Created and maintained Access databases for department
• Performed data analysis and complex database queries.
• Provided telephone and desktop support of software and hardware problems
• Proven ability to clearly explain and guide users through necessary steps to obtain desired results Support of Seagate Crystal Reports, Justice Trax, Pathassist, Microsoft Office Suite, Windows 3.1, Windows NT, Windows 95, Windows 98, Intranet Assigned jobs to the appropriate technicians

Report Writer / Desktop Support PC Help Services-Consulting

Confidential

Responsibilities:

• Relational database experience utilizing SQL, Oracle Data Analysis
• Creation of SQL Views, Tables and Stored Procedures
• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, graphical reports, formula based, drill-down reports, analysis reports and data reports
• Performed data analysis and complex database queries
• Ensured the integrity and availability of data and reports published to the Intranet and Software applications
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated requirements into design and programming specifications.
• Performed report development following standard Development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Obtained and documented reporting requirements for various departments
• Performed data analysis and complex database queries Maintained databases for department through Access / DK Help Desk
• Provided telephone and desktop support of software and hardware problems
• Proven ability to clearly explain and guide users through necessary steps to obtain desired results Support of Seagate Crystal Reports, Microsoft Office Suite, Windows 3.1, Windows NT, Windows 95, Windows 98, Intranet Lotus Smart Suite, AS400 applications Assigned jobs to the appropriate technicians
• Responsible for installation and maintenance of all computer hardware and software
• Purchased and received company computer equipment
• Created help desk user manual, currently being used by department

Management Information Systems Supervisor

Confidential

Responsibilities:

• Development and modifications to a wide spectrum of complicated reports including sub-reports, parameterized reports, graphical reports, formula based, drill-down reports, analysis reports and data reports
• Performed data analysis
• Worked with Application Leads and Business partners to gather and analyze business requirements.
• Translated requirements into design and programming specifications.
• Performed report development following standard Development lifecycle (Requirement Analysis, Design, Construction, Testing & Implementation).
• Obtained and documented reporting requirements for various departments
• Utilized report writer to provide tools and information for company
• Trained company staff on software applications
• Provided and maintained system documentation
• Responsible for installation of all computer hardware and software
• Usability testing on multiple applications, supervision on system tests, analyzed results and directed maintenance action
• Responsible for maintenance contracts for hardware and peripheral equipment
• Provided telephone and desktop support of hardware and software problems