Re-platforming of client's legacy DB2 based data warehouse onto big data Hadoop Operational Data Source and Oracle Exadata based data lake to serve as an analytical sandbox to support business analytics, operational analytics, financial risk analytics and provide effective client reporting. Responsibilities:

• Design and develop data ingestion procedure using IBM Datastage to import data from legacy systems (DB2, AS400) through CDC and load onto HDFS operational data source.
• Code SQL executed against Impala to perform data transformation onto Hadoop.
• Code Oracle SQL stored procedures to transform the incremental operational and load ready data onto the enterprise relational model.
• Design and develop Hadoop control framework consisting of Control-M, run service and spring batch components for workflow management.
• Design and develop regular table partition maintenance process for effective stream execution.
• Participate in presales initiatives by responding to RFPs/RFIs for application re-engineering solutioning.
• Design and develop Cobol-DB2 based batch scheduled components to provide history and incremental transactional and positional data to clients on daily basis.
• Participate in system version and infrastructure upgrades and ensure no adverse impacts to application processes.
• Customer relationship management by being single point of contact for any client queries related to the vendor portfolio engagement. 2
• Project management activities such as SOW creation, client invoice management, status tracking and reporting to internal and client stake holders.
• People Management tasks such as conducting annual appraisals, team training and upskilling etc. Senior Technical Architect Client
• Leading Banking and Financial Asset Management Services Provider JAN 2015
• JUN 2018
• Client Delivery Application is a legacy DB2 based data warehouse responsible for processing and storing transaction and valuation holdings information to be made available for client reporting and for various internal processes. Source accounting engines residing on AS400 i-Series box feed the transactional data which is interfaced with other system of record applications to create relational data used for client reporting and internal processing. Responsibilities:
• Involved in all phases of Software Development Life Cycle (SDLC) including design, development, enhancement, migration and testing of applications using COBOL, JCL, DB2, TSO/ISPF, REXX, Batch scheduling, Expeditor, SCLM.
• Coded and tested new modules and Implemented code changes in applications according to coding standards in COBOL-DB2 with exposure to DB2 utilities.
• Coded SQL Stored procedures including native SQL stored procedures, worked on DB2 functions and objects, referential integrity, Cursors, Triggers, Views etc.
• Created new/Changed existing JCL's and Procedures.
• Worked on FTP transmission to send files from one system to another. Client Delivery Application is a legacy DB2 based data warehouse responsible for processing and storing transaction and valuation holdings information to be made available for client reporting and for various internal processes. Source accounting engines residing on AS400 i-Series box feed the transactional data which is interfaced with other system of record applications to create relational data used for client reporting and internal processing. Responsibilities:
• Involved in all phases of Software Development Life Cycle (SDLC) including design, development, enhancement, migration and testing of applications using COBOL, JCL, DB2, TSO/ISPF, REXX, Batch scheduling, Expeditor, SCLM.
• Coded and tested new modules and Implemented code changes in applications according to coding standards in COBOL-DB2 with exposure to DB2 utilities.
• Coded SQL Stored procedures including native SQL stored procedures, worked on DB2 functions and objects, referential integrity, Cursors, Triggers, Views etc.
• Created new/Changed existing JCL's and Procedures.
• Worked on FTP transmission to send files from one system to another. Client Reporting and Delivery application involves generation of periodic scheduled as well as on demand data reports and delivered to client through various channels such as flat files transmission, hard copy reports as well as SWIFT messages. The application uses suite of meta-data tables along with the source transactional tables to report client holdings and valuations. 3 Responsibilities:
• Understand client's requirements for application enhancement/capability enhancement and design solutions to meet these requirements.
• Coded and tested new/existing modules and Implemented code changes in applications according to coding standards in COBOL-DB2.
• Created new/Changed existing JCL's and Procedures.
• Coding and scheduling of batch jobs to run at designated intervals with proper predecessor-successor relationship.
• Worked on FTP transmission to send files from one system to another.
• Monitoring the batch jobs and resolving the abends. Mainframe Developer
• Technical Lead Client
• Leading Credit Card Services Provider, Phoenix, AZ AUG 2006
• MAR 2011 Summary
• Rebates and Rewards platform was responsible for computing and awarding of reward dollars for various suite of card products. Project involved development of on demand redemption capability and banking of reward dollars for card members. Responsibilities:
• Involved in all phases of Software Development Life Cycle (SDLC) including design, development, enhancement, migration and testing of applications using COBOL, JCL, DB2, TSO/ISPF, REXX, Batch scheduling, Expeditor, SCLM.
• Coded and tested new modules and Implemented code changes in applications according to coding standards in COBOL-DB2 with exposure to DB2 utilities.
• Created new/Changed existing JCL's and Procedures.
• Quality control through reviews and end to end testing. Defect tracking in Quality Centre.
• Thorough and