We provide IT Staff Augmentation Services!

Data Analyst Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • Good Knowledge in using BI tool: Tableau.
  • Hands on experience in creating various database objects like tables, stored procedures, functions, and triggers using SQL.
  • Detailed understanding of Software Development Life Cycle ( SDLC ) and strong knowledge in project implementation methodologies like Waterfall and Agile .
  • Exposure to Oracle and Teradata analytics.
  • Excellent technical, communication, analytical and problem - solving skills and ability to get on well with people including cross-cultural backgrounds and trouble-shooting capabilities.
  • Data Analytics, front-end reporting, data collection, integration, data quality assessment.
  • Exposure to pilot project requirements, Gantt Charts, Critical Path Analysis, and schedules using MS-Project.
  • Worked on data mapping documentation with Data Governance team to define functional and design specifications.
  • Analyzed historical data, plotted trend lines using predictive models to visually display the correlation between variables with confidence intervals.
  • Experience in Tableau, SQL, advanced Excel with working knowledge of R, Python and other analytical/statistical tools.
  • Developed Dashboards, quantitative displays and ad-hoc reports for the leadership team.
  • Utilized row level functions and complex calculated fields and methodologies to clean data as well as eliminate duplications and promote data accuracy/integrity in all forms of reporting.
  • Validation of report accuracy and data sources by working with applicable stakeholders.
  • Participated in Confidential user groups for Business Intelligence, advanced and predictive analytics, requirement gathering, critical review of procedures, advising in process change and functional design of the application.
  • Managed and controlled data population in Configuration Management Database (CMDB), client tools, and in-built project tools.
  • Frequent updates and communication with stakeholders to discuss, clarify and resolve any project related issues and risks.
  • Followed best defined practices in mitigating risks and issues across projects.
  • Documenting detailed standards/instructions for process flow-chart & PowerPoint.
  • Maintained version-controlled document on Business Continuity Plans (BCP).

TECHNICAL SKILLS

Tools: Programming& Data:: MS-Office R, SQL

Operating System Data Reporting/ Visualization tools:: Windows 2000/98/XP/7/Vista, MAC OS Tableau, MS-Excel, MS- Project

Database Design &Methodology:: Oracle 11g, Teradata Waterfall, Scrum & Agile, SharePoint, CMDB

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

  • Design, operationalize and manage the evolving data needs with proper documentation.
  • Build data solutions to define requirements, access data sources.
  • Hands on experience with SQL query.
  • Extracted sample data for the relevant business cases.
  • Validated results and share report by running sample queries.
  • Presented graphs, data visualizations and Dashboard for comparing results in Tableau.
  • Used SAS Miner for preprocessing data.
  • Checked the regression and performed missing values procedure.

Reporting & Business Analysts

Confidential

Responsibilities:

  • Manage and control data population in several in built tools, CMDB, client tool.
  • Provided design and tested new features as per the requirement in tools.
  • Prepared daily, weekly, monthly, and ad-hoc reports in excel to share with stake holders.
  • Dashboard creation using tableau for visualization.
  • Created monthly invoicing for the management and clients providing the status.
  • Involved in Availability management.
  • Controlled DL, SMB and SharePoint management for the project team.

Service Manager

Responsibilities:

  • Using Remedy and HPSD ITIL tools monitored SLA in queue
  • Handled Sev. 1 incident while working with different technical teams involved.
  • Update and communicate SLA for priority incidents and work order to technical teams.
  • Prepared daily, weekly, monthly and ad-hoc reports in excel to share with stake holders.
  • Interacting with clients on the daily issue and the Incident discussions.
  • Maintained and documented risk and issues occurred, its frequency and current status on SharePoint as the part of best practices and Business continuity Plan.
  • Coordinated with several operational and technical teams involved to follow the required contingency plan to handle these risks and issues.
  • Prepared shift roster & scheduling in TMS, other daily operations.

PMO

Confidential

Responsibilities:

  • Generated daily, weekly, monthly, and ad-hoc reports in excel to share with stake holders.
  • Created DART, KPI, Dashboard reports using several Office- Suites.
  • Calculated and delivered resource utilization, staffing report, formalized Roll-on Roll-off process, organized, and s for the project team.
  • Update and maintained version-controlled document on Share point.
  • Exposure in maintaining allowance details, Event Management and Newsletter Designing.

We'd love your feedback!