SUMMARY:

• Strong programming, problem solving and organizational skills proven in a fast paced environment.
• Detailed - oriented, meet deadlines and superior troubleshooter.
• Perform well as a team player or independently.
• Currently updating my skills with SQL Server, SSRS 2008R2 and SharePoint 2010 BI.

PROFESSIONAL EXPERIENCE:

Contract Data Analyst / Report Developer (SSRS)

Confidential

Responsibilities:

• Modified existing reports in SSRS 2005 in SQL Server Management Studio 2005. The front end application was Dynamic AX 4.0.
• Created new reports requested by stakeholder in the company. Gathered specifications, generated report layout and went over design with client. Once report finalized moved to test for user testing.
• Deployed reports to SSRS report server in test and production.
• Created report documentation, standards and schemas stored on network drive.
• Saved reports and report SQL, parameter SQL and table creation SQL on same network drive.

Contract Data Analyst / Report Developer (SSRS)

Confidential

Responsibilities:

• Modified existing reports in SSRS 2005 in SQL Server Management Studio 2005. The front end application was Dynamic AX 4.0.
• Deployed reports to SSRS report server in test.
• Created documents for DBA to deploy reports to both STAGE and QA databases and report server.
• Converted reports to new reporting standards that included linking to other reports, subscriptions, saving user selected parameter defaults and created stored procedures for both parameter dropdown and main SQL code.
• Worked with the BI group to get reports working from ProClarity.
• Attended daily scrum meetings.

Contract Data Analyst / Report Developer

Confidential

Responsibilities:

• Used Enterovision Insight to run reports created in Crystal 10 against an Oracle 10 database.
• Built the SQL code using Toad for Data Analysis 2.1. This SQL code was then either integrated into Crystal 10 in the command file or stored in a package within Oracle.
• For the SQL code in a package used PL/SQL to create the code. Created and deleted tables, inserted data, updated and deleted existing records in the tables.
• Within Insight, edited, cloned report definitions, exported the XML code and created parameters.
• Updated the excel spreadsheet to document information about the reports for use by auditors.
• Maintained the each report folder which stored the report, xml code for Insight, the SQL build code in the body file, the create package SQL code, xml file, table creation SQL, synonym creation SQL file and the report document with all of the files for the report listed in it. Also created a PKG file which stored the spec, body and synonym files together so the DBA’s only had to run this file to create the package.

Contract Data Analyst / Reports Developer (SSRS)

Confidential

Responsibilities:

• Created new SQL Reporting Services 2005 reports using SQL Server Management Studio 2005. SQL code stored in the reports data tab or stored procedures. These reports were used on the SharePoint portal.
• Converted Crystal Reports 8.0 to SQL Reporting Services 2005.
• Maintained SSRS reports by fixing errors, making requested changes and doing cleanup of reports.
• Deployed SSRS reports to report server in development, sandbox (testing) and production environments.
• Modified security in Report Manager for the reports.
• Kept track of user requested work orders in Track-It 8. Logged technician notes, saved emails and any other information about the work order.
• Utilized the Visual ERP system SQL 2005 database.

Data Analyst / Report Developer

Confidential

Responsibilities:

• Generated reports in SQL Server 2005 Reporting Services for use in Dynamics AX 4.0. These reports used stored procedures and functions created in SQL Server Management Studio 2005.
• Uploaded the SQL Server Reporting Services reports to the report server so report could run on web pages.
• Created reports using PowerBuilder’s Infomaker report services version 10. Reports used in Enterovision, OMS and Cobra applications.
• Utilized Toad for SQL Server and Oracle to create SQL queries to be used in reports that ran against SQL Server 2005 and Oracle databases.
• Built and maintained reports in Crystal 8.5 for MAS 200 accounting application, Crystal 10 for Solomon 6.0 accounting application and XI for smaller internal applications.
• Modified and created reports in Dynamics AX 4.0 reporting services to run within the Dynamics ERP system.
• Linked SQL Server reporting services reports to Dynamics AX 4.0 so users could run these reports within the AX system.
• Used Visual Source Safe to manage project objects.
• Managed service requests through Magic Incident application.

