Sr. Systems Analyst Resume Profile
Experience Summary
- .Net Architect and Application Developer with 18 years of SDLC experience in commercial software and custom business applications.
- Product knowledge spans education, government, legal, banking and financials, ecommerce, and security services.
- Experience includes utilizing state of the art desktop, client server and web based application development tools and technologies.
- Skills include C .Net, C , ASP.Net, VB.Net, VB 6/5/4/3, JavaScript, ASP, SSIS, HTML, ADO and Windows Server 2008/2003/2000, NT/2000/XP, IIS with over 12 years of SQL experience using a variety of relational databases.
- Excels at troubleshooting client needs and has been responsible for every aspect of project success from writing documentation and planning to providing complex design and development to deliver an efficient and effective system.
- Strong people skills having mentored many Junior Level Developers as well as instructed large seminars.
- Dedicated worker who has strong experience providing 24/7 systems support. Goal oriented and able to work in a fast paced environment while able to multitask and prioritize work in a team environment or in an individual setting.
Expertise
|
|
|
|
|
|
Professional Experience
Confidential
Application Architect /Consultant
- Technically responsible for the firm's Network Provisioning NetPro and Desktop inventory AIMS applications. This includes upgrading legacy ASP modules to .NET 3.5 plus upgrading older 1.1 and 2.0 to the 3.5 framework. Other responsibilities included maintaining and writing new PLSQL procedures and functions for application access and batch jobs.
- Handled application and PLSQL upgrade from Oracle 10g to 11g.
- Successfully implemented coding changes and SQL tuning after doing an extensive analysis on an application experiencing very poor response time and application performance. This included writing a logging mechanism to track down application bottlenecks and database inefficiencies to pinpoint problems within the application. I also used DBCool and other tools to help track down issues with SQL statements and PLSQL code running within the application code. These efforts improved response times from 20-90 seconds to 1-8 seconds within the application.
- Upgraded over 25k lines of ASP code to .NET 3.5 framework MSVS 2010 .
- Upgraded over 120k lines of .NET 1.1, 2.0 code to .NET 3.5 framework MSVS 2010 .
Confidential
Senior IT Consultant
- Network, hardware and software management including the development and maintenance of all in-house applications.
- Junior development mentoring, interviewing and personnel management.
- Developed and maintained all in house applications.
- Designed .NET framework used within company and for client projects.
- Also administers the entire web infrastructure and software.
- Developed and maintained all SQL Server databases including all stored procedure, functions, views and ETL processes utilizing DTS and SSIS.
Confidential
Team Lead/Consultant
- Technical lead for the Acquisitions Team. I was in charge of all client server integration from three different acquisitions that the company had made. This included analysis of systems, documentation, execution and testing for all web applications and database objects. I was also the team's Scrum Master running the daily meeting and setting up the daily burn downs and was also responsible for each build after each sprint.
- Negotiated and worked in business logic for each acquired company into existing website.
- Wrote ELT process using SQL Server Business development Intelligence Development Studio SSIS for processing and transforming data from acquired companies.
- Wrote all technical documentation for acquisition planning and implementation.
- Lead team of eight programmers, DBA's and business analysts.
- All acquisitions were completed on time and within budget.
Confidential
Application Architect/Scrum Master/Consultant
- Designing the next generation Enterprise Framework Platform utilizing both .NET Web and Java business and data access layers technologies to help streamline all future development while providing scalability and reliability to the business units.
- Worked closely with the Senior IT management to insure the department's goals are kept in line with the development effort all the while advocating for the technology's Best Practices and insuring quality and ease of use.
- Did extensive analysis on existing applications to find flaws and bottlenecks in code and architecture that were impairing the performance of the systems.
- Lead a team of two architects and three programmers and oversaw the writing of the documentation that would guide architects and application designers in future projects. This included the writing of the framework solutions and projects as templates.
- Project was managed under PMBOK guidelines enforced by the firm's project management office.
Confidential
Application developer/Consultant
Worked on a fast paced Agile development team to upgrade the Ohio Business Gateway OBG for the Strategic Design and Architectures enhancement project. Upgraded existing application framework and implemented MVC, MS Workflow Foundation and Entity Framework.
Confidential
Software Architect/Team Lead//Consultant
- Developed a state of the art .NET 2.0 framework and Oracle database for the firm's End User Request System EURC . Eventually upgrading MSVS and VSS to TFS.
- Wrote and implemented automated tests using NUnit and later TFS.
- Built and managed Build Agents and build Definitions using TFS and setup and managed all automated builds to DEV, QA, UAT and production servers.
- This system helped decommission over 40 different small request systems throughout the firm. The application had a potential user base of over 230,000 users at any one time.
- Designed a dynamic code hydration and form builder that greatly reduced both time and cost for the project.
- Responsible for all application architecture and design considerations from UI to database.
- Architecture includes: web, web services, remoting Windows services and multi layered business and data access components.
- All interfaces are written in C leveraging ASP.Net, AJAX and Microsoft Data Access Blocks. Data Access Hydration templates written with XML/XSLT to render business logic and data access classes.
- Databases include Oracle 10g and SQL Server 2005.
Environment:
Confidential
Sr. Software Developer / Application Architect./Consultant
- Helped to design the agency's security system: SAFE Security Application for Enterprise . This system provided authentication and authorization for all applications and systems that were implemented at the agency. This was one of the agency's first .NET 1.1 applications.
- Administered all web sites and web site access within agency.
- Managed web code and implementation of project code onto web servers. This included versioning, labeling and branching using VSS.
- Performed Code Reviews as part of code migration.
- Mentored junior application developers and local web managers
- Helped design and code the OEDS application.
- Designed and coded an agency wide survey tool.
Environment: C , ASP.Net, ADO.Net, ASP, Web Services/Remoting, JavaScript, Oracle 9, SQL Server 2000, TOAD, LLBL Gen, IIS, Windows Server 2003/2000.
Confidential
Sr. Systems Analyst/Team Lead/DBA/DBO/VSS Admin./Consultant
- Developed and implemented a strategic plan for porting reports and data to ERP system for the eventual decommission of agency's mainframe system.
- This included the building of a robust human resource application and management reporting tools.
- Also led an effort to implement an agency wide time reporting system.
- Crime Victims, Human Resource, Consumer Complaint and Juvenile Justice/Missing Children Applications
- Performed analysis, development, testing and implementation using Visual Basic 6.0 on SQL Server 6.5 and 7.0 databases.
- Completed project over two months ahead of schedule.
- Worked with HTML, DHTML, XML, and JavaScript languages.
- Fixed and enhanced other systems using Visual Basic 6.0 on a SQL Server 6.5 database.
- Designed and developed component-based, n-tier and distributed applications that account for communication protocols, security, data access strategies, and transactional considerations.
- Wrote HR application from scratch using Visual Basic 6.0 on SQL server 6.5 database.
- Wrote SQL queries and Stored Procedures.
- Provided extensive mathematical formulation to determine crime victims' potential loss and recovery reimbursement.
- Developed object-oriented and component-based software.
- Met with users Crime Victims Unit to determine needs and update specifications.
- Developed COM objects using Visual Basic 6.0.
- Led a team of three programmers and one tester.
- Acted as mentor for junior programmers and DBA's.
- Wrote several web based Intranet and Internet applications using ASP, HTML, CSS, JScript, VBScript and SQL server 7.0.
- Developed applications using COM, DCOM, and MTS/COM technologies.
- Developed and coded agency wide employee time keeping system for the Intranet.
- Member of WWW Technology committee responsible for advising and improving current Internet and Intranet infrastructure.
- Helped develop standards and procedures for ongoing development environment.
Confidential
Consultant/Team Lead/Analyst/Programmer
- Provided technical mentoring and supervision to programmers and DBA's on the PESS and RIO projects.
- Integrated PL/SQL in Visual Basic applications.
- Rewrote project plans to help shore up dates and milestones.
- Performed code reviews and status reports for management on weekly/daily basis for both the project and for the programmers.
- Helped set standards and provide common tool sets for client server developers.
- Mentored and assisted developers in their day to day work.
- Provided technical mentoring and supervision to programmers and DBA's on the PESS and RIO projects.
- Integrated PL/SQL in Visual Basic applications.
- Rewrote project plans to help shore up dates and milestones.
- Performed code reviews and status reports for management on weekly/daily basis for both the project and for the programmers.
- Helped set standards and provide common tool sets for client server developers.
- Mentored and assisted developers in their day to day work.
Environment:
Confidential Sr. Systems Analyst/Team Lead
Records Management System
- Led consulting team for the firm's document management software and hardware systems.
- Performed Object-oriented and component-based software development.
- Performed individual instructions as well as group seminars on UNIX, 4GL, VI, Intersolve's DataDirect, Distinct TCPIP, DBAACCESS, EditPro, PVCS, various editing applications and custom tools.
- Interviewed and mentored new programmers with comprehensive training concerning overall project needs and goals.
- Responsible for converting two of the systems from the FoxPro databases to the Informix database using Access, Unix Scripting and 4GL as conversion tools. These conversions required some enhancements to the ICTL system.
- Developed applications using COM, DCOM, and MTS/COM technologies as well as HTML, DHTML, XML, and JavaScript languages.
- Converted old legacy inventory control/records management systems from the old Chemical/Chase merger. Most of the systems were written in early versions of Visual FoxPro and needed to be converted to Chase's new ICTL system.
- Designed and developed n-tier, component-based, distributed applications including security considerations, communication protocols, transactional considerations, and data access strategies
- Added a module for mainframe development after the implementation was completed.
- Explored data access by using ADO, RDO and trying Informix-CLI drivers to setup DSN's.
- The team inherited Chase's Imaging system as part of the overall responsibilities.
- Wrote and maintained several Informix Stored Procedures for the system.
- Managed, developed and maintained all of the client/server applications and imaging software/hardware for the Records Management team. This included a file inventory control that managed over 4.3 million records that also had integration built in for Chase's Workflow systems.
- Upgraded all of development PCs and operating systems from low end Pentium systems running Windows 3.1 to NT with adequate hardware. This task included fixes and enhancements to get the front-end Visual Basic 3 applications to run correctly on a 32 bit environment. This project later included consulting with Technology support from other sites as they were upgrading to NT.
- Developed prototype application to upgrade existing client/server applications. This included all applications for the Customer Service, Records Management, and Optical Storage Management. The upgrade prototype consisted of Visual Basic 6, C/C on an Oracle gateway server interfacing with Informix. This prototype included the upgrade of all of the third party utilities used in front end processing including Irma terminal emulation and Distinct TCP/IP to Reflections and other native Visual Basic controls.
- Imaging responsibilities including maintenance of four optical jukeboxes, storage manager software, OCR technologies and integrated Floware routing for almost 4 terabytes of images in a .tif format. All of these systems used Visual Basic 3 as a front end and ESQLC, 4GL and Unix Script for batch/backend on an Informix 7.x to 9.x database.
- Extensively used ADO, VB Scripting, and Microsoft Active Server Pages ASP .
- Lead position over 4 consultants and 2 full time employees overseeing all project oriented work for the team.
- Developed and maintained a Task Manager application for the corporation to handle all projects, fixes, enhancements and help desk tickets for all client/server development. This application was written in Visual Basic 6.0, C/C with an Access backend.
- Upgraded Informix database to Oracle and lead an effort to upgrade application software to Java/Forte technologies.
- Successfully completed many different conversion projects from firm's loan acquisitions and mergers.
- Responsible for all database and imaging related processes.
- Worked with Visual Basic 3 4 16 bit on an Unix/Informix backend with all batch application written in ESQLC and Informix 4GL.
- Volunteered for instructing evening and Saturday classes in Visual Basic 3/4/5.
- Developed and coded fixes and enhancements for a file tracking system for the Records Department.
- Performed code management using Visual Source Safe.
Environment:
Confidential
Consultant/Programmer/Analyst
Worked with the Y2K team as an analyst for a customer support application using COBOL and CICS
Environment:
Confidential
Consultant/Programmer/Analyst
Designed and implemented an Overdraft Tracking System for a large bank in downtown Columbus. This system was written in Visual Basic 5 and included many intricate modules including giving the user the ability to dial in to remote credit services to upload/download customer information.
Environment:
Confidential
Consultant/Team Lead/Mentor
- Taught an intermediate class for Visual Basic 3, 4 and an introduction to Visual Basic 5.
- Developed and wrote a corporate wide OA office automation system for company. This project included a Visual Basic 4 front end with an Access backend.
- Involved with the Education, Development Center and Mentor committees.
Environment:
N. Confidential
Programmer / Analyst
- Developed and maintained a warehouse inventory control system for all parts, pre-order parts and custom fabrication items for the major equipment division of the company. The systems were first written in Paradox and then converted to a Visual Basic 3 front end with an Access database.
- Developed and maintained a Quote/Order system for the Sales Department. This system was also written in Visual Basic 3 with an Access back end.
- Acted as sole client / server programmer for the company.
Environment:
| |
|
|
|
|
|
|
|
|