Systems Analyst Resume Profile
Personal Summary
Looking to obtain a new position in information technology where I can apply my experience in full life cycle development from design to implementation. I am a versatile, loyal, and results - driven with almost 10 years of broad-based IT experience. I am an innovative thinker and have the ability to bring proactive, dynamic solutions to difficult and critical systems. Can give practical application to abstract thought, predict patterns, resourceful practical and can envision the big picture . I have demonstrated business acumen by effectively managing multiple tasks concurrently, working well with teams, adapting easily to new projects, and new technologies, and create entire systems in very short timeframes.
Work Experience
Confidential
Lead Software Engineer
- Security software company is a security software company for corporations, hospitals and colleges for employees and visitors
- Replaced one of the founding partners and took over all projects and products without any transition, training or documentation. Finished all remaining pending critical projects mid-cycle of their development with no source code comments and met a significant project deadline.
- Designed, developed and implemented mobile smart phone application for visitor management using .net compact framework for a device with built in drivers license scanner and WiFi card to handle and pre-register visitors and areas of building access for a quick mobile version.
- Instituted Microsoft SharePoint 2007 to control all development processes. SharePoint controlled the development process as well as customer support, documentation, installation, and training, in turn reducing project cost 2 fold. This was done by creating SharePoint Workflows in Visual Studio. The development workflow was based off a small business version of the Agile Development method as well as extreme programming.
- Created new development environment to handle 5 stages of implementation DEV,ALPHA,TEST,RC,PROD . Documentation, source code and installation source code was implemented into the SharePoint workflows. Source control was handled with Harvest by CA, and later Team Foundation Server 2010 BETA with SharePoint Integration.
- Created new ASP.NET visitor management system globally for Pfizer. Also created and designed AI match system customization which would automatically warn security of suspect visitors based on many criteria which were shown to end user along with percent match of algorithm. Database development was done in SQL Server 2005. System is capable of handling 10,000 concurrent users.
- Transitioned all projects to latest C .NET, ASP.NET, C .NET 3.5, Oracle 10g. Projects were initially written in VB6 and highly dependent on expensive third party components.
- Created security checkpoint software and High Roller Players Club database for the Mohegan Sun Casino. The systems had to work with their legacy AS400 system which was implemented with J2EE and C Web Services. Data files and images where highly confidential and were kept secure. Systems were written in C, Spring.net, nHybernate, C, and SQL 2008. The visitor management module for Foxwoods Hotel and Casino was also implemented from this source.
- Created employee and visitor management system for General Electric. Customization to handle contractors and support multiple languages was done with .NET globalization. Database packages, stored procedures were written in PL-SQL on Oracle 9i and 10g. System was written in C 3.5 and written using 5 layers of development. Presentation layer was designed skin-able so customer could choose either ASP.NET 2.0, 3.5 WPF, Silverlight 1,2 or 3 beta, or plain HTML. Second layer supported dynamic parameters coming for any of the chosen presentation layers and relayed to the third layer. Third layer consisted of all our common objects and transactions. Our 4th layer supported any mainstream RDMS. A lot of the coding and design was based on books from Rockford Lhotka's CLSA.
- All database scripts for Oracle, Microsoft SQL Server, MySQL, DB2 and Sybase were re-written to have a standard universal schema's. The SQL in Stored procedures were ANSI compliant so all products could work with any database. This cut down on development time and helped out installation and support and in turn saved 50 of project costs alone.
- Clients for products above included: UBS, Corning, ISO New England, L'Oreal, Merck, Pratt Whitney, Picantinny, Quest, Rutgers, Textron
- Created touch interface in WPF 3.5 and C for touch version interface. Also took advantage of new Windows 7 touch API and lesser Windows XP tablet framework.
- Created new product called NetworkWatch which was a computer network security system written in a client/server that monitors employee and visitor computer usage in depth. Data is sent real-time to server and reporting is viewed in a web manager. System hook dll was written in C .
Confidential
Software Developer
- The National Basketball Association is the very top sports entertainment company in the world.
- Developed new DTVI Data television interface platforms which send data created by NBATV Channel operators to Cyron graphics system where final output is scores and statistics during NBA games on cable tv and All-Star game. Was able to create auto event driven actions for player substitutions and score updates which in turn animated scoreboards and TV. some with sound for more active and attractive scoreboards
- Created ASP.NET mobile page for windows mobile phones as well as WEP capable phones for scores and updates on nba.com
- Created new schema for statistics for NBA.com on RDBS by tuning stored procedure performance, which increased statistical updates from 12 hour delay to a more acceptable instant real-time 30 second delay. Database users in hundreds of thousands, database size 1TB
- Created C .NET Web Services for worldwide real-time scoring distribution to sports news companies like ESPN. Objects were filled from our Sybase and Oracle backend and then serialized to XML files and sent FTP or Web Services via raw SOAP or binary depending on customer legacy preferences.
- Previously other NBA departments did not have real-time access. If real-time was needed they had to ad-hoc our production system. I created C .NET object which encapsulated all the low level api which was unusable to most users and now other departments could easily read and fill their proprietary projects and needs with scores, plays, rosters etc with real-time data via xml, Web Services or serialized objects without any due hardship on our real-time system or low level packet streams manipulation.
- Supported and developed internal ArenaNet Web application site for the NBA which Cable TV network and operators, Arena Supervisors, and Teams used for all day to day Arena level management. Web application was written in C and OOD.
- Lead technical resource and contact for all advanced issues including unknown problems causing nba.com performance issues ESPN's data rendering faster then NBA.com, virus attack and tracking, web services security, database security, websites security and prevention of XSS and SQL injection vulnerabilities to NBA.com and other external intranets and networks.
- Researched and developed a Microsoft Silverlight live game and statistics widgets for NBA.com.
Confidential
Sr. Systems Analyst
- Direct Energy is an energy company that trades natural gas and electrical power on the market for Canada and deregulated growth markets in the United States on the NYMEX
- Lead developer and Project Manager for all New England customer and billing systems. CT, RI, MA, NY, NJ . This was a real time application that integrated with new code I created in our Houston Trading platform in C and SQL Server 2005.
- Initial responsibility included seamlessly migrating an acquired company, Energy East Inc., and their system and business logic into existing New England system using C, CSLA Object Oriented Business Objects techniques. Handled data transformation process and EDI with SSIS service on Microsoft SQL Server 2005.
- Created web report writing system using parameterized reports created in Visual Studio 2005 for accounting and operational analysis in SQL Reporting Services 2005.
- Became a competent primary technical backup to our Houston trading platform system. This included training and becoming a backup in Java J2EE and Oracle in a small timeframe.
- Implemented product life cycle forms and documentation process for our flagship Toronto office Project Request Form, Project Change Form, Business Design Document, Internal Design Document technical and User Acceptance Testing Document . All documents implemented some extreme programming techniques. This in turn gave business and technical employee's responsibility to stages in development as well as documentation to projects.
- Database administrator and developer working in security, database modeling techniques such as 3rd normal form database normalization, mandatory/non-mandatory, identifying/non-identifying relationships and horizontal partitioning. SQL development with stored procedures, DTS packages, triggers, views and advanced joins.
- Spent 3 months performance tuning billing system SQL statements, execution plans, etc. Speed improvements were 500 across the board.
- Worked in system and network security, patching all possible 0day or not yet known attacks such as buffer overflows, XSS cross site/zone scripting, privilege escalations, DoS denial of service, and distributed DDoS.
Confidential
Senior Developer/DBA
- Moran Transportation is a large company that works in the shipping industry handling oil, liquid natural gas, container, and passenger ships for the East Coast, Gulf of Mexico and Puerto Rico and internationally abroad.
- Project leader on creation of new accounting, operations and billing system, designed and recoded the entire company's manual legacy billing system from AS400 into automatic billing system using C, ASP.NET and SQL Server 2000.
- Projects were completed using advanced methodologies such as OOD, inheritance, asynchronous sockets, multi-threading and COM .
- Constructed a native SMTP 15 step email filtering system for Exchange in COM with web page manager to stop worms and spam permanently using C, C and ASP.NET.
- Created CRM Customer Relations Management System for sales department in ASP.NET and SQL Server 2000.
- Created 24/7 network monitoring system for automatic alerts of network trouble by analyzing real time bandwidth to early identify issues on down lines and critical systems. Reporting is done via webpage manager with graphs and grids in C, ASP, SQL.
- Created replication process on SQL Server from our operation RDMBS DB2 and Oracle databases for real time data reporting and analysis thereby reducing load of our operational database and letting users ad-hoc freely.
- Database administrative duties included automatic disaster recovery, replication, installations, maintenance and backups.
- Saved almost a million dollars in IT software budget in 2 years by creating internal purchase order systems, billing systems and others with ASP.NET and Win Forms and SQL Server 2005 DB2 and Oracle.
- Handled database and network security. Involved testing and scanning for possible access violations. MSBlaster, SQL Slapper, Sasser and other worms were patched internally months before their actual release or any official patches were available.
- Systems Union, Inc. now known as infor Developer 5/99 - 5/00 White Plains, NY
- Systems Union is a worldwide accounting software company based in the UK. Also known as Sun Systems
- Part of 3 person development team for financial software company working in business development department.
- Worked for client, Pfizer Pharmaceuticals, on international platforms written in JAVA, COBOL VB on numerous additions and projects to the accounting system. Made major changes to lot control and general ledger, profit and loss statements according to specs given by Pfizer.
- Accreditations and Skills matrix
- Accredited in Wired Magazine for new security threat /politics/security/news/2007/12/aim hack
- Worked at Microsoft campus in Redmond to discuss security, Internet Explorer 7, and vulnerability disclosure process with MSRC and the Internet Explorer team after being the first individual to find a remote vulnerability in their multi-million dollar XP Service Pack 2 operating system.
- Been nominated into the Microsoft MVP program. Title is assumed higher then MSDB, MSCE, MSCD alike.
- I have been widely published on the internet writing security white papers for highly accredited security websites like Links to the papers can be found here:
- I have worked with secure microsoft.com and Symantec on security flaws found in their software which lead to system compromise.
- Was volunteer firefighter for Maywood Fire Department
- Programming language skills Programming Technologies and Methodologies
- Microsoft Visual C /VB.NET 6 years - eXtreme programming 4 years
- C/C /MSVC 3 years- - Object Oriented Development 6 years
- Java/VB script 9 year - Ajax/AJAX.net asynchronous java script 3 years
- Microsoft Visual Basic 3.0-6.0 9 years - Web Services 4 years
- Java/J2SE/J2EE/J2ME 3 years - SQL Server SSIS Services 3 years
- SQL-TSQL 7/8 8 years - Microsoft Click Once 3 years
- PL SQL/Oracle 3 years - CSLA 2 years
- HTML/DHTML/CSS 6 years - Windows Presentation Foundation WPF 2 years
- Active Server Pages/ASP.NET 6 years - Silverlight 1/2/3 2 years
- Assembly MASM 3 years - Windows Communication Foundation WCF 1 year
- XMLXLST 4 years
- Software, systems and platforms Network protocol development
- Visual Studio 2010b .NET 4.0 3 months - HTTP 1.0/1.1 9 years
- Visual Studio 00/03/05/08 7 years - SOAP 3 years
- MOSS SharePoint Server 2007 3 years - LDAP 4 years
- SQL Server Reporting Services 3 years - UDP 2 years
- Crystal Reports IX,2008 2 years - Telnet 3 years
- Microsoft Source Safe 6/2005/TFS 8 years - TCP/IP 8 years
- Windows 2000/2003/2008 server 9 years - OSCAR/TOC/ICQ 5 years
- IIS 4/5/6/7 9 years - DNS 6 years
- Microsoft Exchange 5-2K3-2008 5 years - FTP 8 years
- Ethereal/Wireshark packet engineering 6 years - COM DCOM 6 years
- UNIX/Linux 4 years - SOCKS4/HTTP Proxy 4 years
- IDA Pro/ollydbg/WinDASM 2 years - SMTP 9 years
- eNcase data forensics 3 years - Bittorent/libtorrent 3 years
- Microsoft Access 95-2007 9 years
- Networking System/Desktop administration
- Router/Switch setup/configuration 3 years - Active Directory setup/config/admin 6 years
- VLAN setup 2 years - Windows Domain Controller setup/admin 6 years
- Small/Mid network installation/config 5 years - Server format/setup/config/admin 6 years
- Pix Firewall configuraion/admin 3 years - ISA Server setup/config/admin 3 years
- VPN setup/config/admin 5 years - Exchange Server setup/config/admin 3 years
- SSH/TELNET 3 years - Gateway/IPTABLES/Snort IDS 3 years
- ISP integration/WAN/LAN setup/admin 6 years