Rajesh Loke

Manager

Phone: +91-992**-***** email: adlbmj@r.postjobfree.com

LinkedIn: - https://www.linkedin.com/in/rajesh-loke-yahoo-00015121/

Experience Summary:

Overall IT experience of around 16+ years including 10+ years exclusively in Mainframes & BI with 1 year in Big Data technologies. Also have 5+ years in Mainframe Testing.

Specialized in Application Development and Application Maintenance which includes Data Warehousing and Business Intelligence solutions, primarily using IBM Mainframe, DB2, Teradata & Big data.

Good track records in application Maintenance and Application Development in Mainframe Technology with global companies like Fingerhut, HSBC, Marks & Spencer, Telia Sonera, Nordea, and SSAB.

Possess very strong knowledge of Data Ware House Life cycle and architecture.

Managing projects of Application Maintenance and enhancement.

Coordinating with all the stakeholder working on projects.

Lead the daily standup call for the team, as a part of Scrum framework.

Area of expertise in Big Data technologies include HADOOP,HIVE,SQOOP,OOZIE

Requirement gathering by the end user and translating the requirement into the technical and creating blueprint for the solutions and generating low level design documents.

Performed a wide range of consultancy roles including Project Leader, Team Leader, data analyst, technical design, evaluation, creation and project co-ordination

Involved in successful implementation of two major Data Warehousing and Business Intelligence Solutions.

Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

Established track record of successful delivery across geographies and industries

Responsibilities:

Played the role of Big Data Consultant in last project.

Good experience in Application Development and Application Maintenance including production support.

Responsible for Requirement gathering, Provide Solutions, Estimations, Design & Development.

Leading technical teams and mentoring fresher’s in the teams.

Adapted to client business process.

Skills Set:

Primary Skills

Mainframe-Cobol,JCL,DB2, TERADATA,IMS,TELON, CA-7 Scheduler, QMF, SPUFI, File-Aid, File-Master, VSAM, ISPF, BMC Easytrieve, Changeman, Panvalet, Unix, TERADATA 14,HADOOP,HIVE,SQOOP,OOZIE,

Technical Skills

Project Lead

Team Management

Change/ Release Mgmt.

Mainframes

Mainframes Testing

Cobol

JCL

IMS

DB2 ON MF/LINUX

Unix

Hadoop/Hive/Sqoop/

Oozie

Teradata

Consulting Skills

Oral Communication

Written Communication

Building Rapport

Team Building

Project Management

Time Management

Questioning and probing

Certifications:

1. IBM Certified Database Associate -- DB2 Universal Database V8.1

2. IBM Certified Database Associate -- DB2 Universal Database V9.1

Professional Experience:

Training Attended : Hadoop Administration, Big Data Developer, Python,

R, Advance Excel and Mongo DB

Duration : June-2017 to Till Date

Organization : Capgemini India Pvt. Ltd. (Mumbai).

Designation : Manager

Duration : 09-Jan-2006 to 9th June 2017.

Organization : Kanbay Technology Solutions

Designation : Consultant

Duration : 1-Jan-2003 to 31-Dec-2005

Organization : CGI(Mumbai)

Designation : Software Eng.

Duration : 06-Sep-2000 to 31-Dec-2002

Organization : Canbank Financial Services Limited

Designation : EDP Assistant

Duration : 01-Jan-1994 to 05-Sep-2000

Key Projects:

1. Predictive Maintenance Daimler China:-

BBAC plant is facing issues such as equipment failure, shunt burn out for spot welding Robotic operations and glue leakage for Gluing Robotic operations. These robotic operation are widely distributed at most of the lines in Body shop (MRA I & II ).The unexpected failure creates considerable losses in terms of productivity and cost.

There is need to predict such failures well in advance so as to reduce downtime and cost associated with these failures.

As a Team Member coordinated with Data Science team to understand the requirement of data for all the 3 Use cases. Implement and maintain physical data models for Big Data Predictive Maintenance Application. Developed hive scripts for creation of tables and to load data from Landing Area to Hadoop. Design library structure for Data in Unix and Hadoop. Design Work flow (Automation) for entire Use Case 1 and 2. Guided and Mentored junior team members in the team. Ensure smooth implementation of the project by timely completing all the activities on time.

Client : DAIMLER (CHINA)

Organization : Capgemini

Tools : Big Data - Hadoop, HIVE, SQOOP,OOZIE, HDFS

Role : Technical Consultant

2. SSAB – Swedish Steel

SSAB is a Nordic and US-based steel company with a global reach, cost-efficient and flexible production system. SSAB is a leading producer on the global market for Advanced High Strength Steels (AHSS) and Quenched & Tempered steels (Q&T), standard strip, plate and tubular products, as well as construction solutions.

Project involved Knowledge Transfer of 3 legacy applications from client to Sogeti India Onsite Team for Application Maintenance. After transition, India Sogeti team started supporting these applications from offshore.

Client : SSAB - Sweden

Organization : Capgemini

Tools : Mainframe, Cobol, Jcl, DB2

Role : Project Leader

3. Nordea Bank – Forceful Closure

