Systems Analyst Resume Profile

Objective

Information technology professional with proven ability to meet deadlines, improve process development, develop business requirements. Experienced in management and development application process.

PROGRAMS

Visual Studio, HTML, XML, Visual Basic 3, Visual Basic 4, Visual Basic 5, Visual Basic 6, Microsoft Access

DATABASES

SQL 2000 - 2008, Oracle 10g, SYBASE

REPORTING

Crystal Reports, MIC 5, HTML- SSRS

LANGUAGES/SCRIPTING

VB, VB.NET, C , Crystal, T-SQL, PL-SQL, HTML XML, DHTML, JAVASCRIPT, INTERDEV

Technical skills

Proficiency with the Microsoft office suite word, excel, powerpoint, and access , case tools, and project management tools.
Proficient in: Visual Basic, VB.Net, TSQL,PL/SQL, ASP, JavaScript, Crystal Syntax, HTML, DHTML
Familiar with: Java, C
Strong skills in Oracle server side programming which includes SQL, SQL Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, PL/SQL Web-services, Java Stored Procedures, Oracle AQ and Oracle Web Toolkit/PL-SQL Web Cartridge and a very good knowledge in Oracle 10g Developer Suite modules.
Experience in designing creating databases in Oracle 8i/9i/10g for OLTP applications.
Extensive experience in data migration techniques using SQL Loader, Import/Export.
Strong experience in Data conversions from MSSQL, MySQL, ACCESS, AS400 to Oracle.
Expertise in designing developing application using J2EE, Server Side Components using Java, Servlets, JSP, JavaBeans, XML, JMS, JSF, JNDI, Web Services SOAP , Hibernate, Struts framework, Spring framework.
Hands on Experience with SQL Server 7.0/2000/2005, T-SQL and DTS.
Hands on experience in building applications using MS Access, Excel, Macros, VB.Net
Experience in Rational Unified Process RUP , Unified Modeling Language UML
Experience in Functional and Technical design, Test Plan Preparations, Unit Testing, System Integration Testing and documentation.
Experience in shell scripting, includes file monitoring scripts, data manipulation scripts and data load scripts. Extensively used VI editor. Hands on with Perl scripting.

Key Skills:

Managed projects as Team Lead and conducted meetings with all levels of management.
Excellent trouble shooting, debugging and error trapping skills.
Extensive experience in full life cycle or SDLC processes development and post implementation support of various large-scale systems.
Excellent written, verbal communication, interpersonal skills and a team player.
Problem solving - Resolves in-depth queries in a methodical manner independently and with internal and external business partners to find appropriate resolutions, efficiencies and high level of quality.
Team Player - Enjoys sharing knowledge and encouraging development of others to achieve specific team goals.
Planning and organizing - Refined planning and organizational skills that balance work, team support and ad-hoc responsibilities in a timely and professional manner.

Experience:

Siemens Systems Analyst

Siemens Soarian Operational Report Writer.
Create Stored Procedures for Reporting in SQL Server.
Build Reports to client specifications in Crystal Reports XI.
Troubleshoot and resolve issues with reporting in Operational Reporting, Context Sensitive Printing, and Soarian Job Scheduler reports.
Report optimization.
Setup and Maintenance of Event Driven Routing EDR groups
Creation of stored procedures in SQL Server for the purposes of reporting
Support and Troubleshoot Soarian Clinicals OPENLink Messaging Interfaces
Soarian Clinicals Report writing in Crystal Reports XI and scheduling through Siemens Job Scheduler
Maintenance and creation of jobs in Siemens Job Scheduler
Creation of rules in Siemens Rules Engine using Arden Syntax for integration into Soarian Workflows
Automation of daily system tasks through the use of PowerShell

Crystal Enterprise/PL/SQL Programmer

Confidential

Develop new reports for an online application eOasis and Mic 5.
Develop reports using CSS, HTML 5 for the MIC 5 environment.
Strong skills in Oracle server side programming which includes SQL, SQL Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, PL/SQL Web-services, Java Stored Procedures, Oracle AQ and Oracle Web Toolkit/PL-SQL Web Cartridge and a very good knowledge in Oracle 10g Developer Suite modules. Create Functions and Oracle Packages for efficient reporting.
Also used ETL processes and dimensional model design for the purpose of data mining in the creation of reporting views.

Management System

Confidential

Staff manager for Ajilon while consulting for the AOPC my duties included, Screening candidates for technical positions, perform technical interviews, asses communication abilities and fit at various sites also performed annual reviews and salary recommendations. Weekly reports for Ajilon's corporate office of various projects and timelines.
Develop/Maintain reports for Common Pleas Criminal Court Management System
Create new and maintain existing reports within the system using Crystal reports and SQL stored procedures Performance tuning of stored procedures, conversion from table driven reports to stored procedures xsd driven reporting. Developed Metadata tools using VB.Net for report parameter interface

IT Manager/Programmer/Analyst/Systems Administrator

Teachers Protective Mutual Life Insurance

Developed client side rate quoting program for company underwriters and Agents.
Developed web based rate quoting application, intranet and internet, developed various census programs.
Assisted in creation of a data repository, administrator of document imaging system
Responsible for all hardware and software certification for the HIPPA compliancy.
Oversee all technical aspects of server and database installation, including overseeing creation of schedules, documents, and guides for contractors, vendors, and consultants.
Act as sole point of contact for end users during router/switch/PBX and Web POS installation, and troubleshoot problems. Document and report findings to facilitate problem resolution.
Create and maintain project schedule and database documentation, and act as liaison between all project contractors.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship