System Analyst Ii Resume Profile
5.00/5 (Submit Your Rating)
OH
SUMMARY
- 8 years experience of database application Oracle and SQL Server
- 8 years experience of in-house application programming C , VB.NET, XML, XSD, XSLT, and WCF Web Service
- 8 years experience of web development ASP.NET, ASP, JavaScript, AJAX, HTML, DHTML, JQuery, LINQ, and CSS
- 3 years experience of Microsoft BizTalk 2006 R2 Schemas, Maps, Orchestrations, BRE, Deployment, Administration and Operations
- Self-motivated and results-driven
TECHNICAL PROFILE
- Strong computer software development background including experience and training since 2000 Quick t master new technology Able t increase productivity by quickly analyzing client needs
- Programming: ASP.NET, VB.NET, C , C , C, SQL, Oracle, PL/SQL, XML, PHP, ASP, VBScript, JavaScript, JQuery, LINQ, AJAX, HTML, DHTML, CSS, MS BizTalk Server
- Environments: Windows, Unix
- Databases: SQL Server, Oracle, MS Access
- GUI Tools: MS Visual Studi 2005/2008/2010, MS Visual Source Safe/Team Server, MS SQL Server Enterprise Manager, Oracle Enterprise Manager, TODA for Oracle IIS, MS VPC
- Database Design Tools: UML, Visio, ERwin, PopKin System Architect
- Reporting Tools: Microsoft Reporting Services, Crystal Report, Microsoft InfoPath
WORK EXPERIENCE
Confidential
Application Developer
Major Projects:
- Disaster Recovery Backup Web Site
- Microsoft Visual Studi 2010 Windows Service
- ASP.NET 4.0 C
- Microsoft SQL Server 2010
- Biomaterial Tracking Management System Data Search
- ASP.NET 4.0 C
- Microsoft SQL Server 2010
- Lupus Study Data Management System
- ASP.NET 4.0 C
- Microsoft SQL Server 2010
- Microsoft Access Database
- Epic
- VBA
- P01 Project Data Management System
- ASP.NET 4.0 C
- Microsoft SQL Server 2010
- Microsoft Visual Studi 2010
- REDCap API
Expertise:
- MS Visual Studi 2005/2008/2010
- Design, develop, test, and deploy ASP.NET Web pages, and implement C /VB.NET applications
- Increase administrative productivity by using ASP.NET Web portal and C Windows Service t monitor application operations
- Improve ASP.NET Web site performance through configuring, coding, and database tuning
- Integrate health care software output with SQL Server database by using .NET technologies such as LINQ and JQuery
- MS SQL Server 2010
- Create Databases and Tables
- Create stored procedures, triggers, index, and constraints
- REDCap
- Export and process data out of REDCap by using .NET API
- Integrate REDCap data with SQL Server by using .NET Windows Service
- Implement REDCap security requirements t a web application by using ASP.NET and C
- EPIC
- Integrate EPIC output data with SQL Server by using .NET Windows Service
- 21 CFR Part 11
- Comply with 21 CFR Part 11 regulations while developing an electronic data capture system
Job Description:
- Lead all departmental IT projects and activities
- Design, develop, test, and debug applications independently and communicate with IT teams in other departments
- Analyze user requirements and make custom enhancements for applications, tools, and health care regulations
- Document project life cycles conduct demos
Confidential
System Analyst II
Major Projects:
- SAP, Service Access SA and Astea Alliance AA BizTalk Integration Lighthouse
- Enterprise ERP System - Astea Alliance
- BizTalk 2006 R2
- CRM System - Clarify
- SAP - IDOC
- IIS
- FTP
- Microsoft Visual Studi 2005 C , VB.NET, ASP.NET, and BizTalk Applications
- BizTalk Application Integration
- Enterprise Integration Web Portal
- Window Services
- Web Services
- Console Applications
- Application Deployment and Setup Projects
- Class Library
- BizTalk Custom Functoid Scripts
- Windows Form Applications
- BizTalk Development, UAT, and Production environment setup
- Install and configure Microsoft .NET Framework, Microsoft Visual Studi 2005, IIS, SharePoint, Microsoft SQL Server 2005, Oracle 11g Client, Microsoft BizTalk 2006 R2, SSO, and SAP GUI
- Import Database tables, data, and stored procedures
- Deploy/Undeploy and configure BRE
- Deployment batch file
Expertise:
- MS Visual Studi 2005/2008
- Designed, developed, tested, and deployed BizTalk applications, ASP.NET Web pages, and C /VB.NET applications
- Increased administrative productivity by using ASP.NET Web portal and C Windows Service t monitor BizTalk application operations
- Improved ASP.NET Web site performance by configuring, coding, and database tuning
- BizTalk 2006 R2
- Schemas, Document mapping, Orchestration, Business Rules Engine, Deployment, Administration, and Operations
- ExplorerOM and WMI Object Classes
- MS SQL Server 2005
- Created Databases, Tables, Stored Procedures, Functions, Triggers and Transact-SQL
- Called Stored Procedures from ASP.NET web pages and C /VB.NET applications
- Maintained and improved database performance by using DTA, SQL Server Profiler, purging, and indexing, etc.
- Imported and exported data, created, saved, and ran Packages using Integration Service
Job Description:
- Designed, developed, tested, and debugged applications independently or through team-work
- Analyzed user requirements and made custom enhancements for applications and tools
- Analyzed business requirements modified database and application accordingly t meet those requirements
- Created documents and user guides
- Supported both internal users and external customers
Confidential
Programmer/Analyst
Major Projects:
- Customer Contact System for Sales and Collections
- Purchase Order System Drill-down t Receipt and Invoice
- Action Tracking System
- Customer Contract Management System
- eShop Scheduling System
- PDA Inventory System
- Repair Order/Service Maintenance Estimate Display System
Expertise:
- MS Visual Studi 2005
- Developed, tested and published ASP.NET Web
- Generated reports by using Microsoft Reporting Services
- VB.NET, VB 6.0, Web Services, MS Access, SQL, MS BizTalk Server, WSDL, UDDI, SOAP, XML, Oracle Database management
- TODA for Oracle
- Created Database and Tables, Stored Procedures, functions, triggers and Transact-SQL
- Called Stored Procedures from ASP.NET web pages
- Maintained and improved database performance by purging and indexing
Job Description:
- Wrote VB ActiveX EXE and VB.NET DLL source codes
- Integrated ERP Systems using MS BizTalk Server
- Created SQL stored procedures t get data from the database
- Generated Crystal reports based on customer's requirements
- Created reports from Web services by using MS InfoPath
- Developed, tested, and debugged Web applications independently
- Analyzed user and business requirements and made custom enhancements for applications t meet those requirements
- Wrote documentation and trained users
A. O. Confidential
Application Developer
Major Projects:
- IT Task Request Intra/Internet Web Site
- News and Document Systems Intra/Internet Web Site
- Order Shipment Tracking System
Expertise:
PHP, JavaScript, HTML, DHTML, MS SQL Server, VB.NET, C, MS Access, Mainframe, Attachmate
Job Description:
- Designed GUIs
- Wrote source codes using PHP, JavaScript, HTML, and DHTML
- Developed a database and the stored procedures t update the database using MS SQL Server 2000
- Created an MS Access database and the SQL statements t access the database
- Converted a mainframe program written in C int a VB.NET program using screen scripting,
- Documented the projects
- Conducted a demo