santanu manna

SANTANU MANNAMOBILE NO-(+1)262-271-6610EMAIL: [email protected]

PROFESSIONAL SUMMARY:

Having 7+ year of total IT experience in the Business Requirements Analysis, Application Design, Development and Implementations of DataWarehousing, web Based Applications.

KEY SKILLS:

Have good knowledge and experience in the areas of Data Warehousing Concepts & Report development.

Proper understanding of Star schema/Snowflex schema and Data Modeling. Have work experience in OBIEE 10.X,OBIEE 11g,OWB,Oracle and Teradata. Extensive expertise at developing and scheduling ad-hoc and canned Analytics

Reports using OBIEE/BI Answers, Dashboards. Responsibilities included Building of RPD application design for Physical, Logical,

and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher, testing and deployment.

Translating business requirements into logical business dimensional model. Defining various logical subject areas and organization of Presentation Layer metadata, Understanding and defining key metrics, dimensions, hierarchies and attributes.

Developed various reports based on different Views in OBI Answers and developed Dashboards.

Good knowledge of how business processes work and interact. Proficient in using the following tools: Oracle BI Administration, Oracle BI

Answers, Oracle BI Dashboards. Have Knowledge of Basic ETL process. Self-reliant and Proactive to identify and understand business problems and

develop solutions.

PROFESSIONALEXPERIENCE:

Organization Designation Duration TCS I.T Analyst ( as a

OBIEE Consultant) Apr-2008 To Till date

PROJECT PROFILE:

Project #1 Project Name Global Service Visibility-Cost To ServeClient GE HealthcareRole OBIEE ConsultantOrganization TCSDuration Aug 2014 to Till dateEnvironment(with skill versions)

Languages: SQL Database: TeradataTools: Informatica, Teradata BTEQ and OBIEE 11gO/S: Windows 2003 Server and HP-UNIX

Description:

It’s a Reporting tool to serve the needs to service visibility of each selling product across globe by GE Healthcare. It has three basic type of analysis.

1) Event Analysis: It contains Labor Only and Material Analysis.2) System Analysis: It contains System level cost, Product Group and Product Cost trending 3) Material Analysis: It contains Material Usage data, Part level price-mis-volume analysis and QTD/YTD financial analysis.

This application offer details of system under warranty and system under contract. It is able to show details of FOA/FOI [failure on arrival and failure on install] .

This tool consist summarized as well as detail view of profitability, reliability and warranty of services of product across different business unit and region in an interactive way to the end users.

Role Involved:

Used OBIEE admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.

Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations and calculations as per business requirement.

Tested and validated the unit test cases Organized and customized the presentation layer in a format that is easy for end

user to use as basis for reporting Worked on creation of repository variables and session variables. Worked with the Security settings in OBIEE Admin Tool to set up users, groups,

access privileges. Designed and developed interactive navigational drill down reports in OBIEE

Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.

Using the Presentation Variable in prompts Report filters.Using the Presentation Variable in prompts Report filters.

Project#2

Project Name Global Finance Dashboard.Client GE HealthcareRole OBIEE Consultant Organization Tata consultancy servicesDuration Aug 2014 to Till dateEnvironment(with skill versions)

Languages: SQL Database: Teradata, Hyperion EssbaseTools: Informatica, Teradata BTEQ and OBIEE 11gO/S: Windows 2003 Server and HP-UNIX

Description:

This Reporting solution will help in financial analysis for GE Healthcare. At present financial data are scattered among various essbase cubes and teradata. This application will integrate different source to a single platform and create report based on those which will help user in their analysis.

This application will present 1. Measures like Actuals, Estimates and different kind of variances.2. Rolling Average by region, channel and modality3. Financial reports of modality based on different regionAnalysis based on only Base Cost for different modality

Role Involved:








Project #3 Project Name Product Substance ReportingClient GE HealthcareRole OBIEE Consultant

Organization Tata consultancy servicesDuration Mar’2012 to Jul’2014Environment(with skill versions)


Description:

Business Intelligence (BI) PSR application will collect, send and make available to users about shipped data for product regulatory reporting and product REACH, RFP & Battery reports. It provides a list of all Product & Battery data according to the requested filters in OBIEE. The detailed report is a “superset” of all data used across country battery data. We reviewed current and potential regulations to identify data for the detailed report. The report is designed to provide battery data when a country’s summary report is not available. Unlike the detailed report, each country summary report is uniquely formatted and may present data differently from other countries. Country Summary Reports use the data available for the detailed report to summarize data as required by a specific country.

Role Involved :








Project #4 Project Name Trackwise BI ReportingClient GE HealthcareRole OBIEE Tech LeadOrganization Tata consultancy servicesDuration Jun’2010 to Feb’2012

