SUMMARY

• Over (7+) SEVEN PLUS Years of IT experience in all aspects of Business Intelligence applications with a strong knowledge in database development, Data Warehousing, and Business Intelligence
• Broad knowledge of software development, Business Analysis and Business Intelligence for collaboration with various teams to affect a seamless transition of knowledge and requirements in a SDLC Process.
• Proven capabilities with the development and design of QlikView applications
• Experience with Qlikview and Qlik Sense and with exposure to QlikSense 1.0 and 2.0.
• Proficiency in QlikView Server and Publisher maintenance
• Created and organized jobs for QVD extracts and report reload in QEMC.
• Proficient in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Capable of effectively working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Skilled in handling and analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Experience with Qlikview and Qlik Sense sheet objects, including multiple chart types, trends, KPIs, custom requests for Excel exports and fast change, objects for management dashboard reporting, with creating Proof of Concepts (POCs), and with training the business users on how to interpret the data in Qlikview and Qlik Sense.
• Worked in close association with customers for gathering requirements and effectively analyzing them.
• Proven capability in designing and creating database objects such as Tables, Views, Indexes, stored procedures, functions, triggers in SQL Server based on logical design model and business requirements.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Familiarity in performance tuning, logging, error handling of SSIS packages and deploying from development server to production server.
• Expert in generating reports using SSRS from relational databases as well as OLAP cubes.
• Thorough understanding of industry best practices in both business management and technological domains.
• Expert in analysis, design, development, customization, implementation and testing of software applications and products.
• Exceptional analytical, inter - personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS

BI Tools: QlikView 10/11, SSRS, Informatica

Databases: MS SQL Server, Oracle9i/10g/11g

Web Technologies: HTML, Java Script, VB Script, Servlets.

Data Modeling Tools: Erwin, MS Visio 2000.

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

Languages: SQL, PL/SQL, VB Script, Shell Scripting.

Other Tools: MS Access, MS-Excel, MS Visio, Power Point & Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr. Qlikview Developer/ Business Intelligence Analyst

Responsibilities:

• Extract a heavily normalized data set and build a data model with Link Table and Master Calendar to connect the various fact tables with the master tables.
• Data Validation and analysis based on the data pulled into QlikView.
• Application is built based on guidelines set in prototype proof of concept.
• Developed dashboard tab with overall details of health care products (growth, baseline, etc.) and additional tabs for information on performance details, summary, budgets, call activity and call & change details.
• Implemented conditional expressions and dimensions for some charts to show different metrics in the same chart based on selections by users.
• Involved in creating publisher tasks for data extraction, reload and loop & reduce based on territorial hierarchy.
• Improved the overall performance of the application by redesigning the data model applying some best practices and performance tuning techniques.
• A powerful custom, conditional report and comparative analysis sheet were built to enable users to perform further analysis. This feature is newly available in QV 11.
• Involved in Technical Documentation detailing the use of data model on backend and different charts and variables on front end.
• Creating support transition documents with details of all publisher jobs and the order in which they need to be run.
• Impact and solutions document with details of probable problems that may arise and the solution to fix the issue.

Environment: QlikView 11, SQL Database, Windows Server 2003, oracle 10g

Confidential, Dover, New Hampshire

Sr. Qlikview Developer

Responsibilities:

• Gathered Requirements by communicating with lab technicians and hospital Management.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Conducted Feasibility Analysis with the technical support team for the migration of legacy database to MySQL database to implement web-based solution.
• Design report layout and implement QlikView dash boards using various sheet objects like charts, table box, list box, multi box, buttons etc., to get front end professional look which are used for sales, finance, traffic analysis teams.
• Used Oracle/SQL Server as backend and also QlikView script for ETL Operations for extracting, transforming & loading data into QV applications or into QVD files to speed up the loading process into QV application.
• Manage/Schedule QlikView applications using QlikView Management Console (QMC)/ QlikView Enterprise Management Console (QEMC).
• Deploy & Maintain QlikView Applications into the development, UAT, and Production environments.
• Configured QlikView Server /Publisher. Scheduled jobs, & security.
• Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements.
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• Created chartsas per the customer requirements on Quarterly, Monthly and Yearly for report analysis.
• Involved in Production support and maintenance.
• Provided user training to get familiarity on using QlikView Applications
• Experience in using triggers and actions to provide certain functionalities.

Environment: QlikView 10(SR4)/11, QlikView Server and publisher, Oracle 11g, SQL Server