Sindhuja Koluguri

BI Developer / Power BI / Tableau

Contact No: +1-571-***-****

Email Id : adyt8n@r.postjobfree.com

Linked In : Sindhuja Koluguri

SUMMARY:

Meticulous Business Intelligence consultant with 8.2 years of experience in Health care and Domain with strong knowledge on Data Ware Housing, Data Analytics, translating business needs into technical specifications, designing, deploying and building BI solutions using scrum/agile methodologies. Deft at providing easily understood dashboards using Power BI and Qlik sense and Tableau. Organized and dependable candidate, successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Hands on experience in developing visual reports, dashboards and KPI scorecards using Power BI desktop.

Have good knowledge in Power Query, Power pivot, Power view, Power BI Q&A, Power apps, SQL Server.

Experience in working with Power BI desktop, Power BI desktop Pro, Power BI Service, Power BI report, QlikView and Qlik sense, Tableau.

Imported data from SQL Server DB, Azure SQL DB, Jira API, SAP BW to Power BI to generate reports.

Hands-on experience in creating various types of visualizations like KPI, Gauges, Cards, maps, Q&A.

Good knowledge in DAX functions to manipulate the data.

Publishing Power BI Desktop reports created in Report view to the Power BI service.

Performed Connecting to data sources, importing data, and transforming data for Business Intelligence.

Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients.

Experience in performance tuning and query optimization.

Experience in designing and developing dashboards using Tableau desktop and publishing visually rich and intuitively interactive tableau workbooks.

Involved in Tableau administration tasks such as publishing workbooks, setting permissions, managing permissions, managing ownerships, providing access to the users, adding users to specific group in Tableau Server.

Skilled in gathering and analysing business requirements from stakeholders to identify data visualisation needs and deliver actionable insights

Conducted thorough business process analysis and gap assessments to improve operational efficiency and identify potential areas of data driven improvements.

Collaborated with cross functional teams to understand business needs, translate them into technical specifications and successfully implemented solutions.

Conducted in-depth analysis using power BI to identify trends, patterns, and outliers which led to actionable insights and business optimisations.

Analysed and documented business needs, objectives and constraints to define clear and actionable BI project scope and objectives .

Expert in creating Different Visualizations in Tableau like Heatmaps, Histograms, Gantts, Bubble, Scatter chart.

Experience in extracting data from databases like Oracle, MS Sql into Tableau.

Excellent communication, analytical, client interaction and presentation skills and proven experience in leading a team, working independently in a team.

Utilized SQL and other data querying tools to perform in-depth data analysis, identifying trends, patterns, and insights that supported data-driven decision-making.

Conducted data profiling to assess data quality, integrity, and consistency within BI datasets.

Designed logical data models, data flows, and data integration processes for efficient BI reporting and analytics.

Conducted training sessions and workshops for business users, empowering them to leverage BI tools and self- serve analytics for day-to-day decision-making.

Supported change management initiatives to facilitate the successful adoption of BI solutions across the organization.

Proficient in designing and developing paginated reports using tools like SQL Server Reporting Services (SSRS) or Power BI Report Builder.

Created complex and pixel-perfect reports, adhering to specific business requirements and formatting guidelines.

Designed aesthetically appealing report layouts, incorporating tables, charts, graphs, and images to effectively present data-driven insights.

Customized report formatting, such as header, footer, and page numbering, to match organizational branding and improve report readability.

Good exposure to all phases of the Software Development Life Cycle and Agile process.

Proficiency in Data Modelling and Dimensional Analysis.

Experience developing in Report Builder (static reports, paginated reports, etc.)

Experience in designing and development of Canvas and Model-driven Power Apps.

Writing efficient SQL queries for data retrieval, manipulation and analysis.

Effective liaison between Business Analysts, Developers, Quality Assurance, Systems Support and Customers/Users with a reputation for timely resolution of issues and a drive for business results.

Experience in communicating with stakeholders, Subject Matter Experts (SMEs), and end - users to better understand, analyse, communicate, and validate requirements.

Have knowledge in creating SSIS packages and adding tasks.

Working with Query Editor to connect to different data sources and working on Data models.

Creating new Calculated Tables, Calculated Columns and Measures.

Performed detailed data analysis, validation, and identify data quality issues to ensure consistency across all environments.

Good Functional understanding in Supply chain, Finance, Procurement (Direct & Indirect) in Health care Domain.

Demonstrated Intermediate level proficiency in snowflake, utilizing its data warehousing capabilities to design and implement scalable and efficient data solutions.

Knowledge in writing SQL queries in snowflake, including joins, subqueries, aggregations to extract and analyse data for business intelligence purposes.

Implementing security measures in snowflake, ensuring data privacy and compliance by managing user access, roles and privileges and implementing row level security for sensitive data.

Worked through all phases of SDLC which includes gathering & analysing business requirements, functional/technical specifications, designing, developing, testing & deploying the applications.

Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.

Data mashups and transformations using M language.

Use of power shell commands.

Created design documents, system requirement documents, change logs specific to each application/project.

Good at analysing and debugging data errors.

Closely worked with stakeholders in backlog grooming, point based effort estimation, prioritising, planning sprints and actively led the sprint review, retrospective, planning meetings.

Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.

Designed and developed Qlik sense dashboards by extracting data from different sources like SAP BW, SAP SQL, flat files etc and building QVDs.

Creating powerful calculations, key metrics, and key performance indicators (KPIs).

Excellent communication, interpersonal, problem solving, and analytical skills.

While Qlik sense, Power BI have been areas of my work, got my hands on Power apps and Power Automate.

Ability to work in groups as well as individually with minimum supervision.

Ability to adapt to fast changing skills and work.

Experience working on Python scripts.

Willing to learn new technologies as when needed. Technical Skills:

Reporting Tools Power BI Desktop, Power BI Service, Qlik sense, Qlik view, Tableau Desktop, Tableau server

Database Teradata 14, SQL Server 2014/2016, Oracle 12c Domain Experience Health care and Life science(Finance Data), Supply chain Management Other Tools &

Technology

Microsoft Excel, Microsoft Word, JIRA, Confluence, Power apps Power Automate, Azure SQL, Azure Storage, Azure Data factory Professional Experience:

Tech Mahindra, India/ London UK

Client: GSK (GlaxoSmithKline, UK) Dec 2021 – Oct 2022 Location: Hyderabad

Power Bi Developer

Responsibilities:

Actively participated in the interactions with the end users during requirement gathering, prepared high level requirement specification documents, worked with Product Owner in technical design to fulfil the client requirements.

Participated in the various sprint ceremonies – Sprint demos, sprint retrospective and planning, daily stand-up meetings. Demo the stories developed to the product owner and acquire the story acceptance, identify, and mitigate any blockers so the sprint runs smoothly.

Collaborated with business users and technical teams to design BI solutions that aligned with business goals and addressed specific analytical challenges.

Created functional and technical specifications for BI reports, dashboards and data models ensuring alignment with business requirements.

Conducted thorough interviews and workshops with stakeholders to elicit business requirements related to data analysis, reporting and decision making.

Implemented data validation processes to ensure data accuracy, consistency, and integrity within BI reports and dashboards.

Created different types of visualizations like maps, KPI, Gauges, Pivot Tables, Bar Charts, Q&A and cards.

Imported data from SQL Server DB, Azure SQL DB, Flat files to Power BI to generate reports.

Worked with Dataflows with Incremental models to enhance the query performance.

Worked on data transform using Power Query to join different queries.

Applied DAX functions on the received data.

Created hierarchies and attributes as part of dimensional modelling.

Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs.

Developed high level daily summary reports (Flash reports), and monthly business summary reports (Monthly Management Report).

Developed multiple reports under ICT App for different markets.

Drafted all the required documents for all the reports under ICT.

Implemented row level security to the reports using Power BI service.

Published Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.

Scheduled Automatic refresh and scheduling refresh in power BI service.

Created Page Level Filters, Report Level Filters, Visual Level Filters, Bookmarks, Buttons in Power BI according to the requirements.

Worked with the stakeholders from multiple teams, QA testing and business analyst teams during the day in having the change requests analysed, fixed, and tested.

Provided extended support for the Production implementation activities to ensure the smooth migration of the new changes.

Scheduling workshops/meetings with the end users for Demo on the developed reports and to seek their feedback.

