SUMMARY

• 6 years of strong experience in the IT industry as an MSBI Developer (SSIS, SSRS, SSAS) with sound business analysis skills.
• Experienced in medium to large scale environments in various domains like Finance, Retail and Healthcare.
• Experienced in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Worked Extensively on Business Intelligence (BI) technologies to provide Historical, Current, and Predictive views of business operations.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end - user to make filters.
• Expertise in DAX functions for various fact calculations for efficient data visualization in Power BI.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS by creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Expertise in creating multivalued parameterized reports, multi-level cascading reports, drill down, drill through, sub reports, charts and ad hoc reports using SQL Server Reporting Services ( SSRS ) and publishing them to SharePoint server for daily/weekly/bi-weekly/monthly reports.
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server 2005/2008/2008 R2/2012.
• Strong Knowledge of data architecture concepts such as OLTP and OLAP systems, operational data stores, data warehouses, data marts, staging databases and data servicing layer.
• Expertise in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, Merge join, union all, and slowly changing dimension.
• Expert in creating cubes, perspectives and deploying using MS SQL Server Analysis Services (SSAS) involving multidimensional data.
• Worked extensively in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and database Engine Tuning Advisor.
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS

RDMS/DATABASES: MSSQL Server 2005/2008/2012/2015 , Oracle, MS Access2007, MYSQL, Azure Data Lake, Microsoft Azure

DATA WAREHOUSING & BI: Star Schema, Snowflake Schema

PROGRAMMING LANGUAGES: T-SQL, PL/SQL, Dynamic SQL, JAVA, C

ETL TOOLS: DTS,SQL Server Integration Services(SSIS), SQL Sever Analysis Services (SSAS), SQL Server Reporting Services (SSRS) 2005/2008/2012/2015 , Microsoft Visual Studio 2010 /2015 /2016 , Cozyroc

SQL SERVER TOOLS: SQL Server Management Studio (SSMS), DAC, Microsoft Management Console, Power BI.

DATA MODELLING: Physical and Logical Data Modelling

OTHER TOOLS: MS Office, Microsoft Sharepoint 2007/2012

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

MSBI/ Power BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• 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.
• Designed and developed Test Plan and Test Cases corresponding to workflow and requirements
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
• Provided technical assistance with troubleshooting reports/models/cubes by responding to inquiries and questions
• Developed new and maintain existing Power BI reporting solutions
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Performed thorough unit testing on all relevant platforms to ensure proper implementation.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Created database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes.
• Installed, maintained, developed using SQL Server 2017/2016
• Created, modified 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.
• Developed Azure Data Factory Pipelines, linked services, data sets, deploy and monitor them
• Scheduled/enabled triggers for the ADF Pipelines developed.
• Written complex stored procedures, functions, and triggers to implement business logics in the OLTP database.
• Created Complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Developed and maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures.
• 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, modified and troubleshoot SSIS packages.
• Implemented transactions at package and task level in SSIS to meet the business requirements.

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, Power BI

Confidential, Oklahoma City, OK

MSBI Developer

Responsibilities:

• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Elicited requirements from various divisions to improve and modify data corresponding to business logic.
• Designed, developed and tested SSIS packages and SSRS reports to support business initiatives, goal setting, and performance management and risk avoidance.
• Created and managed database objects that include tables, views, stored procedures, user-defined functions and constraints to implement business logic.
• Created stored procedures and written complex queries and T-SQL Joins to address various reporting operations and random data requests.
• Rectified and fixed various bugs in the stored procedure as well as various suggestions of the outsourcing team is incorporated.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Incorporated Error Redirection during ETL Load in SSIS Packages. Performed Unit testing and System Testing of ETL Process.
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS) and report builder.
• Created, executed, and deliver tabular, matrix, and charts reports, debugged and deployed reports in SSRS.
• Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Loaded the data into destination tables: both full and incremental load, by performing different kinds of transformations like row count, Look-up, derived column, merge, script task using SSIS packages and performed with truncating, modifying and creating tables in data base as per requirements.
• Worked extensively creating and maintaining DAX calculations, DAX queries and MDX queries.
• Provided Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Published reports on to Share-Point 2010 and Report Server and set the data-driven subscriptions for these reports.
• Administered and deployed OLAP cubes on development and production server for performance analysis using SSAS.

Environment: SQL Server 2012, Microsoft SQL (T-SQL), SSIS, SSRS

Confidential, Newark, NJ

MSBI/SQL Developer

Responsibilities:

• Actively participated in the meetings between Business Users and Technical team to gather and discuss the business requirements and convert them into technical/functional requirements.
• Designed and implement Data Mart, Facts, Dimensions and OLAP Cubes using dimensional modeling standards in SQL Server 2012 that maintained data.
• Initiated to implement technological solutions in a cost-effective way by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators and partners.
• Designed SSIS Packages to perform the extract, transfer, and load (ETL) operations with existing data into SQL Server through OLTP database from different data sources.
• Worked with SSIS Data flow task, Transformations, For-loop containers and Fuzzy Lookups, Data conversion and configured data in slowly changing dimension.
• Worked with team to Develop and Extend the OLAP Cubes, Dimensions and data source view.
• Worked in the complete Data Warehouse development life cycle and actively supported business users for change requests during the project development.\
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Worked with the team in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed several drill down and drill through reports using SSRS as needed by clients.
• Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases to integrate the data as business requirements
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2014, SSIS, SSAS, SSRS, visual studio, Import/Export tools, SQL Server Agent, MS Access, T-SQL, ERWIN and Windows10.

Confidential

SQL/ MSBI Developer

Responsibilities:

• Collaborated and coordinated with business analysts to gather requirements for implementing data mart.
• Designed and developed various analytical Dashboards from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Designed a database optimization plan like creation of table partitions and the use of appropriate Indexes.
• Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.
• Worked with various SSIS control flow tasks and data transformations like Data conversion, Derived, Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL.
• Created Event Handlers, Package Configurations, Logging, System and User-defined Variables Incorporated control for solution source control, project coordination, and task management.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
• Written various reporting queries for Billing, Accounts Payable, Claims, and Customer Service.
• BI team is responsible for development, enhancement & maintenance of various internal and external reports/applications to support claims, members, providers, compliance related processes.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory and experience with Data Lake.
• Configured the cloud databases for HA solutions with Geo-replication.
• Created Parameters, customized Calculations, Conditions, Groups, Sets, Bins, Context filters for various analytical reports and Dashboards.
• Generated context filters and data source filters while handling huge volume of data in Tableau.
• Created Tableau dashboards with Hierarchies, interactive views, drill downs with user level security.
• Created different visualizations using charts like Bars, Lines and Pies, Maps, Scatter plots.
• Developed Tableau workbooks to perform year over year, quarter over quarter type of analysis.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop and published them to server.

Environment: Microsoft SQL Server 2012, SQL Server Integration Services (SSIS) 2012, Microsoft SQL Server Management Studio, BIDS, T-SQL, Tableau Desktop V8/V9, TFS, Azure

Confidential

JR. SQL/ MSBI Developer

Responsibilities:

• Participated in Analysis of the Business requirements and source systems.
• Designed the mapping technical specifications on the basis of functional requirements.
• Designed and documented the High Level process flow of extracting the data from the Source system till loading the data in Data warehouse.
• Designed and implemented stylish report layouts.
• Transferred data using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Analyzed reports and fixed bugs in stored procedures.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Created SQL Server Reports using SSRS.
• Developed Query for generating drill down reports in SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Scheduled subscription reports with the subscription report wizard.
• Participated in Performing the Unit testing and basic functional testing.
• Monitored Scheduled jobs and alerts.

Environment: SQL Server, SSRS, T-SQL code, complex Stored Procedures, Triggers, Functions, Indexes, Tables, Global Variables, deployed SSIS.