SUMMARY

• 8 years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and business Intelligence (BI).
• 4+ years of experience in Designing and Development of Business intelligence applications with QlikView 11.2/10.0/9.0 as BI tool.
• Ability to offer end - to-end solutions starting from requirement gathering, design, development & deployment of Business Intelligence applications.
• 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 the 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 dashboards as per the user requirement.
• Strong Experience in Extract, Transform & Loading data in QlikView Applications & Developed 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.
• Excellent analytical, co-ordination, interpersonal, organizational and problem solving skills, ability to adapt, learn new technologies efficiently and effectively.
• Experience with Oracle Application Modules - Account Payables, Order Management, Purchase Order, Account Receivables, General Ledger.
• Experience in project coordination, User Acceptance Testing (UAT), Integration test planning, business end-to-end testing, end-to-end project delivery
• And refinement and enhancements in an environment with various iterative models within the stipulated time, resources and cost constraints.
• Attention to detail & ability to work in a pressurized time sensitive environment.
• Expertise in optimizing, debugging and testing SQL queries
• Created the QVD Library, which will provide information about all QVD's on Server like Source QVW, Record Count, Fields in QVD.
• Have knowledge in the ETL tools, IBM Data stage and Informatica.
• Experience on Oracle9i and PL/SQL Programming.
• Expertise inQlikView11.0 SR1/10.0 SR3 installation and upgrading existing version.
• Expertise in designing inQlikViewwith complex multiples data sources (SQL, Oracle, Flat Files) relational designs and optimizing applications by using QVD's, removing non key fields and script variables (Loading phase).
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Good communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Proficient in managing the entire application development operations involving requirement gathering, Development of functional specifications, design & development and co-ordination with customer Domain expertise includes Banking, Insurance and Healthcare.
• Well versed in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysisand familiar with HTML, JAVA, ASP, OOPS, UNIX.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven.
• Excellent technical, analytical, and problem solving skills. Strict attention to detail and ability to work independently as well as within a team environment.
• Excellent written, oral communication and interpersonal skills.
• Strong experience in writing SQL Queries, views and stored procedures.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView 9.0/10/11/11.2 Qlik Sense, OBIEE 10g

Languages: SQL, PL/SQL, C

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, Newtown Sq, PA

QlikView Developer

Responsibilities:

• This QlikView Project is for Finance Department, which includes Bookings, Revenue, Cost and Gross Margin.
• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Multiple levels of Hierarchies are implemented such as Sales, Product, Bookings, Customers and Service Hierarchy etc.
• Providing executives and operational users with powerful analytic capabilities and detailed information on their operational and marketing performance.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• The application is used by 20 CAL licensed user, with additional session licensed users.
• Task set up are done using QEMC and created architecture for the interdependent applications and execute in proper order.
• Ad hoc excel reports are created based on the business user requirements.
• Forecasting model is created by using booking, revenue applications and created 4 year Forecast model and successfully implemented in QlikView.
• Application size is 169MB, with 178 demographic fields, 5 million rows of Bookings data, associated with 95% data density.
• Created Heat map with alert mechanism. Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• Document event trigger and field event triggers is created. Incremental reloading is implemented
• Created Document for the project planning and production Interface Documentation.
• Four dashboards were created, along with helping other team to create Qlikview reports.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Environment: Windows 2000 Server, QlikView 11.0, Oracle 11g, SQL Server 2005, SAP,MS Office.

Confidential, Gaithersburg, Maryland

Business Intelligence Developer - QlikView/Tableau

Responsibilities:

• Designed and enforced enterprise strategy design for data marts, data warehouse, ETL, to leverage and visualize data to knowledge for the multi-site enterprise.
• Lead cross-functional teams to design, build, test and deploy complex analytical solutions utilizing Qlikview.
• Demonstrated proficiency with Qlikview Scripting, stored procedures, use of complex Qlikview functions, experience with complex data models and optimization of data model for query performance to create QlikMarts.
• Strong knowledge of Qlikview SBS and Qlikview Enterprise architecture and building Qlikview reports by applying user preferences, business rules and database modeling methods and validations.
• Skilled in data visualization with an eye to simple and clear front end design - Familiarity with all visual options available, create complex visualizations for dynamic aggregation, Actions and Triggers.
• Good understanding of graphic design concepts.
• Active team player, process driven, self-motivated and able to work independently to meet deadlines.
• Strong knowledge on Qlikview server architecture and building QVD, QVW and applying business rules and data validations.
• Strong knowledge of SQL and databases.
• Experiencing sourcing data from disparate systems with a good understanding of their Data Models and ETL procedures.
• Work with project manager to ensure technical execution risks & issues are captured and mitigated.
• Performed GAP Analysis/Impact Analysis as Confidential was changing their vendor from RxCrossRoads to CareMateX.
• Performed field to field mapping for RxCrossRoads and CareMateX.
• Performed Reverse Engineering to identify Key Metrics utilized for development of Qlikview Dashboards.
• Developed Combiner to combine data from History data warehouse and current datamart.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users.
• Efficiently used parameters, sets, groupsandcalculationsin worksheets and dashboards.
• Involved in creating adual-axis and dual mapswith multiple measures.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Tableau server to publish dashboard to a central location for I & I portal integration
• Created visualization for logistics calculation for Spend Transparency.

Environment: QlikView 11.2, QMC, SQL Server 2008, Tableau Desktop 7.0 & 8.1 to 8.3 Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel, MS BI Windows 7, Windows Server 2008, MS Visio.

Confidential, Cleveland, OH

QlikView Analyst / Developer

Responsibilities:

• Delivered advanced/complex reporting solutions such as Dashboards and Standardized reports utilizing QlikView 11.
• Enable the features that were requested by the Business Process Owners and also train them in better understanding of 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.
• Developed ad-hoc reports to see how revenue, cost and gross profit are doing against forecast budget vs actual.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Implemented Incremental Load to improve Load Time.
• Read and gathered QlikView Planning requirements.
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering it to the end users.
• Installation/Configuration of QlikView 11.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Participated in the 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 the access to the users, Distributing the application.
• Responsible for post-production support and maintenance.

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

Confidential, Mt.Laurel, New Jersey

QlikView Consultant

Responsibilities:

• Gathered the required data to designQlikViewapplication from the 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 the requirements
• Established a secure environment using QlikView Section Access.
• Wrote SQL Scripts to load the relevant Data inQlikViewApplications.
• Developed Macros, 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 the data to resolve loops & ambiguity joins.
• Used to solve the issues related to the end users.
• Communicated and trained the end users effectively to use the 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

SQL/PL-SQL developer and ETL 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 the ETL process, automate the process of loading, pulling the data.
• The EDW project aims at developing an Enterprise Data Warehouse for the claims Department.
• The project was designed using SQL, Pl/SQL, SAS, Mainframe, Teradata, and Oracle.
• Developed Test Plan, Test Strategy and Testing Scope Document.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that 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 the requirements.
• Performed manual testing on various modules of the Application.
• Generates functional test cases that capture actual code behavior as a deployed application is exercised.
• Executes the test suite to identify regressions and unexpected side effects.
• 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 the 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, Oracle