PROFESSIONAL SUMMARY:

• Over 6 years of experience as a Business Intelligence Developer and D Analyst in Development and implementation of Client server Applications and data system
• Involved in Full life - cycle Implementation which includes Requirements Gathering, Analysis, development, Testing Process, Production environment with support of Data Flow and Process Models
• Extensive knowledge in BI Design and Development, maintenance of I.T business applications using cutting edge software solutions.
• Experienced in using Microsoft BI Studio reporting tools as Power BI and products like SSRS and SSAS
• Outstanding knowledge on building and deployment of reports either by native browser mode generating subscriptions or share point integration mode by using SQL Server reporting service
• Extensively involved in activities like understanding the client requirements, Business Analysis, data analysis, preparing various project documents required for demonstrations
• Strong understanding of BI application design and development principles.
• Good understanding and working knowledge on cloud-based solution tools like Power BI in creating and publishing reports
• Applied technical skills using SQL in data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner
• Strong communication and management skills with excellent role-playing capabilities

TECHNICAL SKILLS:

Technology: Microsoft Business Intelligence Tools

Languages: SQL

Reporting Tool: Power BI, Tableau, SQL Server Reporting services

Databases: SQL Server, Advanced Excel, MS Project

EXPERIENCE:

Confidential, NJ

Power BI Lead / Developer

Responsibilities:

• Extensively involved in development and supporting of design for Power BI Dashboard Reports for various risk areas as per mappings provided across different countries that are within the scope of the project.
• Involved in analyzing the Technical aspects of Business requirements, converting them to Functional requirement specifications to facilitate development and maintenance of the Power BI reports
• Create report visualizations via data mapping the source field columns from ETL-BI aggregates to AAS Tabular model
• Capable in defining KPI’s, logic calculations in development of different measures and calculated tables in AAS cubes, Power BI Datasets modelling that enabled visual interactions to perform better in terms of functionality in the reporting layer
• Ability to Create Dashboard Reports by making data source settings to wide range of connections like Live Azure Analysis services, Excel, SQL DB etc.
• Extensive knowledge in Developing different kinds of visualizations on report dashboards including bar charts, Scatter plots, Matrix visuals, Heatmaps, Line and clustered charts, donut charts, card visuals etc.
• Well versed and familiar in using all the Interface features of Power BI Desktop app like Filter selections, Format and Analytics components, Selection panes, Bookmarking, sync panes during development of reports.
• Capable of creating workspaces and Power BI Apps to host and publish the reports
• Ability to troubleshoot various report UI bugs encountered during System testing and providing quick fixes
• Worked on Preparing Unit test cases/ SQL Queries for the components developed in Power BI Reports.
• Involved in Production Deployment of Power BI Reports to Service and managed access to datasets, reports via role-based user management
• Involved in development of several POC’s to test the functionality of the business requirement using Dax functions.
• Knowledge on implementing Power BI Report templates and Themes
• Worked on Azure DevOps tools Visual Studio Online Services to maintain the development code for AAS and Power BI via Source control systems.
• Capable of handling various Operational and Project related settings in DevOps to create projects and perform bulk uploading of tasks via team settings, Creation of different work items, backlogs etc.
• Created Deployment checklists, Object lists and release notes as part of Production release activities for Publishing Power BI Reports to Service.
• Knowledge on Azure analysis Services Dimensions, Facts, Measures and data relationships in Tabular model design
• Ability to understand the Cube Design, data source views and deploying of Cubes via Azure analytical services

Environment: Microsoft Power BI Desktop / Service, SSDT, SSMS, SQL Server

Confidential

Data Analyst BI

Responsibilities:

• Extract and Analyze data from internal databases to inform Business Decisions and actions to generate reports using MSBI tools
• Extensively involved in supporting and development of design of reports
• Involved in Data Analysis for source and target systems, understanding data design and data mapping of columns to facilitate report development
• Expertise in generating reports using SQL reporting services and MS Excel spread sheets
• Designing enterprise reports using SQL server reporting services (SSRS) generated Drill down Reports, Parameterized Reports, Linked Reports, Sub-Reports, Matrix Dynamic and Filter Charts
• Experience in creation of ad-hoc reports, data driven subscriptions reports by using report builder in SSRS
• Coordinated Statistical Data Analysis and Design Flow Process
• Experience in logging, error handling by using event handler component in SSIS packages and custom logging based on the requirements of the project
• Configured error output in data flow to redirect the error records
• Created various visualizations tiles and published over to power BI server to enable multi- user access
• Embedded Power BI reports for the work force data and provided access by assigning roles
• Good understanding and knowledge on DAX queries in Power BI to satisfy business needs

Environment: SQL Server, MS Visio, Power BI

Confidential

Data analyst logistic management

Responsibilities:

• Evaluate, design and implement enterprise level business decisions to deploy meaningful solutions
• Source information from multiple upstream data sources including flat files, excel files
• Involved in support for creating SSIS packages using various transformations like Fuzzy Lookup, Conditional Splits, Aggregates, Execute SQL and Data flow tasks to extract data from discrete sources like SQL server, Excel
• Design, build, deploy and test reports using SSRS and provide data visualizations to the users
• Created Reports based on requirements using report parameters like Queried, Non-queried, Multivalued and cascaded
• Well versed in using different features of the Report Builder like expression editor to produce differential reports based on parameters
• Deployment of reports to report server in SSRS using subscriptions allowing visualization possible for different users across the departments.
• Knowledge on Data visualizations using tableau software to analyze and interpret results allowing management to make key decisions
• Designed rich graphical visualizations using Tableau scorecards, dashboards and Gantt charts
• Data visualizations using tableau software to create box and whisker plots, scatter plots to analyze and interpret results allowing management to make key decisions
• Good understanding of Data warehousing concepts like dimensional modelling and staging tables

Environment: SQL Server 2012/2016, SSMS, SSDT

Confidential

Business Intelligence Data Specialist

Responsibilities:

• Requirement Gathering, Performed needs assessment, Impact Analysis with Business Users for reporting and analytical projects
• Analyzed data flow and gathered Business requirements to create design documentation
• Participated in translating some key Business requirements into technical specifications.
• Worked closely with business users to define reporting requirements and documenting the requirements to design, develop and maintain, and secure BI reports
• Reported data for current and previous fiscal year and Plotted Bar graphs and pie charts to enable the users compare the performance of the Business Unit using SSRS
• Worked on tuning the queries and fixing the Stored Procedures to get data consistency while pulling data for reporting
• Involved in Creating and delivering presentations to various business teams regarding the status and key decisions of business issues.
• Designed reports using 2-3 level Cascading Hierarchical Parameters enabling users the choice of dynamism
• Performed data analysis and explored data visualization techniques on a variety of data stored in spreadsheets and text files using combination of integration and reporting services

Environment: SAGE, SQL Server, SSDT, SSRS