Resume

Sign in

Seasoned Data Analyst

Location:
Clarkston, Michigan, 48346, United States
Salary:
75000
Posted:
February 02, 2018

Contact this candidate

JIMMIE L. WARREN

**** ******* ***** *****

Clarkston, MI 48348

313-***-****

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



Contact this candidate