Sanjiv S.

DATABASE DEVELOPER

366 dollar
Freelancer
6 ans
London, UNITED KINGDOM

Mon expérience

Voir plus

Baringa PartnersOctober 2019 - January 2020

• Engaged with the data analytics team, based within a retail bank to build financial crime detection logic within Oracle SQL. Conducted several phases of deep dive data analysis and referential integrity checks identifying patterns and making recommendations to senior stakeholders.

• Testing and documenting the entire the process and managing regulatory expectations of the programme.

Career BreakJune 2019 - September 2019

Voir plus

Santander Corporate & Investment BankingJuly 2018 - May 2019

Company: Santander Corporate & Investment Banking - Senior Database Developer (
Position: Otello - Counterparty Analysis and Reporting tool. (Excel VBA/SQL Server)

* Engaged via a referral to standardise and enhance the functionality to the existing suite of applications.

* On the trade floor creating trader tools and solutions from minimal specifications (VBA/Python).

* Development of an Excel/SQL Server based Credit Exposure/Rec & Credit Limit/Headroom dashboard.

* Migration of legacy systems into the standardised suite of applications. ETL tasks using SSIS.

* Functionality, Performance and Optimisation enhancements to Access/SQL Server application.

* Highlighting manual operation risks and designing/building/testing solutions and plans of action.

* Mentoring, assisting and providing good practice guidance to junior developers.

Company: JP Morgan Chase. Senior RAD Developer - Regulatory Reporting - (Excel VBA/SQL/Python)
Position: Front Office Supervision Applications / Cross Border Program - Process Automation & Reporting
Voir plus

Lloyds Banking GroupNovember 2012 - November 2014

Position: Analyst Developer (Excel/VBA, SQL Server) (RAD) Global payments and reconciliations.

* Advanced VBA/ADO/SQL. Development of tactical solutions in a RAD environment including a
reconciliations engine with a workflow front end for managing reconciliation exceptions and a suite of reporting tools and dashboards reporting to executive level. Subject matter expert status.

* Several utility applications to enhance business management using VBA Access/Excel and SQL Server.

* Advanced T-SQL Development. T-SQL programming including procedures, functions, triggers, transactions and query optimisation, database structure, definition and schema design. Creating business logic, relationships and constraints.

* Responsible for the migration of a database to SQL Server and deploying the application to 200+ Users.

* Conversion of Access queries to SQL procedures. Conversion of Access reports to use SQL datasets and procedures. Additional reporting in Excel and automation with Excel/ Word/Outlook.

* Development of a facility management tool, sourcing live facility utilisation from the banks central system.

* Regular User/Analyst/Team interaction to gather and analyse requirements. (RAD approach).

* Interaction with management and department heads to manage releases/delivery and training.

* Self driven to deliver solutions with minimal guidance. Able to build strong relationships with requirements providers and key data stakeholders enabling solutions to be developed as specified.
Voir plus

Mitsubishi UFJ SecuritiesApril 2012 - October 2012

Position: Technical Analyst / Database Analyst, SQL Server, VBA

* Development of a VBA/SQL workflow database replacing several disparate Excel workbooks.

* Migration of legacy systems employing Access/Excel/SQL Server to define processes and hold logic.

* Several utilities built in Excel/VBA to automate functions including payroll reconciliation, payroll submissions to Sage accounting, leaver/joiner processing, training management and headcount reporting.

* Upsizing legacy systems to SQL Server, developing data extraction processes, data validation routines, data mapping, error logging and reporting all with an emphasis on automation.

* Involved with system upgrades converting VBA to C# and the creation of a new database structure, mapping old processes into new and enhanced logic.
Voir plus

Lloyds Banking GroupDecember 2009 - March 2012

▪ Design and development of a front office Deal Pipeline Application with Excel VBA (ADO) and SQL Server  allowing teams to manage income flows, funding levels, probable outcomes and Liquidity (RWA’s) ensuring internal and external (regulatory) compliance.
▪ Excel based development of income forecasting solution module providing a detailed yet simplified golden source view of Income (current and forecasted) per client/sector/time period, including a graphical dashboard allowing all users to view data that was previously difficult to obtain.
▪ Development of an Access/SQL Server based workflow application handling Client Complaints and Client on boarding (KYC) ensuring regulatory targets and competencies were met. Reports generated for management and regulatory (FSA). Development of an Excel/VBA dashboard. Acquired SME Status.
▪ Automation of daily extracts from Bloomberg and Murex data sources, including interfacing with Sybase.

Mes compétences

VBA, Sybase, SQL Server Integration Services, SQL, SDLC, Release Management, Oracle PL/SQL, Microsoft Word, Microsoft SQL Server, Microsoft Excel, Jira, ETL, Design, Business Analysis, Analytics, ADO