SUMMARY

• Over 8 years of total IT experience in software analysis, design and development for various software applications in client - server environment with expertise in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems.
• Around 5+ years of experience in working with QlikView Desktop, QlikView Enterprise Management Console (QEMC) and QlikView Publisher.
• Developed Complex Graphical User Interactive reports using various QlikView Objects.
• Extensive experience in developing different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).
• Expertise in Creating Dashboards using QlikView 11.0 using different data sources like DB2,Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Experience in advanced loading concepts like ‘Incremental Reload’, ’Partial Reload’ and ‘Binary Reload’.
• Senior QlikView BI with comprehensive experience in planning, designing and building BI Dashboard and Analytics Reporting solutions, utilizing BI tools (QlikView, BO, SSIS/SSRS), Databases (Oracle, DB2, Microsoft SQL,IBM Netezza), data analytics and dashboard visualization skills, supporting evidence-based business decision making.
• Having knowledge on Qlik Sense
• By Using Quik Sense Creating expressions to calculate fields and also some useful expressions to know when loading data into your app.
• Having Knowledge on Equipment Leasing.
• QlikView Expert in full development Lifecycle reloads automation and management.
• QlikView scripting language, Macro, VBScript, JavaScript, AJAX, PDF reporting, QlikView Enterprise Server and Publisher, QlikView Developer, Section Access and Security/Entitlement model, QlikView scripting language, Macro, VBScript, JavaScript, AJAX, PDF reporting, QlikView Enterprise Server and Publisher, QlikView Developer, Section Access and Security/Entitlement model.
• Strong experience in Qlikview Product family such as Qlikview Desktop Client, Qlikview Management Console, Qlikview Server.
• Experience with Qlikview sheet objects Pivot, List, Multi box, multiple charts types, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Experience with Oracle Application Modules - Account Payables, Order Management, Purchase Order, Account Receivables, General Ledger.
• Sound skills in writing SQL Scripts and Pl/SQL Stored Procedures.
• Strong Database Development skills using SQL Server, DB2, Oracle and Teradata.
• Strong Skills in Providing Custom functionality using Macros and Triggers.
• Over 3+ years of experience in designing, developing and deploying of QlikView Applications.
• Strong Database development experience in writing functions, packages, procedures, triggers and views in PL/SQL.
• Expertise in Teradata, Oracle, SQL Server, Netezza, SSIS, SSRS, UNIX, Toad.
• Expertise in QlikView 11.0 SR1/10.0 SR3 installation and upgrading existing version.
• Expertise in designing in Qlikview with complex multiples data sources (SQL, Oracle, Flat Files) relational designs and optimizing applications by using QVD’s, removing non key fields and script variables (Loading phase).
• 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.
• Experience in creating ETL Applications for QVD’s and Qlikview Scripting variables and File, Date, System, Mapping, and Table functions.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

TECHNICAL SKILLS

Qlikview Tools: Qlikview Developer 11, Macros, Set Analysis, QVDs.

Reporting Tools: Qlikview 11.0/11.2/10.0/9.0 , Information Broadcasting, Cognos, Crystal Reports.

Testing Tools: Mercury Tools, EFDE, CCT, TM.

Databases: SQL Server 2008/2005/2000/7.0/6.5 , Oracle 11g/10g/9i/8i, Teradata, MS Access, DB2, Netezza and MS-SQL Server, .

Operating Systems: Windows XP/2000/ NT/7, Windows 2003 Server, UNIX (HP, LINUX)

Languages: SQL, PL/SQL, VB Script, C, Java Script, HTML, CSS, XML.

Desktop: Excel, Word, Visio, Publisher, Lotus Notes, Outlook, SharePoint, Info path.

PROFESSIONAL EXPERIENCE

Confidential - Richmond, VA

Sr. Qlikview Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Participated in Business Processes with the Business Analyst to understand the requirement and reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager.
• Hands-on experience in the design, development of end user applications for the data presentation and analytics, including dashboards, reports, monitors, and graphic presentation (Information Visualization & Analysis) using QlikView 11 BI platform.
• Involved in the daily standup with business analysts and data architect to resolve the business issues and Data challenges. Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.
• Extracted information from different data sources like Teradata, SQL Server, MS Access and flat files by using different scripts like add, concatenate, resident, qualify, unqualified etc..
• Wrote SQL queries and created ad hoc queries to perform data validation and analysis.
• Created QVD files to hold data from data sources and updated the QVD files on timely basis as the source database updates.
• Developed various QlikView Data Models by extracting and using the data from various sources like QVD files, MS SQL DB, Excel, and Flat Files.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Used QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields, etc.) for creating dashboards, and designing the User Interface based on business/user requirements.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island. Also, installed and deployed them according to UI design.
• Adept in creating various QlikView reports and publishing them as per clients request.
• Used Section access and Sheet access to make the application available to desired users.
• Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, currency selection box, buttons, charts, text objects, bookmarks, etc.
• Customized and tweaked the scripts and necessary data transformation, created simple and complex expressions (using Set Analysis).

Environment: QlikView 11.x, Oracle 11g, TOAD, Netezza, SQL Server, Teradata, Tortoise SVN and UNIX.

Confidential - San Francisco, CA

