PROFESSIONAL SUMMARY

• Over 8+ years of IT experience with more TEMPthan 4 years of experience in Designing and Development of Business intelligence application with QlikView.
• Ability to offer end - to-end solution starting from requirement gathering, design, development & deployment of Business Intelligence applications.
• Developed Proof of Concept for Customers.
• Experience with 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.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading teh data, resolved Circular Relationships, Synthetic Keys.
• Expertise in Creating Dashboards using QlikView 11.0, 11.2 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per teh user requirement.
• Strong Experience in Extract, Transform & Loading data in QlikView Applications & Develop Data models using Star Schema & Snow Flake Schema’s.
• Developed QlikView Macros/ Triggers in customizing applications.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and QlikView.
• Excellent working noledge in Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Expertise in optimizing, debugging and testing SQL queries.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• Attention to detail & ability to work in a pressurized time sensitive environment.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView 9.0/10/11/11.2

Languages: SQL, PL/SQL, C, Java

Database Technologies: Oracle SQL Developer, Oracle11g/10g, MS SQL Server 2012/2008, TOAD

Operating Systems: Windows 7/8, Windows XP, UNIX

Domains: Manufacturing, Finance, Social Media and Communication

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions tables, Physical and Logical Data Modeling.

Others: MS Access 2013, MS-Excel 2013,MS Power Point, MS Word.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta,GA

QlikView Developer

Responsibilities:

• Analyzed requirements and gatheird data for designingQlikViewapplications.
• Involved in gathering data from sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Proposed and created new business analysis for data, which has no prior reports.
• Experience in creation of QVD's for theQlikViewapplications following two-tier architecture.
• Wrote, Edited and Debugged ETL Scripts for data cleansing, resolving synthetic keys & circular loops.
• Monitoring of teh QVS, QVW's and user accounts for teh usage of teh applications.
• Created User-friendly Interactive Sheets & Reports as per teh business needs and requirements.
• Created KPI's and set analysis applications, according to user needs.
• Designed and developed different types of charts Bar charts, Straight Tables, Pivot Tables, Pie charts and Radar charts etc.
• Used different functions such as counter, date and time, conditional, aggregation functions etc., for data transformation.
• Created different types of sheet objects like List boxes, Buttons, Multibox etc.
• Performance tuning by analyzing and comparing teh turnaround times between SQL andQlikView.
• Sound noledge of various functions ofQlikViewtechnology.
• Installed IE plugins and trained teh end users to use teh reports TEMPeffectively, to build and customize their ad-hoc reports.
• Assisted teh end users if their were any problems very TEMPeffectively and efficiently.

Environment: QlikView 11/11.2, Oracle 10g,SQL Server 2005, MS Access, MS Excel, .CSV Files, Windows XP.

Confidential, Cleveland, OH

QlikView Analyst / Developer

Responsibilities:

• Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using QlikView 11.
• Enable teh features dat are requested by teh clients and make them understand teh new features.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, charts and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developing ad-hoc reports to see how revenue, cost and gross profit are doing against forecast budget and actual.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved teh loops issues.
• Gatheird & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g,.CSV and excel files).
• Implemented Incremental Load to improve Load Time.
• Tested Applications, ensuring teh application met teh requirements, Data quality for QualityAssurance before delivering to teh end users.
• Installation/Configuration of QlikView 11.
• Working noledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Participated in teh UAT process along with business users.
• Supporting multiple clients and responsible for ad-hoc queries which are raised by client.
• Creating client setup on server for different clients and providing teh access to teh users,distributing teh application.
• Responsible for post-production support and maintenance.

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

Confidential, Newark,New Jersey

QlikView Consultant

Responsibilities:

• Gatheird teh required data to designQlikViewapplication from teh scratch and analyzed business requirements.
• Dealt with many data sources such as QVD files, Excel & Oracle in developing theQlikViewData Models.
• Designed and developedQlikViewDashboards using Chart Box (Drilldown & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Created variables and applied them to sheet functionality.
• Knowledge and experience in UsingQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc.).
• Dashboard analysis portfolio by profit low to high and doing research for poor performance for revenue growth.
• Developed User Interactive Sheets & Reports as business needs.
• Designed proficient dashboards according to teh requirements
• Established a secure environment using QlikView Section Access.
• Wrote SQL Scripts to load teh relevant Data inQlikViewApplications.
• Used SET ANALYSIS to provide custom functionality inQlikViewApplications.
• Applied Security & involved in Deployment ofQlikViewApplications.
• Created QVD's & updated them on timely basis as database updates.
• Developed and debugged ETL Scripts while loading teh data to resolve loops.
• Used to solve teh issues related to teh end users.
• Communicated and trained teh end users TEMPeffectively to use teh reporting tool, to build and customize their ad-hoc reports.
• Drill Information by creating Groups in QlikView.

