SOHAM R JADHAV
SOHAM JADHAV
11850, Dr MLK Jr St N, St Petersburg, FL – 33716 | (Willing to relocate Nationwide)
------------ | ------------ | ------------/in/sohamjadhav/
SKILLS__________________________________________________________________
Programming Languages: Python, SQL, COBOL, NodeJS, JavaScript, VBA, SSIS, SSRS, SSAS
Methodologies/tools: MATLAB/Simulink, Agile, JIRA, Alteryx, Microsoft BI stack, Access, Excel, PowerPoint, Word
Data Tools/Data Visualization: Google Analytics, Azure, Power BI, Tableau, Hive, Splunk, Apache Spark, AWS Redshift, S3, EC2
WORK EXPERIENCE_______________________________________________________ FIS (Fidelity Information Services) – Data Analyst II August 2020-Present
• Migrating, Analyzing and Integrating large financial dataset of WorldPay customers (FIS acquired company) to the FIS dataset by using and accessing FIS mainframe using COBOL
• Executing SQL queries daily to analyze and check accuracy of Customer Demographic data and financial Data files
• Dashboarding and monitoring various parameters of credit details using Power BI and Splunk
• Acting as SME on Data warehousing, ETL Processes and data quality analysis
• Reporting and documenting detailed process for various data files, security keys and pins validation, financial files
• Analyzing in Tableau, the account details and customer data, for checking data discrepancy and inconsistency
• Working on reducing the cost and increasing security of Credit cards with Data analyst, Conversion and Credit Migration team by solving data migration and analysis issues daily
• Mentoring team on SQL test scripts based on detailed functional and workflow design made using MS Visio
• Balancing the account sheets using financial data in MS Excel and Python
Florida Institute of technology – Data Analyst May 2019-June 2020
• Provided key Business Intelligence solutions through predictive module of eSRPD algorithm increasing 28% accuracy
• Extracted, Cleaned and analyzed 30 GB dataset every week of the fundamental frequency and pitch data
• Gathering and analysis of speech data in Excel and Tableau for reporting undetected pitch while parsing data
• Developed creative Dashboards and reports in Tableau enhanced speech resolution pitch determination algorithm created using Python in collaboration with professor and cross functional team
• Updating and querying the speech data on weekly basis in MS SQL server
Florida Institute of technology – Data Analyst Jan 2018-May 2019
• Revised student data every semester in Excel and updated meal plan data in MS SQL environment using the SSAS
tool for business intelligence strategy development which saved 90 man hours every week
• Analyzed, cleaned, and interpreted the complex data of student meals in SQL environment, supported and designed
database modeling and developed meal plan strategies based on KPI by interpreting patterns in data using Tableau
• Created predictive meal plan for different group of students using the predictive modeling in Azure ML Studio
• Reporting to stakeholders for providing insights and key business decisions using data visualization in Tableau
Maestro technologies – Data Analyst Intern May 2018-Aug 2018
• Worked on making ‘i-SCOUT’ device autonomous by using data analytics techniques in Agile team
• Acquiring, and querying of data from various sources using SQL to detect delays in production schedule and
predicting device health of CNC machines which helped to increase the revenue by 18%
• Contributed towards upgrading the visual inspection of ‘i-SCOUT’ device in a startup environment by working with
cross functional teams for automation of data flow and ETL process
• Daily data mining, cleaning, management using Excel and supporting upgrades in database architecture
• Weekly presentation to stakeholders based on KPIs using Dashboards, macros and Pivot tables in Excel
Sanmin Systems – Data Analyst Dec 2016-Jul 2017
• Responsible for head starting a ‘WebEye iIOT solution’ project as data analyst by performing automated data capture
and aligning data architecture with business requirements saving 2100$ every week by automating data entry
• Detailed Excel reporting of cycle time, spindle time and job count data with machine operation time details and efficiency by using Tableau for visualization
• Developed SQL data queries and solved the query issues with minimal supervision
• Implemented statistical modeling and predictive analysis in Python while mentoring colleagues about its development
and contributed towards upgrading database design and data pipelining methods using AWS Redshift
EDUCATION_____________________________________________________________ Florida Institute of Technology, Melbourne, FL. MS in Data Science, Electrical Engineering Aug 2017-May 2019
(statistical modeling, data mining, database design, forecasting and anomaly detection algorithms, Business Intelligence)
Savitribai Phule Pune University, India. B.E in Electronics and Telecommunication Aug 2013-May 2017
SOHAM JADHAV
11850, Dr MLK Jr St N, St Petersburg, FL – 33716 | (Willing to relocate Nationwide)
------------ | ------------ | ------------/in/sohamjadhav/
SKILLS__________________________________________________________________
Programming Languages: Python, SQL, COBOL, NodeJS, JavaScript, VBA, SSIS, SSRS, SSAS
Methodologies/tools: MATLAB/Simulink, Agile, JIRA, Alteryx, Microsoft BI stack, Access, Excel, PowerPoint, Word
Data Tools/Data Visualization: Google Analytics, Azure, Power BI, Tableau, Hive, Splunk, Apache Spark, AWS Redshift, S3, EC2
WORK EXPERIENCE_______________________________________________________ FIS (Fidelity Information Services) – Data Analyst II August 2020-Present
• Migrating, Analyzing and Integrating large financial dataset of WorldPay customers (FIS acquired company) to the FIS dataset by using and accessing FIS mainframe using COBOL
• Executing SQL queries daily to analyze and check accuracy of Customer Demographic data and financial Data files
• Dashboarding and monitoring various parameters of credit details using Power BI and Splunk
• Acting as SME on Data warehousing, ETL Processes and data quality analysis
• Reporting and documenting detailed process for various data files, security keys and pins validation, financial files
• Analyzing in Tableau, the account details and customer data, for checking data discrepancy and inconsistency
• Working on reducing the cost and increasing security of Credit cards with Data analyst, Conversion and Credit Migration team by solving data migration and analysis issues daily
• Mentoring team on SQL test scripts based on detailed functional and workflow design made using MS Visio
• Balancing the account sheets using financial data in MS Excel and Python
Florida Institute of technology – Data Analyst May 2019-June 2020
• Provided key Business Intelligence solutions through predictive module of eSRPD algorithm increasing 28% accuracy
• Extracted, Cleaned and analyzed 30 GB dataset every week of the fundamental frequency and pitch data
• Gathering and analysis of speech data in Excel and Tableau for reporting undetected pitch while parsing data
• Developed creative Dashboards and reports in Tableau enhanced speech resolution pitch determination algorithm created using Python in collaboration with professor and cross functional team
• Updating and querying the speech data on weekly basis in MS SQL server
Florida Institute of technology – Data Analyst Jan 2018-May 2019
• Revised student data every semester in Excel and updated meal plan data in MS SQL environment using the SSAS
tool for business intelligence strategy development which saved 90 man hours every week
• Analyzed, cleaned, and interpreted the complex data of student meals in SQL environment, supported and designed
database modeling and developed meal plan strategies based on KPI by interpreting patterns in data using Tableau
• Created predictive meal plan for different group of students using the predictive modeling in Azure ML Studio
• Reporting to stakeholders for providing insights and key business decisions using data visualization in Tableau
Maestro technologies – Data Analyst Intern May 2018-Aug 2018
• Worked on making ‘i-SCOUT’ device autonomous by using data analytics techniques in Agile team
• Acquiring, and querying of data from various sources using SQL to detect delays in production schedule and
predicting device health of CNC machines which helped to increase the revenue by 18%
• Contributed towards upgrading the visual inspection of ‘i-SCOUT’ device in a startup environment by working with
cross functional teams for automation of data flow and ETL process
• Daily data mining, cleaning, management using Excel and supporting upgrades in database architecture
• Weekly presentation to stakeholders based on KPIs using Dashboards, macros and Pivot tables in Excel
Sanmin Systems – Data Analyst Dec 2016-Jul 2017
• Responsible for head starting a ‘WebEye iIOT solution’ project as data analyst by performing automated data capture
and aligning data architecture with business requirements saving 2100$ every week by automating data entry
• Detailed Excel reporting of cycle time, spindle time and job count data with machine operation time details and efficiency by using Tableau for visualization
• Developed SQL data queries and solved the query issues with minimal supervision
• Implemented statistical modeling and predictive analysis in Python while mentoring colleagues about its development
and contributed towards upgrading database design and data pipelining methods using AWS Redshift
EDUCATION_____________________________________________________________ Florida Institute of Technology, Melbourne, FL. MS in Data Science, Electrical Engineering Aug 2017-May 2019
(statistical modeling, data mining, database design, forecasting and anomaly detection algorithms, Business Intelligence)
Savitribai Phule Pune University, India. B.E in Electronics and Telecommunication Aug 2013-May 2017