Rajinder Kumar Email & Phone Number

San Francisco, California, Us

Projects – EIW (Enterprise Information Warehouse)Application Systems Engineer Aug 2017 – Apr 2021• Designed (Technical), Developed Ab-Initio code/Teradata DDLs for various applications under EIW. • Documented application guides and playbook for multiple applications.• Promoted code on different environments using Jenkins, Anthill, uDeploy and PAC2000 tools.• Maintained below applications for production issues and design/code changes by working closely with production support, Infrastructure, upstream, downstream teams.• Store Vision Platform• Phone Bank• Alerts• Time Trade• Deposits• Authentication Solutions Unbound Identification• Enterprise Customer Profiling and Referral System• Sales measurement, Active data warehouse and Enterprise customer profile Reporting

Bangalore, Karnataka, In

Project: 8Project – DFS (Dealer Financial System)• Assessed impact, gathered requirements to utilize industry standard Deal Rehash functionality available via Dealer track and Route One which allows dealerships to submit a change to deal structure on existing credit applications. • Designed, led the development of ETL code for the DFS changes on Big Data platform.• Worked on the LexisNexis vendor to create an interface with Loan applications to detect frauds and analyze risk.

Bangalore, Karnataka, In

Project: 7Project – CLSDW (Consumer Lending Data warehouse)• Designed, developed the ETL code on Ab-intio to convert SQL Loader scripts and other CRON jobs.• Working across the teams to update the Oracle database version from 9i to 12c.• Assessed entire Consumer Lending and Cards applications to strategize future enhancements and big data movement.• Documented current state and future state of Consumer Lending applications. This contained applications overlaps/dependencies, end to end flows, detail level data mappings, gap analysis and future architecture proposal)

Bangalore, Karnataka, In

Project : 6Projects – CRM (Customer Relationship Management)• Designed, developed the ETL code for the new CRM application.• Finalized the concurrency setting on Salesforce loads/unloads after multiple interactions with Ab initio and Salesforce support teams.• Successfully deployed and supported the project in production after creating a complex CA7 job schedule with over 200 jobs.

Bangalore, Karnataka, In

Project : 5Project: RES Redesigning Res redesigning project involves migration of oracle database and ab initio 2.15 codes to DB2 database and ETL on ab initio 3.1. This migration contains lot of enhancements on the code mapping side. Role Description:• Working as onshore lead for project.• Communicating with Business and client architects for various solution implementation techniques.• Code Review and provide suggestions on code improvements.• Implementation/Testing/Migration/Support of the Ab-initio code.Environment: Ab-Initio, DB2 Command editor, LINUX, Mainframe, Oracle, ITSP

Bangalore, Karnataka, In

Project : 4 Organization : Infosys Technologies Ltd.Project : Production Support & OptimizationClient : SunTrustTool : Ab-Initio, CA7, DB2 Command editor, Reveleus, OracleDatabase : DB2Team Size : 20Duration : 7 months (currently involve)Environment : UNIXRole : Onshore LeadProject Description This project involves the support and optimization of multiple SunTrust portfolios. The services include emergency break fix, corrective maintenance and client assistance for various Data Warehousing and Business Intelligence packages in production. It also includes perfective maintenance to avert future foreseeable application issues in order to improve performance, quality, reliability, efficiency and usability.Business continuity activities like infrastructure designing for Business Intelligence application install, installation/upgrade of Business Intelligence application, capacity planning and server/data backup planning and coordination including disaster recovery planning and support exercises are part of this project. In addition, the production support team members engage with enhancement and continuous development projects for production support turnover activities and also provide client acceptance testing assistance. Responsibilities:• Serving as onshore lead for 3 applications (Finance Analytics, Finance Business Intelligence and Net Interest Income).• Interface with Business for optimization of ETL code.• Interact with development teams for various code related issues.• Review/Test Ab-initio graphs and unix scripts for upcoming applications.• Reduced time effort/complexity by automating various manual steps/ scheduling changes.

Bangalore, Karnataka, In

Project#3 Organization : Infosys Technologies Ltd.Project : Continuous Development Client : SunTrustTool : Ab-Initio, DB2 Command editorDatabase : DB2Team Size : 4Duration : 5 monthsEnvironment : UNIXRole : DeveloperProject Description Continuous development and optimization of ETL code for all the applications under investment portfolio. Major Applications were RPMS (Relationship Profitability Management System), SFDC (Sales Force Dot Com) and MDM (Market Data Mart).Responsibilities:• Worked as offshore lead for project.• Communication with Business and client architects for various solution implementation techniques.

Bangalore, Karnataka, In

Project : Relationship Profitability Management SystemClient : Leading American bankTool : Ab-Initio, DB2 Command editorDatabase : DB2Team Size : 20Duration : 36 months Environment : UNIX

Bangalore, Karnataka, In

Project Description Replacing the legacy mainframe COBOL system which maintained and managed the entire RPMS portfolio by UNIX based Ab-Initio and COGNOS handling the backend with robust ETL and presentation with versatile COGNOS. RPMS is an information system that calculates and reports Profitability at multiple levels, from the customer to the organization in an Income statement format, providing commercial account officers and management with the data required to effectively manage existing relationships and help make informed new business decisions.Responsibilities:Served as offshore developer for 3 modules.Laid foundation with strong design and driven the implementation for completion. Done complete Detail level design for one module.In depth interaction with Business and client architects for solution implementation gaining appreciation from top business levels.Developed/Reviewed Ab-initio graphs and worked on performance optimization of processes.Scheduling of entire project which handles large number of graphs (over 400), involving logical thinking to come up with an approach without having any clashes among processes across modules.Support and resolve any technical challenges faced by the team during developing and testing phases. Point of contact for communication with entire testing team during Application and Integration testing phases.Key contributor towards training activities on Ab-Initio tool conducted at organization level.

Bangalore, Karnataka, In

Client : Leading American Insurance Provider firmDatabase : SQL Server 2005Tool : SSISTeam Size : 12Duration : 4 monthsEnvironment : Windows