Sql Server Analyst
Resume:
MICHAEL W. SELF
Houston, TX ***07
713-***-**** - *******@*******.***
EXPERIENCE
JPMorgan Chase (Investment Bank), Houston, Texas 2/2008 – 1/2009
RAD Developer/Analyst
Programming skills used: Excel 2003/2007, Access 2003/2007,VBA, Oracle
Developed and supported Excel reports for two large web based applications supplying key bond and loan
information.
Worked with users on ad hoc projects to define their business rules and deliver rapid concise solutions.
Specific projects/applications:
Supported and created intricate and detailed Excel reports generated from raw data from web application.
Key part of the team that converted acquired company’s bond and loan data to JPM’s existing applications.
Responsible for setting up a system for rapidly identifying and address data conversion issues, and making
the respective changes. (Excel, Access, VBA used).
Excel application that imports user spreadsheet, and creates a number of investment bank rating reports.
Key feature was that the user’s import sheet specifications were easily configurable to account for common
changes arising. (Excel, VBA used)
Developed several Excel VBA utilities to efficiently assist with application and programming tasks.
BP (GAS & POWER) (contract), Houston, Texas 11/2002 – 11/2007
Programmer/Analyst
Programming skills used: Access 2003, Excel 2003,VBA, DAO, ADO, Oracle, SQL Server, Sybase
Designed and developed applications in Access 2003 and Excel 2003, (many of which were business
critical), to enable users to easily manage key trading information. Filled roles of business analyst,
database designer and programmer on most applications, as well as working in a team environment,
All applications were screen driven. No specific software knowledge needed by users.
Much of the code in applications using ODBC were written in the native language (Oracle, SQL Server, or
Sybase).
Specific projects/applications:
Access deals database for key trading group that was secured with Access security (VBA, Access SQL,
ADO and DAO used). The reports were dynamically generated from custom pivot table (and other) reports
from a secured Excel spreadsheet.
Access inventory storage and WACOG calculation database. Used WACOG business rules for various
volume balance cases to track inventory volumes and costs for specific transportation agreements. One key
part of the application was the Excel custom reports..
Excel reports for deal confirmation reporting that used Oracle data normalized in an Access database.
Data was retrieved from Oracle with customized scheduling routines to not interfere with the enterprise
database processes. (VBA, Access SQL, Oracle SQL, DAO used)
KIERSTED SYSTEMS, INC. (contract), Houston, Texas 5/2002 – 10/2002
Programmer/Analyst
Programming skills used: Access 97/2000, VBA, Excel 97/2000, DAO, ADO, HTML
Developed and supported several Access (97 and 2000) applications primarily for a large energy company.
Developed database application for quickly creating thousand of HTML email documents.
Michael W. Self Page 2
ENRON – (contract), Houston, Texas 2/2000 – 12/2001
Programmer/Analyst
Programming skills used: Access 97/2000, Excel 97, VBA, DAO, ADO, Oracle 7i/8i
Developed several key applications acting as business analyst and programmer. These included using
Access front ends to Oracle and SQL Server and Sybase databases via ODBC.
Used Excel automation technology to assist users in meeting aggressive deadlines.
Specific projects/applications:
Data analysis application that retrieves data from external data sources and lets the user create custom text
explanations for variance explanations programmatically. Oracle 8 backend and pass thru SQL was used
for key procedures.
Marketing database application for Enron On-Line. This database utilized several techniques to assist with
performance. (Access 97 front end, Access 97/Oracle 7 back end)
LYONDELL CITGO REFINERY (contract), Houston, Texas 4/1999 – 2/2000
Programmer/Analyst
Programming skills used: Access 2.0/97, Excel 97, VBA, Microsoft SQL Server 6.0/6.5, SAP
Key project was support and enhancement of mission critical Mechanical Integrity Access/SQL Server
database (80 users plant wide). The front end of this application was Access. The back end was MS SQL
Server (100 tables) with approximately 10 Access tables.
Converted large Access 2.0 front end/Access back end tables to Access 97. A very detailed conversion
plan was developed and executed.
Develop Access/VBA interface for SAP validation.
BANK UNITED (contract), Houston, Texas 4/1998 – 1/1999
Programmer/Analyst
Programming skills used: Access 97, Excel 97, VBA, DAO, Microsoft Project
Designed and developed a multi-user commission compensation system. This project involved scoping out
the business rules with management, and creating a project time line in Microsoft Project as well as the
database design and the actual programming for the Access 97 application.
Implemented multi-user Access security for the commission system. This application was the primary
source of pay computation for all loan officers in the Bank’s wholesale real estate loan department.
Assisted users with various ad-hoc Excel programming requests.
SHELL SERVICES (contract), Houston, Texas 12/1997 – 4/1998
Programmer/Analyst
Programming skills used: Access 97, VBA, Excel 97, DAO,Visual Basic 3.0/4.0/5.0, NOMAD
Main project was converting an extensive NOMAD Inventory conversion application to Access 97. This
involved learning to read the NOMAD SQL and convert the business rules to Access 97 VBA (DAO) code.
Extensive planning and testing was done as part of a team.
EDUCATION & CERTIFICATIONS
University Of Houston - BBA in Accounting
Certified Public Accountant, Texas (currently inactive)
Various courses of study in Microsoft Access, Visual Basic, Oracle, and SQL Server
Contact this candidate