Summary

• Sound knowledge in design, development and implementation of applications in client/server environment.
• Hands on experience using Cognos 8.2/3/4 BI (Frame work manager, Cognos connection, Report Studio, Query Studio) Cognos Planning 8.2(Analyst and Contributor)
• Sound knowledge and experience of different phases of software development life cycle (SDLC).
• Hands on experience administering, deploying and maintaining reports, using Cognos 8x BI.
• Proficient in using best practices to support the reporting activities. Adept in using performance tuning and optimization techniques such as load balancing, table weighing and partitioning. Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills. I am a quick learner and have a niche for technology.
• I have worked for different federal govt. agencies like TSA, USPTO, Marine Corp, IRS, Dept. of Justice. Veteran Affairs. Department of Navy, HCPS FL, GSA

EDUCATION

• Masters in Computer Science

TECHNICAL BACKGROUND

Business Intelligence
Cognos Tools: Cognos 8.2/3/4 BI (Frame work manager, Cognos connection, Report Studio, Query Studio, Analysis Studio), Cognos Planning8.2/3,4 Analyst, Contributor, Access Manager, Transformer 7.1, Power Play, Cognos TM1

Hardware & OS: HP-9000, UNIX, Xenix, IBM RS6000, HCL Horizon III, IBM PC, AIX 4.0, SCO UNIX 3.2, SCO Xenix 2.3.2, Alpha-MOS, DOS, Windows NT 4.0
Training by COGNOS: Cognos Planning Administrator, Frame Work Manager, Report Studio

CERTIFICATION (By PeopleSoft Inc.): PEOPLESOFT 8.0, PEOPLECODE, PEOPLETOOLS,
APPLICATIONDESIGNER, CRYSTALQUERY, SQR, SQL, PS/NVISION, DATAMOVER, DATAMANAGMENT TOOLS, WORKFLOW, Process Scheduler.

Professional Experience
Confidential (General Service Administration) Feb2012 – Cont.
Working on creating reports in Crystal and Cognos

Confidential Feb2012 – Feb2012
Work on modification of the reports.

Confidential Nov 2011 – Feb 2012
Worked on proposal for FBI and Veteran Affairs

Confidential. Sep 2011 to Nov2011.
Performed requirements gathering work for Cognos Report Conversion project. Currently these reports are developed in Business objects. Once the requirement gathering is complete we will start converting into Cognos 10. l have captured requirements for over 400 reports.

Confidential Cognos Developer/Administrator Jan 2011 to Sept 2011
The Department of Navy (DON) Financial Improvement Program (FIP) supports the DOD’s goal to achieve an unqualified audit opinion by asserting that the department is ready for audit. The FIP effort coordinates and administers numerous initiatives to improve financial management within the Department of the Navy (DON). The FIP has enabled DON to establish a plan and enact corrective actions with the goal of improving the quality, timeliness and accuracy of financial information. Additional objectives include providing information and training regarding financial management and improvements, A-123 controls and validation testing techniques to the greater DON financial community.

• Responsible for the development and maintain Department of Navy Cognos systems
• Responsible for gathering report requirements, analyze the requirement and make changes

according to the new requirements

• Responsible for development of Cognos reports for Department of Navy using Cognos 8,

Report Studio, and Query Studio

• Created Dashboards using Report Studio
• Developed List, Crosstab reports and charts
• Developed reports using Conditional Layouts and condition expression like String Variable

and Boolean Variable.

• Developed prompted reports using different prompts like Value Prompt, Date and Time

Prompt.

• Created queries using Join and Union
• Using Cognos Connection for deployment of packages, user security, setting up user groups
• Schedule daily, weekly and monthly reports in different formats and output version.
• Created Model and Package using Framework Manager
• Created calculated columns for different objects
• Configure Cognos configuration with IIS and SQL Database
• Activated single sign on
• Working on configuring Cognos connection
• Ability to conduct research into Cognos, database issues as products is required.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Experience working in a team-oriented, collaborative environment.
• Provided technical support and troubleshoot BI-related issues.
• Create and maintain documentation of operating procedures, application designs and

architecture

• Prepared technical design documents for new applications or features.
• Provided ad-hoc customer support in information and reporting services.
• Thorough understanding of project-based work structures, project lifecycle models
• Understanding of software development lifecycles and methodology.
• Ability to work independently, positively handle conflict, and work in a fast paced

environment.

• Understands project-based work structures, project lifecycle models, and the change

management processes
Confidential Sep210 – Oct2010.
Develop and deploy Fast Track Claims Processing System for the Department of Veterans Affairs (VA) within 105 days from contract award. The Fast Track Claims Processing System processes disability claims for the three newly added Agent Orange (AO) presumptive conditions (B-cell leukemia, Parkinson’s disease, and Ischemic heart disease) and has the potential to support disability claims for other presumptive conditions.

• Analyze software requirements and evaluate them for test planning.
• Update test requirements as system changes are approved for implementation.
• Assist with development and execution of automated and manual Test Cases.
• Performed assigned testing as per the Test Plan.
• Documented and reported all discovered defects with the software application.
• Executed regression tests.
• Collaborated with developers and users to optimize testing

Confidential June 09 – Feb10
Cognos Administrator/Developer

• Install and configure Cognos 8x
• Responsible for gathering report requirements, creating functional specifications and report
• Responsible for development of Cognos reports for TSA and Change Management using Cognos Report Studio and Fortress
• Created Power point presentation about an application to show senior management
• Clone Cognos and configure.
• Create Package using Framework Model.
• Support and maintain the current Cognos 8.x reporting system
• Assign different data source to allow user to run the report
• Activated Single sign on.
• Created Report Bursting
• Created calculated columns.
• Developed complex report to monitor the total number of bags processed per TSO
• Developed reports using Conditional Layouts and condition expression like String Variable and Boolean Variable.
• Developed Drill Through reports.
• Developed prompted reports using different prompts like Value Prompt, Date prompt.
• Created queries in report studio using Join and Union.
• Developed Report Views to organize reports in Cognos Connection
• Configure Cognos Connection
• Wrote queries and case statement to design report
• Test reports. Smoked test and Functional test.
• Trained the end users to effectively use the reporting tool to build and customize their ad-

hoc reports
Environment: Cognos 8.2/4BI (Framework manager, Cognos Connection portal, Query Studio, Report Studio) Oracle 10g, Toad, SQL.

Confidential Feb 09 – Apr 09
Cognos Report Developer

• Providing technical assistance/troubleshooting and support for Cognos reports.
• Provides report management and analysis.
• Customize reports according to customer specification
• Supplies information regarding assigned projects to other support groups and departments.
• Migrated reports from Test, to Dev to production using STAT
• Updated procedure for test and installation.
• Created SIT(System Integration test)
• Create Frame work manager Model in Contributor to create Report
• Help in writing UAT(User acceptance Test)
• Trained the end users to effectively use the reporting tool to build and customize their reports

Environment: Cognos 8.4BI/EP8.2 (Cognos Connection portal, Query Studio, Report Studio) Oracle 10g, Toad

Confidential Oct 08 – Dec. 08
Cognos Consultant

• Enhancing existing Cognos Planning (Contributor and Analyst) applications.
• Supporting existing production Cognos Planning (Contributor and Analyst).
• Test internal calculations and formatting.
• Complete macros, end-user interfaces and maintenance screens.
• Resolve development and support issues of moderate to high complexity or risk.
• Provide systems administration support for Cognos Planning and Cognos
• BI applications
• Set up user rights and security.
• Created D-Links, D-Cubes, Admin Links.
• Used synchronized with analyst Functionality.
• Published cube in Table Layout.
• Create Framework Manager Model in Contributor.
• GTP Applications.

Environment: Cognos EP 8.2 (Analyst, Contributor, Cognos Connection portal, Query Studio, Report Studio, Frame Work Manager) Oracle 10g, Toad, SQL

Confidential May 2008 – August 08
EDM Consultant

• Worked on an internal Deltek project as an EDM (Engagement Document Management) consultant. EDM is a tool which provides BearingPoint with a centralized way to manage, store, and retrieve projects documents. I been asked to create files C250s and 260s and folders to import files and create reports using Cognos tools. The following steps are taken to create the folders-
• Import C250
• Run the Proposal wizard
• Import C260s
• Link the C260 to the proposal folder
• Run the engagement wizard
• Run the project wizard
• Create report

Environment: Cognos 8.2 BI MR1 (Cognos Connection portal, Query Studio, Report Studio,) Oracle 10g, Toad, SQL

Confidential November 2007 – March 2008
Cognos Expert/Report developer
I worked as a COGNOS expert and Report Developer. I was asked to write reports that will be used by BearingPoint to help measure our success.

• Analyzed Business requirements from the analysts
• Customized Cognos Connection with appropriate reports and security measures
• Worked on Analysis Studio to develop reports
• Involved in Creating Query Prompts, Developing Prompt pages and Conditional variables
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in Designing models using Framework Manager and deployed packages to the Report studio
• Implemented Framework manager security for Data access, Object level access and Package access.
• Involved in migrating reports from one server to another using Migration Utilities.
• Developed List, cross tab, drill through, chart and reports which involved Prompts in Report Studio
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Transferred technical knowledge specific to Cognos tools
• Some of the reports I have created:
• Regular Hourly Pay Variance Analysis Report for US and CANADA
• Retro Pay Variance Analysis Report for US and CANADA
• Non Standard Pay Variance Analysis Report for USA and CANADA
• Overtime Variance Analysis Report for US and CANADA
• NSP Labor Location Tracking
• NSP Pay Allowance Listing Report
• NSP Hours and Cost for tracking

