MedCost: Benefit Solutions Company – Winston-Salem, NC 2018 to Present
Application Developer
- Worked on the deployment of a new company wide CRM system. Responsible for ETL work to load 12 different PBM import and export data files.
- Lead on PBM ETL import and export processes to load and export files.
- Lead developer on out CMS MSP quarterly files sent to the US government.
- Lead developer on new process to load Flex data to a third-party vender that handles the members website.
- Lead developer on Cobra process to gather and load data into the Travis Cobra program that send out communication to the members for Cobra.
- Because of my experience I was asked to do code review to make sure the developer code was up to standard and was fully optimized.
Randstad – Raleigh, NC \ Winston-Salem, NC 2015 to 2018
Senior SQL Server Developer
Accordant a CVS Company:
- Lead developer on a project that imported 10 different clients. ETLs created for multiple files per client that loaded data for medical claims. The data was then run through business rules that would check data for defects.
- Implemented a reporting server.
Cardinal Solutions – Raleigh, NC \ Winston-Salem, NC 2013 to 2015
Senior Consultant II, Data Solutions
Reynolds American Inc.:
- Part of a small team that created a data warehouse that brought together data from several different sources. This data was brought in by different methods that included loading an Excel spread sheet, SSIS packages, and replication databases.
- Played an integral part of in the design, implementation and enforcing the RAI SDLC process called “Crank the Wheel”. This included the creation of processes and documents that tracked the development life cycle from requirements gathering to deployment and finally maintenance.
- Worked closely with managers and business stakeholders at RAI to ensure the requirements where complete before design and coding where started. I would also reach out to the business when questions came up during the design and coding part of the process that were not part of the requirement documentation.
- Trouble shot maintenance issues that arose after deployment. This included server memory and IO issues which lead to the team working to optimize SSIS packages and T-SQL code.
- Became the process expert on Tidal scheduler were RAI scheduled the SQL processes to run throughout the day. This was used instead of SQL Server Agent.
Campus Partners – Winston-Salem, NC 2012 to 2013
Sr. SQL Developer/Code Master
SQL Server Development, SSRS and SSIS:
- Programmed a process that brings in data from several text delimited files, manipulated the data and outputs a text file that is formatted for processing into the mainframe. This process was optimized to bring in over 200,000 records per run.
- Built a SSIS package that determines if a customer needs one of four different email types and sends that email to customers of four different venders.
- Worked in a leadership role called “Code Master” that coordinated all SQL Server deployments to the production environment. Responsibilities included checking code for mistakes and correct commenting, ensuring all testing was performed and documented, putting together all the needed documents change control tickets, and represented the SQL Server team in the change control meeting.
- Assigned a partially programmed process after a teammate left the company that was the highest profile and priority for the company. This process brings all payment types for customer loans together into one file that is sent to the federal government. (FMS)
Vitacost.com – Lexington, NC 2010 to 2012
Sr. IT Analyst
SQL Server Development, SSRS and SSIS, and Back-up for the local IT director:
- Designed and developed a SQL process that used SSIS and stored procedures that will gather and consolidate data for DHL shipments before passing the data to DHL.
- Worked on connections from Microsoft AX system of record to SQL Server databases used in customer order picking and stock replenishment.
- Worked to write out specifications for several different systems projects for the team to program. Ranging from RF Scanner processes to connections between SQL Server and MS AX systems.
- Worked with managers and end users to define and document scope before building a customer order return system in c#. I worked with several teams to design a system that met the needs of customer service and warehouse departments to streamline the returns process.
- Worked with the CEO to redesign the companies packing slip invoices in SSRS reports. Updates included adding advertising that rotate between several active advertisements. The advertisement will open and close automatically by a date time period or quantity of ads requested.
- Implanted a QC form that will document QC data and help guide the employee that is performing the testing.
- Mentored several junior analysts by teaching them the best practices and other possible solutions when reviewing their code. Help them define what testing is needed by critiquing their test document and pointing them in the direction of testing requirements that they might not have about.
- Lead, Developed, and documented a failover process for SQL database server and application server.
Pepsi Bottling Company – Winston-Salem, NC 2007 to 2010
SQL Server Developer/Business Analyst
Maintenance, Development and Implementation of Dispute tracking system (CTS):
- Managed all phases of the project life cycle of system issues or upgrades. Determined the scope, planned possible solutions, developed the solution, tested the solution and implemented the solution.
- Designed, maintained, and implemented SQL server objects such as stored procedures, views, functions and triggers.
- Designed, developed, and maintained several complex queries, SQL scripts, and indexes for data analysis, processing and extraction.
- Worked with business stakeholders to identify business needs for updated workflow processing to find technical solutions.
- Wrote or updated documentation, workflows and job aids for business processes used by the business and other members of my team.
- Optimized several Crystal Reports and created and maintained several Access databases used for reporting.
Planned, Developed and Tested database code changes for a major Oracle Implementation:
- Member of an implementation team that reengineered the CTS system from a standalone case tracking system to an integrated system with the new Oracle AR system.
- Redesigned and developed central process within CTS that identifies the reason for the disputed invoice and routes the case to our field partners and back to our business until the issue has been resolved.
- Lead the updating of the case routing process within CTS that moved the disputed case from agent to agent though out the cases lifecycle. Routing was divided into 5 types of routing which included triggers.
- Designed and built SQL Server Integration Services (SSIS) and Data Transformation Services (DTS) objects to attach documents to CTS cases.
Part of a project team that planned, developed, and converted data during a large company merger:
- Member of the data conversion team that converted data for over 400,000 customers and their invoices into the Oracle AR system.
- Wrote specifications for several pivotal sections of the data conversion of 400,000 customers as well as for the customer module in the Oracle AR System.
- Managed the manual conversion process of adding customers into the hierarchy system in the Oracle AR system. This included translating legacy customer relationships into Oracle AR hierarchies.
- Built a SQL server database including tables, schemas, views and stored procedures that will import Oracle data translate the data into the correct hierarchy and export the data into a format that can be used to update Oracle.
THE TODD ORGANIZATION – GREENSBORO, NC 2006 to 2007
System Analyst
Key Results:
- Provided technical support to workers in information processing departments.
- Trained 20 analyst and managers and achieved significant improvements in their productivity.
- Planned and prepared technical reports and instructional manuals as documentation.
- Resolved questions of program intent, data input, output requirements and inclusion of internal controls.
- Planned and prepared technical reports, memoranda and instructional manuals as documentation of program development
AON CONSULTING – WINSTON-SALEM, NC 2005 to 2006
System Analyst
Key Results:
- Analyzed user requirements, procedures and problems in order to improve existing computer system.
- Instrumental in planning, preparing, and coding for annual enrollment for our customers.
- Expanded and modified systems to serve new purposes and improve work flow.
- Trained staff and users to work with computer systems and programs.
