Resume

Sign in

Data Sql

Location:
Houston, Texas, United States
Salary:
90000
Posted:
February 03, 2018

Contact this candidate

LAXMA REDDY GILLALA

Houston, TX

713-***-****

313-***-****

ac4bw3@r.postjobfree.com

Summary:

Over 15 years of professional experience in Analysis, Design, Modeling, Development, Support and Implementation of applications in the client/server environment using Oracle 12c/ 11i/11g/10g/9i/8i/8.0/7.x, Developer2000, Designer2000, SQL, PL/SQL, Forms 11g/10g/6i/6.0/4.5,3.0 Reports 10g/6i/6.0/2.5, SQR Reports, Pro*C.

Extensive experience in PL/SQL Stored Procedures, Database Triggers, Toolbars, Performance Tuning and Batch Processing.

Extensive knowledge of the Oracle architecture, Oracle Memory structures, Logical and Physical Structures, Data Dictionaries and with PL/SQL.

Experienced numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, SQL Tuning and Backup and Recovery Planning, Testing and Implementation.

Extensive experience in using Oracle Reports 6I and Forms 6I.

Proficient in installation, setup, configuration, maintenance and tuning of Oracle 8i/9i//11i/11g/8.0/7.x/under Unix (Sun Solaris 2.6, 7, 8) and Windows NT environment.

Extensively worked in Oracle based application software design, development, and implementation and application maintenance. In-depth knowledge of SQL and PL/SQL, Pro*C.

Proficient in developing PL/SQL packages, SSIS, stored procedures and triggers.

Good knowledge and understanding of Data Warehousing.

Worked on all phases of development lifecycle, from gathering requirements to testing, implementation, and support.

Design and develop Oracle packages, store procedures, configuration files, tables, views, and functions, implement best practices to maintain optimal performance.

Created system for capturing, reporting, and correcting error data.

Education:

Jackson State University, Jackson, MS.

MS - Andhra University, Waltair, India.

Osmania University, Hyderabad, India, BS.

Job Related Summary:

10+ years of experience as a Database Developer.

10+ years of experience in Oracle and Microsoft SQL databases.

Proficient with Frontend and Backend Development.

Familiar with Perl.

Extensive experience in PL/SQL Stored Procedures, Database Triggers, Toolbars, Performance Tuning and Batch Processing.

Excellent communication and interpersonal skills.

Professional Experience:

Client: Electronic Transaction Consultant Corporation, Houston, TX 12/2014 – onwards

Role: Senior data Analyst & Oracle Developer

Responsibilities:

Work onsite for ETCC at the client’s Harris County Toll Road Authority (HCTRA) offices in Houston TX as a Senior Oracle Database Analyst to streamline all of their toll road collections, violations, reporting, billing and accounting programs.

Worked with various performance tuning techniques using tools provided by Oracle like Explain Plan, SQL*Trace, TKPROF, Auto trace, Hints, DBMS_Profiler, etc.

Open trouble tickets and view status, review details of past service issues and sign up to receive trouble ticket updates via email.

Check account balance, view, download, and analyze bills and call detail reports. Pay bills online.

Update mailing address, or “go green” and sign up for paperless statements.

Review accounts and manage user access: add users, reset passwords, change user IDs, and more.

Architectural Review of the database design for new implementations and Code review.

Troubleshooting performance and application related issues and fixing the same.

Work on complete life cycle of database, which includes Requirement analysis, designing of database, generating

schema based on data model, Populating lookup data, Creating Stored Procedures as per front end developer’s

requirement and commercial transitions, writing Triggers, creating user defined functions and created Views to

simplify the complexity of the data structure, Reporting Archiving, Disaster Recovery using SQL server 2005.

Support very complex data loads, batch processes and end of day reporting for Billers and Fix any issue related to that.

Responsible for creating Ad-hoc and Canned reports for operations, management

Demonstrate proficiency in all aspects of database programming and analysis, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Triggers, Table Indexing.

Experience in Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects, etc.

Develop, analyze, troubleshoot and tune PL/SQL code. Solid facilitation skills to gather the necessary (functional and technical) information to document and/or develop a strategic/tactical plan.

Document (functional and technical) source to target mappings, process flows, data flows, technical specification and unit test document.

Design, develop and deploy business rules and requirement into PL/SQL code for data analysis, transformation.

Performance tune PL/SQL stored procedures and package. Expert in Query optimization, Debugging, and Tuning for improving performance.

