Professional Summary

• 9 years of IT experience with Sound knowledge and experience in different phases of software development life cycle SDLC including analysis, Design, Development, Testing and Production. Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions using Cognos10 Hyperion 8 Series
• As a Sr BI DWH Consultant typically responsible for evaluating and analyzing customers' needs and requirements, design, architect, develop integrated data warehouse, data models, reports, scorecards, dashboards and integrated solutions. In addition provided both technical and functional Cognos and Hyperion product support and guidance to ensure successful implementation
• Expertise in Installing Configuring, Administration of Cognos 10 8 BI Series 8/8.1/8.2/8.3 and Implemented Single Architecture and Multi- Architecture Environments and Configured Audit logging and Monitoring Dispatcher Services and Administered Configured Active /Passive Content Store Environments in Cognos.
• Performed Cognos configuration, administration, and System Performance and implementing Cognos software upgrades and Reviewed Complex Modeling situations and implemented solutions using Framework Manager in Cognos8 BI Series
• Experienced in Configuring Administration of Cognos Connection and Framework Manager and Design developed Business Intelligence Reporting Solutions for Report Studio, Query Studio, and Analysis studio.
• Performed Migration of Reports from Cognos 7 Series Impromptu to Cognos Report Net 1.1 and Cognos 8/8.1/8.2/8.3 Series using Migration Tools Applying patches across Multiple development, test, and production environments
• Extensively Worked different series of Power play Transformer 7/7.3/8 on Design Modeling Concepts and Building Cubes with Power play Transformer and Designed Multi-Dimensional Models for creating Reports in Analysis Studio and Report Studio
• Proficient in Using Best Practices to support the Reporting Activities, Adept in using performance tuning and optimization techniques such as Load Balancing, Audit logging, Query Performance.
• Expertise in setting various Security Setups Package Level, Object Level, Row Level, Folder and Users level security framework manager and Cognos connection.
• Experienced working with different database environments as Oracle, Microsoft SQL Server, Access, Teradata,DB2 ,Databases
• Ability to meet the timelines and handle multiple tasks, Develop relationships with executives and managers in client's IT and business departments. Mentoring Users Training sessions on Cognos 8 Product.
• Provide knowledge-transfer services to customers, Demonstrate strong technical knowledge of the entire Cognos product line, Advised customers on Best Practices for BI deployments.
• Implemented modeling concepts of Start Schema ,Snow Flake Schema, Resolving Conceptual Models and design user friendly Modeling Environment matching to Client Reporting Requirements.
• Experienced in Relation Model Concepts, Dimensional and Multi-Dimensional Modeling Concepts and maintain technical documentation to describe program development, logic, coding, testing, changes, and corrections.

Technical Skills:

Business Intelligence Tools:

• Cognos Enterprise Planning 8.1, 8.2, 8.3:- Contributor Administrator, Analyst, Add-In Excel, Contributor Manager.
• Cognos 10, 8 BI 8/8.1/8.2/8.3/8.4 Series :- Cognos Configuration, Cognos Connection, Administration, Metrics studio, Report Studio, Query Studio, Framework Manager, Metrics Manager, Power Play Transformer 8, Analysis Studio, Power play Studio, Event Studio. Cognos Go Dashboard, Cognos Office.
• Cognos Report Net Suite Series: Cognos Connection, Query Studio, Analysis Studio, Report Studio, Framework Manager.
• Cognos 7 Series:- Cognos Impromptu Administrator 6.x/7.x, Power Play 6.x/7.x, Upfront, Power play Transformer, Access Manager, Decision Stream, Impromptu Web Report Server IWR , Notice Cast, Power play Enterprise Server, Metrics Manager, Scheduler, Visualizer, Macros., Cognos Go office, Cognos Go Dashboard. 8.4
• Hyperion Interactive Reporting Brio , SQR Production Reporting, Financial Reporting Reports , Web Analysis Analyzer
• ETL Tools: Informatica Power Center/ Power mart 6.1, Cognos Decision Stream 7.1, Microsoft Analysis Services.

