PL SQL Developer
Resume:
Lavanya Muktevi
adaumi@r.postjobfree.com
adaumi@r.postjobfree.com
Visa H4 EAD
Looking for C2C position only
Near by MD, DC and VA area
SUMMARY
•6+ years of experience in software development with full life cycle development (SDLC) including requirements analysis & documentation, design, development, testing and implementation of applications.
•Strong work experience in Oracle Database .
•Working experience in Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Export/Import Utilities.
•Exposure in using CASE tools like TOAD, SQL Navigator, SQL Developer for writing PL/SQL programs.
•Expertise in analyzing business requirements and converting business requirement into code.
•Extensive knowledge of creating Business Requirement and Technical Document.
•Having around 5 years of working experience in database coding and implementation with Oracle PL SQL.
•Have experience with Client/Server tools like SQL Server Enterprise Manager, Query Analyzer and SQL Management Studio to administer SQL Server.
•Experience in design, development, coding, and testing of various service oriented and web-based applications using Coldfusion MX/8 and 9.
•Hands-on experience in developing applications using JavaScript, JQuery, XML, AJAX and CSS.
•Experience in database design and implementation with SQL Server 2008 R2. Around 2 years of working experience in design, implementation and maintenance of Relational database servers like MS SQL Server 2005, 2008 with hands on experience on writing stored procedures and triggers in SQL Server.
•Having knowledge on ETL.
•Having knowledge in creating BPEL process using SOA middleware.
•Ability to work independently on individual tasks with minimal technical & management guidance.
•Ability to manage multiple priorities, set functionality, quality, and timelines expectations for project team.
•Proven communication skills with experience in gathering user requirement, documenting and training.
•Experience on Operating Systems like XP/NT/2003/2000/98/95 and UNIX.
•Experience on working in Tableau Desktop.
SKILL MATRIX
Operating Systems
Windows Server 2003, Windows 95/98/NT/2000/XP, MS DOS
Frameworks
Coldfusion Fusebox, NET Framework 4.0/3.5/ 2.0, VisualStudio .NET 2010/2008/ 2005, MVC
Languages
PL SQL, Java, C, C++
Tools
Oracle SQL Developer, Toad, SQL Navigator, PL SQL Developer, mks Integrity, Bug tracking system,Tableau desktop 8.2,
IDE
Dreamweaver
RDBMS
Oracle 9i/10g/12c, MS SQL Server 2008 R2/2005/2000, MS Access, My SQL.
Web Technologies
ColdFusion MX7/ 8 /9, JavaScript, Ajax, jQuery, HTML, XML, CSS, IIS 6/5.1, C#
Version Control
PVCS, Visual Source Safe (VSS) 6.0.
UML Tools
MS Visio
PROFESSIONAL EXPERIENCE
Sr.PL SQL Developer &Analyst, Voya Financials Windsor, CT February 2019-present
Swift Conversion involves the conversion of production workflow data from the WISE DB2 database and metadata from the Oracle IPM SQL Server database will occur in the Power Image Exadata database. The conversion of documents and related data along with data element / data value mapping for this project is tightly coupled with the implementation of new workflows.
•Worked closely with business users to analyze the data. Provided various analysis that would impact the project.
•Created new procedures for PL/SQL development (functions, packages, procedures, triggers, Anonymous Block).
•Core SME for the project.
•Experience working with large databases.
•Involved Extensively in coding for the business logic.
•Worked on performance tuning of queries .
•Experience working with cursors, collections, Bulk collects.
•Wrote complex SQL queries using joins and subqueries to retrieve data from database
•Debugging the data issues/defects assigned, fixing the defects after the analysis and ensuring smooth running of the system post defect fix.
•Involved in deployment during different phases of migration.
•Automated scripts for validations to match the source data counts post migration for business users.
•Handled errors using exception handling extensively.
•Worked in a fast-paced dynamic team-oriented environment.
•Involved in end to end functional testing during different migration cycles.
•Prepare user guide for the end users.
Environment: Oracle PL/SQL 12c, DB2, SQL Server 2016
PL SQL Developer, Fidelity Investments-Smithfield, RI June2017–December 2018
Fidelity Investment’s Asset under management is an application which helps to maintains and track the assets for all the users. It also helps to check the cash flow transactions made and account details by the users . It also enables to edit,delete and freeze the accounts.
•Created and maintained PL SQL scripts and stored procedures.
•Analyze all business requirements and document all technical specifications.
•Designed and Developed application using packages, stored procedures and functions to manipulate the database and to apply the business logic according to the user specifications.
•Wrote complex SQL queries using joins and subqueries to retrieve data from database.
•Worked on performance tuning using various PL SQL tuning techniques for query optimizations.
•Support all day to day activities related to database like data consolidation, data migration scripting
•Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
•Experience working with bulk collections in PL SQL objects
•Created and modified Unix scripts to migrate files.
•Worked on SQL*Loader to load data from flat flies obtained from various sources
•Generate Reports based on day to day activities.
•Handled errors using exception handling extensively.
•Conduct unit testing according to the business requirements.
•Involved in writing Test cases documents.
•Worked under tight schedules for successful development and implementation.
Environment: Oracle PL/SQL,UNIX
PL/SQL Developer, Xerox, Wilsonville, OR Oct 2015 – June 2016
Xerox OCF Convergence Equipment interface is a new interface in PL/SQL to capture all product/SN records and customer information that flows through one application system (GSCB) instead of already existing channel (OCF) for all specific equipment (A4 equipment and A3 equipment) that is sold through the channel. These interfaces systemically load model, customer information, product/sn records, all part information associated to each model from GSCB to OUT.
•Analyze all business requirements and document all technical specifications.
•Designed and Developed packages, stored procedures and functions to manipulate the database and to apply the business logic according to the user specifications.
•Wrote complex SQL queries using joins and subqueries to retrieve data from database.
•Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
•Created scripts to create new tables, views, queries for new enhancements using TOAD
•Worked on SLA’S to meet the business requirements.
•Created indexes and sequences on table during deployments to production.
•Involved in preparing documents for program change specification and program specification for the various changes that need to be done in the existing project.
•Conduct unit testing according to the business requirements.
•Write Test cases.
•Worked under tight schedules for successful development and implementation.
•Design and Develop tableau visualization solutions
•Created worksheets and dashboards.
•Used Multiple measures like individual axes, multiple axes and dual axes.
•Prepare dashboards using calculations, parameters in tableau.
Environment: Oracle PL/SQL, Tableau.
Application Developer, Xerox, Wilsonville, OR June 2014-September 2015
Xerox PagePack is a web application where Entitlements are ordered ONLY via the PagePack online tools available on the PagePack Program Site. PagePack Contracts are the written agreements between Channel Partners and their end-user customers Channel Partner shall cooperate with Xerox to address all PagePack related issues. PagePack helps to understand and manage printing costs, with free automatic meter reads for accurate billing. It also boosts productivity, with online consumables ordering available 24/7 delivered to the door.
•Developed and enhanced the application based on change Requests using coldfusion,PL SQL,,server side JavaScript.
•worked on module to support and maintain application.
•Worked on SLA’S to meet the business requirements.
•Created stored procedures and functions to manipulate the database and to apply through business logic according to user specifications.
•Used HTML, JavaScript and embedded PL/SQL coding within those languages.
•Used JavaScript for client- side scripts to interact with user.
•Created scripts to create new tables, views, queries for new enhancements using TOAD.
•Created indexes and sequences on table during deployments to production.
•Involved in data loading using SQL developer by calling scripts to load the batch data into the tables.
•Support all day to day activities related to database like data consolidation, data migration scripting.
•Responsible for performance tuning activities in the project.
•Generate reports on day today basis for the all the data that is being loaded in the tables.
•Conduct unit testing according to the business requirements.
•Involved in preparing documents for test cases and program change specification for the various changes that need to be done in the existing project.
Environment: PL/SQL, jQuery, Ajax, XML, JavaScript, CSS, ColdFusion.
Application Developer, Net.Orange Technologies,India December 2013-April 2014
Care Management helps to enroll patients on custom-tailored care plans that can be easily adapted from a library of standard care plan templates. Patients can be enrolled in care plans with the care plan wizard and associated flow sheets are automatically enabled to track the patient's status over time and along with patient-specific goals and parameters. This is built on clinical operating system.
•Worked on module to support and maintain application in a Health care domain.
•Experience working in Agile methodology.
•Worked on bug fixes based on the change requirements.
•Used Dynamic HTML (DHTML) and JavaScript in the application to create and manipulate HTML elements.
•Used JavaScript for client- side scripts and to interact with user
•Used jquery for simplifying HTML document traversing, event handling and validations.
•Conduct unit testing.
•Involved in Scrum calls and Report t
•o a scrum master on day today activities and bug fixes.
Environment: JavaScript, Jquery, HTML, Ajax, XML,Oracle PL SQL, Coldfusion. CSS.
Software Developer, Invincible software solutions Integrated,India February 2012-November 2013
Timesheet Management System is a web-based timesheet and project management system for small and medium businesses. It is Simple to use, geared for consulting businesses with many projects, and billing, Cross platform, Self-updating. Multilingual Any company that bills for services or performs project-oriented work can be benefit from TMS.It allows for employers to track people's billable time.
•Extensively involved in designing and developing the GUI using Web Forms
•Developed the Application using ColdFusion, JavaScript, jQuery, XML and SQL Server 2008.
•Provided Role management to differentiate information according to user’s role.
•Used Jquery and JavaScript in the application to create and manipulate HTML elements.
•Implemented Administrator module to manage facilities to accept and decline employees, projects and its associated tasks.
•Implemented Mailing concept to send mails to employees on submitting the tasks.
•Implemented Data exporting functionality to export data to Excel and PDF.
•Created Stored Procedures to manipulate the database and to apply the business logic according to the user specifications
•Performed Unit Testing and Integration Testing on the modules according to the requirements and development standards.
•Worked with the testing team for resolving bugs.
Environment: ColdFusion, jQuery, Ajax, XML, MS SQL Server 2005, JavaScript, CSS.
Track Environmental Energy application measures the consumption of energy in various forms such as Electricity, Water and Gas on scheduled time frames. We use some qualified devices such as meters and mod bus to measure/record the values. The application involves the extensive use of graphical user interface features.
•Actively participated in gathering requirements from client, analyzing and preparing design document.
•Implemented Graphs and Charts (like Bar Charts, Pie Charts, Line Graphs and Stacked Graphs) according to energy measurements available in Database.
•Implemented Compliance Report using SQL Server Reporting Services (SSRS).
•Using jQuery implemented selection criteria to generate Graphs.
•Created Stored Procedures to manipulate the database and to apply the business logic according to the user specifications.
•Provided Role management to differentiate information according to user’s role.
•Implemented Administrator module to manage facilities, locations, regions, and meters (Gas, Water, and Electricity).
•Implemented Data exporting functionality to export data to Excel and PDF.
•Used Dynamic HTML (DHTML) and JavaScript in the application to create and manipulate HTML elements.
•Implemented functionality to maintain logs of transactions to or from Database in two ways (i) Storing logs in database (ii) Storing logs in text files.
•Performed Unit Testing and Integration Testing on the modules according to the requirements and development standards.
•Worked with the testing team for resolving bugs.
Environment: ColdFusion, jQuery, Ajax, XML, MS SQL Server 2005, JavaScript, CSS.
Competency skill matrix system is used for assessing skills for the employee. It is used as assessment tool to assess skills of the employee. Employee can insert and edit new skill based on the skill category and can rate their skills. For each employee Reports can be generated based on skills and their skill rating in form PDF, excel and word formats.
•Extensively involved in designing and developing the GUI using Web Forms
•Developed the Application using ColdFusion, JavaScript, jQuery, XML and SQL Server 2005.
•Generating the PDF Prints and Reports
•Performed Unit Testing and Integration Testing on the modules according to the requirements and development standards.
•Involved in Bug fixing.
Environment: ColdFusion, jQuery, Ajax, XML, MS SQL Server 2005, JavaScript, CSS.
Education:
Bachelor of Technology (B.Tech) in Computer Science from TKR Engineering College, India
Contact this candidate