SUMMARY:

• Information Technology professional with extensive experience in business/IT information and systems analysis, database/data warehouse/repository design and development, reporting and data analysis, metadata management, and IT configuration data management.
• Excellent mix of analysis and project management skills and knowledge stemming from work in various IT disciplines and internal audit.
• Varied industry experience includes Chemicals/Gases Manufacturing, Information Services, Healthcare/Medical Equipment, Financial Services, and Insurance. Broad knowledge base, and proven ability to rapidly assimilate into new business environments.

TECHNICAL SKILLS:

PLATFORMS: Microsoft Windows, IBM OS/MVS, IBM zOSLANGUAGES: SQL, T - SQL, Access VBA, Excel VBA, CA-Easytrieve Plus, COBOL

SOFTWARE TOOLS: MS Office Suite (Excel, Access, Word, Powerpoint) / Project / Outlook / SharePoint and Visio, SQL Server Enterprise Manager, HP TestDirector, BMC Remedy, BMC Atrium CMDB, OS/JCL, TSO/ISPF

MODELING TOOLS: CA-ERwin, CA-BPwin, CA-ModelMart

ERP PACKAGES: SAP R/3, SAP ECC, JD Edwards, GEAC Smartstream

DATA WAREHOUSE / REPORTING TOOLS: MS Access, SPSS ShowCase, Crystal Reports, Business Objects, COGNOS Impromptu/PowerPlay, CA-Easytrieve Plus, IBM QMF/SQL, SAS (Mainframe), Trillium

DATABASES: Microsoft SQL Server, Oracle, IBM DB2, Sybase, CA-IDMS, Microsoft Access

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville, PA

Data Modeling and Architecture Consultant

Responsibilities:

• Provide data requirements analysis, data modeling, database design, and metadata management/reporting for OLTP and data warehouse development projects. CA-ERwin used for all data modeling and database designs in Oracle and SQL Server databases.

Confidential, Center Valley, PA

Senior IT Consultant (contract engagement)

Responsibilities:

• User requirements analysis, documentation, and development for business intelligence reporting applications serving the financial, sales, marketing, inventory control, and contract administration operational areas
• Logical/physical/multidimensional data modeling of OLTP and data mart databases using CA-Erwin
• Data sourcing analysis and mapping, report/data extract development, and application development using SPSS ShowCase, SQL, MS Access/Excel.

Environment: IBM DB2 and MS SQL Server database environments, JD Edwards ERP system and data warehouse, CA-ERwin, SPSS ShowCase, SQL, MS Access/Excel.

Confidential, Trexlertown, PA

Repository Administrator / Reporting Specialist

Responsibilities:

• Database and application analysis, specification and design for in-house developed repositories using CA-ERwin, MS Visio/Word/Excel
• Logical/physical database and data warehouse modeling using CA-Erwin
• Standard and ad hoc report and data extract development using MS Access/Excel, MS SharePoint, and Crystal Reports
• Repository development project management using MS Project/Excel/Visio/Word
• Content management and ETL processes using SQL, MS SQL Server stored procedures, MS Access/Excel
• Application test specification and execution using HP QuickTest Pro
• Data integration analysis and mapping specification using SQL, MS Access/Excel
• Development of repository and portfolio management work processes and support of end-users
• Served as key resource for implementation of IT service management program, and federation of repository with IT configuration management system based in the BMC Atrium software and MS SQL Server Reporting Services (SSRS)

Environment: MS SQL Server, IBM DB2 and Oracle database environments, CA-ERwin, SQL, MS Access/Excel/Visio/Project, Crystal Enterprise, Visual Source Safe (VSS), SharePoint, MS SQL Server Reporting Services (SSRS) and Integration Services (SSIS), SAP R/3 and ECC

Confidential

Database Analyst / Metadata Management Specialist

Responsibilities:

• Data requirements analysis, logical/physical data modeling and database design for ODS, data warehouse, and data mart development projects using CA-ERwin
• Metadata management reporting using Access, Crystal Reports, COGNOS Impromptu and Powerplay
• Team resource for ERP master data standards research and adoption
• Led project to create and implement CA-ERwin data modeling metadata standards and best practices
• Created multi-year plan for an IT repository strategy
• Designed, managed and maintained several in-house developed repositories based in Access and Sybase.

Environment: MS SQL Server, IBM DB2, Sybase, Oracle, CA-IDMS database environments, CA-ERwin, SQL, Access, Excel, Visio, COGNOS Impromptu and Powerplay, Crystal Reports, Visual Source Safe (VSS), SharePoint

Confidential, Parsippany, NJ

Data Administration Consultant

Responsibilities:

• Data requirements analysis, logical/physical data modeling and database design for OLTP and repository databases using CA-ERwin and Texas Instruments (TI) IEF
• Designed, managed and maintained several repositories based in MS Access
• Served as lead data analyst/database designer for several new product development projects
• CA-ERwin and TI IEF tool administrator and subject matter expert
• Integrating, managing and reporting metadata content from Sybase, DB2, and IDMS databases using MS Access, Business Objects and CA-Easytrieve Plus

Environment: IBM DB2, Sybase, CA-IDMS database environments, CA-ERwin, SQL, MS Access/Excel/Visio, CA-Easytrieve Plus, GEAC Smartstream, TSO/ISPF, OS/MVS, VSAM, COBOL

Confidential, Peapack, NJ

Systems Analyst

Responsibilities:

• Systems analyst, data analyst, and user liaison for application development projects
• Supported 25 member Corporate Controller's organization for decision support software development, report programming, and financial reporting automation in a mainframe environment
• Provided application development and services to the corporate benefits, insurance claims processing, human resources, marketing, accounts payable operational areas
• Planned and supervised audits of application system work processes, security, and development projects
• Developed software for audit testing using CA-Easytrieve Plus
• Supervised and trained a staff of four auditors.

Environment: IBM DB2 and CA-IDMS database environments, TSO/ISPF, OS/MVS, VSAM, COBOL, CA-Easytrieve Plus, SAS, Data General CEO Office suite