SUMMARY

• Over 8+ years of Experience of IT experience with more than 3 years of experience in Designing and Development of Business intelligence application with QlikView 11.0 as BI tool.
• Extensive experience in developing different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).
• Expertise in Creating Dashboards using QlikView 11.0, 11.2 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Designing Data Mart and Data Warehouse and Implementation of Qlikview for BI (Business Intelligence) Reporting Solutions.
• Involved in ETL Tasks (data cleansing, Joins, Aggregation Tables) using QlikView.
• Develop Dashboard reports using various QlikView Objects.
• Expertise in Data Modeling (Star Schema, Snow Flake Schema).
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
• Strong Skills in Providing Custom functionality using Macros, Triggers.
• Installation & configuration Of Qlikview Software.
• Experience in Incremental Loading & QlikView document Versioning.
• Sound skills in writing SQL Scripts, Pl/SQL Stored Procedures.
• GUI (Graphical User Interface) programming in Visual Basic for desktop application.
• Strong Database Development skills using SQL Server 2008 & Oracle 11g.
• A team player with good interpersonal skills and work independently.
• Strong Skills in providing Training for End Users.
• Analyzed reporting requirements to usable long term dashboard and reporting solutions, develop solutions as necessary.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long - term, flexibility, and standardization.
• Conduct validation of existing reporting, User Acceptance testing and new solutions to ensure continuous accuracy and front end ease-of-use.
• Experienced in Training & Supporting end-user reporting needs using QlikView & Business Objects products.
• Onsite-Offshore coordination in delivering Business Intelligence Solutions.
• Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts.

TECHNICAL SKILLS

QlikView Tools: QlikView Developer, QlikView Publisher, Enterprise Management Console, Management Console, QV Ajax Client, QV IE Plug-In.

Business Intelligence: Business Objects XIR2/3.1, QlikView 9.0/10.0/11/11.2

ETL Tools: Data Services 3.1/3.2, Informatica 8.xRDBMS Oracle 11g/10g/9i/8i, SQL Server 2005/2008, DB2, MS Access

Web Applications: IIS 6, Web Logic 8, Tomcat 5.0x/ 4.1x/4.0x.

Languages: SQL, PL/SQL, DHTML, JSP, Shell Scripting, VB-Script, C, C++

Data Modeling: Erwin 4.0, Visio

PROFESSIONAL EXPERIENCE

Confidential, PA

QlikView Architect / Developer

Responsibilities:

• Gathering requirements from business users and developed technical specifications.
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Involved in Requirement gathering & designing QlikView applications.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed SET ANALYSIS in 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 the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Implemented security in QlikView Applications.
• Trained End Users on Using QlikView Tools.
• Experience with QlikView Enterprise Management Console (QEMC).
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Developed QlikView Applications using SAP Data.
• Involved in up-gradation of QlikView environment from QV 8.5, QV 9.0 versions.

Environment: Windows 2003 Server, Oracle 10g/11g, SAP BW, Teradata, MS SQL Server 2005/2008, QlikView 11, QlikView 10, QlikView 9.0, MS Office.

Confidential, PA

Sr. QlikView Developer

Responsibilities:

• Worked with Business Users for requirement gathering and passing on the information to team.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule adhoc reports by leveraging the basic components of QlikView.
• Developed KPI’s and set analysis applications.
• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• 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 feedQlikViewapplications
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application
• Coordinated with ETL team and performed integration testing to check data discrepancies
• AutomatedQlikViewjobs inQlikViewPublisher and rolled out toQlikViewAccessPoint and administered Security using Active Directory
• Analyzed the existingQlikViewdata model, script logics and the ETL business logic for the existingQlikViewapplications
• Generated the QVDs from the SAP database and redeveloped the QV scripts to in corporate AMA & PED restrictions
• Executed the scripts and checked the incorporated script changes in the Application
• Improved the overall performance of the application and redesigned data model applyingQlikViewperformance tuning techniques

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

Confidential, KY

Business Objects Lead

Responsibilities:

