SUMMARY

• A proactive Application Consultant with proven analytical & problem - solving skills. Proficient in data analysis, intelligence gathering, project management, data modelling, implementing user acceptance testing, providing trainings and technical support towards achieving business goals.
• I am passionate about turning raw company’s data to actionable insights, data storytelling and building compelling dashboards to help stakeholders make critical business decision.
• My knowledge of business applications and technology solutions helps ease project management, collaboration, and communication with team members and management on project status, process, and issues.

TECHNICAL SKILLS

• Business Analysis
• Proficient in SQL
• Proficient in Python
• Data visualization with Power BI
• Excellent presentation skills (PowerPoint, Visio)
• Proficient in Tableau
• Project Management
• Web scraping
• Knowledge in Star Schema
• RLS Implementation
• Reporting and Documentation
• Workflow design
• Cloud Data warehouse

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential, Forth Worth, TX

Responsibilities:

• Devised Computerized Maintenance Management Software with modules for inventory monitoring, procurement, work order, asset management, preventive maintenance, and generation of reports.
• Designed different employees related reports with Report Builder and also set up and configured SQL Server Reporting Services for clients.
• Hands-on experience with SQL Profiler for debugging and troubleshooting on client’s server.
• Administer production, development, test, and training server environments; define strategies for backup and disaster recovery systems.
• Monitor performance, capacity, licensing and patching to maintain the defined standards for applications installed in client environments.
• Develop performance metrics derived from raw company’s data to track improvements in organizational efficiency.
• Responsible for gathering, documenting, and validating business requirements and functional specifications.
• Develop a deep understanding of business procedures and how the solution or application will benefit the business.
• Write and design relevant user and administrative manuals or documentation to serve as a business guide or reference.

PowerBI/ BI Developer

Confidential, Grand Prairie, TX

Responsibilities:

• Worked on Requirement analysis, design and development of modules usingPowerBI,Tableau, SSIS and SSRS. worked on client problem understanding, requirement building, documentation and translation of the requirements into dashboard solutions.
• Building, publishing customized interactive reports and dashboards, report scheduling using bothPowerBI andTableauserver.
• Created stored procedures and SQL queries to pull data intopowerpivot model
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• DevelopedTableauvisualizations and dashboards usingTableauDesktop.
• DevelopedTableauworkbooks,PowerBIreports and dashboards from multiple data sources using Data Blending.
• Developed Unit testing of the modules.
• DesignedpowerBIdata visualization using cross tabs, maps, scatters plots, pie, bar and density charts.
• Scheduled Automatic refresh and scheduling refresh inpowerbiservice.
• Wrote calculated columns, Measures query's inpowerbidesktop to show good data analysis techniques.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available inPowerbiquery editor
• Weekly presentation to the business users about the reports and their changes as required.

Environment: SQL Server 2016,, SSIS, Tabular, SSRS,PowerBI,PowerPivot, Oracle, SharePoint 2013, Windows Server 2012, Sql Server,Tableau10, Windows 8.

PowerBI/ BI Developer

Confidential, Seattle, WA

Responsibilities:

• Met with business users, gathered business requirements and prepared the documentation for requirement analysis.
• Created centralized data warehouse (ODS) and developed de-normalized structures based on the requirements and to improve the query performance for end users.
• Worked on building, publishing customized interactive reports and dashboards, report scheduling using Tableauserver.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets usingTableau.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Did debugging using break points and data viewers and performance tuning of ETL data flows.
• Created various SSIS packages to populate the data from Oracle and flat files into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction based data).
• Used SSIS project deployment model and deployed the packages using incremental package deployment and used package parts to do custom logging and to reuse parts across all packages.
• Worked onpowerpivot models and created calculations using DAX expressions to build various KPIs.
• Developed various types of reports drill down, drill through, matrix and sub reports using SSRS 2016.

Environment: SQL Server 2016, SSMS, SSIS, Tabular, SSRS,PowerBI,PowerPivot, Oracle, Report Builder 4.0, TFS, SharePoint 2013, Windows Server 2012, Sql Server,Tableau9.x/10, Windows 8.