Sql Project
Resume:
Shiva Chalapathi Raju, Bhupathi Raju
ac17u8@r.postjobfree.com
PROFESSIONAL SUMMARY
* ****’s 04 Months experience in analysis, design, development and implementation of Software development Life cycle (SDLC). Responsibilities included analyzing the client requirements, preparing specifications, development of the SQL Queries, Database design, Post implementation support and preparing the user documentation.
Working as a Tech Lead Position in reputed organization and had experience in leading a small team
Working experience of Oracle supplied packages like UTL_FILE, DBMS_CRYPTO, DBMS_JOB, DBMS_LOB, DBMS_MVIEW etc. Strong Technical expertise in SQL, PL/SQL, SQL Tuning, UNIX, Basic DBA Skills and CA Erwin Tool.
Hands on experience in SQL Tuning, Unix Shell Scripting
Expert knowledge of new features in Oracle 11g, such as Virtual Columns, Flashback Table, PIVOT and UNPIVOT queries, Scheduling and processing and in Oracle 12C like FETCH FIRST, Implicit Statement Results and Invisible Columns etc.
Worked on data extraction from various source sources like Oracle 12C/11g/10g, DB2, and Complex Flat Files.
Extensive experience in creating XML files to store data and making them available when necessary.
Understanding and working experience in CA ERWIN Tools and basic DBA Skills. Team player with the ability to communicate effectively in all the levels of development process
Interface professionally and communicate easily with customers and team members.
Expert in performing Oracle SQL Tuning on the Developed Code using Explain Plan, Optimizer Hints, TKProf, partitioning, Statistics and Automatic Workload Repository.
Expert in creating database objects like tables, views, sequences, synonyms, indexes, materialized. Debugging PL/SQL codes to identify the root cause of the issue and resolve it.
View and worked closely with DBA on partition maintenance, index maintenance, Compression etc.
Worked on Advanced PL/SQL concepts like Varrays, Associative Arrays, Nested Tables, Autonomous Transaction, PL/SQL optimization, Pipelined Table Functions and Bulk Binding
Expertise on Oracle and UNIX development tool set (Like SQL*Plus, SQL Loader, SQL developer, TOAD, Putty, Win SCP).
Having a basic awareness of Data warehousing concepts and Informatica. Having a basic awareness of reporting tool Cognos, Crystal Report and Oracle Report.
Experience with version control (Tortoise SVN, SVN), change management and defect tracking systems (HP Quality Centre).
Proven ability to quickly learn and apply new technologies
Basic understanding and knowledge of Java/J2EE technologies
Experience with Agile Methodology.
Strong communication, interpersonal, analytical & team building skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.
TECHNICAL SKILLS:
Technical skills & Languages
SQL, PL/SQL, SQL Tuning, Unix shell scripting
Tools/Utilities
PL/SQL Developer, Oracle SQL Developer, Toad, CA Erwin Tool, SQL*LOADER
Secondary Skills
Java/J2EE, HTML, DHTML, XML, Informatica
Database
Oracle R11, Oracle 12C, SQL SERVER 2005
Operating Systems
MS-DOS, Windows 7, Windows 2000, XP, Linux
EDUCATION:
B. Tech in Computer Science and Engineering, JNTU, Hyderabad, India. (Graduated in 2008)
EMPLOYMENT HISTORY:
Organization
Period
Designation
S2Tech
Feb 2015 – Till Date
PL\SQL Team Lead
Wipro Technologies
March 2008 – Feb 2015
Sr. PL/SQL Developer
PROFESSIONAL EXPERIENCE:
Client: CONDUENT STATE HEALTH CARE, Ridgeland, MS
Project: Medicaid Eligibility Determination System
Role: PL\SQL Team Lead Feb 2015 to Present
Primary Skills: SQL, PLSQL, SQL Tuning, UNIX Shell Scripting
Medicaid eligibility determination system determines Medicaid eligibility for persons who are 65 years of age or older, legally blind and/or totally disabled according to Social Security. The primary objective of this project is to capture applicant information related to Medicaid like Demographic information, Non-financial, institution, financial, resource, transferred resource, third party liability, Medicaid income budget, and ineligible dependent information which is used to determine the appropriate category of eligibility (COE) as part of the Eligibility Determination process. Medicaid eligibility includes a defined Time Period for which the applicant is requesting benefits. Applications may include information for one or more household members as well as authorized representatives. The project is taking care to migrate data from legacy MAGI system to new system and generates reports/Letters/Notices for DOM (Division of Medicaid, MS).
Responsibilities:
Performed maintenance for Mississippi State New Medicaid Eligibility Determination system.
Worked on the merging the legacy MEDS system with New MEDS
Solid understanding of Relational Data modeling and Normalization.
Designed/modified design of database Tables, Constraints, Indexes, Grants, Packages,
Functions and Procedures etc.
Worked on External Tables and preparing files using Oracle Supplied Packages. Developed Database Triggers for audit and validation purpose.
Experienced in troubleshooting SQL statements to increase the overall performance as part of
Performance tuning.
Worked on Oracle 12c new Features like FETCH FIRST, Implicit Statement Results and Invisible Columns etc.
Used Cursors, Ref-cursors, Bulking techniques, Collections and Dynamic SQL.
Extensively used to generate XML code from oracle by using XMLELEMENT, XMLForest and
XMLConcat etc.
Used advanced PL/SQL concepts like Table Functions, Advanced Queuing.
Perform Bulk-testing on the code changes and code review
Took the responsibility of leading the offshore team.
Designed and developed UNIX shell script to schedule the batch job and for receiving\sending files to Federal and State worksites
Client : GM ONSTAR, Detroit MI
Project : TEST DATA INTEGRATION
Role: Sr. PL/SQL Developer Sep 2013 to Jan 2015
Primary Skills: SQL, PLSQL, SQL Tuning,
GM OnStar TDI Project involves developing a Tool (TDI Tool) for the OnStar testing team that ease them in automated testing and Manual Testing. Also was a part of the System Engineering team responsible for the Business Process flow and Architecture for the functional requirement
Responsibilities:
Design and Development of the TDI Database. Involved in the whole life cycle of the project.
Understanding and gathering the business requirements for TDI Application
Translated business/functional requirements to create and alter database objects like Tables,
Indexes, Constraints, Indexes, Types, Grants, Synonyms, Queues, Queues Tables and
Stored Procedures.
Develop software, architecture specifications and business logic in Oracle using Stored Procedures, Packages, Functions and Views.
Tuning queries/procedures for the application. Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Responsible for ensuring coding standards are followed at each phase of development.
Responsible for estimation, planning and execution
Worked on Oracle 11g new Features like Invisible Index and Virtual columns etc.
Performing the code fixes for the developed code to meet the requirement
Responsible for creating Detail design document, unit test cases, change request document and mapping documents for reporting.
Responsible for people management, including goal setting and providing performance feedback.
As an onsite resource passing the business requirements to the offshore team, coordinating with offshore team to get the assigned technical work completed, updating the offshore status to the customer on an ongoing basis.
Client: British Petroleum, (Naperville, IL)
Project: Global Cartage Newco project
Role: Onsite Team Lead May 2012 to Aug 2013
Primary Skills: SQL, PLSQL, SQL Tuning, UNIX Shell Scripting, Oracle DBA and CA Erwin Tool
Global Cartage NEWCO deals with cloning the Application and dividing the contract, trucking companies, Stock point, terminals information among the BP Global Cartage and Non-BP Global Cartage. The team ensures design, development, implementation & execution of various components for uninterrupted payment to trucking companies in both the systems. The team is also responsible for regular maintenance of the Global cartage application and providing continuous technical support to Application users and stakeholders.
Responsibilities:
Supported Global Cartage application as Onsite Team Lead in addition to the project work.
Worked on identifying the main tables and their dependent tables that are to be effected in Global Cartage Newco project
Creation of table space, indexes, user and database objects like tables, views, materialized views, procedures and packages using Oracle tools like Toad, PL/SQL Developer and SQL* plus.
Prepared the queries for deleting the BP Related data from the Cloned Application and archive the Newco data using scripts
Analyzing the Oracle objects and modify them in both applications according to the requirement.
Prepared the queries for deleting the old data from the Global Cartage archival
Helped the user in testing the integrity of the database in test and production
Implemented multiple Change Requests in GC and prepared reports as and when required
Prepared and executed unit test cases
Worked with DBA for setting up the Database Replay functionality for testing purpose.
Modified UNIX shell script for scheduling the batch jobs for Global Cartage Newco Project.
Analyzing available information applying experience and system knowledge to diagnose problems and identify solutions to meet user requirement.
Took the responsibility of leading the offshore team.
Worked as a Business Analyst in British petroleum for their Windows 7 Migration.
Client: British Petroleum, (Hyderabad, India)
Project: GLOBAL CARTAGE
Role: Offshore Team Lead Developer Jan 2010 to Apr 2012
Primary Skills: SQL, PLSQL, SQL Tuning, UNIX Shell Scripting, CA Erwin Tool
Global Cartage deals with payment of invoices of the Secondary Freight Transport of the BP Products from stock point to Terminal. The main function of Global Cartage is, to accept the trip information from Vitria (Middle tier), calculate the cost of the trip using Contracts, combining the cost of all the trips for each trucking company to generate the invoices and sending the invoices to SAP in the required format. The team ensures design, development, implementation & execution of various components for uninterrupted payment to trucking companies. The team is also responsible for correcting the cost of trips for any invalid contracts, re-executing any failed batch jobs and providing continuous technical support to Application users and stakeholders.
Responsibilities
Capturing business knowledge by closely working with customer technical teams and set of business users and documenting it in BRD.
Design and developing packages, Stored Procedures, functions, SQL Scripts, Packages and Shell Script
Worked on various tables to create Indexes to improve query performance and Oracle Statistics to improve query performance
Used the concepts of Advanced PL/SQL concepts like Autonomous Transaction, PL/SQL optimization, Pipelined Table Functions and Bulk Binding during Global cartage development
Helped the user in testing the integrity of the database in test and production
Design and development of Global Cartage application
Implemented multiple Change Requests in GC and prepared reports as and when required
Prepared and executed unit test cases
Designing and modifying Database model using CA Erwin Tool.
Adhere to full software development life cycle.
Created programming code using advanced concepts of Records, Collections.
Client : PepsiCo, (Chennai, India)
Project : PEPSI COLA MASTER FILES (PCMF)
Role: Junior PL\SQL Developer Dec 2008 to Dec 2010
Primary Skills: SQL, PL-SQL, SQL Tuning, UNIX Shell Scripting
Secondary Skills: Core Java, J2EE, Java Script
Pepsi Cola Master Files is a data repository for both item and bottler information.
Responsibilities
Migration of the Data source of PCMF from IPS-Haht application to SAP
Performed data monitoring, testing and prepared the reports, which helped in smooth transition of application
Created database objects like tables, views, Procedure etc.
Preparing multiple Queries as per User Interface (UI).
Maintenance of PCMF and prepared reports on demand
Developed Java client application for Pepsi Cola Master File online
Contributed in the preparing a web application for effort tracking in Pepsi.
Experience in working with CVS and Tortoise SVN
Experience in working in Java/J2EE for POLR application and EPM Applications
Prepared and executed unit test cases
Worked on UNIX Shell Scripts for Job Scheduling and Automation.
Understanding of Extract, Transform and Load
Responsible for creating a data model, ER diagram by using used cases.
Client : CSFB (Pune, India)
Project: CSFB IT Risk Reporting
Role: Reports Developer Jul 2008 to Nov 2008
Primary Skills: SQL, PL/SQL, Microsoft Excel
CSFB IT Risk Reporting involves timely preparation of the reports regarding IT Risk for all divisions of Credit Suisse
Responsibilities
Prepared daily, weekly and monthly data reports for CSFB and delivering them at the right time
Worked with Database Administrators (DBAs) to add some hints in Extract SQL as required per Explain plan of the SQL to gain efficient performance results.
PERSONAL INFORMATION:
Father Name: Peddi Raju Bhupathi Raju
Address: 6811 Old Canton Road,
Ridgeland, MS, 39157
Skype: shiva.bhupathi1
Work Authorization: H1B
LinkedIn: https://www.linkedin.com/in/shivacraju-bhupathiraju/
I hereby declare that the information that I have furnished is authentic and true to the best of my
Knowledge.
Shiva Chalapathi Raju Bhupathi Raju
Contact this candidate