Houston, Tx 77065

281.966.6966

Malamin@FortitudeConsulting.Biz

www.FortitudeConsulting.Biz

View Resume in Word Format

Title

SQL SERVER DBA and Senior SQL Server Developer

Primary Skills

SQL Server 2005/2000, SSIS, Data WareHousing, ETL

Location

Houston, Tx

Posted

February 5th, 2010

RESUME DETAILS

SQL SERVER DBA / Senior SQL Server Developer AND ETL DEVELOPER

• Over 10 years compound experience in IT, 7 years solid SQL Server database administration & development experience with DBA duties

• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005

• Experience in developing and monitoring SSIS Packages and DTS

• Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, and data integrity

• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and Database Mirroring

• Extensive experience with query tuning and analyze db performance.

• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments

• Extensive experience in design techniques, ETL processes, relational database theory, N-Tier development

• Excellent report creation skills using Microsoft Reporting Services

• Excellent communication, presentation and interpersonal skills

• Strong troubleshooting and organizational skills
• Expertise in requirements gathering and data mapping. Highly skilled in performing data analysis from multiple data sources and combining them into data mapping documents for ETL purposes.
• Extensive experience in working for financial institutions such as Wells Fargo, US Bank, Certes Financial, Coldwell Banker Burnett. Highly Skilled at working for Fortune 500 Corporations and providing Database Solutions that meet mission critical business needs. These solutions are currently in use at corporations such as Target, US Bank, Wells Fargo, United Health Group, and Coldwell Banker Burnet and other Fortune 500 Companies such as Target Corporation and United Health Care.

TECHNICAL SKILLS

Database SQL Server 2000/2005 Enterprise

SQL, T-SQL, Performance Tuning, Capacity Planning

Installation, Upgrade, & Migration, DTS, SSIS, Reporting Services

Data Warehouse Development, Data Modeling

Operating Systems Windows Enterprise 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional/NT 4.0 Server

Applications ER Studio

Visual Studio 6.0/.NET

Client / Server

Language

Professional Experience

Project: Fiserv Sept 2009- Current                                                                

Role: Database Administrator/ETL SQL Developer.

Fiserv is a Fortune 500 Company that specializes in providing technology solutions to financial institutions

 Areas of responsibility:

• Database Conversions
• ETL Operations
• Design Dimensional Model for Data Mart.
• Designed SSIS Packages in SQL Server 2005 to handle data migration (ETL Processes) From
• Transaction System to Dimensional Model
• Wrote Stored Procedures, functions and views to handle data extraction and processing.
• Environment: SQL Server 2005, Sequel Server Integration Services

Project: United Health Group March 2009- July 2009                                                                

Role: Dimensional Modeler/SQL Developer.

United HealthCare is a Fortune 50 company and one of the leading providers of Health benefits and insurance. As a Dimensional Modeler/SQL Developer I was responsible for designing, developing and testing a new data mart.

 Areas of responsibility:

• Query Optimization and Trouble Shooting.
• Design Dimensional Model for Data Mart.
• Designed SSIS Packages in SQL Server 2005 to handle data migration (ETL Processes) From
• Transaction System to Dimensional Model
• Wrote Stored Procedures, functions and views to handle data extraction and processing.
• Environment: SQL Server 2005, Sequel Server Integration Services

Project: Minnesota Department of Education   July 2008- March 2009                                                                

Role: Dimensional Modeler/SQL Developer.

Minnesota department of education is responsible for overseeing the administration of funding and curriculum for the state of Minnesota. As a Data Modeler I was responsible for the Project Management and directly contributed to the roles and responsibilities of the Data Modeling team. I drove the creation and enhancement of the dimensional data models for several of the State of Minnesota Department of Education databases for analytical and decision support systems.

Areas of responsibility:

• Query Optimization and Trouble Shooting
• Design Dimensional Model for Data Mart.
• Built Analysis Services Cubes
• Designed SSIS Packages in SQL Server 2005 to handle data migration (ETL Processes) From
• Transaction System to Dimensional Model
• Wrote Stored Procedures, functions and views to extract data as required
• Performed Requirement Gathering of business processes to facilitate the Dimensional Modeling efforts.
• Performed analysis of production Database to gather critical information that was pertinent to Dimensional Model
•  Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Environment: SQL Server 2005, SQL Server Analysis Services 2005, SQL Server 2000, Reporting Services 2005, Visual Studio.Net 2005, ER Studio

Coldwell Banker Burnett (Realogy Corporation)                                                                  August 2007 – June 2008

Role: Database Administrator

Realogy Corporation, a global provider of real estate and relocation services, has a diversified business model that includes real estate franchising, brokerage, relocation and title services.

• Designed SSIS Packages in SQL Server 2005 to handle data migration (ETL Processes)
• Designed DTS Packages in SQL Server 2000

• Designed and implemented SQL Server 2000 databases for mission-critical business applications by using Microsoft .NET N-tier Enterprise Application Architecture

• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications

• Created logical and physical database design, data structures, and implemented large databases • Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis

• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity

• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach

• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code

• Generated the weekly, monthly, and quarterly report by using Crystal Report

• Prepared migration document which outlined the resources required to move production database to SQL Server 2005
• Perform Code Review of developers code before moving scripts to production.

The Lacek Group                                                                   March 2007 – August 2007

Role: (Consultant) SQL Server Developer

Is a global leader in retention marketing in and loyalty programs.

• Wrote Standardized reports in Reporting Services 2005.
• Designed SSIS Packages in SQL Server 2005 to handle data migration (ETL Processes)
• Identify severe database performance problems and provide optimization using optimized Language features of SQL Server 2005.

• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications

• Created logical and physical database design, data structures, and implemented large databases

• Developed, modified, and optimized complex stored procedures,

• Managed the products and development databases including performance tuning, capacity planning,  database security configuration, and database continuity

• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach

• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code

Environment: SQL Server 2005, Reporting Services 2005, Visual Studio.Net 2005,

Wells Fargo        August 2006 – February 2007

Role: (Consultant) Database Administrator/SQL Server Developer

Wells Fargo is a household name in regards to banking. It provides a full range of commercial & individual banking products and services.

• Performed Initial Assessment on the impact of migrating from Access 2000 to SQL Server 2005 Conversion. 
• Improved operational efficiency with database design and server configuration improvements.
• Converted application from “un-normalized” Access 2000 to a SQL Server 2005 Database Normalized to 3^NF. This included modeling the data structures, architecting the tables and implementing the physical model.
• Architect New Database Structures to integrate into existing production application.
• Wrote Standardized reports in Reporting Services 2005.
• Designed SSIS Packages in SQL Server 2005 to handle data migration (ETL Processes).
• Re-Designed DTS Packages in SQL Server 2000 to improve efficiency.
• Diagnosed severe database performance problems using SQL Profiler recoded the offending procedures to be more efficient.
• Use the SQL Profiler to Monitor, troubleshoot and diagnose misbehaving or slow running stored procedures and queries and provide optimization based on SQL Profiler Results.
• Review and correct (where appropriate) data types.

Environment: SQL Server 2005, SQL Server 2000, Reporting Services 2005, Access 2000, Visual Studio.Net 2005, C#, Visual SourceSafe

Certes Financial         June 2006 – August 2006

Role: (Consultant) Database Administrator/SQL Server Developer

• Perform Initial Assessment on the impact of migrating from Access 97 to vb.Net/ SQL Server 2005. 
• Complete Normalization of existing database before migration to SQL Server 2005.
• Develop SQL Server database to serve as back end to existing access application.
• Develop stored procedures to handle data inserts, modifications and validation on the Server.

Environment: Visual Studio.Net 2005, SQL Server 2005, SQL Server 2000, Access 97

CMSDirect                                                                                          March 2006 – May 2006

Software Engineer

Provide support, maintenance and enhancements to SQL Server 2000 and DB2 databases. This includes re-writing of select scripts, development of User Defined Functions and Stored Procedures and advances DTS usage. Engineer and support Brio Reports bound to SQL Server 2000 and DB2 Data environments. This role included some of the following skills:

• Ability to estimate work and drive to make committed to dates on budget/time after the requirements are known and agreed to with the business user community.
• Ability to create and interpret general and detailed design from the gathered business requirements, execute development, perform unit/system testing.
• Ability to own and resolve production problems by using troubleshooting techniques to determine root cause, tactical and strategic resolutions, plus define Irreversible Corrective Action. 

