Harshitha Prasad
McKinney,TX
Summary
Masters in Computer Science Kent State University, Kent, Ohio(2021) Bachelors in Informa>on Science New Horizon College of Engineering, Bengaluru, India(2018)
Overview
7
7
years of professional experience
Work History
ETL Developer
Pinnacle Group
, TX
02.2023 - Current
- Use Agile methodology to deliver sustainable code for data processing and perform data quality checks for building data warehouses using industry standard data governance and data privacy rules.
- Collaborate and work cross-functionally with Accounting/Financing team and the Business Analysts team to understand requirements and business processes of the client for whom data modeling and data warehousing plan will be laid out.
- Translate all the requirement gathered from the Analytics team into efficient data warehousing solutions.
- Involved in identifying the data needed for the business problem, implement logging to ensure data availability, data modeling and designing and development of a most efficient data warehouse using star/snowflake schema where all the financial and timesheets information are stored.
- Develop complex SQL queries and Stored Procedures to populate the data into the Facts and Dimensions so that the data is ready to use for Reporting using the Tableau Dashboards.
- Independently design and maintain ETL(Extract, Transform, Load) pipeline using SSIS and Azure Data Factory, maintain data integrity and verifying pipeline stability with limited guidance.
- Deploy SSIS pipelines and manage the version control CI/CD using Git and Azure DevOps.
- Perform unit testing and debugging and support the BA testing to ensure accurate financial data is being populated.
- Support and manage existing data warehouses running in production and implement optimized solutions and manage the defined SLAs and solve some of the interesting data problems with efficiency and integrity.
ETL DEVELOPER
Tata Consultancy Services
, OH
11.2021 - 02.2023
- Implemented and followed Agile development methodology within the cross-functional team and acted as a liaison between the business user group(Pentagon Federal Credit Union) and the data engineering team.
- Responsible for developing the ETL workflow using batch processing which included writing and delivering stable script for production support and resolving business queries while dealing with data using SQL, Python Scripting, Shell Scripting.
- Developing the rules for data transformation based on business requirements and for business improvement using SQL.
- Designed and executed various SQL database queries from MySQL Db package.
- Worked closely with the senior data engineers during data warehousing and deployment process.
- Designed rich data visualizations to model data into human-readable form using Tableau and for the after conversion reports generated after ETL.
- Good hands-on on using SSIS for extracting the data to source tables in the database, generating the reports.
Data Analyst
Wipro Technologies
Bangalore, India
08.2018 - 07.2019
- Used Agile Methodology for Iterative development and rapid delivery of the insights and results to the stakeholders and the customers. Understanding and translating the business requirement and actively participated in the requirement gathering, designing, analyzing and reporting.
- Used Neoload tool to measure the performance(performance management) of the applications and extract the final reports after testing.
- Used Pandas, NumPy, SciPy and Matplotlib in Python for developing various analysis of data sources like flat files, databases etc., derived from the reports.
Education
Masters - Computer Science
Kent State University
12.2021
Bachelors - Informa>on Science
New Horizon College of Engineering
12.2018
Skills
- SDLC
- Agile
- Waterfall
- Python
- R
- Jupyter Notebook
- NumPy
- Pandas
- Matplotlib
- SciPy
- PySpark
- Tableau
- Power BI
- MS SQL Server
- MySQL
- Snowflake
- SSIS
- Azure Data Factory
- Git
- MS Office
- AWS
- Azure DevOps
- Microsoft - Excel
- Windows
- Linux
Publications
A Novel Approach to Detect Acute Lymphoblastic Leukemia, Third IEEE International Conference on Recent Trends in Electronics, Information & Communication Technology (RTEICT), Bangalore, India, 01/18 - 06/18, 02/27/20, 978-1-5386-2440-1
Personal Information
Total Experience: 5+ years of overall experience in the field of data engineering and data analytics.
Timeline
ETL Developer
Pinnacle Group
02.2023 - Current
ETL DEVELOPER
Tata Consultancy Services
11.2021 - 02.2023
Data Analyst
Wipro Technologies
08.2018 - 07.2019
Masters - Computer Science
Kent State University
Bachelors - Informa>on Science
New Horizon College of Engineering