Sathya Gujulva Rajani Sridhar Location: McKinney, TX, USA

Data Architect & Data Modeler Email: ad4q5q@r.postjobfree.com Oracle – SQL & PL/SQL Lead Developer Mobile: +1-832-***-**** https://www.linkedin.com/in/sathya-gujulva-rajani-sridhar Page: 1 (9) Date: 3/3/2024

PROFESSIONAL SUMMARY

15 years of excellence in IT industry, working in all areas of SDLC – analysis, design, development, coding, testing, deployment and maintenance

12+ years of experience in developing data-related solutions and software

Expertise in Advanced SQL and PL/SQL Programming with environments comprising of multiple transactional databases and multi-terabyte data warehouse.

Specialized in Data Warehousing and Business Intelligence implementations in Banking, Financial and other domain

Currently working as Data Architect/Data Modeler/ Lead Database Developer at Objectstream supporting State’s Worker’s Compensation Commission

Lately worked as Lead Database Developer/ Assistant Vice President at Bank of America, Plano, TX providing solutions and support to Compliance/ Risk and Merchant Commerce applications

Previously worked as Module Leader at Wipro Technologies, System Analyst at Hexaware Technologies, Senior Member Technical Staff at Oracle Corporation and System Engineer at IBM Global Services

Proficient in writing advanced SQL queries using complex Joins and Analytical functions; creating Oracle DB objects like Tables, Indexes, Constraints, Views, Materialized Views, Cursors, Triggers, Temporary tables, Sequences and Synonyms

Proficient in creating Functions, Procedures and Packages using advanced PL/SQL programming concepts like PL/SQL Records and tables, Collections, Ref Cursors, Exception Handling and Dynamic SQL

Hands on experience in SQL and PL/SQL performance tuning using Indexes, Explain Plan, Table Partitioning Methods, Bulk operations and Hints

Hands on experience in Data Modeling, Data Migration and Master Data Management concepts. Hands on experience in creating data archival/purging scripts to remove old data based on the data retention policy given by the business

Have good knowledge on the maintenance of code repository and version control using SVN, Git & Bitbucket for effective team collaboration and to manage/track code changes

Hands on experience in reporting and application development tools / technologies like Discoverer 10g, Toad and SVN (version control tool)

Expertise in understanding / analyzing and gathering customer requirements, creating functional/design documents, coordinating and executing to the final phase which Sathya Gujulva Rajani Sridhar

Page: 2 (9) Date: 3/3/2024

includes resource planning, coding, unit testing, creating release documents and deployment support

Hands on experience in managing and mentoring a team. Supporting the team with functional and technical assistance. Responsible for the project deliverables

Effective communication within the team and across global counterparts / clients on daily basis

Worked individually and collaboratively in onsite/offshore models and well versed in using Agile Methodology for diverse requirements

Excellent in Programming, Problem solving and Customer Interaction skills

Received various prestigious awards and recognitions at the work place TECHNICAL SKILLS

Databases : Oracle 12c/11g/10g/9i/8i, Amazon Relational Database Services (RDS), Postgres, SQL Server & Teradata

(elementary)

Primary Query Languages : SQL & PL/SQL

Primary Tools : Toad, SQL Developer, SQL Plus & MySQL Workbench Version Control System : Tortoise SVN, Git & Bitbucket BI Tools : Oracle Discoverer 10g

PROFESSIONAL EXPERIENCE

Employer: ARC Solutions USA Inc. Client: Objectstream Inc. Duration: Oct 2022 – Till Date

Designation: Data Analyst

Location: Plano, TX, USA

Objectstream – Project #1: Missouri State Work Comp Connect Role: Data Architect/Data Modeler

Description:

The goal of this Modernization Program is to replace legacy applications and implement modernized business processes that leverage technology and help create a dynamic environment capable of providing stakeholders with online access via a single portal

This strategic initiative will introduce new operating processes, roles, and tools to transition from the current transactional model of services engagement to an online personalized customer experience

Technical Responsibilities:

Working actively with the Missouri State Client on the requirement gathering through Joint Application Development/Design (JAD) sessions for the newly built WCC platform

Analyzing and translating business needs into long-term business and data solution

Actively involved in the design of several core features such as Case Management, Customer Service Functions, Enterprise Functions, Self Service Portal, Financial Services and Adjudication

Responsible for Data Modeling and creating various Design Documents like Conceptual/Logical Data Flow Models, Data Dictionary and Data Validation documents Sathya Gujulva Rajani Sridhar

Page: 3 (9) Date: 3/3/2024

Actively involved in the Data Migration process of the legacy data which includes Data Analysis, Data Profiling and Data Mapping activities.

Technologies/Tools Used – Postgres SQL, Git, Bitbucket, JIRA, Draw IO Objectstream – Project #2: Oklahoma State Workers Compensation Commission Role: Lead Database Developer

Description:

WCC (Workers’ Compensation Commission) - The new electronic/online feature to provide digital solutions and services to help the Commission, Claimants, Practitioners, and other Stakeholders operate more efficiently

Creating a flexible business and technology platform for internal and external user accesses

Technical Responsibilities:

Involved in streamlining and automating the operations for Oklahoma WCC Staff Claims, Docketing, Orders & Appeals for WCC.

Primarily involved in several high priority production defects and providing hot fixes and work arounds on timely manner

Involved in ongoing major & minor enhancements

Creating and making changes to the large data structures

Technologies/Tools Used – Amazon Relational Database Service (RDS), MySQL Workbench, JIRA, Git & Bitbucket

Employer: Bank of America

Durations: Jul 2017 to Aug 2019 (EAD Expiry) & Nov 2020 to Aug 2021 Designation: Assistant Vice President/Lead Database Developer Location: Plano, TX, USA

Profile: Bank of America is the second largest American multinational investment bank and financial services holding company headquartered in Charlotte, NC. Its primary financial services revolve around commercial banking, wealth management, and investment banking.

Bank of America – Project #1: Merchant Commerce Master Repository (MCMR) Role: Lead Database Developer

Description:

MCMR (Merchant Commerce Master Repository) captures and maintains all bank’s merchant details, related purchase history and product information Technical Responsibilities:

Involved in the development and maintenance of the MCMR Oracle DB repository upon new requests and business modifications

Mainly responsible for the requirement analysis, sizing and the technical track of the database changes; including data mapping, DB changes, PL/SQL coding, unit testing, assuring sign offs at various stages, deployment scripts and deployment. Monitoring daily JIRA board

Sathya Gujulva Rajani Sridhar

Page: 4 (9) Date: 3/3/2024

Worked on several high priority production defects and provided fixes and work around on timely manner

Worked on making the Golden Gate configuration related changes in the DB repository

Developed and responsible for the generation of daily and monthly reports. QA and queries on the reports were handled

Actively participated in all the Project releases and post production validations.

Technologies/Tools Used – Oracle 12c, Oracle 11g, PL/SQL, JIRA, SVN, Git & Bitbucket Bank of America – Project #2: ORCIT & SDAR

Role: Lead Database Developer

Description:

ORCIT (Operational Risk and Compliance Integrated Technology) and SDAR (Strategic Data Analysis and Reporting) programs are multi-layer technology projects designed to replace numerous legacy risk systems with a single platform that delivers significantly enhanced data integration, reporting and user experience Technical Responsibilities:

Involved in project development, support and BAU (maintenance activities) of ORCIT and SDAR applications

Responsible for the technical track of the project development activities; mainly DB coding, unit testing, assuring sign offs at various stages and deployment

Did extensive PL/SQL coding following the organizational coding standards; to build the complex business logic in the DB. Wrote huge PL/SQL Packages, several functions and procedures. Widely used Views, Cursors, Ref cursors, PL/SQL records and tables, Temporary tables, Index Organized Tables, Triggers and Exception handling

Worked on several low performing SQL queries and Views. Used Explain plan, Indexes, table partitions, bulk operations and optimizer hints to improve the response time

Generated Ad hoc reports by using Oracle 11g Pivot, complex joins and Analytical functions

Worked on both relational and dimensional models for Transactional (ORCIT) and analytical (SDAR) databases respectively

Responsible for handling all the activities of the minor enhancements and bug fixing till the deployment. Monitoring daily JIRA board

Actively participated in all the Project and BAU releases

Technologies/Tools Used –Oracle 12c, Oracle 11g, PL/SQL, JIRA, SVN, Git & Bitbucket Employer: Wipro Limited

Duration: Feb 13, 2012 – Jul 18, 2016

Designation: Module Leader

Wipro – Project #1: Cardinal Health, USA

Location: Wipro, Bangalore, India

Role: Project Lead /Team Lead/Technical Lead

Profile: Cardinal Health is a health care services company providing medical products to over 75 percentage of hospitals in United States. It specializes in distribution of pharmaceuticals and medical products. It also manufactures medical and surgical products.

Description:

Manufacturer portal - MP is an information portal to improve manufacturer’s process by facilitating joint performance ownership between Cardinal Health and Suppliers through a collaborative tool

Sathya Gujulva Rajani Sridhar

Page: 5 (9) Date: 3/3/2024

Generics Costing – GC is a solution that enables the business to improve gross margin and reduce expenses. It maintains rebate information and other calculations which help to maximize cost savings opportunity

Technical Responsibilities:

Led the onsite and offshore teams across functional and technical aspects of the project

Owned the overall application’s accountability and end to end project delivery

Involved in development, support and maintenance activities of MF and GC applications

Involved in creating design documents, data base design and data structure changes

Working and interacting with client directly on day-to-day basis on their business needs and change requests

Provided constant support and solutions till the applications were stable. Much appreciated by the internal management and client for the tremendous efforts put in here

Provided leadership, guidance and support to the offshore development team during transition and knowledge transfer process. Worked closely with clients and built-up confidence during transition phase

Created, modified and fixed several PL/SQL Packages, Function, Procedures, View Materialized Views and DBMS_JOBS.

Worked on several low performing Views and. Used Explain plan, Indexes, table partitions and bulk operations to improve performance

Coming up with various checklists and standard documents for the quality of work at client place

Technologies/Tools Used –Oracle 11g, PL/SQL, Teradata, SQL Server, Toad & SVN Wipro – Project #2: ASGARD & BT Financial Group, Australia Location: Client Location, Perth, Australia

Role: Senior Database Developer

Profile:

ASGARD is a financial services company in Australia that provides wealth management and insurance services. It provides personal insurance and other online banking transaction services.

BT, formerly BT Financial Group, is a financial services company. Its product range includes managed investments, superannuation, insurance, and private banking. Description:

FOFA Project - Worked on the new legislation change request of introducing

'Negotiated Rate Card' feature for the customers and removing 'Volume Bonus Payments' for the dealers / advisers in FOFA project Technical Responsibilities:

Involved in Design, Coding and Unit Testing of the FOFA project life cycle

Working and interacting with client directly at client location on their new project requirements and change requests

Coming up with various checklists and standard documents for the quality of work at client place

Technologies/Tools Used –Oracle 11g, PL/SQL, Toad & SVN Wipro – Project #3: Xoserve, UK

Location: Wipro, Bangalore, India

Role: Technical Lead / Senior Database Developer

Sathya Gujulva Rajani Sridhar

Page: 6 (9) Date: 3/3/2024

Profile: XOSERVE is a leading gas transporters’ agent which provides centralized information and data services for gas transporters and shippers in Great Britain. Description:

‘ConQuest’ is the Query Management system used by Xoserve, Network Operators and Shippers

BPMS Q project is a web-based enhancement of ‘Conquest’ with improved features Technical Responsibilities:

Involved in Design, Coding and Unit Testing of various process modules of Q Project – Phase 2

Mentoring junior team members in coding, testing, back plan and coding standards

Technologies/Tools Used –Oracle 11g/10g, PL/SQL, Toad & SVN Employer: Hexaware Technologies

Duration: Aug 16, 2010 – Jan 30, 2012

Designation: System Analyst

Location: Chennai, India

Hexaware – Project #1: Freeport-McMoRan Copper & Gold Inc. (FMI), USA Role: Team lead

Profile: Freeport-McMoRan Copper & Gold Inc. (FMI) is a leading international mining company with headquarters in Phoenix, Arizona. FMI has a dynamic portfolio of operating, expansion and growth projects in the copper industry and is the world’s largest producer of molybdenum. Description:

The main scope ‘Data Conversion’ Project is the conversion FMI applications from Legacy system to SAP system

The conversion process mainly consists of Extraction process, Conversion process and Loading into SAP

Technical Responsibilities:

Getting the Conversion Procedure document and Source to Target Mapping information document from the customer

Working (Programming) on Data cleansing, Extraction and Transformation Process. Ensuring that proper unit testing is done by the development team

Streamlining the processes, standards and security integrity to ensure corporate standards and compliances

Technologies/Tools Used – Oracle 10g, PL/SQL, Toad, SVN & BODI Employer: Oracle Corporation

Duration: Oct 11, 2007 – Jul 29, 2010

Designation: Senior Member Technical Staff

Location: Bangalore, India

Role: Database Developer

Oracle – Project #1: Oracle University Global Business Solutions (OUGBS) Profile: Oracle University Global Business Solutions (OUGBS) is responsible for Data Warehousing and Web Applications Development for Oracle University. The team is also responsible for business analytics and reporting, to ease up OU’s sales and marketing operations / processes across the world.

Technical Responsibilities:

Writing SQL, PL/SQL programs using stored procedures, functions, packages, cursors, Sathya Gujulva Rajani Sridhar

Page: 7 (9) Date: 3/3/2024

views and materialized views following Oracle standards and guidelines

Designing and developing web applications using PL/SQL, HTML, JavaScript and Apex

Developing reusable Discoverer and SQL ad-hoc reports using advanced SQL and analytical functions for Sales Management, for different business/functional perspective

Designing and analyzing independent / dependent data marts for various applications comprising of daily refresh cycle maintenance and performance tuning

Technologies / Tools Used – Oracle 10g, SQL, PL/SQL, Apex (HTML DB), Discoverer, Toad, Java Script and SVN

Functional Responsibilities:

Following project management cycle on a day-to-day basis; comprising of requirement analysis, BRD & FDD creation, risk analysis, coding, code walk through, UAT and patching process

Working with QA team to ensure quality delivery of each project

Ensure all the changes (development activity) done in development environment are applied on production environment via patching process

Reporting and discussing project ETAs and Change Requests with my Project Manager for ensuring my work efficiency and achieving targets Oracle – Project #2: Oracle University (OU) Color Reports Description:

The color reports provide a detailed overview of bookings (orders and transactions), activities and opportunities generated by Sales Reps of Oracle University. These color reports help Sales Teams in making various critical business decisions

These reports provide the Sales Directors / Mangers with the daily sales matrices comprising of OU Daily bookings (Green Reports), OU Sales channels (Blue Reports), OU Sales Activities (Yellow Reports) and OU Opportunities (Orange Reports)

The data is sourced from various Oracle Apps functional modules (OM, AR, etc.) and is available at various granularities i.e., Sales Representatives, Managers, Call Center Managers and Division further grouping the data according to the product type, order channel and cross map reports like quota attainment with opportunity Technical Responsibilities:

Understanding of OM and AR modules with their respective workflows in Oracle Applications

Design of dependent data mart to hold data; required PLSQL packages and procedures to handle daily refreshes and Materialized views / Views for reporting purposes

Scheduling and monitoring of refreshes of ETL system. Incorporation of email notifications on successful completion or failure. And also, providing solution to the various data, performance and refresh issues

Development of reusable Discoverer reports showing Sales Representatives’ performance using various date hierarchies

Automation of report extraction, QA, publication on the sales portal

Technologies / Tools Used – Oracle 10g, SQL, PL/SQL, Discoverer, Toad and SVN Employer: IBM

Duration: Aug 16, 2005 – Oct 7, 2007

Designation: Application Programmer

IBM – Project #1: Telstra, Australia

Role: Database Developer/Production Support

Profile: Telstra is Australia’s leading telecommunications and Technology Company, offering a full range of communications services and competing in all telecommunications markets

Sathya Gujulva Rajani Sridhar

Page: 8 (9) Date: 3/3/2024

Description:

Product Construction and Maintenance (PROM) is a Product Manager’s Workbench designed to assist product managers with the conceptual design, creation and implementation of Object such as Product, Promotion Rules / Events and Call Price Plans (CPP)

Technical Responsibilities:

Implementation of new features, handling service requests and issues on the PROM application

Involved in development, testing and deployment phases of all the maintenance requests of PROM

Technologies Used – Centura Team Developer 2000, Oracle 9i/8i and PL/SQL IBM – Project #2: AT&T, USA

Role: Database Developer/Production Support

Profile: AT&T is the largest provider of fixed telephone services and mobile telephone services in USA. It also provides broadband subscription television services through DirecTV in USA.

Description:

Chief Financial Organization (CFO) is the application developed to handle the AT&T’s billing process. CFO protects AT&T’s financial process by ensuring that it only pays for access ordered and/or used

Technical Responsibilities:

Implementation of new features, handling maintenance requests and issues upon the LCIP (Local Connectivity Infrastructure Platform) application.

Involved in development, testing and deployment phases of all the maintenance requests on LCIP application

Involved in testing phase of NEAL-R (Nationwide Expense Access Link-Result) application

Technologies Used – Visual Basic 6.0, ASP, Oracle 8i and PL/SQL TRAININGS AND CERTIFICATIONS

Introduction to Oracle 9i -SQL Certification

Wipro PLCP Certified

AIX Basic Operations V5 Certification from IBM

EDUCATIONAL QUALIFICATIONS

Year Institute / University Degree/Examination Percentage 2003-2005

Madurai Kamaraj University,

Madurai, India

(University Rank Holder)

Master of Science

(Computer Science -

Software)

83.90%

2000-2003 Fatima College, Madurai, India Bachelor of Science

(Computer Science)

80.23%

1999-2000 St. Joseph’s Matriculation Girls

Higher Secondary School,

Madurai, India

Higher Secondary

School Certificate

(H.S.C)

93.40%

1997-1998 St. Joseph’s Matriculation Girls

Higher Secondary School,

Madurai, India

Secondary School

Leaving Certificate

(S.S.L.C)

89.90%

Sathya Gujulva Rajani Sridhar

Page: 9 (9) Date: 3/3/2024

PERSONAL DETAILS

Sex : Female

Marital Status : Married

Nationality : Indian

U.S Visa : H1B

Social Security Number (S.S.N) : Available

Location : McKinney, TX, 75024, USA

Contact this candidate