Ramkumar Ranganathan Email & Phone Number

Boston, MA, US

New York, NY, US

• Participating in the Data Stewardship function across the enterprise to uncover the definitions, ownership, and key characteristics of enterprise data.
• Develop and maintain data flow lineages & terms for various applications.
• Assist in setting formal standards, policies and processes regarding data stewardship, governance and management.
• Ensure there is a consistent standard data glossary and data definition for each data subject.
• Participate in best practices in regards to the data governance toolset.
• Work with the business teams & notify them the behavior that is leading to quality issues.

Boston, Massachusetts, US

• Gathering business requirements and capturing them to BRD’s /SRF’s.
• Working & updating on the problem statement and business requirement overview by understanding the business processes.
• Will go through the existing code & work with the business teams to understand the logic behind the current process and write SQL queries to pull various data in Oracle SQL Developer for testing.
• Preparing Test plans /scenarios & Use cases and assist the testing team and do the regression test.
• Worked with the Architect to finalize the architecture design.
• Creating requirements to develop new /modify macro process in MS Access for various functions like offering loans and re-book an original loan for a merger corporate action, to input and create recall notifications.

Round Rock, Texas, US

• Gathered business requirements and capturing them to User stories with the acceptance criteria’s and creating functional design documents by following Agile methodology.
• Documenting the User stories & acceptance criteria’s in the Agile tool “Version-One”.
• Formulated and executed process flows and product backlog.
• Working on creating Functional Design documents for various products of EMC Corp.
• Preparing process flows using MS Visio for the respective User stories as a part of Functional details
• Preparing Use cases & test scripts for various projects in ELMS project

Bangalore, Karnataka, IN

• Alternative Investments – Private Equity & Brainware (Jan 2013 – Feb 2015)
• Gained comprehensive understanding of client operations, processes, and business objectives and utilize that knowledge on engagements.
• Supervising the Alternative Investments IT team to provide round the clock IT support and maintenance for 2 proprietary products of the Bank dealing with 200+ Private Equity and Real Estate Investments made by large.
• Inducted the offshore team of 3 people from India into the project to support the application 24 hrs. and provide the issue resolutions in shortest possible time.
• Analyzed and tested the various customization and enhancements sought within the application to meet client needs and delivering ~100% bug free releases.
• Working on applications Interchange (VCx), MyStateStreet.com & Vision Explorer.

Bangalore, Karnataka, IN

• Project: Street FX Client On boarding, State Street Global Markets (Jan 2012 – Dec 2012) The Client On-Boarding team facilitates the integration of institutional clients into the State Street's framework and.
• Gathered requirements through interviews and meetings with product owners and business users to arrive at the interface functional design for the engagement
• Documented Data and Process flows using MS Visio.
• Coordinated and participated in business requirements walkthrough and reviews with peers and the client team.
• Authored the FRD document for all data sources/feeds and target systems that need to be mapped.
• Involved in static data management and decomposing report requirements for Futures Commission Merchant (FCM) module for setup and testing.

Bangalore, Karnataka, IN

• Project: Metrics Automation Platform (MAP) - Citi Bank (Jan 2010 – Dec 2011) This project was focused on various client Dashboards to be automated from MS Excel, PPT, PDF, Word doc & other formats of data to a Web portal
• Automation of dashboards of the entire Investment Banking operations (Capital Markets)
• Training new employee’s & preparing training materials
• Preparing process maps in MS Visio & FMEA for the automation
• Designing user interfaces and preparing functional specifications
• Preparing test scripts / test cases for all the processes

Bangalore, Karnataka, IN

• Project: National Claims Center (NCC) - Sears (Jan 2008 - Dec 2009)Claims is the backbone for Sears which is the finance & accounting division of sales happening in Sears. NCC takes care on filing the claims to the.
• Migrated the finance division of “Retail Giant” from Dallas, TX - USA.
• Have experience in doing excellent documentation on business requirements
• Expertise in System design and development required for business process
• Vast Experience in Project and Operations Management
• Make sure all the claims are submitted to the respective vendors on time & follow-up for the payments.

New York, NY, US

• Project: Client Data Group (CDG)
• Performed treasury and private banking activities relating to client and account maintenance, FX maintenance & static data updates on the various operational tables in Globus, FAS & SBS.
• Update Bank Holidays for a year across different systems and locations.
• Recommended valid controls and enhancements are in place to mitigate system deficiencies.
• Actively supported in migrating Singapore Op-table (SBS system) maintenance activities.
• FX Rates, Static Data, Holidays & CCY setup done in Globus.

New York, New York, US

• Project: Citi Bank North America (CBNA)
• Worked in the Pilot batch of CBNA which are Check collections, Mortgage release and Debit Cards
• Worked in US Mortgage for 2 years & 6 months which includes all the 50 states in the USA
• Liaise with the clients for all Checks related queries and for new process updates.

Master'S, Business Administration

Master, Information Technology

Bachelor, Computer Science