PROFESSIONAL SUMMARY

• QlikView Developer with 9 years of IT experience, including 4 years of extensive Business Intelligence, Decision Support Systems and Software Development experience
• Over 2 years experience in designing and developing dashboards using Qlikview.
• Developed Complex Graphical User Interactive reports using various QlikView Objects.
• 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 using different data sources like DB2,Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Experience in advanced loading concepts like 'Incremental Reload', 'Partial Reload' and 'Binary Reload'.
• Sound skills in writing SQL Scripts and Pl/SQL Stored Procedures.
• Strong Database Development skills using SQL Server, DB2, Oracle and Teradata.
• Designing Data Mart and Data Warehouse and Implementation of QlikView for BI reporting Solutions.
• Involved in ETL Tasks data cleansing, Joins, Aggregation Tables using QlikView
• Develop Dashboard reports using various QlikView Objects.
• Excellent knowledge in Implementation of Relational Database OLTP , Data warehousing systems OLAP and Data Marts.
• 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 and Triggers.
• 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.
• Onsite-Offshore coordination in delivering Business Intelligence Solutions.
• Created statistical reports using SAS by extracting data from EDW Teradata Database
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC
• Built reports in Web Intelligence using BO XI involving advanced report functionalities like scope of analysis, Drill feature, formulae etc.
• Proficient in managing the entire application development operations involving requirement gathering,
• Development of functional specifications, design development and co-ordination with customer
• Domain expertise includes Banking, Insurance and Healthcare
• Well versed in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis
• Demonstrated professional excellence in understanding the customer's business needs and translate them into targeted and effective solutions that improve processes, increased productivity reduce costs
• Suave and pragmatic with excellent interpersonal and communications skills competent to work in highly diverse environments with people from varied backgrounds popular team worker with leadership traits

TECHNICAL SKILLS

Professional Experience

Confidential

Qlikview Developer

Responsibilities

• Worked with Business Analyst and the Business user to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
• Actively participated in the design, architecture and development of user interface objects in QlikView applications.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Created dashboards with complex sheets which include List boxes, Statistic boxes, containers, different charts bar charts, scatter charts, Heat charts, and Block charts and pie charts to show the statistics of the sales held on different products in different years.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Dynamically creating the WHATIF analysis reports by modifying the input data though slider object and input boxes
• Created Layout themes and applied it to several QVW's
• Used advanced scripting, Alternate states for comparative analysis, set analysis, VBScript and JavaScript macros, advanced aggregation functions, advanced charts for applications and Document chaining
• Involved in performance tuning of dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW
• Good understanding in the area of monitoring the various services in QMC,Task setup, Managing client licenses, Mounting folders, session collaboration,enable session,performance and audit logging,type of authorisation NTFS and DMS ,loop and reduce and Section access management in PAT

Environment: Qlikview 11.0, QEMC, SQL Server, DB2, Windows 2008 server, HTML, VB Script Java

Script, QViewer, Microsoft TFS, MS Excel, Geoqlik

Confidential

Qlikview Developer

Responsibilities

• Project requirement gathering, coordination with business analyst and pre sales teams
• Involved in designing of Qlikview solutions full lifecycle implementations
• Implemented the QVW files in a 3 tier architecture by loading the data from various external data sources thereby creating optimized QVD's and then building applications using transformed QVD's
• Develop efficient Qlikview data models using flat files, SQL 2005, MS access and Oracle
• Setting up of tasks, reloading data and refreshing the applications on a scheduled basis using Qlikview Management Console
• Implemented SECTION ACCESS for the applications
• Developed Qlikview Dashboards which comprises various charts,Objects,Drill down Cyclic grouping, Alerts,Variables,Input boxes, Calendar macros
• Experience in using Qlikview functions AGGR,PICK,MATCH,Date and time,Keep,Join,Mapping
• Experienced incremental loading,PDF report generation and auto emailing of reports
• Extensive use of SET analysis expressions in charts and shown the critical KPI's in gauge charts
• Implemented binary load and hidden script
• Implemented security and involved in deployment of Qlikview applications,used windows scheduler,batch files for refreshing QVD and QVW
• Utilized QlikView Publisher and QlikView Server capabilities though QEMC tool

Environment: Qlikview 11, QEMC,Oracle, SQL Server, Toad 9.6.1/SQL Developer, SQL Loader and Windows 2007.

Confidential

Business Objects Developer

Responsibilities

• Interacted with business users, business owners to know their Business views in developing, modifying universes and report development.
• Analyzed the existing database and created/modified the Universes using Business objects Designer Module.
• Created new Classes, Objects and Conditions. Detected Cardinalities and Loops. Resolved the loops by creating Aliases and Contexts and checked the Integrity of the Universes.
• Exported the universes to the Repository to make the resources available to the users.
• Used the functionality of linking universes so as to have the flexibility to use the objects defined in one universe in another.
• Created standard Full Client and Web I reports based on business requirements with drill down functionalities.
• Reports were formatted according to the user requirements using Business Objects functionalities like Breaks, Calculations, Slice and Dice, Drill Down and Variables.
• Organized data in the reports using Filters, Sorting, Ranking and highlighted data using Alerter.
• Used Import wizard to import existing User accounts, Groups, Categories, Universes, Web I Reports, Connections and Universe restrictions to BO XI R2 environment.
• Created complex reports in Web Intelligence and Desktop Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
• Created Web I reports with multiple data providers and synchronized the data using Merge Dimensions option in BO XI R2.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
• Created Crystal reports using Business Views and Universes as data providers.
• Created new Universes specifically designed for creation of Dashboards.
• Responsible for creating Dashboards, Metrics, Rules, Alerts and Goals using Performance Manager EPM XIR2 for user analysis based on user requirements.

