SUMMARY

• 7+ years experienced as Data Analyst and BI Reports Developer with an experience in deploying T - SQL queries to validate error reports and preparing T-SQL scripts for the Application team, Reports team during development.
• Proficient in building calculation, measures, and hierarchies to create detail level summary reports and dashboard using Power BI and DAX expressions.
• Generated daily, weekly, monthly and dashboard reports for analysis purposes and created report models for ad hoc reports when the end user wants to see the reports on fly using SSRS.
• Focused, intuitive and competent individual with a knack for completing projects on time.

TECHNICAL SKILLS

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Azure

Storage: BLOB, Tables, Queues, and File Share

Programming: Python, R, Scala

PROFESSIONAL EXPERIENCE

Data Analyst/Business Intelligence Engineer III

Confidential | Redmond, WA

Environment: SQL Server 2016, T-SQL, Python, R, Spyder, SSDT, SQL Profiler, SSMS, DTA, DAX, Power BI, MS Azure, TFS

Responsibilities:

• Coordinated with the business users and subject Matter expert to gather business requirements and transform in technical leads.
• Documented the development process to streamline the development activities.
• Analyzed the data sources and massaged/cleaned the data utilizing Python Script and TSQL queries based on various sources.
• Debugged the SQL queries and fixed /Optimized utilizing converting into Stored Procedures, Index utilization, query execution plan and other best practices.
• Adapted control flow constructs like WHILE loops, IF-ELSE statements within SQL scripts and procedures.
• Consumed data through various sources such as SharePoint online and APIs including exiting RDBMS in Power BI Desktop.
• Consumed the data and developed the Power BI model in Power Bi desktop with use of DAX, relationship (single and both direction) based on the business report need.
• Created various calculated measures and dimension with use of DAX expression such as Time Intelligence (QTD, YTD, Sameperoidlastyear, etc.), DATE, Filter and Statistical Inbuilt functions.
• Used R statistical software for effective analysis by hypothesis testing to validate data and interpretations.
• Developed analytical reports/dashboards from multi-dimensional models to identify critical KPIs via Power BI.
• Implemented gateways to sync data between Power BI service and on premise OLAP system.
• Utilized Power BI to design interactive data visualization using on-premises/azure data sources.
• Integrated custom visuals based on business requirements in Power BI Desktop.
• Refined the Data model utilizing Power BI model with help of Power Query and DAX expression.
• Performed data messaging operations using Power Query editor in Power Bi desktop to clean data per requirements.
• Published Power BI reports to the Power BI self-service and troubleshoot deployment and performance issues.
• Utilized the App workspace and Apps for sharing and collaboration purpose in Power BI service.
• Consumed Data from Azure Analysis service and in premise tabular Model with live mode.
• Implemented the predictive analysis utilizing Python Script and libraries.
• Installed and configured enterprise gateways to setup scheduled model/data refresh of Power BI reports
• Utilized the Online TFS version for Source and version control purpose with the team (UAT, Dev and Production environment)

Sr. Power BI Developer/ Data Analyst

Confidential | Scottsdale, AZ

Environment: SQL Server 2016, T-SQL, Erwin, SSDT, SQL Profiler, SSRS, SSMS, DTA, Power BI, MS Azure, TFS

Responsibilities:

• Consolidated business requirements and specifications for project through JRD sessions
• Documented the development process to streamline the development activities
• Implemented SQL constraints and DML triggers on relational databases to ensure data integrity
• Drafted stored procedures and complex SQL queries to acquire business logic
• Developed analytical reports/dashboards from multi-dimensional models to identify critical KPIs via Power BI
• Implemented gateways to sync data between Power BI service and on premise OLAP system
• Designed reports utilizing visualizations and pinned tiles from reports and insights to create dashboards in Power BI
• Developed user interactive Power BI reports utilizing charts, maps, matrices, slicers, tiles, gauges, and funnel
• Created new hierarchies and managed active and inactive relationships in Power BI data models
• Performed data messaging operations using Power Query editor in Power Bi desktop to clean data per requirements
• Published Power BI reports to the Power BI self-service and troubleshoot deployment and performance issues
• Developed Power BI Apps and deployed to Power BI App workspace to share multitude of dashboards and reports with user groups
• Installed and configured enterprise gateways to setup scheduled model/data refresh of Power BI reports
• Formulated design specification documents for the new reports developed through SSRS
• Deployed SSRS to create, execute, and deliver tabular, matrix and charts reports
• Developed various operational drill-through and drill-down reports using SSRS
• Deploying TFS for version control and change management of BI solution for cross-functional communications.

Power BI Reports Developer

Confidential | Philadelphia Area, PA

Environment: SQL Server 2012, T-SQL, Erwin, SSDT, MS Excel, DTA, Power BI, TFS

Responsibilities:

• Collaborated with project managersduring JRD sessions to gather system specification requirements for the project
• Designed logical Dimensional Model for the new data mart utilizing Erwin
• Maintained referential, domain, and column integrity utilizing multiple options
• Created and optimized stored procedures to support front end and reporting applications
• Adapted control flow constructs like WHILE loops, IF-ELSE statements within SQL scripts and procedures
• Implemented error handing techniques liketry catch and error functions to create robust T-SQL code
• Optimized SQL queries by reviewing execution plans to optimize performance
• Implemented package configurations with package and project level parameters
• Developed reports using complex formulae and queried the database to generate different types of ad-hoc reports using SSRS
• Reviewed existing SSRS reports and recreated them in Power BI desktop
• Utilized Power BI to design interactive data visualization using on-premises/azure data sources
• Integrated custom visuals based on business requirements in Power BI Desktop
• Refined the Data model utilizing Power BI model with help of Power Query and DAX expression
• Formulated dashboard reports to support end users using SSRS.
• Managed different versions of code with Team Foundation Server (TFS) to support project coordination

BI DW Developer

Confidential | Franklin,TN

Environment: SQL Server 2012, T-SQL, SSAS, SSRS, SSDT, Erwin, Windows Server, Power Pivot, Power View

Responsibilities:

• Gathered system specification requirements for the project by conducting JAD sessions
• Performed normalization and de-normalization of existing tables, thereby improving query processing
• Created database objects such as stored procedures, triggers, cursors, indexes, functions, and views
• Created constraints and triggers to ensure database consistency
• Implemented error handling techniques including RAISERROR, system variables, and try-catch in SQL
• Created SSAS cubes to facilitate the reporting of business based on previous/current data
• Designed sub, drill-down, summary, and matrix reports in SSRS
• Identified slow executing SSRS reports and optimized embedded queries or stored procedures to generate reports
• Designed SQL queries to generate the drill down/drill through, sub-reports with SSRS to present detailed summary data
• Rendered reports in multiple formats as per business requirements utilizing subscriptions
• Developed dashboards and scorecards with Power View for business analysis
• Created analytical reports/dashboards from multidimensional models to identify critical KPIs utilizing Power Pivot

Report Developer

Confidential, Spokane, WA

Environment: SQL Server 2008 R2, T-SQL, SSRS, BIDS, MS Visual Studio, Erwin, MS Excel, TFS

Responsibilities:

• Coordinated with the business users in order to gather business requirements
• Defined multiple constraints in the logical phase of the Data Modeling Life Cycle
• Created and managed schema objects such as tables, views, indexes, and referential integrity
• Implemented temporary tables, indexes, execution plan, resolve parameter sniffing problem to optimize SQL queries
• Modified temporary tables, indexes, and lookup techniques to optimize stored procedures
• Developed OLAP cubes with multiple fact, dimensions, hierarchies, calculations using SSAS
• Delivered on-demand and scheduled reports for business analysis in SSRS
• Scheduled report deliveries to multiple users utilizing subscriptions (standard/data driven)