Software Engineer Development
Resume:
Mallikarjuna Reddy
Frisco, TX +1-630-***-**** ************@*****.*** https://www.linkedin.com/in/mboiella
CAREER SUMMARY
Solutions-driven software engineer with 13 Years of expertise in guiding and steering teams towards achieving ETL process and data integration with data reporting to exceed corporate objectives. Driven to enhance internal systems with tailored software solutions after verification and validated testing with a strong background in Oracle 11g /10g SQL, PL/SQL. Skilled in generating robust code that is clear, concise, and clean to minimize technical risks with effective shell scripting in an Agile environment. Experienced in C, HTML, DBA, JavaScript, and other development activities to bridge the gaps in the software development phases to drive significant organizational growth. Effectively communicate with multiple stakeholders for a collaborative working relationship with cross-functional teams across the globe.
CORE COMPETENCIES
PL/SQL Programming & Database Management
ETL Process & Data Integration
Performance Tuning & Optimization
Back-End Technologies & Design
Handling with different XML/JSON/CLOB datatypes.
Handled OLTP/ OLAT and LLTP DB
Oracle Database Development
UNIX & Shell Scripting
Data Visualization & Reporting
Analytical Problem Solving
SQL Server Management Studio and Visual Studio.
Team Leadership & Collaboration
Oracle Development Tools
Compliance & Risk Management
Process Automation & Job Scheduling
TECHNICAL SKILLS
Languages: Oracle SQL, PL/SQL, SSIS, Autosys, Tableau, MetricStream, AppStudio, Python, UNIX, HTML, XML, JS
Tools: SVN, Eclipse, Toad, PLSQL Developer
Database: Oracle 11g,12c, Azure, SQL Server
IT EXPERTISE
Software Engineering: Directed the software development lifecycle to exceed stakeholders’ expectations in project deliverables by producing tailored solutions that help organizations scale exponentially.
Programming Expertise: Experienced in generating, reviewing, and reforming existing codes to develop software and applications to minimize technical risks while driving operational feasibility in all functions.
Business Acumen: Liaised extensively with a vast range of stakeholders to drive digital alignment and excellence across tools, applications, and software in cross-functional teams utilizing excellent communication skills.
PROFESSIONAL EXPERIENCE
Maxil Technology Sol Inc. Database Engineer Sep 2024 – Present.
Bank of America Senior Database Developer Dec. 2021 – Jul 2024
Maveric Systems Senior Software Engineer Nov. 2019 – Dec. 2021.
Bank of America Senior Software Engineer May 2014 – Nov 2019.
Birlasoft Software Engineer Aug. 2011 – May 2014.
EDUCATION
Bachelor of Technology in Computer Science Engineering in 2009. JNTU, Hyderabad, A.P.
Project Sep 2024 – till date
Title: Maxpro, Maxil Technology solutions Inc (US)
Role: Database Engineer
Technology: Java, Microservices, MySQL, Python, Oracle.
MAXPRO architecture is a java multi-tier enterprise application platform providing scalability, availability, security, recoverability, manageability and interoperability. A flexible, object-based design that allows rapid incorporation of new features and functionality.
Responsibilities:
● Oracle database full life cycle development including data modeling, database architecture, SQL and PL/SQL development, unit testing and support.
● Tune application SQL queries for performance optimization
● Evaluate existing database structures and recommend improvements
● Ability to turn high-level requirements into a working system through iterative development
● Create acceptance criteria, develop automated test frameworks, and validate work products
● Provide technical assistance by responding to inquiries regarding errors, problems, or technical questions.
● Develop detailed technical analysis and design specifications based on functional requirements.
● Collaborate heavily with fellow developers, designers and analysts to solve problems.
Title: Central Issue Management Application (CIMA) Jan 2022 – Jul 2024
Client: Bank of America, U.S.A
Role: Database Developer
Bank of America is an international financial institution that specializes in meeting the requirements and needs of global corporations. This project emphasizes the importance of workflow and system design via the MetricStream enterprise compliance platform. Using Agile methodology, the issue management system is integrated with the audit application.
The execution of a customized issue management system is based on the MuleSoft APIs. Front end processes include content library mapping, report building with JavaScript customizations and Oracle PL/SQL code at the back end.
Developed PL/SQL procedures and functions to handle CLOB data, including data transformation, aggregation, and reporting.
Implemented performance tuning strategies for queries and operations involving CLOBs, resulting in improved database performance and reduced query execution times.
Improved application performance by optimizing CLOB data management techniques, leading to reduction in load times.
Validated the field levels through Pl SQL after creating the Pl SQL Packages, Pipeline function & SQL tune while producing, testing, and debugging code to steer the IT team towards achieving corporate objectives.
Spearheaded operational and technical excellence of all projects by attaining deliverables within tight deadlines with no deviation from quality while utilizing Agile methodologies.
experience and knowledge on Transactional databases architectures will utilize both OLTP,OLAP, LLTP databases, though for different functions.
Aligned the requirements of user needs with the enterprise’s business goals to develop high quality software solutions to maintain robust IT architecture with clean and functional codes.
Managed and optimized databases containing large CLOB data types, ensuring efficient storage, retrieval, and processing of extensive text data.
Environment: Oracle 12c, SQL-PL/SQL, Autosys, SSIS, TOAD, Tableau.
Title: GRC BCM & OCIR, Dec 2019 - Dec 2021
Client: Standard Chartered Global Business Services, U.K
Role: Database Engineer
Standard Chartered Global Business Services Private Limited (SCGBS) is a financial institution that facilitates trades across markets to help MNCs perform complex business transactions. With a rising international consumer base, its innovative and collaborative nature enables clients to advance financially in their best interests.
In the IT architecture, there is an implementation of OCIR & BCM modules based on the EORP Platform, forms and workflow defined in AppStudio (MetricStream proprietary). JavaScript customizations take the front-end engineering lead in content library mapping and report building with Oracle PL/SQL code at the back end.
Generated strong coding and scripts by leveraging PL/SQL packages, procedures, functions, and views as per the requirement to improvise and improve existing technical features in the IT system.
Involved in reforming ECP & AppStudio platform for front-end design forms and Reports while reviewing and debugging code to produce tools and applications with relevant testing.
Designed, developed and delivered the blueprint & workflow using AppStudio with technical reporting in accordance with user requirements using concept of joins, sub query and pipe row functions.
Enhanced data interchange processes by implementing efficient XML parsing techniques, reducing data processing.
Automated XML data conversion processes, leading to reduction in manual data handling errors.
Led a project to migrate XML-based data from legacy systems to a modern database platform, ensuring seamless integration and data accuracy.
Environment: MetricStream, Appstudio, JS, Oracle 10g SQL and PL/SQL
Title: GRC Risk & Control Enhancement Aug.2014 - Dec.2019
Client: Bank of America, U.S.A
Role: Oracle PL/SQL Developer
Bank of America is a global banking and financial service corporation enterprise with consumers across the globe. Logging of all incidents is a core requirement with the project focused on manipulating workflow and system design by utilizing the MetricStream enterprise compliance platform. There is an integration of the issue management system with the existing audit application within an Agile environment.
Optimized knowledge of programming languages and databases to generate scripts using PL/SQL packages, procedures, function, views as per the requirement within an Agile environment to produce practical software.
Guided the internal team towards process improvements with technological advancements by collaborating on ECP & AppStudio platform for front-end design and performance tuning to eliminate long loading times.
Proficiency in working with joins, subqueries, window functions, CTEs (Common Table Expressions) in Oracle.
Generated strong coding and scripts by leveraging Oracle Pl-SQL packages, procedures, functions, and views as per the requirement to improvise and improve existing technical features in the IT system.
Tested and troubleshot defects in the coding and IT systems to perform mandatory updates while documenting the software development process after reviewing and debugging code for efficient and clean ones.
Environment: MetricStream, SSIS, Autosys, Tableau, PL/SQL.
Title: Global Trade Repository Systems Jan. 2012 - May 2014
Client: DTCC, NY, USA
Role: Oracle PL/SQL Developer
DTCC’s cross asset Global Trade Repository (GTR) solution acts as a first point of centralized contact for the storage and reporting of Over-The-Counter Swaps transactions and positions to regulators for all Credits, Equities, Rates, Commodities and FX Derivatives.
DTCC resolves all broker-to-broker equity with payment and movement of securities ownership occurring at the depository subsidiary virtually. By utilizing a repository system, DTCC is able to migrate data from several systems to repository, and to develop small to large reports that serves high level as well as daily business needs.
Delegated and allocated work accordingly after identifying, prioritizing, and executing tasks in the software development lifecycle to deliver new business projects successfully.
Developed and delivered tools and applications through the design and development of SQLs, Pl/SQLs, and reviews of other members’ performances to ensure no performance degradation and integration of modules.
Performed project specific knowledge transitions sessions with validation and verification testing to during collaboration with internal teams and vendors to reform and improve products exponentially.
Carried out onboarding sessions for new recruits to ensure alignment of technical knowledge and information to enhance the document development phases while monitoring systems with updated technologies.
Automated several tasks through disparate tools and scripting while debugging codes after extensive reviews to improve the software architecture to help corporations scale in the industry.
Environment: Oracle 10g SQL and PL/SQL, Oracle SQL developer
Title: XEROX USCBO PRODUCTION SUPPORT Aug.2011 - Jan.2012
Client: Xerox Corporation, NY, USA
Role: Oracle PL/SQL Developer
EDITH (Electronic Data Interchange Transaction Handler) is an intermittent center that accepts external transactions from consumers and sends them to the correct Xerox applications, more commonly known as inbound transactions. EDITH also accepts inbound transactions and sends them to external partners known as outbound transactions.
Piloted the design and development of procedures, functions and packages using PL/SQL while transferring data using the SQL loader from Flat files to Data Base after studying operations and installing software solutions.
Assessed, analyzed, and evaluated defects discovered during User acceptance and Component testing while driving operational feasibility by defining problems, requirements, and proposed solutions internally.
Ascertained premium points and prepared test cases that improve operations through system analysis and recommendations in policies and procedures that uses programming techniques, and computing equipment.
Summarized development and service issues to achieve engineering objectives by developing documentation, coding, writing functional documents and maintaining professional liaison with several stakeholders.
Leveraged flowcharts, layouts, and diagrams to translate technical details while managing budgets, project milestones and timelines for various projects while remaining relevant with the latest
Environment: UNIX, Oracle 10g SQL and PL/SQL, Pl-SQL developer
Contact this candidate