Manager Data

PROFILE

Over ** years of IT experience, including 13 years of Business Intelligence and Data warehouse.

Skilled and thorough in requirement gathering, analyzing, designing, developing, testing and implementing end to end data warehouse and BI solutions.

Strong knowledge and liaison experience of gathering and transforming requirements into deliverables. Worked on several business requirement documents, solution design documents, and detailed design documents in multiple projects.

Successful track record for identifying business cases, translating and documenting business requirements.

Experience in Financial data modeling and reporting using ETL and BI tools.

Strong database knowledge, SQL writing and optimization skills. Involved in tuning SQL queries, ETL workflows and Cognos cubes and reports.

Experience in architecting/developing Cognos Applications – including installation, configuration, securing, administering, modeling, and reporting – (Cognos7,Cognos8, Cognos 10,11, Cognos TM1).

Solid understanding and experience in metadata modeling, professional report authoring, and dash boarding using different BI and reporting tools – including Cognos, Crystal Reports etc.

Experience in building OLAP models, OLTP - Relational and DMR models in Framework Manger in C8x, C10x & optimizing Cubes in Transformer.

Actively involved in creating project documentation, training authors and end users. Interacted with Cognos technical support to resolve technical issues

Strong knowledge and understanding of Data warehousing concepts such as Kimball’s methodology, OLAP, SCDs (type1, type2 and type3), star schema and snowflake schema.

Strong analytical and problem solving skills with quality oral/written/communication/presentation skills.

Skilled in various ETL and BI tools including – Data Manager, Cognos TM1, Cognos Business Intelligence tools, SAP BW 7.3, Oracle OBIEE etc.

EDUCATION Bsc in Computer Science University of Ottawa, 2003

WORK EXPERIENCE

Economical Insurance (Tata Consultance Services) 2020 Jan – 2010 Mar

I was hired by TCS (Tata Consultancy Services) as security expert in Cognos Analytics and edit some report.

Role:

Understand Business Requirement Documents based on Client’s Requirements (Security)

Developed a BI security architecture by maintaining the different IBM Cognos users and roles

Edited some reports gave the user access to which Cognos Group he belongs.

Technical Environment:

Cognos Analytics 11.1, SQL Server, Reporting Database Oracle 12x, Active Directory

Canada School of Public Service 2017 Nov – Oct 2019 CSPS offer courses to different Federal Government Department, and CSPS keeps track of the all the course, classes, dates, number of courses offered etc. There is TM1 model already made however, in that TM1 model, there is lots of deficiencies. I was hired to remove those deficiencies and make TM1 model stream lined with business needs. Also, created few new cubes, and worked on the existing reports, and Framework manager model to see how performance can be improved. complete documentation and provide cross-training. Data was sourced from MS SQL Server, DB2, CSV and Others Sources.

Project: 1

Role:

Developed Business Requirement Documents based on Client’s Requirements

Developed a BI security architecture by maintaining the different IBM Cognos users and roles

Design, develop, and implement Cognos TM1 10.2(Cognos) Applications for CSPS courses

Installed and Configure and upgrade to Planning Analytics 11.X and push it on Production

Wrote a SQL for in SQL Server to retrieve the information in CSV format

Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.

Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.

Scheduled Chores and Monitored Data Loads on a timely manner.

Created different IBM Cognos cube-based analysis using IBM Cognos TM1 Web, Report Studio and Analysis Studio

Crated a TM1 security based on business needs

Worked with Cognos Planning Analtics TM1 Web, Cognos Performance Modeler, Cognos Perspective, Cognos Architect, and Planning Analytics Workspace.

Assisted in upgrading Cognos 10.2 to 11.0.5 - 11.0.12 and finally 11.1

Technical Environment:

TM1 10.2, Planning Analytics 11.0, client: Architect, Perspective (Excel), TM1Web, Panning Workspace and IBM Planning Analytics (Excel), CSV files. Oracle 12

Project: 2

Role:

Assisted in upgrading Cognos 10.2 to 11.0.5 - 11.0.12 and finally 11.1

Developed Business Requirement Documents based on Client’s Requirements

Installed Framework manager, Transformer

Developed and managed relational DMR, Cube models using the Framework Manager model

Developed visualisation data modules in Cognos 11.x

Created some report as dashboards from TM1 datasource

Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Technical Environment:

Cognos Analytics 11.1, IBM Cognos Analytics (Excel), SQL Server, IBM DB2, Oracle 12

