About Me
12+ years experienced BI and data warehousing professional adept at collecting, analyzing and interpreting large datasets, developing analytical solutions to provide valuable insights from raw data. Proficient in designi…
12+ years experienced BI and data warehousing professional adept at collecting, analyzing and interpreting large datasets, developing analytical solutions to provide valuable insights from raw data. Proficient in designing and implementing data warehousing & BI solutions for banking, healthcare and manufacturing domain.
Experience
Senior Consultant
Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI
Senior Consultant – Oracle Analytics Cloud/Fusion Analytics Warehouse
<p>Creating appropriate BI data model suitable for reporting out of data present in a format of entity relationship model<br>
Gathering and analyzing requirements and building various reports to create dashboards to report default management<br>
Leading the BI team to provide Analytics solutions for the client<br>
Provisioning FAW, configuring Data Pipelines and enabling different fusion Analytics(ERP,SCM etc.) offerings<br>
Working on Data Augmentation and Semantic Model Extensions to meet the custom requirements<br>
Implementing custom and OOTB security in FAW and validating the data in FAW with OTBI<br>
Interacting with business leaders to understand their pain points and current state architecture and reporting needs</p>
Data Analyst
<p>Analyzed various datasets to extract hidden and meaningful information from the data and build predictive models<br>
Adapted various Data Processing techniques for making data useful for creating Machine Learning models<br>
Developed models by using different algorithms such as Linear Regression, Decision Tree & Random Forest<br>
Created POC’s/POV’s for client to automate through Machine Learning and NLP using Python</p>
Senior ETL Consultant
<p>Created ETL source to target mapping document by understanding the business requirement<br>
Prepared HLD(High Level Design) and LLD(Low Level Design) by discussing with functional users and Business Analyst<br>
Developed complex mappings by creating Aggregate, Router, Sequence generator and dynamic lookup transformation<br>
Tuned performance of mappings and sessions by identifying the bottlenecks in existing process<br>
Built Update Strategy and Lookup transformation to implement the Change Data Capture CDC process<br>
Created connections, sessions, tasks and workflows utilizing Workflow Manager in Informatica Powercenter<br>
Implemented Push down optimization to improve the system performance<br>
Created UNIX shell script for file processing to third party vendor through SFTP, encryption and decryption process</p>
BI Analyst/OBIA Consultant/Tableau Analyst/Tech Lead
<p>Led a team of ~15 as a Technical Lead for upgrading OBIEE 11g to OBIEE 12c for a Banking client<br>
Trained ~4 fresher’s within the team in OBIEE to groom them for taking up the future challenging works<br>
Interacted with Business users for gathering requirements for GAP Analysis and prepared technical design documents<br>
Implemented Financial Analytics including installation, configuration and customization of OBIA for manufacturing client<br>
Designed efficient Tableau dashboards through efficient use of Tableau Desktop involving multiple datasets<br>
Designed documentation of the Tableau Dashboards by evaluating functional and technical business requirement<br>
Awarded as Star of the Quarter by TCS inSep’16 for leading the team for defect free delivery for a mission critical project<br>
Awarded as Star of the Month by TCS in Jan’17 for leading the team of 15 people for delivering the project successfully</p>
OBIEE Developer
<p>Developed reports, dashboards and dashboard prompts in OBIEE Answers<br>
Created/modified Metadata repository using the OBIEE 10g/11g's Physical, BMM and Presentation Layers<br>
Designed and modified OBIEE security using roles, privileges in EM, Administration Console to Access security</p>