SQL Server Enterprise manager Resume Washington, DC - Hire IT People

SUMMARY:

Designed Conceptual, Logical and physical Model of database.
Expert in Data conversion, Data modeling, Normalization and SQL Server Enterprise manager.
Wrote complex Stored Procedures, User Defined Functions, Views, and creating other database objects.
Expert in Migration of data from different sources .csv, excel and text files and Oracle to SQL Server.
Involved creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
Expert in Creating, maintaining and Configuring SSIS packages and configuring Incrementing loads.
Involved working with heterogeneous data source like Excel, Flat file, Oracle, DB2, and SQL Server.
Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Involved creating operational reports in SSRS … i.e. Drill - Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.
Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
Involved in data matching using fuzzy grouping to sort duplicate records.
Expert in Database Backup, Recovery and applied necessary SQL Server database Service packs, hot fixes and Security Patches.
Defined and administered database standards, controls, procedures and documented the same.
Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role.

TECHNICAL SKILLS:

MS SQL Server 2008/2012/2014, SSIS/SSAS/SSRS T-SQL, SQL, PL/SQL, RDMS’, Excel, Access, Project Management, Enterprise Architecture, SDLS, and MS Proficiency.

EXPERIENCE:

Confidential, Washington, DC

SQL Server Enterprise manager

Responsibilities:

Interaction with clients to fulfill business requirements, design & implementation phases.
Created customer information to load in to database in excel and flat file form.
Developed stored procedures and triggers to facilitate consistent data entry into the database.
Create and produce ad hoc reports for the business as needed and per cyclical schedules using Microsoft Excel, SQL Server Reporting Services and SharePoint.
Produced documentation for all kinds of reports and packages and update client information on CMC.
Responded to clients regarding account information; investigated problems and performed problem resolution
Cross sold banking products and services

Confidential, Washington, DC

SQL Server Enterprise manager

Responsibilities:

Proficient at data analysis and quality checking for patient data and billing information.
Provided friendly customer service at prescription drop off and pick up counters.
Worked appropriately in cashiering, cash handling and credit-card processing.
Verified patient data and billing information.
Worked in HIPPA- regulated environment closely with the pharmacist to dispense patient medications accurately.

Confidential

SQL Server Enterprise manager

Responsibilities:

Created database tables with various constraints including primary key, foreign key, etc.
Extracted data from SQL Server database tables and Oracle database tables into flat data files and Excel sheet.
Designed and created reports based on technical specifications provided. Mapped data between Crystal Reports, Data Marts and the Enterprise Data Warehouse.
Provided design, implementation and maintenance for custom reports using SQL Server.
Develop and maintain proficiency the company’s products and services.
Adhere and apply policies and procedure of corporate office for project management.

We provide IT Staff Augmentation Services!

Sql Server Enterprise Manager Resume

Washington, DC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship