Summary

7 years of expertise in Information systems design and development as a result driven professional. Have extensive experience in Analysis, Design, Development and Implementation of Data Warehouse and Business Intelligence solutions for industries from different business domains (Healthcare, Pharmaceutical, Finance, Entertainment, Insurance and Manufacturing).

• Have Over 7 years expertise in Cognos 8.4 Suite of products for Relational and Multidimensional Modeling/ Reporting (Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio, GO Dashboards, Cognos Analysis for Excel (CAFÉ))
• Specialist in Developing OLAP Cubes reporting applications using Powerplay, Transformer 8 and Cognos TM1 9.4.
• Expert in creating information solutions using Cognos Enterprise Series 7 tools (Transformer, Impromptu Web Reports, Upfront, Powerplay Enterprise Server (PPES), Access Manager)
• Involved in Migrating Reports from Cognos EP Series 7.3 to Cognos 8 and Cognos 8.1 to 8.4.
• Installed and configured Cognos components for various clients on distributed environment.
• Worked on all phases of life cycle, including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Lead Projects and Teams for delivering Project Milestones, Prioritization and Implementation.
• Liaise with developers, Stakeholders, business analysts and users in application design and document reviews.
• Have acted as a SME with Business Users and have mapped business requirements to technical specifications for developing Technical Requirement Documentation.
• Good knowledge on SCRUM methodology for Projectplanning and control of post-production activities.
• Played a critical role in the design, development and implementation of course curricula.
• Proven ability to build strong relationshipswith clients team members, functional counterparts, vendors and related business partners.

Certifications

• Cognos ReportNet Product Professional- Reporting Track
• Cognos ReportNet Product Professional- Modeling Track
• Cognos ReportNet Product Professional- Administration Track
• Cognos PowerPlay Product Professional
• Cognos Certified in ReportNet 1.0
• Cognos Certified in Impromptu
• Cognos Certified in PowerPlay
• Cognos Certified BI Author

Education

MS in Electrical Engineering

B.E. in Electronics Engineering

Confidential, Bala Cynwyd, PA October 09 - Current
Cognos Consultant

Confidential, is a leading Insurance Company that designs, markets, and underwrites Commercial Property & Casualty and Management & Professional Liability insurance products.
Responsibilities:

• SME to Junior Cognos Developers by overseeing the application development process, including design, maintenance and test tasks to drive successful implementations.
• Maintained a detailed production schedule that includes time estimates for each task, check points, deliverables and reviews to be included in the overall project plan.
• Accountable for leading the development and unit testing according to SDLC standards for IT Business Intelligence systems and applications.
• Participated in project planning sessions with IT Development Services team members to analyze business and technology requirements and outline the proposed technology solution.
• Prioritized and managed development and implementation of enhancements and changes.
• Determined approach and lead design, code, integration, performance tuning and testing review sessions.
• Served as a project manager for small and low complexity projects that do not fall under the jurisdiction of PMO.
• Participated in code reviews and ensured that all solutions are aligned to pre-defined architectural specifications.
• Drive process improvements to ensure quality and efficiency in the development operation by through consistent adherence to SDLC, code, and release management processes.

Project Work
Confidential

• Develop Cognos Dashboard using Go Dashboard and Cognos Portal for CRM solution Salesforce.com for Corporate Underwriting Dept
• Design Salesforce.com Data Model in Framework Manager
• Design Table Structure to create a Feasible Data Mart from the Salesforce.com UI.
• Coordinate with Offshore Team for customized Salesforce.com UI Development

Alphabet Houses/ Sales Trends:

• Analyze Design Document for Alphabet House group of Agencies
• Recommend Cognos Tool for Implementing the Project
• Provide Table Design Structure to ETL Team for Cognos Implementation
• Design Data Model using Framework Manager to encapsulate the different levels of aggregation
• Develop 8 Reports in Report Studio using Bubble charts, Conditional Blocks, Drill Through and JavaScript

Sales and Marketing Dashboard:

• Recommend Cognos Tool for Implementing the Project
• Develop Sales and Marketing Dashboard using Cognos Report Studio and Cognos Portal

IT Performance Dashboard:

