OBJECTIVE:

Remote SQL Server Developer

SUMMARY:

• Senior T - SQL, SSIS, SSRS, and MSBI Developer with PM, BA, and Leadership experience
• Database, and report developer experienced in: documentation; design; coding; testing; implementation; and maintenance of: relational and multi-dimensional databases; database applications; enterprise reporting; user interfaces; data interfaces and migrations; and data analysis using: Office 365; SQL Server; SharePoint; Microsoft Office; Microsoft Access; and Visual Studio programming environments.
• Additional expertise includes: effective PM practices, effective BA practices, gathering and documenting user requirements; production support; ad-hoc reporting; data trending and analysis; end user support and training; and administration of Microsoft web, database, file, and domain servers.

TECHNOLOGY:

• SQL
• DBA
• SSIS
• SharePoint
• Data Analysis
• Prod Support
• VBA
• Excel VBA
• Testing & Debug
• SQL Server
• Interface Design
• C#.Net
• Database Design
• T-SQL
• SSRS
• VB.Net
• Reporting
• Offsite Teams
• Visual Studio
• VBScript
• Offsite Dev
• Microsoft Access
• Word VBA
• Office 365
• User Support
• IT Leadership
• Oracle PL-SQL
• Web Dev

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

SQL Developer, SAS Developer, Internal Auditor

Environment: SAS, SQL Server 2014, Microsoft Office, SharePoint, Lync

Responsibilities:

• Analyzed SAS and SQL Server Data processes to validate internal audit results prior to further submission

Confidential, Fort Worth, Texas

SQL Server Developer, Team Lead, Project Manager, Business Analyst

Environment: SQL Server 2012, Office 365, Microsoft Office, Azure, SharePoint, Visual Studio, Skype, Microsoft Project, Microsoft Access

Responsibilities:

• Developed backend databases in SharePoint for Microsoft Access applications to enable use from anywhere capability
• Developed Microsoft Access application using Azure SQL Server database to enable remote users
• Performed setup, configuration, architecture, and administration of Office 365, and SQL Server business systems
• Migrated large email based business from Exchange to Office 365 enabling archive and enterprise search capabilities
• Collaborated with teams (PM, BA, and Developer) and business users using online practices and technologies
• Facilitated collaboration on project management, system documentation, and business discussion/agreements

Confidential, Dallas, Texas

SQL Server Developer - Finance Analytics

Environment: SQL Server, SSIS, T-SQL, SSAS, Tabular Data Models, Excel, Team Foundation Server

Responsibilities:

• Developed complex reporting functionality to support Finance Analytics operation for Retail Dairy Sales BI
• Administered SQL Servers in Test and Development environments and implemented change control practices
• Supported Finance Analytics Analysts Department in conversion to, and adoption of, new SDLC processes
• Consulted on conversion of Microsoft Access and Excel BI processes to SQL Server SSAS Tabular Data Model platform

Confidential, Wichita, Kansas

SQL Server/SSRS Developer

Environment: SQL Server 2012, Visual Studio, SQL Server Data Tools, Microsoft Office 2010, Lync 2010, Citrix, Simplement SAP Data Liberator

Responsibilities:

• Developed 30 SSRS reports and SQL Stored procedures from business functional specifications
• Developed standardized system for leveraging Simplement SAP Data Liberator software for reporting purposes
• Created development processes and document templates converting 200 SAP Transaction Screens to SSRS Reports
• Created technical specification documentation identifying gaps and engaged business to fill gaps in technical specs

Confidential, Lisle, Illinois

SQL Server Developer

Environment: SQL Server 2008 R2, Visual Studio 2010, Team Foundation Server, Lync 2013, WebEx

Responsibilities:

• Developed and implemented Hospital Claims Processing for use by Affordable Care Act clients
• Developed changes to large multiple build/version software application using Agile methodology
• Designed flow charts of complex components to clarify and communicate system functionality
• Acted as technical SME for claims processing functional area of Healthcare Administration software product

