RAMKUMAR K S

#**/*, **** ****, ** Layout, Near Kadirenahalli circle, Bangalore – 560070 +91-720******* ac5cpk@r.postjobfree.com

Having 3 years of experience in development of extraction transformation loading methodology for supporting

Data transformations and processing in corporate wide ETL Solutions using ETL tool Informatica power center.

3 years total experience in ETL development using Informatica Power Center 9, Oracle.

Have a good work experience in processing relational database, flat file formats.

Experience in handling CSV files with multiple delimiters

Experienced in understanding the requirements, S-T mappings and preparing Technical design Documents.

Have good knowledge on overall architecture of HRMS payroll

Have good experience on configuration management tool - SVN

Well-known knowledge on different schemas of data warehouse.

Having involved in doing POCs using Informatica MDM for new requirements

Good work experience Agile methodology

Comprehensive knowledge in SQL.

Have good knowledge on data modeling

Involved in Peer reviews, proactively initiated brain storming sessions to produce the best solutions.

Quick learner and Excellent Team player, ability to meet tight deadlines and work under pressure.

Bachelor of Engineering - Computer Science & Engineering from PT LEE CN college of

Engineering and technology, Kanchipuram, Tamil Nadu.

Diploma - Computer Science & Engineering from Sri Krishna Polytechnic College, Arakkonam,

Directorate of Technical Education, Chennai, Tamil Nadu.

Company : MIMsys technologies Pvt, Ltd, Bangalore.

Duration : May 2015 –till date

Designation : Junior Software Engineer

Role : ETL Developer

ETL tool : Informatica Powercenter 9

Database : Oracle 11g

Configuration management tool : SVN

Defect tracking tool : JIRA

Project 1: HRMS– Agent Sync

Company : MIMSYS technologies Pvt, Ltd, Bangalore.

Environment : Informatica Power Center 9

Database : Oracle 11g

Role : ETL Developer

Team Size : 03

Place : Bangalore

Duration : May 2015 to till date

Description:

MIMSYS HRMS is a flexible, reliable, easy-to-use and yet comprehensive application which goes beyond the core payroll activity of administrating employees’ salaries in the organization. MIMSYS HR and Payroll transforms administrative tasks to enable a more streamlined workflow. In this module, we receive unprocessed flat files that would be further transformed with respect to agent sync and also created headers such as agent_name, agent_code, agent_city, agent_country, candidate_name etc. The processed data would be loaded into Oracle 11g

Responsibilities:

Analyzing functional and requirements specifications.

Understanding the data model for Agent sync

Creating ETL jobs for Agent sync

Cleansing the data according to target tables

Applying the transformations such as Expression, Sequence generator, Aggregator, Router

Loading the data targets such as agent-base and agent-hist

Using debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Monitoring Workflows and Sessions using Workflow Monitor.

Checking in and out the ETL scripts using SVN

Reporting the daily status to manager and clients.

Maintaining status reports and creating MOMs.

Communicating with business customers to discuss the issues and requirements.

Giving KT to new joiners.

Project 2: HRMS– Referral Sync

Company : MIMSYS technologies Pvt, Ltd, Bangalore.

Environment : Informatica Power Center 9

Database : Oracle 11g

Role : ETL Developer

Team Size : 03

Place : Bangalore

Duration : Jan 2017 to till date

Description:

MIMSYS HRMS is the complete HR cycle from Position definition to Position budget control along with requirement management including application data bank. The system also offers recruitment management cycle, employee training etc. In this module, we receive unprocessed flat files that would be further transformed with respect to referral sync and also created headers such as referrer_name, referee_id, referee_name, referee_email, referee_phone etc. The processed data would be loaded into Oracle 11g

Responsibilities:

Analyzing functional and requirements specifications.

Understanding the data model for Referral sync

Creating ETL jobs for Referral sync

Cleansing the data according to target tables

Applying the transformations such as Expression, Sequence generator, Normalizes Transformation, Router Transformation

Loading the data targets such as referral-base and referral-hist

Using debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Monitoring Workflows and Sessions using Workflow Monitor.

Checking in and out the ETL scripts using SVN

Reporting the daily status to manager and clients.

Maintaining status reports and creating MOMs.

Communicating with business customers to discuss the issues and requirements.

Giving KT to new joiners.

Project 3: HRMS– Direct Sync

Company : MIMSYS technologies Pvt, Ltd, Bangalore.

Environment : Informatica Power Center 9

Database : Oracle 11g

Role : ETL Developer

Team Size : 03

Place : Bangalore

Duration : May 2015 to till date

Description:

MIMSYS HRMS is the complete HR cycle from Position definition to Position budget control along with requirement management including application data bank. The system also offers recruitment management cycle, employee training etc. In this module, we receive unprocessed flat files that would be further transformed with respect to direct sync and also created headers such as candidate_name, candidate_id, candidate_city, candidate_email, candidate_phone, profile_header etc. The processed data would be loaded into Oracle 11g

Responsibilities:

Analyzing functional and requirements specifications.

Understanding the data model for direct sync

Creating ETL jobs for Referral sync

Cleansing the data according to target tables

Applying the transformations such as Expression, Sequence generator, Router

Transformation

Loading the data targets such as direct-base and direct-hist

Using debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Monitoring Workflows and Sessions using Workflow Monitor.

Checking in and out the ETL scripts using SVN

Reporting the daily status to manager and clients.

Maintaining status reports and creating MOMs.

Communicating with business customers to discuss the issues and requirements.

Giving KT to new joiners.

Father’s Name : Sivanath K R

Nationality : Indian

Date of Birth : July 30, 1990

Gender : Male

Residential Address : 16/1, 3rd floor, 9th Main Road, RK Layout, Near Kadirenahalli circle,

BSK 2nd stage, Bangalore – 560070, Karnataka, India

Contact this candidate