SUMMARY:

• Over 8 yearsof IT experience with 4 plus years of experience in Designing and Development of Business intelligence application withQlikView 9.0/10.0/11.0 as BI tool.
• Extensive experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance different analytical applications using QlikView suite of Products (QlikView Server, Publisher andQlikView Enterprise).
• Experience in using NAS storage hosting QlikView applications managed filer security permissions.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Expertise in Creating Documents using QlikView 9.0/10.0/11.0 using different data sources like Oracle, SQL Server,QVD files, text files, excel and generated dashboard as per the user requirement.
• Experience with QlikView Sheet objects including various charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Strong Experience in Extract, Transform & loading data in QlikView Applications & Develop Data models using Star Schema & Snow Flake Schema’s.
• Performance tuning QlikView Applications for faster data reloads & efficient response times.
• Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
• Sound Skills in SQL. Validating data using SQL Scripts.
• Having knowledge on the SDLC methodologies like AGILE, Waterfall model.
• Involved in Performance Tuning & Deployment of QlikView Applications.
• Experienced in Training & Supporting end - user reporting needs using QlikView&Cognos products.
• Onsite-Offshore coordination in delivering Business Intelligence Solutions.
• Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts.:

TECHNICAL SKILLS

Business Intelligence Tools: QlikView/Qlik Sense, Tableau (Educational Knowledge) .

Database: Oracle 9i/10g/11g,SQL server 2008 & 2012, My SQL, Teradata, MS Access.

Web technologies: HTML, JavaScript.

Languages: C, C++, Java, Visual Basic,JSP.

MS office: Project management, Excel.

Web browser:Internet Explorer 6/7/8/9, Mozilla Firefox 3/3.5/3.6/4.0 , Google Chrome, Safari.

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

Sr. QlikView Developer

Responsibilities:

• Understanding the requirements from the business users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards. 
• Developed QlikView Dashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, Container etc...
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Design, Develop, Test, debug and implement QlikView solutions based upon specified requirement. 
• Re-use the existing QVDs, new tables as QVDs and scripts to generate appropriate fields that help in modeling the data according to the requirements. 
• Gathering data sources like QVD files, Excel, Oracle DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed data models based on the client requirements and without any ambiguous or Synthetic tables. 
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc ) 
• Extract, transform and load data from multiple sources into QlikView applications.
• Developed SET ANALYSIS to provide custom functionality in QlikView Applications. 
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Design, Build, Test, Debug the QlikView application in QV Test server environment.
• Creating QlikView Applications using qvd files from user analytical/Business purpose. 
• Served as QlikView application developer for various ad-hoc analysis requests. 
• Provided ongoing maintenance and support to existing QlikView documents. 

ENVIRONMENT: QlikView11.2, QlikView Server/Publisher, Oracle 10, Business Objects, MS-excel, Windows Server 2008.

Confidential, Long Island, NY

QlikView Developer

Responsibilities:

• Created POC’s to demonstrate the scope of the project to the business users.
• Extracting normalized data set from various database sources and build a data model with Master Calendar to connect the various fact tables with master tables
• Used QlikView sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting
• QlikView best practices were used in scripting, set analysis and usage of variables.
• Designed/Implemented Star Schema while loading data from multiple data sources.
• Implemented data level Security using Section Access that hides selected areas of the dashboard and reduces data dynamically depending on user entitlements/privileges.
• Created QVD's & updated on timely basis as database updates.
• Made sure that no synthetic keys or circular loops are getting formed in the data model.
• Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.
• Monitoring of the QVS, QVW's and user accounts for the usage of applications and user access to manage the limited number of licenses.
• Deploying the QlikView reports onto the QlikView servers.
• Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

ENVIRONMENT: QlikView 11.2 SR6, Oracle 11g, DB2, MS SQL Server 2008, Toad, Informatica 9.0., Windows 2008 R2, Excel, MS Access, Flat files.

Confidential, Raleigh, NC

QlikView Developer

Responsibilities:

• Extracted the data from various databases such as Oracle, MS SQL Server, web files and MS Excel to create and schedule different complex reports as per given business requirement.
• Involved in User requirements, Documentation and Dashboard Prototypes.
• Developed various internal prototypes for acceptance testing.
• Implemented and configured QlikView 9.0.
• Validation of Qlikview application at base level against QVD’s and Excel test files.
• Eliminated synthetic keys using QVD concatenation
• Developed data model to reflect a Start model after translating various sources into Dimension and Facts.
• Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies
• Created batch scripts to process the data periodically as per the business requirements
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy
• Create and manage ETL script generation using QlikView Script.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.

ENVIRONMENT: QlikView 10.0/11, Windows 2003 Server/XP, MS Access, Oracle 10g, MS Access 2007, MS Excel 2007.

Confidential, Raleigh, NC

SQLDeveloper

Responsibilities:

• Effectively participated in requirement gathering, architecture design, Data Modelling, ETL process and development of user interface objects in QlikView applications.
• Performance tuning of the reports in order to reduce the execution time to generate the reports and thereby improving the overall speed of execution and performance of the reports.
• Developed various internal prototypes for acceptance testing
• Worked with data warehousing team to create standard rules and procedures for data validation which reduces QlikView application development time.
• Migration from QlikView 10 to QlikView 11.
• Worked with ETL team to build mappings that were used in the Informatica tool to transform the data from the source systems to the target system
• Analyzed and developed best practices for data management and Extract, Transform, Load (ETL) processes from multiple data sources.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView server.
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Written complex expressions using Set analysis and various QlikView functions.
• Worked on data modeling and developed different complex models as per given user requirement by eliminating circular loops, Synthetic tables and ambiguous relationships.
• 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.
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using QlikView Enterprise Management Console.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Created Dashboard using different components of QlikView like listboxes, multiboxes, slider, buttons, and charts.
• Handled the end-to-end implementation of QlikView dashboard deployment.
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Defined standard themes and color coding schemes to improve the look and feel of applications.

ENVIRONMENT: QlikView 11.x, Cloudera HIVE/Impala, Oracle 9i/10G/11G, SAP BW/ECC, Windows XP/2003 server, HTML and Java Script.

Confidential

SQLDeveloper

Responsibilities:

• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Provide database coding to support business applications using Sybase T-SQL.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Writing validation packages using PL/SQL package.
• Developed Installation scripts for  all the deliverables.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Confidential

SQL Developer

Responsibilities:

• Designed, implemented and administrated SQL Server 2000 databases.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures

ENVIRONMENT:SQL Server 2000, SQL Profiler, Data Transformation Services, and T-SQL.