Sarfaraz Khan

• Facilitating the digital transformation of MLC technologies to SS&C platforms following
operational outsourcing.
• Conducting workshops and brainstorming sessions to elicit business requirements and
support strategic decision-making.
• Performing functional decomposition and gap analysis to align SS&C tools with MLC business
needs.

• Led the migration of MLC applications from NAB Data Centres to IFL Data Centres and Public
Cloud (AWS/Azure).
• Managed the end-to-end migration of a 13 TB Oracle DB Enterprise Data Warehouse (EDW).
• Implemented Adaptive MFA using Auth0 for MLC Web and Mobile applications.
• Reduced video storage costs by 80% through technical analysis of the VioStream platform.
• Authored technical documentation, epics, and user stories using Jira.and Confluence
• Leveraged Generative AI tools (e.g., Copilot and Gemini) to accelerate requirements
elicitation, user story creation, and documentation accuracy.

• Delivered critical legislative features including Transfer Balance Cap Indexation, Digital
Signatures and 6-member SMSF rules.
• Managed product milestones and served as the primary liaison between product and
development teams.
• Conducted backlog grooming and story sizing using planning poker.

Aligning the business processes in the existing COIN financial advice application and getting the Financial planning software migrated to new application while ensuring lowest possible down time for business and maximum coverage of data throughout the application. Ensuring that Paraplanning team perform their jobs smoothly and act as a single point of contact for other various departments like Remediation, Quality, Compliance, Research and Customer Relations is priority. My activities ranged across providing analysis of business requirements, creating functional document, clarifying requirements, identify alternate solutions, creating technical documentation, scripting, testing, implementation, incident/change/problem management and Vendor management.
Responsibilities:
•Work with customers in gathering business requirements for data migration needs.
•Assist in designing, planning and managing the data migration process.
•Perform source system data analysis to manage source to target data mapping.
•Perform data migration audit, reconciliation and exception reporting.
•Data mining and reporting to support Remediation team with their investigation.
•Create data migration approach and strategy documentation.
•Follow the best Business Analysis practices and standards
•Elicit, analyse, validate and document clear business requirements
•Develop strong working relationships with internal and external business stakeholders
•Provide clear and correct business requirements to the development team within the scheduled time-frames
•Extensive experience in logical data modelling and data migration
•Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2012)
•Maintain multiple environments for testing and development
•Supporting monthly and quarterly system updates
•Provide support to Group in responding to ASIC queries
•Assist business in raising and escalating internal IT issues with respective teams and performs root cause analysis for the issues

Achievements:
•Aligned technical documentation with current scenario of the application and environment
•Complete migration of data between old and new advice application
•Created data warehouse for old application and data mapping document, SOP and user guide
•Successfully responded to several complex business requests in response to ASIC queries
•Designed, documented and developed complete workflow system in COIN for Financial planning associates team

Temenos Australia (formerly Rubik Financial)
Customer: AMP,

The role is of an onsite technical SME for the client Colonial First State, the consolidated asset management division of Common Wealth Bank. My major project here was about migration of their in-house CRM and workflow system, which was used for several superannuation, retirement and pension products, from physical server boxes to On Demand Platform, with scale-up and uplift of all the related components like Microsoft .net framework (4.5), Telerik components, Memcached, Daija viewer.

Responsibilities:
•Migration of code base from .net 2.0/3.5 to .net 4.5
•Resolving issues with Telerik controls upgrade
•Resolving code migration issues with best workable solutions
•Upgrading and testing of web services, windows services and win form applications
•Migration of SOAP based services to RESTful services
•Design firewall requirements document with the reference from existing High-Level Infrastructure Document, service management plan and operations guide
• Testing firewall rules and F5 configuration for multi-site for internal and external systems
•Configuring in-house Automated deployment tool for deployment of multiple environments using Automated Configuration and Deployment Coordination(ACDC)
•Code merge and retrofit for on-going releases using TFS
•Providing handover to the Dev-ops team and respective documents
•Creating run sheets for SQL Server database and UI deployment

Customer: KPN Telecom, British Petroleum

