Chirag Bafna

Chirag Bafna Email and Phone Number

ETL & DWH Specialist @ Accenture
dublin, dublin, ireland
Chirag Bafna's Location
Mumbai Metropolitan Region, India
About Chirag Bafna

Overall 11+ years of work experience in the field of Information Technology in understanding and analyzing the ERP and data sets across various domains. Worked extensively in US HealthCare system for more than 6 years. Experienced in the field of Digital forensics. Strong working experience in defining ETL strategies and building Data warehouse. Strong knowledge in SSIS & SQL server as a primary skill sets.

Chirag Bafna's Current Company Details
Accenture

Accenture

View
ETL & DWH Specialist
dublin, dublin, ireland
Website:
accenture.com
Employees:
407706
Chirag Bafna Work Experience Details
  • Accenture
    Associate Manager
    Accenture Mar 2024 - Present
  • Ltimindtree
    Specialist
    Ltimindtree Sep 2021 - Mar 2024
    Mumbai, Maharashtra, India
  • Citiustech
    Technical Specialist
    Citiustech May 2015 - Aug 2021
    Mumbai, Maharashtra, India
    Working as Technical Specialist at CitiusTech, my roles and responsibilities included were:• Worked directly with US Healthcare facilities and developed good understanding of Quality Measures which are implemented by CMS in order to asses and compare the quality of the Health Care Organizations across US Markets.• Lead/participate in an analytical investigation aimed at addressing specific business or clinical situations using the SQL data base. • Actively involved in multiple external audits like "ISO 13485 - Medical devices" & "ISO 9001 - Quality Management System" and driving the discussions with external Auditor. • Developing and maintaining the T-SQL based procedures that pre-process and pre-summarize data to organize data for faster, easier, and repeatable use.• Ability to independently gather the requirement from non-technical business & clinical workforce members.• Worked on PQRS, ACO and Meaning Full usage Measures. Worked actively on CMS Data Submission module like CAT I, CAT III and GPRO Submission. • Providing Ad-hoc data support on complex subjects in an expedited manner.• Familiar with the relational data structures, theories, principles, practices and data modeling concepts.• Working experience in SQL Server 2008/2008 R2/2012 versions and using SSIS to develop the ETL strategies.• Working and communicating directly with the US customers and attending the weekly stand ups as a part of the Project activity. The purpose is to keep the customer transparent about the work and challenges being faced with the project.• Working with the Project support team and assisting them whenever applicable in order to resolve the high priority tickets.• Preparing the monthly\Weekly Dashboard stats and leading the discussions with Client.• Working on different technologies like MS SQL Server, SSIS, MySQL & Netezza DB.• Worked extensively with MSSQL technologies and good knowledge in writing SQL queries. Developing, creating & debugging SSIS packages.
  • Ey
    Associate Consultant
    Ey Dec 2014 - May 2015
    Mumbai Area, India
    Forensic Data Analysis is a branch of Digital forensics. Working as Forensic Data Analyst at EY, my roles and responsibilities included were:• Working with financial data sets.• Examined structured data with regard to incidents of financial crime. • Understanding the business workflow from the business users to understand the data.• Working with a team to carry out the Investigations on the aspects of financial grounds.• Preparing financial reporting and identifying securities fraud.• Carrying out analysis that relates to cause for bribery and corruption.• Identifying the transactions that can relate to money laundering and employee fraud.• Creating a Data Warehouse by importing data from various sources like Excel, SAP, SQL DB and CSV files. This data sets are largely related to Finance.• Developing SSIS packages to load the data from different types of files.• Worked with Tableau, to provide the Graphical analysis of the data • Running Analysis in SQL server on the received data sets to identify the fraudulent areas.• Working with SQL Server 2012/2014, SSIS, and Excel Workbooks.• Working with SAP and extracting the data from SAP.
  • Maia Intelligence
    Business Intelligence Consultant
    Maia Intelligence Sep 2012 - Nov 2014
    Navi Mumbai
    Working as BI Consultant at MAIA-Intelligence, my roles and responsibilities included were:• Database Design, ETL processing, report building and help define standards for ETL.• Traveling across client place and working within the team to deliver full BI solution.• Analyzing and understating client’s ERP to bring the data on the centralized platform (SQL Server).• Creating a Data Mart, this includes the reporting logic for creating BI reports and designing dashboards that helps higher management for taking better business decision.• Active interaction with client and attending brain storming session for requirement gathering.• Automating excel reports (eg: MIS reports) in BI, which could save more time and help in taking faster business decision. • Providing support to the end user with the application and developing reports as per the users requirement. • Attending kick off meetings with a team.• Carrying out POC, to demonstrate the capability of BI on client’s data.• Developed complex T-SQL queries and designing SSIS packages.• Domain Knowledge across Sales, logistics, retail and media. • Working experience on SQL Server 2000/2005/2008 R2/2012, SSIS, Query optimization and developing ETL strategies.• Basic experience in working with SAP, Oracle and Microsoft Sharepoint.• Dealing with Client Interaction and Team Management.• Working experience in dealing with Pre Sales and Post Sales activities.

Chirag Bafna Education Details

  • Yadavrao Tasgaonkar College Of Engineering And Management (Mumbai University)
    Yadavrao Tasgaonkar College Of Engineering And Management (Mumbai University)
    First Class
  • Nes Ratnam College
    Nes Ratnam College
    Distinction
  • Nes High School
    Nes High School
    First Class

Frequently Asked Questions about Chirag Bafna

What company does Chirag Bafna work for?

Chirag Bafna works for Accenture

What is Chirag Bafna's role at the current company?

Chirag Bafna's current role is ETL & DWH Specialist.

What schools did Chirag Bafna attend?

Chirag Bafna attended Yadavrao Tasgaonkar College Of Engineering And Management (Mumbai University), Nes Ratnam College, Nes High School.

Who are Chirag Bafna's colleagues?

Chirag Bafna's colleagues are Shabnam Mallick, Alina Kraav, Abhishek Kumar, Angeley Rodriguez, Edyta Zimna, Rhea Varkey, Shalu Sangwan.

Not the Chirag Bafna you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.