LOKESH KALEGOWDA

Markit EDM Consultant

EXPERIENCE SUMMARY

20+ years of overall experience with proven skill in Analysis, Design, Development, Testing and Maintenance of Finance and Investment domain application software

Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment with resource constraint

Expert level experience in Markit EDM platform and worked on both Onsite and Offshore Model

Over 8 years of experience in capital markets, Asset management and financial services

Extensive experience in Master Data Management and Reference Data Management.

Experience in processing Trades, Transactions, Positions, Performance and Risk data.

Handled Matching and Mastering for different asset classes like equities, fixed income, currencies, futures, options.

Experience in processing Credit risk data and ratings from Moody, Fitch and S&P.

Experience in processing Bloomberg products like Back Office, Per Security and fundamental data

Experience in working with different vendors data like Bloomberg, FactSet, Barclays Point, Algorithmic, Barra

Extensive experience in L2 and L3 Production Support for Markit EDM project, Analysis of production issues, Identification of root cause and provide break fix as short-term solution and create Jira for long term solution.

Extensively worked on SSIS to integrate and analyze data from multiple homogeneous and heterogeneous information sources

Extensively worked on complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)

Good experience in overall software development life cycle with good knowledge of processes like version control, defect tracking and package promotions.

Ability to work in a team as well as independently with minimal supervision.

A quick learner, motivated problem solver with strong analytical skills.

Possess rich knowledge in Software Development Life Cycle Management, Software Project Planning, Estimation Techniques, Process implementation.

Experience in working on Safe Agile methodology

EDUCATION

Bachelor of Engineering in Electrical and Electronics from Mysore University, India

SKILLS

Operating Systems : Windows.

EDM Tool : Markit EDM (Cadis) Versions: 7.5, 8.5, 9.5, 10.5, 18.2 and 19.2

ETL Tool : SSIS

Database : MS SQL SERVER 2017/2014/2012/2008, Oracle 11g, MySQL, DB2

Reporting Tool : SSRS, ClickView, Power BI, Tableau

Script Language : Windows batch Scripting, Shell Scripting

Middleware : IBM WebSphere MQ Series, Data Base Message Queue, TIBCO JMS, Kafka Message Queue

Scheduler : Control-M, UC4, Orsyp

FTP Tool : MoveIT, WinSCP

Language : C#, VB.Net, VB, SQL, PLSQL, XML, XSLT, Python, NoSQL

API : Exposure to MuleSoft

Cloud Technology : Exposure to AWS S3, CouchBase

MS Technology : Asp.net, WCF, MVC, Web Services

Version Control : VSS, TFS and SVN, GitHub

Other tool : JIRA, ServiceNow, Denodo, version One

CERTIFICATION

Markit EDM Professional

Markit EDM Certified User Interface

Markit EDM Introduction Exam Qualified

Flip Certified in Banking and Financial Markets

PROJECT EXPERIENCE

American Century Investments, Kansas City, MO May 2019 - Till Date

Role: Sr. Markit EDM Developer,

American Century Investments is a leading asset manager managing more than $225 billion assets on behalf of their clients.

Responsibility:

Translate business requirement into technical design specifications

Used extensively Data Porter, Data Flow, Data Constructor, Data Inspector, Role Builder Data Generator, Data Matcher, Core Matcher and UI components

Implemented Process keys to improve performance for vertical validation, it increases the performance of vertical validation

Worked on matcher to setup new source, mastering and then released to DB2 for Trading

Supporting data management team if any issue while doing mastering and release to downstream applications (Eagle pace, DB2, SimCorp)

Design and developed single Data flow to load Bloomberg back office files from different region with different column structure.

Design and developed Copp Clark Holiday calendar and used Kafka Message to push data

Working on MuleSoft API for data transfer to AWS S3, CouchBase

Working on Product and Portfolio master and developed User Interface screens

Created Core Matcher POC to convert legacy Matcher

Converted Legacy data inspector as per latest version

Support the production environment and fix the issues as needed

Leading offshore 5 members team

Environment: Markit EDM V18.2 and 19.2, SQL Server 2017, DB2, Oracle, Version One, Service now, UC4 job scheduler

CIT Bank, Livingston, NJ April 2015 – April 2019

Role: SQL /MSBI Developer

The CIT Bank CIT Group Inc. is a Bank Holding Company, with more than $60 billion in finance and leasing assets that provides financial and advisory services to small and middle market businesses.

Responsibilities:

Designed, developed and automated various data feed load processes from different Vendors

Worked on Lease, Loan and Mortgage source systems to provide data to OneSumX tool to prepare federal reports 14M,14A and 14Q

Collected business requirements from users and translated them as technical specs and design docs for development.

Database design and process flow design to set up interfaces for inbound/outbound vendor data feeds using EDM/ETL Tools.

Redesigned existing legacy Extractor ETL framework developed on T-SQL

Designed Python wrapper using T-SQL and python code for data driven process

Designed and developed consolidator process to pull the data from heterogeneous data source systems and then stitched data for end consumers

Designed and developed automated reconciliation environment to compare the data disparity between source and destination.

Created complex ETL packages using SSIS to extract, transform and load the data from heterogeneous data sources to destination

Mentoring junior developers for implementing design approaches in Extractor, SSIS and Python for implementing solutions.

Worked on complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS

Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non queried parameters).

Environment: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, SSMS, SQL Profiler, UNIX Shell script, BCP’s, XML, Oracle 11g, C# and Asp.Net, Markit EDM

KELLOGG, Battle Creek, MI Sep 2014 – March 2015

SQL /MSBI Developer

Responsibilities:

Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

Involved in development and implementation of SSIS, Azure Cloud services

Debug and analyze the data in SQLite DB file created at Azure blob storage

Designed Data Mapping documents, DDL scripts, and Data Dictionary and Meta data of the models and maintained them.

Wrote database functions, scripts, stored procedures, views, triggers and dynamic SQL query etc. using T-SQL

Used SSIS to create ETL Packages to validate, extract, transform and load the data to data warehouse and data mart databases

Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component

Hermes Fund Managers, London, UK Nov 2011 to Sep 2014

Role: Markit EDM Developer,

Hermes Fund Managers is a global asset manager managing £33.5 billion of assets on behalf of their clients across 14 specialist investment areas. Hermes Fund Managers has a growing global presence; supported by their head office in London.

Responsibility:

Designed and developed to enhance existing trade flow process to improve performance

Designed and developed Generic Interface to load listed and unlisted portfolio data coming from different vendors

Designed and enhance existing Algo system to UBS Delta system to handle to measure risk and performance across fixed income, commodities and equities

Designed and support to expand the range of instruments to trade to include ETD (Commodity) Options, TRS commodity swaps (1,2 and 3 Legs) and OTC (Commodity) Options

Designed and developed mastering solution for issuer and their ratings received from Moody’s, Fitch and S&P

Successfully took over Production support from client and setup 10 members team in offshore

Created Data generator to show the trade flow exception and process status

Implement new XML porter by replacing deprecated method

Used Event watcher and process launcher to communicate between modules

Used extensively Data Porter, Data Constructor, Data Inspector, Role Builder and Data Generator

Ensure that code developed is reviewed and is meeting Markit Best practices

Defect tracking and their resolutions in various environments.

Level 2 production support for Trade flow related issues

Designed DOS command tool to automate Cadis release process.

.

Environment: Markit EDM, SQL Server 2008, IBM Web Sphere MQ, Think-Folio, MoveIT central, Orsyp Scheduler tool and JIRA

DBS Bank, Singapore Oct 2010 – Aug 2011

Role: .Net Developer and Murex report

Responsibility:

Prepared prototype as per business requirement

Designed and developed .net application for Rate management system

Design & coding ASP.Net web pages

Developed oracle Packages and Stored procedures and Murex report

Extensively used Telerik Grid and other controls

Environment: Visual Studio 2010. ASP.Net, Oracle 10g, Telerik Web control, Murex

Mindtree, Bangalore May 2005 - Jan 2018

Role: Technical Manager

Responsibility:

Designed and Implemented multiple database and .Net appliactions using C#, VB, Asp.Net, WCF and SQL Server 2005/2000, DTS and Oracle

Worked as Individual contributor and Techinical Lead for multiple .Net and Database applications for customer like ESP, Symantec, DBS, Hermes, Kellogg and CIT

Worked as onsite coordinator/Lead in Singapore, London and US

Designed and developed WCF service interfaces, Web services, MS Windows and Web Applications

Worked on Markit EDM and ETL (SSIS) tools

Worked on database migration from SQL server 2000 to 2005

Extensively worked on Stored Procedures, Triggers, Functions, Indexes, Tables, Views

Environment: Visual Studio 2013/2010/2008. ASP.Net, VB.Net, C# and Web services, WCF

b-Commerce Info system, Bangalore April 2001 - March 2005

Role: SQL and .Net developer

Developed T-SQL Queries, Triggers, Functions and Stored Procedures.

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Used SQL Analyzer and Profiler analyzing the SQL statements and procedures.

Worked on .Net and Visual Basic 6.0 to create application

Designed and Developed Inventory application for multiple customers

Extensively worked on Stored Procedures, Triggers, Functions, Indexes, Tables, Views

Environment: Visual Studio 2002/2005, VB 6.0. ASP, C# and Web services

Contact this candidate