Environment: QlikView9, Oracle 10g, Access, .CSV Files, Windows 2003 Server / XP.

Confidential, Jacksonville,Florida

QlikView Developer

Responsibilities:

• Finding and Understanding teh essential data, eliminating teh data which doesn't suit teh requirement.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging teh basic components of QlikView.
• Creating teh data model with necessary fact and dimension data.
• Created a standard template for teh dashboard.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, IncomeStatement, Bad Debt and Payment Reports in response to user needs.
• Created analytical expressions for teh different KPIs used in teh dashboard.
• Performed analysis, documentation, for calculation for various attributes.
• Worked on Automation & scheduled QVW document refreshments.
• Promoting dashboards to production environment, Scheduling and Distributing through QMC and manage user access.
• Involved in working with Server, Publisher and Application Deployment.
• On demand reload facility for teh users to reload teh data when needed to view in report.
• Performed testing of dashboards for functionality, data and worked with QlikView administrator to optimize QlikView performance.
• Involved in teh Unit Testing and validation of data on QlikView Applications.

Environment: QlikView, Excel, MS SQL Server, Oracle 11g, PL/SQL.

Confidential, California

SQL Business Intelligence Developer

Responsibilities:

• Importing data from across teh using Microsoft BI tools such as SSIS/SSAS.
• Taking ownership of teh development, delivery and management of BI reports utilising SQL and Microsoft SSRS.
• Working through teh entire data/report development lifecycle.
• Being involved in teh requirements gathering, ensuring dat teh data/reports offer value to teh customer.
• Owning teh quality of teh data/reports and content to ensure customer satisfaction and corporate standards.
• Maintaining and managing changes to data/reports and any other issues.
• Transitioning current manual Excel-based reports, increasing automation of reporting.
• Reduction of administrative burden in report production
• Supporting teh data quality and governance processes by proactively monitoring teh quality of teh data, developing data quality metrics and scoring, dealing with teh business and technical teams on issues identified.
• Accountable for developing reporting, and reporting strategies for both internal and external client needs using various technologies, eg. SSRS, SQL grid reports, etc…
• Responsible for design, development, maintenance and optimization of various reporting data sources, including OLAP cubes (SSAS) and views of data on both data warehouse and OLTP.
• Coordinate with other team members and write necessary produce ETL, load data warehouse using SQL and SSIS technologies, as needed.
• Develop a repeatable and high quality release management process for reporting.
• Perform support for existing reporting solutions, as needed.
• Tune and troubleshoot stored procedures to ensure prompt return of accurate data to customers.

Environment: SQL Reports / Excel Reports, SQL / SharePoint / SSAS / SSIS / SSRS, WindowsXP,SQL Server 2008

Confidential

SQL/PL-SQL developer

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of teh ETL process, automate teh process of loading, pulling teh data.
• Teh EDW project aims at developing an Enterprise Data Warehouse for teh claims Department.
• Teh project was designed using SQL, Pl/SQL, SAS, Mainframe, Teradata, and Oracle.
• Developed Test Plan, Test Strategy and Testing Scope Document.
• Analyzed teh use cases given by teh business analysts and developed test cases using them.
• Worked with teh team lead to coordinate teh test case turnover process proceeding each cycle and selectively executed teh test cases to verify dat they are kept current.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement teh requirements.
• Performed manual testing on various modules of teh Application.
• Generates functional test cases dat capture actual code behavior as a deployed application is exercised.
• Executes teh test suite to identify regressions and unexpected side TEMPeffects.
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources).
• Monitors test coverage and achieves high coverage using branch coverage analysis.
• Tests individual methods, classes, or large, complex applications.
• Tracks how test results and code quality change over time.
• Conducted performance and load testing using Load Runner.
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to teh QA lead, provided test summary report once project was fully completed.

Environment: MS-Office Tools, Informatica 6.1, SQL, PL/SQL, UNIX, Shell Scripting, Manual Testing, Test Director, DB2, Oracl