Title: Senior .NET / SQL Developer / Data Analyst.

Objective:

With over 22 years since 1993 in software development and coding. I am pursuing an opportunity to utilize those areas of expertise in a challenging and productive environment.

Summary:

Experience in Develop / Design / Test / Analyze / Reverse-Engineer / Collect Business Requirements / Deploy / Maintain / Support of Software / Database Front-end / Back-end / Client-Server / Multi-Tier Application using full Object-Oriented-Programming style for Desktop / Web Applications to Manipulate Data using Algorithms in RDBMS environment for both OLTP OLAP with ability to migrate data from old system to new system with optimization in time cost and with backup strategies.

Plus knowledge of :

• Solving complex problems using Algorithms / Simulations / Image Processing / Encryption
• Networking and TCP / IP protocols.
• Some Graduate level of Advanced Mathematics/Statistics Subjects after mapping it to the USA Curriculum .
• Complete Curriculum of Graduate level of Strategic Management And Leadership UK Curriculum / Edexcel University .
• Astronomy-science / Physics simulations its applications.
• Advance 3D processes Multi-Dimensions / Metrics / Rotation / Shifting / Scaling .. etc. .
• GIS application and principles ArcGIS / 2D-Mapping / Graphics Images .
• How to get the necessary information from Internet research.
• Experience in teaching and leading other co-workers.
• Video games / movies / music.
• Good communication and soft-skills in a multi-cultural environment, patient, diplomatic, organized, creative, and willing to learn more things, and like to have more friends, Fluent in Arabic language.

Technical Skills:

Table indicates the skill name with years of experience and the last time I have use it :

Also:

• Advanced-Level of Mathematic subjects including: differential equations, probability theory, operational research, numerical analysis, metric and topological spaces, linear algebra, field theory, mathematical logic, number theory, topics in logic and foundations, complexity in computer algebra .
• Complete Curriculum of Graduate level of Strategic Management And Leadership , Includes: Creative And Innovative Management, Strategic Human Resource Management, Strategic Marketing Management, Strategic Quality And Systems Management, Professional Development For Strategic Managers, Developing Corporate Culture, Developing Strategic Management and Leadership, Project Development And Implementation For Strategic Managers, Corporate Communication Strategic, Strategic Change Management, Supply Chain Management and Logistics.

Professional Work Experience:

Confidential

Responsibilities:

Design / Execute complex SQL queries.

• Understand in depth- the structure of the Database 105 Tables so I can provide advice to the Business unit co-workers on how to design their queries for their reports.
• Report bugs to the IT department so they can fix them.
• Testing Algorithms and verify results
• Provide solutions to the business unit co-workers for the problems they face.
• Meet sharp deadlines by providing the reports they need

Data Analyst

Tuning SQL queries they are using for creating the reports:

All reports numbers must be in the expected range so it can be handed to the director of the company, and then handed to the leaders, we as a group of the Global Capacity Planning department handle numbers of Billions of USD of sales/forecasts/marketing, we as a department drives the plan of the company for the next 20 years from now

Confidential

Responsibilities:

• Using Telerik Controls for advanced functionality
• Using eConnect to communicate with Microsoft Dynamic GP Great Plains
• Using SQL-Stored Procedure/Functions in the combination with ADO.NET
• Using SQL-Triggers/Indexes/Constraints in Tables
• Design complex Database contains 80 tables with 140 relationships
• Dealing with Multiple Servers in a single SQL statement
• Design/Implement an Audit system to monitor the activity of each software
• Design/Implement an Error Tracking system to track internal error for each software
• Use SqlDataReader / SqlConnection / SqlCommand classes in the code
• Develop a DLL using VB.NET and calling it from SQL server on a schedule bases
• Normalize all the tables using NF1 / NF2 / NF3
• Using the Scrum as a SDLC
• Divide the Layers of the iBart software into 4 Layers: Data Access Layer, User Interface Layer, Business Logic Layer Lower , Business Logic Layer Higher
• Design an Auto-Code-Generator to generate all the Stored-Procedures / DAL / BLL-Lower codes in SQL and VB.NET Total 50,000 lines of code
• Design an Auto-Code-Generator to generate an WCF Windows communication foundation Code for DAL / BLL-Lower , Total 30,000 lines of code
• Use Parallel Programming to speed up the process specially networking connections
• Use LINQ to Objects / PLINQ to manipulate data in memory
• Use WCF Windows Communication Foundation to host Web-Services.
• Use TFS Team Foundation Server of Visual Studio to manage 3 coders working on the same project
• Use Generics to design some classes
• Use ASP.NET / HTML / CCS / Java / ADO.NET
• Maintain and support the old POS Point of Sale project using VB6 / CrystalReports
• Design a Data-Wherehouse database OLAP for reporting purposes

