SAI CHOWDAWARAM

BI Analyst | QlikView / QlikSense Developer         

•        Around 7+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.

•        Experience in database design & development, database programming, data modeling, business process analysis, and application development.

•        Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView. 

•        Good expertise with the development and design of QlikView applications. 

•        Expertise in Installing and Configuring QlikView11.x,12.1 / Qlik Sense Desktop 3.0,3.2(Sept 2017,April 2108), QlikView / Qlik Sense Server, QlikView Publisher and Qlik Sense Server.

•        Expertise in things like QlikView performance optimization, QlikView Management console, and QlikView Data Modelling.

•        Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.

•        Very good experience in designing data visualization widgets factoring usability, accessibility and user experience (UX). Leveraged browser technologies like CSS, HTML, JavaScript and D3.js for interactive widgets with animations and transition support.

•        Worked in close association with customers for requirement gathering and effective analysis.

•        Experience in designing and creating database objects such as Tables, Views, Indexes, stored procedures, functions, triggers in SQL Server based on logical design model and user requirements.

•        Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQLserver.

•        Worked on QlikView Server & Publisher maintenance, creating scheduled jobs for QVD extracts and report reloads.

•        Hands on experience in customizing the QlikView, Qlik Sense and NPrinting reports as per the business requirements. 

•        Experience in designing QlikView Document/User Setting Layouts to make consistent and professional optimized look to clients. 

•        Experience in performance tuning, logging, error-handling of SSIS packages and deploying from development server to production server. 

•        Experience in report generation using SQL server reporting services (SSRS) from relational databases as well as OLAP cubes. 

•        Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products. 

•        Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

Rent-A-Center, Plano, TX                                                                                                                                                                                                                                         AUG 2016 – MAY 2018 Qlikview/Qliksense Developer

Developed and supported inventory management dashboard which provide detail information and analysis of Inventory for Management. Migrated inventory management dashboard from QlikView to QlikSense product.

The project scope includes QlikView/Qlik Sense Installation, Configuration, Maintenance and Production Support.

Responsibilities as BI Developer:

•        Developed extensively Alerts, Variables, Input boxes, calendar & Macros. 

•        Identification data sources and targets for data modeling and solution architecture. 

•        Worked with business teams to understand requirements for creating dashboards with required KPI's in QlikView and then migrated to QlikSense.

•        Configured and customized NPrinting platform to publish produce PDF and HTML reports.

•        Worked directly with business users to define and prototype QlikSense Applications. 

•        Worked on look and feel of widgets and report to meet Rent-A-Center visual guidelines and applied fonts and colors using HTML, CSS.

•        Implemented better user experience using JavaScript and D3.js by offering interactive controls for drill down and data filter.

•        Involved in designing of QlikView solutions & Full Lifecycle Implementations. 

•        Experience in designing dashboards using Qlik Sense and migrating applications from QlikView to Qlik Sense. Knowledge in QlikView Extension objects. 

•        Experience in loading data into Qlik Sense from various sources and modeling data as per user requirements. 

•        Involved in Extracting, Transforming and Loading data from different data source.  

•        Leveraged existing QlikView DataMart’s to migrate Qlik Dashboards onto QlikSense environment.

•        Presales project requirement gathering, coordination with business analyst and pre- sales teams. 

•        Provide scripting support for the Analytics Department to meet complex business requirements 

•        Utilize QlikView Publisher and QlikView Server capabilities.  

•        Developed QlikView Dashboards using Drill Down & Cyclic Grouping

•        PDF report generation and auto emailing of reports. 

•        Developed KPI’s and set analysis applications.

•        Implemented Security & involved in Deployment of QlikView Applications.

•        Experience in transformation of external data sources to QVD’s and from QVD’s to QVW reports

•        Used Windows scheduler, batch files for refreshing Qvd and Qvw.

•        Developed dashboard which gives overall health of all the servers viz. No. of users logged in, usage of an application daily/weekly/monthly which helps in capacity planning, different reload tasks status.

•        Develop effective QlikView data models on various databases like flat files, SQL 2000 & 2005, MS access and Oracle to fetch the data into Qvds/models. 

•        Developed KPI’s and set analysis applications. Experience in Using QlikView Functions.

Environment: QlikView 11.2,12.1, QlikSense v3/3.2, v2017 Sept/2018 April, NPrinting 15x/16x, QlikView Enterprise Management Console, HTML5, CSS3, JavaScript, D3.js, Oracle, SQL, PostgreSQL, SQL Server

Aurobindho Pharma, India                                                                                                                                                                                                                      MAR 2013 – JUN 2015

QlikView Developer

Responsibilities as BI Developer:

•        Worked with the finance teams to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables. 

•        Participated on business requirement document preparation. 

•        Participated in Scrum stand up meetings. 

•        Created SQL Stored Procedures and Views to fetch the data from database to build reports. 

•        Designed and created the financial dashboard reports for Executive board of company. 

•        Modified existing reports using QlikView. 

•        Maintained and updated the dashboard reports as required by client. 

•        Developed Dashboard showcasing different KPI's involving QlikView objects like Containers, Charts, Text objects, List boxes, Buttons, Bookmarks. 

•        Designed and developed QlikView(TM) desktop applications and server-based QlikView(TM) dashboards from scratch to support BI initiatives. 

•        Migrated applications from QlikView to QlikSense.

•        Analyzed the external financial and regulatory reporting, intercompany and internal management reporting needs of the business process. 

•        Installed, configured and deployed QlikView application on top of Oracle DB. 

•        Created and maintained OLE DB/ODBC connections for all environments. 

•        Developed hierarchical business model for company codes, account numbers, line of business, treaty/plan, customers and adjustment periods. 

•        Designed dashboards identifying the KPIs and to support the time comparison between budgets and actual. 

•        Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.

•        Improved

•        Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges. 

•        Maintained user guides and documentation for QlikView applications. 

•        Installation/Configuration of QlikView 11

Environment: QlikView 11/10, Oracle, SQL Server, SAP, Excel.