Reporting Analyst Resume Profile
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