Sql Server Data

* ** * * . * L O R I DA AV E N U E • D E N V E R, C O 8 0 2 47

P H O N E 72 0 2 01 3 0 6 0 • E M A I L C U L S T U F F @ AO L . C O M

ROBEL H. HAILEYESUS

SUMMARY OF QUALIFICATIONS

Experienced IT professional with a combination of a Dual Masters degree in Software

Engineering/ Database Administration and a post bachelor IT Professional

Certificate. Posses over 12 years combined experience in IT, 6+ years’ solid

SQL Server database administration & development experience with DBA

duties. Posses a combined strong analysis and application development skills

coupled with an exceptional communication skill. Experience in web based

relational database technology design analysis and implementation backed up

with a solid technical customer support and troubleshooting skills. High level

of work ethics and integrity proven by fairly quick job promotions within

organizations and high GPA’s. Ability to work as a team member as well as an

individual with little to no supervision. Ability to prioritize projects, and to

manage multiple tasks. Applying for a SQL Server Database Administrator

position where I can contribute more towards meeting your IT database

specific organizational goals.

SKILLS

Programming TSQL, PL/SQLC, C++, JAVA,HTML, DHTML, XML,WSDL,XHT,ML,

L ASP, ADO, Active X, Visual Basic, JavaScript, VB Script, Cobol, PHP,

a Phython

n

g

u

a

g

e

s

Database ORACLE 9i,MS Access 2003, MS SQL Server 2000,2005, MySQL, ZODB,

T Sybase, Genesys Infomart

e

c

h

n

ol

o

gi

e

s

IIS administration, DNS and DHCP configuration,

Networking

LDAP/Active Directory administration, FTP configuration,

T

Firewall set up, Proxy Server set up, TCP/IP configuration,

e Web Service Technologies

c

h

n

ol

o

gi

e

s

RAD Tools MS Frontpage, Dreamweaver, Fireworks, Flash (basics), Borland JBuilder,

Ant, Semantec Café, MS Visual Interdev, TOAD, Smart Draw, Text Pad, PGP,

eTalk, PL/SQL Developer, Visual Studio, Brio (Hyperion), Crystal Reports,

Sybase Power Designer

Platforms

Windows 9x, Windows NT/2000, XP, UNIX, Mainframe AS400 (rhumba),

Zope/Plone CMF.

Other

MS Project, MS Visio, MS Outlook, Lotus Notes

PROFESSIONAL EXPERIENCE

Pearson Education Publishing Co. (ECollege division) Denver,CO

Database Engineering Department March 2008 Present

Database Administrator II

• Design logical and physical OLTP and OLAP databases with TOAD data modeling tools.

Write schema and data patch scripts and processes for development.

• Troubleshoot multilateral database issues. Review database design changes with the team

to determine the impact to the physical database and other systems.

• Actively participate with review of QA test plans and enforce DBA database standards.

Configure and maintain SQL Server and database settings. Support Application

Development staff with respect to database objects.

• Major contributor in mission critical product specification meetings with project team

members to determine the scope and limitations of the project and conduct capacity

planning in an agile development environment.

• Monitor database and SQL Server performance. Manage and perform maintenance,

backups and security for different environment databases. Perform data migrations.

• Conduct implementation and maintenance of log shipping and replication concepts.

• Provide support production issues for cubes, DW Reporting, and ETL jobs.

Alta Colleges Inc. Denver,CO

Information Technology Service (ITS) Department November 2006 March 2008

Sql Server Database Administrator

• Effectively installed, configured, managed, scheduled jobs, and automated SQL Server

OLTP and OLAP Data warehouse load processes. Upgraded over 10 servers from SQL

Server 2000 to 2005 Enterprise and Standard edition

• Ensured high availability through regularly monitoring and optimizing around 30 SQL

Server 2000 and SQL Server 2005 Production, QA and Dev instances using IDERA’s SQL

Server monitoring tool.

• Tuned and analyzed, identified and resolved db performance bottlenecks (locking and

blocking issues) and wisely allocated server resources to achieve optimum db performance.