Qlikview Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.
• Worked with the team to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
• Performed redesign of QlikView BI platform to improve availability, scalability and performance to accommodate high volume of data with 60+ dashboards
• Participated on business requirement document preparation.
• Rebuild dashboard applications on both frontend UI and backend, developing scripting templates, UI design and coding standards, design guidelines, migration strategy and implementation plan.
• Developed different dashboard with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. Monitor user access to manage the limited number of licenses.
• Optimizing 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.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Participated in Scrum stand up meetings.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Designed and created the dashboard reports for Executive board of company.
• Developed scripts for data reloading, mapping and transformation
• Conducted UI visualization improvement on Usability and User Experience (UX)
• Designed the integration of Enterprise Management Reporting Portal to provide single point of entry, developing Drill-to-Detail (D2D) for deep linking and cross-system Interoperability
• Modified existing reports using QlikView.
• Maintained and updated the dashboard reports as required by client.
• Analyzed the external and regulatory reporting, intercompany and internal management reporting needs of the business process.
• Installed, configured and deployed QlikView application on top of Oracle DB.
• Conducted and guided QlikView BI application global roll out, managed QA Testing, User Acceptance Testing, software update, migration deployment and parallel run, stabilizing the server platform and application to achieve the steady state for transitioning.
• Developed hierarchical business model for company codes, account numbers, line of business, treaty/plan, customers and adjustment periods.
• Designed dashboards identifying the KPIs and to support the time comparison between budgets and actual.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Maintained user guides and documentation for QlikView applications.

Environment: Qlikview 10/11, Oracle, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Cognos, QlikView Enterprise Server, JavaScript, Java, ASP.NET.

Confidential - NYC, NY

Qlikview Developer

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule ad hoc reports by leveraging the basic components of Qlikview.
• Actively participated in the design, architecture and development of user interface objects in QlikView applications.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Developed KPI’s and set analysis applications.
• Developed Qlikview data warehouse enterprise framework.
• Developed a Qlikview AdventureWorks Enterprise Template.
• Developed Qlikview documents and frameworks for Financial, ERP, CMMS, point-of-sale and medical industries.
• Used Qlikview components such asd List Box, Slider, Buttons, Charts and Bookmarks to create Dashboards.
• Generated new QVD files created by ETL logic to feed Qlikview applications.
• Consulted with project/program stakeholders to understand business problems and translates them into functional and non-functional requirements
• Created dashboards with complex sheets which include List boxes, Statistic boxes, containers, different charts (bar charts, scatter charts, Heat charts, and Block charts and pie charts) to show the statistics of the sales held on different products in different years.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Dynamically creating the WHATIF analysis reports by modifying the input data though slider object and input boxes
• Performed ad hoc duties in accordance to business needs.
• Improved the overall performance of the application and redesigned data model applying Qlikview performance tuning techniques.
• Dashboards served to track inventory and sales as well as to monitor various KPIs.

Environment: Windows 2000 Server, Qlikview 9.0, Oracle 10g, SQL Server 2005, MS Office.

Confidential

Data Analyst

Responsibilities:

• Reading raw data, Validating, Manipulating from Flat Files and Creating Tables in Oracle Database Analytical Environment.
• Creating Monthly Business Reports by writing Oracle SQL.
• Documentation the Process and Steps for creating reports.
• Developed data maps for retrieval of information from existing account systems.
• Outlined security measures for accessibility and transmission of information.
• Wrote SQL queries to verify the system functionality and provided the users with the needed data and information during operational phase.
• Worked on creating shell scripts efficiently.
• Physical database design and tuning.
• Adhoc reporting.
• Developed and implemented new ways for determining which diagnoses were pre-existing conditions and the environmental factors affecting individuals participating in the program.
• Created and maintained data management and statistical report programs.
• Created data sets from raw data sets for the analysis of safety and efficacy data using SAS to access remote clients.
• Generated interpretive summaries, charts, tables and listing reports in accordance with regulations.
• Drew conclusions based on analysis. Prepared manuscripts upon study completion, as well as various management reports.
• Worked extensively with business users on requirements gathering, analysis and documentation.
• Interacted with clients, modelers and analysts to define targeted populations and control groups.

Environment: Oracle 8i, Word, Excel, Power Point, UNIX, Mainframes, Windows NT.

Confidential

Data Analyst

Responsibilities:

• Worked directly with end users to gather Business requirements,
• Design and develop a front application in VB 5.0.
• Designed and developed Search and View screens and did field level validations for all the fields used in the application using VB6.0.
• Perform data manipulations and scrubbing. Unix, BTEQ and KSH scripting
• Designed the database in MS Access (Creation of Database, tables, views and Procedures).
• Performed validation testing and UAT to produce clean and consolidated results.
• Manipulated and updated the tables as per specifications and extensively used stored procedures.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
• Came up with methods to improve functionality and effectiveness of the code by brainstorming with other team members during team meetings and discussions.
• Assisted the DBA with scheduling jobs, running various scripts related to space management
• Assisted in documenting User Manual and facilitate UAT and provide follow up to resolve the issues
• Automating reports using MS Excel with ODBC Connection.
• Scheduling SQL Job to run at night times.
• Designed and developed a metadata driven automated reporting system

Environment: Visual Basics 6.0 MS Access, Word, Excel, Windows