JIMMIE L. WARREN
Clarkston, MI 48348
ac4blu@r.postjobfree.com
Data Analyst ( Interweb Concepts, Contract, Southfield, MI) 1/2017 - 1/2018
Writing reports using SQL in MySQL, SQL Server R12 for analysis
Importing Reports to Excel and applying lookup tables and complex formulas for analysis
Created and configured flows, forms, integration processes and dashboards using Workflow
Analyzed and documented scope of work for data conversion projects.
Coordinated the conversion of various types of customer data.
Responsible for converting data from multiple data sources including text files, MS Excel and MS Access
Using Six Sigma methodologies, reverse engineered problematic processes to troubleshoot issues
Identified root cause issues and take the proper actions to resolve them.
Responsible for running validation processes to ensure conversion accuracy.
Reporting Analyst (Short-Term Contract, Flagstar Bank, Troy, MI) 11/16 – 12/16
Retrieved Call Center data from multiple sources (Verint, Cisco, Sharepoint)
Applied Macros, Visual Basic scripts and formulas in Excel to format and analyze Call Center data
Created automated processes to manage data
Created Dashboard reports for Management daily
Data Analyst (Interweb Concepts, Davison, MI) 1/16 to 11/16 - Contract
Employed ETL process in Data Stage in accordance with Business Requirements
Imported and managed data in BI/Power BI Suite to include: Framework Manager, Transformer, Metrics Studio, Analysis Studio, Report Studio and Query Studio
Writing reports using SQL in MySQL, SQL Server R12 for analysis
Importing Reports to Excel and applying lookup tables and complex formulas for analysis
Created and managed database objects in MS Access, created live auto-update forms linked to Excel spreadsheets, created processes using VBA, created front-end forms for data entry, created jobs that executed and ran reports
Importing data into Tableau and creating Dashboard reports
Created and configured flows, forms, integration processes and dashboards using Workflow
Analyzed and documented scope of work for data conversion projects.
Utilized Hadoop to manage large data sets
Utilized MDM to define and manage the processes, policies and tools of critical data to include: removing duplicated data, standardizing, cleansing and employing root cause analysis.
Coordinated the conversion of various types of customer data.
Responsible for converting data from multiple data sources including text files, MS Excel and MS Access
Communicated project status to customers and works with customers on verifying that data is converted correctly.
Using Six Sigma methodologies, reverse engineered problematic processes to troubleshoot issues
Identified root cause issues and take the proper actions to resolve them.
Responsible for running validation processes to ensure conversion accuracy.
Facilitated conversion related support calls from all customers.
Data Analyst (Bullseye Telecom, Southfield, MI) 11/15 to 1/16 - Contract
Employed ETL process in Data Stage in accordance with Business Requirements
Imported and managed data in BI Suite to include: Framework Manager, Transformer, Metrics Studio, Analysis Studio, Report Studio and Query Studio
Writing reports using SQL in MySQL, SQL Server R12 for analysis
Importing Reports to Excel and applying lookup tables and complex formulas for analysis
Importing data into Tableau and creating Dashboard reports
Utilized storage services, data management and business analytics functions in Microsoft Azure.
Data Analyst (Diplomat Pharmacy, Flint, MI) 8/15 to 10/15 - Contract
Manipulating prescription data in an Oracle environment
Data mining of prescription data
Passed the data on to the IT department for upload into PeopleSoft environment
Verified accuracy of data in PeopleSoft
Creating canned and adhoc reports using SQL in MySQL, SQL Server R12 for analysis
Importing Reports to Excel and applying lookup tables and complex formulas for analysis
Data Analyst (Latcha & Associates, Farmington Hills, MI) 5/15 to 8/15 - Contract
Manipulating Marketing data in an Oracle environment
Received data in many formats, transformed data for upload to Oracle
Employed ETL process in DataStage in accordance with Business Requirements
Writing reports using SQL in MySQL, SQL Server R12 for analysis
Importing Reports to Excel and applying lookup tables and complex formulas for analysis
Importing data into MS Access tables and creating reports using SQL/VBA, SRS, SSRS
Importing data into Tableau and creating Dashboard reports (tabbed/untabbed)
As a backup MDM Analyst, ensure data maintenance procedures are developed, maintained and are compliant with regards to SOX/GMPs requirements
Define and document processes, tools and templates to help others adhere to the Master data standards
Analyze and help resolve data problems that may be causing transactional issues
Receive, analyze and implement requests for changes to master data
Utilized MDM to define and manage the processes, policies and tools of critical data to include: removing duplicated data, standardizing, cleansing and employing root cause analysis.
Administer Insurance Channel master data within ERP system
Maintain related master data in CRM and other local systems as needed
Measure and report on data quality and key business metrics within ERP and CRM systems
Analyze data exchange processes with external sites to understand their strengths and weaknesses and determine opportunities to improve and/or automate processes and functions
Collaborate with business partners and IT technical teams to create requirements for changes to customer data models, fields, objects and/or reference data
Define and/or modify existing customer data policies and rules that apply to relevant customer data
Ensure compliance to any documented customer data governance policies and approved usages as well as resolve data quality issues
Data Analyst (Etkin Skanska, Farmington Hills, MI) 3/15 to 5/15 - Contract
Manipulating Construction data in an Oracle environment
Writing reports using SQL in MySQL, SQL Server R12 for analysis
Importing Reports to Excel and applying lookup tables and complex formulas for analysis
Data Analyst (State of Michigan, Detroit, MI) 11/14 to 3/15 - Contract
Writing reports using SQL in MySQL, SQL Server R12 for analysis
Importing Reports to Excel and applying lookup tables and complex formulas for analysis
Importing data into MS Access tables and creating reports using SQL/VBA, SSRS, SSIS
Importing data into Tableau using SAP to create Dashboard reports (tabbed/untabbed),
Ford Motor Company 03/14 to 11/14
Data Analyst
Developed queries and ran reports jobs in Oracle
Imported and managed data in BI Suite to include: Framework Manager, Transformer, Metrics Studio, Analysis Studio, Report Studio and Query Studio
Created and imported data into MS Excel and MS Access for analysis and reporting as well as Tableau or COGNOS 8.0 - 8.4 for dashboards and metrics development and reporting.
In COGNOS – Utilized Reportnet 1.1 to migrate reports to Reportnet
In COGNOS – Utilized drill through/drill down to show summary or details of data
In COGNOS – Imported data into Catalog
In COGNOS – Used COGNOS SQL in Report Studio
In COGNOS – Converted list/tabbed reports to charts and graphs in Impromptu Administrator
In COGNOS – Used report burn to send sections of reports to users/groups
In COGNOS – Used Access Manager to provide security to data packages
In some cases, used MDM to manage relative data sets
Compiled and formatted raw data in MS Excel using VBA, pivot tables, lookup tables and advanced formulas
Created 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
Created workgroups, imported/shared files in Sharepoint.
St. John Health Systems 06/13 to 10/13
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)
Imported and shared large data sets and files in Sharepoint and Salesforce
Employed ETL process in DataStage in accordance with Business Requirements
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
City of Detroit 06/08 to 06/13
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,SRS,SSIS) and ran reports jobs using selection criteria in multiple systems
•.Retrieved the data from multiple systems and exported it into 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 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 using the COGNOS and Tableau (30%) software packages.
Coordinated and supervised the installation/upgrade and daily monitoring of the computerized fuel delivery systems and network to include:
•.Monitored system performance
•.Maintained the computer hardware/software
•.Performed preventive maintenance
•.Installed hardware/software
•.Cataloged computer files
•.Resolved database issues
•.Utilized Dell Quest IAM to process new access requests, create and modify individual/group users, create, reset and delete user access ID’s and passwords, configure job titles to locations, business units and levels of access.
•.Performed system security, backup and recovery functions
•.Created, modified, monitored and deleted user accounts
Assessed and developed effective ways to arrange, track, secure and store information for the municipal fuel systems including:
•.Coordinated database security systems to 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 to aid in investigations
•.Interviewed clients (department heads) regarding fuel theft cases
•.Interviewed clients (department heads) to assess database needs
•.Applied database programming languages to 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 to organize and store data
•.Created detailed reports for analysis
Ford Credit (Contract) - National Bankruptcy Service Center 03/05 to 04/08
IT - Systems Analyst / Reporting Analyst
Exported/Imported data from multiple systems (AS400, TerraData, SCIR, MAPS, Business Objects, Salesforce, SAP)
Formatted and combined data in Excel and Informatica 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 report queries
Performed repair and troubleshooting as needed
Developed performance metrics for forty seven (47) various departments
Developed KPI's (Key Performance Indicators) to track performance for metrics
Utilized PGP data encryption software to send/receive sensitive information
Created/modified and deleted user accounts
Provided hardware/software access based on job description/managerial approval
Performed daily, monthly system/data security audits
Participated in Disaster Recovery system controls and reporting testing
Scheduled end of day jobs to run reports for the previous day’s transactions (data dump)
Contract Service Firm 08/01 to 03/05
Assigned to Detroit Public Schools
Computer Specialist
Served as an 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 and software installation and configuration issues within the office
Used MS Excel, importing school data, formatting, and creating reports for the Director
Contract Service Firm 02/98 to 08/01
Assigned to General Motors Global Headquarters
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
Jeep/Eagle Engineering 01/93 to 09/97
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 and 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
U.S. Marines - Jacksonville, NC 09/88 to 10/92
Admin Specialist / Legal Assistant
Functioned as an 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
EDUCATION:
Kaplan University
Information Systems and Technology
Pre Bachelors (April 2017)
ACHIEVEMENTS:
Meritorious Mast (x8)
Combat Meritorious Promotion to E4
Certificate of Commendation (x10)
Tech Challenge Winner (x2)
VFW Member
Marine Corps Urban League Member