SUMMARY

• Seasoned Microsoft Certified database administrator in MCITP and MCTS with 15+ years of IT experience and knowledge of database maintenance/design obtained from positions in banking institutions and financial services.
• Professional, flexible, creative, service - oriented, offering unique combination of creativity and analytical skill with the ability to assess both vantage points to create cost-effective solutions for internal and external clients.
• I am a self-starter, diligent problem solver with keen interpersonal skills, Interested in effectively leveraging my skills and experience to make significant contributions to your organization.
• Years of experience using SQL Server Administrations (SSMS, Profiler, Backups), Database design (schemas, database objects, Relational database design (including 1, 2, 3 and 4 forms)) and SQL Coding (Triggers, Stored Procedures, Views, Functions).
• Data migration (DTS, SSIS), data mining and warehousing and SSAS (OLAP and OLTP).
• Accomplishments in application design, coding and seasoned technical writer (project documentation, user manuals Technical specifications).
• Familiar with Oracle 8i, 9i administrative tools (enterprise manager) as well as Oracle developer.
• Excellent knowledge of Microsoft Office, with concentration on Excel and Access.

TECHNICAL SKILLS

• SQL Server 2000 - 2008 including SSMS, SSIS, SSAS and SSRS, SQL Server Agent, SQL Server Profiler and Database Engine Tuning Advisor.
• Oracle 8i, 9i enterprise manager, Oracle studios and Oracle developer.
• ERWIN schema development applications.
• Microsoft Office, Access, Excel, Word and PowerPoint
• Crystal reports, Monarch (data conversion tool)

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

• Administrator of entire SQL Server databases in a multi-server SAN environment including:
• Performance monitoring, tuning and optimization of entire SQL Server environment.
• Using said analysis to determine/forecast growth patterns, Memory/CPU requirements
• Also, using analysis to determine seasonal business trends to better determine capacity planning to prevent a negative impact on database performance.
• Create standardized polices for the entire SQL environment.
• Created logins/users and administer credentials/permissions and securables from server level to database level.
• Created and administered comprehensive backup plan for all SQL servers.
• Created disaster recovery plan for entire SQL environment.
• Work with development team to insure efficient/effective SQL coding is implemented, deploying only processing that meet standardized business practices.
• Extensive documentation of all processes, procedures and policies.
• Test and evaluate any third party software for possible recommendation to senior management.
• Setup SSRS report server services.
• Application/Database was created to manage day-to-day transactions, sales, inventory and weekly-to-yearly sales for monitoring growth, forecasting\directing and accounting purposes.
• Handled all managing responsibilities including, corporate budget, Sales, advertising, customer relations, Employee relations (Employed and managed eight employees).
• Exploring possibilities of marketing this application/database at the retail level.

Confidential

IT Administrator\Developer

Responsibilities:

• Develop, implement and maintain front-end application with SQL Server 2008 instance including:
• Utilizing SQL Server SSMS, SSRS and SSIS.
• Creating logins, users/groups granting credential, permissions and securables at the server and database levels.
• Responsible for tuning and optimizing SQL Server environment.
• Application/Database was created to manage day-to-day transactions, sales, inventory and weekly-to-yearly sales for monitoring growth, forecasting\directing and accounting purposes.
• Handled all managing responsibilities including, corporate budget, Sales, advertising, customer relations, Employee relations (Employed and managed eight employees).

Confidential

Database Developer/Application Designer

Responsibilities:

• Responsible for extraction and migrating data from pervious database to SQL Server 2005 platform.
• Setup a new relational database, included all users, permissions, roles and automated tasks (IE: backups).
• Created all new views, triggers and stored procedures to effectively manage data processing and retrieval increasing database effectiveness by 40%
• Developed front-end application to manage client data entries with connectivity to SQL database backend, which increased user productivity by 25%.
• Provided post project database support, instance tuning and optimizing.

Confidential

Database Developer/Database Administrator

Responsibilities:

• Developed new relational data-models forward- engineered (logical and physical schema) using Erwin.
• Migrated data from SQL 2000 to 2005.
• Created new Triggers, Stored procedures and Views, along with optimizing previous ones. Optimizing database performance by 20%
• Responsible for database tuning, securities, permissions, backups and maintenance plans.

Confidential

Database Administrator/Database Developer/Application Designer

Responsibilities:

• Developed a database/application for the Bank’s Consumer Investment Division, which tracked and data-stored high-level investors’ portfolio activities and correspondences. The application was also used as a static/dynamic reporting tool to identify consumer tendencies and provided the Consumer Investment Division with valuable information for future product recommendations. Critical project task included converting and uploading sensitive loan information (received from clients) into SQL Server database.
• Designed an application/data mart to manage the Bank’s education program, which included all employees’ internal and external class scheduling, course completion and grade received. In addition, this application managed the Bank’s Tuition Reimbursement Program, which included calculating tuition reimbursement disbursements on the individual level along with the Bank’s yearly costs for over seven-hundred participants. Creating this Application data mart instead of soliciting an outside vendor resulted in substantial cost savings.
• Developed an application/database to manage and service the company’s secondary mortgage portfolio, with assets totaling over 1.8 billion. Increasing customer servicing effectiveness but 30%.
• Designed database for a web-based application allowing over fifty-thousand Bank customers nationwide to access certain account information as well as their current mortgage status. Providing one of the first visible products in the company’s web-based initiatives.
• Created a database/application for the Human Resources Compensation Division. This database was utilized to identify, compile and formulate calculations based on policies resulting in execution of confidential total compensation letters for over seven thousand employees, including senior management population. Resulting in a reduction of HR payroll by 5%
• Composed several detailed technical and user manuals.

Systems Information Technician

Confidential

Responsibilities:

• Network administrator for over 100 network accounts
• Performed NT systems backups.
• Help desk support for over five-hundred NT/Windows users.
• Acted as backup to Exchange Administrator.