TECHNICAL SKILLS:

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

EXPERIENCE:

Confidential, Marietta, GA

Data Analyst

Responsibilities:

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

Confidential, Kennesaw, GA

QA/Business Analyst

Responsibilities:

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

Confidential, Atlanta, GA

QA/Data Analyst

Responsibilities:

• 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

Confidential, Atlanta, GA

SQL Reporting Analyst/QA Testing

Responsibilities:

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

Confidential, Atlanta, GA

Jr. Java Developer

Responsibilities:

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

Confidential, Memphis, TN

Java Developer

Responsibilities:

• Perform data entry and retrieval to validate data integrity by utilizing knowledge of Confidential 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 Confidential database
• Write SQL statements and queries to modify or update data in the database
• Develop and execute stored procedures.