Software engineering senior advisor

• Apr 2021 - Present

Software Engineering Senior Advisor

• Feb 2020 - Apr 2021

Software Engineering Advisor

• Mar 2018 - Feb 2020

Consultant

• May 2015 - Oct 2017

Provide on-site consulting services to Cigna, CT based insurance company. SUMMARY: - Skilled in all phases of the software development lifecycle and experienced in designing, developing, integrating, and supporting corporate tools and applications. - Experience in working with data modeling and ETL teams to convert logical data models into physical data models on Teradata warehouse. - Extensively worked with Teradata utilities like BTEQ, TPT, Fast Load, Multi-Load to export and load data to/from different source systems. - Proficient in performance analysis, monitoring, tuning and optimized various complex SQL queries. - Hands-on experience in Automation and Configuration Management using the principles of CICD. - Use of Agile Methodology and the scrum process since 2015. PROFESSIONAL EXPERIENCE : Sr. Application developer - CIGNA Bloomfield, CT Jan’17 – Sep’17 I was working as a pseudo team lead and managed day to day operations of team, including but not limited to: daily stand up calls, JAD sessions, analysis review sessions with SME, requirement gathering, test case development, PI Planning, and complete release management. Application developer - CIGNA Bloomfield, CT May’15 – Jan’17 As a part of base layer team in Cigna Corporate Warehouse, I helped develop several processes to help streamline and automate the loading of tables from sources to the data mart. We delivered 30+ base layer tables to production in less than 10 weeks for the 1/1/2016 go-live of reports. I helped coordinate and produce a sudo production environment for reporting to test before going live, which involved coordination between reporting team, DBA’s and masking teams.

Associate technical analyst

• Jul 2011 - Jul 2013

Job Responsibilities : - Responsible for daily activities on production and non-production Database and Application servers. - Pro-active Monitoring/Health check of Database/Backup and any other errors and troubleshoot accordingly. - Responsible for Sys-Admin activities and space management of the server. - Administering Workflow mail, concurrent managers/parallel concurrent processing and troubleshooting. - Responsible for the setting of environment for all databases and also experienced with RAC environment. - Maintaining Control files, Redo Log files, Data files and Schema Objects. - Sound knowledge of Data Tablespace, Undo Tablespace and Temporary Tablespace. - Experienced in handling ORA errors, trace, tkprof. - Sound knowledge in Data guard (physical/logical), MRP/Gap troubleshooting. - Submitting periodical reports on the activities performed and finding a permanent fix for repeated issues. - Experienced in maintaining and supporting multiple Oracle databases and applications in high availability (24/7) heterogeneous environment. - Responsible for the support and maintenance of the applications and databases in the onshore and offshore model.