Abhishek Kumar

Oaks, Pennsylvania, United States

adx6z7@r.postjobfree.com 215-***-**** linkedin.com/in/abhishek-kumar-99111217

Summary

I have 18 years of experience in IT industry presently as a Techno functional Consultant in BFSI domain. Recently completed Data Engineering from Massachusetts Institute of Technology.

My expertise in Handling team development and support applications using majorly Oracle Technologies and equipped with MySQL, Python, Docker, NoSQL and MongoDB. My proficiency in designing, coding, version controlling, client onboarding, interface development product configuration management and well versed with Agile methodology.

Worked in multiple istripe environment for multiple client’s different version support. As a BFSI domain veteran worked with wealth management banking, core banking, corporate banking and brokerage bank account.

Presently working with US, UK wealth management bank and US advisor.

Having a sound knowledge in PL/SQL, UNIX Shell scripting and Object-Oriented Programming. I actively involve myself to explore the latest technologies and learn new ventures to take my career to new heights.

Involved in MIS reporting and exposure of ETL tools and Business intelligence tools. Good exposure of Data modeling Data mining and Data warehousing. Critically involved in data migration projects and worked with various interface for collectively informative data reporting. Involved in understanding of Business Requirement and implementation and preparation of FSD, LLD and HLD and test cases. Exposed with Flex cube, Prime, Equation system good in Data mining and slicing.

Understand the business needs, gather business requirements, assess data requirements, and Project estimations

Create business, functional requirement documents, expertise in reverse engineering and sampling of data and analysis.

Formulate data sourcing strategy and make recommendations for process improvement areas

Translate complex data requests into clear, business-oriented communications

Create Data Requirement Specifications, Technical Specification documents and ETL map

Experience

Lead Datbase Analyst (BFSI Domain) Business event project Development and support

SEI

Mar 2017 - Present (6 years 4 months)

Working as a Technical Analyst in Platform delivery team of

SEI Investment Corporation. Involve in Business events change incorporation client-driven, Incident driven, Product support, Corporate Driven.

Requirement gathering, Analyzing, Design for customization point - workflow and integrate with other application. Business interaction understanding of business and providing Business IT solution Plan. Extensively involved in coding, implementation, development and deployment of code. Worked as a single player and leading a team depends on assignment and duration. Post production support for

application bug fixing and code deployment.Used SQL PL/SQL optimization technique to reduce the time for application performance.Data modelling Business mapping to technical document.

Team Lead

First Data Corporation

Nov 2014 - Mar 2017 (2 years 5 months)

•Understand the business needs, gather business requirements, and assess data requirements

•Create business and functional requirement documents

•Formulate data sourcing strategy and make recommendations for process improvement areas

•Translate complex data requests into clear, business-oriented communications

•Create Data Requirement Specifications, Technical Specification documents and ETL mapping specification documents

•Perform complex data analysis in an evolving data environment

•Identification of data specific issues and liaise with key technology partners in resolving them

•Working as technology developers in implementing the ETL, data controls and a quality portal .

•Experience in Business Process Analysis/consultation,RFI/RFP Creation, As-is Analysis,Business Requirement Gathering, Elicitation, Requirement Management and Communication, Solution Assessment and validation, Process Designing & re-engineering, Data Modelling, workflow creation, Resource Management, Metrics generation, Writing User Stories, UAT and Overseeing aspects of project life cycle, from Inception through delivery of the project within solution area. Use Business intelligence tools to create Ad-Hoc reports and understand complex relationships in large amounts of data.

Principal Lead (Quantitative Analytics Team (QAT) within Financial Crimes.AML)

JPMorgan Chase & Co.

Mar 2014 - Nov 2014 (9 months)

•Mantas Applications that monitor and report on suspected anti-money laundering activities along with screening activities of individuals and companies

•Disclosure of Interest applications supporting the position and regulatory reporting globally, taking into consideration jurisdictional regulatory requirements

