Keywords
Skills
I have more than 18 Years (15+ IT & 3 Non IT) of experience. Extensively more than 10 Y in Data Management & Data ware house technologies in Architect role. Played different roles Technical& Management like Database Architect, ETL Architect, OLAP Architect, Information Architect, E2E Architect, Senior Solution Architect & Head DWH/BI Practice for Telecom BI. Researched and Developed Product for telecom BI for oracle database for their effective analysis on Enterprise level. The same was implemented & customized for major telecom operators. Extremely worked with Teradata iLDM models C-LDM, FS-LDM, R-LDM. Worked in large scale database size of 3.2 PITA Bytes for PAYPAL. Good experience in Big data Implementation Framework for telecom domain.
Highly Technically skilled in the following Data warehouse tools & Data Bases like architect, administrator, developer.
Big Data: Hadoop, Hive, Hbase, Spark, Sqoop, flume.
ETL tools: Data stage, Informatica, OWB, ODI, Talend, Teradata Utilities, SSIS.
BI tools: Cognos, Micro Strategy, Business Objects, OBIEEE, SSRS.
Data Model: ER-Win, ER-Studio, Power Designer and SQL Work Bench.
Data bases: Teradata, Oracle, SQL Server, My SQL, DB2.
Highly Technically skilled in the following Data warehouse tools & Data Bases like architect, administrator, developer.
Big Data: Hadoop, Hive, Hbase, Spark, Sqoop, flume.
ETL tools: Data stage, Informatica, OWB, ODI, Talend, Teradata Utilities, SSIS.
BI tools: Cognos, Micro Strategy, Business Objects, OBIEEE, SSRS.
Data Model: ER-Win, ER-Studio, Power Designer and SQL Work Bench.
Data bases: Teradata, Oracle, SQL Server, My SQL, DB2.
- Developed large scale data bases from 100TB to 3.2 PITA Bytes. Worked & developed standard methodologies for continuity of DWH Systems.
- Developed third generation DWH system using Ralph Kimball, Inmon Approach.
- Expert in normalized & de normalized techniques and more in DWH with Star schema/snow flake schema and modelling in enterprise scenarios implementation of database architectures, ETL processes.
- Highly work experience in capacity planning, resource planning, cost estimation, time estimation, BAR Architecture.
- Worked more on change data capture, data archival process with different vendors.
Project history
Project Name: Tesco GMO.
Client : Tesco, UK.
Description: Tesco is one of the largest retailers in the Europe. General Merchandising Online (GMO) is Tesco's e-commerce platform which serves its customer through various channels viz. online, phone, in-store. As part of data management we developed ODS as well as EDW for better analysis on the behavior of customer, product information, Order management, and inventory.
Project Name: Lenders one Management.
Client : Altisource, USA.
Description: Lenders one is a national alliance of leading community mortgage bankers, corresponding to lenders and vendors of mortgage products and services. Each vendor uses their one system to maintain transactional data. The project was developed In order to maintain & combine all vendors’ relevant data and to produce analytical reports on members and vendors performance.
Project Name: ET-EDW
Client : Etisalat, UAE.
Description: Etisalat is a leading telecommunication provider in UAE region. Etisalat want to establish their own business in other countries like Egypt, Nigeria, and Srilanka. As part of improvement Etisalat top management decided to renew their systems by bringing new technologies from competitive world. The main focus of this project is a full, turnkey solution that is easy to operate, maintain, develop, and upgrade, and offers the best total cost of ownership and return on investment. The Data Warehouse was developed for Etisalat by customizing CLDM for various requirements in terms of contain historical information with the lowest granularity possible and integrates several source of information in a way which makes querying, reporting and analysis fast and efficient.
Project Name: EDW-360
Client : PAYPAL
Description: PayPal is global online company owned by eBay having its own data centers at Sanjose, Omaha, Chennai. PayPal DWH system is the biggest Data ware house system after Wall mart (more than 3 PITA Bytes) which was implemented in terdata.The PayPal business enormously increases during the recent time and it crossed 100 million active customers Base. Now PayPal internally started EDW-360 Project to focus on rebuilding DWH system for to reduce the CPU count, data redundancy, single version of truth, Metadata management, Master data management & data governance.
Project Name: EDB-BI-EDW
Client : ETISALAT
Description: EDB aims to launch its wireless GSM operations in different parts of India, targeting 75 million subscribers Base in the first 10 years. EDB will operate in three regions of India and will have license for 15 operation circles. Each circle will have a separate operation identity but it will maintain its operations centrally. Business Intelligence (BI) is responsible for giving the enterprise wide view of the business for EDB, to provide necessary dashboards & reports to business. BI is responsible for taking all the source systems data and provides cross functional analysis for the business. Implementation was happened using Teradata with cLDM customization.
Roles & responsibilities:
Project Name: Unitech Wireless Business Intelligence
Client : UNINOR
Description: The Telenor Group has in 2009 acquired a majority stake in Unitech Wireless, a telecommunications company with licenses to operate in all of India. The company is a green-field implementation, scheduled to roll out operations in the first 8-11 circles (government specified operating areas for Telcos) by December 2009, with continuous roll out of operations in the remaining circles afterwards. The main focus of this project is a full, turnkey solution that is easy to operate, maintain, develop, and upgrade, and offers the best total cost of ownership and return on investment. The Data Warehouse was developed for Unitech by customizing TCLDM (Teradata communication logical data model) for various requirements in terms contain historical information with the lowest granularity possible and integrates several source of information in a way which makes querying, reporting and analysis fast and efficient.
Roles & responsibilities:
Project Name: BI-360
Client : Dialog Telekom, Srilanka.
Description: Dialog Telekom is the largest mobile phone network in Sri Lanka, focusing mobile telephony business. The company provides international services, supporting an International Gateway infrastructure providing retail and wholesale international voice and data services under the brand name of Dialog Global. The company also provides Internet services through Dialog Internet-a fully-fledged Internet Service Provider (ISP). Dialog Telekom also operates Dialog SAT, a mobile satellite service. The focus of BI-360 Project implementation for Dialog was to continue with its energetic drive towards rapid growth, Business Intelligence (BI) capabilities will enhance the competitiveness while empowering Dialog to take timely decisions both at strategic and operational level based on analysis.
Roles & responsibilities:
Project Name: GHI Integration System.
Client : GHI, USA
Description : This project is to integrate and implementing Enterprise Data warehouse system for the two companies GHI (Group Health incorporated) and HIP (Health Insurance Plan of greater New York) which are merged in 2006. The focus of the project is to make ease for the business users to take proper decisions time to time and to analyze various reports for different levels. Before the merger the two companies had different plan structures to provide insurance for their customer’s approx 2.6 millions. The goal of the project is to integrate the two company’s data into one common database and implementing Data Warehouse. The project is of offshore model.
Roles & responsibilities:
§ Testing of mappings
§ Tuning of ETL Process.
§ Talend was used ETL Tool.
§ Create reports to meet client requirements.
Project Name: e-governance.
Client : Goa Government.
Description: This project is developed for Goa government to put all their 22-dept operations into Online on departmental level. This was one of the big and huge project concerns on the database level. The main focus for e-governance software development was to eliminate all manual operations in the Government and put everything into online on different accessing levels. The Goa Government employees are the users. All the operations was captured by dept level and analyzed based on the business logic and converted into software applications. The project covers all major domains Healthcare, hospital, financial, payrolls, Legal, inventory, human resource etc.
Roles & responsibilities:
o Preparing of SRS and URS.
o Dividing the modules into sub modules.
o Preparation of database high-level design.
o Preparation of database Low-level design.
o Design the screens by Understanding the business logic of the operations according to department requirements.
o Analyzing the required reports.
o Filling the gaps between the programmer developer and database developer.
o Analyzing common things between dept.
o Developing ER diagrams
o Developing complex quires by using Toad.
o Data migration.
o Database tuning.
o Database backups.
o Ensure the project to complete in time frame.
Highlights of the project:
1 Nearly three thousand tables had designed for this project.
2 4NF had used.
3 In some Areas Data migration had done by using Process engines and in some areas using ETL Tool Informatica.
Project Name: Loan Tracer
Client : IOB Bank.
Description: This project is developed to help the banks to find the loan defaulters at the time of sanctioning loans to the customers. Here the admin module the bankers will register then the admin creates two IDs and passwords for that banker. Using that id bank manager can login to that site, and just he check out the person is available in defaulters list using search options. If he finds then he will decide for the sanction of loan. This is purely bank maintained site and all bankers formed like a committee and takes necessary steps to overcome from the defaulters.
Roles & responsibilities:
Project Name: WDM system.
Client : Data tray services. USA
Description: WDM system is developed to distribute & organize the work in systematic manner in the companies. The project helps to use in medical transcription companies and BPO companies. The software consists of client component and server component. The server component will create central repository and all clients’ collects information from this. The client component will connect to the server and also creates own folders for the users. The users are managers, quality control team and employees of various sections etc. Admin will create roles & access permissions to the users based on the levels they are working. All backend process will save in the database so management can take proper decisions time to time.
Roles & responsibilities:
Project Name: PDC banking system.
Client : HDFC Bank.
Description: This project basically developed for to maintain the cheques in the bank or some other vendor place. The software will helps about the necessary cheque information for the user where it has to present, when it has to present, the current status of the cheque and old history of the customer to take necessary action. It also supports to take decisions time to time. The system Can be used offline so that this will be reduces the work in the bank at peak times.
Roles & responsibilities:
Project Name: Banking IPO system.
Client : Kotak Mahindra Bank.
Description: This software developed for Banks to help out whenever public issues will open. This software will use in allover their branches and collected information will keep in central repository. The managers can take executive decisions based on day-to-day Transactions. Reports can be generated based on religion, payments, and branch wise. It will also help to prepare plan on resources whenever large IPOs occurs.
Roles & responsibilities:
Project Name: E_Liasion.
Client : Nahusha Systems, USA
Description: This project is developed for online bidding (like consultancy) for projects development. In this two types of users are there, one is the buyer and other is service providers and administrator. Here service providers’ means who are giving services and they have four categories According to the project handling. The buyers are to take projects or services from the service providers. Admin has to interact with both service providers and buyers and acts as a mediator.
Roles & responsibilities:
Client : Tesco, UK.
Description: Tesco is one of the largest retailers in the Europe. General Merchandising Online (GMO) is Tesco's e-commerce platform which serves its customer through various channels viz. online, phone, in-store. As part of data management we developed ODS as well as EDW for better analysis on the behavior of customer, product information, Order management, and inventory.
- Leading Data management group for Tesco GMO group.
- Build & Develop Process For Data management group.
- Providing key inputs for choosing vendor tools in data management.
- Gathered information from all vendors sources systems.
- Implemented MDM to give complete data uniformity, accuracy for all systems.
- Worked in Estimation of ETL, OLAP, and Data model based on tools Data stage, ER-Win, Micro Strategy.
- Provide Architecture complete ETL.
- Provide Architecture Change Data Capture using IBM CDC.
- Developed data model for the project.
- Work with teams closely to Collection Meta data from all Business units.
- Drive & mentor teams like ETL Team, OLAP Team.
Project Name: Lenders one Management.
Client : Altisource, USA.
Description: Lenders one is a national alliance of leading community mortgage bankers, corresponding to lenders and vendors of mortgage products and services. Each vendor uses their one system to maintain transactional data. The project was developed In order to maintain & combine all vendors’ relevant data and to produce analytical reports on members and vendors performance.
- Build & Develop Process For Data management group.
- Implemented MDM to give complete data uniformity, accuracy for all systems.
- Gathered information from all vendors sources systems.
- Worked in Estimation of ETL, OLAP, and Data model based on tools Talend, SQL work bench, Micro Strategy.
- Provide Architecture complete solution for BI.
- Developed data model for the project.
- Work with teams closely to Collection Meta data from all Business units.
- Drive & mentor large teams like ETL Team, OLAP Team.
Project Name: ET-EDW
Client : Etisalat, UAE.
Description: Etisalat is a leading telecommunication provider in UAE region. Etisalat want to establish their own business in other countries like Egypt, Nigeria, and Srilanka. As part of improvement Etisalat top management decided to renew their systems by bringing new technologies from competitive world. The main focus of this project is a full, turnkey solution that is easy to operate, maintain, develop, and upgrade, and offers the best total cost of ownership and return on investment. The Data Warehouse was developed for Etisalat by customizing CLDM for various requirements in terms of contain historical information with the lowest granularity possible and integrates several source of information in a way which makes querying, reporting and analysis fast and efficient.
- Re-building Solution Architecture for Data warehouse Practice.
- Build & Develop Process For Data management group.
- Implemented MDM to give complete data uniformity, accuracy for all systems.
- Gathered information from All Business unit heads like marketing, sales, finance to know the present challenges.
- Worked in RFP, RFQ and RFI.
- Architect & provide complete solution for BI.
- Customization & implementation on teradata cLDM.
- Plan, analyze and evaluate solutions for Cognos enterprise planning environment.
- Work with teams closely to Collection Meta data from all Business units.
- Drive & mentor large teams like DM team, ETL Team, OLAP Team.
Project Name: EDW-360
Client : PAYPAL
Description: PayPal is global online company owned by eBay having its own data centers at Sanjose, Omaha, Chennai. PayPal DWH system is the biggest Data ware house system after Wall mart (more than 3 PITA Bytes) which was implemented in terdata.The PayPal business enormously increases during the recent time and it crossed 100 million active customers Base. Now PayPal internally started EDW-360 Project to focus on rebuilding DWH system for to reduce the CPU count, data redundancy, single version of truth, Metadata management, Master data management & data governance.
- Build & Develop Process For Data management group.
- Consult All Business unit RM’s to know the present challenges.
- Analyze the gaps on present DWH System.
-
- Business.
- Logical Model management.
- Physical model management.
- ETL all strategies.
- OLAP model management.
- Infrastructure.
-
- Architect & provide solution based on Standard models like FSLDM.
- Convince & make accept the new solution for all business users.
- Implement on Power designer as a single tool for all model management.
- Work with team closely to Collection Meta data from all Business units.
- Drive & mentor large teams like DM team, ETL Team, OLAP Team.
Project Name: EDB-BI-EDW
Client : ETISALAT
Description: EDB aims to launch its wireless GSM operations in different parts of India, targeting 75 million subscribers Base in the first 10 years. EDB will operate in three regions of India and will have license for 15 operation circles. Each circle will have a separate operation identity but it will maintain its operations centrally. Business Intelligence (BI) is responsible for giving the enterprise wide view of the business for EDB, to provide necessary dashboards & reports to business. BI is responsible for taking all the source systems data and provides cross functional analysis for the business. Implementation was happened using Teradata with cLDM customization.
Roles & responsibilities:
- Gathering requirements from the client.
- Estimation on project deliverables & mile stones.
- Design the E2E Solution architecture for EDW & MIS.
- Customized cLDM according to requirements.
- Customized DAC for the required reports.
- Design Logical Model for EDB EDW.
- Design of physical Dimension model.
- Analysis on the source systems.
- Design the ETL Architecture, OLAP Architecture.
- Drive the ETL Team, OLAP Team, DM & BA team.
Project Name: Unitech Wireless Business Intelligence
Client : UNINOR
Description: The Telenor Group has in 2009 acquired a majority stake in Unitech Wireless, a telecommunications company with licenses to operate in all of India. The company is a green-field implementation, scheduled to roll out operations in the first 8-11 circles (government specified operating areas for Telcos) by December 2009, with continuous roll out of operations in the remaining circles afterwards. The main focus of this project is a full, turnkey solution that is easy to operate, maintain, develop, and upgrade, and offers the best total cost of ownership and return on investment. The Data Warehouse was developed for Unitech by customizing TCLDM (Teradata communication logical data model) for various requirements in terms contain historical information with the lowest granularity possible and integrates several source of information in a way which makes querying, reporting and analysis fast and efficient.
Roles & responsibilities:
- Gathering requirements from the client.
- Design the E2E Solution architecture for EDW & MIS.
- Customized cLDM according to requirements.
- Customized DAC for the required reports.
- Design Logical Model for Unitech EDW.
- Design of physical Dimension model.
- Analysis on the source systems.
- Design the ETL Architecture, OLAP Architecture.
- Drive the ETL Team, OLAP Team, DM & BA team.
Project Name: BI-360
Client : Dialog Telekom, Srilanka.
Description: Dialog Telekom is the largest mobile phone network in Sri Lanka, focusing mobile telephony business. The company provides international services, supporting an International Gateway infrastructure providing retail and wholesale international voice and data services under the brand name of Dialog Global. The company also provides Internet services through Dialog Internet-a fully-fledged Internet Service Provider (ISP). Dialog Telekom also operates Dialog SAT, a mobile satellite service. The focus of BI-360 Project implementation for Dialog was to continue with its energetic drive towards rapid growth, Business Intelligence (BI) capabilities will enhance the competitiveness while empowering Dialog to take timely decisions both at strategic and operational level based on analysis.
Roles & responsibilities:
- Gathering requirements from the client.
- Design the Solution design architecture.
- Analyzing required Database.
- Customized WTLDM based on Dialog requirements.
- Design Logical Model for both ODS & EDW.
- Design of physical Dimension model.
- Analysis on the source systems.
- Design the ETL Architecture, OLAP Architecture.
- Drive the ETL Team, OLAP Team, DM & BA team.
Project Name: GHI Integration System.
Client : GHI, USA
Description : This project is to integrate and implementing Enterprise Data warehouse system for the two companies GHI (Group Health incorporated) and HIP (Health Insurance Plan of greater New York) which are merged in 2006. The focus of the project is to make ease for the business users to take proper decisions time to time and to analyze various reports for different levels. Before the merger the two companies had different plan structures to provide insurance for their customer’s approx 2.6 millions. The goal of the project is to integrate the two company’s data into one common database and implementing Data Warehouse. The project is of offshore model.
Roles & responsibilities:
- Gathering requirements from the client.
- Design the client architecture.
- Analyzing required Database.
- Design Logical Dimension model.
- Design of physical Dimension model.
- Analysis on the source systems.
- Preparing business rules to load Data from source to target.
- Lead ETL team.
§ Testing of mappings
§ Tuning of ETL Process.
§ Talend was used ETL Tool.
- Design of OLAP System.
§ Create reports to meet client requirements.
Project Name: e-governance.
Client : Goa Government.
Description: This project is developed for Goa government to put all their 22-dept operations into Online on departmental level. This was one of the big and huge project concerns on the database level. The main focus for e-governance software development was to eliminate all manual operations in the Government and put everything into online on different accessing levels. The Goa Government employees are the users. All the operations was captured by dept level and analyzed based on the business logic and converted into software applications. The project covers all major domains Healthcare, hospital, financial, payrolls, Legal, inventory, human resource etc.
Roles & responsibilities:
- Design architecture for the process.
- Gathering & analysis of the various departmental Processes.
o Preparing of SRS and URS.
o Dividing the modules into sub modules.
o Preparation of database high-level design.
o Preparation of database Low-level design.
o Design the screens by Understanding the business logic of the operations according to department requirements.
o Analyzing the required reports.
o Filling the gaps between the programmer developer and database developer.
o Analyzing common things between dept.
o Developing ER diagrams
o Developing complex quires by using Toad.
o Data migration.
o Database tuning.
o Database backups.
o Ensure the project to complete in time frame.
Highlights of the project:
1 Nearly three thousand tables had designed for this project.
2 4NF had used.
3 In some Areas Data migration had done by using Process engines and in some areas using ETL Tool Informatica.
Project Name: Loan Tracer
Client : IOB Bank.
Description: This project is developed to help the banks to find the loan defaulters at the time of sanctioning loans to the customers. Here the admin module the bankers will register then the admin creates two IDs and passwords for that banker. Using that id bank manager can login to that site, and just he check out the person is available in defaulters list using search options. If he finds then he will decide for the sanction of loan. This is purely bank maintained site and all bankers formed like a committee and takes necessary steps to overcome from the defaulters.
Roles & responsibilities:
- Gathering & analysis of the System.
- Design architecture for the process.
- Design of data warehouse system using star schema and snow flag schema.
- Preparing of SRS and URS.
- Preparation of database high-level design.
- Preparation of database Low-level design.
- Analyzing the required reports.
- Developing ER diagrams.
- ETL Process done by informatica tool.
- Database tuning.
- Database backups.
- Ensure the project to complete in time frame.
Project Name: WDM system.
Client : Data tray services. USA
Description: WDM system is developed to distribute & organize the work in systematic manner in the companies. The project helps to use in medical transcription companies and BPO companies. The software consists of client component and server component. The server component will create central repository and all clients’ collects information from this. The client component will connect to the server and also creates own folders for the users. The users are managers, quality control team and employees of various sections etc. Admin will create roles & access permissions to the users based on the levels they are working. All backend process will save in the database so management can take proper decisions time to time.
Roles & responsibilities:
- Gathering & analysis of the System.
- Design architecture for the process.
- Design of data warehouse system using star schema and snow flag schema.
- Preparing of SRS and URS.
- Preparation of database high-level design.
- Preparation of database Low-level design.
- Analyzing the required reports.
- Developing ER diagrams.
- ETL Process done by Informatica tool.
- Database tuning.
- Database backups.
- Ensure the project to complete in time frame.
Project Name: PDC banking system.
Client : HDFC Bank.
Description: This project basically developed for to maintain the cheques in the bank or some other vendor place. The software will helps about the necessary cheque information for the user where it has to present, when it has to present, the current status of the cheque and old history of the customer to take necessary action. It also supports to take decisions time to time. The system Can be used offline so that this will be reduces the work in the bank at peak times.
Roles & responsibilities:
- Design of Database.
- Preparing of SRS and URS.
- Preparation of database high-level design.
- Preparation of database Low-level design.
- Analyzing the required reports.
- Filling the gaps between the programmer developer and database developer.
- Developing ER diagrams
- Data migration.
- Database tuning.
- Database backups.
- Ensure the project to complete in time frame.
Project Name: Banking IPO system.
Client : Kotak Mahindra Bank.
Description: This software developed for Banks to help out whenever public issues will open. This software will use in allover their branches and collected information will keep in central repository. The managers can take executive decisions based on day-to-day Transactions. Reports can be generated based on religion, payments, and branch wise. It will also help to prepare plan on resources whenever large IPOs occurs.
Roles & responsibilities:
- Design of Database.
- Preparing of SRS and URS.
- Preparation of database high-level design.
- Preparation of database Low-level design.
- Analyzing the required reports.
- Filling the gaps between the programmer developer and database developer.
- Developing ER diagrams
- Database tuning.
- Database backups.
- Ensure the project to complete in time frame.
Project Name: E_Liasion.
Client : Nahusha Systems, USA
Description: This project is developed for online bidding (like consultancy) for projects development. In this two types of users are there, one is the buyer and other is service providers and administrator. Here service providers’ means who are giving services and they have four categories According to the project handling. The buyers are to take projects or services from the service providers. Admin has to interact with both service providers and buyers and acts as a mediator.
Roles & responsibilities:
- Design of Database.
- Preparing of SRS and URS.
- Preparation of database high-level design.
- Preparation of database Low-level design.
- Analyzing the required reports.
- Filling the gaps between the programmer developer and database developer.
- Developing ER diagrams
- Database tuning.
- Database backups.
- Ensure the project to complete in time frame.
Local Availability
Only available in these countries:
India
Available
