Satyam

[email protected] • 999999999 • Hyderabad, Telangana– 500049

PROFESSIONAL SUMMARY

Managing Consultant having 15+ years of hands-on experience in design, development, debugging, testing and code reviews in PL/SQL, using DevOps methodologies Engaged with Citibank since 2014 previously from Virtusa Consulting Services and subsequently joined as employee of Citibank since Sep 2022 Currently working in Citibank since Sep 2022 as Managing Consultant within Oracle PL/SQL and Appian areas Extensive experience in Change management and Release processes. Managed release processes independently, overseeing deployment activities Working experience on Appian (Low code/No code platform) with a capability to develop BPM, Tempo, Record Types, Reports, Process Models, CDTs, smart plugins, and SAIL based features & components Expertise on Client/Server development using Oracle Forms & Reports (D2K) Involved in Month end activities including generation of Month end reports, Month end process review and reconciliation Extensive experience in problem solving, development, simplification, and finding innovative solutions Received awards for Best performer and Best Team Player Articulated communicator with ability to blend technical expertise with interpersonal skills while interacting with cross-functional team, customers, and stakeholders

WORK EXPERIENCE

Managing Consultant
09/2022 - Present
Citicorp Services India Private Limited (Citibank) , Hyderabad, Telangana
• Leading Oracle PL/SQL and Appian development projects
• Managing change management and release processes independently
• Overseeing deployment activities and ensuring smooth production releases
• Developing BPM, Tempo, Record Types, Reports, Process Models, CDTs, smart plugins, and SAIL based features & components
• Coordinating with cross-functional teams and stakeholders for project delivery
Team Member
01/2022 - 09/2022
NetCracker Technology Solutions (India) Private Limited , Hyderabad, Telangana
• Involved in resolving tickets and change requests
• Participated in coding and unit testing phases
• Prepared and submitted project artifacts including SQA and audit documents
• Assisted in recruitment and conducted monthly and weekly status calls and reports
Team Lead/Member
07/2014 - 01/2022
Virtusa Consulting Services Pvt. Ltd., Hyderabad (Polaris Consulting & Services Ltd., Hyderabad) , Hyderabad, Telangana
• Involved in resolving RFCs (Request For Change)
• Participated in coding, unit testing, and deployment phases
• Tracked deliverables and financials
• Prepared and submitted project artifacts including SQA and audit documents
• Assisted in recruitment and conducted monthly and weekly status calls and reports
Team Member
02/2014 - 07/2015
Virtusa, Chennai /Oracle (Micros), US , Chennai, Tamil Nadu
• Created and modified packages, stored procedures, functions, and new Oracle reports
• Prepared test plans and test case documents, executed test cases ensuring quality deliverables
• Provided technical support for production environment issues
• Set up application and database servers in development environment offshore
• Deployed and upgraded patches and executables daily in development environment
• Created new environments offshore for customizations
Team Member
12/2009 - 01/2014
Mphasis Ltd., Chennai/Chartis Insurance – Greece (AIG) , Chennai, Tamil Nadu
• Gathered requirements and prepared design documents
• Created and modified packages, stored procedures, functions, and new Oracle reports
• Prepared test plans and test case documents, executed test cases ensuring quality deliverables
• Provided technical support for production environment issues
• Managed month-end processes without issues
• Customized front-end forms and reports and created new database objects

EDUCATION

B.Com
Nagarjuna University, Tenali (Andhra Pradesh) , Tenali, Andhra Pradesh

SKILLS

PROJECTS

REALM – Real Estate and Lease Management System
Technologies: Appian, Oracle 19c Database PL/SQL
• Developed the Core Module to enhance Property Management and support the full lifecycle of Lease Administration, including Lease Term, Rent Reviews, Options, and Critical Dates
• Implemented intuitive data relationships, enabling Property Asset Managers to efficiently search and report on portfolio aspects
• Actively addressed compliance issues by remediating end-user clients within Citi internal systems related to EUCs
• Successfully remediated three EUCs, with additional EUCs currently in progress
• Involved in resolving RFCs (Request For Change)
• Participated in coding, unit testing and deployment phases of the project
• Active participation in overall process design
• Analyzed user stories, designed, and developed application modules
• Created process models and UI SAIL forms
• Created CDTs and Record Types
• Created expression rules and constants
• Handling 6 team members
NRM – Netcracker Revenue Management (Rating and Billing Management)
Technologies: Oracle 19c Database PL/SQL
• Netcracker Revenue Management empowers service providers to dynamically personalize service offerings, manage complex policy-based charging scenarios, and facilitate partner-based billing and revenue settlement models
• Involved in resolving tickets and change requests
• Participated in coding and unit testing phases of the projects
• Prepared and submitted project artifacts (SQA, Audit)
• Assisted in recruitment
• Took care of monthly and weekly calls & status reports
REALM – Real Estate and Lease Management System
Technologies: Oracle 11g Database PL/SQL
• The Core Module encompasses both Property Management and the complete lifecycle of Lease Administration including Lease Term, Rent Reviews, Options and Critical Dates
• Intuitive data relationships enable the Property Asset Manager to easily search and report on any aspect of the portfolio
• Involved in resolving RFCs (Request For Change)
• Participated in coding, unit testing and deployment phases of the project
• Tracked deliverables and financials
• Prepared and submitted project artifacts (SQA, Audit)
• Assisted in recruitment
• Took care of monthly and weekly calls & status reports
Opera – Property Management System
Technologies: Oracle 10g Database PL/SQL, Oracle 10g forms and reports
• OPERA – Property Management System is fully integrated with modules like Reservations, Rate Management, Front Desk, Rooms Management, Cashiering and Reporting
• Created and modified packages, stored procedures, functions, and new Oracle reports
• Prepared test plans and test case documents, executed test cases ensuring quality deliverables
• Provided technical support for production environment issues
• Set up application and database servers in development environment offshore
• Deployed and upgraded patches and executables daily in development environment
• Created new environments offshore for customizations
PREMIA - Insurance management system
Technologies: Oracle 10g Database PL/SQL, Oracle (6i/10g) forms and reports
• The insurance management system solutions suite is designed to proficiently perform all the functions of an insurance company such as underwriting / policy administration, claims management, reinsurance and accounting
• Production Support, Maintenance and Customization
• Monet – Customization Project to standardize reporting of policies for new business / endorsements / renewals, claims reserve and payment status across all countries for Greece and Cyprus
• Finance Reporting – Customization Project to develop new reports and customize existing accounting entries posting for month end and quarter end reconciliations for the F & A department, done onsite at client location in Dubai, UAE
• Provided support on database-related issues during testing and troubleshooting of existing applications in live environment to resolve performance, security, and other back-end issues
• Gathered requirements and prepared design documents
• Created and modified packages, stored procedures, functions, and new Oracle reports
• Prepared test plans and test case documents, executed test cases ensuring quality deliverables
• Provided technical support for production environment issues
• Managed month-end processes without issues
• Customized front-end forms and reports and created new database objects

CERTIFICATIONS

OCA – Oracle Certified Associate (1Z0-007,1Z0-147)
OCP – Oracle Certified Professional (1Z0-141)
Appian Developer Certification