SUMMARY

• Having 8+ Years of Experience in Business Intelligence, Decision support systems and software development projects.
• Global experience in implementing QlikView and Business Intelligence Solutions to the business needs of Post Trade Operations, Sales, Finance and Marketing divisions in Clearing House, Investment Banking, Logistics and Manufacturing business domains.
• 3+ years of experience in Designing and Development of Business intelligence application with QlikView 10.0, 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 10.0/11.0 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.
• Installation & configuration Of QlikView Enterprise in clustered, single server and Fail over mechanism.
• 5+ years of experience in designing and development of SAP Business Objects 4.0,BOXI 3.1, BOXI R2,Crystal Reports 2008, Xcelsius 2008 Dashboards
• 1+ Years of exp in SAP BODI (Business Objects Data Integrator) ETL tool.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
• Skilled in scheduling jobs in QlikView Enterprise Management Console (QlikView Publisher) and managing license and user accounts in QlikView Management Console.
• Skilled in conducting Business meetings, Business Requirements Gathering & Analysis and Functional Requirement Translation & Documentation.
• Experienced in Training & Supporting end - user reporting needs using QlikView & Business Objects products.
• Skilled in QlikView, Business Objects, Crystal Reports and BODI tools.
• Expertise in Data Modeling ( Star Schema, Snow Flake Schema)
• Worked in all phases of Business Intelligence Life Cycle and Software Development Life Cycle.
• Specialized and knowledgeable in writing SQL queries using Oracle, SQL Server Databases, Strong knowledge in Data warehousing concepts.
• End user/client-facing experience and interacting with the users and resolve the issues as per their criteria.
• Hands-on experience in FX Derivatives, Stock Derivatives, Currency Derivatives, Commodity Derivatives etc.
• NSE Certified in Financial Markets and in Currency Derivatives.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView Enterprise v 9.0,10.0,11.0, Business Objects XI R2/R3, 4.0, Crystal Reports 2008, Xcelsius 2008, BODI XIR2, BODS

Databases: Oracle 11/10.x/9.x/8.x, SQL Server 2008, Sybase, MySQL

Languages: SQL,PL/SQL

Tools: Toad 9.x, Oracle SQL Developer, Clear Case, Quality Control

Operating Systems: Windows XP, 2000 & Vista, 2003, 2008, UNIX

Office Tools: MS Word, Excel, PowerPoint, Outlook

Scheduler: Autosys, Control-M

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Environment: QlikView 10.0, QlikView 11.0, Oracle 9i, Sql Server 2008R2, Windows Server 2008, Control-M, Sql Developer

Responsibilities:

• Developed User Interactive Sheets & Reports as business needs.
• Developed Complex Graphical User Interactive reports using various QlikViewObjects.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity)
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, 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.
• Automated the reloading process using windows Schedulers and Implementing the Section access.
• Participated in daily scrums meeting as part of the SDLC process.
• Created documentation related to the application design and provided system documentation for day to day maintenance of the application.

Confidential, New York, NY

Environment: QlikView 10.0, Business Objects XI3.1 SP2 / XI R2, Web Intelligence, Info View, Universe Designer, 4.0, Crystal Reports 2008, Oracle 9i, Sybase, Control-M, Sql Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data Specifications about the Forex Clear.
• Developed Complex Graphical User Interactive reports using various QlikViewObjects
• Generated new QVD files from the EDW by writing scripts in QlikView applications
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs
• Scheduled and managed QlikView jobs using QlikView Scheduler for QlikView application dashboards
• Implemented Triggers using Macros to provide custom functionality in Dashboard Applications
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data Specifications about the Swap Clear.
• Implemented SECTION access for the applications
• Involved in Extracting, Transforming and Loading data from different data source
• Experience in transformation of external data sources to QVD’s and from QVD’s to QVW reports
• Developed extensively Alerts, Variables, Input boxes, calendar, triggers & Macros
• Installation/Configuration of QlikView10.0
• Developed KPI’s and set analysis applications. Experience in Using QlikViewFunctions (Date and Time, Keep, Join, Mapping)
• Created of automatic schedulers to reload the data as per requirements
• Implemented Security & involved in Deployment of QlikViewApplications
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data Specifications about the Repo Clear.
• Involved in Extracting, Transforming and Loading data from different data source
• Implemented SECTION access for the applications
• Identified data Sources and Targets for data modeling and solution architecture
• Setting up tasks for different application enterprise wide on Dev, QA and Prod environment
• Developed effective QlikViewdata models on flat files and Sybase to fetch the data into Qvds/models
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data Specifications about the Group Fees
• Created Accounting, Banking & Group fee Reports by using QlikView
• Modified existing QlikViewReports
• Installation/Configuration of QlikView10.0
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys
• Developed QlikViewDashboards using Drill Down & Cyclic Grouping
• Provided Training Sessions on QlikViewcapabilities to potential clients
• Developed webi reports/Crystal Reports for the Service Reporting as per the requirement
• Developed Universes using Designer module in Business Objects
• Developed Remedy tickets Weekly & Monthly dashboards for different clearing services
• All the Scheduled report jobs were built and maintained through Info view. Output destinations in shared location in various formats such as PDF & Excel.
• Having good knowledge on Clearing & Settlement process
• Used publication to burst the reports to different users
• Designed a Corporate web intelligence template based on the corporate standards

