Ranganath Bongale

Data AI leader with a track record of driving large complex cloud data AI transformation and strategic solution.18+ years of technology consulting experience. Hands-on senior lead who can quickly adapt to the trends of disruptive Data, AI and Cloud technologies. Demonstrated end-to-end delivery & management of complex high risk, compliance & regulatory projects & programs in a matrix organization with multi-vendor, multi-location & multi-technology teams. Also performed as Solution Architecture and Business Development specialist. Developed and implemented various comprehensive data management strategy aligned with the overall business objectives.

Client\Customer level experience details are mentioned below.

• Worked on various phases of solution building
• Discovery and analysis of current technology landscape, Strategy to migrate 4.5 Pb data from Teradata to GCP BQ
• Evaluating various technologies and platforms such as BQ, Cloudera and Databricks
• Strategy to migrate historical data and incremental solution which includes more than 29K data integration processes
• Deliver Large Petabyte Scale of data migration & modernization
• Architect, Solution and delivery of migration/modernization complex Hadoop/Spark ETL/AI workloads to Cloud
• Define Cloud Modernization solution strategy and architecture for Data Lake and Machine Learning Platform
• Lead Estimation, Planning and Integrated Project Plan across multiple Line of Business
• Define Cloud Data Governance, Cloud Data Security Strategy, Architecture & Implementation Plan.
• Improved solution efficiency by designing and implementing scalable architectures for enterprise clients.
• Facilitated seamless communication between technical teams and non-technical stakeholders by effectively translating complex concepts into understandable terms for all parties involved in projects.

• Built 3-year AWS cloud data migration roadmap and Data strategy. (AWS, S4, Redshift, PySpark, CDGC, IICS, Glue).
• Helped clients transform and consolidate various legacy systems (SSIS, SAP, BODS, Oracle scripts, Ksh and other applications) into suite of Informatica tools including IICS, IDQ, B2B Data Developer
• Helped clients transform and setup new programs around Data Delivery, Engineering and Data Governance (IDQ, EDC, AXON, CDGC)
• Migrate current Teradata environment (70TB) to TD vantage
• Worked in various initiatives to implement and improve Data security, Data redundancy and Data velocity
• Worked effectively in fast-paced environments.
• Skilled at working independently and collaboratively in a team environment.
• Assisted with day-to-day operations, working efficiently and productively with all team members.

• Setting up a new Abinitio team and practice for client
• Work with IT, Business team, Stake holders and other client leadership team
• Project intake, Estimation, Planning and budget approval from clients
• Managing over 96 Abinitio ETL team members across 23 data warehouses
• Managing multiple Abinitio projects build UT and UAT
• Act as release manager for all Abinitio projects
• Warranty production support
• Also planned and managed relocation of whole team from Chicago, IL to Alpharetta, GA.
• Acted as a liaison between the delivery team and upper management, effectively communicating concerns and suggestions for improvements.
• Managed relationships with key stakeholders to ensure smooth project deliveries and overall satisfaction.
• Supervised delivery staff and general productivity.
• Managed resources effectively to avoid unnecessary delivery delays.

• Setting up a new Abinitio team and practice for client
• Managed a team of 18 developers and 13 testers
• Work with IT, Business team, Stake holders and other client leadership team
• End to end project delivery management of multiple Abinitio, Hadoop and QueryIT projects
• Project intake, Estimation, Planning and budget approval from clients
• Act as release manager for all Abinitio projects
• Warranty production support.
• Enhanced customer satisfaction by consistently meeting or exceeding project delivery milestones and quality standards.
• Implemented continuous improvement initiatives to identify areas of inefficiency in the project delivery process and develop solutions for optimization.
• Improved project delivery efficiency by streamlining processes and implementing best practices in project management.

• Worked on a Healthcare Analytics Payer Operations (HAPO) RFP for a Health Care client
• Lead design, build and test case review meetings with client stakeholders
• RFP to build scenarios to identify fraud and Abused claims
• Identification of potential recovery scenarios and building various applications
• Work with PMO, SA, Sales and leadership team to prepare oral presentation
• Work with PMO and legal team on drafting and presenting SOW.
• Planned marketing initiatives and leveraged referral networks to promote business development.
• Expanded client base by identifying and targeting new business opportunities through market research and analysis.

• Ab Initio data migration build project (5.9+ million customers) from legacy systems to BRM
• Managed a team of 14 Abinitio developers
• Managed change requests and end to end project execution
• Lead design, build and test case review meetings with client stakeholders
• Generate and review migration reports with client leadership team.
• Conducted thorough data profiling to ensure optimal performance during the migration process.
• Provided clear communication with stakeholders, ensuring smooth progress of projects from initiation to completion.
• Improved data migration efficiency by designing and implementing optimized ETL processes.
• Trained team members on best practices for data migration, fostering a culture of continuous learning and improvement among peers.

• Managed Informatica ETL-AD team of 27
• Developed comprehensive documentation for solution design specifications, ensuring clear communication between stakeholders at all stages of project lifecycle.
• Delivered high-quality solutions on time and within budget through diligent adherence to project scope, timelines, and resource constraints.
• Technical Architect
• Analysis, Estimations, Project and Resource plan
• Improved solution efficiency by designing and implementing scalable architectures for enterprise clients.
• Managed data quality and MDM team.
• Managed end-to-end software development life-cycle, from initial requirements gathering to post-implementation support and maintenance.

• Supervised Data & Analytics team
• Implementation of a DataMart sourcing data from FACETS and building a warehouse and DataMart for reporting
• Managed a DataStage ETL build team of 20 Members
• Design, Code, Test cases and results reviews
• Release management and warranty support
• Lead design, build and test case review meetings with client stakeholders.

• Identified use cases to recover cost on fraud and abused claims across Claims, Membership, Provider, Medicare and other area
• Worked with analysts, SMEs and designed ETL and Data mining applications to identify and recover fraud/abused claims
• Migrated and consolidated data from various BCBS state owned databases to Greenplum (PostGres) database
• Lead a team of 15 to build, test, UAT, Productionalize and automate
• Work with SMEs on scenarios to improve hit rates on the recovery.
• Trained team members on best practices in data analytics, fostering a culture of continuous improvement.
• Mentored junior analysts, providing guidance on analytical techniques, tool usage, project management skills, and professional development.
• Spearheaded the development of an automated reporting system for streamlined tracking of KPIs across departments.

• Performed as Architect and ETL Delivery Lead
• Managing multiple DataStage, Db2 and Oracle projects for a Commercial Insurance client based out of Novato, CA.
• Spearheaded efforts to improve overall system performance by conducting thorough assessments of existing ETL processes and recommending optimization strategies.
• Led a team of developers in delivering high-quality ETL solutions on time and within budget, fostering strong working relationships among team members.
• Implemented effective monitoring and alerting mechanisms for ETL workflows, enabling proactive resolution of issues before they escalate.
• Delivered training sessions on new ETL tools and methodologies to internal stakeholders, promoting a culture of continuous learning within the organization.

• Worked as a Data migration lead
• Ab Initio data migration build project for a large US bank
• Lead a team of 40 Abinitio and Cognos developers
• Identified use cases for Mortgage and credit card fraud and risk management
• Delivered applications successfully.
• Contributed to continuous improvement of internal processes and documentation by identifying areas for enhancement and implementing necessary changes.
• Conducted thorough data profiling to ensure optimal performance during the migration process.
• Improved data migration efficiency by designing and implementing optimized ETL processes.

• Worked as team lead and lead Abinitio and Informatica dev teams
• Worked as senior developer and designer
• AbInitio data migration build project for large US Credit Card client based out of Phoenix, AZ (Offshore Mumbai, India).
• Developed reusable code libraries that streamlined development efforts and improved consistency in software architecture across multiple projects.
• Developed secure applications by enforcing strong encryption standards and implementing robust authorization mechanisms.
• Managed multiple design projects simultaneously, ensuring timely delivery within budget constraints.
• Developed innovative design concepts for improved brand recognition and customer engagement.
• Streamlined design processes, resulting in increased efficiency and faster project completion times.

• Delivered HLD, LLD and UT and IT test cases
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Reduced processing time for ETL tasks through implementation of parallel execution strategies.
• Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
• Mentored junior developers on best practices in ETL development, fostering culture of continuous learning within team.
• Integrated data from heterogeneous data sources into Oracle DB
• Designed and built complex Abinitio ETL jobs
• Worked as tester and production release lead
• Provided warranty support.