Outcome: Successfully implemented TM1 Model and created Cubes, test, and roll out to production to agreed outcomes and time frames

Project: 3

RBI (Restaurant Business International) 2016 Aug – 2017 Jun

Cognos Architect: Acted as a Senior BI resource within an internal IBM Cognos team (Analytics). There is change in clients\IT direction, they are going away form Hyperion cube to TM1(Cognos) solutions for budgeting, forecasting reporting needs. Primary responsibilities include scoping, designing and development of the project, including the implementation of Group wide budget, forecast, reporting and support area cost allocation and general posting creation. Worked closely with the senior management team and the development team in the analysis of the risks that may exist within the project.

Role:

Responding to a change in the client's IT direction, promptly prepared for construction of the planning and forecasting tool, developed a global enterprise-wide application using IBM Cognos.

Helped supply chain portion of RBI system implementation, including requirement gathering, process flow documentation, testing, and training.

Actively participated and contributed to the design of the client's new corporate EDW model

Setup the relationships of the different EDW dimension and fact tables using inner joins (one to many or 1:n relationships) using IBM Cognos TM1

Bridged the relationships of the dimensions and fact tables in the OLAP models using associated surrogate keys column names

Designed complex relational and DMR based Report Studio reports using advanced techniques such as parameter maps, conditional rendering, and the conditional style variable

Successfully converted a functional requirement to technical specification

Developed a BI security architecture by maintaining the different IBM Cognos users and roles that are located in the Cognos BI namespace as well as by setting up complex TM1 security rules using IBM Cognos TM1 Architect

Design, develop, and implement Cognos TM1 10.3(Cognos) Applications for Financial Planning and Budgeting models with complex rules.

Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.

Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.

Scheduled Chores and Monitored Data Loads on a timely manner.

Created different IBM Cognos cube-based analysis using IBM Cognos TM1 Web, Report Studio and Analysis Studio

Worked with Cognos CAFÉ, Cognos TM1 Web, Cognos Performance Modeler, Cognos Contributor, Cognos Perspective, IBM Cognos Insight, Cognos Architect, and Planning

Analytics Workspace.

Technical Environment:

Cognos 10.3,Cognos on IBM Cloud, CAFÉ, Cognos TM1 Web, Cognos Performance Modeler, Cognos Contributor, Cognos Perspective, IBM Cognos Insight, Cognos Architect, Redshift

Outcome: Successfully implemented TM1 Model and created Cubes, reports, test, and roll out to production to agreed outcomes and time frames

Project: 4

Royal Building Products 2015 Feb – 2016 Aug

Application Architect Responsible for creating POC with Dynamic Cube Designer including cube security and calculations. Old cube is designed using MS Analysis Service (SSAS). Successfully designed and implemented TM1 application from scratch and promote the application to production Environment. Troubleshoot Transformer model for reconciliation and make some adjustments in the model. Assisted in designing complex reports and FM Model.

Role:

To document the business process by identifying the requirements

Preparing excellent documentation on business requirements.

Handling various activities of the project like information gathering, analyzing information gathered, documenting the functional or business requirements.

Involved with ETL team for making star schema for dynamic cube

Source system JD Edward, data load to ODS and ETL to EDW

Write SQL script to validate the data in EDW

Write Stored Procedure as update SQL script

Capture all the business logic, in the form of calculations

Implement security to the cube

Created a new model in TM1 for Pipe and Fitting Department

Write complex rules to do currency conversion

Helped in upgrading Cognos 10.1 to Cognos Analytics 11, and tested the security and reports

Assisted designing the complex reports from relational package

Created a DMR model.

Upgraded multiple IBM Cognos BI and TM1 servers by applying a newer IBM Fix Pack release

Created a comprehensive implementation guide

Technical Environment:

TM1 10.2, Cognos CAFÉ, Cognos TM1 Web, Cognos Performance Modeler, Cognos Contributor, Cognos Perspective, IBM Cognos Insight, Cognos Architect, SQL Server, JD Edward

Outcome: Successful management of project delivery to agreed outcomes and time frames

Cognos Developer, OMERS Inc. 2011 Sep – 2014 Oct

Project: 5

Solution Designer: Responsible for supporting multiple business teams including finance, budget, pension, AVC, operations. Provide data warehouse and BI solutions. Design and Develop reporting solutions - Support TM1 Budgeting, Planning and Forecasting application

Role:

Acted as Subject Matter Expert (SME) to end-users by demonstrating strong functional understanding of the applications supported. Provide input and advice on application capabilities and functionality to clients

Troubleshoot end-user system problems when they arise, and provide ongoing support and technical assistance when needed.

Pro-actively identified data issues by monitoring results of end day staging jobs

Analyzed and ensured data integrity to avoid user errors

Write PL/SQL script to validate the data in source system (Oracle)

Make sure the user is following process

Keep track all the bugs

Technical Environment:

TM1 10.2, Cognos CAFÉ, Cognos TM1 Web, Cognos Performance Modeler, Cognos Contributor, Cognos Perspective, IBM Cognos Insight, Cognos Architect, SQL Server

Outcome: Successfully implemented TM1 Model and created Cubes, reports, test, and roll out to production to agreed outcomes and time frames

Project: 6

Description: Designed and Develop TM1 Budgeting, Planning and Forecasting Model for Budget team and created reports

Role:

Explained Lean principles and proper use of Lean tools to employees.

Identified and coordinated lean improvement opportunities leading to improvements in on time delivery metrics while reducing costs and inventory.

Extract the data modeling and the business rules, which are being used.

Designed STAR Schema for Corporate Performance Management Data Ware House

Developed oracle PL/SQL functions and procedures to Populate the Dimension and Fact table of STAR Schema

Created a new model in TM1 to facilitate Headcount planning

Reused/updated current models in TM1 to meet the Compulsory/High priority requirements in document

Worked closely with business stakeholders to understand business requirements.

Involved in loading Historical data from Monthly Reporting Cube to Data Repository using TI Process.

Created new input templates to facilitate the Headcount and Expense planning

Updated BI current reporting to reflect the new reporting requirements

Responsible for converting excel based reports (Template) in IBM Cognos Report Studio

Created few complex reports which has to burst using batch report service

Responsible for report generation (Bursting) using BI tools

Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Created Dashboards to present critical company data in a single report.

Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio

Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.

Used some advanced features like Conditional Formatting in Report Studio

Augmented/enhanced current data feed to facilitate the requirements set out within this document

Deactivated the current forecast model and salary and salary related models replaced with Headcount model

Modified complex Business Logic into TM1 Rules and increase performance by writing feeders

Provided user security to TM1 and end user access (Perspectives)

Responsible for unit, integration and user acceptance test

Created script for unit and integration testing, and assisted in user acceptance test script

Technical Environment:

TM1 10.2,Cognos CAFÉ, Cognos TM1 Web, Cognos Performance Modeler, Cognos Contributor, Cognos Perspective, IBM Cognos Insight, Cognos Architect, SQL Server, IBM Cognos 10.1

Outcome:

Successful management of project delivery to agreed outcomes and time frames

Project: 7

Description: Upgraded 300+ financial reports.

Role:

Migrated 300+ plus reports from IBM Cognos 8.4 to IBM Cognos 10.1

Validated reports for errors

Validated reports for data integrity

Promoted reports to Production

Technical Environment:

IBM Cognos 10.1, SQL Server, Oracle 11

Outcome: Successful upgraded reports

Project: 8

Description: Hierarchy change for TM1 Model. New hierarchy is created in Oracle, and I have to take new hierarchy in BV and push it to TM1

Role:

Coordinated with ETL team explaining the need and logic to make views in Oracle Finance

Validated the views by writing PL/SQL script

Created new Cognos BI package, which included view of new hierarchy

Created new dimension in BV and map it accordingly

Validated new hierarchy in BV

Pushed the new hierarchy to TM1

Made new cube in TM1, which included this new hierarchy

Made a new TI process to load the data to cube

Validated the cube for data

Recreated 30+ managed reports from this new package in Report Studio

Created reports using List, Cross tab, and Chart templates in Report Studio.

Developed standard reports, Charts, Drill-through Reports and Master Detail Reports

Created query prompts, calculations, conditions and Filters.

Created scheduling for several reports

Technical Environment:

TM1 10.2,Cognos CAFÉ, Cognos TM1 Web, Cognos Performance Modeler, Cognos Contributor, Cognos Perspective, IBM Cognos Insight, Cognos Architect, SQL Server, IBM Cognos Business View point 10.1,IBM Cognos 10.1

Outcome: Successful created new TM1 cube

Project: 9

Description: Upgraded IBM Cognos BI 8.4 to 10.1.

Role:

Upgrade IBM Cognos BI 8.4 to 10.1 in DEV, UAT and PROD server

