| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Supriya MahakodeEMAIL AVAILABLEPHONE NUMBER AVAILABLEProfessional Summary:15+ Yrs of IT experience in Oracle Database Design and Development, Data model, ETL methodology, OOPs SQL and PL/SQL.Worked on SQL Query and application performance tuning. Experienced in shell scripting, Explain Plan and AWR report.Excellent programming and debugging skills in Python and PL/SQL. Expertise in writing SQL Queries in accordance with performance as well data reporting.Ability to provide technical support for application at run time up to expert level turnaround time with high quality.Good experience on Agile and Waterfall methodology.Experience in Tableau reporting tool.Good understanding with batch processing using job schedulers such as Control-M and Autosys.Clear understanding on CI/CD pipeline using Bitbucket, JIRA and Service Now IncidentA Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.Good Knowledge in using Oracle packages UTL_SMTP, UTL_MAIL, DBMS_METADATA and DBMS_PROFILERTroubleshoot application codes to identify and correct errors that improved its usability.Excellent experience in Application Development using Oracle SQL, PL/SQ, pythonAbility to write SQL queries using oracle analytical functions such as LEAD, LAG.Experience in use of oracle session level object V$SQL, V$SQL_PLANExperience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques. Expertise in Client-Server application development using Oracle PL/SQL, SQL *PLUS, TOAD.Experience on oracle external tables and SQL loaders.Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.Good knowledge on logical and physical Data Modelling using normalizing Techniques. Created Tables, Views, Constraints.Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.Experience in Python and UNIX scripting development.Experience in creation of Tableau Dashboard and reportingExpertise in data validation after pre and post migration. Good hold on data validation for Data in transit and Data as Rest.Excellent understanding on batch processing of data using job schedular.Certified scrum master and worked under agile methodology.Follows complete CI/CD pipeline to deploy the code in production.Strong analytical and problem-solving skills with ability to work within team environment and independently when needed.Strong interpersonal skills, ability to interact with people at all levels.Ability to provide training and guide the team in order to getting work doneAbility to work on any technology to provide best result.Effective team working skills. Able to work both as an individual and as a team member within multi- disciplinary team to meet the expected deadlines.Technical Skills:LanguagesOracle PL/SQL, Core Java, Python, Shell ScriptingDatabasesOracle, DB2 9.7Database InterfaceTOAD, SQL Developer, SQL *PlusToolJenkins, Jira, Service now, HP Quality CenterOperating SystemsMS Windows XP/NT/2000, Linux (Red Hat)Subversion ToolGIT, Bit Bucket, Microsoft Team version control systemReporting ToolsTableauSchedulersControl-M, AutosysCertifications: AWS Cloud Practitioner (2022) Certified Scrum Master (2018) OCA (2008) Oracle 9iProfessional Experience:J. P. Morgan and Chase, Chicago, IL May, 2022 Till DateProject: Info One PlatformTitle: Sr Candidate's Name
Info One Platform is a common database across multiple applications to develop. The team is responsible for providing solution with respect to performance access level and standard development which is used across applications in JPMC. The data migration from 11g to Exadata. Creating data backups with data in dump file.Roles & Responsibility:Understand the process that are used within database for maintenance such as gather stats, data compression etc.Develop the generic script for Weekly, Monthly and year Reporting using Python and PL/SQL.Implemented procedure to create policies and applying on table column to restrict user data visibility across region.Created package for foot print reduction and sending emails for unused objects in database.Identify and restrict granted access to multiple databases.Monitor development which will get implemented in database and reflect flows in development with respect to performance or permissions in DB as per provided standards by organizations.Interact with multiple team members to train to have successful access on DBCreated Tableau Dashboard to understand monthly use on DB with respect to size.Find unused object on the DB in order to reclaim the space.Created periodic data delete process so the table size will remain consistent.Generated the report to understand DB use with respect to these application access.Use of Git Bit bucket to perform changes in CI/CD pipeline.Involved in Production Support and troubleshooting data quality and integrity issues.Created test document for newly created API.Provided training to the team to perform code push across Database.Environments: Oracle Enterprise Linux, Oracle database 19c, Toad, PL/SQL, Tableau, Git Hub, Remedy, Jira, confluence, Bitbucket, Jenkin, Control MBank of America,India Sept, 2010 May, 2022Project 1: BIS (Bank Information System)Title: Sr Candidate's Name
BIS facilitates opening, closing and updating all accounts that Merrill Lynch and its subsidiaries maintain at third party institutions, either for itself or clients. The group reviews daily bank balances from third party banks and resolves positive and negative bank balances to ensure overdrafts are covered in a timely manner and long cash is effectively utilized by the firmRole & Responsibility:Responsible to perform data/Performance validation after Data migration completed from 11g to 19c.Provided generic solution in order to have data as per the compliance policy.Created proc to delete data older than specific month for given account.Understand the process that is manually taken care by the support team and provide automated solutions using Autosys job and shell scriptAutomated balance details update of specific accounts provided by upstream in a given location.Provided automated solution to reduce batch time by 60 minResponsible for data migration from Oracle 11g to 12c, without impacting existing functionality.Independently handled UNIX OS upgrade for servers.Solo responsible for TFS to bitbucket migration of database and UNIX objects. Converted Pro*C code in PL/SQL procedures, functions and packages.Provided documentation for the work completed to have smooth knowledge transition within team.Environments: Candidate's Name , Confluence, Jira, Bitbucket, Ansible, Autosys.Project 2: LIBRA (Liquidity Based Reporting and Analysis)Title: Sr Candidate's Name
LIBRA is the platform to support liquidity risk business. LIBRA application is developed using Quartz platform which is having front end in python and database as Oracle 11g. This application provides data quality, data reconciliation, analytical and reporting capabilities.Role & Responsibility:Part of LIBRA development team which is created from scratchImplemented global masking so that data can be viewed only as per rules like cross border etc. to adhere best compliance practicesImplemented business requirement to minimum liquidity maintained by each product in order to maintain liquidity ratio at global level using PL/SQL Procedure.Created Foreign exchange dashboard for to display value of product as per given filter from UI.Created Auto scheduler for data loading to process data in application as and when availableCreated workflow model for LIBRA data reporting to visualize the current state of data.Automated multiples modules where complex UI based entries were made by the users. Users have to enter data from UI now with a single click user can import data.Reduced batch execution time by 1hr 30 minInvolved in the continuous enhancements and fixing of production problems.Created data model to showcase data in transit.Used python to process the and create report in txt format.Involved in Third party audit process to confirm as there is no data loss during process.Environments: Candidate's Name , Confluence, Jira, Bitbucket, Ansible, Autosys.Project 3: LRS (Liquidity Risk System)Title: Candidate's Name
LRS is a Risk assessment application used by the Business to evaluate the Liquidity Position of the Company. It gives a Strategic solution to the current liquidity position of the company by calculating the Cash Flows coming from different entities. The financial Instruments data is collected from various sources and data is filtered using ETL and the behavioural Models are applied. The LRS application Deals with Preparing Basel FSA Reporting to UK Regularities.Role & Responsibility:Create and maintain DB2 objects. (Create, modify, execute, RUNSTAT, REORG) in the production environment.Developed Unix Shell scripts and PL/SQL procedure to automate database operation and database monitoring.Involved in providing production Application Support and database support. Analyse code for problem resolution and performance optimizations.Involved in Developing stored procedures and other database objects and Performance Analysis and tuning SQLs.Coordinating with the Onsite team in gathering requirements for allotted JIRAs for the team and involved in different phases like designing, developing and responsible for on time delivery.Developed SLA and Data Validation module in DB2 for audit requirement.Environment: DB2 9.7, Shell, Toad, Import/Export, PL/SQL, SVN, Autosys, HP Quality Center.HP Company, India Jan, 2007 Aug, 2010Project: USGS MMISTitle: Jr Candidate's Name
MMIS (Medicaid Management Information System) is a huge program in the US and has a lot of complex processes. The interchange product has a .NET based web portal and UNIX based back-end processing logic. It uses Oracle 10g database to maintain a large amount of data. This product is used by various states in the USA. I have worked with 2 states Tennessee and Connecticut.Role & Responsibility:Preparing the design after thorough analysis of requirements keeping in mind the product needs.Coordination with Business analysts and Tech leads.Constructing the code and testing the outcome of the process in all the environments.I was also responsible for validating the others changes and preparing the test document for future understanding.Environments: C, Pro*C, Oracle 10g, UNIX Shell ScriptingEducation: B.Tech in Computer & Science Technology S.N.D.T. University Mumbai (2006) |
