SUMMARY

• 8+ years of IT experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment.
• 5+ years of experience in designing, implementing, customizing and maintaining QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise) with comprehensive experience in planning, designing and building BI Dashboard and Analytics Reporting solutions.
• Good Knowledge and experience of 2+ years in Creating Dashboards in Qlik Sense.
• Expertise in designing and creating various analytical reports and Dashboards to identify critical KPIs and facilitate strategic planning in the organization using QlikView.
• Experience in Dimensional data modeling, snow flake schema, star schema, Fact and dimensional tables.
• Expertise in Creating Dashboards using QlikView 12/11.2/11.0/10 using different data sources like Oracle, SQL Server, Teradata, Salesforce, QVD files, text files, XML, excel and generated dashboards as per the user requirements.
• Experience in developing User Interfaces and QlikView Dashboards using Chart - Box (Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars and Date Islands.
• Experience with QlikView sheet objects List, Multiple chart types, Pivot, and Multi box.
• Custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Experience in developing and maintaining QlikView QVDs and QVWs and generating automated reports from QlikView application (QVW).
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys and Modeling Issues.
• Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications.
• Performed different types of loads Binary Load, Incremental Load, Optimized Load.
• Excellent skills in Triggers to achieve event based requirements.
• Expertise in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.
• Experience in installing and configuring QlikView Desktop, QlikView Server, QlikView publisher, QlikView document Security with section access.
• Experience in customizing Dashboards/Reports using Java, JavaScript, jQuery APIs, Web Services and third-party plugins.
• Used CSS files, XML, JavaScript in QlikView/Qlik Sense object extensions.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance prior to making delivery to end users.
• Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Extensively involved in Reverse-Engineering and Business rules extraction expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Trained several developers on QlikView in terms of best development and design practices and general “how to” procedures.
• A motivated team member, with the ability to multitask and acquire efficient time management skills working with on-site and off-shore teams.

TECHNICAL SKILLS

BI Tools: QlikView (12/11.2/10), Tableau, SSRS

Data Integration Tools: Informatica, SSIS

SQL Tools: Teradata SQL Assistant, Toad, PL/SQL Developer, Rapid SQL

RDBMS: Teradata, Salesforce, Oracle, SQL Server, DB2, MySQL, Access

Documenting and Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, MS Project, MS Office (Word/ Excel/ Access/ Power Point), SharePoint, Documentum.

Scheduling Tools: AutoSys, Control M

Defect Management Tools: Mercury Test Director, HP Quality Center

Change Management Tools: HP Service Manager, CA Service Desk Manager, Lotus Notes

Scripting/Lang.: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Operating Systems: Windows 2008/2012 Server, Unix, Linux

EDUCATION: Bachelor's in Information Technology JNTU - India - 2008.

PROFESSIONAL EXPERIENCE

Confidential - South SFO, CA

Sr. QlikView/Qlik Sense Developer

Responsibilities:

• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Developed applications in Sense Desktop as well as in the Qlik Sense Hub and shared the apps with the team through Qlik Sense Cloud.
• Developed and designed the dashboards with different types of charts in Qlik Sense Designed visualizations like pie chart and bar chart.
• Application was built based on guidelines set in prototype proof of concept.
• Created charts as per the customer requirements on Quarterly, Monthly and Yearly for report analysis.
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• Deploy & Maintain QlikView Applications into the development, UAT, and Production environments.
• Deployed the QlikView applications in the server. Created Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.
• Performed Unit and Integration Testing and validates results with Business Analyst and end users.
• Documented each stage of the project and attended status meeting every week.
• Involved in converting the existing QlikView application to Qlik Sense and prepared dashboards using Qlik Sense extension objects.
• Qlik Sense App development, templates, themes, master library items and story generation.
• Developed complex SET ANALYSIS to provide custom functionality in Qlik Sense Applications.
• Sound ability to interact with end users and craft clear technical requirements from business language.
• Prepared Qlik Sense proof of concepts as per the requirements and specifications.

Environment: QlikView (12/11), Qlik Sense 3.0, NPrinting, SQL Server, Oracle 11g, MS- Access, Excel, SharePoint, QMC, Power Designer, JavaScript, Windows Server.

Confidential, Belmont, CA

Data Analyst/Sr. QlikView/Qlik Sense Developer

Responsibilities:

• Creating/designing QlikView Dashboard. Used Section access and Sheet access to make the application available to desired users.
• Developing and maintaining high level overview of the data flows using MS Visio.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Analyzed the existing Qlik Sense QlikView data model, script logics and the ETL business logic for the existing QlikView applications and optimizing them.
• Worked on Qlik Sense App development, templates, story generation, data modeling and Qlik Sense app performance optimization.
• Designed and developed the Data mart for the QlikView dashboards in star schema/snow-flake schema. Identified various sources and designed the data transfer and transformations with in QlikView.
• Created Multiple Templates for different reports with different Filters and scheduled them daily in NPrinting.
• Used SQL Stored Procedures and Views to fetch the data from database to build reports in Qlik view and Qlik sense.
• Designed and Developed Qlik Sense dashboards using Chart Box (Drill Down, drill up & Cyclic Grouping), List, Input Field, Table Boxand extensions using JavaScript.
• Experience in using ETL Tasks such as data cleaning, joins, keeps, concatenate, aggregation tables, Mappings using QlikView/Qlik Sense.
• Handled the end-to-end implementation of QlikView /Qlik Sense dashboard deployment.
• Implemented security through database shell scripting as well as QMC/AP in order to restrict data as per users/group privileges.
• Worked on Qlik Sense files/ dashboards along with understanding the basic differences between QlikView and Qlik Sense.
• Created Variables and to enhance the functionality of QlikView/Qlik Sense.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Environment: QlikView (12/11), Qlik Sense 2.2, NPrinting, SQL Server, Oracle 11g, MS- Access, Excel, SharePoint, QMC, Power Designer, JavaScript, Windows Server.

Confidential, San Diego, CA

Data Analyst/QlikView/Qlik Sense Developer

Responsibilities:

• Strong understanding in creating Dashboards for the required KPI’s in QlikView/Qlik Sense.
• Created various Flags based on user’s requirements.
• Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access) using QlikView/Qlik Sense.
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Trained End Users on Using QlikView Tools.
• Designed application for Sales Marketing Modules that Generates GUI Report for easy access through the data.
• Created dashboard style of layouts using different components of QlikView Enterprise such as List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Managed schedules and reloading of QlikView /Qlik Sense data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Experience in Navision is an ERP (Enterprise Resource Planning) Solution designed for small to mid-sized businesses to automate the majority of their transactions from CRM.
• Involved in Script development, script functions, script variables, inline load, QVWs, QVDs, set analysis and section access.

