OBJECTIVE:

• Seeking a position to utilize my skills and abilities in IT’s Business Intelligence world which offers professional growth for me and business growth for my client.

PROFESSIONAL SUMMARY:

• 10+ years of experience in IT’s Business Intelligence space
• 3+ years of experience as QlikView Architect
• 5+ years of experience in QlikView Development and QlikView Server Administration.
• 3+ years of experience in Excel Reporting

TECHNICAL SKILLS:

Technology and Tools: QlikView (Client and Server) 8/9/10/11, QlikView Web parts for SharePoint, Crystal reports 8.5/9.0/10/11 , Crystal Enterprise 8.5/9.0/10, Business Objects, VB6.0, Excel Reports, C, C++, IIS, Oracle, DB2, SQL Server, Sybase.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Responsibilities:

• Leading a team of 4
• Requirement Analysis
• Data Analysis
• QlikView Dashboard development including:
• Scripting
• Data Modeling
• UI Development
• Maintenance of the dashboards
• Production Support

Environment: QlikView 9/11, DB2, Excel

Confidential

Responsibilities:

• QlikView Server Administration:
• QlikView server and Client installations and upgrades
• QlikView server license updates
• Address QlikView server capacity issues
• QlikView application development:
• QlikView Usage application:
• Application that shows data about usage of various QlikView applications hosted under EBIS infrastructure.
• This application helps EBIS clients to look at the usage of their applications from different perspectives.
• Helps clients to analyze their users and enables them managing their QlikView licenses efficiently.
• Used by EBIS team to calculate monthly hosting charges for applications hosted in EBIS infrastructure. The costing is based on application usage.
• QlikView Licensing application:
• QlikView license holders in the firm
• New license requests
• Inactive users
• License cleanups
• QlikView 9 migration
• Qlikview 8 Environment decommission tracking
• Named to Session License Conversion analysis
• Falcon Incident Data Explorer (FIDE):
• A tool to analyze the various outages and their root causes.
• Exchange Outage Analysis (EOA):
• This is a tool developed specifically around outages on Exchange servers in Confidential .
• Trouble shoot user issues with QlikView infrastructure
• Application access issues
• Application reload issues
• Production Support
• Handle production issues and outages
• Co - ordinate with level 2 team on issues and outages
• Manage QlikView licensing
• Manage license transfers and assignments
• Inactive license revocation.
• Named User license to Session license conversion
• Analyze usage of QlikView licenses (using a QlikView application created by me) from different perspectives in order to find opportunities to reuse the licenses to save client money.
• Build Dedicated QlikView Servers
• Co-coordinating the efforts of migrating QlikView 8 applications to QlikView 9.

Confidential

Environment: BusinessObjects XI R2/R3, Crystal Reports, Excel Writer, Sybase

Responsibilities:

• Involvement in all the phases of SDLC cycle
• Leading the team and doing development
• Client Communication

Confidential

Environment: BusinessObjects XI R2/R3

Responsibilities:

• Requirement analysis
• Universe and Report Design
• Client Communication

Confidential

Environment: BusinessObjects XI R2/R3

Responsibilities:

• Requirement analysis
• Universe and Report Design
• Client Communication

Confidential

Environment: BusinessObjects XI R2/R3

Responsibilities:

• Requirement analysis
• Universe and Report Design
• Client Communication

Confidential

Environment: BusinessObjects XI R2/R3

Responsibilities:

• Requirement analysis
• Universe and Report Design
• Client Communication

Confidential

Environment: BusinessObjects XI R2/R3

Responsibilities:

• Involved in every phase of SDLC.
• Involved in ETL Architecture and Data warehouse Design.
• Creation of ETL mappings using Microsoft BI Platform (SQL Server Integration Services SSIS ).
• Develop cubes over the created data warehouse for analysis using SQL Server Analytical Services.
• Report development using SQL Server Reporting Services.

Confidential

Environment: Microsoft BI (SSIS, SSAS and SSRS), SQL Server 2005

Responsibilities:

• Analysis and development of the specifications.
• Analyze the dataflow and create the efficient stored procedures for the reports.
• Design the reports using Crystal Reports (8.5 and 10) as per the business requirements. Designing the reports in such a way that the report is in its most readable format was a challenge that we succeeded to achieve.
• Production Support, as ever, most demanding task of the project. Considering the huge reporting infrastructure that Confidential has this task was a challenge to handle. I handled it with quite good success.
• Scheduling and publishing reports on Business Objects XI.

Confidential

Environment: Crystal reports 8.5/10, Business Objects XI, Sybase, Composite, Excel Writer, Unix, Confidential Infrastructure tools like GQ (Generic Query, RGS Workbench etc).

Responsibilities:

• This was a very demanding project considering its huge reporting infrastructure and I learnt it in a very quick speed.
• Confidential Prime Brokerage Reporting was ranked #1 for consecutive 3 years in the Investment Banking world. Without any doubt I attribute this success to the hardwork done by our team throughout the years.
• Migration of existing reports created in Crystal Reports 8.5 to Crystal Reports 10.0 was a big challenge for me as it not only required to migrate the report templates but also required the Confidential infrastructure upgrade. Overcoming these difficulties I successfully completed the migration of various streams of Confidential reports.

Confidential

Environment: Crystal Business Objects XI R2, Crystal reports, SQL Server 2000, Business Objects XI, MS Project

Responsibilities:

• Analyze and understand the different data models on which reports will be created.
• Create stored procedures for the reports.
• Design reports using Crystal Reports (11) as per the business requirements.
• Getting the team member’s doubts and queries cleared from the onsite coordinator.
• Manage the deliveries from other members in the team.
• New team member grooming.
• Active member of SQA Consultant group in the organization.

Confidential

Environment: Crystal Reports, SQL Server

Responsibilities:

• Design reports using Crystal Reports (8.5/9.0/10) as per the business requirements.
• Database Designing.
• Manageable Coding using OOP’s
• Debugging

Confidential

Environment: Crystal reports, Crystal Enterprise, VB Script, Excel Reporting, Oracle

Responsibilities:

• Design reports using Crystal Reports (8.5/9.0/10) as per the business requirements.
• Publish the created reports on Crystal Enterprise (8.5/9.0/10) server.
• Manage the Crystal Enterprise server, Crystal Reports server and all the related installations.
• Handle the Crystal Reports module in our products SmartOffice, Client Data System (CDS), WCDSi and SOINDIA.
• Handle the crystal report’s integration with application, which involves java and scripting.
• Research related to Crystal Reports, Crystal Enterprise.
• Gather requirements from client for required projects/enhancements.
• Co-ordinate with client regarding scope and time negotiations.
• Understand business requirements and logic from the client and translate the same for technical team.
• Help Quality Assurance Professionals to prepare test cases and test plans.
• Test business logic of the applications.
• Follow ISO/Tick IT processes.
• Help Project Leader during various phases of SDLC.
• Coordinate with members of Release Group for related activities associated with the projects.
• Work on multiple projects at any given time.

Confidential

Environment: VB 6.0, SQL Server 2000, Crystal Reports

Responsibilities:

• Involved in each phase of SDLC
• Database Designing.
• Planning & Development of GUI.
• Coding using OOP’s
• Debugging
• Building Reports using Crystal Report 9

Confidential

Environment: VB 6.0, SQL Server 2000, Crystal Reports

Responsibilities:

• Involved in each phase of SDLC
• Database Designing.
• Planning & Development of GUI.
• Coding using OOP’s
• Debugging
• Building Reports using Crystal Report 9