Anusuya Resume
Anusuya Resume
Anusuya Resume
A professional with 5+ years of experience in the area of Oracle PL/SQL who has tremendous belief in intellectually
stimulating work process, to excel and succeed through smart work, thus enhancing value addition to my job, the
organization and myself. Often praised for my ability to handle the projects independently, I am also appreciated for
my team handling skills.
Skill Set
• SQL- Expert
• PL/SQL - Expert
• UNIX/LINUX/Shell scripting- Intermediate
• Data Analysis - Expert
• Performance Tuning - Expert
• Debugging - Expert
• Database Objects - Expert
• QA- Intermediate
• SQL Server - Intermediate
• Data Warehouse – Intermediate
• PROS – Pricing, Analytics, Guidance – Intermediate
• Power BI Testing – Expert
• Scrum Process – Beginner
• Agile Methodology – Working experience.
• Data Staging - Working experience.
• Application Support - Working experience.
Experience Summary
Projects Handled:
This project is for Profit and Revenue Optimization Software (PROS) handles pricing optimization methodology.
Here, I am working in a Data analytics team to handle pricing strategies & methodology for the various
countries.
Responsibilities:
• Assessing data from a variety of sources to gain insights into pricing strategies and market trends.
• Analyzing competitor pricing and market trends to increase market share and profitability.
• Tracking customer engagement to develop effective pricing strategies for products and offerings.
• Applying statistical modeling methods to determine the potential impact of pricing strategies on
profitability.
• Recommending pricing strategies that align closely with market trends and identifying new market
segments.
• Forecasting revenue and market share based on market trends, production costs, profit margins,
and sales volumes.
• Pricing guidance uses historical quote data to evaluate the total discounts of products on previous
quotes and determine the median discount percentage for those products.
• Have experience on customize target, norm, and floor discounts as percentages relative to the
median discount. Defined filters for the type of quotes and products included in the evaluation.
When a sales rep adds a product with pricing guidance to their quote, then can apply the target
discount and view the norm and floor discounts for additional context.
• Experience on creating pricing guidance manually or use CRM Analytics for advanced quote analysis.
Client & Project Description: Honeywell Project Solutions (HPS) – Power BI & SAP BO
Responsibilities:
HPS Pricing website running on legacy .NET framework with Oracle SPM database. Based on ETL process, extracting
the same from .Net and Transforming in Tableau framework and loading the dashboard.
Responsibilities:
• Worked as Developer on this ETL process into Tableau. Later to this, I have worked as QA on checking
the report generation in HPS website.
• Good experience in Manual UI testing & backend database testing and analyzing the procedures.
• Involved in testing the row level security.
• Conducted SIT testing jointly with rest of the project team. Log and fix defects identified during SIT.
• Responsible to prepare the Environment for UAT. Review, Triage, and fix issues logged during UAT.
• Responsible to prepare testing strategy related documents along with Test cases & Test queries.
• Extensively involved in writing Sub Queries, Joins, Analytical functions, Group functions.
• Created Indexes on tables to improve the performance by eliminating the full table scans.
• Worked on Cursors, Execute Immediate, Bulk Collect and Bulk bind to improve performance.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the
application.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like Explain
Plan.
• Raising tickets in JIRA ticketing tool and resolving the issues as per the agreed SLAs.
Organization: Infosys
Project & Role Description: Bank of America (Leading bank in US) - ABIT (T-Rex)
ABIT (Analytics and Business Intelligence) is a Data Analytics project which involves data
migration from the old legacy mortgage systems to the centralized data hub using strategic
solutions for reporting and regulatory requirements. This is an end-to-end Data Migration and
Analytics development project involving requirements elaboration, design, data modelling,
build, testing, implementation, and support. The system will be developed in multiple releases
with respect to subject areas.
Responsibilities:
• Involved in Job batch running & creation of Datamart’s and loading data through oracle packages.
• Involved Migration of objects from Oracle 11g to 12c
• Creating and scheduling jobs in Autosys.
• Involved in Enhancement of framework for creating jobs in Autosys.
• Have good experience in performance tuning for oracle packages.
• Interacting with Onsite people, Taking clarifications regarding applications.
• Analyzing the requirements and discussed with BA and leads on the functionality.
• Participate in Walk-through sessions with onsite people.
• Worked as L3 support to perform root-cause analysis for issues in the new release.
• Also working as a Data Analytics & PLSQL Developer in both MSP & T-Rex project.
Organization: Infosys
Client & Project Description: Bank of America (Leading bank in US) & ABIT -Mortgage Service Platform (MSP)
Responsibilities:
Educational Qualification:
Place of
Degree Institution CGPA Year
Education
Technical Skills:
• Operating Systems: Windows 2000/XP/7, Windows Server 2012 R2, Oracle Linux
• Languages: PL/SQL, SQL
• Tools: Autosys, TFS, ALM, Informatica (Basic level), Cognos (Basic level), Toad, PROS, Tableau, Power
BI, Soap UI, Putty, IBM DataStage, ETL Tools, Visual Studio.
Key Strengths:
Personal Profile:
Declaration
I hereby declare that all the statements made in this resume are true, complete, and correct to the best of
my knowledge and belief.
Anusuya B