Sql Server Visual Basic

Shoukry Malaty

**** *. **** ******

Franklin, WI 53132

414-***-**** home

414-***-**** cell

***********@*******.***

U. S. Citizen

SUMMARY

Over 10 years of experience in the IT industry with Object -Oriented Analysis, Design and Development.

Proficient in developing applications using Java, .NET Framework(VB, ASP, C#), WCF, SQL Server, Oracle, JavaScript/JQuery.

Exposed to web development with emphasis on all stages of System Development Life Cycle (SDLC).

Exhaustive experience in developing Mission Critical applications using Component technologies .NET, XML, Oracle, Sybase and SQL Server.

Strong Experience in Designing User Interface using HTML5, CSS3 and Java Script/JQuery.

Good aptitude, Communication and Interpersonal skills.

Willingness and Exceptional ability to quickly master new concepts and applications.

Experience using configuration Management Tools such as Visual Source Safe (VSS), and Sub Version (SVN) for version control.

A dedicated professional who generously shares my knowledge to mentor others.

Areas of Expertise

SKILLS

.Net framework 4.5

Visual Studio 2012

Asp.net

C#.net

VB.Net

WCF

Java Script

VB Script

HTML5

Bootstrap

SVN

CVS

SQL Server 2008

SQL Server Studio 2008

Transact-SQL

Oracle 11g

TOAD

ADO

XML

DTD

MS Access

Java JDK

JDBC

ADDITIONAL SKILLS

Oracle WebCenter Content Management 11g

Windows

COBOL/COBOLII

UNIX

Fortran

Rexx

Crystal Reports

AWK

MS Office

BCP

CERTIFICATIONS

Sun Microsystems Certified Web Components Developer for the Java J2EE Platform.

Sun Microsystems Certified Java Programmer.

Microsoft Certified Business Solutions Developer

Windows Architecture II, ODBC, MAPI, SQL

Microsoft Certified Product Specialist

Windows Architecture, OLE, MS Visual Basic, MS Access

Professional Experience

WE Energies Milwaukee, WI March 2007 – Jan 2016

Sr. IT Application Consultant

GPS Trimble Repository Web

Supporting and maintaining GPS Web application written in JavaScript, Jquery, Ajax, Json, Bootstrap, and C# ASP.Net. The application maintains project for GPS Trimble handheld Surveying, GIS, and imaging solutions that facilitate data collection, asset management, processing, modeling, and analysis for utility mapping, operations, and management

Sysprot Replacement Project (Project Manager, developer):

Sysprot project is a replacement of old software “Sysprot” that is not combatable with Windows 7. Sysprot is replaced by Aspen software.

I created mobile application on laptops called Briefcase. The briefcase enables a user to take a subset of the data on his or her laptop and work off-line.

It allows relay testers to extract a mobile copy of the database and simultaneously multi-user synchronization of completed work from the field.

I helped others with their applications development work and testing of the developed applications. I have worked from home to meet a deadline and support clients without being asked to do that. I volunteered in much additional work when it is needed.

I became a primary support for Aspen applications and software. I did a demo for business unit and IT member on the software. I’m also the primary contact with Aspen vendor installing/updating the software and solving problems reported by business unit.

Service Record Card (SRCtoStorms) project:

Created Web application using ASP.NET to generate Work Request in STORMS from Service Record Card (SRC). The system maintains an existing application to access Service Record Card information in SQL server database and generate work request in STORMS in Oracle database. The system also access GIS server to get x, y coordinate (longitude and latitude).

Data Collection Maintenance (DCF Viewer) project:

Created Web application using ASP.NET to collect gas information from the field about meter, service, regulator, piping, survey, sketch, the system access Oracle database.

Field Automation Project (FAP) project:

Created Web Services applications using SOAP written in VB.NET that generate xml to create jobs in CAD (Inbound messages) and also receiving xml from CAD to update STORMS database. The system create/cancel jobs in CAD, assign crews, and also update assign crews in STROMS from CAD or update work request from CAD (Outbound).

Database Development in SQL Server and Oracle:

Create/maintain relational database tables (third normal form).

Create/maintain stored procedures/functions.

Create/maintain triggers.

Access/retrieve/update database from C#, /ASP.net/vb.net.

Create complex SQL queries.

Provide Operational Support, including:

Complete on Call assignments rotation 24/7, and respond to all pages within target response window. Provide appropriate client and service level communication, and escalation for emergent issues. Develop On Call documentation and/or Knowledge Base articles. Meet SLA availability and reliability targets.

Support Oracle WebCenter Content Management 11g.

Support utility vendor third party software: Madgetch, Doble, Cascade, Aspen, DV-WIN, and Spatial Risk Analyst.

State of Wisconsin – Supreme Court Madison, WI May 2004 – February 2007

Software Engineer

Developed, analyzed, designed, coded, tested, and implemented application for Wisconsin Courts called Consolidated Court Automation Programs (CCAP). CCAP is responsible for supporting the IT needs of the entire Wisconsin Court System.

Build and deploy application daily on Wisconsin county and Supreme Court.

Application technical support:

Debugging and troubleshooting problems reported by the Help Desk.

Metavante, Milwaukee, WI May 2003 – December 2003

Consultant by: Stratagem, Inc

Involved in analysis, design, development and implementation stages of create new banking account for Capital One.

Worked with Metavante’s custom framework which provides Custom tags, Exception and Error Handling, Message and Transaction Processing and Data Base Access etc

Designed and Developed the presentation layer using JSP,HTML and Java Script.

Used Jbuilder as IDE and Application is deployed on Websphere App Server

Used Oracle as Database.

Used Harvest as Source Control tool.

Consultant by: Stratagem, Inc

Maintained and created new Java components for Long Island Railroad Ticketing System. The application is Java 2 Enterprise Edition (J2EE) compliant, it runs on IBM Websphere. The system is used for:

Online New Account Setup.

Personal Cash Management (PCM).

Forgotten Password System.

Bill Payment Support.

Long Island Railroad Ticketing System.

Environment: JSP, XML, Servlet, IBM DB2 database, JBuilder, Havest.

Bank of New York Clearing Service (BNYCS) Milwaukee, WI June 2000 – May 2003

Sr. Programmer/Analyst

Developed, analyzed, designed, coded, tested, and implemented trading system for BNY. The main function is stock exchange.

Responsibilities:

As a team-member, responsible for creating BNYCS API, a system of distributed, Java-based processes moving messages in XML format between correspondent clients and Beta (mainframe), while applying business rules/validations. Messages are divided into two types: Requests, which go to Beta, and Responses, which come from Beta. Responses are further divided into Synchronous (immediate) and Asynchronous (delayed). The system’s processes are Java-based and spread across multiple servers utilizing Java's Remote Method Invocation (RMI).

Converted the system to Weblogic 6.1 using J2EE: JMS, MDB, and Java Servlet. The project is to provide a uniform means of interacting with BNY Clearing Services for the function of querying, maintaining, and executing account and security transactions. The goals for the project are: uniform access to business-to-business services, support increased transactional volume, and scale business-to-business services to the Internet. The system is configured to use ANT as its build tool and Junit as unit, integration, and system test. Ant is used to compile and package (JAR, EAR, WAR, etc) builds. The CVS repository is used to host at BNY Clearing Services on a Windows NT server.

Developed a Java Applet for the Online Breaks System (OLBS) using Swing components, a web-based application firms use to view and resolve breaks on a daily basis. The enhancement improved the system to notify firms of their exposure more efficiently.

Application technical support:

Debugging and troubleshooting problems reported by the Help Desk.

SQL Server is used as back end.

Environment: Java, Apache software (ANT, Log4j, Struts), Together Control Center, JBuilder, SQL Server, DTD, XML, DOM, SAX, XSLT, Junit, UML, MQ Series, Swings, JDBC, CVS, Visual Source Safe

Keller Graduate School, Milwaukee, WI September 2001 – June 2002

Java Instructor

Taught graduate students Java 2 for two semesters.

Marquette University, Milwaukee WI September 1997 – August 1999

Consultant/ Sr. Programmer Analyst

Taught undergraduate and graduate students on computer programming languages including COBOL and Visual Basic, and a database management

Renaissance, Inc., Milwaukee, WI May 1999 – June 2000

Consultant

Various Consulting Assignments using Visual Basic, Access, SQL Server, Sybase, Oracle.

Designed a web site using ASP, VB Script, VB to create DLL, and using ADO to return a record set from MS Access using DLL.

Assigned to: GE Medical System – IS Engineering Department

Milwaukee, WI 2/00 – 6/00

Software Developer / Consultant

Developed a web application with a search engine to display information stored in an Oracle database on the Internet.

Displays row Oracle data depending on search criteria

Calculates yields of different products and displays a summary

Displays a yield chart

Environment: ASP, Java Script, VB Script, MS Remote Scripting, ChartFX software

Assigned to: Northwestern Mutual Life Ins. Co., Milwaukee, WI 5/99 – 12/99

Software Developer / Consultant

Developed, designed, coded, tested, and implemented business applications using Visual Basic and Sybase with stored procedures in the following applications:

oInvestment consolidation: to allow online updating and insertion of new investments.

oProblem Loans: determine delinquent and foreclosure loans.

oFolder Management Systems: maintained the existing system to improve performance and response time by adding new functionality.

Created reports using Business Objects and Crystal Reports.

Environment: Visual Basic, Sybase, Business Objects, and Crystal Reports

Omni Resources, Inc. Brookfield, WI March 1995 – May 1999

Consultant/ Sr. Programmer Analyst

Various Consulting Assignments using Visual Basic, Access, SQL Server.

Designed a web site using ASP, VB Script, VB to create DLL, and using ADO to return a record set from MS Access using DLL.

Assigned to: William Mercer, Inc. Deerfield IL 7/98 – 12/98

Consultant Sr. Programmer Analyst

Developed an interactive voice response system “open enrollment” enabling employees to enroll for insurance benefits over the phone using Visual Basic with a SQL Server backend with the following features:

oCreated stored procedures, created tables, on-line queries, system utilities and tables.

oSecurity to verify SSN and PIN

oEnrollment selection of benefit from menu using touch tone phone

oRetrieval of current year and/or new enrollment insurance and summary.

oUpdates allowing employee to add, delete, change benefits, and add/delete dependents.

oExtracts updated enrollment and sent to the client via updated touch-tone log file.

Created and maintained ActiveX DLL, ActiveX EXE, and EXE programs.

Transferred text files to SQL server using Block Copy Program (BCP).

Environment: Visual Basic, SQL Server, Rexx, Awk.

Assigned to: Bluecross/Blueshield, Milwaukee, WI 4/98 – 6/98

Consultant Sr. Programmer Analyst

Developed, analyzed, designed, coded, tested, and implemented database for providers and payers of Bluecross/Blueshield hospitals. The system was developed in Visual Basic and the back end was in MS Access Database using ADO.

Created ActiveX DLL for editing and validation.

Created simple User Document and installed on Internet browser.

Environment: Visual Basic, MS Access

Assigned to: Aldrich Chemical, Milwaukee, WI 7/97 – 3/98

Consultant Sr. Programmer Analyst

Analyzed, designed, coded, tested and implemented business applications.

Maintained and added modules in to a Visual Basic application through ODBC to a DB2 mainframe back end.

Maintained and created new databases using MS Access for Accounts Payable department.

Created new databases for Regulation, Purchasing and Engineering departments using MS Access.

Environment: Visual Basic, MS Access.

Assigned to: Johnson Wax, Racine, WI 4/95 - 6/97

Consultant Sr. Programmer Analyst

Analyzed, designed, developed, tested and implemented a circuit application for Telecommunications and Financial departments using MS Access. System included MS Access Security for the LAN, on-line help, OLE and a backup program written in Visual Basic.

Developed a new Search Engine and a new database for Data Acquisition, which became the standard for the RD&E department.

Developed new Electronic Forms, which were sent between different departments for acceptance or rejection. If rejected, it would return to the specific user who sent it; if accepted, it would update the database automatically. Electronic Forms became standard in the RD&E department.

Developed an Internet application to create an index table containing hyper-text to reference HTML documents and created bookmarks to jump to specific portions in the documents.

Environment: Visual Basic, MS Access.

MAI System, Irvine, CA October 1993 – December 1994

Senior Programmer/Sr. Programmer Analyst

Mai Systems, Corp. MAI System, Irvine, CA 10/93 – 12/94

Maintained and supported modules to handle Accounts Receivable, General Ledger, Inventory, Order Entry, and Manufacturing. The system included user-friendly graphical interfaces written in Business Basic using Ps Forms (GUI).

Designed and implemented conversion programs to convert data files from Minicomputer (MAI Basic Four) to a LAN based database, Platinum, using Btrieve.

Designed GUI based applications using Access Basic Customer Services, Order Entry, and Telemarketing.

Environment: Visual Basic, MS Access, Business Basic.

Tadashi, Inc., Los Angeles, CA May 1989 – March 1993

Senior Programmer/Sr. Programmer Analyst

Created and implemented the company's new Management Information System. The system was recognized for its superior design and user-friendliness. Increased user productivity by 30%.

Environment: Business Basic.

Education

Florida Institute of Technology, Melbourne, FL

Master of Science, Computer Science

Ain Shams University, Cairo, Egypt

Bachelors of Science, Mathematical Statistics

Contact this candidate