• Led the Management By Objectives (MBO Tracking) Performance Management Project.
• Design Data Model combining Relational and Dimensional Structure using Cognos Framework Manager 8.4
• Design IT Performance Dashboard for CIO and COO of the Company.
• Created SSIS Package for loading Confidential Financial CAPEX/ OPEX data into SQL Server database.
• Provide Status Reports to CIO, VP and Stakeholders and provide Cognos Solutions for Improvisations.
• Liase with ETL Team to develop a Cognos feasible Datamart and maintain Technical Specification Documentation.
• Provide Operational Support to the Project by Troubleshooting Bug Fixes, accommodating enhancements, track ad-hoc requests by stakeholders.

Triangle Builder:

• Analyze the Visual Basic Application Concept of Loss Triangle and create documentation for the AS-IS state and Logic.
• Provide Solutions for Cognos UI replacement and an improvisation from the existing application.
• Designing the Strategy for the Project Implementation and assist in leading the effort.
• Designed and Developed the Cognos Framework Manager Model for implementing the Concept of the Loss Triangle.

HR Dashboard:

• Analyzed Business Requirements, created Technical Specification Documents and mapped functional requirements to database.
• Created SSIS Package for loading data into SQL Server Tables.
• Cognos Administration Activities including data source creation, deploying packages, security setup for Active Directory, Defining User Groups and Access Levels.
• Mapped the Attributes and Measures into TM1 Turbo Integrator 9.4 for creating TM1 HR Dashboard Cube.

Oden Subscription:

• Designed Relational Framework Manager Model with Subscription Lists and Policies that have expired, on hold and payments due.
• Bursting Schedule setup for Oden Reports.
• Provide Production Support after Project was Operational.

Actuary - Detailed Experience:

• Analyze the AS-IS Reporting Functionality of Detailed Experience for Actuarial Dept.
• Provide Architecture Solution for replacing the Reporting with Cognos Suite of Products using Best Practices in Framework Manager Modeling.
• Develop a Prototype for Stakeholder's Review and Delegate to Developers for further development.

Underwriting - LCA Vendor:

• Liaise with BA for understanding Functional Requirements of Labor Cost Analysis of Vendors for Underwriting Department.
• Design Architecture Solution with Cognos Recommended Best Practices in Data Modeling.

Environment: Go Dashboard, Cognos 8.4, (Report Studio, Query Studio, Analysis Studio, Framework Manager, Dashboards) Cognos TM1 9.4, SQL Server 2005, 2008 and SSIS, Salesforce.com, Cognos 10.

Confidential, Gaithersburg, MD June 09 - Sept 09
Cognos Team Lead

Confidential, is a leader in Clinical Trials to provide successful products like Synagsis and Flumist. The project is called as Release 1 of the Clinical Trial Management System against Impact - Polaris Database which is Oracle 10g.

Responsibilities:
Clinical Trial Management System - Release1

• Analyzed the existing Clinical Trial Management System composed of Impact-Oracle 10g, SAS, SAP and Cognos.
• Analyzed 5 Framework Manager Models and 8 Packages for Impact, Medical Operating Plan and Site Personnel.
• Analyzed Highly Critical 30 Report Studio Reports sent to FDA for creating Technical Requirement Documentation and Design Specification Documents.
• Designed Strategy to migrate Framework Manager models and Report Studio reports to new Impact-Polaris Database.
• Designed Cognos Development to QA Migration Roadmap.
• Install Cognos 8.2 on QAS Server and Configured for Oracle 10g Database.
• Configured Security with Active Directory and set up User Groups and Access Permissions.
• Created Documentation for Installation and Configuration of Cognos for OQ and IQ.
• Developed a Framework Manager model to consolidate 5 existing models and leverage packages for 20 existing and 10 new reports.
• Interacting with Business Users for Report Specifications and Impact Application Overview.
• Modifying existing reports like PI and Sites Report, Trial Team List, Trial Cost Tracking, Trial Study Compliance Report, Investigator Report and Clinical Dashboard.
• Created New Reports like Monitoring Visit Status Report, Dispensation Report, Study Specification Report, and Site Payment Report.
• Created Clinical Dashboard with Drill up and Drill down and Drill Through Capacities.
• Test 30 Reports and release for UAT for Release1.

