We provide IT Staff Augmentation Services!

Data Analyst/data Engineer Resume

SUMMARY

  • Over 6+ years of experience in IT industry with Data analytics and reporting as Data Analyst with Tableau, Power BI, MS SQL Server and Python with strong background in Databases and Data warehousing concepts.
  • Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.
  • Expertise in writing T - SQL queries, dynamic queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User-Defined Functions, Views, Constraints (Primary key, Foreign key, Unique key, check key etc.) and cursors.
  • Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP),Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
  • Experience in configuring reports from different data sources using multiple data sources like flat files, CSV, Excel, MYSQL Server, Oracle database and blending the data to build a relationship between them in reports .
  • Worked and created data solutions on various SQL databases engines following best practices for the performance tuning of SQL server queries
  • Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler.
  • Immense Knowledge and skills in statistical analysis, market data visualizations, status reports KPI/Metrics analysis and Dashboard Development
  • Experience in Handling ETL (Extraction, Transformation, and Loading) process and exporting data to flat files to MySQL.
  • Experience in validating the results in Tableau by running SQL queries in MS SQL developer.
  • Good understanding of Data Modelling concepts like Dimensional Data Modelling, Star Schema and Snow-Flake, Functions, Measures and Dimensions Tables.
  • Strong Programming Knowledge with Python programming, SQL queries, procedures, triggers.
  • Experience in Administration/Maintenance of source control management systems, such as Sub Version (SVN), Perforce, CVS, TFS, GIT and knowledge of Clear Case
  • Expert in migrating data from Salesforce CRM into tableau.
  • Implemented the best practice of complete life cycle management and deployment strategy of reports in Power BI Service by leveraging the New Power BI workspace experience and one drive
  • Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
  • Excellent technical, communication and interpersonal skills with very good troubleshooting and problem-solving skills. Ability to work on multiple tasks in a fast-paced environment independently and in a team.

TECHNICAL SKILLS

  • Salesforce
  • CPQ
  • SQL
  • MS-Office Suite
  • Sales Process
  • Quality Audit
  • Python
  • Tableau
  • Power BI
  • Data Structures

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst/Data Engineer

Responsibilities:

  • Worked on generating various dashboards in Tableau using various sources such as SAP, SQL, Server/Teradata/Oracle analysis data for generated at different hubs and locations.
  • Monitored the server logons and reviewed the security checks.
  • Developed innovated and easily navigated Dashboards that are a part of the mobile devices the Confidential installation field agents carry to make order bookings, create new orders or ship the request orders.
  • Write Python scripts to parse JSON documents and load the data in database.
  • Analyzed data trends using packages like Numpy, Pandas and Matplotlib in Python.
  • Analyzing various logs that are been generating and predicting/forecasting next occurrence of event with various Python libraries.
  • Using different calculations levels, parameters, action filters, groups, sets, binary sets in Tableau.
  • Understood of the complex relational database structures and data warehouse structure to feed data continuously without and load failures to the Tableau reports.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Sybase Database/Teradata/Business Objects.
  • Worked closely with business power users to create reports/dashboards using Tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet.
  • Worked on the development of SQL queries and PL/SQL code.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Administer user, user groups etc.
  • Created and monitored the report data refresh schedules on Tableau server and monitored data feed loads.
  • Wrote custom SQL queries with related joins and union functions to query data from database.
  • Excellent in debugging analytical and forecasting problem solving skills with strong ability to quickly adapt to business processes and effectively develop technical solutions to according to their requirement.

Confidential

Data Analyst/Data Engineer

Responsibilities:

  • Worked as Data Analyst for NA Robotic Fulfillment centers and was responsible for the quality audit of the amazon warehouses in stowing/pick/pack/sorting and dock department.
  • Data mining, analysis using statistical techniques on large-scale Supply Chain and analyzes data and investigate new growth opportunities for the fulfillment centers by finding efficient and quality way to store product into the inventory.
  • Generated reports from numerous databases (using Excel, Access, SQL and/or other data management systems) and performed ad hoc reporting.
  • Created dashboard reports to track overall business results as well as lead efforts using Tableau.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Administer user, user groups etc.
  • Researched and suggested effective guidelines to improve the time for stowing which improved the packing time by 10%.
  • Used Pandas, Numpy, Scipy, Scikit-learn, NLTK in Python for scientific computing and data analysis.
  • Supported as Transportation Specialist in NOC Team. Accomplished continual, tactical communication with external and internal customers which include Retail, Finance, Software Support and Fulfillment Centers.

Confidential

Data Analyst

Responsibilities:

  • Collect data from sales, marketing, and finance departments to use in establishing organizational structure.
  • Organize, extrapolate, and disseminate data across departments to be used for drawing conclusions about the success of current methods.
  • Present detailed reports about the meaning of gathered data to members of management and help them identify scenarios utilizing modifications in the data.
  • Delivered data summaries and monthly productivity reports of ten department programs.
  • Analyzed and summarized patient satisfaction survey data and produce yearly reports.
  • Created web-based surveys and reported data using SurveyMonkey.com.
  • Generated reports for sales forecasting and consultant sales performances on monthly basics.
  • Worked with a team of analysts in the collection and dissemination of company performance via multiple reporting tools/methodologies.

Intern Data Analyst

Confidential

Responsibilities:

  • Created the database objects, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.
  • Managed the user access, logins, audit trials, assigning user rules and permissions.
  • Created Table views and functions to restrict the data visibility based on user access and to implement security.
  • Administrated the SQL Server with various tools like SQL Server Enterprise Manager and Query Analyzer to monitor the server health.
  • Developed MS-SQL queries and procedures, custom reports, and modified the ERP user forms to enhance
  • Organizational productivity.
  • Retrieved the metadata from the SQL Server System Tables.
  • Responsible for troubleshooting and minimizing issues related to data loads, server slow down and production issues.
  • Scripted several stored procedures and triggers required from the program queries as per the client requirements.
  • Monitored and fixed the DBCC consistency checks and data corruption issues occurred in the application.

Hire Now