Data Engineer
Location : Jaipur, India
Experience : 6 Year
Rate: $18 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Ravi – 5+ Years – Data Engineer
A quick learner & hard-working person who has 5+ years’ experience in the Data Analytics field. Having strong knowledge of Power BI, SQL, DOMO, and Advanced Excel. Team
coordination, problem-solving, good communication, and interpersonal skills.
EXPERIENCE:
[Feb 2022] – [PRESENT]
CONFIDENTIAL
Designation: Data Analyst
PROJECT 1: RETAIL – CUSTOMER ANALYSIS REPORT.
project description:
The project’s objective is to involve end-to-end BI Development and build the reports for all
segments.
Involved in end-to-end processes, gathering customer requirements, and finding the
correct solution to support business.
Working on Power BI Desktop to analyze and develop the reports as per KPI.
Connected with Snowflake data source to the Power BI and was able to write a
query to retrieve data from the data warehouse.
Strong experience in Data Transformation in Power query editor.
Implemented data modeling techniques using a star schema model to optimize the
report.
Strong knowledge of DAX Function to create Complex measures to reach the
customer’s requirement.
Experience in creating complex reports with drill-down and drill-through capabilities.
Implemented schedule refresh for the report that keeps the data up-to-date.
Implementing the RLS features for various management depending upon the
organizational hierarchy.
Alerts have been included in the reports to keep the Project Manager updated
about the threshold level.
Generated Scorecards using Power BI for the Client to understand the Business in
a single Report.
Use Jira to create sprint and track the issue and bug status.
PROJECT 2: E-COMMERCE – PRODUCT & SALES ANALYSIS REPORT.
project description:
The objective of the project is to be involved in end-to-end BI Development, Migrating SQL queries into Power BI to Automate the reports. Also responsible for building complex Views & stored procedures in Azure SQL Server. Played a Data analyst role and was completely involved in the requirement analysis phase and delivering the solution. Have work experience in ETL process, data migration, and data integration. Strong knowledge of SQL to transform the data and modeling concepts. Ability to design and implement data transformation (data cleaning, data mapping, and data consolidation) in SSIS.
Doing transformation (Joint and append) in the power query editor based on the requirement. Used a Power BI Subscription to send the reports in an automated fashion to the end users. Embedded a Power Apps feature for the End User’s flexibility to update the Comments after reviewing the Monthly Performance of the Business. Use DevOps to create a sprint and track the issue and bug status. Have work experience in DOMO, particularly in the ETL (Extract, Transform, Load) process, as well as the creation of data flows and visualizations.
[Oct 2018] – [Jan 2022]
CONFIDENTIAL
Designation: Data Analyst
Domain: HEALTHCARE INSURANCE – INVENTORY ANALYSIS
Working on Power BI and Tableau to analyze and obtain insights into large data sets. Connecting with different data sources – SQL Server, Excel, CSV... Working on SQL to do some transformation to improve the performance in Power BI. Strong knowledge of Power Query, Power Pivot, and Power Views. Provided solutions to complex business problems using Data Visualization. Building and publishing customized interactive reports and dashboards in Power BI Hands-on experience in Tableau for data connection, transformation and visualization. Creating action filters, parameters, and calculated sets for preparing dashboards in Power BI. Experience in creating aggregates, hierarchies, charts, table calculations, trend lines, and calculated measures in Power BI. Created Power BI Dataset which can be consumed by a cluster of reports. Working on Advanced Excel to build the dashboard for small data sets. Data cleaning and manipulation using Excel functions such as VLOOKUP, and Pivot. Using aggregate and logical formulas to perform complex calculations.
[June 2012] – [Aug 2018]
CONFIDENTIAL
Domain: US HEALTHCARE INSURANCE
Designation: Senior Process Associate.
Nature of Job: Claim Analyst.
Served as a claims analyst on the payer side, handling various healthcare products such as HMO, PPO, and POS across different insurance programs, including Medicare, Medicaid, and Commercial plans. The nature of the Job is to analyze the claim, fix the Error based on client guidelines, and decide to finalize the claim. Identify the Errors/Exceptions on the claim then manually edit and resolve it based on the client database. I performed claim audits, communicated quality-related findings to team leaders, and provided constructive feedback to associates for areas of improvement.
EDUCATION:
[2007] – [2010]
BSc - Information Technology
SKILLS:
Power BI SQL
DOMO Advance Excel
LUMENORE
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
