Sql Server Visual Basic

Ram Malla: Phone: 508-***-****, ***-***-.****

Current Location: Philadelphia, NJ, NY, Boston, Providence

SUMMARY:

Over 15 years of professional experience in rapid prototyping of

applications using MS-Access 97/2000/2003/2007, Oracle 10G, SQL Server

2000/2005/SQL Reporting Services, SQL SSIS, Visual Basic 6.0, Visual

Interdev 6.0, HTML, Active Server pages (ASP), COM, DCOM, VBScript,

JavaScript, Web Methods, VB.net, ASP.net, business analysis, & Enterprise

application support

Extensive experience in the design, development and creation of database

and client server applications, using MS-Access, SQL Server and Visual

basic 6.0/MS-Access as front-end user interface with back-end databases

being MS-Access, SQL Server and Oracle.

Application Support - Systems Application Support, Administration, Problem

Management, Analysis, and Implementation for production applications for

middle office applications and SQL Server / oracle databases.

Provide light support/development to improve production support processes

Change management, schedule and track application changes & Releases

Document Specific procedures for implementation, error checking & Fallback

Manage software & configuration, changes on test and production environment

Implementation management - Make several daily modifications to support

customers business & technical specifications

Perform technical tests before changes are rolled out

Documentation - Collect & Analyze business requirements / functional

specifications document User Guides, Test plans / cases and manage detailed

project implementation plans.

Design & Development - Knowledge of both DAO and ADO object models.

Knowledge of Active X and COM components

Configure ODBC connections to SQL, Oracle, Excel and MS-Access, Clipper,

DB2, Excel databases and file based systems to import large data sets from

diversified data sources and to create reports using MS-Access and Excel.

Proficient in VBA programming - extensively used to create modules, private

and public functions making use of ADO and DAO object libraries.

Automate various processes that involve routine and recurring data

manipulation and creation of reports in .PDF, MS-Access, Excel, Crystal

reports to create mail process to distribute reports automatically to the

clients using MAPI components.

Create automated process to compact and repair databases on a daily basis

Implement security groups and roles for MS-Access databases.

Create Import modules within MS-Access and Visual Basic front-end interface

to export data to relational database systems like SQL Server and Oracle

and create client server applications for the users to interact with the

application and run reports.

Create Visual basic Utility and interface applications to meet various data

processing requirements of business groups.

Microsoft applications being ActiveX components- I have significant

experience in using Visual basic 6.0, MS-Access and MS-Excel to seamlessly

connect and access all sources of data regardless of platform and create

both user interface apps as well as standalone applications.

Upgrade MS-Access 97 databases to MS-Access 2003 and 2000 versions.

Migration of Access 97 databases to SQL server databases.

Excellent debugging and troubleshooting skills, developed, managed and

supported 100+ MS-Access, Visual Basic, SQL and web based applications.

Create innovative business solutions to initiate and drive business

processes to meet client requirements from time to time.

Good team player, interacts well with the team, accept constructive

criticism and work well with length and breadth of the organization to

initiate and accept challenging projects to meet organizational goals

Education:

Postgraduate Diploma in Computer Applications

Interface Information Technologies, India (June, 1999)

Andhra University, India (1989-92)

Bachelor of Business Management

The University of Memphis, Memphis

Database Management Systems

Brandies University, Boston, MA

Project Management, currently pursuing Masters in Software Engineering

Skills:

Operating Systems: Windows NT, Windows 2000/XP, MS-DOS

Programming Languages: Visual Basic 6.0, SQL, VBA, HTML

Databases: Microsoft Access, SQL Server2000, Oracle 10G.

Microsoft Office: MS-Word, MS-Excel, and MS-PowerPoint

Tools/Studio Used: Web Methods, MS-Front Page, Visual Interdev

Total Years of Experience: 15 Years:

Primary duties include application development, application enhancements

and production support using technologies like MS-Access and SQL server

2000/2005, Visual Basic, Active Server Pages, IIS. I am also experienced in

creating and supporting over 100+ MS-Access databases, SQL, Excel spread

sheets and Visual Basic applications. Current working environment comprises

MS-Access / SQL Server, Oracle databases, Visual Basic programs and web

based systems.

Employment History from September 1992 - Present

Radian Guaranty Inc 1601 Market street, Philadelphia, PA

Job Title: Senior Engineer

Start Date of Employment: July 2010 to present

Type of Business: Primary mortgage Insurance & Analytics Division

Presently working on analysis and reengineering group's MS-Access databases

and upgrade some of the dB's to SQL Server back-end.

