Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

Sr. Cognos Consultant

Responsibilities:

• Understanding the TM1 Cube built requirements and Post population calculation behind each scenario.
• Taking updates from onsite on daily bases and transferring that knowledge to offshore team.
• Preparing 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.
• Validating data and Comparing 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.
• 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.
• Developed most of the reports along with the team, made them understand the requirements and deliverables.
• 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.
• Responsible for conducting pre sales presentations before C-level executives and winning an account
• Preparing 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.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Validating data and Comparing 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.
• Responsible for lead generation via user group presentations
• Created solutions pertaining to financial budgeting and costing, sales and profitability solutions for a big retail company using Cognos TM1 suite
• Interacted with business and technical users to gather requirements and created design document
• Responsible for creation of metadata models in Framework Manager and cubes in Transformer Responsible for upgrading their Enterprise Planning and Cognos BI Content from Cognos 8.4 to Cognos 10.1.1 and troubleshooting upgrade process
• Developed various dimensional and relational reports by employing lists, crosstabs, charts, union, joins, burst, master-detail, drill through and drill down, report burst techniques.
• Developed Reports using Cognos 10.1.1 Business Insight, Business Insight Advanced Active Reports.
• Developed reports, cubes and dashboards using Cognos Insight, Cognos Insight Advanced and Cognos Workspace.
• Installed Cognos Audit Package and documented the entire process
• Understanding the customer's requirement, analyzing whether the requirements are feasible and checking if they are clear and deployable
• Developed and modified large number of reports sophisticated reports/dashboards/scorecards, analysis and queries to highlight various revenue and expense components of plan, actual and budget data using Cognos Report Studio, Cognos Query Studio and Cognos Analysis Studio

Environment: Cognos BI 10.1/10.1.1/8.4 Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, BIA, Business Insight and Event Studio , Cognos TM1, , Informatica 8.6.1, SQL Server 2008, Oracle 10g and Windows server.

Confidential

Cognos Developer

Responsibilities

• Managed the Cognos Planning and TM1 project as IBM Cognos implementation methodologies standards.
• Planned, and successfully implemented the cross functional projects within defined budgets and timelines.
• Identified and assembled the project resources and directed project team tasks to assure effective project completion.
• Led the overall Cognos Planning architecture in the development and production multi server environments.
• Designed and implemented the migration and upgrading to the current version EP 8.3 to 8.4 in both the environments.
• Designed the analyst models, libraries and application workflow for financial planning and forecasting system.
• Build Business Insight Advance Reports to support the Ad-hoc needs for power users.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Developed and enhanced the merchant forecast and budgeting applications as business needs in Cognos Planning.
• Developed advanced dashboards in business insight for commercial sales department which includes Activity, Sales and Prescriber data.
• Designed and created rolling planning and forecasting process within the existing planning applications.
• Managed all the design, development and implementation strategy and process in Cognos Enterprise Planning.
• Designed functional solution for planning applications in TM1 financial performance management environment.
• Developed and implemented the best practices in designing and development for TM1 financial planning applications.
• Led the TM1 proven solutions in business process, performance improvement, and system implementation.
• Designed and implemented TM1 architecture for the corporate planning system and applications.
• Migrated EP planning models and applications to new Cognos TM1 system.
• Developed and maintained the planning models in TM1 environment.
• Developed Business Insights and Reports Business Insight Advanced and Active Reports using Cognos 10.
• Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle.
• Managed the change and control process in the financial planning solution design and architecture documentation.
• 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.
• 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.
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.
• Customized Reports by writing complex custom SQL.
• Customized Reports using HTML, JAVASCRIPT and SDK.
• Deliver advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting including the bursting of reports globally using Cognos 8.
• Creating 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.

Environment: Cognos BI 8 Suite v8.3 , Windows XP., Informatica v9.1, Cognos Access Manager, Cognos TM1 Oracle 10g, Windows 2003 Server, Unix Shell scripting, SQL Server 2008/2005, Shell scripting, UNIX, Tomcat/Apache, Cognos SDK.

Confidential

Data Warehouse Developer

Responsibilities:

• Meeting the clients for gathering New Business Requirements and existing system changes.
• Writing the SQL scripts and procedures to load the data into Reporting tables.
• Developing the SQL scripts using Teradata SQL Assistance to populate the data in Reporting tables as per the requirements.
• Used Framework Manager to build metadata model, which could be used by Report Developers in the group
• Created and published several packages in Framework Manager
• Developed Standard Templates, which laid a foundation for all reporting needs
• Developed Standard and Dashboard Reports, Charts, Drill through Reports, Master Detail Reports and Burst Reports using Report Studio and Query Studio.
• Created Conditional Blocks, Filters and other prompts for dynamic selection for users
• Scheduled and Run Reports through Schedule Management in Cognos Connection
• Used SQL Server Management Tool to check the data in the database as compared to the requirement given
• Trained users on Query Studio for Ad-Hoc Reporting and involved in documentation
• Developed HTML, CSS enabled report pages for customized report content
• Extensively worked on Analysis Studio to develop multi-dimensional reporting using MDX function for revenue and gross profit analysis reports for each quarter
• Developed MDX scripts for generating reports based on the cubes created for every month
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports
• Built Power Play Reports based on cubes and published to ReportNet Server and maintain the cubes on the series 7 environment
• Deployed Cubes and Reports on PowerPlay Enterprise Server and also Published to Upfront
• Implemented security and granted privileges according to user classes using Access Manager Used LDAP Directory Server
• Load the data into the Reporting tables using the Teradata SQL.
• Creating the DMR model using the Cognos Framework manger.
• Customizing the Cognos portal using the Cognos SDK.
• Preparing the Entity Definition Sheet for Reporting tables.
• Developing Dash Board reports in Report Studio using MDX Functions.
• Creating the Report Studio reports using the MDX functions.
• Creating the Cognos OLAP cube using power play transformer.
• Setting up cardinality minimum, maximum optional , Determents to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Developing the Dashboard reports using Cognos Report Studio and Metric Studio.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environments: Cognos BI 8.3 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio, Metric Designer, Metric Studio Event Studio , Cognos 8.2 Suite, Power Play Transformer 8.3, DB2 8.1, Cognos Access Manager, Cognos TM1 Oracle 10g, Windows 2003 Server, Unix Shell scripting, SQL Server 2005, Teradata, Shell scripting, UNIX, Tomcat/Apache, Cognos SDK, MSAS Analysis Services 2005.

