SUMMARY:

• 8+ years of experience in project design, analysis, administration, development, and management using Microsoft SQL Server (2005/2008/R 2/2012/2014/2016 ), AWS and SQL Azure.
• Excellent Knowledge in Microsoft Business Intelligence Technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and SSAS of MS SQL server 2005/2008/2008 R2/2012 and MS SQL DBA.
• Knowledgeable in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Skilled with Database Backup, Recovery and Disaster recovery procedures.
• Experienced in implementing SQL server high availability tools like Log shipping and database mirroring.
• Experienced in implementing different types of Replication Models like Snapshot, Merge and Transactional replication, Always on, WFC setup.
• Experienced working on Data Extraction/Transformation using ETL, DTS/SQL Server Integration Services (SSIS).
• Experienced in T - SQL Programming in writing Stored Procedures, Functions and Triggers.
• Experienced in Data Migration between SQL Server 2005 and 2008R2.
• Practiced in Creating Packages, Jobs and Sending Alerts using Database Mail.
• Highly Experienced with SQL-Server Management Studio, SQL profiler, Query Analyzer.
• Experience in MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity and running Database Consistency checks Using DBCC.
• Excellent Knowledge in Data Warehouse Concepts like OLAP and OLTP.
• Designed, developed, and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
• Experience in writing SQL Queries for pulling large volume of records from Facts and claims database using stored procedures, and Extraction, Transformation, and Loading (ETL) process using SSIS.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server.
• Experience as AWS Solutions Architect.
• Experience in AWS Redshift.

TECHNICAL SKILLS:

Database Tools: SQL Server Management Studio (SSMS), SQL Server BIDevelopment Studio (BIDS) Languages: T-SQL, PL/SQL, XML, Java, VB.Net, VBA, C#, .NET, ASP.NET, HTML, VB6

Databases: MS-SQL Server / 2008 R2 / 2012,SQL Azure, MS Access, MySQL, DB2, Oracle,Azure, Sybase, Teradata, RDS, Redshift, DynamoDb

Reporting Tools: Microsoft Excel, SSRS, SSAS, Informatica, Tableau, Microstrategy, SharePoint

ETL Tools: DTS, SSIS, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Crystal Reports, Toad

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

SQL DBA/Developer

• Experience in SQL Server Installation, Configuration, Upgrading, troubleshooting skills and Patching of Server
• Experience in SQL Server Performance Tuning, Query Optimization, blocking and deadlocking issues, Server Connectivity and running Database Consistency checks Using DBCC.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution plans, Trace, Statistics and index tuning wizard.
• Experience in administration, implementation, monitoring, operations and maintenance of SQL database on VMware servers and non-virtualized servers.
• Experience in creating jobs to automate repetitive tasks using SQL agent jobs and SSIS packages
• Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints
• Designed Data Warehouse and analyzed various approaches for maintaining different dimensions and facts
• Designed ETL packages with different data sources SQL Server, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS
• Backed-up enterprise databases to Azure storage in block BLOBs and back up files in Azure environment
• Retrofitting complex data to load different kinds of data from different sources including staging phase
• Created and modified stored-procedures, triggers, cursors, and user defined scalar valued and table valued functions, and views
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models
• Responsible for building reports in Power BI from scratch
• Used T-SQL to create tables, views, user-defined functions, CTEs, Index for implementing application functionality at the database side for performance improvement
• Created new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server
• Experience in Microsoft Visual C# in script task and script component of SSIS
• Schedule and maintain SSIS packages daily, weekly, and monthly using Task Scheduler
• Created Source Target mappings for migrating on-Premise Data Mart to SQL Azure
• Created VB.Net Script for Data Flow and Error Handling using Script component in MSBI (SSIS)
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS
• Generated weekly and monthly reports for the financial advisors in wealth management team
• Worked on RDS on SQL Instance on AWS platform to implement high available and fault tolerant solutions
• Implemented a data ware housing solutions on Amazon Redshift

Confidential, Arlington, VA

SQL DBA/Developer