Environment: SAP Business Objects XIR2 CMC, CMS, CCM, Designer, Desktop Intelligence, Web Intelligence, Info View, Performance Manager, Dashboard Manager, Import Wizard, Scheduler Manager , Crystal XI, Oracle 9i, SQL Server, TOAD, SQL, PL/SQL, Windows 2003 Server.

Confidential

Business Objects Developer

Responsibilities

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects universes and reports.
• Involved in creating repository and setting up of groups and users for Business Objects users.
• Scheduled the Web Intelligence reports using Info View.
• Designed and built universes, classes and objects.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the universes.
• Created hierarchy and conditions at the designer level.
• Exported the universes to the Repository to making resources available to the users.
• Involved in creating reports on the web using Business Objects Web Intelligence
• Created the reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Functions and Master Detail etc. Environment: Business Objects 6.1, Designer, Web Intelligence 2.7/Info View, Oracle 9i, SQL, SQL Plus, UNIX, Windows NT/2000.

Environment: Business Objects 6.1, Designer, Web Intelligence 2.7/Info View, Oracle 9i, SQL, SQL Plus, UNIX, Windows NT/2000.

Confidential

Module lead/Senior Developer

Responsibilities

• Led a team of 4, gained an insight about the business requirements, involved in application design, coding, review and testing
• Worked extensively on SAS to generate BDDS reports
• Modifying the existing JCL's, Procedures and Control cards and creation of new copybooks as a part of enhancement
• Used DB2 OLAP functions in SQL queries
• Performed DB2 stored procedure development, Dynamic SQL and Scrollable cursors and created triggers
• Generated EXPLAIN reports for SQL performance tuning
• Responsible for implementing the emergency and expedited changes
• Responsible for providing the status reports on weekly and monthly basis and also imparted knowledge
• Transition for the new members in the AMEX BU
• Fulfilled the SLA's as per the client requirements to solve the production problems and requirements

Environment: VS COBOL II, JCL, SAS, DB2, DFSORT, ICETOOL, CA-7 Scheduler, AVRS, OS/390

Confidential

Team member/Developer

Responsibilities

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Involvement in implementation of BTEQ and Bulk load jobs.
• Involvement in physical database design and database optimization, performance tuning.
• Created complex mappings to compare two databases SQL Server and Teradata.
• Developed FastLoad FLoad , MultiLoad Mload , TPump and BTEQ scripts to load data from various data sources and legacy systems to Teradata
• Used Workflow Manager for Creating, Validating, Testing and running the workflows and Sessions and scheduling them to run at specified time.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Analyzing production support documents and finding the feasible time to run their jobs through OPC scheduler
• Created tables, multitable views, views, macros using TD DDL.
• Created Logical Data Model from the Source System study according to Business Requirements.
• Create and execute test plans for Unit, Integration, and System test phases.
• Automated related tasks by developing UNIX shell scripts used to maintain the core EDW.
• Worked closely with Project Managers, Business Analysts, and BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements.

Environment:Z/OS,TeradataV2R6.0/12.0,BTEQ,FASTLOAD,MLOAD,BTEQ,FASTXPORT,TPUMP,

TeradataSQLAssistant, TeradataAdministrator,Teradata Viewpoint, MVS, JCL, COBOL, SQL,

ERWIN

Confidential

Team member/Developer

Responsibilities

• Analysis of the new application design document of all 4 releases of SCR
• Preparation of data dictionary, new component designs and review process of all 4 releases
• Development of new COBOL-DB2 programs, Minor enhancements to existing COBOL
• Programs
• Worked on COBOL XML parser to process the events in a processing procedure of a XML document
• Used Various XML functions such as REC2XML in DB2 SQL queries to built a XML from Column values in tables
• Preparation of Unit test plan and executing the test scripts, Documented the Unit test results
• Leveraged various DB2 utilities, Abend-Aid, File-Aid for DB2 heavily while building and testing the
• Applications
• Adhoc execution of SQL queries using SPUFI and reporting forms using QMF
• Created BMC load and unload jobs for loading and unloading data from DB2 Tables
• Closely working with the team members and providing them the solutions for any technical doubts

Environment: VS COBOL II, JCL, DB2, FILE-AID, ABEND-AID, OPC Scheduler, AVRS

Confidential

Team member/Developer

Responsibilities

• Understanding client's system and preparing technical design document based on high level design document for 6 applications related to backbone of FSG credit card management system
• Coding and executing Unit test scripts
• Created new BMS maps using Screen Definition Facility SDF and done code changes for the existing
• PL/1 programs accordingly
• Used Test Harness tool in testing the CICS programs

Environment: PL/1, JCL, DB2, CICS, FILE-AID, ENDEVOR, XPEDITER, SDF

Confidential

Team member/Developer

Responsibilities:

• Involved in project requirements capturing, identifying functional changes, design, coding and Unit testing
• Developed and modified PL/1 DB2 programs
• Developed a new Printing functionality using an interface from Mainframe to a print application on
• UNIX system using XML messages and MQSeries connectivity
• Done Technical design, code reviews and walkthroughs with Onsite technical team. Provided functional expertise, queries resolution with the help of Business

Environment: PL/1, JCL, DB2, CICS, SDF and MQ Series