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.
• PM practices, effective BA practices, gathering and documenting user requirements; production support; ad-hoc reporting; data trending and analysis; end user support and ; and administration of Microsoft web, database, file, and domain servers.

TECHNICAL SKILLS:

Technology: SQL DBA SSIS SharePoint Data Analysis Prod Support VBA Excel VBA Testing & Debug 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 - Fort Worth, Texas

SQL Server Developer

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Confidential - Plano, Texas

SQL Server Developer / DBA / Data Warehouse Developer

Responsibilities:

• Modeled, designed, developed, and implemented relational and multi-dimensional databases
• Developed DTS load and update processes for relational, multi-dimensional, and cubed data for refresh and integrity
• Implemented, administered, and maintained 20+ SQL Server 2000 databases on 12 Windows 2003 Servers
• Implemented database development standards using Visio, Visual Studio 2003, and Visual Source Safe
• Coordinated, collaborated with, and managed 3 overseas SQL Developers to cost effectively develop databases

Confidential - Plano, Texas

Entrepreneur, Owner Operator, and Database Application Developer

Responsibilities:

• Operated Software Consulting Firm to design, develop, implement, and support database software systems
• Mentored junior programmers in development standards, application development technique, and testing procedures

Confidential - Corinth, Texas

Responsibilities:

• Developed project management, estimating, budgeting, facility assignment, and service order database systems
• Coordinated development team of 3 programmers to implement enhancements and system version update releases

Confidential, - Dallas, Texas

Responsibilities:

• Designed, developed, and supported time and billing, electronic data interchange, and bulk billing systems
• Supported database and software issues for 100+ user law firm

Confidential - Roanoke, Virginia

Responsibilities:

• Designed, developed, implemented, and supported time and billing system
• Reduced weekly billing cycle from 3 days with 3 clerks to 2 hours with no clerks
• Reduced monthly billing cycle from one week to one day

Confidential - Richmond, Virginia

Responsibilities:

• Designed, developed, implemented, and supported project estimating, project tracking, and funding request systems
• Automated funding approval processes of legacy system reducing the submittal process from weeks to days

Confidential - Fort Worth, Texas

Database Application Developer/Analyst

Responsibilities:

• Designed, developed, and implemented: Sales, Estimating, BOM, Purchasing, Job Tracking, Labor, and Payroll systems
• Converted paper based manufacturing company processes to Visual Basic and Access database systems

Confidential - Plano, Texas

Senior Programmer Analyst

Responsibilities:

• Analyze Year 2000 modification efforts for Enterprise Human Resources mainframe CMS/VMS FOCUS environment
• Identified that 90% of 2 million plus lines of FOCUS code was obsolete and could be retired through data analysis

Confidential - Plano, Texas

Senior Programmer Analyst

Responsibilities:

• Support annual salary planning cycles for 1998 and 1999 through system setup, modification, and report development
• Enhance user interfaces to show vital information, optimize nightly batch, and eliminate paper based systems

Confidential - Richardson, Texas

Database Application Developer

Responsibilities:

• Design, develop, migrate, implement, and support project estimating, submittal, tracking, and contact management
• Isolate project cost over-runs and estimation flaws enabling engineering management to react preemptively

Confidential - Plano, Texas

Database Analyst / Senior Programmer Analyst - Human Resource Information Systems

Responsibilities:

• Acted as primary HR reporting support maintaining libraries of 500+ batch mainframe jobs and 30,000+ reports
• Developed 10+ in-house HR applications and 5,000+ ad-hoc and scheduled HR reports over 2 years
• Designed, developed, and supported conversion of HR reporting from mainframe FOCUS to PeopleSoft HR

Confidential - Hackensack, New Jersey

Senior Programmer Analyst

Responsibilities:

• Develop, document, test, and implement enhancements to Pricing and Order Entry systems
• Mentor 2 junior consultants in development standards, estimation of requirements, and testing with COBOL/DB2/CICS

Confidential - Warren, New Jersey

Senior Programmer Analyst

Responsibilities:

• Implement breakpoint testing environment for legacy Auto Insurance System using COBOL, IMS, and XPEDITER
• Resolve programming, testing, and implementation issues meeting Service Level Agreement guidelines

Confidential - Paramus, New Jersey

Senior Programmer Analyst

Responsibilities:

• Design, develop, test, and implement addition of currency conversion markup to international shipping systems
• Streamline testing process by emulating the production environment reducing testing phase by 3 weeks

Confidential - Harrison, New Jersey

Programmer Analyst - Financial Systems

Responsibilities:

• Hired prior to finishing mainframe programming into corporate financial systems team
• Completed an estimated two year backlog of requirements in approximately 6 months