PROFESSIONAL SUMMARY:

I am seeking a development position in Information Technology with the focus on SQL Server Database Administration and BIDS/SSMS. I am highly motivated with strong analytical skills and understand complex business processes. My technical skills include systems optimization, SDLC, database design and administration, database optimization, business processes improvements, customer satisfaction and employee mentoring and training. I have excellent technical writing skills which I have prepared user manuals and procedural documentation.

TECHNICAL SKILLS:

Languages: Visual Basic, ASP.NET, VB.NET, XML, VBA, SQL, T - SQL, PL-SQL, VBScript, JavaScript, HTML, PHP

Software: InfoPath 2003, SharePoint Services 2003/2007, SharePoint Portal Server 2003, iMacros, HIPAATalk, CodeCharge 4.3 Studio, Angel, Case Complete, .NET 2003/2005/2008/2010 , .NET Framework, BizTalk2009, Net Beans 6.7, IIS 6.0/7.0, Active Directory, LDAP, Web Services, ASP.NET, C#

WORK EXPERIENCE:

Senior SQL (DBA) Database Administrator/Developer/Analyst

Confidential

Responsibilities:

• Support for Microsoft Azure IaaS and SQL Azure DBaaS Environments
• Cloud/On - Premises database management
• Synchronization using Data Sync toolset
• Review and document PaaS migration strategies
• Database design and development using SQL Azure, SQL Server, Microsoft Access
• Experience with Agile/Scrum and Waterfall software development methodologies
• Create linked services, datasets, pipelines and data factories per LOB
• Visual Studio 2015 - SSIS Packages/SSRS reports/SSAS cubes
• SQL Server 2012/2014/2016
• Excel import/export transfer to SQL Server
• Visio data diagrams for business process workflows
• Manage 8 to 10 employees
• Remote Desktop Connection for server connectivity
• Multiple Environments - DEV, TEST and PROD
• Advanced stored procedures including dynamic SQL
• Administration and Security - create and assign db roles
• Create and schedule SQL Jobs
• Visual Studio Team Services
• Implemented best practices for SQL script writing and package configuration
• Designed complex ETL strategies to pull data from various sources like SQL Server, flat files, Excel files and Oracle databases and load into destination databases utilizing different types of transformation
• Designed high level ETL Architecture for overall data transfer from the source server to the Enterprise Services Warehouse including server names, database names, accounts, tables and direction of data flow, column mapping, data dictionary and Metadata.
• Implemented stored procedures and enforced business rules via checks and constraints
• Created new SSIS packages and implemented those packages in DEV, TEST and PROD
• Monitored SSIS packages for performance analysis and data optimization
• Implemented Master Child package model for easier maintenance, reusability and better performance
• Implemented the logging process for all SSIS packages for troubleshooting and traceability
• Auditing and tracking package runtimes
• Involved in data profiling, identifying data quality issues thru data analysis, impact analysis and data model enhancements
• Involved in development phase scrum meetings for business analysis and requirements gathering with department managers and users
• Developed Data Mapping, Data Governance and transformation and data cleansing rules for Master Data Management Architecture involving OLTP/OLAP
• Used TFS for version control and moving code from one environment to another environment
• Visual Studio 2015 - SSIS Packages
• Build File Layouts and Data Points
• File Monitor Import custom application tool
• Prepare SQL scripts to run in all environments
• ETL and data feeds/over 25 LOB’s
• Developed, implemented and evaluated metadata and cataloging workflows and standards
• VB.NET and C# script task coding
• SQL Server 2014/2016
• Performance tuning and monitoring
• Tracking of data bottlenecks and blocking
• SQL Server Profiler
• Manage 6 to 8 employees
• 600 Servers with terabytes of data
• International client-base
• Advanced stored procedures including catch try and raiserror messages
• Financial implementation of AR, AP, GL, HR, INV and Payroll
• Analyze business needs for client objectives
• Oracle software solutions for ERP Cloud
• Increase productivity with best practices and automation of tasks
• Develop, design and implement custom reusable solutions with Oracle Products for multiple LOBs
• Added visibility and analytical capabilities for business decisions
• Financial reporting thru ad hoc analysis
• Setup and configuration of on-premise solutions
• Working knowledge of Oracle Fusion Applications Release 11 middleware development tools
• Oracle Business Intelligence
• Oracle Application Development Framework (ADF)
• Oracle Identity Management
• Oracle Access Manager
• Oracle Cloud Adapters
• Oracle Data Integration
• Oracle Golden Gate Studio
• Oracle SOA Suite
• System integration
• SSIS Integration Toolkit
• Change tracking synchronization
• Configuration, customization and administration
• Dashboards with KPI’s
• System and personal dashboards
• Views and forms
• System and personal
• Business processes and workflows
• Activity tasks
• Security and administration
• Data management and auditing
• Provide mentorship and training to other team members

Senior SQL (DBA) Database Administrator/Developer/Analyst

Confidential, Beachwood, OH

Responsibilities:

• Strong leadership and analytical skills in database management, data modeling and architecture
• Lead a team of IT employees to accomplish multiple complex projects and tasks
• SQL 2000/2005/2008 R2/2012R2/2014/2016 CTP
• Create complex stored procedures, triggers, views, tables and indexes
• Design and develop DTS and SSIS packages and Active Objects
• Ensure database integrity, reliability and availability of business data stored in production
• Manage database security and control access permissions and privileges
• Data replication, restore, backups, mining and warehouse
• SSAS OLAP cubes, dimensioning and hierarchies
• Create and schedule jobs
• T-SQL - utilize cursors, select, insert into and update statements
• Performance tuning, monitoring, execution and maintenance plans
• Design and implement preventative maintenance checks and services plans
• Manage buffering and distributed data
• Perform proactive review of systems performance metrics and alerts
• Trend analysis using statistical aggregation and metric rollups
• Database server usage and capacity analysis to minimize outages and performance issues
• Create Windows Failover Cluster shared on a SAN
• Disaster Recovery Plan
• Document database and server configurations
• Business Intelligence 2005/2008R2/2012R2
• SSIS - integration services - packages extracting and loading data
• SSAS - analysis services - OLAP cubes, data warehousing, data mart, data mining
• SSRS - reporting services - drilldown, tabular, matrix, sub reports, cached and snapshot reports
• Demographics (Grant Writing & Marketing)
• Dimensions - Age Bracket, City, Ethnicity
• Measure - Date
• Meal Deliveries (Scheduling)
• Dimensions - Drivers, Zip Code
• Measure - # of Meals
• Medicare/Medicaid Revenue (Billing Reconciliation)
• Dimensions – Client, Insurance Type
• Measure – Amount Billed, Amount Paid
• SQL Server Data Tools/SQL Server Data Sync
• Windows Azure Management Console/Portal
• High Availability in the Cloud
• Database creation on virtual servers
• Configuration with allowable IP addresses
• Visual Studio 2013 project migration
• Responsible for systems programming support for Z/OS, CICS, DB2, VTAM, security and storage administration
• Responsible for all aspects of systems programming support for 45+ DB2 subsystems running in a large Data Sharing Monoplex, Sysplex and Parallel Sysplex environments
• Isolated CICS and DB2 transaction bottlenecks using TMON/CICS. TMON/DB2, CICS PA DB2 PM and SMF data analysis
• Utilized modeling tools (Best/1, PerfMon) to forecast resource requirements and justify hardware upgrades to meet business service levels ad future workload needs
• Presented workload trends and growth forecasts to upper management using Excel charts/graphs and PowerPoint presentations within high volume production systems
• Supported TCP/IP, including SMTP and FTP
• MySQL 4.x/5.x
• Performance tuning, query optimization and client server connectivity
• Expertise snapshot, import/export and db optimization
• Installation and configuration on Windows environments
• Designed databases for referential integrity and involved in logical design planning
• Performance tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor
• Created data extracts as part of data analysis and exchanged with internal staff
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master
• Managing database clustering
• Documented all servers and databases
• Developed stored procedures, triggers in MySQL for lowering traffic between servers and clients
• Administration and management of the entire development, QA and production environment
• Visual Studio 2008/2010/2013
• Create data connectors, datasets and classes
• Design forms and relational diagrams
• Build queries using ADO.Net and LINQ to SQL
• Develop modules, methods and functions
• Error handling and debugging and utilizing conventional naming schemes
• If statements and select case statements
• Deployment and updating using MSI packaging for .NET applications
• Access Client Distribution via network per application per cpu
• Office 2003/2007/2010/365
• Create forms, queries, reports, macros and modules
• Advanced functions written in VBA code
• Utilization of pass thru queries to execute stored procedures
• ODBC connectivity to SQL Server
• Creating charts and pivot tables
• Advanced formulas, functions and formatting techniques
• Using workbook templates, linking spreadsheets and data validation
• SharePoint 2003/2007/2010/2013
• Setup user rights, permissions and list items
• Configure document library settings and utilization of web parts
• Creating and managing sites and hierarchy
• Document and meeting workspaces
• Surveys and discussion boards

Senior SQL/Oracle (DBA) Database Administrator/Developer/Analyst

Confidential, Mayfield Heights, OH

Responsibilities:

• Developed and designed
• QA testing. Lead the team in defining QA processes and test planning standards
• Provided support to proprietary software
• Complex stored procedures including cursors and advanced T-SQL statements
• Creation and conversion DTS/SSIS packages
• Performance tuning & maintenance plans
• Backups and Recovery
• Database administration and configuration
• Performance planning
• System architecture
• Data Modeling
• Workload testing
• Automated database maintenance tasks
• Monitoring and Improving application performance
• Designed and developed
• Phone Directory application
• More efficient way for the call agents when transferring calls to other support engineers
• Support and trouble-shoot
• RSLinx
• RSView ME/SE
• RSView Studio
• RSLogix 5/500/5000
• RSSQL
• RSBizWare
• Historian
• Factory Talk Activation Server and Client
• Pico Soft support and programming
• Used DSN’s: OLE DB and ODBC connectivity to databases
• SQL Server 2000/2005

SQL (DBA) Database Administrator/Technical Support Specialist

Confidential, Cleveland, OH

