SUMMARY

• Over 8 years in Information Technology field wif Extensive Business Intelligence, Analysis and Database Skills including 4+ years in QlikView wif extensive hands - on experience in Design, Development, Analysis, Server, Qlikview Publisher.
• Extensive experience in QlikView Scripting using wif best practices, used to create complex data cleansing, transforming functions for achieving an TEMPeffective data model.
• Ability to offer end-to-end solution starting from requirement gathering, design, development & deployment of Business Intelligence applications. Experienced wif Agile Development Methodology in providing quick analysis and visualizations for business users.
• Expert in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and business executives to take informed action.
• Hands on experience wif integration of Hadoop, Teradata & other Big Data technologies wif Qlikview.
• Experience wif QlikView 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.
• Implemented Incremental Load to handle high, historical and incremental volume of data.
• Implemented Section Access, Binary Loads and abstracting teh 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 wif visual design whenever necessitated.
• Extensively worked on all teh QlikView In-built charts wif different options available for them.
• Extensively worked on some of teh available extensions Objects such as QlikMap, Org Chart, Whisker Pie etc.
• Implemented Dashboards wif 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, range sum, first sorted value, apply map, match, concat, numeric and date functions, etc.
• Extensive use of Excel Functions to get Cleaning up teh data & maintain smooth recovery of teh system.
• Sound noledge of SQL, PL-SQL and Oracle analytical functions, and LLD extractions.
• Having experience of Daily interaction wif end users for gathering business/ KPI requirement.
• A great team player, self-starter, can work TEMPeffectively wifin a group or as a stand-alone environment.

TECHNICAL SKILLS

QlikView: QlikView Development, QlikView Server, QlikView Publisher.

Programming Languages: QlikView Scripting, SQL, HTML.

BI Features: Business Objects XIR2/3.1, Crystal Reports XI/2008

Databases: SQL Server, Oracle, Sybase, DB2, Teradata, MS Access.

Tools: and Utilities Microsoft Project, MS Visio, Confidential Quality Center, MS Outlook, MS Word, Ms Excel, MS Access, MS PowerPoint.

Operating Systems: Windows XP, Windows Server 2003/2008, Unix; Solaris, AIX, and Linux

Domains: Pharma, Banking, Financial Services, Healthcare, Retail.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Qlikview Developer

Responsibilities:

• Actively involved in requirement gathering sessions wif data analysts, stakeholders, Subject Matter Experts (SME), Project Managers and sponsors to create QlikView Requirement Documents and Designs to define KPIs (Key Performance Indicators), and identify data sources.
• 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 wif Dashboard standards for teh company.
• Extensively involved in working wif Users in understanding requirements, preparing BRDs and presenting POCs to arrive at Dashboard solutions.
• Designed and developed dashboards wif various levels of complexity including different kinds of charts and extensions.
• Built complex expressions using set analysis and functions in support of teh 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.
• Implemented incremental load by creating QVDs and optimized teh periodic data additions.
• Scheduling teh automation of QV jobs using QlikView Management Console.
• Worked wif 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.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using QlikView 8.5 and 9.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros and developed Linked Tables, Concatenation and solved teh loops issues.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Hands-on experience of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Created DAR s using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks etc.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to teh end users.

Environment: QlikView, Oracle, SQL Server 2008, Access, CSV Files, Windows 2008 Server, SharePoint.

Confidential, Auburn Hills, MI

Sr. Qlikview Developer

Responsibilities:

• Responsible to identify teh trends of loan applications, funding, penetration, buy rates and other KPIs
• Responsible to distribution and comparison of KPIs across geographies, brands, credit tiers
• Responsible for drilling into various KPIs to spot patterns and opportunities at lower levels such as districts and dealerships
• Provided complex KPI's (Penetration) using set analysis.
• Requirements gathering, Impact Analysis and solution designing to in corporate teh Business requests.
• Understanding teh business functionality & Analysis of business requirements.
• Creating mock up wif teh sample data.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Assist wif schema design and development of ETL processes.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts
• Implemented Data Modeling by using Star Schema and Snowflake Schema
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports
• Used QlikView Scripting and Complex SQL coding for loading, and transforming
• Designed and developed QlikView dashboards using different Charts (Drill Down, Cyclic Field grouping), Sheet Objects (List Box, Input Field, Table Box, Calendar & Date etc.) and extensions
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in teh scripts
• Developed Set Analysis providing custom functionality in QlikView Applications
• Designed and developed teh incremental loading where applicable
• Created QVDs, QVW files and scheduled teh tasks in Publisher to reload them
• Developed required user interactive Sheets/Reports & categorized as per business need
• Implemented Data Level Security, Object Level Security & Document Data Level Security

Environment: DB2, Qlikview, Microsoft Windows XP Professional, UNIX

Confidential, Cleveland, OH

Qlikview Developer

Responsibilities:

• Extensively worked to confirm and clarify requirements and business logic.
• Analyzed teh reporting requirements wif teh business users and came up wif teh technical specifications.
• Strong understanding in creating Dashboards, scoreboards for teh required KPI's in QlikView.
• Developed load scripts to work wif multiple data sources (SQL, DB2, AS400, Excel, and Share point site)
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed an applications for to support teh 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 teh QlikView Publisher
• Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions. Did end to end Unit Testing when migrating teh applications.
• Designed, developed, implemented and tuned multiple QlikView applications for teh Sales, IT, Manufacturing, Purchasing & Finance qlikview applications.
• Working wif teh management to identify teh business reporting needs and also develop teh architecture of prioritized reports by role dat would of teh most positive impact on teh business
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Wrote SQL Scripts, procedures and views which are required for qlikview projects.
• Configured and deployed teh application on QlikView server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Setting access permissions and assigning CALs based on users.
• Schedule QVW reloads on server and troubleshoot errors and failures.
• Worked on data modeling and developed different complex models as per given user requirement wifout any closed loops, Synthetic tables and ambiguous relationships.
• Mainly designed and developed Qlikview software applications and complex server-based Qlikview dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Sales Analysis, Production over time and implemented performance tuning dat offers fast and flexible access to all key information across teh enterprise.
• Involved in ERP system upgrade from MOVEX RPG to M3 JAVA system. For dat upgrade designed qlikview applications required for teh upgrade.
• Trained Distribution Center, Planning and Purchasing & Finance Teams on how to use qlikview applications.
• Worked on production tickets for teh applications which are in production.
• Testing dashboards and data validation.

Environment: QlikView 11x/10 (Desktop, Server/Publisher, Access Point), Nprinting for qlikview (14.03.), SQL Server,AS400 ( Iseries), Windows XP/7, ERP system M3 Java & MOVEX RPG.

Confidential, San Jose, CA

SQL Developer

Responsibilities:

• Involved in Installing SQL Server 2008 and creating users and Groups.
• Actively participated in gathering Business Requirements and System Specification from users.
• Carried out teh back up recovery process on a regular scale and regular up gradation to Developed views to facilitate easy user interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into teh database.
• Developed stored procedures to retrieve customer information from as required to evaluate eligibility for loan requests, account status etc.
• Wrote store procedures to generate account statements for different types of accounts.
• Monitoring performance and optimizing SQL queries and indexes for maximum efficiency.
• Created & modified a number of existing stored procedures based on teh changes made to some existing tables.
• Developed ETL Processes using SQL Server 2008 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database
• Created SSIS Packages by using different kinds of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created Packages by testing and cleaning teh Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Designed and deployed reports wif Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SQL Server 2008 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created standard & Data driven report subscriptions. Created report snapshots and cache for better performance.
• Configured report builder and trained business users so dat they could create reports from teh report models I created.
• Prepared teh Layouts by placing teh fields to teh appropriate place according to teh requirement of teh final Report.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA..

Environment: MS SQL Server 2005/2008, T-SQL, SQL Server 2008 Integration Services(SSIS), TFS, SQL Server 2008 Reporting Services(SSRS), MS Office, MS Visio 2007, SQL Server 2008 Analysis Services and Windows XP.

Confidential

Responsibilities:

• Create Users and Responsibilities for Security.
• Involved in design of teh application system.
• Involved in developing E-R diagrams, creating tables.
• Enhanced and developed several forms and reports using developer 2000
• Designed and developed library files (PLL) dat are commonly used across teh application
• Involved in design and development of Menu module
• Created database triggers to validate teh complex integrity.
• Created stored procedures, functions and packages for implementing major functions of teh system.
• Wrote scripts for populating teh database tables wif test data.
• Testing and documentation.
• Involved in design and development of Menu module
• Created database triggers to validate teh complex integrity.
• Created stored procedures, functions and packages for implementing major functions of teh system.
• Involved in design and development of Menu module
• Created database triggers to validate teh complex integrity
• Wrote scripts for populating teh database tables wif test data.

Environment: Oracle 7.3, SQL, PL/SQL, SQL*Net, Windows NT/95, SQL*Loader, Import, Export.