Amarendra Sahoo
Wilmington
Summary
Accomplished Technical Lead at Tata Consultancy Services Ltd. with expertise in AS400 and ETL processes. Proven track record in delivering high-quality data solutions and enhancing system performance. Skilled in mentoring teams and fostering strong stakeholder relationships, driving successful project outcomes through effective coordination and innovative problem-solving.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Technical Lead, ETL Developer, Team Lead
Tata Consultancy Services Ltd.
Wilmington
07.2011 - Current
- Lead AS400 development for admin data extraction and validation for actuarial modeling. Responsible for 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.
- Generates various data extracts from admin systems to be used for various Actuarial modeling like Experience Study, IFRS and LDTI.
- Analyzed admin system data, generated raw extracts, and transferred processed data to team via SFTP for enhanced data accessibility.
- Prepared GAP analysis documents and extracted business rules from AS400 to facilitate migration projects and ensure smooth transition.
- Data acquisition, Data analysis, Data Correction, Code review, documentation review.
- Led interactions with local clients and offshore team, reviewing all offshore deliveries to ensure quality before final delivery.
Senior Developer and Tech Lead
Tata Consultancy Services Ltd.
Louisiana
05.2018 - 12.2018
- Gathered functional requirements, understood business needs, mapped requirements to technical components, designed technical solutions, coded, conducted unit testing, supported system integration testing and user acceptance testing, and delivered projects.
- Facilitated daily meetings with stakeholders and team members to ensure project alignment.
- Created technical design documents, RCA documents, and flow diagrams.
- Provided robust and efficient solutions to existing glitches in the system adding to system improvement and efficiency.
- Loaded incoming data from local office to database, analyzed incorrect data, and implemented fixes per business requirements using SQL procedures and embedded SQL in COBOL.
Developer and Team Lead
Tata Consultancy Services Ltd.
Kolkata
07.2011 - 04.2018
- 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.
- Coordinated offshore deliveries with business analysts and onsite leads to ensure alignment and timely completion.
- Coordinated the offshore team daily on development activities and ensured all deliveries remained on track.
- Reviewed code, technical documents, and test results from offshore to ensure quality before client delivery 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.
- Facilitated healthy working environment by guiding offshore teams and fostering collaboration, resulting in successful achievement of team milestones.
Education
Master of Computer Application -
College of Engineering & Technology
Bhubaneswar, IndiaSkills
- AS/400
- IBM iSeries
- COBOL
- COBOL ILE
- CLP
- DB2
- SQL
- Query400
- Aldon
- FEU
- Micro Focus NetExpress 40
- Micro Focus COBOL
- ODBC/SQL
- MS SQL Server
- ETL
- Data extraction
- SQL transformations
- Python scripting
- DCS
- Mainframe COBOL
- JCL
- CICS
- FTP
- SFTP
- SQL Procedures
- AS/400 Utilities
- Automation tools
- Offshore coordination
- Mentoring
- Delivery ownership
- Client relationship
- Life Insurance
- Policy Admin Systems
- Performance optimization
- Production Support
- Batch Processing
- Triggers
- File Handling
- Job Scheduling
- Automation
- Documentation quality
- Python programming
- ETL principles
- Validation
Certification
Data Science & Machine Learning Developer Certification, 2019, Big data Hadoop and Spark developer Certification, 2020, Azure AZ900 Certification, 2024, ALMI (Associate Life Management Institute) Certified, LOMA (Life Office Management Association), Insurance
Personal Information
- Title: Senior AS400 Developer & Modernization Engineer
- Visa Status: H1B with approved i140
Additional Modern Skills
- Python programming for data processing and migration.
- ETL Concepts (data extraction, SQL transformations, validation)
Timeline
Senior Developer and Tech Lead
Tata Consultancy Services Ltd.
05.2018 - 12.2018
Technical Lead, ETL Developer, Team Lead
Tata Consultancy Services Ltd.
07.2011 - Current
Developer and Team Lead
Tata Consultancy Services Ltd.
07.2011 - 04.2018
Master of Computer Application -
College of Engineering & Technology