Sql Server Project

Pedernal ***-*, Col. Corral de Piedra,

San Nicolás de los Garza, NL, México

J ose Rivera Merla (81) 8141-0727, (81) 1382-1317 mobile

************@*******************.***

DataWarehouse Project Leader, Python Developer, SQL DBA, ETL Developer (SSIS, DTS)

1 RECOGN I ZED, TECH N ICALLY PROF IC IE N T I T

P ROFESSIONAL

Offering extensive experience with 8 years of experience as Datawarehouse project leader, a

distinguished track record, and demonstrated abilities in Information Technology;

areas of expertise and interest includes:

DataWarehouse/BI– Python – Plone – SSIS – Project Leadership – C# .Net

SQL Server DBA– T/SQL – Oracle PL/SQL

2 CAREER SUM MARY

I have 17 years of experience in the industry, I have worked in the IT field since 1993 at the

beginning at outsourcing companies, later started working as a freelance IT professional in the year

2002, and started my own IT consulting firm in the beginning of 2009. With proven expertise in

analysis, design, and support of systems. I served successfully as project leader in Femsa Comercio

for 12 years with many projects delivered on time.

Solutions-oriented and highly analytical candidate with extensive experience in the analysis, design,

development, and management of application systems. Successful history of effective leading

projects, implementing systems, and directing key initiatives. Demonstrated excellence in systems

institution, testing, delivery, and post-implementation support. Skilled troubleshooter with the

proven ability to provide creative and effective solutions through the application of highly

developed technical and problem-solving skills. Able to quickly grasp and adapt to new concepts,

technologies, and environments. Fluent in English and Spanish.

Deputy Customer Testimonials

at the end of this document.

T EC H N ICAL SK I L LS

Programming Languages/Tools: Python, PowerBuilder, .Net, C#, Visual Basic, T/SQL, PL/SQL,

Perl, HTML/CSS, JavaScript, Pascal, Delphi, C, C++, SSRS, SSAS, and COBOL

ETL Tools: Python, MS Data Transformation Services (DTS), SQL Server Integration Services

(SSIS), Oracle WareHouseBuilder

Web Frameworks/Servers: Zope/Plone, IIS, Apache, Django, and Google App’s Engine

Database Administration: SQL Server 7, 2000, 2005, MySQL, SQLite

Non-SQL Databases: Metakit

Software: OpenOffice, Microsoft Office, Outlook, Evolution, Excel Programming for

BI/Dashboards

Virtualization: VirtualBox, VMWare

OS(s): DOS, Windows 3.1/95/98//NT,/2000/XP Professional/Vista, Linux Ubuntu/Debian

I'm versatile and quick to learn new technology and able to find the simple solution to the problems.

SELECTED ACCOMP L IS H M E N TS

Successful project leader of the Datawarehouse system, carrying the analysis, design,

implementation and support of the backend and frontend to more than 200 users at

national level successfully in Femsa Comercio for 8 years, with information of up to 3500

stores processed each day with a volume of 1 GB. Helping later in the migration to

Oracle DB and Microstrategy technologies by automating tests and QA for the BI

project.

Dealt with the grow of the company from 300 stores to 3500 stores in 8 years, passing

from only monthly analysis of information to reports analysis by month, week, and day.

Technologies applied were Python, Metakit, SQL Server, T/SQL, DTS/SSIS,

PowerBuilder, Excel, Oracle Warehousebuilder and Plone.

Project leader responsible for the analysis, design, implementation and support of over

25 successful projects over the past 12 years, 16 of them in the last 5 years, delivering on

time and within budget.

SQL Server DBA for several databases, among them the Datawarehouse DB with a size

reached of 1 Terabyte. Being able to design and optimize it for fast response at users,

having this role for a period of 10 years with success and giving support more than 250

users.

Gained the recognition among the users of being an IT expert able to deliver fast results and

that easily understands the user requirements to then deliver results to their satisfaction.

Project leader of the Monitoring of Level of Service Given of Suppliers at Stores. Being

responsible for the prototype delivered on time and later delivering the design, and the

implementation on time of the system processing more than 7000 XML files per day and

preparing of data for the analysis reports daily with SQL Server, Python processing,. Giving

support to more than 100 users at national level at Femsa Comercio. Web frontend with report

generation on Plone and additionaly an Excel Dashboard for analytical reports.

Project leader of the Inventory System of AdSpaces at the stores at Femsa Comercio

conceived for managing the availability of advertising space in over 7000 stores, being

responsible for the analysis, design, development, and support to over 100 users. Reducing the

operation times from days to minutes in the consolidation of information to generate orders for

advertising material for shops and set up promotions. Technology applied: Plone, Python, MS

SQL Server, HTML, CSS.

Designed and implemented an Intelligent Agent for the monitoring of servers,

communications, SQL Server databases, Oracle databases, FTP Servers, and the state of

processes of the systems with a Python agent able to send emails to people in charge according

to an easy to modify configuration file to specify servers, ftp servers, Oracle databases, SQL

Server Databases, etc.

3 EDUCAT IO N

Bachelor of Computer Science Faculty of Math & Physics Sciences ‘1993 Graduated

Universidad Autónoma de Nuevo León

4 LANGUAGES

English – Conversational, Spanish – 100% (Native)

5 E M P LOY M E N T CHRONOLOGY

6 Owner / Project Leader 1-Feb-2009 Today

Sistemas de Monterrey

Responsible for the sales, prospecting, calling, and the negotiation of the projects.

Eight projects delivered on time of 8 projects taken and within the budget projected being

responsible for the analysis, design, development, and support of the projects.

Designed and developed processes with Python to maximize the utilization of the available

resources making use of parallelism and concurrent processing at different servers to the

processing of XML files in minimum time for the loading of information to SQL Server.

Ensured the correct operation of the systems developed integrating the development with the

generation of key indicators for a website just for the monitoring of the systems by the

operations department personal and of automatic alarms for the automated detection of

problems and generation of alarms to key people.

Automated the monitoring of servers, communications, SQL Server databases, Oracle

databases, FTP Servers, and the state of processes of the systems with a Python Agent able

to send emails to people in charge according to an easy to modify configuration file where

you specify services to be monitored and the personal to be notified when an issue is

detected.

Technologies applied:

o UML: For the definition of the requirements gathered with the users.

o Python, Python lxml, SQLAlchemy/elixir, and ftplib. For the automatic processing

of XML Files for the loading of data to SQL Server and tracking the reception of

files from more than 7000 stores of Femsa Comercio. Designing the processes for

parallelism and concurrent processing at different servers to maximize the use of the

available resources.

o SSIS: For the processing of Zip files containing Access files to load data to SQL

Server.

o SQL Server: For the storage of information and also for the processing of

information to generate complex reports with T/SQL, calculating at night some

aggregated tables for the analysis of information.

o MS Excel 2007: For the generation of a dashboard system for the access of

information stored at SQL Server and utilize the pivot tables and charts to give

different analysis to the user with the freedom to use filters, and sorting that Excel

offers delivering the system in a record time of 1 week, for something that would

have required at least 3 months of development in Microstrategy.

o Plone, HTML/CSS: For the creation of websites at different projects, some to be

used as a website to access reports with data read from SQL Server and Oracle, and

others as a CMS for the management of content created by users.

7 Project Leader 1-May-2002 15-Jan-

2009

Femsa Comercio – Freelance

Delivered 12 projects on time and within the budget projected being responsible for the

analysis, design, development, and support of the projects to more than 200 users.

Excelling with fast development times and the delivering of systems wich required

minimal support.

In charge of the Datawarehouse Project for 6 years working successfully with new

requirements for bigger volumes of historical information, new requirements for reports

generated in PowerBuilder and Web, and giving support to more than 150 users. The

technologies applied were PowerBuilder, Plone, HTML/CSS, SQL Server, Python, T/SQL,

and DTS (MS Data Transformation Services).

Eleven Web Projects delivered on time and within budget.

Technologies applied: UML, Python, Plone/Zope, HTML/CSS, PowerBuilder, Ms Data

Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server, T/SQL y

Oracle PL/SQL.

8 Systems Analyst 1-Jun-2000 1-

Apr-2002

Femsa Comercio - Promissus SA de CV

In charge of the Datawarehouse Project for 2 years working successfully with new

requirements for bigger volumes of historical information, new requirements for reports

generated in PowerBuilder and Web, and giving support to more than 150 users. The

