Ashok Akkineni
McKinney,TX
Summary
Experienced Technology Architect and Hands-on Lead with over 20 years in IT, specializing in designing and implementing innovative solutions to solve complex business challenges. Expertise in Informatica tool administration, development, and performance tuning, along with cloud technologies (AWS, Azure, Snowflake). Proficient in Python, SQL, PL/SQL, Unix Shell Scripting, and database management (Oracle, SQL Server, Teradata). Strong hands-on leadership in guiding teams through solution architecture, system integration, data migration, and 24/7 production support. Proven ability to manage critical systems, mentor developers, and deliver successful projects across diverse industries including telecom, banking, and healthcare. Excellent problem-solving, communication, and client interfacing skills.
Overview
22
22
years of professional experience
Work History
Sr ETL/Data Engineering Lead
Bank of America
08.2023 - Current
- Designed and implemented robust ETL pipelines using Python, enhancing data processing efficiencies by automating data extraction, transformation, and loading tasks within Control-M scheduler.
- Developed scalable data architecture to improve data access and analytics capabilities, leveraging Python and cloud technologies for efficient data management and scalability.
- Enhanced data quality through Python-driven validation processes and cleaning techniques, ensuring high data integrity and accuracy across the pipeline.
- Led the migration of legacy systems to cloud-based data solutions, utilizing Python scripts for data migration and Control-M scheduler for task automation, ensuring a seamless and timely transition.
- Designed and developed Data Mappings to ingest data from disparate sources like flat files, RDMS, Hive, or REST APIs using Python, and managed scheduling and execution of jobs through Control-M.
- Leveraged advanced analytics tools within Python to create interactive dashboards, providing actionable insights into key business metrics while automating data updates and refreshes via Control-M scheduler.
- Optimized data pipelines by streamlining data flow and implementing advanced ETL processes, automating monitoring and reporting tasks through Control-M and optimizing Python code for maximum performance.
- Re-engineered existing ETL workflows by identifying bottlenecks and optimizing both Control-M job scheduling and Python scripts, resulting in improved performance and reduced processing time.
Sr ETL Lead
CVS Healthcare
10.2020 - 03.2023
- Self-motivated and responsible, demonstrating strong ownership of tasks while working in fast-paced environments. Effectively worked both independently and collaboratively, managing complex ETL processes with Informatica IDQ, IICS, and Oracle RDBMS in a dynamic team setting.
- Quick to learn and adapt, with proven expertise in Informatica IDQ, IICS, Autosys Scheduler, and Oracle RDBMS, ensuring efficient ETL management and optimization even when navigating new technologies or complex systems.
- Provided 24/7 support for critical administration tasks, including emergency deployments, resolving fatal errors on the Informatica Server, handling unexpected Informatica services failures, and troubleshooting repository issues in a timely manner.
- Configured, maintained, and provided technical support for Informatica ETL Server implementation, ensuring seamless operation of ETL jobs and loading into Oracle, while utilizing Autosys Scheduler for job automation and monitoring.
- Worked closely with project teams to identify process bottlenecks within Informatica ETL workflows and provided amicable solutions, enhancing overall data processing performance and ensuring smooth operation across environments.
- Maintained updates and patches for ETL environments, ensuring all Informatica and IICS components were current and functioning at peak performance, and coordinating necessary system upgrades and enhancements in line with the business requirements.
- Configured security at various levels (user/groups, roles, file system) in alignment with security design and configuration documents to ensure data protection and adherence to corporate security policies.
- Coordinated and prioritized all escalated activities, including testing, implementation of system upgrades, bug fixes, and enhancements for Informatica, IICS, and Oracle RDBMS systems, ensuring efficient resolution of issues.
- Collaborated with cross-functional teams, including DBAs, Mainframe Admins, and Unix Admins, to maintain the health of the environment and to address operational concerns in the ETL jobs.
- Actively involved in software upgrades and patch management for Informatica, ensuring smooth transitions during version updates while minimizing system downtime and impact on business operations.
- Monitored and managed Informatica services through the Informatica Admin Console and Linux environment, overseeing their stability and resolving issues related to job execution and resource utilization.
- Led efforts in testing, debugging, validation, and performance tuning for data warehousing processes, delivering optimized solutions for data warehouse deliverables in collaboration with business teams.
Sr ETL Architect
Alliant Credit Union
11.2017 - 09.2020
- Enhanced data integration by designing robust ETL processes.
- Developed architecture for seamless data flow to optimize system performance.
- Improved data consistency with implementation of advanced ETL solutions.
- Facilitated seamless data transformation, ensuring high-quality outputs.
- Created ETL architecture frameworks for improving data accuracy.
- Optimized data pipelines to ensure timely data delivery.
- Architected ETL solutions to support strategic data initiatives.
Education
Bachelor’s Degree - Computer Engineering
JNTU
Andhra Pradesh01.2001
Skills
- Git Repository Management
- ETL Solution Implementation
- Data Pipeline Development
- Database Management
- RDBMS
- SQL programming
- ETL processes
- Cloud platforms
- Data governance
- Proficient in Python Programming
Technical Skills
Data Ware Housing Tool (ETL)
Informatica Power Center
Database
Netezza, Informix, Oracle
Teradata 13, Sybase12.5, SQL Server, PDW
Front End Tools
TOAD, SQL Navigator 7.x, WinSQL, Rapid SQL.
Language / Script
C, C++, COBOL, SQL/PL, SQL,Python
Scheduler
Autosys, Control-M,IBM Tivoli (TWS)
Version Management Tools
Harvest, Visual Source Safe,Git
Operating Systems
Windows,linux/Unix,Co-op
Cloud Technologies
SnowFlake ,Azure
Prior Client Experience
- Toyota
- AMD
- Alliant Credit Union
- Integrys Energy group
- U.S. Cellular
- Fair Isaac
- Wachovia Bank
- Mellon Financial Bank
Timeline
Sr ETL/Data Engineering Lead
Bank of America
08.2023 - Current
Sr ETL Lead
CVS Healthcare
10.2020 - 03.2023
Sr ETL Architect
Alliant Credit Union
11.2017 - 09.2020
Bachelor’s Degree - Computer Engineering
JNTU
Similar Profiles
Steven BaezSteven Baez
Relationship Banker at Bank of AmericaRelationship Banker at Bank of America
Charles AlstonCharles Alston
Market Executive, SVP at Bank Of AmericaMarket Executive, SVP at Bank Of America
Elise CouturierElise Couturier
Operations Specialist II at Bank of AmericaOperations Specialist II at Bank of America