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