Badges
Certifications
Work Experience
Consultant - Data Engineer
Affine Analytics• February 2020 - Present
● Developed a Data-Quality Framework which enforces data aggregation rules and SEM taxonomy validations using TeradataSQL and python across multiple platforms ● Created an alert engine over the framework to send email notifications for job completion and error correction ● Automated the python code using shell scripts for the marketing analytics taxonomy project which validates daily Disney SEM impressions on various media platforms like Google, Bing, YouTube, etc. using TeradataSQL
Analytics Engineer
ANB Systems Inc• August 2019 - January 2020
● Developed and designed python scripts to predict digits off 7-segment led energy meter displays with Image Processing using OpenCV, and Machine Learning using KNN classification algorithm with 89% accuracy ● Created algorithms and designed data pipelines to perform ETL operations and provide data to Machine Learning models using scikit learn and store generated pickle files in Amazon S3 utilizing API calls and python scripting ● Created a document classifier using NLP, nltk, topic modeling and text processing that predicts the document tag ● Collaborated with Business Analysts to design a scalable data model to predict project timelines using support vector machines and feature hashing and helped them to clean data and reduce data redundancy ● Proficient in designing ETL scripts for large data sets using NumPy, Pandas, scikit-learn, matplotlib, joblib etc. ● Wrote functional unit test cases for testing the data pipeline scripts that were developed using python ● Performed Time Series Analysis on project growth data and forecasted future growth using SARIMAX ● Analyzed trends and performance of each of the clients and created reports for the CEO using MS-Excel
Business Intelligence Analyst
Jagged Peak• August 2018 - April 2019
● Developed QlikView dashboards to depict product inventory and pricing information; reducing workforce by 20% ● Proficiency in hands on data gathering, data cleaning and data processing product inventory reports and retail pricing datasets of over 200 merchants using Python, SQL, Advanced Excel ● Designed Salesforce objects, leads, quotes, user roles and profiles which improved user satisfaction by 25% ● Worked with project management and collaboration tools like JIRA, Confluence and was exposed to data warehousing concepts ● Integrated Salesforce trailhead environment onto the production sandbox for the firm to increase user visibility Salesforce : https://trailblazer.me/id/dhann1
Senior Systems Engineer
Infosys Limited• July 2014 - June 2017
Clients –Investment Banking, Airlines ● Database analyst for the baggage management portfolio of a fortune 500 Airlines firm following Agile methodology ● Analyzed data of hand-held bag scanners from various data sources to track baggage metrics and reduce flight delays using SQL and Splunk which effectively increased efficiency by 30% ● Coordinated with SPRINT to resolve network issues affecting flight delays and improve scanner efficiency by 50% ● Streamlined server health-check reporting processes using Tableau and developed data visualizations for KPIs ● Performed Root Cause Analysis, which helped in identifying misplaced baggage instances and flight delays ● Gained advanced SQL skills by writing complex SQL query aggregation functions, Window Functions, etc. ● Managed database and administration for the revenue management portfolio of a fortune 500 investment banking firm ● Managed code deployment for around 35-40 Functional Teams. Code deployments were done using Sybase database (Schema, Views), Linux and UNIX hosts ● Optimized querying large scale databases using SQL scripts by joining data from multiple relational databases ● Automated server version upgrades by creating web applications and internal tools using Perl-scripting, SQL, CSS and HTML on Sybase and Linux data servers, which helped in increasing efficiency by about 55% by reducing downtime by almost 1 day
Education
University of South Florida
Busines Analytics and Information Systems, MS• August 2017 - May 2019
Research Projects: ● Developed an interactive and dynamic web chat dashboard using open source JavaScript library D3.js, Python, JavaScript, FLASK, NLP and text processing that displays details of HR dataset through natural language extraction ● Collaborated on the study ‘Econometric Analysis of the learning outcome of online academic courses’ - to identify the impact of different mode of instructions on the learning outcome of students using STATA, Excel, Propensity matching ● Forecasted S&P500 stock fluctuations by time series modelling with an error rate of 14% using R, Tableau, ARIMA ● Created a model to predict bankruptcy using Linear regression, Tableau, MS-Excel, Random forest, scikit-learn