Roles:Software Design / Develop / Test / Analyze / Reverse-Engineer / Collect Business Requirements / Deploy / Maintain / Support Engineer

Design / Develop the new iBart Point-Of-Sale for 120 Branches/Franchises World-Wide using VB.NET / SQL :

Using Visio to design the database tables/fields/relationships/primary keys/foreign keys then export it as a SQL-script then run it on SQL-server to build the database, re-build/re-design the whole POS system from ground zero, from how to calculate the invoice to how to identify records in a universal way to how to protect the software to how to use merge replication to replicate the database to other dealers to how to move data from OLTP to OLAP for reporting purposes to how to partition the database to increase performance to how to setup a web service to work as a middle-point between the HQ and the dealer locations to how to make the .exe file more stabilized by making all rates configurable ..etc. , Migrate the data from the old system to the new system.

Design / Develop / Test Internal software using ASP.NET / VB.NET / SQL / ADO.NET:

In Between

Using eConnect API to connect VB.NET software to GP Microsoft Dynamic GP/Great Plains , to send and receive transactions/open accounts/issue bills/ .etc. , extract historical information about customers and export them into excel-spreadsheet, moving data from MS-Access Database to SQL Database to GP-Database to Excel-spreadsheet to Flat txt file to Platnium Database backward and forward , Design a system that can handle Gift Certificates starting from the purchasing time to printing time to the redeem time with all the output reports and taking care of the uniqueness of the serial number of the Gift Certificate after adding the watermark on it, Design a system to handle reminder cards, another system to rebuild the entire old POS database.

Reverse Engineer/Analysis old VB6 code for Confidential

Using Digital-ID for each PC which is a combination of the motherboard-ID CPU-ID Memory-ID Video Card-ID Hard Drive-ID to Identify which Software is Licensed to run on which PC, send the Finger Print for each PC to the FTP server, and re-send back the expiration date encrypted to the dealer, Reverse Engineer more than 10,000 Line of code in VB6 that do reporting/calculating/moving data, modify the old softwares to add a Debug feature that indicates when/where the error happened with a log file that indicates all the steps that has been executed.

I was attending 3 schools .

Confidential

Responsibilities:

• Develop solutions for the city of Detroit using ArcGIS software.
• Calculate the Length of Roads / Highways in the city of Detroit and report them using ArcGIS.
• Develop custom-design-macros to analyze the structure of data-file to pull out points-coordinates that represent world-map.
• Analyze the ArcGIS file-structure so it can be accessed by another softwares other than ArcGIS .
• Import Data from Excel Spreadsheets into MS-Access-Database.
• Creating Excel Templates as a bill , then fill it and convert it to .pdf file then email it to customers.
• Utilizing the Normalization Theory when Designing the Relational-Database NF1, NF2, NF3 .
• Going through the whole SDLC from gathering requirements stage to the deployment stage, and Provide all the documentations for every stage.
• Analyzing the performance of the Database and make some changes.
• Adding / Upgrading Computer-Parts Hardware .

Roles:Software Design / Develop / Test / Maintain / Support Engineer

Design / Develop Confidential

Imports Customers-accounts/customers-cell phone-usage-data from MS-Excel files and validate the integrity with the current data, then spread the data to appropriate tables so SQL statement can be executed on the data, then bills for each customer will be generated and convert them to .pdf files, then print them and/or email them to the customers, then generate monthly/annual reports of profits/usage/statistics .etc. , Client-Server structure with Login/Password permission for each user, with 9000 line of VBA/SQL code, debugging features within the code, run the software in 2 modes Release Mode / Debug Mode and generate Log files of all code activities optional , Un-Authorized copy protection features to prevent the software from running on un-authorized PC optional .

Use ArcGIS software Confidential

Using Satellite Images of the city of Detroit to analysis the city Roads / Highways / Traffic lights, Locations and coverage, Multi-Layering Maps, Providing Calculations and Results for Contractors

Confidential

Responsibilities:

