Bi Developer Power

HrishiShesham

Power BI Developer

*******.*******@*****.*** 438-***-****

SUMMARY:

AMicrosoftPowerBIDeveloperwith 4yearsofexperienceinDataWarehousing&AzureCloud.

ExpertisewithSQLServerinconstructingtables,triggers,userdefinedfunctions,views,indexes,stored procs, user profiles, relational database models and data integrity.

ExperienceinAgileMethodologiestomanagefulllife-cycledevelopmentoftheprojectandinvolvedin Business requirement phase which involved direct interaction with client.

WellversedinNormalization/Denormalizationtechniquesforoptimumperformanceinrelativeand dimensional database environments.

Write DAX Queries and M Queries in Power BI

ExperienceinFactandDimensionalDataModelingStarandSnowflake Schemas.

Flexible,enthusiastic,andproject-orientedteamplayerwithexcellentwritten,verbalcommunicationto develop creative solutions for challenging client needs.

Handsonexperience in calculatingcolumnsandmeasuresusingDAXinPowerBIbasedonreportrequirements.

Creatingreports usingvisualizationssuch asBarchart,Clustered ColumnChart, Waterfall Chart,Gauge, Pie Chart, Tree map etc. in Power BI.

Worked with business teams and cross-functional partners to determine true reporting need, align on report, and tool outputs

Using several types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart,Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.).

Experience with Business Intelligence tools such as Power BI, Tableau.

Hands-on experience in data analytics tools like Excel, SSAS, DAX, SQL Server, etc.

Familiar with HTML, CSS, Python, R, and other scripting languages.

Knowledge of various software development life cycle models and documentation.

Utilizing advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards.

Aligning with Agile Methodologies, scrum stories, and sprints in a Python-based environment in association with data analytics and Excel data extracts.

TECHNICALSKILLS:

OperatingSystems

Windows,MacOS,Linux

Databases

MSSQLServer,MSAccess,Oracle

DatabaseDesign&Data Modeling

StarSchema,SnowflakeSchema,DimensionDataModelling,FactTables, Dimension Tables, Normalization, Denormalization

Modelling

FlowCharts,SequenceDiagrams,ActivityDiagrams,UseCasediagrams, DataModelling, ER Diagrams

Techniques/Tools

VisualStudio,PowerBI, MS Visio, MS Office

Languages

Java,Python, SQL, PL/SQL, TSQL

Development Tools

Microsoft Visual Studio .NET 2005/2008/2010

Networking

Ethernet, TCP/IP, VPN, LAN/WAN

BI/Reporting Tools

SSRS 2012,2016, Tableau 10, Crystal Reports

ETL/Agile Tools

SSIS, CA, Rally, TFS (Team Foundation Server), Jira

EDUCATION:

Bachelors in Computer Science from KMIT College, India.

PROFESSIONALEXPERIENCE:

BMO, Toronto Sep2021– Till Date

Power BI Developer

Responsibilities:

Study, analyze and understand business requirements in context of business intelligence.

Design and map data models to shift raw data into meaningful insights.

Develop and review simultaneous SQL queries with the use of join clauses (inner, left, and right) in Tableau desktop to validate static and dynamic data for data validation.

Build visually appealing interactive dashboards and scorecards in Power BI using various data sources.

Spot key performance indicators with apt objectives

Proficient in writing and debugging Complex SQL's queries & Stored procedure in Teradata

Serve as a Subject Matter Expert (SME) within all aspects of Microsoft Power BI Platform and collaborate with different teams to understand the business requirements and conduct gap analysis.

Conceptualize, design and implement Microsoft Power BI solutions from the existing corporate database and burgeoning data flake house/warehouse, as well as other enterprise data sources.

Build automated reports & dashboards with the help of Power BI & other reporting tool.

Make essential technical and strategic changes to optimize Power BI environments.

Assist in the design of logical and physical dimensional data mart models.

Design and implement ETL processes to integrate data from various sources into data warehouses.

Conduct unit & integration tests, assisting in test preparations to ensure data integrity, data quality, and program functional completeness & correctness.

Monitor and optimize performance of data solutions to ensure they meet business requirements and performance standards.

Staying up to date with industry trends, best practices, and emerging technologies related to data management and business intelligence.

Produce and maintain technical documentation for colleagues, as well as procedures for end users.

Develop strong data documentation about algorithms, parameters, models.

Write DAX queries,functions and M queries in Power BI.

Make essential technical and strategic changes to improvise current business intelligence systems.

Identify the requirements and develop custom charts accordingly.

Worked with data analytics and interpretation.

Worked with key process mapping and process improvement.

Connect to data sources using SQL queries and API calls for better results.

Ability to implement row level security on data and understand the application of security layer models in Power BI.

Environment:MSSQLServer, Windows, Linux, VisualStudio,PowerBI,MSAccess

Jade Global, Hyderabad, India Feb2019–Aug2021

Power BI Developer

Responsibilities:

CreatednumerousefficientStoredProcedurestoperformdatacleansingandloadingtaskwhendataisloaded into staging area.

Worked in Agile methodology to discuss status of the project twice a week and take further measures which includes scrum meetings daily to discuss product backlog.

Worked on transforming data into user-friendly visualizationto givebusiness users acomplete view of their business using Power BI.

ProvidedmaintenanceanddevelopmentofbugsfixesfortheexistingandnewPowerBI reports.

InstalledandconfiguredEnterprisegatewayandPersonalgatewayinPowerBI service.

Design, develop and maintain data management tools that support Sales, product management, supply Chain, and finance teams.

DevelopedReportstogeneratedaily,weekly,monthly,quarterly,yearlyReportsusingCrystalReports. Scheduled the reports to run on daily, weekly basis in the report manager.

ScheduledAutomaticrefreshandschedulingrefreshinPowerBIservice.

CreatereportsinPowerBIpreview portal.

ResponsibleforbuildingPowerBI Dashboards.

ProvidedproductionsupportontheexistingPowerBIDashboardstoresolvetheissuesquicklyandpublished Power BI Desktop reports created in Report View to the Power BI service.

PublishedreportstoAzure-basedPowerBIservicesandschedulesubscription&sharingoptions.

Troubleshootcriticalissuesintimelymannerto-ensuretheSLAsaremet.

Involved in understanding the functional requirements, translation of technical documents, data dictionarymapping and data mappings.

Createdseveraluserrolesandgroupstotheend-userandprovidedrowlevelsecuritytothem.

WorkedontheSnow-flakesSchemaontheDimensionstoremoveredundancy.

CreatedCalculatedColumnsandMeasuresinPowerBIandExceldependingontherequirementusingDAX queries.

ParticipatedinmeetingswithUsers,Businessanalystsinunderstandingthebusinessrequirementsand analyzed use cases to develop detailed map strategy.

ComplexSQLqueriesaspertherequirementandexportedtoExcel,Flat file.

Provided production support on the existing Power BI Dashboards and other ETL processes to resolve theissues quickly.

Conductedmeetingswithbusinessstakeholders,clientsanddirectorlevelmembersforrequirement gatherings and presented various solutions using best practices.

OptimizeSQLqueriesforimprovedperformanceand availability.

Configuredandmonitoreddatabaseapplication.

WorkedwithQualityassurancetodeveloptestplansandtestcasestoconduct systemtesting.

Backingup,restoringsystem&otherdatabasesasperrequirements,andscheduledthose backups.

UsedSQLServerProfilertotracetheslowrunningqueriesandtriedtoOptimizeSQLqueriesforimproved performance and availability.

Environment:MSSQLServer,Excel,Windows,VisualStudio,MSOffice,PowerBI,MSAccess

Contact this candidate