Abhitosh Kumar

Company overview:

• This is a core banking product which is mainly focused on US banking. The application can cater to various banking needs for a Financial Institution (Banks/Credit Unions). The application can handle the life cycle of Loans, Saving Accounts, Retirement Accounts etc.
• Front end of the product is designed in .NET and the core banking logic is written in Oracle Database. SQR is used as a reporting tool.

Job Role:

• Involved in Analysis, Design, Development, Unit Testing and Delivery .
• Responsible for end-to-end development for any enhancement or new functionality.
• Improved the performance of the application by rewriting the complex SQL queries.
• Worked on Oracle database 11g/12c and PL/SQL. Developing objects like tables, views, Sequences, Synonyms, Stored procedures, function, packages, Cursors and Ref Cursors.
• Involved in modifying various existing code and creating new code for the application as per new business changes. Involved in Unit and system testing.
• Worked on SQR development which involves modifying / writing of SQL scripts.
• Involved in testing, implementation and documentation.
• Responsible for preparing user manual docs for end users.
• Held regular Brainstorming sessions with teammates.
• Optimized customer experience by delivering superior services and effectively troubleshooting issues.
• Developed effective improvement plans in alignment with goals and specifications.

Company Overview:

• Morgan Stanley Wealth Management is the wealth management division of the investment bank Morgan Stanley. The division serves individuals, families, businesses and institutions. Morgan Stanley Wealth Management offers a range of services, including wealth planning, investment management, Estate planning, IRAs, and other retirement solutions. It offers a variety of account programs, each with Different account minimums and for varying levels of investment experience. Morgan Stanley's Global Sports & Entertainment division is focused on serving sports and entertainment professionals. Morgan Stanley Wealth Management's search feature also allows you to search for an advisor by name or to find Nearby branches. Wealth Management Technology is responsible for the design, development, delivery, And support of the technical solutions behind the products and services used by the Morgan Stanley Wealth Management Business.

Job Role:

• Wealth Management Technology is responsible for the design, development, delivery, and support of the technical solutions behind the products and services used by the Morgan Stanley Wealth Management Business.
• We work closely with our operations partners on requirements for projects.
• Development is performed using an agile methodology, which is based on scrum.
• Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
• Design and build reporting layer from different data sources.
• Writing packages, procedures, functions, triggers (SQL, PL/SQL) etc. to customize the software to satisfy their needs.
• Database and ETL development, including stored procedures, queries, performance tuning etc., using python, SQL
• Morgan Stanley Wealth Management is the wealth management division of the investment bank Morgan Stanley. The division serves individuals, families, businesses and institutions. Morgan Stanley Wealth Management offers a range of services, including wealth planning, investment management, Estate planning, IRAs, and other retirement solutions. It offers a variety of account programs, each with Different account minimums and for varying levels of investment experience. Morgan Stanley's Global Sports & Entertainment division is focused on serving sports and entertainment professionals. Morgan Stanley Wealth Management's search feature also allows you to search for an advisor by name or to find Nearby branches. Wealth Management Technology is responsible for the design, development, delivery, And support of the technical solutions behind the products and services used by the Morgan Stanley Wealth Management Business.
• Technology Used: Oracle SQL Developer, Toad, Oracle 12c (Oracle 12c Database Server), SQL, PL/SQL, Teradata, Python.

Company Overview:

• The Online Integrated CoalNet System was designed to take care of the entire functional process of Coal India, This system constitutes of fourteen modules some of which are Personnel Information System, Payroll System, Finance Information System, Materials Management System, Sales and Marketing, Production System etc.

Job Role:

• My responsibility in CCL, to implement the Coal Net software there along with a team. This includes first deploying the CoalNet software in Oracle9i Application Server.
• Interacting with client understating their data, asking for data in the format as required in Coal Net, verifying those data, formatting data and then loading them into our database.
• Writing packages, procedures, functions, triggers (SQL, PL/SQL) etc. to customize the software to satisfy their needs.
• Designing reports (Oracle 6i and 9i) as per user's need.
• The aim of the module development is to calculate the entire CCL Employees (Executive & Non Executive) salary & generate the pay slip.
• Developed Oracle Report for the user interface. (Attendance, Offline ,Salary Related Checklist & Check sheet , payslip , classification(PF ),monthly tax, yearly vv-yy statement , LIC etc.)
• The Online Integrated CoalNet System was designed to take care of the entire functional process of Coal India, This system constitutes of fourteen modules some of which are Personnel Information System, Payroll System, Finance Information System, Materials Management System, Sales and Marketing, Production System etc.
• Technology Used: Oracle SQL Developer, Toad, Oracle 12c (Oracle 12c Database Server), Oracle 12c Application Server (OC4J), SQL, PL/SQL, Oracle Reports (6i/10g), Java, JSP, JavaScript, HTML.
• Updated old code bases to modern development standards, improving functionality.
• Participated in software field testing to verify performance of developed projects.

Company Overview:

• Online Book Store is an online web application where the customer can purchase books online. The Internet has become a major resource in modern business, thus Online Book Shopping has gained significance not only from the Entrepreneurs Point of View but also from the Customer point of view.

Job Role:

• Understanding the requirement specification for the product.
• Developing the Java project.
• Deploying the Project in real life.
• Guides, trains, and assist other team members at lower levels on technical issues. Help them understanding by proper knowledge transfer sessions and team building activities.
• Online Book Store is an online web application where the customer can purchase books online. The Internet has become a major resource in modern business, thus Online Book Shopping has gained significance not only from the Entrepreneurs Point of View but also from the Customer point of view.
• Technology Used: By using JSP/Servlet created a website for online bookstore. It is connected to databases with the help of JDBC. CSS/HTML is used for frontend presentation.
• Translated customer requirements into written use cases.
• Built databases and table structures for web applications.
• Designed and implemented scalable applications for data extraction and analysis.
• Coordinated deployments of new software, feature updates and fixes.

• IBM -Career Education Program
• GPA: 70

GPA: 65.5

• Final Grade: [65.5]%

GPA: 56.6

• Final Grade: [56.6]%

GPA: 58.6

• Final Grade: [58.6]%