Developer Engineer

Engineering Lead

SQL Server / ETL / C# / C++ / Markit EDM (Cadis) / Dundas / Radar Soft/ Strategy Companion/ ObjectiveC / Analytics / .Net / MVC / JavaScript / Web Services / Design Patterns / Object Oriented Analysis and Design / Agile / Azure / Netezza / AWS / Python

Qualifications Summary

●SQL developer and ETL developer with a background that spans over 12 years in Information Technology industry with extensive IT operations experience emphasizing Requirements Analysis, Design, Development, Integration and Maintenance.

●Experience in MSBI-2014/2012/2008/2005 (SSIS, SSRS and SSAS) with sophisticated technical skills in Design ETL and Reports.

●Expertise in developing MDM using Cadis/ Markit EDM

●Good hands on experience in Object Oriented programming with C++ and data structures.

●Hands on experience on Credit Risk Model, Mortgage Backed Securities, Asset Backed Securities, Credit Reports and Collateral Debt Obligation

●Performing RMBS Analytics, loan level analytics, Credit OAS, Loss and Prepay models and cash flow projections

●Expertise in Trepp, Intex Solutions, Loan Performance Model APIs.

●Good Experience in infrastructure related issues debugging and analyzing.

A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Optimistic team player in any environment.

Professional History

Blue Shield of California- San Francisco CA Developer Sept 2017-Present.

● Netezza SQL developer, design and fix ETL for BOR records.

● Python.

● Involved in finalizing ETL structure which includes extraction, error handling, notifications.

● Unix Scripting.

Santa Clara County - San Jose, CA SQL Database Consultant- January 2017- Sept 2017.

● Analyze data sources transactions and design ETL to extract data into new AIMS system to make better reporting and easy maintenance.

● Built staging database which includes tables, procedures, functions, triggers in Microsoft SQL for transformation.

● Involved in finalizing ETL structure which includes extraction, error handling, notifications.

● Worked on code optimization and SQL queries optimization which dramatically improved execution times fixed significant defects.

● Created SQL Server Traces in SQL Server Profiler to collects a variety of information about SQL Server connections, stored procedures and Transact-SQL statements.

● Developed dynamic configuration system for components for better error event handling.

Oaktree Capital Management, Los Angeles, CA SQL / SSIS (ETL) Developer March 2016 to Jan, 2017

●Successfully implemented MDM. We implemented security master a golden copy which is quite complex in nature as this us handling updates from multiple sources like Bloomberg, WSO, Grey Market, SNP, Moody and Fitch Data.

●Proactively, associated with the business users to jointly come up with initial user requirements.

●Good understanding on Data porter, Data Generator inbox, SQL, illustrator, data builder, inspector, constructor, data matcher, data flow and EDM Web client configuration Elements, Pages, Workflows.

●Good understanding of Markit EDM best practices and solution diagrams.

●Strong experience/ understanding of XML data models, supporting and developing end to end solutions using Markit EDM. Extensive experience in data modelling, database design and report design.

●Analyze Data Sources and design queries to extract data for operational reporting utilizing SQL Built queries in Microsoft SQL.

Oaktree Capital Management, Gurgaon, India SQL / SSIS (ETL) Developer May 2011 to Feb 2016

●Proactively involve in designing the daily, weekly, and monthly operational reporting.

●Involved in upgrading process from DTS to SSIS and with design architecture and reduced process time of many jobs.

●Involved in automating Index process system which reduces drastically process time and error free system.

●Without fail every month involved in monthly process with dead line first two working day.

Vichara Technology Gurgaon, India BI Developer / Support Jan, 2008 – May, 2011

●Wrote APIs which is consumed by web and console applications.

●Proactively involved the development of database including SQL views, function and stored procedures.

●Analysis of source LP Data and wrote multi-threaded console application with C# which for

●Formulated design and develop wrapper to use Intex API in C++.

●Created various project artifacts (e.g. standards & guidelines, program specifications, test strategy, test plans) as per the defined schedule and estimates

●Helping support team on various issues.

●Delivered the new features of Risk Model by taking complete ownership from design to implementation.

●Created dash board using third party control of Dundas and Strategy companion.

●Coordinate with team members to deliver the product

●Wrote MDX queries to fetch data from cube.

●As a full stack engineer involved in multiple roles.

Prime Consultants (P) Ltd, India Software Engineer Jan 2005 – Dec 2007

●Worked with the business analysts and SME team to understand the business requirements to be translated into design considerations.

●Proactively involved in small project management.

●Actively participated with user feedback and involved in releases.

●Worked as full stack engineer.

Professional History

Master in Computer Applications – UNIET, India, 2001

Bachelor in Science – LU, India, 2001

LinkedIn : https://www.linkedin.com/in/amit-singh-13351112/

Contact this candidate