Sohag D

acd4h1@r.postjobfree.com

732-****-****

acd4h1@r.postjobfree.com

Professional Summary:

• An accomplished SQL Server Developer with 7+ years of extensive experience in database design,

development and administration with MS SQL Server versions 2012/2008/2008R2/2005/2000 using

SSIS, SSAS, SSRS (BI Tools) in various industries.

• Strong experience in creating T-SQL objects, working with DDL/DML, performs most of the SQL

Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.

• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration

Services (SSIS), DTS, Bulk Insert, BCP.

• Expertise in Extraction, Transforming and Loading (ETL) data using BI/SSIS creating

mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources

and load into various Business Entities(Data Warehouse, Data mart).

• Expertise in generating reports using SQL Server Reporting Services (SSRS), and Microsoft Access

& Excel spreadsheet.

• Proficient in creating Indexed Views, complex Stored Procedures, effective functions, and

appropriate Triggers to facilitate efficient data manipulation and data consistency.

• Experience in writing Distributed Queries between SQL Servers.

• Expert in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and

Windows Performance Monitor for Monitoring and Tuning Server Performance.

• Handled vast financial data, expert level query optimization and performance tuning experience.

• Familiar with version control Team Foundation Server (TFS).

• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued and

various Adhoc reports through Report model creation using BI/ SSRS.

• Proficiency in Developing BI/SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data

Mining Models, and Deploying and Processing SSAS objects.

• Excellent Knowledge of Software Development Life Cycle(SDLC), Agile Methodology, RDBMS,

Data Warehouse & Data Modeling concepts.

• Good Business and System analysis skills to understand the requirements and customize client

applications.

• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent

communication skills, proactive, self-managing and teamwork spirits.

• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical,

troubleshooting, and problem solving skills.

• Very good team player with ability to perform under stress and excellent presentation and technical

documentation skills.

• Expertise in Object Oriented Analysis and Design.

• Excellent analytical, problem solving, communication skills and team player.

• Strong research and analytical skills, computing abilities, problem solving, dynamic leadership quality.

Technical/Business Skills:

MS SQL Server 2012/2008R2/2008/2005/2000, MS SSRS 2008/2005/2000, MS SQL SSAS 2008/2005/2000,

MS SSIS 2008/2005/2000, DTS, Erwin Designer 2000, Power designer, DB2 SQL syntax, MS-Access 2000,

C, C++, java, JDBC, Tomcat, JBOSS, JSP, VB 6.0,Developer 2000, Erwin 7.3/4.2/4.2/4.0, Oracle 9i/10g, T-

SQL, PL/SQL, ASP.NET,, HTML,XHTML, XML, XSL,DOM, Visual Studio 2005,Eclipse,RAD,TOAD, T-

SQL, PL-SQL, Crystal Reports, ODBC, MS Office, Windows NT/ 2000 Server/ XP, UNIX/LINUX, Solaris.

Education & Certification:

Bachelors in Computer Science

Professional Experience:

Security Benefit, Topeka, KS Nov 2012 – Till Date

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.

• Gathered data and documenting it for further reference and designed Database using Erwin data

modeler.

• Designed ETL packages for extracting the data and load into the appropriate tables in the database

using SQL Server Integration Services (SSIS).

• Responsibilities include were data analysis, reporting, issue tracking/management, status

reporting/management and other analysis to support the ongoing Supply Chain Analytics initiative.

• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow

Task, Sequence Container, and Expression.

• Developed E-Business Suite programs for databases supporting supply chain management, order

management Created SSIS package to load data from Flat Files and SQL Server 2008R2 to SQL

Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term

Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse

and Data Mart Databases.

• Modified the existing SSIS packages to meet the changes specified by the users.

• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database

on Daily basis using SQL Server Agent.

• Created stored procedures to do two phase load of data to staging area and then to warehouse using

SSIS packages

• Involved in usage of various SSIS components like for loop, Foreachloop, Derived column, Sql

execution task, Variables, and Error Handling etc.

• Modified SSIS ETL package for changed business requirements to load data from different source files

to SQL Server tables in data warehouse.

• Involved in Unit testing in SSIS Packages, Query verification in SSIS and Stored Procedures.

• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.

• Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports

using SSRS 2012.

• Created reports to retrieve data using Stored Procedures that accepts parameters.

• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

• Responsible for Monitoring and Tuning Report performance.

• Created various database object like stored procedures, functions, tables, views

• Configured the report viewing security for various users at various levels using Report Manager

• Scheduled report and exported in PDF format.

• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database

Engine Tuning Advisor.

• Provided documentation for all kinds of reports and SSIS packages.

• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: MS SQL Server 2012/2008, SSIS, T-SQL, SSRS, Win 2008 Advanced Server, VSS, Erwin v7.3.

Citizens Bank, Providence, RI July 2011 – Oct 2012

SQL Server Developer/ SSIS/ SSAS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and

