Virendra Patil Email & Phone Number

New Jersey, United States

New Jersey, United States

New York United States

The objective of this project is to automate the FR Y9C, FR Y-14Q & FR Y-14A (Actuals) reports comprised of Securities, PPNR, Wholesale, Balances, and Supplemental schedules each with multiple supporting worksheets via the use of a regulatory reporting tool called the AXIOM Controllerview.

Newyork Usa

Title: CCARDuration: June 2015 to till dateTechnology: Oracle, UNIX shell scripting , AXIOM and control-M.Client: Barclays Capital, New York, USA

Singapore

Title: DBARRT Duration: Jan 2014 to till dateRole: Senior DeveloperTechnology: Oracle, UNIX shell scripting , AXIOM and control-M.Client: Deutsche Bank, Singapore• Undertake the build and implementation of the Axiom Controller View for the reports in scope and perform unit test.• Support the UAT with the users. UAT issue fixes and retesting to secure the sign off within the set timelines.• Worked on creation of Data Sources, Data Modelings, Portfolios and Short hands ,Aggregations, Workflows.• Created Tabular and Free form reports. • Requirements gathering, project definition, define design and test strategies, deployment plans.

Pune, India

Title: APAC Reg Reporting Duration: Dec 2012 to Jan 2014Role: Team LeaderTechnology: Informatica, Oracle, UNIX shell scripting , AXIOM and control-M.Client: Credit Suisse, SingaporeA comprehensive set of reform measures designed to improve the regulation, supervision and risk management within the banking sector. The Basel Committee on Banking Supervision published the first version of Basel III in late 2009, giving banks approximately three years to satisfy all requirements. Largely in response to the credit crisis, banks are required to maintain proper leverage ratios and meet certain capital requirements.Responsibilities:As Offshore Project Leader,• Undertake the build and implementation of the Axiom Controller View for the reports in scope and perform unit test.• Support the UAT with the users. UAT issue fixes and retesting to secure the sign off within the set timelines.• Worked on creation of Data Sources, Data Modelings, Portfolios and Short hands ,Aggregations, Workflows.• Created Tabular and Free form reports. • Responsible for onsite-offshore co-ordination activities, Customer co-ordination and status reporting.• Requirements gathering, project definition, define design and test strategies, deployment plans.• Involvement in Unit, System and Integration test planning.• Co-ordination with teams to ensure requirements are understood and implemented correctly.• Review architecture, designs/processes & monitor the progress of project phases.• Providing effort estimation & Proposal creation, Business Case Definition.• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.• Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance.

Pune India

Duration: Sep 2006 to Jan 2008Role: Team MemberTechnology: Informatica, Oracle and UNIX shell scriptingClient: WaMu-Washington Mutual Bank.Retail Banking and Financial Services WM Financial Services is a full-service brokerage firms that specializesin helping individuals meet their financial goals. The segment offers abroad range of investment products, including individual retirement accounts (IRAs), fixed annuities, life insurance, stocks and bonds as well as retirement and estate planning.The segment also offers mutual funds, including those in the affiliated mutual fund family, WM Group of Funds. Home Loans Home Loans segment is a leader in the mortgage industry in mortgage origination, sales and servicing. The segment offers a broad array of home lending products through its retail, wholesale, correspondent and sales channels.Responsibilities:As Offshore Project Team member,• Writing of UNIX shell scripts to automate Informatica workflows• Testing of UNIX shell scripts and Modifications• Design of Run Book for changed requirement• Development and testing of Informatica code.

Pune Area, India

Title: AADM Data MigrationDuration: Oct 2004 to Sep 2006Role: Team MemberTechnology: Informatica, Oracle.Client: SBC/AT&T Services Inc, USA.SBC is one of the biggest telecom service provider in USA which is been merged with AT&T. This project deals with the data warehouse technology in telecom domain area. Due to this merger of SBC with AT&T, SBC is required to exchange the billing information data with AT&T database. This project is using ETL tool Informatica to migrate the information from Legacy systems (DB2, IDMS), relational database like Oracle, SQL Server, and Terradata to AT&T database.Responsibilities:As Offshore Project Team member,• Development and testing of Informatica code. • Preparation and execution of SIT cases. • Conduct team meetings and participation in Focal Point call.• Participation in Internal audits and project status reviews.• Conduct defect prevention meeting.