PROFFESIONAL PROFILE

Over 7 years of professional experience in analysis, design, development, customization and implementation of Software applications and products. 7 years extensive hands on experience in developing Data Warehousing/BI applications using Cognos BI and ETL tools with strong business understanding of Financial, Banking, Healthcare, Retail, Pharmaceutical and Entertainment domain.

• Expertise in IBM Cognos 8.x BI suite (All Studios), Framework Manager,Transformer
• Excellent knowledge of ReportNet (Cognos 10.x/8.x ,Report Studio, Query Studio, Framework Manager), Powerplay, Transformer, Impromptu, Impromptu Web Reports (IWR), PPES, Upfront, Access Manager, and Scheduler.) and Cognos Series 7.
• Involved in the entire BI lifecycle development process and have a very good understanding of the underlying architecture of Cognos tool.
• Technical and analytical skills with clear understanding of the difference in design goals of ER Modeling for OLTP and Dimension Modeling for OLAP
• Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Experience in building Multidimensional models and creating Power Play Cubes.
• Excellent Knowledge on Data Warehousing and techniques.
• Very strong experience in Design Custom Dashboard reporting solutions using Cognos 10/8.4 BI suite.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Strong experience in migration of Cognos report from 8.x series to 10.x series.
• Strong experience in improving the performance of Cognos reports by tuning SQL, implementing Data Marts, suggesting indices, running explain plans and implementing server changes.
• Extensively interacted with top level Business Users (CEO, CFO, CMO and CHRO) and Executives, and gathered information, and requirements.
• Handful experience and profound knowledge on SAP BI/BW, SAP-BO and applications.
• Experienced in working with SAP BI i.e. creating Infocubes, Datasources. Migrating data from BW 3.5 version to BI 7.0
• Generating reports using Bex Query designer and Bex analyzer.
• Worked with Erwin Designer to develop logical model and physical model diagrams.
• Excellent programming experience in Oracle 10i/9i/8i, MS-Access, MS-SQL and DB2 and Database access tools TOAD and SQL Management Studio.
• Worked closely with ETL tools (Data stage 8, Informatica 8.6/8.1, Cognos Data Manager, (OWB) Oracle Warehouse Builder) and ETL developers to understand the data patches and business information.
• Involved in data profiling, data cleansing in staging area in ETL Informatica tool.
• Expertise in developing Database Schemas such as Star Schema and Snowflake Schema, which are used in relational, dimensional and multidimensional modeling.
• Team player and self-starter with strong work ethics, excellent communication and development skills, flexible, adaptable to all kinds of stressful environments with ability to work independently or as a part of a team and ability to pick up new skills quickly.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules.

TECHNICAL SKILLS

Business Intelligence tools

Cognos 8 BI Suite: Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Transformer, Framework Manager, 
Cognos ReportNet: Report Studio, Query Studio, Framework Manager.
Cognos Series 7: Impromptu, Impromptu Web Reports (IWR), Powerplay, Cognos Query, Access Manager, Cognos IWR administration.
SAP BI/BW (Netweaver), SAP BO (Xcelcius, WebeX, Bex Query designer and Bex analyzer)

Web Servers

Microsoft Internet Information Server (IIS) 3.0/4.0

Databases

Oracle 8i/9i/10i, DB2, Teradata 12.0, MS SQL Server, and MS Access 97/00/XP/03

Languages

C, C++, SQL, PL/SQL, T-SQL, HTML, XML, JAVA scripting.

Operating Systems

Windows 95/ 98/ NT/ 2000/ 2003/ XP/ Vista, MS DOS and UNIX, LINUX, MAC.

Tools/ETL/Data Modelling

PL/SQL Developer, TOAD, Oracle SQL Developer, MS-Office suite, Macromedia Dreamweaver, Eclipse, SQL Navigator, ERWIN, Informatica. Data stage 8

EDUCATION

• Bachelors in Computer Science Engineering .

CERTIFICATION / TRAINING

• Certified and Trained inSAP Enterprise Info Systems
• Certified and Trained in SAP BI/BW (Net weaver)

WORK EXPERIENCE

Confidential, El Segundo, CA

Cognos Developer/ BI Analyst Oct 12 - Present

Based in El Segundo, Calif., Confidential provides comprehensive broker-dealer services, innovative technology, and competitive advisory programs for approximately 6,500 independent financial professionals and more than 600 financial institutions affiliated with its four independently managed broker-dealers: The main objective of the project is to fix the data issues in data warehouse and back office that happened because of mergers and acquisitions in and within the company. Design, develop and test existing and new reports and create executive dashboards.

Responsibilities:

• Extensively interacted with top level Business Users (CEO, CFO, CMO and CHRO) , gathered information, and requirements.
• Created Active reports, list reports, cross tab reports and dashboards real quick in the business meetings to help top level business users in making important business decisions.
• Worked for many business users and created ad-hoc reports and complex report.
• Worked closely with Data warehousing (ETL), Ulti-pro (Human Resources Information Systems) teams to understand the data patches and help resolve.
• Extensively interacted with the Ulti-pro support team to rectify few errors in the FM model and the database.
• Created reports, identified and exposed errors and issues in database, HR and Payroll back office systems.
• Developed C-Level dashboards using Business Insight, Cognos 8.4/10/1 BI suite.
• Created different types of prompts and filters for user convenience.
• Scheduled the reports and created events in Event studio to help make decisions on time.
• Migrating all the reports and cubes from Cognos 8.4 to 10.1
• Designed models using Impromptu Query Definition (IQD), created OLAP Cubes in Cognos Transformer, and analyzed the data using Cognos and Power Play
• Developed Templates, Master Detail Reports, Chart Reports and Multilingual Reports using Report Studio and Query studio.
• Generated SQL/MDX and analyzed Cognos SQL, Native SQL to trouble shoot the report issues.
• Performed Unit Testing to verify if the Actual Results meet the Expected.
• Worked on Analysis Studio to develop multi-dimensional reporting for further analysis.
• Changed the already existing static reports to Dynamic reports.
• Built Power Play Reports based on the cubes and published to Report Net Server
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members
• Prepared User documentation to train users and functionality of each report.
• Trained End users on Query Studio and Report Studio.

Environment: Cognos 8.4/10.1, Report studio, Query studio, Analysis studio, Business Insight, P/L SQL, SQL server, Power Play 7.1, Transformer, MS Excel, Ulti-pro, Informatica, HTML, MS Access and Windows XP

Confidential, El Segundo, CA

Cognos Administrator Feb 11- Sep 12

Confidential is American direct broadcast satellite service provider and broadcaster based in El Segundo, California. It has nearly 19 million customers across the nation. The OLAP project was to provide an analysis report for the Sales management. The project focused on the usage and allocation of the resources. The main objective of this project is to migrate 8.x to 10.1 and resolve the issues involved withmigration. The project was designed for management to estimate its processes for marketing and trap the customer and market trend. The main aspect remained mentoring the Cognos team and show then the best methods for using the tools latest release. 
Responsibilities:

• Used to interact with users for requirement gathering
• Involved in analysis, and design the technical specifications to create models.
• Designed the 3 layer architecture for the FM model.
• Defined governor settings in Framework Manager to tune the performance.
• Defined join conditions, table aliases and views for the user requirement.
• Created and developed various reports like Business Mix Reports, Variance Reports, and Trend over Time Reports.
• Worked on Cross tab reports, drill-thru, linked-sub reports and sub reports (Complex reports).
• Created drill-through from Cube to relational and relational to relational.
• Organized accessed data sources into Transformer models, Dimensional maps and developed Power-Cubes, which can be changed in many ways to Slice and Dice and drill-through data for further multi-dimensional analysis.
• Developed the OLAP cubes.
• Developed reports in Analysis Studio for further analysis.
• Used to write macros for scheduling reports. Worked on Cognos Security Administration to restrict the Users.
• Extensively involved in customer support.
• Upgraded to Cognos 10.1 from 8.4
• Created User Classes and Users in Access manager.
• Created Models by using Impromptu Query Definition (IQD) in PowerPlay Transformer.
• Maintain the Cube Security using User Class Views.
• Used PL/SQL to analyze Queries.

Environment: Cognos 10.1/8.4, Power Play 7.1, Transformer, MS Access and Windows XP, Teradata.

Confidential, Pasadena, CA

Cognos Developer Aug 09 - Jan 11

Confidential is one of the world\'s leading fixed income managers. From offices in Pasadena, Hong Kong, London, Melbourne, New York, São Paulo, Singapore, Tokyo and Dubai, the company provides investment services for a wide variety of global clients, across an equally wide variety of mandates. There were multiple projects that I got to work on during my tenure in this company. Many of them were end to end projects developing full Applications to provide better business solutions.
Responsibilities:

• Replicated Cognos Report Net Security to Cognos Series 8.
• Maintained Security in Cognos Connection by controlling privileges for users, groups and roles.
• Involved in administration of servers using Cognos connection.
• Setup users with security using Access Manager Administration.
• Involved in setting up User Groups/Roles in Access Manager to secure the Models, Packages and Reports.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Deployed the entire content store from development to test environment.
• Developed a Framework Manager model involving four schemas/databases called Loanstar, Appro, Empower and B2B.
• Resolved ambiguous, hierarchical and recursive relationships in the Framework Manager Model.
• Involved in design and development of filters, calculations and session parameters in Packages within Framework Manager.
• Created various packages within the same Framework Model.
• Developed List Reports, Cross-tab Reports and also some complex Reports using Master Detail Relationships and conditional formatting.
• Testing and improving Report Performance and performing Query optimization.
• Extensive unit and performance testing for the reports and fixing report bugs.
• Trained End users on Query Studio.

Environment: Cognos Reportnet1.1/8.3/10.1, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Scheduler, Access Manager, Oracle 8i/9i, PL/SQL, SQL Server, HTML, MS-Access, MS- Excel.

Confidential. Irvine, CA

