Akshata G Hegde

AWS based Data Engineering project

Client: COX
• Worked as Sr Consultant in Python Data analysis to meet expectations of client COX under Capgemini and to learn, upgrade My skillsets.
• Worked on AWS Athena, Glue ETL, S3, cloud watch, EC2
• Been a part of development of below services.

- Data Exchange
- Data Transformation
• Worked on Oracle and SQL databases.
• Actively worked on JIRAs to fix bugs in above services.

Search machine project for HP

Client: HPE

• This search machine project is new and Currently I am part of senior Python development team to build the product from scratch.
• Working on API development using FastAPI.
• Prepared swagger documentation for FastAPI docs and redoc.
• Owns complete designing and developing service layer for the entire project.
• Developing automated testing tool for all the APIs developed using PyWright.
• Preparing unit test coverages for the code using PyTest

Element Management team
• Worked on data analysis and processing and contributed to It's documentation. Starting from data collection through SFTP/SNMP from multiple sources, data cleansing, data processing
and data storage, data visualization.
• Identify and analyze patterns in complex data sets.
• Design, model and develop ETL scripts for multiple use cases, to extract data from sources and load into data warehouse.
• Migrate required pipelines, scripts, triggers to various environments using AWS.
• Developed below components using Python and owned these completely. Received FY21 Q3 Award for Excellence Design for the same.
- Processor and Persister
- Aggregator
- Exporter
- Data Purger
- Reporting System
• Came up with the idea of using the parquet files for data storage for maximum space efficiency using advanced compression techniques.
• Replaced Ribbon's legacy java code which was used for processing the data by new Python code using data analysis libraries like Pandas and NumPy.
• Developed a framework to integrate unit test case results of all Python components of
Performance Management Microservice with the build using shell and Perl scripting.
• Worked on centralizing the logging system for the entire microservice using Fluentbit.
• Automated complete installation process of PM and reduced installation time by 20%
• Designed and developed Backup/Restore tool for PM.
• Worked on supporting RESTCONF across the EMS product.
• Provided support for Five different releases parallelly While also developing new features of Our current release.
• Provided quick resolutions to any issues from customers - Mainly Verizon, Rakuten and Intelliquent
• Always been good at providing the promptness in communication and fast work around to
unblock customers.
• Worked on Python libraries like pyTest, pandas, NumPy, matplotLib, tableau.
• Handson experience using csv, xml, parquet, json files
• As part of ETL - Used SQL to get data from DB and FTP file based data collection methods to get data from different sources, Pandas/NumPy for data cleansing, processing, aggregation and transformation. Finally load the data into parquet files.