SUMMARY:

• Over 6 years in Information Technology field with Extensive Business Intelligence, Analysis and Database Skills.
• 4+ years in QlikView with extensive hands - on experience in Design, Development, Analysis, Server, Publisher.
• Over three years of experience in Data Analysis, including cleansing, penetration and Top sheet production and using statistical functions.
• Experience in all aspects of SDLC right from Requirement Gathering, BRD, Prototyping, Design, Development, Testing, and Deployment with effective communication.
• Experience with 3 Tier Implementation of QlikView Projects as a standard best practice methodology.
• Extensive experience in QlikView Scripting using with best practices, used to create complex data cleansing, transforming functions for achieving an effective data model.
• Implemented Incremental Load to handle high, historical and incremental volume of data.
• Implemented Section Access, Binary Loads and abstracting the data layer using QlikView library and QVX files.
• Extensive experience on designing Dashboard UI and layouts, Themes and Color Palettes etc.
• Well experienced in visualizing customer requirements and coming up with visual design whenever necessitated.
• Extensively worked on all the QlikView In-built charts with different options available for them.
• Extensively worked on some of the available extensions Objects such as QlikMap, Org Chart, Whisker Pie etc.
• Implemented Dashboards with features such as Comparative analysis, Extensive Set Analysis, Consolidation of variables in External file etc.
• Extensively used various Qlikview Scripting and UI functions such as aggr, rank, rangesum, first sorted alue, apply map, match, concat, numeric and date functions, etc.
• Extensive use of Excel Functions to get Cleaning up the data & maintain smooth recovery of the system.
• Sound knowledge of SQL, PL-SQL and Oracle analytical functions, and LLD extractions.
• Having experience of Daily interaction with end users for gathering business/ KPI requirement.
• A talented team player, self-starter, can work effectively within a group or as a stand-alone environment.

TECHNICAL SKILLS:

QlikView: QlikView Development (Version 9.0/10/11), QlikView Server (Version 9/10/11), QlikView Publisher.

Other Business Intelligence: Business Objects XIR2/3.1, Crystal Reports XI/2008

Databases / DB Tools: SQL Server 7.0/2000, Oracle 8i/9i/10g/11g, Sybase 7.x/11/12, DB2, Teradata, MS Access.

Programming Languages: QlikView Scripting, SQL, HTML.

Front End Tools: Microsoft Project, MS Visio, HP Quality Center

MS Office Tools: MS Outlook, MS Word, MS Excel, MS Access, MS PowerPoint

Operating Systems: Windows 98/2000/XP/Vista/7, Mac OSX

PROFESSIONAL EXPERIENCE:

Confidential, Raritan, NJ

Sr. QlikView Developer

Responsibilities:

• As a QlikView Architect, worked with the client to scope out the requirements and setup a project plan and enterprise framework deployment methodology.
• Strong understanding in creating Dashboards, scoreboards for the required KPI are in QlikView.
• Assisting the client to update their current QlikView dashboards and reports and to modify the existing ETL processes, to in corporate the change in business rules
• Developed load scripts to work with multiple data sources (DB2, Flat Files, Excel, and MS Access).
• Assessing the Data Governance process, relevant systems and performing gap analysis for a key
• Department of the financial institution.
• Presented the gaps, recommendations, and the road map to achieve the short term and long-term goals.
• Used QlikView to design and implement a Data Governance Dashboard. The dashboard analyses the source systems, processes, and people information and presents the data in the Government Iron Triangle. The analysis can be performed down to the lowest levels in all three areas
• Developed KPI's, set analysis applications, User Interactive Sheets as business needs.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Analyzed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
• Executed the scripts and checked the incorporated script changes in the Application.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed an application for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Integration with Third party portal & Share Point Portals.
• Involved in up-gradation of QlikView environment from QV 9.0, QV 10.0 versions.
• Designed, developed, implemented and tuned multiple QlikView applications.

Environment: QlikView 10.0/9.0, SAP BW, QlikView SDK, Windows 2008 R2 Server, Oracle 10g, MS Access 2005, SQL Navigator, Windows XP.

Confidential, Houston, TX

Sr. QlikView Developer

Responsibilities:

• Main goal is to build and maintain the Analytics for Defecto & Call resolution.
• Dash board is made to Monitor Service record from Problem calls to resolution, pattern of defects, resolution time line, lead time from call to resolution, call repetition from customer and specific problem related to parts, token analysis for replacement and extended support.
• Participated in Template designs, User Interface and Navigation Design patterns, coming up with Dashboard standards for the company.
• Extensively involved in working with Users in understanding requirements, preparing BRDs and presenting POCs to arrive at Dashboard solutions.
• Designed and developed dashboards with various levels of complexity including various kinds of charts and extensions.
• Built complex expressions using set analysis and functions in support of the dashboards.
• Used variety of QlikView Extensions such as Google Maps, QlikMaps, Webpage Viewer, Org Chart, Whisker Pie Chart and HtmlTextBox.
• Involved in Dashboard optimization to handle large volumes of data using QlikView best practices and Techniques.
• Prepared data models connecting to variety of multiple data sources such as Oracle, SQL Server, Access, flat files.
• Handled the end-to-end implementation of QlikView dashboard deployment.
• Implemented incremental load by creating QVDs and optimized the periodic data additions.
• Scheduling the automation of QV jobs using QlikView Management Console.
• Worked with QlikView Publisher for PDF Distribution, Loop and Reduce and Data Reduction.
• Implemented triggering of QlikView Task via Autosys using EDX in order to invoke Dashboard refresh via Autosys Tool independent of Server.

