SUMMARY

• Over 7+ years of professional experience in Information Technology with extensive experience in the field of Business Intelligence (BI) leveraging QlikView/BO for various domains like Finance, Banking, Healthcare and Insurance sector.
• Over 3+ years of experience in Designing, developing and deploying of QlikView, 3+ years of experience on SAP Business Objects Reporting Tool.
• In Depth Knowledge in Requirement Gathering, Designing and Data - Modeling for QlikView Dashboards.
• Expert knowledge in Data Visualization and User Interface.
• Implemented Incremental Loading for various projects using the QVD Files (QlikView Data Files), which would make the QlikView Dashboards to work efficiently.
• 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.
• Experienced in implementing Incremental Loading for various projects using the QVD Files (QlikView Data Files) which would make the QlikView Dashboards to work efficiently.
• DevelopedQlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Developed KPI’s and set analysis applications.
• Experience in UsingQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc).
• Developed User Interactive Sheets & Reports as business needs.
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Strong experience in full life cycle project design and development implementing Siebel Analytics.
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Strong experience in full life cycle project design and development implementing Siebel Analytics.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• 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

OLAP: QlikView 9/8.5/ QEMC /10(SR3/4)/11

ETL Tools: Informatica Power Center

Databases: SQL SERVER, MS Access, MS Excel & .CSV Files

ERP: SAP ECC 6.0, R/3 4.7/4.6x, Siebel CRM

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

Operating Systems: Windows XP/00/NT/98/95, Unix

Web Technologies: HTML, DHTML and XML

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

QlikView Developer

Environment: QlikView 10(SR4), QlikView Server and publisher, Oracle 11g, SQL Server

Responsibilities:

• Involved in analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies and related interfaces.
• Involved in installing the latest versions of QlikView, recently migrated from QlikView 10 to QlikView 11 SR2 Release.
• Designed and developed business intelligence solutions usingQlikView.
• Developed QlikView Dashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, Container, etc.,
• Implemented security anddeployedQlikView Applications.
• Created dashboards style of reports using QlikView components like Slider, Buttons, Charts and Bookmarks.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping)
• Developedlinked tables andsolved loops issues.
• 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 Loan Revenue Tracking, Portfolio Risk, Number of New Loans and Loan Type, Total Processing Costs, Non-performing Loans, 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 data sources 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 List Boxes.
• 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.

Confidential, Reston, VA

QlikView Consultant

Environment: QlikView 9/QEMC, Oracle 10g, SQL*Plus, SQL Developer, .CSV files, MS Excel

Responsibilities:

• Involved in analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies related interfaces and data visualization
• Designed and developed business intelligence solutions usingQlikView
• Involved in gathering customer business and technical requirements and write high-quality requirements documents.
• Performed comprehensive BI and DWH systems evaluations and wrote testing documents.
• Involved in Implementing and integrating BI and ETL software platforms into a customer’s environment
• Developed QlikView (dashboards, reports etc), analyzed the Data and involved in gathering requirement.
• Partnered with the QlikView team in gathering and analyzing business requirements from various sources, ensuring the business needs and delivery feasibility.
• Created Dashboard of reports usingQlikViewcomponents like List Box, Slider.
• Developed Variables, Input boxes, calendar & Macros.
• Developed Linked Tables, Concatenation and solved the loops issues
• Designed rank, Exceptional reports according to the customer needs.

Environment: QlikView 9/9.5, Oracle 10g, SQL*Plus, SQL Developer, .CSV files, MS Excel

Confidential, Minneapolis, MN

QlikView Consultant

Responsibilities:

• Involved in performing detailed analysis of source systems and source system data and modeling that data in QlikView.
• Involved in Designing, developing, and testingQlikViewscripts to import data from source systems.
• Involved in Designing, developing, and testingQlikViewdashboards to meet customer requirements.
• Involved in creating and maintaining technical design documentation.
• Developed QlikView (dashboards, reports etc), analyzed the Data and involved in gathering requirement.
• Partnered with the QlikView team in gathering and analyzing business requirements from various sources, ensuring the business needs and delivery feasibility.
• Developed analytical dashboards and reporting that meet customer requirements.
• Worked with client staff to enable them to utilize theQlikViewapplications.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting usingQlikView.

Confidential, Hauppauge, NY

Analytics Developer

Environment: Siebel Analytics 7.7.1, SQL Server, Oracle9i and Windows NT.

Responsibilities:

• Installing Siebel Analytics and configuring the connection parameters with SQL Server, Oracle9i.
• Developing the prototype subject area and sample reports to demonstrate the capabilities of Siebel Analytics
• Map Dashboard field requirements to Siebel OLTP/OLAP Physical/Business Model.
• Perform Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions,
• Create Snowflakes and Star Schema to perform data modeling for proposed architecture.
• Proposed/Recommended design alternatives to confirm to the business requirements, Interact with Business Owners/end-users.
• Involved in the full life cycle implementation of Invoices Tracking Analytics
• Application used by Accounting Team to monitor the invoices made to Point-of-Sale (POS) customers, Commercial / Business customers and third-parties.
• Interacted with Billing and Account Receivables Subject Matter Experts (SME), Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements.
• Created materialized views to fasten slower queries with complex joins in them.
• Identify Data Sources (Siebel & Enterprise DW) & Extension columns - Identify Siebel OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP’s Physical layer tables/schemas.
• Design & Develop Siebel Dashboards.
• Established access rights for pages in the Dashboard for different user groups
• Performed custom formatting with html tags in Dashboard
• Create/Modify Metadata repository (.rpd) as per the data requirements by using Siebel Analytics Server Admin tool.
• Build Repository at 3 layers - Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping)
• Presentation layer level (create presentation catalogs), create presentation folders, test and validate the model.

Confidential

Technical Engineer (Business Objects)

Environment: Oracle 9i, Business Objects 6.5, Web intelligence, Info view, Informatica, Teradata.

Responsibilities:

• Development of Full Client and Web-Intelligence reports.
• Created various standard reports and queries based on the existing classes/objects.
• Imposed several Filters, and sorting to restrict the unwanted data and highlight the required data.
• Designed reports containing complex charts to present the end users with a better graphical representation of the data.
• Created sections report which provides graph for each section.
• Created report with a nested conditions, slice and dice.
• Involved in designing of universe using the designer Module in Business Objects.
• Created classes with Dimension, Detail & Measure Objects.
• Created user prompts and Conditions.
• Created section report which provide graph for each section.
• Created reports with nested conditions.
• Created various standard reports and queries based on the existing classes/objects.
• Imposed several Filters, sort, breaks and Alerter to restrict the unwanted data and highlight the required data.
• Exported the universes to the Repository to make resources available to users