Hemanth Pidaparthi

bpojrs@r.postjobfree.com /bpojrs@r.postjobfree.com

+1-217-***-****©

Summary of Qualifications:

•Over 4 years of professional experience as Programmer Analyst/ Developer. My hands on experience in projects life cycle includes Requirement gathering and Analysis, Database design, Database development, Database Administration, Test, Implementation & Support.

•Involved various activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution, SQL scripts and PL/SQL programs, related reports and forms, unit level and user acceptance testing, Strong Oracle Forms / Reports skills.

•Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate complex data sets in Oracle Databases.

•Experience working with the Account Management on Oracle/ SQL Server.

•Experience in applying Quarterly critical patch updates to the database from Oracle.

•Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

•Experience in all levels of performance tuning of Informatica Sources, Targets, Mappings, Transformations, Sessions and Workflows.

•Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.

•Extensively used SQL Loader as an ETL tool, TOAD and SQL* PLUS for writing several SQL queries to pull the data, and for determining the optimization level of the query. Good Command over creating database objects like views, clusters, indexes, Sequences, partitions etc.

•Experience in developing programs using SQL*loader and PL/SQL procedures to transfer data from legacy systems

•Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding and implementing business applications.

Technical Skills:

Languages

Java, SQL and PL/SQL, T-SQL

Databases

Oracle 8i/9i/10g/11g, SQL Server 2005/2008, Sybase, MS-Access

Oracle Tools AQUA Data Studio 4.7, SQL *Plus, Rapid SQL 7.2.1, SQL Loader, Oracle Apex 3.1.1, SQL Developer, TOAD

Web Technologies CSS, HTML, Java Script, Ajax

Operating Systems Windows 2000/XP/NT, UNIX, Linux

ETL Informatica 8.6.1 (Repository Manager, Designer, Workflow Monitor, Workflow Manager)

Other Tools

Ultra Edit -32, SSH Secure Shell, MS Visio, Putty

GUI/Reporting Tools

Developer 2000 (Forms 4.5/6i/9i, Reports 6i/9i),Eclipse BIRT Reporting , Developer Suite (Forms/Reports 10g)

Indiana University, Bloomington, IN, USA Mar ’09 – Till Date

Team: Enterprise Decision Support Services (EDSS)

Project: Shared University Data Service (SUDS) with some Data warehouse work

Systems Analyst/ Programmer

Data warehouse environment:

We have the transactional systems / application areas (Enterprise Business Systems) with their ODS (Operational Data Store) Schedule. Data is copied from the source to the Data Store. We have 7 different ODS’s for different enterprise business systems) running during midnight. After the schedule is done on the transactional systems we use the ETL processes through Informatica power center workflows scheduled to load the data into the Data ware house. After the data is loaded to the DW database (DSS1PRD) through the ETL processes from the data access layer we can perform the report writing or BIRT reporting .Reports are generated through Web based publishing (IUIE- Indiana University Information Environment). Also from the data ware house the data can be accessed from the ODBC/ JDBC applications.

Shared University Data Service

The, Shared University Data Service, is a common set of data sources for shared data elements. The production Oracle instance exists on a high availability node. SUDS have two main goals. One is to eliminate dependencies (on physical data structures) and replication in applications requiring access to other data sets. The other is to utilize Web Services and stored procedures. Our Project is about migrating the existing SUDS Database on AIX machines to Linux. SUDS DB is driven by shell scripts that use metadata on each of the different publishing systems to create materialized views. A view is set up on each publishing system that needs access to data from the publishing system.

Responsibilities:

Worked on Preparing the Technical Documentation for SUDS Migration Schedule from Unix (AIX) to Linux

•Requirement gathering, Requirement Analysis, Coding, Code Review, testing, and Implementation.

•Worked on the SQL Scripts for uploading the Data into the tables in the EDSS Schema.

•Worked with the DBA’s on the test build for SUDS on Linux.

•Creating Tables, Synonyms, Views. Wrote database triggers.

•Created and worked on the Audit Tables for the SUDS environment.

•Cut over of the nodes from the AIX (UNIX) Test Environment and pointing them to the Linux Nodes for the Test and the Production Server.

•Used Dynamic SQL for DDL commands in PL/SQL. Developed database triggers to maintain audit tables and a large number of stored procedures using PL/SQL to validate and populate the data.

•Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.

•Development process for new or existing DW objects - Developing the DDL ,Initial testing to the DDL in the development environment, Migrating the DDL to the test environment, Creating and modifying Informatica power center mappings and workflow load data, Develop reports in BIRT using eclipse and publishing the reports to the IUIE( Information environment ).

