Gautam S.

Gautam S.

B.Tech with 9 years of experience on ORACLE SQL & PLSQL

Hyderabad , India

Experience: 10 Years

Gautam

Hyderabad , India

B.Tech with 9 years of experience on ORACLE SQL & PLSQL

28800 USD / Year

  • Start Date / Notice Period end date: 2020-01-20

10 Years

Now you can Instantly Chat with Gautam!

About Me

B.Tech with 9 years of experience on ORACLE SQL & PLSQL

...

Show More

Portfolio Projects

Compliance Tools (Tracker)

Company

Compliance Tools (Tracker)

Description

Project Profile:

This is requirement for leadership, for understanding how the firm views both the product and value of technology.

 

Roles & Responsibilities:

  • Worked with business users to determine and translate business requirements into technology solutions.
  • Developing of custom queries in advanced SQL for clients to deploy and run reports and developed about fifty reports using advanced SQL.
  • Developing of reports using Crystal Reports.
  • Virtual teaming.
  • Point of contact for clients.
  • Interaction with clients on daily basis as a part of support.
  • Point of contact in India for US team.
  • Responsible for maintaining, enhancing and developing and also supporting applications and technology solutions.

Technology

Oracle 11g,  Crystal Report

Show More Show Less

IBM Implementation & Support

Company

IBM Implementation & Support

Description

Project Profile:

This is an implementation project for Global Mobility team of IBM, where we have setup the data and remuneration policies for global Assignees of IBM. The database stores the information of IBM global assignees and we have designed the custom balance sheet reports using “Crystal Reports” tool. Developed several custom reports and interfaces using SQL, PL/SQL.

 

Roles & Responsibilities:

· Worked with business users to determine and translate business requirements into technology solutions.

  • Developing custom queries in advanced SQL for clients to deploy and run reports and developed about forty reports using advanced SQL and developed generalized SQL and PL/SQL scripts for data load.

· Developing of reports using Crystal Reports.

· Converted custom report from Crystal reports technology to SSRS technology.

· Loaded data from OS file to Oracle data base using SQL*Loader and SQL*PLUS.

· Interaction with clients on weekly basis as a part of support.

  • Point of contact in India for US team.

· Responsible for maintaining, enhancing and developing and also supporting applications and technology solutions.

Technology

Oracle 11g,  Toad 9.53 and 10.6,  Crystal Report, SSRS

Show More Show Less

Client Account Management

Company

Client Account Management

Description

Project Profile:

Work with business users to determine and translate business requirements into technology solutions. And lead Client UATs in new release efforts and help the team in new client acquiring activities.

 

Roles & Responsibilities:

  • Responsible for Bi-weekly Client calls
  • Have conversations with Clients on their day to day issues and problems with GA applications.
  • Responsible for understanding the business issues and data challenges of client's organization and industry.
  • Develops functional specifications and system design specifications for client engagements.
  • Reviews and edits requirements, specifications, business processes and recommendations related to proposed solution.
  • Involved in migration plans and communications with Clients on Production and Test environments migration schedule.
  • Lead Client UAT efforts in Application Releases.

 

  • Technology
  • SharePoint, TFS

Show More Show Less

Tier-II/III Production Support

Company

Tier-II/III Production Support

Description

Project Profile:

GA International Human Resources and GA Comp Assistant are Deloitte management tools which are used for tracking and managing expatriate payroll and compensation collection process. These are used to monitor and maintain international assignee assignment information and store data relating to payroll and compensation, this information stored is then used to support tax compliance process and other project based work. My role is to support Clients with their technical and functional issues and to work on their customized report/interface/script requests.

 

Roles & Responsibilities:

  • Responsible for understanding the business issues and data challenges of client's organization and industry.
  • Reviews and edits requirements, specifications, business processes and recommendations related to proposed solution.
  • Develops functional specifications and system design specifications for client engagements.
  • Ensures issues are identified, tracked, reported on and resolved in a timely manner.
  • Works with client personnel to identify required changes.
  • Communicates needed changes to development team.
  • Assists in enforcement of project deadlines and schedules.
  • Communicates and applies project standards.
  • Manages resources in accordance with project schedule.
  • Consistently delivers high-quality services to our clients.
  • Provide project and release support, including research, business analysis, test plan construction, test case construction, test execution, issue resolution and status reporting related to application changes.
  • Work with Tier-I/II support personnel to resolve client issues in a timely manner.
  • Assist client and internal support personnel with quality assurance initiatives.

Technologies :-  Oracle 10g, 11g,  Toad 9.53 and 10.6, SQL Developer, Putty, WinSCP, MS Office 2003/2007/2010, TFS, , FirstWave CRM, Service Now

Show More Show Less