SUMMARY:

• Is a local (U.S. Citizen) Data Architect who specializes in information architecture, business process re - engineering, data modeling, and systems delivery to enable strategic business initiatives.
• He has data modeling experience using Erwin and S-Designer to design, re-design, and consolidate transactional and analytical systems.
• He has extensive experience across multiple database platforms remodeling for data delivery and improved database performance. Carl has great communication skills and is available immediately.
• Proven Data Architect with an outstanding record of achievement in both development and delivery through multiple consulting positions.
• Specializes in requirement management, business process re-engineering, and implementing systems that enable strategic business initiatives.
• Strong financial and technical management experience.

TECHNICAL SKILLS:

Web Development: Java Certified, HTML5, CSS, JavaScript, AJAX, JQuery, PHP

Data Modeling: Erwin, S-Designer

Database Development: MySQL, SQLServer 1.42- 2008, Oracle 6.0 - 11g, Sybase 8 - 14, Toad, PL/SQL, T-Sql, Stored Procedures, Scripts, Triggers, Packages, SQLPlus, Views, SQL Anywhere, Tuned queries, Assigned permissions on schema and procedures, installed all flavors of rdms.

Networking Skills: TCP/IP, SNMP, Vlans, SSL, SFTP, FTP, Certificates

Additional Tools: Rational Suite, Clear Case, Clear Quest, SharePoint, Visio, MS Project, MS Office, AllClear, GitHub

Operations: ITIL, Disaster Recovery, Backup/Restore, Data Storage, SLA’s Help Desk Management, Wiki

Operating Systems: Linux, Unix, Windows

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Chief System Engineer

• Designed models for all data integration between Oracle 10 / 11, and DB2 using Cognos, MQ and various ETL tools
• Gathered requirements for a time reporting system across 86 Mayoral agencies for New York City by meeting with key management and union representatives.
• The requirements were stored within Oracle and dictated the time reporting of 165K employees on a daily basis.
• Conducted meetings with Agency heads, directors and timekeepers.
• For the FDNY and New York Law agencies, conducted all requirements gathering for gate access systems deployed redundantly across 10 sites and five boroughs of NYC. Built out 2 sets of redundant datacenters.
• Performed analysis of requirements including gap analyses and conversion to Use Case’s.
• Obtained sign off from Agency CIO, CFO and Project Sponsors.
• Produced weekly status slides presented to the Head of Office of Payroll Management and the Mayor’s Office.
• Performed custom designs for custom systems for Internal Affairs Bureau, HR - gate access system running on SQL Server and the FDNY Redundant SQL Server installations at a primary and backup datacenter
• Created custom designs for Redundant SQL Server installations at a primary and backup datacenter
• Managed Penetration Testing, 5 datacenters and 36 engineers across Development, Test, User Test and production environments
• Managed 5 engineers in Telecommunications covering Exchange, SharePoint, Telephony and desktop support
• Provided system rollout support across 86 New York City Agencies

Confidential, Stamford, CT

Manager

• Migrated Asset Maintenance reporting system from Oracle 8 and Crystal Reports to SQL Server and Visual Basic.
• The system tracked the maintenance needs for all NYC owned or leased asset from single wall, to escalators to elevators.
• The conversion included the capture of field generated pictures yet reduced the number of annually published books from 336 to 164.
• Rewrote an undocumented check writing system from an Amdahl mainframe to Oracle PL/SQL using Data Loader, Packages and stored Procedures.
• Used SQR to track all of its daily production reporting.
• The SQR ran against the PeopleSoft 7.5 application running on Oracle 9.New York City School Construction Authority
• Extracted data out of Oracle Financials 11ii’s Oracle database into Sybase 13.
• Used remote connections to have the databases communicate directly after upgrading Sybase from v 11 to 13.
• Due to the changes of the T-SQL between 11 and 13, all stored procedures were re-written to calculate the to-date cost of each school construction project and account for materials, labor, fees, permits, and track plan to progress status.
• The SCA is responsible for maintaining all 2,000+ schools within NYC.
• Completed all extracts, upgrades and rewriting of the data mart within 26 calendar days.
• Managed and implemented all database modifications for Oracle Financials and PeopleSoft Financials

Confidential, Norwalk, CT

Director of Application Development

• Used ERWin, S-Designer, Toad, Embarcadero, isql and Pl\SQL to create models and analyze databases.
• Led a database consolidation from 8 sales systems were combined into a SQL Server database gaining efficiencies in maintenance, reporting and operations.
• The database was replicated and updated daily across three locations - North America, Europe and Asia.

Confidential, Glastonbury, CT

Senior Technical Consultant

• Created logical and physical database models for a defect tracking system - results fed to the FDA, CDC and NHA
• Extracted data from DB2 to SQL Server and wrote an open-to-buy system for a retailer that owned Petite Sophisticate, August Maxx and Lens Crafters.
• The reporting and calculations were completed using T-SQL, stored procedures and bcp.

Tools: ERWin, S-Designer, Toad, Embarcadero, isql and Pl\SQL

Confidential, Hartford, CT

Senior Technical Consultant

• Model databases to digitize the sales of print ad space and components such as ‘gutter bleed’ for 64 b2b publications including Variety using ERWin, S-Designer, Toad, Embarcadero, isql and Pl\SQL.
• The system was rolled out to 14 countries but data was housed centrally in Waltham, MA.
• Won international industry awards for this system.

Confidential, Branford, CT

Programmer

• Used ERWin, S-Designer, Toad, Embarcadero, isql and Pl\SQL to model databases for an International trade and tariff system that tracked the shipping of goods across 17 countries and 47 planes.

Confidential, New Haven, CT

Adjunct Professor

• Taught C++ and Visual Basic