TECHNICAL SUMMARY

General

• IT Professional over 10 years of professional experience including analysis, design, development and implementation of OBIEE OBIA.
• Strong experience in full life cycle project design and development implementing OBIEE.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema Modeling, Fact and Dimensions tables, and Physical and Logical Data Modeling.
• Deriving Functional Design based on Requirements, Development and maintenance of Data warehouse/Business Intelligence.
• Experienced in grounds up development of Financial Analytics, Supply Chain and Order Management Analytics, Sales and Marketing Analytics.
• Solid foundation in Oracle PL/SQL Procedures, Packages, Functions.
• OBIEE/OBIA Administration
• Experience in Installation, Configuration, and Administration of Oracle BI Apps 7.9.6.3/7.9.6.4, OBIEE 11.1.1.7/10.1.3.4, Informatica Power Center 9.5/9.1/8.6, DAC 11.1.1.6/10.1.3.4.
• Extensive experience on Upgrading and Configuring business intelligence and OBIA tools.
• Experience with Weblogic server and Fusion Middleware.
• Extensive hands on experience in Code Migration, Cut Over activities.
• Experience in configuring Security Settings Groups, Roles, access/query/report privileges and scheduling iBots/Agents for OBIEE 10g and OBIEE 11g.
• Experience in Security and integration between OBIEE with Oracle EBS Applications.
• OBIEE RPD/Reports/Dashboards
• Vast experience in designing and building Physical, Logical BMM and Presentation Layer of OBIEE Metadata Repository.
• Experience in implementation of highly complex security requirements using best available resources from out of the box.
• Experience in complex design and development of reports and dashboards.
• Experience in extensive usage of different types of variables like Repository / Session / Presentation / Request.
• Extensive experience in modeling Hierarchies / Level Based Measures.
• Experience in effective implementation of usage tracking / event polling / cache management.
• ETL: Informatica DAC
• Experience in design and development of ETL mappings in Informatica.
• Experience in customization of DAC

TECHNICAL SKILLS

• Oracle BI Enterprise Edition OBIEE 11.1.1.7/11.1.1.5/10.1.3.4.x, BI Publisher 10.x.
• Oracle BI Applications OBIA 7.9.6.4 /7.9.6.3/7.9.4
• Informatica 9.5/9.1/8.6/8.1.
• Siebel/OBIA Data warehouse Administration Console DAC 11.1.1.6/10.1.3.4.1
• Oracle 11g/10g, SQL PL/SQL, Essbase, Oracle SQL developer, Toad.
• MS Access, SQL Server 2000, SQL Server 2005/2012/2014.
• Microsoft .NET VB.NET, C , WinForms, ASP.NET, VB 6.0, C, C .
• Crystal Reports BO 11/9/8.5/7, Far Point Spreadsheet Control.
• OBI Applications

ERP: Financial / Supply Chain and Order Management / Procurement and Spend Analytics.

CRM: Sales Analytics / Marketing Analytics.

PROFESSIONAL EXPERIENCE

Confidential

HYLA Mobile

Hyla Mobile is a leading redistributor of used mobile devices from mobile network operators. In order to support their customers in a better way and to manage the overall functions the company chooses Oracle EBS and Oracle Business Intelligence 11g for their Analytical needs. We have been engaged to implement OBIA Financial Analytics, Supply Chain and Order Management, Procurement and Spend Analytics, and HR Modules.

Role: OBIEE/OBIA Consultant

Responsibilities:

• Work collaboratively with IT applications implementation team to ensure quality delivery of BI Solution
• Customizing SCOM/ Financial/ Procurement metadata repository RPD using admin tool.
• Security integration with Microsoft Active Directory MSAD for OBIEE on PROD and UAT.
• Creating new mappings and customizing existing mappings based on the business requirements.
• Configured Informatica custom workflows synchronized with DAC tasks for routine scheduling.
• Installing and Configuring OBIA 7.9.6.4 components OBIEE, Informatica and DAC
• Support BI solution Planning and implementation of enhancements.
• Work with business users to define, plan and develop further BI / reporting capabilities.
• Develop and maintain a long-term roadmap for solutions.
• Ensure documentation is available and up-to-date.
• Train power users in the use of these tools and development of basic queries / reports / dashboards.
• Responsible for the application maintenance of both Production and Non-Production environments.
• Troubleshoot environment issues, identifying root causes and planning remediation.
• Develop reporting standards and best practices to ensure data standardization and consistency.
• Configured scheduler and created iBots to send alert messages and reports to subscribed users.
• Setup Usage Tracking and Dashboards to track performance.
• Monitoring daily Incremental Load and fix if there are any issues during the Load.
• Define and develop physical and logical data models to support departmental and functional reporting needs.
• Create, maintain, and manage documentation for all data warehouse and reporting development efforts Help to create and implement a long term storage and business continuity strategy including backup recovery and data storage and archiving

