Mainframe Developer

Sonal Agrawal

***, ****** ****** **** **. W, Cincinnati, OH 45220

513-***-**** ********@****.**.*** www.linkedin.com/in/sonalagrawal23 EDUCATION

University of Cincinnati, Carl H. Lindner College of Business, OH Expected: December 2018 Master of Science in Information Systems Available: May 2018 Acropolis Institute of Technology and Research (RGTU) Indore, India Bachelor of Engineering, Electronics and Communication June 2014 SKILLS AND COMPETENCIES

Technical Skills (Domain: Banking, Operating System: Z/OS Windows, Hardware: IBM Mainframes)

• Expert: SQL, DB2, IMS Databases, Cobol, JCL, Telon, IBM Mainframe Tools (SPUFI, FAD, ADB, XPEDITOR, ISPW (Version management tool), ABEND-AID (Fault Analyser, B-92),

• Intermediate: MS Excel, MS Visio, SERVICE NOW (Change management tool), HP ALM)

• Beginner: Python, UML, .NET

PROFESSIONAL EXPERIENCE

On-site offshore coordinator ABN AMRO Bank (Netherlands) August 2016-July 2017

• Worked as onsite coordinator attending project review meetings with clients, to understand user needs

• Developed keen interest in analytics, have been coordinating with business analysts and business stakeholders to understand user needs and remodel functional requirements into technical for further processing

• Mediated between the product owner and scrum team members in an Agile environment to reach to common consensus on product features

• Delivered project of various sizes, been a part of performance tuning, production support, trouble shooting team

• Acted as coordinator between multi vendors such as IBM, Infosys, TCS & ABN members and single point of contact from TCS for various production implementations

• Prepared high, low-level design documents, transitioned the requirements and technical design documents to offshore for development activities in SCRUM framework as well as WATERFALL methodology

• Worked on detailed impact analysis, estimation, planning, solution designing to user change requests and redesigning of the legacy Forex Systems and payment engine for ABN AMRO Bank

• Ensured software standards as per SLA with the bank, serving as a SPOC for payment team of 40 developers

Application Developer Tata Consultancy Services Limited(Mumbai) September 2014-July 2016

• Performed ETL (Extract, Transform, Load) on transaction databases to create datasets for departments that analyzed settlement of charges

• Designed IBM DB2 databases and batch schedulers for bulk booking of payments

• Created ad-hoc reports for Forex payments to study booking patterns by writing SQL Queries on key databases

• Developed end to end projects such as Bank clearing code (BCC) and SNI SNU decommissioning, GPI Initiative where ABN AMRO payment domain was pilot engine

• Conducted technical trainings for freshers & created various knowledge sharing documents for further reference

LEARDERSHIP AND EXTRACURRICULAR ACTIVITIES

• Organized hiking event for 500 associated where I managed a team of 50 in TCS during my training in Trivandrum October 2014

• Organized biggest car treasure hunt in Indore city and lead many social and non-profitable activities as part of college fest during under graduation March 2013

• Organized fair to develop and enhance entrepreneur skills among school students as part of competition conducted by Wadhwani Foundation, Bangalore March 2012

Contact this candidate