•ETL performance tuning for the Informatica SQL. ( Identifying sessions for tuning, Space utilization

•Used Informatica designer for designing mappings and mapplets to extract data from Oracle sources.

•Handling any Critical batch processing errors outside business hours once a month carrying team pager for 3-4 consecutive nights, verifying the scheduled completed and check for ay Critical errors and non-critical Errors.

•Checking the workflow run on the test and production repositories from the Informatica Monitor and resolve the errors involved with the failed workflows. Check the log files located on the UNIX.

•Worked on creating web forms and Perl Scripts for the requests that come in for the SUDS database.

Environment: Oracle 10g R2, AQUA Data Studio 4.7, SQL Developer 1.5.4, Informatica Power Center Client 8.6.1 , SSH Secure Shell, Eclipse 2.5.1 BIRT Reporting, Foot Prints, UNIX, SQL, PL/SQL, PERL, HTML.

Team: Data Services for Departments and Instruction (DSDI) for EDSS.

Analyst/ DBA

Data Services for Departments and Instruction is a subdivision of EDSS and provides and supports shared, interrelated database and web environments used within Indiana University for instruction on database and web technologies. The Learning Technologies division of UITS is the service owner for the services delivered by EDSS and the Enterprise Web Tech Team. Our Vision is to provide high quality services and support; to departments by adding value to their use of database technologies and to faculty members for teaching database concepts, web application programming and web site design.

Responsibilities:

•Offering Accounts for learning Database and Web Server Applications.

•Oracle Account Management: Provide Oracle Database Accounts to IU Students, Faculty and Staff independent of learning SQL and Oracle.

•Unix Account Management: Work on the Unix Accounts with Apache/ Tomcat (Mentor) for the Students and Faculty

•SQL Server and IIS Accounts for Students at IU: Responsible for acquiring and making arrangements for any additional Software other than MS SQL Server (Clark Accounts )and IIS Server.

•Checking the Feasibility and compatibility of software applications or client tools that will potentially use the UITS MS SQL Server as Backend.

•Preparing the Documentation for the software upgrades on the University Website (IU Ware) and make sure we have the instructions available for the students to install the Oracle Releases (10g R2, 11g).

•Resolving the requests which comes in a queue in Footprints Interface for the faculty (Create Class Requests for the

•Databases for their Instructional purpose) or students when they have issues accessing their WEB accounts or Database Accounts. (Oracle, SQL Server).

•Worked on applying Quarterly Critical patch updates from oracle Meta link website regularly to the database on test and the production servers.

•Currently migrating the existing Mentor (Instructional Web Programming) Accounts on Solaris Machine (SYTHE) to the Linux Machine (GLADIUS) for the future Data Center Migration.

Environment: Oracle 10gR2/11g, Account Management on Oracle, SQL Server and IIS, UNIX, Mentor, Enterprise Manager Console, Foot Prints, SQL Server Management Studio 2008, SSH Secure Shell.

C & S Grocers, Hatfield, MA, USA Sep ’08 – Jan ‘09

Project Name: Labor Scheduling

Oracle Database Developer / APEX Reporting

C&S Wholesale Grocers of Keene, NH is the second-largest food wholesaler and the tenth largest privately held company in the United States.. C&S is currently working on a project to schedule their Labor. This Application helps the Management of C&S to understand and Schedule the labor to meet the company needs. Also the application helps to improve the relationship between the Management and the Labor.

Responsibilities:

•Involved in the requirement collection, analysis, design, development and maintenance of the application. Extensively worked in TOAD. Created Database Objects like Tables, Indexes, Synonyms and Sequences in Application Express (APEX).

•Created and developed Stored Procedures and Functions in PL/SQL.

•Creating Tables, Synonyms, Views. Wrote database triggers. Created Cursors using PL/SQL.

•Designed the Architecture for the database, created and extracted the tables from different sources. Involved in the Conceptual Data modeling Process.

•Experienced in creating the Front end Applications using APEX. Created Interactive Reports, Charts in Web based applications.

•Involved in the user interface design for creating the regions, buttons, items, Breadcrumbs, Templates, Themes, LOV’s, Navigations for the project with the Application Express.

•Used Java Script for client side validations.

•Managing the schema objects like tables, indexes, views, synonyms, clusters, etc.

•Involved in Creating the Pages and Forms with reports for the labor scheduling application.

Environment: Oracle 11g Database, Oracle APEX 3.1.1, PL/SQL, TOAD (Tool for Oracle Application Developers), APEX Reporting, XML, ETL, Java Scripts, HTML

The Northern Trust Company, Chicago, IL, USA Feb ’08 – Aug’08

Project Name: Fund Strategy

Forms/ Reports Developer

Northern Trust is a global leader in delivering innovative investment management, asset and fund administration, fiduciary and banking solutions to corporations, institutions and affluent individuals. Coming to the Project, Northern Trust is migrating PACE Application Reporting Engine (PARE) from Sybase to Oracle database. As part of this initiative, Fund strategy needs to be migrated into Executive Reporting (ER) application from Sybase to Oracle without any changes to the reporting.

Responsibilities:

•Involved in a migration effort to move reporting applications from Sybase to Oracle.

•Migrated numerous Sybase stored procedures to equivalent Oracle stored procedures.

•Wrote test plans and scripts to automate unit testing including SQL and UNIX scripts. Wrote technical design for migrating Sybase procedures to Oracle and to convert the business objects reports.

•Extensively worked in SQL*Plus, Rapid SQL. Created Database Objects like Tables, Indexes, Synonyms and Sequences.

•Created and developed Stored Procedures and Functions in PL/SQL for the front end.

•Creating Tables, Synonyms, Views. Wrote database triggers. Created Cursors using PL/SQL.

•Used the SQL Loader for Extraction Transformation and Loading purpose(ETL).

•Developed and changed Procedures, Functions, Packages, Triggers, and Views using PL/SQL Provided support to development applications for various databases.

•Managing the schema objects like tables, indexes, views, synonyms, clusters, etc.

Environment: Oracle 10g DB/ Developer Suite (Forms/Reports 10g), PL/SQL, SQL*PLUS, MS Access, Sybase 12.5.4, Embarcadero Rapid SQL 7.2.1.

Minnesota Department of Human Services, Saint Paul, MN, USA Sep ’07 – Jan’08

Project Name: HIV/AIDS Divisional Database

Reporting Analyst/ Database Developer

Responsibilities:

•Designed and developed the user Interface using Forms 6i according to Specifications given by the project manager.

•Extensively worked in SQL*Plus, SQL* Loader, Oracle SQL and PL/SQL.

•Worked on Share point designer for creating and modifying the Front end user interface.

•Wrote the different event triggers and procedures to implement business rules using Forms 6i and Reports 6i.

•Worked extensively Visio 2003 for Flow Diagrams Design.

•Developed forms using oracle form builder template and tabular report using Oracle Report Builder.

•Creating Tables, Synonyms, Views. Wrote database triggers. Created Cursors using PL/SQL.

•Wrote SQL Scripts to create, alter, and drop database objects, like tables, views, and sequences. Developed Dynamic SQL to build complex Queries

•Experience in SQL Query Tuning for improvement in system response.

•Created stored procedures, triggers, and functions to retrieve data from the database using PL/SQL.

•Created shell scripts in UNIX to automate the data loading process and to cleanse the flat file inputs.

Environment: Oracle 10g DB, Forms 6i, Reports 6i, PL/SQL, SQL*PLUS, HTML, ETL, Data modeling, Java Script, Ultra Edit 32, TOAD (Tool for Oracle application Developers).

Illinois Department of Health care and Family Services, Springfield, IL, USA Aug ’06 – Jul’07

Claims Processing Division

Reporting Analyst

Responsibilities:

•Interacted with the Business Analyst in collecting the technical and business requirements for the project. Assisted the Data Architect in Designing and Modeling of the database using Erwin.

•Identified Primary Keys, Foreign Keys and made relations. Involved in preparing E-R diagrams.

•Involved in creation of database tables and Index-by tables using storage parameters.

•Work experience with Tera-data Database Stored procedures.

•Worked on the Application Development for Tera-data RDBMS using Explicit and Implicit SQL.

•Involved in creation of sequences for automatic generation of voucher numbers.

•Created backend queries, stored procedures, Packages and Database triggers.

•Developed tabular reports using MS Access.

•Extensively Worked on MS access and SQL plus for updating the data in the database.

•Worked on BI-Query tool (Humming Bird) for loading the data into the data warehouse from the database.

•Created and Modified Macros on the Teradata RDBMS.

•Used SQL*Plus for faster application design and developments.

•Involved in generated work plans, and developed complex matrix reports.

Environment: Teradata DBMS, Oracle 8i/9i, Developer 2000, Query Man, Embedded SQL, SQL*Plus, Humming Bird, MS Access.

References:

1.Rebecca Gribble - bpojrs@r.postjobfree.com - +1-812-***-**** (Email Preferred)

Manager- Enterprise Decision Support Services (EDSS), University IT Services- Bloomington.

2.Shelly Owen K - bpojrs@r.postjobfree.com - +1-651-***-**** (Email Preferred) Project manager - HIV/ AIDS Division - Minnesota Dept of Human Services

3.Mike Noone - bpojrs@r.postjobfree.com - +1-312-***-**** (Email Preferred) II Vice President - IT Services, Northern Trust Company

4.Debbie Helms - bpojrs@r.postjobfree.com - +1-217-***-**** (Admin Services)

Manager, Data Control section- Claims processing Division - IL Dept of Health Care and Family Services

Education:

•Masters in Computer Sciences - University of Illinois, Springfield, IL, USA

•Bachelors in Computer Sciences - Acharya Nagarjuna University, India

Contact this candidate