SUMMARY

• Result oriented and pragmatic Application Architect with over Eleven (11+) years of experience on full life cycle, multimillion dollar projects in various models (including offshore, onsite models).
• Expertise in the development of enterprise architecture road maps and best practices and providing training to the users.
• Functional knowledge of Market Share Trends, Profit and Loss, Cash Visibility Metrics, Online Metrics, Cost Metrics, Service Delivery Metrics, Treatment Authorization, Case Management, Survey Results, Commercial Claims, Billing and Collections, Learning Management Solutions, Sales Force, Supply Chain.
• Expert on processing Statement Of Work (SOW), Project Risk Assessment (PRA), Productivity Analysis (PA), Project Management (PM), Application Outsourcing (AO) methodologies.

TECHNICAL COMPETENCIES:

Application Development Tools: Cognos Impromptu, Cognos Power Play, Cognos Transformer, Cognos Visualizer, Cognos Architect, Cognos Query, Access Manager, Impromptu Web Reports, Cognos Upfront, PowerPlay Enterprise Server, Cognos PPES Administrator, Cognos Impromptu Web Report Administrator, Cognos Visualizer Administrator, Cognos Deployment Manager, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos Connection, Content Store, Report net 1.1, Cognos Series 8.x,Cognos Series 10.x, Dynamic Cube Designer, Cognos Mobile, Informatica, SQL Loader, Business Objects, QlikView, Crystal Reports XI

Database / DB Tools: TOAD, SQL* Plus, SQL Navigator, Oracle 9i, 10G, 11G, SQL Server, MS Access, Teradata, DB2/400, VSAM, Netezza, SAP EDW

Desktop Tools: MS Office, MS Project, Abode Acrobat, Niku Workbench, MS Outlook, Lotus Notes

Hardware: IBM PC Compatibles, Mainframe, Midrange

Methodologies / Techniques: Six Sigma (DMAIC, DMADV)

Network Software: TCP/IP

Operating Systems: Windows (All Versions), UNIX

Programming Languages: SQL, PL/SQL, C

PROFESSIONAL EXPERIENCE

Confidential, Raritan, NJ

Sr. Cognos Admin & Developer

Responsibilities:

• Work directly with business customers to build Business Layer, Reports, dashboards with the COGNOSBI authoring suite (Framework Manager, Report Studio).
• Worked with Relational & Dimensional Database.
• Be responsible to work with Elims & Sample Manager team to understand project goals and requirements in order to quickly develop & deploy reports and analytics to different environments that enable better decision making.
• Worked with the Supply Chain channel in order to document the Requirements & design the reports.
• Requirements gathering and documenting directly from the business users.
• Analyzing the data based on the requirements and implementing the BI best practices.
• Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, cubes.
• Report Formatting by using conditional Formatting.
• Performance tuning FOR Report Prompts & Reports.
• Recommend consolidation of reports and data queries as needed.
• Prepare technical specification documentation and handoff to IT Manager. Assist in development and testing when needed for quick turnaround.
• Manage various projects as assigned by BI Management. Contribute to creation of project plans. Provide periodic updates on status of deliverables.
• Set up Data Level and Object Level Security in Framework Manager using macros.
• Cognos Installation & Configuration & Security Setting, User Access, etc.
• ManageCognosmetadata, Folder structure and utilizeCognos10.2 advanced features.
• Responsible for implementing best practices onCognosDashboards, Scorecards, Portal, report design, development and testing.
• Created Dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.
• Designed Active Reports for Janssen Supply Chain.
• Created Drill Through Reports & Master Detail Reports for Janssen Supply Chain.
• Developed various Standard Reports, Charts and Master Detail Reports using Report Studio.
• Created a custom prompt page by enabling system driven cascade options, dynamic dimension selection and conditional display of prompts.
• Created additional reports on an ad - hoc basis as requested by business users.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists using Cognos connection.
• Involved in deploying reports and packages from Development to UAT to Production environment.

Environment: Cognos 10.2, Components like DQM, Framework Manager, Report Studio, Query Studio, Analysis Studio, Oracle 11g, TOAD, PL/SQL, Sample Manager, and Crystal Reports XI

Confidential, Basking Ridge, NJ

Sr Cognos Developer/Administrator

Responsibilities:

• Work directly with business customers to build Business Layer, Portals, reports, dashboards with the COGNOSBI authoring suite (Framework Manager, Report Studio and Transformer).
• Worked with Relational & Dimensional Database.
• Be responsible to work with SFDC & SAP EDW team to understand project goals and requirements in order to quickly develop & deploy reports and analytics to different environments that enable better decision making.
• Worked with the Distribution channel in order to Automating the Weekly and monthly partner credential status changes from Sales Force.
• Requirements gathering and documenting directly from the business users.
• Analyzing the data based on the requirements and implementing the BI best practices.
• Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, cubes.
• Report Formatting by using conditional Formatting.
• Built Segmentation and DMR Model and published thru Framework Manager for HR Team.
• Designed Dynamic cubes for Sales compensation application.
• Performance tuning on cubes.
• Provide technical direction to Cognos Development team for migration from Cognos 8.4 to 10.2.1. Includes making improvements in the design of Framework Manager and Transformer models, and packages.
• Recommend consolidation of reports and data queries as needed.
• Analyze business requests for BI reports and data cubes.
• Prepare technical specification documentation and handoff to Development. Assist in development and testing when needed for quick turnaround.
• Manage various projects as assigned by BI Management. Contribute to creation of project plans. Provide periodic updates on status of deliverables.
• Install and configure IBM Cognos 10.2.1 software on servers (multiple environments).
• Set up Data Level and Object Level Security in Framework Manager using macros.
• ManageCognosmetadata, Folder structure and utilizeCognos10.2 advanced features.
• Responsible for implementing best practices onCognosDashboards, Scorecards, Portal, report design, development and testing.
• Monitoring the daily and weekly loads thru Informatica ETL tool (IOD).
• Writing & Modifying PL/SQL code for loading data and logical implementation for metadata model.
• Worked on Active reports in order to support the Distribution Channel for KPI.
• Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.
• Designed active reports for IPAD compatibility.
• Created Burst Reports in 8.4 based on groups of users &Preferences for our Asian, African and European partners.
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Developed various Management reports - MTD, QTD, YTD, last fiscal year, current fiscal year reports, and employee taxable. MTD, QTD, YTD, Clients, Costumers, sales, shops, Products etc. Developed Standard Reports, Charts and Master Detail Reports using Report Studio.
• Created Active reports with different data decks and data cards.
• Created a custom prompt page by enabling system driven cascade options, dynamic dimension selection and conditional display of prompts.
• Created Work Space Dashboards prototypes for the user to understand the new Cognos 10.2 features and functionalities.
• Created daily, weekly & monthly jobs in Cognos scheduler.
• Installation & Configuration of Cognos Application on all three environments(DEV, UAT & Production)
• Setting up Cognos services and Cognos security (Thru Access Manager).
• Created additional reports on an ad-hoc basis as requested by business users.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists using Cognos connection.
• Involved in Deploying reports, cubes and packages from Development to UAT to Production environment.

Environment:: Cognos 10.2,8.x,Components like DQM, Framework Manager, Report Studio, Query Studio, Analysis Studio, Teradata 13,Oracle 10g, TOAD, PL/SQL, Access Manager, SQL Developer, BO, SAP EDW, Informatica

Confidential - Orangeburg, NY

Sr Cognos Developer

Roles & Responsibilities:

• Developed DMR Framework model in order to bring the HR Hierarchy.
• Worked with Report net 1.1, 8.2, 8.3 & 8.4.
• Analyze the existing Data sources to the Packages and document them.
• Developing Drill down Reports to all areas in report studio.
• Functional Requirements Documentation and Test Cases.
• Gather and analyze the requirements of the users
• Analysis of data necessary to resolve issues uncovered relating to source data
• Participated in design and code walk-through with project team.
• Involved in Developing, testing and Production Support.
• Study the Current BI System - Framework Packages, Cognos 8 reports.
• Retired all the Cognos packages, reports and cubes from Report Net to Version 8.
• Proposed and Designed Cubes in 8.3.
• Create Cube Source package and published and built Cube for Dimensional reporting.
• Developed drill through reports based on Analysis cube reports.
• Create Folders, Filters, Calculations, Prompts, User Groups and User Classes.
• Maintain User sign on information and auto access privileges for data sources.
• Optimize the Cognos 8 reports performance.
• Create Analysis Reports thru metric studio.
• Established Union & Join relationships between Query Subjects to pull complex reports.
• Create Standard Reports in Report Studio.
• Developed CS & Sales Automated scorecard.
• Scheduling and delivering the automated reports to the users.
• Publish Framework Packages to Development Environment.
• Migrating reports thru different environments.
• Face to Face and online User Training for Adhoc Users to develop their own Adhoc reports in Report Studio & Query Studio.
• Implement Cognos Package Security.
• Troubleshoot and resolve functional issues.
• Define the Data sources in Cognos.ini file for usage of Iqd generated thru Framework.
• Generate SQL Scripts and Create Aggregate and Relation Tables on Toad.
• Defined object level security & Data level security.
• Installation and setting up Cognos configuration.
• Analyzing and creating indexes for Query optimization.
• Written Oracle functions to support Cognos reports in order to convert Data Types to see more characters in the report.

Environment: Oracle Client 11g,Toad, Cognos Series 8.4,Transformer, People soft, WINSCP, Teradata, UNIX, Windows

Confidential - New York, NY

Sr Cognos Developer

Roles & Responsibilities:

• Translates business needs into Report specifications
• Functional Requirements Documentation and Test Cases.
• Gather and analyze the requirements of the users
• Analysis of data necessary to resolve issues uncovered relating to source data
• Participated in design and code walk-through with project team.
• Study the Current BI System - Framework Packages, Cognos 8 reports.
• Proposed and Designed Dimensional Frame work Model.
• Create Folders, Filters, Calculations, Prompts, User Groups and User Classes.
• Maintain User sign on information and auto access privileges for data sources.
• Optimize the Cognos 8 reports performance.
• Defined, stored and maintained security information using Access manager.
• Develop Dimensional Framework model in conjunction with the Database Architects.
• Analyze the existing Data sources to the Packages and document them.
• Create a DMR Business view out of the query subjects for Query Studio Users.
• Establish Join relationships between the Query Subjects.
• Create Standard Reports in Report Studio.
• Create Dashboard Reports For Sales Team.
• Create the necessary Cognos 8 Reports and schedule them.
• Establish a New Join Strategy based on the new business requirements.
• Publish Framework Packages to Dev.
• Implement Package Security.
• Troubleshoot and resolve functional issues.
• Define the Datasources in Cognos.ini file for usage of Iqd generated thru Framework.
• Configuring The Web servers and the App Servers
• Installing the Content Store
• Generate SQL Scripts and Create Aggregate and Relation Tables on Toad.
• Creating User Classes in Access Manager and adding users to those user classes

Environment: Oracle Client 10g, Toad, Cognos Frame Work manager, Cognos Series 8.2, Metric Studio, Access Manager, Informatica

Confidential - Irvine, TX

Sr Cognos Developer

Roles & Responsibilities:

• Impact and Risk Analysis during Upgradation to Cognos series 8
• Training the users in creating ad-hoc reports after migrating from series 7 to 8.
• Translates business needs into Report specifications.
• Functional Requirements Documentation and Test Cases.
• Gather and analyze the requirements of the users
• Analysis of data necessary to resolve issues uncovered relating to source data
• Participated in design and code walk-through with project team.
• Study the Current BI System - Framework Packages, ReportNet reports
• Create Folders, Filters, Calculations, Prompts, Users Groups and User Classes.
• Maintain User sign on information and auto access privileges for data sources.
• Optimize the ReportNet reports performance.
• Defined, stored and maintained security information using Access manager.
• Develop Framework models in conjunction with the Database Architects.
• Analyze the existing Data sources to the Packages and document them.
• Create a Business view out of the query subjects for Query Studio Users.
• Establish Join relationships between the Query Subjects.
• Create Standard Reports in Report Studio.
• Create the necessary ReportNet Reports and schedule them.
• Create check point reports.
• Establish a New Join Strategy based on the new business requirements.
• Publish Framework Packages to Dev.
• Implement Package Security.
• Troubleshoot and resolve functional issues.
• Define the Datasources in Cognos.ini file for usage of Iqd generated thru Framework.
• Configuring The Web servers and the App Servers
• Installing the Content Store
• Creating User Classes in Access Manager and adding users to those user classes

