PROFESSIONAL PROFILE

Versatile bilingual IT specialist experienced in all phases of the system development life cycle. Keen analytical and problem solving skills, complimented with a computer science and mechanical engineering background. Works well independently and as a team member. Delivers outstanding bottom line results. Self-starter in mastering new technology and committed to staying current in industry. Expertise includes:

Database Engineering Software Engineering Systems Engineering Spanish Communications

PROFESSIONAL DEVELOPMENT

PROFESSIONAL EXPERIENCE

Database Consultant

Confidential

• Team member on an Anti-Money Laundering Project under the Confidential Secrecy Act umbrella
• Implemented a series of controls on data flow processes from source to intermediate to destination systems centralized in SQL Server 2012

• Provided direction on techniques to accomplish mission objectives
• Developed solutions to meet business requirements
• Developed tables, triggers, stored procedures, Windows command-line scripts, SSIS packages, and jobs to implement and automate controls on the data as it passed through layers of processing
• Provided client with code to create credentials and proxies to associate SQL Server service accounts with domain accounts with extended permissions for use with file share access
• Provided permission requirements LSP for the SQL Server service accounts on the Windows servers that contained SQL Server instances
• Provided instruction on the subject of permissions vs. performance of linked servers
• Assisted with the installation and testing of Team Foundation Server features
• Analyzed stored procedures and views and created indexes to improve performance of reports in a data warehouse environment
• Provided direction on techniques to troubleshoot existing stored procedures for performance and stability in a data warehouse environment
• Provided direction on techniques to accomplish mission objectives with the use of Data Quality Services and the DQS Cleansing Task

Senior Database Performance Tuning and Documentation Consultant

Confidential

• Executed advanced performance assessments on nine SQL Server Failover Cluster Instance servers that included Database Design, Processor Performance, Memory Performance, Storage Performance, Network Performance, and much more
• Identified and documented all Service Broker configurations and errors
• Identified and documented all hardware and software attributes
• Identified and documented all WSFC and SQL Server FCI settings
• Identified and documented all Linked Server settings and advised on their usage
• Identified and documented all SQL Server security concerns
• Used PERFMON, SQL Trace, SQL DMV's, TSQL Scripts, PowerShell, Windows Commands, and third-party tools as part of the engagement
• Presented findings and made recommendations to senior level personnel

SQL Server 2012 Database Architect Consultant

Confidential

• Designed database solution that included architectures using SQL Server AlwaysOn Availability Groups for high availability and disaster recovery on one set of servers and SQL Server SSIS and SSRS on another server with failover implemented at the VMware layer in a Microsoft Dynamics AX environment
• Implemented SQL Server AlwaysOn Availability Groups solution across servers on a Windows Server Failover Cluster

SQL Server 2012 SSIS Consultant

Confidential

• Designed and developed SQL Server 2012 SSIS ETL packages in a Microsoft Dynamics AX 2012 database environment
• Designed and developed complex stored procedures that were used in the SSIS packages
• Created jobs to execute the SSIS packages
• Administered security with respect to the jobs
• Documented all SSIS processes
• Trained database administration personnel on how to create, convert, and deploy SSIS packages, create jobs, and administer security
• Identified a serious performance bottleneck at the disk IO layer as a result of the Windows installation and addressed the concern with the client and the data center host
• Identified problems with the SQL Server failover cluster with regard to features that were expected to be implemented in the production environment
• Proposed database architecture solutions that included SSIS, SSRS, and SSAS features using AlwaysOn Availability Groups for High Availability/Disaster Recovery and for offloading reports and backups

Senior Database Performance Tuning Consultant

Confidential

Performed advanced performance assessments on their database servers that included Database Design, CPU Utilization, Memory Utilization, Disk IO, Blocking, Network, Database Connections, Security, Hardware/Software Attributes, VMware installations, Windows OS installations, etc.

Senior Database Performance Tuning Consultant

Confidential

