EXPERIENCE:

Confidential

Data Analyst

• Developed queries and ran reports jobs using selection criteria in multiple systems
• Exported it into MS Excel or MS Access
• Compile and format raw data in MS Excel using VBA, pivot tables, lookup tables and advanced formulas
• Create fields and specific field formats to gather raw data for reporting in MS Access
• Created, modified and developed SQL and VBA script in MS Access to 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 to create high-level dashboard reports
• Used MS Excel/VBA to 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 into 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 to 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 to ensure optimal operational performance.
• Researched and prepared statistical reports using data from computer systems and internal surveys. Consolidated information into 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
• Retrieve the data from multiple systems and exported it into MS Excel or MS Access
• Compile and format raw data in MS Excel using VBA, pivot tables, lookup tables and advanced formulas
• Create fields and specific field formats to 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 to track performance for metrics
• Created and presented high-level dashboard reports to department Directors, Managers and Supervisors
• Coordinated and supervised the installation/upgrade and daily monitoring of the computerized fuel delivery systems and network to include:
• Monitoring system performance
• Maintaining the computer hardware/software
• Perform preventive maintenance
• Install hardware/software
• Catalog computer files
• Resolve database issues
• Perform system security, backup and recovery functions
• Create, modify, monitor and delete user accounts
• Assessed and developed effective ways to arrange, track, secure and store information for the municipal fuel systems including:
• Coordinating database security systems to safeguard computer databases and fuel sites
• Conduct investigations of fuel theft run reports, gather information and evidence
• Worked with City Internal Affairs Officers in fuel/vehicle theft cases
• Researching city fuel policies and procedures to aid in investigations
• Interview clients department heads regarding fuel theft cases
• Interview clients department heads to assess database needs
• Applied database programming languages to create or improve databases SQL
• Test database structure
• Maintain and enhance system security
• Coordinated efforts with a team of managers and computer specialists
• Constantly updated knowledge of tools used to organize and store data.
• Create detailed reports for analysis

Confidential

IT Systems Analyst / Reporting Analyst

• Data Analyst
• Exported data from multiple systems AS400, TerraData, SCIR, MAPS, Business Objects
• Formatted and combined data to create high-level dashboard reports
• Used MS Excel to 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 47 various departments
• Developed KPI's Key Performance Indicators to track performance for metrics
• Utilized PGP data encryption software to send/receive sensitive information
• Systems Analyst
• Created user accounts
• Performed daily, monthly audits
• Developed report queries
• Performed repair/troubleshooting as needed

Confidential

Computer Specialist

• Executive Assistant to the Director of Mathematics for all of the Detroit Public Schools, Assistant to the Middle and Elementary Mathematics Supervisors, Computer Specialist to the Office of Mathematics Education to include: Filing, faxing, emailing, creating and implementing curriculum guides and pacing charts to be distributed to all Detroit Public Schools and resolving network, hardware/software installation and configuration issues within the office.
• Using MS Excel, importing school data, formatting, and creating reports for the Director.
• PC break/fix alternate.

Confidential

Website Engineer

• Acquired incentive and other information pertaining to GM vehicles posting the information daily on the GM website using Java, RSS, HTML, XML.
• Created and routed the information and authorization to implement the approved rates and incentives to every GM dealer in the South Central Region.
• Created and maintained a file system to 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 into MS Excel for analysis/reporting
• Created formulas to manipulate data
• Created pivot tables to sum data categories
• Created Charts/graphs to show trending
• Created databases using MS Access to store and sort data
• Distributed reports weekly and monthly to the engineers
• Accompanied engineers to Jefferson North Auto Plant JNAP to assist in the engineering process via laptop

Confidential

Admin Specialist / Legal Assistant

• Office Manager, Executive Assistant to 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.