Eshwar Chandra

SUMMARY

• Over *+ years of programming experience as an Oracle PL/SQL developer and Forms/Reports Developer.

• Excellent knowledge in Analysis, Design and implementation of Business Applications using Oracle Relational Database Management System (Oracle RDBMS).

• Have good experience in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes and sequences, Flashbacks.

• Good knowledge of ERWIN for Data modeling to design the logical model, physical model, Entity relationship.

• Good experience in generating forms using PL/SQL for data validation, processing Oracle Forms 9i/10g and also generating reports in Oracle Reports 9i/10g.

• Written Perl routines to handle daily requests and processes from users

• Expertise in using Oracle 8i/9i and 10g databases and knowledge about PL/SQL programming to develop stored procedures and packages.

• Expertise in using advanced features of Oracle 9i for PL/SQL programming like Varrays, Dynamic SQL, Query Optimizer, Nested Loops, External Tables, Nested Tables, LOBS.

• Used Hints for better performance of the queries and any procedures.

• Very Good Knowledge about the Oracle tools like SQL, PL/SQL, SQL*PLUS, Oracle Enterprise Manager, SQL*Loader, and data pump utilities like Export/Import.

• Experience in application fine-tuning and database fine-tuning using Explain Plan and TKProf.

• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.

• Good knowledge of using Flashbacks to recover the data from recycle bin.

• Expertise in all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance

• Expert in creating special Grouped reports, Cross Tab / Matrix Reports, Sub reports in main reports, Drill Down reports, mailing reports using Crystal reports.

• Good knowledge of creating database links and materialized views.

• Good knowledge in design, coding and testing.

• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.

Education:

• Bachelor’s (B-Tech) in Computer Science from JNTU Hyderabad, Andhra Pradesh, India

• Master of Computer Science from New York Institute of Technology, NY.

CERTIFICATIONS

• Oracle Certified PLSQL Developer.

• Brain bench certified RDBMS concepts.

• Brain bench certified PLSQL Fundamentals.

TECHNICAL SKILLS:

Languages SQL, PL/SQL, Shell Programming (Bourne, Korn), C, C++, JAVA.

Databases Oracle 8.0, 8i, 9i, 10g, MS Access, SQL SERVER 2000.

Reporting Tools Crystal Reports 9.5, oracle reports 10g, 9i, forms 10g,9i.

Tools ERWIN 4.0, Oracle Enterprise Manager, TOAD 8.5, Oracle SQL, Developer, Database Configuration Assistant, Net Configuration Assistant, F-Secure 5.3, MS-OFFICE (2007).

DB Utilities SQL Loader, Export / Import, Data pump, TKPROF, Stats pack.

Operating Systems UNIX, LINUX, Sun Solaris 5.6/5.8/5.9, Windows NT, Windows 95/98/2000, Windows XP, Windows Server 2003.

Web Technologies HTML, Macromedia Dreamweaver MX, MS-FrontPage, JavaScript, Macromedia, Fireworks MX, XML.

PROFESSIONAL EXPERIENCE

Client: Barclays May’13 – Till Date

Role: Tech Lead/Oracle/ETL developer

Barclays is a major global financial services provider engaged in personal banking, credit cards, corporate and investment banking and wealth and investment management with an extensive international presence in Europe, the Americas, Africa and Asia. With over 300 years of history and expertise in banking, Barclays operates in over 50 countries and employs 140,000 people. Barclays moves, lends, invests and protects money for customers and clients worldwide.

Responsibilities:

• Worked as a Tech Lead for couple of projects.

• Involved in approving SDLC artifacts.(SIT plan, DESIGN, Requirements, SOL REVIEW)

• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.

• Used Sql*Loader (ETL) extensively for loading files (ASCII) into Database tables.

• Developed complex packages and procedures and functions using Record types.

• Worked on SQL Tuning using Explain Plan. Tuned SQL Queries and plsql objects.

• Used Analytic function over partition by order by clauses for calculations along with RANK.

• Worked with AVG, ROWNUM, TRIM, LPAD, RPAD and some other Aggregate functions for performance and data matching.

• Created PL/SQL packages to perform validations on the imported data from legacy system.

• Involved in mapping the data from one layer to another.(staging, source, target mappings) as per Line of business.

• Created Views and Synonyms for the database objects.

• Assisted the QA team in performing Load Testing and Performance Testing.

• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

• Created PL/SQL packages to perform validations on the imported data from legacy system.

• Involved in Data modelling to come up with physical and logical models to create table and establish the entity relationship using ERWIN.

• Analyzed integrity constraints during development of physical model using ERWIN.

• Developed complex packages and procedures and functions using Record types.

• Worked on Datastage tool and used Plsql Frameworks to implement ETL concepts (File loading to tables).

• Worked on priority levels tasks using Unicenter Service Desk software.

• Good knowledge of control-M jobs.

• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

Environment:

Oracle 10g/11i, SQL, PLSQL Packages, Procedures, Functions and Triggers, ERWIN, TOAD, Unix, Data stage(7,8.1,8.7), WinCVS, HP Quality Center, WinSCP

Client: IMS Health Oct’12 – Apr’13

Role: Plsql/Netezza developer

IMS Health is the world’s leading information, services and technology company dedicated to making healthcare perform better. With a global technology infrastructure and unique combination of real-world evidence, advanced analytics and proprietary software platforms, we connect knowledge across all aspects of healthcare to help clients improve patient outcomes and operate more efficiently.

Responsibilities:

• Worked on Framework called QBM (Query Builder Merge) internal to IMS.

• Created PL/SQL packages to perform validations on the imported data from legacy system.

• Attended Business meetings and walkthroughs to discuss the status of the project.

• Written shell scripts to generate a report as per Business Requirements.

• Written shell scripts to send an email after the job Failure or Success.

• Worked on the Config properties file to set up the database connection and changed accordingly to reflect the same in the code.

• Assisted the QA team in performing Load Testing and Performance Testing.

• Created PL/SQL packages to perform validations on the imported data from legacy system.

• Scheduled jobs using Mainframe Code.

• Good knowledge of Mainframe jobs.

• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

Environment:

SVN, Netezza, Mainframe, Oracle 10g/11i, SQL, TOAD, UNIX.

Client: Barclays Oct’10 – Oct’12

Role: Oracle/ETL developer

Barclays is a major global financial services provider engaged in personal banking, credit cards, corporate and investment banking and wealth and investment management with an extensive international presence in Europe, the Americas, Africa and Asia. With over 300 years of history and expertise in banking, Barclays operates in over 50 countries and employs 140,000 people. Barclays moves, lends, invests and protects money for customers and clients worldwide.

Responsibilities:

• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.

• Created PL/SQL packages to perform validations on the imported data from legacy system.

• Developed complex packages and procedures and functions using Record types.

• Worked on SQL Tuning using Explain Plan.

• Created Views and Synonyms for the database objects.

• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

• Assisted the QA team in performing Load Testing and Performance Testing.

• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.

• Created PL/SQL packages to perform validations on the imported data from legacy system.

• Involved in Data modelling to come up with physical and logical models to create table and establish the entity relationship using ERWIN.

• Analyzed integrity constraints during development of physical model using ERWIN.

• Developed complex packages and procedures and functions using Record types.

• Got familiar with Datastage tool and WinCVS.

• Worked on priority levels tasks using Unicenter Service Desk software.

• Good knowledge of control-M jobs.

• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

Environment:

Oracle 10g/11i, SQL, PLSQL Packages, Procedures, Functions and Triggers, ERWIN, TOAD, Unix, Data stage, WinCVS, HP Quality Center

Client: Zale’s Corporation: Jul’10 – Oct’10

Role: Oracle Developer/Reports developer

Zale Corporation, a leading specialty retailer of fine jewelry in North America, is propelled by a diversified portfolio of strong brands that includes Zale’s Jewelers, Zale’s Outlet, Gordon's Jewelers, Peoples Jeweler’s and Map pins jewelers of Canada, and Piercing Pagoda. Zale is driven by three core product categories that cater to each consumer segment with varying intensity.

Responsibilities:

• Involved in requirement gathering and development of the application.

• Involved in migrating all the database objects (Tables, Views, Triggers, Procedures, Functions, Packages) from 10g to 9i.

• Involved in migrating Oracle Forms from 10g to 9i

• Involved in migrating all the UNIX shell scripts from one server to another.

• Generate SQL scripts for altering, inserting, creating the tables.

• Created Views and Synonyms for the database objects.

• Assisted in scheduling the everyday activity of data purging using CRON jobs.

• Migrated forms from one server to another using the version control tool VSS (Microsoft Visual Source Safe).

• Used the WITH clause to rewrite the Sql query for faster Performance.

• Performed debugging of the PL/SQL codes using the DBMS_OUTPUT.

• Performed debugging in Oracle Forms using MESSAGE.

• Extensively used ‘vi’ editor in UNIX.

• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

• Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation of the code.

• Assisted the QA team in performing Load Testing and Performance Testing.

Environment: Oracle 9i/10g, SQL, PLSQL Packages, Procedures, Functions and Triggers, TOAD, UNIX.

Client: RBS World Pay Sep’08 – Jul’10 Role: Oracle Programmer Analyst

RBS World Pay is the single card and non-card electronic payment processing solution that any business can rely on. From face-to-face transactions, to online and phone transactions where the cardholder is not present, we provide a service that is amongst the most effective, most secure ways to process payments.

Responsibilities:

• Involved in requirement gathering and development of the application.

• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.

• Created PL/SQL packages to perform validations on the imported data from legacy system.

• Developed complex packages and procedures and functions using Record types.

• Used UTL_FILE to import the data from database tables to flat files.

• Used External Tables for Data Conversions to populate the data from spreadsheets to a base table.

• Created a DBMS_SCHEDULER job to write the data from a table to a flat file on a daily basis.

• Worked on SQL Tuning using Explain Plan.

• Worked with Analytical functions like OVER, LAG, LEAD, PARTITION BY and familiar with the MODEL, RANK etc.

• Extensively used Strong Ref cursors for manipulating the large amount of data and reducing the coding and error margin and wrote some scripts in UNIX.

• Good familiarity with the concepts of partitioning the database and Materialized Views.

• Good knowledge of data model design (Logical data Model and Physical data Model), Star Schema and Snowflake schema.

• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

• Created Views and Synonyms for the database objects.

• Used the WITH clause to rewrite the Sql query for faster Performance.

• Created indexes on some of the columns on the tables to increase the application's performance.

• Developed Landscape and portrait Reports using Oracle Reports 10g.

• Created Tabular reports, Group Above reports for the Clients as per the requirement.

• Generated Spread Sheet, XML, PDF format reports.

• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

• Assisted the QA team in performing Load Testing and Performance Testing.

Environment:

Oracle 9i/10g, SQL, PLSQL Packages, Procedures, Functions and Triggers, Oracle Forms and Reports (6i,9i,10g) SQL*Loader, HTML, CSS, Java scripts, TOAD

Net vision Web Technologies Ltd., Feb’05 - Nov‘05

Hyderabad, India.

Role: Oracle Developer.

This module consisted of different modules including patients records, purchases, invoices, inventory in the hospital. Accounts module is also integrated with this package. The patient’s surgery videos and images are stored in database. This package generates many important reports like profit and expenses.

Responsibilities:

• Created Korn Shell scripts which act a wrapper for various tasks like for executing the SQL*Loader command lines, for refreshing the materialized views and for updating the Fact and the Dimension tables.

• Wrote database PL/SQL Triggers and Procedures, Functions, Packages to provide backend security and data consistency.

• Involved in coding,testing and documenting various Packages,Procedures and Functions for various Libraries Stored Procedures

• Worked on user exit, Dynamic SQL and PL/SQL block in PL/SQL.

• Responsible to maintain the dependencies of all Procedures, Function, Packages, Views and Triggers in a Script file.

• Developed Java Server Pages, Servlets that interact with back end Oracle Database.

• Implemented complex business rules with the use of integrity constraints and Database Triggers also Handled Exceptions.

• Worked on Power Builder tool for drawing user interfaces, reports and accessing the web content.

Environments:

Oracle 7.3, SQL, PL/SQL, SQL*Loader, Windows98, UNIX Shell Scripting, Java, Java Server Pages, Servlets, Apache Web server, Power Builder

Contact this candidate