Environment: Oracle9i, Cognos Transformer, Cognos PowerPlay, Cognos Frame Work manager, Cognos Series 8, Cognos Report Net .1.1 Access Manager, Informatica, Cronacle

Confidential

Cognos Developer/Analyst

Responsibilities:

• Maintain User sign on information and auto access privileges for data sources.
• Optimize the Impromptu report performance.
• Defined, stored and maintained security information using Access manager.
• Analyze the existing Data sources to the Catalog and document them.
• Study the Current BI System - Catalogs, Impromptu reports.
• Enhance the Catalog Structure in accordance to the new requirements.
• Troubleshoot and resolve functional issues to meet user requirements.
• Designing and developing approaches to acquire data from new sources
• Build OLAP cubes using Cognos Transformer, views using Power Play.
• Create the Calculations, conditions and prompts in catalogs.
• Analyze the Constraints, Dependencies and Assumptions involved in the Project.
• Translates business needs into program specifications, which are Critical to Quality.
• Prepare Impact associated documentation and logic flow charts applied to business
• Coordinate all communications with the Project Management team.
• Develop, document, manage, and coordinate all user acceptance testing.
• Monitor the Cube performance and modify the structure to enhance performance.
• Create and Define user classes and their privileges.
• Migrate the Cognos Application from the Development to Test Server.
• Publish the Visualizations, Cubes and Reports to the PPES.
• Configure the .ini files for faster cube load in Upfront and Customize the Upfront pages.
• Develop Framework models in conjunction with the Database Team.
• Create a Business view out of the query subjects for Query Studio Users
• Establish Join relationships between the Query Subjects.
• Create Standard Reports in Report Studio.
• Generated Externalized Query Subjects for usage as a source in Transformer Models.
• Provided Drilldown capability from Powercubes to Report Studio Reports.
• Publish Framework Packages to Dev, QA Servers.

Environment: Oracle8i, Cognos Impromptu, Cognos Transformer, Cognos PowerPlay, Cognos Visualizer, Cognos PPES Administrator, Cognos Impromptu Web Report Administrator, Cognos Visualizer Administrator, Cognos Deployment Manager, Cognos Frame Work manager, Cognos Report Net (Report Studio & Query Studio), Cognos Access Manager, Informatica, Redwood Cronacle.

Confidential

Cognos BI Functional Advisor

Responsibilities:

• Gather and analyze the requirements of the users.
• Analysis of data necessary to resolve issues uncovered relating to source data.
• Designed and developed approaches to acquire data from new sources.
• Created source to target definition.
• Enhance the Catalog Structure in accordance to the new requirements.
• Troubleshoot and resolve functional issues to meet user requirements.
• Establish and Define join strategy.
• Creation of business view of the Catalog folders.
• Create the Calculations, conditions and prompts in catalogs.
• Setting up appropriate user class and security
• Design of cubes, dimensions, measures, hierarchies, calculations, aggregations and rules.
• Enhanced the performance by client/database server balancing, and by altering table weights
• Involved in Integration of Cognos Upfront with other Web Applications.
• Creation of a variety of standard and analytical reports including multi-drillable, cross tabs.
• Develop Framework models in conjunction with the Database Team.
• Create a Business view out of the query subjects for Query Studio Users
• Establish Join relationships between the Query Subjects.
• Create Standard Reports in Report Studio

Environment: Oracle8i, Cognos Impromptu, Cognos Transformer, Cognos PowerPlay, Cognos Visualizer, Cognos PPES Administrator, Cognos Impromptu Web Report Administrator, Cognos Visualizer Administrator, Cognos Deployment Manager, Cognos Frame Work manager, Cognos Report Net (Report Studio & Query Studio), Cognos Access Manager, Informatica, Redwood Cronacle