SUMMARY

• Over 7+ years of IT experience in Data Analysis, Design, Implementation, and support of Business Intelligence using Power BI, SQL, PL/SQL and Data modelling.
• Microsoft Certified Power BI Data Analyst Associate.
• Developed complex reports and dashboards using Power BI Desktop and Power BI Service based on the end - user requirements.
• Design, develop and implement reporting and dashboard solutions using Power BI Desktop and Power BI Service.
• Performed data modelling using Power Query in Power BI.
• A high level of proficiency in Data Analysis Expressions (DAX) in Power BI.
• Good knowledge in M query language to process data in Power Query Editor.
• Expertise in Power BI, Power BI Pro, and Power BI Mobile.
• Experience in installing and configuring gateways in Power BI Service.
• Experience in implementing Row-Level Security in Power BI. Additionally, good knowledge on Power BI licensing and admin portal.
• Well versed in calculated columns, tables, and measures in Power BI desktop.
• Good knowledge on all types of transformations available in Power BI query editor and DAX functions.
• Created Bookmarks in reports for dynamic visualization.
• Implemented incremental refresh on huge volume of dataset.
• Well versed in building and deploying reports/dashboards in Power BI Service.
• Experience in creating various reports like table, matrix, drill down, drill through, parameterized, cascaded, linked and sub-reports.
• Experience in configuring and maintaining Report Manager and Report Server for SSRS. Deployed and scheduled the reports in Report Manager.
• Experienced in generating ad-hoc and data driven subscription reports using Report Builder.
• Experience in writing expressions and fine tuning the reports.
• Created PowerApps using wide variety of data connectors along with Common Data Service (CDS) to demonstrate KPIs and data visualizations.
• Used PowerApps for designing Canvas Apps.
• Connected to RDBMS using Direct Query mode while the dataset is very large.
• Developed Power Automate flows to automate tasks involving various data sources.
• Presented Power BI dashboards, reports and PowerApps in customer demos and helped them understand the KPIs.
• Good working knowledge on Extract, Transform & Load (ETL)packages and SSIS packages for integrating data using various connections from heterogeneous sources like Excel, CSV, Oracle, Flat file, Text file and XML by applying multiple transformations like data conversion, conditional split, bulk insert, merge, pivot, union all, and slowly changing dimension.
• Implemented Row Level Security(RLS) and Page level security in Power BI Desktop and Power BI Service.
• Experience in designing, deploying, data conversion and data migration using SSIS from different databases like SQL server, Oracle, MS Access, and flat files.
• Expert in developing, monitoring, extracting, transforming, and loading data using SSIS, Import Export wizard, and bulk insert.
• Experience in writing complex T-SQL queries using various functions like numeric, date and string functions.
• Performed various joins like Inner, Outer, Self joins on huge databases to slice and dice the data for later business analysis and report design.
• Built several database-core objects like Stored procedures and Views to use in repeated data extractions.
• Extensively worked with Azure Blob Storage by loading data into it and connecting to it in Power BI to create reports.
• Refined complex data from multiple Azure sources like Azure SQL database, Azure HD Insights and Azure Blob Storage and used it to create effective dashboards in Power BI.
• Extracted and transformed data from huge Azure Data lakes(ADL) and used that data back in SSRS and Power BI to create wide variety of reports.
• Cleaned data into Azure Data Factory(ADF) and perform the ETL operations directly in the cloud.
• Good Confidential File handling using read, write delete functions.
• Having good knowledge on Python and its libraries like Numpy, Pandas and Matplotlib.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

TECHNICAL SKILLS

Reporting Tools: Power BI, SSIS, SSRS

Databases: SQL Server 2012/2008/2005/2003

Web Development: HTML, JavaScript, jQuery, JSON, Bootstrap, Angular JS

Operating Systems: Windows, Linux/Unix

Versioning Tools: Visual Source Safe and SVN Tortoise, Team Foundation Server.

Standards: MS Word, MS Excel, MS PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, Mechanicsburg - PA

Sr Power BI Consultant

Responsibilities:

• Organized meetings to gather business requirements from business users.
• Designed the logical model with Erwin based on business requirements.
• Maintained data integrity with the creation of constraints and DML triggers.
• Wrote SQL queries and stored procedures to generate data for reports from various sources. created a multitude of reports using Power BI desktop with a variety of visuals such as charts, tables, slicers, gauges.
• Wrote DAX expressions to create new measures, calculations per business requirements.
• Implemented row-level security and groups to restrict data access in Power BI reports.
• Integrated custom visuals based on business requirements in Power BI Desktop.
• Utilized Power BI gateways to configure data refresh of Power BI data models.
• Optimized reports with modifications to embedded queries and/or stored procedures.
• Utilized the PBI interface to organize reports, data sources, schedule report executions, and track report history.
• Conducted JRD meetings to gather business requirements from business users and SMEs.
• Conceptualized and designed data marts involving bottom-up approach and star schema.
• Designed and optimized complex stored procedures to perform data profiling and auditing in the pre-staging database.
• Formulated stored procedures to perform index maintenance and data profiling for loading data marts and generating report datasets.
• Created stored procedures and functions to implement the business logic for interfacing with parameterized reports.
• Utilized Power BI to amplify data visualizations with interactive sharing, collaboration, and data management.
• Configured parameters and functions to extract data from Web APIs within Power BI reports.
• Implemented data blending, groups, calculated fields, and aggregated fields to analyze data in Power BI.
• Utilized Power BI gateways to configure data refresh of Power BI data models.
• Performed troubleshooting of performance issues that were associated with Power BI reports.
• Implemented drill-up, drill-down, drill through in Power BI Desktop.
• Prioritized and managed work items, tasks as per stack ranks on Team Foundation

