VIJAY PERSHAD

** **** **** ****

Bethany CT *****

Cell: 203-***-****

Home :203-***-****

ad1cc6@r.postjobfree.com

TECHNICAL SKILLS

PL/SQL

ETL

SQL Server

ODBC

DTS

Stored Procedure

Oracle

Crystal Report

OLAP

SQR

Microsoft Visio

Toad

Microsoft PowerPoint

Microsoft Access

VBA

VBScript

SQL

TCP/IP

PeopleSoft

Visual Basic

MS .Net

ActiveX Data Objects (ADO)

Remote Data Objects (RDO)

Data Access Objects (DAO)

Web Client Technologies

VNC (Virtual Network Computing)

Visual SourceSafe

EXPERIENCE

Fiserv Inc

Consultant Sept 2017- Aug 2023

Develop and standardize several financial, ad-hoc reports pulling large volume of data from data warehouse,

MS Access database, SQL Server database.

Performed data analysis; data mapping and extraction from data files coming from several banks daily

Work on windows upgrade 2008 to 2012 and migrate all the applications residing on the server and resolve all the issues.

Generate various senior management reports summering the extracted information on weekly, monthly, quarterly and yearly basis.

Migrated all the MS access 2010 applications to SQL Server and other platform that includes writing stored procedures and create Crystal Reports.

Resolve complex production issues from legacy applications.

Robert Half Management Resources – HSB Insurance Company (Munich Re)

Financial Reporting Analyst 2016(June)-July (2017)

Automated several monthly and yearly processes using advanced excel functions, VBA programming for

Forecasting budget and actual budget calculations utilizing advanced techniques

Perform various day to day functions of accounting & financial department like extracting information from various settlement systems and generate forecasting and actual budget summary reports.

Converted old excel complex files with macro and links to databases into new excel versions file with integrity of the data

Perform data analysis using Excel macros, pivot tables, VLOOKUP tables, advance excel functions.

Royal Bank of Scotland, Stamford, CT

Risk Analyst/Consultant 2011 (Feb) – 2016 (May)

Reconcile various feeds from RBS settlement system like Loan IQ, FX and make sure data is reported accurately to IRS.

Worked on several RBS internal projects using relational databases, SQL Server enterprise manager, data mapping to import export data by developing custom queries, stored procedures, T-SQL and DTS (data transformation services).

Generate various Tax reports summarizing the total for all the 1099 filing and 1042-S filings for 2010, 20011and 2012.

Document all the technical and business requirements changes to the existing systems and future enhancements to existing RBS internal systems.

Automated several small applications using VB and VBA script for account remediation of various TAX forms.

UAT testing of new tax application both front end and back end. Created SQL server database to store historical information for last 3 years of all the RBS filing of 1099 (Various forms 1099-int, 1099 Misc., 1099-Div, 1099-B, 1099-C and 1042-S)

Electronic filing of 1099 and 1042-S data to IRS using 1099-Pro and 1042-S pro software for 2009, 2010, 2011and 2012.

Design and Developed complex MS Access application and link to SQL Server database

Comp Intelligence, Oxford, CT

Consultant 2010 (Jul) – 2010 (Dec)

Develop and maintain SQL scripts and procedures (Microsoft SQL Server, Oracle, and Microsoft Access)

Design & developed Oracle Tables, views, stored procedures, functions for a major project.

Manage data conversion projects with frequent client contact, conduct post-conversion

Data reconciliations between source and destination platforms.

Perform data analysis using Excel macros, pivot tables, lookup tables, advance excel functions.

GDF SUEZ North America / FirstLight Power/Select Energy, Hartford, CT

Risk Analyst 2006 (Mar) – 2010 (May)

Performed data analysis; data mapping and extraction; data cleansing, data mining, data warehousing and relational database management.

Perform historical energy price analysis; compare forward prices from several brokers and performed statistical analysis using Excel functions and SQL Server functions.

Performed requested technical enhancements and modifications to existing data collection process’s Queries, Stored Procedure,

Automate various analytics reports including custom financial reporting using SQL Server Stored Procedure, VBA, MS Access, Excel Macro's

Perform VaR (Value at Risk) scenario analysis and track volumetric risk using ZAINET analytics software

Developed complex Visio flowcharts, Excel graphs, histograms and documented existing daily procedures and processes.

Create technical ad-hoc queries for senior manager, business users, and validate risk management calculations

Performed statistical analysis using Excel functions and SQL Server functions.

Ensure compliance to risk management policies and procedures on a daily basis and to investigate and report instances of noncompliance on a timely basis.

