Project Data
Resume:
Mr.Madhuvarman Periasamy Mohan Mobile- 501-***-****/
Professional Summary
7+ years of experience in IT industry and has a good domain expertise in Credit Card Applications and Banking Application.
Worked extensively in TERADATA, SQL, UNIX, JCL, COBOL and well versed with Teradata ETL Utilities, AUTOSYS, VSAM, File-Aid, NDVR and Change Man.
Very good domain knowledge in Card posting and billing system and experience in both Application
development and Production Support in Teradata and mainframes.
Also good domain knowledge in Data Warehousing.
Skills Profile
Technical
Operating System
Windows 98/XP, UNIX, OS/390
Environment
IBM Mainframes
Database
TERADATA, DB2, Oracle 10G(Basics), VSAM, VERTICA
Internet Tools
HTML, CICS
Languages
BTEQ, SQL, Cobol, MVS JCL, C, C++, SAS, FOCUS
Other
Teradata Utilities(Mload, Fload, Fast Export) File AID, NDVR, QUICK JOB, CHANGEMAN
Functional
Management and Leadership Skills
Development, Application Support, Project Management and Business Analysis
Training & Development
Trained and worked on the development projects of cards, insurance and data warehousing. Have conducted many training for team members.
Professional Organizations
Capgemini (30th October 2008 – 19th September 2011)
Cognizant (26th September 2011 – 18st May 2012)
Infosys (28th May 2012 - till date)
Professional Experience
1) EIX(Enterprise Information Exchange) – (Duration) FEB 2015 – Till date
Designation : Technology Analyst
Client : BANK OF AMERICA
Employer : Infosys
EIX – All transations (including all applications Home loan, Debit card, WIR, Credit card, etc) that happens in Bank of america system are collected together by our single system and used for Data analytics and Data quality. All lots of Classification and Categorizations are done based on the daily transactions and lots of predictions and analytics are performed. Am working as an Onsite couterpart by gathering reqirements from Bank and sharing it with my offshore team and work along with the offshore team and make successful implementations of the Development Initiatives using the SDLC model. We also provide support for the same EIX system and I am the primary Support.
Environment: TERADATA, Teradata ETL Utilities(MLOAD,FLOAD,FAST EXPORT,TPUMP), BTEQ, SQL, UNIX, MAINFRAME, Autosys, Remedy, SAS.
Roles and Responsibilities
Played Role of Onsite Lead.
Responsible for gathering requirements from Clients and providing Offshore with high level code and Design.
Accountable for reviewing the Design document and the getting it approved from Clients.
Accountable for code development in Teradata BTEQ, MLOAD, Fast Export and Unix shell scripts based on the requirements.
Involved in the migration of code components across various pre-production environments like SIT, UAT and Production migration. Also worked on the post production activities which includes code reviewing, Post production Validation and monitoring the production runs.
Used to work with other teams like DBAs, migration teams, metadata teams for approval and install activities in the production migration.
Used Remedy for attending Ticktes and for Production Install activities.
Used to provide 24/7 production support for my appliction.
Used Autosys extensively for scheduling Jobs, monitoring and run manually whenever required.
Accountable to handle my application whenever there is an Outage in the Source side or in case of an Environment Outage.
Have used Teradata ETL utilities to pull data from Mainframe flat files to Teradata table and also have exported data from Teradata to Mainframe files.
2) CDM(Customer DataMart) – (Duration) MAY 2012 – Jan 2015
Designation : Technology Analyst
Client : BANK OF AMERICA
Employer : Infosys
CDM – This is a Data Warehousing Project where we collect details of the Customers transactions and Account Details and make analysis of the Account/Customer and generate reports to recommend Privileges to the the Customers. Worked on more similar Enhacemnts and Development Initiatives.
Also worked on the migration of Teradat to Vertica.
Environment: UNIX, TERADATA, Teradata Utilities(MLOAD,FLOAD,FAST EXPORT,TPUMP), BTEQ, MAINFRAME, SQL, VERTICA, Autosys.
Roles and Responsibilities
Played Role of Team Lead.
Responsible for gathering requirements from my Onshore and Client LOBs and allocating tasks for my team members.
Used Maximo for attending Ticktes and raising tickets.
Used to provide production support for my appliction whenever there is an issue that is beyond L1/L2 Team's reach.
Used Autosys extensively for scheduling Jobs, monitoring and run manually whenever required.
Accountable to handle my application whenever there is an Outage in the Source side or in case of an Environment Outage.
Accountable for maintaing the list of activities/tickets and prepare weekly Dashboard for the L3 Team's activities.
3) DTS(Drain The Swamp) – (Duration) Jan 2012 – May 2012
Designation : Programmer Analyst
Client : MetLife
Employer : Cognizant
DTS – This is a migration project. Conversion of all the focus programs with the relavant SAS programs to generate the same report(output) as before.
Environment: SAS, FOCUS, File Aid, CHANGEMAN, JCL.
Roles and Responsibilities
Played Role of Senior Team member.
Responsible for gathering requirements from my Onshore.
Used Changeman for installing Mainframe components.
Migrated lots of Focus programs to SAS programs.
Responsible for testing the programs created and move it to the next environment.
4) Metpay – (Duration) Sep 2011 – Dec 2011
Designation : Programmer Analyst
Client : MetLife
Employer : Cognizant
Metpay – This is an enhancement and development project. Have worked in many design, coding and testing part of enhancement projects.
Environment: COBOL, VSAM, CICS, File Aid, CHANGEMAN
Roles and Responsibilities
Played Role of Senior Team member.
Responsible for gathering requirements from my Onshore.
Used Changeman for installing Mainframe components.
Involved in the development of many COBOL programs.
Responsible for testing the programs created and move it to the next environment.
5) Pricing Readiness - (Duration) Aug 2009 – May 2010
Designation : Associate Consultant
Client : Discover Financial Service.
Employer : Capgemini
PRICING READINESS– This was a massive and huge development project in CPB, implementing CARD ACT regulations in Discover system.
This Project had most of the impacts in CPB system. Worked on design, coding and testing for most of the complex requirements. Have the knowledge of CPB system and shared with 30 more resources to start this project.
Environment: COBOL, DB2, CICS, File Aid, NDVR, Unix, EXCEED
Roles and Responsibilities
Played Role of Modle Lead.
Responsible for gathering requirements from my Onshore and distributing among the team.
Involved in designing the Creidit cards Payment Hierarchy and Interest hierarchy.
Used NDVR for installing Mainframe components.
Involved in the development of many COBOL programs in Mainframe and Unix.
Responsible for testing the programs created and moving it to the next environment.
Provided support for L3 Teams analysis whenever required.
6) Card member posting and Billing - Duration - Nov 2008 – Sep 2011
Designation : Associate Consultant
Client : Discover Financial Service
Employer : Capgemini
CARD MEMBER POSTING AND BILLING - As an associate consultant, worked on designing the requirements, coding the logic for new functionalities and unit/volume testing the changes applied. This project uses a powerful combination of mainframe and unix technologies.
• Stores critical cardmember information in DB2 and Oracle database.
• Posting the transaction using the application program developed by Cobol.
• Creating billing information every month for every eligible cardmember.
Environment: COBOL, DB2, CICS, File Aid, NDVR, Unix, EXCEED
Roles and Responsibilities
Played Role of Team Member.
Responsible for gathering requirements from my Team Lead and completing it before the dead line.
Used NDVR for installing Mainframe components.
Involved in the development of many COBOL programs in Mainframe and Unix.
Involved in coding and enhancements on the Credit cards Monetary module and Account transfer module which made me understand the functionality of the Credit card system.
Responsible for testing the programs created and moving it to the next environment.
Summary of Projects
1) EIX
This project is a Data Warehousing Project. All transactions (including all applications Home loan, Debit card, WIR, Credit card, etc) that happens in Bank of America system are collected together by our single system and used for Data analysis and Data quality. These details are also used for predicting future for the Bank and the other Business Organizations by summarizing these transactions.
2) CDM
This project is a Data Warehousing Project. The Team does analysis on the available Customer data and develops and implements new opportunities and Daily/Monthly Reports used by Engineering Clients for Risk analysis. Also a big migration of all the Data from Teradata to Vertica happened where we implement all our existing BAUs in Vertica.
3) DTS
This project is fully about migration/conversion/automation. The team finds the places where manual tasks can be automated and comes up with the plan from designing till implementation of the same. Also it deals with cost reduction plans by proposing the technologies that cost less for the client that the current one and develop it.
4) Metpay
This project is fully about billing of insurance. Process like billing, remittance, respread, rebill are all taken care for every Group, account and policy for Payroll deduction module.
5) PRICING READINESS
Deals with the regulations of payment and billing system so as to favor the customers. For this CPB was almost redesigned.
6)CPB - CARD MEMBER POSTING AND BILLING
This project takes care of posting transactions and billing the statement for every card member of Discover credit cards.
Training and Seminars
IBM Mainframe Application programming – Maples ESM Technologies,Chennai.
Knowledge transition with onsite as part of CPB application, posting and billing application of credit cards.
Fresher learning program at Capgemini Pvt. Ltd, Hyderabad.
Knowledge transition with seniors as part of insurance and payroll deduction billing system for insurance.
Training on Teradata from Infosys.
Knowledge transition with onsite and Senior members of the CDM application on Data warehousing concepts with Teradata.
Recognition
Received Best Performance award within the Team for outstanding performance and helping the team to meet deadlines.
Received appreciation mail from client for dedicated and best performance during Pricing Readiness project.
Received BOFA award for Best performance for Leading the L3 Support team of CDM application, successfully.
Received INSTA award from Infosys for quick fix and support tasks performed as part of THOR(EIX) Application.
Additional Responsibilities:
Ability to train and motivate.
Able to work well independently and in teams.
Identifying training needs of the team members and providing training to the new team members
Responsible for Leading a Team and assigning tasks to team members.
Education
• SRM University, Chennai, Tamilnadu, India, B.Tech/Computer science, 2008, with 7.089 CGP.
• 10+2 from Spic Nagar Higher Secondary School, Tuticorin, 2004 with 88.83%.
• 10th from Spic Nagar Higher Secondary School, Tuticorin, 2002 with 91.20%.
Personal Details
Name : Madhuvarman Periasamy Mohan
Father’s Name : Mr. Mohan Periasamy
Date of Birth : 11-Apr-1987
Age : 28
Sex : Male
Nationality : Indian
Languages : English, Tamil
Marital status : Married
E-mail : **************@*****.***
Address : 10121,Woodberry Trail Lane, Apt 624, Charlotte-28262,North
Carolina,USA.
Declaration:
I hereby declare that the information given above is true to the best of my knowledge.
Contact this candidate