Ujjawal Sagar
Muzaffarpur
Summary
Experienced developer with over 9 years of proven success in leveraging software engineering techniques to optimize development processes utilizing the Microsoft Power Platform. Highly skilled in implementing cutting-edge technologies to enhance efficiency and productivity. Conducts thorough market and consumer research and effectively translates findings into innovative application features using Power BI and Power Apps. Demonstrates a rapid grasp and application of complex technology concepts within tight timeframes, utilizing Azure Services.
Overview
9
9
years of professional experience
10
10
years of post-secondary education
6
6
Certifications
Work History
Application Development Team Lead
Accenture Solutions
9 2021 - Current
- Developed structured coaching programs that enhanced team competencies across 8 key areas, leading to a measurable improvement in performance evaluations for all direct reports and increasing overall productivity by 25%.
- Develop and deliver verbal/written communications with the team and stakeholders, ensuring completion of tasks and adhering to Accenture My Wizard & Strategies planned and defined by the organization.
- Established regular review sessions focusing on critical aspects of BRDs and TDs, while fostering collaboration among departments, leading to improved clarity in requirements across eight funded initiatives.
- Collected and analyzed data on established and prospective sources.
- Prepared reports that interpret behavior, business opportunities, conditions, results, trends, and levels.
- Converted data into actionable insights by predicting and modeling future outcomes for more than 100 + reports.
- Built dashboards to gain deep insights with process mining.
- Rich experience in Data Viz, Reporting, Data Synthesis, Modelling, ETL/ELT process, cloud analytics tools.
- Very strong consulting experience on Power BI engagements for various implementations, with rich exposure towards architecting/engineering back-end data to help achieve KPIs required.
- Process time savings upto 95% are achieved through solutions using Power Apps, Power Automate, Azure Data Factory, PowerShell, and Azure DevOps solutions.
- Savings are synthesized by identifying opportunities and democratizing the solutions across the organization.
- Identified and acquired appropriate third-party solutions to integrate into development processes.
Technical Lead
EY GDS
08.2020 - 09.2021
- Created an end-to-end in-app Power BI solution using Power Apps in the Power BI platform for the General Dynamics account, which is organized into four business groups: Aerospace, Marine Systems, Combat Systems, and Technologies.
- They have a balanced business model, which gives each business unit the flexibility to stay agile and maintain an intimate understanding of customer requirements.
- GDS Assurance PBT/SBT Centralization dashboard to track various KPIs across the entire life-cycle of the requests using heterogeneous data sources, i.e., Excel, SharePoint, Azure SQL.
- GDS Assurance Head Count Dashboard with utilization, B2A, availability KPIs.
- Worked on creating drill-down, drill-through, charts, and dynamic URL filtering.
- Helped Assurance Digital Team to expand the Data Analytics team from 3 members to an 8-member team with 100% utilization.
Sr. Software Engineer/PowerBI Developer
EY GDS
09.2019 - 08.2020
- Engage in project planning, controlling, and writing technical documentation.
- Analyzing and designing new reports based on user stories.
- Understanding requirements and identifying gap analysis of customer requirements with respect to source systems and technology feasibility.
- Charts with Individual Axes, Dual Axes.
- Designed reports with drill down, drill through, and drop-down menu options, as well as parameterized and linked reports.
- Report scheduling using Power BI Service.
- Power BI: Building reports with various functionalities using DAX and M.
- Highly intuitive dashboards with meaningful visuals on best standards using bookmarks, dynamic parameters.
- Rich experience in storytelling.
- Scheduled Refresh in Power BI Service.
- Created the report based on SharePoint list, folders, and Azure DevOps tables.
- Migrated Spotfire reports and ad-hoc reports using Power BI.
- SSIS: Experience in using tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
- Created databases and schema objects, including tables, indexes, and applied constraints. Connected various applications to the database and written functions, stored procedures.
- Extensively worked on Data Extraction, Transformation, and loading the data from source to target system using SSIS.
- Rich experience in DDL, DML, T-SQL, and PL/SQL.
- Implemented row-level security and incremental refreshes.
Sr. System Analyst
Sonata-Software
09.2018 - 09.2019
- Creating Tabular model as per the requirement
- Analyzing and Designing new reports based on Business Requirement
- Handled enhancement activities in relational model to support new tables from business
- Wrote stored procedures to handle complex Power BI reporting requirement to improve performance in reports
- Creating Excel/Power BI reports on top of the Analytics Cube
- Created Dashboard reports using Excel and Power BI to show Microsoft Sales.
System Analyst
Sonata-Software
01.2016 - 09.2018
- Developed SSIS Packages to load data using different transformations.
- Migrated standard Excel reports and ad-hoc reports using Power BI.
- Involved in the implementation of configuration and logging in SSIS ETL packages, level.
- Developed Power BI Dashboards using SQL Server Analysis Services (By Using Tabular Cube).
- Developed SSAS Tabular Cube by designing and configuring Model, Dimensions, Measures Groups, KPIs, and Calculated Measures using DAX.
Education
Bachelor of Science - Information Science
Visvesvaraya Technological University
Bengaluru, India 05.2011 - 06.2015
High School Diploma -
Guru Gobind Singh Sr. Sec. Public School
Bokaro Steel City, India 05.2008 - 03.2010
Associate of Science -
Adarsh Vidya Mandir, Shankar Vidyapeeth
Mount Abu, India 05.2004 - 03.2008
Skills
Data Viz - MIcrosoft Power BI
SQL
DAX
M
Microsoft Fabric
T-SQL
Cloud: MS - Azure DevOps
Microsoft Azure Enterprise Analytics
Microsoft Power Apps/Automate
SSIS
ADF
DB: MS-SQL Server
Agile/Scrum/SDLC
Workload Automation: Power Automate
Jira
Finance
Agriscience
Banking
Customer Planning
Inventory Management
Oil and Natural Gas
Certification
AZ-900 MS - Azure Fundamentals, 06/2021 - Present
Accomplishments
- FY24 Client Value Creation - Accenture
- FY23 Skills Star Award - Accenture
- FY22 Extra Mile Award Winner - Accenture
- FY20 Spot award - EY
- FY19 Best Performer DNA award - Sonata-Software
Supportedcauses
CSR - Coaching rural government students near Bengaluru suburbs on using computers
Languages
English
Hindi
Bhojpuri
Timeline
DP-600 Microsoft Certified: Fabric Analytics Engineer Associate
09-2024
DP-900 MS - Azure Data Fundamentals, 06/2023 - Present
06-2023
SC-900 Microsoft Certified: Security, Compliance, and Identity Fundamentals
07-2022
AZ-900 MS - Azure Fundamentals, 06/2021 - Present
06-2021
DA-100 MS - Certified Data Analyst Associate, 03/2021 - 03/2024
03-2021
EY Silver Badge Analytics - Data Visualization, 08/2020 - Present
08-2020
Technical Lead
EY GDS
08.2020 - 09.2021
Sr. Software Engineer/PowerBI Developer
EY GDS
09.2019 - 08.2020
Sr. System Analyst
Sonata-Software
09.2018 - 09.2019
System Analyst
Sonata-Software
01.2016 - 09.2018
Bachelor of Science - Information Science
Visvesvaraya Technological University
05.2011 - 06.2015
High School Diploma -
Guru Gobind Singh Sr. Sec. Public School
05.2008 - 03.2010
Associate of Science -
Adarsh Vidya Mandir, Shankar Vidyapeeth
05.2004 - 03.2008
Application Development Team Lead
Accenture Solutions
9 2021 - Current
Similar Profiles
SARITA SAHARANSARITA SAHARAN
Manager Talent Acquisition at Accenture SolutionsManager Talent Acquisition at Accenture Solutions
Kiran R VKiran R V
Payment & Reconciliation Analyst at Accenture SolutionsPayment & Reconciliation Analyst at Accenture Solutions
Harshavardhan T KHarshavardhan T K
Packaged App Development Analyst at Accenture SolutionsPackaged App Development Analyst at Accenture Solutions