Sanjay

• Used Python extensively for EDA.
• Validated results and performed quality assurance to assess accuracy of data.
• Applied knowledge of data modeling and statistical analysis to note trends and draw conclusions
• Analyzing user requirements and validating the available data to propose usable designs.
• Interacting with multiple stakeholders to gather business needs & developed technical specs,
• Conceptualizing and developing novel reports, dashboards & KPI scorecards on Power BI
• Publishing and sharing reports with the business users Through On premises Data Gateway
• Converting pre-existing Excel-based reports to Power BI dashboards

Data Blending & Transformation

• Accessing & transforming massive datasets through filtering, grouping, aggregation, & statistical calculation
• Combining different data sources to extract uniform data & create views that deliver important insights & developing a 360 business dashboard

Data Visualization & Business Intelligence

• Deploying rich graphical visualizations in dashboards to create effective views of data such as:
• Line Charts, Bar Charts, Pie Charts, Scatter Plots, Histograms, Tree Maps, Heat Maps in Power BI Desktop
• Implementing advanced Power BI features such as parameters, DAX calculations, RLS, Q&A, user filters to deliver dashboards
• Creating different KPIs using calculated key figures and parameters & developing Drill Down
• Designing Power BI Dashboards with interactive views, trends, and drill downs for users.

Environment: Windows 7,Power BI, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL

Requirements Gathering & Dashboard Development

• Liaised with business stakeholders to gather requirements & manage delivery
• Devised rich dashboards using Power BI Desktop to deliver actionable insights
• Connected Tableau server with share-point portal and setup auto-refresh feature
• Played a key role in all phases of development from analysis through implementation and support

Data Visualization & BI

• Made visualizations to clearly demonstrate department spend analysis & performing GAP analysis for various projects
• Used Python extensively for EDA for before performing Data Analysis .
• Defined and incorporated KPIs for customer satisfaction as well as customer acquisition

Data Blending & Security

• Controlled user access by restricting data for particular users using Row-level security & User filters
• Developed Cleaned Dataset ready for Analytics from multiple data sources using Data Transformation (Query Editor).
• Designed & maintained SQL scripts, indexes, & complex queries for the Analytics team of 15
• Resolved end user reporting problems through collaboration with IT and Operations

• Automotive 3W Chassis Frame Analysis as per Road Load Conditions,Using Hypermesh and Abaqus Software Tools and Optimized the mass of frame .
• Air Compressor Skid Frame Analysis subjected to Different Load cases like Wind Load ,Lug Lifting ,Gravity Loadcases etc to identify critical failure locations and modify the design to sustain these critical operational loadcases Using Hypermesh and NASTRAN Tools.
• Thermomechanical Analysis of HP-IP Turbine casing subjected to Pressure load and varying thermal load(Temperature ).
• Strength and Fatigue Analysis of UAV (PANCHI) Critical Brackets using Abaqus and FESAFE Tools.
• Trained Fresh GETs on FE Model Building and Model Checks .

I started my job career with GBN as an CAE Analyst and Worked on Different Automotive Analysis Projects. I used to perform various task related to Automotive components analysis right from FE Modeling,FE Analysis and Report creation along with Trained Different Analysis Tools to students.

I worked in Shetty Polytechnic College as a Lecturer in Mechanical Department , I created awareness among Students about higher education for professional success and mentored for there academic project as well along with regular subjects and also trained students for state CET exams for B.Tech Admission.