Saurabh Dimri
Gurgaon
Summary
Over 9 plus years of IT experience in analysis, design, development, implementation and testing of applications in data warehousing and client/server environment.
Worked on Oracle PL/SQL ,Snaplogic,Snowflake,AWS, Informatica ,Unix,ETL
Overview
8
8
years of professional experience
Work History
Accenture Services Private Limited
Application Development Specialist
Accenture
Gurgaon
06.2021 - Current
- Performed code reviews to ensure quality standards were met.
- Provided technical guidance to team members on coding standards, debugging techniques and best practices.
- Working on snap logic tool to create recon feeds
- Working on Snowflake
Senior Application programmer
Virtusa Polaris
gurgaon, haryana
03.2019 - 11.2020
- Works with performance testing team to resolve all performance issue related to any jobs
- Resolve all performance issue which are related to database by providing solution for better performance
- Analysis OEM & AWR report for performance environment and provide best solution to optimise batch job
- Write complex SQL query to help testing team for any particular issues to test them
- Having experience of Production releases and manage them with zero defect
Application development senior analyst
Accenture
06.2016 - 03.2019
- Worked with the KENAN core tables for NRC, RC and USAGE
- Understanding the requirement and developing the PL/SQL objects such as procedures, Functions and triggers
- Providing technical direction, mentoring and training new developers for understanding the Kenan Configuration
- Create DDL for required database objects and migration scripts to load data into new structures when needed
- Have worked on various schema objects like tables, sequences, indexes and views
- Solid understanding of inheriting PL/SQL object types, casting PL/SQL objects types into descendent types, converting PL/SQL object collection into a result set, bulk operations
- Used SQL, PL/SQL in writing queries, functions and procedures
- Worked with Program Analyst regularly for mocking test cases for the Business Requirements
- Dynamic SQL to provide data on UI
- Worked on data migration from test environment to UAT and production environment.
Skills
- Snowflake
- PL/SQL
- Performance tuning
- AWS
- Unix
- ETL
- Snap logic
- INFORMATICA POWER CENTER TOOL
- Control M
- GIT
- Oracle enterprise manager
- Bamboo
- GIT
- SVN
- Finance
- Telecom
Academic Qualification
B.Tech. in Electronics & Communication, 2014, Graphic era university, Uttarakhand, D.A.V Public school (CBSE), 2009, St. joseph’s convent school (ICSE), 2007
Personal Information
Date of Birth: 03/06/93
Disclaimer
I hereby declare that all the information furnished above is true to the best of my knowledge and belief.
Timeline
Application Development Specialist
Accenture
06.2021 - Current
Senior Application programmer
Virtusa Polaris
03.2019 - 11.2020
Application development senior analyst
Accenture
06.2016 - 03.2019
Accenture Services Private Limited