Resume

Sign in

Financial Services Sales

Location:
Woonsocket, Rhode Island, 02895, United States
Posted:
November 11, 2017

Contact this candidate

VANDANA JOSHI

Contact: *-617-***-****;

Email: ac29jl@r.postjobfree.com

IT PROFESSIONAL : (11 Years Exp: Senior Database analyst)

Seeking a challenging and rewarding opportunity with an organization of repute

Valid H1B visa till 2019

TECHNICAL SKILLS

Language

SQL, PL SQL,NZSQL,UNIX shell scripting, C#, Oops, VBA Macros

Domains

Banking and Finance, Investment, Insurance, Taxation, Telecom, IT services

(Backend programming, Web Application programming),

Database

Netezza, Oracle 10G(Primary), 11G, SQL Server 2005, MS-Access

Editor

Aginity, PL SQL Developer, Oracle SQL Developer, Toad,, IBM Netezza Administrator

Web Technology

ASP.net(Web Applications)1.1,2.0,3.5,4.0, ASP, C#.Net, VB.Net., Javascript, Web Services

Tools

Markit EDM, Infragistics, Telerik Controls, Ajax Extensions, My Generator

Methodology

Agile methodology with scrums, Waterfall model

Version Controls

IBM Clear case, Clear Quest, VSS, SVN

PROFESSIONAL EXPERIENCE

ORACLE FINANCIAL SERVICES SOFTWARE INC, Boston, MA since Aug 2016

Senior Consultant

Successfully handle the task of developing/supporting different Application Modules as per client requirement using Netezza database, Unix shell scripting, Oracle 10g, Oracle 11g, ETL,,SQL Server.

Gained exposure in end-to-end development of software products from requirement analysis to system study, designing, coding, testing and debugging

Handling Agile methodology, daily scrums and managing developement dashboards.

Involved in requirement analysis, database design, coding, testing, implementation and maintenance of several software applications

Communicating with the clients, interviewing end-users to know the requirements and expectations of the clients

Supervise smooth implementation of the project and extend post-implementation, application maintenance and technical support to end users

ORACLE FINANCIAL SERVICES SOFTWARE LIMITED, Mumbai India May 2010 to Aug 2016

Senior Consultant

GTL INFRASTRUCTURE LTD, Navi Mumbai India Apr 2008 to Apr 2010

System Developer

RHEAL SOFTWARE (P) LTD, Mumbai India Jan 2007 to Jan 2008

Trainee Programmer

EDUCATIONAL CREDENTIALS

Master of Computer Applications(Full time); 2007

North Maharashtra University; First class with distinction, 73%

Bachelor of Science (IT)(Full Time); 2004

N.M.U; First class grade, 68%

Higher Secondary Certificate; 2001

Nasik Board; 68%

Senior Secondary Certificate; 1999

Nasik Board; 68%

Microsoft Official Certificate Course in ASP.Net; 2006

Seed Infotech, Panchsheel, Karve Road, Pune

Cleared first exam Z-051 for Oracle certified associate- SQL fundamental.

PROJECTS UNDERTAKEN

Organization

ORACLE FINANCIAL SERVICES SOFTWARE INC, Boston, MA

Title

Client

Risk Data mart

State Street Global Advisors, Boston, MA

Environment

Duration

Netezza Database, Unix Shell scripting, Autosys, Markit EDM

Aug 2016– Till Date

Synopsis

Enterprise risk management (ERM) consists of operational (ORM), counterparty (CRM), and investment risk (IRM) oversight. With a continuously expandable investable universe across markets, asset classes, and strategies, ERM has multiple perspectives for accessing risk and contextualizing the investment process for internal and external audiences. With the breadth of mandates and evolving regulatory supervision, there is an increasing challenge in providing timely, accurate data across each discipline.

Responsibility

System analyst working for Netezza database and automation process. Creating reports to monitor different risk alerts for top management and reporting audience in SSGA. Writing procedures and views, performance tuning of complex SQLs, writing shell scripts in UNIX server, running autosys jobs, troubleshooting UAT and PROD issues and providing knowledge transfer to offshore by daily scrums and guiding them on requirements.

