Ashvin Sharma Email & Phone Number

India

India

Indore, Madhya Pradesh, India

AV Collections is primarily a women's apparel store. We have both Ethnic as well as Western collections.

India

Hyderabad Area, India

Responsible for:o Involve in Automation of Release Management of DB and Non-DB Objects.o Resolve partition related space issue for development and batch run.o Develop standards procedures for all aspects of the Database. o Created and managed different kinds of tablespaces, space issues, and extent.o Identify routine activity and based on this preparation automation scripts or jobs to maintain day to day DB issues and regulate the activity, building, deploying, and monitoring applications as well as alerting.o Batch Run and design, develop the DB objects as well as Test Cases.o Development & Support, Worked on Projects & Enhancements, report preparation.o Regression testing, Enhancements & Reports preparation, o Preparation of TWS Jobs & Schedule, Release & Deployment Activity.o Resolve partition related space issue for development and batch run.

Bengaluru, Karnataka, India

Responsible for:o Identify the requirement for a new tool which gives optimizes the result for Google searches based on the parameter available on the Google Ad Platform.o Preparing DB objects, fine-tune them based on the different aspects (timings, network load).o Involve The complete life cycle of the new products. (Design, preparing of Code, test case, and implementation).o Worked as an Individual contributor to this project.

Bangaon Area, India

Responsible for:o DB Design (Object such as Table, Views, Procedures, Functions, Index, Partitions based on Data Distribution).o Developed the code and implement the migration procedure and provide support for Migration and data validation.o Fine Tune the queries and resolve the production issue. Query Optimization.o Node Balancing and queries distribution for Data Migration.o For this particular project we have worked on very big DB was one of the table having the size of 5TB and Dell’s whole 20 Years of Service data from one of the file system to Oracle.o Resolve Data type mismatch and Golden gate replication production issue.

Bangalore

Worked with BFSI, Retail industry leader clients 1. JPMC : At Client Location (Mumbai, Bangalore) as a Project Lead2. Society Generale : At Client Location Bangalore as a Consultant3. Family Dollar : Offshore as a Team Lead/Application Administrator4. Walmart : Offshore as a Module Lead5. Wellls Fargo : At Client Location Bangalore as a DB ConsultantResponsible for:o Client Interaction, Requirement Gathering, Data Analysis, RICE Developmento Updating and maintaining configuration spreadsheets and system setups, and cross-functional setup verificationso Understand Business and provide technical and functional solutions to Client.o Interact with Clients VP, HOD, Business Managers, Business Analysts, and understand the issue faced, resolve the problem.o Involved in re-engineering and testing, Oracle Stored Procedures, Functions, and Packages & DB Objects.o Process analyst (analyses, build, an implementer of the new process).o Review of code changes, test procedure, test plans, and other deliverableso Based on either new development or providing a solution on the existing base.o Design & development, Coding of new requirements.o Involved in preparing technical specifications, test plans, and test cases.o Involved in tuning queries in Oracle SQL and PL/SQL.o Involved in DBA activities and Shell Scripting.o Testing of Database Objects and Application Objects.o Involved in the production support activity for various clients.o Involved in the data validation process, Defect, and bug fixing.o Incident/ticket management with Magic Tool (BMC Service Desk Express).o Creation/modification/Deletion of users or roles based on Various Tools to maintain Back office Activity(For client Family Dollar)o Resolve User related as well as Application related issues based on various applications.o Co-ordinate Various teams for support related issues.o Monitor Kronos as well as other 15 application alerts and take appropriate action.

1. Working with Sales & Manufacturing, Supply-Chain clients Cummins Avalon Relational Distribution system (CARDS) is an application supporting the business the functionality of Parts Distribution Centers (PDC) of Cummins: Cummins - Belgium, US, 2. Unilever - UK: Legacy Management System as a DeveloperResponsible for:o Acquiring project-specific knowledge by gathering client requirements based on industry trends.o Involved in Design, Coding, Testing of PL/SQL procedures, triggers, and packages, and shell scripts.o Involved in the Production Support Activity.o Solving issues of access-related activities(Giving Proper user rights and roles).o Preparing Implementation & Backout Plan (Deployment Strategy) for Small as well as Long Changes or Enhancement. (Work as an Implementer).o Coordinating with Team members (Offshore and Onsite) with different Cummins group for Change Management. (Offshore coordinator).o Involve in Sox Activities also work as a Change Coordinator for Problem-solving (Tools used for this Remedy).

Mumbai Area, India

Working with e-Governance clients Ministry of Shipping & its allied departmentResponsible for:o Acquiring domain knowledge.o Acquiring project-specific knowledge by gathering client requirements as per their norms.o Involved in Design, Coding, Testing of PL/SQL procedures, triggers, and packages, Forms and Reports.o Involved in preparing requirements documentation for all affected applications(Mom, and keep tracking of all legal and other documents)o Involved in deployment strategy.o Support and Maintenance( Taking daily, weekly backups).o Understanding of various Unix commands and Unix Cron Tab/Job.o Preparing reports & documentation for end-users.o End-user Training and Customization of our system as per their requirement.

Mca, Organization Behavior And Erp

MCA From SSIT, RATLAM

Bsc Computer Sc. Hons, Computer Science

B. Sc. Computer Sc. Hons