Anil Patel | Data Engineer at CIPLA | MumbaiAs a proactive, skilled, and self-motivated Data Analyst with over 4 years of experience, I am passionate about using data to drive insights and make informed decisions. My expertise lies in data analysis, data cleansing, and data visualization, and I am well-versed in Python libraries such as Pandas, NumPy, xlwings, Selenium, and Matplotlib. I have a strong command of SQL DDL and DML queries, and I am proficient in extracting and transforming data from various sources using Python, Excel, Tableau, and Power BI.I have hands-on experience with AWS services such as EC2, VPC, EMR, and S3 for data storage and processing, and I am skilled in Linux CLI and scripting, with expertise in Python scripting and an understanding of the Linux file system. I am also experienced in collaborating with cross-functional teams, communicating analysis results to stakeholders, and addressing ad-hoc data requests.With a proven track record of automating repetitive tasks using Python scripting, Bash scripting, and other tools, I have consistently increased efficiency and reduced manual effort. My analytical skills include descriptive and categorical analysis, quantitative data summarization, and data distribution modeling. I am well-versed in advanced Excel skills including pivot tables, charts, and conditional formatting, and I have experience with data visualization tools like Tableau and Power BI.In my current role as a Data Analyst at GXO Logistics, I am working on client startup sites, automating repetitive/manual invoicing tasks, and creating web automation scripts to pull and auto-create template-based invoices using Python libraries such as Selenium, xlwings, Pandas, DateTime, and NumPy. I have working on an MS Access-based project to simplify the audit process.Prior to this, I worked as a Spatial Data Specialist at Here Technologies, where I created EC2 instances for Linux or Windows server machines with custom VPC settings to run jobs on the fleet instance, and worked with various AWS services for data storage and processing.I am proficient in Python scripting, Shell scripting, SQL, and other technical skills, and I am well-versed in tools such as Power BI, Tableau, Advanced Excel, and various databases. I am a results-oriented professional with a keen eye for detail and a strong commitment to accuracy and quality in all aspects of my work. Connect with me to discuss how I can add value to your organization with my data analytical skills and experience.
-
Data EngineerCipla Sep 2023 - PresentMumbai, Maharashtra, India• Medallion Architecture (Bronze, Silver, Gold) using Azure Databricks, PySpark, and Delta Tables.Improve data quality, make the system more scalable, and ensured better data governance.• Built batch processing pipelines for time-series data, loading them into Delta Tables. • Implemented UAT and Production environments, ensuring seamless deployment and testing• Set up CI/CD pipelines with Azure DevOps, simplifying environment management, quality checks, and improving team collaboration.• Extracted data from various sources like CSV, Excel, PDFs, and JSONs (including nested ones) to create flat files used for model building.• Automated email alerts for data changes in Delta Tables using Logic Apps, Databricks, and API connectors.• Boosted notebook performance by optimizing code (runtime reduced from hours to minutes) and moved workloads to job clusters, which significantly cut down on costs.• Migrated and replaced SQL Server with Delta Tables, enhancing data governance and lineage• Automated several manual reports using Python (Pandas, NumPy), SharePoint, Data Lake, Logic Apps, and Databricks, tying it all together with workflow job triggers.• Managed and optimized Databricks clusters and Azure services, reducing monthly costs by ₹1.5 lakhs while keeping everything running smoothly and efficiently. -
Data AnalystGxo Logistics, Inc. Mar 2022 - Sep 2023Mumbai, Maharashtra, India- MS Access (Reporting)- Toad for Oracle ( SQL, PL/SQL)- Advance Excel- Python ( Pandas, NumPy, MatplotLib, Selenium, xlwings) -
Sp. Data Specialist IHere Technologies Jan 2019 - Mar 2022India• As a Data Specialist for more than 3 years, working with 200+ million records to construct elite products on a weekly basis.• Creating various products out of 200+ million data and validating them using statistical and analytical skills, which helps product Owners/Stakeholders to make better GO/No-GO decisions.• Generating visual reports which will be shared across teams and maintaining them over confluence pages. • Excelled my skills in SQL queries, AWS services (Athena, EMR, S3, EMR, Batch, etc..), Advanced Excel, Linux CLI commands, JIRA system, Confluence, Python, Analytical, Visualization, and Problem-solving skills.• Automation: Shell Scripting• Languages: Python, R, Basic Java, OOPS concepts• DBMS: AWS, MySQL, Hive• Query Languages: SQL, Linux CLI• Operating Systems: Fedora Linux, Windows• Analytics and Visualization tools: PowerBI, Tableau, Advanced Excel• Knowledge of XML, JSON, CSV, Bash, IP protocols, DNS, DHCP• Others: Confluence, JIRA, Putty, WinSCP, Microsoft Office Suite -
Support EngineerUnisys India Jun 2018 - Sep 2018Mumbai, Maharashtra, India• Installing OS on laptops via server• Configuring essential services before deploying to users • Windows 7 to Windows 10 migration
Anil Patel Education Details
-
Vidyalankar School Of Information TechnologyA
Frequently Asked Questions about Anil Patel
What company does Anil Patel work for?
Anil Patel works for Cipla
What is Anil Patel's role at the current company?
Anil Patel's current role is Data Engineer @Cipla.
What schools did Anil Patel attend?
Anil Patel attended Ramniranjan Jhunjhunwala College, Vidyalankar School Of Information Technology.
Who are Anil Patel's colleagues?
Anil Patel's colleagues are Anand Tiwari, Mohammad Zameel Akhtar, Irshad Mohd, Aravind D, Swapnil Zagade, Dipak Ingawale, Anant Malik.
Not the Anil Patel you were looking for?
-
-
Anil Patel
Entrepreneur & Technological Excellence | Co-Founder & Cto At Jupitrix India Limited | Founder & Director At Telnet Communications Pvt. Ltd. | Creation, Development, Implementation, & Dissemination Of New Business ModelsAhmedabad -
Anil Patel
Kolkata -
Anil Patel
Bengaluru -
Anil Patel
Indore
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial