Experience Summary

• Extensive experience in Analysis, Design, Development and Implementation of Oracle database applications 11g/10g/9i/8i and MS Access 2007/03/02/00/97.
• Experience in all phases of Software Development using Visual Basic VB 6 Crystal Reports.
• Proficient in designing relational database model and implementation as per business requirements.
• Strong practical experience in designing/development of queries, tables, relationships, forms, reports using Oracle 11g/10g/9i/8i and MS Access 2007/03/00/97.
• Extensive experience with writing code and developing forms, macros, modules, reports in Microsoft Access VBA and VB6.
• Experience in data manipulation using ODBC, DAO ADO Objects in MS Access VB6.
• Extensive experience with manipulation of data in oracle database and Access database.
• Extensive experience in development of macros, modules, pivot table, Vlookup Various Excel functions.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experience in implementation of strong referential integrity and auditing by the use of triggers.
• Worked with Oracle products, tools and utilities like SQL Loader, SQL, PL/SQL, SQL Plus, iSQL Plus
• Experience in translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze and deploy programs.
• Experience in testing SQL codes in large Data Warehouse consisting billons of rows.
• Experience with medical health care claims Data, especially Medicaid claims.
• Experience in working with Production, Testing and Development environments.
• In-depth technical experience of performance tuning, query writing and query optimization.
• Experience in working in Toad, Microsoft SQL Server 2008/05/00 and Oracle BI Discoverer.
• Experience in database design, backup and recovery, data transfer and transformation.
• Self-motivated and possess ability for critical thinking, good interpersonal and communication skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Experience in ASP, Java, VBScript, Unix Shell Script, JavaScript, Active X, HTML, and IIS with good proficiency in Web-enabled applications.

Areas of Expertise

• OS/Platforms: Windows 95/ 98/XP/Vista/07, Linux, Citrix application server
• Languages: C, C , VC , COBOL, JAVA, VB, VBA, SQL, T-SQL, UNIX Script, PL/SQL
• Networking/Protocols: Socket Programming JAVA
• Web Technologies: IIS, Apache Tomcat, Java-Servelet, VB Script, ASP, HTML
• Database: MS SQL Server 2008/05/00, Oracle 11g/10g/9i/8i, MS Access 2007/03/02/00/97
• Tools: MS FrontPage, MS Office, MS Word, MS PowerPoint, MS Outlook, MS Project, Crystal Reports, Visual studio, Oracle BI Discoverer, SQL Developer, Toad, Oracle report 10, SAP Business Objects, MS Excel 2007/03/00/97, iSQL Plus

professional Experience

Confidential

Sr. Software/VBA Developer

• Spectra Techonvision was established in the year 1999 with a vision to excel in the fast growing field of Automatic Identification Technology based Solutions. These solutions are necessarily a combination of time recording devices and relevant application software.
• Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements
• Involved in Development of different Attendance Access Control Applications Customized Applications
• Involved in Development of different Applications like,
• Net X Control: This application will used for company's security purpose. This application is used with hardware to allow peoples to use there premises. By this application they can watch there employees movement in different departments.
• ARS WinPro, ARS WinNet: A complete system for attendance Software provides all kind of HR operation required in industry like making attendance, leave process, overtime process, tour or outdoor duty process, adjustments and generating payroll inputs.
• Visitor Management: It computerizes the current manual system of visitors. The Software manages the visitor scheduling, appointment history, visitor information along with visitor history.
• Developed complex forms, reports, modules using VB6 MS Access VBA
• Developed Active X control, DLL exe files
• Developed new reports as per business requirement
• Develop large and complex SQL/PLSQL queries, procedures, Functions as per specifications
• Create ODBC connection, ADO DAO objects to connect Oracle SQL Server databases
• Worked on complete SDLC system development life cycle including system analysis, high-level design, detailed design, coding and testing.
• Documented technical, user documentation and the user guide for the system

Environment: VB 6, VBA, Oracle 10g, SQL Server 2008/05 , SQL, T- SQL, PL/SQL, MS Access 2007/03, Excel 2007/03, VBA, Windows XP, TOAD, Crystal report 11/8.5 , Robo help

Confidential

MS Access Oracle PL/SQL Programmer/Analyst

• Confidential mortgage banking has one of the core services as Loan Administration. Loan Administration encompasses the operational functions supporting loan transfer, escrow, statements, tax, insurance, end-of-year operations, credit reporting, lien release and Manila operations. These groups work closely together to ensure reporting integrity, strengthen controls, provide audit and compliance oversight, enhance vendor management, and improve and enhance customer statements.
• Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements
• Involved in migration from MS Access reports to Oracle reports
• Provide support to various MS Access applications
• Import/Export of data from oracle database to MS access using linked tables
• Worked on break fixes and enhancements of the oracle reports
• Worked on data extract from oracle
• Developing new oracle reports as per business requirement
• Involved in writing code, developing forms, reports in Microsoft Access VBA
• Develop large and complex SQL/PLSQL queries, procedures reports as per specifications
• Writing technical and user documentation
• Involved in writing Business requirement document BRD
• Writing SQL/PLSQL scripts for database objects
• Develop schedule reports as per business requirements in SAP Business Objects

Environment: Oracle 10g, Oracle Report 10, SQL, PL/SQL, MS Access 2007/03, Excel 2007/03, VBA, SAP Business Objects, Windows XP, TOAD

Confidential

MS Access VBA Developer/Analyst

• OPWDD helps people with developmental disabilities live richer lives. They are creating opportunities and supporting people in ways that allow for as many as possible to access the supports and services they want and need. I am responsible for various mission critical tasks and projects that support the strategic framework of the agency's 5 year plan, the Local Government Plan, NYCARES III and a host of other informational resources , which includes
• Developing various Microsoft Access Application as per Business Requirements
• Developing applications that utilize a Microsoft Access front-end and an Oracle database back-end
• Writing SQL/PLSQL scripts for database objects
• Developing complex queries, tables, relationships, user entry forms, reports, database objects, modules macros using Microsoft Access VBA
• Developed Pass-through queries, ODBC connection to oracle database
• Developing Oracle databases involved in data manipulation
• Developing complex functions, procedures, triggers reports
• Developing Microsoft Access 2007 Application using DAO ADO objects
• Creating XML File from Access database
• Responsible for development and support of a number of high priority Agency Oracle / MS Access and MS Access Applications. This includes
• Provide support to Helpdesk on Application related issues
• Developing Microsoft Access applications residing on a Citrix application server
• Writing technical and user documentation
• Write VBA code in Excel outlook to automate the process
• Standing Committee Incident Tracker Application. This MS Access / Oracle application assists the Agency's Internal Affairs Bureau in the tracking, analysis, and reporting deaths and alleged abuse of the individuals served by the Agency.
• Development Plan Application used to manage the Agency's state and voluntary development plans and will provide Executive Management with data on community development including the status of NYSCARES initiatives.
• Workforce Planning Application used to manage the Agency's state staff catalog Training and Talent Development Programs. This Catalog contains programs of interest to professional and direct support staff in both the state and voluntary non-profit sectors.
• Aging Out application tracks individuals served by the Agency that will have a residential need once they reach the age of 21 years.

• Allocation Tracker application used by Budget Services to track and maintain DDSO resource allocations. Data from this application will be passed to the Tracking and Billing System TABS for maintaining and tracking At Home Residential Habilitation allocation units. In addition, this application will be interfaced with the Development Plan Application for the purpose of exchanging allocation unit data.

• Willow Brook Tracking System. Application will be migrated from a standalone application to a Citrix environment and is used for litigation support and to monitor and report information for the Willow Brook Class as mandated by NYS Law.
• Commissioner's Emergency Roster Application. Application will be used to track and maintain employees' personal information for use in the event of an emergency.

Environment: Oracle 10g, MS Access 2007/03/02/00, MS Excel 2007/03, Windows 7/XP, SQL Developer, PL/SQL, VBA, Crystal report, Citrix application server

Confidential

MS Access Oracle PL/SQL Developer /Analyst

