Professional Summary

• 10 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 Tm1 9.5, 10.1 :- 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. Tm1 Architect, TM1 Perspectives, TM1 excel.Tm1 Contributor.
• 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

• Designed, developed, and maintaining Business Intelligence and Data Warehouse solutions using Microsoft SQL Server database and related tools SSIS, SSRS, SSAS , IBM Cognos 10.2 Suite Framework Manager, Report Studio, Query Studio, Business Insight Advanced, Business Insight
• Works closely with other IT staff to meet expectations for design reviews and coding standards.
• Provided issue resolution during Quality Assurance / User testing.
• Assisting with the move to production/implementation process.
• Provides primary production support for developed reports.
• Providing troubleshooting, analysis, and support to resolve system, data, or reporting questions and issues.
• Facilitates customer requests for new or changed solutions.
• Conducts customer requirements workshops, develops options with recommendation, creates functional specifications including performance requirements, creates test plans to confirm delivered.
• Defines and writes technical documentation related to systems and applications as necessary.
• Plays a key role in driving the success of Anoka County's Reporting Committee.
• Tracks and publishes on-going status related to reporting issues, resolutions, and development progress
• Collaborates closely with technical and non-technical resources Technical Analysts, Systems Project Leaders, Senior BI Developer/Architect, vendors, and other business or IT personnel as needed to develop timely and accurate reporting solutions and shares pertinent information with other county resources.
• Providing project management oversight, including time estimates, resource allocation, project status updates, and managing critical path and milestone deliverables.
• Works with end users to train them on use of developed solutions.

Environment: Cognos 10.2 Suite Framework Manager, Report studio , MS SQL Server, SunGard one's Financial Solution.

Confidential

• I'm working as Cognos Technical Lead with coordinating Onsite/Offshore team. Working on different Projects and providing support to existing Cognos 7 Series business applications and also Cognos 10 development projects.
• I'm Responsible for analyzing, building, testing, implementing and supporting BI solutions including, Requirements gathering, Analyzing requirements, Designing solutions, Building and testing BI solutions.
• Ability to work within/across team and get job done.

Environment: Cognos 10.2, Cognos 7.3 Oracle, SQL Server, Data stage.

Confidential

Role: Sr Cognos Consultant

• Responsible for the strategy and design of enterprise reporting and analytics architecture, including the conceptual, logical, and physical layers.
• 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.
• 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. Proficient in writing Cube Rules, appropriate Feeders and fine tune Feeders for better performance.
• Proficient in creating complex Active Forms and enhanced the performance of existing Active forms.
• Excellent Inter-personal skills and a quick learner. Ability to get along with the team well, and can handle client issues at all stages of the development process.
• Experienced in Data modeling using framework manager and Transformer Cubes DMR, MDX .
• Troubleshooting Cognos configuration and Reporting issues in 10.2
• Create dashboards, scheduled reports, data analysis and report development.
• Provided all types of documents for Cognos Migration and project based development.

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

Confidential

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 .
• Work with the Business Analysts and Report Designers to create the Framework Manager models and to design packages and reporting objects
• 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.
• 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

Confidential

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.
• Developed TM1 Cubes, Dimensions, Business Rules, Written rules and TI process without wizard method.
• Creating Multiple TM1 Instances for development, Testing, TM1 Cubes, and Dimensions and populating the Cubes with using different data sources Like, TM1 cubes, Oracle/SQL server/DB2 database and MDX queries.
• Creating Business rules and data transfer between cubes and Loading Data into Cubes using Turbo Integrator.
• Environment: Cognos Tm1 9.5 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

• Confidential. 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.
• Created framework manager Relational DMR models for business users ad-hoc users.
• 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.
• Conducting User Training Session on Merial Transformation Model and Creating Ad-hoc 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.