SUMMARY

• SQL Server DBA/Developer/Data Analyst/ (SQL/TSQL/SSIS/SSRS/SSAS/MySQL/AWS/Azure) with 7 Years of experience in MS SQL SERVER 2019/2017/2014/2012 , 2008R2/2008 Database Administration in Production, Test and Development environment.
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client - server, internet\intranet environments.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2019/2017/2014/2012 /2008R 2/2008/2005.
• Experience working with Bit Bucket, Git Hub, Jenkins, Docker, Kubernetes, Azure, Cognos, Tableau and Spot Fire.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience with T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and working knowledge of Analysis Services (SSAS).
• Designing applications including data mapping, data integration jobs, database design, data architecture, implementation of business rules, calculations (stored procedures)
• Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Developed ETL process using SSIS with various control flow, data flow tasks and store procedures for work order validation process.
• Expert in migrating the DTS Packages to SSIS Packages by using Package Migration Wizard.
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Worked Extensively on ETL process using SSIS packages
• Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server.
• Experience with Microsoft Azure cloud computing service for building, testing, deploying, and managing applications and services through a global network of managed data centers, Azure SQL Database Migration and migration to Azure VM.
• In-depth knowledge of fundamental and Advance concepts for Working with Amazon cloud Web Services, EC2, S3, RDS, SQS, SNS, EBS, ELB, Cloud front, AWS IAM, Amazon VPC.
• Experienced with Data Warehousing using Informatica Master Data Management, Informatica Metadata Manager, Informatica Data Quality, Power Center, Ab Initio, Data stage, Oracle, Teradata and AWS in industry verticals like Finance, Insurance and Health care.
• Experience working with all the services (SaaS), (PaaS), (IaaS), tools and frameworks, including both Microsoft-specific and familiar with VM, Azure SQL DB, Storage account and Networking.

Technical Skills

Relational Databases: SQL Server 2019/2017/2014 / 2012 / 2008 / 2008 R2 / 2005, MS-Access 2000 / 2003 / 2007 , MySQL 4/5, Oracle 9i / 10g, SQL Server/Oracle/DB2, SQL and PL/SQL

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Ad hoc, Crystal Reports.

Languages: C#, XML, SQL, T-SQL, Python, run books and ticket documentation

Operating Systems: Windows 2014, Windows 2012R2, Windows 2008, Windows 2005 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0/7.0, Apache, Tomcat, Amazon web services (AWS), Service Center, Virtual Private Cloud (VPC).

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2008/2012/2014 /2017/2019 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

AWS SQL DBA/Developer/MSBI/ETL

Responsibilities:

• Cloud/AWS: Migrated on premises databases and Legacy databases to AWS, and setup production, development and test environment on AWS.
• Migrated Data from Production SQL Server to Snowflake Datawarehouse using FIVETRAN and SSIS for Analytics.
• Managed Database Servers in Development, Test, and Production environment.
• Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014, 2017 and 2019 in Development, Test, and Production environment.
• Installed, Configure and Maintained HA/DR Solutions using Clustering, Always On, Mirroring, Replication, and Log Shipping.
• Installed, configured monitored and troubleshoots Log Shipping as Standby database from Production database for Reporting purposes.
• Database Upgraded and Migrate (Production environment Development and Testing)
• Upgraded/Migrated SQL Server 2005 to SQL Server 2012/2008 R2 & 2012 to 2014/2016.
• Migrated Oracle 10gR2/11gR2 and My SQL 5.1.23 Database to SQL Server 2008 R2/2012.
• Good understanding on data modeling projects and generated E-R Diagram.
• Data modeling tools used: Toad Data Modeler, SQL Server Data Diagram.
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues.
• Enable SSL or IPSEC for connections enable password policy checking. Implement Always Encrypt to protect confidential (PII) data
• Implement Data masking in conjunction with Transparent Data Encryption (TDE) to encrypt SQL Server Backup files, AWS SQL Database and AWS SQL Data Warehouse data files and encrypting data at rest.
• Move a TDE Protected Database to another SQL Server
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Database Monitoring/Performance Tuning/Troubleshooting, strong on database Monitoring and Performance tuning.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Monitor SQL Server Error Log, Space usage, Identifying the memory, I/O and bottlenecks, blocking and deadlocks triggered by complex queries where using SQL Server Activity monitor and profiler and implement better Query Execution plans.
• Strong on SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan.
• Database Programming T-SQL, Functions, Trigger, Partition, View, and Stored-Procedures, joins, union and writing scripts for job set-up.
• Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using BIDS, SSDT.
• Export & Import data from/to databases as My-SQL, and Access to/from SQL Server.
• Creating SSIS Packages and deployed from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports OLEDB Data sources and deployed jobs from various sources.
• Data analysis and migration by transferring and using SSIS packages.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports and drill down reports using SSRS.
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in Designing and Building dimensions and cubes using SQL Server Analysis Services
• Created report snapshots to improve the performance of SSRS.
• Improved the accuracy of the source data by implementing data validation on the source Data for reporting
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modeling using ERWIN data modeler
• Backup/Recovery: Strong working experience in Database Backup and Disaster Recovery.
• Experienced with Point-in-Time Recovery and Restoring Database from backups.

Environment: Microsoft Cloud/AWS, SQL Server 2008 R2, 2012, 2014, 2017 and 2019 IIS 7.5, 8.5, Windows Server 2008 R2, 2012 R2, ASP, ASP.net, ETL and AD (Active Directory).

Confidential , Annapolis, MD

Azure SQL DBA/Developer/DB Analyst/SSRS/SSIS

Responsibilities:

• Extensive experience in developing Integration solutions with SSIS, ADF, DTS
• Design, Development & Support of MS SQL Server 2019 and Integration of large data sources using Azure data factory (ADF).
• Experience working with the ADF components Pipelines, datasets, triggers, Linked services and other Activities.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Extensive experience in working with different RDBMS Oracle, Teradata, My SQL, SQL Server and with File base system - Flat Files & XML Files.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Informatica and Business Intelligence Development Studio (BIDS).
• Performance tuning of the ETL, SQL queries, Store Procedures, Functions and Triggers.
• Migration of large and complex data sets Azure data lake.
• Experience with Azure devOps to automate process for CI/CD pipeline and manage releases with multiple environments using Azure Pipelines.
• Automate workflows with GitHub Actions and TFS
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS. Extract Transform and Load data from Various Database Sources to Azure SQL Database using Azure Data Factory.
• Perform query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance.
• Create T-SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS using Visual Studio.
• Involved with SQL Server installation, upgrades, and administration of SQL Server security.
• Involved in designing and implementing backup and recovery procedures.
• Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Provided database support to other developers in a Data warehouse environment.
• Involved in converting data from different databases to SQL Server using DTS.
• Involved in writing SQL stored procedures to enforce business logic.
• Involved in developing many stored procedures, triggers and views using SQL Server 2012.
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database. Made dynamic SSIS packages which did data scrubbing, including data validation checks
• Created complex SSIS packages using proper control and data flow elements.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Worked on using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio

Confidential, Raritan, NJ

Azure SQL Developer/MS BI

Responsibilities:

• Creating SQL Server platform for BI and designing DW solutions for several financial clients. Created ETL framework for data marts loads. Coaching local resources.
• Experience including SSIS with MDS and DQS, SSRS, SSAS. Design, load and support SCD 2 type dimensions. Implementing Master Data Management Solution for maintenance of several Dimensions and mapping tables using MDS and Excel MDS Add-in. Inferred Dimension Members support within MDS and SSIS. Setup MDS models deployment processes. Reports design using MS Power View, Query and Pivot. SharePoint BI functionality. Microsoft Test Manager integrated with Team Foundation Server
• Migration of on-promise SQL DW to Azure by moving existent VMs to cloud (IaaS). Provisioned the Azure-SSIS Integration Runtime in Azure Data Factory. Migration of Ferry DW from on-promise to the cloud Azure SQL DB (DBaaS). Redesigned SSIS ETL solution in Azure Data Factory.
• Database analysis and support. SSRS and SSIS Ad Hoc projects development. Design and implementing new SQL DB security model. Day to day maintenance and support SQL Servers
• Data warehouse modeling and ETL SSIS development on EDW project. Integration of CRM application with insurance EDW. SSRS Reports development with SSAS and SQL DB data sources. Policy Claim and Billing Center reports development. Day-to-day solution support in Dev, QA and Production environments.
• Business analysis, design and development BI Solution using SQL Server 2012, SSAS, SSIS, SSRS,
• Master Data Services, Data Quality Services. Deployment solution into the production environment. Day-to-day support ETL jobs, OLAP and SQL DDBs.
• Designed ETL processes using SSIS 2012. Modeled DW database. Analyzed and implemented mapping business rules for loads data from very complex source files to the target fact and dimension tables.
• Implemented data cleansing rules using SQL Data Quality Services.
• Developed cubes, ETLs, reports, dashboards for D365 project using SQL 2008 R2 (SSIS, SSRS, SSAS). Designed and maintained reports deployment to production environment. Support and maintenance the solution in the production. SSIS packages and SQL DB performance turning.
• Migration from I5 system to Azure. reports changes and development. Day to day SQL server and DB applications support and maintenance. SQL DBs performance turning.
• Database solution using SQL Server 2012 (SSRS, SSIS, SSAS). Automated actuaries day-to-day work replacing Excel/MS Access manipulation with centralized database solution integrated Business cloud solution. Deployed MS Azure Platform. Migration of on-promises infrastructure to the cloud. Day-to-day SQL Servers and DBs maintenance support. Designed and implemented a disaster - recovery strategy for SQL solution with DB mirroring.

Environment: MS SQL Server 2005/2008/2012 , MSBI (SSIS, SSRS, SSAS), Power BI, MS Access, MS Excel, MS Office Access 2007, SQL Profiler.

Confidential, McLean, VA

MSSQL Developer/Data Analyst

Responsibilities:

• Experience working with Azure data lake analytics and USQL cloud execution with huge amount of data.
• Experience managing SQL Server 2017 and visual studio 2019.
• Experience working with Azure Data Bricks, Azure Data Factory (ADF) and Azure Data Lake (ADL)
• Interaction with the clients to determine the requirements.
• Experience in SQL SERVER Services (SSRS, SSIS, SSAS)
• Deployed code to support Real time Web Application Wallet Insights Dashboard with Spot Fire BI tool.
• Experience with Bit Bucket and Jenkins to fix missing Endpoint.
• Very good T-SQL Programming skills. Experience in query optimization and performance tuning.
• Experience with Loading data using complex stored procedures and ETL tools.
• Designed profile viewer dynamic dropdown selection tool with excel to create charts and graphs for data visualization.
• Working with SSAS to connect Cubes for analyzing the data from multi dimension.
• Extract data to build Reports, charts and graphs for Stake holders and Project Managers.
• Resolve errors with Dynamic SQL, C#, VBA and Power shell for Database encryption.
• Execute SQL server jobs on Management Studio to make sure that jobs are scheduled for time of execution.
• Store, retrieve, and manipulate data for analysis of system capabilities and requirements.
• Experience working with Amazon Redshift in Aws platform, a fast, fully manage data warehouse that makes it simple and cost-effective to analyze the data using standard SQL and existing Business Intelligence (BI) tools.
• Modify existing software to correct errors, allow it to adapt to new hardware, or to improve its performance.
• Perform Relational Data modeling and DDL commands to create Alter and drop existing System.
• Assist manager in making quick decisions to adopt new technologies that can help organization to improve the existing system.

Environment: Microsoft Visual Studio 2008/2012/2014 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor.

Confidential, Reston, VA

SQL Server Data Analytics

Responsibilities:

• Designed and Installed SQL Server 2012 on various platforms like SQL Server 2008 and SQL Server 2014.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server
• Involved with SQL Server installation, upgrades, and administration of SQL Server security.
• Involved in designing and implementing backup and recovery procedures.
• Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Provided database support to other developers in a Data warehouse environment.
• Was involved in converting data from different databases to SQL Server using DTS.
• Involved in writing SQL stored procedures to enforce business logic.
• Created and configured crystal reports based on custom SQL statements
• Was involved in developing many stored procedures, triggers and views using SQL Server 2012.
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database. Made dynamic SSIS packages which did data scrubbing, including data validation checks
• Created complex SSIS packages using proper control and data flow elements.
• Interaction with the clients to determine the requirements. Normalized and checked database for data entry errors.
• Logical and physical data modeling and generation of technical implementation plans.
• Worked with both functional and technical personnel to develop detailed requirements and implement those requirements into the technical architecture.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Worked on using script task, containers to logically execute the SSIS package performance and execution time.
• Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio
• Involved in designing reports using XML data string components from SQL Server 2012.
• Conducted many performance tuning and monitoring tasks for Windows NT
• Designed an Oracle database for data warehouse applications.
• Involved in Troubleshooting, Monitoring and tuning the MS SQL Server 2012 for optimum performance.

Environment: MS SQL Server 2005/2008/21012 , MSBI (SSIS, SSRS, SSAS), Power BI, MS Access, MS Excel, MS Office Access 2007, SQL Profiler.

Confidential , Baltimore, MD

MSBI SSIS/SSRS Developer

Responsibilities:

• Maintained SQL Server 2005/2008R2 and 2012 versions.
• Excellent experience with SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts and Power BI.
• Involved in End to End migration of 15 SQL Server 2005 instances to SQL Server 2012.
• Configured always on 4 nodes in SQL Server 2012.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Experience using Red gate SQL Server backups and restores.
• Created SSIS process design architecting the flow of data from various sources to target.
• Involved in security plan meetings filtering the obsolete logins and users.
• Created linked servers between two SQL Server 2012 servers.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Monitoring and troubleshooting various servers and issues respectively.
• Analyzing long running queries and tuned the same to optimize application performance.
• Contribute the ongoing development of technology and production Processes Company wide.
• Keep abreast of new design tools hardware software & technology and make recommendations for future deployments.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Created and configured crystal reports based on custom SQL statements.
• In depth query performance tuning - detailed understanding of the query optimizer, execution plans, plan cache, Contest Imation, indexes and statistics. Good experience with SQL Profiler, index tuning wizard and performance.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Used Bulk insert, BCP and database consistency checks using DBCC command.

Environment: SQL Server 2008/2012, Integration Services (SSIS), Reporting Services (SSRS), MS Excel, MS Access, MS visual Studio, Power BI.

Confidential

SQL Server Developer

Responsibilities:

• Created various datasets for the reports based on required parameters and columns in the report.
• Developed & executed several complex T-SQL procedures for creating datasets for the reports.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Validations and scripting in VB Script, JavaScript. Migration of DTS packages to SSIS packages
• Worked to create Software Requirement Specification (SRS) document.
• Defined data sources for the reports to pull the data from server and database in the background.
• Identified the necessary steps to enhance user response time by checking fragmentation and re-indexed tables for efficient application access methods.
• Created views for easier implementation on web pages and wrote triggers on those views to provide efficient data manipulation.
• Communicating with Developers, QA Engineers and other Database Administrators to ensure smooth operational flow and problem resolution.
• Created packages using DTS for moving data from MS Access to SQL Server and vice versa.
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Implementing indexed views, and tuning stored procedures to help increase database performance.
• Monitoring and tuning server configuration to ensure maximum capacity and output.

Environment: Windows NT 4.0/2008, MS SQL Server 2008, VB, T-SQL, SQL Server Enterprise Manager.