Environment: Cognos 8.2, (Report Studio, Query Studio, Framework Manager, Dashboards, Oracle 10g, Toad), CRN, Impact Orion and Polaris.

ISA Consulting Aug 08 - May 09
ISA is a leader in providing Management and Technology consulting services in the Performance Management, Data Integration and Business Intelligence Fields. As a lead consultant I worked on four primary projects for ISA which required me to take up different roles and understand different business domains.

Confidential
Systems Analyst
SmartSource Project

• Analyzed Business requirements, customer data and mapped data warehouse fields to Framework model in Cognos 8.3.
• Sales Mart Data Model design demonstration in Framework Manager 8.3 for analyzing Clinical Replies by Dominance by Geography and Skill sets Assignments.
• Developed complex reports like 'Contacts over Time by channel', 'Voice of Customer', 'Escalated Call Metrics', 'Escalated MIR Contacts over Time', 'HCC MIR Tracking Summary Report'.

Confidential
Cognos Architect
Clinical Research project

• Worked with ETL Team for creation of Healthcare Management Data Mart using Informatica in the Integrated Data warehouse forClaims, encounter information, payment and remittance advice.
• Build Framework Model for Healthcare MGPO Professional Staff Compensation Benefits with relational and DMR dimensions.
• Identified Dimensions, Measures and designed multi-dimensional applications like Professional Billing Office Cubes, Lag Analysis Cube, and Write off Analysis Cube.
• Developed Wait-list management reports for tracking patient through-put, and establishing wait-time alerts, Capacity management report for tracking key indicators like critical incidents, discharge times, and patient transfers.
• Converted existing Predictability reports for analyzing all factors that impact a patient's length of stay and Daily Planning reports for resource allocation such as planning staff levels

Confidential
Cognos BI Analyst
CARS Applications

• Analyzed the existing CARS data system for developing new Framework Manager Model in 8.4.
• Performed impact analysis on upgrading existing reports against the new model.
• Designed dynamic reportsin 8.4 like Project Overview report, Budget Analysis report, and Site-Level Details report.
• Modeled data from disparate sources and developed 'Contract by Product by Customer' Dashboard for overview of various sales monitoring activities.

Environment: Cognos 8.4, 8.3 (Report Studio, Framework Manager, Dashboards,Toad), Informatica, Oracle 11i, Oracle 10g.

Confidential, East Aurora, NY Apr 06 - Aug 08
Cognos Datawarehouse Specialist

Confidential, is the world's number one brand in infant and preschool toys. Projects worked on include Demantra Sales Forecasting, Product Forecasting, Purchase Order Reporting, Domestic Finance, Sales, Tax, BAP Allocations, Forecast & Allocations, and Customer Benefits and Keep the Wheels On.

Responsibilities:
Project Work
Point of Sale:

• Created an Order Management Solution from the weekly customer data using Transformer Series 7.4.
• Designed a One Source Point of Sale Schema which had transactional Sales information from Customers and Dimensions from Enterprise Datawarehouse.
• Developed a One Source Point of SaleFramework Manager Model and created reports on Customer Demand, Inventory Level, and Promotion decision.

Purchase Order Reporting:

• Developed Framework Manager Model from EDW (Oracle 10g) to create reports on customer purchase orders and open orders according to Sales VP organization.
• Created Broker Commission reports and VP approved reports.
• Designed the complex security requirement for FM model according to Sales VP organizations. Bursted Reports according to Broker IDs.

Demantra Sales Forecasting:

• Mapped the Demantra Transaction System (OLTP) tables to Integrated Datawarehouse (Redbrick).
• Optimized existing Schema for effective and improved BI performance.
• Analyzed existing Impromptu Catalogs to model a consolidated Framework Manager package. Modeled Forecasting cubes (ROLAP) using Transformer for Powerplay Reports.

Production Support

• Worked on the highly critical and confidentialRecall Reports.
• Monitoring Project Status, Tracking updates, performanceimpactusing SCRUM methodology.
• Establish best practices, and create metrics insupport of BI Center of Excellence.

Environment: Cognos 8, Cognos EP Series 7.4 (ReportNet 1.1, Powerplay Transformer, Impromptu, SQL Server, Redbrick, Teradata)

Confidential, Simi Valley, CA Mar 06 - April 06
Cognos BI Consultant (Working for Cognos Corporation professional services)

