Bi\sql Server Developer Resume
5.00/5 (Submit Your Rating)
SUMMARY
- Nine years of heavy MS SQL Server Database Development and administrative experience. Three years of SAP Business Objects Development.
TECHNICAL SKILLS
OBJECTIVE: To obtain a challenging position as a DBA or BI Development wif a progressive company that will utilize my MS SQL Server and SAP Business Objects experience as well as extend my noledge in Database technology.
SOFTWARE: MS SQL Server 2008 - 2012, SYBASE SYSTEM X and XI, TRANSACT SQL, Business Objects XI, SSRS, SSIS, SSAS, C#, POWERBUILDER 5.0-9.0, VSS, JIRA, Red Gate
PROFESSIONAL EXPERIENCE:
Confidential
BI\SQL Server Developer
Responsibilities:
- Design and develop fully automated ETL process’ to consolidate multi databases into one database unit using SSIS technology for TMS Application. Responsible for creating and maintaining all ETL processes using SSIS and C# technology.
- Create and maintain a variety of reports using MS SSRS. Convert existing reports from Crystal and MS Word format to SSRS . Work wif different departments and other IT staff to gather specifications for data and report requirements.
- Development of Stored procedure, Functions, Trigger, View, Index, Jobs, Alerts, SQL Mail Notification using Enterprise Manager and Query Analyzer.
Confidential
Business Objects /SQL Server Developer
Responsibilities:
- Responsible for Design and development Import data processes using MS SQL DTS and SSIS packages.
- Developed Stored procedure, Functions, Trigger, View, Index, Jobs, Alerts, SQL Mail Notification using Enterprise Manager and Query Analyzer.
- Performance, Optimization, and Tuning of SQL Server 2000/2008 Databases and T-SQL Queries using Enterprise Manager, Query Analyzer and SQL Server Profiler.
- Designed Physical and Logical Data Model and Normalization rules.
- Created and maintained a reports system using Business Objects XI and SSRS 2008.
- Maintained all existing legal systems and initial design through production and post-implementation enhancements
Confidential, New York
DBA Developer/DBA Administrative
Responsibilities:
- Performance, Optimization and Tuning of SQL Server 2000, Databases and T-SQL Queries using Enterprise Manager, Query Analyzer and SQL Server Profiler.
- Development of Stored procedure, Trigger, Index, Jobs, Alerts, SQL Mail Notification using Enterprise Manager and Query Analyzer.
- Development, scheduling, implementation and documentation of backup and recovery plan.
- Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting
- Create and maintain Import data process using DTS.
- Design and implementation of Replication solution for SQL Server 2000
- Assisted users and internal groups wif data analysis, ad hoc support and problem