Client: GSK (GlaxoSmithKline, UK) Feb 2021 – Dec 2021 Location: London

Business Intelligence Consultant

Responsibilities:

Worked with the Product Owner and the end users to gather requirements.

Conducted Weekly meetings with clients to understand the support process and backlog grooming.

Worked on creating ATP reports and Dashboards with different visualizations using Power BI desktop.

Involved in Data Extraction, Transformation, and Loading (ETL) process from source to target systems.

Actively supported business users for change requests.

Used parameters and functions in M query for optimization.

Worked on fixing the issues occurred during the batch process and solving the tickets raised in Helpdesk.

Extensively used Jira to track and reports issues and bugs.

Participated in the identification, understanding, and documentation of business requirements, keeping in mind the need for the application based on the project scope and SDLC methodology.

Performed various data massaging activities like treating null values, cleaning data, sorting, data conversions by using the Power Query Editor.

Developed UAT plans and test cases for BI solutions, coordinating with business users to validate data accuracy, report functionality, and overall user experience.

Facilitated UAT sessions and managed defect resolution to ensure successful BI solution deployment.

Created various models with the fact and dimensional tables that are imported into Power BI.

Created the calculated columns and measures with the use of DAX Expressions.

Involved in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc.

Accessed and used various Custom Visuals available in Power BI.

Identified process inefficiencies through data analysis within BI reports, leading to process improvement recommendations and actionable insights.

Supported business users in defining key performance indicators (KPIs) to measure process effectiveness and performance.

Creating interactions of Highlight action, Filter action add interactivity to the visualizations.

Involved in advanced calculations, creating Parameters, slicers, Buttons and Bookmarks. Client: GSK (GlaxoSmithKline, UK) Jul 2020 – Feb 2021 Location: London

Business Intelligence Consultant

Responsibilities:

Provide a consolidated view of the captured Procurement data by combining subsets of data from systems and stage it in a format that can be easily interrogated by the business users.

Regular catchups with business users for gathering the requirements.

Involved in importing data in Import and Direct Query Modes from SQL Server.

Performed various data massaging activities like treating null values, cleaning data, sorting, data conversions by using the Power Query Editor.

Created various models with the fact and dimensional tables that are imported into Power BI.

Created the calculated columns and measures with the use of DAX Expressions.

Involved in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc.

Assisted in change management activities, including user training sessions and communication plans, to ensure smooth adoption and utilization of BI solutions.

Provided training materials and documentation to enable self-service reporting and data exploration for business users.

Monitored BI solution performance, identifying bottlenecks and areas for improvement to enhance system response times and user experience.

Conducted periodic reviews with business stakeholders to assess BI solution effectiveness and address evolving business needs.

Use of Parameters and functions in M query to optimise query performance.

Accessed and used various Custom Visuals available in Power BI

Created multiple reports and dashboards according to the client requirement

Creating interactions of Highlight action, Filter action add interactivity to the visualizations.

Involved in advanced calculations, creating Parameters, slicers and Interactions.

Implemented Row Level Security on data and have an understanding of application security layer models in Power BI.

Designed and created use cases and test cases

Extensively used Jira to track and reports issues and bugs

Experience in generating on-demand and scheduled reports for business analysis or management decision.

Shared the created workspace across the organization using Power BI Apps.

Worked on Advance Analysis actions, filters, parameters, background images, maps for preparing dashboards and worksheets in Tableau desktop 10.5.

Client: GSK (GlaxoSmithKline, UK) Jan 2019 – Jul 2020 Location: London

Business Intelligence Consultant

Responsibilities:

Worked through all phases of SDLC which includes gathering & analysing business requirements, functional/technical specifications, designing, developing, testing & deploying the applications

Generated test cases to test the functionality of the datasets and document and fixed the issues found during testing

Expertise in using advanced level calculations on dataset.

Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.

Use of power shell commands.

Extracted data using API, setting up dataflows, building models, designed reports.

Developed applications using PowerApps, canvas, model driven app.

Developed multiple dashboards, analytical reports, KPIs and Interactive reports based on business needs.

Developed, implemented, and maintained test strategies and plans.

Organised and presented weekly/fortnightly user feedback sessions.

Performed various data massaging activities like treating null values, cleaning data, sorting, data conversions by using the Power Query Editor.

