SUMMARY

Around * years of programming experience as an Oracle Technical Lead/ETL/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.

Dynamic SQL, Query Optimizer, Nested Loops, External Tables, Nested Tables, LOBS.

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

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

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.

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 Professional PLSQL Developer(OCP).

Brain bench certified RDBMS concepts.

Brain bench certified PLSQL Fundamentals.

PROFESSIONAL EXPERIENCE

Client: OMH May’15 – Till Date

Albany, NY

Role: Senior Oracle developer

New York State has a large, multi-faceted mental health system that serves more than 700,000 individuals each year. The Office of Mental Health (OMH) operates psychiatric centers across the State, and also regulates, certifies and oversees more than 4,500 programs, which are operated by local governments and nonprofit agencies. These programs include various inpatient and outpatient programs, emergency, community support, residential and family care programs.

Responsibilities:

Working on a Project called NICS (National Instant Criminal background check system.)

Responsible for writing high level document about NICS process.

Did analysis on the data flow of NICS to understand the application.

Involved in assisting other developers to optimize the sql queries using EXPLAIN_PLAN.

Written a framework to give delta among three systems (NICS, HERDS, and MHARS).

Created a high-level architecture documents for NICS process.

Involved in Complex SQL query optimizations.

Created PL/SQL packages,procedures,functions,cursors to meet the Business requirements.

Developed Oracle Framework for a project called ICOA, to automate the data flow from GUI to database with some transformations.

Suggested some changes to the existing packages to include some more logging and proper exception blocks.

Used Rollup,CUBE functions to achieve the results as per the business requirements to generate reports.

Used Crystal reports10 to create reports for Business user’s team.

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

Involved in mapping the data from one table to another.

Good knowledge of ODI tool.

Used GECS and ESB for scheduling the jobs to run at a certain timeframe.

Created Views and Synonyms for the database objects.

Worked on Unix platform to sftp the created files and used grep,vi and awk commands to find the file content and properties.

Used Microsoft TFS and Visual Studio for Check out/check in the scripts.

Environment:

Oracle 10g/11g, SQL, PLSQL, TOAD, Unix,ESB,GECS,CVS,Unix,Data stage(7,8.1,8.7,9.1), HP Quality Center,TFS,Visual Studio,Crystal reports 10.

Client: Barclays May’13 – Feb’15

Wilmington, DE

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 aritifacts.(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.

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).

Used Crystal reports10 to create reports for Internal purpose for reviewing.

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, TOAD, Unix, Data stage (7,8.1,8.7,9.1), WinCVS, HP Quality Center, WinSCP,SVN,Crystal reports 10.

Client: IMS Health Oct’12 – Apr’13

Collegeville, PA

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.

Used NZSQL command to create database objects like Tables and to run queries.

Used NZLOAD command to load the data into the tables using control file.

Used some of the Built-In functions (like Upper,case,decode,NVL) in netezza to meet the requirements.

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.

Environment: SVN,Netezza, Mainframe,Oracle 10g/11i, SQL, TOAD, Unix,TFS,Visual Studio.

Client: Barclays Oct’10 – Oct’12

Wilmington, DE

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.

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 mapping the data from one layer to another.(staging, source, target mappings) as per Line of business at Enterprise level(EDW).

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,, TOAD, Unix, Data stage, WinCVS, HP Quality Center

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

Dallas, TX

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, and 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.

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, TOAD, UNIX.

Client: RBS World Pay Sep’08 – Jul’10 Atlanta, GA

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.

Familiar with RazorSQL tool(for working with Pervasive databases, a Pervasive database browser, an SQL editor, Pervasive import and export tools, a query builder, and an edit table tool).

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.

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.

Used Microsoft TFS and Visual Studio for Check out/check in/debugging and developing the scripts.

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.

Environment:

Oracle 9i/10g, SQL, PLSQL, Oracle Forms and Reports (6i, 9i, 10g) SQL*Loader, TOAD,TFS,Visual Studio.

Contact this candidate