SUMMARY

• BI developer having 8+ yearsof IT Experience in Data Analysis, Data Mining,focusing onDesign, Development, and supporting several software applications in Client/Server environment using Business Intelligence Tools.
• Experience in data discovery, data visualization, data analysis, and report development using various tools like Power BI and Tableau.
• Expertise in interacting wif end users, functional/technical experts and identifying, analysing and developing teh reports that meet teh business needs.
• Expertise in creating reports from importing, Direct Query and Live data from several data sources.
• Experienced inSQL Server Business intelligence tools like SQL Server Integration services SSIS, SQL Server Reporting Services SSRS and SSAS.
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL Server and Teradata SQL Assistant.
• Good Knowledge on DAX.
• Designed and developed ETL/SSIS packages that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.
• Experienceincreatingaggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures,andparameters in Power BI and Tableau.
• Experience in creating various filters likevisual filters, page level filters and report filtersin Power BI.
• Experience in designing Interactive Reports and Data Visualization reports using Power BI and Tableau.
• Experience in use of Power Query for Data Modelling.
• Extensive noledge of Tableau Server Concepts liketab cmd, tab admin, creating/ adding users, sites, and projects,managing licenses and data connections, scheduling tasks.
• Capability in designing exquisite visualizations using Power BI, Tableau publishing and presenting Dashboards on web and desktop platforms.
• Managed and prioritized requests from various stakeholders and manage teh expectations of stakeholders.
• Excellent communication, interpersonal and analytical skills wif ability to manage and work effectively to meet deadlines in fast paced environment.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows, Unix/Linux.

BI TOOLS: Power BI, Tableau

ANALYTICS TOOLS: Power BI, SSAS, SSRS, Tableau

MICROSOFT: SharePoint, Azure, Power Apps, Excel, Word, PowerPoint

LANGUAGES: SQL, C, Shell Scripting, SAS

DATA BASES: SQL Server, Oracle, Teradata, MySQL, IBM DB2, MS Access, Hadoop

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Power BI Developer/Data Analyst

Responsibilities:

• Gathered business requirements, interacted wif Strategic Development Team, Business analysts to analyze business needs and developed technical specifications.
• Increased efficiency, time and cost savings to teh company by implementing automation and data analytics.
• Performance tuning of dashboards and best practices for designing, building dashboard, reports in Power BI.
• Worked closely wif business partners in addressing their queries.
• Created SQL Cluster/Non - Cluster Index, Unique/Check Constraints, Views, functions.
• Normalization done to reduce redundancy and populate data in teh tables accordingly.
• Wif use of SQL queries build various Stored Procedures for modifying, adding data to teh tables.
• Developed complex stored procedure, cursors according to teh need.
• Designed and developed SSIS Packages for regular ETL load.
• Analysed teh source data and handled efficiently by modifying teh datatypes.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, aggregate and Slowly Changing Dimension, Merge Join and Union all.
• Generated multiple reports depending on required Similarity threshold using Fuzzy lookup.
• Deleted approx. matching records manually depending on teh fuzzy lookup reports to avoid repetition.
• Developed SSAS Tabular Model and Imported in Power BI in Live connection mode to keep data updated in Power BI.
• Was involved in creation, updating and managing daily dashboard for Test Management Activity.
• Developed dashboards using relational databases and cubes (SSAS).
• Knowledge on On-premises data gateway and On-premises data gateway (personal Mode).
• Regularly developed Power BI Reports as per teh HR Department demands.
• Scheduled data refresh on Power BI server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Designed mobile specific dashboards in Power BI.
• Used multiple DAX functions like Calculate, Min, Max, Average, Filter etc. for analytics and reporting.
• Created side by side Graphs, Card, Table visual, Pie Charts, Slicer, and Maps according to deliverable specifications.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Presented Monthly process refresh though dashboards, reports to track trend for teh different business’s challenges using Power BI.

Environment: SSIS, SSAS, T-SQL, Power BI, MS Access, SQL Server, Flat files, CSV files, MS Excel, MS Access.

Confidential, Dallas, TX

Power BI Developer

Responsibilities:

• Actively participate in review meetings wif Project Manager to ensure that teh development of projects meets business and system requirements for design development testing and production rollover of reporting and analysis projects wifin Power BI Desktop.
• Migrated excel reports to Power BI reports.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Written custom SQL Queries to get teh data from teh data source.
• Connect SQL Server to Power BI in Direct Query mode.
• Implemented Automatic Refresh and Gateway in Power BI.
• Developed SSAS Tabular Model and Imported in Power BI in Live connection mode to keep data updated in Power BI.
• Identified teh factors involving teh performance of teh reports and coordinated in creation of indexes statistics to improve teh query turnaround time efficiently.
• Developed story telling dashboards and published them which allowed end users to understand teh data on teh fly wif teh usage of quick filters for on demand needed information.
• Created Power BI Dashboards wif filters, KPIs using calculated key figures and parameters.
• Scheduled data refresh on Power BI Report Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Perform quality assurance checks. Regularly developed Power BI Report as per teh Need.
• Used Alteryx for Data Modelling.
• Created various charts - like Bar Charts, Line Charts, Pie Charts, Donut Charts, Tree Maps and Built Dynamic KPIs.
• Created rich interactive dashboards for senior management to understand daily/weekly trends.

Environment: SSAS, SQL, T-SQL, SSIS, Power BI, Alteryx, SQL Server, Excel, MS Access.

Confidential, Secaucus NJ

MSBI Developer

Responsibilities:

• Involved in reviewing business requirements. Created user stories.
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
• Written custom SQL to get teh data from teh data source. Implemented low level security.
• Worked closely wif business power users to create reports/dashboards using Power BI desktop.
• Created Test Cases and documented teh Test Results.
• Take Backup in chunks every month before deployment in production.
• Schedule SQL Server Agent to run teh package on daily basis or schedule according to teh change request.
• Performed teh Modification of SSIS package.
• Worked wifseveral facets of SSIS - Mapping Data, Data Flow, Control Flow, transformations for better performance and exporting.
• Configured teh sessions usingworkflow managerto have multiple partitions on Source data and to improve performance.
• Understand teh business needs and implement teh same into a functional database design.
• Detail analysis of excel sheets. Finding teh right error for package failures.
• Deployed packages to Production server.
• Running teh package in Production by making site down.
• Helped in Implementation of Power BI environment.
• Used Power Query for Data Modelling.
• Conducted POC.
• Converted SSRS reports into Power BI.
• Designed and developed various analytical reports using various data sources.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

Environment: Excel, MS Access, SQL Server, SQL, Excel, Power BI Desktop, SSIS, SSRS

Confidential, Charlotte, NC

BI Developer

Responsibilities:

• Analyzed, developed, tested and documented data integration ETL processes using SSIS Packages.
• To migrate business data from multiple legacy data sources to a single data base source.
• Developed enterprise dash boards that’s how teh Key Performance Indicators (KPIs) and data trends.
• Transformed teh company’s business data to get useful insights for strategic decision making.
• Interacted wif business users in gathering, analyzing, and documenting teh business requirements and translate them into technical specifications.
• Created a SharePoint site for use by teh project team for collaborative document management.
• Increased productivity by developing UNIX shell scripts to automate applications.
• Ensured quality by creating unit test cases and documenting teh unit test results.
• Created Tableau dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies.
• Developed several reports/dashboards using Dual Axis charts, Histograms, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot.
• Exported of Data from Track Wise.
• Used SQL data sources, excel sheet, flat files, CSV files for Tableau reporting.
• Worked wif end users in creating complex dashboards in an iterative process.
• Configured scheduled updates (Automatic and User notified) for optimal performance.

Environment: s: SSIS, SQL, Tableau, SharePoint 2010, Shell Scripting, Track Wise, Teradata, Oracle, IBM DB2, Team Foundation Server (TFS), JIRA, Agile Scrum.

Confidential, Princeton, NJ

Data Analyst

Responsibilities:

• Participated in project planning sessions wif project managers, business analysts and team members to analyse business requirements and outline teh proposed solution.
• Gather requirements from business user and develop dashboards based of their requirements.
• Worked oncomplex mappings, building teh workflowto meet teh business needs ensured they are reusable transformation to avoid duplications.
• Created analysis of source systems, business requirements and identification of business rules.
• Extensively used Cron jobs for Scheduling and monitoring
• Created a SharePoint site for use by teh project team for collaborative document management.
• Increased productivity by developing UNIX shell scripts to automate applications.
• Ensured quality by creating unit test cases and documenting teh unit test results.
• Created Tableau dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies.
• Developed several reports/dashboards using Dual Axis charts, Histograms, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Used SQL data bases, excel sheet, flat files, CSV files for Tableau reporting.
• Presented reports and dashboards in Tableau wif filters.
• Worked wif end users in creating complex dashboards in an iterative process.
• Configured scheduled updates (Automatic and User notified) for optimal performance.
• Supported different file transfer on FTP server.

Environment: Tableau, Teradata, Oracle, SQL, SQL Server, DB2, UNIX, SAS, SFTP, FTP Server.