Confidential, Reading, PA

Environment: Business Objects XI3.1 SP2 / XI R2, Web Intelligence, Info View, Universe Designer, SAP BI 7.0/ BW 3.x, BEx analyzer, Query Designer, Web Application Designer, Crystal Reports, Crystal Xcelsius2008, Oracle10g, Windows 2003 Server.

Responsibilities:

• Attended requirement gathering meetings with business users
• Designed and modified Universes from data mart by defining joins, cardinality between tables. Added/created complex objects and derived tables
• Used shortcut joins, aggregate tables
• Created and maintained Universe using features like aggregate aware, Index aware, Conditions and hierarchies to optimize the universe
• Universe development and performance improvement
• Developed Master/Detail web intelligence reports with drill functionality
• Created reports using hyperlinks, multiple data providers in web intelligence
• End user training on the Fuel and Repair Order Reports
• Designed functional and Technical specifications for Complete end to end Implementation and Development of BO XI 3.1 over SAP BI
• Created query using QAAWS and using Dynamic query's created Xcelsius Dash boards
• Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints
• Maintained warehouse metadata, naming standards and warehouse standards for future application development
• Created Complex Reports such as linking of Two Reports, Drill Down and Drill Up using Webi
• Using BO, Various types of reports like Simple, Drill down Report, and Grouped Cross Tab are created for better analysis
• Used Ad-hoc Query Designer, Web Application Designer to develop web reports
• Implemented Web Intelligence reports by using all business objects functions
• Maintained BOE server over SAP BI and responsible in resolving the tickets.
• Involved in production support activities and solved tickets based on Webi reports and Xcelcius dashboards
• Strong technical, communication, time management and interpersonal skills
• Created and distributed the reports using Crystal Reports

Confidential, Reading, PA

Environment: Business Objects XI3.1 SP2 / XI R2, Web Intelligence, Info View, Universe Designer, Import Wizard, Crystal Reports, Crystal Xcelsius2008, Oracle10g, Windows 2003 Server.

Responsibilities:

• Client discussions to understand the existing environment
• Used the Import Wizard and BIAR file for migration
• Resolved the issues related to webi after migration to BO XI3.1 SP2
• Testing of the reports/universes/users/profiles
• Creation of Publication based on dynamic recipients list
• Xcelsius Dashboards used the QaaWS and Live Office connectivity to create the dashboards

Confidential

Environment: Business Objects XI R2, Web Intelligence, Info View, Oracle 9i, SQL, Toad.

Responsibilities:

• Worked on Requirement gathering stage to Reporting stage (End To End)
• Created the tables in dwh by pulling the data from Oracle apps and building the Reports
• Prepared the Report mapping
• Development of Universe using Designer Module in Business Objects XI
• Created user response functions, Alerters, Universe level prompts, Merge dimensions, Multiple Data providers in the reports as per user requirements.
• Build the webi Reports using Business Objects Reporting Tool.
• Created the MD70 Document with Report building steps.

Confidential, Pittsfield, MA

Environment: BODI, BO 6.1.3, Designer, Supervisor, CMC, CCM, Oracle 9i, SQL, Toad and Autosys

Responsibilities:

• Involved in analysis of existing System
• Carry out Support, Maintenance and Enhancement activities on EDW.
• Scheduling and Maintenance of Jobs in Autosys (Unix Scheduler)
• Involved in close monitoring of all Autosys jobs of EUR pole
• Implemented RCCA for recurrent failure.
• Involved in handling job failures.