We provide IT Staff Augmentation Services!

Sr. Data Analyst Resume

Katy, TX

SUMMARY

  • Senior Big Data Analyst with extensive experience in data strategy, business analysis in diverse scope of demanding business environments focused on using data to increase productivity, improve business processes.
  • Architect and Implement data framework using industry best practices to create a fluid, end - to-end vision for how data will flow through in Oil & Gas drilling fluids enterprise.
  • Expert in Systems of Engagement: utilizing exploratory data insights to help businesses understand customers, employees, and even their products and services.
  • Application Lifecycle Management Consultant: Strong experience in SDLC including maintenance, testing, and quality assurance. Experience in enterprise level project management and governance using industry frameworks SAFe, CMMI, Scrum and Agile Methodology.
  • SQL queries, sub-queries and joins to generate, User-defined functions, Indexes, Views, and effective functions to facilitate efficient data manipulation and data consistency.
  • Knowledge in handling huge databases - NoSQL and RDMS

TECHNICAL SKILLS

  • Data Mining & Analysis
  • Machine Learning
  • Rapidminer
  • R
  • Python
  • Tabeau
  • Power BI
  • MSSQL & MySQL, SSRS, SSIS
  • Data Warehouse, Data Lake
  • Data Governance
  • AWS - CLI, EC2, EMR, S3 Config.
  • Market Basket Analysis
  • Data Visualization & Presentation
  • Classification & Regression algorithms
  • Excel - Vlookup, Pivot Table, VBA, Macros
  • Business process improvement
  • Business analysis and design
  • Data QA
  • Relational Database Management
  • NoSQL- MongoDB/CouchDB
  • User documentation
  • Business Systems Documentation
  • Project Management
  • Experience in Agile / Scrum processes
  • Financial Analysis
  • Business Development
  • IoT Analysis and Solution.
  • HPE Networking Sys. Platform
  • Knowledge of Data Migration & Documentation
  • JiRA and TFS

PROFESSIONAL EXPERIENCE

Confidential - Katy, TX

Sr. Data Analyst

Responsibilities:

  • Manage deep dive analysis projects on various business topics to develop insights and solutions to complex problems.
  • Manage multiple enterprise-level databases migration from Dev. environment to Prod. Environment, persistence layer, maintain business logics, and adopt best practices.
  • Create and manage SSIS tasks that extracts data from multiple sources, with parse JAVA .exe (transform) the data and the tasks load incremental data in databases in automation.
  • Introduce and implement Data Quality Service (DQS) in enterprise system with SSIS.
  • Explore data to discover hidden insights and develop new metrics.
  • Continuously focus on ways to improve quality control within the data.
  • Lead data mapping, create data dictionary, and write technical/business User Stories in support of Recap Reports creation from drilling fluids management application in Agile software development.
  • Work with Solution Architect and DBA to implement data analytic framework.
  • Develop statistical hypothesis for to test sets of ML algorithms for products performance, loss circulation, and other drilling muds management and business processes.
  • Exploratory data analysis using Python - Panda, Numpy, Matplotlib and R - Plotly, and ggplots
  • Proactively communicate, and collaborate, with organizational departments and third-party vendors to determine needs and best suited tools. E.g setup and configure Azure Table Storage to load data collected from field sensors using .NET Azure Tables in Dev. and later migration to Production.
  • CouchDB Documents Refactoring, modeling, and security setup.
  • Meet with stakeholders to gather requirements, prioritize requirements, and find data-driven solutions to address their business problems. Identify, analyze, and interpret trends or patterns in loan defaults and collection data sets.

Confidential

Sr. Data Analyst

Responsibilities:

  • Manage deep dive analysis projects on various business topics to develop insights and solutions to complex problems.
  • Help with compliance audits and make sure data framework meets industry compliance standard.
  • Explore data to discover hidden insights and develop new metrics.
  • Continuously focus on ways to improve quality control within the data.
  • Develop and oversee company data governance practices from scratch.
  • Design and work with Data Architect and DBA to implement data analytic framework.
  • Exploratory data analysis of loan default data using Python - Panda, Numpy, Matplotlib
  • Proactively communicate, and collaborate, with organizational departments and third-party vendors to determine reporting needs and perform data analysis in support of those requests.
  • Use statistical methods and available report writing applications to analyze data and present the data in a manor best suited to the stakeholder’s needs.
  • Design, build and maintain Tableau visualization dashboards to monitor and visualize trends, patterns, customer behaviors, and KPI for multiple departments.
  • Validate and filter data to ensure integrity. Develop and implement data collection systems, data warehouse, data analytics and strategies that optimize the analysis process.
  • Use and support, database applications and analytical tools required to perform data collection and analysis. Document and maintain an extensive library of enterprise reports from multiple applications.

Confidential

Project Analyst

Responsibilities:

  • Coordinate with management in developing overall budget for assigned projects.
  • Ensure that project labor costs and activities are in accordance with allotted budget.
  • Perform project cost analysis and forecast actual costs and future commitments.
  • Monitor and control expenses within allotted cleanup project budget for ExxonMobile storage tanks, PEMEX, PetroEcuador.
  • Create statistical models to forecast time series and labor costs.
  • Work with finance team in maintaining project accounting, budgeting and capital planning systems. Develop workflow diagram, ensure cost-effectiveness, and timely signoffs.
  • Ensure proper collection and evaluation of data from multiple sources including employee databases, finance and AR databases.
  • Proactively communicate, and collaborate with departments for future project planning, expectation and provide support on data-driven requests.

Confidential

Sr. Data & Business System Consultant

Responsibilities:

  • Used SQL and R to extract, wrangled, analyzed, and explored insights of data from multiple sources that assisted users in identifying business problems, needs and functions in a big data environment.
  • Elicited comprehensive business requirements, studied and understood stakeholders’ concerns, identified improvement opportunities, and turned those requirements into developing the business case for the IT application development. Documented specifications for development.
  • Performed ETL and data mapping to the client and development team.
  • Delivered precise well documented functional specifications to include functional hierarchy, workflow, business rules, interface design and definitions, and outstanding issues.
  • Developed impact and cost analysis and forecast.
  • Conducted gap analysis between application and stated customer requirements and collaborate with developers to estimate project impact.
  • Created reports and highlighted key issues for business stakeholders using Excel Macros, Pivot tables, & VBA.
  • Managed multiple competing priorities through effective organization and communication.
  • Provided recommendations on best practice, tools and methodology towards standardization of the business analysis deliverables and procedures and collaborated with Development and QA Leads to uphold and improve Agile processes.
  • Designed functional specifications based on business processes requirement.
  • Validate quality delivery, testing, and QA on SaaS project for an ISV.
  • Worked on data migration and import.
  • Create necessary blueprint documents for functional requirements, Technical requirement documentation, design and implementation and review work performed by other team members as per established standards and requirements.
  • Extracted data from multiple database SQL queries for data analysis. Also used RMySQL to extract, load, and explored the data and performed data analysis for AT&T migration project.
  • Used R Caret package for machine several modeling projects.
  • Created visualizations reports and dashboard using ggplot2 or Plotly.
  • Created visualization and interactive dashboards in Tableau.
  • Created configuration files to deploy the SSIS packages across all environments. Transform and validate data using SQL (SSIS) Conditional Split, Lookup, Merge Join, Sort and Derived Column.
  • Construct, validate, and deploy predictive statistical models to improve client's sales and business
  • Performed data collections and sentiment analysis on smart phone devices using Qualtrics online survey tools for AT&T Sentiment Prediction project.
  • Led a team of analysts on a successful sales-oriented initiative to develop product recommender application for client’s eCommerce sites and in-store aisle positioning using market basket analysis to uncover any interesting associations between customer’s transactions and the items purchased.
  • Extracted and analyzed 48 months (over 2 million observations) of transactional data, creating sparse matrix datasets using arules package in R. Created items frequency visualization and documented exploratory insights using arulesViz package.
  • Applied Apriori algorithm to assess association rules using two types of measurements: statistical Support and Confidence measurements to measure itemsets or rules frequency and accuracy of the rules. Insights helped the client to visualize interesting patterns in item relationships within its transactions data. Client benefited from cross-selling products, recommended product sale promotions, and avoided expensive acquisition of competing business.
  • Created technical documents for SDLC.
  • Made recommendations that relate to the insights and findings

Hire Now