LAWRENCE ROSSER

• Develop/manage SSIS projects
• Configure database security
• Monitor, configure, and schedule SQL jobs.
• Query tuning.
• Database migration
• Conceptual/logical/physical database design
• Database backup/restore
• Install SQL Server cumulative updates
• Participate in T-SQL code reviews

Design, test, publish, migrate, and monitor ETL processes,

Design, test, script, and migrate all objects related to database lifecycle management,

Document project tasks and user stories in DevOps,

Monitor, debug and correct production jobs,

Publish, download, and migrate code in Git.

• Modernize the Reporting Solution of the Accounts Payable Department, which includes the following responsibilities:
  1) Design of conceptual, logical, and physical data models,
  2) Migrate Microsoft Access application and Excel macros to SQL Server,
  3) Create Alteryx workflows to ingest SAP flat files into SQL Server,
  4) Create and deploy SSRS reports and subscriptions.
• Testing/researching/debugging the validation of new sector data into the existing Human Resources Data Warehouse which includes:
  1) Modifying tables and stored procedures,
  2) Verifying that new data was added in the dimensions and fact tables using T-SQL, and
  3) Verifying that new data was also added in the cubes using SSAS.

• Modeled data & created jobs to allow my team to be the 2nd fastest state in the country to submit Healthcare files to CMS. Modeled data & created jobs to allow my team to be the 10th fastest state in the country to evaluate an individual's eligibility based on his/her financial resources.
• SQL Developer that designed, created, and implemented an automated job to encrypt/decrypt data at rest using either AES Crypt or WinZip Design, Implemented database models with emphasis on query optimization and slow changing dimensions, Design and implement fact tables that capture data regarding customer defined KPI's, Create/modify/debug SSIS packages for daily ETL processes, Migrate/Upgrade databases & database objects, Create/modify SSRS reports using parameters, drill-through, charts, and document maps, Perform query analysis to improve performance.

First team member to use parameters on SSRS reports, Successfully migrated an Accounting system from Microsoft Access to a web app,

Developed process to calculate the amount of overpayment by State Agency based on the child's eligibility using SQL Server & Oracle databases,

Develop and maintain SSRS reports, Develop and maintain SSIS packages, Develop and maintain PL/SQL packages, Migrate database objects to different environments.

• Automated Medicaid Batch cycle to run on holidays without any manual adjustments, First technical staff member to use IF..ELSE statements in JCL, Developed and maintained internet and intranet applications using Oracle/PL/SQL, ASP.Net, and VisualBasic.Net, Developed and maintained mainframe programs and jobs using Cobol, JCL, MVS, CICS, Easytrieve, Served as mainframe scheduler for the Medicaid HealthCare Batch Cycle using CA7, Served as Cycle Monitor for the Medicaid HealthCare Batch Cycle to resolve abends and other cycle issues in a timely manner.