Technical Environment: EBS 12.1.3, OBIEE 11.1.1.7, Informatica 9.5/9.1, DAC 11.1.1.6, OBIA 7.9.6.4, Windows Server 2012/2008, Linux Servers, Win SCP, Oracle Database 11g, Microsoft SQL Server 2014/2012

Confidential

USANA Health Sciences is one of the leading companies in the field of Health and Nutrition. EBS Applications is used by HR, Sales, Financial Advisors, and Institutional business lines for marketing initiatives and services. USANA has implemented OBIA HR and Financial Analytics OFA version 7.9.6.3 integrating EssBase. APEX integrated with OBIEE to get user inputs and the same data federated in the logical layer to show up on appropriate analysis.

Role: OBIEE Consultant

Responsibilities:

• Imported Essbase cube and flattened measures based on business requirement.
• Created Unbalanced and Value based hierarchies for a single Essbase Hierarchy.
• Integrated Essbase cube data Planning with existing OBIA data Vertical and Horizontal data federation .
• Data from APEX Application is loaded into OBAW and federated with the financial data in the BMM layer.
• Monitoring of DAC execution plans and Informatica workflow runs.
• Extensive design and development experience in all 3 layers of the RPD.
• Developed Budget Vs Actuals, Month-end and Consolidated Analytics dashboards.
• Configured a multi-user development environment MUDE .
• Experience with Interactive Dashboards, agents/Delivers and OBIEE security setup.
• Development of Unit, Integration and System test cases to validate the data loading process and reports.
• Involved in the change management process to migrate the changes b/w the environments.

Technical Environment: EBS R12, OBIEE 11.1.1.7, Informatica 9.0.1, DAC 10.1.3.4.1, OBIA 7.9.6.3, Linux Servers, Windows Server 2008, Win SCP, APEX, Oracle Database 11g, EssBase 11.1.2.3

• Confidential The company is the local leader in the importation and the distribution of quality spirits and wines as well as the top producer of alcoholic drinks derived from sugarcane.
• I have principally worked with OBIEE as data access tool to construct a complete Business Intelligence environment against the ERP Oracle E-Business Suite.

Role: Team Lead / OBIEE Consultant

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and feasibility study for the given requirement.
• Developed technical solutions to business problems in the OBIEE repository.
• Created and Configured Physical layer, Business Model Layer BMM and Presentation Layer of the repository with Business Logics, Hierarchy, Aggregates and Security privileges.
• Designed, developed, tuned and troubleshoot ETL Informatica mapping, session and workflow for full, incremental load using EBS Data source.
• Created Sales Analytics Dashboard based on the Performance and Revenue achieved by Executives, Supervisors and Sales Representatives.
• Created Marketing Analytics Dashboard that provides top performing channel information and shows how much budget available and how much has been spent per brand.
• Created Supply Chain and Order Mgt. Analytics Dashboard to monitor the time efficiency of the distribution as well as the quality of movement and warehousing operation of the goods.
• Created Dashboard for Management Accounts like Trial Balance, Income Statement, Balance Sheet, Cash Flow Statement and AR AP Analytics etc.
• Implemented Data Object Level security using Admin Web catalog tools.
• Created materialized views and aggregates to improve performance.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Implemented user level security for dashboards based on Business Requirement.
• Extensive experience in running SQL queries against database using SQL Developer, and analyzing the data.
• Administrative tasks Environment creation, ETL Code Migration, Webcatalog Merge, RPD Migration.

Technical Environment: OBIEE 11.1.1.5, Informatica 8.6.1, Oracle 11g, Oracle SQL developer.

Confidential

Client is a leader in automobile multi branded one-stop shop over the last fifteen years and has implemented Siebel Sales and marketing analytics for managing the Sales Representatives goals and tracking opportunities.

Role: OBIEE Developer

Responsibilities:

• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository.
• Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Finance Experts, Business Analysts and Users.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Custom tables to populate Brand, Category, Class, Region, Product, and Time Dimensions and Fact and Aggregated Facts.
• Developed Business models to represent business logic for Market Measurements.
• Created logical tables and defined the complex joins for a business model.
• Created dimension hierarchies.
• Developed measure and dimension based aggregates to improve query performance.
• Developed custom logical columns and calculated measures using expression builder.
• Created presentation catalogs with restricted access to various business users.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Expertise in debugging and optimizing Dashboards / Reports. Working With Reports Customer Requirements
• Worked Extensively on Answers to create the reports as per the client requirements.

Technical Environment: OBIEE 10.1.3.4.1, OBIA 7.9.6.1, Informatica 8.6.1, Oracle 10g, Toad.