Environment(with skill versions)


Description:

The Trackwise BI Reporting Tool is configured to generate the intended reports as defined in the user requirements. Data from the Trackwise application flows into the BI environment (Teradata Database). The Trackwise BI Reporting tool is hosted in the BI environment, which in turn is configured to generate custom reports. The project will align with the monthly BI Release for pulling data for reporting purposes. The Complaint Handling Unit, Quality and Manufacturing Engineering, CAPA Leaders, Regulatory Managers and Risk Management team use this tool to generate reports. The intended use of the Trackwise BI Reporting Tool is to provide a robust reporting mechanism for trend analysis, metrics and Ad Hoc queries of the following data from the Global TrackWise system:

Complaint Records Risk Assessment RecordsAdverse Event Reporting Records/SubmissionsInvestigation RecordsCAPA RecordsNon-Conformance Records

Role Involved :





access privileges. Implemented Data level and Object level Security. Designed and developed interactive navigational drill down reports in OBIEE


Using the Presentation Variable in prompts Report filters. Using the Presentation Variable in prompts Report filters.

Project #5 Project Name Account Payables Reporting ToolClient CUMMINS USARole OBIEE Developer

Organization Tata consultancy servicesDuration Sep’2009 to May’2010Environment(with skill versions)

Languages: SQL Database: Oracle EBSTools: OBIEE Apps, DACO/S: Windows 2003 Server and HP-UNIX

Description:

This project deals with Account Payables (AP) module of Oracle EBS.It was out of box implementation.

Role Involved :








Creating Job chain in DAC of Informatica Maps.

Project #6 Project Name Global Services Integrated Sales Reporting ToolClient British TelecomRole ETL and Report DeveloperOrganization Tata consultancy servicesDuration Jan’2009 to Aug’2009Environment(with skill versions)

Languages: SQL,PL/SQL Database: Oracle 10gTools: OWB and OBIEE 10gO/S: Windows 2003 Server and HP-UNIX

Description:

Sales Reporting deals with processing high data volumes of call data to enable BT product Managers and end customers to view their call details and summary OBIEE reports through web access integrated with GS portal. Sales data would be extracted from mediation servers. The data needs to secure at data level access for the customers compliance with BT security and BT Branding.

Role Involved :



Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting

Worked on creation of repository variables and session variables. Worked with the Security settings in OBIEE Admin Tool to set up users, groups,




Used OWB to create ETL maps according to provided mapping sheets. Tested and validated the unit test cases

Project #7 Project Name Retail Of-com. Reporting ToolClient British TelecomRole ETL and Report DeveloperOrganization Tata consultancy servicesDuration Jul’2008 to Dec’2008Environment(with skill versions)

Languages: SQL,PL/SQL Database: Oracle 10gTools: OWB and OBIEE 10gO/S: Windows 2003 Server and HP-UNIX

Description:

The Office of Communications - Ofcom - is the regulatory authority under the Communications Act. In addition, it has concurrent authority with the Competition and Markets Authority for the telecoms sector. Ofcom Reporting deals with processing high data volumes of call data to enable BT product Managers and end customers to view their call details and summary OBI reports through web access integrated with Retail portal. Ofcom data would be extracted from mediation servers. The data needs to secure at data level access for the customers compliance with BT security and BT Branding.

Role Involved :



Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting

Worked on creation of repository variables and session variables. Worked with the Security settings in OBIEE Admin Tool to set up users, groups,




Used OWB to create ETL maps according to provided mapping sheets. Tested and validated the unit test cases

Project #7 Project Name Initial Learning ProgrammeClient TCS InternalRole TraineeOrganization Tata consultancy servicesDuration Apr’2008 to Jun’2008Environment(with skill versions)

Languages: SQL,PL/SQL Database: Oracle 9iO/S: Windows XP Server and UNIX

Description:

Tata Consultancy Services conducts Initial Learning Programs for its new-joiners. This program is intended for smooth transition of its new-joiners from academics to professional

arena. This program consists of not only technical courses but also courses on various soft-skills that are essential in IT industry.Carried out the following activities:Undergone trainings in software development.Undergone trainings in TCS specific soft-skill courses.

Role Involved :

Understanding Software Development Life Cycle. Program designs in both structured and object-oriented approach using Doctor's

Scheme (a programming language developed by MIT in 1972 and used by TCS for initial trainings).

Designing of DFDs and ERDs for the same above mentioned project. Designing the UMLs viz. Class Diagram, Sequence Diagram and Object Diagram for

the Route management system project in object-oriented approach. Learning the basics of Relational Database Management System Completed the courses on various soft-skills viz., technical documentation, Client

Communication, Corporate ethics, Industrial Etiquettes.

santanu manna

Documents