Lead Consultant Resume
Santa Monica, CA
OBJECTIVE:
Secure a challenging Information Technology position commensurate with skill set that provides challenging work and professional growth opportunity.
PROFESSIONAL SUMMARY:
Over 15yrs of professional work experience in technically demanding positions. Extreme attention to detail coupled with solid leadership and interpersonal communication skills. Strong expertise in: Object - oriented programming, DBA, System Administration, Network management, Possesses a strong quantitative background in programming, database programming, and statistical analysis. Highly focused and disciplined with the ability to independently plan, manage, and execute multiple projects simultaneously, while also responding to any ad-hoc tasks.
TECHNICAL SKILLS:
Language: Visual Basic, C, C++, Fox Pro 2.5, Fox Prow 6.0, Visual Fox, Power Builder, Star Designer, Informatics Oracle Developer Forms and Reports, Java Script, HTML, PowerBuilder, C#, PL/SQL, SQL, T-SQL, SSIS, SSRS, Visual Basic, XML, VBA, VB Scripting, Adobe Master Collection CSS3, CCS5,CCS6, Macro, Python, PERL.
Software: MS SQL 6/5 Server, SQL 2005, SYBASE SQL 10.0, Oracle 8.1.6i, 9.0i, 10G and 11G, SQL Enterprises Manager, Service Manager, SQL Server BI Tools, Import Export Data, T-SQL, PL/SQL, MDX, Crystal Reports 9/10, SSAS, SSIS, SSRS, HTML, Dimensional Modeling, DW architecture, ETL Frameworks, Design and Development using Informatica, Informatica B2B, Troubleshooting.
Operating Systems: MSDOS, Windows XP, Windows 98, Windows 2003 Server and 2000 Server, Windows200, Windows 2007, Windows Vista, Windows 8, Unix/Linux system, file systems, shell scripting.
Hardware/Networking: Lan Work Place for Win3.11 and Windows 95, FTP, Cisco Routers, Switches, Vlans, Fiber Optic, UTP Cables cat 5 & 6, .NET., Networks LAN and WAN and communication protocols, Implementation of atmosphere protocol TCP/IP Windows, Handling of Software of Network Management CA-Unicenter TNG, Automatic distribution of Software, Services of Inventory of Software and Hardware, graphical interfaces for the handling of the SNMP in servants, compatible Routers, Hubs and devices with this protocol, Implementation and configuration of servers DNS, DHCP and WINS, VOIP, networking, routing experience, TCP/IP knowledge, Core Java programming, Java Programming and Queries Java.
SKILLS: Overall PL/SQL and SQL Server Performance tuning, DB tuning, Query optimization, Experience in PL/SQL and SQL development T-SQL, Views, Tables, SP, Triggers and functions, Indexing, Query plan analysis, DMV, Disk IO analysis, Migrating large quantities of data and writing complex queries for data analysis, BCP - migration, Informatics Resource monitor, PL/SQL, Shell Scripting, SQL Server Integration Services, SQL Server Reporting Services. SQL Server Administration - SQL Server configuration, Optimizing SP configure, Backup/Restore, DB move, File Group, database file allocation and optimization, Transactional Replication and Always on, Experience in PL/SQL and SQL Server analysis, SSIS, SSRS, design and implementation of ETL/ELT framework for complex warehouses/marts.
PROFESSIONAL EXPERIENCE:
Confidential, Santa Monica, CA
Lead consultant
Responsibilities:
- Created custom web interfaces using C# for users to map various fields between the client’s dashboard and their associated database. This in turn allowed client to efficiently respond to client’s request for customized fields and forms on their system.
- Conducted tuning of major databases, utilizing various tool sets (Oracle RMAN, SQL PLUS Scripts and Triggers, SSIS, SSRS and PL/SQL) Conducted backups, restores, and recovery disasters.
- Implemented SAN Storage management anti-viruses with automated run-times, firewalls, security integration: software, switches, routers, hardware, and data base.
- Implemented router with switch and anti-intrusion detection. Set up shared peripheral networking, integration for client server. Received telephone calls on hardware, software, and SNA and Ethernet problems; troubleshooting for root cause and resolution. Including LAN, WAN, controllers, lines, routers, terminals, and printer problems; software problems including file transfer using FTP; resetting VM and MVS passwords; resetting user ids through SNA and Ethernet connecting on VM systems.
- Suit Dreamweaver, Fireworks, Photoshop, Illustrator, Flash, Bridge, Contribute, After Effect, HTTP, HTML
Confidential, Los Angeles, CA
Senior IT System Administrator
Responsibilities:
- Main server installation and configuration
- Microsoft Exchange
- User Configurations
- Security (HTMS)
- System Administration (SQL), SSIS, SSRS and PL/SQL
- Unix/Linux (SQL PLUS, PL/SQL)
- Software Accounting installation and configuration
- Software Asset Management installation and configuration
- Networking Configuration
- Design and implementation of Corporative Website
- Programming and developer Tools of Office: Lotus, Project, Word Perfect, Visio, Corel Draw, Flow, News, Harvard Graphics, Mac Finish and Photo Finish, Office, Excel, PowerPoint, Access, Publisher, Office Pro, AutoCAD 2000, Rational Rose, Enterprise Manager, Photoshop, Suite Dream Weaver
- Implementation and Monitoring Networks LAN and WAN and communication protocols.
- Implementation of atmosphere protocol TCP/IP Windows Servers, printers and terminals
- VOIP, networking, routing implementation,TCP/IP and FTP transfers files
- Programming and Implementation of DUI (Unit Document Identity For Confidential )
- Implementation of Civil IAFIS for Unit Document Identity for Confidential: The Integrated Automated Fingerprint Identification System, or IAFIS, is a national fingerprint. IAFIS provides automated fingerprint search capabilities, latent search capability, electronic image storage, and electronic exchange of fingerprints and responses
- Implementation of Network Branch of RNPN-DUICENTROS (Registro Nacional de Personas Naturales) for El Salvador Government
- Implementation of SAP financial software for ISSS (Salvadorian Institute of Social Secure of Confidential )
- Implementation of Network and communication for Presidential and Deputy Election for Confidential TSE(Tribunal Supreme Election of El Salvador)
- Implementation and Configuration of Workflow Software Onbase OCR, Rational Rose and Enterprise Manager for Presidential and Deputy Election for Confidential TSE(Tribunal Supreme Election of El Salvador)
- Manager of Data Center of ANDA (Administración Nacional de Acueductos y Alcantarillados) for El Salvador Government
- Implementation and configuration of servers DNS, DHCP and WINS for ANDA (Administración Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)
- Programmer analyst in the department of informatics Development, Management of Computer science of Data Center for ANDA (Administración Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)
- Analyst in Committee of Improvement for Automatization Department of Credits and invoices of ANDA (Administración Nacional de Acueductos y Alcantarillados)
- Support for Update of Operating system in Servers NT, UNIX, HP SAN Storage for for ANDA (Administración Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)
- Data Base Administration for: MS SQL 6,5 Server and SQL 2005, SYBASE SQL 10.0, SSIS, SSRS and PL/SQL, Oracle 8.1.6i, 9.0i, 10G and 11G for ANDA (Administración Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)
- Data base SQL Developer, SSIS, SSRS and PL/SQL: Overall SQL and PL/SQL Server Performance tuning, DB tuning, Query optimization, Experience in SQL and PL/SQL development T-SQL, Views, Tables, SP, Triggers and functions, Indexing, Query plan analysis, DMV, Disk IO analysis, Migrating large quantities of data and writing complex queries for data analysis, BCP - migration, Informatics Resource monitor for for ANDA (Administración Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador) and RNPN (Registro Nacional de Personas Naturales)
- SQL DBA, SSIS, SSRS and PL/SQL: PL/SQL and SQL Server Administration - PL/SQL and SQL Server configuration, Optimizing SP configure, Backup/Restore, DB move, File Group, database file allocation and optimization, Transactional Replication and Always on, Experience in SQL Server analysis is plus for ANDA (Administración Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador) and RNPN (Registro Nacional de Personas Naturales)
- Administration Tools of Communication: Lan Work Place for Win3.11 and Windows 95, FTP, Cisco Routers, Switches, Vlans, Fiber Optic, UTP Cables cat 5 &6 for ANDA (Administración Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)
- Implementation and Monitoring Networks LAN and WAN and communication protocols for RNPN-DUICENTROS Branch.
- Implementation of atmosphere protocol TCP/IP Windows Servers and terminals for RNPN-DUICENTROS Branch.
- VOIP, networking, routing implementation,TCP/IP and FTP transfers files for ANDA (Administración Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)
- Programming and developer Tools of Office: Lotus, Project, Word Perfect, Visio, Corel Draw, Flow, News, Harvard Graphics, Mac Finish and Photo Finish, Office, Excel, PowerPoint, Access, Publisher, Office Pro, AutoCAD 2000, Rational Rose, Enterprise Manager, Photoshop, Suite Dream Weaver for ANDA (Administracion Nacional de Acueductos y Alcantarillados), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)
Confidential
Senior IT System AdministratorResponsibilities:
- Coordinator of Project and Implementation of software CA-UNICENTER TNG (Network Management) of the Confidential Bank (Cuscatlán Bank El Salvador).
- Handling of Software of Network Management CA-Unicenter, Automatic distribution of Software, Services of Inventory of Software and Hardware, graphical interfaces for the handling of the SNMP in servants, compatible Routers, Hubs and devices with this protocol.
- Implementation and configuration of servers DNS, DHCP and WINS
- Programmer analyst in the department of informatics Development, Management of Computer science of Data Center
- Analyst in Committee of Improvement for Automatization Department of Credits Confidential (Cuscatlán) Bank El Salvador.
- Support for Update of Operating system in Servers NT, Project 2000 Confidential (Cuscatlán) Bank El Salvador.
- Data Base Administration for: MS SQL 6,5 Server and SQL 2005, SYBASE SQL 10.0, SSIS, SSRS and PL/SQL, Oracle 8.1.6i, 9.0i, 10G and 11G
- Data base PL/SQL and SQL Developer: Overall SQL Server Performance tuning, DB tuning, Query optimization, Experience in SQL development T-SQL, SSIS, SSRS and PL/SQL, Views, Tables, SP, Triggers and functions, Indexing, Query plan analysis, DMV, Disk IO analysis, Migrating large quantities of data and writing complex queries for data analysis, BCP - migration, Informatics Resource monitor.
- PL/SQL and SQL DBA: SQL Server Administration - PL/SQL and SQL Server configuration, Optimizing SP configure, Backup/Restore, DB move, File Group, database file allocation and optimization, Transactional Replication and Always on, Experience in SQL Server analysis, SSIS, SSRS and PL/SQL
- Administration Tools of Communication: Lan Work Place for Win3.11 and Windows 95, FTP, Cisco Routers, Switches, Vlans, Fiber Optic, UTP Cables cat 5 &6.
- Implementation and Monitoring Networks LAN and WAN and communication protocols for Branch.
- Implementation of atmosphere protocol TCP/IP Windows Servers and financial terminal
- VOIP, networking, routing implementation
- TCP/IP and FTP transfers files
- Programming and developer Tools of Office: Lotus, Project, Word Perfect, Visio, Corel Draw, Flow, News, Harvard Graphics, Mac Finish and Photo Finish, Office, Excel, PowerPoint, Access, Publisher, Office Pro, AutoCAD 2000, Rational Rose, Enterprise Manager, Photoshop, Suite Dream Weaver, HTML, HTTP.