Sajith Joseph
Senior ETL Engineer
Trivandrum
Summary
Dynamic Lead Developer with over 15 years of IT experience, including 13 years specializing in SAS. Expertise in software development, application enhancements, and code optimization utilizing SAS, UNIX, and Azure technologies. Proven track record in gathering and analyzing customer requirements to deliver tailored technical solutions, along with extensive knowledge of the Software Development Life Cycle. Proficient in SAS Base & Advanced, Macros, SQL, and SAS DI programming, as well as ETL tools such as SAS EG, WRS, SAS VA, and Viya platforms. Recognized for strong problem-solving abilities and effective communication skills, fostering collaborative relationships within multidisciplinary teams while contributing to significant projects such as GDPR implementation and IFRS17 data pipeline creation.
Overview
13
13
years of professional experience
2
2
Certifications
Work History
Assistant Consultant
Tata Consultancy Services
09.2019 - Current
- Analyze and design IFRS modules.
- Translate the business requirements to technical specs and oversee its implementation
- Responsible for designing SAS ETL jobs using SAS DI, Base SAS, SAS EG.
- End to end design and implementation of data pipelines from multiple source systems to IFRS datamart and finally into the FPSL IFRS17 compliant standards.
- Automation of quarterly data refresh into SAS Viya platform(SAS VA) for reporting.
- Manage a team of developers for ETL development, testing and implementation.
- Deployment of jobs using GiT and Azure Dev Ops.
- Scheduling of developed jobs using Stonebranch scheduler.
- Provides support during warranty period.
- Collaborated with cross-functional teams to enhance project delivery and client satisfaction.
- Analyzed client requirements to design tailored solutions, improving service efficiency.
- Developed and implemented process improvements, leading to streamlined operations.
- Conducted training sessions for junior consultants, fostering skill development and knowledge transfer.
- Provided strategic insights to senior management, influencing decision-making processes.
Senior System Analyst
Allianz Technology
05.2017 - 09.2019
- Create system requirements, solution options, and technical specification.
- Responsible for developing/enhancing SAS ETL jobs using SAS DI, Base SAS, SAS EG.
- Create and execute unit test cases in HP Quality Centre.
- Schedule the jobs using TWS/UC4 job scheduler.
- Verify and validate the implementation.
- Provides support during warranty period.
- Monitoring CMIS batch jobs and resolving failures.
- Led cross-functional teams to implement system enhancements, improving operational efficiency across multiple departments.
- Developed and maintained system documentation, ensuring compliance with industry standards and best practices.
- Collaborated with stakeholders to gather requirements, translating business needs into technical specifications.
Software Developer
L&T InfoTech
06.2012 - 12.2013
- Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design.
- Store, retrieve, and manipulate data for analysis of system capabilities and requirements.
- BASEL recommended values were implemented for a leading banking client.
- End to end development of SAS codes using SAS BASE and SAS Enterprise Guide for different portfolios like Mortgage, Credit cards, Installment finance, Cheques etc.
- Also developed minor reports for different portfolios using the reporting capabilities of SAS.
- Modify existing software to correct errors, allow it to adapt to new hardware, or to improve its performance.
- Analyze and reformat the loading programs of different clients to properly populate the data warehouse using Datastage and SAS.
- Modify UNIX shell scripts to include enhancements in the existing application.
Education
Bachelors Degree - Electronics and Communication
Rajiv Gandhi College of Engineering
Chennai, TN06.2008
HSC - undefined
Don Bosco HSS
Kottayam, Kerala05.2004
SSLC - undefined
Don Bosco HSS
Kottayam, Kerala05.2002
Skills
Operating Systems: Windows Family, Unix Family
undefinedCertification
SAS Certified Specialist: Base Programming
ADDITIONAL SKILLS
- Completed courses on Azure Databricks and Fabric
- CORE JAVA certification from NIIT, Kottayam.
- Two weeks training and internal mini project using IBM websphere Datastage TX 8.1 in June 2010
- Attended boot camp provided by IBM on IBM Websphere Datastage v8.5 in August 2011.
- Internal domain certification on Core Banking and Payments.
- Internal domain certification on General Insurance.
Timeline
Assistant Consultant
Tata Consultancy Services
09.2019 - Current
Senior System Analyst
Allianz Technology
05.2017 - 09.2019
Software Developer
L&T InfoTech
06.2012 - 12.2013
HSC - undefined
Don Bosco HSS
SSLC - undefined
Don Bosco HSS
Bachelors Degree - Electronics and Communication
Rajiv Gandhi College of Engineering