•Trade Surveillance and Employee Compliance applications focused on the monitoring and surveillance of trading activities and employee activities in support of regulatory requirements

•Understand the business needs, gather business requirements, and assess data requirements

•We were moving data and replicating For Mantas Threshold setting .

•Formulate data sourcing strategy and make recommendations for process improvement areas

•Translate complex data requests into clear, business-oriented communications

•Create Data Requirement Specifications, Technical Specification documents and ETL mapping specification documents

•Perform complex data analysis in an evolving data environment

•Identification of data specific issues and liaise with key technology partners in resolving them

•Working with technology developers in implementing the ETL, data controls and a quality portal

•Solid understanding of Quality Assurance process and work with a QA team in developing and implementing a testing strategy.

Technology Consulatant Team lead

SEI

Jun 2011 - Mar 2014 (2 years 10 months)

Comprehensive database management and migration framework . Automation and integration of distributed system available on platform .

Working as Technical Analyst in IT Application development & Support team of

SEI Investment Banking Division. Involve in Tools and automation and Data migration for various ongoing projects.

Technical Analyst (Team Leader)

Technology:,PL/SQL,SQL,ORACLE. Front-end : D2K Forms and Report,Control M (Job Stream scheduling )

Backend: Oracle 11g Familiar with SQL Unix Shell script

Requirement gathering, Analyzing, Design for customization point - workflow and integrate with other application .Business interaction understanding of business and providing Business IT solution Plan .Extensively involved in coding,implementation, development and deployment of code. Worked as single player and team player depends on assignment and duration .Post production support for

application bug fixing and code deployment .Used SQL PL/SQL optimization technique to reduce time for application performance .Data modeling Business mapping to technical document .

Senior Consultant(Oracle Technology )

Commercial Bank

Dec 2009 - May 2011 (1 year 6 months)

Team Delegation,Team Management, Technical development and design review .

1.PCIDSS compliance of Oracle based application, 2.Automated tracking of CRDB loaders

3.Indus provisioning

4. Qatar central Bank reporting

Commercial Bank of Qatar Banking and financial services domain

Working as Oracle Consultant (Team Leader) in IT Application development & Support team of Commercial Bank of Qatar .Involve in support of Oracle base Application and Business Intelligence reporting MIS .

1.PCI DSS compliance is very critical project for bank as CBQ is the first bank in Qatar to follow PCIDSS norms As CRDB is central database and interacting with Card system and storing Card Information so comply with PCIDSS standard use SHA256 algorithm as there was no linking with Online and authorization system except Card number it was good experience to complete this challenging project.

2.As CRDB is central database and interacting with various system so for proper and timely data load is very important so to track data load and provided immediate solution in case of failure is mission critical so we developed email alert for all loader in case of failing in doing any critical job earlier it was manually done by the IT operators.

3.Indus provisioning project to provide arrears detail to vendor developed application in fixed length format as well other outgoing file related to customer information to interact with other vendor handled application for error tracking .

4.Qatar central bank data requirement for loans and various business critical data for auditing so development of interface to handle incoming and outgoing csv file.

Technology: D2K Forms and Report,PL/SQL,SQL,ORACLE. Front-end : D2K Forms and Report

Backend: Oracle 10g, Oracle Discoverer,winscp,putty, Unix Shell Scripting for compilation of program unit and forms and scheduling job

Coding to support PCIDSS compliant for product .In this worked I was extensively involved in coding and implementation .

Technical Consultant

Oracle

Sep 2008 - Nov 2009 (1 year 3 months)

Oracle FLEXCUBE Citibank Loan Syndication version 7.4 is being implemented for Global Wealth Management (GWM), Citibank, USA. Oracle FLEXCUBE is replacing GWM’s present system called ‘Hogan’. There are systems that are interfacing with Hogan which have to interface with Oracle FLEXCUBE. For this development of interface. This can integrate with Oracle Flexcube with different systems in term of outgoing and incoming flat files.

•Understand the business needs, gather business requirements, and assess data requirements

