Paul Pena

Houston, Texas *****

714-***-**** • ac5lo0@r.postjobfree.com • LinkedIn

Senior SQL Developer / .NET Developer

Accomplished Analyst and BI developer with extensive experience in Data warehousing, FLCD, SQL, SSRS/SSIS/SSAS, C#/.Net, dBase systems, ETL and Business Intelligence. Broad knowledge and success with MS SQL Server, MS Access and FoxPro databases as well. Experience working with Fortune 50 companies and executing on multiple projects successfully. Successful team and project leader.

Core Competencies:

Full Life Cycle Data Warehousing

MS SQL Server 2005/08/12

SSRS/SSIS/SSAS

VB/.Net applications

Business Intelligence

Quality Assurance and Testing

dBase/FoxPro

Access / Excel / VBA

Backup and Recovery Strategies

Professional Experience

SQL Development Analyst, Houston, TX

Tmk-Ipsco, 11/2017 – 03/2018 (short term contract)

Researched productivity and data flow bottlenecks and system errors. Created stored procedures, scripts and FoxPro programs to remedy bugs, improve performance and roll out new applications.

Key Projects:

Legacy FoxPro applications: Created solutions to remedy existing FoxPro challenges, bugs and inefficient SQL implementation. Modified forms, recoded program files, modified menus, changed SQL stored procedures, scripts and remote SQL views.

Heat Banding Project: Created VB/.Net Solution to allow plants to efficiently band heat-treated pipes with variant color schemes. Used company’s standards to develop forms and business and data access layers in Visual Basic.

DDE to Opc conversion: Recoded FoxPro applications to implement OPC communication protocols (overriding the older DDE calls) for all interactions with RSLinx terminals.

SQL Development Analyst, Austin, TX

Nugs.Net, 12/2016 – 09/2017 (short term contract)

Implemented strategies to resolve live streaming/royalties/ETL issues in relation to artists, Ascap, vendors, Sony, Harry Fox and other parties. Analyzed data, created Stored Procedures and scripts to facilitate ETL goals. Liaised between information technology and business units to ensure complete integration of in house systems with external clients.

Key Projects:

Sony Music: Spearheaded Sony Digital Sales Reporting project. Worked with engineers at Sony to streamline ETL processes, write and rewrite business rules for Sales records, Market share reporting, Royalties distribution reports, financial statement templates and detailed Provider metrics. The work identified errors that accounted for more than $500,000 in missed revenue.

Harry Fox Agency: Created processes to export data from web based apis into SQL backend. Normalized data in Excel using macros, vba code. Imported data to SQL backend using Stored Procedures.

LivePhish, Metallica, misc. musicians: Wrote extensive macros and VBA code to massage data in Excel and port to SQL. Wrote, modified stored procedures and scripts to normalize and import data from both Excel & flat files. Generated monthly, quarterly and ad-hoc reports.

Database Developer, Multiple States, USA

Various Companies, 2007 - 2016

Provided technical leadership for pre- and post-sales support, Banking systems, Music and Entertainment and IT firms. Analyzed data throughput, changed ETL processes, provided BI analysis and evaluation of current systems. Wrote extensively t-sql scripts, stored procedures, SSRS reports and coded in C#/.Net environment. Coded heavily in VBA for Excel including macros, pivot tables, etc. Provided documentation on existing systems and improved functionality. Conducted technical presentations, product demonstrations, and customer training.

Key Projects:

Excel/VBA/SQL Developer at MindShare Playa (02/2016-07/2016) – Vista, CA: Wrote macros and VBA scripts to allow SQL data entry in Excel, automation of accounting practices, charting, massaging and redisplaying data, scraping data from Excel to SQL. Developed and deployed SQL database.

SQL/C#/.Net Developer at Insight Global (06/2014-12/2-15) – Westlake, CA: Worked with Disney and Bank of America to modify and create SQL scripts, stored procedures & triggers for batch processing & reporting. Created and modified C# programs for new releases and updates. Performed business analysis for auditing and data lineage documentation. Creating Excel macros and VBA code to optimize ETL. Performed UAT testing & code migration. Modified SSIS packages to facilitate loading and parsing of files in Music Royalties database.

SQL/C#/.Net Developer at Technicolor (03/2014-06/2014) – Los Angeles, CA: Utilized MS SQL to create reports. Supported users and resolved user problem tickets on company’s proprietary platform.

SQL Developer/SSIS/BI at Bank of America (04/2013-02/2014) – Thousand Oaks, CA – Developed and supported Secondary Loan Mortgage applications using SSIS. Performed business analysis and wrote T-SQL Code for ad hoc reporting.

Excel /Access Developer at Nestle (01/2013-03/2013) – Glendale, CA: Normalized and consolidated vendor/supplier data from SAP & Web Portal system. Analyzed Supplier Diversity specifications to report on exceptions to Nestle rules. Created and supported Access2007 database. Automated email replies to vendors not in compliance with company licensing & protocols. Generated report in Excel and created macros to parse data.

SQL Developer / Excel Guru at FPA Technology (03/2012-12/2012) – Encino, CA: Reported data using SQL Server 2008 r2 SSRS & Crystal Reports. Enhanced and debugged applications in FoxPro(9.0). Utilized MS Excel to maintain company dashboard and create pivot tables for status reporting.

SQL Developer / FoxPro / Excel Guru at Apex Energetics (03/2011-02/2012) – Irvine, CA: Created Calendar application in Visual FoxPro (9.0) for medical distribution software. Authored VBA scripts to facilitate data throughput from FoxPro to SQL. Built FoxPro application using HTML DOM to scrape web data. Coded SQL stored procedures to automate reporting requests.

Excel Reporting Analyst / FoxPro Developer at InfoSend (07/2010-03/2011) – Placentia, CA: Created and upgraded existing FoxPro programs (Visual FoxPro 9.0) to generate HTML and XML files. Formatted Crystal Reports and PDF documents for printing imposition. Wrote and modified MySQL stored procedures and queries.

Excel Reporting Analyst / FoxPro Developer at New York Life (01/2010-06/2010) – Boston, MA: Coded Change Requests for Retirement plan services system in Visual FoxPro (9.0). Designed and deployed web reports in SSRS (SQL Server 2008 r2).

SQL Developer / FoxPro / Excel Guru at Chevron (05/2008-01/2009) – San Francisco, CA: Coded modules for Chevron’s various petroleum processing and filtration systems in FoxPro(2.5,.2.6). Coded FoxPro bug fixes for systems related to refinery construction, equipment tracking and location scouting as well as several employee management applications.

FoxPro / SQL BA at Banfield Pet Hospital (04/2007-04/2008) – Portland, OR: Coded over 800 repairs to the Visual FoxPro application (9.0) known as “Petware”, the main application for examining pets, categorizing illnesses, prescribing treatments and tracking pet history

FoxPro / SQL BA at Honda / N.Y. Dept. of Health (02/2000--03/2007) – New York, NY: Created and modified Visual FoxPro (5.0) classes, forms and objects to support real estate applications. Designed and developed new Adult Services database system in FoxPro 2.6 (full life cycle) for the “Brad-H” project.

FoxPro / SQL BA at J.P. Morgan / I.N.G. Capital (02/1994-01/2000) – New York, NY: Provided technical support/coding for various FoxPro financial systems, including: Foreign Exchange, Capital Markets, Risk Management, Commodities/Derivatives and Loan Booking.

Education

Associate of Science in Computer Information Systems

Strayer College, Washington, D.C.

Diploma in Computer Science Systems

Strayer College, Washington D.C.

Contact this candidate