We provide IT Staff Augmentation Services!

Data Analyst Resume

Atlanta, GA

SUMMARY

  • Passionate Data Analyst with 5+ years of IT experience in Data Wrangling and analyzing data, ETL Process and Data Modeling.
  • Experience of complete Software Development lifecycle (SDLC) process.
  • Participated in all phases of Data management including data collection, data cleaning, data mining, developing models and visualizations using Tableau and PowerBI.
  • Involved in data science project life cycle comprising data extraction, data cleansing, statistical modeling, and data visualization with large data sets of structured and unstructured data. And discover meaningful business insights.
  • Experienced Analyst with a demonstrated history of working with Data. Skilled in Data analysis,Python,Excel, SQL, Statistics.
  • Skilled at performing data cleansing, parsing, manipulation, and preparation using approaches such as describe data contents, regex, split and combine, merge, subset, descriptive statistics of data, and reshape
  • Developed queries to retrieve and analyze data from multiple databases. Found tables using database diagrams in SQL server, established relationships in multiple tables using Primary and Foreign keys.
  • Building queries to extract the information using SQL. Experience in Data Cleaning and Visualization using Python, Tableau to save time and increase efficiency.
  • Extensive experience in creating interactive dashboards with guided techniques such as drill down capability, slicing and dicing of data and navigating to external webpage with URL’s using tableau desktop.
  • Proficient with data visualizations tools like Tableau, Power BI.
  • Knowledge in NoSQL databases such as Mongo DB
  • Ability to extract Web search and data collection, Web data mining, Extract database from a website, Extract Data entry and Data processing using Python.
  • Experience working with SAS Language for validatingdataand generating reports.
  • Statistics: Hypothetical Testing, ANOVA, Chi - Square, Cross-Validation, Correlation, P-value, Sampling Methods, Normal Distribution.
  • Great understanding of business operations, analytical tools for efficient analysis of data, project management and customer relations.
  • Excellent technical and professional client interaction skills. Interacted with technical, functional and business audiences across different phases of the project life cycle.
  • Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Python concepts: Lists, Dictionaries, Tuples, Numpy, Pandas, Matplotlib.

Reporting & Visualization Tools: Matplotlib, Tableau, PowerBI

Statistics: SAS Studio, Hypothesis Testing, Gephi.

Design Tools: Matlab, Xilinx, Keil Microvision, Microsoft Visual Studio, Microsoft SQL Server.

Databases: MySQL, SQL Server, SQL Navigator, SQL Developer, MS Access.

Operating Systems: Windows, IOS, Linux, Android, Unix.

Web Technologies: HTML, CSS, XML, Java.

Softwares: Wireshark, PythonShell, Pycharm.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Data Analyst

Responsibilities:

  • Analyzed business requirements, prepared design documents, and developed python and SQL scripts for business intelligence reporting solution for the Clients
  • Built Tableau based visualization platform to view historic data, to comparison between various issuers, analytics for different markets
  • Utilized python features such as split, merge, join, concat to cleans and transform raw datasets
  • Developed SQL scripts using joins, aggregate functions, case statements, single-row functions, union and minus functionalities for various data analysis and validation
  • Involved in creating graphs by utilizing various data measures and corresponding dimensions from various databases using data-blending concept
  • Involved in the data analysis and data discrepancy reduction for the source and target schemas.
  • Extensively used Tableau advanced analysis actions, calculations, background images, maps, trend lines, statistics, and table calculations
  • Prepared donut charts and implemented complex features within charts such as bar chart using tooltip
  • Used excel sheet, flat files, CSV files to generate Tableau ad hoc reports
  • Generated context filters and used performance actions while handling huge volume of data.
  • Translated business requirements into data analysis, BI data sources and reporting solutions for various internal clients
  • Utilized complex query statements using sub queries, correlated queries, case statements, and aggregate functions
  • Perform variety of data validation using SQL and python Pandas functionalities
  • Developed tableau dashboard for various daily tests with data from three different testing platforms
  • Analyzed business requirements, prepared data flow design documents, and built data cleansing processes
  • Involved in the data analysis and data discrepancy reduction for the source and target schemas
  • Created various Oracle database objects like tables, views, indexes, sequences, functions
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
  • Prepared dashboards using various calculation parameter using tableau
  • Used Python pandas and MySQL to process and transform large data sets
  • Analyzing various logs for predicting/forecasting next occurrence of event with various Python libraries such as pandas, Numpy and matplotlib
  • Created different KPI using key figures and calculated parameters for M&A division
  • Well-versed with various data formats such as CSV, JSON, XML, TSV and parquet
  • Worked on data transformation and accessed raw marketing data in varied formats with different methods for analyzing and processing
  • Provided support to end users for production issues and built custom SQL scripts for business needs
  • Involved in creating ad hoc analysis and reporting requests in a timely manner for Risk Metrics related to fraud analytics engine

Confidential, Atlanta, GA

Data Analyst

Responsibilities:

  • Research, analyze and prepare reports on a wide variety of markets and competitor data to support business development and strategic initiatives.
  • Responsible for creating SSIS packages to extract data from different sources, consolidate and merge into a single source.
  • Create data models that illustrate relationships between tables and other database objects.
  • Create and document constraints that ensure integrity of data.
  • Create queries that are efficient with an emphasis on performance.
  • Diagnose and tune poorly performing queries.
  • Work with analysts, end users, and other developers to analyze and design solutions that meet business objectives.
  • Involved in End- to -End Success Factors Employee Central implementation project.
  • Served as SME for Foundation objects and good knowledge of Employee objects and foundation objects.
  • Worked in collaboration with HR business partners, developers and Solution architects to implement EC.
  • Worked extensively on Data Mapping and Transformation process from Legacy SAP, Oracle HRMS to SAP Success Factors Employee Central for foundation and Employee objects.
  • Created data models in access for few Employee objects.
  • Performed Data Validation to ensure Data quality, completeness and correctness by working with business partners using MS Access and MS Excel
  • Provides the target population and work with the data quality team
  • Compared and validated pre-load & post-load data migrated by the ETL team to ensure the data accuracy between source & target tables.
  • Managed and uploaded Foundation data and Employee data into Success Factors on a regular basis.
  • Created Employee PTO database and corresponding Tables usingDDLstatements
  • Used DML statements to retrieve, delete or update the data and Joins to get data from multiple tables.
  • Managed data defects encountered cutover and Mock
  • Maintained data mapping spread sheets, transformation logic and validation checklists.
  • Involved in the day-to-day ETL activities performed by the BackOffice team and served as the nodal point of contact for the business teams.
  • Used MS Visio for flow-charting, process model and architectural design of the application.
  • Performed post production support in the Hypercare team built to stabilize the newly implemented SAP system.
  • Performed data governance activities including audit reports and replication issues as part of the stabilization and maintenance phase of the migration project.
  • Implemented data governance using Microsoft Visio and Excel
  • Established and maintained programs to monitor and measure data governance adoption and achievement of program objectives.
  • Documented and maintained data governance activities, maintains logs, and records issues and corresponding resolutions.
  • Resolving the incidents and drove the defects to closure as part of the support team via Jira.
  • Created the training material and conducted the training sessions to familiarize the end users on the functionalities of the new SuccessFactors module.
  • Created load files and supported for all the data loads in to Success factors EC after post Production

Confidential

SQL Database developer/ Data analyst

Responsibilities:

  • Worked on SQL developer for data cleaning, altering the data and data masking for concealing the identity of the user.
  • Merged and matched differentdatasets from differentdatasources using SQL.
  • Conditional filtering of data and analyzing to improve the performance and to meet the customer requirement.
  • Loaded and transformed large sets of structured, semi structured and unstructured data.
  • Checking for the status of the parameters by collating the comparison scripts and the xml files.
  • Troubleshooting errors and testing for discrepancies, to provide efficient results at all time.
  • Developed and reviewed SQL queries with use of joins (inner, left, right) in Tableau Desktop to validate static and dynamic data for validation.
  • Worked closely with cross functional teams for providing full support to solve the issues efficiently with greater customer satisfaction.
  • Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed system is displaying accurate up-to-date live data.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
  • Effectively conveyed weekly project status, burn down charts to the stakeholders.

Confidential

Data Analyst

Responsibilities:

  • Analyze and transform data using various SQL functionalities using MySQL server to generate data extracts and reports
  • Standardized incorrect data formats, misspellings, redundant, missing data values and performed de-duplication of customer data
  • Participated in status, requirement, and technical review meeting
  • Closelyinteracted withmanagement for client’s business and reporting requirements
  • Written SQL statements using joins, sub queries, aggregate functions, case statements and other advanced functionalities
  • Utilized SQLfeatures like inner join, intersect, union all and union syntax for various data analysis purposes
  • Developed VBA scripts to automate the data extraction and reporting in EXCEL thus improving efficiency by a factor of 10
  • Utilized Advanced Excel features such as formulas, Pivot Tables for managing large data sets.

Hire Now