Deepthi N Email & Phone Number

Responsible for developing, deploying and automating various AWS resources in Cloud- basedinfrastructure using Cloud Formation Template.• Used FastAPI framework, REST API and AWS services for Web application. Developed Python basedAPI (Restful Web Service) to track the events and perform analysis using FastAPI.• Used Postman tool to test RestAPI request and response.• Analyzing data using Pandas, Matplotlib, NumPy libraries and visualizing data using Tableau.• Making Salesforce data available to consumers in real-time and on demand using AWS resources(App Flow, Event Bridge, Lambda, SQS, SNS, CloudWatch Alarm, DLQ, Kinesis Stream).• Deployed SQS queue provisioned resource to receive the Dead Letter Queue (DLQ) from failedworkflow and trigger the Lambda to redirect failed event to Kinesis stream and send notificationusing SNS, CloudWatch Alarm.• Managed, developed, and designed a dashboard control panel for customers and Administratorsusing Django1.10, Jinja, Oracle DB, PostgreSQL, and VMWare API calls.• working on building amazon-EKS from scratch by using EKSCTL and creating multiple node-groupsand Namespace according to the application requirement.• working on building Amazon-EKS cluster microservices deployments using Amazon Code-Pipelinesand Amazon ECR.• Performed downstream data consuming using Secrets Manager, Lambda to write data toDynamoDB and data is available when triggered through AWS API Gateway.• Used AppFlow to enable applications to Integrate with applications hosted on SaaS systems(Salesforce) and transfer the data between AWS platform and SaaS Platform Seamlessly.• Proficient in SQL databases MySQL, PostgreSQL, Oracle and MongoDB.• Optimization of Hive queries using best practices and right parameters and using technologies likeHadoop, YARN, Python, PySpark.• Written Python utilities and scripts to automate tasks and to transfer data into S3 bucket usingboto3.

Chennai, Tamil Nadu, India

Collaborated with Analytics and BI teams to develop globally adopted metrics and reporting-on-demand solutions, reducing manual data analysis by over 60%. Streamlined data integration, profiling, and validation for various data company-wide from multiple sources, increasing data accuracy by 40%. Developed and maintained stored procedures, views, and functions in SQL server to optimize data extract, transformation, and load (ETL) processes by 30%. Developed detailed data models and dictionaries for use in data warehouses, enabling stakeholders to easily access and report on critical organizational data. Experience in microservices architecture, web application development using Django, and implementing automated testing. Involved in migrating on prem Hadoop system to using AWS. Managing and Scheduling Jobs on Hadoop cluster. Worked on analyzing Hadoop cluster and different big data analytic tools including Pig HBase database and Sqoop. Developed a Tableau dashboard on top of the metric dataset to visualize mobile ads performance and report to leadership team. Developed spark applications in python (PySpark) on distributed environment to load huge number of CSV files with different schema in to Hive ORC tables. Defining Automation Test Strategy, Test Approach and Test Planning for the Agile Sprints and releases. Developed and maintained Verizon co-op crowd web application using Python, Django, and Flask, resulting in enhances performance and scalability. Created a report generation logic of the customers which saved a time to get the results of the customer. For the extraction of data from the database, we created queries and stored procedures for normalization and denormalization using MySQL. Followed Agile methodology to develop user stories, work through the backlog, and use Jira to document the stories and defect tracking.

Hyderabad, Telangana, India

Created a Python/Django based web application using Python for data processing, MySQL for the database, and HTML5/CSS3/jQuery and Tableau, matplotlib for data visualization of sales, tracking progress, identifying trends. Used Django APIs to access the database and defined different Django API profiling techniques for faster rendering information. Implemented various Validation Controls for form validation and implemented custom validation controls using Object Oriented JavaScript. Wrote Python routines to log into the websites and fetch data for selected options. Performed testing using Django's Test Module. Designed and developed communication between client and server using Secured Web services. Developed and tested many features for dashboard using Python, CSS3. Worked on updating the existing clipboard to have the new features as per the client requirements. Responsible for gathering requirements, system analysis, design, development, testing and deployment. Architected and developed Python and Django for the backend development and front-end application using PostgreSQL for databases. Designed Forms, Views, Models using Django's MVC software architecture pattern. Used Python and Pandas library for data cleaning and aggregation. Designed and configured database and backend applications and programs. Build all database mapping classes using Django ORM. Used many regular expressions in order to match the pattern with the existing one. Created RESTful API's using Django. Used AJAX calls for transmitting JSON data objects between front end and controllers and utilized continuous integration and automated deployments with Jenkins and Docker.