Languages:

Java Script, HTML, VB Script, SQL, PL/SQL.

Operating Systems:

UNIX Sun Solaris, HP US , Windows 98, 2000, XP/2003.

Web Servers:

Internet Information Services, Apache.

Databases:

Oracle 9.x/10g. SQL Server 7.x/2000/ 2005, DB2, MS Access, Redbrick, Teradata.

Professional Experience

Confidential

Role: Sr Cognos Consultant

• Responsible for the strategy and design of enterprise reporting and analytics architecture, including the conceptual, logical, and physical layers.
• Installed configured Cognos 10.2 in Windows 2008 R2 and configured active/failover database, load balancing of Cognos server and Setting up Security.
• Installed and Configured Cognos Mobile, Go Mobile and configured tuning settings of Cognos server and defining metric thresholds.
• Experienced in troubleshooting Cognos logs and resolving issues.
• Responsible for implementing best practices on Cognos report design and development.
• Lead the reporting team in developing complex reports, dashboards and OLAP solutions.
• Responsible for Training and mentoring the reporting team as well as cross functional teams on various aspects of BI solutions.
• Responsible for providing architecture and implementation recommendations on Cognos environment sizing, scaling, Performance Tuning and load balancing
• Experience in Dimensional modeling, OLAP and Performance Management is desired.
• Consult with clients to provide insights into BI solutions and Prototype and build Cognos Proof-of-Concepts.
• Perform research and coordinate innovation within the organization.
• Worked on multiple projects as PMR, AZTEK, EBIZ, and Real Time Reporting.
• Design scope documents for Cognos 10.1.1 Migration, Administration, and Security.
• Experienced in Data modeling using framework manager and also Transformer Cubes DMR, MDX .
• Installed configured Cognos 10.2 in three different Environments.
• Applying Optimization techniques and driving Cognos for better performance.
• Designed reports, dashboards for real-time and analytical reporting.
• Troubleshooting Cognos configuration and Reporting issues in 10.2
• Provided solutions for Cognos real time reporting.
• Create dashboards, scheduled bursted reports, data analysis and report development.
• Responsible for other duties as assigned or developed.
• Provided all types of documents for Cognos Migration and project based development.

Environment: Cognos 10.1, 10.2, MS SQL Server, Oracle, Essbase, Teradata, Ms Office

Confidential

Health Services Business

Role: Sr Cognos Consultant

• The UnitedHealth Premium physician designation program uses clinical information from health care claims to assist physicians in their continuous practice improvement and to help consumers make more informed and personally appropriate choices for their medical care. The program uses evidence-based, medical society, and national industry standards with a transparent methodology and robust data sources to evaluate physicians across 21 specialty areas to advance safe, timely, effective, efficient, equitable and patient-centered care. The program supports practice improvement and provides physicians with access to information on how their clinical practice compares with national and specialty-specific measures for quality, and with local cost efficiency benchmarks in the same geography.
• Gathering Report design requirements from RSA Requirements Solutions Analysis and BPSD Business Process Specification Document .
• Worked with Data Architect / Modeler to insure data scope is met and that the data models satisfy the needs of the Cognos reporting system
• Work with the Business Analysts and Report Designers to create the Framework Manager models and to design packages and reporting objects
• Worked with the Data Warehouse team to insure standards are set and adhered to the Business Intelligence solution including a comprehensive security strategy
• Provide site coordination ongoing guidance, leadership and mentoring to the development team co-located virtual teams
• Assisted developers with troubleshooting activities 6. Help coordinate and facilitate testing activities
• Supported project managers with project planning and scheduling inputs tasks, estimates
• Supported requirements-gathering and analysis and design processes
• Supported infrastructure teams with code migrations deployment 10. Report progress to management and support risk and issue management
• Working with Business Analysts and ETL and Report development team on functional Specs and BPSD.
• Solid understanding of databases, SQL and data warehousing/marts with SQL Server Studio 2005 .
• Demonstrated problem solving and excellent analytic skills.
• Experience working with team members in multiple locations, including Cognizant off-shore team for HPBC Market Insight projects.
• Based on priority situation to work with QA Team on validating and fixing Cognos HPQC tickets.
• Created 16 dashboard reports with Cognos report studio driven features.
• Created Drill through Summary and Detail Reports in cognos8 environment.
• Created Variable and Conditional rendering of reports in cognos8.
• Designed Dashboards and Summary Reports using DMR for Market Insight Transformer based reports of HPBC packages.
• Designed Executed Design OLAP Structure from Cubes prototype to DMR and Transformer.
• Experienced in using MotioCI within Cognos 8 Environment
• Environment: Cognos 8.4 suite, Motio CI plus, SQL Server Studio 2005, Motio CI plus, Kalido, HPQC. MS office

