We provide IT Staff Augmentation Services!

Senior Systems Analyst Resume Profile

2.00/5 (Submit Your Rating)

CA

Hire Now

Position Desired

Senior Systems Analyst / Systems Analyst / Business Systems Analyst

Software Methodologies, Languages, Tools in Years

  • Systems Analysis 31
  • Oracle 15
  • SQL 20
  • Data Modeling 11
  • Ralph Kimball Methodology 9
  • Project Lead 6
  • UNIX 8
  • Erwin 4
  • MS SQL Server 2
  • Java 2
  • Business Objects 2
  • MS Office: Excel 10 , WORD, PowerPoint 2 , Outlook
  • COBOL 20

Professional Experience

Confidential

Systems Analyst

  • Created two new Data Marts and developed and programmed the ETL procedures.
  • Designed and developed a Claims Pipeline application that collected and organized data from the Data Warehouse and loaded it into tables that fed the company's first Dashboard.
  • Principal analyst and architect on project to submit data to the Federal Government's ERRP program Early Retiree Reimbursement Program . Resulted in largest reimbursement given to any Entertainment health care company.
  • Analyst and Developer on several other projects connected with the Data Warehouse.

Technology: Oracle 9i, 10g, 11g , PL/SQL, SQL Loader, SQL Navigator, Erwin, UNIX, Excel, Business Objects, Dimensional Modeling, Use Cases

Confidential

Business Systems Analyst, Data Modeler

  • Created a new data model for the Vendor Services department Credit Reporting, Title Insurance, Flood Insurance .
  • Maintained several subject areas of large Mortgage data model.
  • Technology: Erwin, Oracle 8i, TOAD, UNIX, 3NF Modeling

Confidential

Senior Systems Analyst, Data Warehouse Architect

  • Lead architect on company's first Data Warehouse
  • Requirements gathering from all departments all Mortgage-related departments, Accounting, Human Resources.
  • Preparation of Requirements documents
  • ETL development and data cleansing
  • Technology: Kimball Methodology, Dimensional Modeling, MS SQL Server, MS Transact-SQL

Confidential

Systems Analyst, Project Lead, Quality Assurance

  • Analysis and design of a QA Testing platform for the entire IT Division. Requirements gathering from all IT departments including JAD sessions.
  • Led team implementing the solution.
  • Prepared requirements documents and PowerPoint presentations for management.

Technology: VAX COBOL, VMS, PowerPoint

Confidential

Systems Analyst, Data Architect, Data Modeler

  • Learned the Java Language and Platform
  • Data Architect on several medium-sized Java projects
  • Technology: Java 2, DB2, Use Cases, Agile Development, RUP

Confidential

Systems Analyst, ETL Developer, Data Warehouse

  • Design and coding of data integration programs.
  • Project lead on Testing project for new Actuarial application. Wrote and executed test scripts, monitored defects, led team of four.
  • Systems Analyst on HEDIS reporting project.
  • Technology: VAX COBOL, Oracle RDB, VMS

Confidential

Senior Systems Analyst, Project Lead, Developer, Data Warehouse

  • Architect of a control layer on top of ETL system feeding the Data Warehouse. Analyzed problem, designed solution, led development project team, led full QA, led cutover to new system, provided full documentation, trained DW support team. Production support and maintenance for the ETL system thereafter.
  • Analyst and developer on new system for the Final Collections department.
  • Analyst and developer on scheduling system for all company batch processes.
  • Analyst and developer on end-to-end bill printing system for two European subsidiaries Telecel in Portugal and Belgacom in Belgium .

Technology: Oracle 6 and 7, SQL Loader, COBOL, VAX VMS, VAX DCL, UNIX

Confidential

Senior Systems Analyst

Architect of new full release of all Financial and Distribution Applications, using Oracle V.5

Confidential

Senior Systems Analyst

Analysis and Design of new release of all Financial and Distribution Applications. Complete analysis and design of two new applications Purchase Order and Project Job Costing.

Confidential

COBOL programmer, Technical Support Rep, Vice President of Support

Packaged Financial and Distribution Applications General Ledger, Accounts Receivable, Accounts Payable, Payroll, Inventory, Order Processing, Sales Analysis

Confidential

IT Technical Support for Laboratory Scientists and Engineers

Confidential

Mathematics Instructor

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship