Sql Server Data
Resume:
Syed
Bay Shore NY *****
*******@*****.***
Summary:
Around 7+ years of extensive IT professional experience with expertise in Database
Development, Database modeling, Design and Technical Management.
Extensive experience in installation and configuration of MS SQL Server 2008/2005/2000
Versions.
Extensive knowledge of Relational Database Management Systems.
Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes,
Triggers, Temporary tables, user defined data types and functions.
Experience in MS SQL Server configuration manager, performance tuning, SQL Profiler,
client/server connectivity, query optimization, store procedure optimization, back-
up/recovery, running Database Consistency Checks using DBCC.
In-depth knowledge of T-SQL, MS SQL (DDL, DML, and DCL).
Hands on experience in troubleshooting database issues.
Experience in migrating Data from Excel, Flat file, Oracle to MS SQL Server by using MSSQL
Server DTS and SSIS.
Hands on experience in setting and monitoring Backups\Restore, Database Mirroring, Log
shipping and Replication.
Maintained Database authentication modes, created users, configuring permissions and assigning
roles to users.
Experience in DTS, SSIS, SQL Server Enterprise Manager, and SQL Query Analyzer, Access
2000/2003, Excel 2000/2003.
Experience in creating packages, Jobs, Alerts using DB Mail.
Used Microsoft Source Safe for version control and configuration management.
Experience in development the Microsoft Analysis services cubes.
Experience in Designing, Creating, and managing multidimensional structures using
SSAS.
Hands on experience on SSRS Configuration and generating reports of day-to-day transactions.
Good team player, strong interpersonal and communication skills combined with self-motivation,
initiative and the ability to think outside the box.
Education:
Bachelors Degree in Computer Science, Lehman College,City
University of New York
TECHNICAL SKILLS:
RDBMS MS SQL Server 2005/2008, R2
Database Tools Enterprise Manager, Query Analyzer, SQL Profiler,
Data Transformation Services, Upgrade Wizard,
SSIS, SSRS, SSAS,
Programming Languages SQL, TSQL,,SP, ASP.NET,C#, HTML, XML,, Java,
Scripts Java Script, VB Script, HTML
Applications Microsoft office, vss and Visual Studio
Reporting Tools SSRS
PROFESSIONAL EXPERIENCE:
R R Donnelley: March 2013 – To date
RR Donnelley is the Mother company of BOWNE and G2COM, they deal with
Financial data of all shareholders.
Role: Ms SQL Developer/ SSIS Package Developer
Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and
Functions.
Actively involved in writing T-SQL Programming for implementing Stored Procedures.
Designed SSIS Packages using BIDS to bring data from different sources to Data Arc
Environment: MS SQL Server 2008, Management Studio, BIDS/SSIS, Visual Studio2010,
VSS, FoxPro
Computech Inc.: Nov 2012 –February 2013
Computech Inc is a consulting and Technology School system.
Role: Ms Sql developer
Clean database using constraints
Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and
Functions.
Actively involved in writing T-SQL Programming for implementing Stored Procedures.
Working with SSIS to import/export and transform the data between the linked servers and
databases.
Designed SSIS Packages using BIDS to transfer data across different platforms,
Environment: MS SQL Server 2008, Management Studio, BIDS, Visual Studio2010, SSIS, SSAS,
SSRS, T-SQL, ETL, SQL Profiler
Bronx Hospital: May 2010- Dec 2011
Role: Ms sql developer
Created Database SCHEMA and table Partition SQL scripts to address production data
problems.
Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and
Functions.
Actively involved in writing T-SQL Programming for implementing Stored Procedures.
Worked with SSIS to import/export and transform the data between the linked servers.
Designed SSIS Packages to transfer data across different platforms,
Experience using SQL Profiler to find long running queries and Stored Procedures.
Designed and implemented user log in and security.
In-Depth working knowledge of ODBC.
Created many complex Stored Procedures / Functions and used them in to generate reports on
the fly.
Environment: MS SQL Server 2008, Management Studio, BIDS, Visual Studio2010, SSIS, SSRS, T-
SQL, ETL, SQL Profiler, Tuning Advisor.
Eztech: Eztech is an IT consulting firm, they have 15-20 developer who work on any
database project from small to large company like Metlife, United Health Group etc.
Role: SQL Server Developer August 2008 – May 2010
Responsibilities:
Developed the databases for the individual departments of the hospital and the central database, which
contains information about all the departments.
Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and
Defaults, Rules and User Defined data types and Functions.
Created Triggers, checks and constraints to maintain data integrity.
Developed complex T-SQL code for the application conversions.
Designed and implemented user log in and security.
Generated server side T-SQL scripts for data manipulation and validation and created various
snapshots and materialized views for remote instances.
Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
Actively involved in migration of DTS packages to SSIS packages.
Responsibilities:
Write and review good quality SQL in order to change/fix data in a Production environments.
To liaise with Support and the Business and provide SQL Reports from Production data.
Create Daily SQL scripts to address production data problems.
Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and
Functions.
Run SQL scripts against production data during maintenance windows. Create Daily SQL
Subscription’s to address Production Business reporting requests for analysis.
Replicated a Database and its entire object to a different Server and changed the SQL jobs to
point to the new Server.
Built Drill Down, Drill through and sub reports using SSRS 2008.
Actively involved in writing T-SQL Programming for implementing Stored Procedures,
Dynamic queries and Functions for different tasks.
Worked with SSIS to import/export and transform the data between the linked servers.
Designed dynamic SSIS Packages to transfer data across different platforms, validate data during
transferring, and archived data files for different DBMS.
Environment: MS SQL Server 2008, Management Studio, BIDS, Visual Studio, SSIS, SSAS, SSRS, T-
SQL, ETL, SQL Profiler, Tuning Advisor, Windows 2003.
Ahyaan Trade International Inc. New York
SQL Developer August 2006- May 2008
Responsibilities:
Design, Create, Ms SQL Database
Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and
Functions.
Run SQL scripts against production data during maintenance windows. Create Daily SQL
Subscription’s to address Production Business reporting requests for analysis.
Replicated a Database and its entire object to a different Server and changed the SQL jobs to
point to the new Server.
Built Drill Down, Drill through and sub reports using SSRS 2008.
Actively involved in writing T-SQL Programming for implementing Stored Procedures.
Worked with SSIS to import/export and transform the data between the linked servers.
Designed dynamic SSIS Packages to transfer data across different platforms, validate data during
transferring, and archived data files for different DBMS.
Managed and delegated the work to offshore team.
Environment: MS SQL Server 2008, Management Studio, BIDS, Visual Studio2008, SSIS, SSAS,
SSRS, T-SQL, ETL, SQL Profiler, Tuning Advisor, Windows 2003.
NYS Department of Health
SQL Developer April 2003-May 2006
Responsibilities:
Developed the databases for the individual departments of the hospital and the central database,
which contains information about all the departments.
Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and
Defaults, Rules and User Defined data types and Functions.
Created Triggers, checks and constraints to maintain data integrity.
Developed complex T-SQL code for the application conversions.
Designed and implemented user log in and security.
Generated server side T-SQL scripts for data manipulation and validation and created various
snapshots and materialized views for remote instances.
Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
Actively involved in migration of DTS packages to SSIS packages.
Worked with SSIS to import/export and transform the data between the linked servers.
Wrote Stored Procedures in designing various SSIS packages.
Handled complex queries used in SSIS and SSRS.
Developed SQL Queries to fetch complex data from different tables in remote databases using
joins, database links and formatted the results into reports and kept logs.
Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
Developed reports using SSRS and published as PDF formats.
Environment: SQL Server 2000/2005, VB.NET, Windows 2000 and 2003, Management Studio, Business Intelligence
Development Studio and Replication.
Contact this candidate