Confidential, is a provider of insurance management services and a holding company. This project called as 'ReportNet Implementation' involved data modeling and developing highly complex reports for insurance claims.

Responsibilities:

• Involved in analyzing the user requirements and completing theBusiness Requirement document.
• Used Framework Manager to model data from Oracle 9i database and developed a huge model involving 420 query subjects.
• Externalized query subjects in Framework Manager and published the IQD's on ReportNet server to be used as data source for Transformer models.
• Created highly complex drill through and master detail reports like Units GT 10 and GT 20,
• Designed Transformer models with 13 dimensions and 11 measures.
• Involved in building 4 cubes for reports in Powerplay User and Powerplay Web Explorer.
• Validated data in reports using Toad.

Environment: Cognos EP Series 7.3 (ReportNet 1.1, Powerplay Transformer, Impromptu, Oracle 9i, Windows XP Pro) and TOAD.

Confidential, Burbank, CA Aug 05 - Mar 06
Cognos BI Consultant

The (BVTV) USA and (BVITV) of Walt Disney engaged in media distribution business has initiated this project to use a custom application called ZEUS to store its data in a highly normalized relational DB2 database.
Responsibilities:

• Procured user requirements and created report specifications based on Zeus application.
• Used Framework Manager to model data from DB2 relational database and created three models Zeus Client, Zeus Deal BVTV, Zeus Product in cross functional areas like Client, Deal and Product for both BVTV and BVITV.
• Data modeling included creating aliases, joins, merging, determining cardinalities and relationships.
• Developed complex reports like Client Mail Merge, Options date, Critical dates report, Ad run down, Distribution play tracking report, Syndicated broadcast schedules using Report Studio.

Environment: ReportNet1.1, DB2 UDB V7.2, Windows 2000, DB2 Visualizer, Advanced SQL Query Tool, SQL Server 2000 as repository, Informatica Powercenter 7.1

Confidential, Atlanta, GA Jun 05- Aug 05
Senior Cognos Developer

Confidential, is a leading animal health care company in collaboration with Merck and Co, Inc. The project named as 'Cognos Sales Consolidation' involved consolidating six existing Framework Manager Models into a consolidated Sales model and creating complex reports.
Responsibilities:

• Used Framework Manager to model metadata from Oracle and IQD data sources to consolidateinto one Sales FM model.
• Analyzed four Transformer models and cubes to link the models.
• Designed Database layer, Business Layer, created joins, determined cardinalities, and resolved Hierarchical relationships, role playing dimension and Recursive Loops.
• Refined metadata models for Sales Work stream, created Project plan to deliver for the business.

Environment: ReportNet1.1, Cognos EP Series 7.3 (PowerPlay, Transformer, Access Manager), Oracle 8i, Windows 2000 and TOAD.

Confidential, Waltham, MA Dec 04 - May 05
ReportNet Developer
Confidential, is widely recognized as the provider of Network and Care Management services. The project involved developing reports using Cognos ReportNet to efficiently integrate and organize medical information and patient records.

Responsibilities:

• Involved in migration of Impromptu catalogs toReportNet using ReportNet Migration utility.
• Involved in building Multidimensional Cubes, Sub cubes using PowerPlay Transformer.
• Published cubes and OLAP reports using Upfront Server.
• Created Business Mix Reports, Trend over Time Reports, Ranking using PowerPlay.
• Created appropriate user classes, users, database sign-on in Access Manager.

Environment: ReportNet1.0, Cognos EP Series 7.3 (Impromptu, PowerPlay, Transformer, Access Manager, Upfront), ReportNet SDK in Visual Basic, Metadata Migration Utility.

Technical Skills:

Reporting Tools

Cognos 8.4,8.3,8.2,8,CRN (Report Studio, Analysis Studio, Framework Manager), Transformer, PowerPlay, Go Dashboards, Cognos TM1 9.4, Impromptu, PPES, CAFÉ, Access Manager.

Databases

Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008, Redbrick, DB2.

Operating Systems

Windows 2000/2003/XP. UNIX, LINUX, MINX

Programming Languages

C, C++, HTML

Web Development Tools

Dreamweaver, Front Page

Other Software

TOAD, ERWIN, MATLAB, SSIS