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
ConfidentialResponsibilities:
- 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.
