>> Design the soluton architecture for Datawarehouse
>> Database Design and Sizing
>> Data Modeling
>> Hardware and Capasity Planning
>> ETL Design and Solutioning
>> Develop the ETL Scripting with using Hive/Shell/Spark
>> Develop complex SQL for ETL
>> Work closely with the business and analytics team in gathering the system requirements.
>> Optimaztion and performance tuning
>> Responsible for ensuring successful and timely completion of all aspects of assigned module.
>> Job responsibilities include translation of business requirements into technology/systems requirements that meet standards and performance criteria.
>> Analyze Data
>> Developed workflows for complete end to end ETL process , validating and applying business logic.
>> Review the design and process.
>> Design Data Migration process

>> Getting understanding of requirements
>> Develop business rules to meet the requirement. analyse the system.
>> Discuss with the business after preparing/verifying the business rules.
>> Design and prapare the pseudo code in MDH for supporitng the development.

With tag of ETL/DWH Architect, serving several things i.e. Technical Solution Architecture definition for EDW. Responsible for design review, code review & ETL review. Review of EDW data model and work on physical design, definition of different indexes. Capacity planning of storage, hardware and software. Support project managers, operations and DBAs. Decides optimum techniques to be followed and applied. Part of external SME reviews and audits conducted for the project.

I Developed the ROI Module of CLM. This module was meant for the Purpose of Measuring and Tracking campaign performances. The Fundamental objective Behind ROI module is to enable bussiness users of clm to enhanced campaigns performances and develop more relevent and more lucrative campaigns road maps.

Also develop Optimized scripts of All CLMUI Scripts with Proper checks & error handling.

Furthermore, I worked closely with the core marketing team of the operator and with external consultants of McKinsey & Co. for definition and closure of the Business Requirements.

Abstract TUI Course Development and Deliver Application is a Web based Interface to the application and a Database System. Application manages the course creation through different tools and various wizards created. Facility to download the courses after compressing the contents. The courses created by the users can be viewed in flash and flash reads the xml as a data source provided by the application. Flash presentation for video file and PowerPoint file for the course.Event calendar

Responsibilities: Database/Application Designing & Programming.

Customer Life Cycle management is a Methodology being adopted by Bharti to understand the customer life cycle, customer behavior , identify patterns, perform micro segmentation and send targeted campaigns & offers to specific segments Business Analytics team to do analytics (modeling - statistical, predictive, micro-segments, cross sell/up sell) on customer data for driving usage and reducing inactive /zero usage. Business Analytics team had a challenging task of presenting a single view of subscribers data thus integrating subscriber information across Bharti IT infra Landscape