Data Sales

Jerin Haboose A

BI Professional with **+ years of experience

Email: adhn36@r.postjobfree.com

Cell:+1-862-***-****

HIGHLIGHTS

●Primary Skills:

oOracle BI:Oracle Business Intelligence Enterprise Edition(OBIEE) 10g/11g/12C, BICS, OAC,Oracle Exalytics,Power BI,Tableau,BI Publisher

oOracle BI Applications:OBIA 7.9.6.4,Oracle DSR

oDatabase: Oracle 12c/11g, MS SQL Server2008, Netezza, DashDB, Impala

●Additional Skills:

oApplication Servers: Weblogic

oETL: Informatica,ODI

oWeb Technologies: HTML, XML

oOther Technologies:ALM,JIRA,GITS,JENKINS,SVN,MS Visio,MPP

●Domains:

oBanking,Finance and HR

SUMMARY

●10 years of rich experience in defining, architecting and implementing Business Intelligence and Analytics solutions for various organizations

●Experience in business requirements gathering, data warehousing, data mapping and data modelling

●Expertise in installing, configuring, customizing, developing and upgrading OBIEE, Oracle Business Intelligence Application (OBIA) and Oracle DSR

●Expertise in rpd and dashboards development in OBIEE 10g/11g/12C versions

●Expertise knowledge in development and deployment of Power BI and Tableau Data Analytics tools

●Connect to data sources,importing data,transforming data for business intelligence and automating the cleansing process using Power BI functions

●Build analysis services report data models,develop visual reports,dashboards using Power BI desktop

●Create DAX queries for advanced analytical calculations and implement row level data security

●Ability to build strong relationships with all stakeholders and manage their expectations

●Expertise in creating Business Requirement Document (BRD) & Functional Specification Document (FSD)

●Determining optimal approach for obtaining data from diverse sources, platforms to move data into Business Intelligence platform

●Estimating system capacity to meet near and long-term data insertion, extraction and processing and spacing requirements by coordinating with appropriate team

●Response to RFPs, tool selection, estimation, High level and activity level Project Planning

●To liaise among development/support team, onsite-offshore and business users, developing technical design documents and presenting to development team

●Developing disaster recovery, backup and archival strategies

●Assisting business decision makers with strategic direction for business intelligence

●Defining data, code and tools standards and best practices

●Continue to investigate and evaluate emerging BI technologies.

EDUCATIONAL QUALIFICATION

●Master of Engineering (Computer Science & Engineering)

●Bachelor of Engineering(Computer Science & Engineering)

TRAININGS/ CERTIFICATION

●Oracle Business Intelligence Foundation Suite Certified Implementation Specialist

●Successfully completed Oracle training on ODI & BIP

●Successfully completed Hadoop training

PROJECT EXPERIENCE

Synechron Technologies Pvt. Ltd., Charlotte,US Nov’19 till date

Project 1: Credit Card Securitization Nov’19 till date

Client: Wellsfargo Bank,USA

Role: OBIEE Consultant

Description: The project aims to create the credit card securitization process by identifying the

representative pool accounts and securitized accounts from FDR and injecting into securitization

data warehouse.The data is pumped from upstream systems using Informatica to ABS suite

.Various control reports for KPMG auditing,daily and monthly reports for rating agencies and

Other banks are created in OBIEE and published to various financial controllers.

Team Size: 10

Responsibilities:

●Solution Design of various financial reports for credit card securitization in OBIEE with the functional

●consultants and business users

●Performance tuning of historic reports

●User training of OBIEE to various business users

●Designing and configuring security securitization reports

●Migrating objects across environments

●Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle Business Intelligence Admin tool

●Configured metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard,

●Pages, Folders, and Reports)

Environment: OBIEE 12C,Informatica,PL/SQL,Oracle DB,Autosys

Larsen and Toubro Infotech Feb’17 to Nov’19

Project 2: Financial Analytics & Sales Analytics Upgradation/Development/Support Sep’18 to Nov’19

Client: Securitas Inc,Parsippany,New Jersey

Role: Technical Lead/Solution Designer

Description: The project aims to upgrade their on-premise Financial Analytics from 11g to 12c and merge HR analytics deployed on BICS analytics to have one consolidated BI system.