Responsibilities:

• Maintain SQL 2000 databases
• Create stored procedures
• Data replication
• Performance Tuning
• DTS Packages
• Maintain MS Access 2000 databases
• Convert Excel spreadsheets from accounting to access databases
• Create tables, forms and reports
• Action Request System
• Update securities, privileges and user rights
• Configure and map drivers of shared folders
• Update pcs with new McAfee Virus Scan 7.0 and SP3
• Setup and add printers to network
• Log data and comments in Remedy AR system
• Setup Data Card printer through coax interface and preset controllers
• Create images of user hard drive for backups
• Utilized Ghost 7.5 to image failed hard drives
• Preserve end user profiles to replace motherboards and hard drives of new pc’s and laptops

SQL Database Engineer/Reports Specialist

Confidential, Cleveland, OH

Responsibilities:

• Created tables, forms and sophisticated reports
• Integrated with other database platforms
• Converted MS Access 1997 to MS Access 2000 version
• Added new VBA code functionality per request by departments
• Created parts list database for Chrysler, GM and Ford
• Created formulas database to track all lab formulas
• Setup security for users to database system
• Setup and programmed workforce management
• Time keeping compliance per shift
• Used for scrap reporting to reduce costs
• Scheduling of materials for cost analysis of production
• Integrated Intouch 7.0 database
• Wonder Tools using JavaScript
• Retrieve and insert data real time from PLC’s to track downtime and accountability
• Designed and implemented
• Trained lead operators, process technicians and supervisors
• Reduced downtime by 66%
• Accountability for each line per shift
• Create detailed reports including statistics and process data from each machine and production line
• Created weekly capacity analysis spreadsheets
• Coordinated vendors from concept to completion
• Machine was specially designed to perform multiple operations to reduce scrap by 30%
• Manual labor was reduced by 50% for each production line

IT Database Developer/Analyst

Confidential, Independence, OH

Responsibilities:

• Implementation and coordination of all database projects
• MS Access 1997 front end and SQL Server 7.0 back end
• Created user documentation for all projects
• Assisted in the design of workflows and business processes within the IT component of the organization
• Worked as a liaison between fourteen educational facilities, delegating duties and responsibilities to the technical teams
• Structured and organized material and information relevant to each project and insure that all materials are included and covers specs and requirements
• Review and system check on-going and new programs
• Administer problem-solving methodologies to the on-site Anderson Consulting Group on the BPR team
• Representative of the Y2K committee
• Overseen future endeavors and special projects concerning pc’s and software applications
• Recommended product enhancements to improve software applications
• Evaluated and set priorities as work is in progress
• Presented concepts and information appropriately to various types of users
• Conveyed abstract concepts for users to understand at various audience levels
• Developed and maintained project schedules and timelines for completion of documentation
• Coordinated integrated user list utilized by the tech team for tracking and monitoring hardware, level of security, and training needed to fulfill job duties for over 6,000 employees
• Developed and designed forms and reports with complex underlying relational diagrams
• Integrated with multiple other database in house systems
• Point and click methodology for easy use for upper management
• Trained technical assistants and registrars
• Verify information accuracy and functionality
• Provided IT set-up and support for four remote locations
• Created scheduling system of SAP classes
• Developed and maintained project schedules and timelines for completion of documentation
• Created spreadsheets and matrices for benchmarking deadlines, scheduling meetings with upper management, and monitoring updates of computer equipment, personnel and courses of 2 releases consisting of 6 plant locations
• Assisted in the scheduling and monitoring of coursework by each department in the SAP process

Database Application Developer/Analyst

Confidential, Twinsburgh, OH

Responsibilities:

• Responsible for interfacing at all levels of management and laborers and coordinating processes
• Design and developed databases in Access 7.0 (Access 95)/Access 8.0 (Access 97) and utilized Visual Basic for Applications 5.0 and SQL 6.5
• Implement trouble-shooting methods for Six Sigma statistical and quality control methodology
• Collaborated with network administrator on system requirements for implementation of applications on the network in a multi-windows environment
• Assisted in the decision making of allocating computers and setting up terminals for operators to input data into the system
• Worked directly with engineers to meet their needs for data extraction for process improvements
• Plan and execute product assembly, process flow compliance and defect prevention to QC department
• Designed plant layout for each department to establish work cells and structural models for each department for assembling and testing powered reactors
• Performed TQM, QFD, DFSS, SPC and provided employee training to 175 employees on the utilization of the routing and inventory databases.

Business Data Analyst

Confidential, Cleveland, OH

Responsibilities:

• Lead requirement gathering meetings and deliver requirement documents
• Owns requirement management functions
• Ensures requirements have all the required data elements
• Ability to document/develop current and create future Business Process work flows with the LOB
• Can navigate between requirements and defects
• Accountable for requirements being updated
• Drives defect resolution
• Knowledge of testing concepts
• Build/execute test scripts including input from LOB
• Ability to execute any/all tests scripts and provide input on Test Strategy
• Run out changes to requirements to determine if a Change Request is determined
• Assists in tracking implementation as per plan
• Escalate as needed
• Collaborates with team members