Upgraded Framework Manager to 10.1 in DEV and UAT

Did end to end testing, if any reports are broken

Validated all the data source

Validated security

Technical Environment:

IBM Cognos 10.1, IBM Cognos 8.4, Framework Manager 10.1

.

Outcome: Successful upgraded the IBM Cognos BI and Framework Manager

Project: 10

+

Description: AVC Predictive Analysis: This project uses SPSS and BI toolsets in conjunction with AVC BI data source, merges data with other data sets to predict “who” to target, “how” to contact and what’s the level of “confidence” to get a desirable outcome

Role: Over the duration of the project, I was responsible for the following activities:

Designed the ETL processes to load data from Oracle, Flat Files, and Excel files to staging database and from staging to the target Data Mart.

Designed and implemented the most complex data transformation processes and Data field mapping

Used Transformations while creating the mappings to load data from one schema to other schema

Involved in Requirement gathering from Business Users

Installed & configured the Cognos 10.1.1 BI in a distributed environment, Administering the Servers, Troubleshooting, and Performance Tuning

Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports

Reversed engineered multiple discovered (Oracle) reports and recreated in Cognos Report studio.

Created Various Dashboard Reports for different Business Areas based on TM1 Cubes and Relational Packages

Designing the architecture for the TM1 model to act as part of the overall pension operation system.

Creating T.I. processes, cubes, dimensions, rules, and other TM1 applications which were necessary for the implementation of the pension operation system

Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects

Technical Environment:

TM1 10.2,Cognos CAFÉ, Cognos TM1 Web, Cognos Performance Modeler, Cognos Contributor, Cognos Perspective, IBM Cognos Insight, Cognos Architect, SQL Server, IBM Cognos Business View point 10.1,IBM Cognos 10.1

Project: 11

Description: Worked on multiple projects

Implemented Cognos BI security utilizing Active Directory Groups

Responsible for BI reports for different application Finance, Budget and Pension

Responsible for designing, developing and implementing multiple OLAP and relational reports as per business requirements.

Responsible for tuning environments, applications and reports. Assist users in defect resolution. Resolve issues resulting from User Acceptance Testing (UAT).

Responsible for maintenance of multiple TM1 applications - Finance, AVC, Pension and Budget and data warehouse.

Reviewed business requirements, designed and developed solutions to business problems using Cognos BI, CognosTM1, Cognos Business Viewpoint, SQL Server and Oracle database.

Responsible for Architecture and Security of Cognos BI products. Worked in a team to design a road map for infrastructure and software upgrade.

Installed, configured multiple instances of Cognos 10.1 BI Environment for Development, UAT and Production. Responsible for administering Cognos BI application and Servers.

Technical Environment:

TM1 10.2,Cognos CAFÉ, Cognos TM1 Web, Cognos Performance Modeler, Cognos Contributor, Cognos Perspective, IBM Cognos Insight, Cognos Architect, SQL Server, IBM Cognos Business View point 10.1,IBM Cognos 10.1

Outcome: Successfully maintained Cognos B1, Business Viewpoint and TM1 support.

Support Engineer IBM Canada Inc 2010 Feb – 2011 Sept

I am to lead the work of business intelligence team members to conceptualizes, author and implement BI solutions. My responsibility was for business intelligence and data warehouse analysis, design, development, implementation and support for multiple big companies like GAP, Nike, GAMC, National security.

Liaising with the Cognos Development, Sales and Field teams to ensure the client’s continued success with the Cognos products .Through providing seamless support, achieved ninety percent support renewal target worth five million dollars as team. Currently, I am recognized as Subject Matter Expert for Report Design issues and collaborate with analysts across Cognos 8 BI support team.

Support Engineer for Global 24 x 7 team

Respond to Production Down issues for IBM Cognos worldwide after hours

Triage and assign the issue to relevant IBM Cognos team

Performed third level support to resolve problems and issues of Cognos 8 BI clients

Document, Follow up and update all the Senior managers regarding status of the issues

Communicate IBM Cognos Analyst worldwide to ensure seamless transfer of ownership of the issues

Create and edit ‘Knowledge Centered Support’ document, mentor Co-Ops students, help co-workers for any repot design and modeling issues.

Setup test case to recreate the issue in-house and collaborate with IBM Cognos Development to come up with quality solutions

Technical Analyst (Team Lead) IBM Canada Inc 2008 May – 2010 Jan

