Gowthama K.

Gowthama K.

Sr. Data Architect

Bangalore , India

Experience: 13 Years

Gowthama

Bangalore , India

Sr. Data Architect

60815 USD / Year

  • Notice Period: Days

13 Years

Now you can Instantly Chat with Gowthama!

About Me

Good experience as Data Architect and data modeler....

Show More

Portfolio Projects

Contribute

• Developing SSIS packages and complex reports • Resolving issues in the ETL (SSIS/SQL Stored procedure) • Responsible for all the jobs (about 350 jobs) • SPOC for all downstream and upstream system

Description

Working as part of support and development team where the focus on developing and improving the SCDI (Service Configration Data Integration). The tool which integrates the data for an entire enterprise to manage and confiure IT systems from different systems like CMDB, ITAM(IT Assent Management Tool), Eventing and Monitoring tools, Discovery Tools(ADDM).

Show More Show Less

Contribute

● Responsible for developement of ETL(SSIS) . ● Responsible for Development of SSRS Reports ● Responsible for developing KPIs ● Dashboards, reporting, automation, deep dive/RCA analysis, insights & p

Description

This project helps Auditing the accounts enterprise wide globally. The project helps to configure KPIs depending on the country and policies. KPIs can be configured according to the local rules and policies.

The challenges faced in this project are to integrate the data from different modules and systems like Sales, Finance Marketing, HR, etc.

Show More Show Less

Contribute

● Taking part in Design meetings, planning data storage. ● ETL development and deployment, developing reports, helping team in resolving performance issues. ● Data mapping, data analysis, investigati

Description

Nielsen Mobile a division of The Nielsen Company has launched a product called On Device Metering. The ODM product will be based on data collected from mobile phone user handsets via an application on the handset which logs the user behavior. The data is transmitted to a central collection system, where it will be processed and reported.

This is a Datawarehousing project which would help Mobile makers in deciding future manufacturing models by helping them to choose features, applications, OS etc to be used in their new models. Other feature of this data warehouse is to help the customers to choose the Mobile application or websites where they can give their advertisements. The application was having the capability to show top Unique Audience per application/website, top application/websites used/visited with demographic details. The main challenge in this project is the magnitude of data in the data warehouse. The data was crossing several TBs in size.

Show More Show Less

Contribute

● Responsible for data migrations.(old schema to new schema) ● Creating SSIS packages for loading data from different data source. ● Responsible for Database administration.(Backup, restore, replicati

Description

Health care product which is used to manage hospitals, patient details, insurance details, claims details, insurance provider details, etc. It’s a integrated product which is used to track business flow and details of patient from admission to insurance claim. The product helps doctors and nurse or hospital staff to manage details of patient, track status of the patient. Assigning work to doctors or nurse, make reviews etc., It has i/p and o/p modules which is for in patient or out patient. They can easily manage patient details using this product. After discharging or taking service from hospital, service providers(Hospital) can directly claim for insurance settlement.

Insurance providers(or TPA) can manage their member details like coverage details, member history, member personal details, claims details etc.

Show More Show Less

Description

General Motors is one of biggest Car manufacturer in US. GM wanted to build different end to end customer journeys and marketing campaign using Adobe tools like AEP AJO CJA Websdk. As an data architect my role was to analyse the source systems build data models for AEP to suite the business needs. Define roadmap and plan for data integration from different source systems.

Show More Show Less

Description

Costa Coffee is having chain of coffee restaurants around the world. Costa Coffee wanted to build different end to end customer journeys and marketing campaigns using Adobe tools like AEP AJO. As an data architect my role was to analyse the source systems build data models for AEP to suite the business needs. Define roadmap and plan for data integration from different source systems. Assist AJO developers in understanding the data and attributes validation and verification of journeys.

Show More Show Less

Description

GoodLife Fitness is having chain of health clubs in Canada and Europe providing Gym and fitness services. GoodLife wanted to build different end to end customer journeys and marketing campaigns with online and offline user activity using AEP. As an data architect my role was to analyse the source systems build data models for AEP based on the their data to suite the business needs. Define roadmap and plan for data integration from different source systems.

Show More Show Less

Description

Show More Show Less