Role: Sr Cognos Consultant

• Health Care Service Corporation HCSC is a customer-owned health Benefits Company focused on improving the health and wellness of our members and communities. Our outstanding employees and their commitment to providing superior services and products to our individual members and group customers have made Health Care Service Corporation and its subsidiaries among the fastest growing health and life insurance companies in the nation.
• All Technical and functional requirements are initially translated to Documents and to Cognos screens with prototype designs using Cognos8. Initial API Goal for the 1st Release of project to develop all prototypes for dashboards and followed by data model for cube development using SQL Server Analysis Services and Cognos Transformer.
• Gathering Functional requirements and specification from business users and management team and showcase functional requirements using power point slides and reviewing with business users.
• As Sr Cognos Consultant developed CDHP Product Marketing Dashboard and Market Segments Dashboard under 65 Dashboard and followed by details reports. Dashboard Includes the Functionality of Drive thru and other comparison of Various Metrics by different Time periods, based on prompts and Charts are dynamically designed with Year over Year and Month over Month and Sequential Year Metrics and other functionalities of Cognos Report Studio.
• Created Database reporting tables and views for all dashboard reports in SQL Server and inserting data for prototypes and updating tables as required.
• Validating Cognos reports and resolving Cognos issues in UAT phase and documenting process control and changes requests in Cognos.
• Documented OLAP cube design structure docs with logical physical diagram and analyzing aggregation role playing dimension and SCD's structures for Cube build construction and build process. From relation flat table, build multi-dimensional structure in database and loading of data in to tables and implemented concept of start schema for OLAP cube. Performed updates statements on database to summarize group data by unique level columns ,
• Environment: Cognos 8.3 Framework Manager, Query Studio, Report Studio, Event Studio, Transformer , SQL Server 2005, Java script. MS Office. Analysis Services, SQL integrations Services.

Confidential

Role: Sr Cognos Consultant

• Ambac Financial Group, Inc. is a holding company whose affiliates provide financial guarantees and financial services to clients in both the public and private sectors around the world. Ambac's principal operating subsidiary, Ambac Assurance Corporation, is a guarantor of public finance and structured finance obligations. The Ambac Assurance financial guarantee is an unconditional and irrevocable pledge that investors will receive principal and interest payments in full and on time should the issuer of an Ambac-insured security default.
• Designed ACW, Claims, Loss Reserves, Loan portfolio Cognos framework model and integrated with dwh model with mutli fact aggregation on different level granularity.
• Designed Relational DMR models using Cognos 8.4 Framework Manager based on E-R Structural diagrams.
• Developed 8 Complex Models with snowflake schema concept 3 models of star schema.
• Co-coordinating Various Project developments on Cognos 8.4 development with users team.
• Defined Conformed Dimension and Alias and proper aggregate type and attribute for DMR Modeling.
• Implemented Security on DMR model in 8.4 Framework managers.
• Provided Assistance to Cognos admin on framework security and data security and user security.
• Created Database Tables, Views for Use Cognos Framework Manager and Reports.
• Designed Prototype Cognos Transformer Cube for All Exposure Report using Database Views.
• Troubleshooting of Framework Manager Issues and Performance tuning of SQL.
• Documented Data mapping for Oracle Model with DWH SQL Server Cognos Model.
• Provided Assistance in report development using Report Studio 8.4 which includes creating complex reports and dashboards.
• Documented Change requests in Framework Manager and reports.
• Environment: Cognos 8.4, SQL Server 2008, Erwin, SQL, Navigator, Oracle 10g, Windows xp, Crystal Reports 11.

