We provide IT Staff Augmentation Services!

Data Analyst Iii Resume

Irvine, TX

SUMMARY

  • Overall 7yrs of Experience in collecting, organizing, interpreting, and disseminating various types of statistical figures.
  • Energetic presenter and confident communicator with the ability to circulate information clearly, efficient, and beneficial for end users.
  • Creative in finding solutions to problems and determining modifications for optimal use of organizational data.
  • Expert at providing realistic projections and establishing various scenarios to determine viable process strategies to utilize.
  • Organized and timely in providing staff, departmental members, and executive management with reports on specific data findings and their impact on organizational growth and success.
  • Data Analyst with strong experience in business intelligence, data mining, analytics, statistical modelling, visualization, data wrangling, data administration and ETL in challenging IT industry.
  • Proficient in Python, Power BI, SQL, MS Excel, MS Access, and Tableau,
  • Experienced in building statistical models - regression analysis, variance analysis, hypothesis testing.
  • Strong Experience in Requirement Gathering, Analysis, Elicitation, Business Requirements Mapping, Requirement Management, Designing Customized Solutions and Business Mapping with strong ability to analyse business practices and define optimal procedures. Expert in clarifying client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders Integrated Eligibility Systems.
  • Experienced as Data analyst with Datawarehouse- designing database structures, involved in creating and deploying SSIS Packages and Cubes.
  • Experienced working with complete Software Development Life Cycle (SDLC) such as Agile (Scrum & Sprints), Waterfall and RUP Methodologies.
  • Excellent Interpersonal, and Analytical skills, with ability to handle challenges under pressure with ease.
  • Outstanding organizational skills including ability to multitask, prioritize, and manage complex issues.
  • Extensive experience in business analysis, gap analysis, cost/benefit analysis, risk analysis, testing, development of functional specifications and project planning.
  • Experienced with Python and R, involved in developing Predictive analysis, artificial intelligence for workforce reports and workforce management.
  • Experienced working with complete Software Development Life Cycle (SDLC) such as Agile (Scrum & Sprints) and Waterfall methodology.
  • Three plus years of experience in all phases of Project Development Life Cycle: business analysis, system analysis, design, development and implementation of Business applications.
  • Strong business acumen, strategic thinking in a multicultural environment and presentation skills adept at creating, editing, and coordinating extensive communication networks.
  • Experienced with Insurance domain payer, Encounters Revenue and Remediation efforts Claims and Clinical Trails systems configuration (Facets) along with Medicare/Medicaid knowledge.
  • Strong Microsoft Office skills, particularly with Word, Excel, PowerPoint and SharePoint, Outlook and other tools like WebEx and Dashboards.
  • Experienced with Finance applications and finance/accounting structure as well as reporting measures.
  • Postproduction support to the environment upgrades, Database refreshes, SSAS tabular model refresh, scalability of the resource and add/remove user access
  • Competent communicator and confident presenter to report analytics findings to members of senior management.
  • Technologically-savvy to assist end users with understanding technology, software updates, and changes to existing protocols.
  • Enthusiastic and friendly team player who can motivate colleagues and contribute to shared objectives in efforts to accomplish departmental goals.

TECHNICAL SKILLS

  • SQL
  • Python
  • Pandas
  • NumPy
  • Seaborn.
  • Matplotlib plotly beautiful Soup
  • SQL Server Management System
  • SAS
  • Power BI
  • Tableau
  • Snowflake
  • Microsoft Excel
  • VLOOKUP
  • VBA
  • Data Charts
  • Microsoft Visio
  • Microsoft Access

PROFESSIONAL EXPERIENCE

Data Analyst III

Confidential, Irvine, TX

