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.
• Working knowledge of Hadoop/Bigdata, Hive, Pig, No SQL, MySQL, Cloud Computing.
• 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.

TECHNICAL SKILLS

• SQL Server / ETL / C# / C++ / AWS / Python / 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

PROFESSIONAL EXPERIENCE

Confidential - San Francisco, CA

Developer

Responsibilities:

• Netezza SQL developer, design and fix ETL for BOR records.
• Facilitated insightful daily analyses of 60 to 80GB of BOR records.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.
• Provided design recommendations and thought leadership to sponsors/stakeholders that improved review processes and resolved technical problems.
• Tested raw data and executed performance scripts.
• 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.

Confidential, Los Angeles, CA

SQL / SSIS (ETL) Developer

Responsibilities:

• 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.
• Worked on complex PL/SQL and cursors.
• 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.

Confidential

SQL / SSIS (ETL) Developer

Responsibilities:

• 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.

Confidential

BI Developer / Support

Responsibilities:

• 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.

Confidential

Software Engineer

Responsibilities:

• 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.