SUMMARY:

• Have 8 years of IT experience as a SQL Server DBA\ Developer\BI Developer. Seeking a position with new challenges and opportunities to build upon my knowledge and experience in
• MS SQL Server in the areas of Installation, Configuration, Development, Maintenance, Performance tuning, Security, Data Transformation and Business Intelligence.
• Extensive experience with SQL Server 2008\2005\2000 database administration and troubleshooting of day - to-day database issues.
• Extensive experience with SSIS and SSRS
• Good experience in installing and configuring SQL Server instances.
• Experience in data migration.
• Good experience with planning and implementing SQL Server security & database permissions.
• Good experience with Database Backup, Recovery and Disaster Recovery procedures.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, restoring database using full, differential, and log backups.
• Have experience with Performance Tuning.
• Have extensively used tools like SQL Profiler, Index Tuning Wizard and for monitoring and tuning SQL Server performance.
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP and Data Transformation Services DTS .
• Have experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC Utilities.
• Have good experience with the maintenance of Database authentication modes, user creation, configuring permissions and users’ assigning roles.
• Optimized DTS packages, procedures, functions and triggers. Fine-tuned Queries and Databases.
• Have good experience with Log shipping.
• Using Performance Monitor\Profiler to solve issues with deadlocks \ long running queries.
• Good experience with optimizing code, re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Have experience in writing and tuning database objects like Stored Procedures, and functions.
• Have experience in creating Jobs, Alerts, SQL Mail Agent and schedule DTS Packages.
• Have experience with Data normalization and database design using Visio\Erwin.
• Have good experience with using Performance Monitor to resolve System bottlenecks.
• Good experience with creating alerts, schema management, database reorganization, data loading, database maintenance, and optimization.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2008\2003

Languages: Transact-SQL

Databases: MS SQL Server 2008\2005\2000, MS Office Access 2010\2007

Tools: MS Visual Studio 2008\2005, MS SQL Server 2008\2005 Management StudioMS SQL Server 2000 Enterprise Manager\Query Analyzer\SQL Profiler.

MS Project: MS Office Suite 2010\2007 (Excel, Word, Project, PowerPoint, Visio) MS Visual SourceSafe 2008\2005, Adobe PhotoShop

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SQL Server Developer\ BI Developer

Responsibilities:

• Work with Project Manager in developing and executing project plans within assigned schedule and timeline.
• Tweaked stored procedures and functions for performance optimization.
• Wrote stored procedures and functions to implement complex business functionality.
• Follow data standards, resolve data issues, completeunit testing and system documentation for ETL processes.
• Collaborate with business analysts, subject matterexperts, and other team members to determine data extraction andtransformation requirements.
• Manage new report generation and report enhancement based on the change requests.
• Perform data warehouse design and modeling according to established standards.
• Determine business intelligence and data warehousing solutions to meet business needs.
• Generate and deliver quality reports to customers in timely and accurate manner.
• Identify and resolve data reporting issues in a timely fashion.
• Perform quality assurance checks on new or enhanced reports.
• Guide junior engineers in their duties when needed.
• Recommend improvements to provide optimum reporting solutions.
• Stay updated with business operations and business intelligence processes.
• Coordinate with Business Analysts and customers to develop business requirements and specifications documents.
• Develop standard reports and functional dashboards based on business requirements.
• Maintain business intelligence models to design, develop and generate both standard and ad-hoc reports.
• Generate reports for internal and external customers for business performance monitoring and business decision making.
• Use customer requirements to improve functionality (speed, performance \ usability).
• Conduct system tests, troubleshoot customer issues andcorrect database defects.
• Respond quickly to bug fixes and enhancement requests.
• Be able to take directions and complete tasks on-time with minimal supervision.
• Participate in special projects as needed and performsother duties as assigned.
• Work in a team environment
• Work on multiple assignments concurrently underaggressive deadlines.

Confidential, NJ

SQL Server Developer\ BI Developer

Responsibilities:

• Created complex SSIS Packages for Client File to be Imported in SQL Database.
• Worked closely with the Business Analysts and Testers to accomplish different test cases scenario and accomplish them through the SSIS package.
• Modified the exisiting Bulk Insert SPs and updated the SPs as per the business requirements.
• Converted the DTS packages to SSIS packages.

Confidential, NJ

SQL Server DBA\ Data Analyst

Responsibilities:

• Monitoring and supporting backup\restore activities.
• Scheduled Backups and performed Restore operations.
• Used SQL Profiler to analyze the data anomalies.
• Administering the SQL Server by creating User Logins with appropriate Roles, monitoring the user accounts, granting the privileges to users and groups for the P21 application.
• Troubleshooting slow running Queries by Performance Monitor and SQL Profiler.
• Worked extensively Prophet 21®, the Epicor wholesale distribution software utilizing the Windows-based platform and SQL Server database.
• Worked on Tableau, Business Intellignece Software making data interactive, creatiing sharable dashboards quiote powerful enough to satisy most analytical problems.
• Developed integrated and created consolidated reports using P21 Data source using SAP Crystal Reports 11 as a total reporting solution.
• Used SQL Profiler for creating Traces in identifying slow running Queries and analyzing data from Trace Data.
• Performed Database Integrity Checks using DBCC Commands and updated Database Statistics.
• Worked closely with User and involved in meetings.

Confidential, NYC

SQl Server DBA\Developer

Responsibilities:

• Monitoring and supporting backup\restore activities.
• Actively troubleshooting backend processes like SQL Jobs, SSIS packages.
• Developed scripts to migrate data from multiple sources.
• Data Migration from legacy to master tables using DTS-Import and Export wizard.
• Created tables and performed data imports and restores for successful migration.
• Worked on SQL Server 2008 migration from SQL Server 2005.
• Maintaining user security of database (Database Logins and permissions)
• Managing internal users for TAMS application (TRanist Account Management System).
• Assisted Developers in database design, writing queries for interacting the software and creating stored procedures for the application.
• Enforcing the standards and naming database conventions for tables and fields.
• Included administering daily and monthly SQL Server jobs.
• Created SSRS weekly and monthly reports for Finance and Marketing department.
• Created SSIS packaged to generate csv and txt deduction fixed length files for customers.
• Worked actively on customer support tickets (HelptIT and TrackIT applications).
• Generated Data for the Marketing and Finance Dept by writing ad-hoc queries as required.
• Used SQL Profiler to analyze the data anomalies.
• Worked extensively on AM7 and migrated the jobs on AM9.
• Received TOA (Token of Appreciations) for maintaining integrity, customer satisfation and teamwork.
• Experience with Microsoft Great Plains

Confidential, NJ

SQl Server DBA

Responsibilities:

• Installed SQL Server 2005 and configured Client Components.
• Administering the SQL Server by creating User Logins with appropriate Roles, monitoring the user accounts, granting the privileges to users and groups.
• Installing MD tablet application on the tablets.
• Set up, configure and administer Merge Replication.
• Administered Backup and recovery and administered Disk and Database Space.
• Used SQL Profiler and Windows Performance Monitor for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Confidential, NJ

SQL Server DBA

Responsibilities:

• Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery.
• Managed the products and development databases including performance tuning, SQL Server clustering, Replication, database security configuration, and database continuity.
• Creating and scheduling SSIS packages in SQL Server 2005 in Business Intelligence Studio to transfer data.
• Migrated data from SQL Server 2000 to SQL Server 2005.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Responsible to optimize the stored procedures and T-SQL queries.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Maintained and created replications Transactional and Snapshot .
• Installed MS SQL Server, Performed Database Design and created schemas using ERWIN.
• Scheduled backups and performed restore operations for system test data depends on testers’ requirement.
• Created DTS Packages to upload test data from Text files.
• Created DTS packages in SQL 2000 Enterprise manager using import\export to transfer data.
• Performed Data migration (import & export BCP) from Flat file to SQL Server. Data transfer using BCP and DTS.
• Performed query tuning and reduced response time 60%.
• Implemented and supported log-shipping servers.