SUMMARY

• Senior-level software consultant with more than 15 years experience in the Information Technology industry implementing professional solutions to business problems.
• Demonstrated expertise in relational database technologies, both Oracle and Microsoft SQL Server, specializing in back-end database design and development.
• Experienced in extraction, transformation and load ETL projects including data analysis, data mapping, database and software design, development and implementation.
• Experienced in all aspects of the System Development Life Cycle SDLC
• Excellent communication and presentation skills.

AREAS OF EXPERTISE

• Data analysis, mapping and migration.
• Database modeling and design.
• Extraction, transformation and load ETL design and development.
• SQL Server T-SQL, SSIS, SSRS development.
• Oracle PL/SQL development.

TECHNICAL SUMMARY

• Databases - Oracle, Microsoft SQL Server, and other relational databases.
• Languages -PL/SQL, T-SQL, C , Java, Shell scripting.
• Tools - Eclipse, Visio, Visual Source Safe/TFS, Visual Studio 2008/2010.

PROFESSIONAL EXPERIENCE

CONTRACTOR POSITIONS:

Confidential

Responsible for converting complex manually-driven Excel workbooks into SSRS reports and building SSIS packages to support the movement of data from Lynx, primarily, to the reporting database. Worked with the business analysts to understand the workbooks and business processes. Software: SQL Server 2008, SSIS, SSRS.

Confidential

Responsible for coding changes to the production MDT Clear application as part of the remediation effort. Worked with the business analysts and requirements documents, analyzed existing code, developed the low-level design, and implemented the changes using T-SQL.

Software: SQL Server 2008, T-SQL, bcp, TFS-ALM.

Confidential

Responsible for maintaining the production Legacy Asset Reporting application databases including stored procedures, functions, table/view schemas, and SSIS packages. Modified stored procedures, functions, and SSIS packages for the HAMP Tier II project. Worked with the Line of Business LOB and system analysts to maintain the Request for Change RFC documents, specifically in generating the low-level design section.

Software: SQL Server 2008, SSIS, T-SQL.

Confidential

Responsible for analyzing existing SQL Server 2008 databases and stored procedures. Generated test scripts and use cases from various business requirements documents. Also responsible for quality assurance of mortgage loan fraud detection rules. Software: SQL Server 2008, T-SQL.

Confidential

Responsible for analyzing, maintaining and tuning production T-SQL stored procedures and SQL Server Integration Services SSIS packages, across multiple SQL Server databases, for the Loss Mitigation/ Troubled Debt Restructuring department. Worked with the quality assurance and production release teams to ensure accurate and timely roll-outs of code changes into the QA and production environments. Utilized Team Foundation Server TFS for code versioning across multiple database servers and databases. Software: SQL Server 2005/2008, SSIS, T-SQL.

Confidential

Audited their existing application databases, both SQL Server and MySQL, to determine the accuracy of a prior data migration project from one database to the other. Developed reports in T-SQL for regional member counts, membership status, contact lists, etc. Software: MySQL, SQL Server 2005, T-SQL.

Confidential

Designed and developed Joomla video search and playlist extensions, both components and modules, in PHP and MySQL. Managed and customized the MySQL database to support new functionality.

Software: Java, Joomla , MySQL, PHP.

Confidential

Spent time with my mother and sister. Learned PHP, Joomla , and the Android OS. Developed several Joomla extensions as well as an Android application.

Confidential

Responsible for the extraction, transformation and loading ETL of data from their existing custom Supply Chain application, running on Oracle 8, to the new commercial off-the-shelf product running on Oracle 9iR2. Attended the data mapping and business event flow meetings, provided database-specific and data migration technical help, and maintained the data mapping documents. Designed and implemented custom ETL applications using PL/SQL, Data Loader and shell scripts to migrate the data through several staging databases. Software: Oracle 8/9, SQL, PL/SQL, HP/UX shell scripts, TOAD.

Confidential

Fixed Sega's failed data warehouse process by analyzing the Star schema model, the Analysis Services cubes, the Integration Services packages, and the T-SQL stored procedures. Reduced data load time from 2.5 hours to less than 30 minutes by re-coding a remote query as pass-through SQL. Debugged, improved and re-created several existing Reporting Services reports, and designed and coded new reports. Modified and improved an existing Excel VBA module to provide the financial users with an automated accounting spreadsheet. Software: SQL Server 2005, SSAS, SSIS, SSRS, T-SQL.

Confidential

Provided consulting services, requirements analysis, and design of Windows SharePoint Services WSS and Microsoft Office SharePoint Server MOSS . Installed and configured WSS and MOSS on multiple real and virtual servers. Software: MOSS 2007, WSS 3, XML.

Confidential

Designed and built a sales and marketing data mart using SQL Server and SQL Server Integration Services which allowed the marketing department to identify and target new and existing customers for up-sell, cross-sell and new products. Designed new, and maintained existing, SQL Server Reporting Services reports targeted at the sales, marketing and financial departments. Worked with the quality assurance and release teams to roll out production database changes.

Software: SQL Server 2005, SSAS, SSIS, SSRS, C .

Confidential

Acted as the lead database developer on the Global Data Integrity project to consolidate data across global legacy Order Entry and Supply Chain Management databases, and to provide enterprise-wide reporting on orders and inventory. Analyzed and documented the company's primary legacy order entry and supply chain databases, and created a metadata database to store the results of the analysis. Designed, developed, and administered the Operational Data Store ODS utilizing Oracle. Designed the data warehouse star schema for sales and marketing analysis. Developed and documented data load, transformation, data analysis, error handling and test case utilities using PL/SQL and Java.

Software: Oracle 9i, PL/SQL, Java.

Confidential

Analyzed the existing HR performance-based compensation web application built in JSP and Java, re-architected the application, and built a new web application using Microsoft .NET technologies. Designed and administered the Oracle database. Software: VB.Net, ASP.Net 1.0, ADO.Net, Oracle 9i.

Confidential

Designed and administered the MySQL database and Java data access layer in a Linux environment. Automated web page content delivery using Java/JDBC and the MySQL database to provide up-to-date medical information to the physicians using the web site. Software: MySQL, Java, JDBC, JSP.

Confidential

Designed and built the Oracle data mart for a web-based, disease analysis project, including PL/SQL routines to load and transform the flat-file data sources. Provided database design and SQL support to other software developers. Software: Oracle9i, PL/SQL, Appforge, NSBasic.

Confidential

Designed and built custom extraction, transformation, and load ETL utilities in Java and PL/SQL to load patient information into the Operational Data Store ODS at HealthNet.

Software: Oracle9i, PL/SQL, Java.

Confidential

Website development utilizing Microsoft Active Server Pages ASP and SQL Server. Improved layout, navigation, and security on the health questionnaire web pages. Enhanced SQL Server and web site security to ensure that patient's medical information was protected from inadvertent access.

Software: ASP, SQL Server 2000.

Confidential

Designed and built business-to-business, web-based and server-side loan applications for this Mortgage Lender. Implemented multi-server, Internet and intranet applications, communicating with third-party processes such as loan underwriting and internal legacy systems. Designed and maintained the SQL Server data mart. Software: VB6, COM, MTS, SQL Server 2000, Perl.

Confidential

Employed as a pre- and post-sales technical consultant for a variety of well-known companies, such as Oracle, Information Builders and Cambridge Technology Partners, as well as a number of technology startups. Acted as the expert in relational database technologies, primarily Oracle, and application programming interfaces utilizing programming languages such as C, PL/SQL, and Visual Basic. Responsible for generating response to proposals, application architecture, requirements analysis, database design, prototyping, and demonstrations in front of customers and at trade shows.