Sql Server Project

Mohamed Elsaawy

Email: *********@*****.***

www.linkedin.com/pub/mohamed-elsaawy/5/a28/357/

IT Software Developer / Production Support / Project Leader

Solid web-based and client-server systems experience. 15+ years of experience in analyzing business needs, designing, developing, delivering and maintaining on-target software solutions, production support and building/nurturing customer relationships. US citizen with excellent communication and interpersonal skills. Highly analytical with proven track record of leadership and mentoring others.

TECHNICAL EXPERTISE

Platforms: Web, Client Server, IBM PC, IBM Mainframe

Software: MS Office, VB 5 & 6, .NET, VB.NET, C#, ASP, JSP, HTML, VBScript, JavaScript, Java, JDK, C, C++, Oracle, PL/SQL, MS SQL Server, SYBASE, UDB, IIS, Crystal Reports, Cognos BI Suite, OS/MVS, COBOL, CICS, VSAM, JCL.

PROFESSIONAL EXPERIENCE

UPS SUPPLY CHAIN SOLUTIONS - ALPHARETTA, GA 09/2013-05/2017

Application Developer (C#, .NET, XML)

Main contact in the Contract logistics Integrated Output system document management system. It provides standardized, configurable, scalable and centralized Document Generation and Delivery from multiple platforms and route them through to fulfillment.

Provide full systems life cycle support for Document management system for

Creates technical documentation to communicate and update project teams and stakeholders.

Monitors Production Servers Services and Queues for bottle necks

Provide support and trouble-shoot production support issues to internal and external clients

Designed C# utility to pull financial data from multiple sources and ETL to SQL server, maintaining and enhancing a huge library of T-SQL scripts and procedures.

Upgraded and Optimized the code to the newer .Net framework 4.5

Communicates and documents unit test results and code revisions to ensure consistency and accuracy.

Environment: C#, .NET, ASP.NET, XML, Oracle, SQL Server, T-SQL

NCR CORPORATION - DULUTH, GA 01/2010 – 03/2013

Global Technology Company and leader in automated teller machines, self-checkouts and self- and assisted-service solutions -software, hardware, consulting and support services.

Technical Consultant II/ Senior Developer

Designed, constructed, integrated, unit tests; provided trouble-shooting and supported software solutions in a variety of customer-facing and internal business scenarios, associated with NCR s ATMs software.

Developed $1.5MM project to migrate major ATM management software to next generation ATM management software utilizing C#.

Interfaced with External and internal business Customers to Perform functional, business and operational analysis of requirements.

Developed code changes and test activities for complicated ATM software including Aptra Edge, Activate VB, C#, JavaScripts.

Worked on change requests for software development and project plans to External customers and senior management.

Worked with large switch networks (VISA, Fidelity, and Jack Henry) and Banks (Wachovia, BoA, TD Bank) to customize ATM applications, ad campaigns and unique features.

Wrote T-SQL procedures and complicated queries and ad-hoc reports to capture statistics and performance data.

Generated the requirements for ATM application’s change requests, developed and delivered the necessary code changes.

Environment: VB6, C#, JavaScripts, C++, SQL Server, T-SQL

ASCAP - NYC, NY 09/2006-10/2009

World’s largest clearinghouse for music performance royalties, with 1 Billion Dollars annual revenue.

Project Analyst / Senior Developer

Senior Developer in a Production support for a multi-platform data processing; PCH (Publishing Clearing House) Systems that processed detailed transactions of licensed TV network, local and cable broadcasts programming and corresponding music content for distribution of performance royalties nationwide.

Developed, monitored, diagnosed, maintained and supported daily, online and batch activities of data manipulation, ad-hoc queries, reports, extract and requests for enhancements.

Redeveloped SYBASE database objects and procedures for optimization and performance resulting in significant improvements in nightly and weekend batch processes and reports (more than 50%)

Implemented sophisticated data archival routines that greatly reduced table sizes resulting in huge online and batch performance utilizing advanced aspects of T-SQL.

Developed cutting edge solutions for critical users’ problems, utilizing UNIX Scripts, Sybase, MS SQL Server, T-SQL, Oracle PL/SQL, Crystal Reports, MS Access, C# and VB.NET applications throughout all stages of project Life-Cycle

Rewrote Sybase objects (Stored procedures, functions, views.. ) into MS SQL Server T-SQL objects to facilitate migration from Sybase to MS SQL Server.

Coordinated and collaborated with product management, development, Technical Operations, and business segments to meet quarterly Enterprise-wide deliverables.

Created, coordinated and executed an extensive UAT, Deployment project plans for interfaces to Enterprise-wide reengineering project that replaced Legacy mainframe systems.

Was selected and participated in an organization’s intensive, hands on 1 year Emerging Leaders Program.

Re-developed VB6 applications to VB.Net and C#. Utilizing Managed components, threading and .NET data providers.

Documented all processes and workflow.

Environment: UNIX, Sybase, MS SQL Server, Oracle, Crystal Reports, MS Access, C# and VB.NET

INDEPENDENT CONSULTANT 10/2005-09/2006

Castle CRM, A provider of Customer Relationship Management SalesLogix solutions.

Customized and Upgraded older versions of SalexLogix modules to client’s specifications.

Wrote .Net application to extend SalesLogix functionalities

SI Paradigm, A full Diagnostic Informatics Pathology Laboratory specialized in providing personalized and quality total services from specimen submission to billing.

Integrated website to remotely access and manipulate cytogenetics results using a central flow cytometry engine and added functionalities to retrieve and archive reports.

Enhanced the billing module for report creation and CPT & ICD-9 codes verification. (.NET)

Non Profit Organization

Designed and wrote .NET & web-based Event Management system to manage conferences registrations, payments and volunteer’s information. (.NET, C#, MS Access 2003)

Environment: VB6, C#, .NET, MS SQL Server, MS Access, SalesLogix

MINDTREE CONSULTING – SOMERSET, NJ 2004-2005

A $70MMCMMi and P-CMM level 5 consulting firm that offers IT services to large enterprises, providing end-to-end project execution onshore, offshore, or in a hybrid delivery model.

Technical Team Lead / Senior Developer

Client: AIG. System: DMS an Underwriting System responsible for issuing policies, capturing deal data and documenting binder and legal documents.

Led a team of 4 onshore and 3 offshore developers to transition the system from another vendor.

Planned and tracked the execution of the Transition plans according to MT Application Transition Knowledge Transfer Methodology using MS Project.

Led and structured the domain, architecture, technical and business knowledge acquisition from out-sourced vendor and AIG staff.

Provided technical support and guidance to team members.

Developed, maintained, enhanced VB6 and MS SQL (DDL and MDL) modules.

Improved, streamlined and minimized manual production support procedures.

Delivered well received documentation and artifacts required by the transition plan (e.g. Application handbook, acceptance procedure, service delivery templates)

Environment: VB6, MS SQL Server.

INDEPENDENT CONSULTANT – NY/NJ 2002-2004

Provided technical and business needs analysis and solution design services to: Vertek Corp, Creative Web Inc, Stratigic Step, Haledon Citgo, Crescent Computers, PC Tech and Jackson Hewitt.

Built and maintained various shopping cart Internet sites using customizable third party shopping cart tools. Setup and fine-tuned IIS server. Sample sites worked on: www.yourgrape.com, www.trainsandmore.com (HTML, ASP, VBScript, JavaScript, SQL Server 2000, IIS, ProductCart and Oracle)

Enhanced a Telecom web-based sales and “Time On Task” applications for Telecom services. Worked on all aspects of PL/SQL and Oracle. Maintained and configure IIS server. (HTML, ASP, VBScript, JavaScript, Java 2, JDK, Oracle, Jbuilder, IIS and Oracle)

Designed web sites for non-profit organizations and small business utilizing HTML, DHTML, ASP, IIS and JavaScript.

Designed several VB6 and MS Access applications.

Environment: HTML, ASP, VBScript, JavaScript, Java, JDK, Oracle, Jbuilder, IIS and Oracle

VERTEK CORPORATION – Murray Hill, NJ 1999-2002

A $30MM professional services firm providing consulting services and solutions to the telecommunications industry and multinational companies.

Technical Team Leader, Senior Programmer/Analyst

Developed, enhanced and maintained several large web-based order entry, workflow, provisioning, order status, project status and capacity analysis applications for AT&T. (ASP, VBScript, JavaScript, HTML, VB 6.0, IIS, Java 2, JDK, C++, Oracle 8.05 PL/SQL, Jbuilder 6 and Jrun)

Designed, developed and supported an OLTP Database system for Worldcom using COGNOS (Cognos BI -PowerPlay, Architect, Impromptu, Query, KPI, Script Editor- and PL/SQL)

Mentored/trained junior team members. Coordinated resources, assigned work, directed and appraised developers.

Produced business, functional and technical specifications Documentation.

Environment: ASP, VBScript, JavaScript, HTML, VB 6.0, IIS, Java 2, JDK, C++, Oracle 8.05 PL/SQL, Jbuilder 6, JRUN, Cognos BI -PowerPlay, Architect, Impromptu, Query, KPI, Script Editor- and PL/SQL.

BANKERS TRUST CORPORATION – Jersey City, NJ 1993-1998

Senior Programmer/Analyst

Led team in migration of “International Trading System” to thin-client architecture utilizing Java as the front end. Converted the database from older versions of Sybase to Microsoft SQL server 6.5 and rewrote DDL and MDL as required. (Java, Visual Café, SQL Server)

Created and developed “International Trader Workstation”, portfolio evaluation system (“Mark to Market”) and “Account Tracking System”. Performed full project life cycle development including user interface, requirement analysis, system design, programming, and database design and fine-tuning. (VB, C, MS SQL server)

SWISS Bank Corporation – NYC, NY 1989-1993

Senior Programmer/Analyst

Designed and developed GUI client/server applications for the Global Assets Division. Applications programmed in Visual Basic, C, MS Access and MS and Sybase SQL servers utilizing the MS Windows NT and DBLib API engines which linked most of the bank's mainframe trading systems to a client’s global position sheet.

As a project Leader, designed functional and program specifications for the Global Position Sheet, which dynamically displayed clients' limits, exposure, custody information, positions of affiliates/subsidiaries and summary pages with zoom in functionality.

EDUCATION

MS, Computer Science, Pace University

BS, Accounting, Alexandria University

Diploma in Computer Programming, Chubb Institute

Contact this candidate