Dilip Singh

Dilip Singh Email and Phone Number

Sr. Data Architect | ETL @ Morgan Stanley
Austin, TX, US
Dilip Singh's Location
Austin, Texas, United States, United States
Dilip Singh's Contact Details

Dilip Singh work email

Dilip Singh personal email

n/a
About Dilip Singh

15 + years of experience in Developing and Programming, Data Modeling, Data Analysis, providing Business Intelligence and Data Warehousing solutions with technical expertise in PostgreSQL 16.0, MS SQL Server 2014/2016, Snowflake 8.2, DBT (Data build tool) V1.8, Azure Data factory (ADF), UNIX Shell Scripting, AWS, Informatica 8.1/9.1, Oracle PL/SQL, Sybase ASE 12.5/15.0/17.0, SSMA, CI/CD, AutoSys, Airflow.Strong knowledge of Migration using AWS Services, Informatica, SSIS, DBT (Data build Tool) and Azure Data factory pipelines, SSMA , Oracle PL/SQL , PostgreSQL , MS SQL , Sybase ASE/IQ and Snowflake.Skilled in end-to-end development software products from requirement analysis to system study, coding, testing, configuration, documentation, and implementation. Experience in Evolving Strategies and developing Architecture for building a Data warehouse by using data modeling tool Erwin.Extensively worked on developing and debugging ETL/ELT pipelines to extract, load and process data from one instance to another instance using various sources like Structured, Uninstructed, Semi Structured data along with implement the rules to fulfill business logic, data cleansing and data validation.Well versed in developing complex SQL queries, complex joins, stored Procs, views, function, trigger and packages. Responsible for developing SQL based business application for automated Trading platforms.Extensively worked on performance tuning of T-SQL and PL/SQL to minimize latency and maximize throughput, finding the incorrect histogram, correct way to use of index, improve parallelized, upgrade to use new optimizer in T-SQL query, partitions the tables to improve performance.Ability to manage complete SDLC, adept in leading and working with the team, analyzing the client requirements, translating new ideas into client's solutions including opportunity identification, requirement analysis, designing and development, implementation and support. Good Experience to write the python script to load/compare the analytics reports and send them to the end users. Also, have good exposure to use python to generate the analytics report for the end users.Good experience in Capital market and Banking domain to handle OPTIONS, FUTURES and Other Derivatives , and Bonds (Munis, agency, corporate, treasury, taxable Munis ,fixed bonds, callable bonds, floater, tips etc.). Good understanding on risk measures data like YTM, YTW, AVERAGE LIFE, DURATION, YTA,YTC, OAS, CONVEXITY etc.. good exposure on Agile / Scrum software development methodology.

Dilip Singh's Current Company Details
Morgan Stanley

Morgan Stanley

View
Sr. Data Architect | ETL
Austin, TX, US
Employees:
94640
Dilip Singh Work Experience Details
  • Morgan Stanley
    Sr. Data Architect | Etl
    Morgan Stanley
    Austin, Tx, Us
  • Pimco
    Senior Data Engineer
    Pimco May 2022 - Present
    Austin, Texas, United States
    Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activitiesand application programs and document the understandings forinternal team referencing. Interact with functional/end users to gather requirements of corereporting system to understand exceptional features users expectingwith ETL and Reporting system and also to successfully implementbusiness logic.Manage and handle activities such as impact analysis, planning ,design and development of CM-ETL migration for Cloud platform using tools like PostgreSQL, DBT (Data build tool), Niagara(Inbuildtool), SNF, Oracle PL/SQL , MS SQL Server , AWS Services, Autosysand Airflow.Migrate the Legacy DB objects which were written in Oracle PL/SQL into PostgreSQL and make minimized latency and maximize throughput, find the incorrect histogram, correct way to use ofindexes, improved parallelized, upgrade to use new optimizer in T-SQL query, and partitions the tables to improve the performance.Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the most appropriate alternative. Involved Conducted and participated in process improvementdiscussions and recommending possible outcomes and focused onproduction application stability and enhancements.
  • Nomura Securities International, Inc.
    Senior Data Engineer
    Nomura Securities International, Inc. Feb 2021 - May 2022
    India
    Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.Interact with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.Manage and handle activities such as impact analysys, planning ,design and development of GLOSS migration for Cloud platform using tools like SSMA (Sql server Migration assistance ), Informatica ,MS SQL SERVER , SSIS , SYBASE ASE , SYBASE IQ.Transformed DB from Sybase ASE and Sybase IQ to AZURE platform included 2000 DB Ojcets and hundreds of GB of data in short spam of time . Used SSMA to migrate DB Objects and data. Generated Pre and Post migration assessment reports. Used and created Python utility to read data in batches with parllel process to geneare the reconsilations reports for the high data volumeset. Written utility to make sure not missing any db objects for themigration.Identify and Handling Database Performance, Stored Proc, SQL Blocks & queries using index, stats, sp_recompile and other utilities such as execution plan of the stored proc, or using SQL Adviser/SQLProfiler. Verified the database configuration details.
  • Pimco
    Senior Data Engineer
    Pimco Mar 2018 - Feb 2021
    Austin, Texas Metropolitan Area
    Analyzed the existing code written in T-SQL, PL/SQL to minimize latency and maximize throughput, finding the incorrect histogram, correct way to use of indexes, improve parallelized, upgrade to usenew optimizer in T-SQL query, partitions the tables to improve the performance.Developed complex SQL queries, complex joins, stored Procs, views, function, trigger and packages for the FES to use in Night cycle models. Identify and Handling Database Performance, Stored Proc,SQL Blocks & queries using index, stats, sp_recompile and other utilities such as execution plan of the stored proc, or using SQL Adviser/SQL Profiler. Verify the database configuration details. Used to involve in Operational support for all critical issues requiring intervention. Interact regularly with business customer and the technical team to fixe those issues, Analyzed an Enhanced the codesfor the Night cycle models (MUNIS, BULLET, AGENCIES , BLOTTER etc ) with Oracle/plsql , Unix shell scripting and Python technologies.
  • Bank Of America
    Senior Data Engineer
    Bank Of America May 2017 - Feb 2018
    Chicago, Illinois
    Technologies- SQL Developer 2012/Sybase 15.7/Autosys/Unix Shell scriptASK mainly deals with business data related to Capital market and investment banking. The primary business objective of this project is to received confirmed and unconfirmed trades from the other sources like DRUM,ARSENAL, ACID, AVALON and generate different-different type of reports like Daily Holdings, Maintenance, Settlement and Trade Blotter.We use Reporting GUI which is a client-server reporting application designed and developed internally to support company's middle office services reporting needs and that are running on database server called ASK_PROD.The GUI application consists of 350 active reports. The generated report can be downloaded in formats like pdf and excel format.We use Autosys application as well where we can schedule job, parameters and the generated report can be downloaded and sent to desired location. It exports trade data from a various data sources to the destination specified by the user.
  • Syntel Inc
    Technical Specialist
    Syntel Inc Aug 2015 - May 2017
    Kansas City, Missouri Area
    Technologies- SQL Developer/Reporting services/Sybase15.7/Unix shell scriptingManaging and handling activities such as requirement gathering, impact analysis, designing, development and maintenance related to Database, Scripting; raising RFCs and Incidents, respond to user queries, interaction with clients, UAT, releases, as well as coordinating with different teams and end users.Assist in the development, design and implementation of application systems using SQL Developer /Sybase 15.7. Serve as member of a project team or as an individual contributor when required.Assist in design of complex, global or strategic development projects. Identify and address interfacing functions and applications.Tuned Stored Proc, SQL Blocks & queries using index,stats,sp_recompile and other utilities such as execution plan,noexec,etc
  • Hcl America
    Lead Engineer
    Hcl America Mar 2014 - Jul 2015
    Denver, Colorado Area
    Assist in design of complex, global or strategic development projects. Identify and address interfacing functions and applications.Tuned PL/SQL Blocks & queries using index,stats,sp_recompile and other utilities such as execution plan,no exec,etc.Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart with Invoice level information from SAP systemsFixe if any jobs failure any times 24*7 for Daily, Weekly or Monthly job.
  • Hcl Technologies
    Lead Engineer
    Hcl Technologies Nov 2010 - Mar 2014
    Noida Area, India
    Interacted with clients and business users. Involved in requirement Created technical design draft.Created logical and physical data models.Written Procedures, Functions & Triggers for different operations.Performance tuning of query and scripts.UAT support at off site.Post production User supportWorking in Informatica 8.6 for transform data using transformation such as filter, aggregator, joiner transformation.Creating canned reports for Business User.Managing and handling activities such as requirement gathering, impact analysis, designing, development and maintenance related to Database, Scripting and ETL; raising RFCs and Incidents, respond to user queries, interaction with clients, UAT, releases, as well as coordinating with different teams and end users.Working as Project Lead and manage and handle the resource which are working from offshore.Participate in daily scrum meeting with the client.Created conceptual, logical and physical data models.Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart with Invoice level information from SAP systems.
  • Cba Group
    Database Developer
    Cba Group Jun 2008 - Nov 2010
    Delhi Area, India
    Managing and handling activities such as requirement gathering, impact analysis, designing, development and maintenance related to Database, Scripting and ETL; raising RFCs and Incidents, respond to user queries, interaction with clients, UAT, releases, as well as coordinating with different teams and end users.Working as Project Lead and manage and handle the resource which are working from offshore.Participate in daily scrum meeting with the client.Created conceptual, logical and physical data models.Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart with Invoice level information from SAP systems.Written Procedures, Functions & Triggers for different as per business requirement.Used the Sybase procedures for Informatica mappings for truncating the data in target tables at run time.Performance tuning of query and scripts.Used the Sybase procedures for Informatica mappings for truncating the data in target tables at run time.Post production User support.

Frequently Asked Questions about Dilip Singh

What company does Dilip Singh work for?

Dilip Singh works for Morgan Stanley

What is Dilip Singh's role at the current company?

Dilip Singh's current role is Sr. Data Architect | ETL.

What is Dilip Singh's email address?

Dilip Singh's email address is di****@****ica.com

What schools did Dilip Singh attend?

Dilip Singh attended Dr. A.p.j. Abdul Kalam Technical University, Dr. A.p.j. Abdul Kalam Technical University, Chatrapati Sahuji Maharaj Kanpur University, Kanpur.

Who are Dilip Singh's colleagues?

Dilip Singh's colleagues are David Rasdolsky, Rachel Deaton, Joseph Gentile, Ray Spina, Cep, Richa Agarwal, Elena Huang, Luke Mcgrath, Cfp®.

Not the Dilip Singh you were looking for?

  • Dilip Singh

    Business Development | Media & Entertainment At Tata Elxsi
    Bengaluru
  • 2
    gmail.com, solunus.com
  • Dilip Singh

    Hightstown, Nj
    10
    yahoo.com, yahoo.com, aol.com, yahoo.com, yahoo.com, compuserve.com, usa.net, hotmail.com, nytp.com, nytp.com

    7 +157129XXXXX

  • Dilip Singh

    Alpharetta, Ga
    4
    gmail.com, baruchmail.cuny.edu, equifax.com, equifax.com

    5 +163064XXXXX

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.