Systems Analyst Resume Profile

SUMMARY

IT professional with experience as senior developer and technical team leader with proven effective planning, analyzing, and design capabilities. Excellent analytical, problem solving, and communication skills. Extensive experience with:

SDLC development	Analysis and design	Development, coding, testing
Oracle, SQL, UNIX scripting	Informatica	Project Management
Data Warehouse / Data Mart	Mainframe	OLTP / OLAP

Specialties: Oracle, Informatica/ETL PowerCenter, UNIX, PL/SQL, SQLPLUS, sqlldr, Sybase, iSQL, Transact-SQL, SQL Server UNIX Shell Scripting Control-M Toad, dbArtisan, Erwin Mainframe, JCL, SAS, COBOL, CICS Visual Basic, VBA AS/400 DB2 Access Visio Crystal Reports Batch processing.

EXPERIENCE

Confidential

Systems Analyst / Developer

Collaborated on projects in the Drug Price and Enrollment pre-adjudication areas at WHI. Designed and implemented solutions for the WHI Claim Solutions Division.
Systems Analyst Technician on individual projects UNIX /Oracle projects.
Performance tuning and data analysis on reporting processes to ensure meeting required SLA.
Dev. Lead / Data Center Migration Walgreens / PBS Client migrations into RxClaim
Sr, Developer on Conversion programming for new client implementations and migrations.

Confidential

Application Development Senior Programmer / Architect

Served as subject matter expert representing Claim Data Warehouse perspective in all prospective client meetings partnered with stakeholders, business analysts, systems analysts and team members to understand business requirements and correlate potential technology solutions that drove the analysis and design of quality technical solutions. These solutions were aligned with business and IT strategies and complied with the organization's architectural standards.

Functioned as a technical team lead for key components of an 80M program development effort to a corporate data warehouse system designed to give Finance and Actuarial decision makers access to key performance metrics.
12TB Oracle data warehouse Application Development team of 18 developers including production support Project Leader of 3 on-shore and 3 off-shore consultants.
Senior level of team leadership and expertise in systems analysis and design, application development and integration, and testing of complex systems and applications: Oracle 10g/11g, Informatica/ETL Powercenter 8.x, UNIX, VBA PL/SQL and mainframe processes.
Lead engineer on upgrade of RMIS CICS/Oracle application, which generates 59M annually.

Confidential

Managed and executed insurance carriers' business requirements, underwriting rules and coverage offerings.
Managed multiple concurrent implementation projects Coordinated regular meetings and status updates to monitor execution of project against plan Maintained project budget, regularly comparing actual versus project performance and metrics.
Developed component and data architecture design, assisted in performance engineering, and implementation of home-grown data transport service between Sybase 11 and Oracle 8i on 2000 user database saving 1M on user licensing over using vendor built recommended service.

Systems Analyst

Consultant in Development Resource Center COE area on various projects. Disaster Recovery Program - MS Access Application Inventory Conversion Project - Conversion of data from multiple sources: MS Access, Sybase, Excel, SAS, SQL Server, and Oracle 7 into Oracle 9i.
Independently designed, managed, and implemented codification changes to developed applications in Visual Basic 3, 4, 5, and 6 Crystal Reports. Packaged client and network applications for Metaframe/Winframe/Citrix and Windows network distribution-using SMS.
Created a standardized template used corporate-wide for implementation of FTP processes and standards within the Claim Processing Team. Developed FTP scripts in UNIX, Windows, VBS, and DOS batch.
Actively worked with stakeholders to mitigate risks by maintaining risk assessment and management plan Led documentation of implementation specific customizations and requirements.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship