Systems Analyst Resume
SUMMARY:
- Database / DOT NET developer with an outstanding track record at medium and large scale companies working on a diverse set of business applications.
- Experience in building Web based Management Dashboards and Reporting systems.
- Back End Developer with ASP.Net web development experience.
- Expert level with SQL Server Jobs 1,2,3, 4, 5, 6, 7
- Intermediate level SSRS and SSIS Jobs 1, 2, 3, 5
- Expert level with VB.Net Development Jobs 1, 2, 3, 5, 6,
- Intermediate level C# Development Jobs 4, 5 knowledge of Object Oriented Design and MVC.
- Experienced in using Software Development Lifecycle Methodologies (SDLC) to communicate business requirements to co - workers, users, and management.
- Experience with Offshore management of IT staff
- Able to learn new technologies quickly to meet the needs of the client
- Application areas include Health Insurance, Retail (front and back office), Sales, Quality Control, Inventory and Warehouse Control, Financial, Order Entry, Insurance. Email campaign management with response collection.
- Source management with TFS and SVN
SKILL:
- SQL Server TSQL, Stored Procedures
- Sequel Server Reporting Services (SSRS) and BIDS
- Sequel Server Integration Services (SSIS)
- VB.NET
- VB6
- C#
- ASP.NET
- HTML, JavaScript, XML
- Content Management DotNetNuke Web Portals
SKILLS/TECHNOLOGIES USED:
Tools: ASP, ASP.NET, VB, VBA, VB.NET, C#, HTML, JavaScript, CSS, AJAX, Web Services, TSQL, Stored Procedures, Database Triggers, Views, XML, Bing Maps API, Google Maps API
Databases: SQL Server 2000, 2003, 2005, 2008 and 2012, MS SQL Reporting Services (SSRS) / with BIDS and SSIS, Access Forms and Reports, Informix Online 6, 7, 8, 9, Cognos Database Modeler, Framework Manager and Report Net, Content Manager Report Studio and Query Studio
Software: Visual Studio 2005 thru 2017, Visual Source Safe, Subversion, SQL Enterprise Manager, IronSpeed Web IDE, SEI SDLC, EDS SDLC, IIS version 6, Office 2007 VBA, Crystal Reports, Adobe PDF, ArcIMS, TrakIt GPS, MapPoint. MapInfo, IS and Apache web servers, Kronos Time and Attendance, SharePoint, Visual Interdev, Microsoft, CRD Crystal Reports Scheduler, Microsoft Web Expressions
Source Management: Team Foundation Server, Subversion
PROFESSIONAL EXPERIENCE:
Systems AnalystConfidential
Responsibilities:
- Maintained and Developed C# programs and SSIS packages used to process customer files for delivery to the correct United States Postal facility.
- Daily FTP of csv flat files and conversion to SQL Server database processing tables.
- Labeling and USPS tracking files were created so customer packages could be tracked. Many daily processes to get truck loads of packages to the USPS for individual address delivery.
- Support for man SSIS packages that were used with the C# programs to handle the 2 to 5-day life cycle of a packages.
- SQL stored procedure problem resolution.
Confidential
Responsibilities:
- Created SSIS project for their customer Anthem. Automatically sent summary report of monthly Confidential invoices. SSIS with VB code to create custom Excel file. The files were emailed.
Confidential
Responsibilities:
- Maintain existing VB.NET Windows forms application and Enhancements.
- Worked with two developers in Brazil. After 1 year, I took over their responsibilities.
- Developed a universal error handler for both logic and system errors. The errors were logged to the database and displayed a friendly message to the user.
- Converted the desktop application to run on Citrix Servers
- Code changes to increase the speed of calculations by 40%
- Changes to use Tax values from Sabrix mainframe system instead of using local tables. Used “REST” type web services to retrieve data from the mainframe.
- New Quote export to Excel and conversion to PDF. Done with Microsoft Office Automation API instead of third party applications.
- Implemented a “Goal Seek” pricing function for “What if” sales price adjustments.
Confidential, Romeoville, IL
Responsibilities:
- Converted Source Safe to Team Foundation Server allowing faster access for Offshore India developers and QA employees
- Lead Developer coordinating Offshore Communications to 11 employees in India. 2 Developers and 9 Quality Assurance
- Technical Lead for VB 6 to VB.NET conversion of ticket printing system for Long Island Railroad.
- Used SQL Server 2012 with Sequel Server Reporting Services, SSRS, and Sequel Server Integration Services, SSIS to manage large customer files received daily.
- Maintained and created VB programs that support the production of credit cards for multiple customers
- Maintained and improved Customer Facing and Internal Web sites to High Security Standards set forth by Confidential .
- Use traditional Waterfall SDCL using a Confidential corporate standard.
- Used HP Quality Center for testing and defect management.
- Worked with both Offshore and Onshore Developers and QA testers to ensure quality of delivered systems.
- Handel production support for finding System problems.
- Worked with Business Analysts and project Stake Holders to create Technical Specifications for medium size projects and medium risk.
- Communicate well with developers and users.
- Learned to maintain a complex job management system that processed customer files daily.
- Used HP Fortify program scanning tool to find security flaws and make indicated corrections.
Job Environment: SQL Server 2005, 2008 and 2012 with SSRS/BIDS, SSIS, VS2012, VB6, VB.NET
Consultant
Confidential, Oakbrook Terrace, IL
Responsibilities:
- Modified current Reports in SSRS using Report manager and web VB client code.
- Converted Crystal reports to SSRS reports with BIDS.
- Worked with SDLC design Documents for Report and Functional specifications.
- Converted stored procedures from old to new database format
Job Environment: SQL Server 2008 and SSRS. VB.Net VS2010.
Systems AnalystConfidential, Aurora IL
Responsibilities:
- Set up and managed Dynamic Email Campaigns for multiple clients using Campaign Manager by Arial software.
- Converted list of email recipients to SQL Server to be used by the Campaign Manager.
- Developed and installed Micro web sites using Asp.Net version 4, C#, Visual Studio 2010 and SQL Server 2008 .
- Used the Adobe CS6 suite of tools to create html for emails and web sites.
- Provided tracing of email open an click through tracking for campaigns that I worked on.
Job Environment: SQL Server 2008, C#, ASP.NET, Email Marketing, ADOBE Software, VS2010
Consultant
Confidential, Naperville, IL
Responsibilities:
- Worked with a small team building & supporting applications that support medical benefits investigations on the behalf or Drug Companies and their Sales Forces
- Web portal development for client companies using the Open Source Content Management System DotNetNuke and SharePoint.
- Responsibilities include unit testing, integration and system testing of assigned modules, software implementation tasks, source control and deployment activities, Subversion and Team Foundation Manager
- Cognos7/8, including Framework Manager and ReportNet Created database models to be used by Cognos Content Manager Report Studio and Query Studio. Reports displayed in SharePoint and DNN.
- Integrated Cognos’s reports to DNN Web Portal and SharePoint using Web Services and Windows Network Services.
- Developed middle tier objects such as web services, data access objects, business logic layers, etc. in C# and VB.NET
- Translated business requirements into functional code
Job Environment: ASP.NET, VB.NET, C#, HTML, JavaScript, CSS, Dot Net Nuke, SharePoint, Web Services, SQL Server 2003/2008 and with TSQL, Stored Procedures, SSRS
Systems Analyst
Confidential, Bridgeview, IL
Responsibilities:
- Company intranet web portal - CMS to run Web applications.
- 3 - Tier Web Design
- Used SharePoint Web Services to access SharePoint 2007 Events for calendar
- Quality Control test data entry, maintenance and printing - 3 - Tier Web Design
- Developed from user specifications and included State of Illinois reporting
- Display and printing with Adobe PDFs
- Reports by selected time period and field criteria. User can run any time
- Quality Control complaint system - Replaced a paper file system
- Used by Quality Control technicians to record customer complaints
- Send email after entry to notify management of problems to be addressed
- Provide monthly summary reports by selected time period and field criteria.
- Employee Status Change system 3 - Tier Web Design with Web Services
- Record all new hire, terminations and payroll changes
- Provide emails to all company departments affected
- Include security by user access levels
- Provide first and second management approval based on type of change
- Returned/Rejected load entry and reporting 3 - Tier Web Design
- Allow data collection for returned deliveries
- Send emails on each entry for immediate resolution
- Sales mapping application 3 - Tier Web Design
- Compare distance of customer orders to various plant locations
- Plant Location Survey Library
- Storage and retrieval of property surveys
- Night Poor Notifications
- Sales mapping application 3 - Tier Web Design
- Compare distance of customer orders to various plant locations
- Plant Location Survey Library
- Storage and retrieval of property surveys
- Night Poor Notifications
- Central maintenance of remote location entry of off hours work
Consultant
Confidential, Homewood, IL
Responsibilities:
- Excel spread sheets programming for long term care centers
- Business applications developed on UNIX with the Informix database using 4GL and Visual Basic
- Cell phone repair center applications developed on UNIX with the Informix database using 4GL and FourGen software
- Statistical reports on phone repair center performance
- Enhancement of warranty claims process
- System Software upgrades on the application level
- All projects used SEI level 3 SDLC as a software development methodology
- Lead developer for one junior programmer
- Job Environment: Informix Database, UNIX, KSH, VB
- GE Financial Assurance, Schaumburg, IL ( )
- Auto Club applications developed on UNIX with the Informix database
- Developed a claim billing system to process Auto Club payments
- Designed and developed claims and dispatch statistical reports
- Designed and developed a Web site with ARCIMS GIS mapping software to show tow truck performance metrics
- Developed a VB6 application used by the Auto Club Tow Truck Network. Used MapPoint API and MapInfo tools to display activity by zip code
- Trained new programmers to take over systems maintenance
- Lead developer for two junior programmers
Job Environment: Informix Database, UNIX, KSH, Java, JSP, Apache, Tomcat, HTML