SUMMARY:

• Results - Driven professional with over 15 years database and IT experience.
• An in-depth understanding of emerging technologies and their commercial applications.
• Enthusiastic personality.
• Highly Proficient in database design, analysis, tuning, trouble shooting and process modeling.
• Meticulous attention to details and accuracy. Solid organizational and communication skills.
• Team leader and team player.

RELEVANT SKILLS:

• Microsoft Solutions
• T-SQL
• VB/ VBScript/VBA
• X++
• XML
• HTML
• POWER SHELL
• PYTHON
• PICK
• Windows server
• XP/ 2003 2008R2
• Ent. Server 2012
• (Clustered)
• VM ware
• SQL Server 6.5 - 2012SSRS -Reporting Services 2000 - 2012
• SSAS -Analysis Services 2000 - 2012
• SSIS - Integration Services 2000 - 2012
• Visual Studio - .Net
• SQL Server Business Development Studio
• Clustering 2003 - 2012BizTalk Server 2004/ 2006MSMQ 2.0/ 5.0,Active Directory 2000/2008Sharepoint Server 2003ACTActive ReportBitbucket(Stash)
• Cognos 9 &10Code CollaboratorConfluence
• Enterprise ReportingErwinFRx ReportingIderaJiraLumigent EntegraMS Dynamics AXMS Dynamics GPMarket ProOpen ManageOracle 7 & 8Perforce(P4)MS ProjectSalesLogixSQL SentryServiceNowTargit BI SuiteVisioXL Reporting

CAREER HISTORY:

Confidential, Centennial, CO

Senior Database Administrator

Responsibilities:

• Responsible for all aspects of Enterprise Data Management in a large global, multi data center environment with 300+ production servers, in a mixed physical and virtual clustered environment
• MS SQL Server installations, migrations, patching and upgraded in multi-nodes SQL/Windows cluster environments both physical and virtual
• Provide solutions for optimization and performance tuning, including index tuning and query optimization, partitioning, sharding and replication on several VLDBs ranging in size from 5 to 20TB
• Provided SQL expertise to developers, performance tuning and analysis of code, code inspection/ code reviews, architecture reviews, writing and reviewing T-SQL code, as a Lead DBA, mentor and assist junior team members
• Managed, developed and supported the Enterprise Reporting solutions utilizing full MS BI stack. (SSAS,SSIS and SSRS)
• Developed, reviewed and approved all code and releases to the Enterprise Reporting production and dev environments
• Managed multiple projects and teams utilizing agile methodologies
• Created standards documentation related to database administration, management, policies and procedures
• Provided administration, monitoring and maintenance of all databases to insure availability, reliability, scalability
• Provide responses to all database related technical issues in a 24 X 7, high availability environment with a 2 minute SLA. On-Call rotation
• Diagnose and troubleshoot all MSSQL Servers and databases issues, hardware, software, network and storage and problem solving with little to no downtime utilizing custom scripts, monitoring tools, DMVs, profiler and extended events, root cause analysis
• Design and implement disaster recovery procedures according to standards utilizing replication, log shipping and database backups and recovery
• Create and maintain data warehouse schemas and databases for ER reporting solutions
• Generate scheduled and ad hoc reports for internal and external customers both operational and analytical reports
• Deployment and configuration of SQL Sentry monitoring tools in multiple locations and domains
• Participation in Confidential (Change Advisory Board) meetings.
• Working closely with Development, NOC, Change management and Incident Management teams
• Diverse working background - worked with on-shore and off-shore teams in Sri Lanka, India, UK, Canada Europe and US

Confidential

BI Solutions Consultant / Database Administrator

Responsibilities:

• Responsible for providing WellPoint/P2Energy Intelligent Dashboard Solutions to oil and gas clients.
• Developed and design infrastructure for Business Intelligence platform using Microsoft BI stack (MS SQL Server, SSAS, SSIS and SSRS).
• Hardware specifications and capacity design, including SAN configuration.
• Performed backups/restores, performance tuning, optimization, analyzing I/O performance and failover.
• Responsible for installation and management of all MSSQL environments (Prod, Dev and Test).
• Create Analysis Services database and cubes.
• Create, maintain and optimize SSIS / DTS packages, Stored Procedures and TSQL.
• Provided production support for BI infrastructure (SQL Server/ Targit BI Suite /TIBCO).
• Provide business analysis and developed data migrations.
• Data modeling - logical & physical
• Analyze business requirements to determine MS Dynamics AX configuration and customization.
• Train end users on reporting tools.
• Respond to all end-user inquiries and support for Business Intelligence environments.

Confidential, Lakewood, CO

Database Administrator

Responsibilities:

• Provided administration, monitoring and maintenance of all databases to insure availability, reliability, scalability.
• Responsible for monitoring systems performance, trouble shooting hardware, software and network issue.
• Responsible for management of reporting environments including report design and creation.
• Developed Datawarehouse to integrate financial, human resource and operational systems including ETL using DTS and SSIS for TARGIT and SSRS.
• Full life cycle implementation of Microsoft Dynamics AX 4.0
• Provided total application and database support for MS Dynamics AX
• Provide business analysis and developed data migrations for all AX modules from four separate legacy systems.
• Analyze business requirements to determine AX configuration and customization.
• Train end users on specific job functions which include but not limited to Accounts Receivable, Accounts Payable/Purchasing
• Implemented and managed CRM application, configured integration and trained end-users
• Respond to all end-user inquiries and support for several engineering software applications.
• Responsible for managing and maintaining groups and user accounts in AD.