• Study the science of Astronomy from scratch from zero in order to design astronomy application.
• Convert the Position of the Moon/Sun between deferent coordinate systems over the period : 100 years forward, and 100 years backward .
• Apply Formulas that has been used by teachers at NASA in the software.
• Use the Hard-Drive signature in the purpose for protection against un-authorized copy of a software.
• Create a 3D software that call functions from a 3D-game-Engine to simulate movements Rotating Shifting of a commercial video-clip .
• Simulate SQL statement on a plain Text file huge amount of data , because SQL-server , at that time, does not support this amount of records .
• Upgrade Computers to the New Windows OS with installation of newer versions of current softwares .
• Diagnose Computers and Fix the problems.
• Give Classes for Students in Math / SQL / C.

Roles:Software Design / Develop / Test / Analyze / Deploy / Maintain / Support Engineer:

Design Astronomy-Application Confidential

Calculating the position of the sun and the moon using hundreds of equations sin cos , the prototype version use Excel / VBA to do the job, the released version use VB.NET 2005/2008/2010, The Software produce World-Map images with Color Charts indicate Where and When the Crescent could be observed, the equations has been taken from Professional-Astronomical-Books, and the images is officially adopted world-wild, The software use Longitude / Latitude / DateTime as input, and give out the Azimuth / Altitude / Right Ascension / Declination / Julian Day / Dynamic Time / Obliquity Of The Ecliptic / Sidereal Time / Ecliptical Coordinates / Equatorial Coordinates / Atmospheric Refraction / Nutation / Aberration / Yellop Equation / illuminated Fraction of the Moon's Disk / Phases of the Moon.

Design Protection against un-authorize usage Confidential

By reading the signature of the hard drive, and embed it inside any software, this could make the software runnable on that particular hard drive only, this idea was used in this project for protection purposes

Design Small Video Clip which used for Advertising Purposes 3D Graphics

By using VB.NET 2005 the 3D-API-Game-Engine of PowerRender , a world of digits has been created in this video clip, this group of digits is creating the letter C , other group of digits are creating the letter o , the big-picture is creating the word Company , with all the 3D- Rotating / Shifting / Zooming of the Camera, this is something similar to the Visual-Effects of the known-Movie The Matrix .

Design Email List Management can handle 500 Million Records

Using C and the Fastest-Sorting-Program Postman-Sort , , this software has been created to manage a huge amount of email list it has been tested on 500 Million records which the filtration against remove lists has been done within 35 Minutes only on WinXP machine, with 512 MB RAM , no SQL statement has been used, all done using plain .txt files.

IT specialist:

Build Custom-Configuration Computers, PC Maintenance, Diagnostic skills, fixing Hardware / Software / Network problems.

Teaching Math SQL C :teaching a small groups of 6 to 12 students , starting from K-12 to 4th year of College in Math / SQL / C , total 6 classes, each class for 3 months

Confidential

Responsibilities:

• Test vFoxPro-ActiveDoc within Internet-Explorer-Browser.
• Writing Source-Code Examples in the Help section.
• Report bugs that has been found in vFoxPro
• Testing COM DCOM components
• Writing Automation Tests scripts and link it to MACE software.
• Writing DLL functions in C, and call them via FoxPro

Roles:Software Test Engineer

Confidential

As a Contractor Through Volt Computer Services .

Test with Internet Explorer Browser in Single/Client-Server environment , Test OLE Automation / COM / DCOM / OCX, writing test case scenarios Logical Coverage, Boundary Value analysis, Equivalence Partitioning, Random Generation, Error Guessing , White-Box, Black-Box, Unit-Testing, Integrated Testing Both top-down / down-top approach , Stub functions, Driver functions, Code-Review, Testing the code is covering Statements, Branch, Condition and compound condition, All Paths .

Confidential

Responsibilities:

• Create Applications that Provide Solutions for the Free-Trade-Zone Organization.
• Create Custom Encryption Algorithm/Software for protection of data.
• Design Large Algorithm/Software to handle How Containers Should be Placed in the Ship to maximize the load.
• Provide Training to the Customers after the software has been created.
• Installing Printers and Accessories to Customers.
• Troubleshoot Software Hardware Issues to customers over the phone.
• Design Logos for businesses custom-made .

Roles:Software Design / Develop / Test / Analyze / Collect Business Requirements / Deploy / Maintain / Support Engineer

Confidential

The Softwares will track the number of ships entered and exited , from and to the sea-port, using MS-Access and VBA / SQL, self-calling functions was used, password protected, Auto-Backup, Custom-Encryption-Algorithm used 10 Million Possibilities , photos for each record are supported, user friendly interface.

