SUMMARY

• Experienced Power BI Developer with a strong track record of delivering data - driven solutions and insights to clients. Proficient in creating interactive dashboards, data visualizations, and reports using Power BI.
• Adept at working with large and complex data sets, establishing data connections, and conducting data analysis.
• Possesses excellent communication, problem-solving, and collaboration skills and a commitment to meeting project deadlines and delivering quality results.
• Expertise and experience in designing and developing, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Database objects such as Tables, Schema, Indexed Views and User Defined Functions for data definition, manipulation, and access.

TECHNICAL SKILLS

BI Tools: Power BI, Power BI Premium, Tableau, SSIS, SSRS, SSAS, Qlik Sense

Software methodology: Agile Scrum, JIRA software, SharePoint

Application Tools: SAP, MS Office, MS 365, MS Visio, MS Project, Erwin

Database Languages: SQL, PL/SQL, T-SQL

Databases: Azure,Snowflake, Oracle 10g/11g, MS SQL Server 2008/2019

Database Tools: SQL Developer, SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Confidential, Georgia

MS Power BI Developer

Responsibilities:

• As a member of BI/Database team, involved in Technical Design, and Development.
• Work with the database modeling manager to identify the requisites of a project.
• Designed and built Power Apps for desktop and mobile devices to gather data and navigate through distribution center solutions, and integrated Power BI for analytical reporting.
• Constructed data extraction, transformation, and loading modules utilizing DAX, and produced dashboards and reports for ongoing monitoring of distribution center operations.
• Developed SSIS packages for extracting, transforming, and loading data, incorporating transformations such as Lookup, and Row count to clean the data before import.
• Recognized the fact and dimension tables in the OLAP database and created cubes using (SSAS).
• Involved in the implementation of incremental data transfers from OLTP to the data warehouse using SSIS data flow and control flow tasks.
• Collaborated with the Business Development team to gather requirements and build an OLAP cube using SSAS 2008, featuring multiple dimensions and measure groups, advanced date-based calculations, key performance indicators, and conditional formatting.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Generated Drilldown, Drill through, Crosstab & Summary reports by using SSRS.
• Used Report Builder to generate Ad Hoc Reports.
• Generated complex reports such as Dashboard, Scorecards, and graph-charts.
• Designed and scheduled Report Snapshots in Report Manager to enhance the performance of SSRS reports.
• Deployed reports and cubes across testing, staging, and production environments, and actively participated in the support and maintenance of the report server in a production setting.

Environment: Microsoft Power Bi Premium, MS SQL Workbench, QuickBase, Azure, MS Integration Services (SSIS), MS SQL Reporting Services (SSRS), DAX/DAX Studio, MS Excel, Role Level Security, MS Visio, Report Builder 2.0, Flat Files.

Confidential, Woonsocket, RI

MS SQL BI Developer/ Power BI Developer

Responsibilities:

• Handled Power BI development and administration role.
• Work with the database modeling manager to identify the requisites of a project.
• Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
• Created Normalized and De-normalized entities for the Data Warehouse.
• Designed and developed stored procedures, functions, views, and triggers.
• Worked with Business Development team to gather requirements and create OLAP cube in SSAS 2008. Included multiple dimensions and measure groups, complex date related calculated fields, KPIs, and conditional formatting.
• Generated Drilldown, Drill through, Crosstab & Summary reports by using SSRS.
• Generated complex reports such as Dashboard, Scorecards, and graph-charts.
• Created and scheduled Report Snapshots in Report manager to improve the performance of SSRS.

Environment: Power BI Premium,Tableau, MySQL Workbench, SQL Server, MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS), Power BI, MS Visio, Report Builder 2.0, Flat Files.

Confidential, Hartsville, South Carolina

MS SQL BI Developer

Responsibilities:

• As a member of the BI/Database team, participated in technical design and development processes.
• Responsible for gathering requirements and designing entities and Data Warehouse.
• Developed an ETL process to create jobs for extracting, cleaning, transforming, and loading data into the Data Warehouse.
• Involved in the Migration of Databases from SQL Server 2011 to SQL Server 2019.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, and XML File.
• Participated in the creation of multiple parameterized stored procedures utilized by reports to access data.
• Developed OLAP cubes by identifying fact and dimension tables, as well as the associated data source and data connection.
• Created Drill-through reports, parameterized reports and linked reports using SSRS.
• Generated subscription of Reports.
• Created reports in various format such as PDF, Power Point and Excel.
• Implemented security measures for reports by setting up role-based security accounts, assigning user authorization at the home and project levels, managing Reporting Services roles, and implementing role-based security.

Environment: MS SQL Server 2011, Erwin, T-SQL, MS SQL Integration Services (SSIS), Power BI, MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS) Snowflake, MS Excel, XML.

Confidential, Sandy Springs, Ga

Power BI Developer

Responsibilities:

• Worked in gathering the user requirements, involved in meetings, reviews, and prepared detailed design document.
• Responsible for performing basic developer task like creating, altering, and dropping tables.
• Retrieved vast amounts of inventory data from data warehousing tables, which were stored in datasets, and serialized the data into XML documents.
• Retrieved vast amounts of inventory data stored in SQL Server 2005 data warehousing tables for reporting and other backend processes using C# and ADO.NET objects such as datasets and serialized the data into XML documents.
• Successfully executed schema change scripts on existing objects to align with evolving business rules.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created, tested, and debugged T-SQL stored procedures for the data layer using SQL Server data adapter, and optimized SQL queries.
• Created Ad hoc reports using SSRS and Created Subscriptions and scheduled reports using subscriptions.

Environment: MS SQL Server 2005, Power BI Erwin, T-SQL, MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSRS), Oracle 9i, MS Excel