Sql Server Data
Resume:
SAMRA KHIZAR
South Richmond Hill
NY 11419
***********@*****.***
Career objective:
To secure a challenging position as a Database Programmer and Administrator in an organization and utilize
my technical skills and IT knowledge for managing organization's projects.
EDUCATION:
Certification Querying MS SQL server (70461) Microsoft NY, USA
Master Electronic Commerce Bahuddin Zakriya University Multan, Pakistan
Bachelors Economics Bahuddin Zakriya University Multan, Pakistan
Technical Skill:
• Experience as MS SQL Developer in administration and development of database design and
development in SQL server 2012/2008R2/2008/2005 system on OLTP and OLAP
• Experience in installation, upgrade and configuration of Microsoft SQL server and databases.
• In depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, and
User defined data types and indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL
Server 2012/2008R2/ 2008/2005
• Experience backup and restore.
• Server knowledge of windows NT/2000/2003, Linux
• Knowledge of working in spread sheet. Microsoft excel database.
• Experience working with Google doc spread sheet and forms.
• Knowledge of import, export data using BCP.
• Knowledge of creating reports using SSRS.
• Knowledge of performance tuning and maintenance on the database level.
• Analyze and document new data or reports.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report,
Matrix report, Chart report, Pie Charts and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for
OLTP and dimension modeling for OLAP.
• Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high
Samra Khizar
pressure environment.
Business Skill:
• Familiar with the project management life.
• Dedicated, well organized and disciplined in work.
• Ability to interpret user needs and transform them into applications.
• Skilled at thinking logically and analyzing the given data.
• Ability to handle work pressure and provide quality work.
• Ability to focus on managing and resolving issues.
PROFESSIONAL EXPERIENCE:
Junior SQL and excel developer June 2011 – Dec 2012
Nov 2013- Current
Alison’s Montessori
Queens NY & New Jersey
• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for
tuning the database. Implemented different types of constraints on tables.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Created the reports based on the requirements using SSRS 2008.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing
demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time,
Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and
interpretation.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build
dimensions and load data to fact tables.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
Handled dead lock scenarios.
• Importing data from excel to SQL server.
• Managing Excel data with VBA programming.
• Managing Excel Sheets.
2
Data Analyst Aug 2013 – Oct 2013
Schaffer Williams LLC
Client: Advocacy Institute
Brooklyn, New York
• Part of a team for creating a new database.
• Creating structure of data Model.
• Filter data, sorting the data.
• Perform analysis of data (inputs and grouped data) using exist district data.
• Collaborate with other analysts on the team.
• Created use case diagrams to explain the flow of events and how different software systems
interact with each other.
• Conducted workflow, process diagram and gap analysis to derive requirements for existing
systems enhancements.
• Meetings with internal UHG customers/project stakeholders to collect and document/write business
requirements and/or explain results of analysis.
• Work with system architects, developers and testers throughout the development lifecycle for new project
work and enhancements.
• Comfortable working both independently and collaboratively.
• Testing the data.
Junior SQL Server Developer Mar 2013 – Jul 2013
Db Directions
Brooklyn, New York
• Build up the database architecture and models.
• Understanding the foundation of T-SQL and logical Querying process.
• Working with data types and built-in functions.
• Filtering data, sorting data.
• Install, configure and upgrade the server to suit the database needs.
• Creating tables, alter tables, enforcing data integrity on the tables.
• Working with joins, Table Expressions, Sub Queries.
• Design and creating views, inline function and synonym.
• Inserting, updating and deleting data.
• Design the schemes, permissions and tables for database.
• Include objects into database like triggers, stored procedures and cursor.
• Implementing Indexes and statistics.
• Implementing transactions, Error Handling, and dynamic SQL.
• Understand the knowledge of optimization and Execution plan.
• Working with XML data.
• Design automated systems to determine information and make reports.
• Control the access for database by giving security password and permissions
Junior SQL DBA and .Net programmer Feb 2009 – Jan 2010
Akil’s Inc
Samra Khizar
Lahore, Pakistan
• Developed a windows based software with VB.Net and SQL server for store and
monitor company assets.
• Gathered project requirements, performed all testing, and trained the end user on how
to use the software.
• SQL server database and tables developed from scratch using SQL server management
studio.
• Installation, configuration and upgrading SQL server software and related products.
• Involved in designing of data model of the database.
• Setting up backup/restore and disaster recovery procedures to ensure minimal down
time
• Worked on the mirroring.
• Creating & Granting Access Permissions to Users.
• Checking error logs for solving problems.
• Responded quickly for alerts to solve issues..
• Monitoring Jobs and Schedules
Trainee DBA Mar 2008 –
•
Jan 2009
Bahuddin Zakriya University (Exam Dept)
•
Multan, Pakistan
•
Provided constant online or on-call assistance to end users for handling their queries
•
Maintained a backup or recovery options to retrieve the lost data
•
• Performed data cleansing and data migration functions
• Assisted in building strategies for installing and improving the database
• Inspected the operations of the database as per the standards set by the organization
Other: Overcome Problems with continuous focus and hard work not matter how difficult it would be.
4
Contact this candidate