Professional Summary:

• Over6+yearsof experience in IT Industry with experience inanalysis, design, testing, development, documentation and implementationofCognos applications.
• Experience in working withCognos 8.3/8.2/8.1toolsFramework manager,

Report studio, Query StudioandAnalysis Studio.

• Have worked on Framework Manager for modeling the packages in Cognos Report Net, Cognos 8.x and published to Cognos Connection.
• Excellent working knowledge ofCognos Series 7.x/6.x (CognosImpromptu,

CognosPower Play Transformer, CognosPower Play,CognosScheduler,
CognosAccess Manager, Upfront).

• Involved in a data migration process between different versions of Cognos like

Migration of reports from Impromptu Catalogs to Report net.

• Experience in installation and configuration of Cognos Report net Environment and Security.
• Involved in developing complex list reports, Crosstab reports, Dashboards with multiple columns, queries, caluculations and prompts.
• Experienced in training power users onQuery StudioinAd-hocreporting.
• Expertise inOLTP/OLAPSystem Study, Analysis and E-R modeling, developing database schemas (Star Schema and Snowflake Schema) used in relational, dimensional and multidimensional modeling.
• Excellent knowledge in developing applications using Oracle 8 /9 /10g, SQL Server 2000/2005,SSIS, Toad and Access Databases.
• Experienced in deployment of applications, providing assistance forUser Acceptance Testing and Implementation Support.
• Mentoredandtrainedusers for the successful execution of the project. Andtrained the power usersto build reports using Report Studio and Query Studio.
• InteractedwithCustomersforrequirement gatheringandeffective analysis.
• Experience in writingBusiness specification documents.
• Versatile Team Player with excellent communication skills, written and verbal, Problem-Solving skills, outstanding interpersonal skills and a demonstrated capability of working onmultiple projects concurrently.

Technical Skills:

Tools : Cognos 8.3/ 8.2/8.1: Cognos connection, Framework Manager,
Query studio, Report studio, Analysis Studio, Metric Studio,
Event Studio, Cognos Report Net MR1, MR2, 1.1/1.02(Query
Studio, Report Studio, Framework Manager) Cognos impromptu
Administrator 6.x/7.x, Power Play 6.x/7.x, Impromptu Web
Reports (IWR), Upfront and Power play Transformer.

RDBMS : SQL Server 2000/2005, SSIS, Oracle 9i
Tools : TOAD, Cognos SDK
Operating Systems : Windows 98/NT/2000/2003, UNIX, Linux
Languages : HTML, SQL, PL/SQL, C, C++
Software Packages : MS Office (Word, Power Point, Excel, Access)

Professional Experience:
Confidential,Irving, TX July ‘09 - Current
Confidential,is the consumer and commercial banking division of JPMorgan Chase. The bank was known as Chase Manhattan Bank until it acquired JPMorgan in 2000. Chase Manhattan Bank was formed by the merger of the Chase National Bank and the Bank of the Manhattan Company in 1955
Sr.Cognos Developer
Responsibilities:

• Interacted with business analyst to gather business requirements and designed functional and technical requirements documentation.
• Developed models in Framework Manager and deployed packages to the Cognos Connection
• Changed the appearance of the reports in Query Studio by reordering the report items, swapping rows and columns and by limiting the number of rows that should appear on a page
• Worked on creating and analyzing the complex reports like Cross tab, drill-thru reports.
• Page explorer, query explorer and variable explorer were used to manage the content of the reports.
• Created multiple page reports with page-break based on the first page of report using master-detail relationship.
• Bursting the reports in various formats, such as html, PDF, excel and sending via e-mail based on the sales area and different levels of administration
• Assisted in creating executive dashboard for management level reports using Report Studio.
• Used Cognos Connection to administer and scheduling reports to run at various intervals
• Formatted data to analyze in drill mode and slice & dice mode.
• Created scorecards and added metrics to it using Metrics Manager.
• Migrated the reports using Server Integration Services (SSIS).
• Worked with user profiles to ensure security by restricting user access to data based on the individual user.
• Used Cognos SDK to validate report schemas
• Involved in unit testing to validate the reports.
• Prepared user manuals and provide technical support and training to end users.
• Involved in conducting training sessions and demonstration of Cognos tools to the end users

Confidential,Woodbridge, VA March ‘08– May‘09
Description: Confidential,is a global leader in medical imaging, healthcare services and information technology. Its offerings include networking and productivity tools, clinical information systems, patient monitoring systems, surgery and vascular imaging, conventional and digital X-ray and a full line of clinical and business services. For more than 100 years, health-care providers worldwide have relied on GE Medical Systems for high quality medical technology and productivity solutions.

Cognos Developer
Responsibilities:

• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions
• Published packages in Framework Manager to the Report Studio.
• Standard reports were created and performed various calculations on Reports using Report studio.
• Ad-hoc reports and templates were created using Query Studio
• Burst the reports and setup the distribution of sub list reports to various people with in the Client
• Prompt pages were developed based on the built framework models to select data in specific groups.
• Filtered the reports based on various conditions and prompts to meet the user requirement.
• Created reports of multiple report pages and prompt pages.
• Applied formatting to the data to make it appear as number, text & percentage.
• Performed grouping, sorting and summed up the values to various levels.
• Implemented the conditional formatting in the reports and enabled the multi-lingual feature.
• Developed Standard Reports, Drill Through Reports, Master-Detail Reports.
• Presented the critical data in a single short manner using dashboard reports.
• Created Packages through SSIS which moves data from one data source to other data source
• Designed multidimensional models using Transformer.
• Test data using Cognos reports and validate business processes.
• Created user groups and roles in Cognos Connection and applied data level and group level security for various entries.
• Responsible for working with Business analysts to write functional development documents and other minor development documents.
• Writing technical solutions documents and working with offshore development team to implement the requirements

