SUMMARY:

Employ hands - on experience in cost-effective, multi-tiered, high-performance distributed enterprise applications across industries including card processing, talent acquisition, tank management, move-add-change management, claim processing. Develop strong client relationships using exceptional interpersonal skills. Expertise in all facets of product life-cycle development from gathered requirements, designed, architected, developed, optimized and performance tuned, tested, and implemented.

TECHNICAL SKILLS:

Platforms: Windows XP, Windows NT, Linux, Solaris, AWS hosting

Languages: TSQL, SQL, VBA, VB.Net, C#, VB script, JavaScript, PowerShell, ASP

Relational Database: SQL Server 6.0-2014, MySQL, Aurora, Oracle, DB2, Teradata

Management System (RDBMS): SSMS, SSRS, SSIS, SSAS, Visual Studio, MySQL Workbench, Toad, QlikView, Tableau Microsoft Office Automation

Project Management &: Microsoft Project, Quality Center, Team Foundation Server, JIRA, CVS, Wiki, Visio

Version Control: Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential, Woodland Hills, CA

SQL Server DBA, Developer, and Report Engineer

Responsibilities:

• Collaborated with clients and internal teams to architect, design, and develop enterprise solutions involving 50 SQL Server and MySQL databases, 2 SSRS websites, and 10 QlikView dashboards.
• Developed multiple on-line analytical reports using SSRS and QlikView for clients, senior management, and company teams saving the company and clients many hours of manual work.
• Optimized and tuned complex queries and data extractions from data sources.
• Used SSIS and other tools to create ETL packages to summarizing data for reports and mass updates for data warehouse, including files over 300 gigabytes in size.
• Created scripts and reports showing the health of the enterprise system which included; documenting job error history, drive free space, and general health of the RDBMS systems.

Confidential, Frisco, TX

SQL Server DBA, Developer / .NET Developer

Responsibilities:

• Partnered with company management to architect, design, and develop solution to track coaches and trainers time to generate necessary payroll data.
• Instituted database to store all payroll information needed for payroll calculations; coaches, trainers, classes taught, students, and time worked enabling payroll calculation bases on multiple variables.

Confidential, Glendale, CA

SQL Server DBA, Developer

Responsibilities:

• Interacted with Disney’s divisions to create IT Salesforce tickets for deploying software patches and upgrades to 1K worldwide proprietary servers using TSQL and PowerShell scripts.
• Maintained database that stored server information and assigned contacts, time windows for upgrades, and patching information established by Microsoft and RedHat streamlining creation of the Salesforce tickets.

Confidential, Glendale, CA

SQL Server DBA, Developer

Responsibilities:

• Collaborated with partners and company teams to design, and develop enterprise solution to track the Executive Search Application
• Re-engineered and rationalized company data for new Global Warehouse, consolidating 20 different global databases.
• Created TSQL scripts on cleaned-up and centralized data for data warehouse, working with database sizes ranging from 1 terabyte to 200 gigabytes and incorporating historical information going back 25 years.
• Developed reports using SSRS for managerial and audit reports summarizing the data into grids, lists, and graphical representations.

Confidential, Richardson, TX

SQL Server Developer / .NET Developer

Responsibilities:

• Partnered with clients and company management to architect, design, and develop gas tanks solutions to increase the accuracy of gasoline loss.
• Built a tank chart correction application using .Net C# Windows Application and SQL Server 2008.
• Improved precision in volume calculations the company used for tracking stolen gas or tank leakage, increasing accuracy by 50%.
• Established web application to show the loss of gasoline from tanks comparing POS sales and volume readings from tanks.
• Increased accuracy 100% by enabling reported losses to be calculated to the minute to find stolen gas from specific dispenser or long-term loss from leaks.

Confidential, Plano, TX

SQL Server Developer / .NET Developer

Responsibilities:

• Created a Move-Add-Change Ordering system, leading to implementation throughout Texas Instruments for services Confidential technicians used to perform their contracted jobs.
• Elevated the number of tickets technicians could complete by creating TI-specific tickets to detail required duties and record specific charges, following contractual guidelines.
• Increased efficiencies of HR personnel to complete customized documents 70% by re-engineering US Employee Reduction Tool from MS Access application to .NET VB web application.
• Instituted web application for Due Diligence department to monitor process of creating future Confidential client contracts by creating status tracking, budget tracking, contract tracking, and risk analysis reports.
• Boosted productivity of each auditor 40% by designing application to ensure feasibility of making targeted margin on each contract signed.