SUMMARY:

• Over 5 years of experience providing expertise in design, development and support with Qlikview application.
• Developed User Interactive Sheets & Reports as business needs.
• Knowledge on how to import data from different sources like SQL Server, Oracle, QVDs, and flat files using OLE DB/ODBC connection through Qlikview.
• Experience with Qlikview sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.
• Good Understanding of Relational and Dimensional Database Concepts.
• Optimizing existing Qlikview dashboards with a focus on usability, performance, long - term, flexibility and standardization. Extensive knowledge and experience in developing scripts using testing SQL queries and debugging.
• Involved in Requirement Gathering, Business Analysis, functional and Technical Documentation by interacting with Business users and Stakeholders.
• Experience in creating and using of variables, fields, and calculated expressions, aggregated functions, joins, concatenation and mappings using Qlikview.
• Extensively used various Qlikview Scripting and UI functions such as aggregations, sum, rank, range sum, firstsortedvalue, apply map, match, concatenate, no concatenate, numeric and date functions, etc.
• Experience in designing Qlikview Document/User Setting Layouts to make consistent and professional optimized look to clients .
• Team oriented individual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.

TECHNICAL SKILLS:

Languages: SQL, C, C++

Databases: MSSQL Server, MS Access, Oracle, Postgres SQL

BI Tools: Qlikview 11x/10/9x (Desktop Server Publisher, Access Point), QlikSense, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), Power BI, QlikSense and Visual Studio.

Design: SolidWorks, AutoCAD, CAM, Pro-E, Computer Aided Machine Drawing, GD&T

Computer Skills: MS Word, MS Excel, PowerPoint, Minitab, MS Project

PROFESSIONAL EXP ERIENCE:

Confidential, Detroit, MI

Sr. Qlikview Programmer Analyst

Responsibilities:

• Working on latest version of Qlikview Desktop.
• Involved in Qlikview BI/DW design, dashboard and KPI metrics design, data modeling and Qlikview scripts development and Qlikview Set Analysis.
• Worked with cross functional team and business user to develop Business requirement document (BRD), define key performance indicators (KPIs) and identify data sources.
• Code review of dashboard and performing the changes to improve the performance of the dashboard.
• Made use of extensive Qlikview scripting to implement incremental loads and QVDs.
• Worked with complicated expressions, aggregate functions to display the automotive data in a pivot table.
• Experience in Qlikview data models and load scripts
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• Assisted associate Qlikview developers, business analysts, targeted for a self-service BI system.
• Analyzed reporting requirements to usable long-term Dashboard and Reporting solutions, develop solutions as necessary.
• Designed and developed Qlikview software applications and server-based Qlikview dashboards from scratch to support BI initiatives.

Confidential, Detroit, MI

Sr. QlikviewProgrammer Analyst

Responsibilities:

• Working with the Mopar branch of Confidential .
• Involved in building two dashboardsnamely Quality and Operations for various teams in Mopar to help them analyze the information related to quality, finance, errors and damages pertaining to motor parts.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Actively participated in full life cycle of Qlikview application implementation and was responsible for Design, Development and Delivery.
• Implemented the 3-tier architecture, Data Extract, Data Transform and Data model & Application.
• Implemented the Incremental Load using QVDs to maximize the efficiency of the load.
• Extensively done business user support, resolved various issues for accessing dashboard and enhanced the dashboard as per user needs.
• Created a Master Calendar table to standardize throughout the dashboard.
• Implemented best practices for Qlikview Dashboard and QVD development, sizing and configuration
• 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.
• 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.
• Scheduled the Publisher Tasks Daily/ Weekly/ Monthly on various dashboards based on the database updates.
• Ability to multitask, self-motivating and accomplish tasks in time.
• Creative, quick learner and a team player
• Strong oral and communication skills.

Confidential, Long Beach, CA

Qlikview Developer

Responsibilities:

• Developed dashboards for clients to see all the information related to the trends of the make and model of the car, finances of the customers.
• Involved in Extracting, Transforming, and Loading data from different data sources like SQL Server, Flat Files, Excel Files.
• Followed step by step procedure of extracting, transforming and loading the data into the application.
• Designed and implemented the Incremental Load using QVDs wherever necessary to reduce load times and improve the speed.
• Experience in using ETL Tasks such as data cleaning, joins, keeps, concatenate, aggregation tables, Mappings using Qlikview.
• Implemented scheduling the tasks with the help of Qlikview Management Console.
• Involved in daily standup with business analysts and data architect to resolve the business issues and Data challenges.

Confidential, Duluth

Graduate Student Assistant

Responsibilities:

• Assisting faculty with departmental research and other projects as needed.
• Worked as a graduate teaching assistant and helped students in teaching and assisting in the lab work.
• Helped the professor in grading students’ papers and create assignments.

Confidential

Qlikview Developer

Responsibilities:

• Worked on the performance tuning of the applications to improve the performance and also optimize the data models.
• Worked mostly on the front end development of the application showing the sales and trends for the company.
• Used various graphs and tables to display the KPI’s.
• Made use of the best practices for a high performance data model by eliminating synthetic keys, circular loops and creating composite keys.
• Used different data sources such as excel files, text files, etc.