Environment: Cognos 8/8.1/8.2 (Framework Manager, Report Studio and Query Studio), Oracle, SQL, SSIS, Windows 2003.
Confidential,NJ Feb ‘07 – Jan ‘08
Confidential,is one of the leading loss adjusting and claims management companies. Confidential,has built a data warehouse, to use for reporting and analysis of the claims data, intended for their customers to identify the high risk policies, minimize the number of claims by providing the most common causes of the claims.
Cognos Developer
Responsibilities:

• Worked on Cognos8 framework manager to import metadata from multiple data sources and to create subject oriented Business models, create and publish packages to Cognos 8 server.
• Mentored and trained team on Framework Manager, “Report Studio” and “Query Studio” tools.
• Customized data by adding filters at both the Framework level and Report level.
• Writing complex Cognos8 Report Studio reports, as well as the unit and system integration testing of those reports.
• Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports.
• Created various reports using drill through, cascaded prompts, conditional formatting and master detail relationship.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Maintaining Cognos 8 Report Studio server in development environment and migrating reports from development to test environment.
• Created Dashboards to present critical company data in a single report.
• Implementing data level security according to various user classes.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Set security for individual reports in Cognos Connection.
• Involved in setting up Groups/Roles to secure the Models and packages.
• Modifying packages and publishing them to the development server.
• Modifying Business view with calculations filters to reflect business rules.
• Working closely with ETL developers in building data marts for the cubes as per the requirements.
• Collecting user requirements and worked accordingly to the reporting requirements.

Environment: Cognos Report Net, Framework Manager, Report Studio, Query Studio, Teradata, XML, Oracle, SQL Scheduler and Windows NT/2000.

Confidential,Orlando, FL Oct ‘05–Dec ‘06

Description: Confidential,retailer stores are fashion conscious, youth oriented stores who develops their own brand of clothing. They develop quality clothing that is in style and is reasonably priced. The scope of the project was to generate reports for users in various departments that include Merchandizing, Planning, Sourcing, Allocation and documenting the progress and analysis according to established IT standards.

Cognos/Report Net Developer
Responsibilities:

• Collecting user requirements and worked accordingly to the reporting requirements
• Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention
• Developed all standard Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio and Query studio
• Created Query Prompts, calculations, Conditions & Filters, Prompt Pages using Report Studio
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used subsets to write union/subtract queries in Report Studio
• Maintaining Cognos Report Studio server in development environment and migrating reports from development to test environment.
• Created various Drill through reports from report to report
• Experience in developing reports, dashboards using Cognos Connection.
• Modifying packages and publishing them to the development server.
• Supported Business Users in generating Adhoc Reports using Query Studio.
• Modified Reports as per the requests, Bursted Reports and generated output basing on the requested format from the end users.
• Created Impromptu Web Reports and published them on the web server and later on Upfront.
• Generated Power play reports with drill down, slicing and dicing, sorting, and ranking features
• Tested existing reports for accuracy and performance.
• Trained End Users on how to use Cognos Tool.

Environment: Cognos Report Net 1.1, Report Studio, Query Studio, Framework Manager, Oracle 9i, SQL Server, MS-access, MS-Excel.

Confidential,Cleveland, Ohio Sep‘04 – Aug ‘05

Description: Confidential,is the largest pharmaceuticals company in the world with its head quarters in Indiana. Lilly is involved in various clinical studies around the world. Being a part of global data availability module was involved in design, development and implementation. Lilly is consistently ranked as one of the best companies in the world to work for, and generations of Lilly employees have sustained a culture that values excellence, integrity, and respect for people.

Report Net Developer

Responsibilities:

• Interacted with the users for the requirement gathering.
• Created various report types like simple report, cross tab, sub report and drill through that cover the entire range of enterprise reporting requirements and distributed to users.
• Created New Jobs using Cognos Connection.
• Provided drill-through to get the detailed information from master to detailed report.
• Configured the sessions to handle the updates to preserve the existing records.
• Involved in formulation of joins strategy, query optimization and weighing the tables.
• Time dimension was created using date wizard as per the requirement.
• Created standard and the Ad hoc reports for the business analysts.
• Distributing reports by email, print and bursting.
• Migrated Impromptu Catalogs and Reports to the Report Net environment.
• Designed catalogs and defined User Classes, Security and Privileges.
• Involved in creating Test plans, Unit testing and UAT of the Report net reports.
• Scheduled Impromptu and Power Play reports to run on a monthly, weekly, and daily basis using Cognos Scheduler
• Gained a working knowledge on up-gradation and migration form MS Excel sheets, and Business Objects to Cognos.
• Used SQL to analyze Queries.

Environment: Cognos Report Net (Framework Manager, Query Studio, Report Studio), Impromptu, Power Play and Oracle.

Education:

• B.Tech Computer Science Engineering