Data Sql Analyst

Marlon J. Williams, M.Ed

**** ****** ***** **. ** Apt F, Marietta, GA 30067 - Cell Number: 770-***-**** - *******.********@*****.***

Experience

MiMedX Marietta, GA (November 2015 – January 2016)

Data Analyst

Participated in the data analysis process for each customer and their commission splits, account realignment, account exchanges, and salesperson data using MySQL Toad and Microsoft Excel.

Wrote SQL queries and performed data analysis on the customer tissue data, the total revenue for each customer, and dates of the sales each type of tissue was sold using MySQL Toad and Microsoft Excel.

Participated in data loading and inserting for each customer and their address, city and state.

Participated in data loading and inserting for each customer and their commission splits, revenue and account adjustments, and account manager data.

To assist with the Invoice change, commission splits and account/territory realignment.

Created the dataset for the new commission split structure and do analysis on HDS data match to facilitate approvals.

Create the data set for commission split as per the new structure.

Do data analysis and categorization of HDS match data set for account and contact to facilitate approvals of the match by stakeholders.

Assist with Invoice change requests and commission splits.

Assist with identifying additional changes as the result of account and territory realignment.

Can Capital Kennesaw, GA (October 2014 – October 2015)

QA/Business Analyst

Adhoc Report building, data extraction using SQL Server, daily, weekly, and monthly report automation using Microsoft Excel and macro VBA code thru the ETL process.

Data manipulation using Microsoft Excel with formulas, pivot Tables, and pivot Charts.

Emailing reports daily, weekly, and/or monthly to the various department managers per their request.

Producing reports for the following departments: QAQC, Sales center, Marketing, Operations, Customer Service, Sales Support, Contract Administration, and Renewals.

Reports that capture missing documentation and/or data for deals funded, in submission, and/or in the prequal stage based on the standards and policy of the organization.

Reports built based on specific parameters given by managers per their request.

Learning the fundamental concepts of Tableau 8.0 reporting software.

OptumInsight/ United Health Group Atlanta, GA (March 2014 – September 2014)

QA/Data Analyst

Analyze and dissect system requirements and technical specifications to create and execute test cases for large business initiatives

Ability to write test cases and execute testing within a web service environment

Automation of new products

Production testing in the QA environment

Establish and maintain test cases and test data

Create and maintain test cases in Quality Center, Data Center, and ALM

Actively participated in walk-through, inspection, review and user group meetings for quality assurance

Participate in production implementation verification, being accountable for validating system quality

Installed and deploying Billing rules scripts and Provider Config scripts using ConMan from production to the QA, QADB4, and Lifecode enviroments

Dropped files from production into the QA environment to test in the old and new data center using FileZone Manager and StoProX

Populated data and displaying them on an Excel spreadsheet to compare the differences between the old data center to the new data center

Communicated and interact with appropriate departments on problems, changes and enhancements that may impact data, workflow and /or functionality within the O360 platform

Complied with standards of the software development life cycle and follow strategies, plans and procedures within information Technology software

Complied with standards and strategies of the software development life cycle

Sedgwick CMS Atlanta, GA (August 2013 – December 2013)

SQL Reporting Analyst/QA Testing

Responsible for database development, both validating and converting client data from their system to the iVOS application system Sedgwick uses.

Participated in modifying existing and creating new SQL reports using Jasper.

Use SQL Server to do further analysis on SQL reporting issues.

Designed standard report formats based on organizational and business owner needs for information.

One-on-one interaction with business owners and client managers regarding specifications of what data they were requesting the reports to have and the format of which it is returned and extracted.

Used SQL Server 2008 to perform database testing and analysis on SQL queries for each report that did not test successfully.

Write SQL scripts for converting and extraction data processes.

Performed SQL Server Procedures, triggers, modifying files, extracting and transferring data.

Participated in daily and weekly scrum meetings give specific updates on assignment and project details to the development team.

Participated in QA testing using the test management tool HP Quality Center Version 9.0.

