We provide IT Staff Augmentation Services!

Reporting Analyst Resume Profile

5.00/5 (Submit Your Rating)

Summmary

I am a Data Analyst with 20 years of systems analysis and thirteen 13 years of experience with extensive experience in data analysis. I have managed multiple systems simultaneously, created reports and automated scripts that triggered reporting events. I have used tools such as SQL, Visual Basic, and Excel t manipulate Health Care, Manufacturing, Financial and Energy data. I als have experience creating dashboards in TABLEAU, Cognos, and Excel. I have been responsible for gathering requirements from clients in order t understand what data is needed and translated those requirements int reporting elements for my analysis team.

PROFESSIONAL

EXPERIENCE:

Independent Contractor

Confidential

  • Writing reports using SQL in MySQL, SQL Server R12 for analysis
  • Importing Reports t Excel and applying lookup tables and complex formulas for analysis
  • Importing data int MS Access tables and creating reports using SQL/VBA
  • Importing data int Tableau and creating Dashboard reports tabbed/untabbed

Confidential

Data Analyst

  • Developed queries and ran reports jobs using selection criteria in multiple systems
  • Exported it int MS Excel or MS Access
  • Compiled and formatted raw data in MS Excel using VBA, pivot tables, lookup tables and advanced formulas
  • Created fields and specific field formats t gather raw data for reporting in MS Access
  • Created, modified and developed SQL and VBA script in MS Access t select data and run reports from multiple tables

Confidential

IT Data Analyst

  • Assisted with the data cleansing process in preparation for the Symphony Project launch
  • Exported massive amounts of data from multiple systems PeopleSoft, Pilot, MedAsset
  • Formatted and combined data t create high-level dashboard reports
  • Used MS Excel/VBA t develop tables, apply formats, lookup tables, pivot tables and formulas for easy access and analysis
  • Created and maintained a MS Access Database for data storage, reporting and monthly, quarterly and yearly analysis
  • Provided analysis for massive database objects
  • Retrieved patient data from Medicare Advantage, formatted and imported int Excel for high level dashboard reporting

Confidential

IT Business Process Analyst / Data Analyst / Systems Administrator / DBA

  • Automated the reporting elements in multiple systems and prepared the data for analysis using Microsoft Excel and Microsoft Access
  • Defined and documented customer business functions and processes
  • Consulted with functional unit management and personnel t identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access
  • Acted as a liaison between departmental end-users, technical analysts, information technology analysts, consultants and other governmental organizations in the analysis, design, configuration, testing and maintenance of case management systems t ensure optimal operational performance
  • Researched and prepared statistical reports using data from computer systems and internal surveys. Consolidated information int cohesive and understandable correspondence or other written form for use in management decision-making
  • Developed queries SQL/VBA and ran reports jobs using selection criteria in multiple systems
  • Retrieved the data from multiple systems and exported it int MS Excel or MS Access
  • Compiled and formatted raw data in MS Excel using VBA, pivot tables, lookup tables and advanced formulas
  • Create fields and specific field formats t gather raw data for reporting in MS Access
  • Created reports and graphs based on source data
  • Developed performance metrics for 47 various departments
  • Developed KPI's Key Performance Indicators t track performance for metrics
  • Created and presented high-level dashboard reports t department Directors, Managers and Supervisors
  • Coordinated and supervised the installation/upgrade and daily monitoring of the computerized fuel delivery systems and network t include:
  • Monitored system performance
  • Maintained the computer hardware/software
  • Performed preventive maintenance
  • Installed hardware/software
  • Cataloged computer files
  • Resolved database issues
  • Performed system security, backup and recovery functions
  • Created, modified, monitored and deleted user accounts
  • Assessed and developed effective ways t arrange, track, secure and store information for the municipal fuel systems including:
  • Coordinated database security systems t safeguard computer databases and fuel sites
  • Conducted investigations of fuel theft run reports, gather information and evidence
  • Worked with City Internal Affairs Officers in fuel/vehicle theft cases
  • Researched city fuel policies and procedures t aid in investigations
  • Interviewed clients department heads regarding fuel theft cases
  • Interviewed clients department heads t assess database needs
  • Applied database programming languages t create or improve databases SQL
  • Tested database structure
  • Maintained and enhanced system security
  • Coordinated efforts with a team of managers and computer specialists
  • Updated knowledge of tools used t organize and store data
  • Created detailed reports for analysis

Confidential

IT Systems Analyst / Reporting Analyst

  • Exported data from multiple systems AS400, TerraData, SCIR, MAPS, Business Objects
  • Formatted and combined data t create high-level dashboard reports
  • Used MS Excel t apply formats, lookup tables, pivot tables and formulas for easy access and analysis
  • Created and maintained a MS Access Database for data storage, reporting and monthly, quarterly and yearly analysis
  • Developed performance metrics for forty seven 47 various departments
  • Developed KPI's Key Performance Indicators t track performance for metrics
  • Utilized PGP data encryption software t send/receive sensitive information
  • Created user accounts
  • Performed daily, monthly audits
  • Developed report queries
  • Performed repair and troubleshooting as needed

Confidential

Computer Specialist

  • Served as an Executive Assistant t the Director of Mathematics for all of the Detroit Public Schools, Assistant t the Middle and Elementary Mathematics Supervisors, Computer Specialist t the Office of Mathematics Education t include:
  • Filing, faxing, emailing, creating and implementing curriculum guides and pacing charts t be distributed t all Detroit Public Schools and resolving network, hardware and software installation and configuration issues within the office
  • Used MS Excel, importing school data, formatting, and creating reports for the Director

Confidential

Website Engineer

  • Acquired incentive and other information pertaining t GM vehicles posting the information daily on the GM website using Java, RSS, HTML, XML
  • Created and routed the information and authorization t implement the approved rates and incentives t every GM dealer in the South Central Region
  • Created and maintained a file system t keep accurate records of transactions and generated reports weekly in detail
  • Operated copy machine, fax, Excel, Word, PowerPoint, Access and other software

Confidential

Engineering Assistant/Data Analyst

  • Imported test data int MS Excel for analysis/reporting
  • Created formulas t manipulate data
  • Created pivot tables t sum data categories
  • Created charts and graphs t show trending
  • Created databases using MS Access t store and sort data
  • Distributed reports weekly and monthly t the engineers
  • Accompanied engineers t Jefferson North Aut Plant JNAP t assist in the engineering process via laptop

Confidential

Admin Specialist / Legal Assistant

  • Functioned as an Office Manager, Executive Assistant t the Commanding Officer, Payroll, Separations, Service Record Books, Travel, Files and Directives, Alternate Admin Chief, Software Trainer, field hardware/software installation and configuration
  • S2 intelligence clerk

We'd love your feedback!