SUMMARY:

Self - starter who can provide budget analysis and management information including queries and reports using database query (crystal report writer) tools, database software, spreadsheets and pivot tables across a variety of business units. Able to multi-task while flexible enough to change direction rapidly as required to meet business needs; including data-mining and data manipulation supportive of management functions of planning, organizing, directing, budgeting and control. A team player and a well-polished professional who is able to work with all levels of management with a roll up your sleeves attitude. Expert skills and well versed in all Microsoft Office software products and database reporting in a SQL Server 2000, 2005, and 2008 and Oracle database environments 9i, 10g, 11g (PL/SQL).

SAP Business Objects and Crystal Reports 7, 8, 8.5, 9, 10, 2008, XI 11,Business Objects Universe, InfoView, SAP Crystal Reports Server 2008, Crystal Enterprise, Oracle BI,Databases: Oracle 9i, Oracle 10g, 11g, SQL Server 2000, 2005, 2008, 2010 and 2012, Microsoft Access, DB2, AS400,Reporting/Queries against Oracle Financials systems, SQL Server 2000, SQL Server 2005, 2008, 2010, 2012 Management Studio Enterprise Manager,Great Plains and Lawson Financials,Microsoft Excel, Access, PowerPoint, Visio,Microsoft Visual Source Safe, Star Team, ClearCase, ReqPro,Windows 3.1, Windows 95, Windows NT, Windows 2000, Windows XP,Novice HTML, Ab Initio, Oracle Reports 6i, SSRS,PL/SQL Developer, TOAD, Oracle Portal/Enterprise, OBIEE, SQL Navigator, MySQL, Transact SQL (T-SQL), Data Studio,Dashboard Metrics KPI

Confidential,Jacksonville, FL 

Web Developer

• Expert software specialist in AppWright scheduling software.
• Train users, edit screens (HTML) and trouble shoot and resolve data, screen and reporting issues Company wide.
• Manipulate data with sql queries within application for forms creation and additional app search functions for end users.
• Create databases to utilize Crystal reporting tools.
• Work with end users to gather requirements for integrating data and analyze usage from old Approach database into AppWright application.
• Incorporate and train on new processes for implementation to new application.

 Confidential,

Systems Analyst

Review current data mappings for provider data, identify sources and revise for new data ware house. Review xml mappings to determine if data is available or if revisions are necessary. Interview internal clients for current extracts and determine if data is currently mapped or work with Architect to have data extracted. Revise SRS documents to include necessary changes for extracts.

 Business Systems Analys

• Work with Internal business units to gather and define requirements, validate data accuracy from MSP and write and schedule code (procedures & packages) for deployment of MIS reports through TDA Automations to SharePoint.
• Oracle 11g, TOAD, TOAD for Data Analyst,PL/SQL, Share Point. Subversion.

Data/Report Analyst

• Perform weekly, monthly, quarterly and Ad-hoc reporting for Accounts Receivable, Financial Operations Management and Executive Management.
• Design and run customized reports and write stored procedures, using Business Objects/Crystal Reports 2008, SQL Server 2005 - 2008, SSRS, MySQL and Access.

Report Analyst

• Develop and modify Business Objects/Crystal Reports v11 extracting data from various client data warehouses writing stored procedures using DB2.
• Administer, schedule and deploy reports through Business Objects Enterprise XI.

Data Analyst

• Create reports in Crystal Reports 2008 and SQL Server 2008 using stored procedures (SQL2008), open query, Toad and Oracle 11g.
• Administered and set up Crystal Reports Server 2008, users, security, folders for automated delivery, scheduling and end user self-servicing for reports through Info View.

Business Intelligence Analyst

• Worked with small IT group in a start-up operation.
• Created standard report request document and inventory tracking procedures.
• Using SQL Server 2005 created reports using SSRS for CEO’s, VP's and all department managers for various analysis and production reports (MSP) deployed through report manager.
• Troubleshoot & resolve report quality and/or performance issues.
• Worked closely with Data Architect to determine best approach for retrieving and/or creating derived fields in warehouse for reporting.

Reports Developer/Analyst

• Analysis, design, development and creation of reports for internal and external stakeholders.
• Work with end users and process owners to understand and assist in the preparation and documentation of report requirements.
• Gathered requirements and work with stakeholders to prioritize and deliver reports.
• Developed client specific hierarchy and structure knowledge for Dashboard and client structure reporting/KPI’s.
• Troubleshoot, create and modify and train users on Crystal reports (v9).
• Create, troubleshoot and modify Dashboard metrics for internal and external clients using Pureshare Active Metrics application.
• Utilization of version control through StarTeam and deployment through FTP.
• Create PL/SQL queries, procedures and packages and modify Oracle reports including intense research through various schemas in TOAD for data reporting discrepancies/bugs. 
• Create SQL queries/views as required to deploy web reports and/or charts to Oracle Portal/Enterprise application.

Reporting Analyst

• Create and/or modify existing stored procedures using SQL Server 2000 utilizing multiple joins in large databases to create and maintain business reports for multiple business operations. This includes ongoing development of monthly/daily reporting, development of a web-based reporting application and adhoc analysis for multiple clients in a complex business environment.
• Interacted with internal client representatives to gather requirements and gain an understanding of the client’s needs for customized reports.
• Part of a large team effort to convert all existing (100’s) Crystal 9 reports over to Business Objects Crystal XI Enterprise.
• Responsible for all new client implementation report packages insuring they were readily available and customized for ‘go live’ dates working closely with our main new business representative.
• Utilize Visual SourceSafe.