SUMMARY

• Dynamic, team spirited, and performance driven professional with 8 years of experience in IT industry.
• Comprehensive and strong skills in SQL development, SQL Server, data warehouse (DWH) designing, building and implementing custom interfaces in domains such as POS, Reporting, finance, and insurance.
• 9+ years of hands on experience as Business Intelligence (BI) Analyst creating dynamic and intuitive visualizations with Power BI, and SQL Server Reporting System (SSRS).
• Designed and developed Power BI graphical and visualization solutions with business requirement.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Worked Extensively on Power BI tool. Have good exposure to other BI tools like Tableau
• Involved in setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway, giving admin access to users
• Help UAT users in setting up test instance for testing the reports
• Collaborate with cross functional teams and stakeholders to resolve data quality and operational issues and ensure timely delivery of work product
• Skilled in importing, shaping and transforming data in Power BI.
• Embedded Power BI reports on front end portal page and managed user level access using roles.
• Experienced in Data Analysis Expressions (DAX) functions to create measures in data model in Power BI.
• Efficient with Data Manipulation Language (DML), Data Definition Language (DDL) for creating Tables, Stored Procedures, Views, Indexes, User Defined Functions.
• Created stored procedures, functions and packages for moving the data from staging area to data mart.
• Expert in debugging, logging, error handling and event handling for SSIS Packages.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Quick learning capability, delivering solutions as an individual and a good team player.
• Having a zeal for reporting, out of the box thinking competence.
• Good understanding and exposure to Software Development Life Cycle (SDLC) methods like Water and Agile, Process Documentation, Data Organization, System Documentation, and Report Writing.
• Working knowledge on Team foundation server (TFS)
• Working knowledge on JIIRA

TECHNICAL SKILLS

Tools: MS SQL Server Data Tools, MS Visual Studio, VSTS, Power BI, JIRA

SQL Server Data Tools: SSIS, SSAS, SSRS, SQL Management Studio

Languages: T - SQL, Linux, JavaScript, VBA (Excel)

Databases: MS SQL server, Oracle

Office Tools: MS Office Suite/Access/PowerPoint

Operating System: Windows Enterprise, Windows Server

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

BI/Data Analyst

Responsibilities:

• Involved in conducting full lifecycle analysis which includes gathering requirements, design, loading data, creating dataflows in Power BI Service, and creating reports and publishing on to workspaces.
• Involved in Sprint planning meetings
• Used Zeplin, a collaboration tool for UI designers and front end developers. It goes beyond the design workflow and helps teams with the design hand - off.
• Participated In design meetings with the BI team
• Interpret data, analyze results using statistical techniques and provide insightful reports.
• Generate Reports and Dashboards in interpreting trends or patterns in complex data sets.
• Experience querying data from database
• Extensively used Power BI tool for Report creation
• Worked on Data modelling and transforming data for the report design
• Performed data validation, debugging and analyzed the reported issues
• Extensively used DAX functions for the Power BI reports
• Used JIRA as test management tool.
• Power BI Visualizations are published to a website hosted on Azure cloud
• Experience in interpreting trends or patterns in complex data sets
• Collaborate with cross functional teams and stakeholders to resolve data quality and operational issues and ensure timely delivery of work product

Environment: AWS SQL Database,SQL Server Management Studio (SSMS), Power BI reporting, Visual Studio, DAX,JIRA

Confidential, Austin,TX

BI Analyst

Responsibilities:

• Interacted with the business users for understanding the business requirements and the existing system.Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.
• Fetched the data from different sources like SharePoint, and cloud solutions like MS Access data base - Flat files, Able to load data from Excel, Flat Files, XML, different databases and SQL database.
• Developed Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using Power BI.
• Involved in creating MDX, DAX, Cubes and Tabular models. Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features.
• Defined and created reports and dashboards on system performance and utilization metrics for preventive monitoring and effective capacity planning.
• Implemented Role based access security using Microsoft Power BI.
• Knowledge on connecting various Data Sources in Power BI Service using On-Premises Gateway connection.
• Integrated custom visuals based on business requirements using Power BI desktop
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Migrated existing reports to POWER BI reports.
• Created Gauge Report, Sub Reports, Drill down Reports, Summary Reports, Linked Reports and Parameterized Reports for different departments.
• Implemented skills like MS Power BI, Azure related data management
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.

