SUMMARY:

• Strong experience as both technical project lead and a manager of people.
• Systems developer with over fifteen years experience leading development of crucial, high - value business solutions for a broad range of corporate and business clients.
• Offers a valuable combination of technical expertise and strong understanding of business requirements, with experience developing key applications for domestic and multinational companies.
• Strong project management expertise throughout the full project life cycle. Including client and end-user communication, staff scheduling and delegation, and management of milestones.

TECHNOLOGY SKILLS:

Current Technologies: TRANSACT SQL, EXCEL, Confidential, SQL Server, ETL (Extract, Transform, Load), BI Tools suite SSIS/SSAS/SSRS, Kimball method DW design, Redgate SQL Server tools, ORACLE, MDX, SQL, PL/SQL, Stored Procedures, Transact SQL

Legacy: Domino, Lotus Notes,, LotusScript, CASE Tools, ONYX CRM, CRYSTAL Reports, MS Office Suite, Lotus Suite, CleverPath Forest, Trees, Visual Basic, VB.NET, JavaScript, HTML, COBOL

EXPERIENCE HIGHLIGHTS:

Confidential, Moonachie, NJ

BUSINESS ANALYST/DEVELOPER

Responsibilities:

• Working as business analyst and developer on Confidential and Confidential systems DWS database code system.
• Extensive communications with off-shore team and trouble-shooting SQL defects.
• High pressure, fast moving environment with short term deadlnes.

Confidential

BUSINESS ANALYST/DEVELOPER

Responsibilities:

• Developed customer database and created mailing and marketing campaign.
• Digitized records and bookkeeping application.
• Aided with customer facing social networking web pages.
• Implemented use of Confidential clone for use by sales force.
• Confidential is small business where requirements stretched across many areas within the company.

Confidential

TECHNICAL ANALYST

Responsibilities:

• Worked on a variety of client support issues.
• Confidential ’s primary product Confidential CO+.
• Essential duties included heavy TRANSACT SQL development for creation of Bordereau imports and insurance industry oriented reports.
• Work requests were developed from client meetings and implemented around the Confidential CO+ framework and EXCEL analysis worksheets.
• Confidential underwent a buy out recently and has eliminated all positions in the New York area.

Confidential

SENIOR ETL CONSULTANT/DEVELOPER

Responsibilities:

• SQL BI Developer for team in implementation of dataflows related to insurance treatments and EDW.
• Primary work in ETL using SSIS and Transact SQL programs.
• Work centered on very complex application of insurance treatments to source data in order to create extracts using ETL methods for latter import into Confidential .
• Technical skills required advanced SSIS, ETL and SQL.
• Deep understanding of insurance practices required to work in this high pressure deadline oriented environment.

Confidential, NY

LEAD ETL CONSULTANT/DEVELOPER

Responsibilities:

• Lead in development, planning and implementation of a Lotus Notes migration to SQL*Server and SharePoint.
• This entailed creation of Lotus Notes Agents, SSIS packages to copy rich text and other forms of Notes data into relational database structure utilizing client determined ETL methods.
• Development of SSIS packages to aid in data move for new company wide systems.
• Sources and destinations varied from MySQL to raw files and semi-structured data dumps provided by vendors.
• Required data scrubbing and research of data elements to establish uniform outputs.
• Development/design of SSRS reports for statistical analysis.

Confidential, New York, NY

SENIOR BI/ETL CONSULTANT/DEVELOPER

Responsibilities:

• Development and maintenance of large scale SSIS ETL feeds for company data warehouse.
• Source data mostly ORACLE, but also come from a variety of unstructured flat file, Confidential and proprietary sources.
• Required intense data analysis and conversion of data across international character sets.
• Consists of data loads from main ORACLE financials database going back about 20 years. Large tables of 300 million plus rows.
• Involved table partitioning for performance gains and storage efficiency.
• SQL Developer on company initiative for front and back office ASP application for sub contractor portal. Major work SQL triggers, data feeds (SSIS) and reports (SSRS).
• SSIS packages for company HUB and other data exchanging applications.
• Planning, partitioning, development for OLAP cubes. Partitions divided according to Parson's unique time frame requirements.
• Creation of KPIs for tracking of financial project performance. Specifically in relation to margin erosion; the prime measure of project profitability.
• Building of cubes and summary tables.
• Primary technical resource for SQL*Server in this 90% ORACLE environment.