provided documentation.

• Installed SQL Server and Management tools using SQL Server Setup Program.

• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server,

Excel and Access to SQL Server using Business Intelligence Development Studio.

• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived

column.

• Wrote T-SQL queries, Store Procedures and used them to build packages.

• Handled slowly changing dimensions to maintain the history of the data.

• Migrated packages from development server to production server using package configuration.

• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.

• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using

SSRS.

• Implemented AD HOC reporting with the report builder for the end users.

• Created reports to retrieve data using Stored Procedures that accepts parameters.

• Generated reports using Expressions and Functions using SSRS.

• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of

software.

• Designed, reviewed, and created primary objects such as views, indexes based on logical design

models, user requirements and physical constraints.

• Improved Performance of the database by creating Clustered and non-clustered Indexes and by

optimizing the T-SQL statements using SQL profiler.

• Used SQL Server profiler for auditing and analyzing the events, which occurred during a particular time

horizon and stored in script.

• Evaluated database performance and performed maintenance duties such as Tuning, Backup,

Restoration and Disaster Recovery.

Environment: MS SQL Server 2000/2005, SSIS, SSAS, T-SQL, SSRS-2000/2005, Erwin, Enterprise, Visual

Studio 2000/2005.

GE Financial, Stamford, CT July 2010 – June

2011

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources.

• Created packages to validate, extract, transform and load data to a centralized SQL server using

OLEDB providers from the existing diversified data sources. .

• Worked with integration services for transferring and reviewing data from heterogeneous sources like

Excel, CSV, flat file, Text Format Data.

• Designed high level SSIS architecture for overall data transfer from the source server to the

Enterprise Services Warehouse.

• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP

and OLTP databases.

• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and

Derived Column.

• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.

• Migrated packages from development server to production server using package configuration.

• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill

through, Sub reports using SSRS.

• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS .

• Deployed generated reports onto the Report Server to access it through browser.

• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily

reports for all domains and published through Report Server.

• Created various reports by comparing the growth of company based on each quarter by using bar charts.

• Responsible for generating annual reports based on the growth of company with respect to customers.

• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables,

Views and other T-SQL code and SQL joins for applications.

• Improved Performance of the database by creating Clustered and non-clustered Indexes and by

optimizing the T-SQL statements using SQL profiler.

• Conducted user training sessions and supported the requests for enhancements, modifications and new

reports.

Environment: MS SQL Server 2008R2, Reporting Services (SSRS), Integration Services (SSIS), Microsoft

Performance Point Server 2008R2, Microsoft Share Point Server, T-SQL, .NET, C# MS Access and Excel.

Oritani Bank Bergen Field, NJ May 2009–June 2010

MS SQL Server/ SSIS/ SSRS Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business

needs and discuss solution options.

• Successfully installed and configured MS SQL Server 2008 on the production server.

• Automated the migration of data from Oracle DB to MS SQL Server 2008 DB using Microsoft SQL

Server Migration Assistant (SSMA).

• Generated assessment reports to analyze the scope and complexity of the migration projects.

• Converted the Oracle DB objects to MS SQL Server 2008 DB objects like tables, views, and stored

procedures.

• Designed a new schema design for the data warehouse using dimensional modeling and developed it

using the Erwin tool.

• Migrated the entire schema as well as data into MS SQL Server 2008 and also validated the migration

process to ensure that it has been successfully migrated.

• Performed various transformations like conditional split, sorting and included data about the

environment using the audit transformation.

• Designed drilldown, drill through, and parameterized report using SSRS.

• Deployed generated reports onto the Report Server to access it through browser.

• Designed, reviewed, and created primary objects such as views, indexes, views and store procedures.

• Worked with User Defined Functions, Triggers to store data into appropriate tables as and when data

arrives and created indexes to the tables that have least update to improve the query performance.

• Defined referential relationships with the measure groups and fact tables.

• Documented the development work and production release for future reference.

Environment: MS SQL Server 2008, SSIS 2008, Visual Studio 2008, T-SQL,MS Access, Windows XP, Erwin

v4.0.

Quicken Loans Inc, Hartford, CT August 2006 - April 2009

MS SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS SQL Server 2005.

• Involved in migration of SQL server 2000 to SQL server 2005 using Upgrade Advisor.

• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data

into database, archive data file from different DBMS’s using SQL Enterprise Manager/SSMS on SQL

Server 2005 environment, and deploy the data, scheduled the jobs to do these tasks periodically.

• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables

and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant

performance boost using index tuning wizard.

• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures

to retrieve the customer details, connection details, payment history by giving the related parameters.

• Involved in Performance tuning and optimizing for SQL Server Application by using performance

monitor.

• Generated test data and tested database to meet the functionalities/deliverables in the project

documentation and specifications.

Environment: MS SQL Server 2005, SQL server 2000, MS Excel, SSIS, T-SQL.

Contact this candidate