Data Quality Power Bi

Damodhar Kalicheti

Mobile : +1-631-***-****

********.**@*****.***

Experience Summary:

12+ years of IT experience in analysis, design, development, testing, implementation and support.

Data warehousing/Business Intelligence practitioner ability to build, customize and publish interactive data visualizations and dashboards using Qlik sense, Qlik Cloud, QlikView, Power BI.

Involved in Requirement gathering & designing Qlik applications by using Agile Methodology.

Involved in Extracting & transforming and loading (ETL) data from multiple data sources into QlikView application.

Install and configure Qlik products suite like QlikView, Qlik sense, and Data bundle packages.

Excellent experience implementing data warehouse tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI and DAX.

Expertise in managing and analyzing customer data, with a strong focus on data quality improvement and experience with Reltio preferred.

Create, define and document data integration, migration and transformation requirements, along with current-to-future state mapping and non-functional requirements.

Document data quality rules for key attributes &work with data quality analysts and business partners on improving.

Proven ability to resolve data issues, define data standards, and implement data governance policies.

Expertise in managing and analyzing customer data, with a strong focus on data quality improvement and experience.

Evaluate the quality of the data, identify and interpret trends or patterns in data sets and Facilitate data harmonization conversations with global business partners

Analyzes user requirements from both state agency and local agency staff and communicates testing requirements, training, and feedback to business leads for enhancements to production.

Consults and escalate project decisions to the business lead for final decisions and approval of complex project deliverables.

Design, develop, coordinate, and conduct test cases for User Acceptance Testing (UAT) that impacts the WIC MIS.

Reviews release notes and communication-related material about EBT benefit issuance, client portal, and other enhancements. Provides feedback prior to implementation in production.

Provides quality customer service to external and internal customers by prompt responses to inquiries, taking the initiative to solve problems, exercising flexibility, and seeking improvements in the advanced planning and business processes.

Provides guidance and explains processes to interested groups and team members.

Participate and support business partners in data governance discussions for key data attributes.

Maintain data dictionary and business glossary and participating in data testing and validation.

optimizing sales processes using Sales business process reengineering (BPR) for efficiency, effectiveness

Experts in Extracting, Transforming, Analyzing, Visualizing, and presenting data from diverse business areas in novel and insightful ways and interface with clients.

Create, execute, and maintain forecasting models to the underlying assumptions and inter-workings of the model used to create the forecast.

Collaborate with data engineers to gather and clean data from various sources, ensuring data integrity and quality

Communicate findings to stakeholders and leadership with recommendations for actions to address business changes, trends, and issues.

Strong business analysis skills, including gathering and documenting data requirements, understanding business needs and trade-offs, conducting interviews and workshops, harmonizing requirements, proposing solutions, and analyzing source systems, Data profiling, and KPI definitions.

Experience in maintaining data definitions, data quality rules, data lineage, data dictionary data governance and data quality improvement,

Proven experience handling complex data projects, collaborating with global teams, and delivering engaging presentations to partners at all levels.

Developing new extensions, Mashups using JavaScript, React, and Qlik APIs using them effectively in dashboards.

Involved in Performance Tuning using Incremental load logic which handles Insert, Update, Delete of source data and tuning underlying data in QlikView Applications.

Implemented machine learning algorithms within Qlik Sense to build predictive models and generate insights directly in your visualizations by integrating Python libraries like scikit-learn.

Configuring EDC and Axon, including glossaries, dashboards, data quality and discovery features.

Establish Row-level data security while comprehending Power BI’s application security layer models

Capable of working efficiently in a team, self-motivated, proactive under tight deadlines with minimal /no supervision

Skills: -

Domain knowledge:

Sales, Manufacturing, Incident Management, HealthCare

BI Tools:

QlikView 10/11/12/May2024, Qlik SAAS, Qlik Sense, NPrinting, Alteryx and Power BI

ETL Tools:

SSIS, Talend, AWS,Azure Data Bricks

Operating System:

Windows XP/NT/2000, 2012 R2

Programming:

HTML, CSS, Python 3.4, Java Script, React, JSON, HTML, XML, OCI

Database/Tools:

Oracle 11g/10g/9i, Microsoft SQL Server 2016/02/08, SQL, IBM DB2, MS Access 2000

Versioning Tools:

SVN, Git

Project Summary:

Client : Mathematica, USA Nov 2022 – Mar 2025

Job Role : Data Analyst/ Data Consultant

Description : Mathematica is a policy research and data consultancy driven by a mission to improve public well-being. Employee-owned and mission-driven, Mathematica works with government agencies, private-sector organizations, foundations, and businesses providing health care and other human services. Organizations around the world committed to the public good rely on us to help improve programs, refine strategies, and deepen understanding.