Confidential

Cognos Developer

Responsibilities:

• Designed Developed Multi-dimensional and Relational Models using Framework Manger
• Designed Developed Complex reports using Report Studio, Analysis Studio
• Working with Development leads in design of Cognos Cubes.
• Published the Cognos Query package on to Upfront
• Developed Cognos TM1 Applications, Cubes, Dimensions, Rules, Processes and Chores.
• Using Access manager to Create and Maintain Users.
• Using Configuration Manager to setup the components
• Demonstrating End users, how to use upfront and Cognos Cubes.
• Tuning the performance of the Cognos Cubes.
• Experienced in writing query and cube reporting.
• Publishing Cubes on to the Power Play Enterprise Server.
• Publishing the Impromptu Web Reports on to the server.
• Writing Unix Shell scripts to refresh the Cubes
• Tuning the Adhoc Business Objects reports
• Publishing Business Objects Universes to repository.
• Publishing the Business objects reports on to Broadcast Agent
• Monitoring the daily production ETL loads.
• Monitoring the mirroring process of the ETL load using VERITAS.
• Monitoring the daily cube builds and reports.
• Assisting global users in installing and configuring BI client tools on their workstations
• Creating Mload Scripts to Load the Teradata Tables.
• Creating Tables in Teradata V2 R5
• Modified the Existing mappings to Change the target from Oracle to Teradata.
• Using Clarify tool to synchronize and historical understanding of the tickets on the tools from the business users globally.

Environment: Windows NT/2000, UNIX, Cognos BI 8 Suite Framework Manager, Cognos Connection, Report Studio, Query Studio, Cognos Enterprise Series 7 Impromptu, Power Play Architect, Upfront, Access Manager , Business Objects, Crystal Reports Informatica, DPA, VERITAS and Clarify.

Languages: SQL, Shell Scripting, Oracle 10g/8i, TM1, Oracle E-Business Suite, Teradata.

Confidential

Sr. Cognos Developer

Responsibilities:

• Study the client requirements gather and manage the requirements and assure that the requirements are met in collaboration with the project manager
• Develops functional specifications and system design specifications for client engagements. Assists in enforcement of project deadlines and schedules
• Quickly understands the business issues and data challenges of client's organization and industry.
• Identifies client organization's strengths and weaknesses and suggests areas of improvement
• Incorporate the components of running a fiscally successful project
• Identification and segregation of source systems like Finacle for Corporate Assets Liabilities, Finone for Retail lending, Oracle General Ledger for internal accounts, Calypso for Treasury Bonds , KTP for Treasury Equities, Forex, Derivatives, Options and swaps from the Conducting the UAT with the Business users and Reconciliation of Balances for all the reports.
• Preparation of scope document for the Customer relationship management CRM reports.
• Developing query and mapping for CRM reports.
• Creation of requirement specification documents for CRM reports.
• Created Framework model, giving joins to tables and fields, publishing package.
• Involved in performance tuning and testing reports.
• Responsible for Lead testing efforts Ensure issues are identified, tracked, reported on and resolved in a timely manner Communicate needed changes to development team

Environment: Cognos Bi 8.2/8.4 BI Frame work Manager, Analysis Studio, Event Studio, Report Studio, Query Studio, Cognos Connection , Cognos Series 7 Version 4 PowerPlay Transformer, PowerPlay Enterprise Server, Oracle10g/11g, TOAD 9.0, Java Script, Informatica 8.

Confidential

Cognos Developer

Responsibilities:

• Designed Developed Multi-dimensional and Relational Models using Framework Manger
• Designed Developed Complex reports using Report Studio, Analysis Studio.
• Working with Development leads in design of Cognos Cubes.
• Published the Cognos Query package on to Upfront
• Developed Cognos TM1 Applications, Cubes, Dimensions, Rules, Processes and Chores.
• Using Access manager to Create and Maintain Users.
• Migrated Cognos 7.3 Catalogs and Reports to Report Net1.1 MR2.
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs Folders, Filters, and Macros
• Implemented Third Party Security with AD and use those in creating Data Level, Object Securities in Framework Manager Models.
• Developed Complex Report Studio Reports using Bursting, Tabular Objects.
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.
• Developed SQL Scripts for testing the reports developed Stored Procedures to build the Reporting Database for Exclusive Reporting.

Environment: COGNOS ReportNet1.1 MR2 Framework Manager, Query Studio, Report Studio Power Play Enterprise Server 7.3, Transformer 7.3, Informatica Powercenter 7x, Oracle 9i, SQL Server 2005.