• IT Professional with 6 years of experience as a BI and ERP applications Developer with various Domains such as Retail, Insurance, Banking, Health and IT Service etc.,
• Seeking a position with an Organisation to enhance my skills and abilities in the IT Industry that offers professional growth while being resourceful, innovative and flexible.

• Experience working on BI tools Cognos 7, 8 10 series and OBIEE Oracle Business Intelligence Enterprise Edition
• Experience working on Cognos Admin, FM Manager, Report Studio, Transformers.
• Experience working on IBM Cognos TM1 9.5.1 and TM1 10 Architect, Turbo Integrator, Contributor and Perspectives
• Experienced in Turbo Integrator processes to load and retrieve data from database tables and other data sources, creating complex Active Forms.
• Experience in using Cognos TM1 rules editor to create various calculations and for analyzing data for TM1 planning, budgeting and forecasting
• Experience in Cognos TM1 installation, Creating Servers, Performance Tuning and Automate Common Processes using TI scripts.
• Experience in building various complex BI Reports, Dashboards in Cognos.
• Experience in Data Warehousing Data Migration projects, ETL Oracle and Informatica
• Good Knowledge on Relational Dimensional data
• Knowledge of using the SAP ECC6 IS Retail systems
• In-sight knowledge and thorough understanding of SDLC and STLC
• Good knowledge in Data Warehousing Concepts
• Good knowledge in OLTP System Study, Database Schemas like Star schema and Snowflake schema used in relational and dimensional modeling.
• Good SQL/PLSQL skills and working knowledge with Relational databases such as Oracle, SQL Server, DB2 etc.,
• Extensively used the Toad for DB2, Oracle Sql Developer
• Good Knowledge on Testing Methodologies.
• Experience in using various IT tools Visio, Jira, RQM etc.,

Confidential

Role Cognos TM1 Consultant

Environment Cognos TM1 10.2, BI Cognos 10.2, DB2, Win 7/Unix.

Duties Performed

• Administered the Cognos TM1 reporting environment including security, upgrades, content storage and usage.
• Designed, developed, and implemented Cognos TM1 Applications to forecast portfolio revenues.
• Developed TurboIntegrator TI Processes to load and retrieve data from database tables and other data sources and leveraged the processes to create dimensions, hierarchies, and cubes.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Created complex Active Forms and enhanced the performance of existing Active forms.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Used Replication to copy the Cubes from one server to other server.
• Worked on replicating the cubes between servers, sharing data between cubes and linking asymmetrical cubes.
• Created ETL Extraction, Transformation Loading processes in TM1 TI, performing business rule mappings of relational data into dimensional model.
• Written TI scripts, Business Rules to create Dimensions, Subsets, Attributes, Cubes, and Views and Variance Calculations.
• Optimized the rules using SKIPCHECK and FEEDERS and Created front end structures using TM1 Perspectives.
• Created Groups and Users and assigned privileges to the groups and Implemented Single Sign On functionality.

Confidential

Role BI Developer

Environment Cognos TM1 10.1, Cognos 10, Oracle 11g, Win 7.

Duties Performed

• Analyzed the business and technical specification documents that helped to guide the Report developers.
• Actively interacted with the Business Analysts and Stakeholders to undestand the Requirements.
• Created Meta data models in FM and published the packages to Cognos Connection and developed reports using these packages.
• Developed a dashboard report for the medicare and Medicaid web application to combine nine different reports into one easy to read report that displayed data specific to Provider participation and data submission in the annual payment update program.
• Design, develop, and implement Cognos TM1 10 Applications for Financial Planning and Budgeting models with complex rules.
• Created Turbo integrator processes to retrieve data from data sources and created dimensions and cubes for forecasting.
• Import the data from ODBC and Text files using TM1 Turbo integrator.
• Maintenance of TM1 users, roles, and security.
• Created complex Active Forms and enhanced the performance of existing Active forms.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Created rules to transfer data between cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Used Replication to copy the Cubes from one server to other server.
• Provided the What If Analysis facility to users to get desired output.
• Performed Unit Testing and User Acceptance Testing.

Confidential

Role BI Developer

Environment Cognos 10 Suite, Windows XP., Cognos TM1 Oracle 10g, Windows 2003 7.

Duties Performed

• Developed FM Projects and Published to the Cognos Connection
• Implemented Framework Manager Security for Data access, Object level access and Package access.
• Developed various List and Crosstab reports using different techniques.
• Developed Master detail Drill through reports, Drill up and Drill down reports, multiple prompt reports and cascading prompts in Report Studio.
• Implemented different functionalities using report filters, sorting, multiple queries and conditional blocks.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Used the OLAP cubes for Fm modeling and DMR packages for Report building.
• Validation of reports in database.

Confidential

Role BI Developer

Environment DB2, SQL Server 2005 2008, ETL Informatica, Crystal Reports 7, Cognos 8.4, MS-Office, HP Manager for Incident Management, Jira Defect Tracking tool , Spira Test mgmt tool used for SAP Data Migration project, SAP ECC etc., POS Point of Sales .

Duties Performed

• Worked on DWH project, Developing and supporting the Cognos Reports such as Written Sales, Delivered Sales, Product care reports and many other reports among 300.
• Developed the list and cross tab reports.
• Supported the Cognos Cubes.
• Loading the Budget figures into Transformer cubes from Excel given by Accounting department.
• Supporting the Crystal reports and MS SSAS Hyper Cubes
• Liasing regularly with DBA's for Data control issues and with POS application team, App support team for a regular data feed into DWH test server database and production issues

Confidential

Role BI Developer

Environment Oracle 11g, Win XP, SQL Devloper, Data Stage, Cognos 10, Cognos TM1 9.5.1, MS-Office, RQM Rational Quality Manager , MRM, Guidewire Policy center PC , Billing Center BC etc.,

PR 340 MIS Project

• Developed the FM Models and published to Cognos Server for Report building.
• Developed various List, Cross Tab Reports and Dashboards of Financial, Club and Insurance Reports among 180 Reports Ex: Un Earned Premium for the current month, Unearned Detail, active coverages, paid premiums etc.,
• Created finance i.e. Accounts, Sales order, GL balance etc Cubes, Dimensions in TM1
• Worked on replicating cubes and cube views between servers.
• Involved to replace cubes between servers and to share across the organizations.
• Worked with advanced calculations by creating Business Rules in TM1.
• Worked with turbo integrator to import the data and manipulate the data to cube.
• Worked on Authentication and authorization by creating the TM1 Users and User groups.
• Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using Turbo Integrator.
• Worked with TM1 control objects to secure the TM1 data based on different users and user groups.
• Created Dimensions, Cubes, View's and Applications and applied Business rules to Cubes in TM1.
• Worked on controlling the TM1 cubes based on security and performance.
• Created Chores to schedule the TM1 Turbo Integrator processors.

Confidential

Role OBIEE Developer

Environment Oracle 10g Sql, Pl/Sql packages , OBIEE, Mercury Quality Center, MS package Excel, Word , Win XP

Duties Performed

• Interacting and analysing the requirements with ANZ Business team
• Build the Semantic Layer using OBIEE Modeling tool and OBIEE Answers
• Designed the Subject Areas in Siebel Analytics Administration tool, configuring and deploying to the OBIEE Answers
• Developing the ad-hoc Reports and Dashboards in Answers
• Worked on Oracle ETL Warehouse initially