Sales Analytics provides a CRM BI solution that can automate a lot of manual processes. Allows detailed ad hoc reporting providing meaningful insights for their sales data. Provide On time & real time reporting serving needs of field sales to senior executives in Power BI.

Team Size: 8

Responsibilities:

●Architecture design for new environment

●Assessment of customization and preparing roadmap for upgrade

●Upgrade and post upgrade retrofitting of EP, RPD, reports, dashboards and fixing complex upgrade issue

●Designing and configuring security in upgraded environment

●Develop and manage the BI dependency plan, job scheduling and cycle management

●Integrated Active Directory for authentication with multiple providers

●Implementation of Authorization using BI SQL Group provider

●Implemented Data level security

●Validation of upgraded reports, dashboards & underlying tables

●Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle Business Intelligence Admin tool by importing the required objects (Dimensions, Fact,Aggregates) with integrity constraint into Physical Layer using connection pool, developing Dimensions (Drill-Down Hierarchies),Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer

●Configured metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages,folders

●Connect to data sources,importing data,transforming data for business intelligence and automating the cleansing process using Power BI functions

●Build analysis services report data models,develop visual reports,dashboards using Power BI desktop

●Create DAX queries for advanced analytical calculations and implement row level data security

Environment:OBIEE 12C/11g, BICS,Power BI, Informatica 9.1/9.6, DAC 10g/11g, Aix7.1/7.2, Oracle database 12C, Sales Force, ODI

Project 3: Warranty Analytics Feb’18 to Sep’18

Client: Eaton Corporation,USA

Role: Solution Designer

Description: The solution aimed at creating an intuitive analytical solution to improvise the offered services,

parts, repairs and service requests and to improve the overall decision-making process.

Team Size: 10

Responsibilities:

●Defined BI data architecture, including Extract-Transform-Load (ETL) processes, Operational

●Data Store (ODS), Enterprise Data Warehouse (EDW), data marts, and data lakes

●Developed architecture artifacts, technical designs, strategy documents and other technical artifacts for data warehouse and BI applications

●Engaged in feasibility study, requirement gathering, develop and maintain the artifacts

●through all the phases of SDLC

●Provided BI technical and architectural guidance to projects and teams, ensuring that new initiatives enable effective data reporting

●Developed and maintained data architecture, data management standards/conventions, data dictionaries, naming and metadata standards

●Collaborated with BI Administrators, Developers, and Data Analysts for successful development of BI reporting and analytic solution

Environment: OBIEE 12C, Oracle 11g, Red Hat Linux 6, Informatica, DAC11g, Oracle Exalytics

Project 4: Financial Data Hub (FDH)

Client: Fidelity, USA Feb’17 – Jan’18

Role: Senior BI Consultant

Project: Financial Data Hub

Description: Fidelity is a multinational financial services corporation based in the USA.

Financial Data Hub program was aimed at creating a single on-going data program and sustainable business management processes that delivers reliability and consistency for analytical data for the Finance process.

Responsibilities:

●Responsible for maintaining the quality of the solutions and assuring that the solution meets the business owner requirements

●Involved in understanding the business requirement

●Lead, design and document the conceptual and logical data models, and assist the technical team in the development of the physical models required to support project deliverables

●Worked with other Architects, defined the overall data warehouse architecture (e.g. ETL process, Operational Data Store, Data Marts & Lake)

●Collaborated with Domain Architects and Enterprise Architects to develop the technology "roadmap" (Business Initiative Roadmap) for the project, and to plan the transition from the current architectural framework to the target architecture of the future

●Verify the content developed by the technical team during the development phase is compliant with the proposed solution architecture

Environment: MS Office, MS Visio, MS Project Plan, JIRA, OBIEE 12C/11g,Oracle 11g,Red Hat Linux 6,Informatica,Netezza,Cloudera Hadoop, Impala, DashDB

Optimum Solutions,Shanghai,China Sep’15 to Dec’16

Project 5: Financial Markets Balance Sheet Management Sep’15 to Dec’16

Client: Standard Chartered Bank,Tianjin,China

Role: Development /Support

Description: Standard Chartered Bank is a British multinational banking and financial services company head-quartered in London.

The project involved development and enhancement of financial markets balance sheet reports and liquidity risk analysis reports in OBIEE.

Responsibilities:

●Responsible for technical design specification for OBIEE and data warehouse, application deployment instruction, verify stability & portability and security

●Engage in feasibility study, requirement gathering, develop and maintain the artifacts through all the phases of SDLC

●Project Planning, team management and coordination of ongoing activities

●Communication management, status updates and progress

●Coordinating with application owners and business users for queries and clarifications

●End to End Data validation, Code review and implementing best practices

●Create report prototypes in Tableau Desktop

Environment: OBIEE 11g, Oracle 11g, Red Hat Linux 6, PL/SQL,Tableau 10.0

Sutherland Global Services,Chennai,India Dec’14 to Sep’15

Project 6: DC Analytics Development Dec’14 to Sep’15

Client: Sutherland Global Services

Role: Technical Lead

Description: Sutherland is a global provider of business process and technology management services offering an integrated portfolio of analytics-driven back-office and customer facing solutions that support the entire customer lifecycle.

The project involved creating a custom analytics solution based on Oracle’s EPM BI application functionality. The sophisticated features and self-service functionality available in DC OBIEE Analytics enabled us to have an important insight into DC data and trends and helped with strategic business goals and objectives.

Responsibilities:

●Creating Project plan for DC OBIEE Analytics

●Requirements gathering & Estimation

●Fixing the complex issues

●Getting BI Functional Signoff

●Implemented Object level Security

●Created process for production support rpd migration

Environment: OBIEE 11g(Oracle Exalytics),Oracle Essbase 11g,SQL Server 2008 R2,Oracle Enterprise Linux 5

IBM India,Bangalore May’13 to Dec’14

Project 7: HR Analytics May’13 to Dec’14

Client: NISource,USA

Role: BI Consultant

Description: NiSource, Inc., based in Merrillville, Indiana, is a Fortune 500 company engaged in natural gas transmission, storage and distribution, as well as electric generation, transmission and distribution. NiSource operating companies deliver energy to 3.8 million customers located within the high-demand energy corridor stretching from the Gulf Coast through the Midwest to New England.

Oracle Business Intelligence Applications are comprehensive prebuilt solutions that deliver pervasive intelligence across an organization, empowering users at all levels — from front line operational users to senior management — with the key information they need to maximize effectiveness. Intuitive and role-based, these solutions transform and integrate data from a range of enterprise sources, including PeopleSoft, and corporate data warehouses — into actionable insight that enables more effective actions, decisions, and processes using the subject areas like Work-force,Recruitment,Compensation,Compliance,Absence and Retention.Custom Reports and subject areas are created and also customized the OOTB reports analyzing the gap between OOTB and Customer Requirements.

Responsibilities:

●Managed the entire OBIEE Application individually

●Requirements gathering

●Creating custom Subject Areas accordingly to client requirements

●Analyzing the gaps in OBIA OOTB reports and customer requirements

●Analyzing and fixing the issues identified and getting sign off from the customer

●Implemented LDAP for authentication

●Implemented Object level Security

●Added custom columns and tables in the OOTB rpd

●Technical training sessions to Business Power users to understand the OBIEE ap-plication and manage security

Environment: AIX 6.1, OBIEE 11g, Informatica 9.01, Oracle 11g

HCL Technologies Bangalore Oct’12 to Apr’13

Project 8: OBIEE 10g to 11g Upgradation Oct’12 to Apr’13

Client: Wipro

Role: OBIEE Consultant

Description: Wipro’s existing OBIEE landscape comprises one environment of 10g (10.1.3.4) and 2 environments [MIS and SS] of 11g (11.1.1.5). The 10g environment is widely used with over 18,000 user bases for its internal reporting purpose. Around 90% of the total reports that exist today come from the 10g environment. Additionally, all OBIEE servers today are in EC2 campus. The new requirements are to re-host all OBIEE servers on 11g (11.1.1.5) environment in Red Hat Enterprise Linux (RHEL) 5.6 version, which would be in Sarjapur data centre. In addition to this, the existing 10g reports / dashboards / schedulers to be upgraded /remediated to 11g (11.1.1.6.5) environments. Apart from this, the MIS and SS environments also need to be migrated to new infrastructure.

Responsibilities:

●Fixed the post upgradation issues in the dashboards

●Fixed the issues in security after upgradation and got sign off from the client

●Fixed the issues in the cluster environment in production