Test the functionality of the iVOS application under each user and security group in the application.

Documented actual test results whether pass or fail, including issues preventing successful execution in HP Quality Center and communicated through the daily scrum meetings with development team to conduct resolutions and knowledge sharing for User Acceptance Testing (UAT).

Participated in functional testing with the ability to design and develop comprehensive automated test strategy and test cases.

Knowledge and understanding of what tabs and fields each security group had access to and tested each of them according to their access.

The Home Depot Corporate Office Atlanta, GA (March 2013- May 2013)

Jr. Java Developer

Data Calls with DAO (data access objects) team and work closely with the team to discuss data format and requirements

Created Batch Applications that requires DAO objects to retrieve data from the database as it maps to the actual table names and data fields

Build data templates

Instantiate type variables that map to the data fields, parse them, and request the parameters for them

Using the DAO explorer, by making a single call to the DAO, selecting a method that contains inputs and outputs of each database table and giving the inputs values to return the outputs of those set values

Get familiar with the data models and structures of each database table as they related to each other depending on the products numbers, department, sub-departments, vendors, stores, markets, and merchants.

Cook Systems International Memphis, TN (August 2012 – January 2013)

Java Developer

Perform data entry and retrieval to validate data integrity by utilizing knowledge of Cook Systems International guidelines

Develop testable programming necessary to compile using Eclipse/Java by connecting to the MySQL database to insert, create, and update data

Trained to become technically familiar with schemas and data types and fields in MySql, SQL Server 2008, and Oracle

Storing employee profile information in SQL Server 2008 version by utilizing SQL programming language

Storing employee images as BLOBS inside of its own BLOB table

Provide programming support to other staff members on design issues, custom applications, and programming issues required

Interact and integrate with the database using PHP files & (MyAdminPHP) to communicate and retrieve data to and from

Develop data sets from data warehouse

Create DB in SQL Server

Create table in SQL DB for loading

Create database tables, and views

Managed large amounts of Cook Systems data and merged with other databases

Writing simple commands to gain access to the PHP files located in our Linux server

Inner join tables as the relate in id numbers to retrieve a certain amount of data at once

Maintain in-house CMS Cook Systems International database

Write SQL statements and queries to modify or update data in the database

Develop and execute stored procedures.

Education

Masters of Education - Education of Technology – Strayer University, 2013

Bachelors of Science - Computer Science – Rust College, 2008

Educational Experience

September 2011 - August 2012

I learn how to conduct reports using the Crystal Reports application where I learned to design data connection(s) and report layout in my database management courses. I learned how to select and link tables from a wide variety of data sources, including Microsoft Excel spreadsheets, Oracle databases, Microsoft SQL Server databases, Microsoft Access databases, Business Objects Enterprise business views, and local file system information. I learned how to use fields from these tables and place on the report design surface, and also be used in custom formulas, using either BASIC or Crystal's own syntax, which is then placed on the design surface.

During my database management courses, I used SQL Server 2008 to learn about accessing to different database servers, maintaining, manipulating, and extracting data from the database tables, as well as performing SQL script writing.

RDBMS Knowledge

Microsoft Access, Oracle, Crystal Reports, SSRS, SSIS, Stored Procedures, SQL, SQL Lite, My SQL, PHP, Oracle RDBMS, MS SQL, ETL process, Microsoft Excel, Pivot tables, SAS, VBA Macro coding

References

Bob Fortenberry - Supervisor - 901-***-**** - ***********@*******.***

Elayna Scott - IT recruiter - 901-***-**** - ******@*******.***

Charlotte Conner –Director of Career Services, Devry University – 901-***-****–*******@*****.***

Sheila Botelho - QA Manager, OptumInsight/United Health Group - 858-***-**** - ********@************.***

Ratish Bhaskaran – Director of Informatics, MimedX – 770-***-**** – **********@******.***

Andrea Bickham – Clinical Data Manager, MimedX – 770-***-**** – ********@******.***

Contact this candidate