Citizens Financial Group, Warwick, RI

Job Title: Senior Database Developer/ Administrator

Start Date of Employment: June 2009 to July 2010

Type of Business: Consumer mortgage & credit analytics Division

Involved in creating end user applications by aggregating mortgage loan

data captured from various legacy systems. I am independently responsible

for architecture, design and implementation of the system which extracts

loan data from various data sources (External files, database and legacy

systems).

As the legacy systems are being retired end of the year, many service

providers (GMAC, Morgan Stanley, FTN, Countrywide, Green point) transition

to new service providers and going forward the data is fed into multiple

systems externally and as such the new application process we are building

captures information from both external and internally serviced loan data

and creates reports for the senior management.

I have thus far created a stand alone custom import process which imports

data from heavily loaded text and excel files in various file formats

(.txt, .xls, .csv fie formats) into a central repository database while

filtering the data based on required data elements much before data is

imported. The technology being used to implement the process is MS-Access,

SQL, Visual Basic, VBScript and VBA where as current legacy and database

systems are implemented in Oracle and SQL platforms. The reporting system

will be built in MS-Access and Excel and there is proposal to build some of

the reports in SQL Reporting services as well.

State Street Corporation / Investors Bank and Trust (Acquired by State

Street Corporation)

Job Title: Software Developer

Start Date of Employment: October 29th, 2001 - January 2008

Type of Business: Banking and Financial Services

Projects:

New york Life Investment Management (NYLIM) - MS-Access 2003, Visual basic

6.0

New York life investment Management (NYLIM) administer 63 mutual funds and

provide custody, accounting, reporting and administration services. NYFTI

database extracts yield, money market data and perform yield calculations

and data will be used to create 7 outbound customized extract files defined

by client and delivered via secured FTP by 6:30 PM nightly.

NYFTI Access database takes in FACTS FUND (FN1), Holdings,(HLD), General

Ledger(GLX), SMAC and tax lo holdings(DTL). These extracts are pulled into

the Access database application daily. The users will then manually update

the NYFTI database with reset dates for variable rate securities. After all

the data is entered and imported, the users will calculate the weighted

average maturity (WAM) using a function within NYFTI application. This

information is then combined with the current day fund information to

calculate the various yield figures required by NYLIM. This includes

current yield, current un-reimbursed yield, effective yield, and effective

un-reimbursed yield. Seven customized extracts files are created using the

fund data based on fund type. The extract files are sent to NYLIM via FTP.

The primary goal of this application is to provide the client NYLIM,

accurate and timely data they require to feed into their internal PACE

system.

Outbound files include:

Days to mature, Floating rate, Yield Feeds, Pam Feeds, NAV Feeds, PHL -

Holdings, PSM - Securities added during the month.

NYLIM NAV FAX Application:

The application was created to provide the NYLIM FUND group the ability to

create, email and fax NAV information to various external clients like

FIDELITY INVESTMENTS etc. ANVFAX application gets the feeds FN1 and

historic yield information from the NYFTI access database. The NYLIM and

Fidelity fund numbers are referenced from a snapshot of the SFX Oracle

"NYLIM_XREF_FUND_LIST" table. The application creates an

"informaticaload.csv" file to be used by an informatica workflow to send

NAV information to DST and Nrowwd. This application creates reports on

information for Mainstay funds, McMorgan funds, and also reports on

Fidelity funds.

OFAC Extract Engine - MS-Access, SQl Server, Oracle 10G, Visual Basic 6.0,

Argent Scheduler

Designed and developed OFAC engine that captures partnership information

from 7 OFAC MS-Access databases and Excel spreadsheets. This is a process-

based application written in Visual Basic 6.0 and MS-Access, which gathers

information (data) from MS-Access databases .CSV, Excel, and text files and

updates a central repository SQL database. The captured information in the

repository is further processed based on a set of business rules

implemented within the database through stored procedures in SQL and pass

through queries in MS-Access and business logic was built into both

database and MS-Access interface. And the final data is made ready for

creating partnership extract reports. Visual basic component architecture

(COM) has been used to leverage process capabilities and data aware classes

have been implemented to reduce the application overhead.

Pershing Trade and Caps Conversion Project - Visual Basic 6.0, MS-Access,

COM, Argent

Created a stand-alone process to extract, de-code and convert Pershing

specification files. The application is designed in component object model

to leverage process speed and conversion capabilities. Application decodes

Excel files for trade and caps data and imported into MS-Access database

and data is further filtered into queries and run the reports in .xl and