Confidential, Denver, CO

Database Administrator

Responsibilities:

• Responsible for all aspects of Enterprise Data Management in a large multi data center environment with 80+production servers, and over 800 databases in a mixed SQL 2000 and SQL 2005 clustered environment.
• Provided administration, monitoring and maintenance of all databases to insure availability, reliability, scalability.
• Performed upgrades, patches and integration of several different business partner software applications.
• Developed Datawarehouse to integrate financial, human resource and operational systems including ETL using DTS and SSIS. Developed reporting functions using Analysis Services, Business Development Studio and Reporting Services.
• Developed and documented solutions for centralized data warehouse/ reporting environment
• Responsible for monitoring systems performance, trouble shooting hardware, software and network issue.
• Managed and created database maintenance plans.
• Performed backups/restores, performance tuning, optimization, analyzing I/O performance and failover.
• Provided total application and database support for MS Dynamics GP including installation and several major upgrades.
• Developed DTS-based import and processing of operational /financial transaction data into Dynamics GP
• Worked closely with accounting department to develop financial reports using FRx Reports and Reporting Services.
• Responsible for management of reporting environment including report design and creation.
• Worked with accounting and executive management in developing consolidation strategy for consolidated reporting environments to service the Finance, Sales and Operational teams. Designed and created financial reports.
• Support of BizTalk and MSMQ integration between several applications/databases.
• Provided application support numerous in-house and enterprise applications.
• Provided SQL expertise to development department performance tuning and analysis of code, code inspection/ code reviews, architecture reviews writing and reviewing T-SQL code.
• Performance tuning of application and SQL code, systems and network configurations for multiple products and technology sets
• Provided on call support for 24/7 production databases
• Designed and implemented replication topology using transactional and merge replication
• Provide support for and development of custom and third party data stores and cubes.
• Developed DBA/ IT operations support, escalation and management procedures
• Database, systems and application configuration/ coding standardization.
• Worked with internal and external clients to define requirements and statements of work provided project management.
• Evaluation of existing and emerging reporting and OLAP solutions for business intelligence, decision support and customer product usage.
• Responsible for the implementation and support of the testing environment

Confidential, Denver, CO

Consultant/ DBA Developer

Responsibilities:

• Developed Custom Software and Database solutions
• Worked with small businesses to define/ gather requirements for application evaluation, selection and deployment.
• Worked with internal and external clients to define requirements, generate contracts and statements of work.
• Johnson Storage & Moving, Designed and developed database for new product line website, foundation for critical business applications Developed Custom Software and Database solutions
• Martens Moving and Storage, developed and implemented intranet application, CRM lead management, contracts, invoices, reports, set up network, PC’s, and servers (Configure server & pc, Domain, Active Directory, user policies)
• Exhibit World, office automation of email and fax processes

Confidential, Denver, CO

Program Analyst/Database Programmer

Responsibilities:

• Collaborated to architect a multi-tiered intranet application that included functionality to streamline the sales process, centralize demographic information, manage customer accounts, simplify customer inventory placementand schedule equipment
• Development program to import internet leads to database using ETL techniques.
• Provided project management and technical expertise described the project scope, resource requirements, budget and deliverable time lines (Full Life Cycle)
• Engaged in performance tuning and stabilization of all aspects of a SQL 2000-databases- reporting and billing environment. This included server configuration, tuning and optimization of hardware, T-SQL, DTS packages and reports.
• Designed and created all forms and reports
• Provided help desk support, user training in pc and sales skills
• SQL architecture, performance tuning and optimization, Integration Services/ DTS, Analysis Services and operational support/ troubleshooting.

Confidential, Denver, CO

Database Programmer

Responsibilities:

• Database development (SQL Server 2000) to include structure, table design, queries, indexes, stored procedure and trigger development and debugging, data integrity and data cleanup, import, export and data conversion, create and execute complex SQL queries, reporting tools backend, MS Access front-end.
• Developed an application (MS Access2000) to process customer requests(SQL Server 2000), CRM to include Customer tracking and follow up reporting (ACT II) integration
• Identify and resolve potential problem areas, backup and recovery, database security capacity planning and space management (SQL Server 2000 )
• Project managed the creation and integration of a custom CRM and subsequent data migration.
• Performance monitoring and tuning, configuration and troubleshooting of all facets of the database environment, and logical and physical database design

Confidential, Golden, CO

Business Analyst/Lead Developer

Responsibilities:

• Design application that batched loan applications for insurance submission that interfaced with FHA application (VB, Access 97, SQL Server) for export
• Development of a complex reporting system (VB, VBA, Perl, MS Access2000,SQL2000 )
• Automated extract data from a Pick Database to multiple databases for individual projects
• Built a project management tool using VBScript, and Access 97 that allowed the loan department to track the progress of related projects and requests.
• Maintained existing programs (MS Access 97) and automated numerous processes to increase productivity.
• Analyze client data, data scrubbing and conversion, data migration (MS Access 97, 2000 SQL Server 7 MS Word, MS Excel)
• Created a resource management tool with Visual Basic, MS Access for use by the Facilities Department to track office furniture and computer usage.
• Created numerous ad-hoc queries and reports as requested(MS Access, Crystal Reports)
• Assessed business requirements and recommended solutions ensuring that new requests were technically feasible and that the implementation remained consistent with the existing architecture.
• Database consolidation and migration of numerous Access and SQL databases.