Bharath Rajan
*************@*********.***
Mr. Bharath Rajan is a senior IT professional with extensive experience as a program/project manager/leader, architect and applications software developer in a variety of industries including brokerage/securities, sales & distribution, financial systems, insurance, manufacturing and logistics.
He has worked as a business partner with client leaders and users to evaluate/improve business processes and arrive at mutual, cost effective solutions. Has supported, advised, assisted and resolved business and technical problems for client leaders. Extensive exposure in the evaluation and implementation of third party software solutions, prototype development, etc,. Extensive exposure to strategic planning, prioritizing, and managing or leading small and large projects and teams onsite and offshore.
Proven interpersonal, written/verbal communication, organizational and leadership skills.
Substantial experience with and knowledge of current information technologies and business functions.
Work Experience:
-15 Years of Project management/Lead experience.
-15 Years of Solutions Architect in an IBM midrange environment
-25 Years of Applications Development – Brokerage, ETD/OTC, Insurance, Distribution, Finance
Functional: Program/project management, systems analysis & design, business/technical
consulting.
Training: SAPR2/R3 (FI) and ABAP/4 programming. GENTRAN EDI
Working
Knowledge: Logical Partitioning of iSeries (LPAR)
Web-based applications, CGI, Net.Data
HTTP Server setup for iSeries web based programming
HTML, XML, PCML, etc,.
Sockets programming, JDBC/ODBC connections to iSeries/AS/400,
MQ Series, and Websphere Development Tools .
Linux
Languages: Free Form RPGLE, SQL, CLLE, C/400, COBOL/400, CL, Java, SAP R2/R3 ABAP/4, Unix Shell Scripts, Python 3
RDBMS: DB2 UDB, MS ACCESS
ISeries Tools: QUERY/400, QM(Query Manager),
AS/400 Tookbox For Java, AS/400 Developer Kit For Java,
HAWKEYE, DBU, HARMONIZER,UFTP, PKZIP, MPLUS,LANSA
Access Tools: Client Access (iSeries Access)and Operations Navigator, Rumba
PC Tools: Lotus Notes, MS Access, Excel, Visio, WORD, etc,.
Project MS Project, PVCS Tracker, JIRA, Confluence
Tracking:
Change Mgmt: ALDON (CMS), IMPLEMENTER, TURNOVER
ERP Systems: Sungard GMI, HFA, Genelco - HBMS (Insurance/Billing/Commissions),
CGAS (Compass General Accounting System), Imrex Distribution System
And JBA
Operating
Systems: OS/400, UNIX, DOS, WINDOWS (Windows 98/Windows NT/Windows XP),
CP/M.
Hardware: IBM iSeries/AS/400 ILE, DEC VAX, UNISYS (A Series), ICL 2904, PC’s, Mainframes
EDUCATION:
PGDBA( MBA) in Systems Management
BS
Certificate in Systems Analysis/Design
PROFESSIONAL EXPERIENCE:
ETD/OTC GMI
-Business analysis, solutions architect
-Change management (ALDON, TURNOVER, IMPLEMENTER)
-Release management
-Client Reporting, Reconcilliation, Exchange mandated Reporting (CME, CBOT, NYMEX, ICE)
-GL, FX Pricing, IRS Reconcilliations and long positions/margin reporting, Exercise/Assignment, Custom Prelims
-Data Conversion, migration to downstream systems (SAP GL, Clearvision, GAPP)
-Static Data setup
SNB Technologies Inc – 10/01/2015 – To-Date
Training in Hadoop Big Data, Python
Aldon Configuration & Setup
SQL Server SSRS Development – Dashboard & Scorecard Reporting
Goldman Sachs, Chicago – 05/04/2015 – 09/17/2015
Was engaged as a senior consultant in the Technology team of Goldman Sachs responsible for design and development of GMI applications in an AS/400 environment utilizing RPGLE, RPGIV, SQL, CLLE and Java.
-Designed a framework for Open Interest Vs Large Trader reconciliation and exception reporting for Compliance & Regulatory group at Goldman Sachs. Developed sql scripts and programs under this framework to generate reports for ICE EU and extend it to other markets.
-Automated mass update of CFTC reporting levels for accurate Large Trader reporting as per Compliance and Regulatory requirement.
Sungard Data Systems, Chicago – 11/21/2013 – 10/31/2014
As a senior consultant to the Sungard Custom Development team is responsible for delivering custom development projects for JP Morgan, Citi Group, BMO Harris, Wells Fargo. Directly reporting to Vice President of Sungard Custom Development. Extensive exposure to Sungard GMI core modules and customization for Sungard’s clients. GMI is a backoffice system that runs on AS/400. All applications are in an AS/400. Development of applications were done utilizing RPGLE, RPGIV, SQL, CLLE and Java.
UBS, Chicago 07/02/2012 -11/15/2013
Engaged as a senior Sungard GMI consultant in the UBS Remediation project.
-Responsible for process improvement
-Change management process design, configuration and setup of TURNOVER.
-Bespoke code development involving GMI modules
-Automation of GMI UPFUTM, MMRUN and changes handled as a checkout/checkin via Turnover
Development of applications wree done utilizing RPGLE, RPGIV, SQL, CLLE and Java.
Group Manager – Apps Delivery, Mphasis – An HP Company, New York 12/26/2006 –06/15/2012
JP Morgan, Chicago engagement
Responsible for the overall management of the MphasiS onsite/offshore JP Morgan IB Tech F&O Engagement. Responsible for efficiently and successfully launching the Mphasis team for the JP Morgan F&O Sungard/GMI engagement along the lines of Mphasis’s onsite-offshore model. Responsible for managing the onsite/offshore development team, delivery timelines, and partner with JP Morgan management to successfully manage and deliver strategic/tactical projects in the Futures & Options line of business for the firm. Additional MphasiS responsibilities include client relationship building, identify and generate revenue streams for MphasiS, assist in RFP, offer consulting advice to other MphasiS teams.
GMI-CR project
Primary responsibility includes design/development/testing and delivery of assigned GMI related applications, Change Requests. GMI is a backoffice system that runs on AS/400. All applications are in an AS/400. Development of applications wree done utilizing RPGLE, RPGIV, SQL, CLLE and Java.
Independent Consultant, Chicago (04/30/2004 – 11/15/06)
As an independent IT consultant, was engaged in a number of contractual assignments for clients in the insurance, automobile and hospitality industries.
OWI - Was responsible for effectively managing the design and development and implementation of financial applications related to and enhance the HFA ERP system for OWI. Directly reporting to the Director Of Financial Applications.
Shell Vacations – Was a consulting iSeries architect responsible for architecting a Java based solution for connecting data mart tables residing on a SQL server database to data mart tables on DB2 residing on the iSeries.
CNA Insurance, Chicago (05/07/2002 -12/30/2003)
Role: Project Management /Technical Architect
Westport Benefits Data/Applications Migration Project
Project management responsibilities over a team of 15 members. Responsibilities included developing the Westport Benefits Transition Plan, Westport Benefits Applications/Data Migration/Conversion Project Plan.
Oversee the overall data/applications migration effort and make sure all the tasks are proceeding as per project plan. Handle immediate issues/concerns that is critical to the project.
Interact with other CNA groups to ensure corporate wide infrastructure, security, software directives are met for the transition/migration connected with choice of hardware/software, data security, network architecture, etc, .
Manage/coordinate the transition project team members which include TOG (Technical Operations Group) and Group Operations. Monitor TOG and other related status of tasks related to the migration.
Monitor status, issues, concerns, identify task assignments and follow up to ensure a smooth implementation
and transition.
ISeries Data Center Hosting Project
Role: Project lead/Technical lead responsible for the analysis/design of iSeries data/applications security setup and administration, backup/recovery procedures, BRMS setup for CNA’s LPAR'd iSeries at iStructure, disaster recovery planning, setting up system values for the new iSeries based on CNA’s requirements. Was involved with systems engineering/administration functions for CNA’s iSeries hosted at iStructure facilities in Omaha, Nebraska. Setting up Job Scheduling scripts using ROBOT/400. Setting up pagers, messaging/monitoring for CNA’s jobs on the iSeries at iStructure using MPLUS. Provide assistance to iStructure system engineer for design and intial setup all system administration/technical activities to cater to CNA’s requirement.
Extensive exposure to TCP/IP, system engineering/administration activities for the iSeries.
Installation/configuration of ALDON CMS on the iSeries. Planning/analysis and implementation of ALDON CMS on iSeries.
Developing testing strategies and ad-hoc utilities to aid testing effort.
Automation of HBMS modules (Billing and Commissions)
Automation of HBMS (Premium Benefits Software package - Vendor - Genelco) Billing & Commissions modules. Customisation of HBMS programs for List Bills.
Setup Client Access file transfers for export and import of Excel spreadsheets into iSeries database tables and linking to Access databases at CNA.
Worked with the CNA Portals and Data Warehousing and SQL Server Database teams to build Proof Of Concepts and prototype solutions for cross platform systems integration with iSeries through Java/ODBC/JDBC technologies.
iSeries (SME) for projects involving HBMS processes/data conversion of Suspense Databases from Access to Oracle with feeds from iSeries applications, creation of E-R diagrams for iSeries database
iSeries Data/Applications Security Setup and Administration, Database Administration, Performance Tuning
Mentoring/training CNA’s IT support team on iSeries technology,
ILE, RPG/IV/III/400, COBOL/400 and CL programming.
Unix Shell scripting, FTP scripting, DB2/400, iSeries Systems Administration.
Research/Analysis of HBMS processes for future CNA projects.
Authoring a HBMS/iSeries Systems Administration/Operations manual for CNA Group Operations
Mentoring Group Operations team with iSeries technology, CL scripting, ILE, embedded SQL, FTP scripts, testing strategy, etc,.
Abbott Laboratories (Abbott Park, IL) (01/10/2002 -04/30/2002)
Role: Senior Consultant
Development of a Product Cost Analysis database using DB2 tables and SQL/400 on the iSeries. Extensive coding of modules, service programs, in ILE RPGIV, embedded sql and stored procedures. The project involved writing stored procedures on the AS/400/iSeries called from web browser or visual basic front end screens using ODBC connections to the iSeries, email messaging from iSeries to Lotus Notes. Extensive RPGIV and sql coding. Native AS/400/iSeries “green screens” were totally eliminated.
Nestle Clinical Nutrition (Deerfield, IL) (11/13/2000 -10/03/2001)
Role: Senior Consultant
Responsible for the design and development of online/batch data gathering and maintenance programs for the Nestle Data Warehousing system, Pricing Engines, EDI, etc,.
Analysis and recommendations, development and implementation of online and batch programs for the Nestle data warehousing files used by the Master Data Team. Extensive exposure to healthcare related contract/group information processing, complex management reporting through interactive and batch queries through embedded SQL and Query/400 applications. Also designed and developed a small scale objects/source implementation utility for Nestle’s requirements. Documented the various nightly processes using Visio for future references as an extensive system flow chart.
Infoware Inc (Rosemont, IL) (01/1998 - 09/2000)
Role: Senior Consultant
Responsible for design, analysis and development of applications in an AS/400 ILE RPG/IV or COBOL/400 environment for Infoware clients which include Cole Parmer, Humphreys, TOPCO, etc.
Cole Parmer (Vernon Hills, IL)
Designed and developed the Order Entry and Maintenance system in an AS/400 ILE RPG/IV environment. All modules, procedures/functions service programs were developed in ILE RPG/IV.
Designed a complex comments module in ILE RPG/IV to be used by any of the applications used by Cole Parmer. Extensive use of pointers, userspace and data queues and APIs.
Humphreys (Chicago)
Solely responsible for the the decompilation of the Systems Management module of the JBA software. The source code for the systems management module was lost and so the primary focus was to make the software work. There was a lot of interaction with a third party tool and their service to derive the source RPG/400 problem. The problem stemmed from the object code, which was then modified to make the system work.
TOPCO (Skokie, IL)
Wrote interface programs for a PeopleSoft Financial module and data migration from the AS/400 to the Peoplesoft Financial module residing on another platform.
Interacted with the PeopleSoft financial consultants and helped them prepare for the implementation on the AS/400 starting with the General Ledger system by developing several interface and data conversion programs.
Bear Stearns (Chicago) (06/1995 - 11/1997)
Role: Consultant
Designed and developed a number of server side modules in a three-tier client server environment. Used an object oriented approach in the design and development of functions, procedures, modules in AS/400 ILE. This project involved the design and development of front end/server side code for the trade entry/order processing system. Extensive coding of modules, service programs, use of pointers, userspace, user/data queues, and APIs were involved. Extensive use of pointers, userspace, user/data queues, and APIs were involved. Worked with the design of price feed from the AS/400 to requests from PCs, mainframes, handhelds and Web Based applications.
Chicago Park District (1994 - 1995)
Role: Project Lead
Project lead for a data conversion project - AS/400 to Unisys A Series financial system.
Solely responsible for the leading the conversion effort of financial data (GL, AR and AP) from the AS/400 to the Unisys A Series system.
Interacted with 4 senior Unisys financial consultants and 6 team members to lead the effort in financial data analysis, conversion and transportation from the AS/400 to the Unisys A Series system.
Price Waterhouse Coopers (previously Coopers & Lybrand) (1992 - 1994)
Role: Project Team Lead
Project Team Lead for AS/400 team consisting of 3 consultants and 4 inhouse functional managers.
Design and development and delivery of an Actuarial database.
Development of a Distribution Logistics System using LANSA case tool.
Responsible for the design and development of screens, files, entry/maintenance functions, and report distribution modules.
IBM Chicago (1992)
Role: Consultant
As a SME completed a performance evaluation of a LANSA based Order Entry system.
Prepared and submitted an extensive report with recommendations for IBM's client.
Whitman Hart, Chicago (1991 - 1992)
Role: Analytical Consultant
Involved in the analysis and development of a Preventive Maintenance System for Catterpillar, Peoria, IL in an AS/400 environment.
Computer Horizons Corporation, New York (1988 - 1991)
Role: Consultant
Responsible for the design and development of applications on the S/38 or AS/400 systems.
All design and development was done with RPG III and COBOL
IMREX Systems, Great Neck, New York (1987 - 1988)
Role: Consultant
Responsible for the customization of the Imrex Distribution System for their client Yves Saint Laurent.
This was accomplished by utilizing IBM S/38 and RPG III.
Advent Computer System (1983 - 1987)
Role: Consultant
Responsible for application software development for the firm's clients in the UK and Australia for the S/38 platform using RPG III, COBOL and FORTRAN on CP/M based systems.