• Contribute as a member of PX4 team within the AiDP (Artificial Intelligence and Data Platforms) department, driving high-impact projects and collaborating with the cross-functional teams to achieve organizational goals. • Improvise the process by creating a common module that includes all shared methods, allowing other ETL jobs referring to its methods; only the common module needs to be updated in case of any changes. • Engage in business projects, including understanding data flow from upstream systems, transforming and loading data in Snowflake tables through ETL processes, and generating files for downstream systems. • Participate in the activity where AWS West region was shut down, and all the requests were redirected to East region, ensuring all the ETL jobs ran smoothly without any issues. • Work on POC project to build Royalty dashboard using the Streamlit framework in Python. • Implement Data Quality Metrics in Streamlit framework of Python, displaying data counts in graphical format for the anamoly detection of Apple’s Media Product usage related data coming on daily and monthly basis.

UPS | Aug 2023 - May 2024

Sr Systems Programming Analyst

• Worked with the Infrastructure side of United Parcel Services in the Department named Global Network Services. • Developed Network Automation Tools using Python to assist Domain Name Service and Network Technology Automation teams with automating the networking tasks. • Assisted in testing and analyzing DNS data during the migration of the DNS tool from BlueCat to Infoblox, ensuring data integrity and seamless transition. • Wrote Python scripts that generated the csv files from Bluecat and Infoblox environment and comparison Python script to find the discrepancy within the data. • Migrated all the previously developed Python scripts for Bluecat environment to Infoblox environment adding new enhancements and features. • Implemented command line statements in Python script for DNS resolution of A, CNAME, PTR records against different DNS servers and generated the csv file for the results. • Created stored procedures in MS SQL Server to enhance security, and improve performance, avoiding the risks associated of SQL injection attacks with direct SQL queries in Python scripts.

Apple | Apr 2022 - Jul 2023

Software and Data Engineer

• Worked in the GBI Core Legal Hold & GBI Finance team in the Snowflake Migration Project. • Built a Python-based Query Engine to extract, process data coming from various core sources and load it into the Snowflake semantic tables. • Developed an outbound process to generate files from Snowflake using the COPY command, store them in S3 for intermediate storage, and then download them in Apache Airflow to send to downstream systems via REST API’s. • Designed and documented the process for building the query engine and outbound jobs by creating detailed flowcharts. • Engineered query engine to execute SQL queries either synchronously or asynchronously, based on the user-provided arguments • Performed process-level dependencies to ensure child processes are automatically skipped if the parent process fails, and executed seamlessly when the parent process completes successfully. • Extensively used exception handling to simplify debugging and error resolution in case of query engine failures or issues with outbound jobs. • Deployed the jobs using the Keystone CICD platform, executed and tested the ETL jobs in Apache Airflow across both test and production environments, ensuring seamless productionisation. • Implemented a logging library in Python to print log statements for queries, info, and errors in Apache Airflow, helping track the progress of ETL jobs. • Utilized asyncio library in Python in order to make synchronous REST API calls and threading library in Python to make the process faster. • Created documentation and conducted knowledge transfer sessions to transition the jobs to the Application Support team, ensuring they fully understood the system after implementation.

UPS | Feb 2020 - Apr 2022

Software Automation Engineer

• Worked with the Infrastructure side of United Parcel Services in the Department named Global Network Services. • Designed and developed Networking Automation tools to improve process efficiency and reduce manual work. • Used BlueCat for IP address management, DHCP allocation, DNS services and various other functions. • Managed IP addresses and host names of all the devices in the UPS Network including workstations, switch, routers, barcode scanners, Printers and many more. • Implement REST API for CRUD operations on the BlueCat Database and SOAP API for retrieving data from UPS user's database. • Utilized Python programming language, including its networking libraries and data types to create CGI tools. • Applied HTML, CSS to enhance the look and feel, and JavaScript to dynamically control the website content in the Python CGI files. • Extensively use Postman for testing API's, Putty for shell scripting and WinSCP for communicating with the servers. • Deployed Microsoft SQL Server for storing data and configurations for switches, routers and load balancers. • Provide 24/7 user support with using the automation tools and for troubleshooting the tools.

Summitworks Technologies | Nov 2019 - Feb 2020

Software Engineer

• Actively involved in Initial software development life cycle (SDLC) of requirement gathering and in suggesting system configuration specifications during client interaction. • Created Django apps and designed data models with Django models and ORM. • Created objects and classes with prototype definition and inheritance for object-oriented programming. • Created API’s, database model and views in python, in order to build responsive web page application. • Involved in the design and development of templates using HTML, CSS, Bootstrap and Javascript. • Utilized CSS for designing, coding and modifying Website from layout to function. • Created and configured EC2 instance and security groups on AWS. • Made use of the Git version control system to track progress and facilitate simultaneous development.

University of New Hampshire | Aug 2017 - Feb 2019

IT Support Specialist

• Provide Tier 1 Support for more than 500+ users, under the supervision of Technical Support Specialist III by troubleshooting for students, faculty, and staff in a timely manner. • Assist developers and QA analyst with Software Development Life Cycle. • Utilized TeamDynamix to resolve the IT related tickets generated by the user. • Design, develop, and maintain optimized databases for testing, production, and training. • Consult with users to determine their technical needs and match them with correct technology solutions. • New systems setup and configuration including installing hardware drivers, Microsoft applications and setting up secure Wi-Fi LAN. • Used system troubleshooting tools to identify any network performance or connectivity issues. • Configuring printers over wireless network and perform printer setup on the computers. • Provide user friendly support in person or via phone.

TheMissionZone | May 2018 - Aug 2018

Full Stack Developer Intern

• Developed an Admin Utilities app for experiential learning project in Laravel Framework of PHP. • Delivered good look and feel using CSS3 and Material Component Design by Google. • Gathered requirements from the business users, created technical specification document. • Used MySQL database for storing data and GitHub for version controlling and management. • Conducted MySQL Server production database analysis on a regular basis. • Created/modified SQL joins, sub-queries, and other T-SQL implement business rules. • Performed BULK INSERT, Imported and Exported data from different Data Sources. • Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans. • Used Trello as a Project Management Tool to keep the track of tasks.

Vodafone | Jan 2016 - Jun 2016

Junior Executive

• Collaborated in a ten-member team to organize one team of Supply Chain Management department, gained complete visibility over the supplier’s practices to prevent organization from enterprise risks and fake transactions which can cause loss to the company. • Operated Material Management module on Enterprise Resource Planning software SAP and used different T-codes to fetch data such as Purchase Orders, Shopping Carts, and Vendor Information. • Applied analytical skills to process the data stored in Excel and SAP and performed audits on the data processed by my other team members.

AISOMEX CONSULTANCY SERVICES PRIVATE LIMITED | Jul 2014 - Jun 2015

Software Engineering Trainee

• Developed models and views using Python/Django to create a user-friendly interface using MVT paradigm. • Actively involved in database admin activities like taking backup, checking log messages and optimization. • Wrote Merge jobs in Python to extract and load data into MySQL database and used Test driven approach (TDD) for developing services required for application.

My Education

Take a look at my formal education

Masters of Science, Information TechnologyUniversity of New Hampshire | 2019

Bachelor of Engineering - BE, Computer EngineeringMarwadi University | 2015

Create Your Data Portfolio for Free