Candidate Information Title Software Development Sql Developer Target Location US-FL-Valrico	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

PROFESSIONAL SUMMARYIT professional with 9 years of diverse experience in IT, including business analysis, applications management, strong software development skills and a solid technical aptitude for troubleshooting and problem solving. Excel in identifying system needs, implementing multi-faceted application solutions, and working with a variety of operational systems, software, development languages and tools.Involved in all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Development, Testing, Implementation and Maintenance with timely delivery.Expertise in writing Packages, Stored Procedures, Functions, Views, Database Triggers using SQL and PL/SQL in Oracle.Strong knowledge in Oracle Cursor management, REF Cursors, JSON queries.Worked on advanced PL/SQL constructs like Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.Experienced in Bulk Collections, PL/SQL Collections and Exception handling.Extensively used oracle UTL_FILE package on XML documents.Creating different kinds of partitions on tables and indexes.Experienced in Tuning Queries for better performance with large volume of data.Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN.Experienced in query optimization using EXPLAIN PLAN, SQL* TRACE and viewing the TKPROF files.Designed and developed the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.Strong in using tools such as SQL developer, SQL*Loader, SQL*Plus and TOAD.Troubleshooted, fixed, and implemented bug fixes and enhancements within tight deadlines.Experienced in writing UNIX shell script and PRO * C script and scheduled job using CTRL M tool.Played a major role in L3 on call support.Experienced in writing 4GL scripts, stored procedures using Informix db.Worked on SAS scripting and debugging.Experienced in Unit testing and Integration Testing with excellent debugging skills.Excellent technical and analytical skills with clear understanding of OLTP, Datawarehouse and OLAP models.Comprehensive knowledge of waterfall and Agile scrum methodologies.Highly motivated, excellent team player, enthusiastic, strong initiative, and quick learner of new technologies.TECHNICAL SKILLSOperating SystemsLinux, Unix, IBM AIX 5.3 and Windows 95/98/2000/NT/XPLanguagesOracle PL/SQL, UNIX Shell Scripting, SAS, Pro C, 4GLDatabasesOracle8i,9i, 10g & 11g, 19c, InformixToolsSQL*Plus, SQL* Loader, SQL Developer V1.5.0.54.40, Toad, CTRL M, SVN, GIT, EURC, RSAM, Cron Job SchedulingSupporting SoftwareBorland StarTeam, Putty, Smartbear Code Collaborator V7, ExceedMiddleware/DistributedWeb servicesOthersHTTP/HTTPS, FTP, SCPEDUCATIONBachelor of Science in Computer Science  Graduated: 2004Bharatidasan University  Trichy, IndiaMasters of Computer Application  Graduated: 2007Anna University  Chennai, IndiaPROJECT SUMMARYProject Name : Retail Energy Management SystemClient : Dominion Energy, Richmond, VADuration : 08/2021  08/2022Position : PLSQL- Unix Lead DeveloperThis Application is being Directly used by the Dominion Data Analyst and Business enhance team to manage/maintain the utility services (Energy, Products and Services), provided by Dominion and its Trading Partners. It enables an insight into the current and future customer services and helps in making business decisions based on the reports generated from data warehouse. There is a separate database which takes care of Inbound/Outbound activity of GAS distributions, and it will feed to Datawarehouse using ETL batch process. The operations include enrollment, billing, payment, usage, bad_dept and confirmation transaction between Dominion and its customers.Involved in gathering the requirements from business and in the analysis, design & development, end to end testing of the project.Demonstrating skill in applying IT experience in business systems in a large-scale environment.Experience in supporting day-to-day operations of business applications needed.Interacted with other Utility providers and other project members to collect, analyze and document user requirements.Propose a reliable solution for the requirement and preparing the technical understanding document.Writing SQL queries using analytic functions and enhancing Complex SQL queries to generate performance reports as per the DA team.Experience in preparing and deploying complex schema updates, data migration and scripts.Improved performance of long running views and stored procedures.Developed oracle tables, views, triggers, synonyms, user defined functions, stored procedures, packages and indexes.Used Cursors and Collections for accessing complex data resulted from joining of large number of tables.Extensively used For all and bulk collect to fetch large volumes of data from table.Used Hints like append, no index, use index, driver site, etc., to improve the performance.Brief knowledge of cleansing and loading of data to different databases. Related Experience in developing/managing large-scale databases.Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every month in Production, UAT, DEV Environments.Wrote Unix shell scripts, wrapper scripts to schedule in cron tab.Wrote Unix shell scripts for dynamic database loading to different tables.Wrote Unix shell scripts for file transfer system using FTP/SFTP.Wrote Unix shell scripts to validate the flat file received from other sources.Plan production deployment activities, ITSM processes and coordinate with various teams like DBAs, Unix Admins etc.Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables.Scheduled job in Cron tab for automation.Environment: Oracle 18c, 12c, 11g, 10g, SQL Developer, TOAD, PL/SQL, SQL*PLUS, MS Office, Microsoft Outlook, Linux servers, Mobaxterm, Cron Job Scheduler, Windows 10 professional and Unix, SVN, Enterprise AXWAY server.Project Name : CMG DashboardClient : JP Morgan Chase, Wilmington, DEDuration : 03/2016  11/2016Position : PLSQL Lead DeveloperThis application is used by Chase customer management group in order to manage the performance of Brokers (a.k.a Third Party Originations or TPO) and Correspondents who do business with Chase The data for this dashboard comes from various systems and feed the details to CMG Dashboard DB using ETL process on a monthly basis. It allows the group to quickly focus on poorly performing customers and negative trends in the portfolio down to a very granular level. The Dashboard contains originations, Booking, Loan Integrity, Delinquency and Charge off information and could be viewed at the TPO level, Account Executive, Portfolio, Channel, or National Level.Working on the service request and business enhancements raised by clientAnalyzing the business requirement and possible Impact of the proposed enhancement.Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on service requests.Created and maintained database objects like tables, views, Indexes, triggers, and synonyms to meet the business requirements.Wrote complex SQL queries, Sub queries and nested loops for faster data retrieval.Created Cursors and Ref Cursors to process the required data.Used Bulk Collect and FOR ALL to DML multi-row from table.Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.Interacted with End Users and other project members to collect, analyze and document user requirements.Wrote SQL queries using analytic functions.Experience in preparing and deploying complex schema updates, data migration and scripts.Improved performance of long running views and stored procedures.Developed oracle tables, views, triggers, synonyms, user defined functions, stored procedures, packages and indexes.Used Cursors and Collections for accessing complex data resulted from joining of large number of tables.Extensively used For all and bulk collect to fetch large volumes of data from table.Used Hints like append, no index, use index, driver site, etc., to improve the performance.Brief knowledge of cleansing and loading of data to different databases. Related Experience in developing/managing large-scale databases.Worked on extracting data from different databases like Teradata, Sql Server and Load to Oracle database tables.Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every month in Production, UAT, DEV Environments.Wrote Unix shell scripts to make the process to run in dynamically.Wrote Wrapper scripts to automate the ETL process.Worked with SAS scripts for some minor enhancements.Plan production deployment activities, ITSM processes and coordinate with various teams like DBAs, Unix Admins etc.Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables.Scheduled job in Control M tool for automation.Worked on SAS scripts analysis and changes for automation.Environment: Oracle 9i,10g,11g, SQL Developer, PL/SQL,SQL*PLUS, MS Office, Microsoft Outlook, Linux servers, Putty, Control M, GIT, Windows 7 professional and Unix, SVN,EURC,RSAM.Project Name : Online Trading SystemClient : United Services Automobile Association, San Antonio, TXDuration : 10/2010 10/2014Position : PLSQL Lead DeveloperOnline Trading system is a web-based application that allows investors and traders to place trades and monitor accounts includes open, close and manage market positions. The trading application providing straight though processing and supporting entire trade life-cycle (front office, middle office and back office functions) of a comprehensive list instruments such as Stocks, MF, ETF's, Options, CD's, etc. System will incorporate data input, validate trade entry, pack the data and send it for processing to the third-party application which take cares of execution of received trades.Working on the service request and business enhancements raised by clientAnalyzing the business requirement and possible Impact of the proposed enhancement.Propose a reliable solution for the requirement and preparing the technical understanding document.Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on service requests.Created and maintained database objects like tables, views, Indexes, triggers, and synonyms to meet the business requirements.Wrote complex SQL queries, Sub queries and nested loops for faster data retrieval.Created Cursors and Ref Cursors to process the required data.Used Bulk Collect and FOR ALL to DML multi-row from table.Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.Extensively worked through SQL Developer and SQL Plus for database development and tuning.Used Oracle packages  DBMS, UTL_FILEUsed exception handling methods along with pragma exception_init to associate our own created exception names for the ease of debugging and displaying the error messages in the application.related batch jobs to load data into our database using UNIX Shell Script and Control - M scheduling.Developed pl/sql program unit to test the business logic in testing environment.Extensive participation in L3 on call support and assisting the Production job monitoring team with the technical issues and test database server manintenence.Analyzed and overviewed the database design for better understanding the relations, associations, and dependencies within the database.Provided technical design and documentation for new development and existing system enhancement.Worked with testing team for test case and test script preparation.Coordinated with QA and Testing team and provided technical support for business implementation.Worked as independent contributor for the project.Environment: Oracle 9i,10g,11g, SQL Developer, PL/SQL,SQL*PLUS, MS Office, Microsoft Outlook, IBM Unix servers running AIX 5.3, Putty, SVN, Control M, Windows 7 professional and Unix.Project Name : Brokerage GUI EnhancementsClient : United Services Automobile Association, San Antonio, TXDuration : 12/2009  10/2010Position : Oracle PL /SQL DeveloperIMCO systems comprise of IT applications which are to provide highly customized Graphical User Interface of investment banking services to USAA audiences through a 3-Tier architecture and other tool services for member support representatives (MSRs) in USAA. This application interacts with various internal/external systems like CBT, STARS, Phase 3 (SunGard), Reuters, IDC, Fund Quest and mainly focused for offering full-fledged investment banking services to the end users.Writing pl/sql procedure/packages/functions to resolve the daily task related issue to make them atomized.Created scripts to load the data into database tables from flat files using SQL* Loader.Created stored procedures with cursors to generate the reports.Created various complex queries with joins, sub-queries, and nested queries in SQL queries.Involved in production support by efficiently debugging the production issues.Created indexes, constraints, triggers, synonyms in different schema.Worked on Oracle Data dictionaries views to get information related to objectWorked on Bulk Collection and Pl/sql table for getting optimal performance.Wrote Shell Scripts to do manipulation on vendor input files and loaded into database tableGenerating various reports on requirements using PL/SQL, ProC and SQL * plus SPOOL command.Involved in job scheduling using CTRL M.Peer Review of code before turning over to production.Preparation of Unit Test plan.Perform System Testing, Release Testing and deploy the code.Coordinating with onsite, attending regular hand-off and transition meetings for new projects.Providing Knowledge transition on delivered effort to Production Support team.Environment: Oracle 9i,10g,11g, SQL Developer, PL/SQL,SQL*PLUS, MS Office, Microsoft Outlook, IBM Unix servers running AIX 5.3, Putty, SVN, Control M, Windows 7 professional and Unix.Project Name : Pro C MigrationClient : United Services Automobile Association, San Antonio, TXDuration : 05/2008 - 11/2009Position : Oracle PL/SQL DeveloperThis migration activity mainly focused to converting the existing system in to new system with adaptive enhancement. This system deals various daily, weekly and monthly reports created in UTL_FILE package and converted to Pro C scripts. These reports are scheduled to run using CTRL M.Worked on project estimates, resourcing, status updates, project plan updates, and team coordination.Preparation of Checklists, identification of Test Cases, preparing Test Plans.Developed Pro C scripts with embedded pl/sql and sql.Wrote Unix shell scripts to invoke the Pro C executables.Scheduled all scripts in CTRL M.Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.Wrote complex SQL queries, Sub queries, Cursors and Collections for faster data retrieval.Involved in Performance Tuning for the SQL, PL/SQL scripts.Coordination with the Release Management team to ensure the version control of the scripts execution in Production environment.Provided knowledge transfer to other team members about the new technology and allocation of tasks to the team.Involved in writing technical documentation, and writing test plan.Coordinated with development team, project management, QA and provided necessary supportEnvironment: Oracle 9i,10g, TOAD, SQL*PLUS, MS Office, Microsoft Outlook, Putty, Windows 7 professional, Borland Starteam, Smartbear Code Collaborator V7, IBM Unix servers running AIX 5.3, Exceed and Unix.