Satish Singh

Columbus, OH, USA

Ph: +1-614-***-****/+1-614-***-****

E-mail: acrglt@r.postjobfree.com

Personal Synopsis:

A certified Ab-Initio Technicia having over 12 years with over 10 years in Business Intelligence, Data warehousing and Data Management using Abinitio.

Extensive experience in finance industry especially around payment system products, equity trading, Corporate Finance, Risk and compliance reporting.

Well familiar with Data Warehousing, Data Quality, Data Integration, Data Governance, Meta Data Management, and Data Masking concepts.

Extensive experience in finance industry especially around payment system products, corporate finance and compliance reporting

Have good exposure to Proof of Concept (POCs), Solution Designing and Architecture design.

Comprehensive exposure to various complex processes involved in Abintio Design and developmnt like Component folding, XML Processing, Continous Flows, Message Queue data retrial, Multiple layout data processing from various source system such as mainframes, OLTP databases, UNIX flat files, XMLs

Well versed with Implementation, Sustain and Optimization (S&O) processes.

Worked extensively with major financial MNCs like JPMorgan Chase, VISA, CITIBANK, Barclaycard, American Express, Capital One and UBS IB.

Client Location experience in USA for 46 months, 15 months in Singapore and 11 months in UK of handling Requirement Gathering, Impact Assessments, and Feasibility Analysis.

Apart from regular project activities, was involved in imparting Ab-initio training, coaching, team mentoring, recruitment and best practices setup across organization.

Have broad understanding of Hadoop, Tableau and SAS.

SKILLS:

Data warehouse Tool : Abinitio, SAS, Tableau

OPERATING SYSTEMS : Mainframe MVS, UNIX (HP, Solaris) and Win-NT

LANGUAGES : C, C++

DATABASES : Sybase IQ & ASE, Oracle 8.0/9.0, Teradata, Netezza

DESIGN TOOLS : Visio. Erwin 4.0

Shell & Utilities : Korn, BASH, CSH

OTHERS : Toad 7.0, Rational Clear case, Rational Clear quest, Visual Source Safe, EME, Test Director 8.0, Electronic Work Bench

EXPERIENCE:

JP Morgan Chase, USA 33 months

Responsible for delivery and solutioning various projects corporate finance, risk and compliance related projects. Worked simultaneously on multiple multi-million dollar undertakings. Worked in various areas of Corporate Finance such as Treasury Data Mart, Cost of Funding Engine, Management Information System, Basel Report optimizations, RAFT and Liquidity Risk Infrastructure.

Key Responsibilities:

oHigh Level project architecture designfor any new changes, effort estimation, overall cost estimation and gap analysis

oEvaluated various new products from Abinitio including ACE, BRE, Query>IT, Metadata Hub, etc. Coordinated Co-Op upgrade activities

oDocument best practices for design, build along with various process improvement initiatives to ensure quality improvement

oOwn projets; understand and translate business requirements for reporting and database solutions assigned to the team in partnership with Business Users, Analysts, Data Modellers, etc.

oDesign, Build and Review the code, design & requirement documents created by peers and partners/

oOptimization of different processes.

Environment: AB-INITIO GDE / CO>OP 3.1.2/3.07/2.14, EME, ORACLE, UNIX, TABLEAU,

VISA, USA 10 months

Global Member Billing Solutions is the only system in VISA which is responsible for rating, billing and generating data for general ledger for all its member banks. It receives data from various sources and generates invoices for its global customers.

Billing team use a UI portal which is used to set configuration data related to Entity relationship, Invoice Account Associated, Billing Rate setup, Invoice formats. Invoicing process will apply all relevant billing logics to associated transactions and generate invoices.

Key Responsibilities:

High level project architecture design for any new change, effort estimation, overall cost estimation and gap analysis.

Leading a team of over 12 resources working in various areas of project.

Carry out sustain and optimization of existing application.

Co-ordinate existing infrastructure maintenance in accordance to business and technical needs.

Work allocation, mentorship, capability development and related activities.

Own projects; understand and translate business requirements for reporting and database solutions assigned to the team in partnership with business Users and Analysts.

Generation of various MIS reports like: project progress report, financial reports etc.

Review the code, design and requirement document created by peers and suggesting changes for continuous improvement of team's deliveries.

Optimization of different processes and performance tuning.

Environment: AB-INITIO GDE / CO>OP 3.0.3, EME, UNIX, DB2, MVS, JAVA, MICRO STRATEGY

Citi Bank, Singapore 12 Months

Compliance Reporting is a system designed and developed for in-house & Third Party post trade surveillance for any Anti Money Laundering activities. Trade data from various trading platforms was picked and reported to MANTAS for in house AML surveillance and sent to FINRA (3rd Party). Data sources were varied including data from XML, Mainframe, Fix Tags, UNIX flat files etc.

Key Responsibilities:

Own projects; understand and create business requirements for reporting and database solutions assigned to the team in partnership with business users, Business Analysts.