• Installation of SQL servers 2014/16 on production, test and development environments.
• Experience in Database Migration and upgrade between SQL Server 2012 and 2014.
• Rebuilding and reorganizing index on the Production Server.
• Configured and maintained transactional and merge replication
• Database backup and disaster recovery procedures.
• Ability to design processes and techniques that enhance end-user efficiency
• Used DBCC regularly to check Database consistency and Maintain data integrity and security.
• Creating and modifying tables, Indexes, Constraints, Views, Stored Procedures and Triggers
• Identified various source systems for data feeds
• Involved in understanding Business requirement document and developing Technical Design specification documents for multiple interfaces
• Experience in query optimization & performance tuning using SQL Profiler, Execution
• Used SSIS to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse
• Designed and developed jobs for loading data to star schema
• Extracted Data using SSIS from DB2, and flat files, Excel transformations
• Populate the data warehouse
• Worked on SSIS to remove duplicate records with data standardization
• Responsible for data integrity between Staging vs. Global Data Repository, and GDR vs. MicroStrategy Metadata
• Created SSIS Package to transfer data from various locations using the FTP task, then loaded the flat file data into the database
• Executed reports using Microstrategy Integrity Manager to compare the results between different versions and between before and after change
• Work with Project Managers, Development Managers, and other Business Intelligence Analysts to develop and implement Data Mart solutions for the Enterprise using Micro strategy tool
• Created various Jobs, Alerts and Events, Created Backups for databases and automated the process
• Assisted in building dimensional cubes with SQL Server Analysis Services (SSAS) and building multiple calculated members, KPI's for user perspectives
• Worked as a developer in creating complex Stored Procedures, tables, and views and other SQL joins and statements using T-SQL for different applications
• Managed index and optimized queries using execution plan
• Created and integrated user defined functions and stored procedures for reporting purposes
• Involved in the Analysis of the Report Data, Developed and Deployed Reports on to the Reporting Server
• Wrote and integrated stored procedures to generate the reports
• Involved in developing highly available and fault tolerant application on Amazon Cloud platform
• Created Cross-Tab, Drill-down and Sub-Reports using RDL and promoting RDLs to Reporting Services Server
• Generated weekly and monthly reports for the financial advisors in wealth management team
• Migrated on prem solutions in to Amazon Web Services

Confidential, Virginia Beach, VA

SQL DBA/Developer

• Experience in Full Software Development Life Cycle (SDLC) including Analysis, Design and Review of Business and Software Requirement Specifications; Development, Testing as per agile software development methodology
• Designing various types of complex reports like tabular, Cross tab reports, bar graphs and pie charts based on the client requirement document
• Worked with the application developers and provide necessary SQL Scripts using T-SQL
• Troubleshooting the issues in the reports as well as in T-SQL queries in the production server
• Involved in SSAS Cubes design by creating measure groups, facts, dimensions, aggregations from huge dataset using SQL Server Analysis Services (SSAS)
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS)
• Expert level skills in Objects creation such as Table, Indexes, Stored Procedures and other SQL joins and query writing
• Expert in creating various kinds of reports and using report builder when required
• Worked with both live and import data in to Power BI for creating reports
• Configuring and managed data source views, cubes, dimensions, roles, and hierarchies in SSAS
• Extracting Data from various sources like SQL Server and Flat files and loading into CRM Database
• Involved in troubleshooting of T-SQL queries, SSRS reports and SSAS Cubes
• Created Multiple SSRS Reports and deployed them to the CRM Application
• Involved in making technical design documents and giving presentations to the team.

Confidential, Detroit, MI

SQL Developer/BI Developer

• Installation of SQL Server 2014 enterprise edition and enabling SSIS/SSRS/SSAS on Client machines, Development, Production Servers
• Developing SSIS Packages to extract data from various data sources such as MS Access, Excel and flat files into SQL server using different transformations, Derived column, Sort, Row count, Fuzzy look up, Multi cast and Merge Join
• Implemented custom logic in SSIS packages script task and script component using C#
• Developed Business Requirement Document (BRD) and keep track of changes in BRD
• Generated reports using SQL Server Reporting Services from OLTP and OLAP data sources
• Deploying and scheduling Reports using crystal reports to generate all daily, weekly, monthly, and quarterly Reports including current status
• Identified high risk, low risk and Moderate Risk members using SSRS dashboards
• Migration of Production databases empty schema to development server as part of set up Development, Testing Environment
• Wrote the test cases for data quality check on development results data based on data analysis (qualitative, quantitative), Performance, to meet client requirement
• Wrote stored procedures and scripts to move content for staging database to operational data store and data warehouse in all environments
• Participated in the entire life cycle including database design, Development, Testing, Optimizing, deploying onto Test, UAT and production servers
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Responsible for creating and maintaining the documentation for implementation and for future changes
• Applied conditional formatting in SSRS to highlight key areas in the report data