We provide IT Staff Augmentation Services!

Programmer Analyst Resume

5.00/5 (Submit Your Rating)

HIGHLIGHTS 
I am currently working in a higher graduate education facility with prior experience in insurance, utilities, and aerospace manufacturing. I work effectively across all levels of the organization and functional business areas by interpreting user requirements to provide clear and concise audit reports to key business area stack-holders. I also practice comprehensive data analytics from our data warehouse and provide mature and sophisticated approach to data security and data privacy.

SKILL SETS & CORE COMPETENCIES

  • Oracle Forms 10G and Reports Developer Suite Applications
  • Create and maintain over 300 reports and data models and forms in production.
  • Oracle 9i and 10G PL/SQL
  • Understand all data sources to use data warehouse to acquire and perform necessary data analytics.
  • IRIS/View Data Manager Version 7.1
  • Mainframe Data Dictionary Meta Topics.
  • Software/Systems Development Library (SDL) to pass all audits.
  • Data Patterns and Data Integration.
  • Perform database migrations, conversions of existing database and migrations.
  • Software Configuration Management Y-drawings to configure and freeze software for production shipment.
  • Resolve data issues on incident and process problem resolution.

RELEVANT WORK EXPERIENCE

Confidential, HartfordCT
Oracle Programmer Analyst.

1999 – Present

Certificate of Achievements
MS Access, BRIO-Hyperion, Visual Basic, JavaScript
Service Recognition Award - Ten Year milestone.

Pratt & Whitney (Universal Staffing Contractor), Controls Cost and Configuration Analyst.

1998-1999

Yankee Gas Services, Computer Programmer Analyst.

1996-1998

CIGNA HealthCare (Intern), Information Resource Management Administration.

1994-1996

Confidential, Engineering Aid.
Senior Management Award – As a group effort, for successful completion and delivery of the C17 Air Propulsion Data Management Computer to Douglas Aircraft in 1992.
Continuous Improvement - Managing for Natural Teams.
Service Recognition Award - 5 Year milestone.

1987-1994

TRAINING & EDUCATION

MBA Management of Technology

BS Management Information Systems

AS Computer Science

EXPERIENCE DETAIL

Confidential, Hartford, CT (1999 – present) Title: Programmer Analyst
  • 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.
  • Database programming to maintain data integrity analysis, and data migration, create and modify scripts to perform ETL (Extraction, Transformation and Loading) using UNIX, shell scripting at Hartford’s local data warehouse.
  • Designed and developed “Plan Of Study” Oracle Forms 6i to Oracle10G online update course information application including guideline manuals, and 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 6i Reports; supporting Accounts Receivables, Admissions, Enrollments, and Registrar functional areas.
  • Customized 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.
  • 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.

Results: Provide new and timely immunization reports based on new state Varicella requirements which would have led to a forced school closure. 
Increase enrollments – Contact information for inactive and non-registered students to complete curriculum prior to first day of term.
Association to Advance Collegiate Schools of Business (AACSB)- Provide Graduate and student demographic, and working professional profile information to continuants at RPI Troy main campus.


Confidential, East HartfordCT (1998 – 1999)
Title: Cost Configuration Analyst for PW6000 & PW8000 Controls/Externals engineering.

  • Inter-Program Team (IPT) to maintain Control System Configuration Database.
  • Gather, compile, and organize proper component costs and weight data.
  • Provide ability through database to track various Control System Configurations.

Results: Provide ability through data base, to perform engine trade studies, to determine value versus engine cost elements based on weights and metrics comprising engine parts.

Confidential, MeridenCT (1996-1998)
Title: Computer Programmer Analyst

  • Analyze business needs, design, develop, document, and implement software systems, in functional areas: Accounting, Capital Budgeting, Energy Assistance, Finance, and Customer Service. Work with and instruct end-user personnel.
  • Modify and support 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.
  • Evaluate legacy systems for Y2K compliance and make necessary changes to test environment utilizing MDI Y2000 Converter Tool.

Results: Manage Energy Assistance Program via through put of information gathered on the field and provide underprivileged families with energy assistance.


Confidential, BloomfieldCT (1994-1996)
Title: Information Resource Data Administration

  • Supported 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, MVS Data Dictionary as required.
  • Participated in technical initiatives. Improved and modified Standard Abbreviation program tools using PC REXX.
  • Audited and synchronized Data Dictionary to IBM MVS/DB2 Workbench.
  • Design and maintain data dictionary meta topics to support metrics analysis and reporting with IRIS View, Data Manager V7.1, and QMF/SQL.

Results: Provided consistency, standardization and reusability in support of corporate data share principals and objectives.

Confidential, WindsorCT (1987- 1984)
Title: Engineering Aid

  • Installed and maintained Boeing/Sikorsky "documentation generation tools" using Cadre Teamwork V4.1 and Document Preparation Interpreter (DPI), Computer Data Interchange Format (CDIF) and FrameMaker V3.1x in Unix Platform.
  • Interfaced with vendors to enhance support and provide training for Flight Systems and Software groups.
  • Software Configuration Management.
  • Use tools on DEC VAX\\VMS, use Digital Command Language (DCL) freeze and configure software.

Results: Provide problem resolution, database testing, software change control and integration into the production environment.

We'd love your feedback!