Galipalli Pooja
Assistant Application developer
Summary
Professional Summary:
· 2.8 years of experience in the IT Industry and having 2.5 years of experience in Microsoft Power BI. Power BI Modelling and Power Visualization, Power BI Service.
· Experienced in developing Power BI reports and dashboards from various Data Sources like Cube, Databases, Excel files.
· Experience on Power BI (Desktop and Service) with different data sources such as SQL Server using Live Connection as well as Importing data from Excel Sources.
· Expertise in importing data from multiple data sources into Power BI, created relationships between various datasets in power pivot.
· Good knowledge on extracting the data from Power BI Desktop Service.
· Experience in Data preparation in Enter Data and shaping data in Edit Query like add column, split column, Pivot column, pivot column, changing data type, and Merge queries and Append queries.
· Experience on DAX Functions like Aggregate, Counting, Logical, Information, Text, Date and Time intelligence Functions.
· Created Data extracts for better performance and accessing data offline.
· Created Joins by combining tables, Created Column Elements from available data sources and Created Filter elements to limit the data retrieved.
· Implemented role-based security as part of user level security in Power BI
· Extensive knowledge on SQL queries relevant to and Power BI.
· Well versed in designing the lists and libraries in Microsoft SharePoint and good at creating look up columns in SharePoint .
· Power Apps development and customize
· Data integration and manipulation using Power Automate and Common Data Service
· User interface design and user experience (UI/UX) optimization
· Power Platform components (Power Automate, Power Virtual Agents) and MS Flows.
· Checking and fixing validation issues at POWERBI.
· Checking and fixing formatting issues at POWERBI.
· Scheduling of reports using Power BI Service.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
Work History
Project-2
Sales And Services
04.2023 - Current
Tools Used : Power BI, Advanced Excel ,Dax , SQL Server, Power BI Service
Description :
LLC is a producer of quality aluminum ladders and custom access solutions. We produce a variety of flatbed truck ladders including the Trucker, a portable ladder that can be customized for a variety of trailer applications. The management wants to analyze the data Using cognos reports. Here we need to develop dashboard reports as per user requirement.
Roles and Responsibilities
- Perform ETL activities and data modeling using Power BI.
- Run created SQL script to get data updated in the SQL server.
- Creating multiple pages of interactive report based on requirement given by Stakeholders and publishing into service workspace. Creating dashboard for easy access of executive summary and other key metrics
- Created conditional formatting to show table visually.
- Creating Top 10 accounts, YTD, YOY growth and Plan comparison with previous year for all available metrics using DAX computed measures and columns.
- Debugging the report issues and solving them if any error occurs on new refresh.
- Creating deep insights to analyze and increase the headcount and hours contribution by pillars.
- Creating drill down, drill through, Page navigation, bookmark, selections, actions, multiple filters, sync slicers and visual interactions to give better data analytics with the available data.
- Analyzing the report performance using performance analyzer and fixing the lagging's.
- Granting report and workspace access basis requirement in Power BI Service.
- Frequency of scheduled data refresh will perform on weekly basis using SQL Server.
Project-1
ICICI Securities Ltd
10.2021 - 03.2023
Tools Used : Power BI, Access and Excel, Dax , SQLS Server
Description:
ICICI Bank Limited is an Indian multinational bank and financial services company headquartered in Vadodara. It offers a wide range of banking products and financial services for corporate and retail customers through a variety of delivery channels and specialized subsidiaries in the areas of investment banking, life, non-life insurance, venture capital and asset management.
Roles and Responsibilities :
- Create and develop Power BI visuals and data models as required.
- Building Power BI dashboards and doing ad hoc reporting.
- Experience in developing Visualization reports using Power BI as per client requirement.
- Visualize data, author reports Publish and schedule automated refresh of reports.
- Using DAX for Power BI Reports.
- Designed the Reports with Conditional formatting.
- Created calculated columns to simplify the data.
- Prepared Weekly Status Reports and shared with the Onsite Managers.
- Created Named Calculations and Named Queries in the Data Source view based on business requirement.
- Created Dimensions, Measure Groups with Custom formats.
- Good experience on Sorting Attribute by another attribute based on requirement.
- Created Calculated Measures and maintaining using folders in the Cube.
- Added new dimension, new partition, or new business logic to existing SSAS Cube
- Created MDX Queries to pull data for SSRS reports.
- Created Parameterized, Cascading and Drill Through Reports and Drill Down and Sub Reports.
Education
B.TECH - Electronics And Communication Engineering
Bharat Institute of Engineering And Technology
Hyderabad 07.2017 - 08.2021
Skills
Microsoft Power BI, Advanced Excel (Power Query and Power Pivot)
SSRS ,SSIS
SQL Server
Technical understanding
Project Scoping
Meeting facilitation
Customer Relationship Management
Timeline
Project-2
Sales And Services
04.2023 - Current
Project-1
ICICI Securities Ltd
10.2021 - 03.2023
B.TECH - Electronics And Communication Engineering
Bharat Institute of Engineering And Technology
07.2017 - 08.2021
Similar Profiles
Isabelle HacheIsabelle Hache
Service Advisor at Valley Sales and ServicesService Advisor at Valley Sales and Services
Gerson Aguirre CruzGerson Aguirre Cruz
RV Hauling and Sales at Lobster Rv Sales and Services LLCRV Hauling and Sales at Lobster Rv Sales and Services LLC
Payton DingusPayton Dingus
Warehouse Worker at Maggard Sales and ServicesWarehouse Worker at Maggard Sales and Services
Rosi Vasquez De De Los SantosRosi Vasquez De De Los Santos
Notary Public at Euroteam Sales and ServicesNotary Public at Euroteam Sales and Services
Rohit RathorRohit Rathor
<ul><li>Production Block Incharge Job Role: Operations, Control and Monitoring</li><li>1. All activities related to production and monitoring the process as per SOPs.</li><li>2. Communicate day to day process deviations and breakdowns of the equipment to concerned persons.</li><li>3. Check and implement the process for cleaning of equipment as per the schedules.</li><li>4. Responsible for housekeeping and implementation of day to day cleaning of process area & clean room.</li><li>5. Preparation, review and approval of monthly Reports and BPRs BCRs, OOS, Deviation, investigations reports, validation protocols reports, validation reports.</li><li>6. Responsible for preparation of daily production planning and ensuring the same.</li><li>7. Production planning, ensuring that the batches are produced as per planning and meeting the dispatch targets.</li><li>8. Ensure proper utilization of equipment and manpower as and when required.</li><li>9. Planning and monitoring during execution of the process validation.</li><li>10. Manpower planning. Monitor the project modification activities.</li><li>11. Responsible to handle production processes.</li><li>12. Implementation of new technology w.r.t. process equipments or facility.</li><li>13. Supporting quality assurance team for DMF submission.</li><li>14. Executing and supervising training, validation, qualification and calibrations protocols.</li><li>15. To perform visual inspection and certification of cleaned equipment after product change over cleaning as per standard operating procedure.</li><li>CGMP:</li><li>1. Following departmental standard operating procedures (SOP) and providing suggestions for SOP simplification and any other improvements.</li><li>2. Making sure all the documents and checklist are verified before and after manufacturing.</li><li>3. Ensuring retention and destruction of records are maintained in a department.</li><li>4. Verifying status labeling of accessories, in-process instruments, containers, area & equipment.</li><li>5. Performing contemporaneous (on time) document entries.</li><li>EHS:</li><li>1. Following Environment, Health and Safety policies and practices.</li><li>2. Making sure personnel health, hygiene and organization practices are followed.</li><li>3. To conduct risk analysis of product, system, equipment, process as per standard procedure.</li><li>Training</li><li>1. Attaining training as per training need and providing training to sub-ordinates through available software of Learning Management System (LMS).</li></ul> at MSN Group<ul><li>Production Block Incharge Job Role: Operations, Control and Monitoring</li><li>1. All activities related to production and monitoring the process as per SOPs.</li><li>2. Communicate day to day process deviations and breakdowns of the equipment to concerned persons.</li><li>3. Check and implement the process for cleaning of equipment as per the schedules.</li><li>4. Responsible for housekeeping and implementation of day to day cleaning of process area & clean room.</li><li>5. Preparation, review and approval of monthly Reports and BPRs BCRs, OOS, Deviation, investigations reports, validation protocols reports, validation reports.</li><li>6. Responsible for preparation of daily production planning and ensuring the same.</li><li>7. Production planning, ensuring that the batches are produced as per planning and meeting the dispatch targets.</li><li>8. Ensure proper utilization of equipment and manpower as and when required.</li><li>9. Planning and monitoring during execution of the process validation.</li><li>10. Manpower planning. Monitor the project modification activities.</li><li>11. Responsible to handle production processes.</li><li>12. Implementation of new technology w.r.t. process equipments or facility.</li><li>13. Supporting quality assurance team for DMF submission.</li><li>14. Executing and supervising training, validation, qualification and calibrations protocols.</li><li>15. To perform visual inspection and certification of cleaned equipment after product change over cleaning as per standard operating procedure.</li><li>CGMP:</li><li>1. Following departmental standard operating procedures (SOP) and providing suggestions for SOP simplification and any other improvements.</li><li>2. Making sure all the documents and checklist are verified before and after manufacturing.</li><li>3. Ensuring retention and destruction of records are maintained in a department.</li><li>4. Verifying status labeling of accessories, in-process instruments, containers, area & equipment.</li><li>5. Performing contemporaneous (on time) document entries.</li><li>EHS:</li><li>1. Following Environment, Health and Safety policies and practices.</li><li>2. Making sure personnel health, hygiene and organization practices are followed.</li><li>3. To conduct risk analysis of product, system, equipment, process as per standard procedure.</li><li>Training</li><li>1. Attaining training as per training need and providing training to sub-ordinates through available software of Learning Management System (LMS).</li></ul> at MSN Group