Developer / Consultant Resume
Troy, MI
TECHNICAL SKILLS:
Technical Skills:ADO.NET (3.5), ANSI - SQL, ASP.NET, (3.5), Azure, Assembler-x86-32bit, C ( Confidential / Borland), C# (2010 / OOP), C++ (OOP), Cloud, Clipper, Crystal-Reports, eConnect (with GreatPlains), ESRI-ArcGIS, FoxPro (2.5 / 3.0), HTML (1.0 - with JS / CSS), JavaScript, MS Excel (2000 / 2003 / 2007 / 2010 / 2013 / VBA), MS-Access (2000 / 2003 / 2007 / 2010 / 2013 / VBA), PowerRender (3D Game Engine - ver 5 / 6), TCP / IP, T-SQL / SQL-Server (2008R2 / 2012 / 2014), VB.NET (2005 / 2008 / 2010 / 2012 / 2013 / OOP), VB6, XML, SSRS, WCF.
PROFESSIONAL WORK EXPERIENCE:
Confidential, Troy, MI
Developer / Consultant
Responsibilities:
- Web Development / SQL Database on Windows Azure ( with DBA role ) / Cloud, for 3 non-profit organizations
- Create an ASP.NET / C# as a data entry to post data into Azure database, then access those information ( after entering credentials ) using reports / statistics / charts ( Power BI ).
- Re-Structure the ( WCM Database Suggestions Tracking System ) Data, for Chrysler/Mexico plant:
- Transfer date from Normalized Structure to Data Warehouse structure, then back to Normalized structure ( in deferent shape ), to meet the business requirements ( like doing UNPIVOT then PIVOT again ) using EXCEL / VBA code, fixing bugs in the reports
- Create a code using C# ( With OOP ) to calculate the position of the sun/moon ( Altitude / Azimuth ) by any given date / time ( from 4000 BC to 8000 AD )
Technologies: Azure SQL / SQL Server / DBA / Excel, Access, VBA, Data Warehouse Concepts, ASP.NET, C#, VB.NET, Cloud Database/Web Development, OOP. Database Architect, Power BI.
Confidential, Dearborn, MI
Data Analyst / SQL Developer / Consultant
Responsibilities:
- Understand - in depth- the structure of the GCRS Database ( 105+ Tables, this is a custom built of a “Supply Chain Planning Solution” that will give reports for Demand / Capacity ).
- Working with Excel ( Pivot-Tables, Charts, vLookup, Import/Export to different types of files including xml/txt/csv/xls.
- Connected to different types of Databases including SQL/Access, Power Charts, Formulas, VBA-Macros, Reports, 32/64 bit versions, moving data across different types of formats/files,
- Maintain the Database as a DBA role, Tuning SQL queries.
Technologies: Heavy usage of TSQL / SQL Server / DBA / Excel, SSRS, SSIS, Access, VBA, DW
Confidential, Troy, MI
Senior .NET / SQL Developer
Responsibilities:
- Applying Multi-Tier Web-Based Application for (internal use software)
- Use OOP, Generics, LINQ to Objects / PLINQ / Parallel Programming Features.
- Using SQL-Stored Procedure/Functions/Triggers/Indexes/Constraints for complex Database
- Design an Auto-Code-Generator to generate all the Stored-Procedures / DAL / BLL-Lower codes ( in SQL and C#, ( Total 50,000 lines of code )
- Design / Develop / Maintain ( the new iBart Point-Of-Sale for 120+ Branches/Franchises World-Wide using C# / SQL )
- Design / Develop / Test Internal software using ASP.NET, C#, SQL, ADO.NET
- Reverse Engineer/Analysis old VB6 code for the BartForWindows Point-Of-Sale, and make updates.
Technologies: Advance usage of TSQL / SQL Server / DBA / OOP, C#, VB.NET, SSIS, Access, VB6, WCF, TFS, ASP.net, ADO.net, Web Services, HTML, CSS, JavaScript, OLAP, Crystal Reports, Client-Server Architect, Web Development, IIS, Scrum, DLL, Database Architect.
Confidential, Detroit, MI
Software / DevOps Engineer ( Full Stack )
Responsibilities:
- Design / Develop (billing system for GlobalLink using MS-Access-2007 / VBA / SQL ), Use ArcGIS software ( Geographic Information System ) to develop solutions to the city of Detroit.
Technologies: Advance usage of ArcGIS, Access, VBA, SQL / SQL Server, Client-Server Architect.
Confidential
Software / DevOps Engineer ( Full Stack )
Responsibilities:
- Custom Build / Maintain / Configure / Upgrade PC Hardware / Software, Design Small Video Clip which used for Advertising Purposes ( 3D Graphics ), Design Email List Management ( can handle 500+ Million Records ), Teaching Programming Classes ( C, SQL ), Complete SDLC.
Technologies: C, C++, SQL, Excel, Access, VBA, VB.NET, OOP, 3D Game Engine ( Power Render ).
Confidential, Redmond, WA
Software Test Engineer
Responsibilities:
- Test Visual FoxPro with Internet Explorer Browser (in Single/Client-Server environment), Test OLE Automation / COM / DCOM / OCX, writing test case scenarios
Technologies: Visual FoxPro, ActiveDoc, C, Transaction SQL.