• Install and deploy Business Objects Enterprise Xi R3.1 SP3; Configure SSO and Windows Active Directory.
• Implemented clustered environment and multi-domain (Forest and Tree) environment in BO.
• Migrate objects using Import Wizard and convert Reports from Deski to Webi.
• Generate Reports using Crystal Reports 2008.
• Configure electronic mail using Simple Mail Transfer Protocol (SMTP) on Job Servers, File locations to export reports to specific recipients/file locations.
• Setup Publications to deliver reports to Enterprise Users and Dynamic Recipients in various output formats.
• Setup profiles for use with Publication to personalize data in reports.
• Configuring CMS and Audit Database.
• Use the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Create Auditing Universe and Auditing Reports; Webi Reports according to user requirements.
• Generate complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects.
• Migrate the code between the development/test/production environments.
• Fine-tune Central Management Server and Audit Database.
• Upgrade Data Services from SAP BODS 3.1 to SAP BODS 3.2SP2FP3.5.
• Upgrade all local repositories and central repositories for ETL developers.
• Schedule ETL jobs on Management Console for constant monitoring.
• Back up jobs onto ATL file.
• Managed users, folders, securities and groups using CMC.
• Involved in ETL process and used Data Services to load data into Test and Production environments.
• Participated in the implementation of Windows AD and Single Sign on.
• Converted several reports from Deski to Webi.
• Fixed bugs and issues related to migration and conversion like multi-value, #syntax, #error, formatting, missing data, and formulas.

Environment: Business Objects XI 3.1 SP3, Business Objects Designer/Workflow Manager, Desktop Intelligence, InfoView, Web Intelligence XI R2, Crystal Reports 2008,Xcelsius, BO Data Services, Import Wizard Live Office, SAP BW, VPN, Windows Server 2003

Confidential

Business Objects Developer

Responsibilities:

• Evaluated usage of Crystal Xcelsius, Live Office for ad-hoc reporting.
• Created complex Xcelsius dashboards, Webi, Crystal Reports connected to Webi, Crystal reports using Live Office, Open Document XML, and Web Service and hosted on Business Objects XI R2.
• Prepared documentation of test cases.
• Created and optimized ROLAP & OLAP Universes.
• Designed QaaWS using Universe data sources.
• Extracted, Transformed & Loaded data from multiple sources into Data Warehouse using ETL tools (Data Integrator).
• Designed technical design documents for mapping Oracle applications to Data Warehouse.
• Interacted with business users for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfill reporting needs.
• Tested universes and reports to map objects.
• Documented Functional, Technical specifications and Test Cases.
• Managed users, folders, securities and groups using the CMC.
• Involved in ETL process and used Data Services to load data into Test and Production environments.
• Participated in the implementation of Windows AD and Single Sign on.
• Converted several reports from Deski to Webi.
• Fixed bugs and issues related to migration and conversion like multi-value, #syntax, #error, formatting, missing data, and formulas.

Environment: Business Objects XI R2, Business Objects Designer/Workflow Manager and Monitor, Desktop Intelligence, InfoView, Web Intelligence XI R2, Crystal Xcelsius, BO Data Services, QaaWS, Live Office, SAP BW, VPN, Windows Server 2003

Confidential

SQL/Cognos Developer

Responsibilities:

• Used Multidimensional analysis for Data Retrieval using PowerPlay structure.
• Created PowerPlay cubes using Transformer.
• Involved in Migrating reports from Impromptu/CRN to Cognos 8.
• Extensively worked on prompts based on the user needs and format required.
• Used impromptu to create .iqd files and used as source of data in Cognos Transformer to create multi-dimensional cubes to generate PowerPlay reports.
• Designed, Developed & Tested Power Cubes and deployed them in to production.
• Drill down, Slice and Dice and Filtering operations done for all OLAP applications.
• Created and maintained the security of the user classes.
• Used Access Manager to administer security for all the catalogs.
• Defined conditions, calculations and prompts in the catalog.
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email.
• Used impromptu’s optimizing features like table weighing, governors, bulk fetch.
• Created various reports (List, Crosstab, Mailing Labels, Form Letter, Free Style) using Cognos Impromptu tool by querying the database
• Created standard and Ad-hoc reports (Formats, Layouts, quality data to carry) using Cognos Impromptu tool.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Production Support which involves solving user problems.

Environment: Cognos Report Net 1.1, Impromptu 7.2, Cognos Power Play Transformer 7.2, Power Play Enterprise Server, Cognos Upfront, Microsoft IIS, Oracle 8.0, SQL Server, HTML, MS-Access, MS-Excel, and Windows NT.