Siddhi Shetye

Client- BCBSA

Project - Care Coordination and Technology Modernization

• Led a comprehensive platform modernization initiative, migrating enterprise databases from DB2 to PostgreSQL and performing critical Ab Initio infrastructure upgrades (Co>Op, Unix server, and graph upgrades).
• Spearheaded critical Ab Initio infrastructure upgrades, including Co>Op, Unix server, and graph transitions, while meticulously refactoring components to meet updated compatibility guidelines, ensuring zero-defect deployments across higher environments
• Ensured seamless system compatibility by meticulously analyzing Ab Initio components against new Co>Op guidelines, proactively refactoring code to align with latest performance and stability standards.
• Directed end-to-end testing strategies, identifying and resolving integration bottlenecks to ensure high-performance data pipeline reliability post-migration.
• Architected a zero-defect deployment strategy for higher environments, leveraging rigorous validation frameworks to ensure seamless production cutovers with zero downtime.

Client- BCBSA
Project - DX Analytics

Every year once the open season enrollment window begins, it allows member to add or remove eligible benefits either newly added or the existing benefits or incentives introduced by the business.
Dx Analytics project allows to add benefits to the member account. It gathers data from different sources like MyBlue portal, validate the eligibility of a member for that
particular benefit and process the request.

• Architected and deployed optimized data integration workflows using Ab Initio, significantly enhancing data processing efficiency and reliability across diverse enterprise applications.
• Provided technical leadership for the Ab Initio development team, directing project design, enforcing coding standards, and delivering high-quality solutions that consistently met business objectives.
• Streamlined the agile development lifecycle by collaborating with stakeholders to refine user stories, accurately estimating effort for sprint backlogs, and fostering continuous improvement through proactive feedback loops.

Project - KYC Framework ETL
Client- CITIBANK US

• Designed and built framework utilizing Ab Initio for data extraction, transformation, and loading.
• Developed utility to streamline generation and updating of CyberArk DB connections in project sandboxes.
• Optimized ETL processes with advanced features like partitioning and dynamic lookup caching.
• Created jobs and enabled automatic import in each Control Center environment through RLM deployment.
• Created jobs and facilitated automatic import in each Control Center environment via RLM deployment.
• Developed utility for generating and updating CyberArk DB connections in project sandboxes.
• Optimized ETL processes using advanced features like partitioning and dynamic lookup caching to enhance data management.

Project - Fraud Detection
Client- Barclays

Barclays has decided in response to UK, European and US regulatory, to initiate the Structural Reform Program (SRP) which is a key strategic priority throughout the Barclays group. The BUK program will deliver a new Barclays Legal entity for Barclays Personal and Corporate Banking in UK.

• Led cross-functional teams to create client project solutions, enhancing collaboration and meeting project goals.
• Coordinated client meetings to gather requirements and align expectations, ensuring clarity and project alignment.
• Participated in all phases of SDLC, focusing on requirement gathering, development, testing, and documentation.
• Developed high-level and detailed design documents to guide project execution.
• Created low-level ETL designs to meet business requirements.
• Generated new ETL processes ensuring uniqueness across interfaces using Ab Initio, SQL, and UNIX scripts.
• Mentored junior developers on coding standards and development techniques, fostering skill development and team capabilities.

Project - CCR NextGen
Client- Wells Fargo

The purpose of this project is to improve the performance, stability and robustness of the Counter party Credit Risk platform. This will be accomplished by following high level task.
1) Migration of CCR Adaptive System functionality in-house from existing hosted model.
2) The building of robust data sourcing and management process.
3) The development of a data control System and reporting tool for the derivative center of excellence. (DCOE).

Responsibilities :

• Designed system flow using Ab Initio framework to enhance functionality.
• Coordinated efforts among technical analysts to achieve seamless collaboration.
• Analyzed high-level technical design documents and prepared detailed design documentation.
• Developed graphs based on functional specifications document for clarity and accuracy.
• Created extensive test cases to cover all possible code scenarios.
• Executed unit testing and documented results to ensure quality assurance.

Project - FMS
Client- JP Morgan

FMS is a strategic program developing a unified financial mapping service for the GFT ecosystem. Phase 1 delivers a platform specifically for the GLS UK transition to SAP GL.
The system architecture features two distinct processing modules:
1. Conversion & Reconciliation: A staged workflow to ensure data integrity during migration.
2. Daily Integration: Ongoing automated mapping to maintain synchronization across disparate systems.

Responsibilities :

• Designed and implemented Ab Initio graphs, aligning with business requirements to enhance data processing capabilities.
• Designed and built Ab Initio generic graphs for data extraction and loading into Oracle DB.
• Created reusable scripts to automate deployment of Ab Initio graphs, streamlining operations across multiple servers.
• Troubleshot and resolved issues in existing data pipelines, improving overall performance and reliability.
• Mentored junior developers on Ab Initio tools and ETL methodologies.
• Conducted code reviews to ensure adherence to best practices and standards.

Project - Aurora, Germany
Client- Barclays

Responsibilities:

• Analyzed business requirements and designed code base to ensure alignment with specifications and project goals.
• Developed ETL Ab Initio plans and graphs aligned with project needs.
  Executed administration tasks, including migration, deployment, and job scheduling using scheduler tools.
• Developed ETL Ab Initio plans and graphs aligned with project needs.Executed administration tasks, including migration, deployment, and job scheduling using scheduler tools.
• Proposed innovative ideas and solutions that improved team collaboration and project outcomes.
• Collaborated with diverse coworkers to achieve project objectives and resolve product-related issues.

Project - 9.1 Network Release
Client- Discover Financial Services

Responsibilities:

• Developed ETL process to ensure data uniqueness across all interfaces using Ab Initio SQL and Unix scripts.
• Created Ab Initio applications for optimized parallel processing to enhance data handling efficiency.
• Designed low-level ETL specifications to meet business requirements effectively.
• Conducted unit testing and integration testing to ensure application reliability and performance.
• Created Ab Initio applications for parallel processing, improving data handling efficiency.
• Resolved production issues during and after migration, minimizing downtime and maintaining service continuity.
• Designed low-level ETL specifications to meet business requirements effectively.