SUMMARY:

• QlikView consultant with over seven years of experience in all stages of systems development life cycle including business requirements gathering, design, data conversions, programming, system / integration / user acceptance testing, documentation.
• 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
• 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.
• Good understanding of CSS, AJAX, and web based integration of QlikView.
• Skilled in handling and analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• 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.
• Experience in extracting data from SAP BW using SAP reload DD, SAP Script builds QVW's.
• Familiarity in performance tuning, logging, error handling of SSIS packages and deploying from development server to production server.
• Well versed with Web Analytics tools such as Omniture and Piwik
• 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,QlikSense, SSRS, Informatica, Hyperion Reporting, Tableau and analysis 9.x/11.x.

Databases: Oracle9i/10g/11g, DB2, SQL Server 2005/2000, Sybase and MS Access.

Tools: Toad, SQL developer, Hadoop, SAP BW, Omniture and Piwik.

Additional Skills: Data Analysis.

Data Modeling: Erwin, MS Visio 2000.

Languages: C, C++, java, Java Scripts, SQL, PL/SQL, UNIX, HTML, VB Script, Shell Scripting.

ETL Informatica:, IBM Infosphere Datastage.

Operating Systems: Windows XP/ 2002/2003/2008, Windows 7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Smithfield, RI

Sr. QlikView Developer/Qlik Sense consultant

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.
• Design and develop QlikView/Qlik Sense security, account reports.
• Assist with QlikView/QlikSense Server integration issues.
• Data Validation and analysis based on the data pulled into QlikView.
• Application was 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 Setup and configuration of QlikSense server in cloud
• 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.
• Experience in extracting data from SAP BW using SAP reload DD, SAP Script builds QVW's.
• Involved in integrates disparate data sources including SAP ECC using SAP Connectors.
• Deployed applications on production server and setup automated data reloads
• Identify customer needs and work collaboratively to determine business requirements.
• 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.
• Expertise in QlikView Management Console.

Environment: QlikView 11.x/10.x, Oracle 11g, MS Office, QlikSense, SAP DW, Hadoop, Windows 2008 R2 Server, Toad, agile environment, Informatica Power.

Sr. QlikView Developer/ Business Intelligence Analyst

Responsibilities:

• Implementing Business Intelligence Solutions by Creating and Developing of QlikView dashboards, analysis and design with extensive usage of QlikView 10 Version, using various databases like SQL Server, Teradata, Excel, CSV files. Documenting event triggering and field event triggering. Incremental reloading is implemented to meet all the Client related aspects along with optimizing the data models meeting the enterprise business standards along with Data Integrity
• 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 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).
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.
• Involved in Creating SOAP Webservices in Salesforce to Consume WSDL Files in Qlick View to Generate Reports
• 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.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• Created charts as 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, Teradata, QlikSense, nPrinting, QlikMaps, Tableau 8.x, SQL Server 2008 R2, MS Access, SAP BW, MS Excel, Flat Files, Windows Server 2008, .CSV Files, agile environment.

Qlikview Developer

Responsibilities:

• Verizon Business is a leading provider of global IT, security, and communication solutions, with one of the world's most connected IP networks. It combines broad range of strategic solutions, services, and expertise to help some of the world's largest organizations and governments - meet the challenges of their increasingly extended enterprises.
• Responsibilities:
• Actively participated with business users and functional team to understand the reporting requirements and worked on all phases of the project.
• Supported in modifying, testing and implementation of existing reports.
• Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Developed scripts for data reloading, mapping and transformation by using joins, concatenations, resident loads and temporary tables.
• Performed redesign of the existing QlikView BI associative model to improve availability, scalability and performance by eliminating synthetic keys and circular loops in the data model.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Implemented multiple levels of hierarchies such as sales, product, partner, customers and service hierarchy etc.
• Worked with various Sheet Objects, Charts (including Drill Down and Cyclic field grouping), Table box, Lists, Input box, Master Calendar.
• Implemented Incremental load for the update of QVD’s.
• Implemented section access, section authorization and sheet access to make the application available to desired users.
• Was actively involved in server migration and the fresh QlikView installation process.
• Used booking, revenue applications, created 4-year forecast model, and successfully implemented in QlikView.
• Considered best practices of QlikView and created heat map and KPI graphs.
• Creating section access code and binary loads for un-compromised security and quick reloading of applications.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.

Environment: QlikView 9.0/10.2, Oracle 10G/11G, SQL Server 2008, CSV Files, Windows 2008 Server.

SQL Server Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Using Oracle Developer Database tools to write triggers and procedures, Function.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF,
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure)

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, ETL.

PL/SQL Developer

Responsibilities:

• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Creating and Debugging of Packages and Procedures & Functions and troubleshoot jobs using the debugging tool.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Involved in Analysis, Coding, Testing and Implementation of various modules and reverse engineering of the application using Erwin. Used Erwin to transform data requirements into data models.
• Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data by using SQL* Loader to custom tables.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• Used Oracle Enterprise Manager, TOAD for developing and managing pl/sql scripts.

Environment: Oracle 11g, Pl/Sql, SQL *Plus, TOAD, Oracle Forms 6i, Oracle Reports 6i, Ms Excel, SQL*Navigator, Power Builder, shell scripting.