We provide IT Staff Augmentation Services!

Systems Analyst Resume

Jacksonville, FL

PROFESSIONAL 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).

SKILLS/TOOLS:

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 - (Pureshare)

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Systems Analyst

Responsibilities:

  • 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.

Confidential, Jacksonville, FL

Business Systems Analyst

Responsibilities:

  • 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.

Confidential

Data/Report Analyst

Responsibilities:

  • 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, SSRS, MySQL and Access.

Confidential

Report Analyst

Responsibilities:

  • 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.

Confidential

Data Analyst

Responsibilities:

  • 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.

Confidential

Business Intelligence Analyst

Responsibilities:

  • 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.

Confidential

Reports Developer/Analyst

Responsibilities:

  • 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.

Confidential

Reporting Analyst - Business Analytics

Responsibilities:

  • 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.

Confidential

HR Global Reporting Specialist

Responsibilities:

  • Develop, modify and troubleshoot Business Objects (6.5) reports for H.R. organization globally, coach and work with end users - globally on using application (Taleo) reports and train how to modify reports to their own specifications.

Confidential

Software Specialist

Responsibilities:

  • 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.
  • In corporate and train on new processes for implementation to new application.

Confidential

Crystal Report Writer

Responsibilities:

  • Created complex custom reports using Crystal Reports 10 on an Oracle 8i and 9i database.
  • Reports entailed complex queries on a database consisting of nearly 300 tables on enterprise wide medical scheduling software.
  • Utilized Visual Source Safe.

Confidential

Crystal Report Writer

Responsibilities:

  • Worked as part of a product development team to perform requirements/business analysis and development of a web based system analysis tool.
  • Created reports using Crystal Reports 9 utilizing stored procedures and views on a SQL Server 2000 database.
  • Worked with data warehouse architect and software developers to validate stored procedures and scrub data.
  • Responsible for testing and optimizing reports on development sites.
  • Utilized Visual Source Safe.

Confidential

Crystal Reports Writer

Responsibilities:

  • Designed and wrote reports using Crystal Reports on Great Plains Financial database using SQL Server to aid CFO and other senior management members including Accounting, HR, and Project Management to manage a wide variety of financial activity on various engineering projects.
  • Also created Microsoft Access databases and forms for additional project analysis.

Confidential, Jacksonville, FL

Crystal Report Writer

Responsibilities:

  • Developed Crystal Reports for Asset Management group (GAAP analysis) for integration into Crystal Enterprise (DB2 to Crystal), utilized Lawson Financials and query tools (ADO) to gain an understanding of the data and location within the database communicating requirements with users: CPA’s, Senior Developers, etc.
  • Effectively manipulate and extract data for Crystal reports. In many instances had to use Access, Excel and Crystal to manipulate the data for one report based on its location.

Confidential

Crystal Report Writer

Responsibilities:

  • Responsible for analysis, development, maintenance, modification, and enhancements of complex reporting solutions for senior management in banking operations, secondary marketing, and production accounting areas.
  • Responsible for testing reports to ensure data integrity and accuracy.
  • Identified opportunities to streamline reporting processes.
  • Used Microsoft Excel and Access tools for efficient data manipulation for queries, pivot tables and presentations.
  • Provided support and to internal customers and other team members on proper use of reporting tools.

Confidential, Jacksonville, FL

Project Coordinator/Financial Reports/Budget Analyst

Responsibilities:

  • Designed and wrote reports using Crystal Reports to aid senior management in a wide variety of financial management on projects for a $28 million annual budget.
  • Scheduled reports for delivery via email, portal, and public folders.
  • Reported on Oracle Financials system to analyze spending patterns and identify potential budget problems.
  • Implemented financial system controls to prevent cost overruns and incorrect charges to the budget.
  • Implemented tracking systems to monitor daily budget variations.
  • Worked with all levels of management and field personnel to ensure adherence to budget guidelines.

Hire Now