Lalit Mohan

(OBIEE Architect)

Michigan, USA

+* (908) 456- 2147

ade5sn@r.postjobfree.com

Career Summary:

** ***** ** ** ********** in OBIEE (12c, 11g, 10g), BI Publisher, Cognos, Tableau, Power BI, ETL (Informatica), SQL, Dimensional Modelling, Performance Tuning, Data Quality.

Experience Summary:

Working experience on OBIEE 12c, 11g, 10g executing end to end implementations. Experienced on installation of OBIEE 12c, 11g on windows and UNIX machines. Experienced in providing end to end solution for OBIEE.

Experience in Data Warehousing, data modelling, Informatica.

Experience in requirement gathering from business and doing an extensive analysis and leading to data Modelling on multiple projects.

Experienced in creating functional and technical design documents for OBIEE Implementation while working on multiple projects

Experienced on working on different versions of OBIEE 12c, 11g, 10g also worked previous versions.

Experienced working on OBIA, in different modules such as retail, HR, Financial Analytics, supply chain, Order management (DAC, Informatica and OBIEE)

Experienced in configuring the OBIEE Repository (Physical, Business and Presentation Layer, Variables, Initializations blocks, Multiuser development Environment etc).

Experienced in Developing dashboards, prompts and reports, Views in OBIEE Answers.

Experienced in implementing Object Level Security and Data level security in OBIEE.

Experienced in developing Unit Test Scripts for the reports and testing them after reports development.

Experienced in creating Mapplets, mappings, tasks, workflows in Informatica.

Experienced in monitoring data extracts (Incremental and Full Load) and Data Warehouse Refresh Loads (ETL) in Informatica.

Experienced in enhancing the pre-existing mappings in ETL tool Informatica.

Experienced in installations and configuration of Siebel analytics 7.8 and Informatica7.1.2, 8.1, 8.6, 9.5.1on client machines.

Experience in Data Warehouse Application Console.

Experienced in SVN for versions controls

Experienced in HPQC

Experienced in UNIX

Experienced as a Team Lead handling a team of up to 9 resources while handling a data warehouse project (Onsite and Offshore Model).

Handling multiple assignments at the same time as a Lead and expert.

Planning, monitoring and training the resources.

Maintaining the positive environment and setting the goals for the team member.

Identifying the needs of the team and resolving it.

Prioritization of the work as per client's need.

Appraising the team for the success.

Good Communication skills and excellent team player

Qualification:

Highest Degree: Bachelor's degree of Technology (B. Tech) -- (76%, Pass with First Class division, Honours – Passing Year - 2005)

Institute: Motilal Nehru National Institute of Technology, Allahabad (MNNIT, Allahabad, India)

Trainings Attended:

OBIEE

Microstrategy

Siebel Analytics,

ETL tool Informatica (8.x,9.x)

Siebel

DAC,

Oracle Warehouse Builder.

Technical Skills:

OLAP Tools : OBIEE 12c, 11g, 10g, DAC, Cognos, Tableau, Power BI

ETL Tools : Informatica (6.1, 7.1.2, 8.6, 9.5.1)

Languages : C, C++, SQL, PL/SQL

Operating Systems : Windows Family, UNIX

Project Details:

Project: 17

Company: DataFactZ / Reliable Software

Project Name: Wexner Science

Client: Victoria Secret

Duration: December 2018 to present

Role: Oracle Business Intelligence Architect & Project Lead

Project Description: Victoria Secret is looking forward to optimize demand and deployment strategy with the use of newly developed cognitive decision making platform called as diwo. diwo as a cognitive decision making platform will help the merchants to assess the true demand of the market at store-item level using the constrains with respect to each store like inventory, safety stock, presentable quantity, store tier index, promotions etc and also will help on deployment strategy on weekly basis. The solution provided by diwo to be implemented to 3 brands such as Victoria Secret Beauty, Pink& VSL.

Key Responsibility:

Understanding the overall business functions and their current demand and deployment system.

Gathering and documenting the requirement from business SME’s and mapping it to the diwo platform where diwo would be able to fill any gap in merchant’s planning.

Understanding and documenting all data feeds along with the data elements to be consumed by diwo-Cognitive Decision Making Platform.

Design the data model as per the need of diwo tool, design to be scalable and efficient.

Designing the transformations and filter need of the data.

