SUMMARY:

• 6+ years of strong Microsoft Certified Business Intelligence Developer and SQL Database Administrator work experience of developing Business Intelligence solutions in an agile environment.
• Strong hands on experience in using the Microsoft BI Stack (SSIS, SSRS, SSAS and SQL). Worked with SQL server 2008/12/14/17.
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration from various type of sources (Excel, flat file, csv, XML, OLTP DB etc.), Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.
• Hands on experience in designing and developing considerable number of reports in SSRS using the data from ETL Loads, Proficient in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS).
• Experience in Dimensional Data Modeling & Cube development in SQL Server Analysis Services.
• Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modelling, Snow flake modeling for fact and Dimension tables.
• Strong troubleshooting and problem - solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Expertise in SQL server security management, SQL Server performance tuning, troubleshooting, Migration/Upgrading, Disaster Recovery and High availability Solutions.

TECHNICAL SKILLS:

Platforms: Windows (2000, XP, Vista,7,8), MS SQL Server 2017/2016/ 2014/2012/2008 R2/2008, MS Access

Languages: T-SQL, XML, Visual Basic

Applications / BI/DBA Tools: Microsoft Data Transformation Services (DTS), SQL Server Integration (SSIS), SQL Server Reporting (SSRS), SQL Server Analysis (SSAS), SQL Server Business Intelligence Development Studio (BIDS), MS Access, SQL SERVER, MS Visio, SQL Profiler, Query Optimizer, Extended Event, Querystore, AlwaysOn, Replication, Log shipping, Mirroring, HA/DR Solutions, RAID.

Work Flow Tools: MS Visio

Miscellaneous: Visible Analysis and Troubleshooting, operational automation.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

SQL Server Business Intelligence (BI) Developer & Database Administrator (DBA)

Responsibilities:

• Experienced in Business Analyst activities: I have been involved in the requirements gathering planning and implementation process of small to medium projects, I participated in the creation and review of the Business Requirements Document.
• Have developed and maintained a Database Schema, Entity relationship diagrams, Data modeling. I developed tables, constraints, schemas, indexes, views, creating complex stored procedures, triggers, functions.
• Have developed, tuned and maintained complex SQL queries using joins, sub-queries and correlated sub queries. Developed complex store procedure and user-defined functions.
• Troubleshooted slow performing queries by using SQL Profiler/Extended Event/Querystore. Data base engine tuning advisor for Performance tuning on stored procedures.
• Installed, upgraded configured and administered SQL server 2008/12/ & migrated data from SQL server 20 and 2016.
• Created packages using Integration Services (SSIS) for extracting data from Flat Files, XML files, CSV files, Access, Excel files, OLE DB to SQL Server, and load data to the Data Warehouse.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup transformations, merge joins, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.
• Experience in creating time dimensions within SSAS and within SSMS
• Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, Sub-reports.
• Created complex stored procedures/functions and used them in SSRS to generate ad-hoc reports.
• Render reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions.
• Deployed the solutions on web server, involved in creating user security and roles in reporting services at both parent level and report level.
• Applied service packs, hotfixes and cumulative updates
• Upgraded SQL Server 22008 and 2008 R2 Database into SQL Server 2012 and 2014/16
• Created and maintained logins, Users, Roles and managed security of the database.
• Implemented Disaster recovery plan by performing routine backups and restore
• Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
• Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail.
• Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures

Confidential (Washington, DC)

SQL Server Business Intelligence (BI) Developer

Responsibilities:

• Designed and created an ETL solution to consolidate data of Federally Granted loans & loan applications received from various sources.
• Worked on all activities related to the development, implementation, administration and support of ETL processes.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Installed, upgraded configured and administered SQL server 2008/12/14/16 , & migrated data from SQL server 20 .
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance. Performance tuning on existing ETL packages.
• Designed, Created and developed various SSRS reports such as Sub-Reports, Drill down reports, Drill through reports and Parameterized reports, Matrix reports using SSRS.
• Created Dashboards, Tabular, Matrix reports, Charts, graphs and Gauges reports as per customer requirements Using SSRS.
• Created and maintained various logins, assigned appropriate database roles and privileges to users based on the required access.
• Developed and performed SQL server post installation maintenance plans: Database backup, integrity check, update database statistics, and index maintenance using GUI and T-SQL.
• Hands-on experience on indexes creation:-clustered and non-clustered, managing index fragmentation; troubleshooting and performance tuning.