Garimella *

BHUVANA GARIMELLA

Professional Summary

Highly analytical and process oriented professional with expertise in data analytics aiming to produce actionable insights with data Technical Skills

Programming: Python, C, C#, C++, R, SQL, Shell Scripting, Scala, HTML, Java Script, CSS, Swift, COBOL Database: Snowflake, Postgress SQL, Microsoft SQL Server, Azure SQL, Redshift (AWS), DB2 Tools and Technologies: Power BI, R Studio, Visual Studio, SSRS, SSMS, MS Excel, Tableau, GitHub, Terraform, Docker, AWS Services, Azure Services, DevOps, Alteryx, Jira, Android Studio, XCode Work History

Full Stack Developer III 11/2022 to Present

Central Michigan University – Mount Pleasant, MI

• Redesign the main CMU website using the Sitefinity CMS

• Enhancing user experience in the existing website by implementing new features and services

• Improvement and maintenance of the existing websites of the university

• Participated in the long-term planning of data warehouse and analytics architectures for the institution, aligning with institutional goals and strategic initiatives.

• Contributing to the creation and management of advanced data warehouse and analytics architectures specific to Higher Education, providing valuable input for solution development and academic insights.

• Actively participating in the ongoing review of existing systems to ensure alignment with established standards, policies, and academic operations

• Applied ETL tools such as Azure Data Factory to develop innovative and scalable data integration solutions, streamlining processes and improving overall data quality.

• Demonstrated proficiency in SQL and utilized dimensional modeling techniques to perform comprehensive data analysis in the Higher Education domain, extracting valuable insights and driving data-informed decision-making. Environment: Azure Data Factory, Azure AD, Azure DevOps, C#, .NET, SQL Server Management Studio, API Testing, Power BI, Microsoft Excel, jQuery, Sitefinity (CMS)

Senior Data Engineer/ Analyst 09/2020 to 11/2022

Ernst And Young, LLP – Cleveland, OH

Client: Maryland Department of Healthcare (March 2021 - Present)

• Worked on setting up a data lake to support data processing, data ingestion, data exchange, data storage and analysis to implement various business intelligence use cases. Mount Pleasant, MI 48858 567-***-**** ad4esy@r.postjobfree.com LinkedIn: Bhuvana Garimella Garimella 2

• Ingested and created data pipelines to integrate raw data from multiple sources for reporting in support of Maryland's operational and strategic decision making

• Built a centralized DataMart to support Maryland's COVID-19 Vaccine allocation. Supported in designing an architectural model to administer data coming from multiple systems as a single source of truth.

• Analyzed complex data and identified anomalies, trends and risks between providers, the MD state reporting systems, and the federal reporting systems to provide useful insights to state of Maryland's COVID response.

• Constantly working with the Governor's office to gather reporting requirements focused on enabling visibility of the COVID- 19 vaccination initiatives across the state.

Environment: AWS Lambda, AWS Glue, Amazon S3, AWS Cloud Watch, AWS CLI, Python scripting, SSIS, SQL Server Management Studio, GitHub, API Testing, Power BI, Microsoft Excel, Power Query Client: Takeda Pharmaceuticals (Sept 2020 - March 2021)

• Developed an automated data retention tool which can be used across various platforms to perform data retention and help reduce storage costs

• Upgraded and configured existing on-prem systems to latest Azure services to enhance security and optimize costs

• Developed dashboard where the user can login and perform day to day transactions.

• Assisted in developing database objects including stored procedures, tables and views in SQL Server Management Studio

(SSMS) using T-SQL to implement backend for web-based dashboards Environment: Azure Databricks, Azure Functions, Azure Blob storage, Azure Data Factory, Azure AD, Azure DevOps, C#, Typescript, .NET, SQL Server, Power BI

Client: Honda (Sept 2020- March 2021)

• Developed, maintained, and scheduled jobs by automating them for daily and monthly processing

• Assisted in maintaining daily data pipelines and in improving the performance of existing systems by optimizing the code.

