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