Candidates About

Bhagat Shetty

QlikView Developer

JP MORGAN Chase- Wilmington, DE ( Open for all locations)

Summary

• Having 7+ years of experience in Information Technology overall 5 plus years in QlikView development and administration. 
• Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island. 
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc. 
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI. 
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support. 
• Strong analytical database design and Data Modeling skills in QlikView. 
• Experience on Oracle9i and PL/SQL Programming. 
• Good Understanding of Relational and Dimensional Database Concepts. 
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and Workflow Development, data cleansing, data quality validation and unit testing. 
• Expertise in setting up server, publisher settings and configurations. 
• Expertise in designing in QlikView with complex multiples data sources (SQL, Oracle, Flat Files) relational designs and optimizing applications by using QVD's, removing non key fields and script variables (Loading phase). 
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients. 
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's. 
• Expertise in QlikView 11.0 SR1/10.0 SR3 installation and upgrading existing version. 
• Experience in creating ETL Applications for QVD's and QlikView Scripting variables and File, Date, System, Mapping, and Table functions. 
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture. 
• Interacted with Customers for requirement gathering and effective analysis. 
• A team player with exceptionally good organizational, analytical, training, troubleshooting, and interpersonal communication skills 
• 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. 
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.

Technical Skills

Education

 • Master in Computer Science from University of Maryland, College Park, MD

Professional Experience

QlikView Developer

JPMorgan Chase & Co. is an American multinational banking and financial services holding company. It is the largest bank in the United States, with total assets of US$2.509 trillion. It is a major provider of financial services, 
The main aim of this project was to develop and upload dashboards in Qlikview from where the end users can analyze the credit Reports. The Reports developed in this project gives complete analysis on different products. 
 
Responsibilities: 
• Work directly with business users to define and prototype Qlikview Applications. 
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement 
• Design, Develop, Test, debug and implement Qlikview solutions based upon specified requirement. 
• Extract, transform and load data from multiple sources into Qlikview applications 
• Created QVD's & updated on timely basis as database updates 
• Deploy applications on production server and set up automated data reloads 
• Create PDF push reports using Qlikview report editor 
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins 
• Developed Qlikview Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.) 
• 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 & snowflake schema (confirmed dimensions).Writing SQL Scripts to load the relevant Data in Qlikview Applications 
• Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications 
• Design, Build, Test, Debug the Qlikview application in QV Test server environment. 
 
Environment: Oracle 10 g,, Excel, QlikView 10.0, Windows Server 2008 R2

QlickView Developer

Description:
 
The University Library, a campus wide network of libraries serving programs of learning and research in many disciplines, is the largest public university research library in the United States. The Library is a worldwide leader in the dissemination of knowledge through remarkable research collections, outstanding services, innovative technologies, and exceptional faculty and staff. 
The Library Gateway is designed to provide a multitude of resources, both print-based and electronic, as well as to offer detailed information about our ongoing services. As the original claim system was built on Oracle and Business Objects become out dated and had to replace the Oracle database and the front-end application and the reports were built using QlickView. 
 
Responsibilities: 
• Identified problems, reporting requirements and problems in existing systems design. 
• Collaborated with Business Intelligence team to learn current processes and practices. 
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical and Extension tables. 
• Identified various KPI's and analyzed existing Business Objects Reports. 
• Generated new QVD files from the EDW by writing scripts in QlikView applications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys. 
• Extensively worked on QlikView Set Analysis. 
• Created batch scripts to process the data periodically as per the requirements. 
• Applied metrics in the data via QlikView scripts and transformed QVDs. 
• Designed and Developed QlikView dashboards using Chart Box, List, Input Field, Table Box, and Calendar. 
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources. 
• Involved in performance tuning to optimize the functionality of dashboards. 
• Provided production support to the existing Qlikview applications. 
 
Environment: QlikView 11 SR1, Oracle 11g, TOAD, Business Objects, Erwin Data modeling,

QlickView Developer

Shared Technology Services Group Inc., also known as STG, a Plymouth Rock Company, identifies, develops and maintains technological solutions for The Plymouth Rock Group of Companies. 
Responsibilities: 
• Extracted the data from various data sources such as databases, Excel documents and CSV files, transforming the data into standard format and load the data so that it is available for analyzing and creating reports. 
• Worked closely with Business to design, develop and enhance the Hyperion Reports. 
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables. 
• Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application. 
• Installed and configured Qlikview 9. 
• Customized QlikView reports to interact with Hyperion IR 
• Application processed tables with over 20 million records. 
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys. 
• Created batch scripts to process the data periodically as per the business requirements. 
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy. 
• Experience in scripting QlikView Set Analysis and Macros. 
• Altered the QlikView scripts based on any unusual latency in the response time on the UI. 
• Created User Interface and prepared layouts for the system by using QlikView. 
• Participated in the developing/enhancement of star schema dimensional data model. 
• Used MS Access and QlikView extensively as reporting tools and to create user build specifications 
• Assisted in upgrading from QlikView 8.2 to version 9.0 
• Wrote scripts and created batch files for automatic running of QlikView scripts. 
• Worked on the UI for various applications 
Environment: QlikView, Set Analysis, Hyperion IR, Oracle 10g, PL/SQL 8.0, SQL*Plus, SQL Developer, MS Access.

SQL Server Developer

SQL Server Developer

Lucent Technologies

January 2012 to November 2012

Developed T SQL code for the application 
● Modifie the existing database by adding the tables and maintained relationships between the tables. 
● Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub. 
● Enhanced the business logic using User Defined Functions to retrieve information on the services like customer, and large business databases. 
● Created SSIS Dynamic Packages using variables and deployed the SSIS packages. 
● Implemented Incremental loads using different kind of tasks using SSIS. 
● Used Event Handlers for Exception Handling in SSIS packages. 
● Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS). 
● Created, Managed and Support existing reports using SSRS. 
● Involved in creating, deploying and configuring reports according to the requirements using SSRS. 
● Developed different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). 
● Developed cubes using SSAS involving multidimensional data. 
● Supported various sectors like Development, testing, Production, Maintenance and Application teams. 
● Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard. 
● Executed Test cases manually Using Quality Center. 
● Maintained the client relationship by communicating the daily statuses and weekly statuses of the project. 
● Managed requests that came from the development team