Data Warehouse/Programmer Analyst Resume Profile, MN - Hire IT People

Summary of Qualifications and Responsibilities

Demonstrated ability to effectively communicate with all levels of management and lead complete project life cycles, from initial planning to final testing and deployment
Conversion, implementation, testing and maintenance of various administrative and student information applications
Worked on all phases of System Development Life Cycle
Experienced in generating and maintaining program code used to process data
Creating aggregated data to meet specific reporting and web application needs
Extracting, Transforming and Loading data into various non-relational database tables using COBOL programs with embedded SQL on an AS400 platform
Creating stored procedures in Microsoft SQLServer for data manipulation
Expertise utilizing various BI tools such as Oracle's Hyperion Professional Suite and applications that performs 'Real-Time' ETL services such as Vision Solution's Double Take Share
Worked with AS400 System Administrator in installing and implementing a disaster recovery application
Create necessary technical document and flowchart to illustrate application design and functionality
Critical thinking and analytical skills
Team Player with strong verbal and written communication skills

Technical Skills

Operating Systems: IBM: iSeries V7r1,TSO/ISPF

Sun/Solaris: UNIX

Windows: 2000/XP/7/8

Microsoft SQLServer 2008 R2

Programming Languages: COBOL, SQL, JCL, FOCUS, WebFOCUS, Easytrieve, UNIX Shellscripting, Unix Editors vi, PICO , PL/SQL

Tools: SQL Server 2008 R2, iSeries Access for Windows,

Vision Solution's Double-Take Share,

Oracle's Hyperion Professional Suite, TOAD

Professional Experience

Confidential

Data Warehouse/Programmer Analyst

Creation and maintenance of DB2 tables, associated keys and indexes, lookup tables and various data views the makeup the Broward School's Data Warehouse and its usage among various District applications including Virtual Counselor, Pinnacle and BASIS Behavioral Academic Support Information System
Responsible for synching Data Warehouse with data entry/source system via Batch and 'Real-Time' processing
Creating and/or updating data in Microsoft SQLServer to be used in various web applications and AS400 environment
Assuring reliable and consistent availability of data tables and various web components used in accessing data tables
Worked with other programmers to implement new ERP SAP and update Data Warehouse with HRMS data
Oversee nightly cycle and ETL data processing
Responsible for archiving data on a yearly basis to maintain integrity and consistency
Loading various test scores and creating various file used for external use
Work with AS400 Systems Analyst to minimize system resources and vendor software installation
Collaborate with various members of the district to coordinate yearly 'ROLLOVER' process
Trained various employees in overall Data Warehouse methodology

Confidential

Senior Computer Programmer Analyst

Instrumental in system conversion of an IBM-Mainframe based system to UNIX-based system for Human Resource Department and various subsystems
Wrote programs to extract payroll files for various external companies and/or systems
Processed data files and reports for various university areas
Instrumental in implementation and conversion of DB2 based Owl Academic Student Information System O.A.S.I.S.
Functioned as Technical Analyst for FAU's Housing system and TERM-END Processing
Supported Client Menu screens for technical team and functional areas
Coordinated schedule for Batch and On-line processing for Housing transactions
Participated in Y2K conversion
Completed technical requests for various university departments

Confidential

Computer Programmer Analyst