Confidential, Franklyn, Tennessee

SQL Server Developer, ASP.Net Developer

Environment: SQL Server 2012, SSRS, Visual Studio 2010, ASP.Net, SharePoint Access Services, Microsoft Access 2003 - 2010

Responsibilities:

• Developed dynamic code generating SSRS reports against numerous Microsoft Accounting 2008 databases
• Developed imbedded SSRS reports in ASP.Net web application for an Energy Audit vendor
• Developed geolocation mile radius criteria in SSRS reports for Community College Alumni seeking College events
• Upgraded server OS and developed modifications to ASP.Net Web Application with Infragistics controls for NY Law Firm

Confidential, Plano, Texas

SQL Server Developer, Vice President, IT Department Manager

Environment: SQL Server 2008 R2, SSIS, SSRS, VB.Net, C#.Net, Encompass Banker, Encompass SDK

Responsibilities:

• Managed an offsite team of 8 including admin, project manager, business analyst, and developer resources
• Developed Operational Data Store of Loan Origination System data using SSIS, Encompass SDK, and VB.Net
• Developed initial SSRS Reports for operational data supporting administrative and business users
• Established online collaboration and teaming practices and standards for Enterprise IT operation
• Engaged company leadership to improve operation efficiency and managed projects to accomplish company objectives

Confidential, Richmond, Virginia

SSRS Developer - Consumer Banking Risk Analytics

Environment: SQL Server 2008, SSRS, T-SQL, VSS, Excel

Responsibilities:

• Developed complex reporting functionality to support Risk Analytics operation for Retail Mortgage Lending business unit
• Designed data mining for newly implemented Mortgage Insurance Rescind and Loan Repurchase tracking systems
• Analyzed sophisticated SAS and Excel reporting processes to automate them in SSRS and eliminate manual effort

Confidential, Dallas, Texas

SQL Server Developer

Environment: SQL Server 2005/2008, SSIS, T-SQL, RedGate, Team Foundation Server 2010

Responsibilities:

• Developed optimizations to transaction and reporting systems for multiple business units using SQL Server
• Developed optimizations to Non-Performing Loan Model to enable 10 times more data to be generated and stored
• Defined and implemented code review and release processes for startup IT department enabling business approvals

Confidential, Dallas, Texas

SQL Server Developer / C# ASP.net Developer

Environment: SQL Server 2005, SSIS, SSRS, T-SQL, VB.Net, C#.Net, ASP.Net

Responsibilities:

• Developed ETL process incorporating Agents of insurance partners into strategic alliance system using SSIS
• Developed enhancements to C# ASP.Net Web Application to in corporate new business rules and functionality
• Developed and documented ETL systems of insurance broker data migration to merge acquired organizations

Confidential, Tulsa, Oklahoma

SQL Server Developer, Oracle Developer

Environment: SQL Server 2008, SSIS, Oracle 10/11, T-SQL, PL/SQL, VB.Net

Responsibilities:

• Developed data extract and Load of Gas Capacities for Public Website to comply with Federal Energy Regulations
• Developed complex SSIS processes to integrate Natural Gas Flow Measurement Data into new application
• Developed very large Oracle SQL Queries performing complex extraction from very large databases
• Developed VB.Net processes in SSIS packages to meet complex business requirements to follow regulatory rules

Confidential, Dallas, Texas

SQL Server Developer

Environment: SQL Server 2000/2005/2008 , SSIS/SSRS, Oracle, PL/SQL, SQL Replication

Responsibilities:

• Developed Executive BI Dashboard database and SSIS processes to combine KPI data for 2 merged companies
• Developed data transformations in SSIS for XML based EAI to merge operations into customer facing vendor portal
• Developed SSRS reports for end user validation of data in an Enterprise System Consolidation Application
• Administered refresh of Development and QA environments for Enterprise Operational Data Store systems

Confidential, Hurst, Texas

