Programmer Analyst Resume
New York, NY
SUMMARY:
A self - motivated programmer with 10+ years of solid hands-on experiences in designing, developing and deploying database-driven applications, has strong ability to learn new technologies quickly, as well as identify and debug application issues in a timely manner.
TECHNICAL SKILLS:
Frameworks/Languages/Scripts: ASP.NET/ASP, Oracle PL/SQL, Java (JSP/Servlet), JQuery/JavaScript, VBA/Macro and PHP
Web Servers: Apache/Tomcat, IIS, ColdFusion, Oracle WebLogic and Oracle GlassFish
Development Tools: Visual Studio, Eclipse/myEclipse, Oracle SQL Developer, Toad, SQL1 2Plus and WebFOCUS Developer Studio.
Databases: Oracle Database, MS sQl Server, MS Access and MySQL
Reporting Systems: Crystal Reports, Argos and WebFOCUS reporting tool
Operating Systems: Red Hat Enterprise(Linux), Mac OS and Windows
WORK EXPERIENCE:
Programmer Analyst
Confidential, New York, NY
Responsibilities:
- Developing database-driven applications using ASP.NET MVC, JSP/Servlet and ColdFusion, which are used in clinics to check patients reports, arrive patients, and generate trip tickets for patient visits.
- Write Oracle PL/SQL procedures to process clinic data
- Modify application written in VB.NET, which is used by physicians to generate reports.
- Setup and maintain Apache Tomcat, IIS and ColdFusion web servers
- Conduct testing of HL7 messages (ADT, ORM and ORU)
Sr. Systems Developer/Analyst
Confidential, Memphis, TN
Responsibilities:
- Developed over-time data mart reports using Information Builders product lines (FOCUS and Developer Studio), which has ability to drill down to show details in hierarchical levels.
- Provided support and modification on sales reporting application
- Provided support on quantitative sales, expense and profit analysis
- Ran Macro reports to generate monthly sale reports
IT Analyst
Confidential, Memphis, TN
Responsibilities:
- Designed, developed and deployed a database-driven application for students who apply for summer research programs.
- The application was written in PHP and has below features
- Collects student data via forms and has ability to upload files
- Send emails to references automatically upon submitting application package
- References fill out recommendation letters in MS Word template remotely
- Administration staff can review the recommendation letters in timely manner
- Significantly speeds up the review process of students who apply for this program.
- Developed database-driven applications using Oracle APEX, including
- Application for residents to track patient’s information o Application to collect information of alumni o Application designed for students with disabilities.
- Wrote Oracle PL/SQL procedures, functions and packages in Ellucian/SunGuard Banner system and published applications into Oracle Portal using Oracle package.
- Wrote a PL/SQL program embedded in Banner system, which is used to validate student mailing addresses before students are registered in the system.
- Created student reports using Oracle SQL Developer and Argos reporting tool
- Loaded student data into Oracle tables from legacy system
- Wrote user instructions and trained end users on applications
Data Analyst
Confidential, Memphis, TN
Responsibilities:
- Programmed on revenue reports in millions of dollars using VBA and Macro
- Wrote code to check results across reports to make sure data consistency
- Provided daily, weekly and monthly production reports, which are important tools for management to monitoring products flow in quantities and graph styles.
- Provided production analysis and represented results to customer (DirecTV )
- Conducted tests and rolled out web applications wrote by local and regional programmers, including Oracle database triggers and .NET applications.
Web Developer
Confidential, Memphis, TN
Responsibilities:
- Programmed database-driven application used for products shipping and tracking, which was written in JSP, Java Servlet, JavaScript/CSS and MS SQL server, the application was deployed on Windows and Linux platforms.
- Provided maintenance on web portal, which was written in ASP and VBScript.