SUMMARY

• 8+ years of IT experience as Business Intelligence Developer, Power BI Developer, Tableau Developer, SQL Developer, User/DB Management, and Installation & Configuration on different server environments.
• I have developed strong abilities in data migrations, developing large SQL queries and business intelligence reporting on different tools like Tableau, Power BI, and Web Focus.
• I worked in different domains which consist of huge data, and I am extremely analytical with excellent problem - solving skills.
• Strong knowledge of working with MSBI, Azure Cloud to retrieve data to support daily Business Intelligence operations and BI processes.
• Knowledge of Data Warehousing methodologies Entity-Relation Diagrams (ERD), Logical and Physical data models, star schemas, snowflakes, dimensional modeling (fact - dimensions)
• Exposure of working on data at different stages with various architectures and teams
• Experience in handling data sources like SQL Server, Oracle, Excel, CSV, Flat, JSON files
• Accessed unstructured via Azure and had Power BI reports using OData feed connection to take Data entities of Dynamics 365 as data source to create reports.
• Expertise in data cleansing using Query Editor, formatted data and established relationships to build models.
• Leveraged DAX in Power BI to compute data and create new columns and measures.
• Developed visual reports, interactive dashboards on Power BI Desktop and Service.
• Utilized Page Level, Report Level and Visual Level Filters, Slicers, Drill down capabilities.
• Utilized Power BI Service/Gateways to schedule data refreshes on dashboards/reports.
• Implemented row level security (RLS) to provide report access to specific user groups in the organization with DAX expressions.
• Good understanding on custom visuals and importing visuals from Microsoft AppSource
• Hands on Data governance activities as data quality, lineage, profiling
• Excellent knowledge of entire SDLC methodologies in Waterfall and Agile, followed best practices in Scrum, participated in Grooming, user stories, acceptance Criteria, story points.

TECHNICAL SKILLS

Methodologies: SDLC, Agile, Scrum, Waterfall

Databases: SQL, MS Access, SQL server 2008, Oracle, Postgre SQL

BI Tools: Power BI, Tableau, Sequel Viewpoint, Micro strategy

ETL Tools: Alteryx, Informatica, SSIS

Domain Knowledge: Finance & Banking, Retail & Managed Services.

Utilities: MS Office Suite, MS Project, MS Visio, Share point, Advanced Excel

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

Responsibilities:

• Develop scorecards and dashboards in Power BI and create stored procedures from the source systems.
• Gather requirements to support ad-hoc analysis for senior management.
• Creating Dashboards and Scorecards using Power BI Desktop.
• Integrate the data sources and standardize the process across different cross-functional teams.
• Designed and developed automated solutions in Power BI which are tailored to the requirements of the stakeholders.
• Creating reports using Power BI Report builder.
• Performed root cause analysis on various data sources by reverse engineering the data from the source systems like SAP and Salesforce
• Understanding the requirements for creating projections and models based on historical data.
• As per business requirement, created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Performed data extraction and validation, applying rules transformation in the flow of data from source to target.

Environment: Power BI, Microsoft SQL Server, SAS, Salesforce, Oracle, Excel, JSON files

Confidential, Randolph, MA

Tableau Developer

Responsibilities:

• Designed and created data visualizations (reports and dashboards) as required to support clinical, financial and operational needs.
• Analyzed requirements, developed, and created documentation for dashboards.
• Championed dashboard quality, consistency, usability and reliability by documenting and applying best practices to their design and development.
• Communicated project status, updates, and recommendations to stakeholders.
• Established standards and best practices for requesting, prioritizing and developing dashboards.
• Collaborated with technical staff and end-users to understand and troubleshoot platform issues and developed appropriate solutions.
• Defined the best practices for creating Tableau dashboards by having a deep understanding of business requirements.
• Developed Ad-hoc daily reports using Tableau Desktop, Excel and also set up daily report e-mails to the client every morning.
• Discussions with the team to decide on the charts to be chosen, color patterns as per visualizer’s needs, standardizing dashboard and size after discussing with the clients.

Environment: Microsoft SQL Server, Tableau Desktop 10.x, Tableau Server, Flat Files, Excel, Windows 10

Confidential

Data Analyst

Responsibilities:

• Developed and maintained executive, enterprise level analytics solutions and reports using Power BI Desktop and hosted in Power BI Report Server.
• Defined and followed Power BI development best practices.
• Used SQL Server including the ability to optimize queries to efficiently retrieve data.
• Created and maintained Power Pivot models, datasets and data flows using best practices
• Provided system support for the Power BI Report Server environment (application administration for both the development and production environments)
• Managed report security, folder security, database row level security, report schedules and distribution.
• Worked with complex queries, using specialized business technologies and applications in the Microsoft stack, such as DAX Studio, Tabula Editor, and Power BI Report Builder.
• Performed unit testing to validate the accuracy and validity of reports and data integrity.
• Provided user (business and client) training in BI reporting tools and reports as needed.
• Troubleshooted and resolved data integrity and performance issues.
• Communicated issues, risks, and concerns proactively to management.
• Creating Dashboards and Scorecards using Power BI Desktop.
• Worked with business and technical teams to gather and define requirements, concise. functional/technical documentation and provide project status updates.

Environment: Tableau Desktop 10/9.x, Tableau Server, Microsoft SQL Server 2012, SAS, Oracle, Excel, Windows 7/8/10.

Confidential, New York

Business intelligence SQL Developer

Responsibilities:

• Worked closely with BI team to develop data infrastructure to provide access to information and expand reporting capabilities.
• Worked with Business Intelligence tools such as Power BI to develop reports and provide data to users.
• Created and leveraged analytical approaches to perform analysis of domain specific source data to provide accurate statements and conclusions.
• Worked with senior management team and operation-level managers to design and maintain sales and operations-based metrics.
• Reviewed and evaluated existing data sources and analyzed conversion steps required.
• Designed, developed and maintained SQL scripts, code, and queries for data translation, conversion and reporting.
• Experience in designing data models, schemas, dimensional models, complex reports and dashboards.
• Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, and Matrix reports using Power BI Report Builder.
• Responsible for providing full Power BI service administration - user management, workspace management, gateway administration, data source creation, monitoring, and troubleshooting.
• Planned along with senior management new ways to increase revenue and minimize errors.
• Developed and maintained/automated monthly campaign performance reports and helped in increasing reporting efficiency by 60%.
• Providing technical assistance to users and monitoring performance of BI systems.
• Participated in team-building activities to enhance working relationships.

Environment: Microsoft SQL Server, Power BI, MicroStrategy, Sequel viewpoint, IBM, Flat Files, Excel, Windows 10

Confidential, Boston

Business intelligence Analyst

Responsibilities:

• Involved in creating database objects like tables, views, procedures and functions using SQL to provide definition, structure and to maintain data efficiently.
• Tested, Cleaned, and Standardized Data to meet business standards using SQL task
• Created Tableau Dashboards and reports with interactive views, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Assist in Report Power BI Server administration, including maintaining the library of reports, security access to the reports, and offer training and consultation in report development.
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau workbooks from multiple data sources using Data Blending
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Migrated Crystal report to Power BI Report Builder in Microsoft Power BI Report Builder.
• Created Procedures for Report Scheduler according to monthly, weekly or daily.
• Interacted with existing database developers and DBA to understand existing schema.

Environment: Microsoft SQL Server, Oracle, Tableau, Excel, Windows 10

Confidential

Jr.SQL developer

Responsibilities:

• Monitored and tuned database resources and activities for SQL Server databases.
• Performed and automated SQL Server version upgrades and patch installs.
• Designed, developed and maintained relational databases Developed, implemented and maintained enterprise business information systems.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients
• Work on support tickets, maintenance tasks and assigned projects at discretion of Reporting Coordinator.
• Gathered business requirements and converted it into SQL stored procedures for database specific projects.
• Maintained data integrity and database structure including tables, views, and triggers.
• I worked with application developers and provided necessary SQL Scripts using T-SQL.

Environment: Postgre SQL, Flat Files, Excel, Windows.