OBJECTIVE:

• To gain employment in a progressive and well - managed organization where I can utilize and enhance my training, talent and experience in my chosen field of SQL Server Database Development or similar at a location in Phoenix metro or Southern California (not LA metro please).

SUMMARY

• 15+ years of experience in SQL Server (t-SQL) database development
• Very adept at designing, maintaining, and performance tuning and debugging stored procedures, functions; etc.
• Written t-SQL in complex, mission critical databases (DDL and DML)
• Highly adept with MS Excel (VLOOKUP, HLOOKUP, custom formulas, Macros, VBA; etc)
• Designed, created, and supported SQL Server databases for critical business systems
• Experience with SQL Server Integration Services (SSIS) for ETL
• Experience with SQL Server Reporting Services (SSRS), Crystal and Excel for reporting and analysis
• Experienced with application development using Agile and Waterfall methodologies using Team Foundation Services (TFS)
• Designed, built and supported numerous MS Access applications
• Worked extensively solving a wide variety of 3rd level database problems in a support mode
• Several years in management and leadership roles
• Quick and motivated learner; fast to adapt to new software and business environments
• Positive attitude, not afraid to work in unfamiliar areas
• EDI experience, including 810, 850, 824, 830, 856, 837, 997 transactions in 4010, 5010

TECHNICAL SKILLS

Application Programming: Visual Basic 6, VBScript, VBA, Progress, Service Pro

Database Programming: t-SQL, SQL Server R2 / 2012/ 2014, DDL / DML, Stored Procedures including performance tuning, Functions, Triggers, Constraints; SSIS, and SSRS; Microsoft Access / VBA

Operating Systems: Windows, familiarity with UNIX (AIX, HPUX)

ERP Systems: QAD MfgPro, BPCS, Symix SyteCentre

Application Software: Excel, Access, Word, PowerPoint, SPC / SQC packages, Outlook, MS Project, Visio, Team Foundation Server (TFS) 2013; Gentran Excel, Total-EDI

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

Sr. Database Developer

Responsibilities:

• Diagnosed and fixed many database problems using very little supporting documentation. Documented fixes and composed ERD’s to help everyone understand the database structures
• Designed and implemented (SSIS) Integration Services and Excel packages to perform ETL - scrubbing and transforming data to a format that the business partners could easily import into their databases.
• Improved stored procedure performance by tuning joins and implementing effective indices
• Designed, implement and deployed production reports to the dashboard and configures security and subscriptions
• Performed a great deal of AD-Hoc reporting and presented it in Excel
• Mentored a junior level Database Programmer

Confidential, Gilbert, AZ

Database Developer

Responsibilities:

• Created new SQL Server databases (3NF) to support new mobile apps, including new tables, schemas, foreign keys, indexing; etc. Created SSIS packages to populate the new database, stored procedures and functions to implement business rules and to interface with middle tier
• Designed and implemented database solutions to implement changing business needs using t-SQL, DDL scripting; etc
• Worked on trouble tickets to diagnose and fix a wide range of issues across all tiers of applications. Even though I am primarily a t-SQL developer, I can read and diagnose other code using my wide range of experience and intuition
• Actively participated in team development using Agile methodology
• Used MS Excel to analyze data, write code, summarize and aggregate using VLOOKUP, custom functions and formulas
• Created reports using SSRS and Excel
• Performed detailed analysis and scrubbing using Excel

Confidential, Warren, PA

Database Specialist / Sourcing Systems Specialist

Responsibilities:

• Researched complex database schema to retrieve data, then wrote SQL Scripts extracts data to generate reports for Senior Management, then presented results in Excel and SSRS
• Administered ERP systems (e-SPS and PDM), including managing user accounts, system security and troubleshooting issues
• Analyzed key areas of the database for data integrity.
• Worked on several IT projects, mostly t-SQL stored procedures and reports using Access and SSRS
• Performed ETL to gather data from server different formats (SQL Server, XML, flat files, Excel; etc.) to populate databases

Confidential, Tempe, AZ

EDI Analyst

Responsibilities:

• Researched current (4010) documents to identify and verify adherence to that standard
• Identified qualifiers and segments to determine if they could be migrated directly to the next version, 5010
• Converted EDI documents (837) from the 4010 to the 5010 standard, which was mandated to be complete by 01/01/12

Confidential, Scottsdale, AZ

Database Analyst

Responsibilities:

• Worked with the business through Business Analysts to determine information needs, then created reports from SQL Server and DB2 databases to best satisfy those needs
• Created numerous t-sql ad-hoc queries to aggregate and analyze data for management, results in Excel and SSRS
• Utilized SSIS, T-SQL and Excel to facilitate ETL for data loads.

Confidential, Phoenix, AZ 

Sr. Software Developer

Responsibilities:

• As the legislative business rules frequently changed, created and enhanced numerous queries to aggregate and analyzedata to present it using SSRS, Access, Excel and Crystal reports
• Worked closely with Business Analysts to help identify business needs
• Created ad-hoc queries for the teams to help explore the data
• Implemented complex business logic in VB6
• Used MS Excel extensively to analyze data, write code, summarize and aggregate using VLOOKUP, custom functions, VBA
• Created complex t-SQL stored procedures and functions to implement business rules using SQL Server 2000, 2005
• Performance tuned existing stored procedures to increase speed and efficiency using Profiler, Execution Plans, DETA, Dynamic Management Views; etc
• Used SSIS, DTS, t-SQL and Excel to facilitate ETL
• Maintained and enhanced legacy Access applications using Access and VBA
• Assisted DBA’s in implementing effective indexing and 3NF to speed up processing
• Maintained and enhanced the department’s numerous major information systems using Visual Basic 6, COM+, MTS, MSMQ,