Responsibilities:

  • Report on findings and make recommendations; summarize analyses into clear, concise and effective presentations; deliver content at the executive level.
  • Perform data integrity audits; evaluate and establish methods and procedures for managing data
  • Compose internal documentation that details processes and findings; assist with the development of standards for internal documentation
  • Analysis of data by conducting queries in SQL and producing more complex inferential analysis.
  • Work with stakeholders to assist with data-related technical issues and support their data needs.
  • Provide training and guidance on how to interpret and apply the most complex data
  • Communicate results and ideas to key decision makers
  • Provide guidance and direction for the most complex, cross-functional projects.
  • Operate as an innovative thought leader; contribute significantly to the overall growth and quality of the department through knowledge sharing and coaching on current best practices and market trends
  • Data Visualization: Build Dashboards using Power BI- this includes data mapping, cleaning, building data measures using DAX formulas, building KPIs, and various kinds of charts and graphs.
  • Worked on data cleansing, data Extraction, Transformation and Loading design, development, source to target mappings, data warehouse transformations, performance tuning, testing and documentation.
  • Working with JIRA Confluence and Kanban Board to ensure Agile/Scrumconcepts and principles are adhered to and make the tough calls.
  • Working on SQL queries to extract the data from database along with data analysis for ETL, DataStage and Master Data Management (MDM).
  • Designed, developed and supported ETL processes for data staging, extraction, transformation, and loading of fact tables, data cleansing, automating ETL and master data management (MDM) processes

Data Analyst

Confidential

Responsibilities:

  • Develop data analytics and visualization solutions in line with business requirements using tools such as Power BI or Tableau or Zoho Analytics.
  • Uncovered data acquisition and analysis opportunities.
  • Prepared reporting models using MS excel and MS Access
  • Developed reports to support improvement of performance and results.
  • Analysis of data by conducting queries in SQL and producing more complex inferential analysis.
  • Work with stakeholders to assist with data-related technical issues and support their data needs.
  • Enhancing data collection procedures to include information that is relevant for building analytic systems
  • Produce business dashboards in line with business strategy
  • Communicate results and ideas to key decision makers
  • Help implement the changes suggested by the data you provide
  • Data Visualization: Created Inventory dashboard which helped company to track inventory status and take informed business decision in real time.
  • Business Intelligence: Performed detailed data analysis on CRM to understand the possible reasons for limited lead conversion, this analysis increases the conversion rate by 12% within a month.

Financial Data Analyst

Confidential

Responsibilities:
  • Created ER diagrams for powerful queries to extract large database information using SQL.
  • Uncovered data acquisition and analysis opportunities.
  • Prepared reporting models using MS excel and MS Access
  • Developed reports to support improvement of performance and results.
  • Create and maintain optimal data pipeline architecture for client data - ETL.
  • Analysis of data by conducting queries in SQL and producing more complex inferential analysis.
  • Completing ad hoc data requests and reports.
  • Work with stakeholders to assist with data-related technical issues and support their data needs.
  • Data Visualization: Designed data reporting model using Power BI DAX to produce quarterly reports, provided insights on patterns of investments, and suggested new ways to trade using statistics and calculated measures with 85% accuracy.
  • Business Intelligence: Executed data mining and detailed data analysis to understand and present possible reasons for limited revenue from investment compared to market. Reported a serious potential improvement in the process of investments to improve the revenue by 15%.
  • Organized quarterly projection data gathered by senior analysts in an orderly way for executive management.
  • Reported bi-monthly data analysis findings to upper management to use in making organizational decisions.
  • Worked with advanced calculations to draw conclusions about data findings.
  • Assisted superiors with interpreting data and compiling it in an organized manner.
  • Presented detailed reports each quarter to upper management alongside my apprentice supervisor.

Data Analyst

Confidential

Responsibilities:

  • Project - Customers” preference on investing in Equity or preference shares”
  • Gathering data, organizing information to identify investment behavior, trend, and patterns.
  • Effectively worked with unstructured and structured data to build a statistical model for the company without any technical knowhow.
  • Prepared ad hoc reports and presentation.
  • Responsible for analysing and presenting financial data to the management of an organization, helping them to make informed decisions.
  • Designing and maintaining data systems and databases; this includes fixing coding errors and other data-related problems.
  • Mining data from primary and secondary sources, then reorganizing said data in a format that can be easily read by either human or machine.
  • Using statistical tools to interpret data sets, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts.
  • Demonstrating the significance of their work in the context of local, national, and global trends that impact both their organization and industry.
  • Preparing reports for executive leadership that effectively communicate trends, patterns, and predictions using relevant data.
  • Translating numbers and facts to inform strategic business decisions
  • Analyzing sales figures, market research, logistics, or transport data
  • Creating and following processes to keep data confidential
  • Coming up with solutions to costly business problems
  • Collaborating with programmers, engineers, and organizational leaders to identify opportunities for process improvements, recommend system modifications, and develop policies for data governance.
  • Creating appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary.

Hire Now