Data Analyst Resume
3.00/5 (Submit Your Rating)
New York, NY
SUMMARY:
- Information Systems professional possessing over 5 years’ experience with expertise in Data Analytics, Systems Integration, and Implementation
TECHNICAL SKILLS:
- SAP HR
- SAP HCM
- Business Objects
- Oracle PeopleSoft HCM v8.0 v9.0 v9.2
- UPK
- ELM
- Siebel CRM
- SQL
- HTML
- Microsoft Office
- Outlook
- VB
- VPN
- Kronos
- ADP Run
- Workforce
- Workday
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Data Analyst
Responsibilities:
- Interpret data and report results to Transformation project lead and Data Stewards
- Translate raw data into understandable content as requested
- Lead Data Validation sessions
- Work with Finance management to prioritize business and information needs for 2016 Transformation project
- Extracted raw data from planning database and produce reports in Business Objects
- Generate Ad - Hoc reports for management using Business Objects
- Work with Finance team to identify discrepancies between databases
- Manage WorkforceTool planning database for Investments, Corporate Technology, and Enterprise Architecture groups
Confidential, New York, NY
HRIS Operations Analyst
Responsibilities:
- Gather, validate, and maintain personnel information using PeopleSoft 9.0/9.2 HCM (Human Capital Management)
- Utilized Siebel CRM (Customer Relationship Management) application to promptly respond to employee and executive inquires including high urgency requests from management team
- Worked with file data imports from large extract files transferring data between Access and Excel
- Processed position and personal changes using HCM custom PARS and PURS
- Troubleshoot and correct issues with Metro North Railroad’s Kronos 8 T&A Badge system
- Created Pivot Tables as needed in Microsoft Excel and created reports in VBA
- Utilized Vlookups to populate data from one spreadsheet to another
- Liaised with agency contacts to process transfer, promotions, and hires into HCM from additional systems
- Established processes to continuously monitor data quality to proactively detect, correct, and prevent invalid data values
- Created and maintained tables for both department budget and job codes for shared services
- Wrote queries to pull headcount reports and created Macros in Microsoft Access 2003 to export Reports to Microsoft Excel
- Collaborated with implementation partners (IBM) for the successful upgrade to v9.2
- Gather requirements for HRIS department
- Participated in 9.2 User Acceptance Testing (UAT) to identify defects and mitigate risks
- Responsible for auditing information during data migration phase of conversion for personnel files and employee financials
- Build and edit Macros in Excel to automate daily processes
- Led small team of additional analysts for preliminary System Integration Testing of Pension conversion to evaluate system compliance
Confidential, New York, NY
Performance Management Consultant
Responsibilities:
- Contract full Cycle Performance Management Consultant for Energy and Resources (ER) Governance, Regulatory, and Risk Strategies (GRR) and Life Science Healthcare (LSHC) sectors
- Worked closely with Market Offering Leaders and Business Advisors for Performance Management process
- Tested and configured Reinventing Performance Management (RPM) to ensure it met expectations
- Facilitated Year-End consensus meetings with Counselors, and Business Advisors for sectors
- Executed enterprise data governance strategies in line with the organization s strategic plan and objectives
- Extracted headcount report from database and created custom presentations using pivot tables
- Leveraged Process Specialists in India for support on various project processes
- Advised Business Advisors on appropriate steps to take for employee dismissal
- Presented business cases for dismissal to Legal and Talent Departments
Confidential, New York, NY
Senior SAP HCM Analyst
Responsibilities:
- Extracted and synthesized SAP HCM reports for leadership team
- Point of contact for all ad hoc requests for system information including global headcount report
- Project lead for NY Metro region onboarding program
- Created/updated Vlookups, upcharts, formulas and spreadsheets utilizing Microsoft Excel for monthly reporting
- Participated in roll-out of new performance management process
- Exported data from SAP to Excel as needed
- Maintained Headcount report and updated it as required
- Responsible for creating and distributing custom SAP HCM payroll configuration reports
- Worked with Information Technology lead to troubleshoot any errors within database.
Confidential, Baltimore, MD
Market Unit Lead HR
Responsibilities:
- Responsible for organizational development through strategic planning initiatives
- Developing, evaluating, and implementing policies and programs for federal and state
- Manage compensation, performance management systems, and safety programs
- Responsible for advising and updating managers on organizational policy changes
- Traveled to multiple locations to educate and train employees on SAP HCM procedures
- Develop, implement, and manage college recruiting program between a total of 5 Michigan and Illinois universities
- Conduct market salary research for entry level consultants based on majors and location
- Creates Excel templates to automate complex analysis or processes that are intended for use by other staff
- Created job codes, position and requisition numbers and updated them as required
- Maintained Kronos T&A system
- Maintain internal database for recruitment program consisting of contact and diversity information
- Train newly hired consultants on corporate policies and completed onboarding procedure
- Assign lower-level tasks to additional campus recruiters and monitored expenses during travel
- Maintain work structure by updating job requirements and job descriptions for all positions
- Successfully obtained work visas for 11 colleagues through the expatriate program including 2 student visas
- Interface with EMEA and LATAM colleagues to complete policy and expatriate training
- Manage the human resources aspects of international employee placements
