SUMMARY:

• A Senior Systems Analyst/Technical Lead with extensive experience in the successful development and maintenance of business applications involving full project life cycle. Background includes project lead, system analysis, and design, development and maintenance of Windows based GUI applications.
• Expert in database modeling, design, development, and tuning. Designed and implemented ETL strategies to capture and load raw transactional, static and market data into data warehouse environment from multiple source systems. Worked as an Oracle expert to analyze and resolve performance issues, actively involved in development and implementation of new applications design and refactoring strategies to utilize technologies provided by Oracle database.

TECHNICAL SKILLS:

Operating Systems: Windows NT,XP, 2000.7, Unix

Software: FILENET, MSMQ, IBM MQ, MS Office, VSS, SVN

Languages: VB.NET, C#, VISUAL BASIC 4.0, 5.0 and 6.0, XML, SQL, PL/SQLTools: ASP.NET, SQL*Plus, Oracle Reports 6.0, 6i, Crystal Reports 6 and 7, Toad, Erwin Data, Modeler, Visio

Databases: Oracle 7.x, 8i.x, 9i.x, 10g, 11g; MS SQL Server 6.5 and 7.0; MS Access

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior Oracle Developer

Responsibilities:

• Participated in initiation of new projects, gathering user and business requirements
• Performed database production support and troubleshooting
• Create technical specifications based on BRD.
• Create stored procedures, functions, types, sequences, packages, triggers, views, tables and other Oracle objects including advanced features of the product
• Write scripts to load data as a part of the scheduled process.
• Tuning PL/SQL programs.
• Create stored procedures, functions, views

Confidential

Responsibilities:

• Create packages, stored procedures, functions, views
• Generate alerts for Norkom Case Management
• Communicate (data, regulations) with Crowe Horwath team to setup Investigator Case Manager tool
• Designed test specification for QA team.

Confidential NY

Senior System Analyst/Developer/Programmer

Responsibilities:

• Front end responsibilities include:
• Analysis, design and development of applications using VB.NET, Visual Basic 6.
• User and production support.
• Database responsibilities include:
• Create stored procedures, functions, types, sequences, packages, triggers, views and tables.
• Write scripts to load data as a part of the scheduled process.
• Tuning PL/SQL programs.
• Conversion FFACTS old system based in Access and Excel into new Oracle environment.
• Create reports using Crystal Report software, MS Excel and MS Word (Mail Merge).
• Create project plans, technical specifications based on BRD and schedules (MS Project).

Confidential, Long Island City, NY

Assistant Vice President, Senior System Analyst/Team Lead/Programmer

Responsibilities:

• Wrote project specifications, statement of work (SOW), High Level Design (HLD), Test Plan (TP).
• Worked with business and communicate results to project stakeholders.
• Front end responsibilities included:
• Analysis, design and development of applications.
• Create classes, COM objects, ActiveX controls using VB 6. and production support.
• Create stored procedures, functions, types, sequences, packages, triggers, views and tables.
• Implement advanced Oracle 8i and 9i features such as Advanced Queuing, collections, E - mail (SMTP server), Oracle Label Security.
• Create reports using Oracle Reports 6i, Crystal Report.
• Communicate with Web Services from PL/SQL.
• Maintenance and troubleshooting development database.
• Tuning PL/SQL programs by utilizing indexes, hints, information from Oracle Explain Plan.
• ETL
• Design and development of VB.NET console applications to get and put XML messages to MSMQ/MQ.
• Design and development of VB.NET applications.

Confidential, NY

Programmer

Responsibilities:

• Front and back end responsibilities included:
• Analysis of the user requirements, screen design.
• Coding and testing the application using Visual Basic 5.0, 6.0.
• Creating stored procedures, functions using MS SQL Server 6.5,7.0.
• Creating reports using Crystal Reports 6 and 7.

Confidential, NY

Business Analyst/Programmer

Responsibilities:

• Performed analysis of data and expenses based on monthly reports. Composed and prepared tables using information received from bulletin board. Formatted the files for updating the system and creating reports. Programmed routine procedures for accepting flat files and loading data in to the tables in SQL Server database. The development was done using Visual Basic 5, MS SQL Server 6.5, MS Access, MS Excel.

Confidential, NJ

Consultant

Responsibilities:

• Designed, developed and tested Cash Flow Management System (CFMS). The CFMS was a multi-platform software package using VB 5 as a front end and Oracle7.2 as a back end. Analyzed the user requirements for modification of existing objects.

Confidential, NY

Business/Data Analyst

Responsibilities:

• Participated in the development of Job Side Tracking Subsystem which provided data entry and data collection for addresses, skills, possible option dates, job sides, ID-cards, etc. Used tools: VB4, MS-Access, Crystal Report 4.5.