Data Quality Assurance

Objective:

To work in a technically competitive and motivated environment involving research, design, development and support where I can exercise my existing skill set and gather wide range of new skills. To put my abilities towards achieving the Organization’s values and goals and to see myself as a mature and thoroughbred professional in the industry.

Professional Summary:

I am unwavering, meticulous, and highly competent IT Professional. I have consistent record of transporting best result driven work with a proven ability in implementing my work in organized manner since three and a half years of my successful career. I expertise in- Business Intelligence Applications (Tableau(Certified)/OBIEE/OWB) including analytics, analysis,data mining, design, data modelling, RPD Modelling, dashboard & report development, configuration, customization, quality assurance testing, debugging, deployment, security, agent configuration, Business Intelligence implementations, administration, UI modification, Data warehousing and ETL processes.

I possess effective professional communication skills and I am a team player with strong Organizational, Logical and Problem Solving Abilities.

I possess determined abilities in planning and executing projects for a wide range of installations, conducting effective preventive breakdown maintenance, planning, problem solving and strategizing techniques to optimize utilization of manpower, machinery and materials.

An effective leader with experience of working with large workforce, possessing excellent communication and interpersonal skills in dealings with customers, regulatory agencies and colleagues at all levels in multicultural environments. Strong influencing and negotiation skills coupled with proven ability to think in and out of the box, generating new solution.

Armed with multitude of competencies and work experience, I am confident to carry forward any organization’s vision & objectives with sufficient ease and dedication towards my job responsibility.

Professional Experience:

Experience 1:

Business Intelligence Consultant at Darwish Bin Ahmed Group of Companies & Saif Bin Darwish,

Abu Dhabi, United Arab Emirates.

Period: February,2016- Present

Role:

Participate as team member following existing processes and procedures.

Migrating current Oracle Hyperion reporting system to Tableau 10.

Understanding Oracle Hyperion Data model and building its optimized version in Tableau 10

Designing the data model (Star/Snow flake modelling)/ RPD modelling & Performance tuning in Tableau 10.

Developing the dashboard /reports/agents & developing complex reports & KPI’s which give more insight into the business performance.

Setting permission access level to the reports/dashboards and subject areas.

Moving the development from development to test to production and hand off the development to the users/clients.

Writing intermediate to complex SQL queries in the data warehouse/data warehousing.

Analysing the physical SQL queries generated by the front end Tableau 10 and writing similar SQL queries in the data warehouse for testing & debugging the development.

Present effort estimation required for planning and prioritizing purposes.

Guide and train to less experienced team members.

Guide and train the users/clients on best practice development of their ad-hoc analysis on Tableau 10.

Perform the Quality Assurance Testing/Debugging on the front end (reports & dashboards) & backend (data model (Star & Snow Flake)) development.

Develop and maintain productive working relationship with customers, team members and project leaders.

Learn effectively business functions to participate in analysis, design, and implementation.

Enhance new technologies knowledge to use them in approved projects.

Participate in special projects as assigned.

Develop code solutions to problems using structured approach considering long term maintainability and accessibility.

Update/write consistently and accurately the documentation on all application projects.

Experience 2:

OBIEE Developer/Analyst at TEKsystems, Hyderabad, India: 2 years.

Period : July- 2013 to July-2015

Clients: Clients based in the U.S.A that I have worked for are Sony Play Station, Amica Mutual Insurance, JDS Uniphase Corporation, PPG Industries & Tervis.

Role:

Participate as team member following existing processes and procedures.

Present effort estimation required for planning and prioritizing purposes.

Guide and train to less experienced team members.

Designing the data model (Star/Snow flake modelling)/ RPD modelling & Performance tuning.

Developing the dashboard /reports/agents and setting security permissions to the development.

Writing intermediate to complex SQL queries in the data warehouse/data warehousing.

Analysing the physical SQL queries generated by the front end OBIEE and writing similar SQL queries in the

data warehouse for testing & debugging the development.

Develop and maintain productive working relationship with customers, team members and project leaders.

Learn effectively business functions to participate in analysis, design, and implementation.

Perform the Quality Assurance Testing on the development.

Gather requirement from the clients based in the USA, and interact with them on daily basis to give status on the development, issues and further requirements or clarifications required for the successful development of the project.

Enhance new technologies knowledge to use them in approved projects.

Participate in special projects as assigned.

Develop code solutions to problems using structured approach considering long term maintainability and accessibility.

Update/write consistently and accurately on documentation on all application projects

Skill Set:

Skills

Software & Technologies

Primary Skill

Tableau 10 (Certified),Oracle Business Intelligence (OBIEE 11g), Data warehousing,Oracle SQL, Data Modelling, Complete Back End(data modeling) & Front End Development(reports & dashboards) with Testing & Debugging, R Programming(Certified).

Secondary Skill

ETL Tool – OWB(Oracle Warehouse Builder), Oracle Hyperion

Database

Oracle Database 11g

Operating System

Windows XP,Vista,7,8,10

Communication Skills

Good professional communication skills in English & Hindi

Certifications:

Please press Ctrl + Click on the certification(s) below to view the certificate on a browser.

1. Tableau Desktop 10 Qualified Associate (Date of Completion: 28-AUG-2017)

2. R Programming by Johns Hopkins University on Coursera.

3. Getting and Cleaning Data by Johns Hopkins University on Coursera.

4. Embedded Systems and Robotics (Serial No. HP/STP-12/DDN/030) – Certified By Hewlett Packard (HP)

Educational Qualification:

●Period : 2009-2013 : (National Institute of Technology, Durgapur)

Pursued Bachelor of Technology in Electronics and Communication Engineering at National Institute of Technology (NIT) - Durgapur, one of the premier institutes for Engineering and Applied Sciences in India.

C.G.P.A: 7.91 out of 10

●Period : 1997-2008 : (Dr. Graham’s Homes: Founded 1900)

Examination

School

Board

Year Of Passing

Result

Intermediate

Dr. Graham’s Homes

Indian Certificate of Secondary Education(ICSE)

2006

86.8%

Secondary

Dr. Graham’s Homes

Indian School Certificate (ISC) examinations

2008

83.5%

●Internship at HP (Hewlett Packard) on Embedded Systems & Robotics.

Personal Details:

Date of Birth : 16-July-1990

Sex : Male

Marital Status : Single

Languages Known : Proficient English, Proficient Hindi.

Total Experience : 3 Years 9 Months

Mobile No. : 00-91-88-055-** 039

E-mail : ****************@*****.***

Thank You for acknowledging my Curriculum Vitae.

Best Regards,

Abhishek Katyal

Contact this candidate