Priyanka Goyal Email & Phone Number

Denver, Co, Us

Denver, Co, Us

Englewood, Co, Us

Team: Wireless Cloud Services - Observability- Received M99+ Innovation award for N2/N3 Health Check Automation. - Worked with different teams NOC, Core and RAN to extract data from logs for visibility. - Developed a python script to fetch the Samsung USM Alarms information using REST APIs and push the required data to kafka topic every minute. - Wrote a pyspark script to fetch all the required security scan data from Amazon ECR repositories and push it to S3 and Kafka topic and also to Athena. - Developed a pyspark job to grab the node IP addresses from all EKS clusters residing under multiple AWS accounts and push the data every day to AWS RDS. - Created python scripts to assemble Nokia inventory using Kubernetes from different AWS accounts and for different Integration/Dev regions and pushed the nested json data structure to S3.- Developed Python scripts to gather VMWare cluster inventory using REST API library and merged the data captured through Kubernetes with the cluster information. Data is being pushed to s3 in nested json structure. - Wrote Python script to fetch health check information of hundreds of clusters by executing kubectl commands and pushed the data to datadog as logs. - Wrote Python scripts to fetch Kubernetes data from Prod Mavenir servers and sink the data to S3 bucket and Amazon MSK Kafka in the nested dictionary structure. - Created a python script to post live-streaming of time-series customized metrics using Datadog's HTTP API that can be graphed on Datadog and Grafana dashboards.- Developed a PySpark script to transfer Parquet files from AWS S3 to Redshift cluster and represent the site data seamlessly on Grafana dashboards. The script takes ~200 seconds to ingest 1M+ rows into the database. - Revised all the production data pipelines (using Python) with AWS Secrets integration to encrypt the login credentials and API Keys into a secret. - Actively involved in AWS trainings and prod data pipeline deployments.

Austin, Texas, Us

Worked with Repair Engineering Team of Global Supply Logistics department. - Configured Oracle 19c Database on Oracle Linux 8/ Oracle x86 X6-2L server for team and business requirements. - Designed and developed an internal ETL tool in Python to batch process structured data from different sources to Oracle 19c database.- Evaluated business features, anticipated requirements, uncovered areas for improvement, and developed/implemented data solution based on defined business rules.- Used Oracle Data Modeler to develop Logical, Physical and Conceptual schemas to generate DDL of the database.- Performed advanced SQL queries and developed PL/SQL blocks to manage performance issues.- Implemented Bash automated solutions for manual redundant database and system administration tasks. - Actively worked with 10 different global repair vendors to enhance data capabilities and troubleshoot data oriented repair issues. Showcased my team data management and leadership abilities. - Developed Python - Flask REST API endpoint for application development.- Cut down manual time taken by the team for data gathering from Excel spreadsheets to multiple databases by introducing SQL+ capabilities and SQL developer interface.- Completed multiple data analysis projects using Bash/Python scripting on repair data generated for CGBU products like Tape Libraries (SL series), SDD/HDD families. - Actively involved in learning Supply Chain Management business evolution and provided data management ideas. - Learned to use Automated Test Suite to load new repair test profiles from Ops directories and troubleshoot testing issues (Networking, SW, HW, Scripting) for SPARC/x86 server families.

Englewood, Co, Us

Worked with Commercial Insertion INVIDI team. - Successfully completed Python project to examine multiple XML files located at different Data Servers through SCP connection and change non-unique Event ID using pattern matching and replacement to ensure continuous further spooling.- Created Python script to delete announcement files referencing a non-matching Orbital Location and Resource Satellite URI.- Developed Bash script to adjust time automatically for different set of XML announcement files by pattern matching.- Automated Python scripts to compare files listed in differently located Data Servers and Advertisement Directory and email list of undelivered advertisements to Dish and NCC Media.

Boulder, Colorado, Us

CSCI 3112 - Human Centered Computing Professional Development

Boulder, Colorado, Us

Provided Computer Access and Technology Services to students with disability. I created Braille scripts for visually impaired Math students. The most challenging part was to write complex calculus equations.

Boulder, Colorado, Us

CSCI - 3002 Human-Centered Computing Foundations

New York, New York, Us

Worked with TSO System Infra Services to automate the process of summarizing the noisy alerts from ‘End of Life’ Hardware and sending out a consolidated report on the same to GS Business Unit.

Mumbai, Maharashtra, In

• Configured reports and forms in Primavera CM and Info Maker for the Railway Business Unit.

Master'S Degree, Computer Science

Bachelor Of Technology - Btech, Information Technology