Perform extensive business process analysis including data analysis. Technical documentation of table structures, views, diagrams and PL/SQL code.

SQL database and PL/SQL support when necessary, be available for on-call duty as needed.

Perform other duties and responsibilities as assigned.

Client: Halliburton, Houston, TX 05/2014 - 09/2014

Role: Information Delivery, Data Management and Production Support

Responsibilities:

Provided full lifecycle support to clients from initial client interaction and requirements analysis through design, coding, testing, debugging, implementation and Provide ongoing application support and troubleshooting.

Created template expense Auditing reports, enabled descriptive flex fields in the Excel spread sheets, customized documentation and messages by modifying the standard help files for the self-service expense module. Customized the Workflow process of expense reports by modifying existing procedures and developing new procedures in the Web Expense PL/SQL packages.

Collected user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, doing code reviews, facilitate source code control.

Developed PL/SQL procedures and functions to support the reports by retrieving the data from the data warehousing application. Developed Actuate Reports and SQL Reports to fulfill the reporting needs of the users.

Used XML, TXT to display the reports. Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.

Enforced database integrity using primary keys and foreign keys.

Created PL/SQL functions to facilitate business functions and calculations.

Used Perl and UNIX/LINUX environment.

Environment: Oracle 10g, 11g, Reports, Oracle PL/SQL, SQL, TOAD, Unix, HTML, Windows XP, SQL, SQL Loader, Batch Process

Client: XO Communications, Plano, TX 09/2013 - 03/2014

Role: Senior Data Analyst and Developer and Production Support

Responsibilities:

Opened trouble tickets and view status, reviewed details of past service issues and signed up to receive trouble ticket updates via email.

Checked account balance, view, download, and analyzed bills and call detail reports. Pay bills online, update mailing address, or “go green” and sign up for paperless statements.

Reviewed accounts and manage user access: add users, reset passwords, change user IDs, and more.

Emailed inquiries to XO Customer Care, browse or search the XO Knowledge Base (repair and troubleshooting information and FAQs).

Developed advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Created management analysis reporting using parallel queries.

Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.

Worked in production support environment as well as QA/TEST environments for projects, work orders maintenance requests, bug fixes, enhancements, data changes, etc.

Used toad to extract and test the data in the database. Involved in full development cycle of planning, analysis, design, development, testing and implementation.

Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.

Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for optimization. This system elimination of manual tracking of inventory and sales data.

Prepared stored procedures, packages, functions and database triggers to implement required functionality and supports Seibel.

Environment: Oracle 10g, 11g, Reports, Oracle PL/SQL, SQL, TOAD, Unix, HTML, Windows XP, SQL, SQL Loader, Batch Process

Client: Amdocs/AT&T, Atlanta, GA 05/2013 - 08/2013

Role: Senior Data Analyst and Developer

The primary purpose of eTally is to provide intraday sales data to enable managers to track the daily progress of sales towards attainment of sales targets for Southeast Region Consumer. My Intraday will automate the gathering of intraday issued order sales for U-verse, Wireless, and DTV data, provide an interface for gathering manual order tallies for Wire line and DSL issued orders, and migrate in-scope tally functionality.

Responsibilities:

Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements

Worked with various performance tuning techniques using tools provided by Oracle like Explain Plan, SQL*Trace, TKPROF, Auto trace, Hints, DBMS_Profiler, etc.

Designed the packages required in SSIS for loading the data in the project.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling. Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.

Used Dynamic SQL (DBMS_SQL, DBMS_DDL) in function and procedure.

Generated SQL Scripts and create views for reports.

Environment: Oracle 11i SQL/PLSQL, SSIS, Tools-Oracle developer, Toad, SQL Navigator, Windows NT

Client: Wal-Mart, Bentonville, AR 01/2013 - 05/2013

Role: Sr. Programmer Analyst

Responsibilities:

Provided production support and troubleshooting. Efficient Oracle packages for data transfers between different layers. System for capturing, reporting, and correcting error data. Performance Tuning of Queries and Packages.

Worked with various performance tuning techniques using tools provided by Oracle like Explain Plan, SQL*Trace, TKPROF, Auto trace, Hints, DBMS_Profiler, etc.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Environment: Solaris 10, Oracle 11G SQL/PLSQL, SSIS, Tools-Oracle Developer Suite, Toad, SQL Navigator, Windows NT., Reports

Client: Boeing, St. Louis, MO 07/2012 - 12/2012

Role: Technical Lead, Developer

Responsibilities:

Provided customer support in code building, deployment. Requirement gathering for the requested change from customer.

Performed analysis of the requirements. Designed and developed Oracle forms/reports, Oracle packages, store procedures, configuration files, tables, views, and functions, implement best practices to maintain optimal performance.

Provided configurations changes to Oracle application server 10g.

Built efficient Oracle packages for data transfers between different layers.

Created system for capturing, reporting, and correcting error data. Performance Tuning of Queries and Packages.

Worked with tuning of SSIS packages for better performance.

Worked with various performance tuning techniques using tools provided by Oracle like Explain Plan, SQL*Trace, TKPROF, Auto trace, HINTS, DBMS_Profiler, etc.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Environment: Solaris 10, Oracle 10G SQL/PLSQL, SSIS, Tools-Oracle Developer Suite, MS-VSS, Toad, SQL Navigator, Windows NT., Oracle Reports/Forms

Client: State of Texas (HHSC), Austin, TX 01/2012 - 06/2012

Role: Consultant

Responsibilities:

Worked on TIERS project which is a real-time system which helps DHS eligibility staff in delivering services and benefits for the needy people. The application is based on the SOA architecture for connecting to different systems.

Created partitions for large tables.

Designed and developed complex PLSQL packages and SQL loader scripts that can load process.

Developed scripts using SQL loader to load data into tables.

Environment: Oracle 10g,11g, Oracle PL/SQL,SQL, Reports 10g, SQL Navigator, Unix, HTML, Windows XP, SQL, SQL Loader, Batch Process

Client: US Oncology, Woodland, TX 03/2011 - 11/2011

Role: Senior Data Analyst and Developer

Responsibilities:

Developed and maintained databases and data systems necessary for projects and department functions in conjunction with other team members.

Analyzed and problem solved issues with current and planned systems as they relate to the integration and management of clinical/financial data.

Acquired and abstracted primary or secondary data from existing internal or external data sources. Developed and implemented data collection systems and other strategies that optimize data quality and completeness.

Interpreted data and developed recommendations based on findings. Monitored data dictionary statistics.

Created and presented quality dashboards and ad hoc reports. Worked under general supervision of Technical Lead on all phases of SDLC lifecycle on large Data centric implementation.

Reviewed data accuracy, completeness and produce high quality software that fits business needs.

Maintained SQL standards and design documentation.

Environment: Oracle 10g,11g, Reports, Oracle PL/SQL,SQL, Reports 10g, TOAD, Unix, HTML, Windows XP, SQL, SQL Loader, Batch Process

Client: Pan era Bread, Saint Louis, MO 10/2010 - 01/2011

Role: Technical Consultant and Developer

Responsibilities:

Developed forms, reports for Order Entry sales system. This system automated sales and inventory functions. This system elimination of manual tracking of inventory and sales data. Prepared stored procedures, packages, functions and database triggers to implement required functionality.

Developed Reports for vendor details, their contact details, and notes using Reports 6i/10g.

Developed interface screens for data entry and data validations using Forms 6i/10g.

Developed Reports for transaction details, item details, stock availability and fast/slow/non-moving stocks using Reports 10g.

Environment: Oracle 10g, Oracle/9i/10g, PL/SQL, Forms 11i/10g, Reports 10g, Discoverer Plus, Discoverer Viewer, SQL Navigator, HTML, Windows XP, SQL Loader

Client: State Of Maine, Augusta, ME 04/2010 - 09/2010

Role: Technical Consultant and Programmer/Developer

Responsibilities:

Wrote and modified Oracle PL/SQL, SQL statements, stored procedures and functions.

Tuned the SQL using Explain Plan to increase performances of Reports.

Used PL/SQL extensively to create extract from Data Warehouse for Down Stream System.

Used SQL-Loader extensively to load data to small Data Mart.

Used SQL/TOAD to query complex relational databases and validate reporting results.

Fine-tuned PL/SQL Procedures for better performance.

Used the EXPLAIN_PLAN to fine-tune the complex query. Unix shell script to create environment variables and load data. Developed SQL*loader scripts to load the data from flat files to the Oracle Tables.

Involved in analysis, design, development, and testing. Modeling and logical/physical design of database schema.

Used Reverse Engineering in ERwin to identify the problems in previous data model.

Environment: Oracle 10g/11g, PL/SQL, Forms, Reports, SSIS, SQL Navigator, Unix, HTML, Windows XP, SQL Loader

Client: Air Liquid America/CGI, Houston, TX 09/2009 - 02/2010

Role: Technical Consultant and Developer

Responsibilities:

Developed forms, reports for manufacturing, HR and Payroll, Order Entry sales system. This system automated sales and inventory functions. This system elimination of manual tracking of inventory and sales data. Preparing stored procedures, packages, functions and database triggers to implement required functionality.

Redesigned existing Reports to Oracle Reports 10g.

Customized different reports in GL, AR and AP such as Account Analysis Reports, as per user requirements.

Environment: Oracle 10g, Oracle/9i/10g, PL/SQL, Forms 11i/10g, Reports 10g, Discoverer Plus, Discoverer Viewer, TOAD, Unix, HTML, Windows XP, SQL Loader

AAFES, Dallas, TX 04/2007 - 01/2009

Software Developer

Responsibilities:

Developed and improved various key modules of the custom built Store Automation Project delivering measured improvements in efficiency and productivity in day to day operations in the areas of ordering, receiving, inventory, management, merchandise planning, POS Integration and Price management.

Involved in the rescue maintenance as needed across a spectrum of store developed applications built on Oracle*Forms, Oracle*Reports, Oracle PL/SQL, and Oracle Pro*C.

Worked in Retek Merchandising System (RMS) and modified vendors order receiving for the Store Automation Project. Application development in forms and reports using oracle 10g and converted oracle 9i to 10g.

Completed programming and/or analysis and design assignments given by the customer for any effort associated with the Store Automation Project.

Managed problem tickets assigned to the group and acted as the primary Developer during a production crisis to manage other resources with resolving the issues reported. PL/SQL was used to process data input and output for the web based. Developed reports for vendor details, their contact details, and notes using reports 6i/10g. Developed interface screens for data entry and data validations using Forms 6i/10g.

Developed reports for transaction details, item details, stock availability and fast/slow/non-moving stocks using reports 6i. Designed and developed user interface screens using Forms.

Designed and implemented several Reports for invoice, purchase order, stock levels and inventory accounting using reports. Created stored procedures, functions and triggers using PL/SQL, TOAD. Expert skills in using TOAD, Explain Plan, TKPROF for Performance and Tuning.

Used various PL/SQL features of Table Functions, PL/SQL Tables, VArrays, Partitioned Tables, REF Cursors in the Development of Stored Procedures.

Worked on Business Intelligence tools like Business Objects and Crystal Reports. Data modeling experience in Entity-Relationship Model, Dimensional Data Model, Fact and Dimensions tables, Conceptual, Logical and Physical data modeling.

Developed user-interface screens for data transactions using Forms. Implemented Forms involving master/detail relationship between the blocks.

Client: TCS America/Cingular Wireless, Redmond, WA 08/2006 - 03/2007

Role: Sr. Programmer

Responsible for CDRlive, this product is designed to capture and analyzed the call details.

Responsibilities:

Analyzed using CDRlive for MSC performance, route optimization, subscriber usage performance, handset usage performance, cell site, traffic usage performance, Inter - network roaming, call failure analysis and market information. Analysis/design custom reports requests from customers using SQL and PL/SQL. Developed user-interface screens for data transactions using Forms 6i.

Designed and implemented several Reports for invoice, purchase order and inventory accounting using Reports 6i.

Designed the database architecture using ERwin (Entity-Relationship tool for Windows).

Developed reports using SQL, PL/SQL, TOAD and Business Objects for T-Mobile network and Cingular network to capture the roamers who came into the market. Traffic growth analysis and planning.

Identified and analyzed worst performing areas in the network and subscriber issues and experience. Effectively communicate network/handset issues to engineer and customer support.

Worked with Java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Client: ExcelaCom Inc., Arlington, VA 10/2005 - 07/2006

Role: Applications Developer/Software Engineer

Responsibilities:

Worked on the analysis, design and development Radio Station Information, application development in forms and reports using oracle 8i, TOAD, PL/SQL,SQL for Arbitron Washington/Baltimore. The software changes to expedite program crediting in diary processing. The program numbering and reaccrediting is primarily performed in the market analysis.

Client: Oracle/Retek, Minneapolis, MN 08/2005 - 10/2005

Role: Applications Developer/Performance Engineer

Responsibilities:

Involved in the Retek Merchandising System (RMS) performance testing, functional areas under various data volumes for RMS 11.0.x. fully familiar RMS Functional areas including scenarios with new product transformation and testing modules. All tests performed in Retek’s Performance Lab in Minneapolis, Minnesota.

