SKILLS SUMMARY:

•Over fifteen years of experience in the field of Information Technology Systems, Administration and Business Systems Analysis. Careers in a higher education graduate facility with prior experience in health insurance, utilities, and aerospace manufacturing.

•Strong Knowledge and Experience in Oracle 9i, 10g, 11g Data Warehouse and OLAP and OLTP concepts, and proficient in SQL, PL/SQL.

•Knowledge and experience in data warehousing and ETL (extract, transform and load) principles and practices including coding and testing.

•Created Business Requirement Documents Data Flow Diagrams, Business Flow Diagrams. Maintain and keep up to date, data dictionary Meta-data.

•Expertise with reporting tools experience in Oracle 10g Reports, Hyperion Interactive Reporting (BRIO), and desktop applications, including MS Project, MS Access, Excel and Word.

•Expertise using Oracle 10g Forms, procedures and triggers, user interface GUI and field testing for “Plan of Study” student/faculty online application.

•Liaison with business functional users and other business managers, and process owners to: gather requirements and produce Business and User Requirement Documents. Interpret user requirements to provide clear and concise audit reports to key business areas.

•Practice comprehensive data analytical skills from data warehouse and provide mature and sophisticated approach to data security and data privacy.

•Work effectively across all levels of the organization and functional business areas using excellent customer service skills.

•Provide production support, business and user acceptance testing.

•Train end-users in new web-based data marts and environment applications where required.

SYSTEMS PROFICIENCY:

Systems/Packages/Tools

Names

Operating Systems:

Windows XP/NT Windows 7, IBM Mainframe MVS.TSO/ISP

Programming Languages:

PL/SQL, SQL PLUS, Natural V2.2.8, IBM Mainframe QMF, JCL, JavaScript, UNIX

Packages

SCT Banner Higher Education – Multi-module management transactional system.

WebUtil 1.0.6 Forms Client-Server Utility Interface

RDBMS:

MS SQL, TOAD, Oracle 8i/9i10G, 11G, MSAccess 2003, 2007

Business Intelligence & Reporting

Oracle Developer Suite Forms and Reports 10g, Frame Maker, Frame Builder, Cadre Teamwork V4.1, MS-Project

Business Objects:

SAS Enterprise Guide, SAP ERP, Technolutions – SLATE Development of Enterprise Information Dashboards College and University Based.

Teradata, Tableau Visual Analytics Oracle Hyperion Internet Based Reporting, Data University, MetaHub.

Other Tools

AppWorx6 Banner self-service web-based accounting job scheduler, CAD/CAM, MS Visio, SRUM, Agile Software Development, TortoiseSVN.

PROFESSIONAL EXPERIENCE:

Company: TEKSystems, Farmington, CT March 2015 – June 2015

Client: CIGNA, Bloomfield, CT

Profile: Business Analyst, Business Intelligence Solutions

Responsibilities:

•Business Analysts at CIGNA Information Management Analytics (CIMA), Business Intelligence Solutions (BIS). As a Business Analyst develop requirements from business owners, document and develop user stories to determine and define business needs and business values for tables and integrated views to migrate from legacy data sources within CIGNA to Teradata Lithia platform.

•Upon migration of legacy data to Teradata perform User Acceptance Testing (UAT). Develop user acceptance testing criteria for data history and data refreshes.

•Provide Quality Assurance documentation.

•JIRA and RALLY User Story creation and Agile development to manage task, task estimate and task completion time.

•As a team member, participate within an Agile Framework, program iterations and sprints, develop estimates for tasks. Provide scrum check-ins, demos, and project retrospectives.

•Data Dictionary documentation and data flows, legacy data source to target source mapping (Teradata), underlying metadata for data warehouse tables and integrated views.

•SharePoint Documentation Management. Populate and manage data knowledge repository with necessary project team documentation and data models.

Company: ABACUS, New York, NY September 2014 – December 2014

Client: Tsunami TSolutions, Glastonbury, CT

Profile: SQL Developer

Responsibilities:

•Developed and maintained back-end Materialized Views using MS SQL Developer

•Create new or maintain existing database tables and database objects based on requirements specifications.

• Provide aerospace engine data to Maintenix, and Engine Performance Utilization Application (EPUA) and Ad Hoc Reporting Tool (ART).

•Customize standardized reports using Crystal and Excel to Test and to Quality Assurance.

•TortoiseSVN revision control and source control software to manage and lock up new software for configuration and shipment to customer.

•Acquired Scrum Certification and practiced Agile Software Methodologies in a software development environment.

•Utilize YouTrack to integrate software bug control, SVN, and integrate test plans to QA. Create new tasks in Agile board and link tasks as they are related to parent/sub-tasks.

Company: Rensselaer at Hartford, Hartford, CT February 1999 to May 2014

Profile: Programmer Analyst Administrative Systems

Project:

Support data warehouse upgrade from Oracle 9i to Oracle 10G. Migrate and upgrade all reports and forms (over 300 supporting data models) to Oracle Developer Suite 10G. Oracle 10g Forms User and GUI Interface, validate field data and functional test web-based applications.

Responsibilities:

•Database programming to maintain data integrity analysis plus data migration, create and modify scripts to support ETL (Extraction, Transformation and Loading) using UNIX, shell scripting at Hartford’s local data warehouse.

•Asses and validate data to day activities to determine a business case; such as accounting and marketing operations and processes.

•Monitor and elicit new process requirements and keep business congruent with company goals.

•Provide new and timely immunization Oracle 10g reports based on new state Varicella requirements.

•Increase enrollments – Contact information for inactive and non-registered students to complete curriculum prior to first day of term.

