Systems Analyst Resume Profile
3.00/5 (Submit Your Rating)
Chicago, IllinoiS
Summary
Versatile software engineer with prior clinical background, who has helped employers meet productivity and capability goals with SQL Server, .NET, Visual Basic for Applications VBA and scripting.
Employment History Personal Project / Systems Analyst
Confidential
- Reduced website development expense by 50 by recruiting a modestly priced developer and effectively utilizing volunteer resources while ensuring the correct function of site features.
- Assured user satisfaction by maintaining a list of issues during development process and insisting on their resolution.
- Secured website by performing timely updates of plugins.
Software Engineer
- Advanced the migration of AON's AONWrap application from Oracle/PL platform to SQL server 2008 by porting 50 SQL stored procedures and functions.
- Added web pages and control logic to Accenture's myTE time and expense data entry system in an ASP.NET 3.5 agile development environment.
- Gave managers visibility into enterprise sales and financial data by configuring SQL Server Analysis Services cubes and report definition files and creating Key Performance Indicators KPIs .
- Advanced Accenture's Global Pricing System project, providing key numerical calculation capability by designing and writing dozens of elaborate stored procedures based on multi-page Excel spreadsheet specifications. Assured correctness of calculations by creating a system of automated unit tests.
- Resolved software defects in Cardinal Health's Syntrac .NET WinForms application as part of an application stabilization team.
Software Engineer
- Gave Avanade managers enhanced formal project cost-estimation capability by writing several hundred lines of Excel Visual Basic for Applications VBA code.
- Tracked nightly enterprise-wide software installation activity by developing and deploying a custom database integration VB6 application at State Farm Insurance Company.
Systems Analyst
- Automated dozens of company's clerical workflow tasks by developing Access VBA Visual Basic for Applications software.
- Contributed to FDA approval of a Pap-smear image-recognition scanner by writing software in C and UNIX.
- Operated own network and data processing service.
- Developed curriculum and taught basic computer skills, MS Office and computer programming.
- Provided clients with local area networks and an FTP file transfer protocol server.
- Provided Lowes Board of Directors with custom sales projections using Visual Basic for Applications VBA .
- Identified and slashed delinquent accounts by creating custom SQL Server package and custom SQL queries.
- Ensured 99 uptime for local area network.
- Exposed real-time readout of 20 bill collections call center activity metrics by developing a Linux web application using Perl scripting and Apache web server.
- Automated data transactions with Illinois Department of Revenue, CustomCall Data Systems and various service providers.
- Improved efficiency of image scanner by programming the image database management system using the Bourne Unix shell.
- Supported development of a customer transaction system by writing data simulator.
- Generated custom printed documents, including provider directories for insurance companies, identification cards and product catalogs by writing