Data Analyst

Yogita M. Rawat

Phoenix, AZ 573-***-**** adcg7h@r.postjobfree.com LinkedIn

Specialized in: Requirement Gathering, Data Analysis, Report Design, Development, Testing, and Publishing

Results-driven professional with a career distinguished by consistent performance as a self-starting individual contributor as well as a dynamic team leader. Strong orientations in data analysis, project management, and process improvement. Highly motivated, innovative, with experience in managing the design and development of analyses to support business needs. Strong communicator, analytical, logical and resourceful in approach to problem-solving, and decision-making.

Professional Experience

HR Data Analyst – Bechtel Corporation Glendale, AZ 2018 – Present

Expertise in transforming business requirements into analytical models, designing algorithms, building models, developing datamining and reporting solutions that scale across a massive volume of structured and unstructured data.

Implemented an ETL strategy to effectively and successfully pull data from multiple sources and place retrieved data into a specifically designated database.

Designed, developed, implemented, and supported QlikView and Power BI dashboards. Integrated data sources and databases and designed and developed data models and backend queries using SQL for presenting data.

Created data queries and reports using Power BI and QlikView connecting directly to Data Lake through SQL queries. Created custom queries/reports designed for quality verification and information sharing

Use SAP Successfactors Reporting Module to create Adhoc, ORD, Canvas reports.

Developed and tested multiple Business Objects Web Intelligence reports using multiple Universes and applying complex filters.

Managed the data security of the company with regards to protecting digital data by developing, implementing, monitoring and enforcing appropriate and effective data protocols.

Nucleus Software Exports Limited Noida, India 2008 – 2015 Assistant Manager (2011 – 2015)

Lead analyst on the HR Executive Dashboard created in Tableau Desktop. Build, published customized interactive reports and dashboards using features such as data blending, extracts, LOD calculations, filters, actions, parameters, context filters, sets, groups and aggregate measures that helped track growth across Business Units, and highlights employee turnover patterns and other critical metrics.

Analyzed business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.

Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.

Extracted data using the HRIS query builder for creation of Reports and Dashboards.

Managed automation of the various HR processes such as – Goal Setting, Performance Evaluation, Training and Development Modules on the HRIS - Training requisition module, Training calendars etc. Created the process flow and requirement documents for automation.

Work on ad hoc queries and reports for the department, internal and external audits.

Responsible for the maintaining the version control of project documents and reports using IBM Rational tool. Supported Audit activities for the Projects. Worked on the Non Compliance and resolving them to closure.

Analyzed business requirements and designed solutions that solved technical and business issues of varying complexity.

Developed and prepared project documentation including requirements specifications and test cases. Executed test plans for all phases of Integration and User Acceptance Testing

Executive (2010 – 2011)

Organized and headed the department-wide rollout and practice of a strategic planning and management system utilizing a balanced scorecard.

Created reports and dashboards showcasing specified KPI’s using MS Excel by extracting data using SQL Programming pulling from MS SQL Server.

Developed systems for a workflow that significantly improved efficiency by automating the scorecard process and linking to existing HRIS systems; resulting in an all in one step to calculate annual incentive payouts.

Created detailed project documentation through obtaining and analyzing business requirements. Translated documented business requirements into business solutions mapped inside a process workflow.

Management Trainee (2008 – 2010)

Managed over 400 projects to include planning, execution, and monitoring all project activities along with stakeholder management.

Coordinated the project efforts to design, develop, test and implement the buildout of a more robust in-house project management tool resulting in the ability to efficiently track and manage internal projects.

Interviewed key stakeholders to document, interpret and translating business requirements into technical requirements, helping senior management make better business decisions.

Accountable for the establishment and preparation of reports using MS Excel extracting data from SQL Server using SQL programming.

Education

Master of Science in Information Management – W.P. Carey School of Business at Arizona State University

Master of Business Administration, MBA – Uttar Pradesh Technical University

Bachelor of Science, Computer Science – University of Delhi

Technical Proficiencies

Microsoft Suite SQL R Alteryx QlikView Tableau Desktop Power BI Power Query Power Pivot Business Objects Visio SAP SuccessFactors

Contact this candidate