Forceful Closure agile based project that focuses on Closing down selected Local Data warehouse with the objective to decrease Organizational data Management Complexity, maintenance of multiple data warehouse with significantly overlapping data, drives cost and complexity. The approach is to identify all application utilizing data from In-scope Local Data Warehouse (LDW), optimize the redundant data and move it into a Common Data warehouse (CDW).

In FC as a Team Leader, I was responsible for Requirement Gathering, Solution proposal, Designing and Implementation. Also coordinated with the entire Stakeholder within the project (Including Team members from other vendors) to resolve all the issue related to project. Also worked as Defect coordinator & Release Manager for FC project.

Client : Nordea Bank - Sweden

Organization : Capgemini

Tools : Mainframe, Cobol,JTeradata 14.0, Datastage 8.1

Role : BI Technical Lead

4. TELIA SONERA (Sweden)

TeliaSonera, Sweden is Sweden’s leading Telecom Operator operating in various countries. Telia Business Base, TBB, is the largest Data warehouse in TeliaSonera Sweden; the “Corporate Warehouse” for fixed line and mobile telephony, internet and broadband and is first and foremost used for analysis and follow up of customers, products, services and business.

Manage entire TBB project including application Maintenance and Application Development. I was single point of contact person for the TBB. As a Team Leader, I was involved in Requirement Gathering, Solution Proposal, Estimation, Designing and Implementation of new Changes.. Coordinated with Operations Team and Business User’s. Worked as a Teradata Expert to support production issues. Guided and Mentored fresher’s in the team.

Client : Telia Sonera(TBB) - Sweden

Organization : Capgemini

Tools : Mainframe, Cobol, JCL, CA-7, Teradata 14.0

Role : Project Leader and Technical Architect

5. M&S EDW – Retail (Multiple BI Project-SAGG & ECOMMERCE)

Enterprising Data ware Housing project for client Marks & Spencer. ECOMMERCE project is part of the BFP program. SAGG & ECOM is a micro-batching solution sending Sales via POS & Internet transactions to the warehouse (EDW). EDW further offers business intelligent reporting of the Internet (sales & refunds) & Stock (counts, movements & adjustments) data received from various OLTP systems.

As a DBA, I was responsible for Implement and maintain physical data models. Define the data mappings that were used for ETL processing. Maintenance of the development and test databases. Query performance tuning using latest features of DB2 9.0. Writing Schell Scripts. Creation of data for performance Testing.

Also worked as a Data Modeler in this project.

Client : Marks & Spencer UK

Organization : Capgemini

Tools : DB2 V9, Datastage 8.1, Business Objects & UNIX

Role : DBA

6. Marks & Spencer – Retail – (Sales & Stock)

The Sales & Stock (SaS) Reporting System was one of most critical Data Warehouse application in M&S. The system catered to 300+ Head Office & Store Users.

As a Team Leader, I was responsible 24*7 support for Legacy application. These includes healthy functioning of all the interfaces, landing of data in Business Data Warehouse and transformation of data into the Business Intelligence Warehouse. Also ensure compliance to ITIL process within project.

Client : Marks & Spencer UK

Organization : Capgemini

Tools : Mainframe – Cobol, JCL, DB2 and CA-7

Roles : Team Leader.

7. HSBC – Consumer Lending - USA

HSBC Consumer Lending - The goal of consumer lending is to offer loans that meet the needs of customers and institutions alike. The term consumer lending process refers to the activities that begin when a borrower requests a loan and end when the borrower has repaid the loan.

As a Team Leader, followed complete SDLC. These includes understanding of Functional requirement, Estimation, Scheduling, Creating Technical design, Coding, Code Review, Preparation of Test Cases, Test Case Review, Unit Testing, System testing and Implementation.

Client : HSBC- Consumer Lending

Organization : Kanbay Technology Ltd

Tools : Mainframe – Cobol, JCL, DB2, IMS, VSAM and CA-7

Role : Team Leader

8. Michelin Manufacturing - USA

Michelin is the second largest tire manufacturing company in the United States. Its business operations are handled by different departments and its Information System (IS) department is responsible for providing System support for Corporate, Commercial & Manufacturing business applications. CGI provides support to Michelin’s IS Department in carrying out the maintenance of Michelin’s computerized applications.

As a Team Member, I was responsible for Coding and Unit Testing of Cobol, VSAM and IDMS program and JCL jobs.

Client : MICHELIN

Organization : CGI

Tools : Mainframe – Cobol, JCL, IDMS, VSAM

Role : Team Member

9. Revolving Charge (Credit Card Application)

Fingerhut is a database marketing company that sells a broad range of products and services through catalogues, internet and direct marketing. The scope of the project is maintenance and production support of Legacy Systems running in MVS as the operating system.

As a Team Member, I was responsible for Application Maintenance of Credit Card Application.

Client : FINGEHUT MAIL SHOPPING (Retail) - USA

Organization : CGI

Tools : Mainframe – Cobol, JCL, DB2, IMS, VSAM and CA-7

Role : Team Member

Academics: : Acquired Bachelor of Science (Physics) from Mumbai University.

: Diploma in Business Management ICFAI University.

Contact this candidate