NICHE TECHNOLOGISTS, INC.

Nationwide Business Intelligence Consulting & Staffing Services since 1993
P.O. Box 507
Revere, PA 18953-0507

(610) 847-2143 Email: dbarber@nichetech.com Web: www.nichetech.com

SAMPLE RESUME # 2

TRY OUR BI/OLAP SKILLS SEARCH ENGINE

Text Box: B.A. in Accounting, minor in IS. Cognos skills include Decision Stream, IWR, Access Manager and Cognos Query. 4 years 10 months demonstrated problem/analysis solving skills. 3+ years ETL experience. Oracle, SQL Server and MS access included in skills mix along with formal DBA training followed by DBA tasks/role. Substantial interaction with technical and non-technical staff. Good interpersonal skills. Enjoys challenge, listens well, actively seeks knowledge, effectively applies what he learns, self-starter, and creative problem-solver.
 

SOFTWARE

Cognos: PowerPlay Transformer, PowerPlay, Impromptu, Impromptu Web Reports (light experience), Access Manager, Architect, Enterprise Server, Upfront, Scheduler, Query (light)

SQL Server, Oracle, Oracle Applications General Ledger and Financial Statement Generator (FSG), Unix, Visual Basic, ASP, JavaScript, Microsoft Access, Crystal Reports Professional, Windows 95/98/2000/XP/NT

Microsoft Office, Visio, Visual InterDev, Visual Basic Script, HTML, and ADO

WORK EXPERIENCE

December 03 to present

Cognos Consultant

·          Extensively worked on understanding the business requirements and designing Cognos applications

·          Developed ETL scripts to extract and cleanse data from SQL databases for loading into Cognos

·          Created List, Sub and Cross-Tab reports using Impromptu and distributed Catalog to users for Ad-Hoc reporting and analysis

·          Created standard filters, calculation prompts, and conditions

·          Designed the architect model, developed the Cognos Query and PowerPlay packages for production and demonstrations

·          Published IWR reports and PowerPlay cubes on the portal using Cognos IWR report admin and PowerPlay Enterprise Server

·          Created dimension maps and multidimensional cubes using Impromptu’s Query Definition in PowerPlay Transformer

March 2001 to August 2003

Senior Cognos Business Analyst

·          Designed and implemented data cubes using Microsoft OLAP services, Cognos Impromptu, and PowerPlay to facilitate executive, management and end user reporting.

·          Created reports using Cognos and automated scripts to validate the integrity of the data based on end user needs.

·          Trained technical and non-technical users on the use of Cognos tools

·          Migrated different databases (Oracle and MS Access) to MS SQL Server database using Data Transformation Service tool (DTS)

·          Monitored data quality, resolving problem data issues, and ensuring timely updates

·          Provided Oracle back end programming including PL/SQL, Oracle Stored Procedure, data mining, data cleanup and data reporting.

·          Administered database security, backups, tuning, configuration, and performance (MS SQL 2000)

·          Responsible for Oracle’s FSG and supported accounting team in performing their daily tasks as they relate to the general ledger.

 

May 2000 to January 2001

Senior Developer/Database Administrator

·          Performed Database and Server administration including Production support, Logical and Physical Design, Performance Tuning, Monitoring space usage, System configuration, Creating devices, Adding logins/users, Dumps/Recovery, Back up, Task scheduling on SQL 6.5/7.0

·          Developed and maintained a Web based Video Streaming Application.  This application gives consumer the ability to purchase or to download and enjoy their favorite video clips via Web.  The site was also developed to allow various business alliances to be able to create customized banners for their sites.

·          Responsibilities included analysis, design, development, testing and maintenance of the system.  

October 1998 to May 2000

Programmer/Analyst

·          Responsible for the design, development, testing, implementation and maintenance of the Sales Order Tracking System.  The system was designed to allow sales personnel to view and electronically annotate reports that are currently delivered to them on paper.

·          Worked closely with the project’s DBA to design and implement Database Stored Procedures.

·          Utilized ADO and used Crystal Reports for report generation.

·          Defined initial client specifications, project planning, design, coding, and testing of client interface.

·          Developed and maintained Bonus Calculator.  The system was a subset of the Sales Order Tracking System. It calculated and kept track of the monthly bonuses paid out to sales personnel.

August 1997 to September 1998

Programmer Analyst

·          Utilized Visual Basic 4.0 and 5.0, MS Access 7.0, PDQ Comm 2.3 communications custom control.

·          Created logical flow, coded, tested and debugged Data Files Exchange System. The purpose of the system was to establish connection and transfer data files between Host and Remote Systems.

·          Designed the MS Access 7.0 host database: tables, queries.  Created stored procedures for the remote SQL Server 6.5 database (to export necessary data).

·          Participated in development of Inventory and Event Tracking Subsystem to keep track of the artworks, customers, and participating artists and maintain optimum level of stock.  Used Visual Basic 4.0 and 5.0, Crystal Reports Professional

EDUCATION

4-year degree