Arshdeep Kapoor

Arshdeep Kapoor

United States
6K followers 500+ connections

Join to view profile

About

Visa Type :- Permanent Resident / Green Card Holder

Dedicated Data/Quality…

Activity

Join now to see all activity

Experience

  • Google Graphic

    Google

    Sunnyvale, California, United States

  • -

  • -

  • -

    San Francisco Bay Area

  • -

    Greater Atlanta Area

  • -

    Greater Atlanta Area

  • -

    Chennai Area, India

  • -

    Chennai Area, India

Education

Licenses & Certifications

Volunteer Experience

  • Volunteer

    Sneham

    - 3 years 4 months

    Children

    The Foundation focuses on four key areas:
    Social rehabilitation and rural uplift
    Learning and education
    Healthcare
    Arts and culture

Courses

  • Advanced JAVA

    -

  • C

    -

  • C++

    -

  • CORE JAVA

    -

  • DB2

    -

  • Data Programming for Analytics

    -

  • Enterprise Resource Planning Systems: Implementation and Management

    -

  • Fundamentals of Database Management Systems

    -

  • IT Infrastructure for Big Data

    -

  • Information Technology Project Management

    -

  • Mainframes( COBOL, CICS, VSAM)

    -

  • Managing Big Data for Analytics

    -

  • Process Innovation

    -

  • Python

    -

  • R Programming

    -

  • RDBMS

    -

  • Security and Privacy of Information and Information Systems

    -

  • Unstructured Data Management

    -

Projects

  • Fraud Management; Royal Bank of Scotland

    -

    Royal Bank of Scotland (RBS) is leading bank in UK. It has around 700 branches, mainly in Scotland though there are branches in many larger towns and cities throughout England and Wales.

    Fraud Management is the transfer of some accounts to new branches of a new bank. It will process and check which branches to keep and report if any duplicity.

    The application also allows Supervisors/Managers to track the workload status of the new bank.

    Delivered as a Team member to Extract…

    Royal Bank of Scotland (RBS) is leading bank in UK. It has around 700 branches, mainly in Scotland though there are branches in many larger towns and cities throughout England and Wales.

    Fraud Management is the transfer of some accounts to new branches of a new bank. It will process and check which branches to keep and report if any duplicity.

    The application also allows Supervisors/Managers to track the workload status of the new bank.

    Delivered as a Team member to Extract the millions of records to provide the proper solution
    Designed a project to eliminate duplicity.
    Transformed the extracted data with the help of Python and R to review the filters and load them accordingly in the new bank system.
    Transferred knowledge of DB2, VSAM, SQL, Python and R to the new joined members of the team.
    Lead the team by taking the responsibility of assigning the tasks and updating the leave and work tracker for it.
    Discussed continuously with clients over the phone for Inter-Company Cooperation for several group interaction and helping them in providing better solutions to RBS.

  • Information Centre; SYSCO; USA

    -

    Information Centre is a project which helps and supports the clients who are facing issues in checking their account for more supply and inventory

    Delivered as a Team member to provide better solutions to reduce counts in BMC remedy.
    Automated the reporting on SQL, to run queries for proper delivery of reports.
    Enhanced the code in SQL for better performance for clients.
    Analyzed the files of records in Microsoft excel with the pivot tables and solver with VLOOKUP…

    Information Centre is a project which helps and supports the clients who are facing issues in checking their account for more supply and inventory

    Delivered as a Team member to provide better solutions to reduce counts in BMC remedy.
    Automated the reporting on SQL, to run queries for proper delivery of reports.
    Enhanced the code in SQL for better performance for clients.
    Analyzed the files of records in Microsoft excel with the pivot tables and solver with VLOOKUP.
    Demonstrated strong technical aptitude and understanding of how technologies impact delivery.
    Generated Ability to work effectively in a fast-paced, sometimes stressful environment as working in shifts for coordination with clients in the different time-zone.

  • TSS modernization BNSF, USA

    -

    BNSF is one of the largest freight railroad networks in North America. BNSF trains traveled over 169 million miles in 2010, more than any other North American railroad

    TSS (Transport Service System) modernization is analyzing the codes written and provide to the developers for the new phase.

    Responsibilities:

    Analyzed the written codes and constructed the BRE (Business Rule Explanation) and DATAFLOWS for further development of new codes
    Delivered the solution in Agile…

    BNSF is one of the largest freight railroad networks in North America. BNSF trains traveled over 169 million miles in 2010, more than any other North American railroad

    TSS (Transport Service System) modernization is analyzing the codes written and provide to the developers for the new phase.

    Responsibilities:

    Analyzed the written codes and constructed the BRE (Business Rule Explanation) and DATAFLOWS for further development of new codes
    Delivered the solution in Agile methodology by consulting the clients personally for completing on SLA.
    Constructed the visualization for the on-site team members with Microsoft Visio.

  • Large Currency Reporting; Bank of America, USA

    -

    Bank of America is an American multinational banking and financial services corporation. It is the second-largest bank holding company in the United States of America.

    Large currency reporting (LCR) is used to maintain and process transaction information to create financially and tax reports. It resolves tax related author Suspects and process to income tax department of United States.

    This system handles the transactions above than $10000.

    System also captures account…

    Bank of America is an American multinational banking and financial services corporation. It is the second-largest bank holding company in the United States of America.

    Large currency reporting (LCR) is used to maintain and process transaction information to create financially and tax reports. It resolves tax related author Suspects and process to income tax department of United States.

    This system handles the transactions above than $10000.

    System also captures account details and tracks the transactions made by the account in a different account from millions of records with the help of Mainframe like DB2, VSAM, CICS.

    Responsibility :-

    Gathering and analysis of requirements and Coding according to the specifications of Client.
    Involved in Enhancement and removing bugs of few programs with CICS, COBOL & DB2.
    Co-ordination with onsite co-coordinator for clarifications, Implementing the approved changes, Unit and Integration testing.
    Optimized COBOL and DB2 Programs to execute faster.
    Delivered on systems with high transaction volume of Data including accounts holder while working for Bank of America, generated Strong analytical skills, quality process, ability to learn new technology, good hands-on experience in relational databases
    Implemented code modifications and enhancement in MAINFRAMES to fixing the Job abends in timely and valuable manner and keeping the coding and documentation standards.

Honors & Awards

  • Best Team Of The Quarter

    Infosys Limited

    Awarded best team of the quarter for BRE implementation and DATAFLOWS.

  • Participated in CIRCUITRON, organized by IIT Roorkee.

    -

  • Won The Robotics event organized by vedrobotics.

    -

  • Stood runner-up in interdepartmental Badminton tournament.

    -

Test Scores

  • TOEFL

    Score: 91

  • GRE

    Score: 321

Languages

  • English

    Full professional proficiency

  • Hindi

    Full professional proficiency

  • Punjabi

    Full professional proficiency

Organizations

  • Data Science Society

    -

    - Present

  • TAG - Technology Association of Georgia

    -

    - Present

More activity by Arshdeep

View Arshdeep’s full profile

  • See who you know in common
  • Get introduced
  • Contact Arshdeep directly
Join to view full profile

Other similar profiles

Explore more posts

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More

Others named Arshdeep Kapoor

4 others named Arshdeep Kapoor are on LinkedIn

See others named Arshdeep Kapoor

Add new skills with these courses

See all courses