Ramakrishnan Parameswaran Email & Phone Number

Chennai, Tamil Nadu, India

Digital Banking Platform IntegrationDigital Account Opening Platform Integration

United States

MDM Application Upgrade and Datacenter Migration

Rosemont, Chicago, Il

Data Architect for MDM (Master Data Management) solution implementation for a US based Financial holding company which is a consortium of 15 community/charter banks a nd other subsidiary business. - Objective is to build a "Customer 360" view comprising of Enterprise Single View of Customer, accounts relationships, services subscribed sourced from various systems of Customer/Account origination and updates like Banking Core, CRM, HRMS, Mortgage LOS.- Build different Hierarchies pertaining to enterprise needs - Provision "Golden" Customer profile via Batch extracts and APIs to downstream systems- On-premise Implementation of Informatica MDM solutionTech stack:MDM Platform : Informatica MDM 10.2 HF1 multi domainApp Server Platform: RedHat JBOSS EAP 6.4 OS: Windows Server 2016Database: MS SQL Server 2016 (Enterprise) as MDM ORSProgramming/Build Tools : SSIS ETL, SQL, T-SQL Scheduler : Stonebranch Workload Automation Others : Informatica Address Doctor (Address Standardization)Responsibilities Include:- Source systems Assessment - Business process and Data.- MDM Product Vendor Assessment, evaluation - Relational Data Model Design for ETL and MDM CMX_ORS.- MDM Hub console activities - ORS validation, BO/Stage/Landing tables definition, MDM mappings, Cleanse list and cleanse function definition, Address Doctor configuration, Trust configuration, Match & Merge rules definition, Batch Group definition, Entity object & types, Relationship object & types, Hierarchy builds; Delta detection, Hard delete detection, Post landing user exit configurations.- MDM Provisioning/e360 configurations.- BES API validations.- SOAP UI setup for SIF service based atomic operations and execution.- Customer interaction, Onshore-offshore coordination, High level task planning and execution, E2E delivery ownership.

Charlotte, North Carolina

Technical Delivery Lead of a Customer Relationship warehouse for an Enterprise wide strategic program to convert Home Equities & Mortgage servicing platform to a new platform which is based on MISMO standards.Program involves many applications - FLUs, e-com & OMNI channel, web & batch services, LOB users. My application is a batch based operational & analytical warehouse has significant changes to achieve the program objectives. - Sourcing of account, profile, profitability, linkages data from new/disparate sources - Functional changes like account#, entity#, product code changes - business rule/transformation changes (ETL/ELT) in processing & new/additional attributes derived - Supply of enriched data to Scoring,Decisioning,Bankruptcy,Reward,collections & recovery systems - New dimensional data at product levelAs an internal Appln activity - platform rehosting to Hadoop platform is being pursued. Changes due to functional impacts are planned for build in Hadoop Platform. This involves RAW data ingestion from data lake and SQOOP based sourcing of data from Teradata Warehouse. Establishing ETL/ELT processes in Bigdata platform.Tech Stack :| Platform -> Linux, Hadoop (CDH 5), Spark v1.6| ETL/ELT & Programming -> Shell script, Python, SQL/HIVE QL, IBM Datastage| Database -> HP Vertica,Teradata,Hive | Scheduler -> Autosys,OozieResponsibilities Include :| Representing application in JAD discussions, Requirements gathering, application level data modelling, design of the process, HLD/LLD documentation & updates| Driving the program into 2 sub-levels 1) Functional changes due to change in servicing platform 2) Technical platform rehosting to Hadoop-Spark platform| Apache SPARK - capability assessment, Technical & functional POCs, Defining data models in target state, Program plan, timeline, Tech stack finalization, Process and data flow analysis, lineage analysis, design decisions, guiding the team on Build.

Chennai Area, India

Application & Data Architect of a sub-application for two Enterprise wide strategic programs of a large US Based global bank 1. Introduction of a Small Business Unsecured credit product. 2. Conversion of global wealth investment management customers from one platform to another with new customer IDs. This is more of a backend change. Both the programs involve many applications from Front line units to Line of business user groups. My application being an operational & analytical warehouse has significant changes to enable these program objectives and data flow with enriched attributes to collections & recovery, credit scoring & decisioning, Bankruptcy, Reward teams. The program involves data ingestion from new systems, building new ETL pipelines, introduction of new dimensional data to product and system attributes , modifying existing ETL core processing of the application. Tech Stack :| Operating System -> Linux| Programming/Scripting -> Shell Scripting, SQL| Database -> HP Vertica, Teradata| ETL/ELT -> IBM datastage| Scheduler -> Autosys| Version Control -> Tortoise SVNResponsibilities Include :| Participation in JAD discussions with various application groups, Requirements gathering, application level data modelling, design of the process, HLD/LLD documentation & updates| Lead these programs from offshore with 10 member team| Process and data flow analysis, lineage analysis, design decisions, guiding the team on Build and testing, code review, engagement with QA teams, validations, defect resolutions| Timely submission of Change Requests, Support team's service requests for production install and verification, Post-deployment validations & certificationAccomplishment : | Complex Business functionalities handled simply in the design and code| Delivery of program on-time though there were many last minute requirement changes| Introduction of new product into the system after a gap of 4 years with minimal impact to existing processes

Guadalajara Area, Mexico

Application & Data Architect of a sub-application for an Enterprise wide strategic program of establishing cross-LOB Bankruptcy application for a large US based global bank. The new application establishment has many different units involvement with my application as significant one given that the 3rd party to bank, which monitors bankruptcy filing of customers across US courts, supplies data to us. We ingest the information, enrich it with new & rolled up dimensions across customer & account level attributes using ETL, distribution to the bankruptcy application team. This program is executed in Agile mode. Tech Stack :| Operating System -> Linux| Programming/Scripting -> Shell Scripting, SQL| Database -> HP Vertica, Teradata| ETL/ELT -> SQL, IBM datastage (Datastage only for Inbound & outbound)| Scheduler -> Autosys| Version Control -> Tortoise SVNResponsibilities Include :| Participation in JAD discussions with various application groups, Requirements gathering, application level data modelling, design of the process, defining stories, participation & status update in everyday Stand-up call conducted by Scrum master, status update of the stories in "Rally Dev" portal at the completion of sprint every 2 weeks| Onshore coordinator and lead for 15 member Nearshore-offshore team which has a mix of TCS and other vendor| Handling of all SPIKE stories (Research). Planning, Designing solution for implementation of current release needs as well as for some technical debts| Code review, Unit testing results and validations, Coordination with QA team for data setup needs, justification and solution for any perceived defects| Timely submission of Change Requests, Support team's service requests for production install and verificationAccomplishments :| Recognized by customer for "Best-In-Class" and timely solutions for enabling the program and process.

Guadalajara Area, Mexico

IT Delivery & Operations Manager for 50+ member Consumer Segments LOB team of a large US based global banking account at TCS Nearshore. The team comprises of ADM, AMS, QA teams across Cards, Deposits, Reference Data systems portfolio. Responsibilities Include :| Delivery & Operational Management| Multicultural Team management with people from 3 different nationalities (Mexico, Brazil, India)| Connect with Business Relationship Managers & Client Partners at onshore on opportunities - for expansion and establishment of teams at nearshore - for location level project status updates - for business planning contributions| Consumer Segments as a separate PnL - operational metrics tracking | Coordination with account & location level finance teams on operational metrics | Participation in campus recruitment as panelist| Team building, new skill development and certification program drives within the team| Timely completion and tracking of activities of the sub-LOB team adhering to larger account level and location level plans and metrics| Quarterly revenue target, tracking and execution plan to achieving it| Coordination with recruitment team for profiles to open positions| Customer connect| Performance Management, Competency Development, Billing and Finance of the teamAccomplishment :| Planned Quarterly certification targets for each associate enabled each of them to complete key certifications like ITIL, TOSCA, Java, IBM Datastage, Hadoop basics, etc. Only sub-LOB with highest number of certifications| Part of Process Improvements/Value additions - added value/saved cost to the tune of 1.5M USD| Awarded as "Star Team" for best functioning across all aspects in the account

Guadalajara Area, Mexico

Lead an account level Innovation team as a horizontal unit at Nearshore location.Responsibilities include : | Identifying opportunities of simplification and automation, Value addition| Understand the application business and tech landscape of the identified opportunities| Discuss, evolve, build thought process for the opportunities| Drive the associates from the respective team of opportunity identified to implement the solution| Present the solution to customer showing both tangible and intangible benefits| Registering the savings in the TCS intra-portals and Customer portals | Recognizing the associates with rewards for taking up such quick time bound process improvements and value additions| Conducting special ideation drives and white paper drives and making the best outcome of it evolved and implemented| Established an account level Analytics and Mobility lab at nearshore location, specifically to build solution needs across other sub-units from Nearshore| Built a nearshore team of Ninja developers who can design and build quicker time bound tech solutions for POC, POV needs of teams at onshore across various sub-units.Accomplishments :| With in 14 months of taking up this role, brought in a combined saving of 2.24 M USD. 1st ever highest PI/VA achieved in TCS LATAM location. | 1st time participation and solution presentation of various TCS-Global Unit level events. 1 such solution was a winner in an event and 2 solutions made it to finals of other event. | Established or built an TCS account level lab for the 1st time in Nearshore location with in 2 months time.| Built a web and MySQL based solution for year end Business planning needs for Client and Delivery Partners giving a paradigm shift from time prolonged Excel based approach to time shortened portal based approach with capability of easier input, to see various dashboards ad reporting functionality.

Chennai Area, India

Application Architect and Program Manager for a strategic program for consolidation of 2 Customer Relationship datawarehouses for a large global USA based bank.Tech Stack :Platform -> Mainframe (COBOL/JCL) in pre-consolidation stateOperating System -> Linux, Windows XPProgramming/Scripting -> C, Shell, Perl, SQLDatabase -> HP Vertica, TeradataETL/ELT -> HP Vertica SQLScheduler -> Autosys, CA7 (pre-consolidation state)Version Control -> Tortoise SVNResponsibilities Include :| Assess & Identify similarities & differences among 2 applications in terms of data sourcing, data profiling, data transformation, storage and distribution.| Working with Architecture teams for Data Modeling of Core of the new application| Recommending data sources to be remediated, processes to be converged, Linked or rewritten, Downstreams to be supplied - with a standard format of data with zero or minimal impact to upstream or downstream systems| Design and build ETL & ELT pipeline for Sourcing and Core processing tracks| Design and built generic utilities based on C for EBCIDIC to ASCII conversion of sourcing files, Perl based utility to convert VB to FB file, Perl based utilities data pull and push between Vertica and Teradata, Shell scripts for ASCII fixed length/delimited files in to Vertica RAW layer with standard pre-load and post-laod quality validations.| Estimation and build of various tracks, Proposal & design & build new generic framework and utilities | Obtaining Architecture Review Board/Technical Review Board sign off, User sign off, Client communication for the project| Leading a 20 member team. Guiding and E2E tracking of team’s activities from design to implementation with proper review at each stageAccomplishments : | Awarded "Best Team award" and "Best Program Manager" award| Recognized by customer for "Best-In-Class" and "First-of-its-kind" high performing & all scenario handling generic utilities for the program

Chennai Area, India

Technical Project Manager for Production Support (L1, L2, L3) for Card warehouse application & Customer relationship Datamart of a Global USA based Bank.Tech Stack :| Operating Systems -> IBM AIX, RedHat Linux, Windows XP| Programming/Scripting Language -> Korn Shell script, Perl, SQL| ETL tools -> IBM Datastage, Teradata SQL| Database -> DB2, Teradata| Scheduler -> TWS Maestro, Autosys| Incident/Problem Management tool -> MaximoResponsibilities Include : | Lead a team of 22 members from offshore covering Card datawarehouse application's Batch Operations (L1) and L3 support, Customer Relationship application's Operations (L1L2)| E2E execution of support – solving production abends, handling service requests, Upstream/downstream follow ups, SLA maintanence, participating in Project walkthrough, Deployment/install support, reporting, customer meetings, Disaster recovery trial exercise| Monitoring and execution of production - meeting the SLAs on timely basis, upstream/downstream follow ups, Business User communications & follow ups, Deployment/install capacity planning & support, timely reporting and customer meetings| Tracking of problem management & change management tickets, prioritizing & implementing code/data fix in production, Reviewing reports and dashboards in L3| Tracking and closure of Timesheets for the entire team| Capacity planning, Shift Planning , Billing, Performance management, Competency Building for teamAccomplishments : | Contributed to an Production Support RFP - contract renewal and rebid of a 3M+ support engagement of a larger USA based global bank. Specific to my area of engagement and scope, Prepared solution proposal decks, potential Process improvement or value add offerings, financial data and cos benefits for the renewal. TCS management WON the RFP and the significant contributors (includes me) were rewarded. | Automation, Process Improvements & Value Additions saving cost to the tune of 1M USD/year to customer.

Chennai Area, India

Project Leader for Development projects and L3 support of a Card warehouse Application of a large Global USA based Bank.Tech Stack :| Operating Systems -> IBM AIX, RedHat Linux, Windows XP| Programming/Scripting Language -> Korn Shell script, Perl, SQL| ETL tools -> IBM Datastage| Database -> DB2| Scheduler -> TWS MaestroResponsibilities Include :| Technical design, development, Unit testing, System testing and production implementation of ETL jobs and Unix scripts.| Estimations, Code walkthrough, getting Architecture Review Board/Technical Review Board sign off, User sign off, Client communication for the project| Estimation for Initiatives| Lead a team of 15 members with a mix of experienced and Freshers.| Leading, end to end tracking, follow up and execution of reportee’s project from design to implementation with proper review at each stage, successful execution and implementation of reportee’s projects| Lead the Application's L3 support team as additional responsibility. Tracking of tickets, review of data/code fix, ensuring testing and successful implementation in production| Tracking and closure of Timesheets for the team| Capacity planning based on confirmed project demand and available associate capacity and making allocations accordingly.| Performance Appraisal and Competency development of the teamAccomplishments : | IBM Certified on Datastage 8.0 with 93%| Before I taking the responsibility of L3 support, the team had lot of escalations. With in 5 weeks of taking over, developed morale in the team and delivered long pending and significant defect fixes. Turned the team from Escalation to appreciation mode. | Rewarded "Certificate of Project Excellence" award for making all initiatives successful and turning L3 support as valuable team| Build lot of Shell based automatic tools to simplify some of the manual work with the freshers. Made is an opportunity for freshers to learn and also for the team to benefit.

Pune Area, India

Unix Technical Lead and Designer for Loan Application of large global EUR based banking customer.Tech Stack : | Operating Systems -> Suse Linux, Windows XP | Programming/Scripting Language -> Korn Shell script, Oracle SQL | ETL tools -> Informatica | Database -> Oracle 10G | Scheduler -> Control-M Responsibilities Include :| Technical Design of Application script modules using Korn shell scripting| Development of Key Application scripts with Korn shell scripting and SQL| Building of Unit test cases and results validations| Design of generic scripts for FTP tools and Informatica command line tools| Assigning build and Unit test execution to developers and managing the deliverables for timely completion Accomplishments :| Design completion and build of utilities in a short time frame and tight deadlines| Appreciated by application onshore coordinator for the quicker completion of a part which was started late - the Unix modules entirely.

Chennai Area, India

Unix ETL developer and Data Analyst for Authorization warehouse of US based large global card transaction processing customer.Tech Stack :| Operating Systems -> IBM AIX, Windows XP| Programming/Scripting Language -> C , Korn Shell script| ETL tools -> Syncsort DMExpress| Database -> Oracle 10G, Netezza | Scheduler -> IBM TivoliResponsibilities Include :| Batch ETL jobs development using Unix shell script, C, DMExpress Syncsort for ETL and Oracle DB| Application Core releases and Enhancements project scripts build | Unit Test case preparation and Execution| Deployment of components in the IBM Tivoli scheduler| Data Quality Checks & Validations for core release projects| Data Analysis and Mining on data residing Netezza platform for standard validations as well as business user queries| One to one client interaction for gathering Data Analysis related business requirement. | Key weekly and monthly deliverables which are used for important business decisions of customer| Mentoring Freshers and New Joinees in the team.Accomplishments :| Recognized by Customer Management as "most favoured developer" for successful impeccable delivery of projects| Appreciations from Buines user groups for the Data Analysis/Mining outcomes| Awarded "FEATHER IN MY CAP" award for the excellence in Data Analysis in the Authorization Application.

Chennai Area, India

Developer and Production Support (L1/L2) Engineer for a large US based Investment Banking Customer. Tech Stack :| Operating Systems -> Sun OS, Windows XP| Programming/Scripting Language -> C Shell script, Oracle SQL, PL/SQL| Database -> Oracle 8i | Scheduler -> Autosys Responsibilities Include :| Monitoring of Nightly batch cycle of Financial Application hosted on Oracle Apps ERM product| Monitoring of jobs in AP, AR and GL modules and publishing of data to Essbase cubes| Acting up on any production issues - SOR delays, data corrupt, SLA delays, etc - immediately and alerting the user groups| Job failure detection and root cause analysis| Opening Incident in AR Remedy and resolving the issue to closure| Timely reporting| Automation of various Reports using Unix Shell Script and Oracle SQL. Accomplishments :| Automated 12 reports and 4 monitoring tasks with better mail based alerts using Unix Shell script and Oracle SQL.| Reduced the effort in monitoring and reporting by means of automation, thus making more time available for resolving issues | Awarded "THANKS A ZILLION" award for staying top on an critical issue and resolving it in a short time and for timely and proper communications to the management and user groups| Awarded "FEATHER IN MY CAP" award for automating most of the reporting and monitoring tasks, bringing up much efficiency in to the team.