KISHORE KUMAR J S

Having 5+ years of total experience In IT Industry with 4.5 years of relevant experience in BI tools like Power BI Desktop, Power BI Service and SQL Server. Hands on experience on Power BI Desktop and Power BI Service. Development and worked on Creating Reports & Dashboards. Developed effective Reports & Dashboards and Worked on existing dashboards and done enhancements as per the Clients requirement. Designed Data Modeling and Maintained relationships between data using different Joins. Defined KPI’s to gauge the company’s overall long-term performance. Writing reports to share knowledge gained from the complied data. Cleaning the data and improving the data quality by removing duplicates, errors, or outliers. Skilled in writing complex DAX formulas to derive meaning full insights from raw data. Experience in extracting, transforming, and loading data from diverse sources using Power Query, SQL, and other data integration tools. Familiarity with integrating Power BI with various data sources such as Excel, SharePoint, SQL Server, and cloud platforms like Azure. Experienced in creation of Appending and Merging Queries. Published and Shared Reports into Power BI Service .Installing & Configuring a Gateway Connectivity and giving access to On-Premises data Gateway. Used RLS (Row Level Security) as a part of security. Experienced in deployment and Scheduling Refresh. Experienced on SQL queries relevant to Power BI.

POWER BI DEVELOPER

Seeking a fulfilling position in challenging and dynamic field of data analytics that offers growth opportunities and allows me to utilize and enhance my skills, experience, and abilities while being resourceful, innovative and flexible.

Client : Fairfax Financial | Domain : Insurance, Environment : Power BI, Power Apps, Power Automate & SQL Server, DESCRIPTION:

 Fairfax Financial Holdings Limited is a globally diversified insurance and investment management company. The company's business model is characterized by its disciplined underwriting approach, robust risk management, and a focus on preserving capital and achieving consistent returns. Fairfax's mission to create enduring value for its shareholders and stakeholders alike., 

RESPONSIBILITIES : 

Responsible for gathering requirements for Power BI Reports from business users and executives., Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators (KPI)., Developed custom Power Apps for data input, approval workflows, and record updates, seamlessly connected to Power BI datasets to ensure data consistency., Delivering reports to the Business team promptly., Effectively use Power Query and DAX for calculations., Used Power Automate to schedule data refreshes, log failures, and maintain audit trails, improving reliability and transparency of BI solutions., Involved in data cleaning and data preparation using Power Query Editor., Build Pages with Slicers for Quick filters and generate report-level filters while handling vast volumes of data., Creating different visualizations using Bars, Lines, and Pies, Maps, Highlight tables and matrices., Worked on On-Premises Gateway to refresh the data sources and schedule the data., Publishing the data source into the Power BI Server and scheduling the data sources.

Client : Eli Lilly | Domain : Healthcare, Environment : Power BI & SQL Server

DESCRIPTION :

Eli Lilly and Company is a global leader in the pharmaceutical industry, with a core mission of improving patient outcomes through innovation in medicine. the company has consistently focused on discovering, developing, and delivering high-quality medications that address significant unmet medical needs. Eli Lilly continues to shape the future of healthcare, making life better for millions of people around the world. 

RESPONSIBILITIES :

Loading the data from development system to staging environment., Extracting data from multiple sources like flat files, Excel, and SQL server and validating data and loading into Final Destination., Created charts like Lines, Pie, Bar, Scatter, Area, Tree map, Map, Filled map, Gauge, Funnel, Single Card, Multirow card, Slicer, etc., Used Edit Interaction functionality to create Interaction between Visuals., Developing Visualization reports and Dashboards using Power BI., Have good Experience to RLS as part of security., Build Pages with Slicers for Quick filters and generate report-level filters while handling vast volumes of data., Loading data into database and running the applications which are created in Powe BI and sending them to users frequently.

Client : Wish | Domain : E-Commerce, Environment : Power BI & SQL Server,

DESCRIPTION :

Wish, primarily a mobile marketplace founded in 2010, has transformed the e-commerce landscape by allowing small businesses and manufacturers to sell directly to consumers. Operated by Context Logic Inc., Wish has quickly become one of the largest eCommerce marketplaces in the world, leading in categories like computer electronics, technology, and video games.

RESPONSIBILITIES :

Gathering the requirements from business users and analyzing those requirements and providing estimates. Participating Weekly, Daily and Ad-hoc meetings., Visualize complex data and interactions between internal and external data sources., Building, publishing customized interactive reports and dashboards,, Implement action filters, parameters, calculated filed and set for preparing Reports and dashboard, Parameters, Table Calculations and Hierarchies., Data joins and Level of Detail Expressions, Creating the parameter and dimension-based reports, drill-down reports, charts, and Power bi reports using Power BI Desktop., Execute and tested required queries and reports before publishing dashboards., MIS reporting by using MS Excel at Operational level., Preparation of various reports. To prepare accounting reports, vendor outstanding and other MIS reports as required.