SKILLS
* Exceptional business analysis or requirement analysis skills combined with strong database and software application design & development skills.
* Over 15 years experience with full SDLC (software development lifecycle)
* Expertise in relational database architecture; data modeling, data analysis, data conversion, data validation, database reporting; database performance tuning; Oracle upgrades; data warehousing; SQL; browser based web & n-tier client server application development; QA & validation management; connectivity technology (e.g. TCP/IP, Named Pipes, TNS, FTP, ODBC, JDBC)
* Proven analytical & problem solution skills; identifies issues & articulates solution strategies to resolve software & hardware problems across varied platforms; effective use of data management processes & tools; history of innovation & creativity.
* Expertise working with intercultural and globally dispersed teams
SOFTWARE
Operating Systems
MS Windows 3.0, 3.1, 95, 98, 2000, NT, ME, XP, Vista) Macintosh; OS/2; Linux; LAMP; Unix
Programming
PHP, PEAR, HTML; DHTML; Ajax; JavaScript; css; rss; Java, XML, TCL, Open ACS; SQL, PL SQL; Transact SQL; Visual Basic 6.0 with focus on ADO; .asp, .Net, Crystal Enterprise, Visual C++, C, UNIFACE, UML, DDL, Perl, ASP, COM/DCOM
Databases
Oracle 10g database & earlier versions, Oracle Enterprise Manager, Oracle SQL Plus, , ETL, Microsoft SQL Server; MySQL, PostgreSQL, DB2, Solid, MS Access, SQL*Net, Enterprise Server, Oracle tools, Toad Data Modeler, Visio, Case Logic Data Modeler, familiar with CA ERwin and Rational Rose Data Modeler
QA& Source Control Tools
SVN, CVS, RCS, PVCS Tracker, QARun, QATracker, TeamTrack, Perforce, MS SourceSafe
Other
Fusion Charts, JDBC, ODBC, Crystal Reports; Toad; Jakarta; Apache; Tomcat; Oracle 9i Application Server; Visio; Siebel, Intel's PDK & Video Conferencing; NetMeeting; ActiveX Control Pad; Adobe PageMaker; Quark Express; CorelDraw; PhotoShop: Lotus Notes; ACT!; MS Project; MS Office Suite; WordPerfect; MS Outlook, MS Internet Explorer, Netscape, Mozilla Fire Fox
SPECIAL TRAINING
Oracle 9i and 10g training at Oracle University in Bangalore, India; March to July 2003
RELEVANT EMPLOYMENT
Oct. 2007 to present – Sr. Systems Analyst, Los Angeles Unified School District, Los Angeles, CA
Senior Systems Analyst/Architect, contracted consultant under SAI Database Experts.
Projects
Developed/analyzed data models and application GUIs for:
* Hierarchical division-wide goals reporting website for top executives
* Internal intranet system for IT contractors to record hours worked, and to manage invoicing and payments.
* Online invoice system for construction contractors to make payment requests for LAUSD construction projects.
* Online handling of the construction project bidding process
Projects included business analysis and requirements gathering for complex sets of business rules; analysis of existing Oracle database objects and data relationships; creation of data model to integrate with existing user, contract, and project and invoice data and to provide functionality specific to each new or re-vamped application; data conversion as required.
Architect Browser Based User GUIs
Design and development of the user GUI and system functionality for the above systems using Oracle SQL, stored procedures, triggers and packages, TCL, HTML, css, javascript. LAUSD uses the Open ACS environment with AOL server and TCL for web development. Systems include reporting modules with Crystal Reports and/or Fusion Charts.
Sept. 2003 to present – Web Application Architect/Developer, SAI Database Experts, Beaverton, OR
SAI Database Experts is a web design and web application development consulting firm specializing in database and web application development, as well as reporting solutions including Crystal Reports 10, business analysis, browser-based GUI design, database design, database analysis, data conversions, and data validation. SAI Database Experts supports Oracle, MS SQL Server, MySQL, PostgreSQL, PHP, PEAR, Ajax, Java, JavaScript, css, HTML, DHTML. SAI Database Experts is developing a suite of business web applications designed to meet the needs of smaller businesses.
Database Consulting
Provides database consulting services for a number of clients, including the City of Portland. Services include: business analysis, data modeling, data conversions, database analysis, database application architecture design and development.
Web and database architect/developer
Designed and developed dynamic data driven websites and eCommerce portals using dynamic HTML and PHP hosted on Linux with Apache, (LAMP) designed and developed backend company and client databases in MySQL and PostgreSQL. Installed and customized osCommerce, phpBB, phpWiki, Mambo and other PHP based open source applications.
Provides a hosted solution for small businesses that includes web hosting and domain registration, Linux based server administration, a suite of near off-the-shelf web applications for small businesses that include highly customizable systems for:
• website content management
• membership registration
• transaction and online payment handling and tracking
• event scheduling and calendar
• online posting for jobs, matrimonial, classifieds etc
• online photo gallery system
• online meeting minutes system
• user management and tracking
Oct. 2000 to July 2002 - Software Engineer, WebTrends Inc. / NetIQ, Portland, OR
WebTrends produces web analytic software for businesses. In 2000 they developed a data warehouse, WebTrends Webhouse, with several supporting applications collectively WebTrends Intelligence Suite to integrate website visitor data with customer data via a Siebel conduit for corporate users. Customers wanted a customizable reporting solution using Crystal Reports.
3-Tier Client Server VB/Crystal Active X database application architect/developer
Performed business analysis for a new reports based software product. Prototyped a 3-tier client/server database application using Visual Basic & Crystal ActiveX for WebTrends to meet user requested functionality.
The prototype was developed into WebTrends Report Designer v.1.0. Architeched WebTrends Report Designer database in ORACLE & MS SQL Server; wrote PL/SQL & T-SQL stored procedures & packages for application classes, functions & reports; designed WebTrends supplied reports; validated database & application components for compatibility with ORACLE v.8.0.15 to 8.17 & SQL Server v.7.0 & 2000, (i.e. VB, Crystal, other third party .dlls & ODBC drivers in supported operating systems: Win 98, 2000 & NT); created SQL scripts to automate database creation during installation. Lead developer for WebTrends Report Designer v.2.0. Image below is a screen shot of application with open report.
Web application Java developer
Programmed J2EE classes, UI panels, web servlets & reports for the future WRC v. 5.0 w/ Borland’s Jbuilder & Jakarta Tomcat w/ data entry & retrieval from My SQL, Oracle & MS SQL Server databases using JDBC. Developed UI & DB reporting components.
Apr. 2000 to Aug. 2000 - Oracle & Crystal Reports consultant, Hopkins Manufacturing Inc., Emporia, KS
Hopkins uses IFS, a third party ERP software system that incorporates Crystal Reports into its UI. Data was migrated & converted from a homegrown AS400 system into the vendor's Oracle database. Hopkins experienced excessive and ongoing performance problems. IFS claimed issues were caused by poor network configuration, inadequate server hardware, inadequate in-house Oracle DBA & Crystal skills, & unique business practices. IFS charged Hopkins high consulting fees & ongoing custom maintenance fees to "fix" problems as custom modules; but performance problems persisted. Hopkins invested in new equipment & employee training.
Originally trained staff in Crystal Reports & Oracle, but found key IT staff had adequate skills. Further investigation of performance problems warranted analysis of the IFS database design. IFS was unable (or unwilling) to provide a data model of their database. Analysis determined performance issues were caused by improper application of relational theory & poor database design, plus an unusual application of the Crystal ActiveX functionality that dramatically increased report generation time. Provided Hopkins with a data model & documented design problems to provide Hopkins with a means to negotiate less costly solutions with IFS until the underlying design issues could be fixed. As a work-around for improper integration of Crystal reports into the IFS UI, designed & developed a Visual Basic application with an Access database to allow scheduled batch printing of Crystal reports outside IFS & when network & database traffic was lowest.
Nov. 1997 to Mar. 2000 - Software Engineer, Universal Algorithms/Collegenet Inc., Portland, OR
Universal Algorithms produces Series 25 software used by universities. Resource25 (R25) is a 3-tier client server application for event scheduling. R25 is developed using Compuware's UNIFACE, a platform independent object oriented development tool. R25 interfaces with student information systems, like PeopleSoft. In Nov. 1997 R25 had few internal reports that were inaccurate. Users wanted better reporting capabilities using Crystal Reports. Database support included Oracle, SQL Server, DB2, Sybase, Informix & Compuware’s Solid DB.
Performed business analysis to determine user requirements for a new report delivery and management module to be added into their existing software. Designed & developed R25 reporting GUI to allow: integration of custom reports & selection parameters; use of R25's internal query engines to process data for enhanced performance & enforcement of R25's security. Developed Crystal reports for R25 that included multiple data groups & sub-reports with parameters & formulas to pass calculated data between the main report & sub-reports; formulas to convert date & boolean values to comply with all supported ODBC databases; formulas to retrieve data via date criteria where no actual date value existed, but was implied. Resolved connectivity issues between R25, Crystal & ODBC. Installed & maintained Oracle & SQL Server development databases on Linux & NT servers; performed DBA duties. Installed & configured R25 on several OS platforms and databases; configured ODBC client tools & Windows ODBC data sources for the Crystal Reports print engine. Tested R25 Webviewer, an interactive web application interfacing with R25's database using Apache web server, on several platforms, including Macintosh, & with several versions of Netscape & MS Internet Explorer. Trained internal technical staff to use Crystal Reports & the R25 reporting UI to add custom reports & user defined parameters. Designed & developed an in-house custom bug tracking system with Compuware's QATracker & automated testing scripts using QARun to interface with target application's code to create automatic testing scripts.
Jun. 1997 to Oct. 1997 - PDK 3.0 Beta Coordinator, Intel Corporation, Hillsboro, OR (5 month contract)
Interfaced between PDK engineers & PDK 3.0 beta (Intel's ProShare Developer's Kit) users worldwide. PDK is a programming tool for Visual Basic, Visual C++ & Delphi developers to allow development of custom applications around Intel's ProShare Business Conferencing technology & Microsoft's ActiveX.
Maintained PDK beta data; was liaison between PDK 3.0 beta users (software developers using the PDK ActiveX controls in their programs) & Intel PDK engineers; resolved technical issues; participated in quality control reviews; qualified bugs & increased beta participation & feedback. Designed & developed VB 5.0 applications using PDK & ActiveX controls; architected an Access database for a client project and assisted programmer in developing recordsets, tested VB tutorial & sample; tested HTML tutorial using Microsoft's ActiveX Control Pad; operated Business Video Conferencing software in several PC environments to determine operational stability & system compatibility; resolved issues related to ISDN or TCP/IP connections.
Feb. 1995 to Jun. 1997 – Help Desk Manager & Senior Support Analyst, Strohl Systems, King of Prussia, PA
Strohl Systems produces BIA (Business Impact Analysis), a specialized database application for business impact analysis, & LDRPS (Living Disaster Recovery Planning System), a structured relational database program for business continuity planning & risk management. LDRPS is the leading software used by the risk management industry and provided OLE linking, user defined security, database customization, database maintenance utilities, import/export templates, customized reporting & report management with Crystal Report Writer Professional. Strohl software is its industry’s leader. Strohl software was developed with Visual Basic.
Provided high level technical support for Strohl’s suite of software products; managed help desk personnel; developed standard help desk procedures to meet growing international business requirements & ISO 9000 standards; helped train international distributors in technical support strategies, was a liaison between program developers & Strohl consultants, sales personnel & customers. Designed an in-house knowledgebase with incident & call tracking applications and guided a Lotus Notes programmer to develop it. Developed Q/A standards and assisted in development of automated QA test scripts & procedures.
Performed data model analysis; designed a data conversion application for a major product upgrade; performed data conversions & validation; key player in database design & development cycle; validated data modeling; resolved conflicts related to: .dll versions, installation, .ini files, system configuration, network rights & connectivity in client/server environments; developed custom Crystal Reports; analyzed application functionality to met customer usability objectives.
Visited client sites on consulting assignments for data scrubs, data conversion and validation or data integration with other internal databases. Provided disaster recovery expertise for fortune 500 clients & Strohl consultants to perform business impact & continuity needs analysis & to develop viable business continuity plans for effective response, recovery, resumption & restoration plans.
May 1993 to Jan. 1995 – Documentation Manager, Clinarium, King of Prussia, PA
Clinarium offered a suite of database applications for the pharmaceutical industry: ARIS (Adverse Event Reporting System), TRIALS (a system for medical trials reporting), and PILLS (a system for international pharmaceutical labeling.) The backend database was Oracle and the systems ran on a Sun Solaris platform.
Clinarium was an Indian owned company. Software developers were mostly Indians living in the U.S. Front office, customer support, data validation consultants and marketing were staffed by Americans and Europeans. Programming was done by teams in India. Initially, India based programmers each wrote documentation for modules they developed. Every chapter was formatted differently then these individual files were merged into one large Word document with no index or TOC. The writing consisted of long run-on sentences with an over abundance of prepositional phrases. U.S. based software users accustomed to reading concise how-to documentation, were unhappy with Clinarium’s software documentation.
Worked directly with India based programmers to re-write Clinarium’s documentation to meet U.S. standards. Learned SQL to validate the Oracle database mapping on various reports to meet strict US FDA regulations for data validation. Set documentation standards & trained India based teams to maintain that standard.
Supported the development team with Visio representations of database & application schemas. Supported data validation consultants w/ resume scrubs and provided other project specific documents, helped manage staff schedules. Supported company executives by producing project proposal, project scope and legal contractual documents. Supported the marketing team by designing and developing marketing materials w/ Photoshop, PageMaker and other graphic and publishing software.
