SUMMARY:

• Sixteen years experience with the of senior information technology, team leader and software developer with progressive experience in supporting,, implementing and deploying rapidly changing system technologies for diverse IT projects. Demonstrated competency as project manager with significant expertise in full lifecycle project management. Strong database schema design and user interface design.

TECHNICAL SKILLS:

Environment: MS - DOS, MS-Windows 3.1, MS-Windows 95, MS-Windows NT, MS-Windows 2000, MS-Windows 95, MS-Windows XP, Windows 2000 Server, MS IIS 5.

Languages: ASP/VB .NET, C#, MS SQL Reporting Server 2005, MS Report Builder 2008, Visual Basic 6.0, Visual Basic 5.0, Visual Basic 4.0, C, C++,VBA, Pascal, SQL, Active Server Pages Script, Java Script, HTML and DHTMAL, VB Web Classes, Oracle Forms and Reports.

ODBC: Server SQL Server 2000, 2005 / T-SQL, Oracle 8i, MS ODBC, MS DB-Library, DataDirect MultiLink/VB, CodeBase 6.0 Database, Jet Database Engine, ADO, RDO.

Applications: MS SharePoint 2007, MS Sharepoint Designer, MS Business Intelligence, SSIS, SSRS, MS Visual Studio 2005, MS Visual Source Safe, White Hill Modeling environment,Crystal Reports, Visio, Legal Key, Elite Enterprise, Star Designer (Case Tool),MS Project, HP Quick Test Professional (QTP).

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Software Quality Assurance

Responsibilities:

• Engaged in test automation for Medidata critical systems. Technology used for these automations are Ruby and MySQL.
• Developed end to end test cases and scenarios using HP Quick Test Professional (QTP). Scheduled these test cases to run on daily basis and send out emails of their results.
• Collaborated in establishing testing strategies, developing test plans and use of testing tools in an Agile project life cycle development.
• Created test plans and performed testing as assigned.

Confidential, New York, NY

Senior Applications Specialist

Responsibilities:

• SQL Server developer responsible for developing SQL scripts, analyzing data and performance tuning.
• Developed business intelligence reports and data models using MS Visual Studio 2005. These reports/models uses SQL server to populate reports. Deployed reports/models to SQL reporting server and setup users permissions.
• Developed workflow engines to manage and control documents distribution. Technology used is .VB NET and SQL server.
• Developed SSIS packages using MS business intelligence development studio to merge data from different database sources and populate data warehouse.
• Developed MS SSIS packages which imports data from different sources, manipulate the data and inserts/updates SQL databases.
• Developed SQL procedures which extracts data from different data sources, manipulate data and archive in a datamart for reporting purposes.
• Worked with business users and outside vendors as a liaison, responsible for leading meetings with business users and management for projects updates and gathering requirements.
• Providing support and dealing with day to day issues with end users.
• Developed MS Sharepoint solutions based on users requests. These solutions includes Lists, sites, sub sites, Sharepoint BDC, and out of the box web parts.
• Maintained and supported MS SQL server reporting services. Upgraded reporting server from and deployed all existing reports to the upgraded version.
• Developed an ASP.Net/VB web applications which is used by admin staff to review and compensate lawyers based on performance. Developed the backend database in SQL server and automated data import from different systems.
• Engaged in the development of Cost Recovery System which automates the cost transaction collection process from various vendors in to the billing system. This system was developed using White Hill technologies, .NET and MS SQL Server 2005.
• Engaged in the development of Workforce Data Lifecycle system. This system automates adding and updating user information into several backend systems.
• Engaged in the installation and deployment of new systems. Worked with vendors on and created a deployment and testing plans.
• Created SQL server reports subscriptions which can be send based on users request.
• Developing complicated SQL queries based on users requests.
• Engaged in data center migration which involves migrating applications to a different data center site.

Confidential, Jersey City, N.J

Senior Programmer/Consultant/Team Lead

Responsibilities:

• Collaborated in the development of IA BILLING system. Responsible for the conversion of database from SQL Server 6.5 to SQL Server 2000, Data modeling and Data extract and manipulation. Also developed C# program which connects to SQL Server, extract data and created an associated XML files which used for data imports.
• Developing complicated SQL queries based on users requests.
• Maintaining and enhancing daily jobs which are written in C#. The purpose of these jobs is data manipulation and extraction.
• Providing support and dealing with day to day issues with end users.

Confidential, New York, N.Y

Senior Programmer/Consultant

Responsibilities:

• Developed Excel spreadsheets for Delta Hedge Fund application. These spreadsheets connect to SQL Server to extract trading transactions and update Excel spreadsheets with the new SHORT/LONG/OPTIONS transactions.

Confidential, New York, N.Y

Senior Programmer/Consultant

Responsibilities:

• Provided database architecture, complex stored procedures development, profiling and tuning. This application is provides Municipal Financial Ratio Analysis calculations and enables users to view Quantitative Rating for all public and private sectors.
• Developed complex reports and data loading methods using SQL Server 2000, SQL tuning utilities, DTS.
• Developed data import utility which imports data from XML web service to SQL Server 2000 database. Technologies used VB .NET and ADO .NET. This utility updates the Quantitative and Municipal Application.

Confidential, New York, N.Y

Senior Programmer/Analyst - Team Lead/ Consultant

Responsibilities:

• Developed and integrated a web service with other client applications. Created custom classes which can easily be integrated into any application. Tools used are VB .NET and SQL server as the backend database.
• Designed VB 6.0 with SQL Server as the backend database application that manages current client’s projects and their financials.
• Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization).
• Performed business and system analysis, designed application and database structure, converted existing data into SQL Server using Data Transformation Services (DTS) and VBScript.
• SQL Server Database Administration, backup functions. SQL Server CDO and CDONTS.
• Currently working on the development of custom controls which will be used in mainly ASP .NET applications. These controls inherit some functionality from existing controls and are customized to fit the requirements.

Confidential

Information Technology Department Manager

Responsibilities:

• Designed and developed Black Listed customer web application. This application uses VB .NET as front end and retrieves data from an Oracle 8i database. This application enables users to verify all internal and international SWIFT transfers before executing the message.
• Designed database diagrams, relations, applications automation and work flow using VISIO and imported it them to an Oracle and SQL server databases.
• Developed a customer management system using ASP .NET and Oracle and SQL Server as the backend database.
• Direct all Information Technology Department activities including strategic technology planning, purchasing, budgeting, inventory, security, documentation, policy and procedure verification, website implementation and development and user control considerations. Supporting 250 users at 8 branches with oracle8i database running on SCO/UNIX server at the head office. Provide documentation for software/hardware fixes. Ensure all IT procedures and policies are in compliance with bank's policies.
• Oversees day-to-day operations, reviews departmental performance and operating reports, resolves operational and service delivery problems to ensure minimum costs.
• Manage and oversees major applications development using Oracle ensuring all projects were properly planned and executed within set time constraints.
• Analyze and solve problems of the different software systems and provide technical support to branches across the country.
• Develop and follow-up of proposals and contract negotiations related to hardware or software systems.
• Worked on the implementation of new banking services which includes phone, SMS and internet banking using top technologies (ASP .NET, SQL Server and Oracle 10g).
• Major projects involved in managing and implementing of real-time ATM, EFT/Point Of Sale switching network, utility bill payment and e-voucher services. Technologies used Oracle 9i database and application server.
• Managed and implemented a disaster recovery solution to the banking core system based on oracle8i stand alone database solution.
• Reconfigured WAN, installed active directory, moved website to hosted facility, brought email server in-house with MS Exchange Server, and completely reconfigured main wire closet and server room in an effort to minimize use of unnecessary servers/hardware and provide security without compromising functionality.

Confidential, New York, N.Y

Senior Programmer/Analyst - Team Lead

Responsibilities:

• Designed and developed campaign emailing application. Technology used ASP, SQL Server and SMTP server for handling emails.
• Implemented and developed VB 6.0 time management and user entry application. Was responsible for application and database in SQL server developments.
• Managed and developed the modeling of Management and Scheduling Application. Responsibility included collecting user's requirements, creating a business model in VISIO and creating a prototype in MS-ACCESS 2000 including developing the database model and snapshot screens.
• Managed, designed and developed Management/Communications application. This web-based application was developed for high managers to control the flow of operations within the company, managing clients and their projects. The application was developed using ASP, HTML, JavaScript, VBScript and SQL Server as the backend database.
• Designed and developed a game show web application for a potential client used as a marketing strategy tool using ASP, HTML, JavaScript and SQL Server as the backend database.

Confidential, New York, N.Y

Senior Programmer/Analyst / Consultant

Responsibilities:

• Collaborated in the development of Hedge Fund Reporting web application. The application was developed using VB and ASP .NET accessing MS SQL Server 2000. Reports were developed using ScriptX ActiveX.

Confidential, New York, N.Y

Senior Programmer/Analyst/ Consultant

Responsibilities:

• Created EXCELL spread sheets which analyze data downloaded from the mainframe. These sheets consist of macros, computation formulas and VB script.
• Responsible for the enhancement of a VB 5.0 financial transactions monitoring system. This system was built on 3-tire with VB as the presentation and business tire and SQL Server as the backend database.
• Designed and developed a web reporting tool called Account Review System which allows portfolio managers to review all transactions they have performed for their clients making sure all securities they have bought or sold have the correct quintile rating at the time the transaction was performed. The technologies used were Active Server Pages as the front end and MS Access as the backend database.
• Developed a prototype web based trading application for the Private Investment Unit. This prototype permits portfolio managers to view accounts they manage and execute trading transactions based on their client’s requirements. Active Server Pages was the front end and Sybase was the backend database. Also, Remote Scripting was used on the server side to refresh users’ screens.

Confidential, New York, N.Y

Senior Programmer/Analyst - Project Lead

Responsibilities:

• Oversee and manage the development and deployment processes for web based IIS log analysis applications. This application allows web server administrator to view all web server hits and generates summary report. The technologies used were Active Server Pages and MS SQL Server 2000 as the backend database.
• Designed and developed a custom (404.asp) page for the developer support group web site. This page should detect broken links and check SQL Server table to lookup the correct link associated with it then redirect to the new link. Otherwise it will add a new entry to the table and inform the web site administrators with the broken link.
• Developed a DHTML WEB project using VB Script and Java Script that allow users to browse through all returned records, delete, update and add new records. This application accesses the mainframe to get data and display it in appropriate format on a web page. The mainframe access was done using an in-house middlewareActiveX component. It also uses another component that manipulates the data returned from the mainframe and format it according to the parameters based to it.
• Designed and developed a web based application that allows developers to submit their applications from the development to user testing stage. VB 6.0 Web Classes was used to generate HTML pages and MS Transaction Server was used to host all components used in this application. It also logs all activities to MS SQL Server 7.0 for tracking procedures.
• Developed different ActiveX DLL components in VB that can be used by other developer within the company. Some of these are INI file access, files zipping, e-mail send, and Servers Connection components.
• Designed and implemented a developer notification system for the Information Systems Department. The front end is developed in VB 6.0 and the backend database was created in MS SQL Server 7.0 that gets accessed throughVB using ADO 2.0 database engine. This system is scheduled daily in order to send e-mails notifications to developers throughout the company. E-mail is generated using SMTP e-mail process.
• Provided technical support to other developers throughout the company. Support includes VB, DHTML and other databases technical problems. Also installed and maintained Windows NT Servers and workstations including IIS and MTS Servers.
• Enhanced and created new features to Cab files download component. This component was created in VB 5.0 and it's been used by web applications to download required cab files to run the application. It also logs messages to SQL Server database for enhancement and tracking abilities.
• Developed an intranet application for files transfers between novel servers using VB, html/Dhtml and VbScript.
• Wrote and maintained functional and technical documentation on the web. Also, added a web search capability for the developer support intranet web using MS Site Search Server 3.0 and MS Index Server.

Confidential, New York, N.Y

Programmer/Analyst

Responsibilities:

