Data Analyst Power
Resume:
Susha Jacob
Data Analyst/Business Analyst
Professional Summary:
3+ years of professional experience in IT.
Well acquainted with hands on experience with all the phases of Software Development Life Cycle.
Expert level knowledge and experience in MS Excel – V lookup, Pivot tables & Power Query.
Participated in elicitation process using interviews and document analysis.
Detail-oriented with strong analytical and troubleshooting skills.
Proficient in Database, MS SQL query writing.
Highly skilled in MS Office Suite, Visio and Adobe Acrobat.
Experience in building, and publishing interactive reports, Visualizations and Dashboards with Tableau and Power BI.
Excellent analytical, communication and interpersonal skills to ensure the coordination and completion of projects on time within budget and scope.
Energetic with a thirst for continuous self-improvement, a willingness to embrace challenges and driven for excellence.
Knowledge in Google Analytics and JIRA.
Very passionate about data and its analysis!
Areas of Expertise
Business Analysis & Data Analysis
Problem Solving and Quality Control
Finance and e-commerce Domain knowledge
Requirement analysis
Business Intelligence, ETL
IT development and Quality assurance
Reporting and statistical analysis
Track and report data
Reporting Tools
Dashboard Preparation
Proficiency in MS EXCEL
Technical Skills
Database: MS SQL, MS ACCESS
QA Tool: Quality Center, Test director
OS: Windows
MS Office: Excel, PPT, Visio
Tableau Desktop/Server/Prep/Online
MS SQL, SSRS
Power BI, DAX
Work Experience:
Position: Data Analyst
Client : Accesslex Institute, West Chester, PA Nov 2019 – March 2020
Responsibilities:
Developed and implemented technical designs of data reports and models in support of business requirements.
Collaborated with business and development community to understand data requirements.
Developed new reports in SSRS as per the requirements received from business and legal departments to help them with the budget processing.
Prepared SQL queries for ETL, Data Analysis and Data Cleansing.
Participated in the migration of portal reports to Power BI report server.
Developed visualizations and dashboards using Power BI
Assisted in gathering and defining business and technical metadata in support of projects.
Conducted Data mining and Data modelling in coordination with the collections department to analyze and update company’s 1099 policy .
Participated in the Portfolio Data management by comparing daily, weekly and monthly files from First Associates using MS Excel.
Position: Business Analyst
Client : Aria Systems, Broomall, PA June 2019 -Oct 2019
Responsibilities:
Created detailed business requirement or business process documents and translated it into functional specifications.
Participated in elicitation process using interviews, document analysis, business process descriptions, use cases, scenarios, business analysis and workflow analysis.
Proactively communicated with stakeholders and business units, both verbally and in formal written communications, to maintain transparency and keep stakeholders informed.
Assisted in entering and updating Issues onto JIRA Agile application.
Prepared end user training material and operational documentation.
Prepared basic flow diagrams and swim-lane diagrams.
Position: Business/Data Analyst
Client : Bed Bath and Beyond, Union, NJ Feb 2018 – April 2019
Responsibilities:
Communicated with business process owners and department heads.
Prepared queries using MS SQL to improve data structure and to build custom reports using SSRS.
Identified Data requirements, reporting structure and issues on complex reports.
Prepared business process documents for reporting procedures using MS Office Suite.
Prepared business models, flowcharts and swim-lane diagrams.
Developed Tableau visualizations and dashboards using Tableau with different data sources.
Position: Business Owner /President
Finappstech Solutions Inc, Wayne, PA Dec 2011 – Dec 2017
Responsibilities:
Performed general accounting activities including invoicing, AP and AR.
Quick Books Management.
Maintained all records for the Internal Revenue Services and tax purposes.
Maintained perfect file records, ensuring important records can be assessed quickly.
Involved and communicated in setting up contracts between customers and vendors.
Responsible for managing taxes, budgets, filing and contracts for business.
Handled day to day activities and provided exceptional customer service.
Position: QA Analyst
SunGard Higher Education, Malvern, PA Feb 2007- Aug 2007
Designed and documented test procedures and test cases for user acceptance, functional and integration testing.
Manual testing of all the test cases for Polaris iterations and performed SQL queries to test whether the database is getting updated properly.
Responsible for testing SQL reporting services 2005 with the Vista report, which is a tool associated with Power Campus Software.
Analyzed Manual test results with Functional requirements.
Defect tracking and reporting was done using Rational Clear Quest.
Education & Training
Masters in Computer Applications (MCA)
Data Analytics Certificate Program (Cornell University 2019)
Associate degree in Accounting (Linfield College, OR)
Microsoft Certified Professional
QuickBooks certified (2016)
ISQTB Foundation Level Certification (2018)
Tableau training (2018)
Power BI training (2020)
Work Authorization status
US Citizen
Contact this candidate