SUMMARY

• A Microsoft certified professional, MSBI developer and result oriented with background of IT solutions with about 4 plus years of experience.
• Experience in BI suite using integration services (SSIS) for ETL (Extraction, Transformation & Loading), Reporting Services (SSRS).
• ETL data from sources to destination using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Strong ability in generating drill down, drill through, parameterized and matrix reports and creating interactive report layouts in SSRS.
• Experience in developing and designing SSIS package to Extract, Transform and load (ETL) data into data warehouse from data source such as Flat files, XML file, OLE DB Source, ADO NET Source, Raw File, ODBC, Excel files in SSDT.
• Experience in developing Parametrized, Clickthrough and Drill through sub reports.
• Hands on experience in performance tuning / analysis, troubleshooting and query optimization using native tools like MSSQL server profiler, activity monitor, performance monitor, event viewer, index tuning advisor, database tuning advisor (DTA), Dynamic Management views (DMV), query execution plan.
• Perform database maintenance on a weekly or monthly basis including Index rebuild, reorganized, update statistics and DB backups.
• Proficient in understanding requirement and designing of Data Marts, Data warehouse, Data Modeling like Dimensional Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, OLTP Relational Schema and OLAP Dimensional Modeling.
• Conversant with all phases of Software Development Life Cycle (SDLC), change control rules, source controls, problem solving skills and escalation procedures and documentation.
• Hands on configuring breakpoint, check point and Error handling to troubleshoot SSIS packages at different stage of execution.
• Experience in developing error handling & logging, auditing, data quality, performance tuning, etc.
• Experience in ETL/SSIS deployment configurations, maintenance and documenting
• Experience in analyzing and optimizing resource contention and troubleshooting database bottlenecks like timeouts, deadlocks, to maintain overall system health.
• Hands on experience on POC AWS Database Migration Services DMS, EC2, S3.
• Familiarity with Azure.
• Ability to adapt changes and new technologies and excellent communication skills.

TECHNICAL SKILLS

Relational DBMS: Microsoft SQL Server 2008/2008R2/2012/2014, Sybase, Microsoft Access, SSMS, Visual Studio

Database Programming: T - SQL, PL/SQL, PowerShell

Database modeling: VISIO 2003/2010, Toad Data modeler, ERWIN.

ETL tools: MS SQL Server integration services SSIS/, DTS.

Reporting: SQL Reporting Service /SSRS/, Power BI.

Third party tools: Red-Gate, Idera-Diagnostic Manager, Ola Hallengren

Networking: SAN, NAS, LAN, WAN, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

MSBI Developer

Responsibilities:

• Configured and maintained of SQL Server 2014/2012.
• Experience in installation, configuration and migration of SQL Server 2016/2014/2012 applying periodic service packs and cumulative updates.
• Experienced in designing database backup/recovery and performed all Recovery models and undertook Database Recovery based on RPO and RTO.
• Scheduled and automated full/differential/transactional backups and implementing recovery strategies.
• Analyzed business processes and performed in - depth work analyses.
• Developed ETL tasks to clean, transform as well as standardize the data from source table and database to destination servers.
• Created and deployed SSIS packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Implemented breakpoint, check point and precedence constraint to troubleshoot and triage SSIS packages at different stage of execution.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Implemented SSIS Business Intelligence Life cycle such as SSIS packages Configurations (XML Configuration, SQL Server, Environment variable, Parent Package Variable), Deployment, Scheduling packages in Development, Test, Production environments.
• Optimized T-SQL scripts used to feed reports and implemented ETL logic for faster loading and processing.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Undertook automation of daily, weekly and monthly system maintenance tasks such as database backup, indexes and scheduled jobs.
• Performed daily checkups on SQL jobs, checked hardware diagnostics for hard drives, backups, disk-space, monitored SQL and windows error logs as part of proactive maintenance plan.
• Exported and imported data from text files and Excel to SQL Server and SSIS using bulk copy insert and BCP utility.
• Coordinated with the development team regarding tuning the SQL queries and stored procedure, index management.
• Maintained the necessary documentation of the database design and maintained SOP.
• Conducted Root Cause Analysis of application availability and narrow down to issues like database bottleneck resource contention issues.
• Used DMVs, DTA, Execution plan to optimize query as well as took further database configuration for an efficient resource utilization.
• Monitored performance issues using SQL Profiler, Perfmon, event viewer as well as using third-party tool called IDERA diagnostic manager, Ola Hallengren
• Provided 24x7 production support

Confidential, Chantilly, VA

SQL Server DBA

Responsibilities:

• Worked extensively on installing, configuring and maintaining of SQL Server 2008R2/2008 and 2012
• CheckedSQLServerand Windows applications and system event log entries for warnings and errors and determine if any entries warrant further investigation.
• Performed system maintenance, such as disk defragmentation.
• Scheduled and automated full/differential/ transactional backups and implementing recovery strategies.
• Configured Log shipping, mirroring, replication, clustering and Always on Availability Groups.
• Involved in Managing servers and databases security by applying best practices and setting permissions and auditing to protect objects from being modified.
• Worked closely with development team reviewing, building, testing and maintaining database structures and SQL scripts.
• Created Indexes, Indexed View in observing business rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.
• Experienced in Running DBCC check, analyzed execution plans and index management for better Query Optimization.
• Coordinated with the development team concerning tuning the SQL queries and stored procedures.
• Handled requests/tickets and completed within the given SLA.(ZENDESK, REMEDY ticketing systems).
• Supported SQL Server Integration Services (SSIS) and SSRS.

Environment: SQL Server 2014/ 2012/2008 R2/2008/ Enterprise Edition, OLTP & OLAP, Microsoft Azure, Windows 2008R2/2012r2, report builder 2.0, SSIS and SSRS, PowerShell, Active Directory.