SUMMARY:

• SQL/BI Developer over 7 years of experience
• Broad experience in different phases of Software Development Life Cycle (SDLC)
• Strong experience with demonstrated success in the Database Design, Development, and Implementation using MS SQL Server 2016/2012/2008
• Extensive experience in T - SQL for developing Stored Procedures, Triggers, Indexes, View, User Defined Functions, CTE, Temp Tables, Table Variables and SQL Joins
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server
• Excellent experience in creating Indexes, Indexed View in observing business rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency
• Familiar with OLTP, OLAP and Data Warehousing Design concepts.
• Well experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Expertise in creating different reports, like Drill-Down, Drill-Through, Parameterized, and Tabular reports based on client requirement using SSRS.
• Extensive experience with Power BI,DAX functions Developing Dashboards
• Hands on experience in Power BI Service & Power BI Desktop Expertise and proven experience in development of reports, dashboards, KPI scorecards, aggregating data from multiple sources
• Experience in creating the SQL Jobs, Sending Alerts using SQL DB Mail and schedule SSIS packages.
• Excellent communication and writing skills with the ability to adapt to new and dynamic environments.
• Ability to multi-task, prioritize and work with time constraints while paying attention to details.
• Good problem-solving, judgment, and decision-making skill
• Ability to work with all levels of management, willingness to learn and implement new ideas quickly and to be a collaborative team player.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2008/ 2008R2/2012/2016

Operating Systems: Windows2000/XP/2003/Window7/8/10

Query Language: T-SQL

Programming Language: C #

ETL Tools: SSIS 2008/2012/2016 , SSMS Import/Export

Reporting Tools: Power BI,SSRS 2008/2012/2016

Web Technology: HTML, XML, DHTML

Other Tools/Technology: SharePoint, Team Foundation Server, Microsoft Word, MS Excel, Outlook Express, Power Point

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

SQL Server BI Developer

Responsibilities:

• Participated in gathering requirements and discuss details with team lead
• Analyzed the source data and figured out correct data mapping to staging tables, data warehouse and data marts.
• Created Tables, Views, Indexes, Stored Procedure and Triggers.
• Used multiple join statements to retrieve data and update the tables.
• Design and develop T-SQL procedures, query performance tuning and SSIS packages.
• Created functions to provide custom functionality as per the requirements.
• Used SSIS to implement slowly changing transformation to maintain historical data in data warehouse.
• Used various SSIS transformations such as conditional split, look-up table and derived column for data scrubbing and data validation during staging, before loading the data into data warehouse
• Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent.
• Designed and developed interactive dashboards and KPI scorecards by aggregating data from multiple sources using Power BI.
• Maintained and deployed new Power BI reports.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Utilized Microsoft team foundation server and its features for code sharing and updates from other members.

Confidential, MD

SQL Server/ BI Developer

Responsibilities:

• Actively involved in gathering system specification requirements for the project through JRD sessions from business users and Subject Matter Experts (SMEs)
• Involved in creation of functional requirement specifications (FRD) and supporting documents for business systems, experience in database design process and data modelling process
• Examined and evaluated the data structures in the source and enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server.
• Worked with database objects like Stored Procedures, User Defined Functions, Triggers and Indexes using T-SQL to create complex scripts and batches.
• Created and deployed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations t o make data standardized
• Involved in package troubleshooting utilizing error logs, checkpoints, breakpoints and data viewers
• Implemented package configurations on the development, test, and production environments
• Wrote SQL queries on data staging tables and data warehouse tables to validate the data results.
• Created summary reports, sub reports, Drill Through and Drill-down reports using SSRS.
• Delivered on-demand and scheduled reports on daily, weekly, monthly and quarterly Reports including current status for business analysis or management decisions using SQL Server Reporting Services.

Confidential, VA

SQL Developer

Responsibilities:

• Participated with business analysts in order to gather requirements for design and implementation of database
• Created complex Stored Procedures, Triggers, User Defined Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Used execution plan and tuning advisor to solve performance issues of query and followed instructions to improve query performance.
• Installed SQL Server Management tools using SQL Server Setup Program
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Created indexed views and appropriate indexes to reduce the running time for complex queries
• Performed data cleansing and validation to figure out reportable data based on the requirements.
• Generated various reports SSRS as per requirements using Report Builder.