Brief Introduction
- An accomplished Data Analyst offering over 5 years of experience delivering end-to-end Data solutions through designing, building and maintaining Business Intelligence projects
- Creative and dynamic Data Engineer with proven expertise in accurately implementing complex approaches to ensure sustainable delivery to Business
- Leverages unrivalled Data-Warehouse understanding, SQL Knowledge and exemplary communication to effectuate robust development practices and build an impeccable solution while achieving intact Business requirements at minimum budget expenditure
- Adept at working effectively to achieve goals, both as a cross-functional team member and individual contributor
Academic Background
- University of Cincinnati, Carl H. Lindner College of Business, Cincinnati, Ohio, Expecting August 2019
- Master of Science, Business Analytics
- Relevant Coursework completed so far - Statistical Methods, Statistical Computing, Optimization, Probability Models & Presenting Analytics
- Nagpur University, GH Raisoni College, Nagpur, India, June 2013
- Bachelor of Engineering, Mechanical Engineering, GPA 3.8 (WES Evaluation, 76% )
- Relevant Coursework - Operation Research, Relational Database
Professional Background
InfoCepts October 2013 - July 2018 Leading Energy Utilities Company
- Customer 360 - Data Modeler
- Gathered requirements while working closely with business users on 4 major subject areas
- Designed & integrated 30+ new entities as per Enterprise Warehouse standards
- Designed complete ETL process and integrated 4+ heterogeneous data feeds
- Designed & developed dimensions, attributes & metrics on Snowflake & Star Models in Tableau & Microstrategy
- Supply Chain Warehouse - Lead BI Developer
- Reviewed & Optimized Data Models involving 70+ tables
- Created 5+ distinct documents like FSD, WBS, RTM, Project Plan, Estimations
- Managed Resource Allocation & Task distribution in a team of 4 Associates
- Designed and developed ETL process, prepared data federation layer & created specs
- Created reports and objects in Tableau & Microstrategy based on specific requirements
- Assets and Outage Maintenance - BI Developer
- Created Functional Requirements working closely with Business Analysts
- Designed, Developed, Tested and Deployed ETL Solutions involving 50+ tables
- Created numerous artefacts like BRD, FSD, ETL Run-books, Disaster Recovery
- Developed Operational and Analytical reports in Tableau & Microstrategy
- ETL Support & Maintenance - BI Support Analyst
- Monitored and supported 25+ legacy systems and subject areas
- Optimized code performance for 5+ subject areas to adhere to Business SLAs
- Designed & Developed 100+ Code enhancements & analyzed 100+ recurring failures for permanent fixes
- Automated monitoring and grooming processes for 25+ subject areas
- Rectified errors encountered by Business Users in Tableau & Microstrategy Reports
- Sr. Business Intelligence Trainer InfoCepts
- Delivered 50+ lectures to college graduates & laterals on SQL, Data-warehousing, ETL & Reporting
- Mentored 4+ Business Intelligence Inters’ teams comprised of college under-graduates
- Conducted 3+ training sessions for new Trainers and revamped Course material based on trainees’ feedback
- Organized and facilitated end to end ETL training programs for 6+ batches of college graduates & laterals
Experience with R
- Intermediate level courses on Datacamp
- Data wrangling in R