Sourabh Jain
Pune
Summary
Results-driven IT professional with over 12 years of experience in Business Intelligence (BI), ETL, and Data Modeling for Data Warehouse projects across both Cloud and On-Premises environments. Proven track record in designing, developing, and deploying BI solutions for diverse clients in the banking, manufacturing, and subscription sectors. Demonstrated ability to deliver impactful data insights that drive business decisions across multiple locations including the USA, Mexico, and India.
Overview
14
14
years of professional experience
Work History
BI Team Lead
Parametric Technology Corporation
Pune
04.2021 - Current
- Leveraged knowledge to design and sustain the Corporate Data Model.
- Integrated diverse sources like Zuora, Onshape, ERP, Salesforce, Intland.
- Transitioned financial modules AR/AP/GL from Oracle EBS to Oracle Fusion.
- Developed pipelines from BICC to transfer fusion data into the warehouse, and developed Tidal jobs to initiate BICC tasks.
- Facilitated design discussions with Business and ETL designers to develop an appropriate Data Mart.
- Planned and executed comprehensive OAC solutions.
- Identified multiple bugs in OAC data visualization and added them in the Oracle Ideal Lab.
- Developed Data Lineage tool to detect object dependencies in Data warehouse.
BI Expert
Cognizant Technology Solutions
Pune
02.2020 - 04.2021
- Adopted structured Agile development methodologies.
- Developed comprehensive functional and non-functional documentation.
- Engaged in data modeling discussions with data modelers and ETL designers.
- Led offshore team to ensure timely project deliverables.
- The technicality of this role includes building interactive dashboards, ad hoc reports, canned reports, drill-down reports, write-back reports, union reports, calling functions and procedures from reports, agents, briefing books, and configuring OBIEE security in terms of OBIEE and BIP reports.
BI Expert
Cognizant Technology Solutions
Pune
07.2018 - 01.2020
- Company Overview: BioMarin is a world leader in R&D of biopharmaceuticals, developing and commercializing innovative biopharmaceuticals for rare diseases driven by genetic causes.
- Cognizant, as a BI team, handles operational and analytical reporting for the BioMarin user.
- Collaborated with users to gather feedback on business issues, developing tailored BI Reporting strategies.
- Prepared technical solutions based on business requirement documents.
- Design, develop, and implement a custom-made end-to-end BI solution according to the plan using reporting, ETL, and data warehousing tools.
- Provided Level 2 and Level 3 application support.
- On the ETL side: getting the mappings, workflows, and sessions created, tested, scheduled, and deployed in Informatica.
- Utilize the extensive experience in writing stored procedures, materialized views, triggers, complex queries, and subqueries using PL/SQL.
- Worked on optimizing the performance of the existing reports by tuning the SQL queries.
BI Expert
Tata Consultancy Services
Pune
02.2013 - 05.2018
- Experinced in end-to-end development of project from requirement analysis with End user to system study, designing, coding, testing, debugging, documentation and implementation.
- I analyzed the data and developed a logical star schema model with consultation from data modelers and business analysts.
- Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer, as per the business requirements.
- Designed and developed various interactive dashboards and reports with drilldowns, guided navigation, filters, and prompts.
- Created various session and repository variables, and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
- Configured BI Scheduler and Oracle BI Delivers—iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
- Used various cache management techniques for performance tuning, including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
- Created security settings in the OBIEE Administration Tool, set up groups, access privileges, and query privileges, and also managed security for groups in Answers.
- Unified BI Publisher and OBIEE for report generation in word, excel, and doc format.
- Created and tested complex Informatica ETL jobs using various transformations, such as source qualifier, lookup, joiner, router, aggregator, and update strategy in 9.x and 10.x.
Software Engineer
Zensar Technologies
Pune
01.2011 - 01.2013
- I worked for Al Hokair and KOJ, prominent retail houses in the Middle East, on their BI needs in terms of reporting.
- Created RPDs, reports, dashboards, iBots, database objects, and data loader stored procedures.
- Involved in the implementation of RDW for Al Hokair.
- My role involved extracting, loading, and fixing ORMS dimensions (such as product hierarchy dimensions and organization hierarchy dimensions) to ORDW.
- Identified facts, dimensions, levels/hierarchies of dimensional modeling.
- Customized and developed RPD (Physical, BMM, and Presentation Layer).
- Developed many reports and dashboards with different analytics views (drill-down, pivot table, chart, column selector, and tabular with global and local filters) using OBIEE.
- Used various time series functions to create trending reports of sales.
Education
Bachelor of Engineering - Computer Science and Engineering
IES IPS Academy
Indore, India06.2010
Skills
Application and Domains
ERP, Salesforce, Banking, Manufacturing/Supply Chain, Healthcare, Oracle Retail, Subscription Model
Reporting and analytics tools
OAC, FAW, OBIA 79x, OAC, Power BI, Qlik, Informatica 9x/10x, IICS, ODI, Erwin
Development and scheduling tools
Jenkins, Putty, TOAD, SQL Developer, DAC, Tidal, Appworx
Azure Services
DevOps, Event Hub, CI/CD Pipeline, Key Vault, Azure Monitor
Databases
Oracle, MS SQL Server
Programming languages
SQL, PL/SQL, HTML, JavaScript, Unix
Methodologies
Software Development Life Cycle (SDLC), Agile methodologies
Project Tracking Tools
JIRA, Codebeamer, ServiceNow, Confluence, GitHub, Microsoft Flow
Personal Information
Title: BI and Data Modeler
Achievementscertificationsandtrainings
- Identify, investigate and analyze business processes, procedures and work practices. (Process Improvement, Saving of $20k).
- Got appreciated by the customer for providing an input for and delivering an OBIEE report that showcased how cost management can be made different for different customers based on the dirtiness of the parts received for the servicing.
- Oracle Cloud Platform Enterprise Analytics 2019 Associate Certified
- Oracle Cloud Infrastructure Foundations 2020 Certified Associate
- Certified SAFe 5 Practitioner
- Azure Services Trainings - Azure Data Lake Storage (ADLS), Azure Data Factory, Azure DevOps.
Timeline
BI Team Lead
Parametric Technology Corporation
04.2021 - Current
BI Expert
Cognizant Technology Solutions
02.2020 - 04.2021
BI Expert
Cognizant Technology Solutions
07.2018 - 01.2020
BI Expert
Tata Consultancy Services
02.2013 - 05.2018
Software Engineer
Zensar Technologies
01.2011 - 01.2013
Bachelor of Engineering - Computer Science and Engineering
IES IPS Academy
Similar Profiles
Brandon PerkinsBrandon Perkins
Senior Engineering Manager at Eaton CorporationSenior Engineering Manager at Eaton Corporation
Vaibhavi RaghavVaibhavi Raghav
Cloud Services Ops, Engineer at Parametric TechnologyCloud Services Ops, Engineer at Parametric Technology
Michael Zaslavsky, CFA, CAIAMichael Zaslavsky, CFA, CAIA
Senior Investment Strategist at Parametric Portfolio | Morgan StanleySenior Investment Strategist at Parametric Portfolio | Morgan Stanley