Supriya Joshi
Quincy,MA
Summary
Accomplished Principal Consultant at Oracle Financial Services Software Inc, a key player in high-stakes migration projects and optimizing database solutions across AWS and OCI.
Expert in SQL, PL/SQL development, data modeling, data warehousing and SQL optimization and blend strategic development with analytical thinking to deliver projects on time.
Recognized for mentoring and leadership, excel in driving cross-functional collaboration and innovation.
Skilled in project planning and estimation and creating technical proposals and presentations for various business and application groups,
Overview
13
13
years of professional experience
1
1
Certification
Work History
Principal Consultant
Oracle Financial Services Software Inc
09.2024 - Current
- Part of core Architecture and Database solutions team at StateStreet Global Advisors - deputed to client location in Boston, MA.
- Successfully handling multiple responsibilities including data modelling, development, data migration and replication, performance optimization, UAT and PROD support to minimize downtime, project planning and estimation, technical presentations, managing Agile projects.
- Played a key role in multiple migration and data center exit projects to move on-prem applications and databases into AWS and OCI. This involved vetting application architecture against Corp cloud standards and working through cloud onboarding process, and refactoring database code to be compatible with target data platforms (Redshift and Aurora PostgreSQL).
- Working with multiple application groups for data replication requirements and setup.
- Collaborated with cross-functional teams to design and implement scalable database solutions for various projects.
- Troubleshot and resolved critical database issues in Production, minimizing downtime and maintaining business continuity.
- Improved performance and efficiency by analyzing and optimizing SQL statements in complex applications.
- Designed data models for complex analysis needs.
- Consistently delivered high-quality database solutions on time and within budget, earning recognition from management for excellence in job performance.
- Gathered, defined and honed application requirements, led project design and oversaw implementation.
- Developed custom SQL scripts for complex reporting requirements and analytical needs.
- Mentored junior team members, providing guidance on best practices in database development and management.
- Facilitated efficient data analysis by creating and maintaining detailed documentation of database structures.
- Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
Senior Consultant
Oracle Financial Services Software Inc
01.2017 - 09.2024
- Collaborated with cross-functional teams to deliver high-quality database solutions within established project timelines.
- Evaluated, designed, implemented, and modified databases and database applications.
- Optimized database performance by implementing efficient indexing strategies and query optimizations.
- Created and updated database designs and data models.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Reviewed peer-developed codes using dedicated version control systems ensuring adherence to coding guidelines and optimization principles.
- Managed multiple high-profile projects, delivering accurate and timely results under tight deadlines.
- Led the transition from a legacy database system to modern platforms, minimizing downtime during the migration process.
- Developed efficient data migration processes for seamless integration of new systems.
Programmer Analyst
Cognizant Technologies Solutions
05.2014 - 12.2014
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Collaborated with cross-functional teams to ensure seamless integration of new features into existing applications.
- Tested and deployed scalable and highly available software products.
- Provided ongoing support for users experiencing issues or requiring assistance with application functionality.
- Performed regression and system-level testing to verify software quality prior to release.
- Performed code refactoring and optimization to improve performance.
- Utilized both agile and waterfall methodologies to develop software of varying complexity and business needs.
- Designed and implemented scalable applications for data extraction and analysis.
- Mentored junior developers on best practices, helping them grow their skill sets while enhancing overall team capabilities.
- Boosted productivity by automating repetitive tasks using custom-built scripts and tools.
- Conducted thorough code reviews to maintain high-quality software development standards.
Associate Consultant
Oracle Financial Services Software Ltd
09.2011 - 05.2014
- Database design and development - write clean and maintainable code (stored procedures, functions, triggers, complex views etc) for multiple modules of application
- UAT support and bug fixes
- Prepare technical and architecture documents
Education
Bachelor Of Engineering - Computer Engineering
Mumbai University
Mumbai06.2011
Skills
Technical
- Data Platforms : Oracle, AWS Redshift, AWS Aurora PostgreSQL, Sybase, Netezza, MSSQL Server
- Data Modelling (Erwin v14)
- Data Analysis
- Scheduling : Autosys, Airflow
- Data Warehousing
- UNIX Shell scripting
- CICD Stack (GIT, Jenkins, Artifactory)
- Project Planning & Estimation (MS Project)
- Proposal Development, Technical presentations (MS Powerpoint) and diagrams (Visio, drawio)
Process Knowledge
- Agile Methodologies: Scrum, Kanban
- Process Improvement
- Business Requirements Analysis
- Solution planning
Soft Skills
- Leadership
- Problem-Solving
- Analytical Thinking
- Attention to Detail
- Team Player
Accomplishments
- Optimized 20+ business facing reports to improve performance and cut down execution time by ~40%.
- Redesigned and implemented multiple Autosys job-based ETL loaders to reduce cost-intensive I/O and improve stability and performance.
- Successfully migrated 30+ application schemas from onprem Netezza to AWS Redshift while aligning to a tight deadline of 6 months.
- Collaborated with 20+ application teams to plan and execute AWS Cloud onboarding process. This involved multiple app architecture analysis, diagramming and reviews, governance approvals and navigating through Corp-wide AWS onboarding workflow.
- Streamlined project planning by setting up JIRA and other project management processes.
Certification
Oracle Certified Associate (10g Developer Track)
Academy Accreditation - Databricks Fundamentals
Languages
English
Full Professional
Hindi
Professional Working
Timeline
Principal Consultant
Oracle Financial Services Software Inc
09.2024 - Current
Senior Consultant
Oracle Financial Services Software Inc
01.2017 - 09.2024
Programmer Analyst
Cognizant Technologies Solutions
05.2014 - 12.2014
Associate Consultant
Oracle Financial Services Software Ltd
09.2011 - 05.2014
Bachelor Of Engineering - Computer Engineering
Mumbai University
Similar Profiles
Akarsh PoovaiahAkarsh Poovaiah
Project Consulting Ops : Sr. Business Analyst at Oracle Financial Services Software Ltd.Project Consulting Ops : Sr. Business Analyst at Oracle Financial Services Software Ltd.
Pronomita PrasadPronomita Prasad
Consulting Sales at ORACLE FINANCIAL SERVICES SOFTWARE LIMITED (OFSS)Consulting Sales at ORACLE FINANCIAL SERVICES SOFTWARE LIMITED (OFSS)
PARTHA SARATHI DASPARTHA SARATHI DAS
Managing Principal Consulting at Oracle Financial Services Software LtdManaging Principal Consulting at Oracle Financial Services Software Ltd
Tanmay ShindeTanmay Shinde
Associate Consultant at Oracle Financial Services SoftwareAssociate Consultant at Oracle Financial Services Software
Shannon ManningShannon Manning
Licensed Physical Education Teacher at Cambridge Public SchoolsLicensed Physical Education Teacher at Cambridge Public Schools