SUMMARY

• Over 9+ years of IT experience and played a significant role in developing and designing solutions mainly in Supply Chain stream for a leading CPG customer.
• Over 3.5 years of Business intelligence and analytics experience with strong experience on QlikView reporting tool to develop, design and support reports, dashboards and scorecards for a variety of business users.
• Over 5+ years working with Manugistics Supply Chain (SCPO) suite of packages owned by JDA, involving the Demand Planning, Forecasting and Fulfillment.
• Well experienced in PL/SQL programming on Oracle, Unix AIX and Linux shell scripting.
• Experienced QlikView developer and architect - Very good experience in QlikView scripting and point-in-time reporting using in-built functions and set analysis.
• Have built reports for various business applications across different functional divisions.
• Experienced in QlikView Administration - Creating scheduled jobs for QVDs, report reloads & loop and reduce using QlikView Publisher.
• Involved in projects with huge amounts of point of sales data running upto 250-300 million rows.
• Very well experienced in data visualization, dashboard builds, reporting and UI design.
• Strong analytical skills and adept at solving complex issues at ground level using systematic approach and statistical information.
• Good interpersonal and communication skills - was the single point of contact for most projects and always worked in close association with third party vendors and customers.

TECHNICAL SKILLS

Business Intelligence: QlikView 9.X/10.X /11.X

Programming Languages: PLSQL, Shell Scripting

Databases: Oracle 9i, 10g, 11g.

ERP: Manugistics (JDA 6x and 7x),.

Others: TOAD Data Modeler & Toad for Oracle, PL/SQL Developer, Control M job scheduler, Putty, Win SCP, Unix AIX, and Linux

Project management: MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Melbourne, FL

QlikView Developer

Responsibilities:

• Extract a heavily normalized data set from SAP BW and build a data model with Link Table and Master Calendar to connect the various fact tables with the master tables.
• Use SAP ReloadDD and Script Builder (SAP Connector) to connect to SAP BW DSO’s and generate QVD’s.
• Data Validation and analysis based on the data pulled into QlikView from SAP.
• Front End build based on a prototype proof of concept.
• Build a main dashboard with overall details of both AD and COPD market products (growth, baseline, MTD, etc) and different sheets for additional information for performance details, summary, budgets, call activity and call & change details.
• Implement conditional expressions and dimensions for some charts to show different metrics in the same chart based on selections by users.
• Involved in creating publisher tasks for data extraction, reload and loop and reduce based on territorial hierarchy.
• Technical Documentation detailing the use of data model on backend and different charts and variables on front end.
• Creating support transition documents with details of all publisher jobs and the order in which they need to be run.
• Impact and solutions document with details of probable problems that may arise and the solution to fix the issue.

Environment: QlikView 11, SAP BW (data source), QlikView SAP Connector

Confidential, Cedar Rapids, IA

QlikView Developer

Responsibilities:

• Build a data model with Link Table and Master Calendar to connect the three main transactional data tables with the master tables.
• Use SAP ReloadDD and Script Builder (SAP Connector) to connect to SAP BW DSO’s and generate QVD’s.
• Data Validation and analysis based on the data pulled into QlikView from SAP.
• Rapid front end build with multiple iterations of user demos.
• Build a main dashboard with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Implement Conditional Reporting (Ad Hoc Reports to give users the flexibility to choose what they want to see) which is a new QV11 feature.
• Involved in overall QM Analytics Dashboard build, Deviations trending, CAPA response analysis, and Complaint analysis based on different dimensions.

Environment: QlikView 11, SAP BW (data source), QlikView SAP Connector

Confidential, GLENVIEW, IL

QlikView Developer

Responsibilities:

• This project was for supply chain users as well as the finance & marketing team to analyze different KPIs appropriate for the particular division.
• Build dashboards, drill downs and reports to present KPIs in an easy-to-use application of business users.
• Analyze data sources and come up with a convenient data model for operational and forecast information.
• Multiple levels of hierarchy implementation for products, manufacturing locations, transportation and customers.
• Usage of macros and VB scripts to calculate some of the metrics.
• A total of 56 users are going to use these reports and access is controlled using Section Access & Loop and Reduce functionality in QV Publisher.
• Worked with multiple data sources including Oracle DB, MS Access, excel, CSV’s, text files as well as previously built QVD’s.

Environment: PL/SQL, Oracle 11g, TOAD, SQL developer, MS Office, QlikView 11.

Confidential, Glenview, IL

QlikView Developer

Responsibilities:

• Interacting with business users and stakeholders for requirement gathering and appropriate data sources.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• A single dashboard was created with multiple drill down and analysis sheets for What-If analysis.
• Front End UI was built carefully with warning and alert mechanisms for specific KPIs in the dashboard and relevant visual cues, mini charts, pivots in the drill downs.
• A powerful custom, conditional report and comparative analysis sheet was built to enable users to perform further analysis. This feature is newly available in QV 11.
• Overall size of the application is 180MB with over 20,000 products, locations and customer details and over 10 million rows in total.
• QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
• A master calendar was used for time related dimensions and a strong source control methodology was used for tracking changes.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality in QV Publisher.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Involved in Weekly Case Fill Rate (CFR) report, Forecast Accuracy and Forecast BIAS reports.
• Days Forward Coverage (DFC) report, Compliance to Schedule, Production Attainment and Schedule Stability reports, Inventory Position reports at Mixing Centers and Warehouses.

Environment: Windows XP, PL/SQL, Unix, Oracle 11g, TOAD, SQL developer, MS Office, QlikView 11.

Confidential, Northfield, IL

QlikView Developer

Responsibilities:

• This report would help the E-commerce team analyze costs incurred for each customer and help conclude on discount rates and other factors for each Customer.
• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• A Snowflake data model was used since there were too many sources and mapping of dimension attributes had to be done separately.
• Overall Application size was over 500 MB with over 25 million rows.
• Emphasized on Data Integrity and good chart aesthetics using various charts available in QV.
• Performed time over time analysis of various costs and performance related data using circular groups, expressions and drill downs.
• Performance tuning of dashboards was carried out to limit the response time to well under 10 seconds.
• There were 3 Dashboards and 25 million records with one incremental load performed after 2 months (business requirement).
• 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.

Environment: Windows XP, PL/SQL, Unix, Oracle 11g, TOAD, SQL developer, MS Office, QlikView9.

Confidential, Glenview, IL

QlikView Developer/JDA Techno functional Lead

Responsibilities:

• Interact with three different vendors to obtain Point of Sales Data (Inventory details of customer) for five of Kraft’s customers for a period of two years.
• Interact with various stake holders in Confidential to get Historical data for requested orders, actual sales, and inventory levels at mixing centers and warehouses, etc.
• Managing and tracking data issues and ensuring data integrity by constant data validation in source and application.
• Clean up of “dirty data” in txt files provided by vendors using complex QV ETL functions, generic load and cross table functionalities.
• Maximum application size of 3GB with multiple hierarchies in product, customer base, manufacturing and storage locations.
• Dealt with about 300 million rows from as many as 8 sources with different formatting/transformation requirements.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 2 Hours.
• Incremental reloads using QVD’s, usage of variables and scripting transformations for better performance.
• Monitor & support the QlikView server and help users build ad hoc reports whenever necessary.
• Was responsible for supervising the upgrade of the reports from Version 9 to Version 11.
• Involved in building comparison reports for History-Historical forecast, order compliance and inventory compliance.
• Review of detail Technical design and developing code mainly comprising of oracle packages and shell scripting.
• Impact analysis and root-cause analysis for issues faced during development and during testing cycle of the project.
• Define and baseline the general production support guidelines and best practices for production go-live.

Environment: Windows, QlikView 9, Linux, PL-SQL, Oracle 11g, Linux shell scripting, TOAD, PL/SQL developer, Control M job scheduler, MS Office.