SUMMARY

• Having 10+ Years of Development and Database Administration experience on MS SQL SERVER 2016/2014/2012/2008 R 2/2008/2005/2000.
• Experience in creating reports in SSRS and extracting the data from Integration services.
• Experience in installing MS SQL SERVER 2016,2014, 2012, 2008 R2, 2008, 2005 and updating with hot fix and service packs and also AWS, Azure environments.
• Expertise in creating MDX queries. Worked as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts and other RDBMS (Oracle 10g, 11g and 12c)
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Extensive experience in implementing HADR solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines
• Implemented In - place and Side by Side Migration of MS SQL SERVER2005 to 2008 R2 and 2008R2 to 2012
• Experience in writing T-SQL (DDL, DML, and DCL) statements
• Worked as a developer to create new stored procedures, developed reports etc.
• Migrated DTS 2000 packages to SSIS packages in 2005 using MigrationWizard
• Experience using SQL SERVER 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel
• Implemented and deployed Azure offerings including both the IaaS and PaaS offering.
• Worked on Data Integrity, Performance Tuning, Query Optimization
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally. Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Hands on implementation experience with a strong background in Azure Platform Confidential SharePoint and Confidential Dynamics development, infrastructure, governance and content management
• Experience in writing queries, T-sql.
• Experience in analyzing the multi dimensional queries.
• Implementing CR (Change Request) and CA (Change Amendments) requested by users
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources
• Performed SQL Upgrades. SQL 2000 to 2005 and building SQL Clustering
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects
• Extensively used native tools like index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis
• Experience in Client/Server Connectivity, Database health Check, Indexing and Updating Statistics
• Knowledge in Data Modelling/Data warehousing concepts.
• Worked in Azure, cloud technologies.
• Configured SMTP SERVER for Database Mail setup and received Alerts for the Threshold values
• Worked on third party tools like BCP Remedy Tool, Lite Speed, Fog light and Red gate
• Experience in creating SQL SERVER Reports using SSRS and worked on Hyper-V and VMware environments
• Implemented change management
• Performing Root Causal Analysis(RCA) of incidents and adhering to SLA standards

TECHNICAL SKILLS

Operating System: Windows 7/Vista/XP/2000/NT, Server 2016/2012/2008 R2/2003, Exchange 2003, Linux, UNIX

RDBMS: MS SQL SERVER 2005/2008/2008 R 2/2012/2014/2016/2017 , MS Access

Languages/Scripting: C,T-SQL, Visual Basic, PowerShell

Database Tools: Enterprise Manager, SQL Profiler-SQL, PL/SQL, SSIS, SSRS, SSAS, ODBC, OLTP, SQL OLEDB, ERWIN, PSSDIAG, VISIO, IIS, LITE SPEED, RED GATE, VSS, TFS, SQLMON, Quest Lite speed, Red gate, Snap Manager, Snap Drive

ETL Tools: SSIS 2005/2008/2008 R2/2012, DTS

OLAP Tools: SSAS 2005/2008/2008 R2/2012

Reporting Tools: SSRS 2005/2008/2012 , Crystal Reports

Monitoring tools: SCOM, Site Scope, ICM, ITSM, Xpert, SNOW, Foglight

Cloud Technologies: Windows Azure, Azure Cosmos, SQL Azure, AWS, Mongo DB

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Sr. SQL Developer

Responsibilities:

• Requirement analysis.
• Identified Dimensions and Facts to build the cube.
• Created Power BI dashboards and reports and User portal design.
• Demos and status calls with client .
• Created various database objects such as tables, indexes and views based on the requirement.
• Created reports such as Parameterized, Cascading, and Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs using SSRS.
• Created Company level inventory, sales, budget reports from OLAP Cubes using MDX Script.
• Created many SSRS reports with lots of metrics on it using row grouping and column grouping.
• Involved in Performance Improvement of thus created reports and deployed reports onto Report Server and Report Manager and to SharePoint Server making those reports available for the end users.
• Created table valued functions and used in the report stored procedures on the fly.
• Worked on the performance of reports, created appropriate indexes on tables and modified the code in existing stored procedures for the best fly-on performance.
• Confidential ended functional testing meetings, user acceptance sessions and worked on the feedbacks.
• Created deployment documents for the reports and worked with database administrator in the deployment of the report objects to the production server.
• Created SSIS packages to get the data from different sources to BI environment using different transformations on hourly basis, daily basis and monthly basis.
• Involved with ETL team and created packages using SQL Server Integration Services (SSIS) to extract data from various feeder systems, apply required transformation and finally load the data to the destination data warehouse.
• Worked on Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Detected by troubleshooting SQL Server related CPU, Memory, I/O, disk space and other resource contention.
• Involved with other teams in Migrating the SQL server 2012/14 to 2016/17.
• Scheduled lot of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
• Deploying the web services with the help of powershell scripts in both production and staging environments.
• Creating Articles for further use in resolving recurring issues.
• Presenting monthly reviews and status of applications to client.

Environment: SQL Server 2016, SQL Server 2014, SQL Server 2012, Enterprise Edition, Management Studio, Windows 2008/2012 Server, Visual Studio Interface, Confidential Power BI, Cosmos Scope Scripts.

Confidential, Irving, Texas

Sr. SQL Developer

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS in Business Intelligence Development Studio (BIDS).
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS. Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes. Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Throughout the day, periodically monitored performance using System Monitor and DMV.
• Checked the fragmentation and rebuild/ reorganize the indexes.
• Involved in the Migration of Databases from SQL Server 2008 to SQL Server 2012/14.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Deploying and migrating to new versions of UAT and production servers.
• Research- Trying to best practice of the implementation and looking for all the possibility of moving SQL Servers into Azure cloud.
• Create Azure subscriptions, storage accounts in the accounts as and when required for the team.
• Creating & Uploading Instance file as per customer based checklist in Windows Azure deployment dashboard portal.
• Worked on Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Detected by troubleshooting SQL Server related CPU, Memory, I/O, disk space and other resource contention.
• Involved with other teams in Migrating the SQL server 2012 to 2014.
• Scheduled lot of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
• Deploying the web services with the help of powershell scripts in both production and staging environments.
• Creating Articles for further use in resolving recurring issues.
• Presenting monthly reviews and status of applications to client.

Environment: SQL server 2016/2014, DTS, SSIS, SSRS, T-SQL, Windows Azure, Windows Server 2016/2012R2, Visual Studio, PowerShell, BMC, Snap Drive, Snap Manager, Fog light

Confidential

SQL Server Developer

Responsibilities:

• Actively involved in all the phases of Software Development Life Cycle (SDLC).
• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into enterprise data warehouse (EDW).
• Dealt with a variety of data sources including OLEDB Oracle Source, XML sources and Flat File Sources.
• Implemented incremental loading into the destination.
• Created alerts for both success and failure of jobs.
• Designed ETL for implementing Slowly Changing Dimensions in order to maintain historical data.
• Created configuration files to deploy SSIS packages across all environments.
• Used SSIS Script Task to write C# Code Snippets to generate error reports to be sent out.
• Coded in C#.Net for Assigning Values to objects dynamically and checking for conditions.
• Created the complex stored procedures, user defined functions to encapsulate the business logic.
• Createdviews, indexes, and user defined data types and implemented the cursors, triggers as needed.
• Followed best practices in writing T-SQL queries as a regular daily routine.
• Involved in the de-normalization of tables in order to make query retrieval faster.
• Involved in performance tuning of queries using query execution plans, SQL Profiler and also DMVs.
• Responsible for creating the reports using the SQL server reporting services.
• Created various types of reports including drill-down, drill-through, cascaded parameterized reports and sub-reports.
• Deployed the reports to the report server.
• Designed and implemented the database replication for reporting database.
• Knowledge Transferred to co-workers &prepared Technical Documentation.
• Used Visual Source Safe for version control.
• Worked extensively on the data changes as per the user specified improvements on each release of the application build.
• Created numerous test cases for testing the application.
• IntegratedSQL Server 2005 reporting services with Confidential Share point Portal Server to deliver automatically generated reports to the Share Point Site.
• Presenting monthly reviews and status of applications to client.

Environment: SQL server 2012/2014, DTS, SSIS, SSAS, SSRS, T-SQL, Windows Azure, IIS 7/7.5/8, Windows Server 2012/2012R2, Visual Studio, PowerShell, ICM, ITSM, Xpert.

Confidential

Database Administrator

Responsibilities:

• Installing, configuring Confidential SQL Server software in developer/ test/ production boxes.
• Implementing and maintaining database security (create and maintain users and roles, assign privileges).
• File and File group management for larger size databases.
• Planning and implementing backup strategies for full, differential and transaction log backups for providing to-the-point-of-failure disaster recovery.
• Restore backups to a test server to verify that we can restore them.
• Designing and configuring high availability methods like DB Mirroring, Log Shipping, Replication and Clustering.
• Developed complex T-SQL code for data retrieval.
• Responsible for data retrieval by extensive use of joins normalization and views.
• Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Effectively use Profiler to find performance issues and deadlocks. I am familiar and comfortable with perfmon. Have resolved blocking and long running queries through Activity Monitor and Profiler
• Catching and Reporting errors using exception handling.
• Involved in Developing OLAP models like facts, measures and dimensions.
• Created SSIS packages from scratch to transfer data from source to destination using all required transformations applied.
• Managed Oracle Databases on Windows and Linux platforms.
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Experienced with optimizing and performance tuning the queries for a large SQL Cube and ETL
• Exposure to supporting ETL based applications
• Upgrading SQL Server 2005 to 2008 and 2008R2 instances.
• Involved in Performance tuning, query-inventory, analysis and optimization.
• Used SQL Profiler - diagnosed the problem related to Transact SQL Statements.
• Monitored, scheduled SSIS and changed SSIS Workflows & Configurations
• Deployment of SSIS packages on Production server after QA.
• Prepare RCA (Root Cause Analysis) using Profiler Trace, Performance counters with System Monitor
• Implemented Disaster Recovery Planning (Using Asynchronous (High-Performance) mirroring with manual failover), Testing and analyzing continuous update of documentation
• Coordinator for onsite & offshore team.

Environment: SQL server 2005/2008 R2, SSIS, SSRS, Windows Server 2008/2008R2, Lite Speed, VMware