CHAITANYA PRASANNA KUMAR

+1-857-***-**** adhnl0@r.postjobfree.com linkedin.com/in/chaitanya-prasanna-kumar TECHNICAL SKILLS

Database: Oracle 18c, MySQL, Microsoft SQL Server, PostgreSQL, MongoDB (NoSQL), PL/SQL Data Integration/BI: Talend, SSIS, SSRS, Tableau, Qlik Sense, Power BI, Einstein Analytics, Informatica, Streamlit, Looker, Bokeh Programming Languages: SQL, Python (Pandas, NumPy, Scikit-learn, Matplotlib, Scipy), PLSQL, HTML, CSS, R, Java, JSON Data Skills: Exploratory Data Analysis, Data Mining, Statistics, Machine Learning Algorithms (Regression, Decision Trees, Classification, Hypothesis testing), Data Modeling, Big Data (Hive, Pig, PySpark, SparkSQL, HDFS) AWS Technologies: AWS S3, IAM, Athena, Redshift, SageMaker, CloudWatch, QuickSight Others: GitHub, Microsoft Excel (Pivot Tables, Macros, VLookUps), MS Office, JIRA, PowerPoint, UNIX, Visual Basic, Google Analytics, A/B Testing, ER Data Studio, Alteryx, Google BigQuery, Google Data Studio PROFESSIONAL EXPERIENCE

• Collaborated with Business users to build Qlik Sense app following Agile methodology (Scrum) by leveraging On-Demand App Generation (ODAG) to facilitate self-service analytics (non-SQL based) of 50M customers (financial dataset) efficiently

• Developed Qlik Sense dashboard for Customer Branch Conversations data enabling deeper insights to manage KPI metrics

• Reduced app data load and refresh time by optimizing SQL scripts/queries in Qlik Data Load Script by 20%

• Governed data using Collibra & Allation tools to update Business terms, its description and SQL queries for Engineers & Scientists

• Built Proof of Concepts (POC) for Data Migration of Customer data from legacy database systems to the Datawarehouse

• Participated in hackathon to build an R Shiny app leveraging Git and R (Shiny, Ggplot2) to carry out Exploratory Data Analysis, Anomaly Detection and Trend Forecasting using time series analysis for business partners

• Gathered business requirements, analyzed, prepared technical design documents with attention to detail & developed Java code adhering to high quality standards within stipulated timeline using Software Development Lifecycle

• Documented and validated 54 Test Cases using SQL Queries for accuracy & consistency of the data ingested into Oracle database

• Automated 54 QA Test case scenarios using Selenium to perform Regression testing of the web application

• Created Stored Procedures, Triggers and upgraded SQL scripts for efficient and faster execution by 30%

• Extended support to 3 associates in creating reports & transitioning to Tableau dashboards and Business Partners in UAT ACADEMIC PROJECTS

Algorithmic Digital Marketing (Python, Jupyter Notebook, Flask, Heroku, PowerBI, Structured dataset April 2020 Implemented Pricing strategy based on Customer Segmentation & Customer Lifetime value Prediction (LTV) models to offer best deals/discounts and built recommendation models using Content Based Recommendation

• Created a Flask based web application incorporating Machine Learning models and deployed it on Heroku for End Users Advanced Data Science April

• Preprocessed Cardiac Dysrhythmia unstructured dataset, then performed Data Analysis & Visualization to classify Human Heartbeat by incorporating Logistic Regression, SVM and Random Forest models using Python and Matplotlib

• Improved the accuracy of the models to 98% by using Keras CNN & LSTM models by tuning Hyperparameters

• Designed Dimensions & Facts in Star/Snowflake schema for Adventure works database & built ETL pipeline using SSIS and Talend

• Implemented error handling, slowly changing dimensions, currency conversion & output stream for Performance tuning to integrate data from different database sources - SQL Server, MySQL, Oracle, PostgreSQL to target data warehouse

• Built interactive dashboards to pull business insights by capturing trends & patterns using Tableau, Power BI & Qlik Sense

• Designed ER model (normalized to 3NF) and implemented an end to end restaurant database for analysis Implemented stored procedures, triggers, functions, transactions, cursors, queries & views to respond to customer’s requests Dec

College of Engineering Northeastern University, Boston, MA Aug 2012 -

Visvesvaraya Technological University, Bangalore, India CERTIFICATION

• Tableau Certified Desktop Specialist

• Oracle Autonomous Database Cloud 2019 Certified Specialist