SUMMARY

• Over 8 + years of experience in Analysis, Design and Development of Business Intelligence Projects and software development life cycle (SDLC).
• Designed Reports based on Predictive Analytic Metrics that can save a corporation 25 Million to 50 Million over the years.
• Well versed with working in different and challenging environments with focus on productivity and quality in Small (Agile Methodology) and big teams (Waterfall Methodology).
• Provide support and guidance to Jr. Developers and responsible for timely delivery of the reports.
• Design the UAT test case to validate data for complex reports using Snapshot dimensions.
• Worked directly with the users in understanding the business problem and designing reports to solve or analyze the various problems areas based on the input from the business users.
• Expertise in Designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 6/7/8/10.
• Expertise in designing Active Reports for Executives and Field Agents for Offline use.
• Developed global dashboards using Cognos Maps to monitor the health of the company and find regions with problem areas.
• Expertise in Cognos suite (Cognos 8.x (framework Manager, Data Manager Cognos connection, Report Studio, Analysis Studio, Metric Studio, Event Studio and Query Studio),Report Net 1.1, Report Net SDK, Cognos Impromptu 7.x/6.x, and Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x Access Manager).
• Extensively worked on IBM Cognos 8 Framework Manger, creating model and implementing best practices while resolving the loops and query items, namespaces, DMR (Dimensional modeling with relational data) and packages.
• Proficient in writing Cube Rules, appropriate Feeders and fine tune Feeders for better performance.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Expertise in Framework Manager Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages) and Complex Report building with Report Studio.
• Sound Skills in Report Development, Modeling (Relational, DMR), Dash Board Report in Cognos 8. Created Various Dashboard Reports for different business areas based on Cubes and DMR’s.
• Provide training to business users in using the Query Studio by providing presentation, documents and hands on demo of the data model to help with navigation.
• Strong understanding of Dimensional Modeling concepts and have experience in dimensional modeling using Star and Snow - Flake Schemas.

TECHNICAL SKILLS:

BI Tools: Cognos8.x(Framework Manager, Data Manager, Report Studio, Analysis Studio, Query Studio and Event Studio), Cognos Impromptu 7.x, Impromptu Web Reports, Power Play Transformer 6.x/7.x, Cognos Access Manager, Upfront, Cognos 8 SDK, Report Net 1.1/1.0x, SQL*Plus, Cognos Data manager, Cognos TM1

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000,DB2, MS Access.

Dimensional Data Modeling: Dimensional Data Modeling using Star Schema and Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5, Oracle Designer, Power Designer.

ETL Tools: Cognos Decision stream, Informatica 8.6/8.1, OWB(Oracle Warehouse Builder).

Programming Skills: SQL, PL/SQL, C, C++, HTML, XML.

Operating System: Windows 7/XP/2000/98, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Business Intelligence Specialist

Confidential, CA

Responsibilities:

• Designed Active and Static Reports to provide Pipeline Reports which are used in long term demand forecasting for the global business.
• Designed Inquiry Aging Report that would help the business add additional revenue in millions over the years.
• Involved in user requirements gathering meetings to talk to the users and identify the requirements.
• Developed Reports using Conditional Formatting and Cascading Prompts. Developed List, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Designed specific advanced dashboards in Business Insight Advanced.
• Power Generation: The Project was based on providing Real-Time reporting against OLTP System, Global Demand forecasting, Performance to plan reports, Forecast Analysis for the Power Generation Department.
• Developed package by using the metadata from the OLTP database directly to develop reports for Real Time monitoring.
• Developed global dashboards that can track the sales and units sold across the global and display the metrics in terms of the traffic lights.
• Developed several Crosstab reports, multi-page reports, accounting reports using singletons, master-detail reports, multi-query reports etc for best serving the purposes of the requirements.
• Developed Cubes using Packages, Reports and delivered them to the users for analysis reporting purposes.
• Supply Chain Metrics: The Project was based on providing Inbound Outbound Velocity, Quality Metrics, Line level reports and daily demand forecast reports for the Supply Chain Board.
• Worked on the project as part of the Production support team to implement package and report changes to fix data issues and changes in business logic.
• Designed the Framework Manager Model with all the necessary joins, filters and calculations for reports.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Project Installment: The Project was based on providing Cost Accounting Reports in the areas of Progress Payments, Past Payments, Project Labor and Material Cost for the Oil and Gas Finance Department.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Worked closely with the Data architect to validate the data and recommend changes to the ETL process to incorporate changes in the user requirements.
• Worked closely with the deployment team to ensure a smooth transition from development to production operation and support.
• Warehouse Metrics: The Project was based on providing Inventory Accuracy, Inventory Transactions, and Inventory 6 Sigma Reporting to provide Inventory Inspections.
• Worked on the team as part of the Migration project from Cognos 8.4 to Cognos 10.1.1.
• Experienced in writing complex queries to validate the data and then deliver it for UAT.
• Validated the data using complex test cases to help narrow the discrepancies.
• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, Executive Dashboards, Tabbed reports using Report Studio.

