SUMMARY:

• Over 7+ years of experience in Database Design, Analysis, Development, and Support of Microsoft SQL Server 2012/20
• Strong Transact - SQL query writing skills (DDL, DML, and DCL).
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services SSAS).
• Extensive experience in both OLTP and OLAP database designs and implementation strategies.
• Experience with high availability systems, 100+ Gigabyte databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes.
• Strong T-SQL Server 2000/ 2005/2008/2012 Developer Skills including writing Stored Procedures, User-Defined Functions, Triggers, Views and Indexes.
• Extensive experience creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors on Microsoft SQL Server 2000/ 2005/2008/2012 .
• Experience in optimizing the database by creating various Clustered, Non-clustered Indexes.
• Created different tabular reports using Power BI features and enhanced them based on user requirements.
• Efficient usage of DBCC commands to increase the performance of the query.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Services (DTS), SQL Server Integration Services (SSIS) 2005, Bulk Insert/ BCP utility.
• Experience in creating and deploying SSIS packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Good experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and Kimball/Inmon strategies. Experience with Physical & logical data modeling using All-Fusion Erwin Data Modeler.
• Proficiency in creating different types of report such as Cross-Tab, Drill-down, Tabular, Top N, Summary, Sub reports, Charts and Graphs and formatting them using SSRS 2005/2000
• Strong experience in MS SQL Server 2005/2008/2012 with Business Intelligence in SQL Server Reporting Services and SQL Server Analysis Services of 2005/2008.
• Experience in design, development, and implementation of SQL Server Analysis Services(SSAS) reports/cubes
• Experience in Trouble Shooting and Query Optimization.
• Expertise in report generation using SQL Server Reporting Services 2005 (SSRS).
• Good understanding of Normalization /De-normalization and database design methodology.
• Excellent skills in Database backup, Replication, recovery, restoration, DTS and Linked servers.
• Experience in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO, OLEDB, ODBC and SQL client.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Have strong analytical, trouble shooting and problem-solving skills dedicated to maintain the high quality standards.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000/XP, 2003/2008 Server, UNIX, LINUX

Databases: MS SQL Server: 2000/ 2005/2008/2012, Oracle 11g/10gAccess 97/2000/2003

SQL Server Tools: Management Studio(SSMS), Business Intelligence Development Studio(BIDS), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard

ETL Tools: DTS, SQL Server Integration Services (SSIS), SQL ServerAnalysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services(SSRS),MDX,.Net

Development Skills: Transact SQL(T-SQL), PL/SQL

Languages: Visual Basic(VB), HTML, C, HTML, XML,C#

Application Packages: MS Office Suite 2000/2003/2007

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server/Business Intelligence Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse Involved in installing and maintaining MS SQL Server 2008/2012.
• Experience in designing Database Models using Erwin 7.2.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Create the clustered/non-clustered indexes on tables; created views, stored procedures and triggers. Trace out for any table required any indexes and determine the type of index on it.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization.
• WorkedwithLawsonDB and oracleDB.
• Application development and support forLawsonDB.
• Extensively worked on Power BI (Power pivot, Power query, Power view, Power map) for reporting needs.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Worked extensively on SSIS Package designs for Import/Export from various Data Source Flat file, Excel, to MS SQL Server and vice versa and schedule the jobs.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Optimized indexes to improve queries and analyzed database performance with SQL Profiler.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery when ever needed.
• Created different types of reports such as Crystal Reports,Cross-Tab, Drill-down, Summary reports using SSRS 2008.

Environment: MS SQL Server 2012/2008/2005, SSIS 2012, SSRS 2012, SSAS 2008, DTS, Power BI, MDX T-SQL, OLAP Service, Visual Studio 2012, SQL Server Profiler, Erwin Data Modeller 7.2, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS).

Confidential

Sr.Business Intelligence Developer

Responsibilities:

• Gathered business requirements for creating the new mission-critical databases from business analyst, project manager, other internal employees as well as customer feedbacks.
• Migrated databases from old servers to the new server.
• Worked in an agile development method.
• Created subscriptions in Report Manager as an automated process to deliver the reports directly to the client (end user) as an email attachment.
• Worked with different report items like Tablix, Matrix, Charts etc.,
• Sub reports were created and called into Master report to show various parts of information on a single display.
• Developed performance efficient stored procedures and transact SQL queries to pull the data into reports.
• As per the client requirements, rendered the Reports in the form PDF, Excel and .CSV formats
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services.
• Responsible for posting all donations, pledges, recurring gifts and gifts in kind entered into Blackbaud Raiser's Edge Database toLawson, the financial database via journal entries.
• Created reports in SSRS & also using Power BI tools
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Migrated DTS packages to SQL Server Integration Services and modified the existing packages by using the advanced features and tools
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Extracted, cleaned and validated from XML file into database using SSIS task (XML source).
• Used Execution Plan to optimize and enhance the performance of SQL Queries.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2008R2 database
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.
• Developed and Deployed reports/report model using SQL Server Reporting Services.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), MDX, Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), POWER BI, Windows Server 2008, MS - Visio, MS- Access

Confidential, San Francisco, CA

SQL BI Developer

Responsibilities:

• T - SQL Developer skills including stored procedures, Indexes, views, User Defined Functions, Triggers and Distributed Transactions.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Implemented slowly changing dimensions in SSIS packages.
• Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform.
• Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created data sources, connection strings and defined the datasets for report generation.
• Designed and written the queries in the query builder for retrieving the data.
• Used report items like tables, sub report and charts to develop reports in SSRS.
• Worked with various delivery mechanisms of reports including Email /PDF/Schedules
• Managed and troubleshoot report server related issues.
• Created dimensions with the cube wizard and generated named calculations /queries.
• Involved in defining d relationships with measure group and fact tables.
• Defined Granularity with in a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.

Environment: SQL Server 2012, SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Business Intelligence Development Studio, T-SQL, DTS, SQL Profiler, OLAP, OLTP, MS-Excel.

Confidential

Database Developer

Responsibilities:

• Wrote Stored Procedures to meet the business requirements.
• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives
• Frequent teleconferencing and e-mail communication with business leads from across the globe to understand business rules and data structure
• Created tables, relationships, triggers and indexes for enforcing business rules
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Designed and built data load procedures, using MS SQL Server
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Configured product meta-data tables to support client data reporting needs.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Wrote SQL scripts using joins, sub queries and correlated sub queries.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.

Environment: SQL Server, T-SQL, Query Analyzer, Outlook, DTS, BCP, Enterprise Manager and Windows 2000 Server.

Confidential

Database Developer

Responsibilities:

• Created ER diagrams Logical/Physical using Erwin
• Assisted in database design, creation of ER diagrams, phasing from development to QA and to production environment
• Creation of user databases and installation of MS SQL SERVER 2000/7.0.
• Worked in Project planning, Designing & Implementation.
• Involved in creating Stored Procedures, triggers, cursors, tables, view and other SQL joins and statements for applications.
• Worked with various business groups while developing their applications.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration. Data transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Resolving various performance issues and running DBCC commands, SQL trace SQL profiler and NT monitoring tools.
• Using data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
• Installing SQL SERVER service packs based on the errors and flaws that are found in the application.
• Testing the stored procedures performance and its path of execution by using SQL profiler.
• Recovering the backups of SQL SERVER production databases in test server environment

Environment: MS SQL Server 2005/7.0, Windows 2000 Advanced Server, T- SQL, VB 6.0, XML, and Erwin 3.5