Home

Damodhar - Sr BI Developer( Qlik view, Qlik sense, Tableau, Power BI)

[email protected]

Location: Austin, Texas, USA

Relocation: Yes

Visa: H1B

Damodhar Kalicheti Mobile : +1(631)202-7121 [email protected] 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. Proven ability to collaborate with developers to resolve data issues, define data standards, and implement data governance policies. Retrieving external data to Qlik Dashboard in terms of QVDs by making connection through ODBC/OLEDB. 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. Developed Drill through Dashboards which enabled users to drill down between dimensions. Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to User community. Install and configure Qlik connectors (web, REST, Sales force, and SAP connectors) Having good experience in data analysis and data modeling with optimization techniques. Qlikview data modeling by building the Star schema and resolving loops/synthetic keys. 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. Establish Row-level data security while comprehending Power BI s application security layer models Using Qlik Sense REST API to send data requests to your Python environment and retrieve processed results. Experience in good data visualization and Qlikview Functions and created NPrinting templates. Developed Scripts to load the relevant Data in Qlikview Applications. Capable of working efficiently in a team, self-motivated, proactive under tight deadlines with minimal /no supervision NPrinting report generation, distribution, and scheduling I have been part of the project implementations to production environment and direct communication with clients 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, Azure Data Bricks Operating System: Windows XP/NT/2000, 2012 R2 Programming: HTML, CSS, Python 3.4, Java Script, React, JSON, HTML, XML 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 Till Now Job Role : BI/QlikView 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 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 Qlikview dashboards optimization and testing the reports and finding the issues and fixing Qlikview dashboards Productions support and Handling all Qlik related SNOW tickets including issues and enhancement and user privileged access and other admin activities. 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 Improved the overall performance of the application and redesigned data model applying Qlik sense performance tuning techniques. Using Qlik Sense REST API to send data requests to your Python environment and retrieve processed results. 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. Handling all the Qlik administrations tasks including upgrades and migration and Qlik cloud, Qliksense environment setup and taking care of Licensing and SSL certification binding as well 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 : Business Intelligence Developer / QlikView Developer 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 Analytical tools like SSAS Tabular and multidimensional Cubes and MDX queries Qliksense 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 Improved the overall performance of the application and redesigned data model applying Qlik sense performance tuning techniques. 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 : The Regional IT service Dashboard will give an overview about major incidents status and their priority for each service categories on regional and time frame wide. The main objective of this dashboard is to collect the incidents data from HPSM which is raised in a company across the regions in organization and generate reports on its status by using Qlikview. It provides drilldown and drill through options to analyze metrics from a high level to a low level. 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 Keywords: user interface business intelligence information technology hewlett packard microsoft procedural language Delaware