Environment: QlikView 11, Qlik Sense, Oracle 11g, SQL Server, JIRA, Toad, ERwin, MS Project, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Atlanta, GA

Data Analyst/QlikView Developer

Responsibilities:

• Extracted the data from various data sources such as databases, Excel documents and CSV files, transforming the data into standard format and load the data so that it is available for analyzing and creating reports.
• Excellent technical, analytical, and problem-solving skills. Strict attention to detail and ability to work independently as well as within a team environment.
• Worked closely with Business to design, develop and enhance the Hyperion Reports.
• Strong understanding in creating Dashboards for the required KPI’s in QlikView.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.
• Application processed tables with over 20 million records.
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Created Dashboards style of reports using QlikView /Qlik Sense components like List Box, Slider, Buttons, Charts and Bookmarks.
• Involved in performance tuning of dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW
• Created batch scripts to process the data periodically as per the business requirements.
• Performed visualizations with self-service capabilities, where end users can create reports and dashboards by themselves
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Experience in scripting QlikView Set Analysis.
• Performed NPrinting reports in a number of formats, including Word, Excel, PDF, JPG
• Created User Interface and prepared layouts for the system by using QlikView.
• Participated in the developing/enhancement of star schema dimensional data model.
• Used MS Access and QlikView extensively as reporting tools and to create user build specification.
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Worked on the UI for various applications.

Environment: QlikView 10, Oracle 10g, MS Access, SQL Server, CSV files, QlikView Server and Publisher, Teradata, Power BI, AutoSys.

Confidential, Racine, Wisconsin

Data Analyst/QlikView Developer

Responsibilities:

• Design the data model, constructed data model, implementation of Star schema for QV better optimization.
• Created dashboards by extracting data from multiple databases, sorting into QVD files and writing load scripts.
• Created Dashboards using chart boards such as Pie chart, Chart, Bar, Pivot table and Straight table.
• Experience in creating variables to develop the functionality of QlikView.
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the QlikView publisher
• Designed and Developed QlikView dashboards using Chart Box (Drill Down, Drill up and Cyclic Grouping), List, Input Field, Table Box, and Calendar meeting the business requirements.
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys
• Executed Simple and Complex SQL Queries like Joins, Select, and Update for data validation and data manipulation
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Created QVDs by importing data from the database tables using QlikView load script.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping,
• String & input Fields etc.).
• Implemented security using QlikView’s section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Experience in performance tuning of dashboards to improve the response time for the users to access the documents by reducing the size of QVW.

Environment: QlikView 10, Oracle, SQL Server, Teradata, SQL Assistant, Excel, QMC, MS Office, SSRS, Oracle, SharePoint.

Confidential

SQL Developer

Responsibilities:

• Developed SQL queries to fetch data as per the business requirements with proper tuning techniques.
• Wrote necessary PL/SQL API scripts for successful running of the programs.
• Interacted with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Created required technical documents, technical specifications, and Test results.
• Created checks and constraints to maintain data integrity across the data in the database.
• Involved in creating tables, views, stored procedures, triggers, and cursors and other SQL joins and statements for applications.
• Responsible for Data Extraction, Transformation, and Loading the data into database tables using PL/SQL.
• Involved in unit testing, system integration testing and user acceptance testing.
• Involved in DBA concepts like creating tables, table space, Grants to users while working.
• Responsible for decreasing Load times of Data Warehouse by optimizing ETL procedures using PL/SQL and Business Objects Data Integrator.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Involved in the changing existing SQL Queries according to the new requirement.
• Involved in the team for documenting Functional and technical specifications, including specifications for others to build.

Environment: Oracle 10g, SQL, PL/SQL, SQL Navigator, PL/SQL Developer, Windows 2007, MS- Excel 2013.