Nandakumar V
Email id : nandyceg@yahoo.co.in
PhoneNo. :9538908434/9600440939
Objective
I am an enthusiastic and dedicated ...
Certified Banking Industry Generalist - completed on March 08, 2013
Certified in Credit cards for Banking -completed on Ja...
Client/Company: Bank Of America/Accenture
Project : AMCDI (Account ManagementCustomer DataIntegration)
Project Duration : ...
Skills: Datastage/Autosys
Role:
 This module was a data integration project which enables the business to improve account...
 Apart from developing data quality rules, I also involved in production support for the jobs of
db2/vertica, UNIX and da...
Role:
 Developing datastage job to process the incoming files load to staging tables.
 Preparing CLIs for framework and ...
of 6

Nandakumar_V_datastage

Published on: Mar 3, 2016
Source: www.slideshare.net


Transcripts - Nandakumar_V_datastage

  • 1. Nandakumar V Email id : nandyceg@yahoo.co.in PhoneNo. :9538908434/9600440939 Objective I am an enthusiastic and dedicated person who is flexible and believes in team spirit, witha passion for knowledge in the ever-changing world of InformationTechnology, Seeking a position to utilize my skills and abilities in a challenging environment that offersprofessional growth while being resourceful, innovativeand flexible. Academic Profile COURSE INSTITUTION EXAMINATION AUTHORITY MONTH & YEAR OF PASSING B.Tech College Of Engineering, Guindy, Anna University,Chennai Controller Of Examinations, Anna University May 2010 H.S.C Don BoscoHr sec school Tamilnadu State board May 2006 S.S.L.C Don BoscoHr sec school Tamilnadu State board May 2004 Software Exposure  Tools:Datastage(ETLtool),Cognos(Reportingtool)  Programming :C,C++ and JAVA  DatabaseManagementSystems :Oracle,DB2and Vertica  Scripts:Shell, PERL,Pythonand JavaScript  Web technology:HTML,ASP and JSP.  PlatformsFamiliar:Windows(XP,7),UNIX and Linux.  Scheduling tools:Maestro& Autosys Areas of Interest  Application Development/Datawarehousing/Data quality Certification IBM Cognos BI Author - completed on January 12, 2013
  • 2. Certified Banking Industry Generalist - completed on March 08, 2013 Certified in Credit cards for Banking -completed on January 15, 2015 Awards and Recognitions  Have won the Topper of the batch award in Accenture Greenfield Training.  Have won ACE (AccentureCelebrates Excellence) award forQ3 2014 for Excellencein Business Operation.  Received monetary awards forcreating reusable utilities. Employer Details Accenture Services PvtLtd 15 Jun 2010 to current Cognos/DATASTAGE/DB2/VERTICA/UNIX
  • 3. Client/Company: Bank Of America/Accenture Project : AMCDI (Account ManagementCustomer DataIntegration) Project Duration : Aug2013– Dec2013 Standard Role : Datastage Developer Client/Company: Bank Of America/Accenture Project :C3PM(Core Consumer Card Platform Migration) Project Duration : June 2014– May 2015 Standard Role : Datastage Developer Skills: Datastage/DB2/Vertica/Autosys/QC Role:  Migrated the sqls running in db2 to vertica.  Worked on analysis on translation from existing source system to new source for bank credit card datawarehouse.  Migrated scripts and Datastage jobs to use new source and tested.  Worked on testing and comparison the data between pre and post migrations of C3PM and captured results in QC.  Creation of CLI scripts & JIL code for autosys required to schedule the jobs using autosys scheduler. Client/Company: Bank Of America/Accenture Project : ECRIS (Enterprise credit risk Information Managementsystem) Project Duration : Jan 2014 – May 2014 Standard Role : Datastage Developer Skills: Datastage/DB2/Autosys Role:  This project deals with extracting the files from the tables in upstream and performing data quality checks on the file feeds sent to the downstream systems  It had 4 modules specific to different categories of consumers i.e. elite class, customer treasury data mart  During this project I have worked on creating Jobs which performs transformations on the columns received in the feed.  Developed sequencers to incorporate the scripting part.  Creation of CLI scripts & JIL code for autosys required to schedule the jobs using autosys scheduler.
  • 4. Skills: Datastage/Autosys Role:  This module was a data integration project which enables the business to improve account management decision capabilities.  Leveraging the valuable customer risk data which will help enable automated decision environments to provide better differentiation of risk.  During this project I worked on creation of jobs.  I developed sequencers for 3 modules.  Creation of CLI scripts & job & schedule definitions required to schedule the jobs using Maestro scheduler. Client/Company: Bank Of America/Accenture Project : Data Qualityand Reporting Project Duration : Oct2010 – August 2013 Standard Role : Report Designer/Developer Project & Role Description Data quality process is primarily to execute the rules on Bank’s warehouse data on monthly /daily /weekly basis and provides the output in form of cognos reports that helps the business people to determine the quality of data in Banks warehouse and make necessary actions to ensure the quality. This process is also developed to validate values in Extracted files from datastage jobs. Skills: UNIX/Shell scripting/DB2/Vertica/Cognos/Maestro Role: My primary role is to develop the cognos reports which can be used by business people to monitor data quality run statistics.  Automating the process improvements by creating reusable utilities using java.  Involved in creating the UNIX shell scripts that loads the data from source tables to Temp table which the data quality rules executed on.  Develop SQL Code for data quality rules which would be executed on Bank Data Warehouse housed in vertica and db2.  Also worked in DBA activities in vertica and db2.  Develop Autosys Jobs for scheduling the data quality rules on monthly /daily /weekly basis.  Directly interact with the client and handle weekly status meetings.  Involved in gathering requirement from business end users to satisfy their report requirements.  I also got the responsibility to develop data quality rules and deploy them to production.
  • 5.  Apart from developing data quality rules, I also involved in production support for the jobs of db2/vertica, UNIX and datastage running in maestro and autosys.  Also maximized the sol query performance by applying partitions techniques on the temp tables so that I reduced total execution time of query executed by data quality rules.  Monitored production Data Quality jobs and taken respective actions for issues happened and got appreciations from client team.  I emphasized on process improvements by creating reusable components in form of shell script/macros.  Worked in datastage for extracting and transforming data from bank warehouse to generate extract feeds sent to downstream.  Created the reports using congas for data quality process. I had a chance to work in all the phases SDLC life cycle (from requirement gathering, development, Testing and migration to production server).  Understanding the business requirements and designing reports to meet their needs.  Development of reports include List Reports, Cross tab Reports, Chart Reports, Drill -Through Reports, Drill down reports and Dashboards.  Have used Drill-through Definitions, Rendering Variables, and Conditional blocks, Grouping and Sectioning, Filters etc...  Have developed scorecards and dashboard reports and received client appreciations/awards.  Created Test Cases and did Unit Testing of the Reports.  Created different types of reports and involved in enhancements of the existing reports with new requirement.  Deployed migrated reports between Test and production environments.  Performed user acceptance tests and make sure that each report is approved.  Responsible for end user training in production for better understanding.  Preparing the Problem Analysis documents for better understanding and for future reference.  Scheduled reports for running at a certain time, such as week, month, etc. Client/Company: Bank Of America/Accenture Project : RDA(Risk DataAggregation) Project Duration : June 2015–Current Standard Role : Report Designer/Developer
  • 6. Role:  Developing datastage job to process the incoming files load to staging tables.  Preparing CLIs for framework and schedule the jobs using the autosys.  Add jobs to validate header and trailer records for each file processing job sequence.  Preparing sqls for loading staging and permanent tables. UG Project Details 1.Library Management - Prama Rajeshwari(professor) Software used:Java,Oracle 2.Patient Billing Software(IBM TGMC 08) - Indhumathy(professor) Software used : IBM DB2, WASCE, Java 3.Mobile Application - Swamynathan(professor) Software used: Visual studio 2005(C#.Net & Mobile Simulator),Msaccess 4.Web Application in Mobile - Swamynathan(professor) Software used: Visual Studio 2005(Asp.net,C#.net,Mobile Simulator),MSaccess Personal Profile Date ofBirth : 11-May-1989 Father’sName : Veerabatran D Phone no : 9538908434/9600440939 Residential Address : 13/7,Arcot st, T.Nagar Chennai-600017

Related Documents