Data Sql Server
Resume:
Ana Hayle
*********@*****.***
SPECIFIC EXPERTISE:
. Over 3 years of Professional experience in the IT industry as a MS SQL
Server Developer/Administrator.
. Proficient in creating T SQL (DML, DDL, DCL and TCL), Indexes, Views,
Temporally Tables, Table Variables, Complex Stored Procedures, System and
User Defined Functions
. Experience in building database structures for data processing and query
analysis.
. Tracing and monitoring databases activities and performance using SQL
Profiler and windows Performance Monitor tool.
. Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server
Enterprise Manager and Management studio functionality using T-SQL
Scripts.
. Experience in Query Optimization, Tuning of Stored Procedures, and
Performance Tuning.
. Experienced in data loads, database integration/conversions, performance
tuning and optimization.
. Advanced extensible reporting skills using SQL Server reporting services
(SSRS). Created & formatted Cross-Tab, Conditional, Drill-down,
parameterized reports & custom reports.
. Ability to create Triggers, Stored Procedures, Functions, Generating
Scripts, Creating or developing Tables and Joins in SQL Server.
. Well-versed with database Installation, configuration, maintenance,
monitoring and debug Stored Procedures and Triggers.
. Excellent in writing highly complex and well-tuned SQL and Queries to
fulfill ad-hoc and strategic data segmentation requests.
. Capable of forming and maintaining positive and productive working
relationships in internal, external and team environments.
Technical Skills:
Databases: SQL Server 2012/2008R2/2005
Reporting Tools: SQL Server Reporting Service (SSRS)
ETL Tools: SSIS (SQL Server Integration Services), DTS(Data
Transformation
Services), Import Export Data, Bulk
Copy Program (BCP)
Operating Systems : Windows 2000/2003/2008/2012 Server/XP/Vista/Windows 7,
Professional Experience:
TD Bank Newark, DE Jun 2013 -
Present
SQL Developer/ Administrator
Responsibilities:
. Involved in gathering the report specifications by interacting with the
business users
. Created Joins and sub-queries for complex queries involving multiple
tables.
. Used DDL and DML for writing Triggers, Stored Procedures, and Data
manipulation.
. Extensively used SSRS to Export / Import data from existing development
to production database
. Used SSRS to create reports, customized Reports, on-demand reports, and
involved in analyzing multi-dimensional reports in SSRS.
. Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine
Tuning Advisor to optimize queries and enhance the performance of
databases.
. Implemented Functions, views, triggers, stored procedures and enforced
business rules via checks and constraints.
. Extensively used SQL Server's Data Tools to load data from source
systems, like Flat Files and Excel Files, transform the data based on
business requirement and load the data into the target database.
. Designed T-SQL queries to manipulate and migrate data from different
legacy databases to Data Warehouse.
. Created SSIS packages using different tasks and transformations and
moved data from various sources to appropriate destinations.
. Extracted data from various sources such as flat file, access, SQL server
and loaded those data into SQL server to build various reports.
. Coordinate with clients as needed for on-going system support and
troubleshooting .
US Bank, Minneapolis, MN
Jan 2011 - May 2013
SQL Developer
Responsibilities:
. Experience in using Performance Monitor, SQL Profiler and Database Tuning
Advisor to solve long running queries.
. Designed and developed different type of reports including Tabular forms,
Matrix (cross Tab report) form, Conditional, List items, Charts and Sub
reports, custom report, Drill down reports using SSRS.
. Created Database objects - Tables, Views, and Functions and developing
Procedures for implementing application functionality at the database
side for performance improvement.
. Worked extensively on SSIS Packages for extracting the data of the
customers from OLTP, transform that data and load it into OLAP
. Responsible for writing many business consolidations logics through
complex stored procedures coming from various data sources using MS SQL
Server 2008.
. Used multiple transformations and integrations in SSIS to meet the
business requirements by collecting data from heterogeneous sources like
XML and flat files to SQL Server databases using SSIS
. Generated weekly reports for higher product management team using SQL
Server Reporting Services (SSRS).
. Reviewed and fine-tuned stored procedures and triggers before production
migration.
Education:
BSc in Computer Science
Contact this candidate