• Periodically monitored database for availability, storage space and access

• Constructed complex SQL queries, stored procedures, triggers and managed Azure SQL resources

• Developed Power BI reports and dashboards from multiple data sources using data blending Environment: Azure Databricks, Azure Functions, Azure Blob storage, Azure Data Factory, Azure AD, Azure DevOps, C#, Typescript, .NET, SQL Server, Power BI, Microsoft Excel, Power Query DevOps Intern 02/2020 to 07/2020

Stacklogy Inc – Dallas, Texas

• Responsible for automotive cloud infrastructure maintenance, building new operational monitoring, alerting capabilities, implementing and maintaining cloud developed engineering solutions.

• Monitored automated build and continuous software integration process to drive build/release failure resolution. Software Developer Intern 05/2019 to 12/2019

Medical Mutual of Ohio – Cleveland, OH

• Worked on Core Modernization project for the replacement of legacy languages with newer technologies like Enterprise Data Warehouse.

Garimella 3

• Designed and developed reports using SQL server reporting services.

• Developed user interfaces with modern JavaScript frameworks, HTML5 and CSS3 for insurance claims processing.

• Constructed and optimized queries from Enterprise Data Warehouse.

• Utilized IBM DataStage ETL tool for data file processing, storing and updating healthcare data. Software Developer 01/2019 to 05/2019

Progressive Corporation – Bowling Green, OH

• Developed a mobile application/ Chatbot for Android and iOS devices as part of an academic project.

• Gathered and defined customer/ client requirements to develop clear specifications for project plans.

• Collaborated on stages of software development lifecycle from requirement gathering to production releases.

• Implemented natural language processing to map the user input to categorize the message to make a predetermined response in the Chatbot.

• Planned and developed interfaces that simplified overall management and offered ease of use. This proactive customer service through the Chatbot has increased customer base by 20% replacing 40% of consumer work Student Mentor, CODE4her 08/2017 to 05/2019

Bowling Green State University – Bowling Green, OH

• Monitored and supervised young girls in Sphero, LEGO robot-programming workshops assuring realistic objectives, making them familiarize with fundamental programming skills.

• Handled public relations and all external communications related to the sessions encouraging the students in careers pertaining to STEM.

• Teamed with subject matter experts in evaluation and revision of training tools in order to continually improve learning platforms.

Software Programmer Intern, IOS App Developer 06/2018 to 12/2018 The Electric Quilt Company – Bowling Green, OH

• Migrated an existing EQApp written in C++ from 32-bit to 64-bit enabling them to be compatible in either of the environments which benefited 72% of the Apple user base.

• Worked on the design and development of an iOS mobile application. Applied Apple's Swift development language to code native apps for iOS platform.

• Designed user experience frameworks applicable to fit both iPad and iPhone screens. Projects Summary

Amazon Product Rating Data, Analyzing & Building Recommendation Engine

• Developed a python script for appending data from multiple files for 24 different categories to a single file. Analyzed 80 million of items rating structured data, provided for 24 different categories.

• Exploratory data analysis to and out average rating distributions across different categories for users/items, most important items.

• Built a simple popularity based and Item-Item similarity-based recommender system, using Jaccard similarity between the items, in order to recommend similar items.

Garimella 4

Picking the right husband

• Performed Variable selection and data preprocessing in Python.

• Designed machine learning models to predict the future cases (Miss-classification rate 0.35026).

• Puzzled out factors such as ethnicity of dad, smoking, years since last birth to be important which are causes of Low Birth Weight.

Predicting price for an Airbnb and evaluation of Topic modeling for reviews

• Predicted a spot-on expected price for a new place with location and amenities, etc.., a host can offer to Airbnb

• Extracted missing features through text processing, worked on feature engineering, EDA, hyper-parameter tuning

• Developed sentiment classifier using Python to implement topic modeling and discover deciding factors. Education

Bachelor of Science: Computer Science 05/2020

Bowling Green State University - Bowling Green, OH

Contact this candidate