Technologies: SSIS, Excel, Confidential, SSAS, SSRS, SQL*Server, T-SQL, ORACLE 10g, Stored Procedures

Confidential

LEAD CONSULTANT/DEVELOPER, Orange County and Los Angeles, CA

Responsibilities:

• This Onshore/Offshore company hired to provide full time consulting services to their primary project customers.
• Repaired an SSIS production issue at a major Auto Manufacturer in Orange County, CA.
• Structuring and partitioning of cubes for large sales database with particular attention to storage option and partitioning and frequency of feeds.
• Live cube model contained data for daily sales statistics.
• Application is a ‘live’ sales feed system presented via ASP.Net 2.0 front end, this included an SQL 2005 back end using SSIS to perform ETL operations from multiple sources, primarily AS/400 legacy system, SSIS application require redesign and new approach to implementation focusing more heavily upon SSIS native structures and controls.
• Application was around 60 SSIS steps feeding about 30 cubes built within the confines of this package. Using SSAS and MDX.

Technologies: SSIS, SSAS, SSRS, SQL*Server, T-SQL, VB.Net, SQL*Server, Stored Procedures

Confidential, Philadelphia, PA

INTEX DEVELOPER/CONSULTANT

Responsibilities:

• Worked as Lead Developer/Architect on a large scale INTEX data warehouse implementation for a client that specialized in trading of mortgage backed securities.
• Extensive hands-on INTEX API exposure was a main part of this effort.

Technologies: SSIS, SSAS, SSRS, MDX, INTEX VB.Net API, SQL, Visual Studio, SSRS, Crystal Reports, Stored Procedures

Confidential, Camden, NJ

ASP AND ORACLE DEVELOPER/CONSULTANT

Responsibilities:

• Confidential is implementing a large scale SAP application.
• Highly disciplined environment involving extensive documentation and creation of system and unit test scripts
• Worked as part of a reconciliation team for the accounting area within the iSales group.

Technologies: Oracle, InterDev, ASP, Confidential , MSI, Crystal Reports, Stored Procedures

Confidential, Willow Grove, PA and New York, NY

ASP.NET DEVELOPER/CONSULTANT

Responsibilities:

• Responsible for all UI design, coding and development of front-end ASP and ORACLE PL/SQL packages, Client provided rough-cut front end and ORACLE data model. Utilizes .Net framework, Java Script, and ORACLE array binding techniques for back-end Inserts/Updates/Deletes.

Technologies: Oracle, ASP.Net, JavaScript, VB.Net, Crystal Reports, Oracle Stored Procedures (Transact SQL)

Confidential, Philadelphia, PA

APPLICATIONS DEVELOPMENT MANAGER

Responsibilities:

• Served as the Manager of a small development staff responsible for all application development within the PMHCC agency domain.
• Performed design, coding and implementation.
• Supervised four full time employees and a fluctuating number or consultants.

Technologies: VB.Net, SSIS, SSAS, SSRS, InfoPath, XML, Lotus Notes, Crystal Reports, Stored Procedures

Confidential, DANVILLE, PA

SENIOR TECHNICAL ANALYST/PROGRAMMER

Responsibilities:

• Served as project leader for the development of a sales force automation system used by 100+ primarily non-technical users, directed the efforts of a five-member project team.
• Installed, configured and implemented SQL*Server 7.X and SQL*Server 2000 on multiple servers to integrate with ONYX CRM.
• Interacted extensively with management to achieve alignment of project details with company requirements as well as to report on project status.

Technologies: VB6/VB.Net, SQL*Server (6.5-2000), Stored Procedures, ONYX, HBOC CRMS, Oracle