Project Data
Resume:
AVINASH R
E-mail : ******************@*****.***
Mobile no: +91-973*******
Objective:
I am seeking for an end-to-end full stack Developer position in the IT industry where my skills, knowledge, high technical aptitude and steadfast commitment to performance, can effectively contribute to the successful and profitable operation of the firm, along with my professional and personal growth.
Areas of Profession:
5+ years of professional experience in the Business Intelligence and Analysis.
5+ years of experience in end to end Qlikview/Qliksense Design, Development, Reporting etc.
Experienced in maintaining vast reporting platforms which contains more then 700+ Qlikview dashboards with daily SLA targets.
Experienced in DB design for reporting needs.
Experienced in Autosys scheduling with cross dependency on DB/ETL, Qlikview and Cognos
Experienced in QlikView Management Console(QMC) - Creating scheduled jobs for QVD extracts and report reloads.
Delivered more than 100+ Qlikview Projects.
Worked on prototype designing for many project proposals, client presentation, conducting user and development trainings.
Experienced in NPrinting report automation, distribution and maintenance.
Worked as a QlikView/Qliksense Architect for a wide variety of business applications.
Experience in complete project life cycle including documentation, analysis, and development and testing.
Active contributor for the Qlikview community and stands 28th rank across the world with the contribution of points and awarded as MVP 2017 from Qlik Tech.
Professional Skills:
Operation systems/platforms
oWindows XP/7
Programming Languages
oQlikview Scripting
oSet analysis
Databases
oMySQL
oDB2
oOracle9i/10g
oSQL Server
oSales Force
oFlat files
oAWS Cloud
Tools
oQlikview.
oQliksense.
oAutosys
oQMC.
oNPrinting.
Notice Period: 60 days
Project Details:
Project#1
Sep 2016 – till now
Morgan Stanley
Title
TT IMRS
Role
DB and ETL Developer, Qlikview Developer
Responsibilities
Maintenance and enhancement of huge reporting platform to meet the daily SLA needs.
Addressing day to day production issues
Analyst
Data Base tables, view and stored procedure development
Autosys scheduling
Qlikview dashboard development
The Project
IMRS is an centralized data warehouse and golden source for all the regulator and non regulator reporting needs of the bank.
IMRS contains more then 700+ Qlikview dashboard for various entities of the bank like Wealth Management, Institutional securities etc
IMRS includes following reporting streams
1.Trade Volume
2.CNC
3.Fails
4.Listed Derivatives etc
Database
DB2
Project Location
Bangalore, India
Project#2
June 2017 – till now
Morgan Stanley
Title
TT TAX Analytics
Role
DB and ETL Developer, Qliksense Developer
Responsibilities
Understanding and analysing Requirements given by client.
Analyst
Data Base tables, view and stored procedure development
Autosys scheduling
Qliksense dashboard development
The Project
TAX Analytics is single analytics platform for various tax metrics like 1099 Daily Corrections, Tax Deposits, Withholding Exceptions, CCAR, Error Queue etc.
Main aim of this project is to eliminate the manual work involved in report generation.
Database
DB2
Project Location
Bangalore, India
Project#3
Sep 2015 – Jan 2016
TATA CONSULTANCY SERVICES
Title
QR REM Reports (Agile Project)
Role
Technical Lead, Developer
Client
Qualcomm, San Diego, CA
Responsibilities
Understanding and analysing Requirements given by client.
Technical Lead of the Team.
Regular Interaction with Client to clarify open queries related to the project.
Developed a Data model in Qlikview to import the data from the Composite, MySQL, and XML DB incrementally.
Developed various Dashboards, reports and charts up on the data model.
Testing and Reviewing other team member’s developed code
Deploying the code in different environment like Test, Production environment.
Assigning the Code for peer-review and incorporate peer review comments.
The Project
REM is ISRM Remediation and Exception Management system, which is involved in managing all the Security issue related to Qualcomm. The aim of this project is to pull data from multiple data sources like Composite JIRA, MYSQL and XML. And to build a dashboard that highlight KPI from all the data source at one place.
Carried out the following activities:
Data Modeling
Qlikview Scripting and data transformations.
Optimizing the SQL Queries
Scheduling the reload task.
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
To work on base lining of different complicated UI design along with Customer.
Database
Composite, MySQL, XML
Project Location
Bangalore, India
Project#4
Oct 2014 – Feb 2016
TATA CONSULTANCY SERVICES
Title
QR LMS Reports
Role
Technical Lead, Developer
Client
Qualcomm, San Diego, CA
Responsibilities
Understanding and analysing Requirements given by client.
Technical Lead of the Team.
Associated in creation of Technical Design Document TDD.
Conduct knowledge sharing sessions with the team
Creating efficient SQL queries.
Regular Interaction with Client to clarify open queries related to the project.
Developed a Data model in Qlikview to import the data from the MySQL DB incrementally.
Developed various Dashboards, reports and charts up on the data model.
Testing and Reviewing other team member’s developed code
Deploying the code in different environment like Test, Production environment.
Assigning the Code for peer-review and incorporate peer review comments.
The Project
LMS is the Learning Management system of Qualcomm, which contains the data related to various types of courses, user enrollments, course completions, schedule planning etc. This project aims at developing various dashboards for the LMS Admins and ITCS support users. This requires though understanding of the data in MySQL (backend DB of LMS) and developing an effective data model for easy and efficient creation of reports in Qlikview. This will help the Admins to keep track of number of course created, course completions etc on a day to day basic.
Carried out the following activities:
Data Modeling
Qlikview Scripting and data transformations.
Optimizing the SQL Queries
Scheduling the reload task.
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
To work on base lining of different complicated UI design along with Customer.
Database
MySQL
Project Location
Bangalore, India
Project#5
Jan 2015 – Mar 2015
TATA CONSULTANCY SERVICES
Title
QR LMS Report Automation NPrinting
Role
Developer
Client
Qualcomm, San Diego, CA
Responsibilities
Requirement gathering and analysing Requirements given by client.
Development of excel templates.
Scheduling and maintenance of NPrinting application.
The Project
LMS is the Learning Management system of Qualcomm, which contains the data, related to various types of courses, user enrollments, course completions, schedule planning etc. This project aims at automation of excel report generation and email the concern recipient using NPrinting tool. This will help the Admins to keep track of number of course created, course completions etc on a day to day basic.
Carried out the following activities:
Design Template.
Dynamic naming of files.
Scheduling the .nsg files.
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
Database
Qlikview Document.
Project Location
Bangalore, India
Project#6
Mar 2015 – May 2015
TATA CONSULTANCY SERVICES
Title
QR ISRM Report Automation NPrinting
Role
Developer
Client
Qualcomm
Responsibilities
Requirement gathering and analysing Requirements given by client.
Conduct knowledge sharing sessions with the team
Development of Word and Excel templates.
Scheduling and maintenance of NPrinting application.
The Project
ISRM is the Information Security Resource Management group of QUALCOMM, they basically keep track of security relation issues and concern in Qulacomm. This project aim to automate the hourly word document report generation from the ISRM qlikview dashboard and mailing the concern recipients.
Carried out the following activities:
Design Template.
Dynamic naming of files.
Scheduling the .nsg files.
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
Database
Qlikview Document.
Project Location
Bangalore, India
Project#7
Jun 2014 – Oct 2014
TATA CONSULTANCY SERVICES
Title
MS QMT Pixtronix Reports
Role
Developer
Client
Qualcomm
Responsibilities
Understanding and analysing Requirements given by client.
Creation of Design Documents.
Writing efficient script for modelling and fetching data
Prepared Documentation for the project.
Regular Interaction with Client to clarify open queries related to the project.
Develop a Data Model in Qlikview to import the data from SQL data base
Developed various Dashboards, reports and charts up on the data model.
Creating test cases for developed Code.
Assigning the Code for peer-review and incorporate peer review comments.
The Project
QMT Pixtronix a subsidiary of Qualcomm which is involved in the production and testing of display screen. They conduct various kind of test on the display screen and record it over the SQL data base. The aim of this project is to read the data from SQL dB and to develop effective data model to showcase the test result for each test metric and creating an overall scorecard which will give a clear picture about the test outcomes on different metric over a period of time. Qlikview helps in overcoming the manual effort of generating the report for which previously they were depended on the 3rd party company to generate report.
Carried out the following activities:
Data Modeling
Qlikview Scripting and data transformations.
Implementing customized extension
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
To work on base lining of different complicated UI design along with Customer.
Data Source
SQL Server data base
Project Location
Bangalore, India
Project#8
Apr 2014 – Jun 2014
TATA CONSULTANCY SERVICES
Title
TT Wireless Reach
Role
Developer
Client
Qualcomm, San Diego, CA
Responsibilities
Understanding and analysing Requirements given by client.
Associated in creation of Technical Design Document TDD.
Prepared Documentation for the project.
Regular Interaction with Client to clarify open queries related to the project.
Develop a Data Model in Qlikview to import the data from the shared point, salesforce and flat files.
Develop various Dashboards, reports and charts up on the data model.
The Project
This project mainly focuses is to keep track of the media imprints on Qualcomm company from different medias sources like new papers, online, print etc. The data related to this various media sites will be pulled form Vocus and Salesforce. Vocus is a Public Relations tool that monitors media sources (print, online, news, etc) and collects the meta data about them. Salesforce is used to capture Project, Contact info (accounts/contacts) and quarterly performance data. Dashboards and reports are developed in qlikview by developing data model, which helps to monitor the trends which are noticed on a monthly or daily basics based on requirement
Carried out the following activities:
Data Modeling
Qlikview Scripting and data transformations.
Optimizing the SQL Queries
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
To work on base lining of different complicated UI design along with Customer.
Database
Shared point, salesforce and flat files
Project Location
TCS, Bangalore, India
Project#9
Jan 2014 – Apr 2014
TATA CONSULTANCY SERVICES
Title
TT AllJoyn
Role
Developer
Client
Qualcomm, San Diego, CA
Responsibilities
Understanding and analysing Requirements given by client.
Prepared Documentation for the project.
Regular Interaction with Client to clarify open queries related to the project.
Develop a Data Model in Qlikview to import the data from the Oracle, XML files, salesforce and flat files.
Develop Various Dashboards, reports and charts up on the data model.
The Project
AllJoyn is a business unit of Qualcomm which server as a connect for other departments of Qualcomm. It keeps tracks of the change request across all the departments and server various business needs. The aim of this project is to pull the data from multiple departments i.e. from multiple data sources like salesforce, oracle, spread sheets, XML files etc and to build an effective data model without any disturbance and to develop an effective dashboard in Qlikview for the business analysis.
Carried out the following activities:
Data Modeling
Qlikview Scripting and data transformations.
Optimizing the SQL Queries
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
To work on base lining of different complicated UI design along with Customer.
Database
Oracle, XML files, salesforce and flat files
Project Location
TCS, Bangalore, India
Project#10
Nov 2013 – Jan 2014
TATA CONSULTANCY SERVICES
Title
TT ISRM
Role
Developer
Client
Qualcomm, San Diego, CA
Responsibilities
Understanding and analysing Requirements given by client.
Conduct knowledge sharing sessions with the team
Creating efficient SQL queries.
Prepared Documentation for the project.
Regular Interaction with Client to clarify open queries related to the project.
Develop a Data Model in Qlikview to import the data from the composite JIRA data base.
Develop Various Dashboards, reports and charts up on the data model.
The Project
Information Security Review Management is the security department of Qualcomm which manages all the security related data. This project aims at pulling the data from composite JIRA data base and developing effective dashboards for the analysis of security incidents over a period of time. This requires complete knowledge about the JIRA data base and building effective data model for easy creation of reports in Qlikview. NPrinting is used to automate the exporting of reports to recipients in various format like word, excel etc
Carried out the following activities:
Data Modeling
Qlikview Scripting and data transformations.
Optimizing the SQL Queries
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
To work on base lining of different complicated UI design along with Customer.
Database
Composite JIRA data base
Project Location
TCS, Bangalore, India
Project#11
Sep 2013 – Nov 2013
TATA CONSULTANCY SERVICES
Title
TT AWS Billing
Role
Developer
Client
Qualcomm, San Diego, CA
Responsibilities
Understanding and analysing Requirements given by client.
Associated myself in creation of Technical Design Document TDD.
Conduct knowledge sharing sessions with the team
Creating efficient SQL queries.
Prepared Documentation for the project.
Regular Interaction with Client to clarify open queries related to the project.
Develop a Data Model in Qlikview to import the data from S3 mount of AWS cloud.
Develop Various Dashboards, reports and charts up on the data model.
The Project
Amazon Web Service is a cloud platform where Qualcomm is hosting their cloud applications. This project aim at pulling billing data from S3 mount of AWS cloud,building an effective data model and dashboards for the IT Managers to keep track of the billed amount and data consumption on a day to day basics
Carried out the following activities:
Data Modeling
Qlikview Scripting and data transformations.
Optimizing the SQL Queries
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
To work on base lining of different complicated UI design along with Customer.
Database
S3 mount of AWS cloud
Project Location
TCS, Bangalore, India
Project#12
June 2013 – Sep 2013
TATA CONSULTANCY SERVICES
Title
TT Remedy
Role
Developer
Client
Qualcomm, San Diego, CA
Responsibilities
Understanding and analysing Requirements given by client.
Associated myself in creation of Technical Design Document TDD.
Creating efficient SQL queries.
Prepared Documentation for the project.
Regular Interaction with Client to clarify open queries related to the project.
Develop a Data Model in Qlikview to import the data from Oracle 11g, Salesforce.
Develop Various Dashboards, reports and charts up on the data model.
The Project
Remedy is the defect tracking tool in Qualcomm, which contains logs related data to all the developing projects across Qualcomm. The aim of this project is to pull data from Oracle data base and building an effective data model and dashboards in Qlikview with trends lines, charts etc . This helps the project managers to prepare their project release plans accordingly.
Carried out the following activities:
Data Modeling
Qlikview Scripting and data transformations.
Optimizing the SQL Queries
Perform root cause analysis for the issue addressed from clients
Fixing the issues addressed by clients
To work on base lining of different complicated UI design along with Customer.
Database
Oracle 11g, salesforce
Project Location
TCS, Bangalore, India
work Experience:
1. Morgan Stanley(Sep 2016 – till now).
2. HCL(Jan 2016 – Oct 2016).
3. TCS(Feb 2013 - Jan 2016).
Personal Information:
Date of Birth: 26 Jun 1990
Age: 27
Sex: Male
Marital Status: Single
Education:
Bachelor of Computer science and Engineering from PESCE college affiliated to Visvesvaraya Technological University, Belgaum, Karnataka in 2012 with 8.43 CGPA
HSC (2006-2008) from Sadvidya PU college Mysore, Karnataka with 78% aggregate.
SSLC (2005-2006) from Sadvidya High school Mysore, Karnataka with 92.30% aggregate.
DECLARATION
I here by declare that all the details furnished are genuine and can be subjected to verification at any time.
Place : Bangalore Yours Sincerely
Date :
( AVINASH R )
Contact this candidate