SUMMARY

• Over 8 years of professional experience in SQL Server database development, extensively worked in Production, Test, Development and Replication & Cluster Server Environments & development databases as a Developer.
• Well versed in Normalization/De - normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• T-SQL Programming using DDL, DML commands for various business applications.
• Hands on experience in creating indexed Views, Complex Stored Procedures, TEMPEffective Functions, Appropriate Triggers, Complex CTE's, Sub Queries, Joins to assist efficient data manipulation and data consistency.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Experience in query optimization & performance tuning, used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler
• Experience in creating Extended Stored Procedures, and Jobs, sending alerts using SQL Mail.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server's and other heterogeneous relational database such as Oracle and DB2.
• Experience in Microsoft cosmos tool.
• Experience withCOSMOS(understanding COSMOS logs and views, SCOPE scripts)
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscommentin various queries and using Database Console Commands (DBCC).
• Worked with improving the performance on SQL, TSQL, and Stored Procedures and provided the recommendation on server related tuning issues.
• Efficient in upgrades and migration from MS SQL Server 2000/2005 to MS SQL Server 2012/2008.
• Hands on experience working with SSIS, for ETL Process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created many complexSSISpackages with complicated transformationslikeLookup, Derived Column, ConditionSplit, Multicast, Sort, Union All, Cache Transform, and ConditionalSplitetc
• Great Expertise in Creating and managing event handlers, Package Configurations, Logging, Check points, Package Securities and User Defined Variables for SSIS Packages.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in creating SSIS packages with Error Handling.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in Reporting Services, Crystal Reports, Tableau, Power BI from MS SQL Server and in supporting services MDX technology of the analysis services.
• Experience in Developing SSRS Reports, Power BI (Dash Board Reports), Tableau Reports, Creating Crystal Reports.
• Development of OLAP in Reporting Service Reports and Custom Development Performed.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports using SQL Server Reporting Services (SSRS) based on-client requirement.
• Supported team in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Sub-Reports, Drill-down, Drill-Through, Matrix, Parameterized Reports and formatting them.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Developing reports on SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service.
• Experienced in deploying created reports in various sources like Web browser, XML and PDF.
• Created score cards with advanced set of dashboards using Performance Point, Power View that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a fictitious construction company extracting data from a SQL Server 2005/2008/2012 OLAP data source and deployed them to SharePoint sites.The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.
• Good knowledge on creating the MDX cubes and dimensions (SSAS).
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005/2008/2008 R2.
• Good knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Good knowledge in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Having good experienced on BI Share Point like SharePoint 2013, SharePoint 2010 and Office tools like Office 365.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTPand dimension modeling forOLAP.
• Excellent experience in designing and developing Reporting System using Business Objects. Experience with Health Care Doman like Insurance, Claims, Enrollment etc and Credit Card tracker information.
• Good Exposure with Microsoft Office System - MS Word, MS EXCEL, MS PowerPoint, MS Access, MS office Tools.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.
• Quick learner and proactive team member with good Communication skills and Leadership capabilities.

TECHNICAL SKILLS

Programming Languages: T-SQL, VB scripts, C,C++, Java, .Net, Oracle, UNIX Shell Script, PHP

RDBMS: MS SQL Server 2000/2005/2008 , MS Access, Oracle 9i/10g.

Tools: & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), DTS, SQL Server Analysis Services (SSAS), MS Visio, Erwin, Crystal Reports 9.0/XI, ProClarity, Performance Point Server, Cosmos.

Web Technologies: XML, HTML, XSL, JavaScript, IIS.

Operating Systems: Windows Vista/XP/ 2003/2000/7/8/10 , Windows Server 2000/2003/2008.

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS).

PROFESSIONAL EXPERIENCE

Confidential, Glen Mills, PA

BI Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2000/20 .
• Extensively worked on stored procedures, triggers, Views, cursors, CTE’s, T-SQL scripts, schemas, permissions and performance issues with client/server database design.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed dashboards using Excel Power Pivot.
• Tuned and optimized SQL statements for the Oracle environment, and assisted in overall tuning of the COSMOS database.
• Create ETL packages (SSIS packages) using Microsoft Visual Studio 2008 and Microsoft SQL Server Management Studio 2008. The ETL packages are referred to as pre-processors that process the input data to a financial services based software application.
• Deploy the packages to extract data from flat files (.txt files) and load the data into the destination table in the production environment. The table serves as a primary input to the financial services based software application used for generating financial reports.
• Implement business logic using the ETL packages, to perform necessary transformations on the data before it is loaded into its final destination table.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005/2008/2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Has good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared for an update.
• Developed Query for generating drill down and drill through reports in SSRS 05/08.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS
• Used Excel Power Pivot and Power view to build Scorecards and Dashboards.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created various Dash Boards using Performance Point Server
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Created Linked Servers to connect OLE DB data sources and providers.
• Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, ROLAP), dimensional modeling, star schema and snowflake schema.
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Configured MERGE Replication using Snapshot agent and MergeAgent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
• Managed the migration of SQL Server 2000 databases to SQL Server 2008.
• Provided day-to-day administration tasks like space and log management.
• All of my applications were data driven. 30% of all SQL code for my ASP.NET applications
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan
• Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.

Environment: MS SQL Server 2012/2008/2005/2000/7.0 , DTS, Windows Server 2008, SSMS, BIDS,SSRS, SSIS, SSAS, Report Builder 3.0,Report Model, Erwin, Team Foundation Server, Performance Point Server, ProClarity, SharePoint (MOSS), FTP, MS-Visual Studio, UNIX, XML,XSLT, ADO.Net.

Confidential, Cumberland

SQL Developer

Responsibilities:

• Create User Defined Functions, Stored Procedures, and Triggers.
• Performed data conversions from Flat files into a normalized database structure.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Responsible for creating constraints, Indexes, and Views.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Researched, planned, and steered deployment of COSMOS on the Citrix platform. This involved the analysis of needs and requirements, requisition of appropriate server hardware, installation and modification of settings for both Windows 2000 Server and Citrix Metaframe software, physical relocation of server hardware to a remote location, troubleshooting of connectivity and user issues, and implementation of the Citrix NFuse web portal to allow user access via the GE intranet.
• Boosted performance of several key COSMOS functionalities over 5000% by porting VB code into PL/SQL packages. Constructed various other PL/SQL stored procedures, and functions to improve overall functionality and remove costly data access logic from the main body of code.
• Created triggers, views, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS TEMPeffective.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Managed up gradation of DTS packages to SSIS packages.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.
• Configured Server for sending automatic mails to when a DTS process fails or succeeds.
• Transformed data from various data sources using DTS packages.
• Created Crystal Reports on daily, weekly and monthly basis for manager’s review.
• Responsible for MS SQL Server 2000 in Production, Test, Development and Replication in Cluster Server Environments

Environment: SQL Server 2000, Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS Excel, MS Access,VB.NET 3.0 and DTS.

Confidential

Jr. BI/SQL Developer

Responsibilities:

• Performance tuning, and optimization of procedures and queries.
• Created complex Stored Procedures, triggers, cursors, tables and views also other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Maintain disaster recovery strategies for the database and failover methods.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in creating complex SSIS packages using proper control and data flow elements.
• Has deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2005 in Test environment with latest service packs and migrated few databases.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS).
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Written DDL / DML Triggers as per company policy.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes has completed successfully.
• Rebuilding indexes on various tables.
• Developed database monitoring and tuning strategies.

Environment: Microsoft Windows 2005 Advanced Server, Microsoft SQL Server 2005 Enterprise Edition, Microsoft Visual Basic 6.0.

Confidential

MS Sql Server Developer

Responsibilities:

• Data transfers between various servers using BCP and DTS.
• Actively involved in different stages of Project Life Cycle.
• Installation of MS SQL server on multiple environments and Creating tables and databases, defining entity, attributes relationships using constraints.
• Followed and maintained standards and best practices in database development.
• Involved in tuning of database by creating efficient stored procedures and T-SQL statements.
• Involved in database programming in writing stored procedures, triggers.
• Created Clustered and Non-Clustered Indexes for improved performance.
• Created Tables, Views and Indexes on the Database, Roles and maintained Database Users.
• Documented the data flow and the relationships between various entities.
• Actively participated in gathering of User Requirement and System Specification.
• Created new Database logical and Physical Design to fit the new business requirement and implemented the same using SQL Server.
• Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Developed new Stored Procedures, Functions, and Triggers.
• Implemented Backup and Recovery of the databases.
• Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: MS SQL 2000, Windows 2000/XP, SQL Query Analyzer and Enterprise Manager. MS Access 2000 & Windows NT platform.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Efficiently took part in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Creation, manipulation and supporting the SQL Server databases.
• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Wrote User Defined Functions and Stored Procedures to implement business rules.
• Created Triggers to enforce data and referential integrity.
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Developed Master/Detail Reports and Tabular reports using Crystal Reports

Environment: SQL Server 2000, Windows NT 4.0, Crystal Reports 9.0.