SUMMARY:

• Certified with 9 years of working experience in Development, Programming and support of Windows and UNIX, having worked in data extraction, transformation and loading to data warehouse, data analysis, updating, testing and data validation, Oracle 9i, 11g SQL/PLSQL in Production, Development environments in the domains of Banking, Insurance and Telecom.
• Expertise in storing and managing data in SAS datasets. Manipulating data using merge, update, create, copy, delete etc., using data statement and other conditional statement.
• Experience in SAS procedures such as PROC SORT, PROC SQL, PROC PRINT, PROC IMPORT, PROC EXPORT and debugging errors in UNIX environment.
• Experience in generating reports employing various SAS procedures such as PROC PRINT, PROC REPORT, PROC SUMMARY, PROC FREQ, PROC MEANS, PROC FORMAT, PROC TRANSPOSE
• Developed SAS macros to modularize and reuse the code.
• Extensively experience in using SAS ODS facility to create customized reports in HTML, PDF, and RTF file.
• Experience in data validation on raw data sets and created data set for analysis and testing purpose.
• Hands on experience in UNIX commands and creation of KSH scripts for batch process.
• Experience in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation.
• Expertise in PL/SQL, in developing and implementing Stored Procedures, Functions, Packages, Triggers and Types.
• Experience in database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Experience in Load Data into Oracle Tables using SQL Loader.
• Experience in Tuned SQL and PL/SQL queries for better application and system performance.
• Extensively using bulk collect for improving the performance.
• Expert in using Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Expert in handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Experience in application jobs scheduled with Autosys scheduler and Control M.
• Enforced data integrity using integrity constraint and database triggers.
• Proficient in advance features of PL/SQL programming like Records, Collections and Dynamic SQL.
• Have worked in fast paced AGILE projects and updated SCRUM dashboard without any spillover.
• Conducted internal training sessions on PL/SQL and UNIX as a part of sharing knowledge programs.
• Great exposure to Production Support and Maintenance of software application.

TECHNICAL EXPERT:

Operating systems: UNIX, MS Windows

Languages: SAS/Base, SAS/Macros, SAS/Access, Oracle PL/SQL

Database: Oracle 11g, SQL Server

Tools: SAS 9.4, TOAD 7.0, PL/SQL developer, SQL developer, SQL Loader, Clarify CRM 6.0, PuTTy, Autosys Scheduler, Control M

Version control: Tortoise SVN

SUMMARY OF WORKING EXPERIENCE:

Oracle PL/SQL Developer & SAS Programmer & UNIX

Confidential, Wilmington, DE

Responsibilities:

• Developing an existing SAS Programming activity for credit card risk assessment data and involved in software development life cycle of the project.
• Performing Oracle PL/SQL code changes for online account summary and credit card portal.
• Perform extraction, transformation and loading from database like Oracle, db2 using LIBNAME and SQL PASSTHROUGH facility.
• Working on pre - existing macros for data by applying business rules provided by the business team.
• Creating new datasets from raw data files using proc import and in file statement. Modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Validating, document and test component programs in an efficient way for inclusion in integrated reports.
• Developing, analyzing and testing SAS programs in UNIX operating system.
• Generating customized reports using SAS ODS with PROC REPORT, PROC TABULATE.
• Performing creation of objects such as tables, indexes, triggers, views, DB links, packages, cursors on business requirements.
• Performing database defragmentation on regular basis to improve the database
• Monitoring jobs in control M environment.
• Performing ITSM for ADHOC code change as per business requirement.
• Working on ADHOC queries for various application reports generated on a daily/weekly or monthly basis

PL/SQL Developer & SAS Programmer - OSP Associate

Confidential

Responsibilities:

• Requirement analysis and design of models based on the discussion with application owners and business users.
• Developed SAS codes to generate user reports (standard data files) as per business requirements and conversion of excel reports to SAS datasets. Testing and debugging the same.
• Used LIBNAME and SQL PASSTHRU facility to read policies data from other sources.
• Produced quality customized reports using PROC REPORT, PROC TABULATE and SAS/ODS.
• Provided descriptive analysis using PROC MEANS, PROC FREQ.
• Created database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Created KSH scripts to automate the housekeeping processes, reports with scheduled jobs and manual file transfer from one server to other.
• Prepared Maintenance requirement document and technical specification document as per client requirement.
• Designed Job Schedule information for batch jobs with Autosys scheduler.
• Co-ordinated with testing team to analyze the defects and resolve the defects raised.
• Documentation of projects such as Functional Requirement Spec (FRS), ER-Diagram.
• Worked with application owners to automate/generate ADHOC reports for their study on business improvements and batch process with UNIX shell scripting.

Confidential

Responsibilities:

• Developed Ezpay application using Oracle 11g, PL\SQL Developer, and TOAD.
• Worked on Account summary batch services. Created stored procedure, Packages, Tables, indexes after normalization, Arrays, Records, and Dynamic SQL etc.
• Responsible for the ADHOC changes in the database level.
• Created Unix KSH scripts for batch process.
• Requirements gathering from business and prepare use case diagrams, business requirement documents such as BRD.
• Worked on preparation of project plan, functional specification document, PL/SQL code review, and test case creation.
• Adhered to timelines within the given schedule and delivered without slippage.

Application Developer - PL/SQL & UNIX

Confidential

Responsibilities:

• Worked on Oracle SQL & PL\SQL Developer and TOAD.
• Created stored procedures, Functions, Packages, Views, Cursors, Records and other objects in new database as a part of SHOCk automating process.
• Testing and Debugging.
• Created Shell scripts for the process batch run and reports.
• Documentation of all the processes as per client standards.
• Point of contact and technical coordinator between onshore and offshore
• Interaction with the design and the architect teams to plan for new deployments
• Communications with the client daily for regular updates.
• Worked on issue resolution and major enhancements to eliminate failures in processing data within SLA.
• Worked on automation scripts in PL/SQL and UNIX Shell scripting for monitoring and report automation.
• Loaded data to DB tables using SQL Loader and worked on table defragmentation and recreating indexes as part of archival activity.
• Analyze and locate the root cause of failure in production and document the same.
• Worked on Incident, Change and Problem Management processes. Conducted periodical meetings with upstream and downstream application teams and discussed on new enhancement.