Talent's Information
-
Location
Anantapur, India
-
Rate
$13.0 per Hour
-
Experience
6 Year
-
Languages Known
English,Hindi
Available for
About M R
Highly motivated Power BI and SQL Developer with over 6 years of IT experience in SQL Server development, T-SQL, Power BI, Azure for building, deploying, and managing business intelligence, data warehousing and Data Analytics.
Expertise in transforming raw data from various formats to a meaningful format as per the requirements of the clients.
Experience in Query Optimization and performance tuning of T-SQL queries, stored Procedures and Views.
Designing, development and supporting of database, data-marts and data warehouse
Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL Query using T-SQL.
Experience in writing SQL queries, stored procedures, functions and Views.
Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities.
Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI.
Experience in managing user access, workspaces, apps and code deployment using Deployment Pipelines in Power BI Service.
Creating Technical Documentation and providing Power BI training to users for creating their own dashboards in Power BI Service.
Experience in creating Filters, table calculations, calculated measures and parameters in Power BI for ease of maintenance and enhancements.
Creating Row Level Security (RLS) to restrict the data access based on the individual roles.
Experience in Waterfall model and Agile Scrum development projects for diverse requirements.
Expertise in creating multiple kinds of Summary, detailed Power BI reports and Dashboards.
Expert in Data Preparation, Data Modeling and Data Blending. Expertise in writing DAX.
Worked under Agile Methodology throughout the project, performed decisive role in developing & planning as well as coordinating with assigned sprints.
Experience in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Database design, ETL Mappings and Reports.
Strong experience Testing, Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as ADF and SSIS.
Expertise in Azure SQL, Azure Data Factory to build ETL pipelines for data orchestration.
Exposure to Microsoft Power Platform services like Power Apps and Power Automate.
Excellent analytical, Interpersonal and Communication skills and good team player.
Tech Stack Expertise
-
Azure
Azure data factory,Azure Blob
6 Years
Work Experience
Power BI Developer
- January 2017 - June 2023 - 6 Year
- India
Projects
IG Wealth Management
- April 2019 - January 2023 - 46 Months
-
Generated Power BI dashboards with advanced page/global filters, parameters and calculated fields that allowed tracking projected KPI for product performance, and customer interactions.
Creating a re-usable Data Models for reusability and to implement the single version of truth.
Experience in migrating the Excel reports into Power BI Solution.
Experience in data cleansing using Power Query (M-Code) and transforming the data to fit for the reporting structure.
Creating different reports like Summary Reports, detailed reports like Drill-through, Drill-down and dynamic Page navigation reports.
Creating complex DAX Measures, Calculated Columns and Calculated Tables.
Creating reports with bookmarks, page navigation and dynamically hiding visuals for better user visual experience.
Collaborated closely with internal stakeholders to gather information related to production problems, projects, or user queries.
Responded to specific BI requests from business development personnel, creating reports with requested information in easily understandable formats.
Perform end to end analysis of Data using various tools and technologies.
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.
Extracted data from Oracle, SQL Server, Flat Files, Excel, and XML using SSIS and cleanse the data.
Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
Analyze the data using Statistical features in Power BI to develop trend analysis.
Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
Programming tasks- Advance Dynamic SQL, Stored Procedures, Indexed Views, Functions and CTEs using T-SQL.
Responsible for creating Company core business KPIs and Executive Dashboards for board members by just not showing the numbers but making a Data Story about it.
Creating Technical Documentation and providing Power BI training to users for creating their own dashboards in Power BI Service.
Experience in using external tools like DAX Studio, Tabular Editor, ALM Tool kit and Bravo.
Westland Insurance
- August 2017 - February 2019 - 19 Months
-
Coordinating with business users in analyzing business requirements and translating them to technical specifications.
Relevant experience in processing flow charts or data flow diagrams
Incorporated complex business logic by writing complex SQL procedures and functions.
Executed SQL queries using complex stored procedure, common table expressions (CTE's), to support Power BI reports.
Collaborated with teams while developing data models using T-SQL scripting and resolved issues with systems, hardware and telephones quickly and accurately.
Participated in continuous improvement by generating results from internal surveys, engaging in problem solving activities to support team members in executing more goals, as well as reporting status in each team meeting.
Scheduling the jobs for executing the stored SSIS packages, which were developed to update the database on a daily basis using SQL server agent or schedule according to the change requests.
Writing/modifying stored procedures, views, triggers and functions etc.
Migrating Excels and SSRS reports into Power BI Reports/Dashboards.
Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, Bullets using Power BI.
Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
Adheres to department, organization and industry guidelines, standards, policies, and procedures.
Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
Excellent problem-solving approach, analytics skills, T-SQL coding commands.
Soft Skills
Industry Expertise
Education
Computer in B.SC
Andhra University- June 2014 - June 2017
