Saif Vur Rahman Siddiquie

Team Leadership & Mentorship:

• Managed and guided a team of 6 developers and a DBA, overseeing all technical changes, deployments, and ensuring high-quality deliverables.
• Led and mentored team members in AWS, Tableau, Informatica ETL, IIB, and various other technologies, driving solution design and implementation across the team.
• Provided continuous knowledge transfer on AWS, databases, ETL processes, and related technologies to enhance team skill sets.
• Delivered constructive feedback and managed conflict resolution within the team, ensuring a collaborative and productive work environment.

Solution Design & Architecture:

• Designed end-to-end AWS architecture for domain data storage and feed generation, leveraging resources like Lambda, SQS, and S3 to create scalable, efficient solutions.
• Led the design and development of a no-code Cloud Feed Generator app using AWS services, enabling seamless feed creation.
• Worked on multiple proof of concepts (POCs) to migrate existing databases and feeds to AWS, ensuring smooth transitions and optimized performance.
• Researched and evaluated AWS resources and the current system architecture, designing disaster recovery and business continuity plans to ensure system resilience.

Database & ETL Management:

• Analyzed, built, and enhanced database architectures and table structures in Oracle and PostgreSQL, guiding the DBA team on developing stored procedures and materialized view logics.
• Led the design and implementation of continuous data reconciliation validations between source and target systems using Informatica and AWS Lambdas.
• Provided support for database-related issues and guided the DBA team in ensuring optimal database performance.

Cross-functional Collaboration & Agile Leadership:

• Worked closely with the Product Owner to prioritize deliverables, ensuring alignment between technical solutions and business goals.
• Assisted the Product Owner in prioritizing stories across multiple sprints, ensuring a well-organized backlog and timely deliveries.
• Helped multiple feature teams in a Safe Agile environment by clarifying data structures and providing SQL designs for feature development.
• Strategized and managed deployments across all regions, including Production, using Bitbucket and Jenkins, ensuring smooth and efficient releases.

Reporting & Data Visualization:

• Led the guidance and support of Tableau developers in building required data sources and breaking down reports into MVPs to ensure business stakeholders received valuable insights.
• Analyzed business user’s ad-hoc data requests and built optimized SQL queries to meet their needs, running them as part of production and ad-hoc reporting processes.

Documentation & Knowledge Management:

• Designed and maintained Confluence pages and SharePoint structures to organize team documents, keeping the product details and development walkthroughs up-to-date for easy reference.
• Took initiative in documenting all technical workflows, deployment strategies, and solution designs for team-wide accessibility.

Continuous Improvement & Production Support:

• Supported production batch failures by providing timely instructions and ensuring production support teams understood thresholds and batch triggers to address issues quickly.
• Supervised all deployments during sprint cycles and ensured deployments were executed successfully at the end of each sprint, ensuring product stability.
• Set up critical conversations with urgency, driving necessary actions both within and outside the team to address any roadblocks or issues.

Leadership & Communication:

• Spearheaded cross-functional collaborations, persuading peers and leaders to align on technical solutions and ensuring successful project execution.
• Presented ideas and solutions effectively to leadership, securing buy-in and driving strategic decisions for future projects.

1. Requirement Analysis and Data Model Review: Analyze business requirements and study proposed data models to ensure alignment with project goals and technical standards.

2. Team Leadership: Managed and led a team of 5 DBAs, overseeing the execution of key database activities, ensuring smooth collaboration between development and database teams.

3. Database Object Creation and Support: Collaborated with the development team to create and maintain database objects (Tablespaces, Tables, Indexes, etc.), and assist in drafting database procedures and triggers.

4. Database Definition in Lower Environments: Defined and implemented database objects in lower environments as per the development team’s requirements to ensure accurate testing and development workflows.

5. SQL Query Development and Embedded Code Writing: Developed SQL queries and embedded code to meet business requirements, ensuring efficient and scalable database operations.

6. SQL Query Optimization: Reviewed SQL queries developed by the team, providing performance optimization suggestions related to I/O operations and database object referencing to enhance efficiency.