Performed advanced performance assessments on two failover clustered database servers, one hosted in a cloud environment and the other hosted internally, that included Database Design, CPU Utilization, Memory Utilization, Disk IO, Blocking, Network, Database Connections, Security, Hardware/Software Attributes, VMware installations, Windows OS installations, etc.

Senior Database Administrator Consultant

Confidential

• Managed database servers running SQL Server 2000-2012 that included installing new database instances, creating new databases and schemas, and maintaining and upgrading existing databases in a 157 database, 600 GB hybrid OLTP production environment
• Designed and developed coded objects such as tables, views, indexes, keys, constraints, triggers, stored procedures, functions, SSIS packages, and jobs for performance, stability, scalability, reliability, and maintainability
• Performed advanced performance assessments that included Database Design, CPU Utilization, Memory Utilization, Disk IO, Blocking, Network, Database Connections, Security, Hardware/Software Attributes, etc. on standalone and in clustered environments
• Created broad array of scripts for analyzing, troubleshooting, and resolving database issues using SQL Server metadata that included system tables, views, and stored procedures, data management views and functions, configuration options, performance counters, SQL Trace, DOS commands, etc.
• Wrote PowerShell scripts to collect WMI and SQL Server attributes
• Designed and developed process to monitor disk space usage that included data file sizes, log file sizes, database sizes, unallocated spaces, reserved spaces, data sizes, index sizes, and unused spaces for all databases in the instance on a quasi-real time basis
• Designed and developed process to monitor SQL Server service restarts and unused indexes, primary keys, constraints, and heaps within each restart interval for all databases in the instance
• Designed and developed process to identify indexes that had redundant columns for all databases in the instance
• Provided substantial input on hardware/software implementation with regard to SQL Server 2005 to 2012 migration project
• Provided load transference rates and other guidance on selecting new and upgrading existing hardware for database migration project
• Created Windows and SQL Server 2012 Failover Cluster Project Plan
• Created Windows and SQL Server 2012 Failover Cluster Project Plan with AlwaysOn Solution
• Created SQL Server 2012 Upgrade Project Plan
• Created SQL Server 2012 SSIS Migration Plan
• Implemented Windows Server 2012 Failover Cluster and SQL Server 2012 Failover Cluster Instance on VMware ESXi 5.1 and Dell Compellent SAN using storage best practices in union with one of the network engineers
• Implemented Windows Server 2008 R2 Failover Cluster and SQL Server 2012 Failover Cluster Instance on VMware ESX 5.1 and Dell Compellent SAN using storage best practices in union with one of the network engineers
• Partitioned disks according to best practices for SQL Server in union with one of the network engineers
• Provided guidance to network team in resolving technical issues affecting database performance and modification of databases due to application upgrades
• Modified data recovery models, backup strategies, and log filegrowth properties for performance and stability
• Created new maintenance plans that included backups, optimizations, and integrity
• Restored databases and created new databases from backups
• Designed and developed scripted data loads and conversions
• Migrated databases between environments
• Supported database environments and provided code review for web development team
• Mentored developers to expand their database skills
• Created procedure to more effectively manage jobs by displaying all attributes in a single result set
• Identified and resolved SSIS package problems that were causing job failures
• Created new SSIS packages and jobs to meet project requirements
• Created Risk Management Plan and Project Plan for Historical Tax Credits Project
• Implemented Change Data Capture processes in relation to Historical Tax Credits Project to load data into a warehouse for fixed data, change data, and historic data scenarios using TSQL as opposed to using Slowly Changing Dimensions for performance reasons
• Worked with COBOL mainframe programmers to develop mainframe extracts and to model the data before migration
• Designed and developed ETL solutions to migrate mainframe data for performance, stability, scalability, reliability, and maintainability
• Designed and developed data warehouse solutions for performance, stability, scalability, reliability, and maintainability
• Developed WinSCP scripts and Windows batch scripts to transfer data files between SFTP and file servers as part of data flow processes
• Identified VB.NET inline, ad-hoc query source code in Visual Source Safe and Team Foundation Server as data sources for migration tasks
• Used .NET Reflector to decompile .dll files to identify source code because code behind pages could not be located in VSS or TFS
• Scripted Peer-to-Peer Replication, Policies, Extended Events, and Event Notifications in development environment
• Installed instances of SQL Server 2012 Enterprise and Developer editions
• Performed extensive research on new features, migrations, and upgrades with regard to SQL Server 2012 including considerations on moving the database server to the cloud
• Interviewed application developers for new job requisitions

Database Consultant

Confidential

• Performed consolidation, migration, and performance tuning engagements in alliance with Hewlett Packard and Microsoft Corporation
• Interviewed client team members to gain understanding of hardware/software architecture
• Performed hardware, software, and performance data collection at client sites
• Analyzed data and developed options based on data
• Developed performance and configuration profiles of selected servers
• Identified performance bottlenecks on selected servers
• Identified dimensions of isolation for selected servers
• Designed solutions that included virtualization, database stacking, etc.
• Provided guidance on amount of effort in performing respective implementations
• Provided implementation methodology
• Provided hardware recommendations
• Provided end-to-end costs
• Completed the following projects

Used tools such as SQL Server 2008 R2, SQL Trace, SQL Scripts, DMVs, SQLDiag, SQLNexus, RML, PowerShell, Performance Counters, WMI, Windows Registry, CPUZ, Excel, TextPad, Oracle 11g, Oracle Trace, etc. to perform my work

Database Consultant

Confidential

• Advised on the significance of database design, resource utilization, and system performance in identifying bottlenecks
• Advised on performance tuning using Query Analyzer, SQL Profiler Trace, and Database Engine Tuning Advisor
• Advised on short and long term capacity planning
• Performed data modeling and data mapping using normalization in OLTP environments
• Installed new instances of SQL Server and created databases for performance and stability
• Designed and developed SSIS and SSAS projects
• Implemented partitioned tables and indexes using partition functions and partition schemes
• Developed a private client/server network which consists of a Windows 2000 Advanced Server EE, two Windows XP Pro machines, and a Linksys router/switch/firewall

Software Design Engineer 4 Consultant

Confidential

• Designed and developed coded objects such as stored procedures, XML schema collections, tables, constraints, keys, indexes, triggers, views, and functions in an OLTP environment under the Licensing, Pricing, and Organizations LPO Entitlement Management Component EMC group to automatically allocate benefits for the Software Assurance Benefits SAB and MSDN programs for Microsoft Licensing MSL
• Analyzed and optimized database performance using Query Analyzer, Profiler TSQL, and Database Engine Tuning Advisor
• Met and worked with developers to effectively understand queries
• Wrote technical specifications on designed and developed processes
• Established and documented the EMC code build process

Lead Database Developer Consultant

Confidential

• Performed requirements definition for a Mumps to SQL Server 2005 data migration project for the HealthTrax Fitness Wellness Program
• Performed data modeling and data mapping using normalization in OLTP environments
• Installed new instances of SQL Server and created databases for performance and stability
• Designed and developed the data migration architecture both logically and physically
• Designed and developed tables, triggers, views, indexes, and stored procedures
• Designed and developed complex data analysis and data fix scripts to identify and correct data anomalies
• Designed and developed complex DTS packages including VBScripts to import/export data
• Designed and developed data load processes to rebuild a data warehouse using SSIS and DTS
• Designed and developed scripts to test the before/after data warehouse content
• Migrated all coded databases objects across dev test prod servers
• Performed database administration back ups, restores, linked servers, security, log file monitoring, database shrinking, etc
• Performed short long term capacity planning and advised on hardware considerations for scalability
• Mentored other database and application developers

Database Developer Consultant

Confidential

