Laxminath Dewangan

Experience

• 

  Simplex Castings Ltd

  Jul 2011 - Jan 2012

  Jr. Software Engineer
• 

  Eastern Software Systems

  Feb 2012 - Jul 2015

  Sr. Software Engineer

  Write PL/SQL queries to extract, correct, or update customer data in Oracle 8.05, 9i, 10g and Oracle 11g databases using SQL Navigator and MySQL Yog.Expertise in Database designing and creation.Expertise in requirement analysis, designing, developing, implementing and executing a project.

• 

  Intertec Software Private Limited

  Sept 2015 - Jan 2016

  Software Developer

  Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.Experience in bulk collect, bulk bind operators and collections.

• 

  Technoforte Software Pvt. Ltd.

  Jan 2016 - Jun 2016

  Sr. Software Developer

  Development new forms and reports as per DLD for custom project.Write new package, function and procedure to execute custom business logic.Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.Experience in bulk collect, bulk bind operators and collections.

• 

  Infosys

  Jul 2016 - Jan 2019

  Technical Analyst

  Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.Experience in bulk collect, bulk bind operators and collections.Experienced in Oracle Database Server 11g installation, Oracle Fusion Middleware installation and Webutil configuration. Prepared blueprint and Template of various Forms/Reports of different ERP modules (Finance, Purchase, Inventory, Sales,)Perform extensive Oracle database programming and tuning of SQL queriesCreated PL/SQL test cases and executed unit and system testing.Involve in all Unix System Production Support by trouble shooting customers urgent requests.Strong motivational and leadership skills.Database recovery using backup control file. Show less

• 

  Epsilon India

  Feb 2019 - May 2022

  Sr. Software Developer

  Collaborate with developers, project managers, business analysts and business users in conceptualizing, estimating and developing new software applications and enhancements..Assist in defining software development project plans, including scoping, scheduling, providing time estimates for programming tasks and implementation plans.Collaborate with QA team to define test cases, metrics, and resolve questions about test results.Work with cross-functional teams during crisis to address and resolve complex incidents and problems in addition to assessment, analysis, and resolution of cross-functional issues. Production Business Intelligence requirement gathering, build and implement the requirement.Write new package, function and procedure to execute custom business logic.Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.Experience in bulk collect, bulk bind operators and collections. Show less

• 

  DvSum

  May 2022 - Jan 2024

  Sr. Data Engineer

  Lead the design and implementation of critical database systems, resulting in a 20% improvement in query performance.Collaborate with application developers to optimize SQL queries and ensure efficient data retrieval.Conduct performance tuning and optimization of complex queries for large-scale datasets.Work on data migration, data warehousing, data integration, data cleansing, advanced analytics, digital transformation, Assist in defining software development project plans.Integrated Azure Data Factory with Oracle databases, Azure SQL Database, and other data sources, ensuring robust connectivity and efficient data flow.Development of Function, Procedures and Package to incorporate the new functionalities.Led the design and implementation of data pipelines using Azure Data Factory, ensuring seamless integration and movement of data across diverse sources.Utilized PySpark for complex data transformations, enhancing the efficiency of data processing workflows.Skills : SQL, PL/SQL, Azure Data Factory, Azure Databricks, PySpark and Unix shell scripting Show less

• 

  Trinity Life Sciences

  Feb 2024 - now

  Product Architect

  Used data factory activities to make the production pipeline for data copy with transformationUsed databricks notebooks for data transformationAzure data lake gen 2 storage used.Fixed broken and failed Azure data factory pipelines on prodStore processed data to azure delta lake tablesHandled TBs of data to the production pipelinesElastic search was integrated to the reporting tabUsed Spark and Scala to process the data (Including Json parsing)Parsed JSON file to Scala case classes and used to map them in PipelineUsed Impala, Hive and Kudu to maintain data hot and cold storage in Parquet formatHandled production issue’s and maintained pipeline.Involved in Sprint planning and requirement refinement Show less