Oversaw performance tuning (i.e., code enhancements, recapturing code, SQL tuning, table partitioning and indexing) for all areas tested for the RMS. Wrote stored procedures, packages, functions and database triggers to implement required functionality, and also performed unit testing and system integration.

Tuned PL/SQL procedures and function for better performance results. Participated in testing and troubleshooting of the applications. Designed required views and SQL statements to access data in an efficient way. Designed and developed various Reports and complex forms.

Designed and developed primary database objects (tables, views, indexes). Designing of the Logical and Physical Database Objects using ERwin.

Client: Louisiana Department of Labor, Baton Rouge, LA 07/04 20- 06/2005

Role: Information Technology Applications Programmer/Analyst 1

Responsibilities:

Worked on the users need reports, programming, analysis, designs and tests.

Designed, developed and implemented various applications using MS-SQL and Web FOCUS.

Created Stored Procedures, Views and Database Triggers using SQL and PL/SQL, TOAD. Developed PL/SQL Procedures for Advanced Targeting Tool.

Developed complex queries to extract and manipulate data. Performed query analysis and enhanced Query performance by taking advantage of Oracles indexing features and table partitioning features. Fully familiar with unemployment Insurance operations and needs, worked closely with users divisions in the areas of Policy services, claims delivering the information on schedule by creating either new or modifying the existing reports using COBOL, MS-SQL, SQL, JCL, TSO, DB2, Excel. Enhanced and modified database packages and stored procedures, functions and triggers, to ensure compliance with business specifications.

Designed Web-based ASP.Net Internet applications linked to firm-wide SQL databases.

Migrated a VB6 imaging application to ASP.Net (VB.Net). Volunteered to write a web application (VB.Net) to allow users to change their Oracle passwords from the intranet.

Client: LWCC, Baton Rouge, LA 07/1999 - 01/2004

Role: Associate Software Engineer

Responsibilities:

Performed the analysis, design and development needs of the company’s underwriting sub system and goldmine sub system using Oracle, SQR and HTML, Pro*C.

Designed, developed and implemented the underwriting sub system that supported the functional areas of policy creation, invoicing, payment processing, cancellations, reinstatements, etc. The sub system is integrated with quotes, claims, and audit management sub systems of the Lagniappe. The entire system is web enabled and accessible to policy holders nationwide. Designing of the Logical and Physical Database Objects using Erwin.

Worked on Workers Compensation Insurance operations and needs, worked closely with the Quality Assurance and End User Divisions in the areas of Policy Holders Services, Audits, Claims and Collections delivering the information sought on schedule by creating either new or modifying the existing Oracle Forms, Oracle Reports, SQL Reports, Structured Query Reports (SQR's) using Oracle 8.x, 9i, Oracle Discoverer, Oracle Forms and Reports 6i and SQR 4.3.5 respectively. Converted Oracle Forms and Reports from Versions 4.5 and 2.5 to Oracle Forms and Reports Versions 6i. Designed ODBC connection to Oracle 8.x.

Created PL/SQL scripts to convert Oracle Database Tables to Power comp System (Power Builder dependent) usable Database Tables to enable the implementation of a New Power comp System for the policyholder Services in the areas of Audits, Collections and Documents. Application development in forms and reports using oracle 8i and Oracle Discoverer.

Involved in the timely conversion, testing and implementation of the existing Oracle Forms and Reports from 4.5 and 2.5 to Oracle forms and Reports 6i. Converted Oracle Database Tables to Power comp System Usable Database Tables. Responsible for the timely generation, testing and implementation of PL/SQL script for conversion and testing of various Policy Holder Services documents and Audit functional tables from the existing data base to Power comp database.

Created new SQR reports as well as converted some existing reports in close discussions with the Data Users and Quality Assurance Divisions to generate valuable reports for Policy Holder Services using the Power comp database.

Designed and developed a fully data driven system with menus created dynamically from the database. Worked with business analysts to help define and set overall project development priorities.

Designed required views and SQL statements to access data in an efficient way. Designed and developed over 70 forms using Oracle Forms Builder and Designer.

Developed over 50 reports using Oracle Reports Builder. Developed a customized data access toolbar which appears on all the forms making data access easier.

Identified various types of external data sources, decoding, migrating data to newly designed Oracle RDBMS tables after solving bad data errors.

Developed a script to load data from external sources using SQL*Loader. Developed script for weekly database backup, as well as for forms and reports. Created data flow diagrams in MS Visio.



Contact this candidate