MicroStrategy Developer Resume

Summary:

9 years experience in Data Warehouse and Business Intelligence applications development, maintenance and support. Specializing in Microstrategy, Cognos, Datastage, Unix , Oracle, DB2, COBOL

Skillset :

Microstratgey 9, 8.1, Cognos 8 Report Studio, Query Studio, Ascential Datastage 7.5.2, Oracle 9i, PL/SQL, Crystal Reports 8.0, TOAD, Unix Shell Scripting, Quest Central DB2, VB6/VB5, VBA, VBScript, SQLServer

Experience :

Dec 2009 - Present, Confidential,Los Angeles, CA

MicroStrategy Developer
Short term contract position creating several Microstrategy sales trends, earnings and distribution reports from existing version 8 to new version 9. Includes level metrics, Intelligent Cubes, Web docs and graphs.
Feb 2001 - Dec 2009, Confidential,CA
Application Technical Designer

Developed and maintained Ascential Datastage ETL applications.
Developed and maintained Oracle 9i procedures, functions, views, tables, sql scripts.
Developed and maintained enterprise wide reports in Microstrategy and Cognos.
Developed Microstrategy Consolidations, Hierarchies, Attributes, Metrics, Prompts, Filters, Question Obects, Datamarts
Developed Microstrategy Report Services, Dashboards, Narrowcast Services, Command Manager and Object Manager.
Developed and maintained MSAccess and Excel VBA, VBScript programs.
Crystal Report development and maintenance support for daily, weekly and monthly scheduled reports.
Ceated data models and table structures for various datamarts.
24/7/365 production support Unix and Datastage jobs with Oracle and DB2 data sources.
Reverse engineered Adjuster Caseload Tracking COBOL II program to Oracle and Microstrategy.
Developed Proc and COBOL II program to ‘scrape’ print records and FTP step to Unix servers for a client/server reporting system.
Conducted and participated in user requirements, data gathering requirements and technical requirements specifications creation for multiple maintenance releases throughout the year.
Followed SOX requirements in SDLC for development, testing and migration procedures.

Aug 2000-Dec 2000, Confidential,Santa Monica, CA
· VB6 Used Report Writer for Ad Hoc reports
· Created GUI interface to DB2 mainframe database.

Mar 2000-Aug 2000, Confidential,Pasadena, CA
· VB6 Development and support for corporate payroll, labor and expense reports
and files maintenance. Maintenance support for Lawson HR system.

May 1999-Jan 2000, Contract, Confidential,San Marino, CA

VB6 Developed credit card account information process using SQL Server 7. Produced account listing reports in HTML format and account activity reports.
Feb 1997-April 1999, Consultant, Confidential,Riverside, CA
Confidential,Irwindale, CA

IBM Mainframe Project Lead

Project lead in Y2K of 3 mainframe programmers, 2 business analysts during analyses, modification and testing phases. Provided time and completion date estimates of 3 batch and 1 CICS online subsystem in the Consumer Loans Dept.
Provided maintenance support for the MSP home mortgage system, developed and modified COBOL II programs to fix VSAM transaction files used in daily batch updating of the master file.
Project coordinator for conversion of the checking guarantee mainframe sub-system from Coast Federal Savings to Home Savings.
Confidential,Long Beach, CA

Lotus Notes / Foxpro Developer

Developed a Lotus Notes 4.6 mobile application that published technical articles of electronic products and contracts downloaded to laptops of District Sales Managers and Sales Representatives

Education:

A.A.Degree in Business Data Processing

Certifications

Microstrategy 8 -
Platform Administrator
Project Designer
Report Developer

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship