SUMMARY:

• Extensive experience in programming and database development on diverse platforms. Strong focus on achieving efficiencies, problem resolution and task automation. Recognized for identifying problems and developing innovative solutions. Major strengths include:
• Database Design
• Research & Analysis
• Written Presentation
• Hardware Maintenance
• Problem Solving
• Organization
• PL/SQL T - SQL
• SAP, Lawson ERP
• Instrumental in reducing number and frequency of errors in processing, by documenting processes and developing process checklists to ensure current process was understood and could be executed by anyone with minimal knowledge of the system.
• Increased efficiency up to 75% by developing automation tools leveraging Microsoft Office
• Quickly became subject matter expert on new technologies such as new backup software and database tools.
• Analyzed processes and systems to create new procedures to increase efficiency, including developing automation tools to replace time-intensive manual processes with more accurate processing tools
• Created detailed procedure documents to simplify processes, enabling tasks to be executed by offshore teams saving time and money.
• Assumed role of team DBA, after attaining diverse experience in database development and administration.

TECHNICAL SKILLS:

Hardware: IBM Mainframe, 3270 Terminal, IBM PC & Compatibles, DELL Servers, HP Servers, Stratus, DEC/Vax

Mainframe: COBOL, QMF, MVS/JCL & Utilities, TSO/ISPF, Panvalet, VSAM, Expediter Debugger

Software: Microsoft Office, DOS, Windows Server 2000, Windows Server 2003, Windows XP

Integrated Solutions: SAP R/3, SAP BW

Client Server Tools: Oracle PL/SQL & T-SQL, Visual Basic, VBA, .Net, SQL Server 6, SQL Server 2000, SQL Server 2005, SQL Server 2008, DTS/SSIS, Automate ETL

PROFESSIONAL EXPERIENCE:

Confidential, Richardson Texas

Sr. SQL Developer

Responsibilities:

• SQL Server Subject matter expert
• Created / Updated multiple T-SQL processes to extract / load / update data into the Epic system
• Updated SSIS packages to facilitate new drug processing for the Epic project
• Participated in team meetings for project and change control management
• Created and updated project documents on a timely basis

Confidential, Dallas Texas

Sr. SQL Developer

Responsibilities:

• SQL Server Subject Matter Expert
• Created multiple T-SQL Processes to extract, cleanse, aggregate and migrate data into new databaseInitiated Scheduled backups of Development Databases
• Created and Restructured Table schemas to improve data migration processes
• Ensured that new structure confirmed to data normalization guidelines
• Map Data elements from Legacy FoxPro / SQL Server 2012 to SQL Server 2016
• Developed data migration plan and processes of Legacy data
• Engaged in development meetings as data and schema expert for new system
• Actively Participated in daily team Scrum meetings
• Created and distributed development reports and data entry aids

Confidential, Dallas Texas

Sr. SQL Developer (Sample Developer)

Responsibilities:

• Developed SSIS Packages used to validate regulatory requirements for Confidential
• Interfaced with SQL Server, Teradata and Oracle databases
• Used SSIS in Visual Studio to Created Automated test procedures to generate audit data
• Used Multiple Proprietary Bank systems to facilitate all aspects of the development lifecycle
• Successfully interfaced with all levels of Bank Personnel gathering requirements and validating results
• Trained new developers on Bank processes and systems
• Modified Bank Stored Procedures to eliminate resource contentions when used by multiple users simultaneously
• Met or Exceeded all development timeframes, completing all projects on time

Confidential, Addison Texas

Sr. Database Developer / Administrator

Responsibilities:

• Developed Stored Procedures and functions to automate manual processes
• Database administration tasks as needed (Backups, user management, table access, indexes, etc.)
• Regularly interfaced with senior management regarding system performance and status
• Performance tuning of queries and stored procedures
• Primary developer for database design and process flow information
• Primary developer for automated database tools for support personnel
• Created and automated multiple reports using T-SQL and Visual Cron (ETL/Scheduler)
• Primary contact for analysis for several departments
• Created Audit reports to identify processing issues and processes outside of SLA
• Responsible for resolving daily data issues preventing order completion

Confidential, Fort Worth Texas

Database Developer

Responsibilities:

• Responsible for daily space allocation
• Responsible for resolution of database job issues
• Primary contact for secure credit card system login for two-tier security of system
• Primary contact for correcting user data errors
• Backup of technical help-desk for entire company
• Main developer of new data load and ad-hoc user reports

Confidential, Dallas Texas

Database Developer

Responsibilities:

• Automated manual processes for several banks data files received for RPM comparative reporting
• Developed processes to load disparate files into SQL Server using Automate ETL and SSIS
• Wrapped internal database data sources to comply with RPM Reporting requirements
• Automated daily audit reports for space, processing dates and file tracking
• Created & maintained extensive stored procedures, triggers, and views using SQL T-SQL on a daily basis.
• Coordinated Installation and “debugging” of Microsoft DTS compatibility module to enable team to maintain Legacy DTS Packages.
• Primary maintenance resource for 8 banks SmarterPay reporting daily processing
• Responsible for managing space and security on all reporting database sets
• Responsible for resolving processing complications due to power outages, network & data problems.
• Administered SQL Server resource requirements, backup policies and disaster recovery after drive failures and unexpected power outages.
• Developed ad-hoc reporting and process utilities using Microsoft SQL Server 2005 & SQL Server 2008
• Performed detailed data analysis to determine trending and limits in data
• Extracted and loaded data for testing, analysis, reporting and prototyping
• Performed limited DBA tasks for the Revenue Enhancement team’s databases

Confidential, Dallas Texas

Database Developer

Responsibilities:

• Integrated system testing on new implementation of SmarterPay product for new client
• Processed daily testing
• Validated and audited results against expected results
• Extracted data for validation between source values and loaded values
• Analyzed and proposed procedure to manage history data in multi-terabyte database

Confidential, Plano Texas

Production Support Analyst

Responsibilities:

• Supported multiple systems using .NET C# and LINQ languages.
• Provided system support and analysis using SQL Server 2005 and 2008.

Confidential, Plano Texas

Visual Basic Developer

Responsibilities:

• Developed new interactive reporting and analysis tool using Microsoft Excel and Microsoft Access, leveraging SQL Server database for a new major client in Canada.
• Included multiple charts comparing different versions of data for analysis
• Provided static and dynamic report capabilities.
• Provided reporting tools to create dynamic reporting.
• Provided auditing tools to validate reporting results.

Confidential

Senior Programmer / Analyst / DBA

Responsibilities:

• Administered 6 SQL Server instances including Database design, maintenance and Security.
• Designed multiple ETL interfaces to load data into SQL Server 2000 and SQL Server 2005 using Data Transformation Services (DTS) and SSIS.
• Managed 8 Servers Operating Systems, disc management, and hardware maintenance tasks.
• Ran & maintained Tape Backup system with scheduling backups, tape rotation & equipment maintenance.
• Created and maintained T-SQL code in Ad-Hoc and Stored Procedure situations.
• Created and maintained jobs in SQL Server for space maintenance and daily backups of all databases.
• Created Visual Basic and Visual Basic for Applications Tools to analyze data and interface with SQL Server to retrieve data to meet immediate and long term financial reporting needs of senior management.
• Instructed other team members in basic SQL Coding techniques and visual basic coding.
• Used SAP R/3 & BW tools to extract data from Confidential Data Warehouse for monthly financial reporting.

Confidential, Dallas, Texas

System Tester

Responsibilities:

• Participated in team that ran functional test scenarios in RETEK (Retail Processing Management) System

Confidential, Dallas, Texas

Senior Programmer Analyst

Responsibilities:

• Extract-Translate-Load Team - Wrote several programs using Asential Data Stage to copy segments of production and development databases to datasets or test databases to meet data testing requirements for Blockbuster development.
• Supply Planning Tool Upgrade - Updated Excel Visual Basic and PL/SQL Stored procedures to expand data requirements for this Blockbuster internal tool, enabling it to extract current stock levels and determine future purchasing requirements, based project demand from online customer requests.

Confidential, Arlington, Texas

Senior Programmer / Analyst

Responsibilities:

• Performed Lawson On-Call support.
• Maintained and Developed On-Call Documentation.
• Ensured that service levels exceed requirements.
• Trained co-workers in system processes.
• Developed and maintained PL/SQL and Access processes.
• Developed and maintained Oracle Forms and Oracle Report Objects.
• Developed management SLA reports and support dashboards from project tracking system
• Technical lead for reenrollment process.
• Coded and maintained Vax DCL and COBOL programs.
• Supported FoxPro CARI System - Custom AR reconciliation System.
• Registered as Subject matter expert for MS Access and MS Excel at Confidential .
• Developed forms for user input, reports, and integrated menus.
• Interfaced with Database manager to resolve Access and SQL Server issues.
• Created Tool written using MS Excel and VBA for Benefits Enrollment process.
• Developed and maintained excellent working relationships with all of my user contacts.
• Aided co-workers in support tasks as requested and/or needed.