SUMMARY:

• Extensive experience developing, migrating, troubleshooting and optimizing database applications.
• Strong analytical skills with a business background in Fortune 100 corporations.
• Proactive.
• Excellent verbal and written communication skills.

TECHNICAL SKILLS:

Languages: T - SQL, PL/SQL, Sybase SQL, Visual Basic for Applications ( VBA ), PERL, Visual Basic 6, FoxPro, VBScript, JavaScript

Platforms: SQL Server 7/2000/2005/2008/2008 R2/ 2012, Oracle 9i/10g, Sybase, MS Access, MySQL.

Software: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Access, MS Excel, MS Outlook, Business Intelligence, Crystal Reports, Pervasive Data Integrator, DTS, Data Junction, Cognos, DBX, TOAD

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Developer

Responsibilities:

• Designed and developed ETLS merging and massaging accounting data using PL/SQL in Oracle 12c.
• Designed and developed actuarial applications using PL/SQL in Oracle 12c.
• Performed troubleshooting and optimization on applications ETLS using PL/SQL in Oracle 12c.
• Developed DOS batch scripts to run Oracle 12c DML and DDL.
• Designed, developed and troubleshot deployment method for Oracle 12c applications.
• Conducted root cause analysis and resolved production and data issues in Oracle 12c applications.
• Authored documentation for applications.

Confidential

Senior Database Application Developer

Responsibilities:

• Designed and developed database applications (Stored Procedures, Functions, Views,Triggers) performing business processes in SQL Server 2012 using T-SQL
• Performed troubleshooting and optimization on existing SQL Applications on SQL Server 2012.
• Authored design and deployment documentation on all objects and processes.

Confidential, Yonkers, NY

Senior Database Application Developer

Responsibilities:

• Designed and developed ETLS using SSIS and T-SQL in SQL Server 2008 R2.
• Performed troubleshooting and optimization on existing SSIS packages and SQL Server 2008 R2 objects
• Designed and developed database applications (Stored Procedures, Functions, Triggers) performing required business processes on SQL 2008 R2 using T-SQL and SSIS.
• Conducted root cause analysis and resolved production and data issues in SQL Server 2008 R2 applications.
• Authored design and deployment documentation on all objects.

Confidential, NY, NY

Senior Database Application Developer

Responsibilities:

• Designed, developed, executed and validated Extract Transform and Load (ETL) on Oracle 9i in PL/SQL, including data profiling, mapping, cleansing and reconciliation.
• Converted Access 2010 applications to PL/SQL based applications (Stored Procedures, Functions, Triggers).
• Converted Access 2010 applications to PERL scripts
• Developed extensive VBA utilities to monitor, audit, analyze and maintain Access 2010 applications.
• Automated, enhanced and optimized legacy ETLS.
• Optimized and automated Access 2010 applications.
• Performed gap analysis on business process and implemented enhancements.
• Designed, developed and implemented validation, audit and alert processes to improve data quality.
• Conducted root cause analysis and resolved production and data issues in Access 2010 applications.
• Performed ad hoc reporting in PL/SQL, SAS and Access 2010.

Confidential, Chicago Ill

Senior Database Developer

Responsibilities:

• Designed and developed database applications (Stored Procedures, Functions, Triggers) performing required business processes on SQL 2008 R2 using T-SQL and SSIS.
• Designed, developed, executed and validated Extract Transform and Load (ETL) of legacy data in SSIS.
• Converted suite of Access 2003 applications to SQL 2008 R2 application.
• Designed and developed database applications that enhanced, optimized and automated legacy applications.
• Designed and developed database applications that cleansed, scrubbed and reconciled legacy data.
• Analyzed, optimized and automated 100+ package SSIS Solution.
• Developed custom tools in SQL 2008 R2 using TSQL and XML enabling rapid analysis and reporting on SSIS package properties and settings.
• Collaborated with Front End design and development teams enhancing legacy system simultaneously assessing system functionality and ROI.
• Participated in JADs on development of new systems.

