Highlights:

• Over all 5.9 yrs of IT Exp. including business intelligence as Project Lead in different organization
• Working Exp. with US client like Humana
• Extensively worked on QlikView Reporting
• Good Knowledge in designing Dashboards and Reports in QlikView
• Experience in interacting with clients for requirement analyses, design and user acceptance testing
• Experience in software complexity estimation
• Strengths include business process re-engineering, data analysis and data modeling, user experience and report design, and an understanding of sustainable business practices
• Experience in writing and reviewing test plan and test cases
• Worked primarily in Account, Production, Sales Finance and HealthCare Domain
• Capable of leading a team of developers to achieve the target and deadlines, multi-tasking, meets deadlines as an individual contributor and also a good team player
• Expertise in people and project management, problem-solving and trouble-shooting capabilities, creation and implementation of KPIs, deliveries as per SLAs. Possessing in-depth understanding of the business needs on multiple domains, logical problem solving approaches, good communication and motivation skills
• Received Syntel ‘Synergy’ award for Trust between members within and across cross functional teams help in efficient and effective contribution

Technical Skills:

BI Tool:

Qlikview, Informatica

Web Technology:

HTML, DHTML, Java Script, VB Script, HTML, JSP, ASP, XML

Languages:

C, C++,VB, CoreJava, JSP,J2EE,XML,EJB, FoxPro, VB/ASP.NET

Databases:

Oracle (9i, 10g), SQL2000, MS SQL server 2005, FOXPRO Databases

Reporting Tools:

MS SQL Server Reporting Services, FoxPro Reports, Crystal Reports, Qlikview, Business Objects

IDEs and Tools:

Eclipse, MS Visual Studio 2010

Office Tools:

MS Excel/Access/PowerPoint/MS Word Toad, SQL Developer, Visual Source Safe 6.0, Microsoft Office 2003

Operating System:

Windows-XP, Windows 2000/2003, Linux, Unix, Solaris

Networking:

Basic knowledge of Networking

Applications:

Int-E-View, PC COMP, other customised packages

ERP:

Int-E-View

Professional Courses:

• Successfully completed “Core Java & J2EE” course from NIIT, Pune with ‘A’ grade
• Completed Oracle Professional course from SSI Computer Education Institute, Pune

Core Competencies:

• Strategic Planning
• Contract Negotiations
• Budgeting & Financial management
• Operations Management
• Staff Training & Development

Employer’s Profile:

December 2010 – Present

Confidential

Project Lead

April 2010 – November 2010

Confidential

BI Consultant

April 2008 – December 2009

Confidential

Software Consultant

April 2006 – March 2008

Confidential

Software Programmer/MIS Head

Current Employer:

Company : Confidential,
Designation: Project Lead - Business Intelligence
Period : 8 Months (Dec 2010 – Till Date)

Project Details:

Company: Confidential, (Mumbai), March 2003 – Till Date

Client:

Confidential, (Louisville, KY - USA)

Duration:

May 2011 – Till Date

Team Size:

6

Environment:

Qlikview, Oracle, SQL

Project:

Server Monitoring, HEDIS and Financial Reports Development

Job Description: Confidential,is a leading Insurance Provider in US, as part of various initiatives associated with insurance, Confidential,needs to evaluate past data for understanding the relation between various treatment, disease and prescriptions for which it needs to study past historical data. Humana being a very large organization needs to control and audit the customer details. For Data mining, ETL, analyzing and reporting Humana refers Qlikview BI tool. QlikView pioneered the in-memory business intelligence space on the premise that meaningful analysis belongs in the hands of the users who need the information, when they need it. QlikView\'s in-memory analysis and reporting capabilities deliver one-click access to dynamic, visually rich, interactive dashboards anyone can build and modify easily. QlikView also enables users to consolidate information rapidly from any data source, and search it with Google-like ease. QlikView allows users to see and know their businesses in new ways and interactively explore data without limits. Empower users to perform their own data analysis and change dimensions “on the fly.”

Role:

• Part of QlikView COE(Centre Of Excellence)
• Participated in project and planning, documentation, budgeting, and requirement analysis
• Managed project review and implement technology standards company-wide
• Led 6-person team
• Responsible for development and management of budgets, determining project scope, liaising between clients and staff throughout project lifecycle, and ensuring objectives were met
• Involved in database analysis and data modelling
• Oversee development and support
• Involved in Prototyping the reports in QlikView
• Interaction with the client on daily basis to understand their existing reports and the requirements
• Performance tuning
• Involved in Extracting, Transforming and Loading data from different data source
• Assisting developers in understanding the business requirement
• Developed dashboard for concurrent user and their logs
• Code review
• Maintain QlikView applications in directory structure
• Developed different dashboard like Chart Retrieval, Measures Review, Workload Disbursement, Reconciliation for HEDID reports
• Experience Incremental load and SET Analysis
• Experience QlikView Publisher environment for reloading and distribution of applications
• Assist in testing the applications after migration
• Helped develop detailed project plans for multiple simultaneous projects, resulting in increased visibility of inter-project dependencies and improved development efficiency.
• Implemented user access for the applications
• PDF report generation and auto emailing of reports
• integration with other applications
• Involved in team management
• Developed application for handling report of 10 QlikView Servers
• Experienced in creation of different Dash Boards for Session log, Performance log, Event log
• Planning and monitoring of the tasks and accordingly creating tasks in QMC and assigning it to team members
• Provided necessary coordination to contractors and subcontractors
• Managed development and implantation of mechanization process for data uploading, and reporting for clients
• Manage software system development and integration projects through all phases of project life cycle - analysis, design, development, testing, implementation, and post-production support
• Experienced in IT project budget analysis, outsourcing strategies, and contract management
• Documentation of the requirement and preparation of Dimension measurement matrices and share the same with development team

Client:

Confidential, (Louisville, KY - USA)

Duration:

Dec 2010 - May 2011

Team Size:

6

Environment:

Qlikview, Oracle, SQL

Project:

HEDDIS, Leadership, Management and Operational Reports

Role:

• Presales project requirement gathering, coordination with business analyst and pre sales teams.
• Documentation and review of BRD/SRS.
• Created sample Application and did Memory foot print server Test
• Resource allocation and management.
• Depth knowledge in Data warehousing, data mining and data/structural architecture.
• Data modelling/data warehousing on various databases like flat files, SQL 2000 & 2005, MS access, SAP and Oracle to fetch the data into qvds/models.
• Proven ability to deliver high quality IT products and services on schedule and under budget.
• Responsible for the recruiting, management and career development of consulting staff,.
• Implemented new production methodologies that resulted in optimizing employee\'s time to finish the tasks, thus enhancing employee efficiency
• Responsible for status reporting, client communication & coordinating with the project management team for timely completion and quality maintenance of projects
• Conducted clients\' communication sessions to evaluate client needs & ensure timely project delivery
• Conducted POC (Proof of Concepts)demo
• Creation of automatic schedulers to reload the data as per requirements
• Involved in ETL and report development
• Involved in requirement analysis and requirement gathering
• Maintain3-Tyer architecture
• Used Windows scheduler, batch files for refreshing Qvd and Qvw.
• Used triggers and macro
• Identification data Sources and Targets for data modeling and solution architecture.
• Involved in data modeling
• Code Review

Previous Employer:

Company: Confidential,(Mumbai), April 2010 – November 2010

Client:

Confidential, (Mumbai)

Duration:

October 2010 – November 2010

Team Size:

4

Environment:

Qlikview, Oracle, SQL, MYSQL

Project:

Ishare

Role:

• Involved in requirement analysis and requirement gathering
• Responsible for creation of Delivery Matrices, Effort estimation and Project schedule
• Application review for Query Optimization.
• Developed QVD generator at various levels for data extraction and main application development
• Developed IShare system for Music and Video.
• Developed Incremental Data Load and reloading of applications on hourly basis with batch files and windows scheduler.
• Experience in developing data tree format as per the requirement.
• Data cleansing.
• Involved in code Reviews and Optimization
• Experience in creation of different Dash Boards.
• Used triggers and macro for automatic spreadsheet and pdf file creation.
• Maintain Qlikview applications in directory structure.
• Experience in testing QlikView application in various environment.
• Involved in providing various features like Print to PDF, access control and limit load of application.
• Creation of section access.
• Co-ordination within different teams.

Client:

Confidential, (India)

Duration:

Sept 2010 – Oct 2010

Team Size:

3

Environment:

Qlikview, Oracle, SQL, SAP, MOVEX ERP

Project:

Ishare

Role:

• Involved in requirement gathering, feasibility studies,preparing Software Requirement Specifications (SRS) and estimation of service request.
• Data modeling at Qvd generation and application level.
• Interaction with the client on daily basis to understand their existing application and the requirements.
• Involved in performance tuning of queries used in the application.
• Project management viz. Conducting Audit.
• Assisting developers in application/database related Queries/issues.
• Assisting developers in understanding the business requirement.
• Created database applications including tables, views, procedures, triggers and macro.
• Master Qvd generation with multiple xls files.
• Implemented set analysis with various requirements.
• Performance tuning for newly developed Sales and Inventory Applications.
• Testing of newly developed applications.
• Testing developed applications with LIVE data environment.
• Preparation of Implementation Document required to moved the code into Live system
• Execution of batch files by building windows scheduler on monthly, weekly, daily and hourly basis
• Preparation of Project Documentation.
• Coordinating with clients with any issue faced.
• Involved in setting up the quality process.
• Interaction with the client on daily basis to understand their existing application and the requirements.
• Assisting the team in application/database related Queries/issues.

Client:

Confidential,

Duration:

June 2010 – Aug 2010

Team Size:

5

Environment:

Qlikview, Oracle, SQL, JINIVA Database

Project:

International Calling Card

Role:

• Involved in project planning and execution.
• Communicating project status to client on daily basis.
• Identification Sources and Targets and created Data Integrator mappings between sources and targets.
• Created transformations, workflows, dataflow, data store scripts according to business requirement.
• Experience in Partitioning, Analytic functions, materialized views
• Involved in understanding and gathering requirements of project.
• Created different 126 applications and dashboards with procedure and triggers.
• Performance tuning of newly developed applications and existing SQL Scripts
• Coordinating with clients on daily basis related to issue and update.

Client:

Confidential,

Duration:

April 2010 – June 2010

Team Size:

5

Environment:

Qlikview, Oracle, SQL, JINIVA Database, Business Objects

Project:

BO

Role:

• Involved in project planning and execution.
• Communicating project status to client on daily basis.
• Identification Sources and Targets and created Data Integrator mappings between sources and targets.
• Created transformations, workflows, dataflow, data store scripts according to business requirement.
• Experience in Partitioning, Analytic functions, materialized views
• Involved in understanding and gathering requirements of project.
• Created different 126 applications and dashboards with procedure and triggers.
• Performance tuning of newly developed applications and existing SQL Scripts
• Coordinating with clients on daily basis related to issue and update.
• Developed Project Documentation for each application.

Straights:

• Multi-Cultural understanding and exposure
• Excellent interpersonal skills in communications, client relations, and negotiation. Team management skills
• Like listening to people
• Take advice from everyone possible
• quick learner
• Ambitious, positive attitude and good grasping skills
• Optimistic
• Experienced in IT project budget analysis, outsourcing strategies, and contract management.
• A highly motivated, energetic individual, and a team player with excellent analytical and problem solving, and interpersonal skills, and interpersonal skills

Educational Qualifications:

• PGDIT (Information Technology)
• BCS(Computer Sci.)
• Diploma in Comp Engg.