SUMMARY:

• Over 8+ years of professional experience in Information Technology with extensive experience in the field of Business Intelligence(BI) leveraging QlikView/BO/SSRS for various domains like Insurance, Banking, Finance and Government Sector.
• Over 3+ years of experience in designing, developing and deploying of QlikView Applications.
• Installed and configured QlikView on Windows 2008 R2 Servers and configured Windows AD Authentication.
• Deep Knowledge in Requirement Gathering, Designing and Data - Modeling for QlikView Dashboards.
• Excellent knowledge in importing data from various Data Sources like Excel Files (.xls), CSV Files(.csv), XML Files(.xml), MDB Files(.mdb, .accdb), Oracle 10g/9i, SQL Server 2005/2008, DB2 9.7 Database and other Databases.
• Implemented the 3-tier architecture (Data-Extract, Data-Modeling and Application Development) as recommended in QlikView best practices guide.
• Helped Business Analysts to understand the advanced features and capabilities of QlikView Tool for the successful implementation of QlikView Prototype and PoC (Proof of Concept) projects.
• Designed efficient Data-Models from Multiple Data sources and followed the Best-Practices guide provided by QlikView.
• In-Depth Knowledge on How-To eliminate the Synthetic Keys and Loops in the Data-Models, as the existence of Synthetic Keys, Loops might yield unwanted results and sometimes might occupy the entire Server’s memory.
• Extensively usedQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc), Loops, Conditional Statements and Variables.
• Developed Macros using VBScript and JavaScript in the QlikView Applications.
• Implemented Security & involved in Deployment ofQlikViewApplications.
• Expert Knowledge with Set Analysis which would make QlikView a very Flexible Tool for analyzing Various Sets of Data.
• Well Versed with the latest QlikView Version 11 which has advanced, powerful Options like Dimension Limits, Alternate States to mention a few.
• Worked on all kinds of Charts like (Bar Chart, Line Chart, Pie Chart, Mekko Chart, Block Chart, Funnel Chart, Radar Chart, Scatter Chart, Grid Chart), Guages and Straight Table, Pivot Table, Date Pickers, Sliders etc.
• Worked Closely with the ETL Team to automate the QlikView Publisher Tasks to run as soon as the Database/Datawarehouse is updated through a Control-M (W00) Jobs.
• Created QlikView Publisher Task in QMC to Reload & Distribute the QlikView Dashboards to the Access Point (the centralized browser-based app to view QlikView Dashboards).
• Implemented Section Access on various QlikView Application so that the Data in the Dashboard will be filtered based on the User’s Access privilege.
• Trained all our Customers/End-Users on How-To Use the QlikView Tool like making selections and Clearing the selections and also explained them the QlikView Architecture.
• Business Intelligence experience using Business Objects XIr2/6.5, BO Supervisor, BO Designer, BO Reporter, Info View, Web Intelligence.
• Experienced in design and development of Complex Universes
• Strong Data warehousing experience with Business Objects, WebIntelligence, CMS (Central Management Server), CMC (Central Management Console), Import Wizard.
• Experienced in creating Metrics, Analytics, Goals/ Scorecards in Xi R2.
• Good Knowledge of database experience using Oracle 11g/10g/9i/8i, MS SQL Server 2005, MS Access 2000/7.0, TOAD, PL/SQL, SQL and SQL*Loader, SQL Navigator.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Eminent on Sanity, Functional, Regression and System Testing.
• Proficient in Software Development, Testing Life Cycle, and Defect Life Cycle.
• Good communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Excellent Interpersonal and Customer Relational Skills. Proven Communication, Presentation Skills and Leadership Qualities.

TECHNICAL SKILLS:

BI Tools: QlikView 11/10/9, BO, SSRS

ETL Tools: Informatica Power Center, Data Services, SSIS

Databases: Oracle 9i,10g,11g, MS SQL Server, Teradata, MS Access, DB2

Web Technologies: HTML,DHTML, XML

Packages: MS-Office( MS-Access, MS-Word, MS- FrontPage and MS-Excel)

Languages: SQL,PL/SQL, C, C++ and Java

Scripting Languages: Java Script, VB Script, Shell Script