Compiled and update forward commodities prices from several brokers into Oracle database.

Check the accuracy of all energy risk model's inputs like volatility curves, forward prices,

And ensure that no major discrepancy in data.

Citizens Bank, Lincoln, RI

Risk Analyst/Consultant Credit MIS Development 2004(June) – 2006 (Jan)

Provided support to internal and external auditors as they validate risk management information for monthly, quarterly and yearly transactions

Designed, coded and implemented ETL (extract, transform & load) for the Citizens Bank risk management projects including extracting information from various source systems such as commercial loans, leasing, asset based lending, bonds, customer derivatives, treasury, and bank trade/Letter of credit.

Performed detailed project management functions, prepared test cases, detailed test plans, document user acceptance testing (UAT), ad-hoc queries for business users, and validate risk management calculations.

Prepared detailed technical specifications for data and systems integration from mergers and acquisitions. Provide management with updates regarding status of all projects. Worked with other IT functional areas, various business units, and the data management team to ensure accurate design of data extraction from legacy systems.

Designed and developed several projects using relational databases, SQL Server enterprise manager, query analyzer, stored procedures, T-SQL and DTS (data transformation services).

Published monthly and daily risk management information including internal and external risk rating for Citizens Bank customers.

Compiled draft executive summary indicating key legacy system totals and noting any irregularities.

Generated and documented new processes, developed complex flowcharts using Visio and power point.

Relational database management, performed data analysis; data cleansing, data mapping and extraction; provided development support for existing systems; created batch jobs; systems documentation.

Energy East Corp, Hartford, CT

Lead Analyst, IT Shared Services 1999 (July) – 2004 (June)

Provided support for accounts payable, purchasing, general ledger, fixed assets, and inventory production modules of the PeopleSoft financial system.

Worked on related customization projects and create technical specifications based on requirements, coded in People code, SQR, HTML, PL-SQL, MS DTS, OLAP, SQR, stored procedures.

Write technical specification, software development; develop test plan, configuration, and life cycle support.

Migrated financial system patches, including upgrades, installation and configuration product updates.

Coordinated electronic file management processes such as positive pay files to bank, 1099 IRS file, 1099 vendor, purchasing card transactions, and refund checks.

Developed SQL Server Stored Procedures, data warehouse PL/SQL scripting, ETL.

Performed requested technical enhancements and modifications to financial system functionality and processes.

Developed complex financial reports: positive pay, budget forecasting, accounts payables, and general ledger.

PRT Group Inc., Windsor, CT

Consultant, IT 1998 (Aug) – 1999 (June)

Developed software from application design through implementation using Visual Basic, VBA, HTML, and VB script MS Access, Java script and ASP.

Designed, developed and documented software in a client-consultant environment.

Gather requirements from business users at all levels, analyzed needs, develop alternatives, and perform systems analysis tasks including process flows.

Developed systems design and functional specifications; created test cases, verify test results.

Implemented Internet based Loss Prevention System for Ames Corporation.

Applied following tools in Software development: Oracle, MS-SQL Server, web design, data modeling (database design), reporting tools, proto-typing, testing tools (test director), ETL tools, XML.

Assisted the senior managers in developing reports, presentations, and data analysis for upper management.

Aetna Inc., Middletown, CT

Senior Systems Analyst, Health Care Information Services 1990(Jan) – 1998 (Aug)

Developed several client/server applications including analysis, design, coding, testing, and implementation

Analyzing large healthcare datasets and perform quantitative and qualitative analysis.

Automated/improved several existing manual tasks by eliminating redundant processes.

Extract data from relational Oracle databases & SQL Server database for reporting and software development.

Integrated third-party add-on tools to existing systems e.g. reporting tools to generate reports.

Provided life-cycle support including upgrades to healthcare and financial systems.

Assisted with complex application installation and configuration in Aetna regional field marketing offices following procedures and policies with in the IT infrastructure group.

EDUCATION

MBA Management Information Systems University of New Haven, CT

Graduate level engineering courses Worcester Polytechnic Institute, Worcester, MA

BS Engineering Osmania University Engineering College, Hyderabad, India

TRAINING

Visual Basic application development

PeopleSoft programming (People Tools, PeopleCode, SQR)

SQL Server senior data transformation services: Hand on training

Working knowledge of the following technologies; web development, ASP, XML, VBScript

SKILL:

Advanced knowledge Microsoft Excel and building integrated Excel VBA applications

Advanced knowledge in statistics and related software

Experienced in relational database such as Oracle, SQL Server, Data warehouse and Access

Experience with PeopleSoft ERP systems.

STATUS: US Citizen

Contact this candidate