●Setting up the DR Environment and prepared the DR drill documents

●Prepared Unit Test Cases for the dashboards validating the 11g environment with the 10g environment

Environment: Red Hat Enterprise Linux 5.6, OBIEE 11.1.1.6.5, OBIEE 11.1.1.5, Oracle 11g

Project 9: Customer Relationship Management and General Ledger Oct’12 to Apr’13

Client: SIDBI,India

Role: OBIEE Consultant

Project: Customer Relationship Management and General Ledger

Description: The Small Industries Development Bank of India Act, 1989 envisaged SIDBI to be "the principal financial institution for the promotion, financing and development of in-dustry in the small scale sector and to coordinate the functions of the institutions engaged in the promotion and financing or developing industry in the small scale sector and for matters connected therewith or incidental there to.

Responsibilities:

●Gathering information from Business Analyst, Designing and developing Dash-boards

●Created Customer Management Dashboards

●Analysed the parked reports in General Ledger in the prior phases of the project

Environment: Windows 2003 Server, OBIEE 11g,OWB 10g,Oracle 10g

Hexaware Technologies,Chennai Apr’11 to Feb’12

Project 10: OPERA and Credit Card Analytics Apr’11 to Feb’12

Client: Banorte Bank, Mexico

Role: Development

Description: Banorte Bank is dedicated to the production, distribution and marketing of products in the form of financial services, with various areas of marketing and management for their services, as well as areas for support and attention to their business units. The area of operations is responsible for managing and presenting information relating to the processes of different products, for it generates various reports of control and monitoring of daily and monthly. Create a user arising from consultations with reliable and timely information for monitoring and decision-making information for the area.

Responsibilities:

●Involved in requirements gathering from the existing Operational Data Source (ODS)

●Creating the report layouts & Report Column mapping document

●Performance tuning for the existing reports

●Understanding the existing rpd and customized based on requirements

●Imported Essbase cubes in rpd and created reports in OBIEE.

●Worked on operational reports in the daily and monthly form of default and reports activated in the month

●User analysis reports on the credit card accounts, payments

●User analysis reports on the variation of portfolio of credit cards and evolution of punishment

●Homepage customization of Logos, banner, color and fonts

●Drilldown and drill through options in Graphs

Environment: Windows 2003 Server, OBIEE 11g, Oracle 11g,Informatica 9.0,Hyperion Essbase 9.0,Oracle 11g

Frontline Consulting Services, Hyderabad, India(Tek Systems) Apr’10 to Mar’11

Project 11: Demand Signal Repository Apr’10 to Mar’11

Client: Activision Blizzard, USA

Role: Development

Description: Activision Blizzard is a worldwide pure-play online and console game publisher with leading market positions across all categories of the rapidly growing interactive entertainment software industry. Customer maintains operations in Americas, APAC and Europe.

The Oracle Demand Signal Repository (DSR) helps manufacturers collect detailed retailer POS and other demand data, analyze it to identify issues and opportunities.

Typical retail data sources include daily point-of-sale, on-hand inventory, store orders and receipts, distribution center withdrawals, returns, store promotions and sales/order, forecasts. The DSR transforms retailer data into manufacturer terms – including manufacturer item identification, manufacturer hierarchies and calendars. A high-performance data loading facility cleanses the data and allocates it to a uniform set of dimension levels.DSR helps to make decision making processes for the customer globally.

Responsibilities:

●Involved in Client Meetings to decide on the structure and columns of the Reports

●Involved in Creation of Client-Side documents like TDD, FDD to get approval from clients

●Involved in Demo of the project to QA Teams

●Customizing the DSR repository and Answers based on Client requirements

●Created new Dimensions and Facts in DSR

●Involved in Measure Mapping like mapping client requirements with Database columns

●Involved in Repository development using SnowFlake Schema in MUD environment, Created Logical Calculated Columns in Business Layer

●Involved in Creation of Dimension Hierarchies for all dimensions

●Used Presentation and Repository Variables and Involved in creation of interactive Dashboards with almost all features available in OBIEE

●Involved in Creation of Dashboard as well as Page Prompts

●Implemented data level security and object level security

●Worked for performance tuning in Dashboards

●Involved in data Validations.

Environment: OBIEE 10.1.3.4.1, OWB 10g R2,Oracle 10g

Contact this candidate