SUMMARY:

• Leader, Solutions Architect, Consultant, Analyst, Developer, DBA with over 15 years of corporate Information Technology experience.
• Agile Scrum Master, Project Management Institute Project Management Professional & Agile Certified Professional (PMI PMP/ACP) with extensive team leadership skills, project management, strong written and inter - personal skills, organizational skills, work ethic and drive make a valuable addition to any project team.
• Over 15 years of SQL Server 2014/2012/2008 R2/2005/2000 & Oracle 12c/11g/10g/9i/8i/7.x. Development and administration on multiple OS architectures, Software Development and Project Management experience. Extensive work in data requirements gathering, data modeling, database development (T-SQL, PL/SQL), (packages/procedures and triggers), test-driven development of multi-tier and Client/Server based projects. Widespread performance tuning (query optimization, partitioning, data modeling refactoring.)
• Developed and supported Very Large Database (VLDB) applications on Oracle 12c/11g/10g/9i/8i/7.x databases and Virtual Private Databases (VPD)
• Experience of Data modeling (both transactional/OLTP and dimensional/BI/star schema) tools, such as ER Studio, Oracle Designer, ERwin & Visio
• Development of EDI and ETL processes using SSIS, Oracle PL/SQL, T-SQL, Informatica 9.5, Clover ETL, Perl (DBD/DBI), SQL*Loader, External Tables, C#/VB.NET (Entity Framework, ADO, ODP.NET)
• Self-motivated, results orientated team player with excellent communication and leadership skills. Focused on delivering high-quality solutions that are on-time and on-budget.

SKILLS:

• Oil & Gas
• PMI PMP
• Architect
• C#.Net
• SSIS
• Windows
• Retail - Energy
• Financial
• SiO2
• PMI ACP
• ISI CSM
• Oracle
• SQL Server
• MySQL
• VB.Net
• Java
• C/C++
• PowerShell
• PL/SQL
• T-SQL
• Informatica
• Perl
• Linux
• Solaris
• VMware
• Apple

SKILLS/TOOLS:

Databases: Oracle 12c/11g/10g/9i/8i/7.x/6, MS SQL Server SQL Server 2014/2012/2008 R2/2005/2000, MySQL 5/4

Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle Enterprise Manager, JDeveloper, Quest TOAD 10.6, Quest Spotlight, Quest SQL Optimizer, Embarcadero ER Studio 9.7, Embarcadero CM Schema 4.0 (Change Management), Informatica 9.0.1/8.6.1 , DB Solo 4, RedGate SQL Compare 11.1, SQL Data Compare 11.1, SQL Prompt 6.4, TOAD Data Modeler, Oracle Forms/Reports 6i, Oracle Designer/2000, Quest Data Modeler, Erwin 7.3, Sybase PowerDesigner, Remedy, Dreamweaver, IBM Rational ClearQuest & ClearCase, Mercury Quality Center, Tidal (job scheduling), Cognos, Nagios; Apple IOS/Xcode development (iPhone, iPad)

Languages: SQL, T-SQL, PL/SQL; C#/VB.Net, VB/VBA/VC++, C/C++/Java; PowerShell/psake/SQL Server PowerShell eXtensions (SQLPSX); Perl, Unix shell scripting (Perl/KSH/BASH)

Database Features: Partitioning, Virtual Private Database (VPD), Fine Grained Access Control (FGAC), Change Data Capture (CDC), bulk collect, pipeline functions, autonomous transactions, compression, Java embedded functions/procedures

Programming Features: XML web services, SOAP 1.1, WSDL, UDDI, Visual Studio 2013/2012/2010/2008/2005 , Team Foundation Server (TFS), VSS; XML (XSD, XPATH). WinForms/WPF

Operating Systems: Windows Server, Windows, Solaris, Linux (Ubuntu, Debian, Red Hat), HP-UX, AIX; VMware ESX administration (both Windows and Linux)

Version Control: git, MS Team Foundation Server (TFS), IBM Rational ClearCase, RCS/SCCS, MS SourceSafe

Project Management: Waterfall; Agile development (including: scrums, burn down charts, user stories and product backlogs.)

Soft Skills: PMI PMP, PMI ACP, Scrum Master, Toastmasters International (TMI) Advanced Communicator (ACG), Advanced Leader (ACB), Club Coach; Kaizen training behavioral interview techniques.

RECENT EXPERIENCE:

Confidential

ETL TEAM LEAD

Responsibilities:

• Team lead (seven developers) spearheading the data capture Extraction Translation and Load (ETL) effort for a $200M/200 person midstream oil & gas, liquid systems improvement project.
• Responsible for coordinating, resolving and optimizing all data related activities, including Master Data Management (MDM).
• Utilizing Visual Studio, extensive use of both SQL Server Development Tools (SSDT) and C# Fluent Migrations to package and deploy both DDL (data model) and DML (data).
• Drove improved efficiency using Change Data Capture (CDC) to produce C#/SQL migrations.

