SUMMARY

• 7 years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
• Was part of the QlikSense Extension development especially in communicating the UI and functionality requirements.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using QlikView. Good at working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Expertise in Installing and Configuring QlikSense, QlikView Desktop, QlikView Server and QlikView Publisher.
• Experience in server - sizing, clustering and load balancing to ensure scalable and robust BI implementations.
• Extensive experience with Data Analysis and evaluation of KPIs. Worked closely with business owners/stakeholders and provided recommendations on leveraging BI tools to make data-driven decisions.
• Establish standards for reporting, data modeling and visualizations.
• Provided recommendations to carry out performance tuning of applications to ensure optimal performance dashboards and applications.
• Experience in working through numerous cycles involving UAT and validation. Worked in close co-ordination with validation teams to design test cases. UAT cycles are designed to test applications for data, functionality and performance.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Interacted with Customers for requirement gathering and effective analysis.
• Supported all phases of a project life cycle including analysis, design, development, testing, deployment of solutions, and postproduction support/maintenance functions.
• An organized professional with excellent communication and interpersonal skills.
• Self-motivated and enjoy working in a technically challenging environment. Have excellent Communication and interpersonal skills.

TECHNICAL SKILLS

BI Tools: QlikView BI, QlikSense, OBIEE

Databases: MS SQL Server, Oracle, DB2, Teradata

Data Modeling Tools: Erwin, Visio 2000.

Operating Systems: Windows 95/98/2000/XP/NT, UNIX.

Languages: SQL, PL/SQL, C

PROFESSIONAL EXPERIENCE

Confidential - Englewood/CO

QlikSense BI Developer /Functional Analyst

Responsibilities:

• Designed, developed and implemented QlikSense/Qlikview dashboards for multiple internal business units.
• Extracted data from multiple data sources such as Teradata, Datalake, Excel etc.
• Collaborated with IT Project Managers and developed dashboards using Qlik Sense to showSales, Inventory as part of the OCS requirements.
• Supported internal employees of all levels by responding quickly to user needs and designing dashboards in a timely manner.
• Closely worked with the Sales team to understand their requirements and induct them into using dashboards.
• Was part of the QlikSense Extension development especially in communicating the UI and functionality requirements.
• Worked on implementing the metrics and developing the data models for RMA’s, DSO, Customer Scorecards, EDI 850, EDI 860 (Electronic Data Interchange - ANSI Standards)
• Worked on re-designing existing dashboards for the OCS Environment.
• Implemented best practices related to Qlik dashboards to reduce maintenance, overhead and complexity.
• Worked with application teams to identify potential improvements to data warehouse or enterprise application systems to better meet user analytical and reporting needs.

QlikView, QlikSense Administrator / Architect/ Developer

Confidential, Pleasanton, CA

Roles and Responsibilities:

• Deployed QlikView Enterprise Framework (QEF) for IT department.
• Used QlikSense to build applications and present front end visualization
• Recommended manager about supplanting QlikView with QlikSense as it has better front-end visualization and web integration.
• Recommended and helped to create Multi- Tier QVD architect depending upon Applications.
• Worked as a QlikView Administrator which include maintains the QMC, Configure tasks; manage the licenses, Implemented Security for applications (Included Section Access, Dynamic Data Reduction and Document level security).
• Installed, Migrated and clustered new Servers, Monitored Metadata for QlikView Servers and Publisher using QlikView Governance Dashboard.
• Recommended best Practices for Data Modeling, Design and Development of applications with more focus on QlikSense.
• Created aesthetically pleasing and informative dashboards.
• Worked with Supply chain, Supply Operation, Pharmacy and IT as Subject Matter Expert (SME)
• Helped the Business User for Navigation the QlikSense Reports and taught users and Developers.
• Currently, working with 24 Core and 96GB RAM server and few more are in procurement process.
• For initial user acceptance of the tool, there are 110 Named CALs 20 Doc CALs, 2 Session CALs.

Environment: QlikView 11.x, SQL Server, TeraData, NPrinting

Confidential, Allentown, PA

QlikView-Developer/ Admin

Responsibilities:

• Responsible for gathering Business Requirements and defining KPIs.
• Extracted data from the HR module of SAP using SAP connector.
• Developed dashboards depicting HR Data at Confidential . Dashboards are used by the Executive tier for critical decision making.
• Dealt with data size of 30 MB handling a volume of 1 million records in the fact table.
• Worked on QlikView Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications. Performed server sizing. Applications were refreshed on a monthly basis and used by a group of 60 users.
• Managed user access and security by implementing Section Access. Scheduled loads and distributions tasks using QlikView Publisher.
• Dashboards served to track KPIs such as Headcount, Vacancies, Turnover and Promotions within the organization. Trending and Point-in-time reporting techniques were used to monitor KPI s through the dashboard. Extensive use of Set Analysis and flags was made for reporting.
• By use of Star-Schema and adherence to best practices in QlikView, optimum performance of the dashboard was ensured.
• Calculation and defining server sizing for optimal performance of QlikView dashboards.

Environment: QlikView 11.x, SAP Connector, SAP HR Module.

Confidential

Data Modeling /QlikView-Developer/ Project Engineer

Responsibilities:

• Involved in development of existing legacy reports intoQlikViewapplication.
• Analyzed requirements, design functional and technical specs from documentation of QlikView application requirements from end users
• DevelopedQlikViewDashboardsusing Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island
• Configured and deployed the application onQlikViewserver and Imported data from different sources like Oracle, SQL Server, XML files, QVDs and flat files using OLE DB/ODBC.
• Designed data model inQlikView. Created multiple layer QVDs to get the desired data model
• Resolved synthetic keys.Used Mapping load,Apply Mapto get descriptions in fact table based on Id’s. Used resident load, preceding load, cross table and so on.
• Used variables to do calculations. Used variables in Set Analysis in expressions.Used Set modifiers. Used alternate state to do comparative analysis.
• Performed different tasks like extraction, reload tasks, reduction and distribution tasks based on Market drill-down using theQlikViewPublisher.

Environment: QlikView 10.x (Upgraded to version 11), Oracle, SQL Server2008, MS-excel, MS-Word.