Madan Sharma Email and Phone Number

->Development of TurboIntegrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.->Proficient in Multi dimensional modelling by using best practices and using distinct feature like reusable dimensions,reporting cubes->Good experience in writing rules ,conditional feeders.->Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using TurboIntegrator->Automation of security and dataload process to Users such that model is flexible for Super Users to maintain.->Worked with Implementation Partner as a developer and functional analyst in migration project from TM1 10.1.1 to 10.2.2 and ensure feasibility of design and clarify user requirements.->Created ETL (Extraction, Transformation & Loading) process with the help of implementation partners using TurboIntegrator in by mapping relational data into dimensional model.

TM1 10.1.1->Development of TurboIntegrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.->Proficient in Multi dimensional modelling by using best practices and using distinct feature like reusbale dimensions,reporting cubes->Good experience in writing rules ,conditional feeders.->Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using TurboIntegrator->Automation of security and dataload process to Users such that model is flexible for Super Users-> Worked with Implementation Partner as a developer and functional analyst in migration project from Planning 10.1 to TM1 10.1.1 and ensure feasibility of design and clarify user requirements-> Created ETL (Extraction, Transformation & Loading) process with the help of implementation partners using TurboIntegrator in by mapping relational data into dimensional model.Cognos Planning 10.1->Expert Developer in Cognos Enterprise Planning: Analyst, Contributor, Contributor Add-In for Excel, Contributor Administration and Access Manager->Possess a good knowledge in Planning Manager to build the data flow diagram for a particular application.->Data reconciliation from source ERP system to Final Profit and Loss Statements

->Implementing and deploying Cognos Planner for budgeting and planning solutions. Translate the business requirements into skeleton model (D-Lists and Cubes).->Performed monthly and quarterly rollover activity as part of Monthly and quarterly reporting meeting. ->Expert Developer in Cognos Enterprise Planning: Analyst, Contributor, Contributor Add-In for Excel, Contributor Administration and Access Manager->Possess a good knowledge in Planning Manager to build the data flow diagram for a particular application.->Data reconciliation from source ERP system to Final Profit and Loss Statements->Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver8.0/7), designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director.->Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup stages in accomplishing the ETL Coding.->Designed and created custom reports using Oracle Discoverer for support of conversion from corporate legacy system to Oracle ERP Reports covered financial modules such as GL, Payables, Receivables, Project Contracts, and Order Management. ->Administered Oracle Discoverer for new changes and monitoring the production issues and resolving them.