Qlik

SUNDARAMOORTHI MURUGAN

Project lead cum developer on Qlikview / Qlik Sense

Mobile : +1 - 646-***-****

India number / Skype Id.+919********* Email : ******.******@*****.***

Professional Summary

●Over 10+ years of experience in Design, Development, Testing, Deployment of Qlikview integrated with D3 Application and Qlik sense

●Experience in IT industry Software Configuration Management including Devops Build/Release Management.

●Experience in continuous integration build and deployment tools with Rally and JIRA.

●Handled Billion record in Qlik.

●Expertise to integrated D3/Javascript application to Qlikview

●Expertise in unstructured data, Granularity Level of data tables, complex Data model, Cloud Application

●Expertise to create auto trigger mail to customer after sale report Generated by using PDF Distribution

●Integrated Authorization and Authenticate via Section access to restrict data level access

●Expertise to design visualization in VIZLIB chart and function

●Experience in QlikView Product family such as QlikView Desktop Client, Qlik Management Console, QlikView Server and Qlik Sense hub

●Integrate Jomashup on top of Qlik sense application and editing it functioanlities

●Expertise in complete lifecycle Implementation of Qlik of Business Intelligence with Star and Snow flake Schemas.

●Hands on in Oracle Query writing and performance tuning on query.

●Worked on Talend 5.6.1 for Data preparation

●Hands on SAP OLAP connector to fetch BEX Query

●Expert to write PostGRE SQL query in pgadmin

●Good Exposure to write Query and procedure in Greenplum DB.

●Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers

●Worked on POC to check possibilities of implementing BI technique in Tableau compared to other BI tools in market

●Good Experience on Ad-hoc Reporting

Education

Master of Computer Applications (MCA) April 2009

Madurai Kamaraj University - Madurai, India

Bachelor of Computer Science (B.Sc) April 2006

Madurai Kamaraj University - Madurai, India

Technical Competencies

Dashboard/ Analytics

QlikView 11.2/11.0/10.0/9.0/6.0 Qlik Sense November 2018

Languages

SQL

Database Technologies

SQL Server, Oracle 10g/11g, Teradata, Share point Excel

ETL Tools

Talend 5.6.1

Operating systems

Windows 10/8.1/7/ XP,

Databases

Oracle 11g, SQL, PL/SQL,

Professional Experience

EMD Serono,

Boston, MA Dec 2019 – Till Date

Project Lead and Qlik Sense Developer.

Project: Neurology Report

We worked on a project to automate the Neurology application into Qlik sense and Mashup the Qlik sense application using Jo-Mashup and the source are from share point excel with limited number of records .I took the overall responsibility to complete project as Lead with 2 off-shore team

Appreciations from management:

Responsibilities:

Interaction with the client on regular basis to get the requirement.

Responsible to optimize Data model and design rendering time

Responsibility design Jo-mashup

Store access Authenticate via Section access to restrict data

Handling offshore team and sharing knowledge with them .

Worked in Vizlib Charts for visualization

Environment: Qlik sense, Jo-mashup.

T-Mobile,

Dallas, TX Dec 2018 – Oct 2019

Project Lead & Qlik Sense Developer.

Project: Item movement report

There are 3 dashboard designed under this project which I worked on the item movement around the stores which deals with 100M record and 9k record will reach every hour to the dashboard. Optimized technique to solve the issues raised in QVD Generator Dashboard reloading and rendering time in each object.

Appreciations from Client:

Responsibilities:

Interaction with the client on regular basis to get the requirement.

Responsible to optimize Data model and design rendering time

Trigger auto mail to customer via NPrinting to send their sale report to respective Customers.

Store access Authenticate via Section access to restrict data

Handling offshore team and sharing knowledge with them to improve the product development phase very faster.

Handled 150MX42 columns loaded in Qlik sense with in 10 min of time

Optimized the rendering time between objects

Worked in Vizlib Charts for visualization

Environment: Qlik sense, VIZLIB, Big data handling ( 150 Millions record )

GE Energy

Louisville, Kentucky Aug 2016 - Aug 2018

Senior qlikview Developer

Project: Inflation and deflation on Purchase report

Main objective is to predict and analysis forecast price for an item based on plant and supplier also calculate the inflation and deflation values based on previous year by showing various analysis methods in qlikview . user can manually adjust the values in the tools based on their mail communications internally.

Appreciation from Management

Responsibilities:

Prepare with Talend jobs to prepare datamodel

Optimizing the data modules to fit into the server environment.

Expertise to fetch data from Hyperion, Greenplum,Excel

Writing post GRE sql & procedure on Greenplum DB using pgadmin

Create and edit job in Talend v5.6.1 to fetch data from multiple source like web,Excel,XML, and Hyperion Greenplum..etc

