Results driven senior IT professional with over 20 years of experience in the financial, manufacturing, healthcare and management consulting industries. Previous experience in management, data architecture, solutions delivery, data warehouse, and enterprise-scale full project lifecycle application development. Worked in various roles including program/project manager, solutions delivery manager, database services lead/manager, data warehouse manager/lead/developer, data center team lead, programmer, and business/systems analyst.

• Project Management: PMP, RUP, SDLC, CBAP, Agile, PMIS
• Business Process Management: Systems Analysis and Design, Workflow and Process Improvement, Automation, Performance Metrics
• Data Modeling: ER Conceptual/Logical/Physical , Dimensional Star Schema and Snow-Flake , Data Flow Diagram, UML
• Data Warehouse: DW, ODS, Data Marts, Business Intelligence Tools, OLAP
• DBMS: DB2, Oracle, SQL Server, Informix, MySQL, MS Access
• Programming Languages: SQL, C, C , Java, COBOL, PL/SQL, UNIX Shell, DB2 Stored Procedure
• ETL - Informatica, Ascential DataStage, SQL Server Integration Services
• Reporting Tools - SAP Business Objects, Crystal Reports, Hyperion Brio Intelligence, SQL Server Analysis and Reporting Services
• Data Profiling/Quality - Talend Data Quality / Open Profiler, DQ Analyzer
• Microsoft - Project, Sharepoint, Word, Excel, Visio, Powerpoint, Access
• Programming Languages: C, C , Java, UNIX Shell, Perl, PL/SQL, Visual Basic, XML, COBOL, CICS, JCL
• Hardware: IBM Mainframes, AS400, RS/6000, Intel servers, UNIX/Linux servers
• Other Development Tools - Erwin All Fusion, Mercury ITG, Tidal, Autosys
• Messaging/File Transfer - FTP, MQ Series, NDM Network Data Mover
• ERP/CRM Application - MAC-PAC, BPCS, MAPICS, Siebel, Salesforce

Confidential

• Work in the Information Services - Business Intelligence and Analytics group
• Work with senior managers from various functional areas to understand requirements, current processes and issues, and recommend technical solutions
• Tracks status of project activities and ensures that schedules and priorities are being met
• Manage the development cycle - requirements, analysis, design, development, testing, and deployment of data warehousing, analytical and reporting solutions
• Perform data analysis, develop stakeholder presentation, and create and modify prototypes, mockups, and other visual aids to assist in communicating development objectives
• Elicit, review and verify the following documentation: Project Charter, Project Plan, Business Requirements, Functional Specifications, Data Flow Diagrams, Logical and Physical data models, Data Migration, Test Plans, Test Strategy, Test Evidence, Training, Operation's Handoff, etc.
• Developed PMIS portal using Microsoft Sharepoint for managing projects, team collaboration and document management
• Provide regular verbal and written project communications/updates regarding status and issues

Confidential

• Worked as a senior data consultant in conversion of existing systems to Salesforce
• Participated in the gathering, review and analysis of business requirements
• Performed identification and inventory of data sources, data analysis and profiling, and generated data quality reports
• Developed data migration strategy and ETL mapping specifications including source-to-target data element mapping, business rules processing and data transformations
• Developed ETL jobs to extract data Accounts/Organizations, Contacts, Household, Opportunities/Donations, Affiliations, Relationships, etc. from various data sources, performed data transformations data cleansing, deduplication, standardization remediation of data quality issues , and load Salesforce using Apex Data Loader API

Confidential

• Accepted full time position as a Senior Manager in the Business Information Management practice for Confidential
• Project start date was postponed indefinitely due to client wind down

Confidential

• Worked as data consultant in Confidential enterprise data strategy group
• Participated in the development of Fannie Mae's enterprise data architecture strategy, roadmap and data framework
• Participated in development of enterprise approach to master data management, data governance, data warehouse and business intelligence architecture
• Performed review and analysis of existing enterprise data repositories - data warehouses, ODS, data marts, master and reference data repositories
• Analyzed information and data requirements, usage of data services, data virtualization and data integration processes
• Project was put on hold and was furloughed indefinitely

Confidential

