SUMMARY:

• 7+ years of IT experience in Business Intelligence, Data Modeling and Data Warehousing.
• More thanfour years of experience in working with QlikView components such as QlikView Desktop, QlikView Enterprise Management Console(QEMC), QlikView Publisher, QlikView Web Server and Ajax Clients.
• Adept in reviewing and analyzing the Business Processes, Business Process Flows and implementing QlikView Solutions.
• Wide variety of Functional Experience with Innovative Solution Design, Information Technology solutions and Passionate Leadership producing consistent results.
• Proficient in Designing Data Mart & Data Warehouse of QlikView for BI (Business Intelligence)Reporting Solutions.
• Interaction with the Process Champions&Business users during various stages of project lifecycle to identify various KPI’s and designed solutions to enhance business decision making.
• Experience in development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.
• Having knowledge onData Modeling concepts like (Star Schema, Snow Flake Schema) & loading data from multiple sources.
• Experience in developing User Interfaces and QlikView Dashboards using Charts (Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars and Date Islands.
• Strong experience in working with Charts(Pivot Tables, Straight Tables, Pie - Charts, Gauge-Charts, Trellis).
• Good Exposure toworking with QlikView Functions and Expression Scripts and Streamlining Reporting operations of QlikView Applications.
• Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications.
• Implementation of security in QlikView Applications at Document and Server Level.
• Implementation &Production Support of QlikView Applications.
• Testing applications, reports using review checklists, Data quality for Quality Assurance prior to making delivery to end users.

TECHNICAL SKILLS:

Reporting Tools: QlikView 9.x/10.x/11.x Series

ETL & other tools: TOAD for Oracle 12.1, TOAD Data Modeler

Databases: Oracle 9i/10g/11g, DB2, SQL Server 2005/2008, MS Access.

Programming: SQL, PL/SQL, UNIX Shell Scripting

Office Applications: MS Outlook, Visio 2000, MS Excel

Web Technologies: HTML, XML, ASP, Java Script, VB Script, Servlets.

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

Sr. QlikView Developer

Environment: QlikView 11.2 SR12 Desktop, Oracle, .CSV Files, QlikView Server 11.2.

Responsibilities:

• Involved in gathering business requirements and preparing functions Specs for the application development.
• Connected to data sources (Oracle) using ODBC and OLEDB connections to create and schedule ad-hocreports by leveraging the basic components of QlikView.
• Performed different tasks like extracting data from the database, writing complex load scripts and generating QVD files for faster and improved performance. Also involved in the development of user friendly interfaces to make analytics easy for non-technical users.
• Developed Budget & Finance data Dashboards as comparative analysis dashboards to provide a flexible and user friendly analysis application.
• Developed a dashboard to show Financial General Ledger for different Process Fiscal years to perform comparative analysis for Financial Management.
• Developed a dashboard to show Transactional level data with order numbers being able to drill to HR Personnel Data.
• Passing parameters to the QlikView dashboard using URL from Cold Fusion nSIGHT Finance Application.
• Designed and developed dashboard to show the KPIs from all the business areas as a summary to know the health of the IC vs. NIH.
• Developed the Financials, Acquisitions and Travel dashboards from scratch to show data visualizations for all the KPIs and also provide comparative analysis capabilities.
• Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications.
• Generated tasks and automated reload tasks as per task triggers along with the distribution tasks in the QlikView Management Console (QMC).
• Maintained and administered source documents and application documents generated from the access point distribution.
• Worked on the performance tuning of the applications to improve the performance and also optimize thedata models.
• Developed Section Access scripts using user groups from Active Directory and also named users.
• Provisioned users to access the application on the access point with the distribution tasks in QMC.
• Provide QlikView Server support and support to the end user queries. Research and troubleshoot technical issues with the access issues of application or the server issues with reloads.
• Developed the application development documentation, Admin Manual and glossary.

Sr. QlikView Developer

Environment: QlikView 11.2, SQL Server 2008, Oracle 10g, Access, .CSV Files, Windows 2003 Server.

Responsibilities:

• Involved in gathering business requirements and preparing functions Specs.
• Connected to different OLE DB and ODBC data sources (SQL Server, Oracle) to create and schedule ad-hocreports by leveraging the basic components of QlikView.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Currently assigned to develop a new dashboard with a complex database system behind it. Task includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and notified by email to the operators if anything went wrong.
• Maintained and administered source documents, source document sets, user profiles and executed resource management services like Access point resources, distribution folders and email servers.
• 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.
• Provide support when internal teams have enquiries. Writescripts in VBS to automate tasks.Research and troubleshoot technical problems.
• Prepared technical documentation for trainingthe end users.

Sr.QlikView Developer

Environment: QlikView 10/11.2, SQL Database, Windows Server 2003, Oracle 10g, Microsoft Visio, QlikView Publisher, QlikView Server 9.0.

Responsibilities:

• Developed User Interactive Sheets & Reports as per business needs.
• Implemented Star schema&Snow flake schema (confirmed dimensions).
• Developed Link Tables, Concatenation (Resolving Loops & model ambiguity).
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks. Developed KPI’s and set analysis applications.
• Developed extensively Alerts, Variables, Input boxes and Calendars.
• Gathered &loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g .CSV and Excel files).
• Generate new QVD files created by ETL logic to feed QlikView applications.
• Included the enhancement scripts to the existing QV scripts and performed the actual load totest the overall functionality of the application.
• Coordinated with ETL team and performed integration testing to check data discrepancies.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikViewAccessPoint and administered Security using Active Directory.
• Analyzed the existing QlikView data 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.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Published Client application using QlikView Publisher and rolled out to Shared Drive with security permissions using Active Directory features.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Developed SQL Scripts in validating data from different data sources.Mentoring Business User Groups.

