SUMMARY

• Over 8 years of IT industry experience wif Microsoft SQL Server, SSIS, SSRS, Power BI, Report Builder, and SSAS environments.
• Extensive database programming experience in writing T - SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
• Hands on experience in Performance Tuning and Query Optimization
• Involved in building a data-warehouse and Datamart wif Dimensions and Fact Tables based on the Business requirements.
• Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Designed data structure wif multiple facts and dimension tables to hold the source data to be used for building new reports wif SSRS and power BI.
• Experience in loading facts and dimensions using SSIS Packages on data warehousing projects.
• Experience in Power BI Business Intelligence tool.
• Developed compelling and interactive analysis reports and dashboards using advanced DAX.
• Developed custom reports and deployed them on server using Power BI.
• Understand business requirements in BI context and design data models to transform raw data into meaningful insights.
• Able to implement row level security on data and has an understanding of application security layer models inPower BI.
• Worked in Development, Testing and Production environment.
• Published Power BI Reports and made available in Web clients.
• Experience in writing T-SQL Stored Procedure, Triggers, Constraints, Views, Functions, and Indexes using various DDL and DML commands.
• Strong noledge of Data Warehouse methodologies and including Star schemas, snowflakes concept.
• Maintained data integrity by Creating checks and constraints.
• Optimized the performance of queries wif modification in T-SQL queries, normalized tables, established joins, and created indexes.
• Handled performance tuning and optimization, wif strong analytical and troubleshooting skills for quick issue resolution.
• Performed some DBA Tasks like checking the jobs dat fail and troubleshooting the issues.
• Developed, tested, and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
• Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, DataMart databases.
• Transferred data from various OLTP data sources such as XML, MS Excel, Flat files, into SQL Server 2012/2014.
• Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Involved in automating SSIS packages using SQL server agent jobs.
• Analyze and present data to help the company make important decisions.
• Ability to integrate reporting components from multiple data sources.
• Performed data model design and implementation.
• Able to properly understand the business requirements and develop data models accordingly.
• Expertise in using advanced level calculations on the data set.
• Proficient in makingDAX queries in Power BI desktop.
• Worked on all types of transformations dat are available in Power BI query editor.
• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.
• Worked on all kinds of reports such as Yearly, Quarterly, Monthly, and Daily.
• Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Weekly presentation to the business users about the reports and their changes as required.
• Expertise in Power BI pro and Power BI Premium.
• Participated in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Experience in generating Drill through and Drill down reports wif Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.
• Wrote SQL queries and stored procedures to generate data for reports.
• Defined the report layout and identified datasets for the report generation.
• Created, formatted, and maintained various reports in SSRS like drill-down, drill through, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports.
• Configured the report viewing security for various users at various levels using Report Manager.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including current status.

PROFESSIONAL EXPERIENCE

Confidential

Report Developer

Responsibilities:

• Migrate Cognos reports and Dashboards to Power BI.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Working in agile methodology to discuss status and product backlog in scrum methodology.
• Experienced in Microsoft Power Query, Power Pivot, Power View, Power Maps, Power BI Desktop, Power BI Service, data visualization, and SQL.
• Responsible for building reports and Dashboards in Power BI and Report Builder from the Scratch.
• Developed multiple page parameterized paginated report using Report Builder.
• Integrated Custom visual based on business requirement using power bi desktop.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.
• Used Power BI to collaborate wif different users and stakeholders to work on live data sources
• Worked wif both live and import data into Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different types of slicers available in Power BI for creating reports.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Developed Complex SQL queries using Stored procedures, CTE, Temporary tables to support my Power BI Reports.
• Worked on all types of transformations dat are available in Power bi query editor.
• Created Calculated Columns and Measures in Power BI depending on the requirement using DAX queries.
• Created Workspaces for business users to view the developed reports.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Scheduled Automatic refresh and scheduling refresh in power bi service.

Environment: SQL Server, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, Cognos, Report Builder, Power BI, Azure DevOps, SQL Profiler, Visual Studio, DAX Studio.

Confidential, Boise, ID

Database/Power BI developer

Responsibilities:

• Develop formulas for reports in Data Analysis Expression (DAX) language.
• Created designs for dashboards based on client requirements.
• Utilized Power BI gateway to keep dashboards and reports up to-date wif on premise data sources.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
• Designed complex data intensive reports in Power BI utilizing various graph features.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers, and data types.
• Establishing referential integrity, data consistency, and indexing procedures to maintain high quality data dat can be used for reporting.
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution and to improve their performance.
• Responsible for Configuring, Deploying, Scheduling Jobs, and Maintaining SSIS packages.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Analyzing a huge number of existing reports to understand the logical and interface design changes to be applied accordingly.
• Worked on T-SQL programming, stored procedures, and views in the process of developing reports.
• Used Azure DevOps and GitHub for managing source code changes.

Environment: SQL Server 2012/2014/2016 , T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, Power BI, Azure DevOps, Jira, Control-M, SQL Profiler, Visual Studio.

Confidential, Tumwater, WA

ITS 5 BI Solutions ETL Specialist

Responsibilities:

• Created Databases, tables and provided constraints and user defined rules and defaults.
• Query tuning based on query execution plans, statistics, and profiling.
• Development and performance tuning of complex stored procedures, user defined functions and views for data migration.
• Connected to multiple data sources, importing data and transforming data for Business Intelligence.
• Created interactive and highly informativePower BI reportsusing advanced DAX features.
• Was responsible for creatingPower BI appsand connecting them wif live data sets for real-time analysis
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date wif on premise data sources.
• Design SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look up ups, derived columns, merge join, conditional split, data conversion wif multiple data flow tasks.
• Provide continued maintenance and development of bug fixes for existing power BI Report.
• Developed complex calculated columns and measures using Data Analysis Expression Language (DAX).
• Design and implementation of the Data Warehouse/DataMart life cycle.
• Working on all phases of Data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

Environment: SQL Server 2012/2014/2016 , T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, Power BI, Power Pivot, Azure DevOps, SQL Profiler, Visual Studio.

Confidential, Bellevue, WA

Database Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
• Optimized the performance of queries for improved Performance and availability.
• Worked on T-SQL programming, stored procedures, and views in the process of developing reports.
• Generating different kind of report in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements.
• Created and implemented a complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Useddifferent types of SSIStransformation for data cleansing to remove unnecessary columns, eliminating redundant and inconsistent data.
• Configured packages wif checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Involved in automating SSIS packages using SQL server agent jobs, windows scheduler.
• Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).

Environment: SQL Server 2012/2014/2016 , T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, SQL Profiler, Visual Studio.