VIKRAMJEET SINGH CHAUHAN
Summary
Python developer with a strong background in Excel automation gained through experience on a US-based pharmaceutical client project. Proficient in leveraging Python libraries such as openpyxl ,numpy and pandas to streamline data processing and analysis tasks. Demonstrated ability to design and implement efficient solutions that improve workflow productivity and accuracy.
Overview
5
5
years of professional experience
Work History
Python Developer
Tata Consultancy Services
Noida
07.2023 - Current
- Designed and implemented Python automation scripts for data processing tasks, tailored to the requirements of a prominent US Based Pharma Giant.
- Developed and implemented Python automation scripts for Excel data processing tasks, customized to meet the specific needs of client.
- Utilized Python libraries such as NumPy, Pandas, and openpyxl to streamline data manipulation workflows and enhance efficiency within the project.
SSIS Developer
TATA Consultancy Services
Noida
08.2022 - 06.2023
- Developed ETL Processes for US Based Healthcare insurance client with SSIS, SQL Stored procedures.
- Experienced in creating complex SSIS packages using proper control and data flow elements with error handling.
- Provided a wide range of value-added services, including implementation and training, operational management services, health care data analysis, transaction processing, employer health centers and third party administrator services for employer-based health plans.
Technology Analyst
Infosys
01.2022 - 05.2022
- Configured Log Shipping and implemented Replication as High Availability techniques
- Handled query optimization by creating various clustered, non-clustered indexes and indexed views
Senior System Engineer
Infosys
05.2020 - 01.2022
- Performed Database Mirroring as Disaster Recovery Solution
- Handled Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
- Managed Performance Tuning ,Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, etc.
- Experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor
System Engineer
Infosys
12.2018 - 05.2020
- Expertise in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent
- Handled user and login creation, permission configuration and role assignment
- Development of automated notification for SQL Server Backups and schedule maintenance Jobs
- Experience in SQL server Migration across versions using standard operating procedures
- Managed 24 x 7 Production Database on Call Support.
- Trained in Python, Data Structures and Middleware Technologies at Infosys Global Education Center
Education
Master of Computer Application -
GLA University
Mathura05.2018
Bachelor of Computer Application -
GLA University
Mathura05.2015
Skills
- Microsoft SQL Server
- MySQL
- Python
- SSIS
Accomplishments
- Big data - Hadoop certification by Ducat
- Project : Retail Data Analysis using Apache Pig and Apache Hive
Timeline
Python Developer
Tata Consultancy Services
07.2023 - Current
SSIS Developer
TATA Consultancy Services
08.2022 - 06.2023
Technology Analyst
Infosys
01.2022 - 05.2022
Senior System Engineer
Infosys
05.2020 - 01.2022
System Engineer
Infosys
12.2018 - 05.2020
Master of Computer Application -
GLA University
Bachelor of Computer Application -
GLA University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Raphaela MahoroRaphaela Mahoro
Python Developer at Rohde & SchwarzPython Developer at Rohde & Schwarz