Dennis Laury

aduwfn@r.postjobfree.com 704-***-****

SUMMARY

Data Analyst

Insightful, results-driven IT professional with notable success and experience across diverse industries while participating in planning, analysis, and implementation of solutions in support of business objectives. Creative problem-solver who accurately assesses technical situational challenges and successfully transforms ideas into appropriate process and technical solutions. Highly communicative in understanding, relating, managing and monitoring client expectations. Demonstrated ability to manage multiple priorities in fast-paced environments. Agile for over 3 years. Used SSIS to load hundreds of tables used to create and send Medicaid rebills to the state. Also converted SSIS packages in a database migration.

COMPUTER SKILLS

Languages: T- SQL 2016, 2012,2008R2,,SSIS, ETL, Advanced SQL,X12,SSIS, Data Warehouse

Past Languages: Coldfusion, C#, HTML, Javascript, Jquery, Java, DB2, CSS

Tools: SSIS,TFS, GIT, Flyway, Subversion, Beyond Compare, Tivoli, Access, Excel, Microsoft suite, ETL, SDLC

Management Studio, Visual Studio 2017, EDI power reader.,,Autosys, Confluence

Platforms: Windows 7,10, SQL 2008, 2012, 2016,Cloud server DBAAS, Jira, ALM, ServiceNow

EXPERIENCE

SQL Developer OCT 2021-Oct 2022

Contractor Wells Fargo

●Supported and modified existing 3rd party application Avant-Guard, ServiceNow,

●Created dashboards and the backend data to support data using SQL, stored procs and views, functions, prod support when I saw problems.

●Collaborated with business to resolve any issues.

●Optimized code to use CTE or temp tables and optimized queries by adding includes to indexes. Imported data from many sources to load SQL tables.

●Loaded tables from many sources to SQL tables.

●Created tables, views, functions, stored procedures. Jira, Confluence

SQL Developer Mar 2020 - Sep 2020

Contractor Wells Fargo

●Processed incoming trading files thru stored procs per line of business. Mapped data from source to target to add to the star schema data warehouse tables.

●Worked with finance to find discrepancies in values being loaded in the system.

Optimized code to use CTE or temp tables and optimized queries by adding includes to indexes

SQL Developer Mar 2019 - Mar 2020

Contractor, Bank of America, Charlotte, NC

●Resolved SSIS issues and found and resolved data issues.

●Created data scripts for CRUD operations. Updated complex queries and CTE for better performance. Stored procs and views. Prod support for the packages

●Learned about SSIS and the differences between SQL 2008 and SQL 2016 packages since the version change required some updating.

●Converted 40-50 packages from SQL 2008 to SQL 2016

●Created jobs and scheduled jobs in Autosys which was the scheduling system for jobs.

●Assisted architect with a database conversion. Verifying tables, views, procs, permissions were in place.

●Resolved query questions, stored proc revisions, Ad hoc queries as needed

SQL Developer I May 2015 – Mar 2019

Cardinal Innovations, Charlotte, NC

●In charge of creating State and Medicaid rebills in 837 files with SQL. Wrote SQL to identify, validate and create files to send to the state. Validated results on returning 835 files.

●Created data scripts for CRUD operations.

●Learned more advanced coding techniques using temp tables and CTE

●Wrote SQL validation scripts. Loaded tables weekly from Excel.

●Created tables. views, triggers, foreign keys. table joins, Stored procedures.

●Created synonyms, SQL tuning and adding indexes and foreign keys.

●As we transitioned to using GIT and TFS for code check-ins, I wrote some documentation to assist others. Checked in code for other teams not trained on GIT/TFS

●Using ETL.I mapped and loaded data back and forth between Excel and T-SQL for 3 years. I had some Excel macro exposure as well

●Provided ad-hoc reports and data validation using SQL, Excel

●Performed Code and Document Reviews to ensure adherence to enterprise processes, policies, and standards per SDLC

●Used EDI Power reader to generate CSV files from x12 files for audits.

●Trained a user after a company partnership was dissolved.

●Ran weekly regression testing and found and resolved differences in the claims system.

Developer Carolinas Healthcare(Atrium), Charlotte, NC Jan 2008 - Feb 2015

●Developed programs in coldfusion for Telehealth Triage and several eforms like mileage that captured, computed amounts to be sent to accounts payable. Other eforms collected data for HR like military service and disability. Integrated with Google Maps.

●Led programming tasks including new development, enhancements, maintenance and support for clients’ applications and interfaces. Tasks included Unit as well as running and developing test scripts, SQL tuning and adding indexes.

●Engineered software products, handling complex analysis and intricate programming to meet project requirements.

●Developed program to compare active directory and peoplesoft data to see discrepancies.

●Provided On-Call Production Support and daily production support of software and assisting clients

●Lead effort for historical problem resolution by documenting issues sufficiently in sharepoint

●Provided ad-hoc reports and data validation using SQL, Advanced Excel, and pivot tables

●Met with SME on multiple systems to discuss requirements, scope, create mockups and functionality

●Performed Code and Document Reviews to ensure adherence to enterprise processes, policies, and standards per SDLC

●Participated in releases moving code to production and testing per SDLC

●Created complex queries in T-SQL for problem resolution, updating data and reports

●Awarded for excellent customer service

●Mapped and loaded data back and forth between Excel and T-SQL

●Created test scripts and performed regression testing, functional testing

●Assisted in auditing of the sign level table with accounting

Programmer

Garrison Enterprises, Charlotte, NC Feb 2006 – Jan 2008

●Modified multiple systems to improve productivity, efficiency, and accuracy of business operations.

●Developed code, system design and test/QA plans for several new systems and coordinated the rollout.

●Provided customer support for older systems and any new system I created.

●Enhanced company image by creating a weekly feed of inspections to the State of NC.

●Cleaned, mapped and imported data from Access or Excel to T-SQL

EDUCATION

Virginia Tech, Blacksburg, VA

BS Business Management, Finance

Virginia Western Community College, Roanoke, VA

AS Data Processing

Contact this candidate