Working with Data engineering team to make sure of implementing efficient ETL strategy is in place.

Working with Data Science team to make sure they have all data feeds in place that they will consume to come up with efficient data science models and have sufficient data to train the model with in order to achieve the output accuracy within the threshold.

Develop physical, business mapping management and presentation layers of reporting documents (OBIEE RPD), test RPDs and provide specs for administrative configurations.

Develop OBIEE rpd, reports and dashboards.

Working with Quality Assurance team to make sure we have the right strategy put in place to ensure diwo as a tool is stable and have data integrity in place along with all functionalities implemented as expected from the tool.

Technical Environment:

diwo-Cognitive Decision Making Platform

MemSQL as Memory database

Mysql as a source database

OBIEE as reporting tool

Anaconda (Python and related libraries) being used as data science platform

Workbench to be used as SQL platform client to MemSQL/Mysql.

Project: 16

Company: DataFactZ / Reliable Software

Project Name: Smart Migration from OBIEE to Cognos, Tableau

Client: Walmart

Duration: June 2017 to Nov 2019

Role: OBIEE Architect

Project Description: Walmart is an American multinational retailing corporation that operates as a chain of hypermarkets, discount department stores, and grocery stores. Walmart is looking forward to migrate their BI platform from OBIEE to Cognos, they have multiple business domain and out of that BI International Compliance, Sam’s club is moving towards Cognos.

Key Responsibility:

Analyse the Complexity in BMM layer vis-à-vis:

oPartitioning

oHandling variables

oLogical table sources

oHierarchies

oLevel based measures

oReporting across subject areas, data sources

oInitialization blocks

Help with security setup and third party tool integration

Help on how to derive the usage statistics in OBIEE

Transfer of knowledge of OBIEE technical functionality to the Cognos Architect

User interaction on certain occasions, to convince the pros and cons of functionality and features (will work with Cognos Architect on this one)

Proper guidance to offshore team and setting the expectations with Walmart (based on OBIEE functionality)

Use Prior Cognos knowledge to help while assessing OBIEE complexity

SQL analysis and tuning assistance

Building ad-hoc reports in Cognos and validating all metrics OBIEE vs Cognos.

Building Tableau reports and doing data validation against OBIEE reports.

Analysing Cognos report’s SQL to find out the issues and resolving those.

Analyse the Complexity in Object with respect to:

oAssessment of Dashboards and related objects

oStrong exposure on assessment of Reports

oAssessment of Sequential, Dynamic & conditional iBoTs

Help on BIP reports

Building complex dashboard in Cognos.

Validating 7000 calculations between OBIEE and Cognos by creating ad-hoc queries at both the end.

Technical Environment:

OBIEE 11g,12c

Cognos

SQL Developer, DBeaver

Oracle, DB2

Microsoft Office Tools, UNIX, windows

Project: 15

Company: DataFactZ

Project Name: Interactive Insights

Client: Genesys

Duration: Jan 2017 to June 2017

Role: OBIEE Architect

Project Description: Genesys is a company that sells customer experience and call center technology to mid-sized and large businesses. It sells both cloud-based and on-premises software. Currently they are looking forward to convert Business Object reports into Oracle Business Intelligence (OBIEE) with 12c environment.

Key Responsibility:

Analysing the requirement and laying the design and foundation for development.

Analysing the SQL queries and functionalities on Business Object reports.

Develop physical, business mapping management and presentation layers of reporting documents (OBIEE RPD), test RPDs and provide specs for administrative configurations.

Develop OBIEE rpd, reports and dashboards.

Validating the OBIEE reports vs Business Object reports output.

Converting Tableau reports into OBIEE.

Configure users based on access requirements and assist in user acceptance testing.

Warranty Support & Issue remediation.

Performs data analysis for both Source and Target tables/columns.

Writes, conducts and maintains unit/system tests and supports system / user acceptance, and performance tests.

Ensures performance metrics are met and tracked.

Prepare implementation and operational documentation for operational readiness.

Warranty Support & Issue remediation.

Technical Environment:

OBIEE 12c, Tableau

SQL Developer

Oracle

Microsoft Office Tools,

UNIX, windows

Project: 14

Company: DataFactZ

Project Name: Claims Reporting/Marketing Project

Client: AAA Insurance, Dearborn, MI

Duration: May 2015 to Dec 2016

Role: OBIEE Architect

Project Description: AAA is one of the largest insurance group in USA. Business group responsible for claims management is looking forward to have visibility towards how many payments processed on a monthly and daily basis. How much claims reserved amount they had monthly basis. Monthly trend on claims payment and reserve amount will help them to identify their monthly or daily claims processed amount they are posting for raised claims.

Key Responsibility:

Developing dimensional models based on user requirements and specifications.

Develop physical, business mapping management and presentation layers of reporting documents (OBIEE RPD), test RPDs and provide specs for administrative configurations.

Develop OBIEE rpd, reports and dashboards.

Configure users based on access requirements and assist in user acceptance testing.

Complete various documentations to be reviewed with ACG developers and administrators and obtain Sign Offs from ACG Project Manager.

Used BI Publisher to create data sources, template and required reports and automated the busting of publisher report each Friday to 378 service providers of AAA across USA.

Provide best practice consulting and mentoring to ACG resources.

Fixing Informatica mappings defects and fixing all data issues.

Creating Materialized views for performance tuning along with right level of indexing and partitioning.

Performance tuning at database and OBIEE level.

Creating specific Map based books and dashboards in Tableau.

Warranty Support & Issue remediation.

Performs data analysis for both Source and Target tables/columns.

Writes, conducts and maintains unit/system tests and supports system / user acceptance, and performance tests.

Ensures performance metrics are met and tracked.

Prepare implementation and operational documentation for operational readiness.

Warranty Support & Issue remediation.

Leading 3 assignments for OBIEE and 7 resources.

Technical Environment:

OBIEE 11.1.1.7.0g, BI Publisher

INFORMATICA

SQL Developer

Oracle, DB2

Microsoft Office Tools,

UNIX, windows

Project: 13

Company: DataFactZ

Project Name: Profit and Loss

Client: Safeway, Phoenix, AZ

Duration: 8 Months (Oct 2014 to May 2015)

Role: OBIEE Lead and Architect

Project Description: Safeway is an American Supermarket chain, second largest in North America. They are looking forward to simplify the posting of profit and loss statements at different organization levels with high accuracy and it’s availability on time to give them high visibility in different account lines. It will provide them a fair idea which accounts are profitable and which is in loss, drilling down further they can learn more about the accounts in details at different levels of organization.

Objective:

●Decision making reports revealing historical along with forecasted data and variances.

●Help analyzing business and looking forward to drill into details

●Flexibility towards merging new acquired business into the existing one.

Key Responsibility:

Designing the data model for data warehouse, keeping the approach to star schema, facts, dimensions and all other tables.

Creating functional and technical design documents.

Preparing the unit test cases to test the reports in unit testing phase.

Designing the tables, aggregates, materialized views and load strategy for the project requirement.

Designing the repository, development, working on physical, business and presentation layer. Implementing the calculation logics in business layer, working on hierarchies in OBIEE.

Working on variables, initialization blocks in OBIEE.

Working on reports, prompts, and dashboards in OBIEE.

Running the unit test cases successfully on reports.

Working on object and data level security in OBIEE.

Delivering it to SIT phase and resolving SIT issues raised.

Delivering the code to UAT phase and supporting UAT, resolving all users’ queries in UAT phase.

Packaging the code after UAT sign off and delivering the code to release team for production release.

Reviewing the Data Stage existing mappings and providing the solution to defects in loading.

Helping the Data Stage team in data load process.

Handling the team of 4 resources, onsite and offshore model in Manila, Philippines.

Implementing the best practices as per Oracle Standards.

Handling the complex issues on my own.

Reviewing the code developed by team.

Performance tuning of the reports.

Handling the DEV, SIT and UAT boxes and configuration.

planning, monitoring, and appraising job results

Recruiting Staff, coaching them, maintain safe and secure work environment.

Maintaining effectiveness and efficiency by defining, delivering, and supporting

Interacting with client on daily basis on project status, planning future requirements etc.

Technical Environment:

OBIEE 11.1.1.7.0g

Data Stage

SQL Developer

Oracle, Teradata, MSSQL

Microsoft Office Tools,

UNIX, windows

Project: 12

Company: DataFactZ

Project Name: EDW Pahse-2

Client: C&S Wholesale grocers, Keene, NH