Confidential

Role: Sr. Cognos Consultant

• Interact with Business users for requirement gathering.
• Installed configured Cognos 8.4 on windows environment.
• Implemented Best Practices on Framework modeling techniques and report studio report designing
• Customizing of Cognos portal with client interface integration of row level security.
• Designed and Created Client Connection FM model with Regular dimensions and Relational Query Subjects.
• Created framework manager Relational DMR models for business users ad-hoc users.
• Created Defined Regular Measure Dimension in FM and Modified Sort Order for Dimensions.
• Defined Scope Relationship for Confirmed Dimensions Facts and Dynamic drill thru reports with Regular Dimensions.
• Experience in writing SQL queries in Cognos for performance tuning.
• Created Prototype report Layouts for Reporting needs for Merial Dimensional Model.
• Created custom calculations, user defined prompts, Security filters in Framework manager for use Query Studio Report Studio.
• Developed Templates, Dashboards Earnings, Redemptions, Coupon Dashboard with Drill thru Features and Master Detail Relationships and used Cognos Query Features to improve performance.
• Resolving runtime errors and problem solving issues during QA of reports.
• Used various prompts, calculations, filters, joins in creating dashboard reports.
• Exported SAS Cubes to Cognos 8.4 Transformer cubes by overwriting SAS business logic.
• Scheduling of Report Transformer Cubes on Weekly Basis.
• Conducting User Training Session on Merial Transformation Model and Creating Ad-hoc reports.
• Training SAS Users to get curve on Report Studio, Query Studio, Metric Studio, Merial Framework Manager models Providing Customer Support to SAS users on Cognos Dashboard Reports.

Environment: Cognos 8.2/8.4 Series Query Studio, Report Studio, Metric Studio, Power Play Studio, Framework Manager, Transformer 8, SAS 9i, MS Office 2003, Windows XP,SQL Server 2005, Oracle 9i/10g Cognos Go Office, Cognos Go Dashboard.

Confidential

Role: Sr Cognos Consultant

• Worked on new development projects including requirements analysis, coordinating with database group s , expanding the use of Cognos through training and hosting user sessions. Worked on Basel Report Monitoring System, Credit Corporate Management reporting, Concentration Reporting.
• Worked with database analysts ETL team on database design, star schemas as well as general concepts.
• Worked with individual business users to educate them on the use of Cognos query and analysis studio also supported existing Cognos group to get curve on report studio.
• Assisting Server Admin back support, cube building and transformer runtime issues.
• Created dashboard reports in report studio and analysis studio using multidimensional cubes and relation model.
• Linking Cognos Reports to Existing Basel reporting Data integrity system.
• Conversion of Existing Oracle Reports in to Cognos Environment's.
• Converted existing reports from Cognos 7.3 to Cognos 8.2 on different data sets SAS, Teradata, Oracle 9i, and MS Access .
• Provided Assistance for developing report standards and procedures for test production environments.

Environment: Cognos 8.2 Series, Redbrick, Microsoft Access, Oracle 9i, Teradata, Windows XP

Confidential

Role: Sr Cognos Consultant

