SUMMARY:

• 8+ years of experience in Architecture, Development, Deployment, Upgrade and Production Support of information delivery systems with extensive focus on Business Intelligence using QlikView 12 x, 11 x/10 x/9 x as BI tool.
• Proficient in understanding the business community and translating the requirements into functional and technical specifications
• Strong knowledge in D Confidential Modeling, D Confidential Mart and D Confidential Warehouse and Implementation of QlikView for providing Business Intelligence Reporting Solutions.
• Extensive experience in developing different analytical applications using QlikView suite of Products (QlikView Developer, QlikView Server, Publisher and QlikView Enterprise Management console).
• Strong Skills in D Confidential Modeling (Star Schema, Snow Flake Schema) & Loading d Confidential from multiple d Confidential sources.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Strong Experience in Loading D Confidential using Scripts like automate QVD’s, Calendar Object, custom scripting to implement SQL Functionalities.
• Extensively worked on developing Dashboards, Analytics, and Metrics using Performance Management and QlikView Enterprise.
• Hands on experience installing & configuring QlikView Server & Publisher in both clustered and non - clustered environments using different types of load balancing techniques.
• Expertise in using QEMC & QMC for creating tasks, Managing schedules and triggers.
• Experienced in Reduce D Confidential, Distribute QlikView applications.
• Extensively used SET analysis expressions to develop different KPI’s like MTD, QTD...etc over accountable Zones & time periods.
• Extensively used section access incorporating row level security.
• Good experience in Qlik view development, analysis, server/publisher support.
• Good experience and understanding of d Confidential warehousing concepts, ETL, Cubes and normalizations to translate business requirements into effective business intelligence solutions
• Strong Experience in gathering requirements and develop Application prototypes.
• Strong skills in Application Development and Extensive skills in OLTP/OLAP, D Confidential warehousing systems.
• Extensive knowledge in Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Cognos Connection).
• Capable of writing SQL/PLSQL scripts.
• Excellent skills with expertise in D Confidential design and analysis using Oracle 11g/10g, Confidential DB2, MS SQL Server 2008/05, Excel, SQL, PL/SQL.
• Goal oriented team player and a leader, with strong analytical & excellent communication skills.

TECHNICAL SKILLS:

Business Intelligence: QlikView, QEMC (QlikView Enterprise Management Console), Clustering,QMC, QlikView Publisher, Workbench, SAP Connector, Cognos 8.x, Crystal Reports 9

ETL Tools: Informatica, D Confidential stage

RDBMS: Oracle 10g/9i/8i, SQL Server, DB2, Terad Confidential, MS Access

D Confidential base Tools: SQL Server Management Studio, Toad, Erwin 3.5.2

Operating Systems: Windows 2008, 2005 Enterprise Server,Unix

Languages: SQL, PL/SQL, VB, Script, C, C++

PROFESSIONAL EXPERIENCE:

Confidential

Sr. QlikView Developer

Responsibilities:

• As a QlikView Architect, worked with the client to scope out the requirements and setup a project plan and enterprise framework deployment methodology.
• Strong understanding in creating Dashboards, scoreboards for the required KPI are in QlikView.
• Assisting the client to update their current QlikView dashboards and reports and to modify the existing ETL processes, to in the change in business rules
• Developed load scripts to work with multiple d Confidential sources (DB2, Flat Files, Excel, and MS Access).
• Assessing the D Confidential Governance process, relevant systems and performing gap analysis for a key
• Department of the financial institution.
• Presented the gaps, recommendations, and the road map to achieve the short term and long term goals.
• Used QlikView to design and implement a D Confidential Governance Dashboard. The dashboard analyses the source systems, processes, and people information and presents the d Confidential in the Government Iron Triangle. The analysis can be performed down to the lowest levels in all three areas
• Developed KPI’s, set analysis applications, User Interactive Sheets as business needs.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Analyzed the existing QlikView d Confidential model, script logics and the ETL business logic for the existing QlikView applications.
• Executed the scripts and checked the incorporated script changes in the Application.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Integration with Third party portal & Share Point Portals.
• Involved in up-gradation of QlikView environment from QV 9.0, QV 10.0 versions.
• Designed, developed, implemented and tuned multiple QlikView applications.

Environment: QlikView 10.0/9.0, SAP BW, QlikView SDK, Windows 2008 R2 Server, Oracle 10g, MS Access 2005,SQL Navigator, Windows XP.

Confidential

QlikView Developer

Responsibilities:

• Working closely with the key stakeholders and executives to develop and enhance the application.
• Updated the existing framework to perform incremental reloads and modified the scripts to improve and implement best practices on the existing application, and implement new business rules.
• Deployed the Accounting application, which prepares the income statements, general ledger, tracks budget vs. forecast and produces other custom report.
• Actively participated in full life cycle of QlikView application implementation and was responsible for Design, Development and Delivery.
• Ramped up the project with multiple resources, following the project plan and the recommended framework to deploy and manage the solutions.
• Implemented three-layered architecture, which involves Extraction from DB and store as QVD’s, Transformation layer to build aggregate QVD’s and finally GUI (Dashboard).
• Created wireframes based on user sessions using Microsoft Visio.
• Developed Dashboard application prototypes after analyzing the requirements.
• Implemented Security & involved in Deployment of QlikView Applications.
• Developed load scripts to work with multiple d Confidential sources (SQL, Flat Files, Excel, and MS Access).
• Developed QlikView Dashboards using Chart Box (Bar, Line, Combo, Pivot, and Str Confidential ht etc.), List, Input Field, Table Box, Groups, and Container...etc.
• Actively involved with upgrading QlikView Environment Version 10 to Version 11.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Designed the daily refresh (batch flow) and created tasks, Triggers using QEMC.
• Improved the overall performance of the application and redesigned d Confidential model applying QlikView performance tuning techniques.
• Testing Applications, reports using review checklists, D Confidential quality for Quality Assurance before delivering to the end users.
• Involved in Production Support for various applications. Failure analysis using Error logs.
• Used SQL Server Management Studio, TOAD to run SQL queries and validate the d Confidential in D Confidential warehouse and D Confidential Marts.
• Conducted end user sessions and prepared the documentation.