Oracle PL/SQL Developer / Microsoft Access Developer / Data Architect

Environment: Oracle 9.2, PL/SQL, Microsoft Access/Excel/Word, VBA

Responsibilities:

• Developed and tested over 250 MS Access queries converted to Oracle PL/SQL producing identical parallel output
• Developed analysis, requirements documentation, and test plans to convert Microsoft Access system to Oracle
• Architected large Oracle database to house complex diversity reporting data converted from Microsoft Access
• Generated large amounts of PL/SQL code for comparison process using VBA to perform forensic validation of data

Confidential, Plano, Texas

SQL Server Developer / Technical Team Lead / Database Architect

Environment: SQL Server 2005/2008, SSIS, T-SQL, Microsoft Access/Excel/Word, VBA

Responsibilities:

• Architected T-SQL Loan Boarding System transforming text files from selling Servicers into data for Loan Boarding
• Automated File Library Maintenance and CSV Generation from Excel data files using Microsoft Access
• Automated Text Parsing of Mainframe reports into CSV data files using Microsoft Word to complex specifications
• Lead a team of 5 (2 BA’s and 3 SQL Developers) in small iteration methodology to speed implementation times

Confidential, Ft. Lauderdale, Florida

SQL Server Developer / HR Interface Developer / Application Developer

Environment: SQL Server 2000/2005, DTS/SSIS, Microsoft Access, VBA, T-SQL, Citrix, Lotus Notes

Responsibilities:

• Developed case management and code generation app in Microsoft Access automating development/billing/productivity
• Developed T-SQL Stored Procedure text file interface processes for major health care and financial vendors
• Upgraded DTS Packages to SSIS replacements migrating client environments from SQL Server 2000 to SQL Server 2005
• Mentored team members on in-house interface framework, consulting practices, and development productivity

Confidential, Richardson, Texas

SQL Server Developer / Admin

Environment: SQL Server 2000, Oracle 9 & 10, DTS, Access, VBA, T-SQL, VB Script, Visio, ERWin, Model Manager

Responsibilities:

• Architected Enterprise Data Capture of Logins for SQL Server and Oracle using DTS for permission Cleanup Project
• Modeled and developed databases housing Network Security Data in SQL Server with ETL Processes in DTS
• Documented Data Segmentation and Process Flows in Visio to clarify approach with Team and Management approach
• Identified and eliminated obsolete database logins per best practices to meet regulatory requirements

Confidential, Dallas, Texas

SQL Server Developer / Database Architect

Environment: Team Foundation, Visual Studio 2005, Win 2003 Server, SQL Server 2005, T-SQL, SQL Server Integration Services, C#, Visio, TFS

Responsibilities:

• Architected data migration and databases for migrating large AS400 application to SQL Server and .Net
• Developed C# routines to generate SSIS Packages from Microsoft Access data map automating migration development
• Administered SQL Server Test, Dev, and QA environments supporting a team of 8 developers
• Coordinated system architecture with development team and documented large application architecture requirements

Confidential, Las Colinas, Texas

SQL Server Premier Support Engineer

Environment: Win 2003 Server, SQL Server 2000, T-SQL, Clarify, Visual Knowledge Base

Responsibilities:

• Supported Microsoft SQL Server Premier Customers and Partners resolving incidents and advisory questions
• Utilized 32 bit Windows internals knowledge for debugging SQL Server 2000 on Windows 2000 and 2003 servers
• Utilized SQL Server 2000 internals knowledge to resolve data corruption, data recovery, and performance tuning issues
• Analyzed diagnostic data to troubleshoot problems with SQL Server 2000 performance, corruption, and data recovery

Confidential, Plano, Texas

Oracle Data Warehouse Integrator

Environment: Win XP, UNIX, Oracle, PL-SQL, KShell

Responsibilities:

• Designed and developed conversions of reporting extracts from mainframe database data to new data warehouse
• Implemented development, parallel test, and production code in complex environment with complex methodology