Summary
Overview
Work History
Education
Skills
Timeline
Generic

Anuradha Mallick

Naperville,IL

Summary

  • More than 15+ years of hands on experience in the analysis, development and maintenance of business applications using Oracle PL/SQL .
  • Worked as Manager -Projects for Cognizant Technology Solutions & part of the Oracle development team for Cummins client.
  • Proficient in Python for data wrangling, transformation, and analytics, leveraging key libraries and APIs.
  • Built and maintained Python automation scripts for data cleaning, transformation, analytics, and report
    generation, enhancing data accessibility and insight delivery    .
  • Hands-on experience with AWS Cloud services including EC2, S3, Lambda, Step Functions,CloudFormation, ECR, CloudWatch, and Load Balancers.
  • Good working experience in database programming on Oracle SQL/PLSQL and/or related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing .
  • Working knowledge in parsing and loading data using oracle XML packages and JSON
  • Extensive experience in Unix Shell Scripting to analyze and provide solutions to integrate the changes needed and suggest the best practices for different projects.
  • Highly skilled in Query Optimization, Debugging, and Performance Tuning for improving the performance of Application.
  • Expert in data modeling and define data entities and attributes. Also performed extensive business process analysis including data analysis and GAP analysis.
  • Working Knowledge of ETL tool like Informatica to establish strategy for extracting, transforming, and loading data tables between different databases.
  • Good Experience in Data loading using SQL Loader, Export and Import utilities.
  • Working knowledge of Version Control & Migration Tool: .Bit Bucket,Github
  • More than 1 Year of industrial working experience as Intermediate level DBA skills.
  • Expertise hands on expirence in FLEXCUBE (Core Banking Product) development, implementation & support.
  • Having good Client Relationship Management, Co-ordination and People Management skills and have the ability to understand and analyze both the business and technology drivers.
  • A highly motivated self-starter, able to hit the ground running with little or no supervision and enjoy attention to detail. Having the ability to work autonomously and as part of a team. Also can adapt quickly to rapidly changing new technologies.

Overview

11
11
years of professional experience

Work History

Manager - Projects

Cognizant Technology Services
05.2022 - 01.2025
  • Project: Cummins
  • Role: Product Analyst
  • Environment: Oracle 19c, PL/SQL
  • Responsibilities:
  • Coordinated with cross functional teams to understand key metrics and data requirements.
  • Analyzed and optimized long running jobs for performance improvement.
  • Created detailed user stories and process flows.
  • Facilitated workshops to gather stakeholders feedback and refine product features based on user needs.
  • Conducted user acceptance testing to validate product functionality and gather insights for future improvements.
  • Co-ordinated and groomed development team to ensure they met the business and user requirement.
  • Identified opportunities for process improvements, implementing changes that increased efficiency across all projects.
  • Developed strong relationships with stakeholders to ensure alignment of goals and expectations.
  • Enhanced team collaboration through the development of communication channels and regular progress meetings.

Tech. Lead

Infosys Ltd
10.2021 - 04.2022
  • Project: MCMR
  • Role: Sr. Oracle PL/SQL Developer
  • Environment: Oracle 12c, PL/SQL
  • Responsibilities:
  • Client requirement analysis and design full cycle development and implementation using Agile Methodology.
  • Responsible for managing testing environment like schema refresh activities and data upload.
  • To analyze, design and development of complex screens and backend procedures based on the clients requirement using Oracle (11g, 10g, 9i) databases applications development using Oracle Packages, Stored Procedure, Functions &JSON.
  • Enhances the performance of the application using PLSQL advanced features.
  • Performed unit testing execution and Support to Integration Testing.
  • Production Bug fixing and Support.

Team Lead/Senior Associate

Cognizant Technology Services
01.2015 - 06.2020
  • Project: OTIS- DSL
  • Role: Sr. Oracle PL/SQL Developer
  • Environment: Oracle 11g, PL/SQL, Unix, Shell Scripting
  • Responsibilities:
  • Client requirement analysis and design full cycle development and implementation.
  • Responsible for managing testing environment like schema refresh activities, data masking and data upload.
  • Root cause analysis for defects raised by client and providing resolution.
  • Involved in the planning, monitoring to support of the testing activities and tasks. Involved in dress rehearsal activities to insure issues free implementation and defect preventing activities.
  • Responsible for desensitized data in secured environments using in house utilities prior to loading into pre-prod environments also referred to as ESQM Release Management Environments.
  • Design & Development of UNIX Scripts & Oracle SQL/PL SQL and Stored Procedures.
  • Working with offshore team and conducted daily meetings to get status update.
  • Technical lead and sole point of contact for all BAU related activities. Interact with Client for problem solution and its implementation.
  • Enhanced overall team performance by providing regular coaching, feedback, and skill development opportunities.
  • Collaborated with other department leads to streamline workflows, improve interdepartmental coordination, and achieve business goals collectively.
  • Managed schedules, accepted time off requests and found coverage for short shifts.

Tech Lead / Programmer Analyst

Niche software solutions
09.2013 - 01.2014
  • Project: FLEXCUBE FCJ Implementation
  • Role: Sr. Oracle PL/SQL Developer
  • Environment: Oracle 11g, PL/SQL, AVA, Unix, Shell Scripting, Windows 8, Java
  • Responsibilities:
  • Responsible for FLEXCUBE FCJ Implementation and Support for the project.
  • To analyze, design and development of complex screens and backend procedures based on the clients requirement using Oracle (11g, 10g, 9i) databases applications development using Oracle Packages, Stored Procedure, and Functions.
  • Enhances the performance of the application using PLSQL advanced features.
  • Performed unit testing execution and Support to Integration Testing.
  • Production support which involves interaction with both Client and other teams.

Education

Bachelors of Engineering (B.E) - Computer Science Engineering

Biju Pattnaik University of Technology
Bhubaneswar
09.2004

Skills

  • Databases : MSSQL Server ,MySQL, Oracle DB ,
  • Languages : Oracle PLSQL,Oracle D2K Forms 6i,Python (Data Science),Shell Scripting,JSON,Java Script, HTML, CSS
  • Cloud Platform : Amazon Web Service (S3, Lambda, Step Function , Cloud formation)
  • ETL Tool : Informatica
  • Operating Systems : Windows, LINUX
  • Domain Knowledge : Banking ,Healthcare ,Retail

Timeline

Manager - Projects

Cognizant Technology Services
05.2022 - 01.2025

Tech. Lead

Infosys Ltd
10.2021 - 04.2022

Team Lead/Senior Associate

Cognizant Technology Services
01.2015 - 06.2020

Tech Lead / Programmer Analyst

Niche software solutions
09.2013 - 01.2014

Bachelors of Engineering (B.E) - Computer Science Engineering

Biju Pattnaik University of Technology

Similar Profiles

CREATE PROFILE
Anuradha Mallick