SUMMARY

• 7+ years of extensive experience in Business Intelligence, Decision Support Systems and Software Development.
• Experienced in QlikView, MS - SQL Server Reporting / Analysis Services and SharePoint tools.
• Over Four yearsof experience in QlikView with data modeling, analysis, design, testing, development and implementation of client/server applications, administration of QlikView for OLTP and OLAP Systems.
• Worked in all phases of Business Intelligence Life Cycle and Software Development Life Cycle.
• Utilized QlikView Scheduler to manage and maintain scheduled jobs for QlikView application dashboards
• Utilized QlikView Publisher for client application rollout to QlikView Access Point and administered security using Active Directory technology.
• Well verse with RDBMS concepts especially with Oracle, SQL and PL/SQL.
• Gathered fair understanding of QlikView application administration encompassing Planning Implementing User, Resource and Password Management, Backup & Recovery Strategies, Performance Tuning, Creation and Configuration of database on Oracle.
• Proficientincreating QVdatamodels,QVobjects,reports,graphicalinteractiveUIusing various datasourceslikeOracle,SQLServer,Access,textfiles, Excel documentsetc.
• Experience in setting up server, publisher configurations and security/authorization at different levels.
• Installed and configured QlikView versions 11 and 10 SR4.
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using QlikView.
• Experience in all phases of project life cycle.
• Generate QVD files created by ETL logic to feedQlikViewapplications
• Experience in Incremental Loading & QlikView document Versioning.
• Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts
• 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
• Team orientedindividual 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/9, Hyperion Reporting and analysis 9.x/11.x

Databases: Oracle 11g/10g, MS SQL Server 2005/2000,Sybase and MS Access

Tools: Toad, SQL developer

Languages: SQL, PL/SQL, T-SQL, C, C++, Java, PHP,.Net

Scripting Technologies: Java Script, UNIX

Additional Skills: Data Analysis

Data Modeling: Erwin data modeler

ETL: Informatica

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr QlikView Developer

Responsibilities:

• Created POC’s to demonstrate the scope of the project to the business users.
• Extracting normalizeddatasetfromInformatica and from various database sources and build a data model with Master Calendar to connect the various fact tables with master tables
• Used QlikView sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting
• QlikViewbestpracticeswereusedinscripting,setanalysisandusageof variables.
• Designed/Implemented Star Schema while loading data from multiple data sources.
• Implemented data level Security using Section Access that hides selected areas of the dashboard and reduces data dynamically depending on user entitlements/privileges.
• CreatedQVD's&updatedontimelybasisasdatabaseupdates.
• Made sure that nosynthetickeysorcircularloops are getting formed in the data model.
• Interacting with end users to gather the functional requirements and customize QlikView dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting QlikView applications.
• MonitoringoftheQVS,QVW'sanduseraccounts for the usage of applications and user access to manage the limited number of licenses.
• Deploying the QlikView reports onto the QlikView servers.
• Interacting with end users to gather the functional requirements and customize QlikView dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting QlikView applications.
• Worked with Business Analyst and the Business user to understand the user requirements, layout, and look and feel of the application to be developed.
• Provide support when internal teams have enquiries. Write scripts in VBS to automate tasks. Research and troubleshoot technical problems.

Environment: QlikView 11.2 SR6, Oracle 11g, DB2, MS SQL Server 2008, Toad, Informatica 9.0., Windows 2008 R2, Excel, MS Access, Flat files.

Confidential, Mentor, OH

QlikView Developer

Responsibilities:

• Actively participated in requirement gathering working closely with business users and stakeholders.
• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
• Delivered advanced and complex-reporting solutions such as Dashboards and Standardized Reporting using QlikView 11.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, Informatica, binary QVW, Inline & txt files in creating the QlikView dashboards.
• Enabled the features that are requested by the clients and made them understand the new features.
• Extensively worked with QlikView functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in QlikView applications.
• Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Worked with QlikView administrator to optimize QlikView performance.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files)
• Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents and error notifications by email to assigned users.
• Closely worked with the release management team to facilitate smooth deployments of QlikView documents in addition also helped with database administration and development.
• Installation of IE plug-ins and worked with business analysts to train the end users to use the reports effectively to build and customize their ad-hoc reports.
• Trained a team of users on QlikView in terms of best developing and design practices and general “how to” procedures.
• Supported multiple clients and responsible for ad-hoc queries which were raised by client users.
• Creating client setup on server for different clients and providing the access to the users, distributing the application.
• Worked with the user community and senior management to identify the business' reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.

Environment: QlikView 11.2/11, QlikView Informatica Connector, Oracle 10g, DB2, MS SQL Server 2008, Toad, Informatica 9.0.,Windows 2008 R2,Excel,MS Access, Flat files.

