Description
PROFESSIONAL SUMMARY * Highly motivated, customer-focused with 5+ years of experience with Accenture and SPFL as BI/Data Analyst, providing enterprise solutions to some of the largest global clients in Energy/ Gas production, Retail, Credit Card and Loyalty programs, Finance domain. * Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis. * Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support. * Expertise includes DB design, DB architecture, RDBMS concepts, SQL queries, Tableau, identifying software requirement specifications and required test scenarios, SDLC and STLC, and documenting business requirements. * Executed multiple projects successfully in liaison with development team, developed business intelligence dashboards for performance enhancement. * Analysis of existing SQL Enterprise data warehouse using gap analysis between the as-is data model and to-be requirements * Initiated budget forecast, analysis, variance reports and generated ad-hoc reports for management for review * Led a team of 4 members and was responsible for training and reviewing performance. * Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance. * Understanding of Business Model development using different functionalities like Dimensional Hierarchies, Level Based Measures, Aggregation Rules, Time Series Function. * Executed monthly financial modeling, budget improvement, processed expense reports and implemented time series modeling TECHNICAL/FUNCTIONAL SKILLS * Programming Skills: Tableau Desktop/Server, SQL Server, SSIS, SSRS
Accomplishments
Highlights:
Keywords
