SUMMARY:

• Around 8+ years of overall experience wif Business Intelligence Reporting and wif over four plus years of experience in Designing and Development of business intelligence application wif Qlikview as BI tool.
• More TEMPthan 5 years of experience in designing, implementing and maintaining Qlikview Applications wif comprehensive experience in planning, designing and building BI Dashboard and Analytics Reporting solutions.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview. Good at working wif Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Expertise in Installing and Configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Adept in reviewing and analyzing teh Business Processes, Business Process Flows &implementing QlikView Solutions.
• Excellent knowledge in designingand developing dashboards using QlikView by extracting teh data from multiple sources (Oracle, Flat files, Excel, Access)
• Extensive experience wif QlikView sheet objects like Straight tables, Pivot tables, Containers, Line charts and Bar charts, scripting and building qvd’s and qvw’s.
• Strong Knowledge on Qlikview Architecture such QVS, QVP, QVWS, QDS and QVW
• Strong Experience in working wif Charts( Pivot Tables, Straight Tables, Pie - Charts, Gauge-Charts, Trellis, Containers, Current selection box,Drill Down, Drill up & Cyclic Grouping, Table Boxes and Date Islands.) List Box, Input Field, Calendar.
• Good experience in Optimization of QlikView Dashboards wif a focus on Visualization, Usability, Performance, Long-term, Flexibility, Accuracy and Standardization.
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys in QlikView and designing an optimized Data model.
• Developed link tables, &incremental loadingOptimized Load & Binary Load on teh needed basis.
• Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, SnowflakeSchema, Fact and Dimensional tables, Section Access, Set Analysis in QlikViewandDW concepts.
• Good usage of SET ANALYSIS functionality in most of teh applications across different objects to achieve simple to highly complex KPIs.
• Proficient experience in working wif QlikView Functions and Expression Scripts and Streamlining Reporting operations of QlikView Applications
• Design of QlikView applications using QlikView Data(QVD) files, different Databases and creating reusable variables.
• Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications.
• Hands on experience working on teh Alternate states to do a comparative analysis and complex requirements of transitioning from one application to another application using Transfer State.
• Proven expertise in analyzing teh Business Intelligence needs of teh enterprise and building teh enterprise Reporting architecture.
• Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and Qlikview.
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Good knowledge of Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Excellent working knowledge on SSIS.
• Good working knowledge in Data Modeling including Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Good Knowledge on ETL tools like SSIS and Informatica Power Center.
• Extensive experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.

TECHNICAL SKILLS:

BI Tools: QlikView 9/10(SR3/4)/11.2(SR2), Tableau.

Data bases: Oracle9i/10g/11g, SQL Server, Teradata, MySQL, DB2

Database Tools: SQL * PLUS, Toad for Oracle Base (10.6.1.3)

ETL Tools: Informatica, Data Stage, Microsoft SSIS

Office Tools: MS Word, Excel, Access, Outlook,Power Point

Operating Systems: Windows/XP/2002/2003/7, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. QlikView Developer

Responsibilities:

• Requirements gathering, Impact Analysis and solution designing to incorporate teh Business requests.
• Understanding teh business functionality & Analysis of business requirements.
• Created dashboards which switch between applications, which is created using transition states.
• Enhancements to existing dashboards/analytics.
• Automated reloading process using windows Schedulers and Implementing teh Section access.
• Created QVD’s wif sub routines for ease of use
• Implemented SET Analysis for FISCAL Year calculations.
• Implemented D3 visualization in Qlikview
• Developed KPI’s and set analysis applications.
• Designing & Development of Analysis Reports, Charts, Scorecards, Dashboards
• Designing of Parameterize Reports wif conditional formatting, sorting, running totals, variables, collections/arrays, groups, group selection, and summary reports
• Unit Testing and Performance Tuning of all teh report in order to reduce teh execution time required for generating these reports and theirby improving teh overall speed of execution and performance of teh reports.
• Researched and fixed erroneous report calculations.
• Coordinate wif Production Support team to develop accurate documentation for production reports.
• Deploying teh code from Development environment to test environment and provide developer support for UAT teams till teh code moves to production.

Environment: QlikView 10/11.0/11.2, Hive, SQL Server, Informatica Power center, Toad /PLSQL Developer.

Confidential, Warren, NJ

Sr. QlikView Developer

Responsibilities:

• Understand Requirement, Analysing Systems and Source Databases.
• Data Modelling using Dimensional Modelling, Star Schema, Snowflake schema
• Implemented ADHOC and DYNAMIC Analysis for easier navigation to user.
• Created QVD’s wif sub routines for ease of use
• Implemented SET Analysis for FISCAL Year calculations.
• Automated reloading process using windows Schedulers and Implementing teh Section access.
• Implemented D3 visualization in Qlikview
• Designing & Development of Analysis Reports, Charts, Scorecards, Dashboards
• Designing of Parameterize Reports wif conditional formatting, sorting, running totals, variables, collections/arrays, groups, group selection, and summary reports
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Writing and tuning of PL/SQL code like Procedures, Functions, Database Triggers, Packages and SQL queries to improve teh application and reports performance.
• Unit Testing and Performance Tuning of all teh report in order to reduce teh execution time required for generating these reports and theirby improving teh overall speed of execution and performance of teh reports.
• Working on different Qlikview features features like linked objects, Associative search, Mekko charts, etc
• Strong understanding on BI architecture
• Maintain security and controls and access
• Maintain admin documentation
• Upgrade / Configuring of software
• Generate report of activity
• Creation of folder structures to standards
• Modified existing production reports to incorporate weighted average sales data.
• Created report context calculations to satisfy client's long-standing report requirement.
• Identifying feasible areas of project for improvement.