Operating Systems: Windows 2008/2005/2000/ XP, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Somerset,NJ

Qlikview Developer

Responsibilities:

• Worked with the business users to create requirements
• Worked on creating a complex data model which would be used in building dashboards for the leadership
• Created complex dashboards and charts to make sure that the management will know the renewal status of every customer policy
• Pulled data from multiple data sources to build dashboards and maintain security
• Created dashboard for underwriters to compare renewal rates over the years
• Maintained security and access using Section access at the document level with the section access data being saved in a database
• Helped through user acceptance testing and also end user for the dashboards built.
• Maintained best practices and helped through code review being performed by an external team
• Created incremental load scripts for the building the data model and the dashboard application using a 3 tier architecture.
• Resolved issues with circular loops and synthetic keys with deep knowledge of data procured by working closely with the DBAs

Environment: Qlikview 11 SR4, IBM DB2, VB Scripting, windows server 2008, HP Quality Control, QMC, Microsoft office Suite, DBeaver Query tool.

Confidential, Beverly, MA

Qlikview Developer

Responsibilities:

• Worked on Building Complex Data models
• Worked with building data lineage for the data models built.
• Built incremental loads with segmentation. This is where the incremental loading of data has been modified into an external script where we used multiple parameters to represent tables and keys so we can built an incremental script with just changing the parameters.
• Worked on scripts to verify data lineage by pulling data from both the QVDs and the database.
• Built a client-Policy-Claim data model where the data is pulled from multiple tables to provide for client policy and claim needs of the client.
• Scheduled the Publisher Tasks Daily/Weekly/Monthly on various Dashboards based on the Database updates.
• Streamlined the incremental load of 150 million records so that the load time was minimal considering the size of the data.
• Built models to built stat reports and claim status reports.

Environment: Qlikview 11 SR4, SQL Server 2008, VB Scripting, windows server 2008, TFS,QMC, Microsoft office Suite.

Confidential, Sterling, VA

Qlikview Developer

Responsibilities:

• Worked on Building the Adhoc Reporting Tool for the End Users
• Designed the Data model for the Adhoc Reporting tool which would be able to improve performance by elimination of the synthetic keys.
• Designed 43 fixed reports which would be pulling data from Oracle Database and built reports on these based on the requirements.
• Designed macros which helped in making the reports more user friendly.
• Designed macros which allowed to perform tasks which are not directly available through Qlikview like hiding a column in a straight table and still have its effect on the report.
• Built the Full reload and partial reload QVWs which helped load data depending on the month.
• Used an enhancement of the 3 tier architecture of QlikView which stores data in the QVDs and loads it from them directly every month instead of pulling the data from the database which relieved the database burden.
• Worked on setting up the tasks for reload using the QMC and distributed them to multiple users depending on the requirement
• Built the Section Access tables to restrict access to particular fields and data.
• Built Section access controls to control access t the application.
• Extensively used Set Analysis and AGGR Functions to provide for the aggregations necessary.
• Controlled the data being available in the reports depending on the date controls set up.
• Improved efficiency of the data reloads using Optimized Loads.
• Worked closely in the creation of standard reports for all the clients so that the reports need not be modified for every individual client using configuration files.
• Worked with the user for user to provide them with enough knowledge to run the reports efficiently.

Environment: Qlikview 11.0 SR2, Oracle 11G, MS office suite, Windows 2008 R2 Server, SQL developer, Agile methodology, QMC, JIRA, Lotus notes, VB Scripting.

Confidential, Franklin, MA

Qlikview Consultant

Responsibilities:

• Involved in various Prototype Designs and helped the Business Analyst to understand the capabilities of the QlikView Tool.
• Designed the Data-Model using various data sources like PostgreSQL 9.2 Database, XML and Excel Sheets.
• Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources
• There were 12 million records with incremental loading of 40,000/week.
• Implemented the 3-tier architecture, Data Extract, Data Model and Application. Data Extract would load the Data from the datasources into the QVDs. Data Model will define the relationships between the tables(QVD) and Application layer is User Interface Design layer
• Enhancement of the already existing Dashboards into QlikView and also improved performance of the applications to better utilize system resources. Extensively worked with Set Analysis.
• Worked closely in the creation of standard reports for all the clients so that the reports need not be modified for every individual client using configuration files.

