SUMMARY

• Around 8+ Years of real time experience in business intelligence lifecycle projects from requirement gathering, documentation, data analysis, modeling, development, testing, production, deployment, and support.
• Strong knowledge in Power BI using SQL Server.
• Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging and Maintenance of Power BI Applications.
• Strong experience in synthesizing the Business Requirements, Data Models and determining Key performance indicators to evaluate key factors crucial to the success of the organization.
• Strong Knowledge in designing and creating dimension and cubes with Snowflake and STAR schema using SSAS.
• Implemented complex query techniques of passing Multi - Valued parameters and cascading parameters in MDX.
• Skilled in creating measures, calculated columns and performing time series analysis using DAX in Power BI.
• Created reports like parameter-based reports, graphical reports, excel reports, drill-down chart using SSRS and tabular report and generated on-demand and scheduled reports for business analysis using SSRS.
• Responsible for creating Power BI reports and deploying it to Power BI Services.
• Created the Dashboards and Shared it to user groups using Power BI Apps.
• Performed time series analysis using DAX expressions in Power BI.
• Used Power BI to create self-service BI capabilities and use tabular models.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data into Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.
• Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
• Performed configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards .
• Experience in developing and maintaining SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Teradata, Flat files.
• Experience with creating ETL processes from source and link data to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies that drive value.
• Experience in developing interactive Web applications using HTML/HTML5, CSS/CSS3, JavaScript, JQuery and Bootstrap for Business Intelligence domains and repositories.
• Hands on experience using the version controls like GIT, project management tools like JIRA, Team Forge.
• Responsible for Checking Cross Browser Compatibility of HTML files and tags, thus worked on different browsers like Internet Explorer, Google Chrome, Firefox for ensuring responsive web design.
• Worked on configuring various data adapters for MySQL, Oracle, SQL Server, Teradata, Flat, Delimited Files, Lotus Notes, JSON.
• Knowledge of full software development cycle, including code reviews, source control management and working knowledge of Agile.
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Experience in Retail Banking Application.

TECHNICAL SKILLS

Power BI Tools: Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS

BI Tools: Power Bi, Tableau, OBIEE, SSRS, SSAS and ETL, Informatica

Databases: MS SQL Server, Oracle, MS Access, MySQL, Snowflake and SQLite.

Operating Systems: Windows, UNIX, Mac OS

Languages: C, C++, SQL, PL/SQL, T-SQL, and Python

Project Methodologies: Agile (SCRUM), Waterfall and Iterative

PROFESSIONAL EXPERIENCE

Sr. Power BI Lead Developer

Confidential, Sunrise, FL

Responsibilities:

• Worked closely with various teams across the company to identify and solve business challenges.
• Gathering and Analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Import data from different data sources to create Power BI reports and Dashboards.
• Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements
• Transform, define, navigate the data from data source and performed merge and append queries using Power Query.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Performed different types of context like Row context, filter context and query context using Power BI Desktop.
• Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
• Performed Query Folding using Power Query to filter data in the data source server.
• Created different chart types and drill down reports using Power Bi Desktop (SSRS).
• Involved in defining report layout in SSRS.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimensions hierarchies in SQL server.
• Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI.
• Published reports and visualizations to Power BI Service and thereby created dashboards.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data into Power BI for creating reports.
• Managed huge volume of data by creating weekly partitions in SSAS models.
• Used different type of slicers available in Power BI for creating reports.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Shared the created workspace across the organization using PowerBI Apps.
• Responsible for creating Row-Level Security (RLS) based on the business requirements.
• Created complex stored procedures and scripts in SQL Server.

Sr. Power BI Admin/Developer

Confidential, Sunrise, FL

Responsibilities:

• Monitored and controlled the design and development of reporting data modules.
• Developed mockup for each report to better analyze, understand and discuss with clients to enhance the visibility.
• Used Power BI Desktop extensively to integrate the custom visuals to support complex business requirements.
• Developed and implemented complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support the Power BI and SSRS reports.
• Worked on continuous maintenance and development of bug fixes in BI reports.
• Gathered and documented the business requirements for analysis and created analytical reports.
• Actively participated and conducted requirement meetings and data mapping sessions to understand business needs.
• Identified and documented the detailed business rules.
• Building, publishing customized interactive reports and dashboards, report scheduling usingPower BI.
• Involved in developing the end to end ELT pipelines for migrating the on-premises Oracle database to Azure SQL Data warehouse.
• Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs.
• Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the Power BI dashboards.
• Worked on various tasks and transformations in SSIS likeExecute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookupwhile loading the data into Destination
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• 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 with 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.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, and line better business analysis.
• Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.
• Provide leadership and direction across the Configuration management, Integrations, incident management and Support issues.

Sr. BI/MSBI Developer

Confidential, New York

Responsibilities:

• Analyzed business requirements, facilitating planning and implementation phases of the OLAP model in JRD meetings
• Participated in JAD meetings to ensure a common understanding with business, development and test teams.
• Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times.
• Performed data cleansing and scrubbing in the staging database.
• Created SSIS packages to implement error/failure handling with event handlers, row redirects, and loggings.
• Implemented a master-child package model to improve maintenance and performance.
• Configured packages with parameters to acquire values at runtime.
• Optimized SSIS packages utilizing parallelisms, fast load options, buffer sizes, and checkpoints.
• Managed packages the in SSISDB catalog with environments; automated execution with SQL agent jobs.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Created data models and data flow diagrams for the to-be process.
• Implemented new and complex calculated members in cubes improve report performance.
• Designed SSAS cube objects such as KPIs, aggregations, perspectives, and translations.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Optimized report performance with caches and snapshots.
• Proactively resolve issues to drive quality and system performance improvements across the application
• Participate in cross-team information sharing resources and work to identify risks early in the development process
• Implemented TFS for project version control and change management with bug tracking.

Environment: Microsoft SQL Server 2012, SSDT, SSMS, T-SQL, SSIS, SSRS, SSAS, Power BI, SharePoint, TFS, DTA, Tableau, Visual StudioSr. SQL Server/ BI Engineer

Confidential, Des Moines, IA

Responsibilities:

• Extensively involved in designing theSSIS packagesto export data of flat file source to SQL Server database.
• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing the physical design for the database.
• Responsible for drafting documentation for describing the metadata and writing technical guides.
• Created StoredProcedures,Triggers, Views and SQL Joins and other statements for various applications.
• Involved in creatingSSISjobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from theOLTPtoOLAPwith the help of SSIS.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
• Involved in designing cubes inSSAS environmentusing Snowflake/ and Star Schemas.
• Thorough understanding of first NF (1NF), second NF (2NF) and third NF (3NF).
• Extract Transform Load(ETL) development using SQL Server 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration ofSQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports usingSQL Server Reporting Services 2008.
• Created SQL Server Analysis Project usingMS SSAS 2008.
• Querying and manipulating multidimensional cube data throughMDXScripting.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created complexSSAS cubeswith multiple fact measures groups.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, Tablix, matrix reports inSSRS (SQL Server Reporting Services)like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Wrote the expressions inSSRS.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implementedParameterized and cascadingreports using SSRS.
• Developed data model based on the BA’s and the reporting Team usingSSAS, SSRS.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multidimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Played a major role in production support of SSAS(cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, MS PowerPoint, Tableau, OLAP, OLTP, MDX.

SQL Developer

Confidential

Responsibilities:

• Created functional/non-functional requirements via JAD sessions.
• Designed data integration process and collaborate with business analyst for various project needs.
• Developed complex stored procedures and functions to perform data profiling and business calculations.
• Modified the OLTP database structure per changes in the business process.
• Wrote queries with joins and common table expressions to simplify complex queries involving multiple tables.
• Optimized the logic in procedures, functions, and triggers.
• Enhanced the performance of inefficient queries with SQL profiler and DTA.
• Created SSIS packages to perform incremental loads using timestamps.
• Utilized SQL server table configuration to configure package properties.
• Devised complex expressions for calculations, groupings, filters, and formatting contents of SSRS reports.

Environment: s:MS SQL Server 2008, BIDS, SSIS, SSAS, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA, TFS, Power Pivot