Data Customer Service

Siddanagouda Sankanagoudar

Education

Bachelor of Engineering with specialisation in Computer Science and Engineering, Visveswaraiah Technological University Belgaum, India, 2009

Experience Summary

Working with Tata Consultancy Services from 2009 till date.

Working as a technical lead and developer in database/data-warehouse developer for Morgan Stanley from April 2010.

Strong knowledge and experience in database/data-warehouse development and maintenance including performance tuning, in RDBMs Sybase ASE and DB2 LUW.

Strong knowledge and experience in ETL development using Informatica PowerCenter.

In-depth knowledge and experience in design and development phases of software development life cycle.

Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.

Key domain experience in Banking/Financial sector.

Areas/Applications

Customer Identification Program (CIP)

-ILLUME: This is a Data warehouse framework, where the Customers are scoped into various jurisdictions, ranked for their RISK and marked complete/incomplete based on the analysis of them having necessary data and documents fulfilments according to the regulatory policy rules of the jurisdiction they belong to.

-FORECASTER: Whenever a new customer is added or a new account created, the data and document needs are projected for the same based on the scoping, risk ranking and the Regulatory policies of the jurisdiction they belong to. Only on successful meeting of the requirements, the process is allowed to complete.

Enterprise Data Group – Client Reference Data (EDG CRD)

-Darwin Suits of Applications: The Party Darwin, Account Darwin applications assist the creation and maintenance of the Party and Account information in Morgan Stanley. The Database operations needed for these applications are handled by us.

-GDS: Global Document System generates the document needs and stores the documents provided by the customers along with their validity and expiration.

-GCIA: This is an application developed for Prime Brokerage team of Morgan Stanley. The data is mainly derived from Darwin database through home-built PERL ETL jobs and enriched according to the Practice area. This involves Java developed front-end application and Sybase as the DB.

-MSCI: Morgan Stanley Client Index is an initiative towards creating a Firm wide Master Data of Party information. Consolidates data from A2, GWM, and LEXI and creates Golden Copy of Party information.

Career Profile

Since 2013 TATA CONSULTANCY SERVICES

Title Customer Identification Program (CIP)

Period Since August 2013

Client Morgan Stanley

Position Technical Lead

Responsibilities

Requirement analysis of the Regulatory rules

Implementation of rules in the database

Build and maintain Rules engine to process the rules

Build and maintain Database/Data Warehouse where the Rule-engine stores data

Coordinate with Quality Assurance and Release management for the migration of rules and Rule-engine components

Task tracking and status reporting

Implement the data model into physical database

Update the data model for the new changes

Creating automation scripts to reduce the effort of the team

Performance Tuning

Project

Customer Identification Program (CIP) - is very high visibility project with mandatory regulatory obligations for Morgan Stanley. The regulatory policies of various jurisdictions are coded as rules which are stored in database for application reference. The Rules engine reads these rules and classifies various Party into jurisdictions and if CIP program applies to them considering any exceptions. The party are also ranked for RISK. Based on the jurisdiction and Risk, data and document needs are generated and their subsequent fulfilment for compliance is calculated and certified.

I was part of the initial Proof of concept project, ILLUME data warehouse, where we developed rule engine to process the rules and store the CIP complete status and generate the reports to business users. The project was a success and our user base has increased with wider regulatory programs being covered. TCS team are the primary Subject Matter experts for these rules implementation.

Operating System UNIX, Windows

Languages SQL, Unix Shell scripting

Reporting Tool BOXI

Special Software Autosys jobs, DBArtisan, Perforce, Erwin Data Modeller, Sybase ASE 15, Informatica PowerCenter 8

Project Location Onsite - Newyork, USA; Montreal, Canada; Near shore - Guadalajara, Mexico.

Since 2012 TATA CONSULTANCY SERVICES

Title Enterprise Data Group – Client Reference data: Database Group

Period August 2012 – August 2013

Client Morgan Stanley

Position Developer

Responsibilities

Interacting with the client

Analysing the requirements and developing database objects.

Task tracking and status reporting

Implement the data model into physical database

Update the data model for the new changes

Creating automation scripts to reduce the effort of the team

Performance Tuning

Project

Enterprise Data Group (EDG-CRD) is a data centric practice area, which caters to all reference and market data needs of the firm. It is a single source of standardized and integrated data across firm (ISG, MSSB, and MSIM). This system is developed in Sybase, DB2, Perl, C#, IIS web container & ASP.NET. The team is responsible for providing L3 support and database solutions across the various practice areas horizontally in the domain. The team also caters to the migration of data to new models for regulatory compliance, service improvements and technological up gradations and migrations.

Operating System UNIX, Windows

Languages Perl, SQL, T-SQL, PL/SQL

Reporting Tool RADAR (In house tool)

Special Software Auto sys jobs, DBArtisan, Perforce, Rapid SQL, Erwin Data Modeller

Project Location Onsite - Newyork, USA; Montreal, Canada; Near shore - Guadalajara, Mexico.

Since 2010 TATA CONSULTANCY SERVICES

Title EDG CRD Engineering Services and Development – ACCOUNTS

Period April 2010 – October 2011

Client Morgan Stanley

Position Developer

Responsibilities

Interacting with the client

Analysing the requirements and creating database objects

Task tracking and status reporting

Enhance and maintain the database objects for client requirements

Performance Tuning

Level 2 support for databases

Deployment and object migration from TEST to QA and PROD environments.

Project

Enterprise Data Group (EDG-CRD) is a data centric practice area, which caters to all reference and market data needs of the firm. It is a single source of standardized and integrated data across firm (ISG, MSSB, and MSIM). The ACCOUNTS practice area acts as the GOLDEN source of data for ACCOUNT and PARTY information throughout the firm. The accounts are created in legacy Mainframe ADABAS files and simultaneously in Sybase based Darwin suite of applications. This has many downstream users consuming the data using web services and database stored procedures.

Operating System UNIX, Windows

Languages Perl, SQL, T-SQL, PL/SQL

Reporting Tool RADAR (In house tool)

Special Software Autosys jobs, DBArtisan, Perforce, Rapid SQL

Project Location Onsite - Newyork, USA; Montreal, Canada; Offshore - Pune, India.

Achievements

Received appreciations from the Morgan Stanley senior management for the successful implementation of the highly sensitive regulatory project – CIP.

Received appreciations from the Morgan Stanley team for making many enhancements and tuning stored procedures.

Automated many manual tasks and created KAs for team onboadrding.

Technical Certification:

Adaptive Server Enterprise SQL Developer Associate Version 12.5.2

Domain Certification:

NCFM : Financial Markets – A Beginners’ Module

Contact this candidate