SUMMARY:

• IT Professional with nearly 9 years of experience in analyzing, designing, architecting, tuning and developing Client/Server, Business Intelligence (BI) applications using QlikView, Qlik Sense, Tableau and IBM Cognos suite.
• Extensive experience in Full Life cycle Development including Analysis, Design, Implementation and maintenance different analytical applications using wide range of Analytical, DWH and web based products.
• Expertise in Installing and configuring Qlik Server and Publisher 9.0/10.0/11.0 with QlikView web server/IIS in both clustered and non - clustered environments.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise reporting architecture.
• Expertise in design analysis and performing tuning of applications. Proficient in Optimization and tuning of applications based on server resource consumption analysis using different load testing procedures.
• Experience in creating custom access point pages, custom security, webpage/web parts integration etc.
• Expertise in Creating Documents using QlikView 9.0/10.0 and Qlik Sense using different data sources like Oracle, SQL Server, Netezza, QVD files, text files, excel and generated dashboard as per the user requirement.
• Experience on QlikView Sheet objects including various chart types, Trends, KPI’s, custom requests for excel export, Fast change and objects for Management Dashboard reporting.
• Experience in enterprise data warehousing Extract, Transform & loading data & develop Data models using Star Schema & Snow Flake Schema’s.
• Experienced embedding QlikView applications into OEM basis host applications using QlikView OCX control.
• Expert in extracting, transforming and loading data from multiple sources into Qlik Sense applications
• Expertise in Qlik sense data modeling, Qlik sense development, Qlik sense SDLC and governance, Qlik sense apps, stories, KPI and story generation.
• Extensive experience in developing stored procedures, functions, triggers, cursors and joins, SQL Queries with T-SQL, PL/SQL and working with TOAD, SQL Developer, SQL*PLUS.
• Familiarity with shell scripting for database deployment and administration
• Self-motivated, team player with excellent communication, analytical, presentation and multi-tasking skills.

TECHNICAL SKILLS:

BI Tools: QlikView 10.x/11.x,Qlik sense 3.0

Databases: MS SQL Server, Oracle, DB2, SAP BW, Teradata

Web Technologies: HTML, Java Script, VB Script

Data Modeling Tools: Erwin, Visio 2000

Operating Systems: Windows 95/98/2000/XP/NT, UNIX

Languages: SQL, PL/SQL, UNIX Shell Scripting

Other Tools: Informatica 7.x/8.x, Toad, DAC, SQL Developer, Putty

PROFESSIONAL EXPERIENCE:

Confidential - Warren, NJ

Qlik View/Qlik Sense Developer

Responsibilities:

• Design & development of highly complex dashboard applications those contain data from different workflow systems intended for insurance.
• Combine data from multiple sources into QlikView, implemented transformation techniques to clean up the data.
• Developed advanced chart types and visualizations, Waterfall, heat map, all other out of box available object types.
• Implemented section access for users at different levels & applied custom security on UI for various custom requirements using flags.
• Developed applications with ad-hoc capabilities where users can create own visuals based on different attributes and metrics.
• Built advanced chart types and visualizations in bar charts-bullet graphs, box and whisker plots, Bubble scatter, Radar charts etc.
• Implemented complex calculations like hit, quote & loss ratios dynamically for segment heads and executive users.
• Developed forecasting analysis for certain business groups to facilitate current, prior & future prediction based on certain parameters.
• QlikSense POC - worked on QlikSense proof of concept by importing and also creating new dashboards and data models for the business teams to evaluate.
• Train the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlik view/Qlik sense.

Environment: QlikView 11, Oracle 10g, MS Office, Windows 2008 R2 Server, Toad, Data Stage, Qlik view 11/Qlik sense 3.0

Confidential - St Louis, MO

QlikView Developer

Responsibilities:

• Analyzed requirements, functional and technical specs from documentation of QlikView application requirements from end users.
• Installation of the latest versions of QlikView, recently migrated from QlikView 10 to QlikView 11 SR2 Release.
• Install and Configured QlikView 11 on Windows 2008 R2 Servers and clustered servers for our production environment.
• Involve in setting up the Development and Production Environments for QlikView.
• Migrated all the Publisher Tasks from QlikView 10 to 11 and applied the dependencies between the tasks.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, and flat files.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Extracted data from different systems transformed and integrated in the QlikView.
• Migrated existing QlikView 10 dashboards to QlikView 11 environment, also added new QV11 features to the Dashboards.
• Developed a standard/optimized theme which is further used across the system.
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• Developed QlikView Dashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
• Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.
• Worked on metadata management by implementing the governance Dashboard.
• Responsible for work breakdown and managing the team.
• Developed Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Deployed the QlikView applications in the server. Created Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.
• Scheduled the Publisher Tasks Daily/ Weekly/ Monthly on various Dashboards based on the Database updates.
• Worked on QMC to Cluster the 3 Production servers, setup the E-Mail alerts in case any Publisher Tasks fails.
• Setting up the Development and Production Environments for QlikView. Responsible for user and server management.
• Helped end users to design test cases and worked through multiple UAT cycles.