Confidential, Buffalo, NY

BI Consultant

Responsibilities:

• Interviewed users to identify problems, reporting requirements and problems in existing systems design.
• Connected to different OLE DB and ODBC data sources (SQL Server, Oracle) . to create and schedule ad-hoc reports by leveraging the basic components of QlikView.
• Collaborated with Business Intelligence team to learn current processes and practices
• Identified the Sales metrics for various businesses by interacting with users and analyzing Business Objects Reports.
• Extracted data from different database stored into QVD file, wrote load scripts and developed UI according to the requirements.
• Established a secure environment using QlikView Section Access.
• Generated new QVD files from the EDW by writing scripts in QlikView applications
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Designed and Developed QlikView dashboards meeting 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.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• Used various KPI's for calculation purposes.
• Worked with the finance teams to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
• Create test scenarios and run tests to find errors and confirm program meets specifications. Also, consult with clients to prototype, refine, test, and debug programs to attain client approval.
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources.
• Presented QlikView applications to various levels of user.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.
• Implemented Incremental Load in QlikView Servers.
• Good hands on experience in optimizing the reports, queries.
• Assisted the users during UAT and incorporated the changes mentioned by the users.
• Design and obtain KPI’s for Dashboard applications.

Environment: QlikView 9.0/10.0, Windows 2008 R2, Oracle 10g, Informatica v 8.6.1, SQL Server 2005.

Confidential, Boston, MA

BI Consultant/QlikView Developer

Responsibilities:

• Used QlikView sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting
• QlikViewbestpracticeswereusedinimplementationofscripting,setanalysis,usageof variables.
• Designed/Implemented Star Schema while loading data from multiple data sources.
• Implemented Section Access that hides selected areas of the dashboard and reduces data dynamically depending on user privileges.
• CreatedQVD's&updatedontimelybasisasper the databaseupdates.
• DevelopedETLScriptsfordatacleansing,resolvingsynthetickeys&circularloops.
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the applications.
• MonitoringoftheQVS,QVW'sanduseraccounts for the usage of applications & user access to manage the limited number of licenses.
• Mainly designed and developed QlikView software applications and complex server-based Qlikview dashboards from scratch to support reporting and Business Intelligence initiatives.
• Deploying the QlikView reports onto the QlikView servers.
• Setting up New task, mounting on Access Point, troubleshooting already existing task setup and other issues.
• Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents .
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Implemented security using QlikView's section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Participated in selection of Business Intelligence solutions according to business and technical requirements.
• Two Dashboards were developed and served to track all the way through Ship to Final acceptance phase, which include Installation, Field STR, Pre-Warranty Aging etc; Dashboards included network detail drilldowns, KPI's and alerting mechanisms.
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering to the end users.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Promoting dashboards to production environment and manage user access.

Environment: QlikView 11.2/11/10.0, SAP R/3, QlikView Informatica Connector, Oracle 10g,DB2, MS SQL Server 2008, Toad, Informatica 9.0.,Windows 2008 R2,Excel,MS Access, Flat files.

Confidential

Business Analyst

Responsibilities:

• Implemented LIMS and BRM software at multiple client locations to make sure the results of tests performed on drugs manufactured are as per 21 CFR part 11 guidelines and releasing automated batch reports using the software.
• Gained experience in gathering requirements and preparing proposed solutions and functional specification documents.
• Contributed to the development of Caliber BRM product and was the first implementation engineer from Caliber side.
• Work with various stakeholders, QA, US RFM-Support, Deployment, Legal, Security, Treasury, development teams and infrastructure teams to ensure our requirements are well thought out, well defined, and implemented very well.
• Presented presale information of Caliber products to give brief introduction to clients.
• Provided post implementation support.
• Well versed with working on SQL 2005 and 2008 R2 serve, IIS 7.0 and team foundation server.
• Validated the products as per 21 CFR part 11 compliance at client locations.

Environment: .net 4.0, Oracle 10g, DB2, MS SQL Server 2008, Windows 2008 R2, MS Office Suite 2007.

Confidential 

Software Engineer

Responsibilities:

• Interacted with Business analysts and developers for the requirement clarification.
• Worked as an Interface between the users and the different test teams for the better understanding of the business and IT processes.
• Framed test plan to execute them in strict time-lines for every Test Cycle.
• Faced several Quality Audits and ensured the alignment of process with organizational standards.
• Built "Online-Knowledge Repository" for Test Cases and integrated Insurance domain.
• Developed “Environment tracker” to automate Server failure reports for clients.

Environment: .net 4.0, Oracle 10g, DB2, MS SQL Server 2008, Windows 2008 R2, MS Office Suite 2007.