Data Analyst Resume Philadelphia, PA - Hire IT People

SUMMARY

Proficient data analyst wif proven skillset in R, Python, SPSS & Tableau to enable data - driven decision across business segments
Expertise in ETL tools like Informatica, SSIS & SSRS to provide integrated data management solution to address business challenges
Competent in extracting business value from big data systems by determining requirements & communicating to stakeholders
Empowered BI solutions in MicroStrategy by blending data from various sources using Alteryx to build executive level dashboards
Gained substantial noledge of Data Mining, Predictive Analytics, Machine learning & Data Visualization through industry based projects

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Philadelphia, PA

Responsibilities:

Designed revenue forecasting of sales data using ARIMA models in R which halped to set the right sales target to the team
Used Tableau to design dashboard to visualize Revenue generated by Confidential 's different product lines to identify top performers
Designed a novel dashboard to visualize customer to sales agent proportion for different business units wifin each city of U.S.
Performed statistical analysis to analyze variability in agents' performance using bubble plot to resolve performance issues
Developed ETL workflows in Alteryx and created dashboards in Microstrategy to provide insights to Chief Customer Officer
Led efforts to support Sales team's ad hoc analytical business needs through deep-dive analysis and hypothesis validation

Business Technology Analyst

Confidential, Syracuse, NY

Responsibilities:

Consolidated operational data from multiple data sources using SQL to a centralized location feeding data to multiple dashboards
Involved in building, pruning & maintaining the team backlog based on client's feedback & timeline to improve existing processes
Planned and facilitated the User Acceptance Testing process for all new product features, enhancements and defect remediation
Researched market trends and devised exclusive product solutions that contributed to a raise of $80k in the fund by investors
Analyzed and prioritized business requirements using MoSCoW method and designed technology enabled business solutions
Used Informatica to carry out ETL process on source data & loaded it into target tables to build the required data marts

Analyst

Confidential

Responsibilities:

Fine-tuned database stored procedures & queries leading to 40% decrease in the load and processing times of web based reports
Developed SSIS solutions to reduce work time by more TEMPthan 50% in company projects and automate daily tasks
Analyzed 5 years of academic result data using Tableau to understand trend for each course to build better educational strategies