*

Amit Choudhary

Tel: 201-***-****

Email: acxjpq@r.postjobfree.com

Over fifteen years of industry experience in application development and support for banking products and rating services.

A high level of expertise in product development and programming using Business Intelligence tools, Oracle, PL/SQL, SQL, Informatica, C, Java/J2ee, Sybase and SQL Server.

Strong command over Object Oriented principles, languages and large relational data warehousing concepts, logical/physical data modeling, Oracle concepts, PL/SQL programming and SQL queries.

Exceptional understanding of Business Intelligence and Data warehouse concepts, extensive experience in overall data warehouse, database, ETL and OLAP used by various systems.

In depth experience with building and maintaining Business Objects for querying and reporting through Business Objects v. 6.5, Business Objects XI R2 and Business Objects XI r3.

Expertise in Data Modeling and Design of Logical and Physical data warehouse.

Designed the entire data warehouse model to support ABS and ABCP applications.

Expertise in SQL Query tuning, providing tuning recommendations to Database jobs, time/CPU consuming queries and expertise in partitioning large tables using range partition technique.

Exceptional understanding of using Explain Plan, Oracle hints, creation of new indexes, usage of advanced analytical functions in SQL to improve the performance of SQL statements.

Experienced as a Techno-Functional Business Systems Analyst

Designed efficient business objects universes to query extensive Oracle data tables.

Worked closely with business to gather functional requirements and translate into system solutions.

Experienced in Dimensional Modeling, ER Modeling, STAR schemas, Snowflake schemas, Galaxy schemas, Facts and Dimension tables.

Involved in use of Explain plan, hints and other techniques for performance tuning of SQL queries.

Worked on estimation, analysis, design, development, testing, mentoring in various projects.

Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.

Designed and Developed complex mappings in Informatica to load data from various sources into the Data Warehouse using different transformations/ Stages like Joiner, Transformer, Aggregator, Update Strategy, Rank, Router, Lookup, Filter, Sorter, Source Qualifier and Stored Proc transformation etc.

Expertise in making use of Table functions, Indexes, Table Partitioning, Collections, Analytical Functions, Materialized Views, Ref cursors, Query Re-Write and Data warehouse concepts.

Led a team of 4 members, including three offshore developers and one full time developer onsite.

Extensive experience working in an Agile development environment. Technical Expertise

Languages Java/J2EE, C, PL/SQL, SQL.

Reporting Tools Business Objects 6.5, XI R2 and XI R3, Crystal Reports 9, Qlikview 11.2, Tableau 9 and Microstrategy 9.2

Databases Oracle 9i, Oracle 10g, Oracle 11g, MSSQL, Sybase, C-ISAM Scripting Tools VBScript, JavaScript, HTML, K-Shell, Perl, XML, XSL, XSLT Frameworks / ORM Spring 3.0, Hibernate 3.2

Data Loading Tools Informatica 8, Informatica 9

Data Modelling Tools ERWin

OS MS-DOS, Windows, UNIX

Education

MBA in Finance with a GPA of 3.6 from Baruch College, City University of New York in 2010.

Passed CFA Level 1 in 2012.

Bachelor of Engineering in Electronics with a GPA of 3.4 from Bombay University in 2000. 2

Experience

Standard and Poor’s Global Ratings Apr 08 till date Title: Lead Application Developer/Delivery Manager Projects: ABS Explorer, CP Explorer and STARS

ABS/CP Explorer is a one stop web based application for all ABS/ABCP amortizing deals for S&P ratings and surveillance analysts. Users have the ability to obtain rating information and track performance for over 500 amortizing and revolving deals, Perform trend analysis, Project losses using system generated or custom loss curves, setup transaction and user defined triggers and receive alerts via emails, perform powerful searched by using Advanced search mechanism, perform pro-active surveillance using system generated ROC variables and exception reports. Responsibilities:

Lead application developer for major enhancements and production support to the auto loans functionality and build out of Credit cards and Student loans asset types in ABS Explorer.

Gathered Business Requirements, Data Requirements and converted them into Functional and Non- Functional Specifications and worked with technical team to create, interpret and implement business rules into technical specifications/data design and data flow diagrams.

Designed and developed entire ETL process to load data from CRISIL (data provider) to load data in ABS Explorer using Informatica 9.

Designed and developed Business objects universe adding new tables and relationships.

Developed aggregate and complex reports containing performance data of Master trust, series and rating information. Used multiple data providers, Union, Intersection, Minus and Master/Detail, Cross Tab, Charts.

