Vikas Tiwari
Summary
Certified in OBIEE+11g (1Z0-591 Oracle Business Intelligence Foundation Suite 11g Essentials), with a strong background in development, implementation, and maintenance. Skilled in gathering reporting and analysis requirements, documenting report specifications, and implementing metadata layers. Experienced in upgrading OBIEE12c to OAS and migrating OBIEE between development, test, and production environments. Proficient in security management of BI through web logic, analytics, and Admin Tool. Extensive experience in OBIEE 10g and 11g development, configuration, and administration. Strong background in creating various charts such as Bar Charts, Line Charts, Scatter Charts, and Pie Charts. Knowledgeable in report designing in OBIEE Answers and creating Dashboards, as well as working with Compound views, Pivot Charts, Summary/Detailed views, and the OBIEE Repository (RPD) security. Skilled in creating batches and scheduling them in OFSAA. Expertise in creating forms and assigning rules for Maker and Checker roles for Excel upload. Experienced in user creation and role assignment based on responsibilities in OFSAA. Involved in applying patches and resolving issues related to batch performance data error. Experience in migrating Batches and forms from UAT environment to Production. Proficient in ODI11g load plans for data loading into the warehouse and creating RTF/PDF Templates for BI Publisher Reports. Developed complex reports for Bank Credit risk (RCA3 and CAR2BANK Reports). Experience extends to Oracle EBS Applications including GL, AP, AR, Fixed Asset, and creating BIP reports. Proficient in writing and debugging database packages, procedures/functions/triggers using Oracle Technologies (SQL/PL/SQL). Adept at preparing documents such as training materials/knowledge articles/Team KPIs and management reports. Successfully handled teams and collaborated with international teams for development work.
Overview
14
14
years of professional experience
2010
2010
years of post-secondary education
Work History
Project Manager
PricewaterhouseCoopers Pvt Ltd
10.2024 - 04.2025
- Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.
- Planned, designed, and scheduled phases for large projects.
- Met project deadlines without sacrificing build quality or workplace safety.
- Coordinated with cross-functional teams to resolve project issues and mitigate risks.
- Provided detailed technical and operational direction in project challenges, consistently meeting deliverables according to deadlines.
- Scheduled and facilitated meetings between project stakeholders to discuss deliverables, schedules and conflicts.
- Verified quality of deliverables and conformance to specifications before submitting to clients.
Manager
Deloitte Touché and Tohmatsu India Pvt Ltd
11.2022 - 10.2024
- Involved in business meetings and daily interaction with client on requirements and application Support
- Report Development for of FTP and PFT(Analysis ,Design and Development)
- Data loading from various source for FTP using SQLLDR
- OFSAA infra management
Manager
KPMG India Pvt Ltd
07.2020 - 11.2022
- Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules
- Interacted with business representatives for gathering the Reports requirements and to define business and functional specifications
- Involved in business meetings and daily interaction with client on requirements and application Support
- Responsible for creating additional Users and maintaining Visibility Privileges using OBIEE
- Created various subjects Areas as per the requirement and created Hierarchies and in BI Admin Tool
- Providing object level Security settings in OBIEE Console to set up users, groups, access privileges
- Developed Reports, Dashboard using various reporting features and functionalities
- Performing maintenance on ODI jobs to provide hassle free data loads into data warehouse
- Creating and developing new jobs to load data as per requirements
- Create RTF/PDF Templates for BI Publisher Reports
- Creation of batches for Credit Risk, Market Risk and other ALM modules in OFSAA
Senior Application Developer
Accenture India Pvt Ltd
07.2017 - 04.2020
- Playing as the lead role for the development and administration of OBIEE
- Scheduling reports as per requirement
- Worked with RPD creation and Deployment, Dashboards
- Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules
- Interacted with business representatives for gathering the Reports requirements and to define business and functional specifications
- Involved in business meetings and daily interaction with client on requirements and application Support
- Responsible for creating additional Users and maintaining Visibility Privileges using OBIEE
- Created various subjects Areas as per the requirement and created Hierarchies and in BI Admin Tool
- Providing object level Security settings in OBIEE Console to set up users, groups, access privileges
- Developed Reports, Dashboard using various reporting features and functionalities
- Monitoring the ODI prod load
- Performing maintenance on ODI jobs to provide hassle free data loads into data warehouse
- Creating and developing new jobs to load data as per use requirements
- Create RTF/PDF Templates for BI Publisher Reports
- Creating BIP reports on EBS tables
- Write, debug, database packages, procedures/ Function / Triggers in RDBMS using Oracle Technologies i.e
- (SQL, PL/SQL) as per business requirement
Consultant
HCL Technologies
07.2016 - 07.2017
- Involved in design & documentation of functional processes based on technical & architectural feasibility
- Strong experience in providing end-to-end business intelligence solution by configuring metadata and building Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) Using Administration Tool (RPD)
- Create the reports like Table, Chart, Pivot, column selector Using Analysis and publish them in dashboard using presentation service
- Add users to the new group and apply the data level and object level security at repository level as well as presentation services
- Developing Reports through OBI and carrying out tasks like Unit Testing, preparing for Production Deployment, Sanity Testing after deployment as required for successful Production Release
- Designed reports & interactive dashboards in OBIEE Answers
- RPD Release migration DEV to QA and QA to Production
- Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBots daily and weekly and Monthly Basis
Consultant
Capgemini India Pvt Ltd
04.2015 - 07.2016
- Participating in requirements gathering of the various work streams by meeting with the business user and by analyzing the existing Business Objects Report and base lining the details
- Build the Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer)
- Configured and created repository using OBIEE
- Create/manage Logical table, logical columns and logical joins in BMM Layer
- Worked on Physical Layer, Business Model & Mapping Layer & Presentation Layer in OBIEE Admin Tool
- Developed/customized different kinds of Reports (pivots, charts, tabular) using global and local Filters
- Developed custom reports/Ad-hoc queries using OBI Answers and assigned them to application specific dashboards
- Creating and maintaining BI Publisher report
- Brainstorming with Clients for extracting concise requirements & documenting them for signoffs
- Release Management, Application testing, conducting User Acceptance Testing (UAT) for clients & training sessions for internal teams
- Document and analyses requirements to determine feasibility and recommend business process improvements where appropriate
System Engineer
Tata Consultancy Services
03.2011 - 04.2015
- Developed metadata repository (.rpd), configured metadata the business model layer & physical data model and web catalog objects as per the reporting requirement using OBIEE admin and web tool
- Worked on oracle BI answers to build interactive dashboards with drill down capabilities
- Configure dimension hierarchies in the business model and mapping layer
- Extensively used answers in building various reports
- Created templates for presenting results and analytics and modified the OBIEE Dashboard using cascading style sheets configured various dashboards and embedded various requests in to the dashboards with the help of pages, columns, sections and dashboard objects according to the business categorization
- Implemented Object level security &data level security to restrict users from accessing unauthorized object
- Assisted in creation of pivot table request allowing manager to analyze the business from different perspective provided optimized analytics request using column selector
- Analyse business problems and design proper solutions utilizing oracle BI enterprise edition (OBIEE)
- Implemented various variables like repository and session variables in RPD
Education
B-Tech -
Saroj Institute of technology and Management
XII - undefined
PMS
Lucknow, Uttar PradeshXI - undefined
PMS
Lucknow, Uttar PradeshSkills
Oracle Business Intelligence (OBIEE) 11g/12c
OAS
OAC
BI Publisher
Oracle Data Integrator
DVA
OFSAA (Beginner)
PLSQL
Oracle Database
Project management
Project planning
Technical support
Project planning and development
Certifications Training
OBIEE 11g Professional Certified (OBIEE 11G)
Educational Overview
- B-Tech (Graduation), Saroj Institute of Technology and Management, Lucknow, Gautam Budh Technical University, 2010, 65.82
- XII, PMS, Lucknow, Uttar Pradesh State Board, 2004, 72
- XI, PMS, Lucknow, Uttar Pradesh State Board, 2002, 68.5
Timeline
Project Manager
PricewaterhouseCoopers Pvt Ltd
10.2024 - 04.2025
Manager
Deloitte Touché and Tohmatsu India Pvt Ltd
11.2022 - 10.2024
Manager
KPMG India Pvt Ltd
07.2020 - 11.2022
Senior Application Developer
Accenture India Pvt Ltd
07.2017 - 04.2020
Consultant
HCL Technologies
07.2016 - 07.2017
Consultant
Capgemini India Pvt Ltd
04.2015 - 07.2016
System Engineer
Tata Consultancy Services
03.2011 - 04.2015
XII - undefined
PMS
XI - undefined
PMS
B-Tech -
Saroj Institute of technology and Management
Similar Profiles
Abhay YadavAbhay Yadav
Senior Associate at PricewaterhouseCoopers Pvt LtdSenior Associate at PricewaterhouseCoopers Pvt Ltd
Sourav DasSourav Das
Senior Application Architect at Pricewaterhousecoopers pvt LtdSenior Application Architect at Pricewaterhousecoopers pvt Ltd
Neha BhallaNeha Bhalla
Senior Consultant at PricewaterhouseCoopers Pvt LtdSenior Consultant at PricewaterhouseCoopers Pvt Ltd