Responsibilities:

Worked in close association with Business Users to understand their requirements

Create, define and document data integration, migration and transformation requirements, along with current-to-future state mapping and non-functional requirements.

Document data quality rules for key attributes &work with data quality analysts and business partners on improving.

Proven ability to resolve data issues, define data standards, and implement data governance policies.

Expertise in managing and analyzing customer data, with a strong focus on data quality improvement and experience.

Evaluate the quality of the data, identify and interpret trends or patterns in data sets and Facilitate data harmonization conversations with global business partners

Analyzes user requirements from both state agency and local agency staff and communicates testing requirements, training, and feedback to business leads for enhancements to production.

Consults and escalate project decisions to the business lead for final decisions and approval of complex project deliverables.

Design, develop, coordinate, and conduct test cases for User Acceptance Testing (UAT) that impacts the WIC MIS.

Reviews release notes and communication-related material about EBT benefit issue, client portal, and other enhancements. Provides feedback prior to implementation in production.

Provides quality customer service to external and internal customers by prompt responses to inquiries, taking the initiative to solve problems, exercising flexibility, and seeking improvements in the advanced planning and business processes.

Provides guidance and explains processes to interested groups and team members.

Participate and support business partners in data governance discussions for key data attributes.

Maintain data dictionary and business glossary and participating in data testing and validation.

optimizing sales processes using Sales business process reengineering (BPR) for efficiency, effectiveness

Experts in Extracting, Transforming, Analyzing, Visualizing, and presenting data from diverse business areas in novel and insightful ways and interface with clients.

Maintain data dictionary and business glossary and participating in data testing and validation.

Dashboards Productions support and Handling all Qlik related SNOW tickets including issues and enhancement and user privileged access and other admin activities.

Strong business analysis skills, including gathering and documenting data requirements, understanding business needs and trade-offs, conducting interviews and workshops, harmonizing requirements, proposing solutions, and analyzing source systems, data profiling, and KPI definitions.

Experience in maintaining data definitions, data quality rules, data lineage, data dictionary, data governance and data quality improvement.

Proven experience handling complex data projects, collaborating with global teams, and delivering engaging

Reporting issues, reasons for issues and solutions for problems to peers, Onsite counterparts and to clients

Environment: Qlik SAAS, Qlik Sense, Qlik View, PostgreSQL, Snowflake, Azure Data Bricks, Microsoft SQL Server 2014

Client : Ball Corporation Sep 2019 – Sep 2022

Job Role : Data Analyst

Description : Ball is the leading global supplier of innovative, sustainable aluminum packaging for beverage and

aerosol products, here I have been involved in multiple dashboards developments in Sales, production, shipping and inventory data reports like shipment cost reporting,Salable inventory, Stock Mix,OTIF.

Responsibilities:

Worked in close association with Business Users to understand their requirements

Data Modeling/scripting, data visualization and managing data flow between source and application.

Creating dashboards by extracting & transforming and loading (ETL) data from database write and externalize the load scripts, store the data as QVD files and design the UI based on business/user requirements.

Leading the Team and interacting with business stake holders, managing, planning maintenance work, solutioning and estimating for discretionary work

Create, define and document data integration, migration and transformation requirements, along with current-to-future state mapping and non-functional requirements.

Document data quality rules for key attributes and work with data quality analysts and business partners on improving.

Proven ability to collaborate with developers to resolve data issues, define data standards, and implement data governance policies.

Expertise in managing and analyzing customer data, with a strong focus on data quality improvement and experience with Reltio preferred.

Evaluate the quality of the data, identify and interpret trends or patterns in data sets and Facilitate data harmonization conversations with global business partners

Participate and support business partners in data governance discussions for key data attributes.

Maintain data dictionary and business glossary and participating in data testing and validation.

Analytical tools like SSAS Tabular and multidimensional Cubes and MDX queries

Qlik sense dashboards optimization and testing the reports and finding the issues and fixing

With Qlik NPrinting, combining several Qlik objects into a single report for analytics, scheduling this custom report to distribute via emails in static format (PDF, Excel, word, Power Point).

Design multi-dimensional data models and Run DAX queries and functions in Power BI.

Establish row-level data security while comprehending Power BI’s application security layer models.

Qlik data modeling by building the Star schema and resolving loops/synthetic keys.

Dashboard allows users to drill down to different levels like Region, Country, year, quarter and Month for different service categories. It shows the trends and indicators for easy analysis

Use the Qlik Sense REST API to send data requests to your Python environment and retrieve processed results.

Reporting issues, reasons for issues and solutions for problems to peers, Onsite counterparts and to clients

Environment: Qlik sense, QlikView, Power BI, SSIS, Snowflake, Microsoft SQL Server 2014, SQL

Client : DXC Nov 2018 – Jun 2019

Job Role : Business Intelligence Developer/QlikView Developer

Description : DXC Technology helps global companies run their mission-critical systems and operations while modernizing IT, optimizing data architectures, and ensuring security and scalability across public, private and hybrid clouds. The world's largest companies and public sector organizations trust DXC to deploy services to drive new levels of performance, competitiveness, and customer experience across their IT estates. Here I worked on Regional IT services data and built dashboards on their IT service categories regionally.

Responsibilities:

Worked in close association with Business Users to understand their requirements

Data Modeling/scripting, data visualization and managing data flow between source and application.

Creating dashboards by extracting & transforming and loading (ETL) data from database write and externalize the load scripts, store the data as QVD files and design the UI based on business/user requirements.

Leading the Team and interacting with customers, managing communications, planning maintenance work, solutioning and estimating for discretionary work

Design multi-dimensional data models and Run DAX queries and functions in Power BI.

Establish Row-level data security while comprehending Power BI’s application security layer models

QlikView data modeling by building the Star schema and resolving loops/synthetic keys.

Testing the reports and finding the issues and fixing

Dashboard allows users to drill down to different levels like Region, Country, year, quarter and Month for different service categories. It shows the trends and indicators for easy analysis

Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.

Implemented machine learning algorithms within Qlik Sense to build predictive models and generate insights directly in your visualizations by integrating Python libraries like scikit-learn.

Reporting issues, reasons for issues and solutions for problems to peers, Onsite counterparts and to clients

Environment: QlikView 12, Qlik sense, Power BI, Microsoft SQL Server 2014, HTML, JavaScript, MS-Excel

Client : Micro focus Feb-2018 - Oct-2018

Job Role : Business Intelligence Developer &Admin

Description : Micro Focus FAST Change and Migrate Program is ability for Requirements Traceability. It will Tracks a requirement through its lifecycle from inception to fulfillment and Identifies changes to scope of requirements when it occur. It Identify the simplicity and/or complexity of a requirement based on the number of relationships. The scope of Requirements Traceability Matrix will include Finalized and Approved Business Requirements, Product Requirements mapped to corresponding Business Requirements and Test Cases mapped to Product and Business Requirements

Responsibilities:

Business requirement gathering/analysis, Defining and documenting business, technical & functional specifications.

Expertise in system feasibility study, system redesign/engineering and implementation with significant experience in Data Modeling/Data Quality Analysis/Data Validation.

Extracted data from Data Source and load data into QVDs.

Responsible for designing, coding, and testing the Qlik applications according to Business requirements

Created Web based reports using Mashups and created NPrinting templates.

Used Qlik data market extensions like Geo Analytics

Migrated Qlikview applications to Qlik sense by using Qlik converter.

Data Modeling/scripting, data visualization and managing data flow between source and application.

Deployment of Qlik Dashboard and Testing the reports & finding the issues and fixing

Reporting issues, reasons for issues and solutions for the problems to peer, Onsite counterparts and to clients

Environment: Qlik sense, QlikView 11, MS SQL Server 2014, Oracle SQL Developer, TOAD, ALM, MS Excel

Client : HP Enterprise Jun-2016 - Feb-2018

Job Title: Business Intelligence Developer/ QlikView Developer

Description: HPE usually starts a contract with partners at the entry level as a Business Partner With increased investments in Sales and Technical training and certification as well as growing Hewlett Packard Enterprise sales revenue, you can move up from Business to Silver, Gold, and top level as a Platinum Partner.EG Channel Heatmap is a secure, intuitive, user friendly dashboard to provide insights of EG Channel Performance at region, sub-region, country, BU, partner tier & product category level with the ability to drill-down by partner for both distributors & resellers wise

Responsibilities:

Business requirement gathering/analysis, defining and documenting business, technical & functional specifications,

Expertise in system feasibility study, system redesign and implementation with significant experience in Data Modeling/Data Quality Analysis/Data Validation.

Improved the overall performance of the application and redesigned data model applying Qlikview performance tuning techniques

Created Web based reports using mashups and created customized objects using list, Hypercube.

Utilized data market extensions in applications like Geo analytics, Currency exchange, weather data extraction

Advance Report generation & scheduling & distributing application by Using N Printing.

Responsible for designing, coding, and testing the Qlik sense applications according to Business requirements

Resolved complex issues and Error Handling in Qlikview.

Deployment of Qlik sense Dashboard

Testing the reports and finding the issues and fixing

Reporting issues, reasons for issues and solutions for the problems to peer, Onsite counterparts and to clients

Environment: Qlik view, Qlik Sense, Oracle SQL Developer, TOAD, or similar data tools.

Client : Terex Nov-2015 - May-2016

Job Title : QlikView Developer/ BI Developer

Description: Terex Corporation is a diversified global manufacturer of a broad range of heavy equipment for a variety of industries, including construction, infrastructure, quarrying, recycling, surface mining, shipping, transportation, refining, utility and maintenance. Terex has a business requirement to shift their current Terex Warranty System (TWS) to SFDC, Warranty on Demand. With respect to this change, loading data to the new DWH from SFDC system through Informatica ETL and develop Qlikview reporting for this new warranty data. In this, we are generating Qlikview reports for claim processing and Global Product based on New DWH Data.

Responsibilities:

Worked in close association with Business Users to understand their requirements

Responsible for designing, coding, and testing the Qlikview applications according to Business requirements

Data Modeling/scripting, managing data flow between source and application.

Deployment of Qlikview Dashboard

Testing the reports and finding the issues and fixing

Reporting issues, reasons for issues and solutions for the problems to peer, Onsite counterparts and to clients

Implemented two different data models for single applications.

Developed Claim Processing KPI’s & Global Product Quality reports based on various KPI’s.

Implemented comparison between Previous Year Vs Current Year charts for various measures.

Implemented Rolling 12 months, MSUM and RSUM charts for different dimensions and measures.

Developed Drilldown Pie chart for a particular measure.

Used set analysis expressions to restrict the data in charts and tables.

Implemented alternate states to compare the measures with a single dimension.

Environment: Qlikview11, SQL Server 2014, MS-Excel, ETL

Client : Fitch Rating Oct-2014 - Nov2015

Job Title : QlikView Developer/ BI Developer

Description : Fitch Ratings is a leading provider of credit ratings, commentary and research. Dedicated to providing value beyond the rating through independent and prospective credit opinions, Fitch Ratings offers global perspectives shaped by strong local market experience and credit market expertise .Fitch Solutions provides credit and macro intelligence solutions helping clients to excel at managing their counterparty risk, gain deeper insights into the debt and fixed income markets, and get comprehensive intelligence about the macroeconomic environment. These ratings are typically published in the form of letter-grades, such as “AAA”, “AA”, “A+”, along with related commentary.

Responsibilities:

Worked in close association with Business Users to understand their requirements

Responsible for designing, developing and testing the Qlikview applications according to Business requirements

Data Modeling/scripting, extracting transforming and loading (ETL), data visualization and managing data flow between source and application.

Retrieving external data to Qlikview Dashboard in terms of QVDs by making connection through ODBC /OLEDB

Designed Dashboard using different components of Qlikview Like List box, Multibox, slider, buttons, charts(Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table)

Deployment of Qlikview Dashboard and Testing the reports and finding the issues and fixing

Reporting issues, reasons for issues and solutions for problems to peers, Onsite counterparts and to clients

Developed multiple Reports (HR SABA REPORT, FDR, AGENTS, Fee Arrangements)

Environment: Qlikview11, SQL, PL/SQL, MS-Excel, ETL

Client : L&T InfoTech Feb-2012 - Sep-2014

Job Title : Software Developer

Description : Due to historical reasons and multiple copies of Master Data on disparate hardware and software platforms, organizations are saddled with the problem of identifying Master information uniquely. This leads to data redundancy and inconsistency.1-View is highly configurable and hence it can be quickly deployed on any type of master such as Customer, Vendor, Material, etc. by just assembling the Table structures. 1-View has a built-in de-duplication algorithm that helps in identifying duplicate records automatically to a very large extent. 1-View efficiently helps in consolidation of Master Data to provide stakeholders with a single version of truth.

Responsibilities:

Worked on Change Requests for the entire project.

Data cleansing and testing and analyzing the data.

Designed JSP pages and java script validations for each page.

Developed presentation-tier JSP pages in HTML, Implemented jQuery Data Grid control, Validation control and other Widget controls.

Designed Dashboard using different components of QlikView Like List box, Multi box, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table)

Developed Web forms/user interfaces using Struts MVC, jQuery and JSP, Ajax Controls, Web forms, JavaScript

Able to construct prototype experimental features quickly with functional HTML/CSS/JavaScript

Created different kinds of pattern validations of zip code using Reg exp.

Environment: QlikView, Java, JavaScript, Oracle (SQL, PL/SQL), HTML, CSS,1-view

Educational Qualification

Master’s Degree(Computer applications) from Jawaharlal Nehru Technology University and completed in 2009.

Bachelor’s Degree from Jawaharlal Sri Venkateswara University and completed in 2006.

Contact this candidate