SUMMARY

• 7 years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.
• 3 Years of experience inQlikViewDevelopment.
• Expertise in designing and modeling ofQlikViewApplications using QlikView with complex multiple data sources (SQL, Oracle, Flat Files, Excel and Access) relational designs.
• Expertise in working withQlikViewDesktop,QlikViewEnterprise Management Console (QEMC), QlikViewPublisher,QlikViewWeb Server.
• Good working knowledge in all components ofQlikViewand interaction on Server and Publisher.
• Experience withQlikViewsheet objects including Pivot, List and Multi box, multiple chart types, Trends, KPI's, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting.
• Strong working knowledge ofQlikViewscripting, set analysis, aggregation functions, multi - dimensional objects, layout and design including chart properties and formats.
• Strong understanding in creating Dashboards and scoreboards for the required KPI's inQlikView.
• Experience in designingQlikViewDocument/User Setting Layouts to make consistent and professional optimized look to clients.
• Proficient in migrating reports from different platforms (such as Excel, Crystal reports) toQlikView.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance usingQlikView.
• Strong experience in UI Design by using differentQlikViewsheet objects including multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change.
• Ability to work in role mapping.
• Experience in1 tier, 2tier as well as 3 tire architecture of theQlikView.
• Good expertise with the development and design ofQlikViewapplications.
• Experience inQlikViewServer and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Developed and scheduled reports using NPrinting tool and also implemented user security for the reports.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports usingQlikView.
• Expertise in Installing and ConfiguringQlikViewDesktop,QlikViewServer andQlikViewPublisher.
• Experience in writing SQL queries, T-SQL, Functions, Views and Stored procedures.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Worked in close association with customers for requirement gathering and effective analysis.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Experience in development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.

TECHNICAL SKILLS

BI Reporting Tools: Qlikview 8.5/9.0/10.0/11.0 , OBIEE, SAP Business Objects 4.0, Crystal Reports, Cognos, SSRS

Languages: SQL, PL/SQL

Databases: Oracle, SQL Server, Teradata, MS Access, Excel & .CSV Files

Tools: SQLDeveloper, SQL*Plus, TOAD, Teradata SQL assistant.

ETL Tools: Informatica Power Center 8.x/7.x, SQL Server Integration Services (SSIS), SSRS

Data Modeling: Erwin, Microsoft Visio

Operating Systems: Windows, Linux and UNIX

PROFESSIONAL EXPERIENCE

Confidential, NJ

QlikView Developer

Responsibilities:

• Extensively worked to confirm and clarify requirements and business logic.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Performed redesign ofQlikViewBI platform to improve availability, scalability and performance to accommodate high volume of data with 60+ dashboards
• Participated on business requirement document preparation.
• Working with many complex SQL queries with Joins, Date functions, Inline functions, and Sub-queries to generate reports.
• Strong understanding in creating Dashboards, scoreboards for the required KPI's inQlikView.
• To make use of the room space inQlikViewused container objects and embedded different charts in QlikView.
• Trained Distribution Center, Planning and Purchasing & Finance Teams on how to useQlikView applications.
• Worked on production tickets for the applications which are in production.
• Testing dashboards and data validation.
• Implemented security using sectionQlikViewaccess technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Maintained user guides and documentation forQlikViewapplications.
• Created triggers for the document level and sheet level to select the default selections when navigating between different tabs
• Used incremental loading scripts for the huge volumes of data where the refresh is done daily.
• Designed an application 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.
• Involved in up-gradation ofQlikViewenvironment from QV 11.2, QV 12.0 versions. Did
• Used Google maps for the applications to know which branches are performing to the expectations around the globe with data visualization.
• Designed, developed, implemented and tuned multipleQlikViewapplications for the Sales, IT, Manufacturing, Purchasing & FinanceQlikviewapplications.
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Wrote SQL Scripts, procedures and views which are required forQlikviewprojects.
• Setting access permissions and assigning CALs based on users.
• Worked on dashboards related to Sales Analysis, Production over time and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.

Environment: QlikView12/11x/10(Desktop, Server/Publisher), SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Cognos, Informatica,QlikViewEnterprise Server.

Confidential, Cincinnati, Ohio

QlikView Developer

Responsibilities:

• Imported data from multiple data sources like Oracle, SQL Server, MS Access, MS Excel, XML and Web files through OLEDB and ODBC connections
• Designed a road-map to successfully run the existing reports while data base migration.
• Performed gap analysis and addressed several data quality issues.
• Performs day-to-day operations of aQlikViewdeployment.
• Developed End-End Ad-hoc reports from the scratch.
• Designed various Front-end objects like Line, Bar and Pie Charts, Straight Table, Pivot Table and sheets objects like List box, Multi box, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Setting up and managing security using Active Directory.
• Performed testing of dashboards for functionality, data and performance.
• Developed script for automatic concatenation of data from two different sources.
• Scheduled auto tasks in publisher.
• Developed SQL Scripts, functions and variables.
• Variables using LET, SET or control statements in the scripts.
• Expertise in using advanced scripting, set analysis, VB script, advanced aggregation functions and advanced charts for applications.
• Implemented security usingQlikViewsection access that dynamically hides selected areas of the dashboards depending upon the user privileges.
• DevelopedQlikViewapplications based on Incremental Load Transactions using QVD files.
• Developed reports inusing different types ofQlikViewextension objects.
• Read QVD headers (Xml) to locate source tables for documenting purposes.
• Vigorous Data Mapping by eliminating synthetic keys.
• Created publisher jobs and also used NPrinting tool to deploy reports.
• Managed theQlikViewServer tasks: developing tasks, assigning license CALs, creating user groups etc.
• Maintained an efficient Data model by clearing Circular loops and Synthetic keys.
• Troubleshooting and debugging the script for error correction and optimization
• User Acceptance Testing.
• Helped end users to design test cases and worked through multiple UAT cycles.

Environment: QlikView11.2/11.0, Oracle (IFS), Access, XML, Business Intelligence, Agile Methodology, VB Script, Excel, Windows Server 2008 R2, T-SQL, SSIS, SSRS, CSV

Confidential, Plainsboro, NJ

QlikView Developer

Responsibilities:

• Working with the 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.
• Gathered, Analyzed, and transformed business requirements of the Client into logical and physical BI solutions.
• Provided technical leadership inQlikViewBI/DW design, dashboard and KPI metrics design, data modeling,QlikViewSAP integration,QlikViewscripts development,QlikViewSet Analysis, and QlikViewServer/Publisher setup/configuration.
• Managed theQlikViewServer tasks: developing tasks, assigning license, creating user groups etc.
• Participated inQlikViewserver migration from one physical server to another.
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.
• Identified data sources and targets for data modeling and solution architecture.
• Perform regular reviews of the database to identify performance problems, inadequate programming, and data duplication problems.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Used complex set Analysis, designed interactive charts like bubble, line, bar & Trellis etc.
• Configured and deployed the applications in the access point usingQlikViewServer/Publisher.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Used to setup security using Section Access.
• Scheduled QVW reloads on Server/Publisher by creating tasks in the Source Documents. Used Loop and reduce concept for creating multiple apps based on the field.

Environment: QlikView8.5(Desktop, Server/Publisher, Access Point), Report Services, Dashboards, Teradata, MS-Excel, Windows XP/7, Microsoft SQL Server, SSIS, SSRS, Oracle Database.

Confidential, Chicago, IL

SQL Developer

Responsibilities:

• Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate and SQR reports.
• Created Cross-Tab, Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.
• Coordinated with the client to make sure that there is not much change during the migration of the reports.
• Involved in Performance tuning and Query Optimization.
• Converted the Actuate and SQR reports to SSRS without any change in the output of the report.
• Enhanced the existing reporting functionality by using the advanced features of SSRS.
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Used SQLDeveloperto Load / Extract data into and from Excel files.
• Written stored procedures for those reports which use multiple data sources.
• Conducted impact analysis and designed structures to enhance performance.
• Created different types of reports such as parameterized reports, matrix report, charts etc.,
• Tested (manual) the reports after migration to make sure that the SSRS reports serve the exact business purpose as that of existing Actuate reports.
• Extensively used Share Point.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN

Confidential

Oracle Developer

Responsibilities:

• Enhanced and developed several forms and reports usingdeveloper2000
• Create Users, Responsibilities for Security and also database triggers to validate the complex integrity.
• Designed and developed library files (PLL) that are commonly used across the application.
• Involved in design of the application system and developing E-R diagrams, creating tables.
• Use of Analyze, Explain Plan for the purpose of better Performance Tuning.
• Involved in design and development of Menu module.
• Created database triggers to validate the complex integrity.
• Involved in working with DATA PUMP utility.
• Created stored procedures, functions and packages for implementing major functions of the system.
• Wrote complex SQL queries using joins and correlated sub queries.
• Developed Adhoc reports as per business needs.
• Creating the table structures in SPINCO which already exist in Vol.
• Wrote scripts for populating the database tables with test data.
• Testing and documentation.
• Involved in design and development of Menu module.
• Use of Analyze, Explain Plan for the purpose of better Performance Tuning.

Environment: Oracle 7.3, SQL, PL/SQL, SQL*Net, Windows NT/95, SQL*Loader, Import, Export.