Environment: QlikView 10/11.0/11.2, Oracle, SQL Server, Informatica Power center, Toad /PLSQL Developer, SQL Loader and Sun Solaris.

Confidential, Pittsburgh, PA

QlikView Developer

Responsibilities:

• Involved in teh Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Understanding source systems and Designing Data Modeling and Loading data from Multiple Data sources.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Designed and developed extensive QlikView reports using combination of charts and tables.
• Developing Set Analysis to provide teh custom functionality in QlikView Applications.
• Installed, configured and deployed teh application on QlikView server and Imported data from different sources like SAP BW, Sales force, Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC
• Working closely wif teh Business users to get teh requirements for managing Qlikview Server and publisher.
• Extracted information from different data sources like Oracle, Teradata and flat files, etc…by using different scripts like add, concatenate, resident, qualify, unqualify, etc.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Writing and tuning of PL/SQL code like Procedures, Functions, Database Triggers, Packages and SQL queries to improve teh application and reports performance.
• Modifying existing PL/SQL code in Packages, database triggers, procedures and functions to add new functionality according to teh requirements.
• Participate in enterprise DW / BI strategy/Dash boarding.
• Involved in utilizing Qlikview solutions to develop complex reports and executive dashboard.
• Involved in administration using Qlikview server using Task Management, Resource distribution and Job Scheduling.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Involved in organizing meetings to know teh needs of clients for teh Enterprise solution Implementation.
• Involved in design and development of QlikView Platform integrated wif Expandable Databases
• Modified existing production reports to incorporate weighted average sales data.
• Created report context calculations to satisfy client's long-standing report requirement.
• Researched and fixed erroneous report calculations.
• Coordinate wif Production Support team to develop accurate documentation for production reports.
• Built and modified reports to enable manual and scheduled data refresh.
• Provided reporting training to development team and business staff.

Environment: QlikView 10 SR2 Desktop/11, QEMC, Teradata SQLConnector, Oracle 10G, Windows 7, Windows Server 2008, Teradata, Flat files.

Confidential . Auburn Hills, MI

QlikView Developer

Responsibilities:

• Requirements gathering, Impact Analysis and solution designing to incorporate teh Business requests.
• Understanding teh business functionality & Analysis of business requirements.
• Created dashboards which switch between applications, which is created using transition states.
• Enhancements to existing dashboards/analytics.
• Reports Validation against Database.
• Improved teh overall performance of teh application and redesigned data model applying QlikView performance tuning techniques
• SET ANALYSIS in providing custom functionality to QlikView Applications.
• Implemented & involved in Security Deployment of QlikView Applications.
• Trained End Users on Using QlikView Tools.
• Developed KPI’s and set analysis applications.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks
• Developed extensively Alerts, Variables, Input boxes and Calendars.
• Maintained both File and Data Level Security and implemented Data Reduction
• Involved in Performance Tuning & Deployment of QlikView Applications
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory
• Deploying teh code from Development environment to test environment and provide developer support for UAT teams till teh code moves to production.
• Identifying feasible areas of project for improvement.
• Preparing required documents related to teh project.

Environment: DB2, Qlikview 11, Microsoft Windows XP Professional, UNIX

Confidential, Dallas, TX

QlikView Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing teh QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Developed KPI’s and set analysis applications.
• Experience in Using QlikView Functions (Date and Time, Join, Mapping, String & input Fields etc...)
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load teh relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.
• Implemented Security & involved in Deployment of QlikView Applications.
• Created QVD’s& updated on timely basis as database updates.
• Developed ETL Scripts while loading teh data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to teh end users.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and QlikView.
• Trained teh end users TEMPeffectively to use teh reporting tool, to build and customize their ad-hoc reports.

Environment: QlikView 8.5/9, Oracle 10g, Access, .CSV Files.

Confidential,

SQL Developer

Responsibilities:

• Promote emphasis on tools and process to facilitate analytics
• Involved in teh development of system test plan which included scope, objectives, resources, timelines etc. of teh testing effort.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Analyzed teh reporting service tool provided by Microsoft to generate reports using Oracle and SQL as backend and developed a similar application wif SharePoint as backend.
• Handled unit and system integration testing
• Prepared a help guide to system usage for teh convenience of end users.
• Participated in meetings and Database Analysis wif Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Assisted teh PM in setting realistic project expectations and in evaluating teh impact of changes on teh organization and plans accordingly and conducted project related presentations.
• Developed Data Flow Diagrams, illustrating teh flow of data from teh legacy systems into teh Application database Tables, along wif checkpoints for testing / verification.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing. Developed user test cases and validated test results during user acceptance testing.
• Assured dat all Artefacts are in compliance wif Department’s SLC Policies and guidelines.
• Used Test Director for Defect Tracking and prioritizing defects and for enhancements after base lining teh requirements.

Environment: Oracle, SQL Server, Putty, SQL/PLSQL and Windows 2000.

Confidential

SQL Developer

Responsibilities:

• Involved in analysis, design and development of teh system.
• Created database Objects Tables, Indexes, Views, Synonyms
• Created stored Procedures, Functions, Triggers by generating teh specified reports.
• Tuning of teh SQL queries using Explain Plan, SQL*Trace ..
• Created teh database from full export for teh Table space point in time recovery.
• Modifying teh database design and structure, as necessary, from time to time upon information given by application users and developers.
• Implemented integrity Constraints on database tables.
• Involved in preparing documentation, Testing and debugging.
• Modified report wherever needed as per teh suggestions given by business analyst and Analyzed theexisting Actuate

Environment: Sun Solaris 7, Oracle9i, Oracle Enterprise Manager, SQL*LOADER, Erwin.