­Sanjeet Gupta Email & Phone Number

Bengaluru, Karnataka, India

POC for Business Intelligence, Data Analysis, Reporting and Analytics, Data Quality, Database, Data Modelling, Requirement gathering, Quality Assurance.Management of Data Visualisation Tools Requirement: OBIEE, Oracle DV Desktop.Knowledge in building WEBCAT reports. Knowledge on Reporting Tool: OBIEE. Excellent knowledge on Oracle SQL. Extensive Knowledge on Oracle Fusion Applications, CRM Applications, Oracle BI Apps. Extensive Knowledge on Jira, BugDB for Defect Management. Extensive… Show more POC for Business Intelligence, Data Analysis, Reporting and Analytics, Data Quality, Database, Data Modelling, Requirement gathering, Quality Assurance.Management of Data Visualisation Tools Requirement: OBIEE, Oracle DV Desktop.Knowledge in building WEBCAT reports. Knowledge on Reporting Tool: OBIEE. Excellent knowledge on Oracle SQL. Extensive Knowledge on Oracle Fusion Applications, CRM Applications, Oracle BI Apps. Extensive Knowledge on Jira, BugDB for Defect Management. Extensive domain knowledge of Subscription, Opportunity, Marketing, Leads areas. Extensively worked on Agile SCRUM model for building new Subject areas and implementing Customer requirements. UAT testing of the reports built by me. Experience in Data Profiling, Data Quality and Data Analysis. Have used developing tools like: Toad, Sql Developer for PL/SQL. Excellent in writing Complex Queries for debugging the issues and for analyzing data and testing the database systems. Working on FAW, OBIA and OTBI Projects. Handling projects related to ETL scripts using PL/SQL. Show less

Bengaluru Area, India

