Professional Summary:

• Around 7+ years of experience in IT industry with strong Skills in QlikView, Cognos, Informatica, BI, DWH, SQL Server, Oracle, SAP, ERP in designing, building and implementing custom interfaces in various domains like Sales, Inventory, Accounts, Finance, Tele Communications, Banking
• 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
• Around 4+ yrs of experience in QlikView
• Strong Skills in QlikView 10, 9.0, 8.5 in designing and creating dashboards and reports with various graphs and analysis
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version
• Experience in requirement gathering and gap analysis, Design, Application Development, Testing, Implementation and Support
• Database structuring and database application design and development
• Developed Complex Graphical User Interactive reports using various QlikView Objects
• Strong Skills in Data Modeling ( Star Schema, Snow Flake Schema) & Loading data from Multiple data sources
• Installation & configuration Of QlikView Software
• Experience in Incremental Loading & QlikView document Versioning
• Sound knowledge in writing SQL Queries, Pl/SQL Stored Procedures
• Good ETL skills ,Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity
• Good ETL skills ,Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance
• Implemented Triggers using Macros to provide custom functionality in Dashboard Applications
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys
• Provided Training Sessions on QlikView capabilities to potential clients
• Involved in Performance Tuning & Deployment of QlikView Applications
• Part of QlikView COE(Centre Of Excellence)
• Involved in Prototyping the reports in QlikView
• A team player with good interpersonal skills and work independently.
• Expertise in 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’s Synergy award for ‘Trust between members within and across cross functional teams help in efficient and effective contribution’
• Received ‘Extra Mile’ and ‘Customer Delight’ awards

Technical Skills:

BI Tool QlikView, Cognos, Informatica,

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

Languages C, C++,VB, Core Java, JSP,J2EE,XML,EJB, FoxPro, VB/ASP.NET

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

Reporting Tools MS SQL Server Reporting Services, FoxPro Reports, Crystal Reports, QlikView, Business Objectes

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 Experience:

Client Confidential Louisville, KY
Duration May 2011 – Till Date
Team Size 3
Environment QlikView, Oracle, SQL
Project HEDDIS, Leadership, Management and Operational Reports, ORR

Role:

• Created sample Application and did Memory foot print  server Test
• Presales project requirement gathering, coordination with business analyst and pre sales teams
• Develop effective QlikView data models on various databases like flat files, SQL 2000 & 2005, MS access and Oracle to fetch the data into Qvds/models
• Participated in project and planning, documentation
• Manage software system development and integration projects through all phases of project life cycle - analysis, design, development, testing, implementation, and post-production support
• Provide scripting support for the Analytics Department to meet complex business requirements
• Utilize QlikView Publisher capabilities
• Experienced Incremental Load
• Developed KPI’s and set analysis applications
• Extract, transform, and load data from multiple data sources into the QlikView application
• Design, Build, Test, Debug, Monitor, and Troubleshoot QlikView solutions
• Maintain3-Tyer architecture
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Implemented Hidden Script
• Implemented Security & involved in Deployment of QlikView Applications.
• Used Windows scheduler, batch files for refreshing Qvd and Qvw.
• Used triggers and macro
• Follow deployment process
• Develop documentation and transfer of knowledge
• Work with business support and technical experts as required
• Conducted clients' communication sessions to evaluate client needs & ensure timely project delivery
• Creation of automatic schedulers to reload the data as per requirements
• Provided necessary coordination to contractors and subcontractors.

 Client Confidential Louisville, KY

Duration Dec 2010 - May 2011

Team Size 3

Environment Qlikview, Oracle, SQL

Project Server Monitoring, HEDIS and Financial Reports Development

Role:

• Monitoring servers for the performance in terms of Memory foot print
• Interaction with the client on daily basis to understand their existing reports  and the requirements
• Involved in Extracting, Transforming and Loading data from different data source
• Involved in database analysis and data modelling
• Maintain QlikView applications in directory structure
• Developed dashboard which gives overall health of all the servers viz. No of users logged in, Usage of a particular application daily/weekly/monthly which helps in capacity planning, different reload tasks status.
• Implemented SECTION access for the applications
• Developed QlikView Dashboards using Drill Down & Cyclic Grouping
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Installation/Configuration of QlikView 10.0
• Developed KPI’s and set analysis applications. Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping)
• PDF report generation and auto emailing of reports
• Integration with other applications
• Performance tuning
• 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
• Documentation of the requirement and preparation of Dimension measurement matrices and share the same with development team
• Setting up tasks for different application enterprise wide on Dev, QA and Prod environment
• Reload of data on required/scheduled basis
• Proven ability to deliver high quality IT products and services on schedule
• Identification data Sources and Targets for data modeling and solution architecture.

Client Confidential
Duration October 2010 – November 2010
Team Size 4
Environment QlikView, Oracle, SQL, MYSQL
Project Ishare

Role:

• Involved in requirement analysis and requirement gathering
• Involved in requirement gathering, feasibility studies, preparing Software Requirement Specifications (SRS) and estimation of service request.
• Assisting developers in application/database related Queries/issues.
• Used Windows scheduler, batch files for refreshing Qvd and Qvw
• 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
Duration Oct 2010 – Oct 2010
Team Size 2
Environment QlikView, Oracle, SQL
Project Finance Reporting

Role:

• Enhancement in previous QlikView Report
• Created reports for Credit, Debit and reconciliation details reports
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Experienced Incremental Load
• Creating data model
• Experienced SET Analysis
• Unit testing, Code testing and Performance testing
• Performance tuning
• Implemented Section Access
• Implemented Incremental Load
• Installation/Configuration of QlikView 10

Client Confidential
Duration Sept 2010 – Oct 2010
Team Size 3
Environment QlikView, Oracle, SQL, SAP, MOVEX ERP
Project Ishare

Role:

• 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.
• 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:

• 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:

• 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.

Client Confidential
Duration April 2009 – Nov 2009
Team Size 7
Environment PC Soft ERP, Oracle, SQL, FoxPro
Project Int-E-View

Role:

• Involved in planning of various applications.
• Involved in requirement gathering and feasibility study.
• Involved in discussions with client for knowledge transition of applications.
• Co-ordination with clients on daily basis related to issue and updates.
• Introduced new application for ‘Future Booking’.
• Customization made for machine routing log and machine group plant wise.
• Online support provided for item account class and inventory.
• Released new TB group wise service tax Module.
• Designed various UDR (User Defined Report) for inventory purpose.
• Technical and functional Knowledge sharing within and across projects.
• Team & Module Management: Mentoring, Training, Business Induction of new members & preparation of Induction Manual
• Involved in Resource Management.
• Assisting team with understanding business requirement of the application.

Client Confidential
Duration Jan 2009 – March 2009
Team Size 7
Environment
Project PC Soft ERP, Oracle, SQL, FoxPro, VSS

Role:

• Provided online support.
• Assessing their Remote server and supported the clients for the changing needs.
• Preparation Bill of Material (BOM) with respective of son-item wise up to fifth level.
• Setting Pharmacopeia concept with respect to CCPC. (Central Coast Profit Centre).
• Implemented business rules for publication group using Stored Procedures, Functions and Packages.
• Prepared program specifications, unit test plans, Internal reviews to meet quality requirements.
• Hands on experience in the usage of Views, Synonyms, Sub-Queries, Cursors, and Exceptions. ss