SUMMARY:

• SQL/BI Developer with 7 plus years of experience
• Broad experience in different phase 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 experienced in Data Extraction, Transformation 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 using based on client requirement using SSRS.
• Hands on experience in development of reports, dashboards, KPI scorecards, aggregating data from multiple sources using Power BI.
• Extensive experience in Power BI Services, Power BI Desktop and DAX functions.
• 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 skills.
• 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:

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

Operating Systems: Windows2000/XP/2003/Windows7/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, Washington, DC

SQL Server BI Developer

Responsibilities:

• Involved in all phases of the Software Development Life Cycle (SDLC) including working with users and development staff to determine requirements.
• Examined and evaluated the data structure in the source and enhanced the old logical and physical database design to fit new business requirement, and implement new design into SQL server.
• Wrote complex scripts for DML and DDL.
• Created stored procedure for the optimal performance of the system.
• Created function to provide custom functionality as per requirements.
• Worked on data mapping to staging tables, data warehouse and data marts.
• Developed SSIS package to load data into dimensions and fact tables using slowly changing dimensions.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Union all Fuzzy Lookup, and Derived Columns with Multiple Data Flow tasks.
• Created XML package Configuration and Error Handling using Event Handlers.
• Involved in automating SSIS packages using SQL Server Agent Jobs.
• Worked in unit testing to check the data is loading into target, which is extracted from different source systems according to the user requirements.
• Performed data validation on data staging tables and data warehouse tables to validate the data results using SQL queries.
• Configured various events driven e-mail notification process in SSIS packages.
• Designed and developed SSRS reports with functionality such as Drill Down, Drill through, and parameters.
• Configured report server and report manager for SSRS report deployment and management.
• Deployed SSRS report to Share Point and Reporting Server.
• Designed and Developed Interactive Dashboards and KPI scorecards by aggregating data from multiple sources using Power BI.
• Maintained and Deployed new Power BI reports.
• Collaborated with network operators, application developers, and DBAs to enhance end user experience.

Confidential, Chantilly, VA

SQL Server BI Developer

Responsibilities:

• Involved in performance tuning and Database optimization process.
• Create indexes for the quick retrieval data from the database.
• Debugged complex stored procedures, functions, and triggers.
• Defined constraints, rules, indexes and views based on business requirements.
• Used Query Analyzer to optimize SQL queries.
• Created and maintained database and database objects like Tables, Views, Triggers, and User Defined Functions.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed database objects from development/testing environment to production environment.
• Used SSIS package for extracting, transforming and loading data from excel, flat files and other sources to different databases and data warehouses.
• Implemented package configuration on the development, test, and production environment.
• Worked on package troubleshooting utilizing error logs, checkpoint, breakpoints and data viewers.
• Created datasets using T-SQL and stored procedures.
• Generated custom and parameterized reports using SSRS.
• Developed and published reports using MS SQL Server Reporting Services.
• Configured subscriptions, snapshots, cache refresh and reports history on report manager.

Confidential, Anniston, AL

SQL Developer

Responsibilities:

• Participated with business analysts in order to gather requirements for design and implementation of database.
• Worked on iteration basis to make sure the deliverables are achieved on time.
• Modified stored procedures, Triggers, Tables, and Views.
• Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Debugged complex stored procedures, functions and triggers.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different database.
• Created and maintained database and database objects like Tables, Views, Stored Procedures, and Triggers.
• Performed quality assurance and testing of SQL server environment.
• Documented all requirements and scripts for future references.
• Collaborated with DBAs to refresh the existing database from the production server.