SUMMARY:

• An accomplished Data Architect Lead with demonstrated success designing and implementing solutions that improve business functionality. Proven ability to implement technologies that decrease costs, increase performance, and positively affects the bottom line.
• Extensive experience working with all aspects of in - house developed systems
• Expertise in full project life cycle development for implementation and integration.
• Polished leadership skills, with ability to motivate teams to increase productivity.
• Deep understanding of technology with focus on delivering business solutions.

TECHNICAL SKILLS:

Databases: Oracle (7, 8, 9,10g,11g); DB2 9.7, 10.5(BLU; MSSQL Server 7,8,12; MySql, Microsoft Access

Software: ERWin, Oracle Data Modeler, IBM Data Architect, Informatica, Quest T.O.A.D., Secure CRT, Autosys, SQL Developer, Visio Enterprise, PVCS, Subversion, Oracle OLAP Data Warehouse, Oracle Forms 4.5, Oracle Reports, Oracle Discoverer Administrator, Oracle Portal, CuteFTP, Secure Shell, Visio 2000, Crystal Reports, StyleIntelligence, JIRA Confluence - ticketing and WIKI, FileZilla

Platforms: UNIX (Solaris, HP-Unix, AIX, Linux), Windows XP, Windows NT, Windows 8.1, Windows NT Server 4.0, Mac OS, DOS

Languages: PL/SQL, SQL, SQL*PLUS, Transact/SQL, HTML, DHTML, XML, XSL, JavaScript, Perl, DBI, Unix shell scripting

Office Applications/Tools: Microsoft Office, Microsoft Project, Microsoft SourceSafe, Excel, Power Point UltraEdit, TextWrangler

PROFESSIONAL EXPERIENCE:

Confidential, Lake Success, NY

Principle Database Engineer

Responsibilities:

• Drove corporate Data Architecture standards for the design and deployment of all DB2 and MSSQL Server data marts.
• Provided primary database administration for all production and non-productions DB2 and SQL Server platforms and databases for the Business Intelligence and Analytics team. Created instances and databases, and installed patches and upgrades.
• Supported primary production and non-production support for Data Stage and Cognos servers and applications.
• Guided Business Intelligence developers towards best practices in ETL design.
• Managed software development using Agile.

Confidential, Norwalk, CT

Senior Business Intelligence Developer

Responsibilities:

• Designed, developed, and implemented an Oracle Data Warehouse that allows for static dashboards as well as Ad Hoc reporting by both internal and external customers.
• Created a Batch Reconciliation Reporting system to produce reconciliation reports verifying the successful completion of each batch processed in the data warehouse. Developed DBMS SCHEDULER jobs to automate the delivery of the daily reports to the appropriate recipients via email.
• Set up configuration management for Data Warehouse objects and processes in Subversion
• Develop ETL processes using various combinations of SQL*Plus, PLSQL, SQL*Loader, and UNIX shell scripting to provide the most optimized solution for each.
• Lead off-shore consultants in projects ranging from the creation of new batch jobs to the development of new dashboards.
• Affect changes in source systems to allow for cleaner data and foot-printing of records to provide for real-time ETL processing.

Confidential, Garden City, NY

VP - Data Management Lead, Auto Finance

Responsibilities:

• Designed, developed, and deployed a metadata application to support business and internal reporting requirements.
• Created a Batch Reconciliation Reporting system that utilizes the metadata application to produce reconciliation reports verifying the successful completion of each batch processed in the data warehouse. Developed Autosys jobs to automate the delivery of the daily reports to the appropriate recipients via email.
• Administer the MIS Portal and all Oracle Discoverer end-user reporting throughout the distributed databases for Chase Auto Finance.
• Develop ETL processes using various combinations of SQL*Plus, PLSQL, SQL*Loader, Informatica, and UNIX shell scripting to provide the most optimized solution for each.
• Designed and deployed an automated database and server re application that provides a complete list, weekly, of all active uses and groups for review by the IRM.
• Lead a team of off-shore employees and consultants in projects ranging from the creation of new batch jobs to the implementation of corporate and government compliance initiatives.

Confidential, Port Washington, NY

Senior Developer

Responsibilities:

• Created stored procedures embedded in UNIX shell scripts to automate the creation and delivery of files to clients’ FTP sites.
• Developed and automated numerous physician, pharmacy, drug, and historical claim loads and created result and error files to UTL directories through extensive use of Oracle’s built-in UTL FILE package.
• Wrote triggers calling stored procedures to manage changes in member coverage.
• Generated Plan Design summaries through the use of PL/SQL records.
• Developed and configured new Windows 2000 adjudication switch server.

Confidential, New York, NY

Senior Developer, Business Systems

Responsibilities:

• Designed and implemented Oracle 8i revenue data warehouse for About and Sprinks, storing data used to provide reports to advertisers, partners, and internal users.
• Wrote all PL/SQL packages that pull data from run-time backup database, populate tables in the data warehouse, and then generate 300,000+ reports for advertisers, partners, and internal users nightly.
• Created Unix shell scripts to automate (or cron) export of warehouse schema from production to import into Beta environment.
• Wrote Unix scripts that automate (or cron) the creation of daily reports on database health and storage and email warnings to appropriate administrators when certain conditions exist.
• Created several internal reports using Perl.
• Designed and created sales order database to manage users, user privileges, client and agency information, internal and external site information, rates, and orders for ad placement.
• Created dynamic Oracle 8.05 inventory database that projects future ad placement availability based on historical page-view counts pulled from a Microsoft SQLServer 7.0 database, as well as actual delivered impressions retrieved from Dart/DoubleClick logs. Designed flexibility into system to allow privileged users to regulate seasonal growth rates and availability caps.
• Developed all stored packages, procedures, triggers, and functions to enforce business rules, automate inventory data loads, create and update orders, and to log transaction trails.
• Co-designed and developed run-time database for About’s new pay-per-click ad auction product called Sprinks.
• Coordinated the discussion between the ad sales, traffic, and finance teams at About, and performed analysis of the combined business needs to provide for an effective sales order and inventory system.

Confidential, New York, NY

Database Developer

Responsibilities:

• Developed web applications using Tango Enterprise on NT 4.0 supported by an Oracle 8.0 RDBMS.
• Co-developed theGlobe’s new web publishing application called uPublish, which provided registered members with the ability to develop their own web sites.
• Designed an implemented database containing news feed, provider, and category information, and created XML and XSL modules allowing links to be added to member web pages to access headlines from such providers as Reuters, FoxSports, and e-Online.
• Developed customizable guest book - with the use of HTML and XSL to generate XML modules - which members can drag-and-drop to their web pages.
• Introduced FTP control to uPublish, granting access to members only upon utilization of checksum parameter links in confirmation email messages.
• Designed and created user privilege database, and developed administration tool allowing privileged users with the ability to update member and site information stored in the database.
• Designed and created email user database to manage information for all user-interest email campaigns, such as theGlobe’s ‘Shop Confidential ’ campaign.

Confidential, New York, NY

Programmer/Analyst

Responsibilities:

• Designed and implemented intranet application to manage all information necessary for the management of information relating to agencies, branches, client billing addresses, orders, as well as for the production of invoices for CareerMosaic, the successful on-line interface for Confidential, Inc.
• Developed user-interface and reports using Oracle Developer/2000 v2.1 on NT 4.0.
• Installed and configured Oracle Report Server on an NT 4.0 machine and produced a PL/SQL package with embedded HTML that provided users with a web page containing links to reports, grouped by category, to be viewed either in a browser or through a PDF viewer.
• Conducted sessions for users of the new application, and developed on-line Users Manual, for additional support, containing overviews and user procedures for each of the screens and reports.

Confidential, Secaucus, NJ

Programmer/Analyst

Responsibilities:

• Performed analysis and created scripts for the mapping of data elements needed in the conversion from the existing legacy mainframe system to a new Oracle database on HP-UNIX.
• Created SQL*Loader control files and server-side procedures responsible for sorting and performed calculations on sales and marketing data, and then aggregated it to an Oracle OLAP Data Warehouse for customer profitability.
• Created PL/SQL package to modify Lock-box process in the Receivables package of the Oracle Financials application to perform validation of customers, checks, discounts, and balances.
• Produced many custom reports and modified existing Oracle Financials Receivables reports to accommodate Hartz’s business needs with the use of Oracle Reports 2.0.
• Created shell scripts on HP-UNIX to move data to and from the mainframe, as well as to automate the lock-box process.