SUMMARY:

• Highly focused and self-motivated Database Engineer/Programmer/DBA with 20 years of IT experience and 18 years of concentrated proficiencies in database technologies specializing in MS SQL-Server, focusing on the TSQL engine coding and Integration Services SSIS with an emphasis on maintainability and performance as well as DB Administration. Innovative problem solving and a focus on organizational efficiency were used to successfully reengineer several pertinent database and data warehousing projects including development, ordering systems, inventory control, and accounting in such diverse environments as the medical, retail, litigation, financial and entertainment industries for both OLTP and OLAP environments, including Business Intelligence and Data Warehousing. An evolutionary, systems oriented style of thinking, grounded in science and philosophy has contributed to the development of improved business strategies and increases in organizational efficiency and cost reductions. Extremely heavy use of TSQL engine Logic, Administration and Integration Services SSIS, with additional skills in Reporting Services SSRS and Analysis Services SSAS, utilizing SQL 2005/2008 R2/2012/2014. Comfortable with very large environments some of which approximated 20 terabytes. Focus on coding optimization maintainability, and version control.
• Sound use of database logic, normalization, scripting, integrity, analysis, development.
• Exceptional facilities for assimilating and implementing pertinent new technologies.
• Capacity for working both autonomously and in team environments.
• Exemplary communications skills.

TECHNICAL EXPERIENCE:

SQL-Server 2000/2005/2008 R2, 2012, 2014, DBPro, SSMS, SSIS, SSRS, SSAS, SSDT, Visual Studio 2010/2012/2013, Team System, TFS, Entity Framework 5, Clustering, Virtualization, Azure, BizTalk, MSBuid, Redgate Products, Subversion, VB.Net 2008, 2010, 2012, Sharepoint/MOSS, Sybase Adaptive Server, C, C ,C , SQL, TSQL, Windows XP, Vista, Windows 7/8, Lotus Notes, Outlook, Word, Access, Excel 2010, VBA, VBScript, Jscript, ASPX, XML, HTML, .Net 3.5/4/5, SAS, Brio, Oracle, Erwin, Endeca, Mercury Quality Center/Test Director, VSS, Rational ClearCase and Requisite Pro, SQL Litespeed, BIDS, BISM, Business Objects, Crystal Reports, Quest, Apex, Redgate, Perforce

PROFESSIONAL EXPERIENCE:

Confidential

Database Archtect/Developer for A/X Conversion Project Dev and Production support contract

• Utilized ORM Entity Framework 5.0 for meta data modeling and data access layers in working with web developers
• Created complex procs for parsing BOM hierarchical data
• Built dynamic SSIS packages, including connection manangers, Control Flow, Data Flow tasks, performance tuning of data lineage and buffers etc.
• Architected entire rewrite of legacy systems including new logical and physical schemas, bitmapping, hierarchy data types
• Utilized Powershell, Ping Options and xp cmdshell to determine server and db availability, correcting automated access errors
• Created new 2012 and 2014 SSIS packages and templates for Resale data for A/X integration project utilizing sequence containers, variable scoping, precedence constraints, sql/file system tasks, lookups, sorting and merging
• Audited object change history and incorporated Data Quality Services DQS
• Use of partition sysobjects to report status of all dbs
• Supported and debugged 15 year old legacy systems
• Conducted planning and documentation sessions in agile framework
• Revised and recalculated existing plans for systems integrations
• Coded for A/X integration
• Reviewed VAR levels for this integration
• Attended seminars on middleware platforms
• Created first version control environment in TFS using dev, main, and release branching with both forward and reverse integration
• Created deployment dpacs for publishing
• MS SQL 2012 and 2014 migrations
• TFS admin created dev, main and release branches with branching and merging
• Created, published and scheduled Risk analysis trending reports via SSRS

Confidential

Software Engineer/DBA Production, Staging Development Environments

• Industry Leader in underserved music market involving legal rights to downloading and streaming music files
• Created batch code using xpcmdshell, pingswitches, and PowerShell scripts to predetermine server and db availability.
• Coded object dependency proc to expose fk hierarchy, job step dependencies, and module definition.
• Included dmv and dmf outputs for io, index usage, statistics timelines, blocking, and cpu usage
• Setup hierarchy metadata solution for BOM project
• Created 2012 SSIS packages for music rights and content data imports to star schema using connection managers, scoping, expressions, error handling, fuzzy lookups, looping, precedences scripting and sql tasks
• Created and utilized Data Mining project for data warehouse to perform predictive analysis for music consumption
• Evaluated VAR level requirements for AX conversion
• DBA and Database Developer for Content Operations and User Experience Projects
• Managed Project via Agile Methods and JIRA
• Monitored and Resized Production Servers with critical space issues
• Index Remanagement based on data distributions, density, and selectivity
• Rewrote 'Splunk' process from cursor based to looped set based logic decreasing processing time from 120 records/20 mins to 120 recs/