Confidential

Capricorn Services involves in manufacturing and import of office furniture as well as interior design. Handling projects such as showroom design and renovation in Mauritius and Madagascar.

Role: OBIEE Developer

Responsibilities:

• Worked closely with Business Analyst, discussed and gathered the analytics requirements from different user groups.
• Created/Modified Metadata repository RPD by using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers.
• Experience in Configuring the Oracle BI Scheduler server and creating ibots to alert users so that they can be proactive and make important business decisions quickly and at less cost.
• Efficiently worked in a multi user development environment MUDE to make changes and additions which met business requirements.
• Involved in merging applications from Development - Testing Production for deployment.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Set up security to authenticate users and assign appropriate permissions and privileges, this is a key business requirement for a large unionized business.
• Modeled aggregate tables to speed query processing and partitions and fragments to improve application performance and usability.
• Used Filters and provided customized prompts appropriately to avoid excessive data showing up on reports.

Technical Environment: Oracle EBS 11.5.10, OBIEE 10.1.3.3, OBIA 7.9.4, Oracle 10g, Toad.

Confidential

• Misys is a comprehensive integrated ERP solution for enhanced operational efficiency of Construction Companies. The main functionality's of this project:
• Hiring of Equipment, Plant and Vehicle to internal and external customers, Repairs and maintenance of Equipment, Vehicle and Plant. Stores Management Fuel/Spare parts/other consumables . Accounts Payables Receivables. Maintenance of comprehensive databases Customers/equipments/ Plant/Vehicles/ sites/ operators/ mechanics/ job types/ parts . Allow for categorization of customers Internal/external/standard/privileged . Process hiring of equipments, Plant and Vehicles Based on predefined hourly or daily rates, Lump Sum Cost, customer type and payment mode . Generation of work orders against requests for repairs or servicing of equipments. Subdivision of work order into job categories. Assignment of jobs to mechanics. Feedback log on job status. Generation of claims including hire and work order details.

Role: Sr. Software Engineer

Responsibilities:

• Involved in Cost Tracking, Purchase, Inventory, Sales, Fleet Management and Financial Accounting modules
• Requirement Study, Design and Coding for the above modules.

Technical Environment: VS 2005 C , Winforms, SQL Server, Crystal Reports.

Confidential

• Khajane is integrated software developed for the computerization of Department of Treasuries, Karnataka. Treasuries mainly deal with the Government Receipts and Payments transactions in the state. It also takes care of the Pensions, Deposit accounts, Stamp transactions and embossing of documents.
• The main application of this project is automation of Treasury Department at 217 locations all over Karnataka. All the treasuries will be connected through satellite link to a centralized server located at Bangalore. All Financial transactions at any Treasury all over state will be validated from centralized server for approval of bills. With the help of end of day, end of month and end of year activities, data of whole State will be available at centralized server, which will be helpful for the State Government for monitoring the Budget administration.

Role: Software Programmer

Responsibilities:

• Enhanced and managed the development of Khajane using VB 6 and PL/SQL proc dures.
• Study, Design and Coding.

Technical Environment: Visual Basic 6.0, Oracle Database 10g, Spreadsheet

Confidential

Secondary Sales Software

It is typical marketing based software developed at Sumukha Technologies. Group Pharmaceuticals is a drugs production company and employed more than 1000 MR's all over India to promote their products. The company also purchasing products from other companies for sales through their network. The commission on sales has to be given to the respective MR, MBD, ZBM, SM and NSM hierarchy. And company will fix targets on certain product that has to be achieved in the specified time span The software should take hierarchy every month to get the rank list based on their sales. MR Headquarters can be abolished and stockists under that particular MR will be merged with some other MR.

Role: Software Programmer

Responsibilities:

• Involved in MR Details, Hierarchy, Sales, Schemes, Achievement, Reports modules.
• Study, Design and Coding.

Technical Environment: Visual Basic 6.0, MS Access, Crystal Reports.

Confidential

Payroll Management System

Payroll management system has been designed to automate the payroll system of a company. The pay slip has to be generated every month based on the attendance and the salary structure of an employee. The pay slip contains details of basic, allowances like DA, TA, HRA etc., deductions like PF, ESI, PTAX, Tax, Loan deduction etc. All the allowances and deductions are calculated as a percentage of gross salary. Attendance can either be entered by the user or imported from Excel files. Reports of Employee Details, Loan Details, Leave Details, Salary Slip, consolidated bank statement etc can be generated from the system.

Role: Software Programmer

Responsibilities:

• Involved in Employee Details, Attendance Leave Details, Loan Details, Tax Calculation and salary generation modules.
• Study, Design and Coding.

Technical Environment: Visual Basic 6.0, MS Access, Crystal Reports7.0.