• Created and revised coded database objects that included tables, views, indexes, constraints, triggers, and stored procedures in a normalized 200 GB Sybase ASE 12.5 OLTP environment to accomplish very complex business requirements for the Common Pleas Criminal Management System used to manage all criminal court cases in the State
• Developed and modified procedures to process payments made on cases so that monies got applied in appropriate proportions to assessments and disbursed to recipients and to create bank account register entries to log bank account transactions according to business rules
• Developed replicated data transfer methods between appellate court and criminal court management systems
• Developed scripts to analyze intricate accounting data
• Developed complex utility scripts to fix data-related migration and development errors
• Employed value object arrays to store and retrieve data in stored procedures from JAVA classes stored in the databases
• Optimized stored procedures and scripts for performance and stability
• Became a financial transaction specialist who gained intimate knowledge of the database structure and intricacies of processing accounting related data and was tasked with training newly hired database developer team lead and database analysts

Database Consultant

Confidential

• Created coded database objects to meet the requirements of the application developers in an OLTP environment
• Coordinated security approaches to database objects
• Created cube with SQL Server Analysis Manager and pivot table with Excel

Application Developer 3 Consultant

Confidential

• Entered short-term contract with the Department of Health Bureau of Information Technology to develop a Web based system to provide electronic submission and tracking of hospital applications for federal bioterrorism grant funds in an OLTP environment
• Participated in the analysis, design, coding, and testing of the Web application
• Gathered user requirements
• Created data models using normalization and flowcharts for development using Visio
• Designed and developed the database schema
• Created tables, views, stored procedures, and functions using complex TSQL
• Created DTS packages and code procedures to import data from Excel spreadsheets into SQL Server
• Wrote HTML code that included HTML and Web Form controls to create user interfaces that conformed to AccVerify
• Wrote JavaScript and VBScript to handle client side processing
• Wrote VB.NET code to handle server side processing
• Created Crystal Reports for Visual Studio .NET
• Created development team and user acceptance test plans
• Coached team members on development strategies

Student Independent Contractor

Confidential

• Attended 19 classes in the MCSE, MCDBA, and MCAD .NET certification tracks while performing independent contract services
• Implemented all technologies contained in the certification domains on my private network

Software Engineer

Confidential

• Executed all major life cycle phases of system development in three domestic sales departments with combined annual sales of 95 million
• Developed processes that integrated multiple business applications from inception to fulfillment of medical book orders
• Created SQL Server objects tables, views, stored procedures to develop new data flow processes in an OLTP environment
• Wrote batch, BCP, SQL, and format files to import/export data between databases
• Developed application changes to SalesLogix for both remote and network users
• Wrote VB modules to modify applications to meet business needs
• Wrote VBA code using OOD/OOP to create reports and utility programs
• Wrote VBScripts to modify registry and other settings for application users
• Wrote Wise InstallMaster scripts to manage databases, application files, and Windows settings on remote computers
• Provided second-level technical support for SalesLogix and other applications

Programmer Analyst - Spanish Interpreter

Confidential

• Executed all major life cycle phases of system development in an OLTP environment for a small, privately owned business in the beginning-intermediate stage of integrating information technology into its business
• Analyzed and documented engineering, manufacturing, and business processes involved in the creation of products to completion of orders
• Developed an experimental, complex order-entry system based on the above-performed analyses using OOD/OOP with VBA code
• Assisted in the design and implementation of SQL Server on a Windows NT machine as the company's primary DBMS
• Created VBA code modules using OOD/OOP to modify the company's primary front-end application to meet business needs
• Installed new hardware and software and implemented network security
• Developed new and modified existing web pages
• Served as Spanish interpreter

Programmer Analyst

Confidential

Developed database-backed Web applications using Oracle, WebDB 2.2, SQL Plus, HTML, and PL/SQL in an OLTP environment

Sales Engineer

Confidential

Distributed control systems consultant and sales representative

Mechanical Engineer Supervisor

Confidential

• Coordinated maintenance and repair of industrial equipment in a steel manufacturing facility
• Supervised an 11 man union workforce

Mechanical Engineer

Confidential

Designed and tested coaxial connectors

Mechanical Engineer

Confidential

Developed a system to track equipment and structural layout of the coal combustion power generation plant