SUMMARY

• Over Eight years of total IT experience wif five years in Qlikview and three years in SQL & other Business Objects tools.
• Experienced QlikView developer - teh pioneered in-memory Dash boarding tool.
• Good knowledge and understanding of QlikView server, QlikView publisher and QlikView Enterprise version.
• Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience wif 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.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading teh data, resolved Circular Relationships, Synthetic Keys.
• ETL, OLAP analysis and reporting processes using QlikView BI, MS SQL Server 2005 and BO. Working knowledge of ETL processes of SSIS Packages, MS DTS, OLAP analysis SSAS cubes and SSRS reporting applications (Operational and Business Intelligence).
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in teh organization using QlikView.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and Qlikview.
• Experience in using ETL Tasks such as data cleansing, joins, aggregation tables using Qlikview.
• Designed and implemented proof of concepts for clients in teh Healthcare, Agriculture, Automobile, Pharmaceutical, Logistics, Financial, Design and Manufacturing sectors.
• Knowledge of industry best practices in both business management and technology domains.
• Adept at solving complex problems through a systematic approach that uses innovation and partnering combined wif project management principals to maximize return on investment.
• Excellent analytical and teamwork skills. Team player wif excellent verbal, written and interpersonal skills and capable of independent work wif minimal supervision
• Strong knowledge & experience in all phases of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, Security management and production support.
• Good Knowledge in Data Modeling, Star Schema/ Snow Flake, Dimensional and FACT tables.
• Strong experience in design & development ofBusiness Intelligence and Data warehousereporting.
• Strong experience in Dimensional Modeling using Star Schema, Identifying facts ad Dimensions, Physical and logical data modeling using ER-Modeling.
• Team Oriented individual wif a result driven attitude, Strong interpersonal and communication skills in effective information exchanged and interaction wif clients at all levels of management.

TECHNICAL SKILLS

Dash boarding/Analytics: QlikView, MS SharePoint, Cognos

Languages: SQL, PL/SQL, C++, VB, C#

Database technologies: Oracle9i/10g/11g, SQL Server, Teradata, MySQL

Platforms: Windows Server 2008, Linux (Ubuntu).

Others: MS Access, MS-Excel, MS InfoPath, Visio

Data Modeling Tools: Erwin, Toad.

ETL Tools: Informatica, Power Center 8.x/7.x., SSIS, SSRS.

Operating Systems: Windows XP/NT/2000, Windows Vista, Unix, Linux.

PROFESSIONAL EXPERIENCE:

Confidential

Business QlikView Developer

Environment: QlikView 10/11, Oracle 11g, MS Office, Windows 2008 R2 Server, Toad, Informatica Power Center.

Responsibilities:

• Analyzed teh reporting requirements wif teh business users and came up wif teh technical specifications.
• Actively participated in full life cycle of QlikView application implementation and was responsible for Design, Development and Delivery.
• Extracted data from different systems transformed and integrated in teh QlikView.
• Designed teh Data-Model using data from various sources like Oracle 10g Database and flat files.
• Extensively used set analysis to calculate/aggregate teh fact data as per teh requirements.
• DevelopedQlikViewDashboardsusing Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
• Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.
• Done metadata management by implementing teh governance Dashboard.
• Extensively done business user support, resolved various issues for accessing dashboard and enhanced teh dashboard as per user needs.
• Designed and implemented teh Incremental Load using QVDs.
• Implemented teh 3-tier architecture, Data Extract, Data transform and Data model & Application. Data Extract would load teh Data from teh data sources into teh QVDs. Data transform will transform teh data and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes. implemented section access for row, object, column and sheet level security.
• Developed Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Deployed teh QlikView applications in teh server. Created Publisher Tasks in QMC for teh QlikView Application to Reload and Distribute teh QlikView Application on to teh Access Point.
• Scheduled teh Publisher Tasks Daily/ Weekly/ Monthly on various Dashboards based on teh Database updates.
• Knowledge of star schemas, Optimization of data model for query performance.
• Utilizing teh Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Extensive knowledge wif Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Involved in setting up teh Development and Production Environments for QlikView. Responsible for user and server management.
• Helped end users to design test cases and worked through multiple UAT cycles.
• Involved in daily standup wif business analysts and data architect to resolve teh business issues and Data challenges.
• Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.

Confidential, Palm Beach Gardens, FL

Business Sr.QlikView Developer

Environment: Qlikview 10/11, Oracle, SQL server, Toad SQL Developer.

Responsibilities:

• Interacted wif customers to gather business requirements and developed functional and technical specification document.
• Participated and proposed new business analysis for data which TEMPhas no prior reports.
• Extracted data from teh database, stored into QVD files, and wrote load scripts.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports.
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Designed proficient dashboards according to teh requirements.
• Established a secure environment using Qlikview Section Access.
• Solid understanding of QVD / QVW / QVS and QMC / QEMC management, bulk data and incremental load.
• Involved in analyzing teh existing data model, script logics and ETL logics for teh existing dashboards.
• Knowledge of star schemas, Optimization of data model for query performance.
• Utilizing teh Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Used Qlikview desktop and publisher, managed user autantication, established publisher tasks, streamlined loading procedures and reviewed log.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading teh data, resolved Circular Relationships, Synthetic Keys.
• Enhanced existing dashboards wif new functionalities and tuned ETL scripts for better performance.
• Creation of reports usingreports and chartsas per teh customer requirement depends on Quarter, monthly And analyzes teh report wif charts provided by Qlikview.
• Provided training and supported client-in house business users.
• Worked as a developer using Qlikview 10/11.