Environment: Cognos 8BI MR1 (Framework manager, Cognos Connection portal, Query Studio, Report Studio, Analysis Studio) Oracle 10g, Toad, SQL, PL/SQL

Confidential September 2007 – October 2007
Cognos Consultant
To improve federal agencies cumbersome and inflexible planning and budgeting process we created a tool called (POM) I worked on an internal development project. In May of 2008, the investment project that I worked on was awarded by COGNOS the “2007 Solution of the Year.” I worked as a technical subject matter expert, integrating different products together on a single platform. The solution will provide budgeting support for Defense Agencies, specifically around the Program Office Memorandum (POM) Process. I have completed the following technical activities:

• Successfully installed and configured Oracle 10g and Apache web server with Cognos Planning
• Install and configured Sun one directory for authentication purpose
• Install and configure Cognos Planning (Cognos Contributor, Cognos Analyst)
• Breakdown of POM(Program Objective Memorandum) budget solution using Cognos Planning
• Created application using Cognos Contributor Cognos Analyst
• Install and configure Cognos Go office
• Configured Access Manager

Environment: Cognos EP 8.1 (Framework manager, Analyst and Contributor, Access Manger) Oracle 10g, Toad, SQL

Confidential January 2007 – August 2007
Cognos Consultant
Worked on a COGNOS project at the United States Marine Corps. I have provided technical expertise in the installation, configuration, development and support of the COGNOS 8.2 environment. The environment for this implementation was the entire Cognos 8BI MR1 Suite, including Framework Manager, Cognos Connection, Query Studio, Report Studio and Analysis Studio, running against an Oracle 10g Database.

• Successfully installed, configured and maintaining the COGNOS reporting system. When issues arose, I trouble shoot the issue and resolved it.
• Implemented industry best practices to prevent issues from arising when possible.
• Designed and developed the Framework Manager Model. This model bridged the technical database structure with the Business View for report developers and power users of Query Studio. The Framework Manager Model also contained Filters and calculated items in the Business View. This Model was published to COGNOS Connection, the portal for COGNOS.
• Applied Role Based security to the COGNOS deployment through COGNOS Connection. This included creating the users/groups and then assigning them the proper security parameters.
• Developed reports in report studio using prompts, parameters, filters and conditional formatting
• Worked on Cognos8.2 framework manager to import metadata from multiple data sources and create and publish packages to Cognos 8 server.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Involved in Migrating metadata and reports from Cognos 8 to Cognos 8.2
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, create reports and conditional formatting to highlight the business needs.
• Worked in Scheduling and Deploying Reports.
• Production Support, which involves solving user problems.

Environment: Cognos 8BI MR1 (Framework manager, Cognos Connection portal, Query Studio, Report Studio, Analysis Studio) Oracle 10g, Toad, SQL

Confidential October 2006 – November 2006
Cognos Developer
I was on the Convergys project as a CONGOS administrator and developer. The environment for this implementation was the entire Cognos 8BI MR1 Suite, including Framework Manager, Cognos Connection, Query Studio, Report Studio and Analysis Studio, running against an Oracle 10g Database. The implementation also used COGNOS 7 for Power Play, used to build 3 dimensional data cubes. Specifically, he was responsible for the following:

• Assisted the data modeler in designing the data mart according to reporting business requirements
• Designed the model in Framework Manager. Created a Business View according to business requirements
• Created model query subjects, filters, calculated items in Business View
• Published package to Cognos8 Portal and this packaged is used in developing reports in Report studio
• Applied security to Cognos Implementation
• Developed reports in report studio using prompts, parameters, filters and conditional formatting
• According to business requirements, developed reports in Report Studio and Analysis Studio
• Deployed reports from development to production
• Trained end users to develop ad hoc reports in Analysis studio and Query Studio

Confidential June 2006 – Oct 2006
Cognos Developer
The project involved extraction of sales information from ERP system, providing timely and accurate production and sales reports to territory managers by streamlining the custom reporting process. It enabled the business users to quickly and easily analyze profitability of products, product types and uncover the effects of price, cost, volume, and product mix using the reports and the flexibility for ad-hoc queries.
Responsibilities

• Interacted with business users to identify key dimension and measures for business performance. Developed and Customized reports using Impromptu Reports.
• Created and maintained catalogs for group of reports in the project. Created Hot Files to be used as Lookup tables to prepare reports and reduce querying time. Formed joins and database definitions according to the requirements
• Created Prompts, set Filters. Assigned various types of securities like table securities, row securities and column security using Governor Settings.
• Created user profiles and user privileges. Customized data by adding calculations and summaries by querying different database tables.
• Created standard and Ad hoc reports using Cognos Impromptu tool. Created List Reports, Created Cubes using Power Play and Transformer for multidimensional reports.