SUMMARY

• 7+ years of progressive experience in IT with Analytics, Data warehousing/Decision Support Systems, Reporting, and Dash - boarding for enterprise wide BI, including experience as a QlikView developer.
• Expertise in designing and development of Business intellengence & Analytics Solutions with Qlikview 11.x/10.x.
• Strong experience on data visualizaiton with QlikView Desktop Client.
• Experience in complete Business Intelligence (BI) life-cycle projects from requirement gathering, documentation, data analysis, modelling, development, testing, deployment and support.
• Expertise in Data Integration from disparate data sources like Oracle, SQL Server, QVD files, text files, excel documents and developing BI and Analytics solutions.
• Experience in QlikView Scripting and hands on experience with QVDs, Calendar Object, custom scripting to implement SQL functionality
• Experience in Extraction, Transformation and Loading data in QlikView Applications and develop data models using Star Schema and Snow Flake Schemas.
• Experience in QlikView projects deployment and automating reload tasks on the QlikView server.
• Experience in writing complex Procedures or functions using advanced PL/SQL concepts.
• Experience in implementing various performance techniques to improve database and reports performance.
• Good understanding of ETL methodologies, Business Intelligence and Data warehousing principles.
• Strong analytical, communication, presentation and problem solving skills with ability to work individually or as a part of a team.

TECHNICAL SKILLS

BI Analysis/Reporting Tools: QlikView 9/10/11/12 (Developer, Publisher, Server)

Tools: Rational Clear Quest, Rational Rose, Rational Clear Case, Rational Requisite Pro

Applications: MS Word, MS Power Point, MS Excel, MS Visio

Databases: SQL Server 2000/2005, MY SQL, Oracle 9i, Teradata, DB2, MS-Access

Web Programing: HTML, XML

Testing Tools: HP Quality Centre 10 and 11.0

Operating Systems: Linux, Macintosh, Windows NT/XP/7/8/10

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. QlikView Developer

Responsibilities:

• Connected to different various data sources like Oracle, and flat files to create and schedule different complex reports.
• Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calender & Date Island
• Analyse existing data models and data marts to meet the needs of reports and dashboards.
• Developed ETL scripts to source data from various data marts such as Sales and Finance.
• Developed QlikView dashboards with various data visualization objects for Sales and Inventory data domains.
• Sales dashboards include Sales by KBD, by customer segment, by region, by line of business.
• Used various data visualization objects such as chart Box (drill down, drill up & Cyclic Grouping), List, Table Box and Calendar & Data Island.
• Involved in performance tuning of QlikView applications.
• Assisted the team in Data profiling smart data optimization using Qlik Sense 2.0
• Assisted the team in implementation of various features in Qlik Sense such as Pivit table, KPI object, PDF printing etc.
• Implemented three tier architecture in Qlikview.
• Implemented sheet level security along with document level security using section access.

Environment: QlikView 11.2, MS Office, Windows 2008 R2 Server, MSSQL Server 2008, MS Access 2005

Confidential, New Jersey

QlikView Developer

Responsibilities:

• Involved in gathering and analysing business requirements.
• Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB
• Developed ETL scripts while loading the data resolving loops and ambiguity joins
• Worked on the Oracle databases and imported SQL scripts into QlikView.
• Implemented sheet level security using section access that dynamically hides selected areas of the dashboard depending upon user privileges.
• Developed dashboards with different KPIs, such as time taken to start and end a deployment and also various data visualization objects.
• Created optimized QVDS which loads faster and helps to improve the performance.
• Used QlikView functions like fabs, peek, previous, isnull etc.
• Worked on enhancements and Performance tuning on existing dashboards.
• Created variables and used them at a document level.
• Developed SQL Scripts to load the relevant Data in QlikView Applications
• Scheduled data refresh on applications on QEMC.

Environment: QlikView 11.0, MS Office 2008, Oracle 10g.

Confidential, Austin, Texas

QlikView Developer

Responsibilities:

• Gathered and loaded data into QlikView from various data sources (SQL SERVER 2005, .CSV and excel files, QVDs).
• Implemented Star schema and snow flake schema (conformed dimensions) as identified in functional documentation.
• Developed linked tables, Concatenation and solved the loops issues.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using QlikView 10.
• Created Dashboards with different style using QlikView components like list box, slider, buttons, charts, bookmarks etc.
• Created variables and applied them to sheet functionality.
• Involved in establishing a secure environment using QlikView Section Access.
• Experience in applying SET ANALYSIS to provide custom functionality in QlikView Applications.
• Implemented Incremental Load to improve Load Time.
• Tested applications, ensuring the application met the requirements and data quality.

Environment: QlikView 10.0, MS Office, MS SQL Server 2008.

Confidential, Lowell, MA

PL/SQL Developer

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Created process force and deployed into run time depository using ware house builder
• Involved in logical modelling and physical modelling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing CRONTAB to schedule the information of crone tries.
• Involved in creation of Conceptual Modelling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas. worked with bulk collect to Implement the performance of multi row queries
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Remediate Oracle application Custom object components like Forms, report and Concurrent Program (PLSQL code).
• Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.
• Upgraded to Forms 10g, Reports 10g, maintained and troubleshoot Oracle Forms and Reports.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Worked on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting the development tasks.
• Developed Master Detail, Detail reports using tabular and Group above reports.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g,Reports10g,UNIX, Windows XP/2000.owb 10g.

Confidential, Jacksonville, FL

PL/SQL Developer

Responsibilities:

• Designed, created and tested enhancements to a high performance OLTP client server system processing for both daily and scheduled financial transactions.
• Involved in designing Technical Design Documents based on health care Business requirements.
• Extensively used advanced PL/SQL concepts (e.g., varrays, PL/SQL tables, cursors, user defined object types, exception handling, database packages, nested tables) to manipulate data
• Wrote packages and procedures to move data from one table to another.
• Created indexes on tables to improve performance of the queries
• Used BULK COLLECT to fetch large volume data.
• Used Control - M a third party tool to schedule various others batch processing jobs.
• Involved in the performance tuning of various database queries. The queries retrieved data from different tables in multiple databases.
• Used EXECUTE IMMEDIATE to execute dynamic SQL.
• Used Explain Plan, TK Prof in tuning queries.
• Used analytical functions like LEAD, LAG.
• Raised Siebel exception using PL/SQL packages.

Environment: Oracle 10g/9i, SQL Navigator 5.5, Rational Clear case 7.0, Quality Center 9.2, UNIX, Win 2000/XP.

Confidential

Jr. PL/SQL Developer

Responsibilities:

• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement businessrules into the application.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used Dynamic SQL (DBMS SQL, DBMS DDL) in function and procedure.
• Generate SQL Scripts and create views for reports.
• Used Toad to Extract and test the data in the database.
• Developed Database Triggers to enforce security.
• Responsible in coding and debugging.

Environment: Oracle8i/9i, SQL, PL/SQL, SQL*Loader, Toad, Windows NT/XP