Summary:

• Over 9 years of experience in IT and Client/Server based Application design, Analysis, Testing and Production Support.
• Systems Programming in Microsoft Access, Visual Basic.Net, ADO.NET, Microsoft Fox pro, Systems Analysis and Design, Microsoft Excel with VBA and SQL queries, PL/SQL.
• Creation of Macros, VBA code and Reports for Business Development.
• Microsoft software development environments, application development, Record Keeping System for Excel automating, modifying, and optimizing extensive reports in Excel.
• Experience in redesigning, maintaining and supporting complex especially in Microsoft Access2002/03 and Microsoft Access 2007.
• Use Rapid Application Development RAD Programming techniques to develop and execute application and manage end-to-end tactical solutions to meet business challenges.
• Migration from Access 2003 to Access 2007.
• Effective leadership skills with good written, verbal communication and presentation skills.
• Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems.
• Self-motivated with result oriented approach.
• SQL statement using SQL server 2000/2005 2008
• SharePoint 2007 Administration and CrewNet maintenance.

Professional Skills

• RDBMS / DBMS: MS SQL Server 2005 / 2008, MS Access 2003 / 2007, Oracle, MySQL and Visual FoxPro.
• Database Technologies / SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, MMC,
• Tools: I-SQL, T-SQL, PL/SQL, DTS, ODBC, SSRS, SQL OLEDB, DBCC, MBI
• Customized Apparel System .
• Operating Systems: MS Windows XP / Vista, Red Hat Linux, Solaris and MS Dos 6.22
• Programming Languages: VB.Net, VBA, Visual Basic 6.0, Java Script, Perl Script, VB Script, Dos Scripts
• C, C , HTML, DHTML, T/SQL and PL/SQL.
• Reporting Tools: PeopleSoft nVision Reports, Access Reports, Crystal Reports, SSRS.
• MS Office Tools: Expert in full MS Office 2003/2007/2010. Great Experience in Office Migration

Confidential

Application Developer/Programmer Analyst.

Summary:

Confidential Retirement plans, Investor services and personal and corporate savings. In my work experience with them I was responsible to develop application for Vendor Contracts Management. I did a lot of development and automation in MS Excel 2007. I was also working with the project manager for migration of Office 2003 to Office 2007 all current functioning applications at Vanguard. I Developed macros and automate manual work. Develop applications for auto generation of Allocations for all Funds. Worked in Peoples Soft application such as nVision reports. Also creates reports on Cognos and adhoc box.

Responsibilities:

• Create and develop Access Databases, Reports and efficient queries in MS Access 2007.
• Support Vendor Contract Management application developed in Access 2003.
• Development of Macros and procedures for daily manual work to improve the productivity and accuracy of data usage.
• Develop Analytical reports for prompt decisions.
• Developed applications using PL/SQL packages and Stored Procedures.
• Coordinating with IT department for main database updates and backups.
• Extraction of data from various customized packages and import into Access.
• Migration of MS Office 2003 to MS Office 2007. Testing all application functionalities.
• System Analysis and suggest enhancements for better productivity.
• Creating reports in People Soft .
• Imports and exports data between Access 2007, Excel 2007 and SQL Server.
• Development of pricing modules and clients reviews applications.
• Co-ordinate with Configuration Analysts for Domain Migration and testing Applications on Citrix Box.

Confidential

Programmer Analyst.

Summary:

Confidential is one of the largest Financial Client, operating globally. In my work experience with them I was responsible to develop application for Offshore and On shore Funds. I did a lot of development and automation in MS Excel 2007. Develop macros and automate manual work. Develop applications for auto generation of Allocations for all Funds. Creations of client's statement in bulk through mail merge auto process. Created lots of valuable reports for management prompt decisions.The company itself describes their strength and values under More detailed responsibilities are mentioned below:

Responsibilities:

• Daily, Fortnightly and monthly Reports Generation from Customer Relation management System, HedgeTek and Eglue Systems.
• Support to Investor Accounting and CS Funds Teams in term of creation of applications, Forms and prompt reports for client's statement generation process.
• Development of Macros and procedures for daily manual work to improve the productivity and accuracy of data usage.
• Extraction of data from HedgeTek System and uploading in CAT system Customer's Accounting maintenance system .
• Bulk statement generation and Mail merge processes.
• Develop and maintain the Customer's shares and investment databases.
• Creation of High Water Mark and incentives for client's investments.
• Imports and exports data between Access 2007, Excel 2007 and SQL Server.
• Extensive usage of SQL Queries for prompt reporting for Higher Management and Client's review.
• Backups and restoration of data from different system like CAT / CRM / HedgeTek and Eglue.
• Data extraction to Excel and generation of Mapped sheets with Dynamical Links of Workbooks.
• Supporting Investor Accounting and CS Funds Teams for their day to day Application requirements.
• Co-Ordinate with company's I.T development team for bulk data uploading for valuable Client's and their share holders.

Confidential

Application Developer /VBA Database Consultant

Responsibilities:

• Maintain, update, and develop Microsoft Access databases.
• Responsible for migration of extensive databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.
• Data migration from MS Access 2002 to MS SQL 2000 / 2005.
• Migration of MS Access Databases 2003 to SQL Server 2005 by using Import wizard and Creating DTS Package in SQL Server.
• Data Validation in MS EXCEL 2007, Creation of forms for data entry while using data validation.
• Creation Pivot Tables for Reports and creation of Graphs.
• Advanced Excel programming, Usage of Vertical and Horizontal look ups.
• Development of Macros and Formulas in Excel 2007.
• Making up backup strategies while doing migration.
• To bring the databases online after migration.
• To assist the software estimation and time frame keeping in view the budget outline of the company.
• To create documentation for future time and training to new onboard users.
• MS Access 2007 with add-ons
• To improve functionality and efficiency, reduce redundancy, and Improve the accuracy, availability, and usefulness of the court's case- related data.
• To perform VBA work, modifying understanding VBA scripts.
• Design and Development of software components.
• Comply with and adhere to the documented quality standards and methods for the development of applications with understanding of VBA.
• SQL statement using SQL server 2000/2005
• IBM Lotus Notes.
• MS Active Data Objects ADO ex record set, type of record sets, and setting up a connection
• Perform code walkthroughs of other team members' code.
• Experience working remotely using Net Meeting, or Windows Live
• To interface with third party programs, other MS products and APIs.
• Troubleshoot and maintain existing MS Access database for Company's Data Inventory System Department.
• Ability to collection of data and design a relational database with queries and reports to meet customer requirements Ability to trouble-shoot relational databases to isolate problems, and fix.
• Extended the capabilities of an existing database used to track customer records in pure refined way after applying different queries.
• Import and Export databases between Microsoft Access, Microsoft Excel, Text, or SQL.

Environment: Visual Basic 6.0, MS Access, VBA and Windows XP Professional.

Confidential

Programmer Analyst.

Responsibilities:

• Provided MS Access database design and support for in-house Accounting Systems applications.
• Provided transition support to assist clients when support was discontinued.
• Support, maintenance and enhancement of Fox pro to Ms Access.
• Data migration from MS Access 2000 to MS SQL Server 2000.
• Encryption of database while using third party tool like MSDB Secure 2008.
• Provided client with startup business support including Fox pro/Access programming and general logistical support for inventory control and management system.

Special Features

• With the help of this system we can create the purchase orders for the customers and the vendors as well.
• All the queries and concerns are being replied promptly by the help of this system.
• Data extractions and Reports generation modules are written for management use.
• Received, Sale and balance sheets are being generated from this system for the use of Sales and Warehouse department.
• Financial transactions and Banking issues are being monitor while using this system.
• Shipping and handling information and delivery status are also update in this system and can easily review by all users on the network.

Environment: Visual Basic 6.0, MS Access, Fox pro, Windows XP Professional.

Confidential

Access Developer.

Responsibilities:

• Provided MS Access database design and support for in-house Accounting Systems applications.
• Provided transition support to assist clients when support was discontinued.
• Support, maintenance and enhancement of FoxPro to Ms Access.
• Maintenance and support of MS Access Mental Health Assessment application.

Confidential

Programmer

Work Profile:

Confidential extractions. The system was developed in MS Access2002 for data entry, editing of data and reports generation.Involved in the requirements analysis of the system for enhancement. For the same, worked with users to know about existing system and their further needs to enhance the performance and solve problems. Complete task was to re-engineer the application.

Responsibilities:

• Was responsible for analysis and design the reports made in MS Excel to work with new system.
• Worked with MS Excel files using VBA to create graph reports interface.
• Wrote Stored Procedures in PL/SQL or complex data manipulation and advanced SQL queries to get data for reports using MS Excel for different criteria.
• Interviewed functional users to identify requirements and converted these findings into program specifications
• Designed request forms in Excel for each expenditure type.
• Added E-mail utility to forms using Outlook
• Designed and developed the database and user interface in Visual FoxPro 6
• Developed and implemented test plan.

Environment: MS ACCESS, MS EXCEL, VBA, MS SQL, MS Windows 2000/2003

Confidential

Project: Inventory System for Operation Department.

Work Profile:

• Designed, developed, maintained, optimized, and debugged corporate and field applications in the nation's fourth largest Bank. Specialized in audit reporting and query analyzer.
• Part of the development team for inventory applications deployment. Designed and developed application logic and architecture. Created and coded the application in Visual Basic front end to interact with back end using Microsoft Access.
• Participated in application testing functional, regression and system bug resolution and carried out client side validations.

Responsibilities:

• Involved in Requirements Analysis of the system for enhancement. For the same, worked with users to know about existing system and their further needs to enhance the performance and solve problems. Complete task was to re-engineer the application.
• Specially involved to rewrite MS Access application to link one database to other. Was responsible for analysis and design the reports made in MS Excel to work with new system.
• Worked with MS Excel files using VBA to create graph reports to display on browser.
• Involved with system integration testing at different levels during the deployment.
• Performed code reviews and bug fixing during various phases of testing.

Responsibilities:

• Being a prior worker of the bank I, performed a lot of Operational task regarding, Account opening, Customer support, Quality service.
• I also worked for transactions handling like System operating billing, Online transactions.
• I also performed for transfer of amount from one account to another account.
• Same day transaction and outward bill for collection was also a part of my working.
• Plus TT, LTB was also handled by me in and out side the country.

Environment: Visual Basic 6.0, MS Access, VBA and Windows 2000 professional.