Himamshu Chandrashekara

Business Data Analyst

New York City, NY 13210 • ad0dkc@r.postjobfree.com • +1-680-***-****

• https://www.linkedin.com/in/himamshukc/ • GitHub: https://github.com/himamshukc96 • Tableau: https://rb.gy/p8g2x SUMMARY

• 2+ years of experience as an Associate Software Engineer/ Data Analyst with a good understanding of Data Modeling, Evaluating Data Sources and understanding of Data Warehouse/Data Mart Design with Oracle Database SQL Certified Associate.

• Proficient in complete Software Development Life Cycle SDLC for the projects using methodologies like Agile and Waterfall.

• Ability to Perform data manipulation, data preparation, normalization, and predictive modeling Improve efficiency and accuracy by evaluating models in Python and R. Well-versed in using various packages in NumPy, Pandas, Matplotlib, SciPy, and ggplot2.

• Good Knowledge of using commands in creating backups and restoring backups of Tableau/ Power BI repository.

• Capable of designing and maintaining MySQL databases and creating pipelines using user-define functions and store procedures for daily reporting tasks.

• Proficiency in Databases and concepts such as Data Cleaning, Data Visualization, Designing, Data Testing, and Generating interactive business intelligence reports, document current business processes.

• Elicit, document, and translate business requirements into actionable plans that drive operational excellence and desired business outcomes and assist in the design of streamlined flows and processes within solutions delivered by the Software Development team.

• Develop and define project roadmaps, ensuring alignment with strategic imperatives and initiatives. Ensure user stories include validation criteria which covers all areas necessary to complete the testing of new functionality. PROFESSIONAL EXPERIENCE

ATOS Bangalore, India

Associate Engineer / Data Analyst AUG 2018- JULY 2021

● Developed and maintained Tableau-based CRM asset performance dashboards for the Digital Twin IOT windmill industry project, showcasing KPIs such as power generation reports and maintenance insights, facilitating work orders and maintenance engineer requests.

● Leveraged PostgreSQL and SQL queries to efficiently manage and manipulate complex datasets, employing joins and Common Table Expressions (CTE) for data optimization. Improved PostgreSQL database design and indexing strategies to enhance query performance.

● Tracked project progress and updated JIRA tickets for daily team meetings, ensuring efficient project management and communication and applied analytics skills to provide valuable insights and support data-driven decision-making.

● Executed data cleansing in Microsoft Excel using pivot tables and advanced formulas, including v-lookup, while conducting comprehensive data analysis and validation for data quality management initiatives.

● Designed ETL processes, data pipelines, and SQL queries to extract, cleanse, merge, and load data from various sources into target text files, ensuring data accuracy and consistency.

● Collaborated with diverse cross-functional teams of over 20 members and senior executives to launch a new feature in an updated version, enhancing windmill remote control capabilities and improving page load performance by 23%. PROJECTS

LOAN DEFAULT PREDICTION ANALYSIS

● Collected and integrated data from heterogeneous sources, ensuring data standardization using Python (Numpy, pandas, matplotlib, sklearn, nltk, scipy), later generated descriptive statistics to find out trends in defaulter behavior.

● Achieved an accuracy of 87.1% to predict loan defaulters by building a logistic regression model and decision tree models with an accuracy of 84.4% and applied association rule mining to support findings.

MUSIC ANALYTICS DASHBOARD - AWS QUICKSIGHT

● Designed serverless data lake architecture and built a data processing pipeline and Data Lake availing Amazon S3 on 10000+ live data.

● Devised Amazon Kinesis for real-time streaming data and AWS Glue to automatically catalog 2 datasets and applied AWS Glue Studio to run, monitor ETL jobs in AWS Glue and streaming data per day was loaded to AWS Redshift Data warehouse.

● Generated interactive graphical dashboards in AWS Quicksight for meaningful insights on trending artists, users, and popular tracks employing Lambda function to execute specific queries in AWS Athena.

HOTEL BOOKING CANCELLATION PREDICTION ANALYSIS in R

● Researched and Performed EDA on 70k+ rows to identify trends and map potential gaps KPIs in marketing strategies for reducing booking cancellation.

● Boosted SVM model performance by enhancing performance prediction to determine and train machine learning model to achieve more than 75% balanced accuracy, and provided recommendations based on those determinants.

● Developed predictive analytics solution to determine likelihood of canceling a booking produced three insights, to revise current deposit policy, promote customization and prioritize affiliation with Tour Operators. EDUCATION

SYRACUSE UNIVERSITY Syracuse, NY

MASTER OF SCIENCE IN INFORMATION MANAGEMENT 2021-2023

( Certificate of Advanced Study in Data Science )

Coursework: Database Administration Concepts, and Database Management (SQL), Scripting for Data Analytics (Python), Project Management (MS Project), Quantitative Reasoning for Data Science, Visual Analytics Dashboard (Tableau/ Power BI), Business Analytics, Applied Machine Learning (R) M.S. RAMAIAH INSTITUTE OF TECHNOLOGY Bangalore, India Bachelor of Engineering, Electronics and Communication 2014-2018 SKILLS

● Methodologies: SDLC, Agile, Waterfall

● Programming Languages: SQL R, Statistics (Hypothesis Testing, A/B Testing), Python, HTML, CSS.

● Packages: NumPy, Pandas, matplotlib, sklearn, NLTK, SciPy, ggplot2, Seaborn

● Visualization Tools: Tableau, Power BI, Microsoft Excel

(Lookup, correlation, regression, Pivot Tables, Pivot Charts,3D Maps, Power Query, Solver Optimization, forecasting, Power Pivot), MS Access (Queries), Google Analytics, Orange Data Mining, Looker, Google Data Studio, SSRS.

● Database: MySQL, SQL Server, Snowflake, PostgreSQL.

● Other Skills: Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving

● Operating System: Windows, Linux

● Certifications: Oracle Database SQL Certified Associate