Environment: QlikView 11.x/10.x/QlikSense, Oracle 11g, DB2 9.7, MS Office, Windows 2008 R2 Server, Toad, Informatica Power Center, Agile Methodology

Confidential - New York, NY

QlikView Developer

Responsibilities:

• Designed and developed business intelligence solutions usingQlikView.
• Analyzed internal project Audit team’s requirements and develop proposals of technical solutions as needed.
• Created finance Dashboards, worked with Project Management data and created high level reports.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Extracted data from SQL Server, flat files and applied necessary transform.
• Enhanced existing reports as per the requirements.
• Implemented incremental loading, so loading performance increases. Followed 3-tired QlikView Data architecture while performing ETL (Extraction Transformation and Loading).
• Created complex and advanced business reports by writing SET analysis to meet the user requirements.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Prepared documents for end user .
• Created a rich user interactive report by using various objects like charts, text objects, input boxes, table boxes, and gauges etc. and applied dynamic visibility on the objects.

Environment: QlikView 10.x, Oracle 10g,SAP BW, MS Office, Windows 2008 R2 Server, Toad, Informatica Power Center

Confidential - Fort Lauderdale, FL

QlikView / Business Objects Developer

Responsibilities:

• Gather & load data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files.
• Tested applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering to the end users.
• Participated in the UAT process along with business users.
• Supported multiple clients and responsible for ad-hoc queries which were raised by client users.
• Created client setup on server for different clients and providing the access to the users, distributing the application.
• Converted existing Business Objects reports to QlikView.
• Worked on SQL and executed them for Reports validation and resolved if any issues with reports.
• Efficient in Optimizing, Debugging and testing SQL queries written in Oracle
• Developed strategies and plan for migration of the reports from BO XI R2 to BO XI R3 and later BO XI R3.1
• Production Support and data validation of Business Objects reports and QlikView models.
• Delivered advanced and complex-reporting solutions such as Dashboards and Standardized Reporting using QlikView 11.

Environment: QlikView8.5, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel

Confidential - Irving, TX

Business Objects Developer

Responsibilities:

• Interacted with Users and Business Analysts to understand and document the requirements and translate these to technical specifications for designing Universes and Business Object Reports.
• Design and implemented Data Models to meet existing and future anticipated reporting requirements.
• Designed Universes using BO XI R2 designer by retrieving data from database, using Derived tables, defining the necessary connections and exported them to specific universe domains.
• Extensively worked with Web Intelligence XI R2 and Info View to create thin client reports based on the business requirements.
• Design and Developed Webi Reports as per the Users Requirements using the features in Business Objects including: Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and requirements of the end users.
• Mocking up the data considering security and confidential data. Thorough Documentation of all the Reports with Report definition, field definitions and layouts.
• Created Crystal Reports Templates to support Corporation Report Standards and color scheme.
• Used Dashboard Manager to build Dashboards and deploy them across the organization to monitor business performance.
• Create interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.
• Development confirmation with users and modification if required accordingly.

Environment: Business Objects 6.5, MS.NET, C#, VB, SQL Server 2000, Photoshop, Flash

Confidential

SQL Developer

Responsibilities:

• Identify and evaluate UNIX, SQL, and or Data Modeling.
• Design and develop T-SQL procedures, query performance tunings, and SSIS packages.
• Developed underlying data models and databases.
• Develop, manage, and maintain data dictionary and or metadata.
• Ensured compliance of standards and conventions in developing programs.
• Design, develop, and implement complete life cycle of data warehouses.
• Translated business requirements into software applications and models.
• Resolved and troubleshoot complex issues.
• Performed and execute data extraction, transformation, and loading using ETL tools.
• Maintain and manage all versions of data models for production, testing and developing databases.

Environment: Oracle 8i, SQL SERVER, Flat Files, SQL, PL/SQL, Windows NT

Confidential

SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in the design and implementation of database.
• Wrote validation scripts to check the data integrity and packages for other entitlement programs as per guidelines and Gained knowledge in handling Bulk data.
• Involved in coding, unit testing, and end-to-end testing of the developed modules.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling and Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization and created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 9i, SQL* LOADER, Forms 6i, Reports 6i, Discoverer 10g, XML Publisher