Aniruddha Namdeo Rode

· 17+ years of experience in analysis, design, development of various Oracle Database applications along with Experience in Oracle10G/11G/12C/19C PL/SQL, Shell Scripts, Core Java, JSP, Servlets, XML, HTML Web Logic, Web sphere, SQL Server 2000.

·

Worked on projects in waterfall and agile and waterfall methodology.

Technology professional prepared to excel in complex and dynamic environments. Adept at leveraging innovative solutions to optimize system performance and drive organizational success. Known for fostering collaborative team environments and consistently achieving project goals while adapting to evolving requirements. Specializes in system architecture, cloud technologies, and strategic planning.

· Rich experience in Telecom & PLM domain system like BSS, Intelligent Network (IN), CRM, virtual Top-up, Mediation, and Intelligent Network (IN), Product Definition Systems, Team Center interfaces.

Offering solid background in software engineering principles and keen interest in technology architecture. Delivers strong grasp of programming languages and cloud services, with ability to quickly learn and adapt to new technologies. Ready to use and develop coding and system design skills in [Desired Position] role.

• Worked on application deployment architecture design and implementation.
• Deployment of the BSS solution in SIT, UAT and production environments at various data centers.
• Worked on Requirements collection for building the core BSS solution.
• Expert in Tracing, troubleshooting with database performance and tuning issues.
• Export/Import of oracle databases.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
• Analyzing and validating database objects.
• Extensive use of Unix Shell Scripts, Cron jobs to automate process along with PL/SQL to create Packages, Functions, and Procedure.
• Involved in testing the application for Oracle upgrade.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• An effective communicator with excellent relationship management skills. Strong analytical, problem solving & analytical abilities. Possess a flexible & detail-oriented attitude Participated in Requirements capture, Show and tells, Demonstrations to customer for Sign off and issue resolution
• Experience in project management, planning & implementation and product testing, analysis, design, development, implementation, Software Testing.
• Good Interpersonal skills, Team player, Self-Motivation, commitment, result Oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks. Excellent analytical and logical skills
• Having knowledge in Application configuration management and deployment.
• Motivate team members, Organize / Conduct internal trainings on various applications.
• Mentoring junior team member and proactively work with R&D and Developers to rectify the defects found.
• Experience in working with multiple vendors and geographically distributed teams
• Attending daily meetings, interacting with clients, attending weekly/daily defect calls
• Act as the single point of contact between Development and Testers for iterations, testing & deployment activities and Sending Sign off mails to Client /Trust

Developed key data engineering skills in fast-paced, collaborative environment, focusing on data modeling and pipeline optimization. Transitioning into new field to apply expertise in SQL, Python, and data architecture. Seeking opportunities to leverage these skills to drive innovation and efficiency.

Personable and analytical with knack for problem-solving and data-driven insights. Proficient in data modeling and ETL processes, leveraging SQL and Python to manage and optimize data pipelines. Committed to delivering scalable data solutions that drive business performance.

Offering solid foundation in data engineering principles and strong desire to grow within this field. Brings familiarity with data modeling and pipeline development, leveraging SQL and Python to manage and process data. Ready to use and develop analytical and technical skills in Lead Data Engineer role.

Experienced with building scalable data infrastructures, ensuring seamless data flow and integration. Utilizes advanced data engineering techniques to support business intelligence and analytics. Track record of leveraging team collaboration and technical acumen to drive data-driven decision-making.

Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Professional data engineering leader with strong focus on delivering impactful results. Extensive experience in designing and implementing scalable data architectures, optimizing data pipelines, and leveraging big data technologies. Known for collaborative team leadership, adaptability, and results-driven approach. Skilled in SQL, Python, Spark, and cloud platforms, with keen ability to align technical solutions with business goals.

• Project Name Virtual Topup
• Project
• Description
• The Virtual TopUp system facilitates e-recharging prepaid and postpaid bills payments in real time
• Subscribers can send a recharge request specifying the talk time amount at anytime and from anywhere
• System interacts with SMSC to get requests and sends processed requests to IN (Intelligent Network) for prepaid and interacts with BSCS for postpaid bill Payments
• A major revenue collection system, with more than 50 lakhs requests processing per day
• Technologies Oracle10G PL/SQL, Shell Scripts, AIX, JAVA, Web sphere
• Role Played
• Process atomization and Customization
• Co-ordination with Onsite teams
• Application deployment during Data Center migration
• Application configuration for postpaid bill payments with BSCS
• Automated daily reports through shell script and java
• Configured auto system generated alerts on mobile to ensure 100% availability and functionality of application
• Duration Nov 2006 – Aug 2009 Team Size 8
• Project Name
• Prepaid BSS ODS and Promotion Management System
• Project
• Description
• Prepaid BSS Promotion System and ODS would support the transactional and operational needs for pre-paid usage data by Prepaid CRM and automated execution of promotion lifecycle for Prepaid subscribers
• These may be triggered by:
• A new MRP recharge
• A request to CRM received from various channels: SMS, CSR, IVR
• A bulk request from a promotion campaign via CRM/BI
• Technologies Oracle10G PL/SQL, Shell Scripts, AIX, JAVA, J2EE, Web sphere
• Role Played
• Involved in requirements analysis and design review
• Process atomization Customization and level 3 support
• Co-ordination with Onsite teams
• Involved in Technical Design, ERD, DFD, FSD design and documentation
• Process Atomization and Customization through Shell scripting and Java
• Writing triggers / functions / procedures / packages / using SQL, PL/SQL as per business logic
• Code reviews and Walkthroughs for the team
• Performance Tuning for batch and Online processes, reviewing the processes and finding bottlenecks in performance (taking Traces, Explain Plans, optimizing the indexes and their proper usages etc)
• Involved in preparation of Unit Test Plan preparation, System Integration Planning, Client coordination and Documentation
• Configured auto system generated alerts on mobile to ensure 100% availability and functionality of application
• Duration June 2009 – Jan 2011 Team Size 10
• Project Name Fraud Management System
• Project
• Description Ranger (v5) from Subexazure is being used as fraud management and revenue maximiser
• It gets CDRs from mediation, billing and subscriber’s data from BSCS and detects fraudulent subscribers and their calls
• Technologies Oracle10G PL/SQL, Shell Scripts, AIX, JAVA
• Role Played
• Configuration of all the new events, Smart Patterns, rate plan, Special numbers, VAS
• Numbers, local numbers and other’s msisdn series
• Script implementation for daily subscriber dump from BSCS, invoice and payment details
• Co-ordination with Mediation team and implementation of the process for continuous CDR Processing
• Generation of daily reports scheduled in cron runs 4 times in a day and reports mail to team member
• Configured auto system generated alerts on mobile to ensure 100% availability and functionality of application
• Duration Nov2006 – April2007
• Project Name Idea Subscriber Management System (CRM)
• Project
• Description ISMS is a locally developed CRM system, used for activations
• Postpaid payments and service provisioning
• For activations/provisioning interacts with mediation (SAS) which interns sends requests to IN
• It interacts with BSCS for postpaid payments
• Very critical system for revenue generation, used by all franchises at
• Idea shows rooms
• Having modules Franchise, Customer Care, Admin
• Activation etc
• Technologies Oracle10G PL/SQL, Shell Scripts, AIX, JAVA, Tomcat
• Role Played
• Development, Customization and level 3 support
• Performance Tuning for batch and Online processes, reviewing the processes and finding bottlenecks in performance (taking Traces, Explain Plans, optimizing the indexes and their proper usages etc)
• Configured auto system generated alerts on mobile to ensure 100% availability and functionality of application
• Duration Dec 2006 – Nov 2007 Team Size 8
• Project Name I care [Customer Care Application CRM
• Project
• Description Icare system used by customer care executives for requests and
• Complaints records
• Used for escalations based on TAT (turn around time)
• Technologies Oracle11G, PL/SQL, Shell Scripts, AIX, JAVA, Jboss-4.0.3
• Role Played
• Development, Customization and level 3 support
• Performance Tuning for batch and Online processes, reviewing the processes and finding bottlenecks in performance (taking Traces, Explain Plans, optimizing the indexes and their proper usages etc)
• Duration Dec 2006 – Nov 2007 Team Size 8
• WORKSHOPS/TRAINING PROGRAMS ATTENDED
• Unix Fundamentals and shell scripting
• Web sphere administrative
• Web logic administrative
• Functional Point Analysis
• QTP
• Oracle PL/SQL

• Key Accomplishments: , Awarded as The Best of IBM in IBM-Bravo-2008 for Outstanding Team Contribution & focus and passion to work Awarded as Most Valuable Team Player in Infosys for Outstanding Team Contribution for consecutive two years Winner of Three IBM Thanks Awards in a year 2009 for excellent work in prepaid domain.