Vinay Yadav
Lead Database Developer (Associate Manager)
Hyderabad
Summary
Over 13.4+ years of experience in Oracle and Teradata Development along with Unix shell scripting in designing, developing, architecture and implementation of Business Intelligence, Data Warehouse Applications under different environments.
Core focus on Data Warehousing OLAP tools and PL/SQL.
3 Years of Experience as Oracle APPLICATION DBA with Exadata Platform
Design logical and physical data models using in-house data warehousing tool ESP.
Worked as Team Lead (for DATAWARE HOUSE) for large Retail customer based in UK
for 1.5 years and a TELECOM customer in INDIA for approx. 2 years.
Developed and automated various jobs for large telecom customer which resulting in
saving approx.. 50% resources cost and increased 300% Revenue for Customer
specific to domain.
Managed 24*7 Support Team for 2 years as a Technical Lead and played domain
spokes role for Telecom customer
Overview
13
13
years of professional experience
10
10
years of post-secondary education
2
2
Languages
Work History
Lead Database Developer
State Street India Pvt. Ltd
Hyderabad
02.2019 - Current
- Worked within applicable standards, policies and regulatory guidelines to promote safe working environment.
- Led projects and analyzed data to identify opportunities for improvement.
- Performance Optimization of SQL Queries and Data management
- Various DB maintenance activity at particular interval
- OGG Deployment and Monitoring
- Built PL/SQL package to automate purge and archive for historical partitions.
- Worked on automation of various manual activities using Oracle, Unix, AutoSys and excel macros thereby saving resource time and cost to company.
- Efficiently resolved SQL query performance issues by using Exadata smart scan and indexing features of Oracle.
- Coordination with L2 production support team and Application Team during any production related Major issues.
- Support deployment activity that involves new enhancement or defect fixes for the tool
- Produce reports from Service Now to report team’s efficiency and performance.
Technical Lead Software Developer
Wipro Ltd.
Bengaluru
02.2014 - 02.2019
- Performance Optimization and enhancement of Loading Process
- Redesign the scripts to perform better and optimally eliminating redundant Joins and optimizing the performance.
- Worked closely with Business Users to get the BRD understanding and Prepared theHigh-Level Design document.
- Worked on design changes in the existing data model, impact analysis and code changes and data corrections.
- Created an automated system to extract data from Teradata tables by using utilities like Fastload, Bteq ,TPT and TJC.
- Automated scripts built by UNIX wrappers and Build Preparation and Release process
Associate Consultant, Technology
Magna Infotech Pvt. Ltd
Gurgaon
07.2011 - 01.2014
- Oversaw technology services delivery, consulting with relevant personnel to assist with migration and troubleshooting.
- Supported technology design, testing and execution by providing research-based product and process knowledge.
- Provided technical and functional recommendations based on project requirements.
- Compiled research data and gave professional presentations highlighting finds and recommended optimizations.
Software Engineer
JR Beeta Soft Technologies Noida
Noida
07.2009 - 06.2011
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance.
- Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
- Analyzed proposed technical solutions based on customer requirements.
- Offered experience with Oracle 11G.
Education
Bachelor of Science -
S.C.P.G College
Ballia (U.P) India 07.2001 - 06.2004
Master of Computer Applications - Computer Science
Madan Mohan Malviya .Govt. Engg. College
Gorakhpur (U.P). India 07.2006 - 06.2009
Intermediate - Physics ,Chemistry , Maths
P.N.Inter College Dubechapara
Ballia (U.P) India 07.1999 - 06.2001
High School Diploma -
P.N.Inter.College.Dubechapara
Ballia (U.P) India 07.1997 - 06.1999
Skills
Data warehouse Development
undefinedAccomplishments
Awarded Innovator of the Year 2014 for developing reusable product for Wipro
telecom customer.
Recognized and awarded for outstanding work in Current organization for year 2020.
Awarded best innovator for Year 2015 Q3 for Automation.
Awarded as best innovation Team in year 2016 as technical/Team Lead.
Spot award achieved for best performer in Q1 2017
Awarded for Best delivery Team in 2020 in Current Organization.
Recognized for Bravo award in 2022 for Committed Delivery .
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
Lead Database Developer
State Street India Pvt. Ltd
02.2019 - Current
Technical Lead Software Developer
Wipro Ltd.
02.2014 - 02.2019
Associate Consultant, Technology
Magna Infotech Pvt. Ltd
07.2011 - 01.2014
Software Engineer
JR Beeta Soft Technologies Noida
07.2009 - 06.2011
Master of Computer Applications - Computer Science
Madan Mohan Malviya .Govt. Engg. College
07.2006 - 06.2009
Bachelor of Science -
S.C.P.G College
07.2001 - 06.2004
Intermediate - Physics ,Chemistry , Maths
P.N.Inter College Dubechapara
07.1999 - 06.2001
High School Diploma -
P.N.Inter.College.Dubechapara
07.1997 - 06.1999
Similar Profiles
Perumalla Manasa CMAPerumalla Manasa CMA
Sr.Associate at State Street India Pvt Ltd.Sr.Associate at State Street India Pvt Ltd.
Abhijeet ParalkarAbhijeet Paralkar
Associate Manager at State-street India Pvt LtdAssociate Manager at State-street India Pvt Ltd
Srikanth LakshmikanthanSrikanth Lakshmikanthan
Vice President of Operations at State Street India Pvt LtdVice President of Operations at State Street India Pvt Ltd