ANmar Amdeen

VBA/Excel developer for 15 years

Buffalo Grove, IL 60089
Job Function
Accounting & Finance, Information Technology, Research
Fast learning, Easy to adjust in any environment, can-do-anything attitude and project driver software architect, VB developer (VB6 + VB.NET) with over 15 years of experience. Developing user-friendly and intelligent Microsoft Excel spreadsheets and VB.NET applications with detailed technical user documentation. Proficient in working on all aspects of the software development cycle including design, development, debugging code, identifying front/back-end interfaces, regression testing, and end-to-end system/functional testing. Designing and building real-life multi-language Excel-VBA-SQL-Based auto and ad-hoc reports, tools and dashboards since 1997.
 

Timeline

'16
'15
'14
'13
'12
'11
'10
'09
'08
'07
Senior Excel VBA Developer
Here - Nokia
Lead VBA Excel developer
Abbott Laboratories
Sr. VBA Developer
Here - Nokia
Lead VBA Excel developer
Abbott Laboratories
Performance Management Analyst
Electronc Arts
Performance Management Analyst
Electronic Arts
Software Engineer/Technical Translator
Ideal Innovations Inc
Excel reports developer
Compensation and Organization Solutions
Software Engineer/Technical Translator
Ideal Innovations Inc
Microsoft Office 2007 Master
Microsoft
Optimization Award
Thank you Bonus
Software Developer
BearingPoint
Technical Translator and developer
Ideal Innovations Inc
 

My Beyond Moment

After my marriage, The best thing happened to me was the first few hours I sat down on Microsoft Excel back in 1997, it was clear that this will be a huge part of my life. PS: I have to write the first part since my wife may read this profile :-)
 

Work Experience

    • Senior Excel VBA Developer
    • Here - Nokia
    • Creating multiple Excel/VBA based systems to automate several aspects of the work flow, reducing the time spent in manual activities

       ...More
    • Lead VBA Excel developer
    • Abbott Laboratories
    • Suggest, design and add enhances to system in “Upload” functionality, reducing the size of file (and bandwidth) by additional 40%
      Adding tons of fixes and enhances to speed up report response and modifying code to match global standards. Fixes added to more 40+ reports, average performance gained around 83%
      Enhance SQL queries and Views to reduce time used by reports while reading data or applying changes

       ...More
    • Lead VBA Excel developer
    • Abbott Laboratories // May '12 - Feb '14 (1 Year, 9 Months)
    • Leading the team into creating and enhancing TPSS (Transfer Pricing Sharing System) using Excel/VBA as User interface, JACL as back-end server programming and Oracle database. System uses Oracle IOP (Integrated Operational Planning), Sandbox technology and Excel2003/Excel2010 Sandbox technology
      Adding tons of fixes and features to enhance speed and modifying code to match global standards. Fixes added to more 40+ reports, average performance gained around 83%
      Suggest, design, and apply the enhance to "Upload" functionality, reducing bandwidth used by average 95%, this actually fixed the issue causing server to stop responding
      Enhancing the user experience by adding solution to overcome the limitations of 65k rows in Excel2003, feature named "Pagination"
      Adding other features like "Progress bar", "Tree" structure views, and "Re-sizing" forms to all reports.
      Reduce the number of queries used by Excel to read Tables, Views or Rowsources, by merging these queries to speeding controls interactivity with user actions

      Suggest, Design and apply “Smart-Drop-Downs” allowing users to select from huge list of products by searching, something similar to AutoFilter in Excel2010 but more custom

       ...More
    • Performance Management Analyst
    • Electronc Arts // May '12 - Feb '14 (1 Year, 9 Months)
    • Manage and enhance Excel-VBA-SQL-based user reports to create readable data using charts and graphs for entire corporation base of clients, employees and executives
      Developing "Della", resource management analysis system, reading from “Clarity” database into Excel spreadsheet and generating high management level reports, customized anytime by end user using custom sheet

       ...More
    • Performance Management Analyst
    • Electronic Arts // May '11 - May '12 (1 Year, 1 Month)
    • Creating several Excel-based reports and dashboards to be used by management in several departments
      Design, create, and manage lots of Auto-Run Excel-VBA-SQL-based reports, running on shared server on weekly, daily, hourly basis to create emails, send reports and status based on customized user configurations
      Creating "Della", resource management analysis system, reading from “Clarity” database into Excel spreadsheet and generating high management level reports, customized anytime by end user using custom sheet
      Create _G.R.E.A.T. system, that manages all daily and hourly reports by any user to eliminate time used by developers

       ...More
    • Software Engineer/Technical Translator
    • Ideal Innovations Inc // Jan '11 - Jan '12 (1 Year)
    • Create translation rules and maintain a database of Arabic names in both English and Arabic languages
      Maintained foreign language interfaces for several applications
      Provide timely technical translations for web-based application and courses

       ...More
    • Excel reports developer
    • Compensation and Organization Solutions // Sep '09 - Nov '11 (2 Years, 2 Months)
    • Designing, and developing several systems (like GMT Matrix, ACuSys, and AMIASys) to automate Sales Bonus, Commissions and Compensations and generating user-friendly reports and charts helping in making executive decisions and salary/bonus changes, plus all user manuals and documentations
      Building Salary, Bonus and Compensations intelligent spreadsheets to automate the process of import, process, analyze huge amount of survey vs. company data and generate comparison reports using custom Excel macros and formulas, saving weeks of manual work into few hours with 99.99% accuracy result
      Create and manage functions and smart spreadsheets to create user-defined-reports
      Create step-by-step videos and prepare documentations

       ...More
    • Software Engineer/Technical Translator
    • Ideal Innovations Inc // Sep '07 - Jan '11 (3 Years, 5 Months)
    • Create translation rules and maintain a database of Arabic names in both English and Arabic languages
      Developing translation software application in VB.NET and MSSQL server that is aimed to translate foreign names efficiently and instantly
      Maintained foreign language interfaces for several applications
      Provide timely technical translations for web-based application and courses
      Provide Arabic timely technical translations for course documents and presentations

       ...More
    • Software Developer
    • BearingPoint // May '07 - Aug '07 (4 Months)
    • Develop Nation-wide census database User-interface entry points using .NET and SQL Server, in both English and Arabic languages, submitting them in CDs due to lack of online capabilities back there
      Assigned as Database Project Leader after manager was kidnapped
      Role ended early when manager got kidnapped and I move to Austin, TX

       ...More
    • Technical Translator and developer
    • Ideal Innovations Inc // Jan '06 - Aug '07 (1 Year, 7 Months)
    • Create, manage and translate technical documentations for IPDMS (Iraqi Police Dept Management System) used across the nation
      Create translation rules and maintain a database of Arabic names in both English and Arabic languages
      Developing Excel/VBA offline tools to facilitate offline data entry from users into SQL Server database saving the project from delays in data entry due to logistics lack downs
      Provide Arabic timely technical translation for course documents and presentations
      Provide translations and grammar corrections in Arabic language
      Record Arabic Audio materials for several types of course
      Role was extended once moved to Austin, TX.

       ...More
 

Education

    • Bachelor's Degree '04 // Computer Science
    • University of Technology
 

Skills

Learning
Intermediate
Advanced
Expert
 

My Statistics

  • 85%
    System speed
  • 3M
    DB rows fit in 65K sheet
  • 300
    Hours saved monthly
  • 15
    Years spent with Excel
 

Keywords

VBA Excel VB.NET SQL
 

My Interests

 
 
 
 
  • Solving issues in Excel
  • LEGOs
  • Developing websites
  • Creating apps
 

Relocation & Travel

Travel Preference
Light Travel
Relocation Preference
No Relocation
 

Awards & Honors

    • Microsoft Office 2007 Master
    • Microsoft Office 2007 Excel Specialist
    • Optimization Award
    • Ideal Innovations // Oct '09
    • Increased software efficiency by at least 80
    • Thank you Bonus
    • Ideal Innovations Inc. // Aug '08
    • Submitting an urgent offline tool in Excel-VBA within less than 4 days, estimated time was 2 weeks
Browse Jobs