• The Confidential Administration/ Department of Social Services HRA/DSS provides temporary help to individuals and families with social service and economic needs to assist them in reaching self-sufficiency. I am responsible for development support of various tasks and revenue-generating and health care claims projects, which include
• Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements
• Participated in implementing the logical design to the physical design
• Involved in writing code, developing forms, reports in Microsoft Access VBA
• Develop large and complex SQL/PLSQL queries, procedures reports as per specifications
• Designed and developed Complex database tables, triggers, cursors, procedures, functions and packages to meet business requirement
• Involved in manipulation of data in oracle database
• Created Views, Sequences and other database objects
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Create spreadsheets and reports using Crystal Reports, Access and SQL
• Responsible for development support of various revenue-generating projects related to health care claims and eligibility which resulting in millions of dollars of annual federal reimbursement to the city, which includes
• Involved in testing the SQL scripts
• Code review in Queries, procedures, functions and triggers
• Responsible for data analysis on revenue-generating projects
• Export analyze data using MS Access and/or Excel
• Export test SQL codes in HRA Data Warehouse using the production development area
• Document processing for all SQL codes
• Used external tables to analyze third party data
• Quality assurance
• Duplicate CIN Project: This Project is used to find duplicate medical claim for Medicaid Managed Care Providers.
• Fair Hearing TALX PEG project: This Project is used to find saving per month in Fair Hearing TALX PEG.
• FSET Matching Project: This Project is used for matching DYCD literacy program clients to determine if their program can be funded by FSET. The other project is matching ACS child care clients to determine if the child care can be paid for by FSET.
• CAS/SPMP claim Project: This Project is used to find claim for Medicaid eligible clients who were serviced by the Customized Assistance Services' CAS Visiting Psychiatric Services VPS unit. The CAS/VPS staff that provides services to Medicaid eligible client can be claimed for enhanced Skilled Professional Medical Personnel SPMP Medicaid reimbursement under the Federal government.
• Summer Youth Employment Program Project

Environment: Windows XP, Oracle 10g, iSQL plus, SQL plus, PL/SQL, Oracle BI Discoverer, SQL Developer, VBA, MS Access 2007/03, Crystal Report, MS Excel 2007/03, Unix

Confidential

Oracle/ PLSQL VBA Developer

• As a team of member responsible to design the logical and physical database designs
• Translated business requirements into specifications for systems development projects
• Wrote database PL/SQL triggers and procedures, Function, Packages to provide Backend security and data Consistency.
• Trouble shooting for the end users requirement and Optimizing database
• Coordinating and scheduling changes to database based on requirements
• Converted an existing database in Ms Access to Oracle for a pre-existing application in VB
• Did some modification in database connectivity for VB application for Oracle database
• Created database tables and indexes and partitioned existing tables
• Coded, tested, debugged and documented the new enhancements
• Generated a number of reports for management to review for system functionality as against the old legacy system
• Documented functional and technical designs, test cases, and user guides

Environment: Oracle 9i, SQL plus, MS Access 2003, MS Excel 2003, VB6, VBA, PL/SQL, SQL, Crystal Report 8.5, Windows NT, UNIX

Confidential

VB/SQL/Access Developer

• Actively participated in gathering Business Requirements and System Specification
• Developed an Inventory Management System
• Develop ER diagram, Data Flow diagram table dictionary
• Developed code, forms, reports, modules, tables, queries in MS Access VBA VB6
• Maintained all pertinent information on - customers, suppliers, and transporters
• Setup various report and login facilities
• Worked on complete SDLC system development life cycle including system analysis, high-level design, detailed design, coding and testing.
• Documented the user guide for the system

Environment: Oracle 8i, Visual Basic VB6 , VBA, Crystal Report 8.5, MS Access 2002, MS Excel 2002

Confidential

Programmer/Analyst

• Determined user/business/functional requirements
• Created vision, scope, and use case documents business process models, use case diagrams, and activity diagrams
• Developed Interactive Billing system for garment shop
• Maintained all information about purchases, suppliers, salespersons and items sold
• Developed forms, reports, modules using VB6 VBA
• Provides login report generating interface
• Involved in the complete SDLC
• Designed coding specification and documentation
• Participated in the full software life cycle.
• Maintained user access
• Involved in testing the system

Environment: SQL Server 2005/00, Java, HTML, VBA, Visual Basic VB6 , Crystal Reports, ASP, MS Access 2002, MS Excel 2002