- Delphi, SQL, MS Office, Reporting, Upgrading

    YOUSSEF H. WARDANI

    1717 WINDYCREST DRIVE, SPRINGFIELD, IL, 62704

    (217)787-1962

    ywardani@hotmail.com, ywardani@gmail.com

     

    Objective:

    To obtain challenging and demanding experience in a position of increasing responsibilities and to further the development of my leadership skills.

     

    Computer skills:

    Computer languages: Delphi [2, 3, 5, 6, 7], VB6.

    Databases: Microsoft SQL Server [6.5, 7, 2000, 2008], Oracle PL/SQL [8i, 9i, 10G], MySQL, SYBASE SQL Server.

    Operating Systems: DOS, Windows (3.1, 9x, NT, 2000, XP, Vista, WIN7).

    Other: Microsoft Office [+VB in Word, Excel, and Access], MS Office Front Page, Crystal Reports, Report Builder, Delphi Quick Reports, Midas, Sockets.

    Imaging Systems: Optika, Stellent, Oracle IBPM, LRS PCX.

    Ancillary Knowledge: C, Basic, C#, .NET, Visual Studio 2005, UNIX FTP Batch Files, HP PCL, Google Analytics.

     

    Management skills:

    • Led project management of four team members to deploy successful application release.
    • Manage and participate in recruitment process of over many prospective employees for positions in development.
    • Develope innovative procedures and policies that aid the speed and effectiveness of hiring, training and continually educating employees in our department.
    • Manage and coordinate monthly meetings to ensure timelines are met and clients are aware of the current project status.
    • Write various Requests for Proposals (RFPs) in response to clients needs giving them immediate feedback and achieving their specific goals.
    • Write coding standards with extensive documentation improving software development.
    • Perform independent critical analysis of specifications.
    • Daily maintain up to date well organized written records of all development changes (Release Notes).
    • Excellent oral and written communication skills, great interpersonal skills which effectively stimulate a cooperative team environment.
    • Define ownership of all parties involved before the start of any project.

     

    Development skills:

          2006-Present, Levi, Ray & Shoup (LRS), Springfield, IL

          Software Engineer Specialist

    ·         Heavily using DLLs.

    ·         Design and Development and Support for Fund and Retirement software known as Pension Gold.

    ·         Design and Development and Support for imaging software. Optika, Stellent7x, and Oracle IBPM 10x [Imaging Business Project Management].

    ·         Converted client from using File Net to LRS-PCX file manager software tools.

    ·         Design and Development and Support for Web Member Services [WMS] using Delphi CGI.

    ·         Design and Development and Support for Web Employer Reporting Services [ERS] using Delphi CGI.

    ·         Created and maintained Conference Manager Software for LRS Teaming Conference. I am in charge of data entries to track conference activities and scores which I created for a scoring tool.

    ·         Updated IRS 1099 Nelco files and Neclo.RES file to be used by our applications. The Nelco.RES file was updated using MS Visual Studio 2005.

    o        All 1099 printing is done using HP PCL.

    ·         Created a simple Security lockout method. Lock will depend on user defined number of trials and it will last by certain user defined minutes.

    ·         Created a Call Center/Contact Center screen that gathers data from various screens and shows to the operator.

    ·         Created a personal light tool [Batch CR] that will allow me to take actions quickly when working with complex daily work. Any steps that are repeatable are added to this application.

    ·         Updated an older version of Top Grid to allow for title to wrap column text.

    ·         Created a command line interface to integrate current imaging software with Pension Gold Case Flow.

    ·         Updated a Delphi wrapper to allow Delphi5 to open a CHM help.

    ·         Trained new comers and co-workers on coding and business rules.

    ·         Weekly writing SQL scripts for MS and Oracle clients, from the simple update to complex as migation.

    ·         All documentation warehousing is done using Starteam [5.0, 2009].

     

    2000–2006, Delta Dental Plan of Michigan, Okemos, MI

    Lead Software Designer/Implementer

    ·         Collected specifications from users and QA team, designed, developed, tested, documented, deployed and supported various applications:

    o        Provider Locator Application using Delphi 7 client and MS SQL2000. Built my own documents library and context sensitive help using Front Page.  Application was a re-write to a mainframe process.

    o        Orthodontic Subsequent Payments Application using Delphi 7 client and MS SQL2000. Application was a re-write to a mainframe process. Built my own documents library and context sensitive help using Front Page.

    o        Claims Reader for General Motors accountant to view claims in a user friendly format, Using Delphi 7 client and ADO text files.

    o        Task Reader to monitor SQL Server jobs and log files created by other applications. It is able to read failed jobs or search log files for a specific message and send e-mail to the corresponding user on the list.

    o        Security Control application to allow a security officer to monitor and edit SQL accounts. On the SQL server side, I created my own SQL Server security using XP-Cmdshell and a Delphi client.

    o        Application Scheduler using Delphi and a text file to mimic Windows Job Schedulers in a much simpler form.

    o        Report Mail application to create a list of all claims per provider and generate a TIF file. It will copy the files into a UNIX server where it gets processed and e-mailed.

    o        Ownership Module to allow the users as well the managers to control users work per module, screen, and fields.

    o        Auto Updater using Delphi 7 and an INI file to allow any application to automatically update itself.

    ·         Modified, upgraded, tested and documented a Report Viewer application. Built using Delphi 7, text files and MS Access database.

    ·         Supported all in-house MS Access Database, MS Excel and a variety of light applications.

    ·         Modified and created Delphi Components.

    o        Mimic DOS line prompt

    o        Fast Windows Files and Folder Search

    o        Complex License Encryption and Decryption [Ordinal and Hex]

    o        SMTP and MAPI simple calls

    o        In memory Text Files loaded and treated like any DB Table.

    o        Add-on to System menus and System Icons

    o        Dialog to create a variety of forms at runtime.

    o        Customized Status Bar

    o        Navigation Dialog to cover MS SQL and ACCESS queries

    ·         Created a light tool [Resource Tracking] that will allow me to take action quickly when working with complex daily work.

    ·         Trained new comers and co-workers on coding and business rules.

    ·         All documentation done in FrontPage and allows the user instant on screen help add-on using text files and/or Word.

     

    1996–2000, Paramount Technologies, Inc., Southfield, MI

    Software Engineer

    ·         Collected specifications from users and QA team, designed, developed, tested, documented, deployed and supported multiple applications:

    o        Requisition modules using Delphi 2&3 on the MS SQL 6.5 and Sybase 9.0.

    o        Problem Tracking Resolutions using Delphi3 and MSSQL to allow users to track problems.

    o        Time and Expenses Entry to allow users to task and schedule their time and expenses.

    o        Request for Quote to allow proposal with a template to purchase order.

    o        Bill of Material to build projects.

    o        Inventory Transfer Engine [XFR] to allow exchange of items among centers.

    ·         Re-designed, developed, tested, documented, and supported Purchase Order, Inventory, Taxes, Items, and Unit of Measure applications. Work included the re-write of client and server code.

    ·         Designed and developed application security for Requisition Manager Software package.

    ·         Provided international user hotline support for Procurement Management System and other applications.

    ·         All application built using Multilizer components for international Locale and Language conversions.

    ·         Created a light tool [Report Maker] that will allow me to take action quickly when working with complex daily work.

    ·         Modified and created Delphi Components.

    o        Inherited Text components that hide when there are no data.

    ·         Trained new comers and co-workers on coding and business rules.

    ·         All documentation done using Word.

     

    1994–1996, Baskerville & Co. Accountants, Detroit, MI

    Programmer Analyst

    ·         Developed custom applications to interface with Excel spreadsheets.

    ·         Designed MS Access database for customer tracking applications.

    ·         Designed and developed on MS Access Billing System.

    ·         All documentation done using Notepad.

     

    1990–1994, Aamdak, Inc., Dearborn, MI

    Programmer and Manager

    ·         Created Lotus1.2.3 Application to calculate Gas Converter.

    ·         Wrote daily check sheet and inventory tracking system.

    ·         Provided user support.

    ·         Managed daily purchases and operations.

    ·         All documentation done using Notepad Lotus1.2.3 data files.

     

    Education:

    ·         May 1996, Wayne State University, Detroit, MI

    o        B.S., Computer Science, Cum Laude.

    ·         May 1992, Henry Ford Community College, Dearborn, MI

    o        A.S., Computer Science, Summa Cum Laude.

    o        A.A., Arts, Summa Cum Laude.

     

    Activities:

    ·         Delta Dental, MI / Events Committee

    ·         Delta Dental, MI / March of Dimes Team Captain

    ·         LRS / User Conference Scoring Committee

    ·         Springfield, IL / Iles School PTO

    ·         Springfield, IL / Iles School Intramural Basketball 2007-2010

     

    What about me?

    I love writing client/server applications. In the past 20 years I have written over 6000 procedures, 2000 tables, 1000 views, and 500 triggers. And post MSSQL 2000, I have written many functions and few XPs. Before DML was on the radar, I always pride myself to take the project from start to end and to document and flowchart the work right down to the smallest data type. I shine more in rewrites. All my years of experience involved me upgrading a company. Along the way I learned many techniques and developed many of my own. I do not wait to be told that something needs to change, I take initiative. I have lack of tolerance for incompetence. I strongly believe that each team member must be accountable to keep up with the general learning pace of the team. I am honest, very honest, and I can deliver. I can safely say that I can develop as well as manage, I have done it!

     

     

    References:

    Upon request.

     


    You can contact Youssef Wardani via this form

    Latest News
    Submit News Form Past News
    Latest Forum Entries