Sql Data

Rajesh Polukonda

Phone: 510-***-****

SUMMARY:

Over 7 years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle including requirements, Analysis, Design, Development, Testing and Implementation.

Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica Power Center.

Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Extensively worked in Client-Server application development using Oracle 8.0/8i, 9i, 10/g, PL/SQL and SQL *PLUS, Oracle Forms/ Reports 10g/6i.

Extensive experience in application data modeling and building data warehouse architecture (Star & Snowflake schemas) and ER Diagrams using Microsoft Visio, Erwin and IBM Rational Rose data modeler tool.

Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables.

Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems

Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, Bulk collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.

Supported DBA to Take Back up, Monitoring Performance and Tuning Activities.

Extensively Worked on Oracle Database creation, Table Space management, (Export & Import) Backup, Performance tuning, Tuning Init.ora file.

Extensively used QUEST Tools (TOAD, Navigator) and SQL*PLUS.

Experienced in Unit testing and Integration Testing with excellent debugging skills.

Experience using Red Hat Linux, Ubuntu, and Sun Solaris.

Experienced in developing the UNIX Shell Scripts to execute the scripts and manipulate files and directory.

Also involved in exporting and importing of data using utilities like Export, Import, Data Pump Export and Data Pump Import.

Experience in reporting tools like SSRS and SAP BO.

Experience working with the CRD (Charles River Development) application.

Experience in working with the Version control tools like Perforce and GIT.

Worked with cross-functional teams such as QA, DBA teams to deploy code from development to QA and from QA to Production server.

Good team player with strong technical, analytical and people skill for effective software development.

EDUCATION:

Bachelors in Information Technology, JNTU Hyderabad, India. Aug 2002- Mar 2006.

Masters in Information Technology, University of Southern Queensland, Sydney, Australia. Mar 2008- Nov 2009.

TECHNICAL SKILLS:

Languages

C, C++, SQL, PL/SQL, UNIX shell scripting, HTML, UML, XML, Basic Javascript.

Operating Systems

Windows Server X,XP,7,8.X,UNIX,LINUX

Databases Tools

MS Access, SQL Server 2000/2005/2008/2012,Oracle 9i,10g,11g, MSBI(SSIS,SSAS, SSRS), SQL*Plus, Developer(REPORTS 6i/10g,FORMS 6i/10g),Power Builder 12.

ETL tools

SSIS, Informatica Power Center 9.0.1&9.6,8.X

Report Tools

SSRS, SAP BOE, Crystal Reports.

Web Server

Tomcat, IIS

PROFESSIONAL WORK EXPERIENCE:

Employer: Infosys Inc

Client: Capital Group, Los Angeles, CA JAN 2015 – TILL DATE

Role: Oracle PL/SQL & Informatica Lead

Description:

Capital Group is one of the most experienced and successful investment management firms in the world. Capital Group serves the needs of individual investors, financial intermediaries and institutional clients by managing their investments.

Responsibilities:

Gathering system requirements through client interactions.

Used ETL tool Informatica power center to extract and load data from Sybase and flat files to Oracle database.

Created the mapping and used different transformations in Informatica while pulling the data from Flat files and other DBs to Oracle DB tables.

Developed procedures, functions and packages to implements the system’s business logic using PL/SQL.

Involved in development, maintenance of Triggers, Joins, Cursors and Views.

Implemented table and index partitioning of various tables with huge data.

Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.

Extensive experience in using cursors and ref-cursors for processing the data.

Wrote SQL queries to developed test data for use during test execution.

Performed UNIT testing of Application, created test cases, test conditions and ran manual tests.

Developed UNIX Shell Scripts for Autonomous Jobs.

Developed UNIX Shell Scripts for to run SQL Queries for Auto Reports.

Testing and debugging of the applications.

Making changes in the existing BO report as per the User requirements.

Wrote the Jil Commands to schedule the jobs in AutoSys.

Working with the CRD application to load the data into CRD tables and run the compliance.

Environment: Oracle 11G, UNIX 5.10, Linux 6.8, Informatica Power Center 9.0.1 & 9.6, SQL * Plus, Sybase, SQL, AutoSys, SAP BO 4.1 & 4.2, TOAD, CRD 9.1,9.6&9.8, Perforce and GIT.

Employer: Eskribe Inc

Client: Honda R & D Americas Inc., Raymond, Ohio AUG 2013 – DEC 2014

Role: Oracle PL/SQL & Informatica developer

Description:

Honda R&D Americas, Inc. (HRA) is an automobile, motorcycle, all-terrain vehicle, and Jet airplane developer located in North America. It develops vehicles for Honda and Acura.

Responsibilities:

Developed mappings/sessions, mapplets using Informatica Power Center 9.X for data loading.

Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

Implemented slowly changing dimensions methodology for accessing the full history of accounts.

Written simple and complex SQL-overrides in source qualifier transformations according to the Business Requirements.

Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.

Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, indexes.

Extensive experience in using cursors and ref-cursors for processing the data.