Created various models with the fact and dimensional tables that are imported into Power BI.

Created the calculated columns and measures with the use of DAX Expressions.

Involved in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc.

Contributed to the development of the organization's BI strategy, aligning BI initiatives with long-term business objectives and future growth plans.

Evaluated emerging BI technologies and trends to recommend relevant tools and approaches for continuous improvement.

Use of Parameters and functions in M query to optimise query performance.

Accessed and used various Custom Visuals available in Power BI.

Created multiple reports and dashboards according to the client requirement.

Creating interactions of Highlight action, Filter action add interactivity to the visualizations.

Involved in advanced calculations, creating Parameters, slicers, and Interactions.

Use of tableau prep builder for joins and data clean up prior to data build.

Implementing Row level security in Tableau.

Publishing Tableau dashboards on tableau server or tableau online and embedding them into portal.

Use of calculated fields, actions, parameters, sets, quick and context filter according to the end user requirement in tableau.

Created multiple reports and dashboards according to the client requirement.

Creating interactions of Highlight action, Filter action add interactivity to the visualizations.

Involved in advanced calculations, creating Parameters, slicers, and Interactions Client: GSK (GlaxoSmithKline, UK) Aug 2017 – Jan 2019 Location: London

Qlik sense Admin & Power Bi Developer

Responsibilities:

Daily monitoring of the scheduled tasks and accordingly solving the issues occurred during daily/weekly and monthly schedules.

Creating workspaces in Dev, Informal, Formal and Prod for self-service dashboards.

Approving signoffs for deployments.

Daily meetings with the Qlik sense users to address their queries as an Admin.

Applying security rules according to the business needs.

Drafting and maintaining documents for every change in the QMC.

Solving the tickets raised in Remedy and creating Qlik sense dashboards for weekly reports.

Managing job failure analysis and production support for various applications.

Designed daily refresh process and created tasks and triggers using QMC.

Involved in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc.

Experience in generating on-demand and scheduled reports for business analysis or management decision.

Created various models with the fact and dimensional tables that are imported into Power BI.

Created the calculated columns and measures with the use of DAX Expressions. Client: GSK (GlaxoSmithKline, UK) May 2015 – Aug 2017 Location: Hyderabad

Qlik sense & Power Bi Developer

Responsibilities:

Responsible for gathering business requirements and technical specifications from the users

Designed and developed Qlik sense dashboards by extracting data from different sources like SAP Bw, SAP SQL, flat files etc and building QVDs,

Worked on Data modelling, developed Qlik sense dashboards using objects like Pivot tables, containers, Line charts, combo charts etc.

Security implementations using Section access and Security rules.

Scheduled the jobs and distributed to end users from QM.

Created detailed technical specification, business requirements and unit test report documents.

Actively involved in upgrading to the latest Qlik sense versions.

Designed, tested scripts and documented debugging processes to effectively control and reduce errors.

Worked closely with other developers, UX designers and analysts to create cohesive finished products.

Ensured bug reports were remedied, handling all associated issues promptly and effectively.

Performed Connecting to data sources, importing data, and transforming data for Business Intelligence.

Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.

Developed multiple dashboards, analytical reports, KPIs and Interactive reports based on business needs.

Worked on data transform using Power Query to join different queries.

Applied DAX functions on the received data.

Client: GSK (GlaxoSmithKline, UK) Aug 2014 – May 2015 Location: Hyderabad

Qlik sense Developer

Responsibilities:

Interacting with business on requirement gathering, analysis of design approach

Data extractions from SAP SQL, SAP Bw, Flat files.

Creating Qvd’s and building transformations on Qvd’s.

Data Modelling using Star schema and snowflake schema.

Working with Qlik sense QMC.

Created Incremental load to load data from different sources.

Experience on using Alternate states and Direct Discovery.

Analysed data and defined Key Performance Indicators.

Perform error handling process, debugging and troubleshooting the jobs.

Involved in performing Unit testing and system testing.

Implemented Set Analysis to improve calculation times on the front end.

Poc’s on developing power Bi dashboards.

Migration from Qlik apps to Power Bi Dashboards. Education

Bachelor of Technology in Computer Science from JNTU University in 2014

Contact this candidate