Duration: 4 Months (June 2014 to Sep 2014)

Role: OBIEE Lead

Project Description: C&S is a well known wholesale grocer in USA. They are looking for redesign of their data warehouse to increase data efficiency to help them making decision in order to achieve more benefits and generating more revenues. Redesigned data model would be more flexible to adjust new structured data which they are getting after acquiring more business.

Objective:

●Structured and flexible data to increase efficiency.

●Decision making reports from historical data.

●Help analyzing business and looking forward to acquire more business from open market.

●Flexibility towards merging new acquired business into the existing one.

Key Responsibility:

Preparing the architecture plan of Datawarehouse and data flow from data sources.

Analysing the gap between the data source and data warehouse.

Analysing the source data model and analysing the reports requirement with it and finding if any gap exists between available in source and reports requirement.

Designing the data model for data warehouse, keeping the approach to star schema, facts, dimensions and all other tables.

Creating functional and technical design documents.

Preparing the unit test cases to test the reports in unit testing phase.

Designing the repository, development, working on physical, business and presentation layer. Implementing the calculation logics in business layer, working on hierarchies.

Working on variables, initialization blocks.

Working on reports, prompts, and dashboards.

Working on object and data level security implementing it thoroughly.

Running the unit test cases successfully on reports.

Delivering it to SIT phase and resolving SIT issues raised.

Delivering the code to UAT phase and supporting UAT, resolving all users’ queries in UAT phase.

Packaging the code after UAT sign off and delivering the code to release team for production release.

Handling the team of 3 resources.

Implementing the best practices as per Oracle Standards.

Handling the complex issues on my own.

Reviewing the code developed by team.

Technical Environment:

OBIEE 11g

SQL Developer, Teradata Client

Oracle, Teradata, MSSQL

Microsoft Office Tools,

UNIX

Project: 11

Company: Future Technologies Inc

Project Name: Healthcare Analytics

Client: Future Technologies Inc, Plainfield, NJ

Duration: 1 Month (May 2014 to Jun 2014)

Role: OBIEE Lead

Project Description: Future Technologies is in process of building a healthcare analytics solution to leverage the reporting experience of healthcare clients in USA. Project involves OBIEE and Informatica as reporting and ETL tool and looking for enhancing the existing product to increase the usability of the health care analytics product in market.

Key Responsibility:

Running full load and incremental load through Informatica.

Displaying the data in OBIEE reports and dashboards,

Preparing a new dashboard for all OBIEE reports with new features.

OBIEE 11g installation.

Modifying the repository in physical layer, logical layer, and presentation layer to accommodate new requirements.

Handling object and data level security.

Handling variables, initializations blocks, multiuser development environment.

Technical Environment:

OBIEE 11g

SQL Developer

Oracle

Microsoft Office Tools,

UNIX

Project: 10

Company: Comtel Solutions, Just Analytics

Project Name: Wallet Share

Client: Standard Chartered, Singapore

Duration: 12 Months (May 2013 to May 2014)

Role: OBIEE Lead, Singapore

Wallet Share Project Description: Sales & Product Management users do not have sufficient visibility on client’s wallet size potentials or their core operating account status in a consistent way at a client level, product level, segment level view. Wallet Share reports will directionally guide us in influence the right drivers that will grow Transaction Banking Business. Sales and Product management will come to know what the size of client’s wallet is and what fraction of it being used in dealing with Standard Chartered Bank and if there are possibilities to grow more business looking at the potent wallet of clients.

Objective:

To provide the opportunity to judge client’s wallet and opportunity to grow.

To provide the management the idea of how much client’s wallet share is being used by Standard Chartered Bank.

Providing the ad-hoc analysis capability to Standard Chartered to do their own report to look in client details.

Producing the standard reports to look into client’s wallet share with security laid to it.

Fast response by reports to quick and reliable data.

Key Responsibility:

Gathering the report’s requirement from client on wallet share and understanding the business and its terminology.

Doing a prototype and providing the client a proof of concept.

Analysing the source data model and analysing the reports requirement with it and finding if any gap exists between available in source and reports requirement.

Designing the data model for data warehouse, keeping the approach to star schema, facts, dimensions and all other tables.

Creating functional and technical design documents.

Preparing the unit test cases to test the reports in unit testing phase.

