SUMMARY

• A Data Engineer with 5+ years of experience in MSBI (SSIS, SSAS, SSRS) Stack and 2+ years of experience with Microsoft PowerBI in analyzing and visualizing data to get meaningful insights from data to assist in well informed decision making for the management.
• Developed SSIS Packages for full loading and incremental loading of data in data warehouse using ETL mapping Document
• Created reports using SSRS with shared data sources, datasets and embedded data sources and datasets
• Designed and documented entire PowerBI Architecture
• Expertise in writing complex DAX functions in Power BI and Power Pivot
• Used various data sources to pull data into Power BI such as Sql Server, Oracle, Flat Files.
• Worked all kind of reports such as Yearly, Quarterly, Monthly, and Daily
• Extensively used Joins and Sub - Queries to simplify complex queries
• Worked with business partners to understand business objectives and develop value-added reporting with data extracts and analysis
• Created Drill Down Reports, Drill Through Report by Region
• Expertise in power Query, Power Pivot and Power View
• Used Power BI Desktop extensively and publish reports to Power BI Service and granted access to business managers to take decisions based on insights from a dashboard
• Created Dashboards from reports to get a high-level understanding on reports published

TECHNICAL SKILLS

Integration Solutions: SSIS

Analysis Solutions: SSAS multi-dimensional, Tabular, Power Pivot

Reporting Solutions: SSRS, PowerBI

Databases: SQL Server 2012,2014,2017

Languages: T-SQL, PowerShell, C#, java, Python, DAX

AZURE: Data Factory, Synapse Analytics, sql database

PROFESSIONAL EXPERIENCE

Confidential, Wilson, NC

Business Intelligence Analyst/Power BI

Environment: Power BI Desktop, Power BI service, PowerBI report Builder, Sql server Data Warehouse

Responsibilities:

• Created reporting solutions for user base analysis and sales analysis and product analysis reports for digital products that are listed at teacherspayteachers.com
• Used Power Query to Get Data from SQL data Warehouse, Flat files, and other sources into powerBI desktop application to model and analyze data and build visualizations
• Used other sources like sql server analysis services where data is already modeled to create reports on power bi desktop
• Used DAX language to crate measures and aggregations and calculations
• Used DAX to create KPIs and used visualizations like card and gauge charts to provide visual insights to users
• Data from Flat files is loaded to understand column profiling and data cleansing for data analysis
• Used DAX FUNCTIONS LIKE FILTER, Calculate, Summarize, SUM, Top N, Calendar etc. for data modelling
• Implemented data visualizations like Pie, Donut chart, Column Charts, Tables, Filled Maps, Scatter Plots, Card, Gauge Charts, Key Influencers etc.
• Implements Slicers for allowing User selected filtering options on the reports and used buttons for user experience improvement of report navigation
• Published reports to power bi service in a workspace
• Created dashboards for consolidated reporting of all the reports for business users at one place
• Implemented subscriptions and alerts for dashboard visuals
• Scheduled data refresh for datasets using gateway configuration
• Shared Reports with business users with different permission levels
• Managed gateways and added data sources to the gateway configuration
• Performance analysis and model improvement with performance analyzer at desktop level
• Collaborating with report developers at workspace levels
• Implemented row-level security and test as role at desktop level and powerbi service level.
• Managed power subscriptions and Data refreshers for data sets
• Implemented Time -Intelligence Functions that are useful in Year-to-Date sales using TOTALYTD, TOTALQTD, TOTALMTD etc.
• Implements data formatting and used analytics lines for easy analysis and used multi chart visuals
• Validated the Data model and Dax Measures created for report accuracy

Confidential, Wilson, NC

Data Engineer

Environment: SQL server 2012, 2014, SSIS, SSAS multidimensional, SSRS.

Responsibilities:

• Developed SSIS Packages for full loading and incremental loading of data in data warehouse using ETL mapping Document
• Performed debugging and unit testing of packages and tasks in a package
• Developed dynamic packages with connection managers at project level, package level and parameters for facilitating dynamic packages
• Implemented packages using tasks like execute sql task, data flow task, Script task, Send mail Task etc.
• Used Data Flow task for ETL and transformation tasks like Lookup, merge, merge join, Row count, Union all, SCD, OLE DB Command
• Implemented logging in packages using SSIS logging
• Implemented Transformations like derived column, conditional split using expressions in transformations of Data flow task
• Integrated Data from different sources Sql server, Oracle, DB2, Flat files like CSV, Excel
• Implemented Event Handling on required events like on Error, Post Execute, Pre-Execute
• Packages are Encrypted for Security Reasons within the organization
• Implemented Performance Tuning with Parallel Execution Buffer Size increase from Default and source side sorting and data type conversion
• Trouble Shooting SSIS Packages for memory handling issues
• GIT integration for SSIS Projects and version Control
• Implemented fact and dimensional modelling of tables in Datawarehouse and created a package for each fact and dimensional tables that are to be loaded into Datawarehouse
• Implemented slowly changing dimension for required columns in type 0 type 1 type 2..
• Loaded the fact table with OLTP Tables and surrogate key from dimensions
• Created reports using SSRS with shared data sources, datasets and embedded data sources and datasets
• Used different visualizations Table, matrix, list, line etc.
• Deployed reports to report server and access to business users
• Created paginated reports on report builder with table layout and formatting
• Created multiple page reports with sub reports and drill through options with parameter passing to the drill down pages
• Used cascading parameters for user filter options and user-based selection
• Connected to sql server database and sql server analysis service multi-dimensional cubes from SSRS for data analysis and visualization

Confidential

Associate Software Engineer

Responsibilities:

• Trained in Oracle Database, sqL, PLSQL
• Trained in sql querying advanced level stored procedures, triggers, cursors etc.
• Worked on a case study train ticketing system using oracle ADF.