Ramkumar Ranganathan Email & Phone Number

Foxborough, Ma, Us

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.• Create metrics to measure data quality targets and conduct policy reviews to ensure procedures and metrics are effective.• Assess business needs and capabilities and interpret results; provide high value and impactful solutions to business opportunities and/or challenges.• Work with the Data Quality team to review results of data profiling. • Relate the quality issues to process analysis and help to propose changes to policies and procedures that will minimize risk of bad data and to promote the accuracy, validity, reliability, timeliness, relevance and completeness.• Update the Information Governance Catalog (IGC) regularly with all the business Terms & Lineages.• Create /edit the IGC queries based on the reports requirement.• Create rules & code them using the Information Analyzer.

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, import the Equilend approvals, rejections, evaluate the data and create a group/broker un-restrict list, etc.• Prepare project estimates & roadmaps and work based on the priority.• Preparing various top management reports and presentations.• Test & verify all requirements in DML Mainframe application. • Writing & Executing SQL queries in Oracle SQL to ensure a successful Production checkout.• Having expertise in building the regulatory Volcker automation project with a very detailed User Interface (UI) web portal which will ensure if the fund is covered under the Volcker rule• Worked on creating Functional Design documents to implement a Database & jBPM /UI tool for the Volcker Office & all business teams (GM, GT, etc).• Worked with Product Owner on all the Backlog refinement, iteration planning & release planning based on the business priority.• Grooming the stories during the pre-planning session for the upcoming iterations.• Prepared process flows using MS Visio for the respective User stories as a part of Functional details to develop the Volcker UI for Volcker Funds DB.• Pull data from Oracle DB through SQL queries and complete testing & reconcile.

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• Working & updating on the problem statement and business requirement overview by understanding the business processes.• Participating on various discussions / meetings to gather requirements and acquire solutions• Working on the user interface mockup designs /forms while preparing the user stories & all functional documents.• Having regular meetings with the team /business to ensure there will be no obstacles• Worked on writing the pre-requisites for the products in ELMS.

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 funds.• 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.• Reviewed operational, financial, and technology processes to provide management with an assessment of overall effectiveness and efficiency of processes and risks, as it pertains to IT governance and internal controls.• Conducting Training sessions for business users to walk through of this new web based application for generating the client reports as per the requirements.• Delivering the timely daily and weekly status to senior management apprising them of ongoing activities, reports in progress and issues, if any.• Brainware Distiller Designer enables you to customize the automatic processing of incoming documents, where the document classes are relevant in an enterprise as well as which information is to be extracted from the classified documents.• Batches that cannot be automatically processed in their entirety by Brainware Distiller Runtime Server are forwarded to the quality assurance application Brainware Distiller Verifier for manual correction.

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 product-offerings like Street FX, Equities, Futures and Securities Lending, including analysis of client requirements, networking and connectivity, configuration and static data management, certification testing, and production go-live.• 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.• Extensively written and as well as reviewed SQL queries and procedures for client specific reports.• Acted as project coordinator for a securities lending report workflow automation project through MS SharePoint 2010 from preparing a project plan till delivery.• Contributed and assisted in product demos, knowledge transfers and Tier 2 support to the business.

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• Various types of testing performed (Regression, White/Black box, System/Software performance testing’s)• Conduct and facilitate workshops with business owners and users to gather business requirements • Analyze existing dashboard templates, files and formats to summarize KPI being measured, their formulas, thresholds etc.• Draft the BRD (Business Requirement Document) from scratch in a specified format to facilitate IT development • Performing GAP analysis & following the Systems Development Life Cycle (SDLC)• Measuring and tracking offshore vendor performance across multiple business areas• Preparing high end reports (PPT & excel) for the client Top management• Training new employee’s & preparing training materials

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 respective consumer, insurance company or any other 3rd party.• 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.• Prepared the process maps for all the new processes in MS Visio (both AS-IS & TO-BE).• Prepared the FMEA (Failure Mode Effect Analysis) for all the processes.• Prepared training materials for the new employee’s & trained.Project: Cash Reconciliation (APAC) – Credit Suisse (Sep 2007 - Dec 2007)• In a part of Reconciliation project migration from Credit Suisse bank, Singapore to Wipro, Pune, India • Matching and tagging of items to the concerned department.• Prepared process manuals for cash reconciliation.• Querying to agent banks through Swift messages.• Hands on experience in Intellimatch & Merva Query System (MQS).• Private Bank Funds Transfer & return of funds (Singapore)• Reconciliation of Nostro a/c’s for all CCY’s• Identify and resolve the payments, which are not settled and outstanding in Nostro A/c.• Liaising with Counterparty and clients for constant follow up of the cases (statements).• Importing new GL and also updating the GL in PeopleSoft financials.• Downloading the GL from PeopleSoft and reconciling them with the statements.

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.• Maintained an up-to-date settlement instructions database for FX and MM products. • Handled SWIFT messages and broadcasts.

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