Designing the repository, development, working on physical, business and presentation layer. Implementing the calculation logics in business layer, working on hierarchies.

Working on variables, initialization blocks.

Working on reports, prompts, and dashboards.

Working on object and data level security implementing it thoroughly.

Running the unit test cases successfully on reports.

Delivering it to SIT phase and resolving SIT issues raised.

Delivering the code to UAT phase and supporting UAT, resolving all users’ queries in UAT phase.

Packaging the code after UAT sign off and delivering the code to release team for production release.

Supporting the production for next 1 month for any issues rose in production.

Continuing working on further enhancement requests from users.

Technical Environment:

OBIEE 11g

SQL Developer

Microsoft Office Tools,

UNIX

Project: 9

Company: Comtel Solutions, Neobytes Asia

Project Name: PMI Redesign

Client: Standard Chartered, Singapore

Duration: 9 Months (Jul 2012 to Mar 2013)

Role: OBIEE Lead, Singapore

PMI Project Description: As part of TB Redesign Phase1, a new reporting data model was established to serve current and future reporting needs. The data model provides full range of metrics including revenue, drivers, risk and others by set of key dimensions: Client, Salesperson, Booking Location, and Product.

The phase1 data model was designed to be fundamentally complete, support future extensibility and serve current and future reporting needs. Phase1 focused on building reports for TB Sales dashboard.

This project (referred as TB Redesign Phase2) extends the data model to achieve following:

Support TB Client and Management view dashboard

Bring new data sets to support additional analytics needs and KPIs: SCF, Limits, Capital Recovery and Maturity profile, etc.

Implement new business rules based on existing data: Client Sub segment group and management location consolidation, Geographical cross sells etc.

Build new dashboards on existing and new datasets. There are 8 new dashboards excluding the TB Client and Management dashboard that shall be built as part of this phase.

Objective:

Improve Responsiveness

Achieve simplified and consistent data model to meet current requirement and support future extensions. The new data model including BI metadata should ease doing ad-hoc analysis and creating custom report for TB Sales users.

Drill down capability – The new model should have fundamental data set at Contract level and allow users to drill down to contract level information.

Key Responsibility:

Understanding the new database design, repository design, and reports design.

Gathering the new requirement for the modifications in existing reports model so that new reports consists the old reports and new requirement as well.

Creating Functional and Technical Design Documents (FDD, TDD)

Presenting FDDs to business and getting it signed off.

Creating reports, prompts, views, dashboards etc based on new data model.

Handling extremely complicate layouts of reports and dashboards.

Unit testing of the reports.

Modifying the repository in physical layer, logical layer, and presentation layer to accommodate new requirements.

Handling object and data level security.

Handling variables, initializations blocks, multiuser development environment.

Solving Reports issues raised by Business users in System Integration Testing phase.

Migrating the webcat and rpd to SIT and UAT

Providing training to business to generate adhoc queries from answers with redesigned database and repository.

Presenting business on redesigned reports and dashboards and guiding how efficiently it can be used.

Supporting production for a month after release to production.

Technical Environment:

OBIEE 10g, 11g

TOAD

Microsoft Office Tools,

UNIX

Project: 8

Company: Acrotrend

Project Name: SRM Programme

Client: Cancer Research, London, UK

Duration: 4 Months (Jan 2012 to Apr 2012)

Role: OBIEE and Informatica Developer, London

SRM Project Description: Cancer Research, UK is a leading charity organization, investing its donated income in research related to all types of cancers. Cancer Research charity organization has got millions of supporter, who donate to the organization. SRM programme helps CRUK in accessing the supporters and tracking the donations on regular basis.

SRM programme had a recent release on sales, have identified some issues in production related to Sales Release. These defects are expected to be resolved on the priority as it’s critical to the business.

Objectives:

Tracking all donations which are already paid and due.

Tracking the activities involved in encouraging the supporters and creating new opportunities.

Key Responsibility:

Understanding of the business which will help in resolving the production defects.

Resolving the production defects in OIEE, ETL Informatica.

Gathering the requirement for new reports and dashboards.

Creating functional and technical design documents for new requirements.

Modifying the repository in physical layer, logical layer, and presentation layer to accommodate new requirements.

Handling variables, initializations blocks, multiuser development environment.

Creating reports, prompts, views, dashboards as per the requirements.

