girl looking into her desktop
Back to search results

Assistant Manager

Gurugram, , India

Job Description:

Overview (Bank overview, GBS India overview, Function Overview)*

Bank of America is one of the world’s leading financial institutions, serving individual consumers, small and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services.

We are committed to attracting and retaining top talent across the globe to ensure our continued success. Along with taking care of our customers, we want to be the best place for people to work and aim at creating a work environment where all employees have the opportunity to achieve their goals.

We are a part of the Global Business Services which delivers technology and operations capabilities to all Bank of America lines of business (LOB) and enterprise functions.

Our employees help our customers and clients at every stage of their financial lives, helping them connect to what matters most. This purpose defines and unites us. Every day, we are focused on delivering value, convenience, expertise and innovation for individuals, businesses and institutional investors we serve worldwide.

* BA Continuum is a nonbank subsidiary of Bank of America, part of Global Business Services in the bank.

Process Overview*

The FAKC (Finance and Accounting Knowledge Center) was set up in 2007 as a part of the CFO Global Delivery strategy to provide offshore delivery to Line of Business and Enterprise Finance functions. The capabilities hosted include Accounts Payable, General Accounting & Reconciliations, Management Reporting & Analysis, Research & Analytics, Financial Transaction Processing, Finance Systems Support and Supply Chain Management. Over the years, the scope of FAKC has been expanded to include operations for other enterprise control functions like Human Resources and Risk and Compliance.

Job Description*

The role includes working in close partnership with onshore technical team and reporting leads. The scope includes working on complex SQL queries as part of change requests created by business executive(s). The scope also includes tuning existing oracle stored procedures, support tech partners & MicroStrategy developers, understanding vendor system flow between various systems, monitor daily loads, work on process improvisation ideas, FPP processing, team support and back up other team members.

Responsibilities*

  • Work on change requests by creating/modifying stored procedures using complex SQL queries
  • Work on adhoc requests related to Spend, Risk, Diversity and Contracts etc.
  • Gathering change request requirements and coordinate with onshore team
  • Regression testing and troubleshooting of data issues reported by end users
  • Extract data from VIPR report builders for reporting and data validation.

Requirements*

Education* - Any bachelor’s degree

Certifications If Any

Experience Range*

5 to 8 Years

Foundational skills*

  • Oracle exadata experience - proficient in writing complex SQL queries and PL/SQL code including sub queries, hints, CTE, correlated/non-correlated sub queries, dynamic query etc.
  • Good knowledge of troubleshooting and optimizing SQL queries
  • Knowledge of data warehousing concepts e.g. Star schema, snowflake schema, slowly changing dimension
  • Understanding business requirement and translating them to PL/SQL queries
  • Good knowledge of advance topics such as transaction handling, exception handling, reading explain plan etc.
  • Knowledge of different applications used within Global Procurement – ARIBA, VRPM, BICS, VIPR etc.
  • Strong data analysis and problem solving skills with the ability to recommend solutions
  • Understanding of different phases of Global Procurement – Plan, Source, and Manage/Govern is a plus
  • Experience in MicroStrategy Web and Alteryx is a plus

Desired skills

Strong analytical skills and ability to work autonomously

Work Timings*

11:30 AM to 8:30 PM

Job Location*

Gurugram

Job Band:

H7

Shift: 

Hours Per Week:

45

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Overview (Bank overview, GBS India overview, Function Overview)*

Bank of America is one of the world’s leading financial institutions, serving individual consumers, small and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services.

We are committed to attracting and retaining top talent across the globe to ensure our continued success. Along with taking care of our customers, we want to be the best place for people to work and aim at creating a work environment where all employees have the opportunity to achieve their goals.

We are a part of the Global Business Services which delivers technology and operations capabilities to all Bank of America lines of business (LOB) and enterprise functions.

Our employees help our customers and clients at every stage of their financial lives, helping them connect to what matters most. This purpose defines and unites us. Every day, we are focused on delivering value, convenience, expertise and innovation for individuals, businesses and institutional investors we serve worldwide.

* BA Continuum is a nonbank subsidiary of Bank of America, part of Global Business Services in the bank.

Process Overview*

The FAKC (Finance and Accounting Knowledge Center) was set up in 2007 as a part of the CFO Global Delivery strategy to provide offshore delivery to Line of Business and Enterprise Finance functions. The capabilities hosted include Accounts Payable, General Accounting & Reconciliations, Management Reporting & Analysis, Research & Analytics, Financial Transaction Processing, Finance Systems Support and Supply Chain Management. Over the years, the scope of FAKC has been expanded to include operations for other enterprise control functions like Human Resources and Risk and Compliance.

Job Description*

The role includes working in close partnership with onshore technical team and reporting leads. The scope includes working on complex SQL queries as part of change requests created by business executive(s). The scope also includes tuning existing oracle stored procedures, support tech partners & MicroStrategy developers, understanding vendor system flow between various systems, monitor daily loads, work on process improvisation ideas, FPP processing, team support and back up other team members.

Responsibilities*

  • Work on change requests by creating/modifying stored procedures using complex SQL queries
  • Work on adhoc requests related to Spend, Risk, Diversity and Contracts etc.
  • Gathering change request requirements and coordinate with onshore team
  • Regression testing and troubleshooting of data issues reported by end users
  • Extract data from VIPR report builders for reporting and data validation.

Requirements*

Education* - Any bachelor’s degree

Certifications If Any

Experience Range*

5 to 8 Years

Foundational skills*

  • Oracle exadata experience - proficient in writing complex SQL queries and PL/SQL code including sub queries, hints, CTE, correlated/non-correlated sub queries, dynamic query etc.
  • Good knowledge of troubleshooting and optimizing SQL queries
  • Knowledge of data warehousing concepts e.g. Star schema, snowflake schema, slowly changing dimension
  • Understanding business requirement and translating them to PL/SQL queries
  • Good knowledge of advance topics such as transaction handling, exception handling, reading explain plan etc.
  • Knowledge of different applications used within Global Procurement – ARIBA, VRPM, BICS, VIPR etc.
  • Strong data analysis and problem solving skills with the ability to recommend solutions
  • Understanding of different phases of Global Procurement – Plan, Source, and Manage/Govern is a plus
  • Experience in MicroStrategy Web and Alteryx is a plus

Desired skills

Strong analytical skills and ability to work autonomously

Work Timings*

11:30 AM to 8:30 PM

Job Location*

Gurugram

Learn more about this role

Full time

JR-21046475

Band: H7

Manages People:

Manager:

Talent Acquisition Contact:

Shweta Madaan

Referral Bonus:

0