PROFESSIONAL EXPERIENCE:

Independent Contractor

Confidential, Davison, MI

Responsibilities:

• 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
• 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
• Used all available software applications to complete data processing jobs in a timely and accurate manner.
• 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.
• Identified issues and takes the proper actions to resolve them.
• Responsible for running validation processes to ensure conversion accuracy.
• Facilitated conversion related support calls from all customers.

Independent Contractor

Confidential, Southfield, MI

Responsibilities:

• 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.

Independent Contractor

Confidential, Flint, MI

Responsibilities:

• 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

Independent Contractor

Confidential, Farmington Hills, MI

Responsibilities:

• 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
• 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

Independent Contractor

Confidential, Farmington Hills, MI

Responsibilities:

• 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

Independent Contractor

Confidential, Detroit, MI

Responsibilities:

• 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)

Confidential

Data Analyst

Responsibilities:

• 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 Confidential 8.0 - 8.4 for dashboards and metrics development and reporting.
• Utilized Reportnet 1.1 to migrate reports to Reportnet
• Utilized drill through/drill down to show summary or details of data
• Imported data into Catalog
• Used Confidential SQL in Report Studio
• Converted list/tabbed reports to charts and graphs in Impromptu Administrator
• Used report burn to send sections of reports to users/groups
• 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.

Confidential

IT - Data Analyst

Responsibilities:

• 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

Confidential

IT - Business Process Analyst / Data Analyst / Systems Administrator / DBA

Responsibilities:

• 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 Confidential 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

Confidential

IT - Systems Analyst / Reporting Analyst

Responsibilities:

• Exported/Imported data from multiple systems (AS400, TerraData, SCIR, MAPS, Business Objects, Salesforce)
• 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)

Confidential

Computer Specialist

Responsibilities:

• 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

Confidential

Website Engineer

Responsibilities:

• 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

Responsibilities:

• 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

Confidential, Jacksonville, NC

Admin Specialist / Legal Assistant

Responsibilities:

• 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