DB Admin Resume profile

Skill Set Summary

SQL Server DB Admin: Installation, configuration, programming and administration of SQL Server 2000 - 2012, design, dev. and implementation of logical physical DB architecture, data warehouse development OLAP - De-normalized and OLTP normalized. Hands on development from the tabular level to procedural level, including index mgt. Programmatic solutions incorporating business rules for server db metrics and engine tuning. Assignment and/revocation of user logins, roles and database privileges including database security. Perform Sql Server optimization and tuning. Adjustment and configuration db internals, jobs and logs monitoring, paging allocation, memory and library management, SQL scripting of stored procedures, triggers and complex queries, log shipping, backups restores plus disaster recovery. Development, Administration and scheduling of DB maintenance plans. Legacy conversions of SQL Server 2000-2012. Lock Block control and error recovery, Local, linked remote server management, Manage distributed transactions and meta data services, Data replication - snapshot, transactional and merge, push or pull . Setup, configuration and synchronization of replication to include, as applicable, publishers, distributors, subscribers articles. Capacity planning, Business systems planning, SDLC, End-user and developer support.
Oracle Development: Oracle 9i, 10g 11.0 PL/SQL dev. of stored procedures, complex queries, triggers, for the aggregation of Oracle data in support and development of reporting solutions and API's.
BI Development: T-SQL programming, development and execution of DTS and SSIS packages, in the development of Marketing, CRM, ERP solutions. Data and control flow, constraints, extractions, transformations, data cleansing and data copies. DTS SSIS container and custom scripts development. DTS to SSIS conversion, BO Development in Business Intelligence Design Studio BIDS,SSRS Reporting.
SAP/Business Objects XI.R2/3:- BO Designer, BO Desktop Intelligence, and CMS. Develop BO universes global reporting solutions -
Objects, Classes, Parameters, Filters, T-SQL or PL-SQL programming, as applicable Reports development from parsed and aggregated OLTP OLAP data. Multi-data source universe solutions. Executive Operational reporting.
Crystal Reports 7.0-11-R2/3/2008:.Installation, configuration administration. Hands on report development, publication distribution.
CMS/CMC admin. Executive Operational Reporting. Excelsior Dashboard Development .
MS Access Development, Admin Programming Versions 2.0 - 2010: Upgrades, configuration, installation and administration. Development of macros, queries, forms reports, event procedures and VBA module coding. Data conversions to SQL Server, Multi-user and stand-alone API's. SQL Server/Oracle back-ends
Data Analysis Architecture: requirements gathering, qualitative quantitative data analysis, data modeling, data mapping, process and dataflow diagramming. Analytic trending and predictive data aggregation. Develop Statistical models, data driven analysis and relational, informational and operational models. Gather business intelligence regarding data acquisitions and conversions. ETL and reporting. UAT and case testing JAMMA .
Query review and testing, Data categorization/aggregation for API support and reports development, Tools Erwin, Visio- Salesforce Solomon - Microsoft Dynamics
Work Demographic: Massachusetts, Connecticut, Rhode Island

Client List

CLIENT	ROLE	SYSTEMS TOPOLOGY	WORK PRODUCT
Confidential	Consultant	Windows Server 2010, Oracle 11.0, Pentaho, JAMMA	Pentaho Reports Developer. Q A of Reports Data. PL/SQL programming. Data Cleansing Aggregation. UA Testing JAMMA . Report development of healthcare data for state of RI and associated businesses partners.

