Amit Chaudhary

End-to-end Project documentation, requirements gathering and transforming those business requirements into informative visualizations assisting in decision making.

Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps.

· Strong ability to analyze user requirements, Business Requirement Specifications.

· Expert in Data Preparation, Data Modeling and Data Blending.

· Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.

· Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities.

· Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query.

· Experience in creating advance charts, visualizations and complex calculations to manipulate the data as per business need through Power BI.

· Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI.

· Generated context filters and data source filters while handling large volume of data using Power BI.

· Involved in creating Filters, table calculations, calculated measures and parameters in Power BI.

· Hands on experience with MSBI (SSIS) to extract, transform and load data into database.

· Experience in Data Analysis, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools SSIS.

· Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.

· Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed analytical, problem-solving skills and document function/process flows.

· Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player.

· Good experience working with Agile methodology

Responsibilities:

· Collaborated with the project team to outline project requirements in meetings

· Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.

· Developed data reconciliation SQL queries to validate the overall data migration.

· Formulated DAX Expressions create Date to yearly columns and implemented charts in Power BI.

· Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

· Wrote DAX expressions to create new measures, calculations per business requirements.

· Effectively used data blending, filters, actions, and hierarchies feature in Power BI.

· Analyzed the data using Statistical features in Power BI to develop trend analysis.

· Published the developed dashboard, reports on the Power BI Services

· Successfully integrated custom visuals based on business requirements in Power BI desktop.

· Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.

· Generated and scheduled on-demand reports for business analyses and management decisions with SSRS.

Environment: Power BI Desktop, DAX, SQL Server, Excel

• A medical coder translates details from a patient's medical documents, such as physician's notes, lab reports, procedures, and diagnoses into universal medical codes to maintain accurate medical records. Healthcare providers and insurance companies use these standardized codes for billing and record-keeping

• A Claims Adjudicator is responsible for evaluating insurance claims and making decisions on the validity and payment of claims. They review claims forms and supporting documents and make determinations on coverage, liability, and the amount of payment.