Location access Authenticate via Section access to restrict data

Optimizing the design and measures of charts which can handle 115 measures with 15 dimensions which complex measure.

Identify the complex measures and optimize the code to reduce the Turn Around Time (TAT).

Balance day-to-day activities along with support activities from the client end.

Publishing the dashboard in UAT environment to get sign off.

Install and maintain Qlik sense Sever and managed License and Server

Interacting with Qlikview administrators to publish the dashboard into production.

Providing suggestions and giving guidance to the client through POC.

Environment: Qlikview, Qlik sense, Oracle, Talend 5.6.1, Hyperion, pgadmin,GRE Sql,

KPMG,

Bangalore, India, Oct 2014 – Jun 2016

Senior Qlikview developer.

Project: Workforce Management system

Bring together data from disparate systems so strategic decision makers have the information they need at their fingertips. Designed data models and created visualizations to provide that helps deriving key insights about workforce. Adopted agile methodology to deliver Workforce Analytics product which provide regular management information on key people metrics.

Appreciation from Client

Responsibilities:

Delivering the product on Agile methodology.

Generating user stories and estimating the time based on work.

Assigning work to team members.

Branch level access Authenticate via Section access to restrict data.

Preparing module design and wire frame model and get approval from project managers.

Analysing D3 and provide better visualization to the product.

Optimizing the design by keeping the repetitive labels and measures in a variable to help the maintenance further and make sure the changes are reflected in all the places.

Implemented GIGO in the data model.

Publishing the dashboard in UAT environment to get sign off.

Environment: Qlikview, D3,SAP Bex

HP,

Houston,Tx, Nov 2013 – Oct 2014

Consultant.

Project: HP Shopping

It’s Migration project from Excel&MSBI to Qlikview .Customer visit information can be extracted from Share point &Geographical Map is designed based on the co - ordinates of Google map. Sales data can be extracted from Oracle Database. The biggest challenge in this project is that the granularity of the data obtained from sources are different and that some data obtained from the database would be wrong. In order to find the correct sales figure we use a complicated formula taking into consideration all the demographical units. We have more than 3000 formulas and we condense it to100 formulas in order to ease the process

Appreciation from Client

Responsibilities:

Connect with MSBI and Excel developer to understand data module.

Designing data module and preparing the design based on requirement.

Prepared Geo map to understand the sales based on countries without using GeoQlik.

Handled different granularity of data in the same hierarchy.

Publishing the dashboard in UAT environment to get sign off.

Interacting with Qlikview administrators to publish the dashboard into production.

Environment: Qlikview,SAP BEx, Oracle, Sharepoint applications, Qv SAP OLAPConnector

Bluechip solutions,

Bangalore, India, Feb 2011 - Nov 2013

Software Development Engineer.

Project: ERP Project support on reporting

The main objective of the project is to handle INPUT /OUTPUT TAX to show the amount that needs to be filed to Indian Income Tax Systems. This taxation will handle the contributed amount that needs to be filed. This Taxation covers total purchase INPUT TAX, CST, Total Sales, OUTPUT TAX, TDS.

Appreciation by management:

Responsibilities:

Connect the data which comes from different Velocity ( Oracle, Sharepoint,Excel)

Single point contact to customer gathering requirement on day to day basis

Cleansing the data with come from sources

Use Oracle queries for Transformation

Worked on POC in Spot fire and Tableau.

Handled huge volume of data(1TB).

Worked on POC in Spot fire and Tableau.

Use Crystal report for Printing

Designing data module that does not affect the performance

Worked on Document Chaining to optimize the rendering time

Understanding and analyzing Data, volume, velocity.

Use macros to send the flag value to the data source.

Create News Feed in Qlikview Dashboard (Non-touch Environment)

Environment: Tableau, Qlikview

Microwits Technologies

Thirupur, India, Dec 2009 - Dec 2010

Trainee.

Project: YARN Manufacturing UNIT

Worked as a Query Designer & and had a close interaction with the Senior Manager to understand his requirement. Responsible for Sales Modules. Yarn Manufacturing & Dyeing is the key sector in the Organization. Pricing is done based on the cost of production as estimated by the Pricing department. Then it is moved on to enquiry, quotation and order placement. The Order Cycle is generally short. If the party is interested with the conversation then they raise proforma invoice which is not the actual invoice but a duplicate copy of invoice being sent to party for confirmation. Once the confirmation is received, the materials are dispatched from the warehouse & the invoice is raised. This was our first level implementation.

Responsibilities:

Involved in the process related activities

Worked in the ERP development business unit of Microwits Technologies

Worked mainly with Query Preparing for Qlikview

Communicate with the Customer for their requirement.

Understand clients’ requirements & Designing as per Requirement

Environment: Oracle, Qlikview

Contact this candidate