• Managed and led the strategy, design and development of the Release Recidivism Data Mart project, a shared data repository for Confidential Law and Public Safety agencies - Confidential - for performing prisoner release-reentry data analysis and reporting to the office of the Governor
• Managed and led requirements gathering business, data, technical using JAD/Focus sessions, one-on-one interviews and presentations
• Developed data mapping specification document and dimensional model design managed and led ETL and BI application/reports/dashboard development
• Performed data quality management initiatives to identify and correct data quality issues data quality tasks include data discovery/profiling, cleansing, matching, notification and standardization
• Introduced iterative development/testing processes and formal QA testing methodology

Confidential

• Worked as data warehouse consultant to review and validate the newly created Sungard financial reporting ODS data model that will replace Glenmede's mainframe legacy reporting system
• Performed project management, requirements gathering, identification and inventory of data sources via user interviews, group work sessions and application code review
• Created data mapping of financial reporting ODS to identified data sources including business rules, data transformations and business/technical metadata
• Developed prototype data model for the financial reporting data mart
• Set up ETL environment and developed ETL jobs and processes to extract and process data from various systems Sungard Global Plus, Onyx and InvestEdge , and load data to target financial data mart
• Developed process to capture and report ETL operational process metadata the captured metadata helped identify the job sequencing to meet the available extract time window

Confidential

• Performed project management, operations and workflow analysis, and production technical support
• Documented problems, issues log and problem resolutions in the Problem Management System
• Developed procedures and processes for handling system failures, overnight job problems and critical system issues review and perform updates and revisions to current process documentation

Confidential

• Managed and led project management, application development and support, database and server management, and development of IT policies and procedures
• Worked as liaison between technology group and other PSG departments
• Managed and led various projects including implementation of ExtraView Issue Management System Workflows, Dashboards, Analytics , PSGNB Community Portal Content Management System , data Integration and reporting

Confidential

• Worked as Senior Project/Program Manager for the Computer Services Division. Managed the data integration project for the SRA/Mantas Anti-Money Laundering, Siebel CRM data sourcing and integration, Portfolio Investment Optimization and Rebalancing, Client Portfolio Transition, Mutual Fund Reporting and Know Your Customer and Enhanced Due Diligence reporting.
• Given additional responsibility of Application DBA Manager in 2002. Supported all technology projects and business data users by providing database administration and development services, data architecture and administration, data migration, logical data modeling and physical database design, non-public information data masking and data/database standards
• Initiated and led the data warehousing group in 2004. Designed and developed the data warehouse architecture, procured DW/BI software tools, developed data warehouse standards, performed data profiling and published data dictionary/metadata/data quality reports
• Managed and led implementation of several data warehouse projects: Business and Credit Metrics, Sales Incentives Planning, Portfolio Analytics and Risk Control, Portfolio Administration and Monitoring, Assets Under Management and Wealth Advisory Management
• Performed program/project management, requirements gathering, stakeholder communication and management, systems investigation and analysis, data sourcing and discovery, data modeling, data quality management, ETL development, and development of business intelligence reports/applications/scorecards/dashboards/pivot tables

Confidential

• Managed and led the application development group for the Strategic Global Accounting system, designed to create one universal accounting system over the Confidential numerous lines of business.
• Responsible for reengineering the design and process of trade transaction processing from static rule based architecture to a dynamic calculation engine. The new design reduced transaction processing time by 25 percent and minimized application maintenance costs by 500K annually.
• Prepared detailed project plans, system analysis documentation, system and data flow diagrams, project design documentation and functional specifications.
• Recipient of incentive and retention bonus awards

Confidential

• Managed and led the Revenue Solutions Center Technical Architecture Group
• Provided management and technical services including architecture design and development, programming, software configuration, change management, database administration, performance tuning, network and hardware support
• Managed and led implementation and customization of Arthur Andersen Tax Accounting System for the IRS Federal and various state agencies NJ/CA/NY/OH/FL/PA/DE/PR
• Managed and led several ERP/MRP system implementation and customization projects BPCS, MACPAC, MAPICS for various client engagement projects
• Performed requirements gathering, systems investigation, systems and data flow diagrams, functional and technical specifications, programming and documentation
• Recipient of several employee of the month awards

Confidential

• Managed and led the IT Department for Greg Manning Auctions, Inc. and its subsidiaries - Confidential.
• Managed and led multiple projects from project initiation, planning, development, testing, production implementation and delivery
• Led the application development of GUI-based Auction, Describing, Accounting and Billing systems.
• Standardized desktop machines and builds which led to 200K savings in decreased maintenance contracts, decreased technician support and discounted volume pricing.