Lead Oracle SQL & PL/SQL Data Architect

SATHYA GUJULVA RAJANI SRIDHAR

Lead Oracle SQL & PL-SQL Developer / Data Architect / Data Modeler

McKinney, TX +1-832-***-**** **********@*****.*** linkedin.com/in/sathya-gujulva-rajani-sridhar PROFESSIONAL SUMMARY

Database Developer and Data Architect with 16+ years of IT experience across the full software development lifecycle, with specializing in database design, development, and data-driven solutions for Banking, Finance, Workers' Compensation, and Healthcare organizations.

● 15+ years of experience in Database Design, Development, Data Warehousing, and Business Intelligence.

● Proven track record leading database development for large-scale platform modernization programs.

● Extensive experience in Data Modeling, Data Migration, Data Bridging, Master Data Management, and data archival/purging.

● Deep expertise in Oracle SQL/PL-SQL, data warehousing, and business intelligence.

● Advanced SQL/PL-SQL developer: Tables, Indexes, Constraints, Views, Materialized Views, Cursors, Triggers, Sequences, Synonyms, Functions, Procedures, and Packages using Records, Collections, Ref Cursors, Exception Handling, and Dynamic SQL.

● Skilled in SQL/PL-SQL performance tuning, indexing, partitioning, bulk operations, hints, and explain plans.

● Skilled in requirements gathering, team leadership, and Agile delivery across onsite/offshore models.

● Proficient with version control systems (Git, GitHub, Bitbucket, SVN) to facilitate effective team collaboration and manage/track code changes.

● Currently Software Developer / Data Migration Lead at ARC Solutions USA Inc. supporting the Missouri State Work Comp Connect platform modernization.

● Former Assistant Vice President / Lead Database Developer at Bank of America, focused on Compliance, Risk, and Merchant Commerce solutions.

TECHNICAL SKILLS

Databases: Oracle 19c/12c/11g/10g/9i/8i, PostgreSQL, Amazon RDS, SQL Server, Teradata Languages: SQL, PL/SQL, PL/pgSQL

Tools: Toad, SQL Developer, MySQL Workbench, pgAdmin, JIRA, Draw.io Version Control: Git, GitHub, Bitbucket, SVN (Tortoise SVN) BI / Reporting: Oracle Discoverer 10g

Methodologies: Agile/Scrum, Onsite-Offshore Delivery, Data Migration, Data Modeling, ETL PROFESSIONAL EXPERIENCE

ARC Solutions USA Inc. (Client: Objectstream Inc.) Plano, TX Oct 2022 – Present Software Developer / Data Migration Lead / Data Architect / Data Modeler Project: Missouri State Work Comp Connect (WCC) Platform Modernization

● Partner with Missouri State stakeholders in JAD sessions to gather requirements for the new WCC platform, translating business needs into long-term technical solutions.

● Architected the data base design for core modules including Case Management, Customer Service, Enterprise Functions, Self-Service Portal, Financial Services, and Adjudication.

● Manage end-to-end data migration activities — data analysis, profiling, cleansing, and mapping — ensuring data integrity and security.

● Lead and mentor a data migration team through ETL and database scripting, including conducting code reviews.

● Built and maintained data bridging solutions/programs using PL/pgSQL to synchronize data between the legacy systems and the new WCC platform.

● Established and managed reference data for migrated and new data, supporting accurate data mapping, validation, and system integration.

● Review user stories to confirm technical scope aligns with business requirements and platform objectives. Create design documentation to support development, code reviews, and stakeholder sign-off.

● Own data modeling deliverables: Conceptual/Logical Data Flow Models and Data Dictionary.

● Build physical database structures (tables, indexes, views, triggers) in PostgreSQL for application development and data migration.

● Develop and test the application to ensure functionality, performance, and data accuracy.

● Support QA through validation and defect resolution across testing cycles. Write test cases and conduct unit, integration (SIT), regression, performance, and UAT testing for data validation. Environment: PostgreSQL, PL/pgSQL, Amazon S3, Git, GitHub, JIRA, Draw.io Project: Oklahoma State Workers' Compensation Commission (WCC)

● Delivered a new electronic/online platform enhancing efficiency for the Commission, claimants, practitioners, and other stakeholders.

● Streamlined and automated operations for Oklahoma WCC Staff Claims, Docketing, Orders & Appeals.

● Resolved high-priority production defects, providing timely hotfixes and workarounds.

● Delivered ongoing major and minor enhancements and contributed to data migration activities.

● Designed and modified large data structures while maintaining data integrity. Environment: Amazon RDS, MySQL Workbench, JIRA, Git, GitHub Bank of America Plano, TX Jul 2017 – Aug 2019 & Nov 2020 – Aug 2021 Assistant Vice President / Lead Database Developer Project: Merchant Commerce Master Repository (MCMR)

● Developed and maintained the MCMR Oracle database repository capturing merchant details, purchase history, and product information, ensuring data integrity and accuracy.

● Led requirement analysis, database changes, PL/SQL coding, unit testing, sign-offs, deployment scripts, and code reviews.

● Resolved high-priority production defects with timely fixes and managed Golden Gate configuration changes.

● Built and automated daily and monthly reports, streamlining the reporting process and handling QA and ad hoc queries.

● Participated in project releases and post-production validations. Environment: Oracle 19c/12c, SQL, PL/SQL, JIRA, SVN, Git, Bitbucket Project: ORCIT & SDAR (Operational Risk & Compliance Integrated Technology / Strategic Data Analysis & Reporting)

● Supported development, production support, and BAU for multi-layer platforms replacing legacy risk systems with unified data integration and reporting.

● Led technical activities including database coding, unit testing, sign-offs, and deployment.

● Wrote extensive PL/SQL for complex business logic using packages, functions, procedures, views, cursors, ref cursors, PL/SQL records and tables, temporary and index-organized tables, triggers, and exception handling.

● Optimized underperforming PL/SQL code, SQL queries, and views using explain plan, indexes, hints, and partitioning.

● Built ad hoc reports using Oracle 11g pivot, complex joins, and analytical functions across relational (ORCIT) and dimensional (SDAR) data models.

● Managed minor enhancements, bug fixes, daily JIRA board monitoring, and participated in all project and BAU releases.

Environment: Oracle 12c/11g, SQL, PL/SQL, JIRA, SVN, Git, Bitbucket Wipro Limited Bangalore, India Feb 2012 – Jul 2016 Module Leader / Project Lead / Team Lead / Technical Lead Clients: Cardinal Health (USA); ASGARD & BT Financial Group (Australia); Xoserve (UK)

● Led onsite and offshore teams across functional and technical project delivery for multiple global clients.

● Served as primary onsite client contact for new requirements and change requests, owning application accountability and end-to-end delivery.

● Directed database design, coding, and unit testing across the application lifecycle; developed and maintained PL/SQL packages, functions, procedures, views, and DBMS jobs.

● Authored design documents, database structures, and data change specifications.

● Led offshore knowledge-transfer transitions, building client trust and providing ongoing post-go-live support.

● Optimized underperforming views and PL/SQL code using explain plan, indexes, table partitioning, and bulk operations. Developed checklists and standard documentation to maintain high-quality delivery at client sites. Environment: Oracle 11g/10g, SQL, PL/SQL, Teradata, SQL Server, Toad, SVN Hexaware Technologies Chennai, India Aug 2010 – Jan 2012 System Analyst / Team Lead

Client: Freeport-McMoRan Copper & Gold Inc. (FMI), USA

● Led the Data Conversion project migrating FMI applications from a legacy system to SAP, covering extraction, conversion, and loading.

● Authored Conversion Procedure and Source-to-Target Mapping documents.

● Performed data analysis and profiling; developed database and PL/SQL scripts for data cleansing, extraction, and transformation. Ensured unit testing and QA to maintain data integrity and accuracy. Environment: Oracle 10g, SQL, PL/SQL, Toad, SVN, BODI Oracle Corporation Bangalore, India Oct 2007 – Jul 2010 Senior Member Technical Staff — Database Developer Projects: Oracle University Global Business Solutions (OUGBS) & Color Reports

● Designed and developed web applications for Oracle University sales and marketing operations using PL/SQL, HTML, JavaScript, and Apex.

● Built color-coded executive reports giving Sales Directors and Managers a concise view of bookings, sales channels, activities, and opportunities, sourced from Oracle Applications (OM, AR).

● Wrote SQL/PL-SQL programs (stored procedures, functions, packages, cursors, views, materialized views) for daily refreshes and reporting per Oracle standards.

● Developed reusable Discoverer and SQL ad hoc reports for the Sales team using advanced SQL, pivot, and analytical functions.

● Designed and tuned independent/dependent data marts with daily refresh cycles and ongoing maintenance.

● Scheduled and monitored ETL refreshes with automated email notifications, resolving data, performance, and refresh issues.

● Automated report extraction, QA, and publication to the sales portal. Environment: Oracle 10g, SQL, PL/SQL, Discoverer, Toad, SVN IBM Bangalore, India Aug 2005 – Oct 2007

Application Programmer — Database Developer / Production Support Clients: Telstra (Australia); AT&T (USA)

● Implemented new features and enhancements, handled service requests, and resolved issues for the AT&T application.

● Supported development, testing, deployment, and production support of all maintenance requests for Telstra's PROM application.

Environment: Oracle 9i/8i, SQL, PL/SQL, Centura Team Developer 2000, Visual Basic 6.0, ASP EDUCATION

Master of Science, Computer Science — Madurai Kamaraj University, Madurai, India (2003 – 2005) University Rank Holder

Bachelor of Science, Computer Science — Fatima College, Madurai Kamaraj University, Madurai, India (2000 – 2003) Graduated with Distinction

Contact this candidate