This requirement is to impose Withholding tax amount on the dividend amount arising in certain derivative transactions over US equities when the dividend amount are paid to non-US citizens.

This is an automated solution that would assist in the process of updating data in GA IHR (Global Advantage International Human Resources) to reduce work time and to increase efficiencies. Created HSBC GHRS System is intended to contain the most up to date live assignee assignments data. Developed GHRS Interface which updates GA IHR with new assignee assignments being planned (non-live) and after the new assignments are approved and finalized assignee assignments details would be updated in HSBC GHRS and flow down to GA IHR.

Deloitte Tax LLP provides Global Mobility Services to lot of Multi-National Companies worldwide assisting them in to be compliant with multiple countries compliance laws. These services include Assignee Management, Payroll administration, International HR and Year-end data collection activities etc. This project is about migration of Reports from Crystal reports technology to MS SQL Server Reporting Services (SSRS)

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

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

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

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