SUMMARY:

• Over 28 years of experience in the IT industry with focus on management, leadership and strategy development in addition to Software Development Life Cycle (SDLC) including gathering requirements, designing, developing, deployment, testing, documenting and training end - users.
• Expertise in designing and developing Windows, web based and client server applications using .Net Frameworks 3.5 and 4, Visual Studio .NET, C#.NET, VB.NET, ASP.NET, ADO.NET, VBScript, JavaScript, XML / XSL, Active X, HTML, IIS6, IIS7, Delphi (Object Pascal), IBM MQ Series, Oracle, MS SQL Server, MS Access, Cognos BI, Crystal Reports, Windows 2000/XP/Vista/7/8/10, Microsoft: Word, Excel, Project, PowerPoint and Visio, MS Office automation.
• Expertise in database programming using MS SQL 2000, 2005, 2008 and 2012, Oracle, MS Access, Dbase and FoxBASE.
• Extensive experience on Enterprise Data Warehouse development, design and develop tools using IBM (Ascential) ETL tool to extract, transform and load data across databases and platforms into data warehouse Datamart.
• Experience in Cognos BI and SDK, design and build OLAP cubes to provide dashboards and reports from Enterprise Data Warehouse.
• Expertise in design and develop reports in Crystal Report, MS Access and MS Excel.
• Managing and handling ERP system performing monthly Inventory cost rollup and Month End close as well as ongoing maintenance, reports and stored procedures.
• Strong experience designing and developing highly usable graphical user interfaces (GUI).
• Extensive experiences in design and develop MS Access and Excel application and reports using VBA, transforming legacy systems and automation of processes and applications.
• Highly motivated and energetic team player with excellent communication and interpersonal skills amicable to work with teammates and clients to achieve common goal of achieving deadlines and to deliver comprehensive applications and supports.
• Extensive experience on all phases of accounting, preparation of various financial weekly and monthly reports as well as annual reports for distribution to employees, stockholders and public. Prepare documents for auditing and taxes.

TECHNICAL SKILLS:

Programming Languages: C#.NET, VB.NET, ASP.NET, Object Pascal (Delphi), HTML, Cognos Report Studio/SDK, Crystal Reports, VBA, JavaScript, VBScript, SQL and PL/SQL.

Development Tools: Microsoft Visual Studio.NET, Delphi, JBuilder, FrontPage, MS Access, MS Excel, Crystal Report, IBM Ascential ETL, IBM Cognos Report Studio and SDK.

Databases: MS SQL, Oracle, MS Access, Sybase, DB2, dBase, FoxBASE

ERP Products: Expandable, Lawson

Operating Systems: Windows (10,8,7, Vista, XP, NT), Mac OS, MS-DOS, UNIX, OS2, TSO

UML/Change Management: Visio, Rational Rose, ERWin, PVCS, Visual Source Safe.

Desktop Software: Microsoft Office 2000/2003/2007/2010/2013, MS Outlook, IE, Toad, Query Analyzer, SQL Server Management Studio, ERWin, Expandable, Adobe Acrobat, MS Project, PVCS Version Manager.

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Application Developer / Project Manager

Responsibilities:

• Project Manager, BICS project at USDA with over $4M budget: Plan, schedule, and execute all stages of enterprise software and system implementations. Assessed business implications for each project phase and monitored progress to meet deadline and standards. Translated business needs/client requests into technical terms, prepared detailed work breakdown structures for achieving project milestones.
• Task orders review, Estimation, cost-benefit analysis and ROI assessments. Provided weekly/monthly status reports for client, resolved numerous project issues including technical matters, scope creep and user needs.
• Developed project plans and assumed responsibility for project profit and loss; guided the team throughout the project phases and Task Orders.
• Maintained continuous alignment of application scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
• Created prototypes to reflect proper understanding of client requirements and ensure accurate implementation of designs.
• Led requirements gathering sessions for enhancements to the BICS web application and the four Cash flow Model Automation applications used by the BD analysts. BICS is a Microsoft .Net web application designed to streamline the BD processes, allow for fast and accurate data sharing between BD and other departments, instantly generate management reports and dramatically reduce processing times. The Cash flow Model Automation are C# Excel Automation applications that integrate OMB Credit Subsidy Calculator tool to calculate subsidy rates for the loan/grants handle by RD.
• Designed and developed the business logic and data access layers using Microsoft .Net, C#, ASP.Net, Office Automation, AJAX web technologies and MS SQL scripts. The system is accessing data stored in a Microsoft SQL Server database and uses Spreadsheet Gear library to generate custom management reports in addition to functionalities to upload and validate data.
• Designed and developed Microsoft .NET, Web (.NET Framework 3.5 and 4, IIS6 and IIS7) and Desktop applications using C#.Net, ASP.Net, Java scripts and SQL scripts / stored procedures (SQL servers 2005, 2008, 2012). These applications used by CRS Analysts to perform Automation processes (Formulation and Reestimate) with ability to upload and populate cohort sheets (Excel file), generate cohort sheets containing required data from BICS database to preform automation process.

