SUMMARY:

Over 16 years of professional experience in rapid prototyping of applications using MS-Access 97/2000/2003/2007, SQL Server 2000/2005/SQL Reporting Services, 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 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 stand alone 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
• Bachelor of Business Management
• Database Management Systems
• Project Management, currently pursuing Masters in Software Engineering

Skills:

Operating Systems:Windows 2000/XP, MS-DOS
Programming Languages: Visual Basic 6.0, SQL, VBA, Vb.NET, HTML
Databases: Microsoft Access, SQL Server2000/2005/2008.
Microsoft Office: MS-Access2007/2003/2002/2000/97,MS-Word, MS-Excel, and MS-PowerPoint
Tools/Studio Used: Web Methods, MS-Front Page, Visual Interdev

Total Years of Experience: 16 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 databases, Visual Basic programs and web based systems.

Employment History from September 1992 - Present

Current position: Architect - FX Business Reporting Systems since April 2011 to June 16, 2011.
Client: Confidential, Boston
Currently involved in multiple FX projects in the capacity of a technology architect as well as Business Analyst to understand and document the processes and functional flows in StateStreet FX business domain.
Due to widespread presence of disintegrated data in diverse platforms such as Oracle, MS-Access, MS-Excel, we are envisioning an integrated data mart which encompasses implementation of all business rules associated with FX Spot & Forward volumes related to FX Sales / Client flows that are entered via the WSS sales entry screen as well as Custody FX services activity where the associated positions are routed to the FX Market Risk Traders Spot portfolios.
Current systems are designed to produce monthly gross/net volumes and P&L reportz whose data is extracted from WSS system (Oracle RDBMS system) through a scheduled automated ETL process on a daily basis. The datz is further triaged based upon pre-determined criteria / business scenarios before it is sent over to extensive business rules engine implemented in VBA routines and queries on MS-Access / Excel platform.
The complex process of netting currency volumes and segregating data flows is performed in this rules engine before the final reports are staged on the Sharepoint server for distribution to Sr.Management team.
Complex process flows have been analyzed and documented and implemented in relavant technology framework. Currently evaluating an application called SEAT report which determines volumes and revenues associated with Risk trading for StateStreet operations for both Custody and sales trading.

Confidential, Boston, MA
Job Title: Sr. Application Developer
Start Date of Employment: June 2009 to April 2011
Type of Business: Consumer mortgage & credit analytics Division

Involved in the migration project from SQL Server 2000 to 2008, responsible for migration efforts with SQL Server, MS-Access GUI interfaces and manual/automated jobs written in VBA, VB.net that run on distributed ESP (scheduler application). Also responsible for automating manual processes to reflect current technology framework. And support / troubleshoot existing databases and enhancements.

Confidential, Philadelphia, PA
Job Title: Sr. Engineer
Start Date of Employment: July 2010 to October 2010
Type of Business: Primary Mortgage Insurance

I was responsible for re-engineering applications and databases for front and middle office operations departments for Radian.

Confidential, Warwick, RI
Job Title: Senior Database Administrator
Start Date of Employment: June 2009 to June 2010
Type of Business: Consumer mortgage & credit analytics Division

I was involved in the creation of end user applications by aggregating mortgage loan data captured from various legacy systems. I was 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 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 was built in MS-Access and Excel and some of the reports in SQL Reporting services as well.

Confidential
Job Title: Software Developer
Start Date of Employment: October 29th, 2001 - January 2008
Type of Business: Banking and Financial Services

Projects:

OFAC Extract Engine - MS-Access, SQL Server2000, 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.

Confidential - 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.

Confidential 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.

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 with in 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.

Confidential
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.

Confidential, 28-10-17, Suryabagh, Visakhapatnam, India
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, 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