Professional with a Bachelors degree in Electronic Systems Engineer with 28 years of experience in Information Technology. Worked as a Software Engineer, Database Administrator, IT Consultant, IT/IS Operations Manager, Project Leader, and System Analyst in the Financial, Insurance, Marketing, Telecommunications, Health Care, and Construction industries.
WORK EXPERIENCE
| RealPage - Carrollton, Texas |
May 2009 – Present |
| Developer |
| |
Responsible for accounting web application's life-cycle using LAMP (open source Linux, Apache, MySQL, PHP) technologies and J2EE frameworks. |
| |
| CONCENTRA, Inc. - Addison, Texas |
December 2003 – January 2009 |
| Programming Analyst II |
| |
-
Responsible for the Batch Billing process, the back end of the Billing and Collections System (BCS) – provided support and maintained in PowerBuilder 9, C, Sybase DB stored procedures. Instrumental in designing forms/reports using C language to format text files with directives for the DOT Print Servers (Document Output Technology – Ricoh Corporation).
-
Produced JSP web pages to automate CAPS exception handling for the Business Analysts to directly manage.
-
Fully design and implemented a web service for the Billing and Collections system to be consumed by Business Analysts logging into this BCS application from the an EDI web Portal – this was all developed in ASP.Net/C#.
-
Tailored SharePoint templates with web parts and AJAX using C# for content sharing customizable and responsive to its users.
-
Developed JSP modules for the CAPS (Concentra Accelerated Productivity Suite) portal in close collaboration with J2EE team members to integrate Concentra Medical Exams, Field Case Management, and Telephonic Case Management. Provided support for CAPS in exception handling, and QA for load testing of the CAPS web portal by writing and executing scripts in LoadRunner (Mercury).
-
Performed the configuration and setting up of SUN Solaris servers with Sybase Open Client for C language for the BCS application, and Web servers with Weblogic, Tomcat for our CAPS system automation.
-
Effectively performed system analysis, design, development, unit testing, and maintenance/support of ClaimOPS patient entry system in Java JFC/Swing Client/Server application in coordination with other areas (QA, DBA, BA's and end users),
-
Effectively supported EDI (X.12, XML) applications and Gentran translator, developing new Unix/PERL scripts & PHP web app.
-
Innovated, through my own initiative, the Sarbanes-Oxley (SOX) reporting web application using JSP, iText & JavaDoc technologies to extract data sets queried from Oracle 10g databases to create the reports in different formats.
-
Created a responsive and dynamic web application called "Dashboard" to monitor Unix batch EDI scheduled processes permitting stakeholders and Business Analysts to check on the status of EDI (X.12, or XML files) events, fully Object Oriented designed and developed in PHP Ver.5.2.9/AJAX connecting to ORACLE 11i databases, with PDF reporting capabilities, and Image support (JPEG, PNG and GIF) by employing initially the native PDFLib extension library, and latter the FPDF (free PDF Generator) lib; sent e-mail alerts with warnings and errors of batch processes scheduled to run every minute on the hour, on a 24x7 schedule with down time programmed.
-
Efficiently and swiftly migrated the Dashboard to Ruby on Rails through rapid development, CoC methodology and the DRY principle.
-
Expeditiously created the Regulatory State Reports using Microsoft Reporting Services mining our EDI Oracle 10g databases. Created the Cross-walk SQL Server Packages to transform and port information from EDI to our data warehouse for Analytical processing to be performed by the Business Intelligence Team.
|
|
| |
| Compuware Corporation - Addison, Texas |
October 2002 – December 2003 |
| IT Consultant |
| |
Company: CardTrans - Responsible for documenting an IPC (Inter-Process Communication) credit card transaction application in UML for a company that processes credit card transactions through direct links or through the web. Documented socket, name pipes, multi-threaded, XML internal structures and communication messages between merchants in client companies, and ADO objects performed using Visual C++ as a tool, and having SQL Server as a DB repository. Provided application inventory, assessment, recommendations, and full application technical documentation. As an end result, the company was able to optimize their processes (were able to exceed Microsoft's limit on number of running threads) thus able to offer their business to companies that required resources that they thought were beyond their technical capabilities.
Company: Knowlwdge Base Marketing - Expeditiously designing, developing and implementing the New Geographic web application to obtain maps and demographic information sold to the company’s clients - designed and developed employing ASP with HTML/DHTML, JavaScript, VBScript, and Jscript. Wrote code, tested and implemented business rules in an Oracle 8i package with 12 stored procedures. Transferred the business rules from back-end Oracle database to middle tier, developing ASP VBScript functions to access an ORACLE CLOB in a table through the record set object and populating the client ASP pages. Modified JAVA applications that parsed XML files and reformatted them into JCL scripts to be transferred (FTP) to IBM 360 mainframe to be processed. These files formed part of the geographic application to obtain counts on selected demographic criteria and to generate orders with general public information for KBM customers (other marketing companies). Trained systems personnel in Stored Procedures (manipulating a CLOB) and on Regular Expressions using JAVA. Finished half a month before deadline, resulting in considerable saving to the company, and faster return on investment. |
| |
| AEGIS Communications Group, Inc. - Irving, Texas |
July 2000 – March 2002 |
| Software Engineer |
| |
Effectively analyzed and developed additional functionality, documenting, and maintaining the TIMEKEEPER application, which was initially developed by an outsource effort. Migrated the Kronos software from Informix/Unix based platform to a SQL Server/Windows 2000 application interfacing with TIMEKEEPER. These changes provided a more efficient way to track the time spend on work, breaks, lunch, etc. accrued by individual Call Center agents working in many States across the Nation. Additionally, the high performance rendered by the new Kronos/Timekeeper application permitted more flexibility registering agent time and ensuing a better tracking of activities and paying for the right amount of work hours, producing substantial savings to the agent payroll. Expeditiously designed, developed, unit tested & deployed a PHP sidecar reporting web tool designed for call-center supervisors to obtain and track work time of personnel at the different call centers throughout many states.
Applications maintained: Human Resources Tax Interface between Lawson and ADP (Informix C) and later rewritten in JAVA, back-end as well as Java Applets and JDBC to connect to Oracle DB’s, using Borland Jbuilder 5.0.
Applications Fully Developed: Automating the HR Personal Action Form to work as a web based work flow collaborating application (FrontPage, Visual InterDev) design with HTML and ASP/VBScript. Developed a system to send messages to pagers whenever there was a problem with the Data Bases, Applications or space on the File Systems, using the Unix SENDMAIL utility and C system calls.
Daily Functions: SQL Server DBA. Systems Support. |
| |
| RENAISSANCE Worldwide, Inc. - Carrollton, Texas |
March 2000 – June 2000 |
| IT Hourly Consultant |
| |
Instrumental in the design, building, implementing, testing, supporting, and maintaining the Security shared libraries and batch wrappers in C++ for diverse UNIX and NT environments (test, Development and Production) for EXCEL company. Also, I developed UNIX Korn shell scripts to automate existing processes and to update the Security Modules. I administered the Unix Test and development environments as well as maintain Btrieve (Pervasive) data structures (rebuilding files), at work and on-call support via remote access (VPN). |
| |
| DR. JAMES D. NELSON MD, PC - Philadelphia, Pennsylvania |
March 1999 – February 2000 |
| Analyst |
| |
Proactively engaged in consulting work as a contractor to fully automate existing medical business. Conceived, conceptualized, developed, implemented, and trained personnel in new 10-BASE-T local network system and customized software. Increased overall performance of clinic while reducing costs and duplication of work as well as use of paper products, installing MEDICALIS (Medical System), developing the Collections System using Erwin V.30 as a data modeling (CASE) tool, Visual Basic 6.0, SQLServer, and reports using Microsoft Crystal Reports. Set up a web site for the practice (using HTML, ASP/VBSript, and SQL Server 6.5), which you can review at: http://www.jamesnelson.neurohub.net
Additionally, put together a PHP web interface for the office manager to support , maintain, and correct corrupt data or with referential integrity issues with the SQL Server database. |
| |
| AETNA - Seguros Monterrey, S.A. (Insurance) - Mexico D.F.(city), Mexico |
May 1997 – March 1999 |
| IT Operations Manager |
| |
Responsible for managing 10 Computing Sites for the Financial Group, administering backups, coordinating the maintenance of hardware and site decontamination, etc. Managing the Help-Desk using REMEDY Request System as a tool, In charge of 65 persons between Mexico City, Monterrey and Guadalajara (Mexico). Some major projects include: Designed and Developed an Intranet application using HTML and ASP/VBScript to automate the issuance of paper claim reports to major departments, thus saving paper and pre-printed forms. Modifying input screens done in Visual Basic 3.0 and Access Data Base. Modifying input screens done in Visual Basic 5.0 and Access Data Base. Assisting in the Y2K Certification Project of all central applications on all computing sites and on different platforms for Year 2000 Compliance, this include repairing code for COBOL legacy applications, Client/Server systems done in Visual Basic 6.0 and Visual C++ 6.0, MS SQL Server, ORACLE, SYBASE, INFORMIX, FoxPro, Access, DB2, SISINF (4GL), INSUNIX, and in SmallTalk, repairing reports for Y2K compliance from all insurance applications done with Crystal Reports (Microsoft), Impromptu (Cognos), Power Play (Cognos), Powerbuilder (under UNIX), and Microfocus COBOL. Collaborating in installing a switched V-LAN. Support in a project to install a WAN based on Frame-Relay in all of AETNA's Regional offices across the country (Mexico). |
| |
| Credito Real, S.A. de C.V. (Credit Institution) - Mexico D.F. (city), Mexico |
April 1996 – May 1997 |
| IS Manager |
| |
In charge of Communications and Telecommunications (Configuring modems, Routers, HUBs, PBX, etc.) and System Applications in a LAN /WAN environment, which I migrated to Ethernet 10Base-T working with Windows 95 clients, maintained the Collections system. Analysis and design with CRC Object Modeling methods and development of the Data Score Client/Server System using Clarion 2.2 from TopSpeed Inc., Visual Studio 97, C++ 6.0, and SQL Server. Also doing upgrades, chip-ups, installing slave hard disks, etc. Created a dynamic web page in PHP to add users and their permission levels (roles) for the Data Score System. |
| |
| Grupo ICA, S.A. de C.V. (Construction Firm) - Mexico |
Octber 1994 – March 1996 |
| Systems Engineer |
| |
In charge of the Integral Treasury Systems, GL (General Ledger accounting System), managing the HP9000 series 827s and the Novell (Netware 3.11) servers and the Windows NT file sever, as well as all the equipment maintenance (such as personal computers, printers, modems, fax machines, scanners, MUXes, CD-ROMs, and other devices). I also became the System Administrator to the HP9000 series 890 and K200 servers. I developed the International Integral Treasury system. I also gave many seminars and training to financial personnel, high executives and managers about Internet and possible uses, such as Electronic Mail using Eudora, File transfers using FTP, and USENET servers using NNTP, Web Browsers like Netscape, Mosaic and Microsoft Internet Explorer, using GOPHER servers, etc. Some projects include:
• Maintenance and development of menus, forms and reports in ORACLE for the SIT (Integral Treasury System) as well as SIT International and GL (accounting system).
• Migrating ORACLE forms to Visual Basic 3.0 for SIT front end application.
• Replacing a Financial (investment) application for one developed using Borland DELPHI visual Pascal language.
• Created my first dynamic web page using PHP for IT to keep track of projects and workflow authorizations for managers. |
| |
| Financial Group INVERLAT (Brokerage Firm) - Mexico |
July 1990 – September 1994 |
| Computer Analyst/ Programmer |
| |
Resourcefully developing the Portfolio of Applications System to register all the systems that Inverlat's end users employ. Developing the Securities module interface program for S.W.I.F.T. (Society for Worldwide Interbank Telecommunications network). Developing programs destined to serve the traders and brokers working for the back offices of New York and London. Some Projects Include:
• Specifications writing for the transfer of files between different platforms of equipment for the system Electrobanca ("Electronic Bank"). (Systems Dept. in Multibanco Comermex, which is the bank of INVERLAT Financial Group) using RSC (communication between TANDEM and PC), SNAX / APC (communication between TANDEM and IBM), IXF (transfer of files between TANDEM and PC).
• Development of a module for the transfer and reception of Fax in a Visual Basic ver. 3.0 front end application for the Financial Floor system.
• Analysis and development of the module for S.W.I.F.T (Society for Worldwide Interbank Telecommunications network) made for the Securities Depository System.
• Analysis and development of the International System and the translation of the User's Manual from Spanish to English for the Back office in New York and London.
• Collaborating in the development of the system of Foreign Currencies which was destined to satisfy the needs of the Foreign Exchange Agency of INVERLAT and which it formed part of a larger integral system called System 90.
• Analysis and development of the Operative Finance System, which was a system for loans to companies by means of emitting notes. |
| |
| XEROX of Mexico SA de CV - Mexico |
October 1982 – May 1990 |
| Project Leader |
| |
Responsible for installing, setting up, configuring, programming, and maintaining the General Ledger and Fixed Assets systems all developed in JCL/COBOL and IMS database on IBM 4381 and 3090 mainframe; Leader in implementing an Executive Information System (EIS) for Business Intelligence called Texas Instruments IEF specifically designed for XEROX’s high ranking executives. |
| |
EDUCATION
| Bachelors Degree - Monterrey Institute of Technology - Estado de Mexico, Mexico |
Completed: June 1987 |
| Major: Electronic Systems Engineer (3.85 Overall GPA), Minor: Systems Engineer |
| |
| DREXEL UNIVERSITY - Philadelphia, Pennsylvania |
* Did not complete - end date: June 1981 |
| Major: Electrical Engineering |
* Note: cooperative experience, i.e. working one trimester, and studying the bext, for about 3 years worth of credits. |
| |
| High School Diploma - Moorestown High School - Moorestown, New Jersey |
Completed: June 1978 |
| Major: Math/Science |
|
| |
TRAINING
| TecFocus - Dallas, Texas |
Completed: March 2002 - April 2002 |
| Administering SQL Server (towards MCDBA) |
| |
| Southern Methodist University (SMU) |
Completed: March 2000 - May 2000 |
| Unix Shell Scripting, Programming in C / C++ , and PERL |
| |
SKILLS
Computer Skills |
C/C++,UNIX (ksh, csh, bash)/Linux/Solaris/HP-UX, unix shell scripting, PERL,PHP/MySQL/AJAX/JScript(Server)/JavaScript,JAVA,JSP,ASP (classical),.Net/C#,SmallTalk,SQL Server, Oracle, Oracle Financials, Sybase, Informix, MS Access, COBOL – many flavors: TANDEM requestor/server non-stop, Microfocus COBOL, and for IBM mainframes, LISP, SmallTalk,(VisualWorks, Squeak), ALGOL, FORTRAN, DELPHI, Pascal, Prolog, HTML/DHTML/XML,EDI(X.12)
Scripting
Unix shell (ksh, csh, bash), JavaScript, Jscript (server), PERL, Phython, and Ruby (RoR - on Rails)
Tools
Eclipse (java or PERL), Borland jBulder, WaveMaker (web java, web services IDE Open Source), VisualWorks (SmallTalk)
|
Additional Skills |
- Main Frames ALTOS, SPERRY UNIVAC 1600, BURROUGHS A-9 5900 (now UNISYS), IBM 4381 and 3090, Cyber-970-32 from CDC (Control Data Corporation).
- Mini computers and servers HEWLETT PACKARD 9000 series K460 and V2200 (V Class), SUN E-6000 and E-10000, DEC Alpha Server 2000, TANDEM VLX, CLX and CYCLONE, IBM AS 400, Compaq Proliant 3000, HP Netserver.
- Micro computers PDP 11 with switch board and LEDs as a user interface (no keyboard or display), PC's such as Vectra, COMPAQ notebook, TOSHIBA laptop, TI laptops, etc., APPLE 2E and MACINTOSH LC II.
- Work Stations Apollo SUN
- Sys Admin(Unix),Net Admin (CISCO Routers,Wireless, Bluetooth,WiFi,Install hubs and Switches for 10-Base-T/100-Base-T)
- Building Desktops from components(Chip-ups, hard-drive and memory installations)
- Private branch exchange Systems Program PBX's like the Harris 20-20 Integrated Network Switch or AT&T Definity
|
Language Skills |
English – 100% Excellent ( Read Write Speak ), Spanish – 100% Excellent ( Read Write Speak )
|
AWARDS
| XEROX CorporaTION - Best Employee of the month (December 1989, March, May 1990, February 1991) |
This is a highly sought award given to one person each month that achieves the most in their category (IT) |
| |
|
|
|
Mauricio J. Solórzano
2436 Aberdeen Avenue
McKinney, TX 75070-9124 US
(972)529-2246 (Home)
(610)571-5623 (Cellular)
mauricio.solorzano@gmail.com
|
VIDEOS
|
GUESTBOOK
|
|
