Data Analytics Engineer Resume Chicago, IL - Hire IT People

SUMMARY

Proactive and results - oriented professional Data analyst with 6+ years of solid experiencein Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration and Data Integration.
Expertise in data modelling, database design development and data mining techniques.
Expertise in devising the hidden trends in data and evaluating them to provide business recommendations by designing captivating dashboards, statistical analysis, prediction analysis, data modeling and data mining techniques.
Implemented a wide variety of customer satisfaction strategies with experience in identifying, analyzing and solving customer issues within a variety of organizational structures and corporate development stages.
Analyzed and processed complex data sets using advanced querying, visualization and analytics tools.
Full lifecycle experience in the Business analysis of the Agile Scrum, object-oriented development systems analysis, data wrangling, core documentation, process analysis design, development and testing phases of Software Development Life Cycle.

TECHNICAL SKILLS

Languages: Python, R,SQL,PL/SQL, Java, HTML, CSS, Java Script, XML

Databases: MS SQL Server, Oracle, MySQL, MS Access, PostgreSQL, NoSQL (Cassandra)

ETL Tools: SSIS

Data Analysis Tools: Tableau, Power BI, Advanced MS Excel, SSAS, SSRS, WEKA

Automation tools: IBM RFT

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Data Analytics Engineer

Responsibilities:

Delivered annual network growth prediction engine for Confidential which is extensively used for budget planning and network capacity management. Implemented highly scalable systems to compute the growth with daily volume of over one billion rows. Implemented Cassandra DB to handle a billion rows of network data every day.
Used Time Series, ARIMA and other statistical models to build the growth prediction engine.
Established big-data governance rules, regulations to manage the growth of data. Growth Engine predicted growth within 2% margin of error, has become enterprise growth tool.
Reduced the engineering effect by 30% by designing and developing an algorithm to find the risk of capacity overloading on a link using predictive modelling techniques.
Modelled a database for the entire business unit by collecting and analyzing all the business requirements.
Developed Python, shell scripts for TWC STB and deployed in the Confidential portal which increased the performance, saved time and to ease use most used commands.
Built NLP based ticket classifier for JIRA support tickets and auto assign based on department identified.
Designed and deployed rich graphic visualizations with Drill down and Drop down menu and parameters using Tableau for cost analysis and financial statements.
Developed Complex SQL queries using stored procedures, common table expressions (CTE’s), temporary table to support Tableau and SSRS reports.

Confidential, Ashburn, VA

Data Analytics Intern

Responsibilities:

Enabled a potential savings of $1.5M by identifying 45K hours of non-actionable effort which could be redirected to proactive tasks through text mining of unstructured case notes and implemented a prototype of a multinomial classification model with a feedback ecosystem to completely eliminate no trouble found cases.
Built a live dashboard to help managers monitor change management and engineer’s effort in real time effectively.

Confidential

Data Analyst

Responsibilities:

Worked with Claims, Enrollment and Billing teams.
Achieved 37% reduction in the number of exceptions occurring during claims processing by performing root cause analysis using a combination of heuristics and machine learning.
Performed extracting, auditing and cleaning operations on huge volumes of health care data.
Developed a Predictive Analytical Model by preprocessing the data & implemented Neural Networks in Python (Pandas, Numpy, Scikit-learn) with high accuracy of 82%.
Analyzed the data and identified trends by applying statistical techniques and machine learning algorithms
Responsible for data extraction, cleaning and normalization of semi-annual reports that are generated for clients and in data analysis of metrics and reports involved in assessing client progress over time.
Worked on data validation using advanced SQL and enhanced the performance of huge reports.
Created and produced ad hoc reports, data-driven presentations to answer business questions quickly and thoroughly.
Gathered data from multiple sources using complex SQL Queries and web scraping techniques.
Reviewed and analyzed key metrics to develop an understanding of member’s behavior and communicated findings to planning and development team.