Objective

To obtain a position as a QlikView Developer in a challenging environment, where I can utilize my Business Intelligence knowledge and experience, to achieve the best possible solution and benefit the organization.

• Over 6+ years of professional experience in the field of Business Intelligence and Analysis.
• Knowledge of industry best practices in both business management and technology domains.
• Adept at solving complex problems through a systematic approach that uses innovation and partnering combined with project management principles to maximize return on investment.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Worked as a QlikView Technical Consultant for a wide variety of business applications.
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Always worked in close association with customers and a single point of contact for many major implementation projects.
• IT industry experience in Insurance, Internet Security, Manufacturing, Supply-Chain Management and Financial with Functional knowledge in daily operation of these industries.
• Enthusiast and Experienced QlikView developer- the pioneered in-memory Dash boarding tool.

Technical Skill Set

• Dash boarding/Analytics: QlikView, Tableau, MS SharePoint, Salesforce.
• Languages : PHP, SQL, PL/SQL, VB Script, Shell Scripting.
• ETL Tools: SSIS, Informatica.
• Database Technologies: Oracle9i/10g/11g, SQL Server, Teradata, MySQL.
• Platforms: Windows Server 2003/2008, Linux (Ubuntu).
• Others: MS Access, MS-Excel, MS InfoPath, Visio.

Skills

• Prefer to work as pro-active person and like to help other employees as much as possible.
• Considerable Reporting and Dash Boarding (UI/UX Design) experience.
• Participating in pre-sales activity working with prospective client and assisting with technical contributions to help my employer win new business.
• Self-starter & Team Player with pleasing personality.
• Adapt to learn new technology and inclined to fast changing Mobile applications.
• Deeply involved in developing logic to solve complex industry problems.

Education

• Master’s Degree in Engineering,Confidential, Newark, NJ, USA.
• Bachelor’s Degree in Engineering, Confidential, India.
• Pursuing Oracle Certification (Expected to achieve by Oct, 2012).
• Currently pursuing QlikView certification (Expected to achieve by Dec, 2012).

Professional Experience

QlikView Developer / Administrator - Confidential, CA (April 2012 - Present)
Confidential is a world leader in Computer Networking Industry.

• This QlikView Project is for Finance Department, which includes Bookings, Revenue, Cost and Gross Margin.
• Leading team of five onshore Members, three offshore QlikView developers and one Database Admin.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Multiple levels of Hierarchies are implemented such as Sales, Product, Partner, Customers and Service Hierarchy etc.
• Maximum Application size is 8.5 GB, with 56 Booking and Revenue related fields, 500 million rows and associated with 98% data density.
• Worked with 40 core processor with two 1TB RAM server and two 256GB RAM servers, having monthly refresh.
• Was actively in the Server migration and the Fresh QlikView Installation process.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.
• The application is used by 46 Named CALs and 30 Document CALs licensed users with additional session licensed users as needed.
• Task set up are done using QEMC and created architecture for the interdependent applications and execute in proper order.
• Ad hoc excel reports are created based on the business user requirements.
• Forecasting model is created by using booking, revenue applications and created 4 year Forecast model and successfully implemented in QlikView.
• Worked with QlikView 10.x, SQL Server, TeraData, Excel, CSV files.

QlikView Team Lead / Developer-Confidential, KY (Nov 2011 - April 2012)
Confidential is a Fortune 100 company that markets and Administers Health Insurance, one of the largest Insurance Company and Federal Contractor for Health Insurance related Products.

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• This Project is related to marketing analytics, concern about the marketing of various insurance products and accepted pattern of the customers.
• Leading team of 4 Member, which includes two offshore Qlikview developers, one Database Admin.
• Providing executives and operational users with powerful analytic capabilities and detailed information on their operational and marketing performance.
• The Process was Agile and strict time line oriented. Worked closely with Project manager and scrum master.
• Created PDF push reports based on ‘loop and reduce’. Alternatively, wrote VB scripts to perform the same (based on requirement of user). Monthly distributed to specific user group via email, through publisher.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Application size is 39MB, with 178 demographic fields, 5 million rows of census data, associated with 95% data density.
• Created Heat map with alert mechanism. Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• Worked with 32 core processor with 200GB RAM server, having daily refresh. 2-tier QVD architecture is implemented and the final application is taking 27 second to reload.
• The application is used by 20 CAL licensed user, with additional session licensed users.
• Document event trigger and field event triggers is created. Incremental reloading is implemented
• Created Document for the project planning and production Interface Documentation.
• Four dashboards were created, along with helping other team to create Qlikview reports.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.
• Worked with QlikView 10.x and 11.x, SQL Server, Oracle, Netezza, Excel, CSV files.

Sr. QlikView Developer -Confidential, CA (Aug 2011 - Nov 2011)
Confidential is into the business of semiconductor chip designing and manufacturing.

• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed.
• Developed dashboards pertaining to KPI monitoring using QlikView10.x.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• Responsible for positioning and delivering QlikView projects and cross building applications into new and existing customer base.
• Worked as Subject Matter Expert (SME) for various projects. Taught the users to get along with Qlikview.
• There were 40 million records with daily incremental reload schedule.
• Emphasized on Data Integrity to good chart aesthetics.
• Performed time over time analysis of sales volume and revenue.
• Worked with QlikView 10.x, SQL, Excel files and flat files.

QlikView Developer - Confidential, CA (May 2011 - Aug 2011)
Confidential is the world\'s leading supplier of process control and yield management solutions for the semiconductor and related microelectronics industries.

• Worked with Business Analyst and the Business user to understand the user requirements, layout, and look and feel of the application to be developed.
• Two Dashboards were developed and served to track all the way through Ship to Final acceptance phase, which include Installation, Field STR, Pre-Warranty Aging etc; Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Setting up New task, mounting on Access Point, troubleshooting already existing task setup and other issues.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher
• Participated in pre-sales activity working with prospective client, assisting with Technical contributions to win new business.
• Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• There were 4 million records with incremental loading of 20,000/week.
• Enhancement and translation of the already existing Dashboards in MSRS into QlikView. Extensively worked with Set Analysis.
• Helped end users to design test cases and worked through multiple UAT cycles.
• Worked with QlikView 10.x, SQL Server, Oracle, SAP, Excel, flat files.

Sr. QlikView Developer and Admin- Confidential, CA (Jun 2010-April 2011)
Confidential is a cooperative of farmers, processing their produce for value addition.

• Collaborated with Business users and cross functional teams to develop Business Requirement Documents (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Active role in the design, architecture and development of user interface objects in QlikView applications.
• Work on requirement specifications for the strategic KPI\'s that drive performance and profitability in the division. Waterfall methodologies were followed during course of the project.
• Performed analysis, documentation for calculation for various attributes.
• Developed and conducted training programs for Qlikview user groups and administrators.
• Worked as a technical consultant for Qlikview. Was a part of the implementation life cycle.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gaugesand alerting mechanisms.
• Performed time over time analysis of sales and performance related data.
• Performance tuning of dashboards was carried out to limit the response time to well under 10 seconds.
• There were 6 Dashboards and 20 million records with incremental load and daily refresh.
• Implemented Section access and Hidden scripting for the Application Security
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Promoted dashboards to production environment and manage user access.
• Worked with Qlikview 8.x, upgrade to 9.x,SQL Server,SAP, Excel, flat files

B.I and QlikView Developer - Confidential AZ (Jan 2009 -May 2010)
Confidential, the project was Dash boarding tool to access Patient Health Information, Insurance details, payment information and Medical history

• Actively involved in requirement gathering sessions with business analysts, business stakeholders, Subject Matter Experts (SME), developers and sponsors.
• Performed Analysis of key business requirements and assisted in development of Business Requirement Specification (BRS).
• Gather, Analyze, and transform business requirements of the Client into Logical and Physical BI solutions.
• Successfully performed UAT before releasing to Production environment.
• Adopted Scrum methodology in the system development process.
• Worked closely with the development team to understand functionality, resolve issues and provided feedback for the UML diagrams.
• Responsible for providing project consulting services.
• The project initially used Tableau but migrated to Qlikview in the 2nd week of development.

Business Analyst and Report Developer -Confidential, PA (Nov 2007 -Dec 2008)
Business of Confidential is chemical synthesis, analytical technology, process engineering and surface science.

• Gather, Analyze, and transform business requirements of the Client into BI solutions
• Architected and developed the executive and regional level project performance dashboards.
• Involved dashboard layout design and internal data mapping design.
• Worked step by step with the business in order to produce the correct business requirements.
• Developed length of stay dashboard for business services client that tracks customer stay length for different lines of services, regions and enterprise level. Dashboard included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.
• White boarded closely with the business in order to map out the most valuable visualization elements on the dashboard.
• Assisted client on useful business cases to display on the reports.
• Worked with Oracle, SQL Server, SQL Reporting Services

Business Analyst and Report Developer, Confidential, NJ (Dec 2006- Oct 2007)
Confidential was a finance industry, and currently acquired by Chase.

• Designed and developed the programs in business intelligence tools that support client requirements
• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Trained and managed developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Conducted code walkthroughs and review peer code and documentation.
• Worked with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Gathered requirements and design of data warehouse and data mart entities.
• Developed project management solutions and process efficient projects for customers with suitable technology
• Developed and maintained proper levels of documentation and contribute to documentation and accounting activities

SQL and Dash Board Developer-Confidential, NJ (Jan 2006- Nov 2006)
Confidential is a Financial service Company, specializing in trading.

• Provided necessary support with analytics and SharePoint implementation for Client Relation and for Top level managers.
• Developed BRDs in close coordination with the Management Group. Decided, on visual and functional aspects required for the developed applications.
• White boarded closely with the business in order to map out the most valuable visualization elements on the dashboard
• SharePoint was used as the Dash Boarding tool, SQL served as the database. Used free-hand SQL for analysis purpose.