•Create business and functional requirement documents

•Formulate data sourcing strategy and make recommendations for process improvement areas

•Translate complex data requests into clear, business-oriented communications

•Create Data Requirement Specifications, Technical Specification documents, and ETL mapping specification documents

•Perform complex data analysis in an evolving data environment

•Identification of data specific issues and liaise with key technology partners in resolving them

•Working as technology developers in implementing the ETL, data controls, and a quality portal .

Software Engineer

3i Infotech Ltd.

Mar 2007 - Sep 2008 (1 year 7 months)

•Understand the business needs, gather business requirements, and assess data requirements

•Create business and functional requirement documents

•Formulate data sourcing strategy and make recommendations for process improvement areas

10.5 version to 10.6 version with Linux and Solaris Flavours of General Ledger Module Of ERP product ORION./ FBT (Fringe Benefit Tax)

Base Product Enhancement 3i Infotech Limited ERP General Ledger Module

August-2007 – December 2007

General Ledger Module deals with automation of complete Finance activities followed in an organization.

The major asset about this application is that it gives Bi-lingual support i.e. in English as well as in Other Language.

It provides a complete automated approval flow for all key transactions. It also provides the integration with other products Of 3i Infotech .

Developer / Team Leader Technology: D2K Forms and Report. Front-end : Asp.Net, D2K

Backend: Oracle9i, Toad as the oracle tool, Unix Shell Scripting for compilation of program unit and forms and scheduling job.

Involved in Preparation of technical specifications from the functional specifications received from the functional team. Involved in Development of Forms including Masters and Transactions. Involved in development of Reports as per requirements. Customization of base forms and reports. Developed triggers using PL/SQL to handle various events. Analyzed and designed the various stored procedures for the application. Developed SQL queries, according to the client requirements. Testing of the

modules. Maintenance of the complete application. Support to the Load testing team. Bug Fixing Activities and customer call consolidation. Customization of base forms and reports. Developed triggers using PL/SQL to handle various events. Testing & Maintenance of the complete application. Support to the Load testing team & the customer. Handling DAPG activities and support as QC Leader

Software Engineer ERP system

Nippon Data Systems Ltd.

Aug 2005 - Mar 2007 (1 year 8 months)

•Understand the business needs, gather business requirements, and assess data requirements

•Create business and functional requirement documents

•Formulate data sourcing strategy and make recommendations for process improvement areas

•Translate complex data requests into clear, business-oriented communications

•Create Data Requirement Specifications, Technical Specification documents and ETL mapping specification documents

•Perform complex data analysis in an evolving data environment

•Identification of data specific issues and liaise with key technology partners in resolving them Implementation and support of NEWTON ERP all modules Stores, Purchase, Personnel, Sales, System Maintenance, Production, Quality Control, Finance

Software Developer/Implementer/Client Interaction/Team Leader Technology: D2K,PL/SQL,SQL platform.

Front-end : D2K forms and Report Backend: Oracle 9i

Reports: D2K,Unix Shell scripting

Involved in Preparation of technical specifications from the functional specifications received from the functional team. Customization and bug fixing

Involved in Development of Forms including Masters and Transactions. Involved in development of Reports as per requirements.

Developed packages, procedures and functions. Testing of the modules.

Client Interaction.

User Training

Education

Massachusetts Institute of Technology

Data engineering, Computer Science

Mar 2021 - Jul 2022

University of Rajasthan

B.E. Computer Science and Engineering, Computers

2001 - 2005

Computer Science

Ministry Of Information and Communication Technology Government of India

Summer internship, SACFA

2004 - 2004

SACFA Project

Hindustan Aeronautics Limited Government Of India

Summer internship In Aviation and Navigation department, Software integration Aerospace

2003 - 2003

Internship

Skills

Agile & Waterfall Methodologies • Cost Planning • Offshoring • Oracle • Oracle PL/SQL Development

•Oracle Forms • PL/SQL • Client Relations • Project Management • MIS Reporting

Contact this candidate