SUMMARY:

• SQL Server database administration and development, VB.net, server side automation, Project Management. Transact - SQL, and Visual Basic.net. Special expertise in banking, finance, and DOT aviation data warehouses.
• Current warehouse methods prove the ability of using large relational databases and data warehouses to perform mammoth tasks for flight control and revenue management with reliability and with lightening speed. Focused but not limited to Financial, DOT, DOD, Medical, and “Compliant” content management.
• Data analysis including team and meeting leadership, software writing, Ad Hoc and SDLC requirements gathering.

TECHNICAL SKILLS:

DATABASES: Microsoft SQL Server 2016 / 2014 / 2012 / 2008 / 2005 / 2000 , MS Access, HPCC, Azure.

Development Environments : Visual Studio, SSMS, SSIS - ETL, SSRS, SSAS, T-SQL, DTS, ASP.net, VBA, MS Access, Office Automation Objects

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Big Data / SQL Data Development & Data modeling
• HPCC (High Performance Computing Cluster) and big data processing and analytics
• Data refinement and ETL transforming structured or unstructured big data from diverse sources.
• Diverse Sources include MS Sql Databases, Oracle, IBM DB2, Excel, Access, text and xml files.
• Data delivery and real time querying and data warehousing
• Use of Confidential programming language integrated development environment

Confidential

Responsibilities:

• DBA and data development using dimensional modeling techniques. SQL server database warehouse and a variety of relational databases.
• Development using Visual Studio 2015 and SSMS
• SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Troubleshooting of an in-house Phoenix supply chain system with a bridge to JD Edwards Accounting.

Confidential

Consultant

Responsibilities:

• Database development dimensional models of SQL server data base warehouses and data marts.
• Data integration /ETL from a large variety of Excel workbooks to SQL server star schemas.
• Deployment from Visual Studio 2013 on to SQL Servers 2014.
• SQL Server Reporting Services
• Deployment and maintenance of production funding systems

Confidential

SQL Server ETL / Data Warehouse /VB.Net Developer

Responsibilities:

• Development of SQL databases and data warehouses for Flight Track and Revenue departments. Responsible for upgrading and maintenance of large databases, driving through millions of records from all well known reservation systems and real time flight control data transmitted by an array of GPS systems. Database conversion of diverse data feeds from their international partners. The primary databases and data warehouses makes data available to DOT and Global flight control systems. Microsoft technologies include SQL 2008R2 Enterprise (SSMS), T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Server, (SSAS), and SQL Server Reporting Services (SSIS). ANSI SQL languages include “JET” query technologies. All systems and sub systems are anchored with SSIS - ETL and VB.Net automation. MS Access. Most jobs depended on me for requirements gathering, user interface, team leadership, and software writing.
• Converted Crystal Reports to SSRS Microsoft Reporting Services
• VBA for the automation of price structure changes to airline reservation web orders, i.e. Google, Amazon, and MSN affiliates. All jobs depended on me for requirements gathering, user interface, and Software writing.
• Confidential (Change Data Capture) for real time flights tracking and delays. Within the array of databases, these systems and sub systems included data synchronization for 1) batch and 2) real time data capture. Integration packages are created using .Net / SSIS - ETL automation, server side scripts, T-SQL, stored procedures, and VB.net.
• Data integration of the company’s six major regions, converting data feeds of all possible formats including Web Services’ XML, legacy text, files transmitted via secured FTP connections, MySQL, Oracle, DB2, and an array of third part SQL servers v.20005-v.2012.
• File system storage includes hardcopy and electronically scanned DOT compliant documents. Documents and file system controls in corporate VB.NET and Microsoft’s object oriented technologies and the .Net framework(s).
• Deployment and maintenance of flight and revenue sub systems

Confidential

SQL Server ETL / Data Warehouse / VB.Net Development

Responsibilities:

• Development of SQL databases and data warehousing for their financial department. Currently converting an Excel system of KPI reports to a data warehouse. The system still drives through billions of records for their national customer base. This warehouse cubes storage items reporting on new additions, removals, cubic feet of storage, and dollars. Microsoft technologies include SQL 2008 Enterprise (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Server, (SSAS), and SQL Server Reporting Services (SSIS). MS Access. All jobs depended on me for requirements gathering, user interface, team leadership, and Software writing.
• Confidential (Change Data Capture) for real time tracking of secure document pickup and delivery and real time Business Intelligence. Within the array of databases, the sub systems included data synchronization for 1) batch and 2) real time data capture ( Confidential ). Integration packages were created using .Net / SSIS - ETL automation, server side scripts, T-SQL, stored procedures, and VB.net. MS Access.
• Large Sql Server integration of the company’s three divisions converting three sql server 2000 databases into one sql server 2008 enterprise system.
• This system includes Business Intelligence for items and documents stored by type, company, and date. Storage includes hardcopy and those electronically scanned. Documents and file system controls in corporate VB.NET and Microsoft’s object oriented technologies and framework. Including MS Access.
• Database architect and developer for document control and storage of the following professional groups: Medical, Defense, Legal, CPA’s and Pharmaceutical along with major hospitals and laboratories. Developed and maintained Crystal and SSRS reports and databases using state of the art Microsoft platforms. Systems and record keeping are under strict government guidelines for document control. Including MS Access.
• Deployment and maintenance of production systems

Confidential

SQL Developer / VB Developer

Responsibilities:

• Developed and maintain SQL scripts, indexes and complex queries for data analysis and ETL extraction using SSIS, MsAccess, SQL Server Analysis Server and SQL Reporting Services using T SQL, Stored Procedures, and User defined functions. All jobs depended on me for requirements gathering, user interface, team leadership, and software writing.
• Use of Visual Studio 2005/08 in the development of SSIS - ETL packages for integration of Home Loan Portfolio data into a “Consumer Direct” warehouse housed in SQL Server Analysis Service. The Consumer Direct warehouse consisted of dimensional aggregates of their Home-Loan Portfolio specifically named “First Mortgages”, Equity Lines Of Credit”, Loan Modifications, and “Imminent Default”.
• Visual Studio.net SSIS - ETL “kick off” procedures in real time programmed in MSAccess, VBA, Visual Basic and ASP.net.
• Developed portal based SSRS reports for business analytics for the Business Intelligence (BI) team.
• Developed and maintained a SQL database for Confidential call center telephony data.
• Perform Data Mining and joining data warehouses from multiple sources for production statistic
• Defined criteria and datasets for the Business Analytics team.
• Extensive troubleshooting, optimizing and creation of stored procedures in SQL 2000/ 2005 / 2008.
• Aided in development, execution and maintenance of disaster recovery plans.
• Worked with project managers, developers and production teams to identify business needs and solution options
• Work closely with database administrators and database security personnel on application and system scripts for secure database implementations.
• Software writing of functional specifications, data modeling, flow diagrams, instructional manuals, disaster recovery documents, test scripts for Business Infrastructure
• Deployment and maintenance of Loan Modifications sales subsystems

Confidential

Database Developer

Responsibilities:

• Real time SQL database programming for document control ( Confidential )
• Real time SQL database programming of a sales reporting system for finance
• Data federation of Microsoft’s Great Plains system for real time ad hoc real reporting
• Continued service on an ongoing / on call basis where I work for the VP of operations on database additions, maintenance, and quality assurance.
• Responsible for FDA validation requirements on systems and the maintenance of sales analysis reporting using general accepted accounting procedures.
• Extensive use of Microsoft Automation objects and MS Access for the auto propagation of datasets to Excel sheets and tabs.
• Development and administration include systems analysis and programming of user defined functions and controls in MS Access, SQL, VB.net, VBA, ADO.
• Extensive use of Microsoft Automation objects for auto propagation of datasets to Excel sheets and tabs.
• All jobs depended on me for requirements gathering, user interface, team leadership, and software writing.

Confidential

SQL / VB Developer

Responsibilities:

• Consultant / trainer familiarizing other programmers with the details of Microsoft SQL Server, ASP, Visual Basic, and Microsoft operating systems and network protocols.
• Data integration using SQL/ Microsoft Access, and Visual Basic including a) mainframe to micro integration, b) Lotus notes to MS Access, C) Word perfect tables to MS Access, and d) Oracle and SQL Server to MS Access.
• Technical writing and controlled releases of software documentation
• Automatic replication procedures for installations of Microsoft based applications, including dynamic linked libraries, licensing issues, and purchases.
• Extensive bank software and hardware inventory reporting using MS access, and SQL Server Reporting Services,
• All jobs depended on me for requirements gathering, user interface, team leadership, and software writing.