• 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

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

Worked in a BI team to build a reporting applications and TM1 Cubes for Financial Analysts, Managers and to help the stakeholders understand the status of healthcare through sharing of patient or other healthcare related information using Cognos BI and Cognos TM1 applications.

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

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

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

• PR 339 Data Migration, PR 340 Management Information system MIS are identified within PG100 Transition program among many other Components Projects
• The key objective of PR339 Data Migration project is to ensure the accurate and timely transfer of data from the source Suncorp systems to RACQ and PR 340 MIS is to ensure the accurate the Reports are produced from SAS data sets and Cognos environment.
• Cognos TM1 is used for Budgeting and Forecasting such as for Premiums earned, Un earned Premiums, Claims etc.,

Duties Performed

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

Confidential

Role Cognos Developer

Duties Performed

• Liaised with the Business Analysts for understanding documented Specs and the user's requirement.
• Build the models in Frame work Manager.
• Designed high level service Reports with complex joins and conditions
• Interacted with the BA and PM on a regular basis for resolving issues pertaining to the reports delivered.
• Analysing the ETL process involved for each reporting application.
• Implemented reports for each reporting requirement based on existing data sources/repository and reporting tools set.
• Authorised, tested and released to SIT and UAT production.
• Solved the defect logs assigned from SIT and UAT.
• Ensured high quality ongoing execution/delivery of reporting.