Prasantha Sarvadevabatla Email & Phone Number

•Over 19 years as DB Developer, DB Tester, Data ETL Lead, Data Analyst, Data Modeler ,Database Architect, BI Architect, Data Manager on data management platforms using several databases tools & cloud technologies – design, development and supported company-wide databases and ensured data is transferred safely across all departments.• Successful Lead Centralized EDM Operations , Changement Management , Deployment chain ,Vulnerability and Disaster Recovery •Experience with End-to-End Data Warehousing & Database Architect Solution .•Experience with End-to-End Microsoft Business Intelligence Solution.•Experience with ETL (Extract, Transform, Load) tools using MS SSIS, SAP BODS, Informatica Power Center for development, deployment, maintenance, Migrations and Administration tools to Process files, data sources, assist in data correcting, identifying issues, Disaster Recovery, Slowly Changing Dimensions, Data Quality, Data Cleansing, Data Migration, Bulks Exports & Imports, BCP, Restore Databases from Backups.•Experience with Reporting, Dash Boards using tools MS SSRS, MS Power BI, SAP Information Steward, SAP Crystal, Tableau, ASP.Net, C#.Net, SharePoint Services, IEV (Integral Enterprise Viewer) for development, deployment, maintenance, Migrations and Administration.•Development Experience with Databases development, deployment, maintenance and Administration MS SQL Server, SAP HANA, Oracle, Teradata, DB2, SQLite, MongoDB, Amazon Aurora, in Query Optimization & Performance tuning, Profiler, Execution Plan, written Complex Queries, Stored Procedures, Batch Scripts, Triggers, Functions, Define Indexes, Bulk Insert and BCP•Leading Production L1/L2/L3 team Experience.• Changement Management • Vulnerability Management•Successfully Implementation of Data Migration Projects from Database to another Database, One ETL tool to another, One Reporting tool to another, On Premises to Cloud (Azure, AWS).•Experience on Premises ETL to Azure Cloud Migration.•Experience in Migration on Premises folders Structure to AWS S3 Bucket and Process 100 years History files data into SAP HANA.•Knowledge in Data Modeling - Dimensional Data Modeling, Star Schema, Snow flake schema, Fact & Dimension tables, Physical & logical data modeling, Normalization and building Referential Integrity Constraints.•Version Tools Bitbucket,SVN,TFS,GIT & Agile Engineering Practices Using Jira –Scrum & Kanban Boards Presentation and meet timeline deliverables.