TECHNICAL SKILLS:

• Oracle 8i/10g/12c
• SQL Server 2008/2012/2014 (SSIS, SSRS, BI)
• Microsoft Access, MySQL
• JSP, PHP, MATLAB, R, SAS
• C#, C++, Visual Basic, ASP.Net, MVC, XML, Java
• T SQL, PL/SQL
• Ruby on Rails, PowerBuilder
• Autosys, Microsoft Project
• Mac OS X Server 10.1, Windows, Linux, UNIX
• SVN, GitHub, GitLab, Atlassian tools (Fisheye, Crucible, JIRA, and Confluence)
• SoapUI (SOAP and REST Web Service)

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. Software Engineer

• Manage and support association management system (AMS)—netFORUM—which generates more than $23 million annual revenue with more than 400,0000 individual records, 600 membership organizations and their staff
• Develop and maintain integration between netFORUM and 15 other applications
• Perform script deployments according to updated management policies, develop solutions in an Agile environment, create and maintain user and technical documentation
• Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages, troubleshoot and optimize existing SQL codes in SQL Servers, develop and deliver standard & custom reports for customers with SQL Server Reporting Services (SSRS);
• Work with business user and external vendor on the netFORUM upgrade and system improvement projects, by analyzing existing system, release notes and business needs. Perform regression testing in the targeted areas;
• Support the LMS Web Courseworks which provides learning management for internal and external users;
• Participate the initiation, planning and implementation of the cloud - based eCommerce system of Magento, which generates about $8 million annual revenue with more than 200 active products, e.g., shippable, downloadable and virtual products
• Test and implement the integrations between Magento and accounting system Workday, shipping system Pitney Bowes, SAML, Salesforce, Internal Account Management System, PayPal and Google Analytics
• Develop custom reports and generate information or report upon request in MySQL 8, SQL Server 2014, Oracle 12c and Magento Business Intelligence Analytics
• Provide day-to-day support to internal business users, troubleshoot technical issues, debug .NET and PHP code, provide solution consultation, coordinate the change management process among different parties and deploy the release packages
• Attention to detail and able to manage multiple projects simultaneously

Confidential, Baltimore, MD

Software Engineer

• Managed and supported Integrated Student Information System “ISIS” for School of Medicine Admission/Financial Aid/Registrar/Business Offices
• Developed, debugged, tested, documented and supported Web-based applications on.NET platform developed in C# with Microsoft SQL Server Databases in Visual Studio; developed ETL system to handle the information migration with SSIS; created bat files and schedule Autosys jobs; maintained and enhanced Microsoft SQL Server storage procedures and views; produced complex information reports in SSRS; supported and documented related software functionality
• Implemented student financial aid system “PowerFaids”, according to stakeholder’s policy and business work flow, which includes mapping, configuring, testing, implementing, and post-launch support; programmed interface in TSQL for data migration and transformation, from existing student management system “ISIS” to “PowerFaids”; developed data warehousing report
• Analyzed business processes and worked closely with business users to identify opportunities to improve the utilization of applications; coordinated stake holders, such as end users and university IT production teams to identify business needs and discussed solution options
• Utilized software version control system SVN and issue tracking system JIRA; Fish Eye Code Review
• Planned and delivered customer support services, including application installation, configuration, troubleshooting, customer assistance and training in response to customer needs

Sr. Programmer/Database Analyst

• Developed, tested and maintained web application- specimen repository; developed in Java Server Pages with Oracle 10g Database on Apache Tomcat Web Server; translated functional and technical requirements into programming specifications through design documents and flow diagrams
• Configured and monitored Mac OS X Server 10.1.4; installed, configured and maintained Oracle 10g database; completed export and import using Oracle Export / Import utilities; utilized RMAN for backup and recovery; troubleshot database and application issues
• Developed standard and customized reports on request
• Analyzed data in SAS, SPSS, R, Excel, SDS and SAM; programmed stored procedure in PL/SQL to analyze large scale data including methylation array data and microRNA data
• Created and maintained website with HTML; built secured shared drive server; reduced cost by $6000/year

Confidential, Baltimore, MD

Research Assistant

• Participated in the project “Segmenting Handwritten Square-Block Characters” and developed efficient algorithm to detect handwritten square characters
• Conducted research on Air Force funded project “Arbitrary Long Fractional Number’s Exact Arithmetic Computation,” overcame computation limitations such as memory-overflow, round-off, and truncation. Implemented in Visual C++ and Mat lab
• Developed student information database with Microsoft Access for Physician Assistant Program. Improved admission process efficiency by 30%

Confidential

Software Engineer

• Developed and maintained large scale Integrated Telecom Service Management System (ITSM) utilizing client-server architectures. Monitored performance of ITSM Oracle 8i application database
• Interacted with function users, analyzed user requirements and developed dynamic modules with Power builder 4.0 and Oracle 8i database
• Developed and generated complex reports for various departments, such as marketing department and billing department
• Monitored and provided front-line technical support of daily process for ITSM end users