SUMMARY

• Over 8+ years of experience in designing and analyzing IT applications in offering invaluable information to help companies serve customers better and optimize critical business processes.
• Provide excellent service and quality solutions in the development, enhancement and maintenance of user Interfaces and Business Intelligence packages
• Over 6 years of experience in customization of Qlikview Business applications in Qlikview Ltd. Sector, Manufacturing, Sales, Production Planning, Sales & Distribution and Call Center.
• Extensive experience in developing different analytical applications using QlikView 8.x/ 8.5/9.0/10.0/11.0 suite of Products (QlikView Server, Publisher and Qlikview Enterprise)
• Experienced in creating customized reports, filters and charts in Qlikview..
• Strong knowledge in developing highly informative dashboards using QlikView objects like ListBoxes, MultiBoxes, Tables, Charts, Current Selection Boxes, Buttons, etc and variables, fields, calculated expressions, basic and aggregated functions.
• Experience in importing data to QlikView from databases, QVD files, text files and connecting to external datasources to generate different dashboard style reporting user interfaces.
• Strong skills in designing and developing of relational database management objects and database design principles using eSQL database system
• Strong skills in object - oriented programming and the use of abstract data types. Expertise in Java, SQL, C++, VB, PHP, XML
• Good understanding of .NET Framework (2.0/3.0/3.5), with experience in ASP.NET, ADO.NET.
• Hands on experience in HTML, Java Script, Oracle & My SQL
• Expertise in writing complex SQL queries to work with database system
• Excellent Management and Communication skills with Leadership and Decision making capabilities for achieving maximum levels of productivity
• Fast-learner with good inter-personal skills and able to withstand pressure.

TECHNICAL SKILLS

Web Technologies: PHP, HTML, JavaScript

Operating Systems: Windows 2003, Windows XP Pro, Linux

Languages: C, C++, Java

.Net Technology: ASP.Net, VB.Net, C#.Net

Other Tools: Microsoft Office Suite, Macromedia Dreamweaver, Unified Modeling Language (UML), Eclipse

Database: MySQL, ORACLE 9i/10g/11g, SQL Server 2003, MS Access

Business Intelligence: QlikView

PROFESSIONAL EXPERIENCE

Confidential, MO

Qlikview Consultant

Responsibilities:

• Created a standard self-learning training application for new users of Qlikview.
• Centralized the list of users having access to multiple applications in Qlikview such that it is easy to track which user has access to which application.
• Created a Year over Year sales reports such that management can track the performance of particular product.
• Developed a report in such a way that a user can see the total number of sales and the revenue generated by it just by the click of a button.
• Defined standard themes and color coding schemes to improve the look and feel of applications.
• Designed a sophisticated security for a Qlikview application such that different users don't see each other's information.
• Helped management make faster and better business decisions by creating informative dashboards.
• Created reports that saves upto 500 hours/year and standardized it in such a way that it easy to maintain every year.
• Developed a Qlikview dashboard in a way that a business user can create his/her own custom made report rather than a standard report.
• Designed custom made reports for Ipad which can be viewed offline.
• Worked with data warehousing team to create standard rules and procedures for data validation which reduces QlikView’ s application development time.
• Improved QlikView’ s application performance by creating as much backend coding such that the server's memory is utilized rather than user's computer memory.

Environment: Qlikview 11, SAP, MS Access 2007, MS Excel

Confidential, IL

QlikView Consultant

Responsibilities:

• Developed, enhanced, re-engineered, maintained and supported QlikView applications.
• Experienced in installing QlikView, maintaining Publisher settings via the control panel, setting up user accounts and maintaining CALs (Client Access Licenses), creating ZFP (Zero Footprint Application or Zero Footprint Client version) of the stand alone applications.
• Developed several BI applications using QlikView BI development platform connecting to and integrating data from PostgreSQL database using an ETL load script, VBScript and standard expressions for calculated dimensions on charts and tables
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Documented report requests in the form of Functional and Technical specifications
• Created dashboard style of layouts using different components of QlikView Enterprise like Listboxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Extracted information from disparate data sources like excel files, QVD files, flat files, etc. by using different scripts like add, concatenate, resident, concatenate, qualify, unqualify, etc.
• Customized and tweaked the scripts for cross-tables and generic loads and created simple and complex expressions.

Environment: Qlikview 8.5, SQL server 2005, Remedy Tool, Team Foundation Server 2008, HP Quality Center

Confidential

QlikView Developer

Responsibilities:

• Developed different user interactive dashboards with complex source systems by extracting data from the database, storing into QVD files, writing complex ETL scripts and developing UI according to business requirements
• Created and managed ETL script generation using QlikView Script Builder Application.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and notified by email to the operators if anything went wrong.
• Optimised existing data models including changing load scripts to load data in optimised way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure
• Provided support analyst when internal teams have enquiries
• Write batch scripts in VBS to automate tasks
• Research and troubleshoot technical problems
• Trained end users

Environment: Qlikview 8.5, SQL server 2005, Remedy Tool, Team Foundation Server 2008, HP Quality Center

Confidential

Qlikview Developer

Responsibilities:

• Designed, developed, implemented, tested, and supported solutions using Qlikview functionality and technologies.
• Worked with the development team to produce a data model that supported the team to prototype, test, and debug reports/cubes to meet business requirements.
• Created and executed test plans/scripts to find errors and confirm reports/cubes meet specifications.
• Analyzed code to find root cause of errors and revise reports/cubes accordingly.
• Worked directly with Qlikview on debugging efforts and trouble tickets.
• Provided technical assistance with troubleshooting reports/cubes by responding to inquiries and questions.
• Created Qlikview macros to automate cube build and report delivery.
• Produced deliverables by gathering information and understanding the business needs and objectives.
• Managed and maintained the security system for external users.

Environment: Qlikview 8.5, SQL server 2005, Remedy Tool, Team Foundation Server 2008, HP Quality Center