Business Application Developer / ERP Manager

Responsibilities:

• Manage and maintain Expandable ERP system; perform Accounting and Inventory month end close as well as providing financial reports, systems maintenance, enhancements and user supports.
• Administrate SQL Server 2000, monitoring and providing maintenance (backup, restore, security, data patch…). Develop variety of queries, stored procedures, views and packages to support ERP system, applications and reports.
• Design and develop MRV Kanban system (Web based application) for Material Management and to control the movement of parts from Supplier to Production line. Have used MS Visual Studio C#, AJAX, ASP.NET, Java and VB Scripts, HTML and Crystal Report .
• Design and development GUI applications using Visual Studio 2008 VB.NET to maintain and support MRV ERP system; design and develop reports using Crystal Report, MS Access and Excel.
• Design, develop and maintain over 250 reports to support Finance, Sales and production lines.

Senior System Analyst

Responsibilities:

• eBills: Design and developed web based applications using Visual Studio VB.NET, containing three user interfaces for internal and external user, to handle billing process and provide service for over 26 member countries. Have used MS Visual Studio VB.NET, ASP.NET, Java Scripts, VB Scripts and HTML to develop user interfaces, IBM Cognos Report Studio to generate Bills, IBM Cognos SDK to generate Bills in batch mode, Crystal report and IBM Ascential ETL tool for data transformation and producing Bills reports. Also, have used PVCS for version management.
• EDW (Enterprise Data Warehouse): Develop over 150 ETL jobs using IBM Ascential ETL tools to transfer and load Finance (IMS, BMS and IMS) data into IDB EDW in Oracle database.
• Client Server and Interface applications: Maintain applications using MS Access to perform data entry, report, import data, reconciliation and prepare interface to transfer data from Sybase to DB2. Maintain COBOL programs containing field mapping and rules to prepare data to be added to DB2 table. Develop Access applications and Crystal for GL/Lawson migration and reconciliations. Develop series of interface application to prepare and upload daily/monthly accounting transactions from BMS and IMS to Lawson.
• IMS EIS (Investment Management System - External Interface System) (In production, since September 2003).- Develop GUI application as External Interface System using Borland Delphi, to provide support for the collection, review and update of market prices and ratings, which are used as input into the Summit system for valuation and performance.
• IMSRD (IMS Return Data): (In production since September 2003). Develop GUI application to compute IMS daily incomes as performance data, which is used to provide Investment performance report (Both EIS and IMSRD are designed to use .Oracle database through ADO connection).
• Settlement Messaging System: A GUI client server application using Delphi, MQ Series and Sybase Database server, to provide SWIFT message for securities and interface with RKP and SWIFT system.
• Request for Payments (In production since April 1994): A menu driven, multi-user PC based application to process the Bank's wide requests for payments and generate SWIFT messages and send payments messages to SWIFT system through MQ Series connection.
• Invoice Approval System (INAP): Develop application to process all Finance invoices through KeyFlow XML based messages powered by KeyFlow and Exchange server eliminating the circulation of hardcopy of invoices. Develop INAP Report system using MS Access to generate and view variety of reports using INAP tables in MS SQL server.
• Cash Control System, Liquidity System (In production since March 1991): A menu driven, multi user PC based application to maintain the Bank's cash accounts, balances and transactions using Clipper.
• Bank Information .System (In production 1991- 2003); Maintain information about financial institutions with which, the Bank maintains business relations. In year 2000, this application was implemented in client server environment using Delphi and MQSeries.
• Budget Control system (In production since August 1993): PC based application to maintain budget and personnel data to provide reporting on budget accounts, obligations, payments personnel and projects.