Environment: QlikView 12/11x/10x, Windows 2008 R2 Server, MS Access 2005, Oracle 12/10g, Sqlserver 2008, SQL Server Management Studio, Toad.

Confidential

QlikView Consultant

Responsibilities:

• Analyze and review Business Requirement and Specification documents.
• Coordinate with business team to provide and receive feedbacks on the business requirements.
• Create Functional Design documents, and hold the reviews with business and IT team.
• Developed HR intelligence Dashboards, used KPI’s which provides powerful metrics, Alerts and reports to HR professionals and line managers, enabling them to understand how workforce factors are affecting individual departments and take appropriate actions.
• Implemented comprehensive security functionality by creating users & web groups, setting up LDAP (ADSI) authentication and associating c Confidential log objects and Web modules with the created users and groups.
• Performance Tuning through aggregation strategy, caching schemes and usage tracking.
• Analyzed Reports and resolved D Confidential Issues Related to Reports.
• Created Time Series Objects, Hierarchies, Level Based Measures.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Implemented Security/Access privileges by creating roles & web groups, checks with External tables.
• Built the applications in order to track predefined KPI’S (Key Performance Indicators).
• Developed many incremental ETL using Informatica mappings & Oracle PL/SQL procedure.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Responsible for Web Logic Administration, Websphere Administration, maintenance and performance tuning.
• Individual support and troubleshooting at application level.
• Responsible for delivering technical diagnosis and solution prescription.
• Work with application development resource if unable to resolve support issues.
• Works on a team and has individual responsibilities for Application Technical support of applications dealing with escalated and complex application problems.
• Created Solution Design Document, Architect diagrams and Ports and Flows diagrams.
• Contributed in creating user and administrator guides for end users.
• Migration of Documentum from 6.5 SP2 to 6.7 SP1 and 6.7 to 7.x platform, creation and maintenance of Docbases, users, groups and, installation and configuration.
• Maintain Content Server, Web Publisher, doc broker, docbase after migration

Environment: QlikView 9.0, Windows 2005 Server, SQL Server 2005, MS-Excel, Windows XP, Terad Confidential, MS Analytical Services.

Confidential

Documentum Administrator

Responsibilities:

• Responsible for Web Logic Administration, maintenance and performance tuning.
• Designed and developed the messaging framework for communication between workflow manager and other Enterprise applications.
• Manage and publish author’s content better using FTP service.
• Manage high volume transaction processing and provide an easy to use interface to quickly review documents using Task Face all in one user interface.
• Connecting people, systems, involving content and D Confidential, Analyzing, monitor typical stages in a business process life cycle
• Involved in migration from Documentum Suite 5.3 SP2 to 5.3 SP6.5. Migration included e-Content Server, WDK, and Web Publisher.
• Involved in getting required specifications for Metabolism assay into design specification for development team.
• Installing new versions of Documentum products on client machines and setting up development environment that links to the other modules of the project environment.
• Maintained Content Server, Web Publisher, doc broker, docbase and docApps after migration.
• Created users, groups, Roles and permission sets using Documentum Administrator.
• Created process workflows to automatically promote test-sheet files to next user in workflow cycle and to the next state in their lifecycles.
• Contributed in preparing customization documents and user manuals.
• Involved in validation of documents.

Confidential

Associate Consultant

Responsibilities:

• Worked as part of design and development team.
• Involved in installation, configuration, administration and development of Documentum 4i, WDK 4.2, Desktop Client 4.3, RightSite Server 4.2 and Developer Studio.
• Managed and supported users and groups in OS level security.
• Used DQL and API to troubleshoot on daily basis.
• Created object types and custom attributes using Developer Studio.
• Used queries to populate attribute values on document property.
• Registered the tables in DCTM Docbase with DQL.
• Executed performance test cases and protocols.
• Involved in design, and analysis of the existing system
• Error message retrieving and reporting.
• Designed and implemented the project using the Model View Control STRUTS architecture.
• Involved in analysis and design for various modules that communicate with the ERP system for the d Confidential transfer.
• Analysis & design of GUI framework classes using Java, JFC-Swing, XML, XSL, XSLT & Design patterns.
• Problem Analysis and solving critical production issues.
• Developed the front-end pages using Javascript and JSP with the back-end as Java beans to access d Confidential .
• Installed and configured the Oracle 8i d Confidential base.
• Written Packages, Stored procedures, Views and Functions at the d Confidential base end.
• Developed the PL/SQL scripts for rebuilding the application d Confidential base.
• Involved in all tasks of application development, from need analysis through maintenance