Wana Maiwand
[Send email using form at bottom]
[Send email to request phone number] 01.6083
Cognos Developer
With over 9 years of relevant computer experience I am a proven applications
developer, programmer/analyst and report designer. In addition to my strong
technical skills, I am organized, efficient and relate well to users. I work
effectively on my own or with a team to produce results.
Core Competencies
" Cognos 8
" Cognos Impromptu
" Cognos ReportNet
" Cognos PowerPlay
" Visual Basic Programming
" Access VBA Programming
" Crystal Reports
" Macro Developer
" Excel VBA Programming
" Networking & System Security
Professional Experiences:
TechLaw, Inc.
Nov. 1998 - Present (Part-time)
Accounting Programmer using Cognos Impromptu, Cognos PowerPlay, SQL, Access VBA,
Writing Macros, and Excel VBA.
In order to provide critical information like daily revenue, total sales, goals,
information on HR and new plans. TechLaw has developed Business Intelligence
System based on Cognos suite of products. The implementation is scheduled in many
parts that involve design, development, training and implementation. Job profile
involves working on Cognos Suit of products (Impromptu & Powerplay) as an
administrator. Specific tasks include developing the most complicated reports
based on government contracts.
Roles and Responsibilities as a Cognos Developer:
" Creating many reports in Cognos impromptu by Developing Catalogs, Hotfiles,
and Macros
" Creation of standard filters, calculations, prompts and conditions in
catalog.
" Created List Reports and Cross Tab Reports and Drill Through reports.
" Created reports on multiple databases, using Costpoint, Deltek Time & Expense,
DB4, and Excel data.
" Created Cubes and drill through views using Transformer and Cognos Powerplay.
" Responsible for designing and developing the sales reporting application.
" Extensively worked on understanding the business requirements and Involved in
performance tuning for Impromptu Reports.
" Upgraded Impromptu (Client) reports from Version 5 to Impromptu 7+.
" Coordinating in training sessions and demonstration of Cognos tools to
End-users.
" Assisting users in troubleshooting their reports.
" Familiar with data structure of Costpoint accounting system and Deltek Time &
Expense systems.
Design, evaluate, and implement database applications to accommodate a variety
of user needs.
Created two major Applications for users to download, manipulate, and create
professional looking reports using Visual Basic and Access VBA. Both applications
have been running successfully for the past 6 years. . (Telecommute)
US Capitol Hill Police Department
Jun 2007 - Sep 2007
As a Business Intelligence Specialist for a large federal law enforcement
agency, I was working directly with senior users and was responsible for the
definition and delivery of reporting solutions across the enterprise over the
web.
Responsibilities:
" Administer and support all reporting tools to provide self-service reporting
solutions and capabilities to end users.
" Create medium to high complex reports using Cognos Report Studio.
" Create and test more complex reports in Cognos 8 test environment.
" Full detailed documentation of the entire Cognos production system.
" Design data model and integrate/implement new data sources following design
standards and proven best practices.
" Provide quality service and support to users adopting self-service reporting
environment.
" Develop and administer Ad-hoc queries and production reports.
" Changes and creating SQL statements and Stored Procedure models using Query
Analyzer.
I have been able to create technical and non technical detailed documentation
for the entire Cognos portal. Applied security procedures to the reports based on
the current Human Resources department hierarchy. The system was ready and tested
to migrate to Cognos 8 but because of budget short fall the process was
postponed.
Customer Value Partners, Inc. Senior Cognos Developer
Oct. 2005 - Jan. 2007
Design, develop, test, and implement CMS Data Warehouse Cubes and reports for
Customer Value Partners (CVP) which is a small business partner to support Cognos
development efforts for Pearson Government Solutions (PGS).The project evolves
support of the 800-Medicare Cognos Software Data Warehouse Implementation
program. The focus of this effort is to improve the developing solutions and
operation of the 800-Medicare Data Warehouse. Roles and responsibilities as
senior Cognos Developer in PGS are as follows:
" Participated in the design, development, and implementation of new reports
using Cognos ReportNet as required by CMS
" Created high level and as required detailed design documents with supporting
implementation test plans in accordance with PGS's established CMM Level 3
standards and processes.
" Created and participated in system test execution and feedback process
" Attended weekly status meetings via conference call.
" Assisted in the determination of project schedules and provide tasks status
updates on a weekly basis
" Provided performance and system tuning recommendations using ReportNet and
PL/SQL
" Prepared estimates for assigned tasks.
" Participated in requirements, design, and code peer reviews.
" Wrote and executed unit test cases.
" Participated in group improvement activities and initiatives to improve
quality
" Prepared, wrote, reviewed and maintained effective system documentation.
PEC Solutions, Inc. (Nortel Government Solutions)
Jun. 2004 - Jan. 2005
Senior Computer Software/Integration Analyst. I was engaged by PEC to provide
expert analysis, application development and testing to PEC in accordance with
the Statement of Work.
Roles and Responsibilities as a Senior Computer Software/Integration
Consultant:
" Review functional specification documents; develop and unit test applications
created using the Cognos Impromptu software development tool in accordance with
report development standards and the functional specification; complete unit
testing validation checklist worksheet and create and/or update technical
specifications upon completion of application unit testing.
" Perform peer reviews of report applications developed by report development
team members as assigned by the PEC project manager.
" Create ad hoc reports to validate the accuracy of the data. (Telecommute)
The Rosenfeld Attorney Network
May. 1998 - Oct. 1998
Programming in Visual Basic, Access, SQL, and PC Troubleshooting, storing data,
Crystal Reports.
Created three different Applications to support the individual needs of stuffs.
Each program was automated to download data, manipulate it, and print reports at
a certain timetable.
Alzheimer's Association Hampton Roads Chapter
Jul. 1997 - Jan. 1998
System Administrator
Designed Access databases to fit the need of each staff member.
Created reports for Major Fundraising events in Crystal Reports.
Trained Stuff on use of all Applications, and created written training
materials.
Troubleshooting on all office computers and NT Server (Intern)
Eastern Virginia Medical School
Oct. 1996 - Jul 1997
Database Management Helper
Assisted editorial assistant of Journal of Gerontology: Medical Sciences for
Designing, mail Merge, and Operating Access Programs. (Intern)
Education And Credentials
Cognos 8 BI Authoring & Modeling FastTrack September 2006
GCS Premier ™ Dataport August 2005
Cognos S7-V3 PowerPlay Transformer OLAP Modeling March 23-25, 2005
Impromptu Administrator Certificates 2000 - 2001
Impromptu Basic Functionality (formerly CP Reports Basics)
Impromptu Intermediate Functionality
Impromptu Administrator Functionality
Associates Degree in Programming and Networking
ECPI College of Technology, Virginia Beach, VA
1996 - 1998 degree received with Honors
References : Furnished Upon Request.
US Citizen.
|