King Companies                                                                               December 2005 – March -2006

Role: Database Administrator

• Provided Maintenance, support and enhancements of existing SQL Server 2000 database application.
• Designed DTS Packages in SQL Server 2000
• Performed routine backups and maintenance of Production Database
• Wrote Stored Procedures, functions and views to extract data as required
• Complete Normalization of existing database.
• Architect New Database Structures to integrate into existing production application.
• Performing Index fine tuning and data integrity reviews.
• Performing Database archiving and restores.

Environment: SQL Server 2000, Visual SourceSafe

Long Term Care Group                                                             September 2005 – November -2005

Role: (Consultant) Database Developer/Migration Impact Specialist

• Complete a technical impact document on the feasibility of migrating from Access 97 to Access 2003.
• Review database structure to see if it meets rules of normalization.
• Document database application and make recommendations to extend the functionality of legacy database. This system will be an Access 2003 Front end/ Sequel Server 2000 backend.
• Developed SQL Server 2000 Database with a front end developed in Access 2003(ADP) to support manufacturing.

Environment: SQL Server 2000, Access 2000/2003/97, VBA

Cardiac Science Corporation                                                 June 2005 – December -2005

Role: (Consultant) Database Administrator/SQL Server Developer

• Collected and managed data information including its branches, employees, subsidiaries, partners and stock holders

• Designed and implemented SQL Server 2000 databases for mission-critical business • Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications

• Created logical and physical database design, data structures

• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis

• Managed the products and development databases including performance tuning, capacity planning,

• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code

Environment: SQL Server 2000, Access 97/2000/2003

Carlson Companies, Minnetonka, MN                             December 2004- May 2005

Role :Database Administrator/ SQL Server Developer

• Architect New Database Structures in SQL Server 2000 Production database and integrate new structures into existing production application.
• Provided Maintenance, support and enhancements for existing SQL Server 2000 Database application.
• Performed routine backups and maintenance of Production Database
• Wrote Stored Procedures, functions and views to extract data as required
• Developed front end for database application and extend the functionality of legacy database.
• Review and correct (where appropriate) data types.

Environment: SQL Server 2000, Visual SourceSafe

US Bank, Minneapolis, MN                         November 2004 - January 2005

Role: (Consultant) VBA Developer

• Develop a mail merge application that can be generated in Microsoft Word. This application is written entirely in VBA.
• Handle all stages of application development, from gathering end-user requirements to coding, testing, supporting and documenting.

Environment: VBA, Microsoft Word 97/2000./XP

Target Corporation, Minneapolis, MN                             September 2004- December 2004

Role: (Consultant) Database Administrator/SQL Server Developer

• Support and modify existing SQL Server 2000 database applications.
• Involved in all stages of application development, from gathering end-user requirements to coding, testing, supporting and documenting.
• Architect Staging Database to serve as data cleansing repository for staging/cleansing data during ETL operations.
• Create Database Maintenance routines.
• Create Recovery Plan for Application

Environment:  Visual Basic 6.0 VBA, Sequel Server 2000, SQL

West Group, Eagan, MN                                                    July 2001- August 2004

Role: Database Administrator/ Scheduling Systems Developer

• Develop new databases, support and modify existing database applications.
• Develop new and modified existing Visual Basic applications and VBA functions, SQL Stored
• Performing Index fine tuning and data integrity reviews.
• Performing Database archiving and restores
• Scheduling and Performing routine maintenance.

Environment: MS Visual InterDev 6.0, Visual Basic 6.0, Crystal Reports, VBA, Sequel Server 2000, SQL, MS Access 97/2000./XP

Education:

Snow College, Ephraim, Utah

Associate, Business Administration, 1995

GPA: 3.5. Dean's List award for three consecutive quarters.

Certifications:

Microsoft Certified Professional (MCP) in Visual Basic 6.0

Brain bench Certified Professional in Visual Basic 6.0

Brain bench Certified Professional in Visual Basic 5.0?

Brain bench Certified Professional in Vbscript

Microsoft Office User Specialist Certification as an Access Expert

I can also be found on twitter: SqldbGuy

and LinkedIn:

http://www.linkedin.com/pub/malik-al-amin/9/266/223