TECHNICAL SKILLS

Product Knowledge: ORACLE 11i, SQL Server 2008 R2, Deltek Time Collection 9.0.1, Deltek Costpoint 7.0.1, Cognos Performance Management Tools - Report Studio, Query Studio, Analysis Studio, Cognos Analysis for Microsoft Excel, Metric Studio, Cognos TM1, CASE Tools - ORACLE Developer, Rational Rose, Rational Unified Process, Platinum Erwin, Oracle Reports, Oracle Forms, Microsoft Visual Studio 6.0

Languages and Platforms: PL/SQL, Visual BASIC 6.0, Python 2.2, C/C++, Java

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

Costpoint Administrator

Responsibilities:

• Led the conversion upgrade of Costpoint from 6 to 7, Cognos from 8 to 10, and the implementation of Time & Expense 9 from JAMIS. Provided training and post conversion led the testing and acceptance process.
• Create and/or migrated 65 reports to Cognos 10. Implement new security to handle 300 new users and 10 groups. Led training in using Cognos tools (Report Studio, Query Studio)
• Led project to implement new budget solutions initially to Deltek Budget and Planning wif future consideration to moving to Cognos TM1. dis allowed us to move away from depending on excel spreadsheets during budgeting process and reducing the time required during the budget cycle.

Applications: Costpoint 9, Cognos Report Studio 10.2, Cognos Query Studio 10.2, Cognos Connection 10.2, Event Studio 10.2, Framework Manager 10, Analysis Studio 10.2, Metric Studio 10.2, Deltek Budget and Planning, SQL Server 2008 R2

Confidential, Herndon, VA

Cognos Developer

Responsibilities:

• Setup the Reporting structure and implement row level security for 500 users and 13 companies. Developed approximately 50 reports. Worked wif end - users to gather reporting requirements. Design and create ad hoc reports from those requirements.

Applications: Costpoint 5, Cognos Report Studio, Cognos Query Studio 10, Cognos Connection, Framework Manager, Analysis Studio, Oracle 10i

Confidential, Reston, VA

Senior Architect/Developer

Responsibilities:

• Cognos Architect - develop implementation plans and solutions to meet clients’ business requirements. Provide hardware advise and security solutions. Build complex application solutions utilizing Cognos tools. Support business intelligence using ETL OLAP tools. Create back-up and recovery plans.
• Cognos Developer - work wif end-users to gather reporting requirements. Design and create ad hoc reports from those requirements. Design and enhance Framework Modeling to create the custom business view for end-users. Create and load custom tables for tracking external budgets against actual metrics. Training users in creating ad hoc report studio and query studio reports. Document the report specifications and the designer’s notes.

Applications: Cognos Report Studio 8.3, Cognos Query Studio 8.3, Cognos Connection 8.3, Event Studio 8.3, Framework Manager 8.3, Analysis Studio 8.3, Cognos, Powerplay Transformer 8.3, Cognos Enterprise Planner 7.2, Contributor 7.2, Oracle 10i, SQL Server 2005

Confidential, Reston, VA

Financial System Analyst

Responsibilities:

• Cognos Developer - Led a team of three in the install and implementation of the move of the Budget process from Excel to Planner. Designed OLAP cubes using Cognos Transformer and deploy to the web using PowerPlay Enterprise Server. Automated the process for collecting financial information from two Costpoint databases and producing the required consolidated income statement reports. The new system reduces the data-gathering time from two weeks to thirty minutes after the period closes. Create OLAP models to use for the forecasting and budgeting process reducing the dependency on 46 organizational excel spreadsheets, each containing 20 tabs. Document desktop procedures and user manuals. Trained back-up administrators and users on the use of the new systems. Create scripts and links to move data between multiple applications and databases.
• Cognos Administrator - consolidated two web sites into one site reducing the resources necessary to maintain, implemented the use of Powerplay reports and cubes on the web to give users more flexibility, implemented backup and recovery procedures, implemented security using access manager, publish new and updated reports to the web, created batch jobs to update reports on a set schedule. Set-up monitoring system and audit reports to monitor application performance and user errors. Perform upgrades and patches to both server-side and client-side applications. Support trouble tickets.
• Report Writer - receive user requirements from the whole company community, define stakeholders, develop reports, review, log changes & publish. Create catalogs and reports to pull data from multiple sources such as Costpoint, Time Collection, and HRIS systems. Setup security and filters.
• Costpoint Administrator (back-up role) - Upgraded Costpoint from version 4.0 to 5.1. Upgraded Timecollection from 4.0 to Time & Expense 7.0, setup new employees, setup clear users, maintain org security, process server, maintain security structure, maintain user override rights, and update per diem rates.

Applications: Impromptu 7.3, IWR 7.3, Enterprise Planner 7.3, Powerplay 7.2, Contributor, Oracle 9i, Costpoint 5.1, Visual Basic Macros, SQL Plus, SQL Talk, MS Query

Confidential, Washington, DC

Database Manager

Responsibilities:

• Oversaw iMIS and Costpoint database administration responsibilities, including maintaining user accounts and passwords, SQL script writing, system configuration changes, and software upgrades. Ensured a stable database environment through the testing, installation and implementation of necessary software upgrades. Performed integration and system tests in a test environment of new scripts and software upgraded. Documented wifin a group library all software upgrades, tracked installation dates and times and tested evaluation. Created stored procedures, views, and indexes. Develop ad­-hoc reports for iMIS and Costpoint users, using both Crystal reports and Cognos Impromptu. Provided maintenance of the Costpoint databases and software including Deltek Time Collection web-based timesheets, and Cognos Impromptu Web Reporting Tools. Troubleshoot and resolve data problems, SQL errors and connectivity problems. Developed an Access application for human resources new employee information into multiply databases of new employees, generating and send e-mail notification to key departments and the Offer Letter to the new hires.

Applications: iMIS 10x, SQL Server 2000, Cognos Impromptu, Cognos IWR, Deltek Costpoint, Deltek Time Collection, Crystal Report, SQL Plus, SQL Talk, Access