Resume

Sign in

Consultant,Data Management and Analytics

Location:
Rawdat Al Khail, Qatar
Salary:
8000
Posted:
June 12, 2019

Contact this candidate

Resume:

Education

College/University

Year Of Passing

GPA

Bachelor Of Science

Stella Maris College, India

2007

7.2

Masters Of Computer Application

SSN College Of Engineering – Anna University, India

2010

7.6

Organization 4 : Thryve Digital LLP

(Under Payroll of:Technosoft Corporation, India Aug 2018 –Apr 2019)

Period: Aug 2018 to Current Date

Role: Lead Engineer

Team Size: 20+

Technologies/Tools: Data Analytics, ETL: Informatica powercenter, Oracle (PL/SQL developer), Teradata

Client: HighMark Health solutions HMHS U.S (Thryve Digital)

Project Brief: Develop ETL process for HMHS Data processing.

Involved in Business Discovery, Data Discovery & Analysis, Data Modeling, ETL Design, Development, Testing, Implementation and Troubleshooting in the field of Data warehousing and Application Development.

Strong Datawarehousing experience specializing in RDBMS, ETL Concepts, Strategy, Design, Development & Testing.

An expert in the ETL Tool Informatica which includes components like PowerCenter, Designer, Workflow Manager, Workflow Monitor, Repository Manager, CDC,Teradata, Oracle. Have had extensive experience in working with various PowerCenter Transformations using Designer Tool. Have handled various Data Sources like DB2, Oracle, SQL Server, MS Access, MS Excel including, Flat Files and XML Files.

Have had extensive experience working with databases like, Oracle and Teradata Was involved in the complete life cycle of quite a few Datawarehouse implementations which include System Architecture, Functional/Technical Design, Development - Coding and Testing (Unit Testing, System Integration Testing and User Acceptance Testing) and Implementation.

Good experience in Performance Tuning at both Database Level and Informatica.

Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.

Strong Team building and mentoring skills and excellent Team leadership capability.

Very good knowledge in working with Windows and UNIX operating systems.

Experience in ORACLE/Informatica performance tuning techniques.

Proficiency in Oracle PL/SQL. Expert in creation of stored procedures and custom SQL to define ETL processes

Played various roles like configuration manager, Defect prevention Representative, Software quality Analyst and Team lead.

Organization 3 : US Tech Solutions, India

Period: Sept 2017 to June 2018

Role: Senior Analyst – Business Intelligence

Team Size: 8

Technologies/Tools: Jasper BI reports (Tibco Jaspersoft studio), ETL: Informatica powercenter, Oracle (PL/SQL developer),,JSP, Jquery, Javascript, GIT Bash

Client: Wipro Project: Best Buy, Canada

Project Brief: Migration of oracle reports and forms of RDM application to Jasper BI reports.

Analyze oracle forms and reports (.rdf files) that has to be migrated to Jasper reports and prepare analysis document for the same.

Had a strong and precise communication with leads and sub ordinates and provided guidance and training to the new bies of the team to ensure everyone was in the same page. I made sure every documentation was available with the team for clearer understanding and development of the project.

Prepared design document, configuration and document required for migration to Jasper servers which was dynamic at its edition level giving me exposure to community edition, enterprise edition and reporting edition and Uploaded all the documents and codes to the confluence server and bit Bucket.

Create jasper reports in jasper studio 6.4 which involves creation and modification of PL SQL queries (oracle being the backend), design reports with multiple sub reports, drill down reports, charts, graphs, conditional formatting, scriptlets, hyper linking images and many more.

Deploy the reports in jasper server and configure required settings and create Unit test case document based on the UAT test results obtained from testing end to end in comparison to source oracle reports and forms and made sure acceptance criteria are met.

Created Java server pages JSP which involved jquery, javascript and java codes for client side validations required at the server level.

Fine tuning and finding defect spots of underlying informatica mappings involved in up gradation and migration at reporting layer database level and documents the changes.

System Testing, Defect Fixing and implementing change request were part of my tasks covering all the stages of SDLC.

Organization 1: Cognizant Technology Solutions

Period: Aug 2010 to Sept 2013

Role: Programmer Analyst.

Team Size: 20

Technologies/Tools: ETL – Informatica Powercenter, IDQ Informatica Data Quality; BI- Jasper BI reports,

DB – MySQL, Oracle (PL/SQL)

Project t: Enterprise Data Clarity;

Clients: mcGrawHill, Diagio, Revenue Assurance, DnB

Project Objective and Brief:

Enterprise Data Clarity is a scientific approach to continuously improving the health of enterprise-wide data. This concept renews the focus on data quality by going beyond commonly adopted approaches and taking it further, into a structured synthesis of components that builds a strong base for maintaining high-quality data at granular levels.

Aid in documentation and maintenance of Use cases, Design, Test cases (QA) and other On Demand Business documents.

Work with the product development team to ensure that the acceptance criteria are met and the software meets project objectives/customer expectations as defined by the product owner.

Bridging Communication between the Manager and Clients through phone calls, live and direct meetings.

Recommendations on new BI Reports on business and technical levels to the clients.

Preparation of deck and Presentation of the business for marketing the build

product to the desired clients.

Business and Technical knowledge sharing to the development and QA team.

Ensuring on Time deliverable of quality products.

Proven experience working in all the phases of software development life cycle.

Maintenance and monitoring of (Data and Metadata) Databases in various servers.

Creating Business Intelligence Reports using Jasper I Reports from the scratch as per business requirements and implementing them in jasper servers.

Performance tuning of query plans and ETL mappings.

Development of Informatica Powercenter (ETL) Mappings and IDQ plans for Data Cleansing, Validation and Migration.

Support for implementation of Business Product for various projects.

User Acceptance Testing, System Testing and Bug Fixing.

Organization 2 : Graphichannel (OYA Events) Qatar

Period: Oct 2013 to June 2017

Role: Business and Events Manager

Team Size: 60

Clients: Qatar Museums, Royal Family HH Sheikh Mohammed, Qatar Rail, Indian Cultural Center, Geo

Wash, Horizon international, Worley Parsons, etc

Responsible for B2B and B2C meetings, Event Planning, Marketing & Social Media Marketing

and prepare marketing strategies and materials.

Handled Company Revenue, invoices, sales and Procurement records and sent the reports to the

Shareholders and communicated with all high level management on organization developments.

Develop a growth strategy focused both on financial gain and customer satisfaction

Conduct research to identify new markets and customer needs

Promote the company’s services addressing or predicting clients’ objectives

Handled Collecting client requirements of the event, Planning and designing of event, Evaluation of budget, logistics, Procurement process, arranging suppliers, Artist & Manpower, Communicate at required stages of an event, preparing Event closure documents and delivering everything on time under budget were important roles of my job but not restricted to it.

Professionally Hosted and MC’d many events.

Handled Recruitment and Training of the staffs.

Handled Projects worth upto 3 Million Qatari Riyals

Events handled: Product Launches, Corporate events, Family day, National Day, Sports Day, Promotions, Birthdays, Weddings, Engagements, Baby Showers and so on.

TOOLS: Microsoft tools, Photoshop, Photobooth Apps

Clients: Qatar Museums, Royal Family HH Sheikh Mohammed, Qatar Rail, Indian Cultural Center, Geo Wash, Horizon international, Worley Parsons, etc

Notice Period: 1 Months. Negotiable

References on Request

Experience Summary: ‘8+ years of experience

5.5 Yrs of Technical (IT) and 3.8 yrs of Management Experience

During my years of profession I have exhibited the following qualities but not limited to the following:

Excellent Communication, Organization, Analytical and interaction skills.

Good Documentation and presentation skills.

Excellent Creative & Technical skills.

Qualifications

Organization Experience

Established Technical Skills

Established Technical Skills

Established Skills

Established Skills



Contact this candidate