Environment: SQL Server 2014/2012, Visual Studio 2013, Red-Gate, PowerShell

DATA ARCHITECT

Confidential

Responsibilities:

• Instrumental in the architecture and development of the project data model, building a holistic end-end foundation to support the entire midstream application.
• Optimized tasks, such as naming conventions model consistency, and the maintenance and enforcement of data modeling standards by extensive use of ER/Studio macros and analytics.

Environment: ER/Studio 9.5, Visual Studio 2013, SQL Server 2014/2012, Oracle 11g, SQL Server Management Studio

Confidential

ETL TEAM LEAD

Responsibilities:

• Agile team lead with a distributed team of eight developers, for the largest ETL conversion project ( Confidential ) for Confidential Mass Market in 2013; migrating data from four source databases (including Confidential ) to eight target systems. On time and on budget, with a revenue savings of over $6M/yr.

Environment: SQL Server 2008R2, SSIS 2008R2, Informatica 9.5

ORACLE ETL + C#.NET DEVELOPER

Confidential

Responsibilities:

• Responsible for turning around an Oracle based ETL project that was failing due to mismatched skillsets. Reduced cycle time from 6 hours to 6 minutes, and data quality reporting from 2 hours to 7 minutes.
• Extensive database tuning - refactored a report workflow from 30+ hours to under 5 hours, enabling billing to be completed within a weekend.

Environment: Oracle 11g, PERL, Visual Studio 2012, C#.NET

DATABASE ARCHITECT + ORACLE PL/SQL + ASP.NET DEVELOPER

Confidential

Responsibilities:

• Developed a receivables management module, integrated into Oracle Utilities (Lodestar).
• Architected data model and backend database API integration modules; developed some of the ASP.NET UI.
• Post-delivery greatly reduced A/R >90days, increased customer touch points, and improved customer payment behavior.

Environment: Oracle 11g, Oracle SQL Developer Data Modeler, Oracle SQL Developer, Visual Studio 2008, C#.NET, DevExpress

Confidential

DATA ARCHITECT

Responsibilities:

• Estream is a green field application, designed to replace and seamlessly integrate over 50 disparate midstream applications, from Line of Business ( Confidential ) to manual/spreadsheet.
• The database was designed to perfectly match the business, providing a supporting foundation for the complete end-to-end solution, encompassing: contracts, Preflow (nominations and scheduling), Postflow (terminals and distribution), Material and Measurement Balance, Accounting, and Master Data.
• Key architect interacting with all application architects to model and support both business and application needs from a data perspective.
• Designed and integrated core sub models (Preflow, Postflow, Master Data)
• Logical and physical models were developed using ER/Studio 9.7. Reconciled changes between group checkins, as well as physical data model. Used Red-Gate SQL Compare to detect database drift and standards discrepancies between the model and the implementation in TFS.
• Maintained the model server repository, containing the Enterprise Data Dictionary (EDD). Member of the architectural review group, to approve database changes and identify model inconsistencies and traps (e.g. fan/chasm)
• Produce an extensive macro library to automate common database maintenance tasks, e.g.: audit columns, constraint naming, model reporting, model-submodel synchronization, entity/column documentation.

ETL TEAM LEAD/SCRUM MASTER/DEVELOPER

Confidential

Responsibilities:

• Team lead and Scrum Master - supervised and directed a team of four developers. Responsible for timesheet approval, product backlog grooming, sprint planning and retro.
• Introduction of the team was pivotal in improving the burn-down rate of the product lines, by bringing strong SQL Server database skills, augmented with close relationships with business product owners, application architects and Business Analysts (BA)
• Responsible for the day to day capture and implementation of Master Data Management (MDM), including Products, Business Entities and Assets (Facilities and Pipelines), as well as Preflow (Nominations and Scheduling) data.
• Created a PowerShell script (cdc2fluent) to automate Change Data Capture (CDC) and automatically convert the changes to either SQL DML or C# Fluent Migrations. Used the script as a basis of a class on PowerShell to the data development team.
• Created a number of C# database migration unit tests, to capture inconsistencies with migrations (scripted changes), to enforce naming standards and to identify and repair idiosyncrasies, such as duplicate foreign keys, indexes etc.
• Heavy use of Visual studio SQL Server Data Tools (SSDT) within Visual Studio SQL Projects, to update and deploy database schema and data changes.
• Automated the comparison and scripted modification to synchronize multiple databases. (Used PowerShell and SSDT DACPACs.)

Confidential

ETL TEAM LEAD/DATA ARCHITECT/DEVELOPER

Responsibilities:

