Atul Hatode
As a Technical Architect I am having 15 years of experience in analysis, architecture, design and development of software solutions, and managing projects and teams under multi-cultural, multi-geographic environments in Banking and Financial Industry. Main straights include strong analytical and problem solving skills with the ability to priorities and oversee multiple complex tasks in dynamic business environments.
Profile Summary
· Domain Expertise on Investment Banking, Institutional Brokerage, Capital Market.
· Expertise in process oriented aspects of Software Development Life Cycle.
· Trained on Ralph Kimball Data Warehouse Lifecycle Tool, TOGAF (The Open Group Architecture Framework), Zachman-Framework, Methodologies and Participated in the Defect & Problem Prevention meetings.
· As Business System Analyst (BSA) Interacted with End Client for requirement gathering, validating and documenting business case, business requirement and prefeasibility analysis for past 10 years.
· Proficiency in Analysis, Design and Preparing Pre-Feasibility. Proficiency in preparing SOW Cost Resource Profile, Time & Materials - Price and Payment Profile, process models & software (i.e. SEI CMM, CMMI).
· Understand the High-Level business Document (HLD) for change request and write the Pre-Feasibility document.
· Experience of working in USA, UK, India and Australia.
· Holding H1B Visa valid till Sep, 2014.
Hardware and Software Environment
Hardware : Oracle, IBM Mainframe, AS/400 & UNIX.
Operating System : OS2, OS/400 & UNIX.
Skills/Tools : PL/SQL on Oracle and DB2, Store Procedure, IBM Optim Data Studio/Optim Development Studio (ODS), DB2 9 for LUW (Linux, UNIX, Windows), COBOL, DB2, DB2/400, CICS, JCL, VSAM, FileAid, Control-M, Changeman, Expediter, Intertest, ERWIN, RPG/400, Training on Informatica Power Center 8.6.1 and Power Mart.
Business Domains : Banking Domain in specific to Investment Banking, Institutional Brokerage, Capital Market & Credit Cards, Telecommunication and Finance.
Academic Qualifications
Qualification / Year / Major / InstitutionBachelor of Commerce / 1992 / Accounts & Finance / Mumbai University
Diploma in Computer Software Technology / 1994 / Cobol, Assembly / Mumbai University
Certificate of Proficiency / 1998 / IBM AS/400 / Concourse Mumbai
PROFESSIONAL EXPERIENCE
May, 2011 till Date JP Morgan Chase, New Jersey, NJ
Project Name : Data Migration Project for Corporate Internet Group.
Environment : Oracle & DB2 on LUW (Linux, UNIX, Windows)
Skill/Tools : IBM Optim Data Studio/Optim Development Studio (ODS), PL/SQL on Oracle & DB2, Store Procedure, DB2 9 for LUW (Linux, UNIX, Windows), Used Advance features like Dynamic SQL, Bulk Collect, Global Temporary Table, Performance Tuning, Analytical functions, Hierarchitical Query, SQL*Loader, SQL Optimization, UNIX Shell Script, Training on Informatica Power Center 8.6.1 and Power Mart.
Role : As a Specialty occupation position of “Technical Architect and Data Architect” responsible for interacting with client and involved in functional and technical requirement gathering; implementing and migrating custom application to the new system; developing and delivering management consulting and strategic technology infrastructure solutions for various environments; business requirement gathering for business product migration, studying business case and doing prefeasibility study. The Migration Project from Oracle to DB2 Architecture designed with Data Staging, OLAP, and Data Integration using SSIS for Integration Services using ERwin for analysis of Data Mining and Data Design created.
Description :
JP Morgan Chase is a leading global financial services firm specializing in investment Banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.
I am involved in the development and customization of the company’s retail payment system, which aims at developing an electronic platform which will facilitate fund movement and payments for retail customers and large institutions. The system would also provide an interface for various billers to enable quick and timely payments of bills to their customers.
Mar, 2010 to Apr, 2011 Telstra, Pune, India
Project Name : LycaMobile Project
Environment : Mainframe
Skill/Tools : IBM Optim Data Studio/Optim Development Studio (ODS), PL/SQL, SQL*Loader, SQL Optimization, JCL, COBOL, DB2, Control-M.
Role : As a “Technical Architect” for LycaMobile Project for Telstra. Preparing Project Plan, Preparing SOW, Resource Planning, Financial Estimation, Client Meeting, Project Forecast, Assigning Roles and Responsibilities, Organizing Training, Interviewing Resources, Backup Planning, Providing Functional Solution, Preparing Weekly Forecast Matrix, Planning Deliverables and Assigning Targets.
Description :
Lycamobile is looking to provide a low cost mobile offering in the Australian market primarily targeting ethnic market segments with high international call patterns.
Lycamobile is looking for a low cost of entry through an MVNO model that will provide roaming on the Telstra GSM network while using HLR for customer fulfillment and prepaid SCP for customer billing.
Telstra or Telstra Corporation Ltd is an Australian telecommunications and media company, formerly owned by the Australian government. Telstra is the largest provider of local and long distance telephone services, mobile services, dialup, wireless, DSL and cable internet access in Australia. Telstra is based in Melbourne, Victoria, Australia.
Digital Business allows customers to share their various fixed voice, mobile voice, mobile data, TMB and TBB included allowance between services within a customer account.
Sep, 2009 to Jul, 2010 Telstra, Pune, India
Project Name : MARS (Message Access Rating System)
Environment : Mainframe
Skill/Tools : IBM Optim Data Studio/Optim Development Studio (ODS), PL/SQL, SQL*Loader, SQL Optimization, JCL, COBOL, DB2, Control M, TOGAF Framework & Zachman-Framework Training.
Role : As “Architect” on MARS Application of Telstra. Provide Design/Architectural and functional solution for BI. Approve technical solution. Maintain data/structural integrity of DB2 databases. Functional inputs, drive application team through Solution Definition & Business Architect, deliverables for Solution Definition & Business Architect phase. Provide service to Telstra Clients like OPTUS, VODAFONE etc. Working with Business Unit to providing solution & data for business study and creating use cases.
Description :
MARS is the wholesale rating and billing system for interconnect calls which are passed between Telstra and other carriers such as OPTUS, VODAFONE etc. MARS calculates the Access Charges payable by other carriers to Telstra for provision of this Service. MARS also calculates the Access Charges to reconcile against other carrier invoices to Telstra.
MARS is the system that currently performs Interconnect Rating for Telstra. The rated information is then passed to Flexcab on a monthly basis to create a bill to be distributed to other Carriers.
Jan, 2009 to Aug, 2009 Western Union, New Jersey, NJ
Project Name : Data Warehouse Management (DWM)
Environment : AS/400
Skill/Tools : CL, DB2/400, SQL, Query/400, Cobol/400, Ms. Visio.
Role : As a “Technical Consultant” on Data Warehouse EIM Application (Enterprise Information Management). Activities performed are Project Transition, Onsite Coordinator, Requirement Gathering, Client Meetings and Knowledge Transfer to Best-Shore Resources.
Description :
EIM (Enterprise Information Management System) consists of two major functional areas of Information Management: One is Data Management layer which known as Data Warehouse Management (DWM) and second one is the Business Intelligence front-end analysis and access tools and applications which known as Decision Support Systems (DSS) using OLAP, Data Staging, Data Mining techniques.
DWM is responsible for the design, administration, and maintenance of Western Union Business Information System’s single data warehouse repository of most business information collected on the iSeries. Its primary purpose is to make data available for data access to perform business analytics without compromising the back-office operational systems, as well as corporate data security rules and privacy guidelines.
DW is based on principles of Business Intelligence, Business Object; data is Extracted – Transformed – Loaded (ETL) in the system. The ETL is essential for providing data that is validated and integrated to enable efficient analysis and to ensure a single-version-of-the-truth.
Feb, 2008 to Jan, 2009 The Reserve, New York, NY
Project Name : Insured Deposits
Environment : IBM Mainframe
Skill/Tools : JCL, DB2, CICS, VSAM, Ms. Visio.
Role : As “Technical Consultant and Business System Analysis Expert” on Insured Deposit in Investment Banking. Onsite Coordinator, Estimation of Change Request, Work Allocation to Offshore, Providing Status Report for Application Collecting Matrix on Monthly Basis, Insuring Adherence to SLA(Service Level Agreement), Meeting with Application Managers, Preparing Pre-Feasibility Document, Managing Risk and Issues for Application, Analysis of requirements, Design as per requirements, Contribution to peer reviews and code reviews.
Description :
Study Shareholding Accounting System, Bank Accounting System, Insured Deposits System and Statement & Reporting System business of the client; prepare System Appreciation Document for the application; providing Maintenance and Support of the Application; resolve SIR (System Investigation Request) tickets.
Sep, 2005 to Jan, 2008 Commonwealth Bank of Australia, Sydney, Australia
Project Name : Bankcard System (Credit Cards Domain)
Environment : IBM Mainframe
Skill/Tools : JCL, COBOL, DB2, VSAM, Control-M & CICS
Role : As “Technical Architect and Business Analyst” on Credit Cards (Banking Domain), understand the Business Requirement, Prepare Design Specification and Provide Business Resolution using Basel I and II rules for risk mitigation.
Description :
Provide Maintenance Services to Bankcard System (Base2000), Authorization (Guidance) System, Network Application, Napersoft Application. Other Application Supported is Merchant and Distribution System. Being to Sydney to acquire knowledge and provide on job support to MasterCard, Visa & Bankcard Credit Card vendors; also worked on implementation of Agile Cards Utility System.
Feb 2005 to Sep 2005 Certegy, Boston, MA
Project Name : Bankcard System (Credit Cards Domain)
Environment : IBM Mainframe
Skill/Tools : JCL, COBOL, DB2, VSAM.
Role : As a “Technical Analyst”, analyze the program, find the defect and provide resolution.
Description :
Project is to provide Maintenance Services to Bankcard System (BASE2000) of Certegy, the Maintenance in terms of Defect fixing and Enhancement of Bankcard System. Bankcard System raises tickets in Test-Director maintaining the details of the defect information. This defect may occur in any of the 3 Mainframe systems of Certegy location (i.e. - St. Pete, Clayton and Warwick). We have to logon to those system to resolve the defect. These defects are segregated in to Batch, On-line and Service View. Bankcard System does data processing for Visa, MasterCard, American Express and Europay Credit Cards based on rules set by them. This credit card institution has subscribers all over the globe. This subscribers uses the system 24 X 7 to get there Credit Card processed as per their requirement. Certegies Bankcard System handles this processing.
Nov 2004 to Jan 2005 ManuLife Insurance & John Hancock, Boston, MA
Project Name : Stardust Migration from IBM Mainframe to SQL Server
Environment : IBM Mainframe and SQL Server
Skill/Tools : Oracle, DB2, IBM Optim, PL/SQL, SQL*Loader, MQ-Series, VSAM, Control-M, JCL, COBOL, SSIS.
Role : Onsite Consultant in USA. Client Interaction, System Study, Conference Call.
Description :
Activities performed are Migration of Stardust System from Mainframe to SQL Server. Analyze the complete COBOL source code, jobs, stored procedures, data sets, I/O flat files and reports to under stand the business logic and data flow to write specifications at procedure level. Reverse Engineer the COBOLprograms in the current systemand produce the Program specification design documents for the TSQL procedures. Identify and document the conversion issues that may arise from JCL to PC based batch scripts and document the solutions for each issue. Convert the objects and data from the DB2 database to SQL server. And reengineer all the TSQL procedures to SQL Server Store Procedures.
Jul 2003 to Oct 2004 Fidelity Investments, Mumbai, India
Project Name : ICS Backend Project
Environment : IBM Mainframe
Skill/Tools : IDMS, DB2, MQ-Series, PL/SQL, SQL*Loader, JCL, VSAM, COBOL, SAS, Control-M.
Role : Programmer Analyst and Business Analyst – Reverse Engineering for B2B Module
Description :
Fidelity Brokerage and Technology Company need to consolidate the two systems into Integrated Customer System (ICS). The present two systems viz. Customer Accounts and FBSI name & address has redundancies within themselves. Consolidation of the systems would result in Fidelity saving on the efforts to maintain these systems and in training the users. The business logic functions could be reused, making the system maintenance and enhancements cheaper and faster, thus reducing the time-to-market for new products and Migration of database from IDMS to DB2.
Jul 2002 to Jun 2003 JC Penney Company, Inc., New Delhi, India
Project Name : Inventory Management Systems
Environment : IBM Mainframe
Skill/Tools : JCL, IMS, DB2, COBOL, SAS, Control-M.
Role : Module Leader – (Associate Consultant for Production-Support on IMS/DC).
Description :
JC Penney has a number of application systems for handling Inventory Management System. The project is about providing production support to the JC Penney Applications System. The SPI (Software Professionals Inc.) supports the JC Penny Application system, which is further classified into SYS/IM, SYS/CAT and SYS/FIN. Role of Support Team is to provide support for 24 X 7 hours for entire year.
Jan 2001 to Jun 2002 American Express, Houston, TX
Project Name : Travel Related Service
Environment : IBM Mainframe
Skill/Tools : JCL, DB2, MQ-Series ,CICS, VSAM, SAS, Control-M.
Role : Programmer Analyst for Production-Support and Coding of new Programs.
Description :
American Express - Provides travel related service to customers all over the world. It provides travel information for passengers travelling Overseas and domestic using. Provides travel reports, in terms of Fight details, Hotel details, and other forms of transportation details to its corporate offices. This information is used for analyzing the service used during travel in terms of agencies, Flight companies, Hotel companies and Car Companies. The information is chocked down in form of Reports and Databases for further Analysis.
Dec 1999 to Dec 2000 HUMANA INC, Mumbai, India
Project Name : Forfeiting Claims for Enrolment System
Environment : IBM Mainframe
Skill/Tools : JCL, DB2, CICS, MQ-Series, VSAM, SAS, Control-M.
Role : Programmer Analyst for Production-Support and Program Enhancement
Description :
Enhancement, Maintenance and Testing of the module as per Client’s Specification by On-site and Off - Shore Team.
Oct 1999 to Nov 1999 AIG (American Insurance Group), Mumbai, India
Project Name : Reinsurance System
Environment : IBM Mainframe
Skill/Tools : JCL, DB2, CICS, VSAM, SAS, Control-M, MQ-Series.
Role : Programmer Analyst for Analysis of RDPS Module and writing new Programs.
Description :
Activities performed are Analysis and study of the RDPS (Reinsurance) module before commencement at offshore. Analysis related with the volume of module, Deliverables, On-site / Off-shore coordination, Tools available, Resource require Stages in SDLC life cycle and Documentation.