SOHAM JADHAV

*****, ** *** ** ** N, St Petersburg, FL - 33716

321-***-**** adg6yp@r.postjobfree.com www.linkedin.com/in/sohamjadhav/

SKILLS

Programming Languages: Python, SQL, COBOL, NodeJS, JavaScript, VBA

Methodologies/tools: MATLAB/Simulink, Agile, JIRA, Alteryx, Microsoft BI stack, Access, Excel, PowerPoint, Word

Data Tools/Data Visualization: Google Analytics, Azure, Power BI, Tableau, Databricks, Apache Spark, AWS Redshift, S3, EC2

WORK EXPERIENCE FIS (Fidelity Information Services) – Data Analyst II August 2020-Present

Migrating 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 and financial Data files

Reporting and documenting detailed process for various data files, security keys and pins validation, financial files

Analyzing in Power BI, 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

Developed test cases and SQL test scripts based on detailed functional and workflow design made using MS Visio

Balancing the account sheets using financial data in MS Excel

Florida Institute of technology – NLP Data Analyst May 2019-June 2020

Parsed large data set of TIMIT and LibriSpeech through predictive module of eSRPD algorithm achieving 78% accuracy

Extracted 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

Achieved better results in extracting fundamental frequency by fine tuning enhanced speech resolution pitch

determination algorithm in collaboration with professor

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 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

eMaestro 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 – Data Analyst Dec 2016-Jul 2017

Responsible for head starting a ‘WebEye iIOT solution’ project as data engineer 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 (BI Stack SSAS for cycle, spin and job count, SSRS for machine operation time details)

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 Electrical and Computer engineering Aug 2017-May 2019

(statistical modeling, data mining, database design, forecasting and anomaly detection algorithms, ML modules)

Savitribai Phule Pune University, India. B.E in Electronics and Telecommunication Aug 2013-May 2017

(data analytics, data modeling, neural network, embedded electronics, business intelligence)

Contact this candidate