I was responsible for successful delivery of Business Intelligence technology initiatives to some high profile customers. Provided hands-on technical knowledge as well as managed client relationships within context of individual role. Handled red list accounts and escalated issues. Managed project queues for multiple products, each with different enhancement requests and bug reports from multiple sources, tracked progress and prioritized with multiple linked levels of granularity. Helped identifying hot accounts and consolidated those accounts to deliver heuristic approach to find solution. Managed weekly and day to day scheduling for the analysts.

Senior Technical Analyst Cognos Canada Inc 2006 Mar –2008 May

Report design and Metadata Modeling for IBM Cognos 8 business Intelligence software

Tasks performed:

Developed business requirement and project scope for report design and metadata modeling issues

Provided feedback regarding BI solution capabilities of report design and metadata modeling

Revised existing reporting requirements and upgrade issues

Consulted with customer business analyst and discuss Reporting and metadata modeling requirement and compiled validates and documented business requirements.

Designed and developed business intelligence component using IBM Cognos 8 BI

Dimensionally modeled Relational and Relational models using Framework manger

OLAP models using Transformer and TM1 Cognos 8 BI

Develop new reports in TM1 and install and configured new TM1 environments

Configured and apply security of TM1 and Cognos BI interoperability

Installation, Configuration, Security and upgrade for IBM Cognos 8 business Intelligence software

Provided support for installation, configuration and upgrade for Cognos 8 BI and Report net involving different Operating Systems, Application Servers, Web servers and databases

Applied Cognos security linked with different Security providers ( LDAP, Series 7, AD, Site Minder)

Designed and developed a metadata repository to capture requirements, business rules, data warehouse objects, ETL objects and data source objects.

Technical Environment:

Cognos 8 BI, Reportnet, Webshpere, Weblogic, Oracle application server, Windows, UNIX, SQL server, Oracle, DB2, Informix, Data manger, IIS, Apache

Series 7 for IBM Cognos business intelligence

Planned, installed and configured impromptu report server, power play

Implemented IWR report and power play cubes

Designed and implemented Cognos security using Cognos access manager, linked Cognos user with NTLM logons

Automated cube builds and cube distribution using Cognos script editor and dos macros

Provide knowledge transfer and support to BI and Series 7 developers

Interfaced with Cognos Development to identity product defect and document defect

Technical Environment:

Series 7.3 and 7.4: impromptu web reports, power play enterprise server, Transformer, power play web reports., Access manager under windows and UNIX

SAP BW Training

Took 10 weeks to SAP BW in class training

Implemented BW InfoCubes, Data source, Info sources, Transfer Rules, Data Transfer Processes (DTPs)

Updated Rules, Info packages, Info package groups, Info objects, ODS, DSO, Process Chains

Reporting Tools: BEx Queries, WEBI Reports and Dashboards

Certification Courses

IBM Certified Report Developers Administration and Security

IBM Certified Designer FrameWork Manager Modeling

IBM Certified Administrator Relational and Dimensional Reporting

TM1 Developer

TM1 Administrator

Web Developer, Learning Library Inc, Ottawa 2003 Sept – 2006 Mar

Responsibilities range from front-end user interface design, to back-end relational database design and development and testing

Developed advance SQL queries as well as created Stored Procedures and Views on MS SQL Server 2000 based technologies.

Created Microsoft Analysis Services OLAP Cubes.

Incorporated third party software in the web application.

Used HTML, JavaScript, XHTML, Active Server Pages [ASP], ActiveX Data Objects [ADO], SQL and VBScript.

Database design and normalization via ER analysis.

Providing product support for escalated technical problems to clients and students.

Senior Technical Specialist, Hewlett Packard 2003 Jan –2003 Sep

Provided second level technical support to MCI, US based one of the largest provider of voice and internet solutions.

Resolved Windows/Unix operating system issues experienced by MCI employee via telephone/email

Provide configuration support for remote tools: Nortel VPN, RasNet, Access Manger, Appgate, Citrix etc.

Provide installation and configuration support for several main frame applications: Arbor, Hummingbird, ETMS etc.

Supported Windows Server 2003 DNS, Active Directory, and DHCP services.

ACHIEVEMENTS

Received bonuses for last three ( GDP: Growth Driven Profit Sharing) years based on Personal Business commitments’

University of Ottawa Admission Scholarship and Differential Tuition Fee Waiver for 1995 - 96.

Arnold Smith Commonwealth Scholarship for 1997-98

REFERENCES

Available upon request.

v

Contact this candidate