| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSathya Gujulva Rajani Sridhar Location: McKinney, TX, USAData Architect & Data Modeler Email: EMAIL AVAILABLE Oracle SQL & PL/SQL Lead Developer Mobile: +1-(Street Address )-576-2373 https://LINKEDIN LINK AVAILABLE Page: 1 (9) Date: 3/3/2024PROFESSIONAL SUMMARY15 years of excellence in IT industry, working in all areas of SDLC analysis, design, development, coding, testing, deployment and maintenance12+ years of experience in developing data-related solutions and softwareExpertise 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 domainCurrently working as Data Architect/Data Modeler/ Lead Database Developer at Objectstream supporting States Workers Compensation CommissionLately worked as Lead Database Developer/ Assistant Vice President at Bank of America, Plano, TX providing solutions and support to Compliance/ Risk and Merchant Commerce applicationsPreviously 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 ServicesProficient 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 SynonymsProficient 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 SQLHands on experience in SQL and PL/SQL performance tuning using Indexes, Explain Plan, Table Partitioning Methods, Bulk operations and HintsHands 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 businessHave good knowledge on the maintenance of code repository and version control using SVN, Git & Bitbucket for effective team collaboration and to manage/track code changesHands 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 SridharPage: 2 (9) Date: 3/3/2024includes resource planning, coding, unit testing, creating release documents and deployment supportHands on experience in managing and mentoring a team. Supporting the team with functional and technical assistance. Responsible for the project deliverablesEffective communication within the team and across global counterparts / clients on daily basisWorked individually and collaboratively in onsite/offshore models and well versed in using Agile Methodology for diverse requirementsExcellent in Programming, Problem solving and Customer Interaction skillsReceived various prestigious awards and recognitions at the work place TECHNICAL SKILLSDatabases : Oracle 12c/11g/10g/9i/8i, Amazon Relational Database Services (RDS), Postgres, SQL Server & Teradata(elementary)Primary Query Languages : SQL & PL/SQLPrimary Tools : Toad, SQL Developer, SQL Plus & MySQL Workbench Version Control System : Tortoise SVN, Git & Bitbucket BI Tools : Oracle Discoverer 10gPROFESSIONAL EXPERIENCEEmployer: ARC Solutions USA Inc. Client: Objectstream Inc. Duration: Oct 2022 Till DateDesignation: Data AnalystLocation: Plano, TX, USAObjectstream Project #1: Missouri State Work Comp Connect Role: Data Architect/Data ModelerDescription: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 portalThis 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 experienceTechnical Responsibilities:Working actively with the Missouri State Client on the requirement gathering through Joint Application Development/Design (JAD) sessions for the newly built WCC platformAnalyzing and translating business needs into long-term business and data solutionActively involved in the design of several core features such as Case Management, Customer Service Functions, Enterprise Functions, Self Service Portal, Financial Services and AdjudicationResponsible for Data Modeling and creating various Design Documents like Conceptual/Logical Data Flow Models, Data Dictionary and Data Validation documents Sathya Gujulva Rajani SridharPage: 3 (9) Date: 3/3/2024Actively 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 DeveloperDescription: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 efficientlyCreating a flexible business and technology platform for internal and external user accessesTechnical 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 mannerInvolved in ongoing major & minor enhancementsCreating and making changes to the large data structuresTechnologies/Tools Used Amazon Relational Database Service (RDS), MySQL Workbench, JIRA, Git & BitbucketEmployer: Bank of AmericaDurations: Jul 2017 to Aug 2019 (EAD Expiry) & Nov 2020 to Aug 2021 Designation: Assistant Vice President/Lead Database Developer Location: Plano, TX, USAProfile: 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 DeveloperDescription:MCMR (Merchant Commerce Master Repository) captures and maintains all banks 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 modificationsMainly 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 boardSathya Gujulva Rajani SridharPage: 4 (9) Date: 3/3/2024Worked on several high priority production defects and provided fixes and work around on timely mannerWorked on making the Golden Gate configuration related changes in the DB repositoryDeveloped and responsible for the generation of daily and monthly reports. QA and queries on the reports were handledActively 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 & SDARRole: Lead Database DeveloperDescription: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 applicationsResponsible for the technical track of the project development activities; mainly DB coding, unit testing, assuring sign offs at various stages and deploymentDid 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 handlingWorked on several low performing SQL queries and Views. Used Explain plan, Indexes, table partitions, bulk operations and optimizer hints to improve the response timeGenerated Ad hoc reports by using Oracle 11g Pivot, complex joins and Analytical functionsWorked on both relational and dimensional models for Transactional (ORCIT) and analytical (SDAR) databases respectivelyResponsible for handling all the activities of the minor enhancements and bug fixing till the deployment. Monitoring daily JIRA boardActively participated in all the Project and BAU releasesTechnologies/Tools Used Oracle 12c, Oracle 11g, PL/SQL, JIRA, SVN, Git & Bitbucket Employer: Wipro LimitedDuration: Feb 13, 2012 Jul 18, 2016Designation: Module LeaderWipro Project #1: Cardinal Health, USALocation: Wipro, Bangalore, IndiaRole: Project Lead /Team Lead/Technical LeadProfile: 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 manufacturers process by facilitating joint performance ownership between Cardinal Health and Suppliers through a collaborative toolSathya Gujulva Rajani SridharPage: 5 (9) Date: 3/3/2024Generics 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 opportunityTechnical Responsibilities:Led the onsite and offshore teams across functional and technical aspects of the projectOwned the overall applications accountability and end to end project deliveryInvolved in development, support and maintenance activities of MF and GC applicationsInvolved in creating design documents, data base design and data structure changesWorking and interacting with client directly on day-to-day basis on their business needs and change requestsProvided constant support and solutions till the applications were stable. Much appreciated by the internal management and client for the tremendous efforts put in hereProvided 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 phaseCreated, 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 performanceComing up with various checklists and standard documents for the quality of work at client placeTechnologies/Tools Used Oracle 11g, PL/SQL, Teradata, SQL Server, Toad & SVN Wipro Project #2: ASGARD & BT Financial Group, Australia Location: Client Location, Perth, AustraliaRole: Senior Database DeveloperProfile: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 cycleWorking and interacting with client directly at client location on their new project requirements and change requestsComing up with various checklists and standard documents for the quality of work at client placeTechnologies/Tools Used Oracle 11g, PL/SQL, Toad & SVN Wipro Project #3: Xoserve, UKLocation: Wipro, Bangalore, IndiaRole: Technical Lead / Senior Database DeveloperSathya Gujulva Rajani SridharPage: 6 (9) Date: 3/3/2024Profile: 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 ShippersBPMS 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 2Mentoring junior team members in coding, testing, back plan and coding standardsTechnologies/Tools Used Oracle 11g/10g, PL/SQL, Toad & SVN Employer: Hexaware TechnologiesDuration: Aug 16, 2010 Jan 30, 2012Designation: System AnalystLocation: Chennai, IndiaHexaware Project #1: Freeport-McMoRan Copper & Gold Inc. (FMI), USA Role: Team leadProfile: 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 worlds largest producer of molybdenum. Description:The main scope Data Conversion Project is the conversion FMI applications from Legacy system to SAP systemThe conversion process mainly consists of Extraction process, Conversion process and Loading into SAPTechnical Responsibilities:Getting the Conversion Procedure document and Source to Target Mapping information document from the customerWorking (Programming) on Data cleansing, Extraction and Transformation Process. Ensuring that proper unit testing is done by the development teamStreamlining the processes, standards and security integrity to ensure corporate standards and compliancesTechnologies/Tools Used Oracle 10g, PL/SQL, Toad, SVN & BODI Employer: Oracle CorporationDuration: Oct 11, 2007 Jul 29, 2010Designation: Senior Member Technical StaffLocation: Bangalore, IndiaRole: Database DeveloperOracle 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 OUs sales and marketing operations / processes across the world.Technical Responsibilities:Writing SQL, PL/SQL programs using stored procedures, functions, packages, cursors, Sathya Gujulva Rajani SridharPage: 7 (9) Date: 3/3/2024views and materialized views following Oracle standards and guidelinesDesigning and developing web applications using PL/SQL, HTML, JavaScript and ApexDeveloping reusable Discoverer and SQL ad-hoc reports using advanced SQL and analytical functions for Sales Management, for different business/functional perspectiveDesigning and analyzing independent / dependent data marts for various applications comprising of daily refresh cycle maintenance and performance tuningTechnologies / Tools Used Oracle 10g, SQL, PL/SQL, Apex (HTML DB), Discoverer, Toad, Java Script and SVNFunctional 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 processWorking with QA team to ensure quality delivery of each projectEnsure all the changes (development activity) done in development environment are applied on production environment via patching processReporting 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 decisionsThese 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 ApplicationsDesign of dependent data mart to hold data; required PLSQL packages and procedures to handle daily refreshes and Materialized views / Views for reporting purposesScheduling 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 issuesDevelopment of reusable Discoverer reports showing Sales Representatives performance using various date hierarchiesAutomation of report extraction, QA, publication on the sales portalTechnologies / Tools Used Oracle 10g, SQL, PL/SQL, Discoverer, Toad and SVN Employer: IBMDuration: Aug 16, 2005 Oct 7, 2007Designation: Application ProgrammerIBM Project #1: Telstra, AustraliaRole: Database Developer/Production SupportProfile: Telstra is Australias leading telecommunications and Technology Company, offering a full range of communications services and competing in all telecommunications marketsSathya Gujulva Rajani SridharPage: 8 (9) Date: 3/3/2024Description:Product Construction and Maintenance (PROM) is a Product Managers 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 applicationInvolved in development, testing and deployment phases of all the maintenance requests of PROMTechnologies Used Centura Team Developer 2000, Oracle 9i/8i and PL/SQL IBM Project #2: AT&T, USARole: Database Developer/Production SupportProfile: 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&Ts billing process. CFO protects AT&Ts financial process by ensuring that it only pays for access ordered and/or usedTechnical 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 applicationInvolved in testing phase of NEAL-R (Nationwide Expense Access Link-Result) applicationTechnologies Used Visual Basic 6.0, ASP, Oracle 8i and PL/SQL TRAININGS AND CERTIFICATIONSIntroduction to Oracle 9i -SQL CertificationWipro PLCP CertifiedAIX Basic Operations V5 Certification from IBMEDUCATIONAL QUALIFICATIONSYear Institute / University Degree/Examination Percentage 2003-2005Madurai 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. Josephs Matriculation GirlsHigher Secondary School,Madurai, IndiaHigher SecondarySchool Certificate(H.S.C)93.40%1997-1998 St. Josephs Matriculation GirlsHigher Secondary School,Madurai, IndiaSecondary SchoolLeaving Certificate(S.S.L.C)89.90%Sathya Gujulva Rajani SridharPage: 9 (9) Date: 3/3/2024PERSONAL DETAILSSex : FemaleMarital Status : MarriedNationality : IndianU.S Visa : H1BSocial Security Number (S.S.N) : AvailableLocation : McKinney, TX, 75024, USA |