Environment: Power BI, DAX, Power Query, SQL Server, T-SQL, Erwin, MS Excel, SQL Profiler, MS Azure

Confidential, Plano -TX

Power BI Consultant

Responsibilities:

• Collecting data from primary and secondary data sources using from Microsoft SQL Server, MS Excel
• Data and Document detailed designed as per requirement in Business intelligence
• Created tables, stored procedures, views, indexes, Triggers, Constraint, temporary tables and user-defined data types and functions using T-SQL
• Developed logically and physical Data Models by using ER and Normalize or Denormalize according to Business requirements.
• Gathered Business requirements and translated objectives into actionable Dashboard and analytics.
• Involved in designing the data model and implemented the star schema for QV better optimization.
• Writing an MDX / DAX Functions for data Manipulation and Transformation for efficient data visualization in Power BI.
• DAX is a component of the BI Semantic Model. That makes it Related to both SQL and MDX.
• DAX is a set of Functional expressions used to connect disparate data across mostly TABULAR data models.
• Designed and developed ETL jobs or extracts to pull the data from multiple sources required for the Visualizations
• Tune ETL code and reports to the optimum performance possible
• Created SSIS Packages to executed ETL data messaging operations for data profiling, cleansing, and verification.
• Experience in used Excel / CSV /Text files to generated reports.
• Used Quick Filters, sets, parameters, and calculated fields on Tableau Reports.
• Created development of business intelligence solutions using Power BI
• Generated scorecards with executive summary dashboards to display performance monitoring measures with Power BI.

Environment: Power BI, DAX, MDX, ETL, SQL Server 2016, T-SQL, MS Excel, MS Azure

Confidential

Power BI Developer

Responsibilities:

• Responsible for Creating and Modifying T-SQLstored procedures/triggers for validating the integrity of the data.
• Involved inSQLperformance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Extensively worked on Views, cursors, CTE's, schemas, permissions issues with client/server database design.
• Designed and developed variousSSISpackages (ETL) to extract and transform data and involved in SchedulingSSISPackages.
• PerformedSSISDevelopment and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel,SQLServer, Raw File, and DB2 into the data warehouse.
• Responsible for month end maintenance activities and large data pulls from COSMOS and CUBES usingSSISpackages and scope scripts.
• Extensively usedSSISImport/Export Wizard, for performing the ETL operations.
• Played Key role in team of ETLdevelopersfor re-writing DTS packages and updating them toSSIS packages.
• Regularly worked/used TFS and did Incremental Load using For Each Loop, Sequence containers, Script Task, Conditional split, Data Conversation, Derived Column, Lookup, Merge/Merge Join, Union all and so on in Visual Studio.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSISPackages.
• Created ETL packages with different data sources (SQLServer, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations usingSSIS/DTS packages.
• Created PowerBIDashboards to show KPI's in the project.
• Built and Monitored Executive reports usingSSRSfor executive team to track progress and other Audit KPI.
• Created AD-Hoc reports using Report Builder and maintained Report Manager forSSRS.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through usingSSRS.
• Created parameters (multi value, hidden, default etc.) for the required fields using the report designer to see the dropdowns in the end report.
• Create reports in PowerBIpreview portal utilizing theSSASTabular via Analysis connector.
• Created stored procedures to build the Fact tables in the data mart for multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports usingSSRS.
• Designed Dimensional Modeling usingSSASpackages for End-User. Created Hierarchies and defined Dimension Relationships.
• ExportedCrystalreportsinto various Formats like PDF, Excel and Word for the Users.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX andSQL.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Created Stored Procedures to transform the Data and worked extensively in T-SQLfor various needs of the transformations while loading the data.
• Documented all the work and all the process of integration and reporting services for further references.

Environment: SQLServer 2012,SSISSSRS,SSAS, Visual Studio, MS PowerBI, T-SQL.

Confidential

SQL Developer

Responsibilities:

• Designed and developed various SSIS packages to extract and transform data and involved in Scheduling SSIS Packages.
• Created efficient SSIS packages for data movement and loading with error checking and well-documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data-to-data warehouse databases and deployed with minimal changes using XML configuration file.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting application.
• Create Web and Console applications using Visual Studio 2012, C# .NET framework.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Designed reports with sub reports, expressions and queries, prepared Ad-Hoc reports using report builders.
• Implementing SSRS solutions, used dashboards and gauges to enhance for the business users.
• Worked on Development and implementation of SSRS reports and ran them as per the requirement.
• Generated daily, weekly, and monthly reports for the managers.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources, established the connections using SSIS, and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.

Environment: SQL Server 2008/2012, SSRS 2012/2008, SSIS 2008, SSAS, T-SQL, Excel, Access, Windows 2000/XP