ANKUR TRIPATHI

• Established strong working relationships with clients through exceptional communication skills, fostering trust and collaboration.
• Achieved successful project outcomes by maintaining accurate documentation and meeting strict deadlines.
• Developed positive working relationships with stakeholders to effectively coordinate work activities.
• Presented technical findings to stakeholders, ensuring clear understanding of project status and goals.
• Provided input to team lead regarding areas for process and procedural improvement.
• Wrote, reviewed and edited technical document in accordance with template requirements.

Project: - Dataone (T-Mobile) , Kubernetes, Splunk, SQL, Kafka, Unix,Airflow, Jenkins, Grafana, Snowflake

Roles and Responsibilities:

• Frequently performing reconciliation between Databases (SQL and No SQL) with help of spark and Snowflake database.
• Finding the impact if there is any kind of incorrect or missing data
• Interacting with developers to sort out issues related to Bugs in code.
• Run microservices job for stop, start etc the Kubernetes pod through the jenkins and Airflow.
• Check the pods log with the help Kubernetes command to debug.
• Communicate effectively with the Clients in the weekly status calls and other meetings.
• Working on Tickets for handling the various team concerns.
• Worked on personal AWS project which involved S3,Lambda,DynamoDB service,Cloud watch and IAM. Project was about movement of file from one S3 bucket to destination bucket S3 bucket automatically and extracting copied file metadata i.e creating data, files size,file type and storing it in Dynamo DB. Python BOTO3 package was used to connect to AWS service and in lambda script was written to act as a trigger and to automate this process E2E.

• Project: - Heineken (Retailer), Putty, Application Tolls, PostgreSQL
• Responsibilities: -
• Developed complex SQL queries, views and stored procedures in multi-database environment, used database to research, gather, analyze and present data
• Monitored debugging processes and investigated the root causes of error and resolved them
• Successfully automated multiple databases to reduce manual work in projects

Project: - Dedup (Vodafone), Putty, Application Tolls, oracle11g, Unix, Remdey ticket tool, PL/SQL.

• Monitoring data, modifying store procedures, data fetching and worked on bug fixing, automation
• Wrote Complex and difficult SQL Queries for Reporting purposes
• Experienced in writing procedures, functions, views, materialized views as required.