Gowthama K.

Gowthama K.

Architect in Software Industry having SQL, Data Mining, Oracle, SSRS, SSIS, SQL Server skills

Bengaluru , India

Experience: 13 Years

Gowthama

Bengaluru , India

Architect in Software Industry having SQL, Data Mining, Oracle, SSRS, SSIS, SQL Server skills

60815 USD / Year

  • Notice Period: Days

13 Years

Now you can Instantly Chat with Gowthama!

About Me

Hi, 

 

Thank you for visiting and going through my profile.

I have vast experience in data and realted technologies. 

I am Microsoft certified in Sql server and Business Intelligence. 

Have more than 13 ...

I am Microsoft certified in Sql server and Business Intelligence. 

Have more than 13 years experience in Data and related techcologies inlcuding database desingn, development, ETL development, Datawarehouse designing, data warehouse development, Data validation , Database administration (Sql server), Database migration from SQL server to Oracle. 

 

I have worked in different domain mainly Advertising and media, Banking, Clinical Research, Healthcare.

 

I am also TOGAF certified Enterprise architecture practitioner. 

I am can help you anything related to SQL server database, ETL, Azure, MSBI(SSIS, SSRS, SSAS) technologies in any domain. 

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