Rajeshkumar Jayaraman Email & Phone Number

Singapore, Singapore

Lead for ETL migration for Regional countries KYC upgrade implementation for VN to meet compliance for UOB's regulatory requirement for VN and CN.Project planning,Estimation and task planning for phased code deployment for SIT & UAT cyclesProject status,DSR to stake holders in weekly basis and internal daily check point calls.ETL mapping,job scripts and SP enhancement for ETL framework and audit requirements.Impact analysis.Requirement gathering and finalization with application team.

Ocbc Bank Tampines, Singapore

Understanding of Bank ETL framework and process methods. Collaborated with BA ,Business User,Data modeler to receive requirement input and analyzed understand the CR's for BASEL3 for Credit RWA . Designed and developed the ETL program to extract source system feeds and transform the changes to load Upstream and downstream DataMart's and push the files through file export programs to external staging servers (Moody RaY 7.1), Data Harvesting staging server and Data lakes

Singapore

Part of design and development of ETL and database programs for NGEMR implementation for Public health institutions in Singapore . Worked in major transition of upgradation of Database and platform upgradation from end to end in Tech refresh project. Worked on ETL conversion from SAP BODS 4.1 programme to Informatica 10.4 ETL programmes.

Chennai Area, India

Chennai Area, India

Project Manager BI DW - - Maintaining Project plan, project metrics and ensured that deliverable are met within schedule, budget, & quality.- Tracking and execution of BI DW projects.including , scoping, estimation, costing, resource allocation, scheduling, execution and control, stakeholder management, post implementation review and project closeout / handover.-Mentoring senior designers, and development teams in technical and career growth path. - Ensured Clients satisfaction, through delivery and coordination and established good relationship with relation ship with sub-contractors and other stake holders of project.

Bangalore &Chennai

• Lead the delivery of multiple simultaneous data management efforts, overseeing on/offshore staff in development and lights on support • Prioritize and schedule work requests and manage the work queue and internal customer expectations • Translate data model changes into technical specs and provide guidance to the application support team.• Proposed the Cognos mock up report and report estimate to replace Ogis Recon release 2 drops by Excel reporting.• Worked on closure of NC related to Project Quality artifacts on Project Plan, PMR ,CM, AMP,RCA,Reviews and CR logs from the internal audit conducted by Mindtree Quality Group function.• Participate in design and impact analysis sessions with onshore/offshore technical leads to ensure sound team decision-making, and come up with the best appropriate solutions • Provide continuous improvement to the efficiency of team, processes, quality, documentation, and support of disaster recovery/business continuity.

United Kingdom,Bangalore & Chennai

-Developed complete ETL programs including informatica mappings,workflows,shell scripts,Plsql programmes,packages,stored procedures, Functions, Exception and Error handling Autosys JCL Jobs for scheduling jobs and done Integration testing,UAT,OAT,Configuration management,Release management, Job Deployment ,coordination with Environment and IT infrastructure team in successful roll out and continuing with Production monitoring and support for larger investment banking clients at on-shore and offshore location.- Have handled Performance tuning of ETL jobs optimization,incremental loading ,CDC,SCD type,data profiling,data cleansing activites, load balancing through pareto-analysis and finally documenting trouble shoot techniques, issues cum resolving approach and working on permanent fix are gathered as guidelines for account and practice level Knowledge repository.- Part of the Global support team pairing with T24 experts at UBS,London ensured reliable,harmonious and smooth running of custody Hedge funds services across EMEA,Americas,APAC regions-Played system analyst role in RA & design phase at onshore and then handled delivery responsibility for the cut phase for a large insurance account based out of Reading UK.- Provided technical leadership to the team and mentoring the junior staffs and conducting Knowledge sharing sessions at the account level.