Hrbi Data Analyst/ Consultant Resume
0/5 (Submit Your Rating)
SUMMARY:
- and experience in process improvement project management
- Six Sigma black belt . Exposure to Lean, Agile and Waterfall
- Database design, optimization and querying, and exposure to data warehousing
- Ability to influence without authority
- Ability and willingness to lead, but also to follow when necessary
- Proven ability to work under pressure in a fast paced environment and meet strict deadlines while maintaining quality of work
- Strong communication skills, both written and verbal
TECHNICAL SKILLS:
Skills: Strong proficiency in Microsoft Office Suite including macro development Excel, Access, Word, Power Point, Visio, Project, Outlook, Share Point Experience with MS SQL Server Stack (SSIS, SSAS) Programming/Data Experience: T - SQL, PL/SQL, Visual Basic, VBA, SAS, Unix, Java Experience in data analysis and visualization tools: Power BI, Excel, SAS, MicroStrategy, Tableau, Minitab
WORK EXPERIENCE:
Confidential
HRBI Data Analyst/ Consultant
Responsibilities:
- Development of project plan and requirement documentation in order to meet customer specifications and establish milestones and timeline
- Tabular data model development integrating data from numerous sources and formats
- Dashboard development including performance, satisfaction, and attrition metrics
- Tools used include Power BI, SQL Server, SSAS, SSIS and Excel
Confidential
Data Analyst
Responsibilities:
- Job Duties include providing technical and strategic support to various Revenue Operations departments and legal projects
- Development and maintenance on recurring reports in various tools including PL/SQL Developer, SSIS, SQL Server, Excel, Tableau, Access, Share Point, Power Point, Netezza and VBA
- Developed a flexible, scalable MIS system to aggregate reports and create a consolidated source of performance metrics to support 300+ Collections teammates and leaders
- Aggregates 14 sources in 4 formats (Oracle, SQL Server, MS Access & Excel)
- Automated ETL Process using SSIS with SQL Server as reporting back end
- Primary data transformations through SQL Server stored procedures
- Dynamic data connection to Excel for final data visualization and additional functionality
Confidential
Business/Operations Analyst
Responsibilities:
- Development of text based keyword data mining models to identify potential regulatory violations within complaint and customer satisfaction datasets
- Dashboard and intelligent cube design and development for key performance indicator tracking and forecasting using Excel, Base SAS, Visual Analytics and/or MicroStrategy
- Project management and support for process improvement efforts via Six Sigma, Agile and/or Waterfall methodologies.
- Experience coordinating and supporting both onshore and offshore technology teams
- Automation of data standardization, report generation and distribution using Base SAS, MS Office Products and MicroStrategy
- Redesign of regulatory text mining program reducing program length by >95% and increasing efficiency many fold
- Responsible for creating, maintaining and running business ETL (Extract Transform Load) process using SQL Server and SAS products ed Confidential Achievers Circle, Net Promoter and several Leadership s
- Developed and facilitated technical s for leaders in Excel, basic reporting and other business applications