| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateName: NagendarPhone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEPL/SQL DeveloperPROFESSIONAL SUMMARYHaving 9+ years of IT experience as a PL/SQL Developer, Oracle Developer, Development & Support of Oracle Database 9i, 10g, and 11g in Production, staging, and Development environments.Involved in all phases of SDLC (Software Development Life Cycle).Proficient working experience with SQL, PL/SQL, and Database objects like Stored Procedures, Functions, Packages, and Triggers and using the latest features to optimize performance like Bulk bindings, Inline views, and Global Temporary Tables.Excellent experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases.Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators.Proficient in writing, optimizing, and troubleshooting T-SQL scripts, including complex queries, stored procedures, functions, and triggers.Extensive experience in using Oracle seeded packages like DBMS_OUTPUT, DBMS_SCHEDULER, UTL_FILE, DBMS_SQL and DBMS_STATS.Expertise in handling errors using Exceptions with the RAISE application clause.Knowledge of Materialized Views.Generating SQL and PL/SQL scripts to install create and drop Trading Exchange Connection database objects including:Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.Expert in creating Public Synonyms, and DB Links.Proficient in SQL Server and T- SQL (ODL and DML) in constructing Tables and normalization/ De normalization Techniques on database Tables.Install and Configure SQL Server 2005, 2008, 2008R2 on Virtual Machines,Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.Experience in Error and Event Handling: Precedence Constraints, Break Points. Check Points, Logging, Archive data files from different legacy systems using SOL Server 2005/2008/2012 environment, and deploy the data, Schedule the jobs to execute these tasks periodically.Experienced in performing data manipulation tasks such as INSERT, UPDATE, DELETE, and MERGE statements using T-SQL.Experience in Performance Tuning. Query Optimization, Client/Server Connectivity, and Database Consistency Checks.Extensively worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemes of Data Marts.Hands-on experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.Managing security by creating and granting Roles and Privileges to users.Experience in developing external Tables, Views, Joins, Cluster indexes and Cursors.Proficient in advanced features of Oracle 9i for PL/SQL programming like Using Cursor Variables, Ref Cursors, Nested Tables, and Dynamic SQL.Skilled in analyzing and improving query performance using indexing strategies, execution plans, and query hints in T-SQL.Experience in the creation of table Partitioning by range, list, hash, composite methods, and Indexes for managing large tables.Proficient in Query/application tuning using optimizer Hints, Explain plan, SQL Trace, and TKPROF.Developed new Reports which are used to extract data from different systems and criteria.Automated the process through the UNIX Shell Scripting and auto sys job scheduling.TECHNICAL SKILLSProgramming Languages: SQL, Python.RDBMS: MySQL, SQL Server.Reporting Tools: Tableau 8.1, 8.3,9.0,2019.4, Power BI.Other Tools: IBM MDM, XML, JIRA, GitLab.Packages: MS Office, Excel, PowerPoint.Methodologies: Agile Methodology, Water flow methodology.Operating System: Windows, Mac, Linux.PROFESSIONAL EXPERIENCERole: PL/SQL DeveloperClient: SafewayLocation: Dallas, TX Nov 2023 - PresentRoles and Responsibilities:Actively involved in interacting with front-end users and gathering User Requirements and Online System Specifications.Writing Procedures, Functions, Triggers, and Packages.Written Stored Procedures using PL/SQL and functions and procedures for common utilities using Oracle 11g/12c.Designed and developed ETL processes using Azure Data Factory, integrating data from on-premises Oracle databases to Azure SQL Database, ensuring data accuracy and integrity.Automated ETL workflows using Azure Logic Apps and Azure Functions, reducing manual intervention and operational overhead.Led the migration of large datasets from legacy systems to Azure, ensuring minimal downtime and data consistency throughout the transition.Worked on form customizations in Inventory, Purchasing, and developed year-end products.Created several database objects like tables, views, indexes, synonyms, and materialized views.Involved in creating procedures, functions, packages, and triggers to facilitate functionality in different modules.Created data mapping files for the data coming from different Web Services.Created audit tables and implemented complex business logic using triggers, statement-level triggers, and multiple triggers.Developed complex stored procedures using PL/SQL to generate reports.Writing database objects such as functions, stored procedures, packages, and triggers to meet the functional requirements using Oracle PL/SQL and T-SQL.Loaded the data into the tables using SQL*plus.Involved in preparing test plans, unit testing, System integration testing, implementation, and maintenance.Modified in Scripts due to database changes using SQL and PL/SQL.Extensively used the advanced features of PL/SQL like Records, Tables, Object types, and Dynamic SQL.Developed ASP.NET application in N-Tier architecture following agile methodology.Implemented XML Web Services in C# based on SOAP protocols using XML and XSLT extensively for data transfers.Developed and maintained Perl scripts to automate data extraction, transformation, and loading (ETL) processes, significantly reducing manual intervention and errors.Conducted data migration projects involving extraction, transformation, and loading (ETL) processes between Oracle and SQL Server using T-SQL.Ensured adherence to best practices in T-SQL development, including code modularity, readability, and reusability, as well as version control.Developed and maintained Perl scripts to automate data extraction, transformation, and loading (ETL) processes, significantly reducing manual intervention and errors.Utilized Perl for efficient text parsing and manipulation, handling large volumes of log files and data feeds.Generated dynamic reports and dashboards by writing Perl scripts that aggregated and formatted data from multiple sources.Extensive use of Object-Oriented Programming Techniques (OOPS) like Abstract Classes, Polymorphism, Interfaces, exception handling, etc.Developed and consumed the Web Services for getting the PNR (personal name record) and Validating the Orders submitted using Web Services, C#, Asp. NET.Used ADO.NET objects such as Data Reader, Dataset, and Data Adapter, for consistent access to Oracle data sources.Created Perl scripts to integrate disparate systems and facilitate smooth data exchange between applications.Implemented CURD functionality to save and retrieve data from Oracle.Implemented Web Services with SOA using WCF for passing data to multiple platforms.Used LINQ to SQL (object-relational mapping) for integrating data validation and business logic rules into the data model.Worked with ASP.NET Web Forms, Web Services, State Management, Caching features, and configuring optimizations for securing the web application.Proficient in using SQL Server Management Studio (SSMS) for developing, testing, and debugging T-SQL code.Created the UI layers and web pages and integrated them to maintain the performance of data flow and data integrity using ASP.NET User Controls, and Web Server Controls.Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.Worked on requirement analysis, coding, and testing various modules in a softwaredevelopment life cycle.Developed Unix Shell Scripts to Schedule jobs to automate tasks of loading data into Tables.Investigated and fixed problems reported by users of the application that runs Prescription Solutions' mail-order pharmacy business.Experience includes analysis, design, coding, testing, training, documentation, and production support that includes a 24/7 on-call.Over all 60 months of experience with problem resolution in a 24/7 production schedule of at least 250 jobs a month in all projects.Staging data for test plan development and implementation based on business requirements using shell scripting tool with Perl scripting preferred.Worked on Unix Shell Scripting, AWK Scripting, and Perl Scripting to schedule jobs and monitor daily.Wrote and ran SQL scripts for reports.Created SQL scripts to create, modify, and populate SQL Server databases.Supported production environment using UNIX shell scripting.Environment: Oracle 19C/12c, PL/SQL, C#, ASP.NET MVC, HTML, Perl, SQL Developer, PLSQL Developer, TFS, Visual Studio, Windows.Role: PL/SQL DeveloperClient: ConduentLocation: Morrisville, NC Mar 2021 - Oct 2023Roles and Responsibilities:Working as SQL Server Analyst / Developer / DBA using SQL Server 2008 for Atlas Data warehousing Project.Manage and update the Erwin models - Logical/Physical. Data Modeling for Consolidated Data Store (CDS).Actuarial Data Mart (ADM), Reference DB according to the user requirements.Source Controlling, environment-specific script deployment tracking using TFS.Export the current Data Models into PDF out of Erwin and publish them on SharePoint for various users.Developing, Administering, and Managing corresponding databases: Consolidated Data Store, Reference.Worked closely with cross-functional teams, including database administrators, application developers, and business analysts to deliver high-quality T-SQL solutions.Enhanced the performance of existing Perl scripts through code optimization and efficient algorithm implementation.Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart.Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain.Physical Structures.Generated dynamic reports and dashboards by writing Perl scripts that aggregated and formatted data from multiple sources.Working with Dynamic Management Views, System Views for indexing, and other Performance Problems.Analyze the Legacy Data and import the data into Reference DB that was verified and published by DMRB (Data Management Review Board).Monitoring existing SQL code and performance Tuning if necessary.Used SQLCODE returns the current error code from the error stack SQLERRM returns the error message for the error code.Managed Perl script versions using version control systems like Git, ensuring code integrity and facilitating team collaboration.Writing Tuned SQL queries for data retrieval involving Complex join Conditions.Created the External Tables to load data from flat files and PL/SQL scripts for monitoring.Liaison with the ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.Creating ETL mappings using Informatica Power Center.Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data.Implemented robust error handling and debugging mechanisms within Perl scripts to ensure reliability and maintainability.Implemented data quality checks and governance policies within ETL pipelines, maintaining high standards of data reliability and compliance.Monitored ETL processes using Azure Monitor and Log Analytics, proactively identifying and resolving performance issues to ensure optimal system performance.using Stored Procedures that accept parameters.Created Parameterized Queries, generated Tabular reports, and Sub reports. Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports.Publishing PDF Reports obtained from the Report Server onto SharePoint Portal.Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#, SQL Server Analysis Services (SSAS). Microsoft Visual Studio 2010, IS, VB.Net, Erwin.Role: PL/SQL DeveloperClient: Seven ElevenLocation: Irving, TX Nov 2018 Feb 2021Roles and Responsibilities:Generate Dashboard Reports for Internal Users using SQL Server 2005 Reporting Services and Dundas ReportingApplication Testing. Debugging SIT, UAT, Test Clusters, and Test Load Balancers.App Testing in Development and Production.UML uses case diagrams, Conceptual Flow Diagrams, and ER Diagrams by reverse engineering the databases using Visio 2003.Deploy various reports on SQL Server 2005 Reporting Server.Tuning the Databases, Auditing, and Dynamic Management Views.Database Capacity Planning, Maintenance Plans, Backup, Restore.Data Modeling, Conceptual/Logical/Physical Modeling.Create and maintain a database for Incident, Problem Tracking, and Metrics.Working with SQL and T-SQL.Database design and development including Tables, Primary and Foreign Keys, Indexes, and Stored Procedures.Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants, and synonyms.Maintained a series of UNIX Shell Scripts to manage batch order processing.Database performance monitoring and identifying bottlenecks hindering the performance of the database.Involved in performance tuning using TKPROF.Migrated and integrated PL/SQL code to T-SQL, ensuring functional parity and performance improvements in the SQL Server environment.Participated in database schema design, normalization, and refactoring to improve database performance and maintainability.Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL Packages, mentor others with the creation of complex SQL Statements, perform data modeling, and create/maintain and modify complex database Triggers and Data Migration scripts.Created, debugged, and modified Stored Procedures, Triggers, Tables, Views, and User-Defined Functions.Design Reports on Internal User needs.Access SharePoint Server using Web Services to deploy reports on Reporting Server.Working with Stored Procedures, functions, triggers, and Views.Involved in creating tables, stored procedures, and indexes.Creating and Maintaining users.Creating / Running jobs with packages.Design, Creating, and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)Configuring the Database Mail and mail Operators using SQL Server 2005.Creating jobs, Job NotificationsGeneral Day to Day Database Administration.Importing Data from various sources like DB2, Oracle, Excel, XMLEnsuring Data Consistency and analyzing the Data.Detailed Documentation of all the existing and new processes, Create and Update Data Dictionaries.Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions.Environment: SOL Server 2005, SharePoint 2007, NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services (SSRS), Integration Services (SSIS).Role: Software DeveloperClient: Sacrosanct infoLocation: Hyderabad, India Jun 2014 Mar 2018Roles and Responsibilities:Create and maintain a database for Server Inventory, Performance Inventory.Working with SQL, and T-SOL, VBA.Involved in creating tables, stored procedures, and indexes.Creating and Maintaining users.Creating / Running jobs with packages.Design, Develop, and Deploy Packages with WMi Queries.Importing Data from various sources like Excel, SQL Server, and Frontbase.Collecting Server Inventory data from users using InfoPath 2003/2007 into SQL Server 2005.Creating Linked Servers to other databases like Frontbase and importing data Using Linked Servers.Ensuring Data Consistency and analyzing the Data.Generate Dashboard Reports for Internal Users using SOL Server 2005 Reporting Services.Backing up the Database.Rack/Stack Proliant Servers, installing the base operating system.Deploy various reports on SQL Server 2005 Reporting Server.Design Reports as per User Requirements.Involved in migrating servers i.e., physical to virtual, virtual to virtual.Installing and Configuring SQL Server 2005 on Virtual Machines.Migrated hundreds of Physical Machines to Virtual Machines.Conduct System Testing and functionality after virtualizationMonitor the migrated System for the next 48 hrs.Closely work with the team.Environment: SQL Server 2005, Windows 2000, 2003 Server, MS Access, Excel, Frontbase, InfoPath, 2003/2007, ESX 2. X, 3. X, SSIS, Reporting Services. |