Project: Accenture DCN Internal (Tableau)Built and published customized interactive reports, dashboards, and scheduled reports using Tableau Server.Utilized Tableau features like action filters, parameters, and calculated sets to prepare dashboards and worksheets.Implemented row-level security and user filters to restrict data access for specific users.Blended data from multiple sources to create comprehensive Tableau workbooks.Project: Telenor GSS (Norway) (OBIEE… Show more Project: Accenture DCN Internal (Tableau)Built and published customized interactive reports, dashboards, and scheduled reports using Tableau Server.Utilized Tableau features like action filters, parameters, and calculated sets to prepare dashboards and worksheets.Implemented row-level security and user filters to restrict data access for specific users.Blended data from multiple sources to create comprehensive Tableau workbooks.Project: Telenor GSS (Norway) (OBIEE 11g)Developed reports and dashboards according to user requirements.Managed deployment of changes across multiple environments (Dev, SIT, UAT, and Prod).Successfully handled tickets of various priorities (P1, P2, P3, P4) through the eSD tool.Troubleshot environment and report data issues.Managed change and problem management tasks within the team.Project: ANZ - Security (Australia - New Zealand Bank) (BI Publisher 11g)Worked within the Bi Publisher Reporting Team, focusing on BI Publisher 11g report development.Set up the BI Publisher 11g environment.Implemented security measures for reports.Project: Credit-Suisse (OBIEE 11g)Contributed to the CS Application Engineering Team, responsible for infrastructure deployment and management for new implementations.Built environments, installed and configured OBIEE 11g in development, test, and live environments.Implemented security models and single sign-on (SSO) using LDAP, SQLAuthenticator, and BISQLAuthenticator.Automated OBIEE 11g enterprise installations.Conducted deployments on development and testing environments.Throughout these projects, I demonstrated expertise in Tableau, OBIEE 11g, and BI Publisher 11g. I utilized SQL for database object creation and mapping ERP columns. I managed deployments, troubleshooted environment issues, and ensured adherence to user requirements. Additionally, I successfully led a team and received recognition from both external clients and internal management. Show less

Bengaluru, Karnataka, India

Client: General Electric (GE)Part of a Development & Support Team on OBIEE 11g project.• Responsible for configuring clustering feature of all the BI components.• Created users and groups through WebLogic Console. Also, worked on a SSO (Single Sign On)environment.• Enabled UT (Usage Tracking) on our Environment as per the customer’s requirement.• Facilitated the development request from end users• Has been responsible for applying loads of OPatch (Patch provided… Show more Client: General Electric (GE)Part of a Development & Support Team on OBIEE 11g project.• Responsible for configuring clustering feature of all the BI components.• Created users and groups through WebLogic Console. Also, worked on a SSO (Single Sign On)environment.• Enabled UT (Usage Tracking) on our Environment as per the customer’s requirement.• Facilitated the development request from end users• Has been responsible for applying loads of OPatch (Patch provided by Oracle for OBIEE env.) on Linuxenvironment.• Was responsible for managing all the 3 environments (UAT, Stage and Production).• Proactively responded to all the tickets requested by customers and provided them the resolution in areasonable timeframe.• Worked on the MUD Environment.• Implemented External Table Authentication as per the requirements of the Customer.• Expert in Server installation and configuration of OBIEE and good understanding of server architecture. Show less

Bengaluru, Karnataka, India

• Involved in development of Oracle apps fusion release for Common modules (Item, Inventory Org,Business Unit and UOM & Sales Product Catalog).• Involved in developing- logical scenario, data sheet, RPD test cases to ensure quality assurance.• Installation and Configuration of OBIEE 11.x, DAC 11.x, Informatica 8.6.2, Oracle Client/server 11.xtools.• Running ETL for Common Areas subject areas and analyzing/Fixing task failures to successfullypopulate Data… Show more • Involved in development of Oracle apps fusion release for Common modules (Item, Inventory Org,Business Unit and UOM & Sales Product Catalog).• Involved in developing- logical scenario, data sheet, RPD test cases to ensure quality assurance.• Installation and Configuration of OBIEE 11.x, DAC 11.x, Informatica 8.6.2, Oracle Client/server 11.xtools.• Running ETL for Common Areas subject areas and analyzing/Fixing task failures to successfullypopulate Data warehouse.• Writing SQL Validation queries for Data warehouse.• Creating Report using Answers for Common modules and then testing them.• Created Test Plan Document using Functional Design Documents (FFD) and Technical DesignDocuments (TDD).• Did various types of testing which includes WEBCAT, RPD and ETL Data Verification.• Was responsible for logging bugs against dev team during the process of testing.• Ran ETL in collaboration with DAC.• Collaboration with members teams who are located globally. Hence, mostly had to work across timezones. Show less

Bengaluru, Karnataka, India

Client: SITA (Société Internationale de Télécommunications Aéronautiques)Installation and configuration of Oracle Business Intelligence 10.1.3 and 10.1.4 on Windowsenvironments• Analyzed the requirement gathered from business.• Designed the logics to be implemented at the RPD level.• Maintained the design and development of all layers of OBIEE, Physical, Business Model, andPresentation layer.• Created dimension hierarchies.• Created various logical measures… Show more Client: SITA (Société Internationale de Télécommunications Aéronautiques)Installation and configuration of Oracle Business Intelligence 10.1.3 and 10.1.4 on Windowsenvironments• Analyzed the requirement gathered from business.• Designed the logics to be implemented at the RPD level.• Maintained the design and development of all layers of OBIEE, Physical, Business Model, andPresentation layer.• Created dimension hierarchies.• Created various logical measures for reporting purposes.• Implemented Aggregate Aware to improve the performance of the reports.• Organized the data into related subject areas in a format that is easy for end users to use as basis forreporting.• Creating Presentation Catalogs with measures from Multiple Fact Tables and provided user friendlydescriptions to the columns exposed in the Presentation layer.• Created users and groups in the Admin tool and administered visibility to the presentation catalogs.• Created dynamic repository variables.• Implemented Object level security.• Implemented efficient cache management techniques.• Also worked on BI Publisher to create pixel perfect reports. Show less

Bca, Computer Science

Education record

Education record

Education record