Contract with DesignMind

Contract with Skytech StaffingConsolidate sales data from multiple sources to feed into Salesforce direct sales and marketing

Modeled new databases and Improved existing databasesUpdated Data Warehouse ETL processes in SSIS to extract data from transactional systemCreated Views, Functions and Stored Procedures to support Tableau reports

Contract with DesignMindCreated data warehouse for the major printer ink cartridge resupplierCreated all ETL sps, package and SQL Agent jobsTrained in-house users to support and extend the system

Contract with DesignMindCreated SSRS reports based on deprecated Crystal ReportsCoded T-SQL stored procedures to return data for reportModified complex data loads in SSIS

Contract with Kforce• Reduced lag time for responding to Business Intelligence team requests• Identified locations of Personally Identifiable Information (PII) in all production databases as part of an initiative to reduce the PII footprint by Answer Financial’s corporate parent (Allstate) • Regularized the Business Intelligence’s team access to all databases. Great care was needed to not interfere with the teams’ ability to do their jobs.• Reduced SQL Agent job failures by analyzing all failures and working with the BI team to correct them.• Set up regular process to refresh statistics and rebuilt or reorganize indexes.

* Contracted with various companies in NJ, NY and CA* Designed logical and physical database models and schemas* Programmed database objects: stored procedures, functions, triggers* Provided troubleshooting of problem queries using query plans, trace and profiler* Designed and built ETL flows in SSIS to support data warehouse operations

* Technical lead on a 4 year project to replace a customized DMS based on FileNet Content Services with a SQL Server backend with an installation of OpenText Content Server with an Oracle backend. The company successfully transitioning to an up-to-date, powerful document management system providing increased overall efficiency and reliability* Converted complex T-SQL stored procedures to PL-SQL for other enterprise applications that interact with the DMS (Workflow, Check Processing, Tax Reporting, etc.) resulting in a seamless migration to the new system.* Administered a SQL Server database functioning as the backend for a customized DMS based on FileNet Content Services maintaining a high level of user satisfaction until the application was decommissioned.* Improved query performance using SQL Server Enterprise Manager to identify necessary indexes, query hints and rewrites which resulted in stellar application performance.* Created a nightly process to import and reconcile extensive enterprise data into DMS database using SQL Server Integration Services (SSIS) which integrated the DMS into the enterprise.* Created a reporting system to provide senior managers with reports on all aspects of the application: performance, usage, metadata utilization, data integrity which allowed them to address user concerns and guide needed development.

* Principal database designer and developer on a project creating a customized DMS for Bessemer Trust based on FileNet Content Services for Bessemer Trust which provided a solid foundation for front-end development.* Maintained data dictionary which allowed front-end developers to work more quickly when writing code to access the database,* Improved query performance using SQL Server Enterprise Manager to identify necessary indexes, query hints and rewrites which resulted in excellent application performance.* Wrote COM objects in VB6 to facilitate interaction between web pages and the database which resulted in timely and reliable database access for the front-end.

Contract with AETEA* Performed business analysis with in-house attorneys to port Legal Case Management System from a DB2 mainframe application to the ConEd Intranet.* Wrote SQL queries against a DB2 mainframe which allowed the firm to maintain its legacy back-end while moving to more modern front-ends.* Wrote intranet app using ASP using AJAX-like techniques to provide a web application that performed like a thick-client application.

Contract with Spherion* Supervised a team of business analysts in the integration of a new billing system which resulted in a solid requirements document on which the client could base their design.* Interacted with a national sales team to ensure that business needs were addressed across the organization which resulting in user buy-in from all sales offices.

* Client: DONALDSON, LUFKIN & JENRETTE* Led a team of specialists to maintain and extend a complex portfolio management, analysis and reporting system which enhanced DLJ’s ability to take advantage of rapidly emerging business opportunities.* Led analysis team to defining a new Deal modeling method, based on XML, to support a web-based version of the system which allowed DLJ’s traders to quickly access reports in support their trading activities.* Kept abreast of constantly changing client needs and managed the team to extend the system’s functionality, often resulting in releases on a weekly basis which kept the application relevant in a fast-moving company.

* Created first company intranet which allowed departments to share important information and documents within and between departments.* Created web pages for each practice area and implemented upload methods for business users which resulted in the business users being in control of their own content.* Wrote company directory application using ASP and SQL which allowed employees to more easily identify and interact with colleagues in a rapidly growing company.