VIDHYA SAGAR JEGATHEESAN
Charlotte,USA
Summary
Results-driven Software Engineer with 16 years in software development and production support. Expert in architecting and migrating complex data systems, including ETL processes and cloud technologies, to enhance operational efficiency. Proven track record in strategic project management and innovative solutions that improve data accessibility and align with business objectives. Technical Architect specializing in leading complex data migrations and cloud integrations. Demonstrated success in enhancing operational efficiency through innovative solutions and strategic project management, ensuring alignment with business objectives to improve data accessibility and performance.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Technical Architect
Bank of America
Charlotte, USA
01.2022 - Current
- Directed migration of legacy DataStage to Cloud Pak, increasing operational efficiency.
- Managed team for application projects, maintaining customer contact information and related services.
- Executed process enhancements for DataStage and AutoSys dependencies.
- Led proof-of-concept projects migrating mainframe systems to cloud environments and Snowflake.
- Applied DBT transformations to optimize data processing capabilities.
Technical Architect
Bank of America
Charlotte, USA
01.2021 - 12.2021
- Migrated data and processes from Teradata to Hive, enhancing data accessibility.
- Converted complex Teradata queries into Hive equivalents for improved performance.
- Developed Unix shell scripts to replicate BTEQ TPT TPUMP functionality using Beeline.
- Utilized Python scripts to extract data from Teradata and transfer it to Hive.
- Created monthly Gen View scripts and implemented purge retention processes with Python.
- Configured connections to Hive from various applications, addressing architectural challenges.
- Collaborated with business analysts to ensure seamless transition and data integrity.
- Documented migration process to facilitate knowledge transfer and future maintenance.
Technical Architect
Bank of America
12.2018 - 03.2021
- Developed resilient customer database to enhance user experience and minimize inquiry costs.
- Executed migration from DB2 to distributed MemSQL database, ensuring data availability across nodes.
- Conducted staged migration, prioritizing inquiry calls followed by update call transitions.
- Rebuilt entire database structure and tables post-initial data load.
- Established processes for continuous data synchronization between DB2 and MemSQL until migration completion.
Production Support Analyst
Bank of America
Charlotte, USA
04.2014 - 12.2018
- Conducted production triages to identify root causes of issues using Splunk and monitoring tools.
- Enhanced production processes based on incident ticket analysis of defects.
- Engaged clients throughout project phases, implementing functional enhancements to reduce late-stage changes.
- Prepared high-level and low-level design documents for clear communication regarding production incidents.
- Renewed Apple, Windows, and Android certificates to maintain uninterrupted push services for customers.
- Developed ETL programs utilizing IBM InfoSphere tools and mainframe technologies for offshore implementation support.
- Created unit and integration test plans, executed test scripts, and managed defect analysis via Quality Centre.
- Collaborated with testing teams to validate developed code across diverse testing methods ensuring functionality.
Developer
Bank of America
07.2008 - 03.2014
- Developed ETL programs using IBM InfoSphere tools, including DataStage v8.x/v9.1 and mainframe technologies.
- Prepared design documents at high and low levels to align with project requirements and facilitate development.
- Analyzed client business requirements for accuracy and completeness to ensure alignment with project goals.
- Participated in initial requirement discussions to assess application impact and gather necessary information.
- Collaborated with offshore team to communicate business requirements and design strategies.
- Engaged in client discussions to clarify functional enhancements and address potential project changes proactively.
- Executed unit and component integration test plans, managing defect analysis through Quality Center.
- Coordinated testing efforts to validate code functionality across multiple testing methods.
Education
Bachelor of Engineering - Electronics and Communication Engineering
Coimbatore Institute of Technology
Chennai, India01-2008
Skills
- DataStage and CloudPak
- DB2, Teradata, SingleStore
- SQL and HDFS
- Mainframe and Linux
- Shell scripting and Python
- DBT ,BTEQ ,Snowflake
- Git version control
- Autosys job scheduling
- Windows operating system
- Cloud architecture
Certification
- IBM Datastage Developer
- DB2 Fundemental
Timeline
Technical Architect
Bank of America
01.2022 - Current
Technical Architect
Bank of America
01.2021 - 12.2021
Technical Architect
Bank of America
12.2018 - 03.2021
Production Support Analyst
Bank of America
04.2014 - 12.2018
Developer
Bank of America
07.2008 - 03.2014
Bachelor of Engineering - Electronics and Communication Engineering
Coimbatore Institute of Technology