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.
Accenture
View- Website:
- accenture.com
- Employees:
- 407706
-
Associate ManagerAccenture Mar 2024 - Present -
SpecialistLtimindtree Sep 2021 - Mar 2024Mumbai, Maharashtra, India -
Technical SpecialistCitiustech May 2015 - Aug 2021Mumbai, Maharashtra, IndiaWorking 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. -
Associate ConsultantEy Dec 2014 - May 2015Mumbai Area, IndiaForensic 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. -
Business Intelligence ConsultantMaia Intelligence Sep 2012 - Nov 2014Navi MumbaiWorking 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)First Class -
Nes Ratnam CollegeDistinction -
Nes High SchoolFirst 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?
-
-
Chirag Bafna
Pega Developer | Graphic Designer | Certified Pega System Architect V8.6 | Certified Pega Senior System Architect V8.6Greater Chennai Area1accenture.com -
-
Chirag Bafna
Nashik
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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