SUMMARY

• Around 8 years of IT experience in Software Application Design, Development, Testing, Documentation and Maintenance of Business Intelligence solutions, OLAP tools, Data Warehousing (DW), Database, Client/Server applications with expertise in CognosTM1/BI.
• Experience in various Cognos Tools - Cognos 8.2/8.4/10/10.1/10.2. Including Framework Manger, Report Studio, Analysis Studio, Query Studio, Transformer, and Business Insight, Business Insight Advance, Active Reports and Administration.
• Experience in full life cycle project development, including design, coding, testing, implementation and ongoing production support for Cognos10.x/8.x products.
• Designed & Developed TM1 Processes, Dimensions, Cubes and Applications.
• Extensively worked on Cognos 10 Framework Manager - Creating Metadata Models.
• Framework Manager - Importing Meta Data from Different Sources, Dimension Hierarchy, Star Schema Grouping, and Packages.
• Extensively worked on Power Play Transformer - designing and building the Power play cubes using Transformer and developing the dashboard reports by using cube as data source.
• Sound Skills in Report Authoring in Report Studio - Custom functionality in prompt page and Report Page using JavaScript in HTML ITEMS and Conditional Blocks to develop Hide and Show scenarios.
• Expert skills in developing complex reports using Direct SQL (with Clause) and Co-related Queries, Sub Queries and Nested Sub Queries in Report Studio.
• Developed complex layouts using List, Cross tabs and Chart reports using Master-detailed relationships and Drill-through functionality.
• Having good exposure OLAP Technologies, knowledge in OLTP System Study, Database Schemas like Star schema and Snowflake schema used in relational and dimensional modeling.
• Installation and configuration of Cognos 10 Business Intelligence.
• Designed, developed Cognos data models and published Packages in Framework Manager to Cognos 10 portal.
• Involved in migration of the applications from Cognos Series 8 to and Cognos 10.
• Automated various activities in Cognos using Scheduler and event studio.

TECHNICAL SKILLS

BI (OLAP) Tools: Cognos 8.x and 10.x BI Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection), Cognos Content store, LDAP Server, SDK, Deployment Tool, MDX functions, Cognos TM1 9.5, 10.1

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005/2008, Teradata, DB2, Sybase, MS Access.

Programming Skills: C, C++, Java, VB.Net, JavaScript.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. Cognos Consultant

Responsibilities:

• Participated in meetings with client to understand and gather new technical requirement and conducted feasibility tests for the new requirements
• Created most of the Documents like Technical Document, LLD, TM1 and BI integration document, Work flow Document, Project Plan, Document on report format and Standards, etc.
• Managed and assigned work to onshore and offshore resources.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Delivered advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting (including the bursting of reports) using Cognos 10.1.
• Handled Critical situations in QA and Production Support in the final Stages of the project.
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
• Designed and implemented TM1 architecture for the corporate planning system and applications.
• Worked extensively in development of Framework Manager Model for development of dashboard style complex reports like Dashboards, Region Enrollment, Division Enrollment, Milestones and Management Reports throughout the project.
• Created solutions pertaining to financial budgeting, planning and forecasting, sales and profitability solutions for companywide analysis using Cognos TM1 suite.
• Provided technical guidance and solution to junior developers in the team
• Managed data load, batch monitoring, cube refresh schedule and production support activities
• Planned and conducted user training sessions for super level user. Trained users on TM1 Perspective, Cognos Query Studio and Event studio.

Environment: Cognos BI 10.1 (Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Business Insight and Event Studio), Cognos TM1 10.1.1 (Architect, Contributor, and Perspective), Informatica 8.6.1 and Oracle 10g.

Confidential, Arlington, TX

Sr. Cognos BI Consultant

Responsibilities:

• Upgrading Cognos 10.2 from Cognos 8.4 on two different environments. Designing, infrastructure, Installation, configuration, Security.
• Integrated the security using LDAP using Cognos and OAM using Oracle structure.
• Created functional and technical documents by gathering business requirements.
• Installation, configuration, Security, web server configuration. WAS configuration.
• Working on the production support issues (performance issue, missing data, software compatibility problems, image display issue, pdf, excel formats issue etc.).
• Analyzed the existing system & reporting requirements and interacted with Business users and understood business requirements before developing the Framework Models and different types of reports using Report studio.
• Creating Projects and Importing Meta data using Framework Manager.
• Generating various reports List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill through Reports.
• Created very complex reports using formatting multi-page reports, drill-through, prompted reports, multiple report structures on one page, variables and conditional formatting.
• Worked with Job Scheduling, Report Bursting and Distribution lists.
• Worked in Framework Manager to add Multilingual Data reports using Parameter maps, session parameters and Macros.
• Creating Public Folders, Private Folders, My pages and custom views in Cognos Connection.
• Scheduling, Distributing Reports and Administering Reports.

Environment: Cognos BI 10.2/10.1/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Business Insight and Event Studio), Powerplay, Informatica 8.6.1, SQL Server 2008 and Oracle 10g.

Confidential, Torrance, CA

Sr. Cognos Consultant

Responsibilities:

• Involved in entire Project life Cycle from requirement gathering to development of the reports and successful Go Live.
• Involved in Designing BI planning DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Examined relationships and cardinality in Framework manager.
• Designed ETL specification documents for all the projects.
• Designed and Developed ETL using InformaticaPowerCenter8.6/7.1.and UNIX shell scripts for the large data loads from OLTP systems to Staging database system.
• Took updates from onsite on daily bases and transferred that knowledge to offshore team.
• Understood the TM1 Cube built requirements and Post population calculation behind each scenario.
• Prepared documents for the integration of TM1 and Cognos BI and shared to onsite and offshore team.
• Created a project plan and made team to working accordingly to reach the goal on time.
• Involved in developing TM1 input page in .ASPX and understanding the Code behind it.
• Developed a Java Script to pull the TM1 input Page to Cognos and also java script for handshaking of TM1 and Cognos BI.
• Validated data and Compared in TM1 prospective excel and in TM1 web with Cognos Report Studio.
• Solved most of the Complex part in TM1 and Cognos BI integration.
• Training resources on TM1 and Cognos.
• Developed most of the reports along with the team, made them understand the requirements and deliverables.
• Responsible for conducting pre sales presentations before C-level executives and winning an account.
• Responsible for lead generation via user group presentations.
• Created Framework Manger Models and created and published packages into the portal.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Created Multi-dimensional reports by implementing Multi-Dimensional.
• Cubes using Power Play and Transformer.
• Provided security for Cubes of various User classes. Used Date.
• Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Created cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.

Environment: Cognos BI 10.1/10.1.1/8.4 (Framework Manager, Report Studio, Cognos Connection, Query Studio, Analysis Studio and Event Studio), Cognos TM1, Informatica 8.6.1, SQL Server 2008, and Oracle 10g.

Confidential, Glendale, CA

Cognos Consultant

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Managed the Cognos Planning and TM1 project as IBM Cognos implementation methodologies standards.
• Designed functional solution for planning applications in TM1 performance management environment.
• Developed and implemented the best practices in designing and for TM1 planning applications.
• Led the TM1 proven solutions in business process, performance improvement, and system implementation.
• Migrated EP planning models and applications to new Cognos TM1 system.
• Developed and maintained the planning models in TM1 environment.
• Involved in Designing DMR models with Relational Data and Relational models using Framework Manager and deployed packages to the Report Servers.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Used Governing techniques for improving performance of the Query.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.
• Created Framework Manger Models and created and published packages into the portal.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Customized Reports by writing complex custom SQL.
• Customized Reports using HTML, JAVASCRIPT and SDK.
• Created IQD files from Report net and designed Power play models in Transformer.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in building the complex cubes and optimizing the cube creation.
• Built Multidimensional Cubes, Sub cubes for user groups using PowerPlay Transformer.
• Created and managed jobs and schedules.
• Published cubes and OLAP reports using Upfront Server.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Created Transformer models and generated OLAP cubes for multi-dimensional analysis of the data.

Environment: Cognos BI 10.1/10.1.1/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, OLAP, HTML, IQD, Cognos TM1, Informatica 8.6.1, SQL Server 2008, Oracle 10g and Windows server.

Confidential, Seattle, WA

Cognos Developer

Responsibilities:

• Involved in analyzing and gathering requirements and provide input into project timelines and ensure adherence to project timelines.
• Designed, implemented technical solutions that address complex business requirements and served as a main technical support and perform root cause analysis for problems experienced within all the Cognos reports/Models.
• Designed and developed/modified the Framework Manager model packages defining the cardinalities and namespaces.
• Designed and developed complex Cognos reports and dashboards per business requirements.
• Created list reports and cross tab reports, charts, Maps and drill through reports. Created complex filters, Conditions and complex financial calculations for developing the reports using report studio as per the user requirements.
• Created Multi page reports with grouping and sorting, creating -master detail relationships.
• Used Conditional formatting to discard unwanted columns in the report using style variables.
• Used render variable on some report pages and also on List, Bar Graphs to render the list and the graph based on the user selection.
• Used Conditional blocks to display the graphs, crosstab and list based on selection of a value from the value prompt.
• Implemented Security prototype for Cognos business intelligence environment incorporating row level, object level, data level and package level and report level security.
• Identified and implemented process improvements in the existing Cognos reports/dashboards.
• Performed scheduling of the reports and created report view of a report for the users.
• Deployed reports and packages from development to test and from test to production using Cognos administration.
• Worked with Cognos support team and Involved in production support by resolving users problems.
• Supported unit testing, integration testing and user acceptance testing.

Environment: Cognos 8.3 BI (Report Studio, Query Studio, Framework Manager, Connection), Power Play Transformer, Power Play Windows, Access Manager, Oracle 10g/9i, Erwin 4.0, 7.1, SQL Server 2000, Flat Files, Windows NT.