SUMMARY

• Over 12+ years of experience in IT industry. BS & MS degree in Computer Science.
• IT Technical Business Analyst, Programmer Analyst, Programing and Application Program Management for several projects.
• Website, Wordpress, PHP, Magento, Ecommerce stores such as Shopify.
• Social Media: Facebook Marketing Integration | Twitter | LinkedIn integration
• Skilled in Mendix, VBA programming in Excel, Word, MS Access, SQL, Visual Basic, Some C, C++, Java
• Good Communication skills.
• Will surprise you at the speed I understand your business requirement/technology needs

PROFESSIONAL EXPERIENCE

Confidential

IT Business Analyst, Programmer Analyst

Responsibilities:

• Performed as a Technical Business Analyst and as a programmer analyst in several projects. Gathering understanding, managing client requirements.
• Interpreting and performing requirement analysis, programming analysis and data analysis. Worked with programming with assigning programming tasks, managing programmer coding programming tasks.
• Also performing coding for several projects. Developed several applications from ecommerce site to display sites to scheduling to live interactive sites to real estate sites using various PHP, Magento
• MySQL Wordpress, Joomla and others including working with various shopping cards and payment systems, plugin and others.
• Developed various intranet applications to manage sales order, inventory based on ERP concept developed using Visual Studio, Visual Basic, Sql Server and MS Access. The application balances goods going out and goods coming in.
• Developed application as SCRUM master and also as a developer using Mendix platform.
• Developed various advanced Excel Applications using Excel advanced formulas, graphs, forms.
• Developed various MS Access Applications with hundreds of forms, macros, queries accessing both Sql Server Databases and MS Access Databases.

Confidential

Sr. Programmer Analyst / Technical Business Analyst

Responsibilities:

• Analysis of customer requirement working closely with customers. Programmed / Developed a Structuring Risk Management application using Visual Studio, Visual Basic, Sql Server and MS Access.
• The application helps Enron agents called structurers put together Structuring deals. Structurers study the feasibility and profitability of providing energy to various consumers. The application has two parts, a deal assignment part and a reporting part.
• The deal assignment part was developed in Visual Basic and the reporting part was developed in Visual Studio. This application has about 50 forms and about 60 tables. Wrote stored procedures and triggers in Sql Server. Used the ADO data objects for data access.
• Using Visual Studio wrote a complete reporting tool.
• Users would select a report or enter a query on a web page. Based the query we developed Active Server Pages (ASP) that would produce HTML pages with the report or query Results.
• Also used crystal reports to produce reports. About 50 reports could be produced by this manner.

Environment: Visual Studio, Visual Basic, Sql Server, MS Access, ASP, VB Script, Java Script, Crystal Reports. COM Objects.

Confidential

Programmer Analyst / Business Analyst

Responsibilities:

• Developed three intranet applications with Visual Basic, Visual Studio, using Active Data Objects (ADO). 1.Merchant Application 2.Credit Review 3.Agreement Review. These applications processed the signing up and approval of merchants for
• TeleCheck services. Merchant Application gathered information about the merchant. Credit Review processed the merchant credit via TRW and D&B reports. Agreement Review processed the final approval of a merchant to become active for TeleCheck services.
• All three completed applications are currently in production and actively used by client services.
• All three applications used ADO objects (ActiveX) to access data from a SQL Server database via the intranet. Extensive use of Active Server Pages, MS Flexgrid, MAPISession and MAPIMessages
• Controls. Collected user requirements for the 3 applications and developed the initial design of the SQL Server database, used Crystal Reports and ASP to produce reports and Visual SourceSafe for code management.

Environment: Visual Studio, Visual Basic, Sql Server, MS Access, ASP, Crystal Reports. Developed some COM Objects in Visual Basic

Confidential

 Lead Programmer Analyst

Responsibilities:

• Developed a Visual Basic 5.0, MS Access 7.0 application called Service Contracts. This application kept track of the service contracts Enron has with various service contractors.
• The application allowed the creation, maintenance and reporting of all service contracts. In addition to access reports, the application mail merge MS Word 97 merge documents and Excel 97 files.
• In the Service Contracts application one of the MS Access forms merge MS Word 97 documents online with the user specified criteria on contracts. The application has about 20 tables, 50 queries, 10 forms and 40 reports. Wrote Word and Excel VBA macros.
• Created setup programs, tested the application and implemented the application and setup the application on user machines. The development of the application involved talking to customers to get requirements, developing, testing and then finally setup and documentation.

Environment: Visual Studio, Visual Basic, MS Access, Some Sql Server, VBA.

Confidential

 Programmer & Analyst

Responsibilities:

• Coded, debugged and modified two applications called Adonis and RPP. Adonis and RPP were two Visual Basic applications that Pan Energy uses for their energy trading and market services.
• RPP was used by the agents in the fields to make sales with clients. Adonis was used to maintain information on Customers, Pipelines, Agents and Distribution Companies.
• It also served an engine that performed calculations based on formulas that could be created and edited through Adonis.
• These calculated results were in turn used by RPP. Both applications consisted of about 50 forms and accessed a MS SQL Server 6.5 database.
• Extensive use of MS SQL Server 6.5. Created Views, Stored Procedures and Triggers. Extensive use of SQL Queries, RDO objects, Visual SourceSafe, etc.

Environment: Visual Basic 4.0, SQL Server 6.5, MS Access, VBA.

Confidential

 Lead Programmer & Analyst

Responsibilities:

• Developed three complete applications: 1. Inventory Management System. 2. Consignment and Delivery Management System. 3. Supplier Module. Replaced the existing legacy system (IBM Mainframe, XBMS) handling Consignment and Inventory in Xerox. Designed and Implemented a Client Server application in place of the current system, using Visual Basic 4.0, Oracle 7.0 and Access 2.0. Wrote several C++ functions to facilitate the communication and data transfer between the IBM Mainframe and the Oracle 7.0 database.
• This involved detail research of the current processes, discussions with material planner, buyer, Xerox’s internal and external vendors, and warehouse supervisors. Used Access 2.0 and Oracle 7.0 to design and implement a data model. Used Visual Basic 4.0 to design and implement a GUI front end. Tested, documented, provided training and support on the developed client server system. Ninety percent of the development of these three systems was performed by myself.
• Inventory Management System: This Visual Basic 4.0 application consists of about 40 forms, with complete menus and toolbars. Primarily used in the warehouse where receiving and issuing of materials are processed. It also enabled the transactions such as inventory transfer, relocation, adjustments, corrections, reports and inquiries. This application was designed to be implemented in four different warehouses nationwide. It would update an Oracle database in the local warehouse, a common central OMF Oracle database located in Rochester NY. This module is currently in production.
• Consignment And Delivery Management System: This Visual Basic 4.0 application consists of about 25 forms with complete menus and toolbars. This application was used to track consignment of Xerox parts to external internal vendors. Transaction such as shipment of material to suppliers, tracking WIP scrap and excess, adjustment, finished goods and editing SODM and PO were possible using this application. It also included inquiries and reports. This application was designed to be implemented in a central location in Rochester NY and it updated a local OMF Oracle database. This module is currently in production.
• Supplier Module: This Visual Basic 4.0 application was designed to be installed at each vendor so that it would communicate with the consignment system that I developed. This module consists of about 10 forms that allowed transaction such as material receipts, WIP scrap reported, received, excess scrap reported, received, finished goods, history of transactions, tracking supplier information and reports.
• Also accomplished a connection, command and data transfer between Visual Basic 4.0 and IBM Mainframe 3270.

Environment: Visual Basic 4.0, Oracle, MS Access, Some Sql Server 6.0, VBA.

Confidential

 Programmer Analyst

Responsibilities:

• Cincom Systems develops manufacturing applications and is a competitor to SAP.
• Involved in the development and debugging of Visual Basic 3.0 applications called Planner Workbench, an application used by Material Planner in manufacturing firms. This is a complete software with menu bar, toolbar, complex, drag and drop features with about 50 forms with extensive use of True Grid custom control. This application was designed for use in different countries and different languages - All displayed text would be in the native language.
• Involved in the creation, development and debugging of a Visual Basic 3.0 software package called INLO Translation Tool. This software is used for translating English text contained in other applications labels, menus and error messages into different languages.
• It is used as an internal tool for accessing an Access 2.0 database, modifying and entering data, and printing reports via Crystal Reports. It is a package with complete menu bar and menu items with True Grid control to display and modify data.
• Involved in modifying and debugging of Visual Basic 3.0 software packages called Design Wizard and OLE Wizard. These packages are for internal use for the construction of applications. Referred to as GUI tools, these GUI software packages provided an interface for designing the GUI for applications and also generated standard code for each application.
• Also involved in the construction and testing of four other manufacturing applications. Each application forms a part of a huge manufacturing software. Each application uses OLE objects to access server database data via ODBC. Each application was designed to be used in different countries in their native language. Created VB setup programs and installation disks for VB applications.
• Involved in data modeling, created entities and their attributes, and normalized data following the three normal forms. Wrote stored procedures and triggers. Used PL/SQL, SQL Forms. Used ODBC to access Oracle server database residing on UNIX.
• Extensive use of Access 2.0 database; creation of tables, forms, queries, macros and modules. Involved in development of Access 2.0 applications using Access VBA and Forms. The application took user input and manipulated tables and data in an Access database.
• Tested applications that were developed in VB versions 4.0 and 3.0. Implemented necessary changes and created applications in 4.0. Wrote VB 4.0 applications to integrate with 3.0 applications. Analyzed the creation of classes, building Add-Ins, controlling VB-IDE, OLE automation, creating DLLS in VB 4.0.
• Using Visual C++ created three different OLE Objects. One called Cstrings that made possible the use of all C++ String functions in Visual Basic. The other two robust OLE Objects were used as a middle layer (Business Layer) to check rules for various business processes. They also formatted data for Oracle backend databases for the Visual Basic front ends. Created Excel macros to test OLE objects.
• Involved in the development of a Visual Basic 3.0 software package called Pulse for the Home Health Care industry. Involved in the development of C routines for the same package. The package uses Ingres 6.4/04 database and resides on a UNIX SCO machine.
• The application consists of:
• Clinical module: which involves keeping a routine maintenance of the patients from admission, treatment, medical and insurance information and discharge. Operational Module: for inventory control, scheduling, Accounting Module: for all accounting activities, including Payroll.
• Setup a Windows NT 3.1 server network with three Windows NT workstations and one WFW workstation. Created Domains, group accounts and user rights. Installed client software over the network using Network Client Administrator.

Environment: Visual Basic 4.0/3.0, Oracle, SQL Server, MS Access, C++, VBA, UNIX, Ingres.