Anurag Varshney

Background

About Anurag Varshney

SUMMARY : 1) 24+ years of rich experience including 3 years of US onsite experience on H1-B in Database Design, Modeling and development in Oracle,SQL Server databases,Postgres, Cloud Databases (Azure, AWS,Dynamo DB,Hadoop), Cloud Data warehouse Snowflake DB Architecture and Cloud Computing 2) 18+ years of experience as Database Architect and Data Modeler in designing,implementing large scale Data Warehouse in OLAP and OLTP systems 3) 15+ years of experience of People Management working as Tech Lead, Team Lead, Project Lead handling a team and Coordinating with India and US Onsite team 4) 06 weeks US On-site visit on ABG,US project through Mindtree Ltd on B1 visa in Jan 2020 at customer location in Parsippany,NJ,US to support the Production Deployment activities, cutover of Database as well as services 5) 05 Weeks US On-site visit on Healthgrades project through Happiest Minds Technologies on B1 visa in 2017 at customer location Madison 6)Worked in Oracle AWS and involved in building Amazon RDS servers and creating instances, EC2,S3 buckets in DEV, TEST and PROD environment 7)Done Performance,Health Monitoring of RDS in Oracle AWS in Solarwinds Monitoring 8)Expertise in Developer Suite, Oracle Forms & Report 11g, D2K 9)As Team lead, mentor my team in Complex coding and new skills in Oracle and sql server Databases and done the code review 10)Excellent communication skills, interpersonal skills, sharp analytical skills and the ability to work as Individual contributor and as part of team and a proven leader. DOMAIN KNOWLEDGE: Oracle,SQL Server, BI/DW, Data Modeling,Cloud-based database design & Architecture-Oracle AWS,Postgres on AWS and EDB Platform STRENGTHS: 1)Database Designing,Data Modeling,Development and coding in Oracle PL/SQL,T-SQL,MS Visio, 2)Designing and administration in Cloud-based Oracle AWS 3)Monitoring database performance in Solarwinds Monitoring tool 4)Performance tuning, analyzing query plans, Explain plan in Oracle and SQL Server databases 5)Coding Complex Stored Procedures, Functions, SQL Scripts in Oracle, SQL Server, Postgresql 6)Data Integration in OLTP and OLAP environment using Data Warehouse, ETL,SSIS,Informatica 7)Job creating, scheduling, monitoring, Automation,troubleshooting in Control-M