Environment: QlikView 11.2/11, Oracle 9i/10G/11G, SQL Server 2008, Access, CSV Files, Windows 2008 Server, SharePoint.

Confidential

Sr. QlikView Developer

Responsibilities:

• Interacted with End Users and Documented the Requirements.
• Developed various internal prototypes for acceptance testing.
• Followed the agile pattern of working and work execution.
• Played a part a Business support solution provider and closely work under the environment of WAR room meeting, complete brain storming.
• Connected to multiple data sources such as Oracle, DB2, Flat files, Excel Spreadsheet’s and prepared close to business requirement like model. (Especially star model and snowflake).
• Established a Standard structure for Test and working files(QVW) and version controlling to maintain parity between production and Test environment.
• Used QlikView direct discovery along with Document chaining to fetch on-demand report from linear database after creating View inside the database to protect performance from huge data loading during mass data accumulation due to Granular data fetching.
• Implemented 3-Layer architecture, Binary loads and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards.
• Incorporated necessary log files and failure mailing mechanisms for smooth day to day operations.
• Worked on data model according to the user requirement and successfully created an optimized QlikView application.
• Developed Dashboard and What-If predictive analysis based on complex price calculation.
• Developed reports / KPI’s for Supply Chain mechanism, including supply demand GAP and self-life stock monitoring reports.
• Developed dashboards and KPI’s using set analysis, variable creation etc. for individual payroll details, comparison with peer and comparison with the market.
• Performed testing of dashboards for functionality, data, performance, and UI design.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality through QV Publisher.

Environment: QlikView 11/10, Oracle 9i/10G/11G, SQL Server 2008, Access, CSV Files, Windows 2008 Server, SharePoint.

Confidential, Austin, TX

QlikView Developer

Responsibilities:

• Involved in User requirements and Documentation and Dashboard Prototypes.
• Created various dashboards using different kind of charts - Bar, Line, Combo, Scatter, Grid, Block, Spider, Pivot and Crossable.
• Written complex expressions using Set analysis and various QlikView functions.
• Build sales dashboard for secondary / distributor’s network.
• Including analytics for on CRM data, trend analysis, performance analysis for sales reps, after sales service dashboard, part supply chain management, JIT dashboard for logistics.
• Create a robust model by adding multiple source of data from Sales Data warehouse and CRM.
• Create a significant Analytics to find out Assortment and commissioning no. of different model parts which are laying unused in the assembly line after testing release of the cars.
• Developed data model to reflect a Start model after translating various sources into Dimension and Facts.
• Eliminated all Synthetic keys and Circular References to make data model efficient.
• Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies.
• Involved in QMC Administration, Server/Publisher installation and Configuration.
• Implemented Data security using Section access and Publisher Data Reduction.
• Create KPI’s on comparative analysis by using Alternate State functions for different car variant.
• Developed QlikView Reports for PDF Distribution via Email.
• Involved in the entire lifecycle of QlikView Dashboards.
• Involved in Testing Dashboard data using extensive SQLs, Excel Pivots and Mappings.

Environment: QlikView 9/10, Oracle 10g,Access, XML Files, MS Excel, Windows 2003 Server, Crystal Report.

Confidential, Phoenix, AZ

Data Analyst

Responsibilities:

• Data churning and input XLS creation for more informative data element.
• Making Proof of concept to justify the value for the Analytics.
• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Engaged in developing Dashboard standards such as Template excel designs for end users.
• Directly worked with End Users to understand their requirements, worked on Demo of Prototypes.
• Developed elegant and professional looking excel reports and charts using different charts and techniques.
• Coordinated with Database and ETL teams for Data and Structural follow-ups and Design.
• Created complex expressions using Excel based advance function like Trend, Slope and other statistical function.
• Developed TOP sheet based on Historic data aligned to unstructured excel data and various Data systems.
• Used extensive amount of V-Lookup and H-Lookup
• Used SSAS to get more data insight by creating Cubes.

Environment: Oracle 9i/10G/11G, SQL SERVER 2005, XLS Files, Windows 2008 Server.

Confidential

Data Analyst

Responsibilities:

• Developed SSIS to extract, transform and load data from different data sources, such as databases, CSV, Excel files into SQL Server database for reporting purpose
• Maintained dimensions/facts/data extractions jobs using SSIS
• Developed complex stored procedures to process data in SQL Server 2005/2008
• Optimized SQL queries and fine-tuned indexes to improve system performance
• Developed scripts to execute SSIS packages using DTEXEC
• Deployed SSIS packages in either File System or MSDB
• Understanding SQL Server Replications, Snapshot, Transactional and Merge type
• Communicated with both customers and DBAs to accomplish large and complex assignments

Environment: SQL Server 2005/2008, SSIS, SSRS, MS Excel, Windows 2003 Server.