• Project team lead and Scrum Master
• On-time and under-budget, with a revenue savings of over $6M/yr.
• Database/data architect
• C#.Net/SSIS T-SQL Developer
• The only team to successfully deliver ahead of the curve, on what was a heavily crashed and fast-tracked schedule.
• The eight-person team was distributed between Houston and Baltimore; and consisted of: Business Analysts, C#.Net developers, database architect, Siebel EIM specialist, Oracle Utilities (Lodestar) specialist and T-SQL/SSIS developers.
• Data migrated from four different SQL Server databases (including Confidential ) into seven different target systems (SQL Server, and Oracle Lodestar, Oracle Siebel, and proprietary databases).
• Conversion was heavily dependent on business processes between the two system end-points (retail energy and commercial energy.) In addition business numerous use-cases for inflight transactions and transaction-management had to be considered; as well as separation and isolation of non-migratible entities (e.g. switch-hold customers, Continuous Services Agreement (CSA), etc.)
• Developed ETL code in SQL Server T-SQL, packaged using SQL Server Integration Services (SSIS.) Used C# Script Components as a data-source to scrub incoming data from some sources, scrub/clean poor data, and to provide complex transformations based on business-rules.
• Developed a C#.NET application to automatically generate SSIS dataflow tasks, used to convert a large number of staging tables between SQL Server and Oracle
• Developed automated Data Quality metrics, including defect burn-downs/glide-path and Pareto graphs of defects using C#.Net/ODP.Net and Excel VSTO
• Wrote a C#.NET SQL Server Assembly for SQL Server 2008R2. The assembly provided functions for: Regular Expression (Regex) handling, social security and credit card verification. Collectively these functions were used throughout the conversion process to improve Data Quality (DQ) and to drive metrics.
• Produced a conversion proof-of-concept using Informatica 9.5, and architected a replacement ETL model (source-stage 1- stage 2 - targets)

Environment: SQL Server 2008R2, SSIS 2008R2, Oracle 11g, Informatica 9.5, C#.Net, Oracle ODP.Net, TFS, Visual Studio 2012

ORACLE ETL + C#.NET DEVELOPER

Confidential

Responsibilities:

• Responsible to turning around an Oracle based ETL project that was failing due to mismatched skillsets.
• Reduced cycle time from 6 hours to 6 minutes, using PERL and Oracle SQL*Loader - automated multiple processes, including: source file retrieval, compression/collation, and target control files.
• Automated Data Quality reporting, using C#.Net Excel VSTO. Report generation was reduced from 2 hours to 7 minutes.

Environment: Oracle 11g, Oracle SQL*Loader, PERL DBD/DBI, Visual Studio 2012, TFS, C#.NET

SSIS ETL + C#.NET DEVELOPER

Confidential

Responsibilities:

• Took over and turned around a receivables management application project, which was struggling for 18 months, mainly due to misinterpretation of requirements and intra-developer communication.
• Improved customer satisfaction from 25% to 95% in just 3 months.
• Reduced A/R backlog of $47M by kaizen process automation (including collated receivables letter generation.)

Environment: SQL Server 2008R2, SSIS 2008R2, SSRS, Visual Studio 2010, TFS, C#

.NETDATABASE ARCHITECT + ORACLE PL/SQL + ASP.NET DEVELOPER

Confidential

Responsibilities:

• Developed a receivables management module, which was integrated into Oracle Utilities (Lodestar).
• Architected data model and backend database API integration modules (PL/SQL packages); contributed to the development of the C# ASP.NET UI.
• Post-delivery greatly reduced A/R >90days, increased customer touch points, and improved customer payment behavior.
• Created a Java stored procedure to send JMS (Java Message Service) XML in real-time to TIBCO, bypassing the latency and dependency on LTP (Lodestar Transaction Processor).

Environment: Oracle 11g, Oracle SQL Developer Data Modeler, Oracle SQL Developer, Oracle JDeveloper, TFS, Visual Studio 2008, C#.NET

Confidential

Responsibilities:

• Responsible for maintaining (ETL, cleansing, performance) gas trading market intelligence data in a >5Bn row, 2.5TB data warehouse
• Migration of data warehouse from Oracle 10g to Oracle 11g
• Tuning and performance optimization related enhancements for ETL & reporting 11g MIGRATION
• Produced a multi-phased plan to migrate from Oracle 10g to 11g
• Query performance and risk mitigation were Critical Success Factors (CSF).
• Used application meta-data instrumentation to produce rank variation of the queries and associated unique parameter signatures.
• Pareto analysis and ranking of queries with a high degree of variation between 10g and 11g were examined in detail using scatter diagrams, to gauge the relative effects of migration.
• Poorly performing queries were identified and tuned - often these were a result of using hard-coded hints or SQL outlines used in 10g
• Benchmarked query performance both before and after the upgrade through the lower environments (DEV, INT, TST) before migrating to production (PRD).
• Identified inconsistencies between the relative environments (e.g. session connections, temp space, and undo space) that affected performance benchmarking and trouble-shooting.
• Data profiling of fact/detail tables for partitioning/composite optimization. Researched the use of interval and reference partitioning solutions to augment/replace existing model.
• Reverse engineering of fact/dimension star schemas using TOAD Data Modeler for documentation purposes.
• Identified virtual column candidates to simplify reporting queries using similar patterns.
• Explored use of compression options (table and index) - demonstrated a 76% reduction of targeted fact data storage.
• Used EM Advisors (Oracle Enterprise Manager) to identify and tune performance bottlenecks and statements which consumed excessive resources.
• Utilized Oracle Explain Plans to target areas to improve efficiency. Solution candidates included: materialized views; index pruning & optimization; selective use of bitmapped indexes (over B*Tree indexes); SQL Tuning Advisor; query rewriting and hand-optimizing.
• Worked with .NET developers to propose architectural solutions to improve application as well as database efficiency (source data archiving and query execution.)
• Made use of Oracle wait-analysis (AWR/ASH) to identify holistic performance issues (e.g. latch and buffer contention, network latency etc.)
• Wrote utility queries for the on-call support team; for example: to identify high connection/concurrency issues; unusable partition/subpartition indexes (from tablespace reorganization/reclamation)
• Identified performance issues with Informatica ETL loads between Source and Target.
• Enhanced existing workflows with fast statistics gathering of staging tables to improve ETL performance. Statistics gathering was executed using parallel sessions, causing zero increase in wait-time, but ensured that the Oracle Optimizer used the most efficient query plan for the given workflow.
• Profiled/mapped server related load issues using Informatica repository (metadata) queries (also used in Oracle 11g migration benchmarks).
• Optimized use of SQ (Source Qualifier) queries.
• Performed data scrubbing and recovery failed workflows.
• Data maintenance of fact and slowly changing dimension/reference data (including rollback/back-out contingencies)
• Data cleansing of duplicate/invalid data (e.g. due to changes in business rule logic for ETL.)
• Identification and remediation of fact data inconsistencies as a result of architectural changes.
• Measurement and tracking of growth statistics (taxonomies: by category, reference/detail, table/index)
• Use of PL/SQL packages, stored procedures/functions to support and maintain ETL and data quality.
• Developed a C#.NET test harness to compare and benchmark FAME data between multiple geo-located database servers

Environment: s: Oracle 11g/10g, Toad 10.6, Informatica 9.0.1, Remedy, ClearCase, Visual Studio 2010

Confidential

EDI/ETL Developer

Responsibilities:

• Kaizen approach to continual process improvement for EDI data flows - reduced defects from ~5% to <1%
• Improved archival mechanisms for long term data retention from 93% to 99.98% within 3 months. Performed business root cause analysis, developed PL/SQL packages for data maintenance and Cognos for reporting.
• Streamlined EDI operations by implementing a 24x7 pipeline monitoring, reporting, and alerting system, to ensure that flows operated within defined control limits. Results presented using a Red-Amber-Green dashboard with control metrics. (Perl, PL/SQL, HTML)
• Designed, debugged, tuned and refactored PL/SQL package flows to improve performance and reliability. Typical solutions included removing dead-code, optimizing loop conditions and replacing CURSOR-LOOP operations with PL/SQL BULK/COLLECT. Performance improvement gains were up between 4-12x.
• Produced a multi-threaded application to transfer 4TB of physical image data, and to reconcile the corresponding record between the various flow stages within backend applications. (VB.NET)
• Developed an application to extract daily Fannie Mae mortgage rate information from via XML/RSS and automatically populate Oracle backend data structures. Replaced previous method was manual and error prone. (PL/SQL, VB.NET, XPATH) Extract, Transform, Load (ETL)
• Developed a Windows front-end application for Informatica job scheduling using SOAP/Web service requests. The application provided access to initiate data flows based on Windows active directory and Informatica security roles/privileges. (VB.NET, Windows Presentation Framework - WPF)
• Developed an XML validation/cleaning console based application (VB.NET) to ensure that feed was not only structurally correct (XSD) but also inspected to ensure that data was correct (including embedded image data). (VB.NET)
• Member of the technical review committee
• Consultant on BI/DW data modeling (transactional to star schema solutions) for Cognos reporting
• Analysis and implementation of solutions to improve transactional model (normalization, table index optimization, referential data integrity)
• Technical analyst responsible for team work-order assignment and PL/SQL QA review.

Environment: s: Oracle 11g/10g, Informatica 8.5, BizTalk 2006, C#.NET/VB.NET, Visual Studio 2010/2005, Toad 10.5, ClearQuest, Visual Source