MIKE BABAPOUR

*** ********** ***

Ladera Ranch **694

acrqsp@r.postjobfree.com

949-***-**** (Cell)

949-***-**** (HM)

Software design, development, integration, and networking solutions, experience with exposure to the entire software development life cycle

Education:

Bachelor of Science – Software Engineering, University of Shahid Beheshti, October 1994

Technical Skills:

Development: deep understanding of SDLC (System Development Life Cycle) and project management.

Languages: T-SQL, PL/SQL, MDX, VB,C#

Software: SQL Server (2000, 2005, 2008 R2 and 2012), ERWIN, ERStudio, VISIO, VSS, SSIS, SSRS, SSAS, Crystal reports, OLAP Cubes.

Effective team capacity management, meeting management and performance feedback.

Excellent ability to manage a team of developers (offshore and onshore) effectively by doing design and code review onshore and development offshore.

Multi-dimensional databases and star schema

OLAP/OLTP-oriented database design.

Establishing a SDLC for database development including designing, reviewing design by the team members, identifying all impacted components, coding, reviewing codes by the team members, unit testing, documenting unit test result, system testing, documenting system test result, documenting query plans and usage of indexes.

Ability to work well with others to accomplish a common goal.

Flexible and able to juggle multiple tasks simultaneously.

Professional Experience / Accomplishments:

VEROS Credit, Santa Ana, CA

Data Base Administrator December 2014 – August 2015

Created stored procedures, triggers functions and views.

Facilitated data transfer between internal and external database/resources using SSIS packages and SQL Server functions and stored procedures.

Created Jobs to connect to linked servers in multi platforms environment like Oracle, SQL, flat file databases and import data into different databases.

Created codes to import XML files into databases, and created codes to export XML files, using SQL server xml path, auto and explicit.

Created maintenance plan to check database integrity, rebuild indexes, backup databases, automatically moved to alternate servers.

Installed SQL Server report server and created new SSRS reports per customer unique requirements, and created schedule to send reports automatically to recipients.

Install and configure new SQL Server instances, install new patches and Worked on SQL Server 2012 and 2014 migration from SQL Server 2008 / 2005.

Worked extensively on Clustering and server consolidation.

Working in agile scrum environment to define story, tasks and related subtasks to achieve desired goals.

Set up SQL Server Always on High Availability group.

Database Network Training Group (DNTG), Cerritos, CA August 2013 – November 2014

Data Base Administrator

Install and configure new SQL Server instances, install new patches and Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Worked extensively on Clustering and server consolidation.

Administering SQL Server High Availability and Disaster Recovery strategies and setup transactional and merge replication, log shipping and mirroring in complex environments.

Working in OLTP environments and designing OLAP databases.

Gathering business user requirements to design CUBES (SSAS) and Reports (SSRS) – consist of 9 dimensions, 5 fact tables, 4 cubes and 35 SSRS reports.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Expert in data transformation like bcp, sqlcmd and bulk insert.

Using SQL Server profiler to collect workload and use tuning advisor to suggest appropriate indices to improve performance.

Experience in using DMV and dynamic management functions for finding out long running queries.

Designing advanced and optimized SSIS packages to handle ETL data load from OLTP database and third party sites to data warehouse.

Create complex SSRS reports like, linked reports, sub reports, parameterized reports, using Crystal Reports in order to satisfy users report demands.

Expertise in T-SQL writing stored procedures, functions and triggers.

Design and create new databases according to new system definitions.

Setup SQL SERVER logins, users, database roles and resolving orphan users problem.

Working with DBCC commands to shrink database and log files.

Use maintenance plan and created automatic backup, reorganized and rebuilt indices.

Use power shell and Visual Basic scripts to manage backup drives over local and alternate network drives.

Setup SQL Server database mail and agent to send automatic alerts and notifications.

Developing new codes to accomplish users request, and debugging existing codes written in C# and VB.net, VBA coding, using ASP.NET to produce dynamic web pages.

National Merchant Center (NMC), Irvine, CA April 2012 - July 2013

Data Base Administrator

Designed and Maintained large OLTP and OLAP databases to handle over 2 million transactions.

Designed partitioned tables to optimize queries and facilitate archiving old data from OLTP and OLAP databases.

Logged shipping, replication and clustering in support of SQL Server failover.

Performed SQL Server and Windows performance monitoring and tuning.

Implemented and maintained database security (created and maintained users, database roles and assigned privileges)

Created SQL server auditing both in SQL server instance and database sides to find security problems and fixed as appropriate.

Maintained databases availably and scalability by automated maintenance plans and SQL Server jobs.

Developed SQL server complex stored procedures, functions, triggers.

Extensively worked on SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Crystal Reports.

Designed advanced and optimized SSIS packages to handle ETL data load from OLTP database and third party sites to data warehouse (total size of databases is 2TB)

Developed stored procedures and triggers for server based processing.

Pars Mine & Industry Construction Company May 2005 - Dec-2011

Data Base Administrator

Setup ORACLE jobs and backups, created different packages and codes using Oracle developer version 10G.

Migrated SQL Server database from v2000 to v2005 and v2008.

Automated backup and restored databases to simulate log shipping.

Partitioned large tables to increase database performance.

Created complex stored procedure and views to facilitate data extraction.

Developed office automation project by c#.net and designed SQL server requirements.

Managed a team of five developers to reach required software.

Developed the existing accounting and payroll software to improve capability and flexibility.

Designed inventory system and built the structure of merchandise coding.

Administration on ERP system in order to match with company’s business rules and workflow.

Supported all the UNIX requests for various applications.

Parsian Ecommerce Company May 2004 – May 2006

Senior system expert (Consultant)

Developed and upgraded critical stored procedures in SQL server to calculate and generate customers’ monthly bills.

Managed and developed new program demand for company's customer service department by c#.net.

Resolved performance issues using SQL Server profiler.

Used maintenance plan to automate daily full, differential, and transactional backups.

Managed OLAP databases to create summary tables for reporting purposes.

Led optimizing database codes project and improved efficiency.

Installed and configured MS SQL Server 2005 version.

Experience in creating Jobs, Alerts, and SQL Mail Agents.

Arya Banader Iranian Company Feb 2004- June 2004

System analyzer and developer (Consultant)

Designed and developed payroll and accounting systems in conceptual and database levels.

Installed and configured MS SQL Server.

Implemented MS SQL Server Security and Database Authentications.

Designed tables, Indices and performance tuning.

Performed import & export of various data formats using DTS, BCP, and Bulk Insert.

Created database backup, recovery and disaster recovery procedures.

Worked closely and efficiently with all levels of management to satisfy project and productivity requirements.

Khaneh Sazi Iran Company (Social Security Organization) April 1995 - May 2005

IT department manager

Used Access, FoxPro and Dataease for creating software running various aspects of company’s business such as accounting, payroll, and inventory.

Installed, upgraded, designed, and implemented SQL Server v2000.

Performed SQL server database administration, system analysis, design, and development tasks.

Created schema objects and database roles.

Created database backup, recovery and disaster recovery procedures.

Created database and database objects such as tables, stored procedures, views, triggers, and functions.

Worked on DTS packages to import data from Fox Pro, Dataease, Access and text files.

Developed project documents, installation documents and user manuals.

Kamyoun Bar Company Aug 1995 - October 2002

Computer Software (Consultant)

Analyzed, designed and developed contracts, transportation and accounting systems.

Contact this candidate