7. Performance Tuning and Metrics Analysis: Monitored CPU metrics before and after implementing tuning changes, providing accurate reports on performance improvements and resource savings achieved.

8. Support for Code Movement to Testing Environments: Coordinated with the development team to ensure smooth code migration to QA and UAT environments, adhering to release schedules.

9. Testing and Production Support: Assisted the development team during unit testing, QA, and UAT phases, providing necessary database support, and also contributed to production release activities to ensure successful deployments.

1. Application Development: Contribute to the design, development, and enhancement of applications within the BFSI domain, ensuring alignment with business requirements and technical specifications.

2. Testing Support: Provide comprehensive support during the testing phase, collaborating with the QA team to validate functionality, troubleshoot issues, and ensure quality standards are met.

3. Production Installation Support: Assist in the seamless deployment and installation of applications in the production environment, ensuring smooth transitions and minimal disruption to operations.

4. Coding and Testing: Engage in coding and testing activities as part of the application development lifecycle, ensuring robust, scalable, and high-performance solutions.

5. UAT and Testing Support: Apply changes in the User Acceptance Testing (UAT) environment, ensuring thorough testing of code changes and validation against business requirements.

6. Issue Resolution During Testing: Provide timely support for QA and UAT testing phases, identifying and rectifying issues from both regression and user perspectives to ensure smooth project progress.

7. Solution Implementation Assistance: Assist in the end-to-end implementation of solutions, collaborating with stakeholders to ensure the successful deployment and integration of the application within the business environment.

1. Mainframe Development: Design, develop, and maintain mainframe applications, ensuring the implementation of high-quality, efficient solutions that meet business requirements.

2. Production Support: Provide ongoing support for production systems, ensuring system stability, resolving issues promptly, and minimizing downtime.

3. Coding and Testing: Write and test code for required changes, ensuring that new functionality is implemented accurately and tested thoroughly.

4. Code Movement Support: Support the migration of code into System Integration Testing (SIT) and User Acceptance Testing (UAT) environments, ensuring proper configuration and integration with existing systems.

5. Implementation and Post-Deployment Support: Participate in the implementation of solutions and provide post-deployment support, ensuring smooth transitions and addressing any issues that arise.

6. Production Issue Resolution: Handle production support by diagnosing and resolving ABENDs (abnormal ends), bug fixes, and tickets, ensuring minimal disruption to business operations.

1. ASP .NET Web Development: Lead the design, development, and maintenance of dynamic ASP .NET web applications, ensuring alignment with business requirements and high performance.

2. Coding and Unit Testing: Write, review, and optimize code for required changes, conducting thorough unit testing to ensure functionality, reliability, and quality of deliverables.

3. Implementation and Post-Production Support: Oversee the implementation of new features and provide post-production support, troubleshooting and resolving any issues that arise post-deployment to ensure seamless user experience.

1. Online Sales Application Support: Provide ongoing support for online sales applications, ensuring smooth functionality, addressing issues, and maintaining system performance to enhance the sales process.

2. Product Support: Offer comprehensive product support, assisting clients with product-related inquiries, resolving issues, and ensuring customer satisfaction.

3. Clearing & Settlement Report Enhancements: Lead efforts in enhancing and optimizing clearing and settlement reports, ensuring accuracy and timely delivery to stakeholders.

4. Report Generation and Enhancements: Oversee the generation and enhancement of daily, weekly, and monthly sales reports, ensuring that they meet business needs and are delivered in a timely manner.

5. Investment Trend Analysis: Analyze investment trends, providing simplified and actionable reports to management for informed decision-making.

6. Online Trading Platform Enhancement and Testing: Drive the enhancement of online trading platforms, including testing and implementing new features to improve the user experience and overall platform functionality.

1. Networking Solutions: Design, implement, and maintain networking solutions to ensure the optimal performance and security of the organization’s IT infrastructure.

2. Networking Support for Existing and New Systems: Provide networking solutions for both existing systems and newly added systems to the network rack, ensuring smooth integration and optimal functionality.

3. Client Connectivity: Ensure seamless connectivity and reliable network performance for all clients, troubleshooting connectivity issues and optimizing network resources to meet business needs.