SUMMARY

• 7+ years of IT experience in Qlikview, SAP BO Business Intelligence, Decision Support Systems and Application Development.
• Expertise includes gathering requirements to fulfill business needs & delivering design documents for developing solution.
• Excellent knowledge in designing and developing dashboards using QlikView by extracting the data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensive experience with QlikView sheet objects like Straight tables, Pivot tables, Containers, Line charts and Bar charts, scripting and building qvd’s and qvw’s.
• Hands on Experience with QlikView Architecture in development and deployment.
• Proficient in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like Oracle, SQL Server, Web Services, SAP, Sales Force, QVD files, Access, text files, excel documents etc. as per the user requirement
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using QlikView.
• Experience with QlikView sheet objects including Pivot, List, Multi box, multiple charts types.
• Strong understanding of Dimensional Modeling technique, Multi - dimensional database Schemas like StarSchema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.
• Excellent analytical, organizational, planning skills with demonstrated abilities in & mentoring the team towards achieving organizational goals.
• Experience with complex BI application environment comprised of multiple / inconsistent data sources.
• Job roles include gathering business requirements from the customers, establishing functional specifications and translating them to design specifications.
• Created data models for power users to create their own ad-hoc queries.
• Expertise in working with relational databases such as Oracle 11g/10g/9i, SQL Server 2000/2005, DB2 8.0/7.0.
• Written SQL queries to test the OLTP & OLAP Databases based on changes of the functionality.
• Experience in requirement gathering and gap analysis, Design, Application Development, Testing, Implementation and Support.
• Involved in preparing Software Requirement Specification, Technical specifications, and design documents viz. Low level design, impact analysis documents, System Architecture Document
• Team oriented individual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.
• Excellent communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure.

TECHNICAL SKILLS

BI Tools: Qlikview 11/10, SAP BO, SAP HANA and analysis 9.x/11.x.

Databases: Oracle, SQL Server, Teradata, DB2, SAP HANA and MS Access.

Tools: Toad, SQL developer.

Languages: SQL, PL/SQL, T-SQL, C, C++.

Scripting Technologies: UNIX.

Additional Skills: Data Analysis.

Data Modelling: Erwin, MS VISIO

ETL: Informatica, ODI

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Qlikview Developer/ BI Consultant

Responsibilities:

• Interviewed users to identify problems, reporting requirements and problems in existing systems design.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Identified various KPI’s with businesses users and analyzing existing Business Objects Reports.
• Generated new QVD files from the EDW by writing scripts in QlikView applications.
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Extensively worked on Qlikview Set Analysis.
• Created batch scripts to process the data periodically as per the business requirements.
• Applied metrics in the data via Qlikview scripts and transformed QVDs to cater the business needs.
• Designed and Developed Qlikview dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements.
• Created batch scripts to process the data periodically as per the business requirements.
• Published Client application using Qlikview Publisher and rolled out to Access point and administered security using Active Directory technology/Access DB integration.
• Scheduled and managed Qlikview jobs using Qlikview Scheduler for Qlikview application dashboards.
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources.
• Involved in performance tuning to optimize the functionality of dashboards.
• Provided production support to the existing Qlikview applications.

Environment: Qlikview, Oracle 11g, TOAD, Business Objects, Erwin Data modeling

Confidential, Columbus, OH

Qlikview Developer/ BI Consultant

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data Specifications about the financial systems.
• Analyzed the Infrastructure, ETL processes including staging areas, log tables, job schedule time and generated Reports.
• Developed Drill Down through Dashboard reports which enabled users to drill between Summary to detail Web reports, templates and personalization.
• Designed and developed the Data mart for the QlikView dashboards in star schema/snow-flake schema.
• Identified various sources and designed the data transfer and transformations with in QlikView.
• Creation of reports using reports and charts as per the customer requirement depends on Quarter, monthly And analyzes the report with charts provided by Qlikview.
• Developed SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Implemented Section access and Hidden scripting for the Application Security.
• Created User Conditions and Filters to improve report generation & readability and SQL tuning of report and displayed the summary of data by creating Charts by using QlikView.

Environment: Qlikview 10(SR4), Oracle 10g, SQL server, Access DB, SQL developer.

Confidential, NJ

Qlikview Developer/ BI Consultant

Responsibilities:

• Qlikview designing and modeling using multiple data sources relational designs.
• Designing Qlikview document/user setting, layouts to make consistent and professional optimized look to clients.
• Involved in Performance tuning at database level, Script level and Application level.
• Qlikview Administration - Creating scheduled jobs for QVD extracts and report plus reloads.
• Gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and Subject matter Experts (SMEs).
• Converted the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Involved in the developing of star schema and snow flex schema dimensional data model.
• Developed KPI’s and set analysis applications.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Performed optimization of the QlikView Application by removing unnecessary fields, avoiding complex joins, avoiding date functions, avoiding conditional functions inside the application using mapping load.
• Follow a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensures that critical requirements are not missed.

Environment: Qlikview, Oracle 10g, SQL Server, PL/SQL, SQL*Plus, SQL Developer, MS Access.

Confidential

SQL Developer

Responsibilities:

• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Creating and Debugging of Packages and Procedures & Functions and troubleshoot jobs using the debugging tool.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Involved in Analysis, Coding, Testing and Implementation of various modules and reverse engineering of the application using Erwin.
• Used Erwin to transform data requirements into data models.
• Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data by using SQL* Loader to custom tables.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• Used Oracle Enterprise Manager, TOAD for developing and managing pl/sql scripts.

Environment: Oracle 11g, Pl/Sql, SQL *Plus, TOAD, Oracle Forms 6i, Oracle Reports 6i, Ms Excel, SQL*Navigator, Power Builder, shell scripting.