PIYUSH DUBEY

As an Application Developer:

• Identifying design flaws and performance bottlenecks, facilitating the development process and operations.
• Building suitable DevOps channels to ensure continuous integration and continuous delivery.
  Developing CI/CD pipelines using Jenkins to ease the code migration across the environments.
• Performing server maintenance using AWS services like EC2, EBS, S3 buckets, and databases like DynamoDB and Aurora.
• Designing reliable and stable new databases, optimizing existing databases and queries, and coming up with ideas to solve database performance and memory usage issues.
• Using Oracle SQL and PL/SQL to write queries, views, stored procedures, functions, and packages to extract data from different databases. Handling common database procedures such as upgrade, backup, recovery, migration, etc.
• Performing ETL operations after sourcing, cleaning, and storing raw data.
  Generating reports and dashboards using Tableau Desktop to interpret and share results.

As a Scrum Master

• At the organizational level, helping different teams set up the Agile framework within their teams.
• Working with businesses to extract and understand their requirements for new and existing business applications, and communicating these requirements within the team.
• Assisting in the technical investigation for new features and the development of business applications.
• Using analysis concepts, convert business requirements into technical solutions by understanding technical constraints and existing technical architecture and functionality.
• Preparing user stories derived from the business requirements.
• Presenting and refining user stories into agreed-upon acceptance criteria with the development team.
• Working alongside developers to ensure that any developments are in line with requirements and are tested to an appropriate level before release.
• Acting as the main point of contact for the development team for product management and requirements.
• Assisting in the building, delivery, and execution of test plans associated with any related developments.
• Prioritizing defects for the team.
• Ensuring a high level of quality documentation is in place to cover both new developments and changes to existing applications.
• Managing a development team backlog by product management priorities.
• Using the team backlog, providing input into sprint and release planning.

• Deputed to client location in Ludwigshafen, Germany. Worked in parallelly with clients.
• Developed and maintained data management systems, databases and reporting tools.
• Collaborated with business teams to understand data needs and provide insights for decision-making and ensure timely delivery of data solutions.
• Collecting, processing and analyzing data to ensure accuracy, consistency and reliability.
• Experienced with SQL, PL/SQL, Python and other data tools to extract and manipulate data efficiently.
  Performing data modelling, administration, and visualization.
• Assisted in data migration, integration and transformation projects. Also performed Role-Based security using DCL.
• Maintained documentation for data processes, workflows and standard operating procedures.
  Supported data governance initiatives by enforcing policies, security and compliance measures.
• Assisted in process automation and optimization for improved data delivery efficiency.
• Expansion of PROS Application in accordance with the client’s requirements. Provided and implemented the solution to complicated pricing issues. Also designed pricing strategies and helped customers to create order proposals.
• Responsible for the PROS tool enhancement as per business requirements using Pricing Optimizer (PO), Deal Optimizer (DO) and Scientific Analytics modules (SA).
• Developed Worksheets, Workbooks, Dashboards using Tableau Desktop. Delivered advanced/complex reporting solutions such as dashboards and standardized reporting by using Multiple Measures Data Blending, Individual Axis, Dual axis and Actions.
• Worked on table calculations, calculated measures and parameters, and charts like pie charts, bar charts, line charts, scatter plot charts, maps, etc.
• Responsible for Operations tasks like System and Application Monitoring, Runbook creation, Deployment Quality and Production environments, Production Support and Incident Management.
• Handled Test Cases for Unit Testing (UT), Functional Testing (FT) and System Integrated Testing (SIT). Involved in other documentation which involved – Code Development Request (CDR), Knowledge Documents (KD), Business Requirement Documents, etc.

• Deputed to the client location in Mumbai. Worked in parallel with the client for requirement gathering, build, unit testing, and documentation of the projects in scope.
• Frequently created Procedures, Functions, and Packages to meet the project requirements.
• Improved script performance by doing performance tuning and query optimization.
• Created User Roles and Privileges using DCL. Responsible for ETL operations i.e., extraction and processing of data from different databases, then loading this data into the target database.
• Developed ETL Jobs, Triggers, Sequences, DB Links, and other PL/SQL objects.
• Responsible for maintaining the client’s application web portal using HTML, CSS and JavaScript.
• Performed Unit testing, Functional Testing, Deployment, and Maintenance.
• Implementation of technical and functional changes as per the requirements.

• Designed, developed, and deployed the application single-handedly from scratch.
• Created Table Architecture using Low-Level Diagrams (LLD) and Entity Relationship Diagrams (ERD).
• Performed Normalization. Created Procedures, Functions, Triggers, and Packages as per the requirements.
• Managed the web application using ASP.NET and web technologies i.e., HTML, CSS, JS, etc.
• Responsible for scheduling tasks using Computer Associates Workaround Automation (CAWA) Tool.