Saikat Sil

About Saikat Sil

Working in banking & financial domain for 13.5 years as a Mainframe developer, Technical lead, Integration & migration specialist, technical & business analyst, distributed application support analyst. Has deep knowledge in Cards issuing & acquiring and Capital markets (Retirement) domains. Is involved in analysis of requirements, designing, development, debugging, testing and root cause analysis of intrinsic problems. Motivated, results-driven professional with good analytical skills and extensive exposure to requirement analysis and design. Has worked with the business and users to gather requirements and interpret technical documents. Also, have worked on developing different tools for automation of repetitive tasks. Known for quick learning ability, problem solving, team bonding & motivating abilities along with technical expertise. Eager to deep dive into any issues and share valuable inputs to the team. Pro-active in learning and discussing new ideas in mainframe as well as other distributed application areas.Specialties: Requirement gathering, requirement analysis, software design, agile methodologies, development, unit testing, regression testing, performance testing & project management.Primary Skills : Mainframe – Cobol, CICS, DB2, Stored procedures, Easytreive, JCL, VSAM, Endevor, Changeman, CA7, IBM TWS, CA View, IBM TOM, REXX, Filemaster, Fileaid, Intertest, JSON, XML, Mainframe API Integration and testingSecondary Skills :Support in distributed system : Linux, Windows server, Nice Actimize tools,Shell scripting, Java, Python, C#.Net, SQL Server (SSMS), OracleBusiness : Cards and Payments || Wealth Management (Retirements)Roles : Senior Developer Mainframe,Technical Lead / Migration & integration SpecialistSupport analyst for mainframe and distributed system,Business Analyst

Experience

1. Senior Consultant

   Capgemini

   Mar 2021 — Present · Alpharetta, GA, US

   Worked on several agile project to facilitate 1. the merger of E-trade and an investmentfinancial service firm which works for managing and distributing capital for clients around the globe. To facilitate the merger, the E-trade clients and accounts are being migrated to new platform as well as E-trade in-house applications are being integrated with the existing system.2. An investment financial service firm\'s migration of the database from DB2 to Oracle details for clients around the globe and the plans for the organizations. To facilitate the migration, the data are being migrated to new platform and the system and existing applications is updated to use the new database.Roles and Responsibilities : Analyzing requirements and clarifying the understanding with the Business Analysts / Business Owners. Performing gap analysis for different areas to implement the requirement. Collaborating with Analysts andArchitects to get an improved solution. Creating Proof of Concepts for an improved future solution. Adapting to the new solutions and collaborating with different teams to ensure the technical requirements areconsistent to the updated requirement. Design, program, code and analyze new computer programs and data structures in accordance with specifications and user needs using technologies like Cobol, JCL, CICS, IOM, VSAM, Stored Procedures. Write, update, and maintain programs to handle specific jobs such as storing, retrieving, and maintaining or data using Databases like Oracle and DB2. Building implementation plan for critical jobs and scheduling new job stream. Troubleshooting issues, provide root cause and fixing the code bug. Reviewing and helping the team to ensure quality deliverables within strict timelines. Reviewing test cases and ensure maximum test coverage

Education

• Birla Institute of Technology, Mesra

  Master’s Degree, Computer Applications

  2009 — 2012

• P.E.S. Instt. Of Tech

  Bachelor’s Degree, Computer Applications

  2006 — 2009

• D.A.V. Jawahar Vidya Mandir

  High School, Science with Information Practices

  2005 — 2006

Skills

• Vsam
• Jcl
• Software Project Management
• Unix
• Sql
• Microsoft Office
• Software Architectural Design
• Javascript
• Rexx
• C++
• C
• Php
• Xml
• Vba
• Oracle
• Requirements Analysis
• Pl/Sql
• Ispf
• Ibm Db2
• Java
• Mvs
• Process Improvement
• Software Development Life Cycle (Sdlc)
• Ca7
• Cobol
• Core Java
• Z/Os
• Testing
• Html
• Endevor
• Software Development
• Db2