Development and enhancement of several Web applications developed in ASP.net and C#, for versions ranging from 2.0 to 4.0. Experience in developing complex web applications involving creating of user controls, implementing master pages and authorisation and authentication of users and resources. Applied state management and caching techniques to resolve various technical issues and performance issues. Developed multiple WCF services and web/windows services using C#.net. Enhanced existing functionality with new features available within latest frameworks.
Roles and Responsibilities:
•End to end Involvement from Designing, Development, Testing and Deployment on Test, Integration and Production Environment.
•Discussed client requirements with team lead to understand technical specifications
•Collaborated with designers, testers and DBAs
•Created front end interface using ASP.Net MVC, JavaScript, jQuery, HTML and CSS with business layer using C#.Net and Queried SQL Server 2008 as backend
•Microsoft .Net application development using Object-Oriented Analysis/Design.
•Consuming and Developing Windows Communication Foundation services (WCF).
•Creating WCF applications requiring Instance and concurrency management.
•Creating LINQ enabled database layer using API such as LINQ to SQL and Entity Framework.
•Using LINQ for querying objects.
•Applying best design patterns such as n-tier, Repository, and Singleton for designing key reusable components.
•Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2008)
•Development of .NET batch applications which processes high volume of data.
•Source control tools such as Microsoft TFS, MKS and VSS.
•SQL Development, ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, indexes, constraints).

Achievements :
•On time and in budget delivery of deliverables
•Transitioned complete business process from FO (Germany) comprising of multiple platforms technologies including Java, .net, VBA, PHP, Mainframes and several third-party applications for cards system
•Created knowledge base, technical document and work instructions
•Groomed and coached new team members to get acquainted with the existing project.
•Managed a team of 6 remote members.
•Made offshore 85 % billable for the whole project.
•Automated several menial tasks like housekeeping and monitoring of backups.

Worked on performance tuning, small enhancements, code revival and migration of legacy components to .net. Automation of menial tasks, testing and deployment on test and production server. Preparing documentation and training material for updates. Maintenance of databases including replication, backup and restore.
Roles and Responsibilities:
•Involved in design, development, testing and deployment using C#, VB6, VBA with Access and Excel.
•Involved in taking clarifications from the customer and suggesting improvements Involved in designing the DFS (Detailed Function Specification), TDS (Technical Design Specs.), creating Unit Test plan, Check Lists etc.
•ADO.NET-based Data access layer in a multi-tier. NET-based application.
•Convert existing classic ASP web application to ASP.net.
•COM + components developed in VB were to be converted to C # Dot Net.

Achievements :
•Improved performance of catalogue website by 65%.
•Migration of VB component and ASP website to .net C#.
•Created white paper for migration project.
•Achieved faster performance by code refactoring and implementing caching.
•Automated Database backup and database shrinking using scripts.
•Generate PDF Functionality using C#, asp.net, XML Web Services, XML, XSLT and XSLFO

Making updates to product functionality and screens as per the requirement, updating user manual and assisting test team and fixing the defects. Working on portfolio management applications for venture capital and hedge funds. Writing complex business logics and SQL queries. Performance improvement, unit testing and documentation were key responsibilities.

Roles and Responsibilities:
•Upgrade and develop products created using VB6, SQL server and Crystal Reports.
•Improved finalisation process performance by fine tuning SQL stored procedures.
•Supporting testing activities and fixing defects for Venture capital, private equity profile management.
•Provide face to face customer support (onsite).

Achievements :
•Created techno-functional document for whole business logic.
•Performance optimisation for final settlement process by 55%.
•Online PDF reporting for individual contributor account.

on several small Inventory, Billing, Payroll and Educational institute projects. Responsible for coding, testing, deployment, demo and updating documentation. Worked on majority of VB, SQL server and Crystal reports.

Role and Responsibilities:
•Gathering Functional Requirement
•Creating High and low-level design
•Architecture Design
•Coding
•Testing
•Deployment Package creation.

Achievements :
•End to end solution development.
•Bagged 2 sales order on basis of prototype and presentation.