Sql Server Data
Resume:
Hossain Zahed
SQL Server Developer
Email: **************@*****.***
Phone: 972-***-****
PROFESSIONAL PROFILE:
• Over 6 years of IT experience as a SQL Server Developer using SQL Server 2005/2008/2012 with
special prominence on SQL Server Integration Services, SQL Server reporting services in IT
Business,Food Industry and Healthcare.
Good team player with strong analytical skills.
•
Experienced in all phases of the system development life cycle (SDLC)
•
Expert in designing relational database model and implementation as per business requirements.
•
Responsible for Logical and the Physical design of the database according to requirements.
•
In depth knowledge of Transact SQL DDL and DML.
•
Extensive knowledge in Tuning SQL queries and improving the query performance.
•
• Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and
tuning MS SQL Server performance.
• Experience in enhancing and deploying the SSIS Packages from development server to production
server
• Experience in migrating DTS packages, reports and analysis services projects from SQL server
2005 to SQL server 2012.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SQL
Server Integration Services (SSIS), BCP and DTS utility. Extracting, Transforming and loading of data
using SSIS and DTS.
Experience in BI Tools (Reporting Services, Integration Services and Analysis services)
•
Developed Drill through and Drill down reports using SQL Server Reporting Services (SSRS).
•
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL
Server Analysis Services (SSAS).
Experience in Dundas Dashboard Visualization
•
Created Cube, Dimension and KPI for Dundash dash Board
•
Wrote C, VB.net script back of Dundas Dash Board
•
Experience in development of Trigger, Procedures, Functions and Packages.
•
Extensive experience in T SQL, Dynamic SQL, Analytical function, Expert in Data Conversion,
•
Data Analysis and validation.
Experience Developing ETL process loading Data Warehouse/DataMarts
•
TECHNICAL SKILLS:
Databases MS SQL server 2005/2008/2012, Oracle 10g
SQL Server Management Studio, BIDS (SSIS, SSAS, SSRS), SQL Server
SQL Server Tools
Query Analyzer, SQL Server mail service, DBCC, BCP, SQL Server profiler
Languages C, VB .net, ASP.net, SQL, T SQL, PL/SQL
Operating Systems Windows 2003/XP/VISTA/Windows 8, Windows NT, Linux(Ubuntu)
ETL Tools Data Transformation Services (DTS),SQL Server Integration Services (SSIS)
OLAP/Reporting Tools SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS),
Scripting Languages Shell
Other tools Toad, Visual Studio 2010, Dundas Dashboard 4.2.1
Professional Experience
Caliber Home Loans, Database Analyst –Irving, Texas Aug2013 April2014
A Caliber Home loan is located in Irving, Texas. Caliber Home loans do business with Freddie and Fannie
Mae for home loans.
Created ETL packages using BIDS 2008/2012 and implemented Delta process.
•
Created Ad hoc report in Excel as per business requirements.
•
Created SSRS Reports like EPO 30 days, spring field and deployed the same in to production.
•
Developed stored procedure APT purchase, collection data ration and fee analysis for using in new
•
package as per business requirement.
Optimized procedures which are taking longer to finish and able to improve the performance
•
drastically. These procedures will feed the data that are required for SSRS reporting.
Migrated data from various sources into the SQL Server 2008 using ETL (Extract, Transform,
•
Load) tool SQL Server Integration Services (SSIS)
Analyzed the system and prepared data in the form excel report to the End user by using SSRS and
•
also reported date in excel for their business use.
Wrote T SQL queries for SSRS reporting and SSIS packages.
•
Wrote store procedure to load data from stage tables to dim tables using slowly dimension method.
•
Med Synergies SQL/ETL Developer Irving, Texas June2013 – Aug2013
Med synergies are located in Irving, TX. Med synergies do business with different health industry like
Vanguard, VHA and THR.
• Created ETL packages using BIDS 2008/2012
• Created Master Package for different Vendors and worked on Configuration of
Master Packages.
• Involved in production support for packages and fixed number of child packages
Those are failed at night time.
• Developed stored procedure for using in new package as per business requirement.
• Optimized procedures which are taking longer to finish and able to improve the performance
drastically. These procedures will feed the data that are required for SSRS reporting.
• Migrated data from various sources into the SQL Server 2008 using ETL (Extract, Transform,
Load) tool SQL Server Integration Services (SSIS)
• Used various data transformations like fuzzy lookup, Lookup derived column transformation etc.
while creating SSIS packages.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server
2005 and Flat files.
• Worked on XML configuration of packages and implemented same in production.
• Created package for archive that point to SQL server instead of folder archive.
• Implemented data mart, facts, dimensions, snowflake schema and OLAP cubes
SQL Developer (SSIS, SSRS, SSAS) – FSCF, Fort Worth, TX January 2012 May2013
FSCF Inc. Located Fort Worth Texas. They produce quality pizza ingredients for top brand pizza like papa
jones and top retail business like Wal Mart.
Coordinated with front end for implementing logic in stored procedures and functions.
•
Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins,
•
Constraints, DDL, DML and User Defined Functions to implement the business logic and also
created clustered and non clustered indexes.
Created simple and complex quires like inner joins and sub quires
•
Tune and optimized query using SQL Query Analyzer Tool.
•
Setup Cluster environments for 2012 SQL Server
•
SQL Server Configuration Setting
•
Created Cluster index, non cluster index based on table requirements.
•
Created backup recovery like Transaction Log Backup.
•
Migrated data from various sources into the SQL Server 2012 using ETL (Extract, Transform,
•
Load) tool SQL Server Integration Services (SSIS)
Used various data transformations like fuzzy lookup, Lookup derived column transformation etc.
•
while creating SSIS packages.
Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server
•
2005 and Flat files.
Created SSIS and SSAS package using Visual studio 2010.
•
Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
•
Created Report Subscription and Data Driven Subscription using Visual Studio 2010
•
Created OLAP Cube and Dimension using Visual studio and SQL Analysis Services.
•
Expertise in Dundas Dashboard Visualization
•
Created cube and dimension in Dundas Dashboard.
•
Created virtual table and KPI .Based on KPI created Dashboard like Bar Chart, Pie chart and Data
•
set.
Wrote VB.net and C++ script back of Dundash Dashboard to make sure all the parameter work
•
properly in the Dashboard.
Involved in designing and maintaining complex ETL processes for enterprise Data warehouse
•
incremental and full loads using SQL Server Integration Services.
Implemented data mart, facts, dimensions, snowflake schema and OLAP cubes
•
Environment: SQL Server 2012/2008, BIDS 2010, Visual Studio 2010, T SQL, SSIS/SSRS/SSAS,
Dundas Dashboard 4.2.1, Window Server XP/Window7
SQL Developer, Volt Corporation (Dell Children Hospital) Oklahoma City, Oklahoma Jan2010
Jan2012
The Dell Children Hospital is a national hospital founded by the Michel Dell, whose mission is to accelerate
the clinical development of immune tolerance therapies through a unique development model. While
working for Dell Children Hospital, I extensively used SQL Server 2005/2008 to design and implement
SQL Server database. Day to day operation included successfully code and test functions, stored procedure,
trigger, SSIS and SSAS packages, SSRS Reports
Translated the business logic from normal business system to a database.
•
Formed tables, created relationships between those tables based on whether it was a one to one,
•
one to many, or many to many relationship and created look up tables (many to many) if needed.
Wrote queries to retrieve necessary data from the database.
•
Utilized different joining techniques, like inner join, left join, right join etc. for retrieval. Used SQL
•
commands, such as insert, update, delete and truncate, for successful DML (Data Manipulation
Language) implementation.
Created SSIS (SQL Server Integration Service) packages for data transformation and loading of
•
different ETL layers. SSRS and SSIS
Worked with flat files from multiple vendors, formatted and validated them before moving them
•
over to destination tables
Responsibilities:
Actively involved in analyzing the old database system and mapping tables, relationships, columns
•
to SQL Server 2005.
Created stored procedure to move data along the ETL boundary and layers. Stored procedures
•
contained business rules for data validation, sequential CRUD (Insert, Update, Delete) based on
business rule and user requirement.
Extracted data from various data sources such as Access database, Excel spreadsheet, and flat files
•
into SQL server using multiple transformations from SSIS such as Data Conversion, Conditional
Split, Bulk Insert, merge and union all.
Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package
•
according to the advanced feature of SQL Server Integration Services
Created table index
•
Experienced in dimensional modeling, Star Schema / Snowflake Schema, FACT and Dimensional
•
tables.
Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning
•
Wizard.
Design ETL process involving data quality, testing and information delivery and access to the data
•
warehouse.
Created Reports using SQL Server Reporting Services (SSRS) using BIDS.
•
Wrote Store Procedure, Function Based on Business purposes
•
Created Views and designed new table.
•
Environments: SQL Server 2005/2008, Windows XP/Vista, Windows7.Visual Studio 2008
SQL Developer (SSIS, SSRS), SM Net Solution, Plano, TX Jan 2007 Jan2010
SM Net Solution is a software outsourcing/consulting company that offers software solution to its client
both in the USA and offshore. It is currently located in Plano, TX and works with multiple clients across the
US. The company currently takes different database and software projects that include the business need of
SQL Server 2005/2008and VS 2010 software. While working for SM Net Solution, I extensively used SQL
Server 2005/2008 to design and implement SQL Server database. Day to day operation included
successfully code and test functions, stored procedure, trigger, SSIS and SSAS packages, SSRS Reports
Responsibilities:
Understanding and documenting business rules, input/output requirement and data sources
•
Creating database objects And Developing and modifying SQL packages, functions and
•
procedures, triggers.
Created new tables, views, indexes,
•
Implementation of new databases, maintenance for existing databases, implementation and
•
maintenance of security and database monitoring activities.
Timely completion of activities for database backup, restoration and health of databases.
•
Implementing the changes in the existing code and modifying stored procedures.
•
Responsible for database backup, restores and performance tuning.
•
Responsible for SQL Server Jobs.
•
Transferred Data from source to destination using 2008 BIDS like Excel file, Flat file,OLEDB
•,XML file
Responsible for monitoring and making recommendations for performance improvement in hosted
•
databases. This involved index creation, index removal, index modification, file group
modifications, and adding scheduled jobs to re index and update statistics in databases.
Technology Used: SQL Server 2005/2008, XP, ASP.net, BIDS
Education:
Bachelor of Science in MIS, University of Central Oklahoma, OK
Associate of Computer Science, Allen County Community College, KS
Contact this candidate