SUMMARY:

• Experienced on working on Agile projects with multiple Sprints Cycles and Scrum meetings, and on Water Fall projects with full Software Development Life Cycle (SDLC)
• Experienced using Agile Project management tools like Trello and JIRA
• Advanced knowledge and experience in system analysis, design, development, implementation and maintenance of Relational Database and Data Warehouse systems.
• Advanced knowledge in logical and physical database design and development using Erwin data modeler, and employing required normalization forms.
• Extensive experience in designing data warehouse, merging data from various sources, and populating dimension and fact tables in data warehouses and data marts.
• Experience in writing complex T - SQL queries, stored procedures, joins, triggers and indexes, user-defined and system built in functions, common table expressions, views, and cursors.
• Knowledge of database installation and configuration principles and In-depth knowledge of database procedures, regulations, applications and methods.
• Involved with a team for Installation and Configuration of the MS SQL server 2008.
• Applied regular security/update patches and service packs to ensure the data integrity.
• Proficiency in database maintenance, monitoring, backup and disaster recoveries.
• Experience in implementing event driven Error handlings and package logs.
• Experience in creating packages, deployment and scheduling, jobs and sending alerts using SQL Mail/Database Mail.
• Experience in data extraction, transformation and loading ( ET L) p roce ss from different sources for small and large-scale Data Warehouses using Bulk Copy Process (BCP), data transformation services (DTS) and SSIS.
• Expert in creating data visualizations such as parameterized reports, drill down reports, and interactive reports using SQL Server Reporting Service.
• Experience in analyzing data by applying descriptive and inferential statistics; and using statistical software like SPSS and STATA.
• Hands on experience in developing executive DSS dashboards using Power BI
• Experience in configuring Reporting Service, Report Manager and Report Server; and MS SQL Integration Service catalogs.
• Ability to translate reporting and analytical needs into technical solutions.
• Strong interpersonal and communication skills; competitive analytical, logical, and problem solving skills; strong management, administrative and leadership skills to work in team.
• Working under pr e ssure, and short dea dli ne s with e x ce pti ona l p roble m solvi ng a nd de c isi on making a na l y ti ca l skil ls a nd strong tea m wo rk spirit .

TECHNICAL SKILLS:

Tools: C#, .NET, Visual Studio 2013/2015, SSIS/SSAS/SSRS, Power BI

Scripting: T-SQL, C++, C#, VB.Net

Databases: SQL Server 2008/R2/2012/2014, MS Access

Platforms: Windows10/ 8/7/XP, Windows Server 2012

Software: Visual Studio .NET, MS Office Suite, Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Reston,VA

BI Developer

• Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems using SSIS.
• Performing Data transfer from different sources like Excel, MS Access, Oracle, DB2 and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.
• Perform in Control Flow items and Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all, and Pivot / Un-pivot).
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Configuring and creating SSIS solutions for ETL and BI Processes for Data Integration and Migration services.
• Implemented security policies to restrict/allow users to access for only certain reports.
• Merging data from various sources, Populating Dimension, Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS Packages.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SSRS 2008/20012.
• Developing ETL interfaces using SSIS and enterprise reports with report manager for deploying the reports across all the environments.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters.
• Created stored procedures, Triggers, User-defined Functions and Views for both Online and Batch requests to handle business logic, and functionality of various modules.
• Automate Packages, Error Report and Jobs such as index reorganize/rebuilding, backups, Alerts, Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc. using SQL Server Agent, FTP and SMTP.

Confidential, Washington, DC

Jr. DBA\ Develop er

• Involved with a team for Installation and Configuration of the MS SQL 2008R2\2012.
• Applied regular security/update patches and service packs to ensure the data integrity.
• Writing T-SQL queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Monitoring the user accounts or groups, granting/revoking the privileges to users.
• Experienced in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects.
• Experienced in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables and Stored Procedures
• Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DMV’s and Query Execution Plans
• Involved in implementing efficient Disaster Recovery Strategies and High Availability’s like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring on test environment.
• Developed and maintained scripts for administrative tasks like backups, tuning and refreshing test databases from production periodically.
• Monitored server performance, database and transaction log growth and error logs.
• Regularly monitor the performance of the servers (CPU, Memory, and I/O) using SQL Profiler, Performance monitors, Dynamic Management Views, Wait Stats and Events.
• Worked and generated basic reports using SQL Server 2008 Reporting services (SSRS).
• Involved in SQL Server Performance, Monitoring Database optimization and Query tuning, using 3rd party tools.
• Experience in using SQL Server Agent to Schedule and monitor Jobs