.txt format. Business logic has been implemented in the database and Visual

basic visual basic COM component, which converts the data for further

processing and for extended reports creation. Excel spreadsheet reports are

created on the fly, which are moved to a network-staging directory at the

end of the process. Argent scheduler kicks off this application daily 7 AM

to reach PERSHING.

SUV Data Transformation Modules (MS-Access to SQl Server Migration Project)

- SQl Server, Visual Basic 6.0, MS-Access2003, Argent Scheduler

Created user defined components to import huge volumes of tax data in

various formats (Excel, .CSV, .txt, .PDF files) into an Access database.

These modules are created for IBT Tax group in Sacramento office. I have

upsized (migrated) the MS-Access application to SQL Server 2000 as the MS-

Access database file was growing in Size due to large amounts of tax data

and we have had bloating issues with multiple users accessing the

application from different locations. I have also worked out on a proposal

to create some of the web based reports.

BGI Toronto Cash Projections application:

This application provides BGI with customized cash projection file and

reports on cash and currency in every fund for Trade date through to Trade

date +6 business days by 6:00AM on Trade date. The cash projection would be

determined by settled cash, maturities, buy trades, sell trades, FX Trades,

Coupon payments, dividend payments by currency, corporate actions (local &

CAD), market to market on futures, subscriptions, redemptions, expense

payments.

Senior loans database:

Senior loans application is an MS-Access application that creates a number

of files for pricing purposes, as well as a number of reports for

reconciliation purposes. The reports reconcile information from FACTS and

Wall Street office for the funds senior debt portfolio, Eaton Vance senior

income Trust, Eaton Vance senior income loan portfolio on FACTS. One the

pricing has been completed on FACTS, SLP will provide a second file for

pricing on Wall Street office.

ITSA Matching Engine - Visual Basic 6.0, Oracle 10g, Argent, MS-Access

Designed and developed a matching Engine for ITSA to use in quarterly ID

reconciliation process. Matching engine was created within built

capabilities to extract information pertaining to Employee Ids and names in

the form of excel spread sheets from various IBT systems like Oracle

databases, mainframes and SEI etc., the information thus gathered is

further processed and matched against Human resources data for data

accuracy and integrity. The processed data is updated during the matching

process to oracle 10g database and Reports are created based on this final

set of data.

Various algorithms and regular expressions have been extensively used in

the engine to automate ID matching process. Presently working on a proposal

to re-engineer the product to accommodate additional data sources and

platforms and creating web based front-end with reports to design in

crystal reports.

Online CAMR web application And Asset Maintenance web-based Inquiry

Application - VB Script, Java Script, MS-Access 2003, COM, Active

server pages, Visual Interdev 6.0, Visual Basic 6.0, MAPI

Designed and developed three web applications for Global Custody Operations

- Ex-date desktop group and Asset Maintenance groups. Both web-based

systems facilitate FACTS users to transmit trade related inquiries. These

applications are similar to Remedy application used by helpdesk. Ex-

date/Asset Main Admin can review and respond to inquiries every 15 minutes.

If an inquiry is left pending for more than 15 minutes, a separate

escalation service (COM service) is activated. This service keeps

escalating the inquiry to the concerned officials every 15 minutes

following hierarchy. The web interface and is dynamically created on the

fly every time a user logs on to the application based on his NT/XP

profile.

This project was implemented using dynamic web pages based on HTML,

Java/VBScript, COM and ASP technologies, Database connectivity is

established using connection pooling through ADO. Argent is used to run

escalation COM service.

ODR Data Transformation services - Visual Basic 6.0, SQL Server 2000, MS-

Access97

Implemented a service based transactional component to transfer data from

ODR SQL2000 database to Overdraft Access Database. Argent scheduler runs

this service every day.

Miscellaneous Projects

Implemented and created web menus for various groups and suggested dynamic

distributed architecture for web based menu system implementation.

Implement an automated process to compact and repair databases on a daily

basis.

I was involved in database upgrades and application re-engineering for many

of the MS-Access 97 databases.

Initiated Overdraft MS-Access databases upgrade to SQL server 2000 and MS-

Access queries have been upgraded to views and SQL stored procedures and

created web based front-end application.

Created and implemented custom security upgrade program for IBT security

file conversions.

Initiated and currently working on SUV, ITSA, web development projects.

I was involved in design, development, and application support of databases

and applications for IBT for last 9 years.

Primesoft Inc

Job Title: Programmer Analyst

Start Date of Employment: October 2000-October 2001

Type of Business: full-service software development, consulting And BPO

