SUMMARY:

• Around 7.5 years of IT experience in developing Business Intelligence and Data Warehouse applications.
• Total 4 years of Experience in Dashboard Development & Report Designing / Development Skills.
• Highly experienced in domains like Health care, Investment Banking, Finance and Wealth Management.
• Good knowledge on migration process.
• Good hands on Experience in Qlikview 9, 11, SQL Server, Oracle.
• Experienced in using various data visualization charts such as scatter plot, grid chart, radar chart, block chart, heat map, gauge, pivot table etc.
• Good experience in implementing section access security mechanism throughout various assignments
• Excellent knowledge on fixing data model issues such as synthetic keys, circular references
• Good exposure to concatenation, join and other data model techniques
• Experienced in designing dashboard UI layout and page wise navigation
• Good exposure to QMC. Have created QMC task for reload and distribution purpose.
• Good knowledge on QlikView system and application architecture
• Experienced in defining and designing QlikView multi layer and multi stage applications
• Experienced in using QlikView set analysis for building complex and high performing expressions.
• Excellent knowledge on use of variables and actions in dashboards
• Familiar with DWH tools namely Business Object 3.0 & Informatica 9.
• Familiar with database such as MS SQL Server 2008, Oracle 10g/9i
• Extensive working knowledge on creation reports using various data providers.
• Ability to read and interpret Complex Data Models, and Data Modeling.
• Expertise in Designing FACT Tables, Dimension Tables, Summary Tables
• Proficiency in SQL and PL/SQL programming to develop Stored Procedures/Functions.
• Extensively used Qlikview reporting functionalities such as Incremental load, Generic load, Cross table, Partial load, Sorting, QVD, Section Access, Variables, Procedures, and Macros etc.
• Competent Knowledge of Oracle SQL & PL/SQL, Data Warehousing.

TECHNICAL SKILLS:

Tools: Reporting & Dashboard Tool: Qlikview 11,ETL Tool: Informatica 8.5

Other Skills: DataWarehousing,BusinessIntelligence,Informatica Power Center 8.5,9 (OLAP, Workflow Manager, Workflow,Monitor Worklets, Source Analyzer, Warehouse Designer, Mapping Designer,Transformations),SSRS,SSIS,Crystal Report,MS - Office(word,Excel,powerpoint)

Database Lang/ RDBMS: SQL, PL-SQL,Oracle 9i/10g

Operating System: Windows XP, 7,8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential,

Jersey City, NJ

Qlik view Developer

Responsibilities:

• Developed various complex dashboards based on client requirements by extracting data from different source systems like SQL server, Oracle and various Excel Files.
• Created QVDs by combining different type of tables from SQL server and scheduled tasks for these QVDs as these QVDs are used by other LOBs.
• Implemented section access using LDAP groups allowing users to have access based on their roles and LOBs they are related to.
• Worked on Macros in order to export the data from qlikview dashboard to excel workbook. Macros are designed for multi tab data export and images export.
• Worked on Compliance dashboards, trend analysis reports and various types of risk reports.
• Created technical design document for the dashboards.
• Created many canned reports and Ad-hoc reports.

Environment: QlikView 11.x, SQL Server, Oracle,, Excel, CSV files.

Confidential, Woodbridge, NJ

Qlik view Developer

Responsibilities:

• To understand client's business requirement and to capture the key performance indicators and metrics that helps client to observe the performance of existing business system.
• To create robust data model by considering the QlikView Scripting and Data Model standards and best practices.
• To identify the facts and dimensions thus by building dimensional model.
• To implement Section Access security model as required.
• To represent Business KPIs and Metrics through multidimensional Charts, tables and other visualizations.
• To identify the suitable QlikView native sheet objects like Bar chart, Gauge, Line chart, Pivot tables, Scatter charts for different business scenarios.
• To promote use of newly introduced powerful QlikView features within organization development community.
• To participate Intra-Org BI discussion Forum and to deliver tech talks and workshops sessions.

Environment: QlikView 10.x and 11.x, SQL Server, Oracle, Excel, CSV files.

Confidential, Hartford

Qlik View Developer

Responsibilities:

• Suggesting the better way of presenting the charts according the user requirements, which are successfully implemented in the dashboards.
• Providing operational users with detailed information on their operational and marketing performance.
• Extracted data from multiple hierarchies from cross table flat files and websites.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application.
• Created Document for the project planning and production Interface Documentation.
• Developed dashboards pertaining to KPI monitoring using QlikView10.x.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• Worked in various projects that require daily incremental reload schedule.
• Created and Scheduled Weekly QlikView reports.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• Created the dashboards for tracking the projects status of different Medicare and Medicaid projects.

Environment: QlikView 10.x, SQL Server, Oracle, SAP, Excel, flat files.

Confidential, Rhode Island

Qlik view Developer

Responsibilities:

• Extracting, transforming and loading data from multiple sources into Qlik View applications.
• Design, develop, and test Qlik View scripts to import data from source systems and test Qlik View dashboards to meet customer requirements.
• Work directly with business units to define and prototype Qlik View Applications.
• Good experience to a qlik view server and publisher.
• Good experience in creating dashboard and reports to CA-level executives.
• Good exposure in a developing what-if analysis reports.
• As a qlik view architect designed high level plans of project implementation
• Design and creation of User Interface and reports.
• Document event trigger and field event triggers is created.
• Task set up are done using QEMC and created architecture for the interdependent applications and execute in proper order.
• Developed advanced backup system through QlikView Publisher to allow for automatic saving of multiple versions of all QlikView applications and supporting files.
• Performed time over time analysis of sales volume and revenue.

Environment: QlikView 10.x, SQL, Excel files and flat files, Oracle.

Confidential, charlotte, NC

Business Intelligence Consultant

Responsibilities:

• Provided billable consulting support for achieving production success.
• Developed business systems and generated high revenues.
• Defined BI application requirements.
• Participated in verification of the application.
• Supported the data warehouse design and integration efforts, including data sourcing and transformation, logical/physical modeling and ETL development.
• Developed unit test semantic layers and reports.
• Assisted the organization in analyzing the compiled data and sorting the completed data.
• Compile the records from different departments and evaluate the performance at a micro and macro level.
• Introduced the data evaluation tools within the business framework.
• Attend meetings and seminars to understand the latest developments in the field of Business Intelligence.

Environment:: SQL server 2008, SSAS, SSIS, SSRS; ProClarity for reporting; Oracle as data sources.

Confidential

Business Intelligence consultant

Responsibilities:

• Attending client calls to understand their requirements. Speaking to expert panels on regular basis to collect information specific to various drugs under research and validate and update the data base accordingly.
• Assisting the senior level management in designing and creating the suitable strategy for developing the effective plans and policies.
• Designed and developed BI solutions and integration with databases and data warehouses for customers.
• Successfully analyzed, collected and prepared user requirements, definitions, scope and expectations for deliverable plans.
• Collected and documented the business processes and business rules, translated the Business and User needs into System requirements. Provided key input in working with users in defining project and system requirements.
• Consulted Solutions delivers global IT consulting expertise to the various industries.
• Analyzed and implemented business and technology change working collaboratively with business leaders.
• Recommended and presented solutions and strategies as needed.
• Provide excellent service to clients by developing long-term customer relationship.
• Develop project management solutions and process efficient projects for customers with suitable technology.
• Develop and maintain proper levels of documentation and contribute to documentation and accounting activities.
• Manage reporting and analytical support of customer BI needs including segment marketing, product & brand management, pricing, promotions, e-commerce, and customer relationship management.

Environment: MS-SQL Server, MS Office Suite, MS-Project, MS Excel, MS Outlook