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

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.