SUMMARY:

• SQL Server / BI Developer offering more than 10 years’ of extensive development experience in development, implementation, replication, and administration of SQL Server and BI initiatives

TECHNICAL SKILLS:

• SQL Server (2014
• 2012
• 2008R2
• 2005
• 2000
• 7)
• Visual Studio (2015
• 2012
• 2010
• 2008)

WORK EXPERIENCE:

Confidential, Houston, TX

SQL Server Developer BI / Energy

Responsibilities:

• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS )
• Created numerous accounting related reports (ie Developed Month End, Inventory, Expenditure Trend Analysis, and Asset Depreciation reports utilizing SSRS)
• Assisted in the creation of an executive summary dashboard specifically related to revenue utilizing Tableau
• Extensive knowledge on SDLC processes such as Requirement Analysis, Design, Development, Testing, Integration, UAT, and Implementation.
• Created acceptance criteria documentation for revenue related reporting, and obtained executive approval
• Developed stored procedures to implement necessary business logic for interface and reports
• SQL Server 2014 / Visual Studio 2015 /Team Foundation Server (TFS)/Data Warehousing and ETL processes.

Confidential, Houston, TX

SQL Server Developer BI / Energy

Responsibilities:

• Created numerous SQL Server SSIS ETL Packages to Merge and transform Oracle 11g data to DataMart.
• Troubleshooted and resolved issues with SQL Server SSIS ETL Packages for DW Group.
• Automated numerous accounting processes utilizing SQL Server SSRS reports, SQL Server Stored Procedures. SQL Server SSIS Packages with an Enertia General Ledger data source.
• Developed ETL Packages for aggregating Aries & Enertia data at the Well, and completion level for a custom SharePoint application.
• Created SQL Server ETL Package to populate Quorum Land application with Enertia Data
• Created a SQL Server SSRS utilization report by object and usage.
• Developed several SSRS Accounting related reports: Estimates, Revenue and DECK. Data sources combined Cube (MDX), and relational data.
• Strong TSQL, SSIS, SSRS development skills with knowledge of SQL MDX.
• Utilized Oracle 11g to create views for the BIRST reporting application.
• Completed unfinished former developer projects, and resolved related issues ETL, SSRS.
• Utilized a variety of tools to accomplish tasks Visual Studio 2012, Visual Studio 2010, Visual Studio 2008, (SSRS,SSAS,ETL), SQL Server 2012 & 2008r2, and Oracle SQL Developer 4.03

Confidential, Houston, TX

SQL Server Developer DBA

Responsibilities:

• Strong Reporting experience using SQL Server 2012, 2008r2 generated on - demand and scheduled reports for business analysis and management using SQL Server Reporting Services
• Designed and developed Two large BDE, (bulk data extract) ETL Processes.
• ETL project consisted of Ebcdic data files the other remote access to Oracle 11G.
• Utilized SQL Server 2012/ 2008 R2 / Visual Studio (VB) in development of a large ETL
• Deceased nightly load from 6 to 2 hours by implantation of delta processing
• Experience with backups, restores and recovery models
• Extensive Knowledge of TSQL, Stored Procedures, Views, and SSIS Scripting.
• Created Resource pools and processes to limit system impact by adhoc report users.
• Experience with data encryption at the column and database level.
• Ensured that all objects conform to company standards and that all audit procedures have been followed prior to production integration. Approved requests, verified code check in, conducted code review, and completed testing.

Confidential, Austin, TX

SQL Server Developer/DBA

Responsibilities:

• Extensive Knowledge of TSQL, Stored Procedures, Views, Triggers, BCP and SSIS Scripting.
• Ability to function in the capacity as a Database Administrator or Developer.
• Experience with management and development of multiple database environments SQL 2000, SQL Server 2005, and SQL Server 2008
• Coordinate efforts effectively across departmental groups and end users.
• Experience in Logical Database design, Physical Database Design, Physical Resource Planning, Allocation and Maintenance.
• Upgraded multiple database's to SQL Server 2005 and resolved technical issues with
• SSIS /DTS, analysis services, reports, and pivot tables.
• Developed small applications utilizing .NET, Crystal Reports, SQL Server 2005, SQL Server 2008
• Created all back end database logic for a custom Oracle Hyperion application.
• Integrated SQL stored procedures, and views in large MS Access database.

Confidential, Dallas, TX

Trintech Application Administrator

Responsibilities:

• Installed, upgraded and maintained the ReconNET Account Reconciliation Software for high volume account matching on both servers and end users pc'c.
• Coordinate efforts effectively across departmental groups and end users.
• Backup and recovery duties in a 24x7 SQL Server 2000 environment
• Monitor all database activities and resolve or report issues as they arise.

Confidential, Dallas, TX

SQL Server Developer

Responsibilities:

• Developed a table driven Replication Administrator Application in SQL Server 2000 capable of creating distributor, snapshots, agents and jobs.
• Created a table driven Quality Assurance Process integrated with Replication Administrator which would store and compare function calls results with current and prior periods, generate an email notification and report in an excel attachment.
• Constructed a central product catalog Data Mart SQL Server 2000 and related data business interface (DBI).
• Database Architect and Data Modeler in the early stages of the project.
• Developed script to extract, transform and load mart from Nocv and Cofe Databases.
• Created numerous triggers, stored procedures, and functions per individual teams requests.

Confidential, Dallas, TX

Technical Architect

Responsibilities:

• Assisted LPDSS development staff with the creation of Views, Complex Queries, and Stored Procedures Utilizing IBM DB2.
• Worked closely with Business Analyst, and Accurate Report Developer to insure result integrity.
• Duties included data conversion and scrubbing of any client data, along with producing audit and data-integrity reports design to ensure accurate end-use data.
• Lead a team of Three .Net Developers and a business analyst in the full life-cycle development of the CSM Resource Availability portal which utilized Vb. Net and SQL Server 2000
• Utilized 3 tier architecture.
• Designed, constructed database and all related logic
• Developed Web Forms per user specifications
• Oracle 9i
• Assisted Development staff with SQL*Loader scripts to load raw data
• Developed script to extract, transform and load database into staging area and then into data warehouse.

Confidential, Dallas, TX

SQL Server Developer

Responsibilities:

• Act as gatekeeper responsible for final testing and implementation of all database changes.
• Optimization of existing databases by data reduction, applying referential integrity and normalization of data.
• Coordinate efforts effectively across departmental groups and end users.
• Backup and recovery duties in a 24x7 environment with databases exceeding 15 TB.
• Monitor all database activities and resolve or report issues as they arise.
• Serve as the Security Administrator for SQL Server 2000 as well a Group Network Security Administrator.
• Researched and applied all required service packs for all servers.
• Experience with capacity planning, trouble-shooting database corruption, backup, and recovery.