Team Size

35

Organization

ORACLE FINANCIAL SERVICES SOFTWARE LIMITED, Mumbai, India

Title

Client

Anti- Money Laundering (Projects: BUSA, HRAC,GR11,Qlikview, Cards, Mantas)

Citi Bank NA, Florida

Environment

Duration

Oracle 11G database(PL SQL), Unix Shell scripting

Jan 2014– Jul 2016

Synopsis

BUSA: A 2012 joint review of Banamex USA (BUSA) by the Federal Depository Insurance Corporation (FDIC) and the California Department of Financial Institutions (DFI) resulted in BUSA entering into a joint Consent Order that, among other things, required BUSA to make enhancements in its Bank Secrecy Act (BSA)/ Anti-Money Laundering (AML) Compliance Program. As part of its effort to fulfill the requirements of the Consent Order, BUSA has made material changes to its BSA/AML Compliance Program and the AML Transaction Monitoring System (TMS) it uses to monitor its customers’ use of the banking products and services BUSA offers. BUSA has expressed its desire to continue with further enhancements in this area by transitioning from its current TMS operating environment to one based on the standard global Anti-Money Laundering TMS solution that is used by Citigroup and several of its affiliates and subsidiaries: Mantas AML monitoring.

Responsibility

Played role of System Analyst (Back end Developer, leading team of three developer. Writing stored procedures and maintaining database for the system, performance tuning of complex stored. Writing shell scripts in UNIX server which communicates to Oracle server via stored procedures in Oracle database and generating reports through csv.

Team Size

40

Organization

ORACLE FINANCIAL SERVICES SOFTWARE LIMITED, Mumbai, India

Title

Client

Cash Views- BB ratings

SSGA, US

Environment

Duration

Oracle 11G database(PL SQL), ETL

Dec 2012 – Oct 2013

Synopsis

Cash Views applications uses ratings obtained directly from three major rating agencies (Moody’s, S&P and Fitch) for various ratings data uses. It needs ratings at both Issuer and Issue level. The project will be delivered in two separate phases – Phase 1 consists of switching the current Agencies ratings data flow to that of Bloomberg ratings. It involves both Issuer and Issue ratings data that is currently sourced from Agencies.

Phase 2 will enhance the Bloomberg ratings feed for including the additional ratings data mainly Money Market and Muni fields.

Marker Data framework (MDF) data repository changes are required to source ratings data from Bloomberg.

Responsibility

Writing stored procedures and maintaining database for the system, performance tuning of complex stored procedure Use ETL to populate data for Cognos Reporting.

Organization

ORACLE FINANCIAL SERVICES SOFTWARE LIMITED, Mumbai, India

Title

Client

GTS- Global Tax System

State Street Bank, Luxemburg

Environment

Duration

Oracle 11G database(PL SQL)

Aug 2012 – Nov 2012

Synopsis

GTS or Global Tax System computes and publishes tax burden (and not tax) of a mutual fund class from German, European, Swiss and Austrian tax point of view.

For German investors the income should be distinguished as taxable (IP or Interim Profit from Fixed Income investments) and non-taxable (AKG or per share percentage on Equity or Equity like instruments, IG or per share percentage on Real Estate). For Austrian, European and Swiss investors the Taxable Income per Share or TIS in short has to be reported. In addition, funds are required to report the Distribution and Deemed Distribution Income (DDI) on an annual basis.

Responsibility

Writing stored procedures and maintaining database for the system, performance tuning of complex stored procedure.

Organization

ORACLE FINANCIAL SERVICES SOFTWARE LIMITED, Mumbai, India

Title

Client

FXBlotter and Tracker system

Sumitomo Bank, Japan

Environment

Duration

Asp.net 4.0 and 2.0 using C#, SQL Server, Ajax,, Web Services

Apr-2012 – July 2012

Synopsis

The system gets raw data along with account details for FX transactions, from the internal system of Sumitomo bank and generates tickets for those FX transactions. These tickets are then communicated with scheduled job to convert into deals.

The system displays end to end MIS reporting with export functionality Sumitomo bank to maintain FX deals and data. Also there is a module which balances ad-hoc transactions to track the FX taxes for local currency and equivalent currency.

Responsibility

Writing stored procedures and maintaining database for the system, performance tuning of application and database functions and procedures. Creating interfaces in the website as per the client’s requirement.

Organization

ORACLE FINANCIAL SERVICES SOFTWARE LIMITED, Mumbai, India

Title

Client

Contract Register Automation(Internal)

Prime sourcing OFSS

Environment

Duration

Oracle 11G database, VBA Programming, Java

May 2011 – Apr2012

Synopsis

The system eliminates differences in Sales data and manual register as well as follow ups to the sales managers.

The system provides multiple ways to upload sales data and manages information regarding Oracle contracts and maintains all sales data into the central repository. Provides data accuracy, efficient capturing of data, and seamless co-ordination with on-fiels sales managers.

Displays end to end MIS reporting with export functionality to Sales and Sales ops and senior management.

Responsibility

Leading role in designing centralized repository in Oracle database, and implementation of VBA code to capture macro based excel data.

Organization

ORACLE FINANCIAL SERVICES SOFTWARE LIMITED, Mumbai, India

Title

Client

Catalyst 4.0

Citi Bank, US

Environment

Duration

Asp.net 3.5 using C#, VB, SQL Server, Ajax,, Web Services

May 2010 – Aug 2010

Synopsis

Catalyst is the “Citi group” project based on banking domain. It contains organization level hierarchy where main three phases are planning, testing and assessment.

Responsibility

Designing database for the required system includes creating database tables, triggers, procedures and functions in oracle, Designing .net web site using the MVC architecture.

Organization

GIL INNOVSOURCE PVT LTD, Mumbai, India

Title

Client

MIS Portal

GTL,Mumbai

Environment

Duration

Asp.net 3.5 using C#, Oracle, Ajax,, Web Services

Jan 2010 – Apr 2010

Synopsis

The Management Information System display the detail information in terms of charts and actual data regarding all the transaction held in the organization like actual input and output of the organization, product development, status of product for each client, quality and timeline of work and definitely performance of all employees by using these reports,major and minor punch points etc. Using which the management team can define the loss and gain of the organization for particular financial year.

Responsibility

Gathering client's requirement and building prototype for the same, Designing database for the required system includes creating database tables,triggers,procedures and functions in oracle, Designing .net web site using the MVC architecture.

Organization

GIL INNOVSOURCE PVT LTD, Mumbai, India

Title

Client

Performance and Incentive Management System

GTL,Mumbai

Environment

Duration

Asp.net 3.5 using C#, Oracle, Ajax,, Web Services

Jan 2009 – Jan 2010

Synopsis

To calculate current quarters incentive amount for each employee of organization according to his performance on the base of two key areas « Time« and « Quality« by considering major and minor punch points of key performance Indicators defined in their KRA

Organization

Rheal Software (P) Ltd

Title

PROJECT MANAGEMENT SYSTEM

Environment

Duration

Asp.net 2.0 (VB.net), Oracle.Telerik Controls

Jan 2007- Mar 2007

Synopsis

Designed to deliver real conceivable benefits to enhance the quality of the software being developed & divided into two sections. Quality Control (QC), Resource Management & Timesheet generation.

ACCOMPLISHMENTS

Honored as a judge in Software exhibition,IT-FESTA-2013, IMR, Jalgaon

Credentials of holding 3rd Prize at National Level IT Quiz held at Institute of Management and Research.

Received 1st Prize at State Level Software Expo “Projection 2006”.

Received 3rd Prize at District Level AIM’s C++ Programmer.

Recipient of Third Prize at District Level Java Programmer.

Received Best Student Award of the year 2006-2007 in IMR, Jalgaon.

Languages: English, Hindi, Marathi, Gujarati

References: Available on Request



Contact this candidate