Developer Sql Server
Resume:
Matthew Livingston
Clearwater, FL 33762
************@*******.***
Objective: Interview for employment
MCSE: Data Management and Analytics obtained 12/2017
I maintain and develop a SQL Server ETL environment using SSIS, reporting in SSRS. The process extracts data from Oracle/PeopleSoft databases and loads into SQL Server 2008 for reporting and analysis. I work with various departments in large organizations to develop and document business processes, and internal controls, streamlining, eliminating and automating steps in the process before documenting the process, implementing and augmenting security on these processes.
EXPERIENCE
Supporting a department of 114 people in 5 groups I was the primary point of contact for technical guidance to the department. I was involved in the development road map for data enrichment tools, and I was the primary liaison with the IT department responsible for setting priorities for enhancements and bug fixes.
Designed and implemented ABRA (American Bar Retirement Association) Plan re-qualification System. This system produces the twenty eight-page plan contract for each of the 4,700 law firms in department. Using Access/VBA and ODBC the system imports a flat file download from the mainframe and produces custom retirement plan contracts for law firms.
Traditional IRA’s and 403(b) RMD Required Minimum Distribution Compliance. Built Excel spreadsheet and Access database system necessary for participants to meet traditional IRA’s and 403(b) RMD required minimum distribution regulations. Producing calculations, for twelve hundred participants each year, necessary to file form 1099 with the IRS.
Responsible for auditing the spreadsheets in our department for Section 404 Sarbanes-Oxley compliance. Working in a department of 63 people I categorized and documented the complexity, calculations, and purpose of each spreadsheet as well as the number of users and the uses of the spreadsheet output. I developed a change control-tracking database of the spreadsheets in our department, and applied security on the spreadsheets. The change control system is used to meet section 302 SOX compliance (Continuous Evaluation).
IRS 5500 Forms and Schedules filing. Responsible for obtaining the information, and producing the 5500 forms and related schedules each year for 4,700 law firms. The 5500 forms is the Annual Return/Report of the employee benefit plan, which we file annually with the IRS. These were signature ready forms and schedules we produced and sent to the clients to be filed with the IRS.
Designed and built the Microsoft Access Stock Purchase/Sell authorization-tracking system necessary to meet Sarbanes-Oxley compliance. The system is tied into, Bloomberg Financial reporting system, for real time pricing. This system is used to track all the authorizations of all the purchases and sales in 12 different mutual funds the department oversees.
SOFTWARE EXPERIENCE
MCSE Microsoft Certified Solutions Expert Data Management and Analytics
Microsoft Certified Professional 70-306 Developing Windows Applications with Visual Basic.net and C#
ASP.net MVC application development
Expert Access Database Developer / Excel Spreadsheet Developer / VBA Developer
Crystal Reports Developer
Advanced VB.net and C# Developer, WPF and WCF
Advanced Visual Basic.net, ADO, ADO.net
BUSINESS EXPERIENCE
Developed and conducted training program for three hundred users for the Rational ClearQuest Defect Tracking Application, including building video demonstrations for offshore contract employees.
Led numerous groups gathering software requirements, and building Application Functional Documents in Rational Requisite Pro
Understanding of the Software Development Life Cycle (SDLC) and Rational Unified Process (RUP) and Sarbanes Oxley regulations
Trained in the Six Sigma methodologies and worked on several Six Sigma projects
EMPLOYMENT HISTORY
SQL Server Developer / Report Writer Jan 2017 - Aug 2017 City of Tampa, FL
Wrote sophisticated Stored Procedures, Triggers, Functions to create SSRS reports for City of Tampa, data aggregation
and auditing reports for senior management decision makers. Wrote SSIS packages to import data from Oracle and Active
Directory . Obtained my MCSA SQL Server 2016 Database Development certification, and am pursuing my MCSE in Data
and Analytics.
SQL Server Developer / Data analyst Feb 2016 - Nov 2016 WellCare Tampa, FL
Redesigning consolidating and optimizing legacy Access databases w/ VBA Functions and migrating them into SQL Server 2012. These databases will be used as the backend for Tableau the data presentation application. Analyzing healthcare data and building custom reports in SAS for delivery to internal business customers.
Application Developer, .net/SQL Server 2008 Dec 2014 – Dec 2015 UnitedHealth Group, Tampa, FL
Support and extend enterprise level, global insurance claims processing ASP.net website, written in VB.net and MVC with a SQL Server 2008 backend. I write and troubleshoot numerous Extract, Transform, and Load (ETL) packages written in SSIS 2008/2005
Jr. SQL Developer, SSIS Developer (contract position) Jan 2014 – Sep 2014 St. Petersburg College, Clearwater, FL
Built numerous SSIS ETL packages to extract data from Oracle/PeopleSoft database into SQL 2008 database tables. The packages are for incremental and full extracts. Worked with team members building and documenting sophisticated Excel formulas, charts, and graphs in Excel 2010. I routinely write sophisticated T-SQL Queries and Stored Procedures in SQL Server 2008.
Application Developer (position migrated to Maryland) 2012 - 2013 ValueOption, Tampa FL
Maintained and developed Data warehouse Reporting Suite in vb.net and C#. The suite contained 85 reports necessary to
comply with Medicaid regulations. The data warehouse contained 1500 tables containing 100's thousands of records and 1000 complex T-SQL stored procedures. I was the sole developer responsible for maintaining six other applications for auditing medical provider performance, license tracking, medical provider staffing, and HEDIS reporting (Healthcare Effectiveness Data and Information Set). Produced HIPAA EDI 837 Files for Medicare reporting requirements
Senior Legal Auditor 2005 – 2011 First Advantage, St Petersburg, FL
Designed and built a database to automate the auditing and compliance for 39 subsidiary companies. The database houses the company’s information, procedures, and practices and tracks compliance with the FCRA (Fair Credit Reporting Act), DPPA (Drivers Privacy Protection Act), In House Legal Compliance Questionnaire. In 2010 the company was sold and the positions moved to California.
Senior Business Analyst / IBM Rational Tools Developer CitiStreet (joint venture between CitiGroup and
2000 - 2005 State Street Financial) Quincy, MA
Maintained excellent, near perfect scores, 4.8 out of 5.0, in all categories in each of the last 5 yearly performance
reviews evaluations. Working with various teams, I was responsible for identifying workflow problems, and enhancing business processes. Developing project workplans, tracking issues, writing business requirements, and functional specifications. I developed applications in Visual Basic, C# and SQL to resolve many of the business problems I identified.
EDUCATION
2003 Bridgewater State Bridgewater, MA
Programming in C++ II
1999 Worcester Polytechnic Institute Worcester, MA
18 week course in Windows NT Network Administration
87-90 Worcester State College Worcester, MA
Contact this candidate