Sql Server Ms
Resume:
PROFESSIONAL CAPABILITIES
* ***** ** ********** ** Database Administrator, Data Analyst and Reports Developer.
Qualified, experienced and trained information technology professional. Four years of full life-cycle development experience with specialization in Web / Desktop application development on Microsoft .Net Development Platform.
Exposure to entire software development life cycle and experience with process based development and industry standards for development, GUIs, change management, document control, issues log and version control.
Sound experience in installation, configuration and maintenance of Database Servers.
5 Years experience in development of database systems, analytic reports (SSRS), SSIS,SSAS,BI,Dashboard.
Experience in MS SQL Server upgrades MS SQL Server 2005 to MS SQL server 2008 to MS SQL Server 2012/2014
Designed and developed Oracle database objects (schemas, table spaces, tables, indexes, views, materialized views etc.).
Experience in query optimization & performance tuning, execution plan, stored procedures.
Development, enhancement and support of Crystal Reports Solution for the Business.
Create dynamic reports in business intelligence suite for cost analysis using the data Banking Project.
Experience covers design, development, testing to successful implementation within budget, scope, timescales and process limitations.
Possess excellent verbal and written communication skills in French & English languages.
TECHNICAL CAPABILITIES
Database: Oracle 11g, SQL Server 2000/2005/2008/2012/2014, MY-SQL,SSIS
Languages: C#, SQL, PLSQL (Oracle), T-SQL
Reporting Tools: Crystal Report 10/11/12, SSRS,BI.
Development Tools: Microsoft visual studion.Net 2005/2008/2010
Operating System Windows Server 2003, Windows Server 2008 R2,Unix, Linux
PROFESSIONAL EXPERIENCE
CDI Computer Dealers Inc. March 2015 – To Date
Report Developer
Performance and Tuning of SQL Server using Index tuning, profiler
SQL Server upgrade and migration from version to SQL Server 2008 and SQL Server 2012/2014
Create BI Reports with the help of SSRS.
Development of Installer package for Microsoft SQL Server Analysis Services and required components
Support all Database problem with development team and QA Team.
Maintain all the Environments of Databases just like (Development, QA and Live).
Maintenance and Administration of Databases and Multidimensional Cubes (Process, Backup, Restore)
Assessment, Setup, Monitoring and troubleshooting of routine maintenance jobs and processes
Responsible for internal Reports.
Write user specific scripts as per application requirements
Installed, maintained, configured Operating Systems and Databases
Tuned SQL queries using indexes and table partitioning and correct database
Provided daily status report on technical issues to senior management
Analyzed Data, Table structure and Relationships after that Create Authentic Reports
Created Reports using Crystal Report 10 & 11
Created Report in Excel with the help of VB Code.
Maintained database recovery and backup schedule
Support for Collection software and Trouble shooting for user problems
Technical Environment: MS SQL SERVER 2008/2012/2014, SQL, Crystal Reports 10, XI,MS Access,SSIS,SSRS.
Sauvageau & Associates. Jan 2015 – March 2015
Database Administrator/Report Developer
Performance and Tuning of SQL Server using Index tuning, profiler
SQL Server upgrade and migration from version 2005 to SQL Server 2008 and SQL Server 2012
Development of Installer package for Microsoft SQL Server Analysis Services and required components
Maintenance and Administration of Databases and Multidimensional Cubes (Process, Backup, Restore)
Assessment, Setup, Monitoring and troubleshooting of routine maintenance jobs and processes
Responsible for internal Reports.
Write user specific scripts as per application requirements
Installed, maintained, configured Operating Systems and Databases
Tuned SQL queries using indexes and table partitioning and correct database
Provided daily status report on technical issues to senior management
Analyzed Data, Table structure and Relationships after that Create Authentic Reports
Created Reports using Crystal Report 10 & 11
Maintained database recovery and backup schedule
Support for Collection software and Trouble shooting for user problems
Technical Environment: MS SQL SERVER 2005/2008, SQL, Crystal Reports 10, XI,MYSQL.
Ottawa Systems Inc. March 2014 – May 2014
Database Administrator/Report Developer
Created the required table spaces, users, and roles for the application
Scripted for automating maintenance tasks and to ease administration
Wrote user specific scripts as per application requirements
Installed, maintained, configured Operating Systems and Databases
Troubleshot Data Base, application and handled user problems
Tuned SQL queries using indexes and table partitioning and correct database
Provided daily status report on technical issues to senior management
Analyzed Data, Table structure and Relationships after that Create Authentic Reports
Created Reports using Crystal Report 10 & 11
Maintained database recovery and backup schedule
Migrated Databases from SQL Server 2005 to SQL Server 2008
Technical Environment: MS SQL SERVER 2005/2008, SQL, Crystal Reports 10, XI.
Sidat Hyder Morshed Associated Pvt Ltd. October 2009 – January 2014
Senior Database Administrator/Report Developer
Creating the required table spaces, users, and roles for the application.
Scripting for automating maintenance tasks and to ease administration.
To write user specific scripts as per application requirements.
Using development and analytical skill to create reports (SQL,SSAS, SSRS, SSIS,BI, stored procedures).
Installation, maintenance, configuration of Operating Systems and Databases as well.
All trouble shooting related to DB & Application & handling the user problem.
Managing the All DBA related daily basis activities.
Tune SQL queries using indexes and table partitioning and correct database.
Responsible for regular deployments, maintenance and support and troubleshooting activities.
Provided daily status report on technical issues to senior management.
Query Optimization for the report for faster result.
Analyze Data, Table structure and Relationships after that Create Authentic Reports.
Creating Reports using Crystal Report 10 & 11
To maintain database recovery and backup schedule.
Monitoring database tuning and performance.
Migrating Databases from SQL Server 2005 to SQL Server 2012.
Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
Documentation, Leading projects, management, Training, Troubleshooting and support
[Tech. Environment: SQL Server 2012, SQL Server 2008/ R2/2005, SSMS, SSIS, Windows 2008, .NET,BI]
Technical Environment: MSSQL SERVER 2000/2005/2008,SQL,Crystal Report 10,11,12,SSIS,SSRS,SSAS,BI,VS.Net 2005/2008//2010.
Projects:
Procter & Gamble Sales & Distribution System
The objective of this project is Sales & Distributed System enable to maintain the Products Distribution Outlet Wise and to check the Performance of the product sales.
Banking Project Treasury Model
The objective of this project was the Treasury Model, it works in 2 categories: Money Market and Forex.
Money Market: The money market consists of financial institutions and dealers of money or credits who wish to either borrow or lend. Participants are borrowing and lending for short periods of time.
Forex: The primary purpose of the foreign exchange is to assist international trades and investments by allowing business to convert one currency to another currency.
Workflow System
The objective of this project is a solution that allows relationships between various activities to be defined. This will serve three purposes:
For automated activities the WS will serve as a parameter driven method to initiate processes in a sequence and within a time frame.
For non-automated activities the WS will serve as a tool to track the timely performance of activities against pre-defined standards.
ARY Communications (Pvt.) Ltd. July 2006 – September 2009
Worked as Database Administrator-Crystal Report Developer.
To write user specific scripts as per application requirements.
Using development and analytical skill to create reports (SQL, SSRS, SSIS, stored procedures).
Installation, Maintenance, configuration of Operating System and Databases as well.
All trouble shooting related to DB & Application & handling the user problem.
Managing the All DBA related daily basis activities.
Responsible for regular deployments, maintenance and support and troubleshooting activities.
Provided daily status report on technical issues to senior management.
Query Optimization for the report for faster result.
Creating Reports using Crystal Report 10 & 11
To maintain database recovery and backup schedule.
Monitoring database tuning and performance.
Migrating Databases from SQL Server 2005 to SQL Server 2008.
Technical Environment: MS SQL SERVER 2000/2005/2008, SQL, Oracle 11g,Crystal Report 10,11,12,SSRS,SSIS.
Projects:
ARY Sahulat Card Management System
The objective of this project was to keep complete detail of shopping, legitimacy and value back information, therefore, the Sahulat System was developed. This system used to load the transaction details which are received from ORIX Leasing Company.
EDUCATION
Bachelor of Computer Science (BS(CS)) January 2002 – December 2005
Shah Abdul Latif University (ORASOFT)
Contact this candidate