Environment: Qlikview 11.0 SR2, PostgresSQL 9.2, MS office suite, Windows 2008 R2 Server,Toad, Agile methodology

Confidential, Greensboro, NC

Sr. Qlikview Consultant

Responsibilities:

• Installation of the latest versions of QlikView, recently migrated from QlikView 10 to QlikView 11 SR2 Release.
• Migrated all the Publisher Tasks from QlikView 10 to 11 and applied the dependencies between the tasks.
• Involved in various Prototype Designs and helped the Business Analyst to understand the capabilities of the QlikView Tool.
• Designed Dashboards like “Revenue Growth Analysis” to analyze the summarized information on the Top 10 Best Performing, Top 10 Under-Performing Branches, Trends of Yearly, Monthly Loss Ratios based on selection of the Branches / Managers / City / State / Month / Year Dimensions.
• Developed Dashboards for the Financial Details of the company with Charts based on the Metrics Revenues, Expenses, Income, Returns, Margins etc.
• Identified the KPIs for the QlikView Dashboards like Revenue Tracking, Portfolio Risk, Total Processing Costs, Non-performing, and Net Charge-Offs etc.
• Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.
• Designed the Data-Model using various data sources like Oracle 10g/DB2 Database, XML and Excel Sheets.
• Implemented the 3-tier architecture, Data Extract, Data Model and Application. Data Extract would load the Data from the datasources into the QVDs. Data Model will define the relationships between the tables(QVD) and Application layer is User Interface Design layer where we layout all our Charts, Tables and ListBoxes.
• Implemented Section Access on the Pharmaceutical Dashboards where users belonging to specified Windows AD group will be able to view the Dashboards based on their privileges defined in the QlikView Application.
• Developed Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms
• 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.
• Installed and Configured QlikView 11 on Windows 2008 R2 Servers and clustered 6 servers for our production environment.
• Participated in pre-sales activity working with prospective client, assisting with Technical contributions to win new business.
• Involved in setting up the Development and Performance Environments for QlikView.
• Worked on QMC to Cluster the 6 Production servers, setup the E-Mail alerts in case any Publisher Tasks fails.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources
• There were 4 million records with incremental loading of 20,000/week.
• Enhancement and translation of the already existing Dashboards in Business Objects into QlikView.
• Extensively worked with Set Analysis in some of the Dashboards which I worked on.
• Helped end users to design test cases and worked through multiple UAT cycles
• Worked with QlikView 10.x, SQL Server, Oracle, DB2, Excel, flat files.

Environment: Oracle 11g, DB2 9.7, SQL Server 2008, MS Office, Windows 2008 R2 Server, Toad, SharePoint, Qlikview 10.x, Agile methodology.

Confidential, Emeryville, CA

Sr. QlikView Consultant

Responsibilities:

• Worked with Business Analyst and the Business user to understand the user requirements layout, and look and feel of the application to be developed
• Two Dashboards were developed and served to track all the way through Ship to Final acceptance phase, which include Installation, Field STR, Pre-Warranty Aging etc; Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms
• Setting up New task, mounting on Access Point, troubleshooting already existing task setup and other issues
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher
• Participated in pre-sales activity working with prospective client, assisting with Technical contributions to win new business.
• Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources
• There were 4 million records with incremental loading of 20,000/week.
• Enhancement and translation of the already existing Dashboards in MSRS into QlikView. Extensively worked with Set Analysis
• Helped end users to design test cases and worked through multiple UAT cycles
• Worked with QlikView 10.x, SQL Server, Oracle, SAP, Excel, flat files.

Environment: Java, QTP, Oracle 11g, SQL Server, MS Office, Windows XP, JIRA, HTML, Rally, Toad, SOAP UI, Altova XML Spy, SharePoint, Qlikview 10.x, SSRS, Agile methodology

Confidential, Raleigh NC

QlikView Developer

Responsibilities:

• Worked with Business Analyst and the Business user to understand the user requirements layout, and look and feel of the application to be developed
• Two Dashboards were developed and served to track all the way through Ship to Final acceptance phase, which include Installation, Field STR, Pre-Warranty Aging etc; Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms
• Setting up New task, mounting on Access Point, troubleshooting already existing task setup and other issues
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher
• Participated in pre-sales activity working with prospective client, assisting with Technical contributions to win new business.
• Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources
• There were 4 million records with incremental loading of 20,000/week.
• Enhancement and translation of the already existing Dashboards in MSRS into QlikView. Extensively worked with Set Analysis
• Helped end users to design test cases and worked through multiple UAT cycles
• Worked with QlikView 10.x, SQL Server, Oracle, SAP, Excel, flat files.

Environment: Java, QTP, Oracle 11g, SQL Server, MS Office, Windows XP, JIRA, HTML, Rally, Toad, SOAP UI, Altova XML Spy, SharePoint, Qlikview 10.x, SSRS, Agile methodology

Confidential, Danbury, CT

Business Objects Consultant

Responsibilities:

• Actively involved in gathering business requirements, functional requirements and data specification.
• Involved in detail design and development of mappings using Business Objects Data Integrator.
• Extracted data from multiple heterogeneous sources like RDBMS, Excel Files, Flat Files and XML into a target RDBMS using Data Integrator and also extracted data from SAP BW and stage them to data marts.
• Extensively used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in data integrator in order to load data from source to Target Systems.
• Developed ETL code using SAP Business Objects Data Integrator/Data Services.
• Worked on performance Tuning of long running jobs used techniques like pushing down operations to database.
• Experienced in Data Migration from one repository to another repository.
• Scheduled and Monitor jobs using Data Integrator Management console.
• Interacted with Business Users to understand the Business requirements and prepared technical documents for implementing the solutions as per Business needs.
• Involved in creating the mappings according to the business requirements.
• Used Universes as source for the Business Objects reporting and analysis
• Designed and implemented BO XI R2 security.
• Designed, developed and modified several BO Universes and Reports.
• Designed and developed BO Dashboards in BO XI R2 environment.
• Subject matter expert in BO and DI. Coordinated closely with on-site team to support the application. Prepared the test cases to validate the mappings.
• Improved the performance of jobs by tuning the batches.
• Involved in the integration of updates based on customer requirements and working on data reconciliation project which is delivered to customer and worked with all jobs to pull the data from source to target with functional requirements...
• Interacted with Business Users to understand the Business requirements and prepared technical documents for implementing the solutions as per Business needs.
• Involved in creating the mappings according to the business requirements.
• Monitored the jobs for successful completion and resolved the data issues.
• Designed and implemented BO XI R2 security.
• Designed, developed and modified several BO Universes and Reports.
• Designed and developed BO Dashboards in BO XI R2 environment.
• Subject matter expert in BO and DI. Coordinated closely with on-site team to support the application. Prepared the test cases to validate the mappings.
• Improved the performance of jobs by tuning the batches.
• Analyzing and importing the source definitions.

Environment: SAP Business Objects Data Services XI 3.o, Business Objects, Oracle 9i/8i, SQL, SQL*Plus, TOAD, MS Office, SQL Server, and Windows NT

Confidential, San Diego, CA

Business Objects Developer

Responsibilities:

• Designed, developed and maintained Universes for supporting Adhoc and canned reports.
• Maintained security for the end users by giving privileges with supervisor module.
• Coordinated with ETL, Data warehouse team to implement the Star Schema modeling.
• Created Context, Alias to resolve the Loops in the universe.
• Created user objects to enhance the reporting needs.
• Object properties (Dimension, Measure & Detail) are defined properly at the design level so that it does affect the reports and charts.
• Created Filters (Condition Objects) to improve the report generation.
• Created Hierarchies from providing drill down options for the end-user.
• Maintained security for the end users by giving privileges with Supervisor.
• Created the Derived and Aggregate Tables.
• Detected cardinalities and checked the Integrity of Universes.
• Created variables, @prompt (Interactive objects), formulas and etc.
• Fine-tune the existing universes to enhance their performance.
• Created Standard reports, Summary, Cross Tabs, sub reports using Crystal Reports.
• Provided to end users to use various functionalities of Business Objects

Environment: Business Objects 6.5, Designer, Supervisor, Web Intelligence, Oracle, Crystal