SUMMARY:

• 9+ years of IT industry experience in Business Intelligence and Business Analysis with full project lifecycle implementation, including Requirements Gathering, Prototyping, Design, Development, Testing and Deployment.
• 4+ years of extensive technical experience in all aspects of Qlikview Development
• Data Modeling, Scripting, UI Design and Development.
• Optimization of existing QlikView reports with a focus on usability, performance, flexibility, testability and standardization.
• Administration and Maintenance of QlikView for OLTP and OLAP Systems.
• Proficiency in QV data modelling using Star Schema and Snow Flake Schema, creation of QV objects, reports, graphical interactive UI and dashboards using different data sources like Oracle, SQL Server, QVD files, Access, text files, excel documents etc. as per the user requirement.
• Functional experience in Asset Management, Retail Management and Internet domains.
• Good communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Excel at communicating with business users in understanding and analyzing requirements and providing accurate reporting of ongoing projects and initiatives.
• Negotiated with business and offshore resources with respect to timelines and project deliverables. Extensively worked with teams in an onshore - offshore model, effectively mentored onsite and offshore junior team members and developers.
• Organized and result-oriented team member with track record of completing projects on time.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers.

TECHNICAL SKILLS:

BI Tools: QlikView Desktop (9/10/11), QlikView Server (9/10/11), QlikView Publisher, Qlik Sense

Programming Languages: HTML, CSS, JQuery, JavaScript, Flash

Operating System: Windows 2K/XP/Vista/7/Server2003/2008, LINUX

Databases: SQL Server, MS-Access, MySQL

MS Office: MS Project, MS Visio, MS Word, MS Excel, MS PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Sr. Qlikview Developer

Responsibilities:

• Interacting with end users to gather functional requirements and customize QlikView dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting QlikView applications.
• Worked on Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access and Set Analysis in QlikView
• Worked closely with Business to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
• Designed and developed the Qlik Sense App development/Data model to support the business.
• Worked on implementing improvements and optimizations of QlikView environment.
• Responsible for managing QlikView servers and administration of users and applications, troubleshooting and corrections in operating procedures, logs and other parts that belong to the QlikView environment.
• Hands of experience on QlikView Enterprise Management Console (QEMC) and QlikView Management Console(QMC)
• Deployed and maintained the QV Applications/Dashboards to the Development, Test, UAT and into Production environment alongwith production support
• Trained the end users effectively to use the reporting tool, to build and customize there ad-hoc reports.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• Designed and Developed QlikView reports, dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar meeting the business requirements.
• QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front- end, improving layout structure.
• Actively participated in the design, architecture and development of user interface objects in QlikView™ applications.
• Worked on data modeling and developed different complex models as per given user requirement by eliminating circular loops, Synthetic tables and ambiguous relationships.
• Extensively implemented incremental loading, so loading performance increases. Followed 3-tired QlikView Data architecture while performing ETL (Extraction Transformation and Loading).
• Helped end users to design test cases and worked through multiple UAT cycles.

Environment: QlikView 10/11, QlikView Server and Publisher, SQL Server 4.0.3, Windows 2008 Server.

Confidential, Jersey City, NJ

QlikView Developer

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Involved in developing Dashboard standards such as Template designs, User Interface and Navigation Design patterns.
• Developed different dashboard with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Extracted information from different data sources like Teradata, SQL Server, MS Access and flat files, etc. by using different scripts like add, concatenate, resident, qualify, unqualify etc.
• Used Incremental loading to handle large volume delta loading to reduce reload time and have a cumulative data for the dashboard.
• Coordinated with Database and ETL teams for Data and Structural follow-ups and Design.
• Implemented Section Access to filter data based on Document Level, Sheet Level and Data Level depending upon user privileges.
• Created publisher tasks for PDF Distribution, Loop and Reduce for Data Reduction.
• Written QlikView Macros to achieve functions such as Copy Objects to Office documents, Screenshot of Dashboards to Email Body and PDFs etc.
• Involved in multiple phases of project like Requirement gathering, Resources evaluation, Designing, developing, application-testing, bug-fixing, UAT and end-user training.

Environment: QlikView 10/11, Oracle 9i/10G/11G, SQL Server 2005, Windows 2003 Server.

Confidential, Irvine, CA

QlikView Developer

Responsibilities:

• Interacted with End Users and Documented the Requirements.
• Developed various internal prototypes for acceptance testing.
• Played a part a Business support solution provider and closely work under the environment of WAR room meeting, complete brain storming.
• Connected to multiple data sources such as Oracle, DB2, Flat files, Excel Spreadsheet’s and prepared close to business requirement like model. (Especially star model and snowflake).
• Used QlikView direct discovery along with Document chaining to fetch on-demand report from linear database after creating View inside the database to protect performance from huge data loading during mass data accumulation due to Granular data fetching.
• Implemented 3-Layer architecture, Binary loads and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards.
• Incorporated necessary log files and failure mailing mechanisms for smooth day to day operations.
• Worked on data model according to the user requirement and successfully created an optimized QlikView application.
• Developed reports / KPI’s for Supply Chain mechanism, including supply demand GAP and self-life stock monitoring reports.
• Developed dashboards and KPI’s using set analysis, variable creation etc. for individual payroll details, comparison with peer and comparison with the market.
• Performed testing of dashboards for functionality, data, performance, and UI design.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality through QV Publisher.

Environment: QlikView 11/10, Oracle 9i/10G/11G, SQL Server 2008, Access, CSV Files, Windows 2008 Server, SharePoint.

Confidential, Memphis, TN

Business Analyst

Responsibilities:

• Involved in gathering requirement from Business Users and Developed Technical Documentation for the Business and Team.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Worked in association with Internal Teams and Business Partners in researching suitable technology platform to
• Gained control over the expectations of the Development Team, Testing Team and Deployment Team and work
• Built a Professional Relationship with Team Members inside and outside the project to enhance the productivity of the work with management to show day-to- day project progress enhance business process
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Resolved issues resulting from User Acceptance Testing (UAT).

Environment: QlikView 9/10, Oracle 10g, SQL Server 2008, Access, MS Excel, XML Files, Windows 2003 Server, SharePoint

Confidential

Business Analyst/Project Manager

Responsibilities:

• Gathered, Detailed and Documented requirements related to online sales and Distribution of different products in order to develop Marketing Websites
• Facilitated with team of two business analyst to elicit requirements in Joint Application Development (JAD) sessions by communicating with various background and skills, documented Scope Definition, Functional Specifications, Use Case document, Software Requirements Specification (SRS) and created User Interface Mockups/Prototypes using Ms Visio.
• Performed the full spectrum of Web-related tasks, including rapid prototyping, design and layout, graphics creation and optimization, standards-compliant HTML and CSS, testing, training, hosting, security, traffic generation and ongoing updates.
• Maintained project plans, task, defect and issues lists, lead meetings to discuss all aspects of the project’s execution, developed test scripts, executed UAT, participated in the QA process, and developed training materials and system documentation.
• Designed different types of triggers at the sheet level and document level of dashboard.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Developed test scenarios and implemented test plan. Assisted in testing the application and
• Setup Mercury Quick Test Pro to Regression test functionalities of the ecommerce portal
• Configured Mercury LoadRunner, developed scripts and executed these scripts to load test the ecommerce portal
• Performance tuned SQL queries to improve build process on large amounts of data. Also helped business to improve the adhoc sql process retrieval time.
• Configured UI, transaction flow and business rules on JDA Win/DSS as per specifications provided by business users

Environment: Microsoft Suites (Word, Excel, PowerPoint, SharePoint, Visio) HTML, CSS, MySQL, Web Forms, JavaScript, PHP, Adobe Dreamweaver, Microsoft FrontPage, Adobe Photoshop, JDA, Windss, Magic (CRM application), LoadRunner

Confidential

Business Analysts/Project Coordinator

Responsibilities:

• Led requirement gathering and documentation for Project Charter, Business Case, Business Requirements, Business Rules, and Functional Requirements, Supplementary Specifications, Activity diagrams, Use Case diagrams and process flows
• Facilitated business requirements gathering sessions with the client, and overlooked the creation of Use Cases/Activity Diagrams, Functional Specifications using UML/Visio.
• Utilized Agile methodology to configure and develop process, standards, and procedures
• Generated MIS for M-Xtasy World (Customer Loyalty Program) of Planet M & Data Analytics for the same including RFM
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based Business Requirements, technical specifications and/or product knowledge.
• Used MS Office suite (Word, Excel, Access, Visio, Power Point, Outlook, and Project) for project tracking, documentation, and presentation to senior management.
• Extensive Business Process Modeling. Authored detailed business process documents to document existing business process and developed efficient to-be business process models.
• Customized UI and workflow on Retail Pro software as per specifications provided by business users
• Created career application web form using HTML, JavaScript
• Involved in integration of the Retail Pro software with payment gateway
• Key achievements: Successfully configured Retail Pro third party software without prior knowledge or training of the tool. Was given additional responsibilities of managing the portal team and MIS reporting within one year.

Environment: MS Visio, DreamWeaver, SQL, PLSQL, XML, VB, ASP, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner HTML, CSS, Adobe Dreamweaver, Microsoft FrontPage, Adobe Photoshop, RetailPro, Magic.