Dynamic IT professional with 14+ years of experience in AS400 based application developments and maintenance projects with core skills in AS400, COBOL, COBOL ILE, CLP, DB2, SQL, MF COBOL and end-to-end delivery of large-scale insurance administration systems. Strong experience with enterprise-scale batch/transactional systems. Specialized in analyzing legacy applications, extracting business logic, and preparing AS400 workloads for modernization platforms. Strong background in SQL-driven data workflows and hands-on exposure to ETL concepts through data extraction, transformation, and validation activities. Actively expanding skills in Python and cloud fundamentals to support end-to-end transformation initiatives. Open to both AS400 development roles and modernization-focused opportunities. Strong experience in building various AS400 based automation tools that helped everyone in team to conduct daily basis work. Strong Experience in data extraction and valuation project working on multiple technologies that include raw data generation from IBM iSeries (AS400) system, transfer data to ETL tool, transform the data into ETL (DCS) based on business model requirement and generate different output modeling file for actuarial analysis. Strong experience in building and leading quality teams to successfully deliver many projects on time. Have vast experience in working with offshore teams and establishing a healthy working environment within the team. Have strong analytical ability and communication skills. Have been able to communicate very efficiently and effectively with onsite and onsite team members and other stakeholders that helped me to build strong teams.
Hi, I’m
Amarendra Sahoo
Wilmington,USA
Summary
Overview
15
years of professional experience
1
Certification
Work History
Tata Consultancy Services Ltd.
07.2011 - Current
Job overview
- DETAIL WORK EXPERIENCES:
- Client: Large Insurance Company based in USA (December 2018 – Till Date)
- Location: Wilmington, DE, USA
- Application: Admin System (AS400) Data Extraction and Valuation
- Technology Used: IBM iSeries (AS400), COBOL, CLP, DB2, SQL, and ETL tool (DCS), SQL Server
- Role: Technical Lead, ETL Developer, Team Lead
- Primary Responsibilities:
- Lead AS400 development for admin data extraction and validation for actuarial modeling. Responsible involves requirement analysis, mapping business requirement to technical functionality, design, coding, Unit and SIT test case preparation and testing, Code movement in ALDON, UAT Support, Deployment.
- Analyze Admin system data; generate raw extracts from Admin system, extracting processed data, and transfer data to required team via SFTP.
- Generates various data extracts from admin systems to be used for various Actuarial modeling like Experience Study, IFRS and LDTI.
- Prepare GAP analysis documents, extracts business rules from AS400 for migration projects and support for smooth migration.
- Data acquisition, Data analysis, Data Correction, Code review, documentation review.
- Lead interactions with Local clients, offshore team and other stakeholders. Review all offshore deliveries before final delivery.
- Client: Large Insurance company based in USA (May 2018 – December 2018)
- Location: Louisiana, USA
- Application: Group Policy Administration System
- Technologies Used: Net Express 4.0, MF COBOL, SQL Server, PostgreSQL
- Role: Senior Developer and Tech Lead
- Primary Responsibilities:
- Functional requirements gathering, business understanding, mapping functional requirement to technical components, technical design, coding, Unit testing, SIT, UAT support and project delivery.
- The project is associated with many existing data fixes of existing system incorrect data. Loading incoming data from Local office to database, analyzing the data, fixing as per business requirement through SQL procedure or query, fixing corresponding code fixes through embedded SQL in COBOL.
- Documentations like Technical design document, RCA documents, Flow diagrams and any other required documents.
- Interacting/Meeting with various stake holders, team members on a day-to-day basis or whenever required.
- Provided robust and efficient solutions to existing glitches in the system adding to system improvement and efficiency.
- Client: Large Insurance company based in USA (July 2011 – April 2018)
- Location: Kolkata, India (July 2011 – September 2014)
- Wilmington, DE, USA (September 2014 – April 2018)
- Application: Policy Administration System
- Technologies Used: Mainframe (3 months of Training), IBM iSeries (AS400), COBOL, CLP, DB2, Query400, SQL and AS400 Utilities
- Roles: Developer and Team Lead
- Primary Responsibilities:
- Requirement analysis, translating business requirement to functional components, design, technical design document, coding, Unit and SIT test case preparation and testing, UAT support, deployment and postproduction support.
- While in offshore, was responsible for offshore deliveries, coordinating with business analysts, onsite leads.
- Coordinating offshore team on daily basis on development activities, making sure all deliveries are on track, helping team in all cases form a great team that delivered many quality projects.
- Review code, technical document, test results, various documents and other deliverables from offshore before delivering to client for UAT and deployment.
- Meeting with various stakeholders regarding requirements, deliveries, and status reporting and other important discussions.
- Performance improvement through building various tools and system enhancements.
- Creating a healthy working environment by coordinating, guiding and helping offshore teams, building a quality and spirited team that achieved many milestones.
Education
College of Engineering & TechnologyBhubaneswar, India
Master of Computer Application
University Overview
Skills
- AS400 / IBM iSeries: COBOL, COBOL ILE, CLP, DB2, SQL, Query400, Aldon, FEU and various other Utilities
- Micro Focus NetExpress 40: Micro Focus COBOL, ODBC/SQL, MS SQL Server
- ETL (Hands-on Exposure): Data extraction, SQL transformations, Python scripting, DCS (Data Conversion System)
- Mainframe COBOL, JCL, CICS(only had 3 months of training on Mainframe, so hands on experience)
- Tools: FTP, SFTP, SQL Procedures, AS400 Utilities and self-built automation tools
- Leadership: Onsite-offshore coordination, mentoring, delivery ownership and managing strong relationship with LOIT
- Domain: Life Insurance, Policy Admin Systems
- Other Skills: Performance Tuning & Production Support, Batch Processing, Triggers, File Handling, Job Scheduling & Automation, Strong quality documentation and Performance Tuning & Production Support
- ADDITIONAL MODERN SKILLS (In Progress / Hands-On Exposure)
- Python programming for data processing and migration
- ETL Concepts (data extraction, SQL transformations, validation)
Accomplishments
Accomplishments
- Built AS400 Utilities like Archive tool, Automatic source and data extraction and automatic FTP
- Built an automatic data transfer tool using AS400 inhouse open SSH to connect other AS400/WS SFTP server for seamless and fast data scheduled data transfer. This tool was able to replace a third party tool goanywhere.
Certification
- Technical
- Data Science & Machine Learning Developer Certification in 2019.
- Big data Hadoop and Spark developer Certification in 2020.
- Azure AZ900 Certification in 2024.
- Business Domain
- ALMI (Associate Life Management Institute) Certified from LOMA (Life Office Management Association) in Insurance domain.
Languages
English
Full Professional
Hindi
Native or Bilingual
Timeline
Tata Consultancy Services Ltd.
07.2011 - Current
College of Engineering & Technology
Master of Computer Application