We provide IT Staff Augmentation Services!

Data Engineer Resume

SUMMARY

  • A versatile IT Guru with strong debugging skills offers a solid understanding of Data and analytics as well as proven technical leadership and project management skills.
  • Leverages comprehensive technical expertise for software engineering, data management, and developing innovative business solutions for corporate customers.
  • Technology Stack: Expert Microsoft Excel, PostgreSQL, SQL/DAX, SSMS, Microsoft Azure, Python, Collibra DGC, Spark, Pyspark, Power BI, PowerApps, VBA, MATLAB, Tableau, IBM SPSS Modeler, IBM Cognos, SAP, Dynamics 365, AWS, Google Cloud, R, MATLAB, ETL, SSRS/SSIS/SSAS
  • Vast experience in gathering data and analysing information/ Exceptional in learning new software
  • Excellent troubleshooting skills with the ability to solve software bugs
  • Strong organization, analytical and problem - solving skills
  • Experience with varieties of Engineering software while working on different projects
  • Familiarity with data management tools, Salesforce, SAP
  • Proven ability to understand and work with big data from various sources using Spark and Hadoop.

PROFESSIONAL EXPERIENCE

Data Engineer

Confidential

Responsibilities:

  • Act as a subject matter expert (SME) for data storage requirements as they relate to the needs of the organization.
  • Design and Develop ETL Pipeline to ingest data using Azure Logic Apps and Azure Data Factory.
  • Perform the GAP analysis between applications to migrate them to newer solutions.
  • Designs, develops, implements, and installs defined SQL Server database systems and maintains enterprise level database systems.
  • Testing, fixing, improving, and deploying software and solutions.
  • Actively troubleshoot and correct database problems to proactively maintain the health of database systems.
  • Provide guidance on the structure of data sources, drafting of queries, compiling of operational type business intelligence data to various departments.
  • Write complex scripts to preprocess files and schedule ETL jobs.
  • Implemented BI solutions in SQL 2008/2012 database, ETL, SSRS, SSIS AND SSAS
  • Meeting project milestones and delivering working solutions.
  • Handle all requests with a high standard of quality and professionalism; determine the best course of action to ensure resolution meets established standards.
  • Coordinate activities with business units. Provide analysis and interpretation in clear user language.
  • Document activities as required in compliance with established controls, delivery schedule, process documents.
  • Maintain knowledge of business unit policies and procedures, systems, and requirements.
  • Identify opportunities for process improvements, document them and collaborate with the team to move them forward.
  • Participate in department objectives; including quality and productivity standards and other duties as assigned within the department.
  • Assisting customers (internal and external) through each phase of the software lifecycle, including requirements, delivery, and support.
  • Works on problems of moderate scope where analysis of situations or data requires a review of a variety of factors.
  • Coaching and mentorship for other members of the BI&A team.

Data Analyst

Confidential

Responsibilities:

  • Undertake data collection from multiple sources, data cleanup, data testing, verification and preparation for analysis.
  • Developed visual reports, dashboards and KPI scorecards using Power BI, Excel
  • Developed and Published PowerApps from Scratch for contractors and stakeholder engagement.
  • Loaded data from different source system into SQL database environment (pre-staging, staging, development, testing and production) using Azure data factory.
  • Created dashboards and reports to effectively visualize information for stakeholder engagement using Power BI and Tableau.
  • Visualization and manipulation of Data structures with Python using Seaborne package and Pandas.Gathered and analyzed project information to ensure targets were being met and project lifecycle was successfully tracked.
  • Established, configured and governed an enterprise data governance and metadata management with Collibra.
  • Managed instances on Azure platforms, data factory, data bricks and created multiple data warehouses.
  • Roll out an enterprise wide data governance framework, with a focus on improvement of data quality and the protection of sensitive data through modifications to organization behavior policies and standards, principles, governance metrics, processes, related tools and data architecture
  • Define roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company’s principal information assets
  • Advanced knowledge of non relational DB structures like Cosmos DB and Mongo DB
  • Produced ETL mapping and transformation rules, data quality documentation for various projects
  • Worked on various projects using Agile framework for Automation projects including technologies like SAP BO, Tableau, SAP, MS Access, Power BI, SQL Server etc.
  • Using scrum framework (Agile) to manage in-progress data tasks and backlog.
  • Checked and verified that overnight data load had completed successfully, collect stats.
  • Implemented BI solutions in SQL 2008/2012 database, ETL, SSRS, SSIS AND SSAS
  • Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.

Data Analyst

Confidential

Responsibilities:

  • Developed, maintained, and enhanced existing databases and reports in SQL environment
  • Created and maintained data flow diagrams and data dictionaries
  • Interpreted data and analyzed results using statistical techniques, Power BI and IBM Cognos and provided ongoing reports
  • Developed data models for review and approval which meet the needs of the organization's information systems and business requirements
  • Prepared documents such as business process, data models, and high-level user documents
  • Actively participated in review of team deliverables, contributing to the development of consistent and effective documentation that adheres to team standards and templates
  • Perform data modeling using Oracle.
  • Deep dive Order Management and Billing data in MS SQL Server.
  • Work with Logistics data in MS Access
  • Predicted analysis of trends and forecasts using SPSS Modeler and recommended actions for optimization
  • Utilized advanced Excel functions to organize and analyze data
  • Developed recommendations to improve business operations going forward

Operating Analyst

Confidential

Responsibilities:

  • Identified operational requirements and opportunities for improvement
  • Reviewed company policies and business process
  • Acquired data from primary and secondary data sources into SQL database environment.
  • Analyzed data and information to identify business opportunities using Excel, Tableau and SSRS
  • Produced effective and professional written materials including presentations to stakeholder groups
  • Analyzed customer requests and provide guidance and technical assistance on obtaining accurate information from our internal data warehouse.
  • Managed group collaboration with business stakeholders, effectively facilitate small to medium size meetings and workshops and elicit meaningful input from all members of the group

Hire Now