s
subodh1raut

Subodh R

@subodh1raut

MicroStrategy Lead Architect, Database Application Architect cum Lead Database D

India
English
About me
I am a MicroStrategy Lead Architect and Database Application Architect with 15 years of experience. I have a proven track record in MSTR Report Development, Data modeling, Oracle SQL/PLSQL Performance Tuning, and Database Application Design and development.... Read more

Skills

s
subodh1raut
Subodh R
Offline • 
Average response time: 1 hour

See my services

Database Development
I will your professional database developer and bi expert
From$50 / projectMore details

Work experience

Citi

MicroStrategy Application Architect and Database Lead

Citi • Full-time

Sep 2015 - Present • 10 yrs 8 mos

Performed requirement gathering from BA, data modeling of database application, MicroStrategy schema object Hierarchies, Transformations, Attributes, Facts and Relationships as a function of Logical model, participating in establishment of design template to make sure common look and feel, design application flow along with development of database code units using Oracle SQL and PL/SQL. Additionally, perform peer code review for performance improvements.

Mastercard

Oracle Database Developer

Mastercard • Full-time

Jun 2014 - Sep 2015 • 1 yr 3 mos

Involved in the Data modeling OLTP application, Development and Unit Testing of SQL, PL/SQL code. Additionally, Optimize Oracle PL/SQL Applications and Performance tune SQL code. Database Partitioning and Database Migration Activity: Database Partitioning for product’s tables and corresponding Index partitioning was carried out taking into consideration various essential factors for data warehousing environment followed by migration of data from the received flat files of existing software at bank’s site to electraPREPAID 6.0 ITX Series by use of classic ETL techniques.