SUMMARY

Goal - oriented and results driven IT Professional. I am dedicated to cutting cost through innovation and technology. I have been successful in my career in building motivated and dynamic teams.

SUMMARY OF QUALIFICATIONS:

• Management ( Operations )
• Budgeting
• Project Management
• Waterfall Methodology
• Agile (SCRUM)
• SQL Server
• SSIS
• SSAS
• SSRS
• Service Broker
• Power BI
• Master Data Services (MDS)
• Always On
• Replication
• Log shipping
• Change Data Capture
• Powershell
• Postgres
• Progress
• Sybase
• ERP
• Sage MAS 500
• Sage MAS 90
• Sage Saleslogix
• Epicor 9
• MS Dynamics - GP ( 8.0, 9.0)
• Database Architect
• Warehouse Design (Kimball, Inmon)
• Extraction Transform Load (ETL)

PROFESSIONAL EXPERIENCE:

Confidential

DB Manager

Responsibilities:

• Managed a team of 14 developers 2 supervisors
• Oversee day to day operations of Data Farm
• Implemented Agile (SCRUM) to deliver
• Authored new policies Database management
• Manage budgets
• Payroll
• Software
• Infrastructure
• Mange software vendors Conduct in-depth technical analysis of all DB systems, including the governance framework, architecture, and disaster recovery and business continuity.
• I delivered gap analysis and recommendations, attaining higher up time.
• Manage import/export of EDI files

Confidential

BI/DBA/Integration Developer

Responsibilities:

• This is a government contactor. I am limited in what I can post on my resume.

Confidential

BI Developer

Responsibilities:

• Create Logical/Physical Models for warehouse design ( Kimball Method )
• Gathered and Documented warehouse design
• Project Charter
• Visio Diagrams
• Requirement documents
• Schema and data dictionary
• Integrate Multiple sources into warehouse
• Created backup architecture via powershell
• Normalize all source data into unified schema
• Managed Master Data Management (MDM) implementation
• Created RFP Requirements
• Managed the Q&A process from vendors
• Created all user stories for Proof of Concept (POC)
• Staged data for POC
• Responsible for all communications between Stakeholders, Management and Implementation team

Confidential

Principal Data Architect

Responsibilities:

• Create Logical/Physical Models for warehouse design ( Kimball Method )
• Gathered and Documented warehouse design
• Project Charter
• Visio Diagrams
• Requirement documents
• Schema and data dictionary
• Integrate Multiple sources into warehouse
• Normalize all source data into unified schema
• Managed Master Data Management (MDM) implementation
• Created RFP Requirements
• Managed the Q&A process from vendors
• Created all user stories for Proof of Concept (POC)
• Staged data for POC
• Responsible for all communications between Stakeholders, Management and Implementation team

Confidential

Database Architect (Consultant)

Responsibilities:

• Data Architect
• Create Logical/Physical Models for warehouse design ( Kimball Method )
• Gathered and Documented warehouse design
• Project Charter
• Visio Diagrams
• Requirement documents
• Schema and data dictionary
• Integrate Multiple sources into warehouse
• Normalize all source data into unified schema
• Created SSIS package for ETL Process
• Create suite of SSRS reports
• Implemented SSAS
• Tabular
• OLAP
• Created Portal for management of Data warehouse
• Role assignments
• ETL log information
• Integrity Checks
• Record counts
• Item amount verifications
• Implemented “Always On” cluster to multiple locations ( Read - Only)

Confidential

IT Manager \ Database Architect \ DBA

Responsibilities:

• IT Manager
• Managed development team of 7
• Ran daily stand-ups (SCRUM)
• Managed budgets
• Software
• Employee salaries
• Consultants
• Responsible for shaping IT direction
• Responsible for communication between IT and management
• Developed/Maintained Project Documents
• Project Charters
• Statement of Work
• Meeting Minutes
• Assumption List
• Change Logs
• Developer
• Custom Stored Procedures
• Service Broker integration
• Custom Triggers
• Custom SSIS packages
• Importing / Exporting Data
• Data manipulation
• Processing Dimensions and Cubes
• WMI integration
• Web Service Integration
• Custom Reports using SSRS
• Custom Dashboard
• Dynamic parameter driven reports
• SSAS driven reports
• SharePoint Integration
• Architect
• Designed OLTP website design
• Designed Financial Data warehouse
• Architectural Designs include
• Hierarchical
• 3rd Normal Form
• Nested Set
• 2nd Normal From (Data Warehouse)
• Created backup scripts via Powershell
• DBA
• Manage 60 instance server environments. Databases sizes range from 20 gigs to 1.5 Terabytes
• Implement Replication
• Snapshot
• Transactional
• Perform database space management, including extent checks and extending database space as needed
• Performed standard database operations including exports, imports, table restorations, and reorganizations appropriate for the support level
• Performed database installs/upgrades
• Performed database recoveries on production platforms
• Ensure proper security policies and procedures are in place and enforce appropriately at the team and database environment levels
• Provided leadership, mentoring, and technical assistance to junior team members
• Performed comprehensive reviews of database environments and operations.
• Provided thorough documentation, observations and recommendations according to DBA Team best practices
• Created custom SSRS reports and SSIS packages.
• Designed Maintenance system for 50 server instances
• Capture pre/post statistics
• Capture growth rates
• Consolidated Reporting System(SSRS)
• Ability to schedule different maintenance functions
• WMI integration to capture problem queries. If CPU or Memory rises above a certain threshold…jobs will capture queries that are currently running.
• Build scripts that include:
• Database Creation( based on the Model db )
• Maintenance Jobs
• Integration with Central Management
• Implement “Always on” cluster to multiple locations
• ERP Implementation
• Project Lead for Epicor 9 (E9) rollout
• Responsible for Setup
• Financials
• Material Management
• Order Management
• Designed Project Charter
• Designed Workflows for Modules
• Created / Maintained project plans

Confidential, Culver City, CA

Database Architect \ DBA

Responsibilities:

• Developer
• Custom Stored Procedures
• Service Broker integration
• Custom Triggers
• Custom SSIS packages
• Importing / Exporting Data
• Data manipulation
• Processing Dimensions and Cubes
• WMI integration
• Web Service Integration
• Custom Reports using SSRS
• Custom Dashboard
• Dynamic parameter driven reports
• SSAS driven reports
• SharePoint Integration
• Architect
• Designed Maintenance system for 300 server instances
• Capture pre/post statistics
• Capture growth rates
• Consolidated Reporting System(SSRS)
• Ability to schedule different maintenance functions
• WMI integration to capture problem queries. If CPU or Memory rises above a certain threshold…jobs will capture queries that are currently running.
• Build scripts that include:
• Database Creation( based on the Model db )
• Maintenance Jobs
• Integration with Central Management
• DBA
• Perform database space management, including extent checks and extending database space as needed
• Performed standard database operations including exports, imports, table restorations, and reorganizations appropriate for the support level
• Performed database installs/upgrades
• Performed database recoveries on production platforms
• Ensure proper security policies and procedures are in place and enforce appropriately at the team and database environment levels
• Provided leadership, mentoring, and technical assistance to junior team members
• Performed comprehensive reviews of database environments and operations.
• Provided thorough documentation, observations and recommendations according to DBA Team best practices
• Created custom SSRS reports and SSIS packages.
• Setup Database Mirroring and Log Shipping

Confidential, Culver City, CA

DB Manager \ Database Architect \ DBA

Responsibilities:

• Managed 4 DBA’s (2 Offshore)
• Identify Problem Queries and divide among the DB team
• Managed budgets
• Software
• Employee salaries
• Consultants
• Responsible for shaping IT direction
• Responsible for communication between IT and management
• Created architecture for new software products
• Implemented New SAN Solution (Clarion CX 380)
• Upgraded Servers from 2000 to 2005 (64 bit)
• Lead Administrator of a 20 terabyte database.
• Upgraded all database from 32 bit 2000 to 64 bit 2005
• Designed the entire maintenance infrastructure for OLTP environment.
• Create backups strategies for the OLTP
• Created and Maintained archiving process for OLTP
• Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects
• Design and trouble-shoot custom Stored Procedures, Triggers, Functions with SQL Server
• Installed and maintained infrastructure for BizTalk
• Created Rules using BizTalk
• Maintained BAM
• Installed, configured, and maintained SharePoint Server 2007
• Performed performance audits
• Install/Configure SQL Server 2005
• SQL Server Analysis Services
• SQL Reporting Services
• SQL Integration Services
• SQL Replication
• Transactional
• Snapshot
• Create/Maintained modeling for Physical and Logical design
• Maintained architecture using ER Studio (Embarcadero Suite)
• Practice SDLC principals

Data Warehouse Administrator \ Developer

Confidential

Responsibilities:

• Created Custom ETL process for warehouse.
• Combined Several databases into one warehouse
• Create reports using Crystal Reports and SQL Reporting services
• Created and Designed OLAP Cubes

Project Manager

Confidential

Responsibilities:

• Trained in Agile Project Management Methodology (SCRUM)
• Trained in Waterfall Project Management Methodology
• Managed Data warehouse Project
• Designing Specifications
• Pre/Post Documentation for any changes to the system
• Lead Daily Stand-ups (SCRUM)
• Maintained Documentation
• Provide budget forecasting for Capital Expenditures
• Implemented 5 node virtual cluster
• All nodes active
• Live migration of images
• Priority Failover

Confidential, Los Angeles, CA

Database Architect

Responsibilities:

• Lead Administrator of a 40 terabyte database.
• Designed the entire maintenance infrastructure for OLTP environment.
• Manage Replication of database across Several servers in 3 data centers
• Install/Configure SQL Server
• Create Data warehouse(s) for OLTP.
• Created Custom ETL process for warehouse.
• Create backups strategies for the OLTP
• Performance tuning for system
• Write Custom ANSI - 92 Standard SQL queries
• Create reporting customizations in Crystal Reports and SQL Reporting services
• Pre/Post Documentation for any changes to the system
• Design and trouble-shoot custom Stored Procedures, Triggers, Functions with SQL Server
• Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects

Confidential, Los Angeles, CA

Senior Technology Consultant

Responsibilities:

• Installed ERP software applications (MAS 500, Great Plains, Solomon).
• Provide technical support and training to existing ERP clients and upgrade systems to latest software versions
• Migrate data from previous system to new ERP system
• Install/Configure SQL Server
• Create Data warehouse(s) for ERP applications.
• Created Custom ETL process for warehouse.
• Create backups strategies for ERP Application
• Run SQL profiler to identify potential bottlenecks
• Create hardware specification for ERP application
• Write Custom ANSI - 92 Standard SQL queries
• Create reporting customizations in Crystal Reports
• Screen Customizations using ERP customization tools
• Post implementation support for client(s). Including maintenance, debugging, and optimization
• Manage database(s) processes with SQL Server
• Create data fixes for corrupted data in MAS 500 via SQL Server
• Design and trouble-shoot custom Stored Procedures, Triggers, Functions with SQL Server
• Trouble shoot application process
• Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects
• Optimize performance for Stored Procedures with SQL Server. Insuring queries are using the best query plan
• Created Custom ETL process for warehouse.
• Combined Several databases into one warehouse
• Create reports using Crystal Reports and SQL Reporting services
• Created and Designed OLAP Cubes
• Assist design team with new features

Confidential, Irvine, CA

Implementation Consultant\Support Engineer

Responsibilities:

• Installed ERP software applications (MAS 500). MAS 500 contains Financials, Distribution, and Manufacturing
• Provide technical support and training to existing ERP clients and upgrade systems to latest software versions
• Migrate data from previous system to new ERP system
• Install/Configure SQL Server
• Create backups strategies for ERP Application
• Run SQL profiler to identify potential bottlenecks
• Create hardware specification for ERP application
• Write Custom ANSI - 92 Standard SQL queries
• Create reporting customizations in Crystal Reports
• Screen Customizations using ERP customization tools
• Post implementation support for client(s). Including maintenance, debugging, and optimization
• Manage database(s) processes with SQL Server
• Create data fixes for corrupted data in MAS 500 via SQL Server
• Design and trouble-shoot custom Stored Procedures, Triggers, Functions with SQL Server
• Trouble shoot application process
• Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects
• Optimize performance for Stored Procedures with SQL Server. Insuring queries are using the best query plan
• Assist design team with new features

Confidential

Database Developer/DBA

Responsibilities:

• Manage database(s) processes with SQL Server
• Managed replication process via Tsunami software
• Design\Trouble shoot custom Stored Procedures, Triggers with SQL Server
• Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects.
• Optimizing performance for Stored Procedures using SQL Server. Insuring queries are using proper indexes.
• Use database utilities to perform analysis to determine bottlenecks.
• Upgraded SQL Server from 6.5 to 2000
• Created custom Stored Procedures