technologies applied were Powerbuilder, Plone, HTML/CSS, SQL Server, Python, T/SQL,

and DTS (MS Data Transformation Services).

Relieved the load of support at the Datawarehouse project through the design and

implementation of a notification system that sent notifications to the operations teams at

different cities when problem in transmissions were detected and Database problems and

any other kind of problem.

Technologies applied: Windows BAT scripting, PowerBuilder, Power Foundation Classes

(PFC), SQL Server, T/SQL, VMS/VAX, and ftp/telnet sessions automated through Python.

Relevant Evidence / Testimonies from Customers

9 Testimony # 1

From all the team thank you for your support in the development of the tool inventory of spaces,

has been a very good job as a result we have saved man hours previously dedicated to manual

consolidation which previously we spent 4 days but now 30 minutes. Even more he has avoided the

debilitating human error we had in the past at both places in the cities and the Office of Services.

I talked to a few offices in Mexico we think alike.

Congratulations and thank you very much.

P. S. And must begin to talk about version 2.0!

Raul Vidaurri Darwich

Cadena Comercial OXXO SA de CV (Femsa Comercio)

Marketing Manager

Office of Services

10

11 Testimony # 2

I hereby confirm and recommend the services of Mr. Jose Rivera as a developer of web portals.

Jose Rivera has been working for several years at Cadena Comercial Oxxo developing various

portals to the area of promotions with a constant hallmark of quality and service.

No more for now

Greetings...

Luis Said Landeros Montelongo,

Cadena Comercial OXXO SA de CV (Femsa Comercio)

Marketing

Office of Services

1 Testimony # 3

José Rivera worked for 9 years with us. He managed to implement our first data warehouse to store

information. Using his creativity and mastery of the tools applied at Oxxo, achieved a solution that allowed

us to monitor stores information.

Jose is creative, has an excellent command of the tools that he manages. Jose is the right person to explore

new tools and start testing to explore new solutions. I think this is his main talent.

Regards,

Javier Figueroa Leon

Cadena Comercial OXXO SA de CV (Femsa Comercio)

Manager of Systems Development and Integration

Office of Services

2 Testimony # 4

Name of the project I did support you: Level Service of Direct Service Providers.

Dimension of the Project.- Grande - National, is a measure to suppliers who supply us directly to the stores

representing 50% of purchases in the chain.

What impact did for your area or department? - The impact was big for the company, came to equip us

with valuable information for managing the supply with direct suppliers, which is being reflected in a

decrease in lost sales, additional came to change management routines of people who are in the 55 cities of

the chain, and last but not least, this also allowed us to work towards culture change in organizations of

suppliers with which it works with this model.

Was it successful? 100%.

What was the difference, why I recommend? Very committed, fast delivery, he knows customer

requirements and express them in the development requested with immediate responses to new requirements

and / or problems.

Did any impact of measurable or quantifiable benefit that made the difference? Yes, a 2% reduction in

lost sales of the suppliers that have already implemented this process.

"In general what would be your opinion if someone asks about my work? Excellent, contrátenlo.

Yola María Murillo Pérez

Cadena Comercial OXXO SA de CV (Femsa Comercio)

Supply Chain Manager

Office of Services

3 Testimony # 5

Your Position / Department: Oracle Development Coordinator

Project Name (s) that you support: Level of Direct Service Providers, MonitorPOS, MonitorTickets,

RMSvsPOS Catalogs Monitor, QA Tickets, MonitorTAE, Sales to Third parties, IMMEX Telephony Sales,

Inventory of AdSpace, Variable Exhibition of Fastfood, among others.

What scale are the projects that I did support? The projects have been of size small and medium.

What impact did your area or department for my help? - Resolution of specific problems and assurance

of information for decision making.

Was it successful, why? Yes, we expected a rapid and timely response to problems that face the area to

make visible some of the quality indicators and monitoring that our business required.

What was the difference, because I recommend? He generates fast results and applications operating on

time.

Which was the impact of measurable or quantifiable benefit that made the difference? Fast results

In general what would be your opinion if someone asks about my work? I consider it good, fast and with

visible results properly delivered.

José Martin Hernández Cendejas

Cadena Comercial OXXO SA de CV (Femsa Comercio)

Oracle Development Coordinator

Office of Services

Contact this candidate