QlikView Developer

Environment: Windows 2000 Server, QlikView 9.0/10, Oracle 10g, SQL Server 2005, MS Office.

Responsibilities:

• Worked with Business Users for requirement gathering and passing on the information to team.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Connected to Oracle using OLE DB and ODBC data sources to create and schedule ad-hoc reports by using the basic components of QlikView.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView.
• Created dashboard style of layouts using different components of QlikView Enterprise like List-boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Presented QlikView applications to various levels of user.
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.
• Worked with QlikView administrator to optimize QlikView performance.

Report Developer

Environment: UNIX, Oracle 8i, SQL, PL/SQL, Oracle Forms, Reports, SQL*Plus, SQL Tuning.

Responsibilities:

• Developed complex SQL Queries for data retrieval from various database objects including tables and views.
• Developed PL/SQL Stored Procedures, Functions, Packages, Cursors, Triggers and Records to implement business rules into application.
• Developed new reports from scratch using Oracle Reports 6i.
• Implemented Event Triggers to perform business logics in the background of Forms and Reports.
• Developed complex stored procedures for making transactions effectively transparent.
• Extensively used built in Oracle packages like DBMS SQL and other packages.
• Designed and Developed form layouts as per user specifications.
• Involved in turning several SQL queries by using indexes, hints and EXPLAIN PLAN.
• Used SQL*Loader to load the data from flat files and CSV files into the database.
• Developed user interfaces, menus and coded different PL/SQL objects for Forms and Reports.

Programmer Analyst

Environment: Oracle 8i, PL/SQL, SQL* Loader, TOAD, Windows XP.

Responsibilities:

• Effectively communicated with Business Users for Data Requirement and Data Analysis Documents.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for weekend batch processing.
• Involved in creation and updates of several SQL packages and Procedures.
• Creation of SQL Scripts and written Procedures using PL/SQL data for uploading data from flat files into new tables.
• Implemented various Exception handling cases for proper flow of data into database.
• Implemented PL/SQL scripts using Ref cursors in order to load data dynamically and implemented Incremental Loading of data.
• Developed complex SQL queries and Inline views, Materialized views, Global temporary tables for reporting purposes.