Sql Server Developer

Professional Headline:

An experimented IT professional and software engineer specialized in the

design and development of information systems with an excellent mix of

business and technical knowledge; oriented to adopt the best practices and

proven methodologies to model, develop and deliver timely, efficient,

robust and practical technology solutions that meet business requirements.

Innovative intuitive thinker gifted with strong analytical and problem

solving skills. Perceiving personality and excellent human touch when is

applying technology solutions. A prudence person who acts well under

pressure, a team player with flexibility to adapt himself for new

environments and a hard worker oriented to goals, always ready to learn

from experiences. Bilingual: English/Spanish, looking for a full time

position at West Houston, TX. (No open to be relocated)

WORK EXPERIENCE: (last 3 positions only)

Assistance VP/ Development at Bank of America (Merrill Lynch Commodities)

from Nov 2012 to April 2014:

Data warehouse implementation and maintenance on SQL Server 2008R2, ETL

processes and Python development for commodities trading using a NON-SQL

OODBMS. Application troubleshooting on production environments.

VLDB multi-server heterogeneous environment using data from/to SQL Server,

Oracle DB and other legacy systems.

Achievement: Solved data population problems fixing DW design issues

Senior DBA at Lender Processing Services (Real EC) from Aug 2012 to Nov

2012:

Data modeling, advance T-SQL development for WEB applications and database

troubleshooting on SQL Server 2008R2. VLDB multi-server homogenous Windows

environment.

Achievement: Deadlock detected and solved using SQL Profiler and rewriting

Stored Procedures causing this problem.

Application DBA at United Rentals (contractor provided by Robert Half

Technologies) from Oct 2011 to July 2012:

SQL Server performance & tuning, T-SQL programming for Web applications,

SQL Server DB maintenance and troubleshooting (DBCC, Profiler, SA). ETL and

database migration from SQL Server to DB2 using mainly SSIS.

Achievement: Improved KPI application performance, reducing computing time

from 20 minutes to 1 minute

SKILLS:

Management (Consulting, Software Development, Operations and Logistics,

Customer/Service Relationship)

Sales (IT consulting services, Custom software development, IT Services and

Floor Coverings Materials)

Software Development Life Cycle (Agile/Scrum, Object Oriented, Analysis,

Design, Construction, Deployment)

Database specialist (Architecture, Normalization, SQL scripting,

Performance & Tuning, DB Migrations)

Business intelligence (Architecture, Programming, Data warehousing, ETL,

Balance Scorecards, Analytics)

Software applications (Project scope, Architecture, Integration,

Programming, Testing, Project Management)

Software engineering (Project scope and management, Design Patterns, Code

Review, Gap analysis, SOA)

Technical expositor (University cathedra [20 years], conferences, white

papers, technical documentation)

INDUSTRIES:

Retail (Floor Coverings, Painting materials, Hardware stores)

Service (Financial Institutions, Restaurants, Education, Information

Technology, Rental Equipment)

Manufacture (Sugar mills, mining), Energy (Gas stations), Pharmaceutical

Tools:

Database Engines: SQL Server (2005/2008R2), Non-SQL key-value OODBMS (BAML

proprietary), Informix.

DB Tools: MS SQL Server (Profiler, NS, SB, SSIS, SSAS), XML,

ERwin,ER/Studio, Salsa, IdeaSoft O3 BI suite

SQL scripting: Advance T-SQL for DDL and DML including stored procedures,

triggers, functions, memory & temporal tables, CTE, sub-queries, rank

functions, indexes, transactions and query hints.

Programming Languages: Python, VB, C/C++, Pascal, COBOL, FORTRAN, Clipper,

Dbase, Informix 4GL

Platforms: Windows, Unix, AS/400, VAX VMS

Office applications: Office, Excel, Word, Power Point, Visio, Lotus Notes

EDUCATION:

Master MBA, Management: Instituto Panamericano de Alta Direcci n de

Empresa (IPADE), Mexico 1999

Continuity Program from 2000 to 2006

Master CS., Computer Science/Information systems: Arturo Rosemblueth

Institute, Mexico 1995

Bachelor CSE, Cybernetics and Computer Science Engineering: Universidad La

Salle, Mexico 1987

Graduated with honors.

Contact this candidate