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