Confidential, Charlotte, NC

QlikView Developer

Environment: Windows 2000 Server, Qlikview10.0, Oracle 10g, SQL Server 2005, MS Office.

Responsibilities:

• Strong understanding in creating Dashboards for teh required KPI’s in Qlikview.
• Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.
• Developed load scripts to work wif multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using teh Qlikview Publisher.
• Implemented ETL- Extraction Transformation and Loading by using QlikView three-tiered QVD architecture.
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through teh data.
• Knowledge of star schemas, Optimization of data model for query performance.
• Utilizing teh Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Involved in designing teh Data model and Construction of teh Data model and implemented teh Star schema for QV better optimization.
• Created dashboard style of layouts using different components of Qlikview Enterprise such as Listboxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Involved in Script development, script functions, script variables, inline load, QVWs, QVDs, set analysis and section access.
• Installed IE plugins and trained teh end users to use teh reports effectively, to build and customize their ad-hoc reports.
• Trained End Users on Using Qlikview Tools.

Confidential, Cleveland, OH

Business Systems Analyst/QlikView Developer

Environment: QlikView 10, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows XP, Microsoft Visio.

Responsibilities:

• Worked wif teh user community and senior management to identify teh business’ reporting needs and also develop teh architecture of prioritized reports by role that would of teh most positive impact on teh business.
• Worked wif different LOBs to understand teh reporting and analytics requirements
• Converted Cognos reports to QlikView dashboards.
• Built multiple dashboards and presented to different user groups to make them understand teh functionality of dashboards.
• One of teh dashboard built was ATM transaction tracker dashboard. It tracked teh ATM usage in teh country by region and division.
• Worked wif Macros, Filters, Variables, Set Analysis, Aggregate functions and Mapping Functions.
• Data was sourced from db2 environment. Used QlikView functions to load data viz Load, resident load, concatenate and so on.
• Created multiple tier QVD architecture. Created base layer, transformation layer and presentation layers.
• Developed a Star Schema Data Model that suits teh business requirements by eliminating synthetic keys and circular loops.
• Created various sheets objects like Bar charts, Line graph, Straight table, pivot table, combo chart. Created complex expressions in charts.
• Involved in user training. Mentoring other team members.

Confidential, Arlington, Virginia

PL/SQL Developer

Environment: Oracle 9i, Oracle Developer 6.0/6i, SQL, SQL*Plus, TOAD.

Responsibilities:

• Interacted wif users, team lead, DBA’s and technical manager to fully understand teh requirements of teh system.
• For complex business queries involving multiple tables from different databases used Joins, correlated and non-correlated sub-queries
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of requirements.
• Enforced business rules via checks and constraints.
• Developed SQL queries to fetch data as per teh business requirements wif proper tuning techniques.
• Created checks and constraints to maintain data integrity across teh data in teh database.
• Created Stored Procedures to generate various Drill-through reports and functions to support efficient data storage and manipulation.
• Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.
• Worked on various back-end Procedures and Functions using PL/SQL.
• Wrote necessary PL/SQL API scripts for successful running of teh programs.
• Created required technical documents, technical specifications, test results.
• Scheduled SQL Server Agent Jobs to run every day to update changes in teh base tables.
• Used Exception Handling for handling errors of programs, scripts and procedures.
• Complete responsibility of deliverables as well as teh production support.

Confidential, San Francisco, CA

Business SQL Developer

Environment: MS SQL Server 2008R2, SQL server Reporting Services 2008R2, MS SQL Server Integration Services, MS Visual Studio 2008/2010,MS Access.

Responsibilities:

• Worked on teh Reports module of teh project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Wrote several VB programs for a new application to receive price data from an external vendor and integrate dis data into teh existing asset databases.
• Created and executed SQL Server Integration Service packages to populate data from teh various data sources, created packages for different data loading operations for many applications.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa
• Designed and created Microsoft Excel spreadsheets to implement mathematical data analysis models and to provide an attractive and functional user interface.
• DesignedSSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and tan load intoDimension and Fact tables in Data Warehouse using SSIS.
• Involved in Performance Tuning activities including Query Tuning and Index Maintenance.
• Created Triggers to monitor activities on server as well as database and generate alerts and notifications.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Involved in preparing unit testing, System integration testing, implementation and maintenance.
• Responsible for data conversion activity for System Integration and User acceptance testing.
• Involved in Production Support to resolve end-users data related reports issues.
• Testing and debugging teh existing procedures.
• Assisted in documentation of teh Tech Specification and Use Case Specification.
• Implemented database triggers based on teh business rules and requirements.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• 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.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations

Confidential, Memphis,TN

SQL Developer

Environment: SQL Server 2005, Oracle 10g, Windows Server 2003, Windows XP, Microsoft Visio.

Responsibilities:

• Involved in analysis, design and development of teh system.
• Created database Objects Tables, Indexes, Views, Synonyms
• Tested queries to optimize teh procedures and triggers to be used in production.
• Involved in Performance tuning and Query Optimization.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
• Conducted impact analysis and designed structures to enhance performance.
• Involved in data cleaning, merging and conversion.
• Created stored Procedures, Functions, and Triggers by generating teh specified reports.
• Tuning of teh SQL queries using Explain Plan, SQL*Trace.
• Created teh database from full export for teh Table space point in time recovery.
• Modifying teh database design and structure, as necessary, from time to time upon information given by application users and developers.
• Implemented integrity Constraints on database tables.
• Involved in preparing documentation, Testing and debugging.