B Manju Kumari
Kolkata
Summary
With 4+ years of IT experience, I have successfully analyzed, designed, developed, and provided technical support for Dashboards using Microsoft Power BI Reporting tool. Expertise in developing Power BI reports and dashboards from multiple data sources and publishing them on Power BI Service. Implemented row-level security in Power BI workspaces based on specific access requirements. Skilled in various Power BI visualizations such as bar charts, column charts, line charts, area charts, waterfall charts, pie charts, donut charts, tree maps, cards, KPIs, funnels, and maps & slicers. Utilized different types of filters like Visual Level Filter, Page level Filter, Report level Filter & Drill-through Filter in Power BI. Proficient in Data Modeling with DAX using functions like Aggregate, Sum, Count, Concatenate, Currency, Calculate, Min, Max and Average. Implemented various Power BI web concepts including Gateways, Schedule refreshes, Q&A and Insights in Data sets. Strong understanding of System Development Life Cycle (SDLC) and experience working in both Agile and Waterfall development environments. Actively participated in migration activities.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Power BI Developer
Varuna Organics
08.2022 - Current
- Proved successful working within tight deadlines and a fast-paced environment.
- Corrected, modified and upgraded software to improve performance.
Power BI Developer
Capgemini
07.2020 - Current
- Participated in requirement gathering and data mapping sessions to understand business needs
- Responsible for developing and building reports/dashboards
- Used different joins, sub-queries and nested queries in SQL
- Built, Extract, Transform, and Load (ETL) process to migrate data from multiple tables using Talend
- Worked with DBA to maintain referential integrity by defining table and column level table and column level options such as primary/foreign keys on applicable data-mart tables
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Power BI
- Created dashboards with interactive views, trends and drill downs
- Interfaced with cross-functional team of business analysts, developers and technical support professionals to determine comprehensive list of requirement specifications for new applications
- Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
- Implemented different type of Power BI web concepts like Gateways, Schedule refresh, Q&A, Insights in Data sets
- Involved in creating a dual-axis bar chart with multiple measures
- Implemented data blending to blend related data from different data sources
- Managed multiple projects with a high degree of accuracy and attention to detail to attain desired user requirements
Power BI Developer
Spartan Stores, USA
02.2021 - 07.2022
- Designed, developed, tested, and maintained Power bi functional reports based on user requirements
- Mastered the ability to design and deploy Graphic visualizations with drill-down and Drop- down menu options and Parameters using Power bi
- Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL, SQL Server, and PostgreSQL structure and to maintain data efficiently
- Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concepts
- Converted existing Excel/BO reports to Power bi dashboards
- Created different KPIs using calculated key figures and parameters
- Developed Power bi data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic maps, Pie Charts, Bar Charts, and Density charts
- Developed Donut charts and implemented complex features in charts like creating bar charts in the tool tip
- Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations
- Provided Production support to Power bi users and Wrote Custom SQL to support business requirements
- Utilized Power bi server to publish and share the reports with the business users
- Responsible for creating calculated fields, combining fields, bins, sets and hierarchies using Power bi Desktop
- Designed and developed forward-thinking systems that meet user needs and improve productivity.
- Designed and implemented scalable applications for data extraction and analysis.
- Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
Database Developer
SAVOYA Chauffer Services, US
07.2020 - 01.2021
- Created Database Triggers to implement business requirements
- Monitored strategies, process and procedures to ensure the Data Integrity, optimized and reduced data redundancy, maintained the required level of security for all prod, test databases
- Involved in performance tuning and optimizing for SQL Server Application by using performance Monitor
- Implemented Data modeling by using Star schema, snow flake schema
- Installed and configured SQL Server 2008, created logins, users and maintenance plans managing use of disk space, memory and connections to the database
- Participated in developing logical model and implementing requirements in Sql server
- Created and managed schema objects such as tables, views, Indexes, procedures, triggers
- Created the database for the reporting team
- Implemented security measures to protect vital business data.
- Provided training sessions for junior developers on best practices in SQL programming techniques aimed at improving code efficiency.
- Supported business analytics initiatives with the creation of dynamic dashboards and detailed reports for data-driven decision-making processes.
Education
M. Tech - Computer Science & Engineering
JNTU-K
Visakhapatnam12.2014
B. Tech - Computer Science & Engineering
JNTU-K
Visakhapatnam04.2012
Skills
- Power BI Desktop
- Power BI Service
- Oracle 10g
- Oracle 11g
- MS SQL Server
- PostgreSQL
- Talend
- Basic C
- MS Word
- MS Excel
Certification
CERTIFICATION
- Certified course in “Data Analyst”
Timeline
Power BI Developer
Varuna Organics
08.2022 - Current
Power BI Developer
Spartan Stores, USA
02.2021 - 07.2022
Power BI Developer
Capgemini
07.2020 - Current
Database Developer
SAVOYA Chauffer Services, US
07.2020 - 01.2021
M. Tech - Computer Science & Engineering
JNTU-K
B. Tech - Computer Science & Engineering
JNTU-K
Similar Profiles
Rohit KumarRohit Kumar
Chef Assistant at Varuna HotelChef Assistant at Varuna Hotel
Jayesh ShindeJayesh Shinde
Assistant Manager at Varuna Integrated logistics pvt ltdAssistant Manager at Varuna Integrated logistics pvt ltd
Pragya PrabhaPragya Prabha
Executive Assistant- Chairman office at Varuna Integrated LogisticsExecutive Assistant- Chairman office at Varuna Integrated Logistics