Data Developer

Tajinder Singh

Email Id: ********.********@*****.*** Contact: 91-989*******,

Company: KPMG Global Services Pvt. Ltd. 91-991*******

Summary:

•12+ years of experience in customizing the business intelligence (BI) applications and worked on more than 15 projects across different sector like. Manufacturing, Sales, Production Planning, Sales & Distribution, Call Center, SCM, Project System, Pharma, Human Resource etc.

•Proficient in stake holder expectation, leading, mentoring and managing teams throughout the project development lifecycle, prioritizing work, problem solving, quick decision taking, job scheduling, time management, process improvement, maintaining resource matrix.

•Strong technical background and excellent interpersonal skills and ability to interact with individuals at all levels. As a Technical/Senior consultant have been involved in designing and implementing the valuable solutions for business users and has been acknowledge by the clients.

•Knowledge of full requirement analysis for business process. Proficient in creating attractive dashboards, KPI’s, analytics, report and data model etc.

•Enthusiastic team player with strong leadership and excellent written and verbal communication skills. Ability to learn and pick up new tool/technology quickly and learned various tool like Qliksense, Alteryx, Tableau, Power Bi, SAP BOE.

•Worked on different Qlikview Version (QV-8.0, 8.5, 9.0,11 & 12). Also Worked on Multiple SAP connector 4/ 5 Version. Worked on multiple Proof of Concept (POC) for different in BI stack.

•Worked with Top clients like Hewlett-Packard(US), KPMG(UK), Air Product & Chemicals(US), Medivation(US), Global foundries(SGP), Indian OIL Corporation Ltd., Liberty, SRF, Religare, DanikBhaskar, HSIL Continental Engines, Benetton, Ambuja Cement etc.

Current Role:

•Currently working in KPMG Global Services (Management Consulting) as Assistant Manager and responsible for End to End Product Delivery that includes Development, Design, Implementation, Unit & Functional Testing, Peer Review, Client Release notes, Impediments etc. using best practices & benchmarking

•Good interpersonal & communication skills and ability to work in team as ‘Floating Consultant’ with same spirit when work independently.

•Talent for communicating and solving complex problems, leading development teams, improving data management, automating and integrating systems as well as delivering projects on time.

•Imparted brown bag session & training and sharing the technical/functional knowledge within the organization as well as client

•Oversaw software developers’ progress on applications and applied principles of agile methodologies to keep track of project. Leading the team and involved in Sprint Planning, Discussion, Task Assignment, Resource Utilization, and Progress Tracking, Highlighting Impediments, Peer Review using Agile Mythology and involved in daily scrum meetings to track the progress.

Supporting various KRA across KGS - Management Consulting

i.Learning & Development: Contributing as a key member of L&D team and facilitating the External Training and Certification

for the larger group of people(MC).

ii.Quality: Key contributor of QA team and providing assistant to all MC projects team and ensuring that the project quality metrics should be maintain for all the running projects.

iii.Interview Panel: Part of interview panel and taking care of all the Business Intelligence Interviews (shortlisting, evaluation etc.).

iv.Solution and Innovation: Supporting the Solution and Innovation KRA and provide assistance for the New Innovation Ideas

which includes resource availability, progress, review, showcase etc.

Professional Experience:

•Currently working as Assistant Manager with BIG4 consulting KPMG Pvt. Ltd. From Jan 2015.

•Worked As a Technical Lead with India Bulls Technology Solution Ltd. From Jul 2013 to Jan2015.

•Worked with IBM from Sep 2010 to Jul 2013.

•Worked with Team computers Pvt. Ltd. From May 2006 to Aug 2010

Professional Qualification:

•MCA 2005 from IGNOU

•BCA, 2003 from IGNOU

•Advance Diploma in Software Engineering (3 Years) 2003 from Aptech Computer Education.

Certifications:

—Alteryx Designer Core Certification from ALTERYX

—Essential Design Principles for Tableau through Coursera

—Fundamentals of Visualization with Tableau through Coursera

Visa Information: Exposure to work with client location (US and UK) and holding the US Business Visa.

Software Skills:

•Business Intelligence

(Qlikview, Power BI, Tableau, Qliksense, SAP Web Intelligence)

•Database

(SQL Server, Oracle)

•Business Analysis/Product development

•ETL Tool

(Alteryx, Data Stage)

•Data Warehousing

•Language (knowledge)

C++,Core Java, VB, HTML, Python

Domain Expertise:

• Heath Care

(Clinical/Pharma Analytics)

•Retail

(Sales, Distribution)

•Manufacturing

(Production Planning)

•IT

•Human Resource

•Oil & Gas

•Publication

Professional Proficiency

1. Client KPMG-UK (BFFS - Benchmarking)

Domain Finance

Technologies Power Bi & Alteryx

Role Visualization Lead

Period Jan-2019 to May2019

Project Type Development

Team Size 4

Role/Responsibility: Currently working as a visualization Lead and responsible for end to end project delivery.

•Responsible for development of product including, client discussion, requirement gathering, follow-up, team hurdle, review meeting and access matrix etc.

•Loading the data from different sources and applying the business logic and massaging the data for dash boarding & reporting.

•Build data model, analytics, dashboard, reports and do peer review and unit testing, defect fixing dashboard development, analytics and specific reports using drill down capability etc.

2. Client Hewlett-Packard (US)

Domain IT & Finance

Technologies SAP BI - WEBI with Hana for BW

Role Visualization Lead

Period Jan-2018 to Nov2018

Project Type Development

Team Size 5

Role/Responsibility: Worked as a Visualization Lead cum BA and responsible for End to End project delivery

(Dishoarding, Reporting) using agile methodology.

•Responsible for development of product including, client discussion, requirement gathering, follow-up, team hurdle, review meeting and access matrix etc.

•Responsible for Sprint planning, sub tasking, documentation, task assignment, resource allocation and utilization using agile.

•Creation of sample data for Mockup, data modeling, analytics, reporting and peer review and unit testing, defect fixing dashboard development, analytics and company specific reports using various Kpi’s like YTD/QTD analysis, periodic trend, YoY comparison, analytics using drill down capability etc.

•Learn new agile tool Jira, ALM, IMPS which helps to track the day to day progress of Sprint and Defects.

3. Client KPMG - UK

Domain HR Analytics (KPMG Learning Solution)

Technologies Power Bi with Excel, Sql-Server

Role Visualization Lead

Period Mar-2017 to Dec-2017

Project Type Development

Team Size 4

Role/Responsibility: Worked as a Visualization lead and was responsible for end to end dashboard delivery which

Includes business understanding, development, design and testing.

•Sprint planning, task allocation, documentation, review using agile methodology

•Creation of sample data creation, data modeling, analytics, reporting and reconciliation.

•Developed of dashboard, analytics and mis reports & kpi’s like ytd/qtd analysis, periodic trend, yoy comparison, analytics using drill down capability etc.

•Learned the Power BI tool by self and successfully delivered the Project with good client feedback and appreciation and got the opportunity to work closely in client Location (UK)

4. Client KPMG UK

Domain HR Analytics (Bio- Workforce)

Technologies Tableau with Sql Server

Role Visualization Lead

Period Aug-2016 to Mar-2017

Project Type Development

Team Size 4

Role/Responsibility: Working as a Visualization lead cum Sr. Consultant and designed and developed the dashboard for the

workforce reporting from the existing Qlikview dashboard using Tableau as a tool.

•Understanding of existing dashboard and creation of task and assigned them to team.

•Responsible for data model creation, designing and developing various Kpi’s, reports and finally data testing.

•Periodic review of project updates with client and the team.

•Picked up the new tool Tableau by self-learning and successfully delivered the Product.

5. Client KPMG - UK

Domain HR Analytics (Strategic Workforce Planning)

Technologies Qlikview with Sql-Server

Role Visualization Lead

Period Jan-2015 to Jun-2016

Project Type Development (Product)

Team Size 5

Role/Responsibility: Worked as a Visualization Lead and being responsible for end to end product delivery which includes

requirements gathering, business understanding using agile methodology.

•Played a role of BA as well and been responsible for the full product development which includes development, designing, deployment and testing of product.

•Sprint planning, sub tasking, documentation, review using agile methodology

•Creation of data modeling, analytics, reporting and data testing.

•Developed a dashboards using DAR approach and show the dashboard, analytics and various reports which includes drill down YTD/QTD analysis, DIY, simulation. periodic trend etc.

6. Client Medivation Inc. (USA), Genentech (USA)

Domain Pharma & Life Science

Technologies Qlikview with Sql Server

Role Technical Lead

Period Aug-2013 to Jan2015

Project Type Development

Team Size 2

Role/Responsibility: Exposure to work with onsite client in US - SFO.

•Working as a Technical Lead cum Team Lead and handling a team of 4 members.

•Responsible for the full development, designing and deployment of the dashboard

•Take care of Job scheduling and monitoring.

•Provide QV training to other team members, users.

•Provide full documentation of the work done and maintaining that for the ongoing CR request.

•Weekly status meeting with client and team members for the project updates and new task.

7. Client Global Foundries (Singapore).

Technologies Qlikview with Oracle10g

Role Sr. Qlikview Consultant

Period Nov-2011 to Aug2013

Project Type Development/Enhancement

Team Size 5

Role/Responsibility: Working as a Sr. Consultant and assisted the core development team to establish the current

running applications. It’s an enhancement cum support project.

•Provide QV training to other team members, users.

•Follow the process of CR and prepare all documents for the new enhancement or change request.

•Weekly status meeting with client and team meeting for the discussion and suggestion.

•Handling the new tool service now for the Incident recording and service request.

•Take care of Job scheduling and monitoring and handling Data Stage jobs monitoring as well.

8. Client APC (USA)

Technologies Qlikview with SAP, Excel

Role Sr. Qlikview Consultant

Period Oct-2010 to Oct-2011

Project Type Enhancement /Support

Team Size 4

Role/Responsibility:

•Understanding of existing application Process flow and table structure GUI.

•Gathering requirement for enhancement work, review meeting for the estimation and schedule meeting for the progress and prepared test case and follow the testing procedure (User and Client champion).

•Update the existing data model, understand the latest change request, discussion with power user, analyze it, Test it and finally deploy it for user access.

•Follow the process to create CR, RFC.

•Handling the new remedy tool UC4 for job scheduling.

•Weekly meeting with client and team members.

9. Client Indian Oil Corporation Ltd.

Technologies Qlikview with SAP, Excel

Role Team Lead/Consultant

Module Sales & Distribution

Period May-2010 to Sep-2010

Project Type Development

Team Size 3

Role/Responsibility:

•Table understanding, developing user interface.

•Data modeling, analysis, reporting, data testing.

•Developed the dashboards, reports, analytics to drilldown with different dimensions, which resulted to, desired "output" view as required and logic provided.

•Incremental/Delta load of tables on daily basis.

•Presentation to the clients, business users, client discussion and meeting.

10. Client Continental Engines Ltd

Technologies Qlikview with Excel, Sql.

Role Sr. Developer/ Consultant

Module Revenue Collection

Period 3 Month

Project Type Development

Team Size 2

Role/Responsibility:

•Understand Business requirements, analysis and translate into Application and operational requirements.

•Duties include performance tuning, data quality, troubleshooting as per qlikview best practices.

•Optimizing SQL queries to increase performance.

•Created joins on business components to appropriately map the related fields to the proper columns of joined tables.

•Developed the dashboards, reports, analytics to drilldown with different dimensions, which resulted to, desired "output" view as required and logic provided.

•Presentation to the clients, meeting and discussion.

11. Client Hindware Sanitaryware India Ltd. (HSIL)

Technologies Qlikview with SAP.

Role Sr. Developer/ Consultant

Module Sales & Distribution, Production Planning, Supply Chain Management,

Period 12 Months

Project Type Development

Team Size 3

Role/Responsibility:

•Analyzing the system requirements and performing logical and physical design of the database.

•Business understanding, prepared SRS, data understanding, developing user Interface and made the application LIVE for user access.

•SAP table understanding, SAP table extraction, incremental load on cluster/non cluster tables.

•Fetching data from SAP through connector.

•Data modeling, analysis, reporting, data testing.

•Client meeting and discussion.

12. Client Danik Bhaskar Publication (Jaipur)

Technologies Qlikview with SAP, Sql-Server

Role Sr. Developer/ Consultant

Module Print Media Module, Market Share

Period 8 Months

Project Type Development

Team Size 5

Role/Responsibility:

•Analyzing the system requirements and performing logical and physical design of the database.

•Business understanding, prepared SRS, data understanding, developing user interface and deployed the dashboard for User Access.

•Fetching data from SAP through connector.

•Data modeling, analysis, reporting, data testing.

•Client review and discussion.

13. Client Religare Securities.

Technologies Qlikview with Sql-Server

Role Developer/ Consultant

Module Revenue Analysis.

Project Type Development

Period 6 Months

Team Size 4

Role/Responsibility:

•Analyzing the system requirements and performing logical and physical design of the database.

•Business understanding, data understanding, data modeling, analysis, reporting, SQL scripting, developing GUI.

•Client meeting and discussion, Prepared SRS, Data understanding

14. Client IMS Call Analysis

Technologies QlikView with Sql-Server, Oracle

Role Developer

Period 6 Months

Project Type Development

Team Size 3

Role/Responsibility:

•Analyzing the system requirements and performing logical and physical design of the database.

•Business understanding, data understanding, SQL scripting, developing user Interface.

•Data modeling, analysis, reporting, deliverables.

•Client meeting and discussion.

15. Client NEW Holland Tractor

Technologies Qlikview with BAAN

Role Developer

Project Type Development(S&D - Pilot)

Period 3 Month

Team Size 3

Role/Responsibility:

•Analyzing the system requirements and performing logical and physical design of the database.

•Business understanding, prepared SRS, data understanding.

•Table understanding, developing user interface.

•Data modeling, analysis, reporting, data testing.

•Client meeting and discussion.

16. Client Liberty Shoes (Karnal)

Technologies Qlikview with SAP

Role Developer

Modules Sales & Distribution,

Material Management

Period 6 Month

Project Type Development

Team Size 4

Role/Responsibility:

•Analyzing the system requirements and performing logical and physical design of the database.

•Business & data understanding.

•Developing user interface, data modeling, analysis, reporting, data testing.

•Client meeting and discussion.

Personal Details:

Nationality Indian

Sex Male

Marital status Married

Total IT experience 12 Years 10 Months

Current location Gurgaon

Mobile +91-989*******, +91-991*******

Email Id ********.********@*****.***

Contact this candidate