Senior Database Developer @ • Designed and built new modules for the application as well as implemented complex profitability models to price loans for various clients • Setup version control, built generic unit tests and implemented Release scripts to ease the deployment process • Cleaned up and rewrote complex database procedures and functions to reduce maintenance costs and improve performance • Improved the weekly data refreshes by building procedures to flexibly copy client’s raw data tables to different environments with inbuilt monitoring and checks Project experience: Pricetek Loans (Lead Developer, Oracle PL/SQL, Shell Scripting, XML, Technical Analysis) • Built Performance Dashboard and Portfolio Analytics modules for the clients to track their pilots and rate the pilots’ performance based on Confidence Intervals derived from elasticity curves against the original forecast • Implemented complex Profitability Models for clients to calculate profitability metrics and the floor rate (rate set per cell to breakeven) using Newton’s Method • Setup and manage version control, release scripts and code promotions to different clients and environments, while optimizing queries across the platform From March 2015 to Present (10 months) Database Developer @ From December 2013 to March 2015 (1 year 4 months) Assistant Vice President - Programmer professional Markets @ • Led the Business Analysis to integrate Asia Pacific payment processing for commission management into the global system • Responsible for internal and external client requirements gathering and translating them into business and technical design documents using agile methods • Handle client onboarding, work with the business teams to maintain data and run reports for continued business operations • Work with external aggregators to set up FTP channels and generate reports to reconcile trade data Project experience: Firmview for APR (Lead Business Analyst, Oracle PL / SQL) • Worked with the Asia Pacific, Americas and EMEA teams to gather Business and Technical requirements • Consolidated the Asia Pacific soft dollar payment processing into the global system which decommissioned hardware thereby resulting in cost savings • Coordinated and lead multiple stake holder meetings on a weekly basis From January 2013 to December 2013 (1 year) Apps Program Analyst @ • Generated reports for 2012 1099 tax reporting for vendors, automated the process and consolidated data from multiple systems into a single database • Managed, administered and configured proprietary applications and third party solutions for application servers • Combined financial, business and technical knowledge to develop comprehensive test strategies for internally developed commission management systems • Built applications to support payment processing, vendor/client maintenance and commission management for the soft dollar business (Equities and Options) Project experience: Commission Manager -Wall Street on Demand, Markit (Business / Technical Analysis, Oracle PL/SQL, C#, XML) • Represented BAML on technical and business conferences with Markit with multiple Financial Institutions participating • Built trade, vendor and payment feeds to send data to Markit for reconciliation and built generic tests to ensure accuracy • Gathered business requirements, on boarded clients, analyzed data and supported trade reconciliation Bacchus and NOX (Business &Technical Analysis, Oracle PL / SQL, XML, JIL (Job interface Language), ITRS, Autosys) • Merged AMRS, EMEA and PACRM systems for soft dollar trade reporting and payment generation into one global application • Designed database objects, mapped data and created feeds to transfer data between global systems • Consolidated statement generation and designed the logic for chronological and amended trade • Worked on business requirement documents and also technically implemented account deficit processing for payments made to vendors • Designed logic and mapped fields to direct domestic and international invoices to appropriate internal and external payment processing systems From July 2010 to December 2012 (2 years 6 months) Part-Time Applications Developer @ Decision Support - Data warehouse at the University Of Illinois From December 2009 to May 2010 (6 months) Programmer/Web Developer @ Office of the Vice Chancellor for Research From August 2009 to May 2010 (10 months) Web/Applications Intern @ From May 2009 to August 2009 (4 months) Noida Area, India

BS, Computer Engineering @ University of Illinois at Urbana-Champaign Rohit Prakash is skilled in: Technical Analysis, Oracle PL/SQL Development, Business Analysis, XML, XSLT, .NET, Requirements Gathering, C++, Database Design, SQL, Data Warehousing, VBA, PL/SQL, Java, Databases, C, Project Management