| Candidate Information | | Title | Sql Server Data Warehouse | | Target Location | US-MD-Bethesda |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateOBJECTIVEA dynamic and challenging position with growth opportunity in any organization where I can apply my experience in database administration, database programming and development.SUMMARYOver 13 years of experience as an Access/SQL Server Database Programmer and Application DeveloperOver 5 years of experience in development of applications using ASP.NET, VB.NET, C#, SQL Server DBA and SQL Server 2012Experienced in database design and development using VB.Net, ASP.Net, T-SQL, ETL, SQL Server DTS, SSAS, SSIS, SSRS, OLAPExperienced in different phases of software development cycle including Programming, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer supportExperience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server and MS AccessKnowledge of, and experience with:- Logical data models and physical data models, full SDLC- Corporate and application network connectivity and hardware architectureTeam player with good interpersonal skills; thrive well within the group environment.TECHNICAL SKILLSLanguages: ASP.NET, VB.NET, C#Scripting Languages: ASP, VBA, VB Script, JavaScriptMarkup Languages: HTML, DHTML, XML, XSL and XSLTGUI: Visual Studio.NET 2003, 2005, 2008, 2012, SQL Server 2005, 2008, 2012 (SSMS, SSIS, SSRS, SSAS, BIDS, XMLA, MDX), SQL Server 2000 (T-SQL, DTS, Query Analyzer), TFS (Team Foundation Server) 2012, MS Visual SourceSafe, Subversion SVN, MS Access (VBA). Xcelsius 2008, SAP BI 4, Dashboards 4, Power BI, Data EdoComponent Technologies: COM / DCOM and MTSReporting Tools: Crystal Reports 9.0, Data Reports, CFML (Cold Fusion), SQL Server Reporting ToolsWeb Design Tools: Macromedia Flash MX/Fireworks & Dream Weaver, Adobe Photoshop, Visual Studio Front Page, BI Tools.Server Technologies: SQL Server (7-2012), IIS6, Oracle 10g, Netware, MySQLOperating Systems: Windows (NT, 2003, 2008, 2012 Server; XP, 7), Windows Advanced Server, Windows 2000, 98/95/NT/Me, MS-Dos, IBM PC, MAC, AS400PROFESSIONAL EXPERIENCE(May 2004 Present), PLC. Washington, DCSNR Database Administrator December 2014 to --- Database Administration in SQL Server 2000, 2005/2008 R2, 2012 R2, 2016 environment with complex queries and stored procedure. SQL Server Database administration and performance tuning Migration to Microsoft Azure CloudAzure SQL Managed Instance (PaaS) SSIS Package development and maintenance with BIDS (Business Intelligence Development Studio) Report Analysis and Analytics using Power BI Database architecture and design in Hybrid (Azure Cloud and OnPrem) environmentsMerkle, Inc. Columbia, MDSQL (Database) Developer/Warehouse Analyst May 2014 to July 2014 Database development in SQL Server 2005/2008 R2 environment with complex queries and stored procedure SQL Server Database administration and performance tuning SSIS Package development and maintenance with BIDS (Business Intelligence Development Studio) Analysis and ETL of Salesforce CRM data using SOQL, Workday Financials/Epicor HCM data with SSIS Data Warehouse Data Store management in SQL Server 2005/2008 R2 environmentHMSHost, Inc. Bethesda, MDData Warehouse Analyst June 2010 to February 2014 3-staff team development and deployment of Corporate BI Dashboard with Xcelsius and SAP BOXI r3.1 using BO universes and Web Services, Adobe Flash and C#.NET as semantic layerwith Full SDLC Dashboard ETL Design and development with SQL Server and SSIS 2008 using BIDS and with disparate data sources Dashboard ETL maintenance with SSIS 2008, SSMS 2008 and T-SQL complex store Procedures, Oracle SQL Developer Data Warehouse cubes maintenance with SQL Server 2000 & 2012 with DTS and SSAS 2000, 2012 BI reporting with SAP Business Objects WebI reports using Universes and SQL Server SSRS Data Warehouse parallel upgrade from SQL Server 2000 to SQL Server 2012 with team members using SQL Data Tools, SSAS, TFS 2012Full SDLC. WebI Reporting Application support and maintenance using ASP.NET and BO universes. Team Lead for offshore team for SAP Dashboard 4 upgrade.CONSULTING (May 2004 2010)AQUILENT, Inc. Laurel, MDSQL Server DBA April 2008 to May 2010 EPS (E-Procurement System) Database and application support at DOL, Washington D.C. ETL support for NCFMS replacement of DOLAR$ at DOL (Department of Labor), Washington D.C SQL Server Security enforcement, Performance, and tuning - SQL Profiler, Index tuning for NUMI application at VA (vha.med.va.gov) Configuration and installation of Windows 2003 and SQL Server 2005 2-Node Cluster off-site for production DR for VA NUMI project. Implementation of SSRS 2005 Reporting Services at DOL for departmental r reporting Data migration and SQL Server 2005 upgrades at DOLGDS (Denex Dental) Rockville, MDSQL Server DBA August 2007 to April 2008 Implemented automated Daily NAS recovery model: Full and T-Log backup SQL Server Security enforcement, Performance, and tuning - SQL Profiler, Index tuning. Data quality Control, SSIS packages, complex stored procedures and T-SQL Programming. Reporting Server reporting, Data migration SQL Server 2005 UpgradesConstellation Energy Group. Baltimore, MDSQL Developer/DBA May 2007 to Aug 2007 Large Volume DB and High Availability: database backup and recoverability, Log Shipping, NAS backup, SQL Server Clustering. SQL Server Security enforcement, Performance, and tuning - SQL Profiler, Index tuning. Data quality Control, ETL, complex stored procedures and T-SQL Programming Collaborations with offshore DBA team member for proper maintenance schedules and to enforce zero-downtime so systems are on 24/7InPhonic, Inc. Largo, MDSQL Report Writer December 2006 to May 2007 Financial Systems report design and creation for business intelligence SQL Server 2000 reporting using: Report Designer, Visual Studio .NET 2003, and DTS for ETL packages and Cubes design, data mining Ad-hoc reports creation using complex stored procedures and data aggregation for Data warehouse using SQL Query Analyzer; collaboration with Dashboard (BI) reporting using Qlikview team.Wolpoff & Abramson, LLP Rockville, MDDatabase Developer October 2006 to December 2006 On-going Data warehouse project for Business Intelligence, reporting, and analysis SQL Server 2005 development using: SSAS, SSIS SSMS, and BIDS for ETL packages and Cubes design Data extraction from mainframe flat files to Relational Database-- onward to Data Warehouse modelingSunTrust Mortgage & Loans Richmond, VADatabase Developer May 2006 September 2006 ETL (Extraction, Transformation and Load) Project to meet Federal Government Loans and Mortgage compliance regulation Created DTS Package that extracts, transforms, and load data for COGNOS cubes that tracks loan sources and ageing Collaborated with COGNOS Analysts to implement business rules in T-SQL queries and stored procedures Optimized the T-SQL queries and stored procedures and reduced job run-time by 45% Created documentation for project and push to production as well as presentation for trainingChainDrugStore.Net. Alexandria, VADatabase Developer March 2006 to May 2006 Created report (with T-SQL) that tracks the workflow process for pharmaceutical trade show Collaborated with web development team with T-SQL queries and stored procedures for C#.NET web application Optimized the T-SQL queries and stored procedures for SQL Server 2005 as well as .NET 2.0 using Visual SourceSafeHogan & Hartson LLP. Washington, D.C.Database Administrator\Developer January 2006 to March 2006 Created ETL and DTS Packages between heterogeneous databases-- InterAction CRM and SydneyPlus applications Upsized MS Access data to SQL Server 2000 for in-house CRM application for firms global employees Optimized the MS Access CRM application for T-SQL queries and stored proceduresFederal Agricultural Mortgage Corporation Washington, D.C.Database Administrator October 2005 to December 2005 Analyzed database architecture and security and presented report on better architecture and security Implemented better database design, introduced proper SQL Server security using NT authentication, use of roles and groups Implementation of business rules using stored procedures and roles; Replication for Data availability and off-site data redundancy Created and maintained Scheduled Backup and Maintenance schedules for system performanceMERKLE Direct Marketing Lanham, MDDatabase Developer June 2005 to September 2005 Data warehousing, data cleansing, database programming with debugging. Successfully managed large volume (millions) of data Designed and developed stored procedures, triggers, and data transformation processes using Transact SQL and Data Transformation Services SQL programming on backend and front-end configuration for Epiphany reporting Large database design and optimization, data extraction, DTS Packages T-SQL programming, data extraction Design and develop reports for delivering business informationMCI Ashburn, VASenior Application Developer-Consulting May 2004 to June 2005 Analyzed and made recommendations on project based on data analysis Upsized MS Access database to SQL Server 2000 Improved data integrity, security and robustness Created DTS packages using T-SQL scripts, Stored Procedures, Triggers, Functions, and Cursors Client-Server database applications development and programming using MS Access and Visual Basic 6 as Front ends Collaborated with web development team to deploy HR management application on-line in record timeFTE (July 1996 May 2004)INFOTEX Corporation Riverdale, MDWeb Application Developer July 2002 to May 2004 Developed and maintained e-commerce web sites for companys clients using ASP, ASP.NET and JavaScript Client-Server Database applications development and programming using MS Access (VBA) and Visual Basic as Front Ends Computer Technician, Network installation ConsultantITECH Services Frederick, MDDatabase Operations Manager December 2000 to May 2002 Dual DBA and Developer roles: Logical and physical design, and deployment of database on SQL Server Improved and maintained an Access 2000 CRM application for company, using VBA--a cost-cutting decision Upsized MS Access database to SQL Sever 2000, for improved robustness, security and data integrity Cut down time by more than 60%, and increased productivity, security, and data integrity. Created advanced SP and DTS. Managerial--team Lead for the development team that developed companys web site and data-driven web portal, for thousands of students and clients from across the country Created and maintained Scheduled Backup and Recovery plan; troubleshoot and database tuningCREATIVE Computers, Inc Torrance, CAData Analyst/Junior DBA July 1996 December 2000 Executed daily operations of departmental database programming, scheduled Backup and Recovery, and scheduled maintenance using SQL Server 6.5 and 7 as junior DBA Supervised and executed daily and monthly operations of sales commission reports using Microsoft FoxPro2.6. Created and implemented call center phone reports and statistics using FoxPro and Excel through VBA programming Initiated, tested and implemented electronic reporting through intranet for the sales department, thereby saving company 25% on reporting cost Provided technical support to customers for both pre-sale and post-sale assistance on both PC and MAC computers as Tech Support Technician.EDUCATION AND CERTIFICATIONEl Camino College, Torrance, CA - AA in General StudiesFederal Polytechnic, Ilaro, Nigeria HND (BSc Equivalent) in Mechanical Engineering.Microsoft MCP; Novell CNA (Certified Network Administrator); A+, Apple Gold Certified. Completed Windows 2000 Installation and Implementation course. Completed SQL Server Analysis Services (SSAS 2012) for Business Intelligence Course. Completed OCP (Oracle Certified Professional) Oracle 9i classes. Now preparing for Oracle (OCP) DBA Exams.Status: US Citizen. |