•Design and develop “Plan of Study” Oracle Forms 6i to Oracle10G online update course information application including guideline documentation and manuals as well as training workshops for faculty and staff user community.

•Support Marketing, Sales, and Enrollment by providing data based on criteria for required mailing campaigns.

•Provide production support and business requirements analysis to produce numerous standardized and ad hoc Oracle 9i and 10g Reports; supporting Accounts Receivables, Admissions, Enrollments, and Registrar functional areas.

•Customize report design and development of packages, functions, procedures, stored procedures, triggers, tables, and customized views utilizing Oracle PL/SQL database programming language.

•Develop financial account detail reports using Brio Intelligence V6.6 (Hyperion).

•Produce yearly electronic and paper tax filings, Oracle 9i data warehouse feed to Reports 6i containing boiler plate forms 1099M and 1098T to IRS for Accounting. Provide data requirements in accordance with Publications 1220.

•Association to Advance Collegiate Schools of Business (AACSB) - Provide Graduate and student demographic, and working professional profile in information to constituents at the main campus, RPI Troy, NY.

Environment: Oracle 10G Web-based Front-end applications for Admissions, Plan of Study, Student Services Enrollment and Financial Requirements.

Company: Universal Staffing Contractor August 1998 - February 1999

Client: Pratt and Whitney

Profile: Cost Configuration Analyst for PW6000 & PW8000 Controls/Externals Engineering

Project: Provided quality service through data base. Performed engine trade studies to determine value versus engine cost elements based on weights and metrics comprising engine parts.

RESPONSIBILITIES:

•Worked with Flight Systems/ Software engineers in Inter-Program Team (IPT) to maintain Control System Configuration Databases using MS Access.

•Gathered, compiled, and organized proper component costs and weight data.

•Provided ability through database; to track various Control System Configurations.

•Provided Project Managers and Engineering Leads in creating agenda, meeting minutes, and prepared follow-up action items.

Environment: Lotus Note, Microsoft Office Suite (Access, Excel, Word)

Company: Yankee Gas Services, Meriden, CT June 1996 - March 1998

Profile: Computer Programmer Analyst

•Project: Modified and supported existing application systems in both the mainframe batch and online environments utilizing: Natural V2.2.8 in a mainframe environment; IBM/MVS TSO/ISPF/JCL.

RESPONSIBILITIES:

Title: Computer Programmer Analyst

•Analyze business needs, designed, developed, documented, and implemented software systems in functional areas: Accounting, Capital Budgeting, Energy Assistance, Finance, and Customer Service. Work with and instruct end-user personnel.

•Managed Energy Assistance Program. Acquire and process information from field personnel to provide underprivileged families with energy assistance aid.

•Evaluate legacy systems for Y2K compliance and make necessary changes to test environment utilizing MDI Y2000 Converter Tool.

Environment: IBM Mainframe, JCL (Job Control Language) Windows XP, MSAccess, Lotus

Company: CIGNA Health Care, Bloomfield, CT April 1994 -June 1996

Profile: Information Resource Data Administration (CCSU Intern)

Project: Provide consistency, standardization and reusability in support of corporate data share principals and objectives.

RESPONSIBILITIES:

•Support the analysis, design and deployment of Production Databases for CIGNA Healthcare.

•CASE Bachman Analyst, a front end software tool suite for DBA, to reverse engineer, and reformat the MVS Data Dictionary as required.

•Participated in technical initiatives to improvement and modification of Standard Abbreviation program tools using PC REXX.

•Audited and synchronized Data Dictionary to IBM MVS/DB2 Workbench.

•Designed and maintain data dictionary Meta topics to support metrics analysis and reporting with IRIS View, Data Manager V7.1, and QMF/SQL.

Environment: IBM MVS Mainframe, IRIS View, MS Windows

Company: UTC Hamilton Sundstrand, Windsor, CT September 1987 -April 1994

Profile: Flight Systems Software Engineering Aid

•Projects: Provided database testing, software change control and integration, to the production environment, for Boeing C-17, Avionics – Flight and Data Management, Airbus Air 320, Data/Display Management Control (DCM), Environmental Engine Control Systems (EECS). Participate in software configuration and delivery for RAH-66 Comanche Avics Helicopter.

RESPONSIBILITIES:

•Installed and maintained Boeing/Sikorsky "documentation generation tools" using Cadre Teamwork V4.1 and Document Preparation Interpreter (DPI), Computer Data Interchange Format (CDIF) and Frame Maker V3.1x in Unix Platform.

•Performed duties as software development librarian (SDL) maintaining status tracking in accordance to MIL-STD compliance. Keep Boeing C-17, Air Propulsion Data Management Computer (APDMC) SDL in a position to pass all audits with minimal impact to cost and schedule.

•Interfaced with vendors to enhance support and provide training for Flight Systems and Software groups.

•Software Configuration Management (SCM). Track the life cycle through acceptance testing maintenance. Freeze software for release with Documentation, to Lock Heed Martin’s Boeing C17 and provided AS-400 PDP tape.

•Maintained and managed tool sets on DEC VAX\VMS with Digital Command Language (DCL).

Environment: DEC VAX/VMS, IBM TSO Mainframe, UNIX

Education:

Masters of Business Administration MBA May 1997 - May 2000

Management of Technology

Lally School of Management and Technology, Hartford, CT

Rensselaer Polytechnic Institute, Hartford, CT

Bachelor of Science BS, Management Information Systems September 1992 – Spring 1996

Central Connecticut State University, New Britain, CT

Associate's degree AS, Business Administration Data Processing Spring 1987 – Summer 1992

Tunxis Community College, Farmington, CT

References Provided Upon Request

Contact this candidate