services provider

Client: American International group, NY

Projects:

Performance Management Program- MS-Access, SQL, VB

Implemented "Performance Management Program" which measures the performance

of various Underwriters, Underwriter Assistants and Technicians spread

across the nation. The application is designed to import the policy data

that is downloaded from various legacy systems such as Clipper, DB2, HTML

and Mainframes etc., into a central repository. The built in import process

validates the data against various checks and the data is ported to a SQL

database to finally create various score cards and reports to measure the

performance of employees.

I was involved in the design of robust bulletproof application that

prevents accidents, errors and protects the data. I have provided intense

training, supervision so that the users understand the data and the

application objects. And grasp how to get the most from them while not

doing any damage. Responsible for Entire Business Process Development,

documentation of Test plans, Test cases and integrated system testing.

Status V-1 Application - Visual Basic 6.0, Access97

Designed and developed a prototype "Status V-1 Application" that would

track and monitor various AIG projects' performance. Several users feed the

data across the nation and the reports are generated based on the weekly

feeds from all the users. I have implemented Groups' level security layer

in the application which limits the reports' access only to a certain

authorized groups. Reports are designed and generated with Microsoft Graph

5.0, which is an OLE2.0 mini server application that is almost

indistinguishable from the graphing application native to Excel 5.0.

Individual projects' status under various teams and groups are reflected

through the graphs, which get updated with the feeds of data from various

users across the nation.

Bill Manger 5.0 -MS-Access, 97

Analysis of architectural migration from MS-Access database to SQL Server

for "Bill Manager 5.0", a Telecom related expense management software and

encapsulating observable best practices in a universally relevant

framework. I was involved in Product evaluation, recommendation, Business-

Process development and migration and implementation of Bill Manager 5.0.

Business-to-Business Integration - Web Methods, VB Script, HTML

I was involved in the integration of Merchant web sites with Snaz using the

tool Web Methods. Made extensive use of regular expressions to capture

pieces of data spread across the web pages.

Emandi International, 28-10-17, Suryabagh, Visakhapatnam, India 530020

Job Title: Business Analyst

Start Date of Employment: September 10th, 1992 - March 31, 1994

Job Title: Computer Systems Analyst

\Start Date of Employment: April 1st, 1994

End Date of Employment-June 8th, 1999

Type of Business: Agricultural, Industrial, Marine and Oil Field equipment

Import & Export Company

Projects:

Sales Management System - MS-Access, Oracle 7.0, Visual Basic 5.0

Designed, Developed and Tested a Sales Management System to keep track of

customer electricity requirements and sale of surplus electricity for Rain

Calcining Limited, India. I have tested the production version of the

software by creating appropriate test cases to get the correct test

coverage. The test plans and the test cases were written based on the

Feature Requirement Specification (FRS). Ran SQL queries and generated

reports to ensure data integrity to meet user requirements.

Developed & tested an Acces'97 and Visual Basic 5.0 based system for

keeping track of all the import and export regulations related to food

products of different countries. The system developed and tested by me

keeps track of all basic food testing requirements of many countries and

potential volume requirements.

Designed and implemented comprehensive sales management system for the sale

of surplus power. Negotiated and interacted with the customers directly to

enter into Energy Sales Agreements. Introduced differential pricing system

to motivate the customers to enter energy sales agreements (ESA's) and

carried out various cost / benefit analysis to augment the Company

revenues. Various business systems were developed to ensure online analysis

of technical data as well as energy requirements to analyze power

generation Vs sales. Conducted an enterprise-wide study to understand and

document necessary data inputs and work procedures required for ISO-9000

certification of our work place.

I have participated in the energy auditing for the optimum utilization of

surplus power and to arrest the loss of power during the transmission.

I have participated in the International power generation exposition held

in India. Pioneered the sale of surplus power and was instrumental in

hiring the distribution facilities for the company by negotiating with the

local grid. This has resulted in considerable cost savings.

Other: Enjoy travel, learning about new places, people &

cultures

Speak, read & write English, Hindi & Telugu

References:

1. Christopher Mcguire, Vice President Investors Services

State Street Corporation - Back Bay Division

200 Clarendon Street, Boston 02116

Phone: 617-***-****

E-Mial: HYPERLINK "mailto:***********.*******@***********.***"

***********.*******@***********.***

2. Rajesh Pednekar

Asst Vice President, State Street Corporation

Boston, MA 02116

Phone: 617-***-****

E-Mail: ********@*****.***

Phone: 508-***-****, 508-***-****

Contact this candidate