• Designed and developed a stand-alone application in VB 5.0 called Exceptions System for Unit Investment Trust. This system allows users to perform searching and sorting exceptions transactions from two different data sources and exporting data from the current grid to Excel. It also reduces the manual work for doing Exceptions Transactions by allowing users to claim, approve and fix these transactions. It generates a list of reports which have been created in Crystal Reports. The front end was developed in VB 5.0 and the underlain database was MS SQL-Server 6.5. The database design and normalization was implemented in Visio Designer and RDO engine was used to access the database by running stored procedures at the server side. The system also was responsible for a daily download and update to the database and then uploading data back to the mainframe at the end of the business day.
• Maintained and enhanced an Excel Spread Sheet which for stock market quotes. VBA and Access technologies used.
• Designed and implemented an Overdraft intranet application using Active Server Pages for server side processing and HTML for generating a page layout. This application allows users to select and enter different criteria to get a list of overdraft accounts formatted in a table layout. Then, users can update and delete these accounts and export the resulted table to MS Excel spread sheet. The system access MS SQL-Server database that gets updated daily using MS SQL-Server Scheduler.
• Created Web Reporting tool using Crystal Web Reports. This tool allows users to view dynamically created reports from their internet browser. These reports access MS SQL-Server database by running stored procedures which accepts passed parameters from web pages.
• Converted and enhanced an MS Access 2.0 database application to MS Access 95 database. This system imports and updates Access tables and allows users to view, update and delete Merrill Lynch pricing data at the end of the day in a form layout. It also generated Access reports and some text files.
• Developed and designed an intranet application ( Corporate Action Pricing) on IIS Server. This application consists of active server pages that allow users to browse, query, and update corporate action pricing data at daily basis using MS SQL-Server as the database back end server.
• Administered and supported MS SQL-Server 6.5 by designing databases, running scheduled tasks, managing user's logins and backing up databases.

Confidential, New Jersey

Programmer/Analyst/ Consultant

Responsibilities:

• Designed and implemented a database system for Account Transfer and Recruiting Services using VB 4.0. The system was responsible for keeping track of all new coming brokers to the firm and transfer their accounts. The system allows users to perform update, delete, searching and sorting based on their selected criteria. It also generates reports using Crystal Reports; some of these reports are summary and some are based on user's selection. The front end was developed in VB 5.0 and the back end was created on MS SQL-Server which gets accessed using Jet database Engine. It was scheduled to run on an NT server for a daily download from mainframe and then update SQL tables.
• Converted a system developed in Paradox 4.0 to MS Access/VBA database. The system generates monthly and quarterly reports for different departments. It downloads data every moth and import it into Access tables. Then, it summarizes and manipulates data to produce different reports.

Confidential, New York, N.Y

Programmer/Analyst

Responsibilities:

• Collaborated in the development of a Prosecution Information Network system. The front end was designed in VB 4.0 and the underlain database was MS SQL-Server. This system automates the process of presenting defendants to the court in less than 24-hours. It browses, updates, and filters all information from SQL tables. It also generates complaint sheets and some other forms by integrating WordPerfect and Visual Basic. The system was also integrated with PROSHARE to allow application and document sharing between District Attorneys in their offices and police officers in their precinct.
• Designed and developed a database conversion system. This system updates dBase database by reading records from SQL-Server and converting these records fields format to a dBase format by using CodeBase Engine for accessing and updating dBase tables.
• Implemented a text file tool which reads data from a text file and then convert and write data to SQL tables. The tool is scheduled on NT Server to run 24 hour.

Confidential, New York, N.Y

Programmer/Analyst

Responsibilities:

• Designed and developed a Time Keeper System. This system keeps track of all employees' working, vacations, and sickness hours and modifying the database. It also generates a comprehensive and criteriation reports. The front end was developed in Visual Basic 4.0 and MS Access as the backend database.
• Engaged in the development of a vertical solution business accounting system. The front and back ends were developed under MS Access environment. The system manages A/R, A/P of customers besides managing customers, orders, quotes, and reports. It also implements searching techniques and (Primary and Secondary) sorting.
• Involved in the development of an Account Management and Scheduling System called Pursuit//Net. The front end was developed in VB 4.0 which accesses MS Access database. The system interfaces with the web and gathers marketing information for potential customers browsing web site. It is used in conjunction with a product called Spyder//Web web browser which collects not only an e-mail address when visitors visit a site of a client, but also a host of marketing information. It also sends and receives E-mail to and from the firm's representatives.