SUMMARY

• Over 5 years of experience in developing BI applications utilizing SQL server, BI stack & Power BI.
• Extremely familiar with database installation, configuration, maintenance, and monitoring of SQL Server.
• Proficient in T - SQL queries: Data Definition Languages (DDL) and Data Manipulation Language (DML).
• Experienced in creating and managing T-SQL queries, stored procedures, user defined functions, indexes, views, and triggers.
• Comprehensive knowledge & in all phases of the Software Development Life Cycle (SDLC).
• Experience in designing and documenting Conceptual, Logical and Physical data models.
• Proficient in relational & dimensional database modeling also normalization & denormalization.
• Expertise in designing and implementing both Start & Snowflake Schemas.
• Experience in utilizing DDLs, DMLs, functions, variables, temp tables & transaction blocks.
• Experience in Developing & delivering data integration workflow using Agile delivery methodology.
• Well versed in developing Data Transformation workflows using SSIS packages.
• Experienced in designing & implementing data flow processes to integrate data from various heterogeneous data sources like SharePoint, Excel, flat files &, Salesforce.
• Well versed in designing dynamic SSIS packages using variables, parameters & expressions.
• Proficient in creating dynamic SSIS Packages to refresh slowly changing dimension tables.
• Experience on various Power BI Visuals and Visual Properties including Tree Map, Pie Chart, Funnel, Scatter Bar Chart and Column Charts.
• Excellent interpersonal, verbal, and written communication skills.

TECHNICAL SKILLS

RDBMS: SQL Server 2008R2, 2014, 2016 & 2017

Database Tools: SSIS, SSAS, SSRS

Reporting: SQL Server Reporting Services (SSRS) and Power BI

Languages: T-SQL; MySQL

MS-Office: Microsoft Office Tools, Trello

Version Control System: GitHub

PROFESSIONAL EXPERIENCE

SQL/SSIS/Power BI Developer

Confidential, Herndon, VA

Responsibilities:

• Worked on the complete life cycle of the project from design to implementation.
• Designed the business requirements and system requests based on the user requirements.
• Involved in designing, reviewing, and creating Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Used SSIS as ETL Tool to extract the data from production servers to OLAP Data warehouse.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Prepared documentation on database structure, design, flow, schedule, and all stored procedures.
• Performed server installation and configurations for SQL server 2008/2008R2
• Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experience in using variables, expressions and functions and defining Query for generating drill down reports in SSRS.
• Provided support SQL Server Reporting Services (SSRS) environment by installing, configuring, and deploying reports.
• Setup database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production database.
• Creating Power BI Dashboards with Tiles and Pins from Reports, Insights and Workbooks.
• Creating and working with IMPORT and UPLOAD options for Dataset Creations.
• Creating Power BI Dashboards from Excel Files using Power BI Publisher for Excel.

SQL/ SSIS/Power BI Developer

Confidential, Leesburg, VA

Responsibilities:

• Developed & maintained complex SQL stored procedures, Views and functions.
• Performed data conversions from various files into a normalized database structure.
• Created check constraints to maintain data integrity.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables for reporting purpose.
• Extracted data from diverse data sources such as SharePoint, Salesforce, SQL Server, My SQL database, Azure SQL Server database and FTP.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Extensively used package configuration to migrate SSIS package from one environment to another.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Scheduled SSIS Packages daily and weekly Basis.
• Developed Standard Reports, Sub Reports, Drill down Reports, used various Charts and graphs like Bar Chart, Line graphs, Pie.
• Created Ad-hoc reports using Report Builder and maintained Report Manager for SSRS.
• Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Work with development teams to make best schema design that balances feature requests with performance concerns.
• Coordinate with the team that responds to all system problems to reduce or eliminate production problems by analyzing production usage information and using that information to design a better architecture.
• Worked with T-SQL to create tables, Views, triggers, and store procedures and, also reviewed many T-SQL issues using management studio for better performance.
• Worked in creating the consolidated script for reporting schema creation, table relationships establishment and indexing for performance improvements.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Working with Power BI Report Server for Paginated Reports and Using Report Builder Tool.
• Implement DAX Measures and Calculations for various Accounting Aggregations.