Business Analyst Resume

TECHNICAL SKILLS

Databases: MySQL, SQL Server, MS Access

Programming Languages: Python, R, RapidMiner, PHP, C, C++, Java, CSS, HTML, Teradata

Software: Tableau, MS Excel, MS Visio, Power BI, Jira

Tools: and Methodologies: Agile, Waterfall, A/B Testing, SDLC

Core Competencies: Business Intelligence, Visualization, OLTP, OLAP, Data Warehousing

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

Set up a data flow to extract members who are at their end of membership for targeted marketing and membership renewal reminder, which in turn increased retention ratio by 21%.
Tuned the SQL query by using optimizing techniques such as Joins and Limits reducing the time to obtain customer details
Analyzed customer database using RFM analysis to determine the type of customers who spend more and customers that were responsive to promotions.
Utilized Microsoft Excel to categorize previous budget reports into a detailed pivot table to develop an improved company financial strategy data
Designed and Developed ETL process while integrating data from different sources performing extraction and sharing it on a common platform reducing time and complexity of data processing
Developed dashboards using Tableau to monitor a variety of data simultaneously and improve membership management by identifying key metrics.
Contribute to and help inform; the development of marketing briefs, which includes research, analyses and key strategies that serve as the strategic foundation for marketing and creative efforts
Closely cooperated with client professionals, gathering information, to enhance the features of the website (Training, Diet plans, Membership plans) building to a more interactive and user - friendly website
Informed the project team on emerging issues related to business and financial operations as part of my stakeholder management role.