Confidential

Responsibilities:

• Create Software Solutions for Customers.
• Programming custom-made computers using assembler / C and link them to standard-PC using RS-232.
• Design algorithm/Software to analyze images to separate colors and to detect the edge of a graph.
• Design DLL to act like a middle-ware between Visual-Basic and assembly-code.
• Create Additional Magnetic-Tracks on Floppy-Disks to be used for protection against un-authorized copy-attempts.
• Design Physics-Algorithm/Software utilizing Newton's Low.
• Design Algorithms/Software to Simulate Rotation of a Building and how does it looks like in real life real eye .
• Help University-Students with their Graduation-Project.
• Build Computers and Network them based on Customer-Orders.
• Fixing Software Hardware Problems.

Roles:Software Design / Develop / Test / Analyze / Collect Business Requirements / Deploy / Maintain / Support Engineer:

Confidential

• using Borland-C and Assembly-Language embedded inside the C code , using the 32bit-Registers for maximum speed, also using the processor-cashe to improve performance, direct interactive with the graphic-card using IN / OUT assembly-statements, sending out to the printer port signals to control the image-electronic-board, custom-visual-effects on images at run-time including but not limited to rolling, shifting, zooming, refreshing signal must be sent out to prevent any image-fading on the electronic-board, display custom images as .BMP files .
• Design Software to Analysis Images for the Computers of Knitting-Machines Professional

Confidential

• Process Images .BMP files, using 24-bit color depth, Red-Green-Blue structure to separate colors from each other, Separate the Outlines-Curves of the Photo from the inside filling colors, then use the Outline-Curve images to be processed by the knitting-machine-computer, using C Language under windows 3.1 Platform, need large amount of RAM for max performance.
• Design Software to Program EP-ROM chips Industrial version :
• Building DLL file using MS-Visual-C as a middleware, the DLL file should be called by Visual-Basic-Software work as a user-interface , the DLL should send-out signals via RS-232 / Serial Port to an Electronic board that will program EP-ROM chips, these Chips can be used to be part of a small-custom-made-computers.
• Design Software to prevent Un-Authorized copy for a floppy-Disk Commercial version :
• Creating a Master Floppy Disk, Writing Additional Tracks on the floppy-disk which DiskCopy command cannot read it , then put a numeric value that indicate the number of installation allowed for this software to be installed, then create an .OBJ file Static Link Library using MS-Visual-C to link/build it with other programming languages like Clipper in the same .exe file, this .OBJ file include the functionality of calling Low-Level-Disk-functions from the BIOS library, once the numeric value on the disk becomes 0, then no more installation allowed for this software then the user must buy a new license to continue installation .
• Design Software to simulate the Gravity between Planets Small Simple Project
• Drawing on the Screen the motion of a group of planets each one of them affecting the other by its gravity, applying Newton's Low F G. m1.m2 /r2 for each object on a small fraction of a time T to calculate the next location of the object, Using C.
• Design a Software to Create a 3D view of a Building Hobby Project :
• Using C Language, the software will draw a 3D view of a building and Apply 3D effects on it Rotating, Shifting, Zooming , after entering the data of the building as 3D-Points and Lines, Similar of a Mini-Version of AutoCAD .

IT specialist:

• Build Custom-made Computers, PC Maintenance, Diagnostic skills, fixing Hardware/Software issues.
• Installation of 25 Computers, and Networking them using Novell platform at the Economic-University-Location in Aleppo, Syria .
• Achievements Recognitions Ranks:
• My current manager has rate my overall performance for the Second 6 month of work as : Generally Exceeds all major responsibilities/objectives and management expectations , With a Raise of 3000 per year.
• My current manager has rate my overall performance for the first 6 month of work as : Consistently Exceeds all major responsibilities/objectives and management expectations , and he comment: Best I.T. Personnel hire, truly gives our company an competitive advantage. , With a Raise of 2000 per year.
• My Score at The Software Engineer College, .NET Stream is 96.75 top in the class .
• Letter of Recognition / Dedicated to Honor from U.S. Congressman Michigan 13th District Mr. Hansen Clarke at 8-23-2012 that recognize my outstanding achievement and graduation from Wayne County Community College District/Infosys Software Engineering Boot Camp.
• The following tests have been done by with a number of IT-Specialists taking the exams in the following areas: