SUMMARY

• Over 7 years of strong professional experience in SQL Server 2012/2008/2005/2000 as Database Administrator and Developer.
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non - Clustered environments.
• Experienced in Configuring, Implementing and Maintaining Database Mirroring.
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Hands on experience in monitoring and tuning database resources and activities for SQL Server databases.
• Proficient in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, effective functions, Cursors and Indexes using T-SQL.
• Excellent knowledge on Object Oriented Programming concepts (OOPS), Relational Database concepts and experience in writing queries using SQL.
• Experience in Data Warehouse Development environment using Microsoft SSIS and SSRS.
• Experience in capacity planning, performance tuning, and disaster recovery and troubleshot performance issues.
• Extensive knowledge in design of logical and physical data modeling using Erwin data modeling tool.
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server.
• Experienced in Data Extraction, Transforming and Loading (ETL) between different source and destinations using Server Integration Services (SSIS).
• Experience in developing reports and deploying reports in SSRS using Report Wizard, Report Builder and Report Manager.
• Experienced in Logical and Physical Database design and development, Normalization, Data mapping, Data profiling and Data modeling using Erwin and MS SQL Server Enterprise manager.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities.
• Extremely diligent strong team player with an ability to take new roles.
• 24/7 On Call Support for Production servers.

TECHNICAL SKILLS

Languages: C, C++, T-SQL, PL/SQL.

Database: MS SQL Server, MS Access.

SQL Server Tools: MS SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Management Studio (SSMS), Enterprise Manager, SQL Query Analyzer, SQL Profiler, Business Intelligence Development Studio (BIDS).

Reporting Tools: MS SQL Server Reporting Services (SSRS), Crystal Reports.

Operating Systems: Windows, UNIX.

Other: IIS, ERWIN.

PROFESSIONAL EXPERIENCE

Confidential, Fort-worth, TX

Sr. SQL Server/BI Developer

Responsibilities:

• Responsible for understanding user requirements, designing and developing the application.
• Analyzed and evaluated requests for reports and develop, create and modify procedures to extract data from various data sources and the corporate data warehouse using report writers and data extract tools.
• Participated in writing Stored Procedures for performing optimization and other database operations such as complex SQL queries, views and triggers etc.
• Developed database application forms using MS Access in coordination with SQL tables and stored procedures.
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Retrieved data from data warehouse and generated a series of business reports using SSRS.
• Validated and tested reports, then published the reports to the report server.
• Extract data from access, excel, flat file, and different data base and load in SQL data base using SSIS packages.
• Deployed SSIS packages on development, test and production servers. Involved in Change management process to deploy data objects on servers.
• Used SQL Server Reporting Services (SSRS) delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Environment: MS SQL Server, Oracle, SSIS, SSRS, T- SQL, Tableau, Power BI, Crystal Reports, Share point server, Windows Server, Team Foundation Server, XML, MS-Access, MS-Excel, Entity Framework.

Confidential - Dallas, TX

SQL Server Developer

Responsibilities:

• Configured and Implemented Active/Passive clustering and Active/Active clustering.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Creation of maintenance plans of the SQL Jobs using SQL Server Agent.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Created mappings to load data extracted from flat files, Excel files to staging area using SQL Server SSIS.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet.
• Designed, developed, and tested of ETL using Microsoft SSIS, processes to in corporate source data into the Enterprise Data Warehouse
• Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Developed stored procedures, cascading parameters and custom code for developing complex SSRS and Power BI reports.
• Developed Report Models using report builder and distributed reports in multiple formats usingSQL Server Reporting Services (SSRS) in Business intelligence development studio.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL.
• Maintained documents and implement Disaster recovery models.
• Worked in 24/7 production support with a rotation basis.

Environment: SQL Server, SQL Server Management Studio, Visual Studio, T-SQL, SQL Server, ETL, SSIS, SSRS, ERWIN, MS Office.

Confidential, Woodland Hills, CA

SQL Server Developer

Responsibilities:

• Installed, configured and deployed SQL Server 2012 in Clustered and non-clustered environment on Windows Server 2012.
• Migrated from SQL Server 2008 to SQL Server 2012.
• Created, maintained and monitored mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server 2012/2008.
• Monitored the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Loaded Warehouse databases and performing maintenance tasks on these databases.
• Generating periodic reports based on the statistical analysis of the data using SSRS.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.

Environment: MS SQL Server, SQL Server Management Studio, Visual Studio, SQL Profiler, Business Intelligence Development Studio (BIDS), ETL, SSIS, SSRS, ERWIN, MS Office.

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

• Upgraded the Server from SQL Server 2005 to SQL Server 2008.
• Migrated SQL Server 2005 DTS Packages to SQL Server 2008 SSIS packages.
• Created SSIS Packages to Extract, Transform and Load (ETL) consolidated data from different sources into Data Warehouse.
• Created Indexes to speed up the queries and Performed Database Normalization.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Created and scheduled back up using Maintenance Plan wizard.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Monitored the application and database performance using SQL Profiler and Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Performed database consistency check as regular Interval.

Environment: SQL Server, Enterprise Manage, Visual Studio, T-SQL, ETL, SSIS, DTS, Crystal Reports, SQL Profiler, SQL Performance Monitor, IIS.

Confidential

SQL Server Developer

Responsibilities:

• Responsible for the Creation, manipulation and supporting the SQL Server databases.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Used triggers, stored procedures and manipulated the data using DDL and DML functions.
• Wrote complex T-SQL statements (Queries) for retrieval of data and involved in performance tuning of T-SQL queries.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.
• Deploying SSRS Reports across multiple environments including Test, Production and supporting environments including Reporting Services Report Manager.
• Scheduled Reports based on a particular day and sent them through Email in required format (Excel, PDF, etc.)

Environment: SQL Server, SQL Server Enterprise Manage, SQL Profiler, SSRS, SSIS, MS Office.