• Verified backups and error logs on the production servers on a daily basis and troubleshoot

any job failures or alerts.

• Regularly used T SQL scripts for constructing triggers, tables, views, indexes, stored

procedures.

• Designed logical and physical database models, data dictionaries, and frequently conduct

database health and data integrity checks. Create Database schema design using Sybase

Power Designer.

• Designed, implemented, maintained and documented complex database applications, and

data warehouse star schemas in campus related data environments.

• Authored multiple detailed corporate database backup, disaster recovery and db migration

rollback plan documents.

• Developed complex ETL processes with DTS packages and ActiveX Scripting for cross

platform data migration and manipulation solutions.

• Worked with high availability SQL Server solutions, including Log shipping, Replication

and SQL Server clustering on a regular basis.

• Apply and Maintain Sql Server Database security and Administer user and group level

access.

MoneyGram International Inc. Lakewood, CO

Technical Operations Department April 2005 – November 2006

Database Programmer (with a Database Developer/DBA role)

Worked on developing a Java based Online/On Demand Data Reporting Tool, which will

•

be applicable for Enterprise wide multi level reporting activities. The tool would have a

Java front end with its backend data coming from various data sources (mainly from

Genesys’ CTI, Enterprise Router and Infomart, Aspect and Oracle) through the use of Java

servlet method calls to an XML based Genesys Web Service API.

Successfully introduced, installed, configured, customized and administered Plone, an

•

open source dynamic Web Content Management System for the Enterprise Intranet

Information Portal. Plone runs on top of a python based server called Zope. Zope is

configured to operate on top of a Tomcat Apache server in a Red Hat Linux box.

Responsible for the overall database development, support, administration and design of a

•

Call Center Database System. The call center has more than 500 call reps. Tasks include

ensuring a very high database availability, redesigning and converting the existing database

system (which was primarily MS Access based system) into a more robust and scalable Sql

Server application which includes DTS automation to most of the data entry and reporting

processes by interacting/interfacing with the pre existing Oracle and Mainframe based

systems. The project required thorough understanding of the existing systems, detailed

requirement gathering, design analysis and database development integration skills.

Effectively migrated applications from Oracle 8i to 9i and 10G environment using up to

•

date database conversion, query optimization and performance tuning techniques.

Provided reliable and on time support (on site as well as 24/7 on call availability) for all

•

Call Center’s Production related database and web related issues.

Maintained and administered the organization’s call center Database server environment.

•

Developed and supported databases that serve as a backend for the Company’s intranet web

•

forms and sites.

Served as the lead web developer who is responsible for developing intranet sites and

•

webforms using technologies like DHTML, ASP, XML, JAVA, Phython and PHP.

Echostar Communications Thornton, CO

(CMO Department, Reporting Team) February 2002 April 2005

Database Analyst/Developer

Designed and developed a web based Sales Tracker related to out bound sales reps using

•

different Microsoft related Web Technologies like DHTML, Java script, VB script,

XHTML,ASP,ADO, SQL Server’s DTS package and Active X scripting automation,

multiple stored procedure calls to Oracle and SQL Server tables with SQL server back end.

Designed, developed and automated various data pulling and reporting processes within

•

the organization per users’ requests and requirements using SQL Server’s DTS Package

technologies.

Designed, developed, automated and maintained a new reporting application for “Call Data

•

and Call Dictionary report” using ActiveX Scripting, Windows API shell scripting, and

SQL Server DTS package technology with SQL server back end. The application pulls call

center call data and call data dictionary raw data and performs the necessary validation

and analysis before it stores it to the SQL server table. The application is scheduled to run

automatically and has a mechanism to notify users via email and has an error log writing

capability.

Designed, developed, automated and maintained a new reporting application for “No

•

problem found” Dish receivers report for supervisors through out the call centers using

VBA for an MS Access frontend, and with SQL Server and Oracle backend. The

application calculates and reports on the rate of returned Dish equipment with no problem

found broken down to Manager, Supervisor and CSR levels.

Responsible for supporting and updating an existing enterprise wide web based Customer

•

Service activity reporting application (called the Daily News) in the company’s Web

Intranet on a daily basis. The application has a web (ASP) front end and an Oracle9i

backend.

Analyzed, optimized and synchronized the Daily call center reps’ performance data which

•

comes from various data sources and platforms through various data filtering and

conversion processes to provide real time as well as historical agent activity reporting.

Responsible for tracking, analyzing and reporting on the daily Customer Credit Card

•

payments using tools like Brio, Monarch, Altair and IEX.

Designed, developed, automated and maintained Monthly Shipping and Trouble call

•

related reports. The application to run this report is created using VBA in Ms Access

Run various Adhoc database reports per client request by regularly pulling data from

•

external sources (like Access, Excel, Sql Server, Oracle (and one time from Sybase) and

creating optimized queries using SQL, TSQL, PL/SQL and pulling and analyzing the data

for reporting.

Worked closely with the IT data warehouse team in automating our (reporting team) daily

•

processes.

Colorado_OpenHouse.com E commerce site project Denver, CO

Lead Web Developer/Designer August 2001 August 2002

• Responsible for developing the front/backend functionalities of the e commerce site

using HTML, DHTML, CSS, JavaScript, VB Script, Java, ORACLE, SQL, MS SQL

Server, ASP, ADO, IIS with the Visual Interdev IDE.

Used HTML and Rapid Application Development tools to design, develop

•

and administer Web sites.

Created Web project plans based on project management concepts and

•

tools.

Demonstrated management and team work skills.

•

Created, query, update, and administer databases.

•

Built a network and resolve basic networking problems.

•

Installed, configured, and troubleshooted Web servers.

•

Implemented basic server security models.

•

Used a scripting language to add interactivity to Web pages.

•

Created a database driven Web site

•

IBM Global Services (Contractor) Boulder,CO

(Lucent account division) March 2002 July 2002

Technical Support/Helpdesk Rep.

Provided remote telephone hardware/software technical support to end user.

•

Troubleshoot Windows 9x/2000/NT operating system related problems

•

Network troubleshooting: Network Adapter, cable, gateway/router problems LAN

•

and proxy settings configuration, DNS/WINS configuration, DHCP, Dial Up Remote

Access, Mapping to share drives/servers, VPN, Internet Connection (TCP/IP) issues.

Email troubleshooting: MS Exchange server, Ms Outlook, Netscape mail)

•

mailbox/profile creation :

Administrative Issues: NT account creation: Password reset, Reset/ Resynch Secure

•

Tokens/Mainframe Applications Password Reset/ intranet web access issues.

Hardware:: Local/Network Printer problems, PC, Laptop, phone equipment

•

troubleshooting.

Tools used :

Remedy, McCafee, Esm(Ticketing tools), Active Directory, Ms Netmeeting,

•

GSS America Inc. Arlington Heights, IL

Technical Recruiter and Business Development Associate Oct 2000 – March 2001

Conducted pre screen interviews

•

Negotiated offer terms, checked references and extended final offers

•

Responsible for creating new client base and other business development tasks

•

Compucare Electronics Denver, CO

Intern Assistant Troubleshooter April 1998 May 2000

Assisted in correcting internet related problems including modem issues, email setup, web

•

browsers and FTP programs configuration in many different programs.

EDUCATION

Regis University Denver, CO

Masters in Computer Information Technology (MSCIT Honors) May 2006

(Emphasis on Database Development and OO programming)

• GPA 3.91

Westwood College of Technology Denver. CO

IT Pro Post Graduate Certificate May 2002

University of Colorado Denver, CO

B.S in Information Systems May, 2000

University of Poona Pune, India

B.S in Marketing/Accountancy Management May,1993

EXTRA

Member of National Honor Golden Key Society since January 1998.

Developed and (still maintain) a fully functional high school reunion site called senjo89.com and

a charity website called agar eayd.org

Contact this candidate