Post Job Free

Resume

Sign in

Data Engineer

Location:
Bloomington, IL
Posted:
December 14, 2020

Contact this candidate

Resume:

Bloomington, IL, USA 309-***-**** adin3t@r.postjobfree.com

Professional Summary

Over 4 years of diverse progressive experience in Information Technology, with emphasis on Business Analysis and Soft- ware Development. Expertise in working with Business Analysis, Business Processes, Business Process Models, Business Flow Diagrams, Business Requirement Documents. Experience includes expertise in all types of documents, diagrams, manual testing, objectives, cases, and scripts.

Skills

Predictive Analytics: R, Python, RStudio, Advanced MS-Excel (Pivot Table and VLOOKUP). Programing Languages: HTML, C++, C, SQL, JavaScript, PL/SQL. Databases: MySQL, SQL Server, MS-Access, MySQL, Transact-SQL, Neo4J, PostgreSQL. Methodologies: Agile/Scrum, Waterfall, RUP, Iterative, Incremental and Spiral Domain: Insurance, Healthcare, Homecare.

Modeling Tools: Gantt Chart, Flowcharts, Use Case, Activity, Class Diagrams, Workflows, Process Flow, UML.

Tools: MS Visio, ServiceNow, QlikView, Google Analytics, Amazon Redshift, Tableau, Track- wise, Visual Studio, VBA, Eclipse, Smartsheet, Slack, MS Word, Power BI, Balsamiq, MS PowerPoint, CSV Imports, MS Outlook, SharePoint, LucidChart, JIRA, SAP (Procure- ment, Production, Sales).

Concepts: Requirement Gathering, Financial Statement Analysis, Enterprise Implementations, Risk Manage- ment, Project Management, User Acceptance Testing (UAT), KPI Dashboards & Scorecards, Data Mining & Analytics

Work History

Role: Business Analyst 3SBusiness Corporation Texas, United States 07/2020 – Now

• Product Owner of Enterprise Search solution responsible for driving direction, business rules and requirements for operation of enterprise search application

• Collaborating with stakeholders to automate manual process across the organizations to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.

• Create and document personas, task flows, task analysis within the principles of User Centered Design process.

• Provide business requirements and direction to development team for digital solutions and perform interaction design and information architecture on digital products.

• Responsible for gathering business requirements by interviewing subject matter experts (SME) and web development groups to understand their business and functional requirements, gathering their future needs, and transforming them to functional specifications.

• Working with teams to design KPIs based on historical trends and data, created reports using PostgreSQL, analytical tools like Excel, Tableau and utilized the data to identify potential problems and recommended solutions

• Coordinates project delivery by participating in design reviews and walk-through to communicate systems designs and validate proposed solutions.

• Leading scrum master meetings and conducting product showcase and retrospective backlog Role: Senior System Engineer (Application Analyst) Infosys Limited Pune, Maharashtra Client: Reckitt Benckiser- UK based Client 07/2016 - 01/2018

• Created systems models, specifications, diagrams, and charts to provide direction to developers. Made recommenda- tions using data to improve policies, procedures, and processes.

• Created ETL jobs and Excel reports for client specific requirements.

• Transformed project data requirements into project data models, created UI specifications and wire frames.

• Enforced Kanban principles as a part of scrum team(agile) that increased the productivity by 20% goals for 2 years and thus increasing team's throughput in less than 8 weeks. Madhuri Arvind Patokar

• Managed and tracked change control process of requirements and design changes.

• Practiced Agile management ideals by participating in exercises such as sprint planning meetings, daily stand-up meet- ings, sprint review meetings, and sprint retrospective meeting.

• Develop project plans that conform to Software Development Life Cycle (SDLC) standards and provide comprehensive status reporting for ongoing programs of work.

• Interacted with business clients to perform various types of testing throughout the Software Testing Life Cycle (STLC) and provided weekly status updates showing the progress of the Automation testing effort and open issues to be re- solved.

• Mapping and process analysis of Reckitt Benckiser Application (TDS) processes, design and documentation of new/en- hanced processes, validation, and Process Sign-off documents.

• Extracted data from google analytics, CRM tools into MS Excel, implemented advanced functionalities like Pivot Ta- bles, VLOOKUP, and macros to perform data analysis for business, impacting insights and making recommendations.

• Increased customer retention by 5% and new customer acquisition by 10% by building customer lifecycle dashboard to enable personalized customer experience and collaborated with tech team to develop UI for live tracking and mass deployment.

• Performed cost-benefit analysis, generated reports for analyzing various investments and their profitability and for an- alyzing various lost opportunities due to time delay in investing. Role: System Engineer (IT Consultant) Infosys Limited Pune, Maharashtra 07/2014-06/2016 Client: Walmart- US based Client

• Evaluate risks related to requirements implementation, testing processes, project communications, and training saving the company on average $3500+.

• Translate stakeholder requirements using tools like Mendix, Balasmiq into different tangible deliverables such as func- tional specifications, Software Requirement Specification, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.

• Involved in defining the source to target data mappings, business rules and data definitions.

• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

• Extracted data from CRM tool ServiceNow for Reckitt Benckiser project in MS Excel to be used for analysis

• Experienced with ITIL Service Delivery and Service Support areas of Service Level, Availability, Capacity, Financial, and IT Service Continuity Management, Incident, Problem, Change, Release, Configuration Management and Service Desk.

• Used industry best practices for setting up meetings such as identifying stakeholders, managing, and facilitating require- ments elicitation and open questions/actions during the meeting, closing out meetings with next steps (action plan), JAD

(Joint Application Development) sessions, documenting and sending out meeting notes, and tracking progress of meet- ing decisions/actions

• Troubleshoot production and network issues and facilitated root cause analysis on incidents.

• Performed system, regression, load balancing, performance, System Integration Testing (SIT) and data interface testing.

• Identified manual processing deficiencies, and instituted automation techniques (by writing scripts in lotus notes) which reduced manual productivity and increased workflow efficiency.

• Administered and led the Design/Development/QA team of 8-10 members per project. Accomplishments

• Awarded with “Star Performer Award” for Productive and consistent performance over 3 years course.

• Certification: Mendix Rapid Developer.

Education and Training

Master of Science: Information Technology, 2020

Illinois State University- Normal, U.S. A Grade: 3.92 GPA Project- NBA Players Data Analysis (Python) Mar 2020 – Apr 2020 1. Analyzed the performance of top 10 players from 2005 to 2015, created functions to generate player specific results for the number of games played, number of field goals scored per game, and salary. Project- “Animal Cremation Website” Aug 2019-Dec 2019 1. Gathered business requirements and performed analysis, created Scope of Work (SOW) to define project require- ments, prepared business process maps to give the team a better understanding of the project. Developed use cases, workflow, screen mock-ups, and conversion requirements. Project- “Data Analysis-OSEMN” Nov 2018-Dec 2018

1. This project involved obtaining a large dataset (winery data) gathered from Kaggle. Used R to Scrub and Explore the data. Performed sentiment analysis on the data. Analyzed the data through bar graphs, box, and scatter plots to derive patterns.

Project- “Sell and Buy Application using Mendix” Aug 2018-Dec 2018 1. Used a new low code technology (Mendix) to create an application for students to Buy or Sell used items for less cost. Documented, coached, and elicited business requirements by writing user stories resulting in a clearer, more detailed way to get complete understanding of project deliverables. Bachelor of Science: Computer Science, 2014

Savitribai Phule Pune University Grade: 3.61 GPA



Contact this candidate