Confidential	Consultant	Windows Serve/2010, SQL Server 2008/2012, Outlook, Salesforce	BI Developer Reporting. Developed T-SQL scripts, SP's and SSIS packaging producing record sets in support of Wellness reporting for multi-client population. Distribution of same by schedule based on Wellness Campaign spec., client contact, CM's CS input. Tracking S/W Config. Mgt. using Salesforce.
Confidential	Consultant	Crystal Reports 2008, SQL Server 2008, Windows 8, Windows Server 2010	Crystal Reports Administration Reports Development. T-SQL programming.
Confidential	Consultant	Crystal Reports 2008, SQL Server 2010, Windows 8, Windows Server	SAP-BO/Crystal Reports Crystal Reports Development, T-SQL programming
Confidential	Consultant	SQL Server 2005, 2008,2012, IBM Info-Sphere , SSIS, SSRS,	SQL Server DBA Devloper Production DBA work, Devloper support, ETL migrations using SSIS DB2 IBM Info Sphere.
Confidential	Consultant	Windows Enterprise 7.0, SQL Server 2008-R2/2010,SSRS/SSIS Reports Manager, BIDS VPN client, Outlook Web App Office Live	SSRS-SSIS Developer. Developed applicable DB components for maintenance tech. status app.
Confidential	Consultant	Windows XP Windows Server 2003, BO XI.R2, Oracle 10/11.0, Toad for Oracle, BO Designer, Desktop Intelligence, Viewer, CMS, DB's Teammate, GCP, WAMMS	SAP BO Dev. Data Analysis Reporting . Build Global Reporting solution using BO Universe technology. Clear FDA compliance reporting flag.
Confidential	Consultant	Windows Server 2003, Windows XP Pro, Oracle 11, Business Objects Crystal Reports Developer 2008,SCRUM Agile, VSN, Toad, MS Project Mgr., Outlook	MS Access Developer. Conversion of Accounting spreadsheets to Access App.
Confidential	Consultant	Windows Server 2003, Windows XP Pro, Oracle 11, Business Objects Crystal Reports Developer Edition. 2008,SCRUM Agile, VSN, Toad, MS Project Mgr., Outlook	Lead Business Objects Crystal Reports Developer Administrator Crystal reports development, executive and production reporting in-house and client based. Lead developer and reports trainer of ISO's.
Confidential	Consultant	Windows Server 2003, Windows XP Pro, SQL Server 2005, MS Access 2003, VB 6.5	MS Access developer Maintenance programming and code fix for pre-existing Federal reporting app. of state homeless shelter data.
Confidential	Consultant	Windows Server 2003, Windows Vista, Cisco VPN, SharePoint, SQL Server Reporting Services SSRS , SQL Server 2005/2008, Redgate Compare MS Project	SSRS Developer T-SQL Programmer. Dev. Rptg solutions.
Confidential	Consultant	Windows Server 2003, Windows XP/XP Pro, Office, MS Access 2003	MS Access developer. HR App. Skills v. employment opportunities.
Confidential	Consultant	Windows Server 2003, Windows XP/XP Pro, SQL Server 2000/2005, Business Objects Dev. Admin, Crystal Reports XI.R2, Business Objects Data Integrator Services BODI ,Netezza, ,MS Access, MySQL, HTML .Net, Active Point	Technology Consultant - BO Dev, Crystal Rpts, T-SQL Programming, MySQL install, Config Admin. Access Dev, Admin Programming.
Confidential	Consultant	Windows Server 2003, Windows XP Pro,SQLServer2005,CrystalReports/XICMS/CMC	SQL Developer Crystal Reporting
Confidential	Consultant	Windows Server 2003, Windows XP-Pro, SQL Server 2005,SQL management Studio, SQL Enterprise Manager, SSRS, Crystal Reports 9.0, Access 2003, FTP, Fuel Smart, CADEC	MS Access developer/FTP scripting, Crystal reports development. VBA programming. T-SQL Development supporting Access API.
Confidential	Consultant	Windows Server 2003, Windows XP-Pro, SQL Server 2005, Microsoft Virtual Server 2005 R2 clustering SQL management Studio, SQL Enterprise Manager, Active Directory, Cisco VPN, SAN, RAID, SSAS, SSIS, SSRS, Red gate Compare	SQL Server DBA Bkups. restores ,jobs monitoring, replication, ETL, user support, DB maint. config, installations and db development, logical to physical design. BI
Confidential	Consultant	Windows Server 2003, Windows XP Pro, SQL Server 2000/2005	SQL Server DBA Bkups. restores, jobs monitoring, replication, ETL, user support, DB maint. config, installations and db development, logical to physical design. BI
Confidential	Consultant	Windows Server 2003, Windows XP Pro, SQL Server 2005, SQL Server Reporting Services SSRS , SSIS, XML, RDL, MHTML, Netezza, T-SQL	SSRS Developer T-SQL Programmer Develop stored procedures per direction of lead as applicable to SSRS reporting and ETL processes.
Confidential	Consultant	OS:Windows Server 2003, SAN, RAID, Citrix Metra frame Applications Mgr., Unix, Crontab Scheduler, Microsoft Virtual Server 2005 R2 clustering , Sybase Data Warehouse, SQL Server 2000/2005	SQL Server DBA Bkups. restores, jobs monitoring, replication, ETL, user support, DB maint. config, installations and db development, logical to physical design.
Confidential	Consultant	Oracle 9i, TOAD, Access 2000, Windows 2000 Professional, Banyan Vines, EHDI	Oracle/Ms Access Developed Blindness in Infants DB. Access API Oracle backend.
Confidential	Consultant	Oracle 9i, TOAD, Crystal Reports Developer 11.0, SQL Plus, PL/SQL, Business Objects Data Integrator Services BODI , Encompass Cardiac Network System	S/W Engineer -Oracle-Crystal-BO. Build reporting solution for Encompass Cardiac Network System

Confidential	Consultant	SQL Server Enterprise 2000, Crystal Reports 11/Business Objects/ Business Objects Integration Services BODI , Visual Source Safe VSS , Wise Enterprise 9.0, Provisions Tax Software 320A, Cisco VPN	S/W Engineer -Oracle-Crystal-BO - Build reports for tax application. program wise scripts for auto installation of same.
Confidential	Consultant	Windows Server 2003, Windows NT, Oracle 8.0, 10g, TOAD, UNIX, VB 6.0 COM, Visual Source Safe, Actuate, Crystal Reports, IE5/IE6, HTML, VB-script, Comm-bridge.	Oracle Devl/VB Programmer. Update and re-program Oracle stored procedures controlling inter-dept. ETL. Update VBscript in State website for problematic code.
Confidential	Consultant	Outlook Express, Windows 2000, MS SQL Server 2000, Crystal Reports Enterprise 10.0. OASIS Scientific Abstract submitter, VPN, VERITAS, PHP, HTML, ASP, Vbscript. VMware, Lawson - ERP CRM	Programmer Analyst Develop applicable ETL code for data migrations to and from OASIS Scientific Abstractor. Adhoc reporting as applicable to business rule.
Confidential	Consultant	Outlook Express, Windows 2000, Ms SQL Server 2000, Crystal Reports Enterprise 10.0	T-SQL Dev/ Crystal Reports Convert Ms Access reporting solution to Crystal Reports.
Confidential	Consultant	Outlook Express, Windows 2000 Server, Ms SQL Server 2000, Crystal Reports Pro. 9.0	T-SQL Dev/ Crystal Reports. Develop reporting solution for Medical App.
Confidential	Consultant	Access 2000 Developers Edition, Windows 2000, Office 2000 Professional, Crystal Reports, Word, Oracle 9i - PL/SQL , SQL Server 2000 - T-SQL, ERP Solomon Excel	Access Developer/DBA Developed business apps. API's with SQL Server or Oracle Backend. Rptg solutions in SSRS, Crystal as applicable to clients business requirements.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship