Professional Summary :

• Over 8 years of experience in Information Technology. Extensive knowledge and work experience in System Analysis, design, development and support of database applications in Client/Server applications using Oracle 10g/9i, SQL, PL/SQL.
• Extensive experience in supporting large mission critical applications in large scale complex enterprise environments serving hundreds of application worldwide.
• Knowledge of relational databases with expertise on Oracle. Able to query complex databases for faultfinding and problem resolution purposes.
• Exposure to Incident Management, problem management, IT changes management procedures within a large organization.
• Provide a proactive approach to supporting the production environment including presenting ideas to automate manual tasks and reduce the team workload
• Proficient in writing PL/SQL Packages, Stored Procedures, Triggers. Developed various applications, using Oracle built-in packages.
• Expert in Export, Import and SQL Loader Utilities.
• Proficient in Application Performance Tuning and Query Optimization.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan
• Code Review, coordinating user training and user testing
• Project demonstration, Implementation, Deployment, Maintenance.
• Experience working with Production and Development environment.
• Excellent experience in implementation of the Complete System Development Life Cycle and
• Functional expertise in Product based and Investment Banking.
• Experience with activities like creating users, granting and revoking privileges on
• Database objects and taking backups, table space management, creating database links, schemas, profiles and roles, managing control.
• Performed Oracle Database Administration activities such as Maintenance, scheduled processes and reports, monitoring and backup of database.
• Strong Trouble-shooting, Problem solving, Analytical Design Skills.
• Have experience on backend systems running Oracle Databases and working with large database.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Have knowledge on SAS programming.
• Have Knowledge on TeraData.
• Able to interact effectively with other members of the Business Engineering, Quality
• Assurance and other teams involved with the System Development Life cycle.

Technical Skills :

Professional Experience:

Confidential

Role: Data Analyst

Responsibilities:

• Developed Test Plans, Test Scenarios, Test cases, Test Strategies, Test Scripts and Test reports for Data Migration Data ware house project known as Integrated Customer Data Warehouse ICDW to replace existing Enterprise Data Warehouse EDW environment.
• Perform data analysis and facilitate in delivery to all end users
• Responsible for loading, extracting and validation of client data
• Extensively write SQL queries between different environments to do a comparison between the two database systems. Analyze the data transition closely.
• Attending the Defect Review meetings with client and development team on regular basis.
• Used MS SQL server Management studio for Creating executing SQL queries for testing.
• Involved in all the phases of software development life cycle SDLC process Design, Development and Unit Testing, System Integration Testing and Functional Testing .
• Developing data analytical databases from complex financial source data.
• Worked closely with Development team and Production Support Team whenever required and maintained the Test Environment.
• Prepared Test Scenarios, Test data and Test cases based on Functional Specifications document.
• Involved in preparation of UAT and Production testing Checklist and do UAT/ Production Testing.
• Data entry, data auditing, creating data reports monitoring all data for accuracy.
• Advising on the suitability of methodologies and suggesting improvements.
• Capture of Business Field Names/Definitions and Business
• Capture data elements - definitions and characteristics for information requirements including commonality with finance Source systems that will provide reporting data
• Analyze the transition of data from old to new environment. Extensively used Teradata SQL Assistant and SAS to compare the data.
• Requirements gathering and analysis.
• Mapping data to the authoritative source field and table name as part of ICDW data migration analysis activity.

Environment: SAS, SQL, Teradata, ALM Tool, Excel, Windows 7

Confidential

Role: SAS/Shell Scripting/PLSQL Developer

Duration: Dec 2013 Apr 2014

Responsibilities:

• Involved in preparing Functional Specification and Technical documents.
• Developed back end interfaces using PL/SQL stored procedures, functions, packages, collections, object types and K-shell scripts
• Automated weekly tasks using Unix shell scripts
• Wrote SQL scripts to store failure reports in Tracking table
• Wrote few Macros to automate Biz to Biz process using SAS
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, partitions, triggers, db links and privileges
• Scheduled Unix jobs through TWS
• Responsible for performing code reviews.
• Testing of all the deliverables done with User support
• Client interaction through meetings presentations.

Environment: Oracle 11g, SAS, SQL, PL/SQL, UNIX AIX 5.3 , PL/SQL Developer Tool, Windows 7, UNIX korn Shell, Putty Tool

Confidential

Role: Oracle PL/SQL Developer/Support Analyst

Responsibilities:

• Involved in preparing Database Design, High level and low level documents.
• Strong Co-ordination between Onsite and Offshore team.
• Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, collections, object types and K-shell script.
• Involved extensively in Direct Marketing and Email marketing campaigns for all SmartCare based on the business requirements and generating the responses for all the campaigns
• Automated the daily tasks using Oracle backend procedures, Unix shell scripts.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, partitions, triggers, db links and privileges.
• Migrated data from Flat Files to Oracle database using SQL Loader and External tables. Wrote Oracle PL/SQL programs for backend processing.
• Wrote SQL scripts to generate BAU reports using Business objects.
• Experience on creating/tracking the change requests and issues using TFS.
• Wrote SQL scripts to generate data for campaigns and to verify the counts with functional team.
• Implemented Oracle Table functions and With Clause queries in PL/SQL scripts, which have written for ETL process.
• Developed packages for ETL Informatica purpose in data warehouse environment, to extract data from the production systems
• Responsible for SQL tuning and optimization using Analyze, Explain plan
• Created PL/SQL Procedures and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs
• Wrote Unix Shell Scripts to send ftp files to other systems.
• Scheduled Unix jobs through SSH Tectia.
• Responsible for performing code reviews.
• Testing of all the deliverables done with User support
• Client interaction through meetings presentations
• System Support Assisted Client for User Acceptance Test for new releases

Environment: Oracle 11/10g, SQL PLUS, SQL, PL/SQL, SQL Loader, UNIX AIX 5.3 , PL/SQL Developer Tool, CVS, Windows NT, UNIX korn Shell

Confidential

Role: Oracle PL/SQL Developer/Support Analyst

• File Import Manager: It is Flex based AIR component which will accept Quote in excel or csv format and convert into XML format. Further it is converted into 3A1 XML format. Quote status is imported.
• Offline Validation: Basic client side validations are performed. And Quote XML is checked with template XML format for field validation. Other validations like number, email etc validation are done in flex.
• Online Validation: Different HTTP/WEB services are used for validation different relations between disti, product etc. Below are list of HTTP services.

Responsibilities:

• Involved in preparing Database Design, High level and low level documents.
• Requirements gathering for the Interface and program development through meetings with functional team and business users.
• Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, collections, object types and K-shell scripts.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, partitions, triggers, db links and privileges.
• Migrated data from Flat Files to Oracle database using SQL Loader. Wrote Oracle PL/SQL programs for backend processing.
• Wrote PL/SQL backend procedures for ETL Informatica process to load data into Enrollment Datamart from various source systems like Mainframes, SQL Server and Oracle.
• Wrote scripts using UTL FILE built-in package to prepare and ftp reports to different systems, if there are any errors while loading data into Datamart from various sources.
• Used the Oracle built in package DBMS SCHEDULER to schedule the PL/SQL procedures.
• Created/Modified the PL/SQL scripts to send Email notifications to customers for various events like Enrollment notification, ID Card Notification, Registration reminders, etc.
• Responsible for SQL tuning and optimization using Analyze, Explain plan, TKPROF Utility.
• Implemented external tables for loading data into database.
• Strong Co-ordination between Onsite and Offshore.
• Created PL/SQL Procedures and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs and Client application
• Wrote Unix Shell Scripts to send ftp files to other systems.
• Responsible for performing code reviews.
• Testing of all the deliverables done with User support
• Client interaction through meetings presentations

Environment: Oracle 10g/9i, SQL PLUS, SQL, PL/SQL, SQL Loader, UNIX AIX 5.3 , PL/SQL Developer Tool, TOAD, SVN, Windows NT, Unix korn Shell

Confidential

Role: Oracle PL/SQL Developer/Support Analyst

Responsibilities:

• Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, Collections, object types and K-shell scripts.
• Utilized TOAD tool in developing all back end database interfaces.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, partitions, triggers, db links and privileges.
• Developed SQL loader scripts to load data in the tables.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Developed PL/SQL packages, procedures, functions and triggers.
• Written Procedures and database triggers for the validation of input data and to implement business rules.
• Wrote Custom PL/SQL procedures to read data from flat files to dump to Oracle database.
• Developed Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
• PL/SQL coding for Exception Handling.
• Involved in simulations to get the out of balance data.
• Involved in the analysis of Out Of Balance Data.
• Strong Co-ordination between Onsite and Offshore
• Developed Fix Scripts to minimize the out of balance percentage.
• Involved in Testing and prepared test cases for few vendors.
• Did Count Analysis to match up with Production with QA.
• Created Reports such as analysis reports for counts, Out of balance data and data mismatches.

Environment: Oracle 9i, SQL PLUS, SQL, PL/SQL, SQL Loader, UNIX AIX 5.3 , TOAD, Windows NT, CVS, Unix korn Shell