SUMMARY

• Over Eight years of total IT experience with five years in Qlikview and three years in SQL & other Business Objects tools.
• Experienced QlikView developer - the 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 with 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 the 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 halp users to identify critical KPIs and facilitate strategic planning in the organization using QlikView.
• Performance tuning by analyzing and comparing the 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 the 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 with project management principals to maximize return on investment.
• Excellent analytical and teamwork skills. Team player with excellent verbal, written and interpersonal skills and capable of independent work with 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 with a result driven attitude, Strong interpersonal and communication skills in TEMPeffective information exchanged and interaction with 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 the reporting requirements with the business users and came up with the 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 the QlikView.
• Designed the Data-Model using data from various sources like Oracle 10g Database and flat files.
• Extensively used set analysis to calculate/aggregate the fact data as per the 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 the governance Dashboard.
• Extensively done business user support, resolved various issues for accessing dashboard and enhanced the dashboard as per user needs.
• Designed and implemented the Incremental Load using QVDs.
• Implemented the 3-tier architecture, Data Extract, Data transform and Data model & Application. Data Extract would load the Data from the data sources into the QVDs. Data transform will transform the 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 the QlikView applications in the server. Created Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.
• Scheduled the Publisher Tasks Daily/ Weekly/ Monthly on various Dashboards based on the Database updates.
• Knowledge of star schemas, Optimization of data model for query performance.
• Utilizing the Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Extensive knowledge with Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Involved in setting up the 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 with business analysts and data architect to resolve the 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 with 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 the 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 the 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 the existing data model, script logics and ETL logics for the existing dashboards.
• Knowledge of star schemas, Optimization of data model for query performance.
• Utilizing the Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Used Qlikview desktop and publisher, managed user authentication, established publisher tasks, streamlined loading procedures and reviewed log.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Enhanced existing dashboards with new functionalities and tuned ETL scripts for better performance.
• Creation of reports usingreports and chartsas per the customer requirement depends on Quarter, monthly And analyzes the report with 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 the required KPI’s in Qlikview.
• Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the 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 the data.
• Knowledge of star schemas, Optimization of data model for query performance.
• Utilizing the Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Involved in designing the Data model and Construction of the Data model and implemented the 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 the end users to use the reports TEMPeffectively, 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 with the user community and senior management to identify the business’ reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.
• Worked with different LOBs to understand the reporting and analytics requirements
• Converted Cognos reports to QlikView dashboards.
• Built multiple dashboards and presented to different user groups to make them understand the functionality of dashboards.
• One of the dashboard built was ATM transaction tracker dashboard. It tracked the ATM usage in the country by region and division.
• Worked with 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 the 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 with users, team lead, DBA’s and technical manager to fully understand the requirements of the 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 the business requirements with proper tuning techniques.
• Created checks and constraints to maintain data integrity across the data in the 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 the programs.
• Created required technical documents, technical specifications, test results.
• Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.
• Used Exception Handling for handling errors of programs, scripts and procedures.
• Complete responsibility of deliverables as well as the 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 the Reports module of the 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 this data into the existing asset databases.
• Created and executed SQL Server Integration Service packages to populate data from the 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 then 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 the existing procedures.
• Assisted in documentation of the Tech Specification and Use Case Specification.
• Implemented database triggers based on the 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 the system.
• Created database Objects Tables, Indexes, Views, Synonyms
• Tested queries to optimize the 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 the specified reports.
• Tuning of the SQL queries using Explain Plan, SQL*Trace.
• Created the database from full export for the Table space point in time recovery.
• Modifying the 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.