Creating new Informatica mappings, workflows in Informatica for data loads.

Running incremental and full loads through DAC.

Giving knowledge transfer sessions to production team for the new reports and dashboards, rpd enhancements, Informatica Mappings, workflows and database changes released into production to accommodate new reports and dashboards requirements.

Creating Resolution documents.

Creating Unit test scripts and performing unit test.

Releasing into SIT and rehearsal environment.

Technical Environment:

OBIEE 10g

TOAD

Microsoft Office Tools,

Windows server.

Project: 7

Company: Acrotrend

Project Name: Sales & Service Demonstration

Client: Acrotrend Sales, Mumbai, India

Duration: 2 Months ( Dec 2011 to Jan 2012)

Role: OBIEE and Informatica Consultant, Team Lead

Sales & Service Demo Project Description: Acrotrend sales team is looking for BI APPS sales and service analytics implementation which will help them to demonstrate their strength and capability of BI – Consultants at Acrotrend. It will help them to create new opportunities in UK market and win the opportunities to grow in business.

BI Apps sales & Service analytics implementation already have inbuilt OBIEE reports, dashboards and Informatica mappings, workflows. Reports, Dashboards currently displays no result because of lack of data and hence relevant data has to be cooked from Siebel front end and Informatica mappings have to run and populate data in the data warehouse to display in the reports, dashboards.

Objectives:

Introducing Acrotrend’s BI-Capability to customers.

Key Responsibility:

Understanding of the Siebel Sales and Service Analytics data warehouse model

Loading Siebel sample sales and service data in Siebel database.

Running full load and incremental load through Informatica.

Displaying the data in OBIEE reports and dashboards,

Working on new features of OBIEE 11g as KPI, Watch list, Map viewer, scorecard, chart slider, value based hierarchies.

Preparing a new dashboard for all OBIEE reports with new features.

OBIEE 11g installation.

Modifying the repository in physical layer, logical layer, and presentation layer to accommodate new requirements.

Handling object and data level security.

Handling variables, initializations blocks, multiuser development environment.

Up gradation from 10g to 11g on a separate environment.

Preparing and implementation of security model for Sales and service analytics.

Leading the team to ensure successful implementation.

Technical Environment:

OBIEE 11g, BI Apps 7.9.6

TOAD

Microsoft Office Tools,

Windows Server

Informatica 8.6

Project: 6

Company: Royal bank of Scotland

Project Name: BSSAO (RBS Clarity)

Client: RBS, London, UK

Duration: 19 Months (May 2010 to Nov 2011)

Role: OBIEE Designer & Developer (Siebel Analytics), Team Lead, UK and USA

BSSAO Project Description: This project is to automize substantiation of Balances for each user as per their roles assigned for balances. Each balance has to be defined with its ownership with different roles (Reconciler, Reconciler Reviewer, Account Owner, Cost Centre Owner, Business Unit Owner and Delegates for each role). Earlier defining ownership and substantiation of each balance was manual process and tedious and took long to complete process. Automizing the system and revealing the information on substantiation and unsubstantiation of balances helps RBS a lot and helps in reduce cost. The goals are as follows:

The BSSAO system will provide the following business control over Balance sheet substantiation process

Transparency of balance sheet issues for monthly reporting as well as allowing systemic issues to be identified.

A balance sheet attestation toolset providing transparency and therefore enabling enforcement of attestation in line with.

GBM policy leading to improved quality and accuracy of balance sheet numbers.

Facilitates reduced risk of operational losses from invalid account balances through better early warning of emerging.

Reconciliation problems and Potential Financial Exposure (PFE).

Clearly defined and agreed ownership and accountability for the entire GBM balance sheet.

Facilitate the move to the target audit level of 2.

Key Responsibility:

Gathering the reports requirement, sample reports, business information etc.

Preparing FDD for reports on the basis of sample and information gathered from client.

Creating TDD for reports and rpd.

Creating Unit Test Scripts for reports for developer’s testing.

Analysis of OLTP data model from reporting perspective.

Creating MUD environment for development.

Creating views from OLTP tables to support OBIEE and to bring data model in star schema shape.

Creating Physical layer, Opaque views in physical layer, aliases and joins.

Creating Business layer, measures, hierarchies, level base measures, using time series functions for month ago functionality.

Creating Presentation

Contact this candidate