Report Writer

Confidential

Responsibilities:

• Gathered user requirements, developed and maintained Crystal Reports 10 - XI programs for pharmacy sales and production reports, graphs, spreadsheets and/or data feeds.
• Created and tested SQL queries against MySQL databases in MySQL Front application
• Proficient with sub reports, cross-tab, arrays, command files, charts, formulas, multiple parameters, group levels, bar codes and ODBC database connections
• Provided database schemas with data modeling application
• Overcome MySQL’s inability to use sub-queries, views or stored procedures by use of the sub-report, command file and SQL expression features in Crystal Reports
• Implemented and tested Crystal Reports Server XI for future deployment.

Contract Report Writer

Confidential

Responsibilities:

• Gathered user requirements, created and maintained Accounting, Sales and Quote reports using Crystal Reports 8.5 with SQL Server, MAS500, an Accounting software package and Sales Logic, a Quote software package

Network Administrator

Confidential

Responsibilities:

• Resolved general network and PC problems for 60 users.
• Upgraded software on server and user machines.

Contract Programmer/Analyst

Confidential

Responsibilities:

• Lead a two-person team that analyzed change requirements and developed a project, which automated data storage for the City Scrap Hauls and Green Box program.
• Overcame the challenge of assuming lead of a two person team part way through the project
• Met weekly with clients to clarify change requirements and present progress reports and demonstrations
• Recommended database changes which allowed for increased optimization
• Created multiple forms utilizing Visual Basic 6, ADO 2.5 / 2.6, MTS and DCOM objects
• Used Visual SourceSafe to manage project.
• Developed and modified reports in Crystal Reports using SQL queers on an Oracle database

Contract Programmer/Analyst

Confidential

Responsibilities:

• Developed reports using Visual Basic 6 with ADO 2.1 and DCOM objects to generate reports.
• Produced year-end reports in Seagate Crystal Reports 7 using sub reports, group levels, OLE DB connection to an Oracle database, Design Query and Report Designer Component (RDC).
• Used Visual SourceSafe to manage Visual Basic project changes.
• Generated ttx files to be used in Crystal Reports to allow Visual Basic to pass record sets to reports.
• Utilized function calls in Visual Basic for commonly used procedures.
• Used TOAD application to view table structures and create SQL queries for testing against the Oracle database.
• Created generic Search routine to locate any record in a database that matched the inputted string.
• Inserted MTS code into DCOMS to bring project up to code standards.
• Modified ASP and HTML code in Visual InterDev environment to add enhancements to Web pages.

Contract Maintenance Programmer

Confidential

Responsibilities:

• Troubleshooting issues over the phone, to resolve occurrences as quickly and efficiently as possible.
• Resolved incidents by fixing Access 97 database, Crystal Report and Visual Basic program errors.
• Developed procedures, which enabled office staff to help solve problems by having them, execute Access 97 queries, perform backups and email all information about problem.

Contract Programmer/Analyst

Confidential

Responsibilities:

• Programmed Oil and Gas, land and accounting applications in Visual Basic 6.0 using ADO 2.5 and DBGrids to produce a user-friendlier product.
• Utilized Access 97 databases to create and modify queries and tables; programmed in VBA.
• Created reports in Seagate Crystal Reports 6.0 and 7.0 utilizing sub reports, cross-tab, graphs, group levels and ODBC database connections to produce appealing reports.
• Designed and developed customer product system in Access to track user software.
• Performed testing and debugging on new and existing Visual Basic applications and Crystal Report to eliminate errors.
• Installed client software on-site and remotely to keep their systems current.
• Worked with Relational Databases in Access 97 using SQL.