Sr. Cognos Developer

Confidential TX

Responsibilities:

• Migrated and verified reports from Cognos 8.4 to Cognos 10.1 and corresponding packages from Framework Manager.
• Planed and executed the installation and configuration of the Cognos 10.1.
• Executed Cognos 8.4 Reports in Life-Cycle Manager to verify the migration.
• Designed the Logical Cognos Framework Model.
• Created Dashboards for power users using Business Insight (New of Cognos 10.1).
• Planed the Cognos Software Configuration and Version Control approach and best practices.
• Designed specific advanced dashboards in Author Business Report Tool.
• Play a significant contributing role in End User working sessions focus on the interaction with the Cognos layer.
• Helped in the design and configuration of the Cognos Connections Portal.
• Designed advanced Dashboards with the use of Author Business Report Tool for power users.
• Created multiple reports in Report Studio, which are detailed reports for Dashdoard Drill through.
• Developed Prompts which filter data, based on selection and re-prompt the data selected based on Conditional prompts and Filters in the reports.
• Created securities for packages (data, object level securities) and reports.
• Created Portlets on Cognos connection and embedded reports into portlets.
• Experience in developing complex reports using drill-through, prompts, master-detail, burst options, dynamic filtering, etc., in Cognos.
• Responsible for understanding the process from clients about the (BRD’s) business document requirements, providing BI assistance.
• Involved in ETL process with data warehouse team

Environment: IBM Cognos 10.1 (Business Insight, Active Reports, Dynamic Query Analyzer, Report Studio, Query Studio and Cognos Connection, Life-Cycle Manager) IBM Cognos 8.4 (Framework Manager, Report Studio, Query Studio and Cognos Connection)Oracle 9i,oracle10g (SQL, PL/SQL), SQL Server, MySQL, Informatica Power Center/Power Exchange 8x, Oracle 10g, Flat files, Toad, SQL Developer.

Sr. Cognos TM1 Developer

Confidential, Morris Plains, NY

Responsibilities:

• Installed TM1 prospective on User’s machine and performed Troubleshooting.
• Sound knowledge on Work Sheet Functions and Strong Excel skills.
• Proficient in creating complex Active Forms and enhanced the performance of existing Active forms.
• Provided Production Support for Applications and Models in Production.
• Integrated Cognos TM1 with Cognos BI and performed BI Reporting.
• Responsible for assigning user Sign-Ons for the New Users.
• Increased Performance by Monitoring Stats by Cube and TM1 Top Utility.
• Performed Troubleshooting by Diagnosing errors by viewing error log files.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Knowledge on Cognos TM1 Work flow and TM1 Executive viewer
• Experience in guiding users through TM1 Web and TM1 Reports.
• Created relational and multidimensional models using star schema in Frame Work Manager and published packages for reporting activity and deployed packages to the Cognos Connection Portal.
• Set up the security in frame work manager at package level, Query subject level.
• Created dashboard based on the requirements using multidimensional functions as per user requirements for them to make decisions on business users and implemented drill through to dashboards.
• Created multiple reports in Report Studio, which are detailed reports for DashBoard Drill through.
• Developed Prompts which filter data, based on selection and re-prompt the data selected based on Conditional prompts and Filters in the reports.
• Created securities for packages (data, object level securities) and reports.
• Created Portlets on Cognos connection and embedded reports into portlets.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Developed cross tab reports (DMR) with drill through, drill up, drill down and complex reports which involved multiple prompts and multi-queries.
• Involved in designing future state reports, dashboards and scorecards.
• Created ad-hoc reports and demonstrated for business users in Query Studio.
• Generated IQD files to feed Power Play Transformer Models and to create Multidimensional cubes to generate Power Play reports. Created OLAP cubes by using PowerPlay Transformer.
• Developed several Crosstab reports, multi-page reports, accounting reports using singletons, master-detail reports, multi-query reports etc for best serving the purposes of the requirements.
• Developed Cubes using Packages, Reports and delivered them to the users for analysis reporting purposes.

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Query Studio and Cognos Connection),Power Play Transformer 7.4, Erwin 7.3, Power Play Enterprise Server 7, Informatica 9.0 power center, oracle11g(SQL), DB2,SQL server 2005.

Sr. Cognos Developer

Confidential, Pleasanton, CA

Responsibilities:

• Interacted with business users to gather business requirements and designed functional and technical requirements documentation.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Created star schema grouping for better understanding of the model & facilitate multi-fact (cross-fact) reporting.
• Ensuring clear query paths by resolving ambiguous relationships (Role-playing dimensions, loops, reflexive and recursive).
• Created the DMR model using the Cognos Framework manger.
• Created prompts with query macros by including references to parameter maps.
• Extensively working with Stored Procedure Query Subjects in Framework Manager.
• Installed Go Office on Cognos 8 and Developed Cognos reports on MS office.
• Users can manipulate the Cognos Reporting data with MS Office features such as Auto Filter, Comments, Charting, and Formatting using the Cognos Go Office.
• Developed and Designed Chart reports, List reports, Crosstab reports, Master Detail reports, Drill through reports, Drill down reports in report studio that are required for the business users.
• Developed the Dashboard reports using Cognos Report Studio.
• Worked experience with different date functions in Report Studio.
• Wrote the SQL scripts and procedures to load the data into Reporting tables.

Environment: Cognos 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio),PowerPlay 7.2, Cognos Transformer 7.2, Oracle 9i,oracle10g (SQL, PL/SQL), SQL Server, MySQL, Informatica Power Center/Power Exchange 8x, Oracle 10g, Flat files, Toad, SQL Developer.

Cognos Developer

Confidential, San Jose, CA

Responsibilities:

• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Customized Cognos Connection with appropriate reports and security measures
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Developed technical specification document for the offshore team
• Data analyzed and created ad hoc reports using custom PL/SQL
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos 8.2 and 8.3 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio),Cognos Report Net 1.1 MR2 (Framework Manager, Report Studio and Query Studio),Upgrade Manager 8.3, Cognos PowerPlay 7.2, Cognos Transformer 7.2, Power Play Enterprise Server 7, Oracle 9i,oracle10g (SQL, PL/SQL), SQL Server

Cognos Developer

Confidential, Miami, FL

Responsibilities:

• Worked on Framework Manager to import data from heterogeneous data sources and creating models & packages as per business requirement.
• Implemented package, object and data security in Framework Manager.
• Edited the governor settings and session parameters using Framework Manager.
• Developed different kinds of reports using calculations, conditional formatting, exception highlighting, static choices, style variables, dynamic grouping, Conditional Blocks, Dynamic level filters on the reports in different formats (PDF, HTML, XML and Excel) using Report Studio.
• Created reports having filters, multiple Prompts (Select & Search, Value, Date, and Time & Date & Time prompt).
• Created Master-Detail reports which has parameterized detail query or filtered detail query based on the requirements in Report studio.
• Developed drill-through, roll-up and drill-down reports using dimensional data sources.
• Run, viewed and analyzed the reports in different formats, testing the reports for data accuracy and consistency and testing all the reports with Generated SQL and Manual SQL data.
• Tested the reports developed in Report Studio and verified the data in TOAD and comparing the results.
• Helped and trained the users in developing simple reports using Query Studio.
• Resolved the issues in existing reports and successfully documented the changes.

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer), Oracle 9i, MSSQL 2005, TOAD, Windows XP

Cognos Developer

Confidential, Madison, WI

Responsibilities:

• Responsible for the development, care, and maintenance of logical and physical ERWin data models, along with corresponding metadata.
• Involved in Modeling and Reporting against a Warehouse (OLAP) which is in the form of a Star Schema.
• Developed dimensionally model relational for Standard Reporting, Ad-hoc reporting and for Multi Dimensional Analysis using multi layer Approach and Modeling best Practices to meet the reporting requirements.
• Rationalized existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed hierarchies and measures to support Ad-hoc Reporting, Multi Dimensional Reporting.
• Implemented various reporting Techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Conditional Layouts, Dynamic Grouping and Sorting, Master-Detail and secure the reports and folders to specific user groups

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Cognos PP 8, Oracle 10g, Widows XP, Informatica Power Center 8.6, Data Manager,TOAD.

Cognos Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Managed Core Project, Responsible for delivery and resource allocation etc.
• Created imported views and employed relation between views.
• Developed DMR modeling using Cognos 8 Framework manager.
• Enhanced the model, Tested and Created replacement IQD’s using Framework Manager.
• Created Dimension IQD’s and Fact queries in Frame work Manager.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Installed and configured Cognos 8.2 BI and worked with Cognos 8 BI modeling, Report Studio.
• Responsible for Access permission and administrating the server.
• Gathered information like attempted calls, type of call (long distance, local), length of call, originated number, destination number, rates, time of call for creating report for billing of a customer.
• Involved in Creating Content store, installation and Configurations of the ReportNet.
• Implemented Tree prompt and MDX Commands in Cognos.
• Experience in Deployment (Export, Import) using Cognos Connection Portal in Cognos 8.2 and ReportNet.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.

Environment: Cognos ReportNet 8.1/8.2,Framework Manager, Report Studio, Query Studio, Analysis Studio), Transformer, PowerPlay Enterprise Server, Cognos Impromptu, SQL Assistant, BTEQ, MultiLoad, Fast Load, LDAP, Access Manager, IIS, Informatica, SQL Server 2005.

Cognos Developer

Confidential

Responsibilities:

• Installation of ReportNet 1.1 and Framework Manager 1.1, setting Cognos configuration and integrating different components were part of the project.
• Communicated with the business users to comprehend the requirements.
• Designed the reports and catalogs using impromptu as per the requirements.
• Modified Power Cubes by adding new Dimensions, Levels and Measures. Designed Cognos Transformer cube models using reports modeled according to user needs.
• Installed Cognos ReportNet and Framework Manager in an interim environment as a proof of concept.
• Involved in migration of catalogs from Impromptu to ReportNet using Migration Utility.
• Created customized BI reports linking various databases, to meet the user requirements
• Designed models using Framework Manager and deployed packages to the ReportNet Servers.
• Created standard and Ad hoc reports using Cognos Query Studio.
• Developed Templates, standard Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio and Query studio. Provided training on Query Studio to create Ad-hoc Reports.

Environment: Cognos ReportNet 1.1/1.0x,Power Play Transformer7.0,Power Play Web 7.0, Visualizer 7.0,Upfront 7.0, Access Manager, Power Play Enterprise Server, Oracle 9i(SQL,PL/SQL), Windows NT,UNIX, Informatica Power Center 6.1, Oracle, DB2

Jr. Cognos Developer

Confidential

Responsibilities:

• Involved in Installation and configuration of COGNOS ReportNet and Framework Manager.
• Developed various packages using Framework Manager in ReportNet, using different data sources, established relationships in a model, Created IQDs, Created different layers (Database/Business).
• Implemented Star Schema Grouping and Dimension Hierarchy in Model.
• Involved in converting catalogs into ReportNet packages using migration utility.
• Implemented Framework manager security for Data access, Object and Package level access.
• Designed the Model according to the Business Requirements by creating a Presentation Layer.
• Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations.
• Created Cascaded prompts, drill through (from report to report, cube to ReportNet report).
• 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.
• Created Multi-Dimensional cubes using PowerPlay transformer
• Worked on performance tuning and optimization techniques such as load balancing, table weighing and partitioning.
• Responsible for COGNOS software upgrades, patch installation and managing the COGNOS security strategy.
• Performance tuning by analyzing and comparing the turnaround times between SQL and COGNOS.

Environment: ReportNet 1.0(Framework Manager, Report Studio, Query Studio), Impromptu 7.0, Power Play 7.0, PowerPlay Transformer, Impromptu Web Reports, Upfront, PeopleSoft EPM, Access Manager, Power Play Enterprise Server, Windows NT/2000, Oracle 9i.