Performed QA testing of Application, created test cases, test conditions and ran manual tests.

Developed UNIX Shell Scripts for Autonomous Jobs.

Developed UNIX Shell Scripts for to run SQL Queries for Auto Reports.

Writing event driven triggers, functions, and packages as needed.

Create and schedule the jobs in AutoSys.

Writing SQL queries, Cursors using embedded SQL, PL/SQL.

Testing and debugging of the applications.

Implementation and end user training.

Environment: Oracle 9i/11G, Oracle SQL Developer, Oracle FORMS, Windows 7, SQL * Plus, Informatica 9.1, AutoSys, GIT.

Employer: Eskribe Inc

Client: EPC ENERGY, HOUSTON, TX NOV 2012 - JUL 2013 ORACLE PL/SQL DEVELOPER:

EPC Energy provide outstanding, dependable engineering, design, construction and engineering management services making technology work to help the clients build a better world. The goals for EPC Energy Services are to perform quality services, for a multitude of clients, at market competitive rates. As a developer, was involved in creating and maintaining the database objects and involved in tuning the PL/SQL code and queries.

Responsibilities:

Gathered the requirements from the users and analyzed their business needs and created SRS documents.

Involved in designing and development of data warehouse for the corporate data repository.

Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures).

Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.

Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.

Analyzed data designed and developed Oracle FORMS 10g/11g queries, layout, report triggers, parameter form, data models etc.

Run batch jobs for loading database tables from flat files using Informatica.

Created mapping documents to outline data flow from sources to targets.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Involved in moving Mappings, Sessions and Workflows between development and production environments.

Used Version Control tools like Perforce for Source Control.

Developed Materialized views and Ref Cursors for reporting purpose.

Defined indexes on various tables to improve the performance of the queries for reporting purpose.

Worked closely with users and developers team to resolve issues in the developed reports.

Actively involved in the production support and also transferred knowledge to the other team members.

Environment: Oracle 9i/11g, SQL, PL/SQL, SQL*Plus, SQL* Loader, Oracle FORMS, TOAD, Erwin 7.2, Putty, UNIX, Shell scripts.

Employer: Eskribe Inc

Client: CONAGRA FOODS, COLUMBUS, OH SEP 2011 – NOV 2012 Oracle PL/SQL Developer

The Objective of the Project was to design and build a Data Warehouse for Sales of Products for Company Conagra Foods, Which fast & efficient reports were generated. This report gives an insight into the various business trends. These reports and statistical analysis helps the decision makers to take better forecasting decisions as well as provide them with a good view of the business data. The various business patterns can be analyzed using the different business dimensions like Product Wise, Company Wise, Branch Wise, Counter Wise, Promotion Wise, Customer Wise, Supplier Wise, and Area Wise.

Responsibilities:

Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.

Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.

Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.

Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, indexes.

Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.

Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data

Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors

Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.

Generated Oracle FORMS and REPORTS using Designer 10g.

Improved Performance of Discoverer Reports using Materialized views.

Developed UNIX Shell Scripts for Autonomous Jobs.

Developed UNIX Shell Scripts for to run SQL Queries for Auto Reports.

Designed, Developed and Tested application in UAT environment and Deployed in Production.

Provided Productions supports and ongoing user supports for the application.

Designed Development Documentation and Support Documentations.

Environment: Oracle 10g, Oracle FORMS/REPORTS 10g, Designer10g, TOAD, Oracle Application Server 9i, UNIX Scripting.

Employer: LEVO

Client: LEGRAND AUSTRALIA JUN 2009 – JAN 2011 PL/SQL Developer

Legrand network with a presence in more than 70 countries and a workforce of more than 35,000 people. Legrand specialists in designing and manufacturing products for electrical and digital building infrastructures. This project here is to implement a complete web based inventory management system that performs the Functions of Purchases, Sales, Storage and payments. This system will guide you through the creation of vendors list, purchase orders, products list, receiving lists, sales orders, Invoices and tracking payments. This is in addition to transfer orders between locations, customers and vendor’s balances and various types of reports for monitoring business. This system allows user and customers to see the data they need in real time anywhere.

Responsibilities:

Requirements gathering, design of the logical flow of the system, preparation of Project Plan and System Requirements Specification (SRS).

Prepared Program Specifications, Screen Layouts, Project Standards.

Responsible for designing the Oracle Database using database-modeling tool Erwin.

Designed and developed different Database Objects (Stored Packages, Procedures, Functions and Triggers) using PL/SQL.

Used PL/SQL to write the Stored Procedures, Views extensively to get the Monthly, Annual Reports and Audits.

Used Dynamic SQL statement for run time SQL query processing.

Wrote various Queries, PL/SQL Stored Procedures and Triggers to augment the application logic.

Modified existing Interfaces using PL/SQL procedure, triggers and functions in the Human Resources module.

Involved in developing test plans and strategies, as well as the design, development, and execution of Test Cases.

Created the conceptual model for the data warehouse using Erwin data modeling tool.

Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered.

Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer 1.5.3, Erwin.

Contact this candidate