Designed and developed Dashboard reports for ABS and ABCP applications.

Key person responsible for the migration of Business objects reports from BO XI R2 to BO XI R3, customizing Business objects SDK code and modifying the reports accordingly.

Currently involved in doing a POC to consider various report technologies like Qlikview, Microstrategy and Tableau for conversion of 500 plus Business objects reports within the Structured finance group.

Developed dashboards in Qlikview and Tableau delivered through the web, enabling to measure the performance of ABS and ABCP market summary reports with analytical capabilities.

Developed Qlikview Load Scripts for distribution across multiple data sources.

Designed and developed few extensive Qlikview and Tableau reports using combination of charts and tables, built dashboards with interactive views for measures with forecasts, trend line and reference lines.

Understanding business rules and developing extremely complex reports for Assets and counterparty exposures in Commercial paper using Business Objects XI R2, PL/SQL and free hand SQL.

Wrote DB triggers, PL/SQL stored procedures, functions, Inline views and Materialized views. Created several Materialized views and scheduled them based on intervals.

Understanding business rules, creating user stories requirements documents, technical system documents and developing alerts engine for ABCP, LOC and RRS.

Day to day interaction with business users on validating the logic and modifying the documents as per the changes in logic to the alerts.

Created several tables, procedures, database views, functions and Database packages to create the alerts logic.

As part of POC project in choosing a new BI tool for the group, developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. Environment: Business Objects XI R2, XI R3, Oracle 10g, PL/ SQL,SQL, Informatica 9, Oracle DWH, Java, Unix, JSP, Spring, Hibernate, Javascript, HTML and CSS. POC Environment: Qlikview, Microstrategy and Tableau. 3

Oracle Financial Services Inc Mar 04 till April 08 Lloyds TSB Bank plc, NY, US Jan 05–Apr 08

Citibank, US Mar 04–Dec 04

Title: Team Lead

Flexcube Implementation

Description: Flexcube, a core banking software product is designed in such to meet all enterprise requirements in retail, corporate and investment banking. It has been rated the No. 1 banking product for 4 consecutive years. Lloyds TSB is implementing the Corporate side of Loans syndication and Loan and Deposits module of Flexcube.

Responsibilities:

Understanding business rules and developing extremely complex reports for Compliance, Risk Management, FINCON, Operations, BASEL extracts, FIS extracts, other back office and front office departments using Business Objects 6.5, PL/SQL and free hand SQL.

Created several history tables to meet the user requirements that were not supported in Flexcube. Written triggers, PL/SQL stored procedures, functions, Inline views and Materialized views.

Performance tuning of Flexcube End of day batch programs and of a dataware housing application called Flexcube Reporting system (FRS). The purpose of FRS is to keep historical data of

Used multiple data providers, Union, Intersection, Minus and Master/Detail, Cross Tab, Charts.

Publishing reports using Info View and training users for ad hoc reporting, refreshing reports. Environment: Windows 2000, Business Objects 6.5, Oracle 9i, PL/ SQL and SQL queries, Oracle D2K Polaris Software Labs (Formerly Citicorp Overseas Software Ltd) Dec 00 – Mar 04 Citibank, Russia and South Africa Dec 04–Mar 04

Title: Senior System Analyst

Description: Citigateway Servers, an integral part of the Citibank Cash Management strategy, open the gateway for the Citi-Banking world to interact with the local Central Bank Clearing System of a country for clearance of domestic transfers /requests and within Citibank Cash Systems as well. The formats of these transfers are in the form of pre-defined financial instructions, which are agreed upon, as apart of the Interface Specifications. Citigateway servers follow the 3-Tier architecture with the components/modules adequately isolated to render them more Flexible in terms of component reuse and deployment. Responsibilities:

Analyze business requirement, prepare functional specification and unit test case.

Completed reverse engineering for Citibank Morocco, Kazakhstan for its migration to Citigateway.

Provided support for various international branches.

Involved in implementation of Clearing Server for Citibank Morocco and Kazakhstan. This includes development of the validation component satisfying all the business rules. Environment: Windows NT, C++, VC++ 6.0, PL/SQL, Crystal Reports, SQL Server 2000 and VB Honors and Awards

Winner of Polaris GEM Award in year 2003

Winner of Standard and Poor’s ACE Silver Award in year 2009 for innovative process for ABCP and Standard and Poor’s ACE Bronze Award in year 2010 for process improvement for ABS group

Contact this candidate