Leading a team of over 6 team including consultants.

Generation of various MIS reports like: project progress report, financial reports etc.

High level project architecture design, effort estimation, overall cost estimation and gap analysis.

Work allocation, mentorship, capability development and related activities.

Review the code, design and requirement document created by peers and suggesting changes for continuous improvement of team's deliveries.

Optimization of different processes and performance tuning.

ENVIRONMENT: AB-INITIO GDE 1.15, CO>OP 2.15, EME, UNIX, NETEZZA, ORACLE

Steria India Ltd 25 Months

Client : Barclay Card.

Abinitio Architect /DESIGNER May, 08 – June, 10Test Data Depersonalization is a system which is a system developed under the jest of the bank for protecting the customer data at any cost. In this project the key data elements identified and there values are changed judiciously to hide the details from the users of the test data.

Scarecrow is a system designed and developed to replace the existing application used by Barclaycard for merchant transaction verification. The existing application was a sunset application supported by Fair Isaac. In the new application, apart from keeping/enhancing existing functionality, many more new features will be incorporated to enhance the over all effectiveness of the application.

Enhanced Prospects Pre-Selection is a system designed to increase recruitment of Barclaycard customers across all of Barclays’ channels. Business have realized that the low success rate (about 60-70%) of the current pre-selection process is affecting the Revenues, Customer Experience, Staff Productivity and Staff Motivation. Project involved detailed scanning of Internal and External Prospects (received from Experian) and creating a warehouse to cater customers and service representative needs at three levels customer care, Branches and Online net access.

Self-Serve is a system which enables Acquirers to enroll themselves for the service which will provide them access to their monthly statements in electronic format. This project is developed to enable the client to come over an strategic disadvantage of not having any online system in place which helps the acquirers to get the statements in electronic format.

Key Responsibilities:

Own projects; understand and create business requirements for reporting and database solutions assigned to the team in partnership with business users, Business Analyst and Project Leader BI/Managers.

Lead a team of over 15 consultants on technical capability buildup and 8-10 people on direct project resources.

Review the code, design and requirement document created by peers and suggesting changes for continuous improvement of team's deliveries.

Guide team and self develop and support reporting and database solutions as per discussion with business users, requirements and design documents.

High level project architecture design, effort estimation and gap analysis.

Optimization of different processes and performance tuning.

Team mentoring, Capability development and related activities.

Environment: AB-INITIO GDE 1.14(CITRIX), CO>OP 2.14, EME, IBM MVS, CONTINUOUS FLOWS, UNIX.

American Express 21 Months

Abinitio Architect 6 Months

Tradeline is an analytic environment developed for 4 different markets Japan, Taiwan, Hong Kong and Singapore. Merchants and Customers data received from credit rating agencies like Experian and Trans Union, having details of get processed by the system which is then used by Business Analyst for various campaign designs for new products design and services.

Key Responsibilities:

High level interface design for rapid development of the project.

Lead a team of 4 Abinitio consultants.

Lead POC analysis for this project.

Mentoring people and reviewing project progress.

Data analysis for system migration from legacy to new system.

Performed gap analysis, change management and dependency analysis.

Key Achievements:

Achieved a disk space compression of 40% for a data repository of 2TB.

Implemented advanced concepts like XML parsing, XML processing and component folding.

About 50 graphs including 12 complex graphs developed in short span of 4 months.

Achieved a defect rate of less than 4% over industry standard practice of 10%.

Environment: AB-INITIO GDE 1.14(CITRIX), CO>OP 2.14, EME, IBM MVS, UNIX, TERASTORE, VISIO.

Abinitio Lead 8 Months

Credit Authorization System

It s a proprietary system which is used to authorize all kind of credit transactions taking place across the world on American Express Network. The application is developed to provide an analytical environment used by various Business teams for Risk Analysis, Marketing Campaign Designing, Product Launch, Fraud detection, Collections and Prevention. Project involved enhancement and support.

Key Responsibilities:

Lead a team of 7 Abinitio professionals.

Mentoring people and reviewing project progress.

Designed and developed 3 critical graphs.

Assignment of issues to team members.

Key Achievements:

Zero defect delivery is achieved for three code releases.

Various job sequence and graphs optimized to reduce the process completion time by 40%.

Data issues for record set of size more than 160GB were fixed in less than 6 Hrs.

Environment: AB-INITIO GDE 1.13(CITRIX), CO>OP 2.13, EME, IBM MVS, SYBASE IQ, UNIX.

ETL Designer 7.5 Months

Generic Architecture Development 5 Months

It is developed to create a platform where the same graphs can be used for dynamic transform functions generation, monitoring data quality and take action accordingly, send email communication to concern groups if required and apply business rules/logics. This has reduced the overall development time and kept a tight noose on the data quality.

Key Responsibilities:

Feasibility analysis and meetings with various business and technical groups.

Performed process flow design and scheduling the flows.

Performed gap analysis and SLA management.

Lead a team of 5 persons.

Performed code review and performance tuning.

Key Achievements:

MIS developed on Data quality is highly acknowledged by higher management.

A unique design saved us generation of more than 200 additional graphs.

The project was completed 2 months before the deadline.

Environment: AB-INITIO GDE 1.13(CITRIX), CO>OP 2.13, EME, SYBASE ASE, UNIX.

Customer Verification Group Email 2.5 Months

It is an application developed for sending email to the merchants when they enquire about a customer for verifying a transaction. The case thus setup is then reviewed manually by a team of Authorizers and the action taken is sent to our system. These details are then used to generate XMLs which will be sent to merchants.

Key Responsibilities:

Designed and developed the whole application.

Low-Level Designing and Scheduling the Flows.

Lead a team of 2 persons

Key Achievements:

This project implementation saved $ 200,000 annually.

Environment: AB-INITIO GDE 1.13(CITRIX), CO>OP 2.13, EME, IBM MVS, SYBASE ASE, UNIX.

Infosys Technologies Ltd 37 Months

Major IT Services Company, with a work force of more than 90, 000 working across the globe primarily in United States of America.

Client : Capital One, USA.

ETL Designer 16 Months

Data Management Infrastructure (DMI)

A system which manages emails sending and monitoring processes to different customers. DMI act as a secure channel to keep track of customer’s responses. Project involved Implementation, support activities.

Key Responsibilities:

Design and Development of Application with view of code reusability.

Coordinated with different partners for Change Request, Requirement Gathering etc.

Performance tuning of graphs.

Key Achievements:

Pre-removal of bad email addresses saved $120000 annually for the company.

Job ran without any production issues for more than 150 days.

Environment: AB-INITIO GDE 1.13(CITRIX), CO>OP 2.13, UNIX, ORACLE 8.0, ERWIN.

ETL Developer 11 Months

Common Loan Origination Data Warehouse

It is a system which is developed to create an auto loan processing system. After getting processed through this system the application will then categorize into three groups: (a) Accepted (b) Declined (c) In Tolerance. Actions are then taken depending on the business policy of the company.

Key Responsibilities:

Developed and supported different modules.

Developed shell scripts to automate the file manipulation and loading procedures.

Prepared test cases and performed system and integration testing.

Key Achievements:

Prepared design and implemented defect prevention in the project.

Environment: AB-INITIO GDE 1.13(CITRIX), CO>OP 2.13, UNIX, ORACLE 8.0, ERWIN.

Client : UBS Investment Bank

Production Support 10 Months

HYDRA is an online reporting tool which is used by traders for different kind of analysis like profit and loss, sensitivity and trade view analysis for derivatives and Equity linked risk management.

Key Responsibilities:

Troubleshoot and fix production issues with short and critical SLAs.

Developed shell scripts to automate the file manipulation and extraction of performance numbers from logs.

Environment: UNIX, C++, ORACLE 8.0, XML, CLEAR CASE, TEST DIRECTOR 8.0, CLEAR QUEST.

Analysis Of Radial Power Supply 6 Months

Radial Power Networks bear a great energy loss while transmitting the power due to different load types. This software will take input of all the node voltages and power. These parameters will analyze the variation of power, voltage and phase over different nodes and the application will find out the optimal location where capacitor banks can be added to the network to reduce the power losses and regulate the power supply.

Key Responsibilities:

Design, development and testing of the system.

Preparation of design document, user manuals for the application.

Environment: Win -2000, Matlab 6.1.

drdo, India

Regulated Power Supply For Radar Transmitter 3 Months

This project includes design, fabrication and analysis of a Pulse width Modulated Power (PWM) Supply using IC –SG1528 for a transmitter used in Missile system. The Input was 230V, 10A at 450Hz supply and Output required was 100V dc with extremely good regulation and efficiency. The project was first designed, simulated and analyzed using Pspice and Electronic Work Bench.

Key Responsibilities:

Analysis, design, development and testing under military conditions .

Research for understanding new design methodology.

Environment: Win -2000 (OS), Pspice 1.0 package and Electronic Work Bench 1.1

Hardware: IC-SG1526, LM147.

Employment History:

S No

Employer

Designation Role

Start Date

End date

1

JP Morgan Chase

Vice President

26-Nov-12

Till Date

2

RS Software India Limited

Technical Support Lead

1-Nov-2011

23-Nov-12

3

Citi Bank Singapore

Assistant Manager

28-Jul-10

31-Oct-11

4

Steria India Ltd

Technical Architect

19-May-08

Jul-2010

5

American Express (I) Pvt Ltd

Systems Analyst

31-Jul-06

19-Apr-08

6

Infosys Technologies Ltd

Software Engineer

14-Jul-03

18-Jul-06

Educational Qualification:

Qualification

Institution/Board

Percentage/CPI

Year of passing

Bachelor of Technology (Electrical Engineering)

Indian Institute of Technology Roorkee, India

7.66/10

2003

Contact this candidate