Environment: SQL Server, SQL Server Management Studio (SSMS),Power BI, Visual Studio, Excel, DAX, SSIS, Business Intelligence Development Studio (BIDS), Azure Analysis services ( AAS)

Confidential, Austin, TX

BI Consultant

Responsibilities:

• Built and published customized interactive dashboards utilizing Power BI.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Created new measures and new calculated columns for reports and dashboard analysis.
• Utilized the Agile Scrum methodology to analyze the requirements to create stories.
• Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Administered and deployed OLAP cubes on development and production server for performance analysis using SSAS.
• Wrote DAX Expressions, Power Query, Functions in Power BI.
• Developed complex SQL queries using stored procedures to support Power BI and SSRS reports.
• Involved in SQL testing to meet business deadlines.
• Developed/Created Average Claims by Severity reports - This Report displays business KPIs like Incurred Loss, Paid Amt, Claim Frequency and Avg Incurred Loss summarized by Adjusting Office.
• Created Claims recovery summary reports.
• Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Implemented data migration from Microsoft Azure cloud platform to on-premises data servers utilizing Azure cloud technology.
• Created various dashboard reports for commission, sales and profit analysis.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Implemented Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
• Used dashboards for data analysis and custom reports.
• Adopted Agile Software Development Methodology.
• Environment: SQL Server, Microsoft Visual Studio, Power BI, Windows, MS Office, SQL Server Integration Services, SQL Server Reporting Services, SharePoint
• RW3 Technologies

Austin,TX Jan 2014 - Oct 2015

BI Developer

Responsibilities:

• Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases.
• Developed SQL queries or Stored Procedures used by reports to retrieve information from Relational Database and Data Warehouse.
• Experience in generating Drill through and Drill down reports with drop down menu option, sorting the data, and defining subtotals in Power BI.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Experience in creating multiple reports such as drilldown reports, drill through, and parameterized report.
• Developed User Interactive Sheets & Reports as per the business needs and requirements.
• Worked with report parameters and performed parameterized and cascading parameterized reports
• Responsible for designing, developing and testing of SSIS packages and SSRS reports to support business initiatives, goal setting, performance management and risk avoidance.
• Generated periodic reports based on the statistical analysis of the data using SSRS
• Gathered data from multiple data sources such as ADO.net, OLEDB, Excel & Flat files in developing the logical Data Models.
• Worked on Data Transformation Services (DTS) in SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server
• Involved in maintenance of ETL Packages in SSIS according to changing business requirements to support the existing ETL strategy.
• Created custom logging and error handling SSIS packages.
• Monitoring of the files and user accounts for the usage of the applications.
• Participated and proposed new business analysis for data which has no prior reports.
• Designed index, statistics and optimized queries by using execution plan for Performance tuning of the database
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Trained end users to use the reports effectively, to build and customize their ad-hoc reports.
• Participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system

Environment: SQL Server Management studio, SQL Server Integration Services, SQL Server Reporting Servers, SQL, Excel, .CSV Files, Windows, Power BI

Confidential, NY

MSBI Developer (SSIS/SSRS)

Responsibilities:

• Exported data from SSRS report to several file formats likes PDF and Excel according to the needs of management.
• Enhanced the Reports by updating the embedded Scripts in SSRS to the Stored Procedures
• Improved the Performance of SSRS reports by optimizing data sets, making use of report caching and snapshots.
• Created dashboard style of layouts using different components of SSRS like List - boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Developed several BI applications using SSIS platform connecting to and integrating data from several databases using an ETL load script and standard expressions for calculated dimensions on charts and tables
• Responsible for all DB work including: Stored Procedures, SQL statements, views, DTS, scheduling DTS packages.
• Designed, developed, implemented, tested, and supported solutions using SSIS functionality
• Extracted information from disparate data sources like excel files, OLEDB, flat files, etc. by using different scripts like add, concatenate, resident, concatenate etc.
• Work with the development team to produce a data model that will support the team to prototype, test, and debug reports to meet business requirements
• Created and executed test plans/scripts to find errors and confirm reports meet specifications
• Provided technical assistance with troubleshooting reports/cubes by responding to inquiries and questions

Environment: SQL Server Integration Services, SQL Server Reporting Services, SQL Server Management studio, SQL, MS Access, Excel, Visual Studio, QlikView