PROFESSIONAL SUMMARY:

• Over 10 years of experience in Microsoft business intelligence Development under SQL Server environment, with thorough knowledge of SQL Server 2008/2008R2/2012/2014 databases. Experience in working with SQL Server Management Studio and Business Intelligence Development Studio. Good knowledge on the versions of Microsoft SQL Server 2016/2017 and Visual Studio 2015/2017.
• Strong background in a disciplined Software Development Life Cycle (SDLC) process involving Data Analysis, Design, Development and Implementation and working knowledge in Agile/Scrum Environment
• Experience in developing Azure data factory pipelines in V1 and V2, creating linked services, data sets, monitoring and scheduling ADF pipelines.
• Experience in Relational, Multi - Dimensional (Star) and Snowflake logical modeling, fact and Dimensions tables and Logical and Physical data modeling using data modeling tools such as Erwin and ER/Studio.
• Good hands-on working experience with using all kind of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique)
• Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
• Extensively used all components of Power BI by creating different types dashboards as per the business requirement and deployed into report servers
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience working with the BIDS and SSDT which includes SSIS, SSAS and SSRS.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using (SSRS).
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Expertise in developing complex SSIS Packages including C# scripting to extract data from heterogeneous data sources.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SSAS
• Experience in creating various SSRS reports like Charts, Filters, Sub reports, Drilldown and Drill-Through, Cascade, Parameterized reports involving conditional formatting.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors using SQL and PL SQL. knowledge in Web technologies such as HTML, DHTML, JavaScript and XML
• Strength in problem solving and effective team player with excellent analytical, troubleshooting, and conflict resolution.
• Excellent team management skills with Onsite-Offshore work co-ordination, good business acumen, effective communicator with Business.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio.

Databases: MS SQL Server 2017/ 2016/ 2014/2012/2008 R2, Oracle 10g/9i/8i, DB2, Teradata, MS Access, Redshift, Vertica.

Programming Languages: C, C++, JAVA, SQL, Visual Basic.

Data Modeling Tools: Physical and Logical Data Modeling using ERWIN and MS Visio.

ETL Tools: Data Transformation Services, SSIS

Scripting: HTML, DHTML, XML, JavaScript.

Reporting Tools: SSRS, Crystal Reports, Tableau 9.1, Power BI

Testing Frameworks: Testing Tools Selenium IDE, Selenium WebDriver, Selenium Grid, Junit.

Operating Systems: Windows 2003/2008, Windows 7, Windows NT, Windows 2000, XP

PROFESSIONAL EXPERIENCE:

Confidential, Woodlawn, MD

MSBI Developer

Responsibilities:

• Responsible for requirement gathering by coordinating with Business users
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other index code and SQL joins for applications.
• Involved in creating, modifying and troubleshooting SSIS packages.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging and Configuration Files.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix and sub reports.
• Involved in development of Azure Data Factory Pipelines, linked services, data sets, deploy and monitor them.
• Monitoring SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Scheduling/enabling triggers for the ADF Pipelines developed.
• Wrote complex stored procedures, functions, and triggers to implement business logics in the OLTP database.
• We used to load different source data from SQL Server, flat files, CSV files using SSIS into our Data Lake/Operational data source.
• Developed SSIS packages, architecting the flow of data from various sources such as MS SQL Server 2000, MS Access, MS Excel, CSV files to target (MS SQL Server 2005)
• Design and developed Test Plan and Test Cases corresponding to workflow and requirements
• Created Complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, indexed views, user defined functions (UDF).
• Participated in Maintenance activities of SQL Azure. Writing stored procedures, functions and complex T-SQL queries in SQL AZURE Cloud.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement
• Created Key Performance Indicators (KPIs) using different storage settings for cube designing.
• Developed and maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Work with developers, DBAs, and systems support personnel in migrating successful code to production.
• Worked extensively on SSAS tabular model using Data analysis expressions.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures.

Environment: MS SQL Server 2017/2016, Microsoft SQL Server Integration Services (SSIS) 2017/ 2016/ 2014/2012/2008 R2, Microsoft SQL Reporting Services (SSRS) 2017/ 2016/ 2014/2012/2008 R2, Microsoft SQL Server Analysis Services (SSAS) 2017/ 2016/ 2014/2012/2008 R2, MS Azure, SQL Server Data tools, Microsoft Access, MS Excel, Azure data factory V1 and V2, Azure Data Lake (ADL), Power BI.

Confidential, Bethesda, MD

MSBI Developer

Responsibilities:

• Extensive Experience in Agile Methodology, starting from SCRUM, business requirement gathering and analysis to testing and deployment.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes.
• Extensively involved in gathering business requirements that will facilitate the planning and the implementation phase of OLTP database.
• Participated in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS).
• Worked on SQL performance tuning and done unit testing to check the performance on the changes made in the backend reflecting in the front end of the application.
• Created Excel Reports, Power BI by connecting to various SQL server databases and improved the efficiency of these large reports.
• Involved in ETL Architecture Enhancements to increase the performance using query optimizer.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Responsible for implementing Cubes (tabular) using SSAS, implementing Power BI reports with cubes as data source for live connection.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Developed and maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Created SSIS templates for developing SSIS packages in such a way that they can be dynamically deployed in to development, testing and production environments.
• Implemented transactions at package and task level in SSIS to meet the business requirements
• Formatted the reports using the global variables and expressions in SSRS, deployed the generated reports on to the Reporting server.

Environment: SQL Server 2016/ 2014/2012/2008 R2, Microsoft Access, Microsoft SQL Server Integration Services (SSIS) 2016/ 2014/2012/2008 R2, Microsoft SQL Server Reporting Services (SSRS) 2016/2014/2012/ 2008 R2, Microsoft SQL Server Analysis Services (SSAS) 2016/2014/2012/ 2008 R2, MS Azure, MS Access, JIRA, C#, .Net, Power BI, Teradata, Excel (VLOOKUP’s, Pivot Tables), MS Visual Studio 2010 and 2008(SSIS, SSAS, SSRS)

Confidential, Fulton, MD

MSBI Developer

Responsibilities:

• Analysis of user requirements and reporting dataset needs and create Dimensional Model to create Logical and Physical Database Design using Star Schema Methodology. (Dimensions/Fact Table Design).
• Worked on SQL performance tuning and done unit testing to check the performance on the changes made in the backend reflecting in the front end of the application.
• Created database tables, Indexes, triggers by writing SQL queries as per the database change request by the business.
• Created Key Performance Indicators (KPIs) using different storage settings for cube designing.
• Extensively used all components of Power BI by creating different types dashboards as per the business requirement and deployed into report servers.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.
• Worked with the front-end Java and UI developers to ensure that the data flow between the front end and backend worked seamlessly by SQL stored procedures for DML Operations.
• Analyzed source OLTP systems and created data mapping documents for the ETL process.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Created SSIS templates for developing SSIS packages in such a way that they can be dynamically deployed in to development, testing and production environments.
• Created Linked Servers, Functions and Stored Procedures and Views. and send data across multiple Servers.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix form, Conditional, List items, Charts and Sub reports, Custom report and Drill down reports using SSRS
• Developed and maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Developed SQL Server reports on daily performance of databases using SQL Server Reporting Services.
• Involved in creating, modifying and troubleshooting SSIS packages.
• Built new MDS (Master data services) and data warehouse application for business users and Migrated data from old data warehouse to new data warehouse. Developed and maintained Crystal reports as per the user requirement.
• Implemented transactions at package and task level in SSIS to meet the business requirements.
• Created Linked Servers, Functions and Stored Procedures and Views. and send data across multiple Servers.

Environment: SQL Server 2014/2012/2008 R2, T- SQL, Microsoft Access, Microsoft SQL Server Integration Services (SSIS) 2012/ 2008R2, Microsoft SQL Server Reporting Services (SSRS) 2014/2012/2008 R2, Microsoft SQL Server Analysis Services (SSAS) 2014/2012/2008 R2, SQL Server Business Intelligence Development Studio, Star Team Version Control tool), TFS, Tableau.