• Installed Configured Cognos8.2 8.3 with Multi-Tier Architecture Environment on Windows Servers and Clients.
• Created modified and updated Views in Database as per requirements.
• Created Data sources Connection and Imported Metadata in to Framework Manager.
• Implemented Concepts of Star Snow Flake Schema Modeling in Framework Manager.
• Developed Relational Modeling and DMR Modeling Techniques in Framework Manager.
• Created Drill-thru Reports with Regular Dimensions and Fact in Report Studio
• Defined Sort Order for Time Dimension and Setting Member Captions Hierarchy's.
• Defined Drill-down and drill up features in report studio reports.
• Setting Business Key and Member Caption for Hierarchies and levels.
• Used Short cut Feature in FM for Regular dimension for Multiple Namespaces.
• Implemented Data security and User Object level security in Framework Manager Cognos connection.
• Designed Dashboard Reports in Report Studio Analysis Studio and Ad-Hoc Reports in Query Studio.
• Created Framework Manager IQD's for use in Transformer Model.
• Designed Developed Transformer Models Published Power play Cube to Cognos Connection.
• Resolved Runtime Errors design issues of Transformer Model and Power play Cube.
• Modified Framework Manager Models and Created Reports as per client's Requirement.
• Designed Pre-Defined Prompts and Report Filters Calculations in Framework Manager for use Ad-Hoc Users.
• Troubleshooting of Cognos Installation errors and Report Runtime of Reports.
• Upgraded Existing Cognos8.2 Models and Reports to Cognos8.3 Environment.
• Deployed Framework Manager Models and Reports and Packages from Dev to Test and Test to Production Environment Troubleshooting Deployment Issues.
• Created Imported User Defined Functions at Database and used in reports.
• Improved Reports Cube Performance by creating views Indexes in Database.
• Implemented Folder Level and Report Level and Access to Studios, Packages.
• Built an OLAP cube from the ground up. Experience writing code / scripts / stored procedures that populate the data in the OLAP cube from an Account Balance/Transaction flat files.

Environment: Cognos8.3, Cognos 8.2 Report Studio, Query Studio, Analysis Studio, Cognos Connection, Metrics Studio, Metrics Manager, Framework Manager Oracle 9i.Microsoft SQL Server 2005, Analysis Services, IIS, Windows 2003 Windows XP

Confidential

Role: Sr. Cognos Consultant

• Involved in prepared functional specification of applications supporting operations, management information and decision support, including OLAP and multidimensional databases and technical design documents for further development.
• Involved in the analysis of the existing system reports and the modification of the reports Upgraded reports and created the new reports based on the user requirements
• Experience in implanting strategies and developing architecture for building a data warehouse.
• Involved in the development/enhancement of Star Schema dimensional data model.
• Design document and prototype layout and discuss with end user and get the layout confirmation from end user.
• Involved in complete SDLC Analysis, Design, Construction, Unit, System, Acceptance, E-2-E Testing and Production support
• Responsible for performance tuning on developed reports, which will send mails to the end user on daily basis.
• Assistance provided for production support and fixing tickets as per priority on various reports

Environment: Cognos 8.2 BI Series Report Studio, Query Studio, Frame Work Manager, Windows XP, Active Directory Server, IIS Web Server, Oracle 9i, TOAD, Microsoft Analysis Services.

Confidential

Role: Brio/Cognos Developer

Responsibilities:

• Involved in Setting up and administering ODS, BCS on windows.
• Expertise in scheduling jobs for fixed schedule reports and sending email notification, and also exported to HTML, Excel, PDF and text files and published to Brio Portal through Broadcast Server.
• Developed customized Broadcast messages using advanced html and published to Brio Portal for end users to view.
• Given Production Support on brio reports different Studies.
• Published existing Brio reports to portal via ONE/Administrator using ODS administrator
• Created Meta data model in Framework Manager by importing Tables and Procedures from Oracle Database
• Scheduled Reports Cognos Reports thru schedule management on daily basis.
• Created Cognos Impromptu Reports in Impromptu Administration.
• Created catalogs and ODBC Connection for connecting to database and importing tables
• Specified Join conditions for Tables in Cognos impromptu and created filters.
• Environment: Hyperion Brio 6.0, On Demand Server, Broadcast Server, Oracle 9i, Java Script, and Windows 2000. Toad .Cognos Impromptu Administrator, Cognos Impromptu, Cognos Report net 1.1, Cognos Framework Manager.

Confidential

Role: Sr. Cognos Consultant