Cognos Developer Mar 08 - Jul 09

Confidential, more commonly known as Confidential, is an American S&P 500 company headquartered in Burlington, North Carolina. It operates one of the largest clinical laboratory networks in the world, with a United States network of 36 primary laboratories. The main purpose of the project was to merge their formerly disparate modules into a single iPLS system. In the process the Sales and Deals team required to create new models and reports using Cognos 8. Main challenges were to work with an offshore team and the short timeline of the project.
Responsibilities:

• Modeled and Reported against an Operational Data Source (OLTP).
• Involved in the entire BI lifecycle development process and have a very good understanding of the underlying architecture of Cognos tool
• Extensive interaction with Business Users and gather information and requirements.
• Upgraded Report Net Models and reports to Cognos 8.2.1 Environment.
• Created several list, Cross tab, Chart, and Repeater Reports using Report Studio.
• Created reports having multiple Report Pages, Prompt Pages (with Select & Search, value prompt, text box, Date, Interval, Cascading, tree prompts).
• Used Conditional Blocks, Conditional Formatting to merge 2 or more Cognos Report Net reports and developed Consolidated Reports in C8
• Developed Templates, Master Detail Reports, Chart Reports and Multilingual Reports using Report Studio and Query studio.
• Generated SQL/MDX and analyzed Cognos SQL, Native SQL to trouble shoot the report issues.
• Performed Unit Testing to verify if the Actual Results meets the Expected.
• Deployed Packages, Reports to Test Environment using Content Administration.
• Involved in creating OLAP hierarchy, Dimensions, formulas & power cubes using Cognos Transformer and Reports using Power Play.
• Created Member based Security, Custom Views, Dimension Views, Apex Custom views, Cloak.
• Added Drill through reports to another cube (.mdc file) from the same model, to overcome row or category limitations

Environment: Cognos 8.2(Framework Manager, Report Studio, Query Studio, Analysis Studio), Report Net 1.1 MR3, SQL Server 2005, TOAD, Access Manager, Windows 2003 Server, Cognos Power Play Transformer, Cognos Power Play, Power Play Enterprise Server, iPLS.

Confidential. UT

Cognos Developer Jul 07 – Feb 08

Confidential to improve the lives of all Utahans. It uses data driven, evidence based interventions to promote healthy lifestyles and behaviors; detect and prevent injury and disease; and improve access to quality health care for all people of Utah including the state’s most vulnerable populations. The main objective of the project was to render all the help and support needed to rebuild all the cubes previously built using Power Play Transformer. The project also demanded designing new DMR models. 
Responsibilities:

• Analyzed Business requirements from the analysts
• Customized Cognos Connection with appropriate reports and security measures
• Worked on Analysis Studio to develop multi-dimensional reporting
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP – ROLAP)
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers
• Designed Power Play reports to provide summarized results by measures and dimensions
• Created custom prompted reports in Report Studio, Bursting reports to different user groups
• Involved in Designing models using Framework Manager and deployed packages to the Report Net Servers
• Implemented Framework manager security for Data access, Object level access and Package access
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model
• Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager in Report Net
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database
• Built Power Play Reports based on the cubes and published to Report Net Server
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members
• Migrated catalogs and reports from Cognos 7.3 to Cognos 8.2 and CRN Reports to Cognos 8.2
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various business’s needs (Folders, Filters, and Macros)
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab)
• Prepared User documentation to train users and functionality of each report

Environment: Cognos 8.2, Cognos Series 7(Cognos Power Play 7.3, Cognos Transformer7.3, PPES, Access manager, Impromptu, IWR), (Impcat2xml, Migratetoc8, Deploytoc8), Sybase 12.0, DB2 8.0, windows 2000, UNIX 5.0

Confidential. DC

Cognos Developer Apr 06- Jun 07

Confidential is an international financial institution that provides loans to developing countries for capital programs. The main objective of this project was to design new models and create reports for the different departments of the company using the latest Cognos release.
Responsibilities:

• Worked for many business users and created ad-hoc reports and complex report.
• Developed landing pages for each business by using Cognos 8.
• Creation of calculations, prompts and filters for usage in various reports.
• Conducting training to users and business owners.
• Created reports using Cognos 8.1 & 8.3 Report Studio features like master detail, section, drill down, drill up, and drill through.
• Responsible for using Power Play Transformer.
• Created analysis on OLAP and dimensionally modeled relational data sources in Analysis Studio.
• Using Framework Manager designed models, name spaces, data model and packages and publish packages to the Cognos connection.
• Designing the system testing and implementation planning activities.
• Optimizing the existing reports in production depending on the run time formatting the reports.
• Cognos Connection to organize objects, security, scheduling, deploy & distribute reports.
• Documenting the object in production and versions of the Cognos Objects.
• Created dashboard reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional formatting, block, tables, master-detail, charts, filters, prompts, various calculations and joins using tabular sets and tabular models.

Environment: Cognos v8.1, SQL Server, Oracle 9i, PL/SQL, OLAP, Windows XP