Confidential, New York, NY

Data Analyst and Developer

Responsibilities:

• Developed financial applications in Excel 2007.
• Analyzed, optimized and automated existing Excel applications.
• Developed complex formulas utilizing all flavors of Lookups, Offsets, Indirects, etc.
• Assessed workflow and processes through analysis of existing architecture.
• Coordinated QA and UAT.

Confidential, New York, New York

Database Developer

Responsibilities:

• Automated risk data ETLs in SQL Server 2005/2008 using SSIS, DTS, Access (VBA) and Excel (VBA).
• Executed data migration (data mapping, matching, scrubbing, loading and validation.)
• Tuned and optimized risk data processes, queries, execution plans, reports and applications on SQL Server 2005/2008, SSIS, Access (VBA) and Excel (VBA)
• Developed T-SQL and Sybase SQL ad hoc financial reports and risk data reports.
• Experience with billion+ row tables on terabyte size Sybase servers.
• Developed Outlook email alert system and log file monitoring applications in PERL.
• Developed hierarchies and reports in Microstrategy.

Confidential, New York, New York

Data Analyst and Developer

Responsibilities:

• Developed SQL Server 2005 SSIS ETLs migrating and transforming ticketing and financial data.
• Developed T-SQL ad hoc reports analyzing flight and financial data.
• Developed financial reports detailing sales and sales trends using SSRS 2005.
• Developed C# scripts in SSIS
• Reconciled, scrubbed and validated ticketing data across international SQL Server 2005 date warehouse.
• Troubleshot applications and data warehouse assessing application functionality.

Confidential, New York, New York

Database Developer

Responsibilities:

• Developed financial reports in SSRS 2008 detailing sales and sales trends
• Developed ad hoc queries in T - SQL.
• Troubleshot and optimized existing reports increasing efficiency.

Confidential, New York, New York

Marketing Database Developer

Responsibilities:

• Gathered requirements and developed PL/SQL, Access (VBA) and Excel (VBA) financial reporting applications.
• Extracted, reconciled, scrubbed and validated data for Oracle data warehouse using PL\SQL and PERL.
• Developed dashboards, reporting applications reports using Oracle 10g, Cognos, Access (VBA) and Excel (VBA), greatly increasing efficiency and flexibility of reporting.
• Performed logical and physical data modeling for relational databases.
• Developed ad hoc and ongoing monthly reports by gathering and analyzing submission, premium and profit&loss data from Confidential -AIU systems (CRS, eStart EDW, and OGIS).
• Developed PL/SQL, Excel (VBA) and Access (VBA) utilities automating data tasks.
• Performed Unit Testing/UAT and Production Verification sign-off.

Confidential, New York, New York

Database Analyst/Business Analyst

Responsibilities:

• Developed reports and dashboards in SSRS 2005 monitoring compliance with Sarbanes-Oxley (SOX).
• Performed data migration and database conversions using SSIS 2005.
• Validated and reconciled data, traced anomalies upstream to 30 feeds.
• Developed apps in T-SQL and Excel (VBA) to reconcile, scrub and validate data.
• Developed PERL applications to edit configuration files, streamlining processes.
• Developed dynamic Excel (VBA) and T-SQL ETLs.
• Coordinated Unit Testing and supervised staff.

Confidential, New York, New York

Data Analyst

Responsibilities:

• Developed extensive PL/SQL stored procedures and functions and PERL applications deduping, denormalizing, migrating, scrubbing demographic and testing data for load into Oracle data warehouse.
• Developed ETLs in Pervasive Data Integrator and PERL, performing data migration, conversion and scrubbing from mainframe to Oracle data warehouse.
• Developed SQL 2000 T-SQL stored procedures and functions.
• Developed PERL applications to edit XML configuration files, streamlining processes.