Sales Manager

Shireesh Reddy

*.********@*****.*** Tel: 973-***-****

SUMMARY:

• Experienced Programmer Analyst/Software Developer in handling various challenging

projects from Client-Server technologies to web based applications on different types of

Security and Operating Systems/Applications like Windows(2000,2003,XP, NT, Office),

UNIX, LINUX .

• Good knowledge on Databases like Oracle, DB2 and SQL Server and TCP/IP Networking

Concepts.

• Excellent knowledge and experience in Object Oriented Programming in Java, C, C++ and

PL SQL.

• Knowledge and implementation experience of Software Development Life Cycle (SDLC),

Quality Assurance, Testing Principles, Configuration and Change Management Disciplines.

• Working knowledge on Web Applications Development/Portals, Service Oriented Architecture

(SOA), Web Services and Unix/Linux.

• Defined the test process, identifying bugs/risks, developing test cases, methods (inspection,

review, dynamic) and baseline acceptance criteria and deliverables.

• Acted as liaison between management and development team for requirements and Quality

Assurance.

• Developing the documentation of the User requirement analysis, design, development &

implementation and Test Case documents.

• Knowledge and experience in Lotus Notes, Microsoft Technologies like Office suite including

Access, Excel, Word, Power Point.

• Strong communication, analytical, programming skills and an excellent team player

enthusiastic to learn new things.

• Highly capable of learning new technology and adapt to a new environment quickly.

SKILLS:

Operating Systems: Windows 2000, 2003, NT 4.0, UNIX (HP, Sun Solaris),

Linux, MS-DOS.

Database: Oracle 8.x, 9.x, 10G, 11G, SQL Server 2000 & 2005

and DB2.

Web Technology SOAP,XML, XSL, HTML, JDBC, Javascript, VB Script,

ASP, Unix Shell Scripts

Database maintenance & TOAD and SQL Navigator

Performance Tuning:

Programming Languages C, C++, JAVA, T/SQL, PL/SQL, ASP.NET, C#, VB.NET.

Report Writers: PS Query, Crystal reports, nVision, SQR, XML

Publisher.

Scripting Shell, nVision, Cognos, SQR, Perl, VB Script.

EDUCATION:

Masters in Software Engineering G.P.A: 3.83/4.0

Stratford University, West Falls Church, VA Jan 06 – Dec 07

Bachelor of Technology in Electronics & Communications Engineering G.P.A: 3.13/4.0

Jawaharlal Nehru Technological University, Hyderabad, India Sep 01 – Jun 05

WORK EXPERIENCE:

Aptek Solutions Inc

Client: Verizon Wireless (Telecom) New York, NY June 08 – Sep 09

Programmer Analyst

Integrating PeopleSoft with 3rd Party Applications:

Worked on Integration\Support of PeopleSoft HR to Third Party Vendors (non-PeopleSoft)

ACHECK America CA and Health Resources Boston, MD who does Background check (Medical,

Criminal and Education) for Verizon.

Environment: Oracle PeopleSoft Financials 8.9 (AP, GL, Asset Management), Oracle PeopleSoft

HCM/HRMS 8.9(HR, NA Payroll, Benefit, eProfile and eBenefits), People Tools 8.46 on DB2

Instance, Integration Broker, SQR, PS Query, Crystal 9i, nVision, Windows XP/2003 server, Citrix.

Responsibilities:

• In Phase I, worked with Technical team from Verizon and Vendors to determine the

developments/modifications in design specifications.

• Interacted with developers from both the vendors to analyze the technical aspects for

Integration and to send and receive route Messages/Transactions (Synchronous and

Asynchronous Transactions).

• Created Application Engine and Application Messaging programs. Worked on Error

handling (validated inbound message from the vendor whether it has valid key fields with

valid values) and XML Parsing in People Code.

• Created a Manage Applicants Page for Manager Level.

• Involved in Integration Gateway Set up for PeopleSoft, Loading delivered connectors,

Configuring a new Gateway Node and defining properties for Target Connectors at Node

level.

• Set up Integration broker for web services.

• Performed testing for the Inbound and Outbound Messages using Verizon Integrity Tool

and also verified the XML using Schema Tester and Event Tester.

• Monitored Messaging activity, Debugging People Code and Interacted extensively with

vendors relating Error Handling, Connectivity issues, Field Mapping and the Transformed

Response Messages.

• Placed our custom API files on the client machine (web server).

• Executed registry file to update the registry with the new libraries.

• Made back up of all Core Tables in Dev Environment before moving it to UAT with Data

Mover, archiving and checking data integrity through Shell Scripts.

• Worked on Archiving to history tables. Using PeopleSoft Data Archive Manager involved in

performing tasks like create and design Archive templates, Work with the Archives and

Archiving data, Run Data archival processes, Run Data Archival reports and audits,

Perform additional Archival procedures.

• Worked with DBA to migrate projects from one environment to another (UAT and

Prod).Hands on experience on Version Control and Object Migration Tools. Knowledge on

generating DMS Scripts for databases(DEMO database and System Database)

• In Phase II, prior to the changes from the Vendors worked on modification of XML tags of

our outbound message and also worked on Manage Applicants Page modification on

Verizon side as per new additions in our design doc.

• Modified existing App Engine programs to pull up Medical and Criminal Flags for a

particular Job Opening Id on the Manage Applicants Page.

• Developed a Work Flow so that whenever a valid inbound message comes in a

Component Interface shoots up Work list (Synchronization EIP) and at the same time an

Email will also be sent to the persons/departments associated with the role.

• Developed a new Application Engine & Crystal Report to determine the Permissions lists

Information associated with Portal Security by Role.

• Worked with the team to learn and handle iMacros to automate data entry tasks into

PeopleSoft system which saves hundreds of hours of data entry time

Verizon Service Operations

Environment: Oracle PeopleSoft Enterprise Learning Management 9.0, Oracle PeopleSoft Human

Capital Management 9.0(HR, Benefit, eProfile, eBenifits), People Tools 8.49 on Oracle 11i

Instance, PL/SQL, PeopleSoft Vanilla, Integration Broker, SOA, WebLogic, SQR, Crystal 9.0,

Citrix, Putty, Windows 2000 Professional, HP UNIX.

Responsibilities in ELM:

• Worked on Integrating PeopleSoft HCM and ELM modules.

• Involved in configuration, documentation, analysis and setup for the PeopleSoft ELM

module for Integration.

• Created SQR program that generates employee’s data from ELM module that were

registered for the Training Courses.

• Involved in analysis, preparing specifications and development for customizations on

Enroll Learners, Maintain Enrollments, catalogs and rosters pages and Setting-up

Approval Work Flow Engine/Work lists for ELM application.

• Created Mass Enrolment Application Engine Process for ELM as per the business

requirement.

• Done Impact analysis, Involved in creating test data, test plans and testing various ELM

customizations.

• Worked on ELM 9.0 application configuration and involved in integration.

• Prepared a detailed documentation of the integration between HCM 8.9 and ELM 9.0.

• Configured Delivered and Custom Publication/Subscriptions from HRM to ELM.

• Created Employee Profile pages which show up the Portfolio of Senior and Manager Level

Employees. My task was to load around 1700 JPEG images from a UNIX server location

and display it on our Portal Profile Pages.

• Wrote SQR which pulls the image from the server and stores it in PS_EMPL_PHOTO Table.

• Created a Procedure with “DBMS_LOB Package” and call that Procedure in the SQR(Since

“employee_photo” field had BLOB data type)

• Created a Directory on the UNIX server which holds the JPEG Images.

• Wrote People Code to pull data of the employee (work experience and summary,

education, Licenses and certification, Language Proficiency, Relocation and Geographic

Preference, Outstanding activities) from Data Base and show up on the profile page with

employee’s Image.

• Interacted with LINUX Administrators for reading the JPEG Images from server’s folder,

creating new folders with read only files and Oracle Administrators for accessing

Directories, Procedures, and Packages.

Aptek Solutions Inc

Client: HSBC Plainsboro, NJ Nov 07 – Jun 08

Project: Account Transaction System

Programmer Analyst

Environment: HP Quality centre, QTP 9.0/9.2, .NET Framework 2.0, Microsoft Visual Studio

2000, T/SQL, MS-Office Excel, and Windows XP.

This project is for the bank customer’s to check information about his/her The system will takes

care of different types of transactions like deposits, account status, balance, transfer the amount

from one account to other, current and previous transactions.

Responsibilities:

Analyzed the business requirements and wrote a Test Strategy and Test Plan.

•

Was involved in the complete Software Development Life Cycle (SDLC).

•

Studied Functional specifications and requirement documents to categorize the Unit

•

Testing.

Created test Cases as per the business requirements and executed them.

•

Involved in writing and implementation of the various test cases and test scripts.

•

Created test scripts manually for Functionality testing

•

Interacted with programmers to identify and resolve technical issues.

•

Participated in Walkthrough and defect report meetings periodically.

•

Involved in Version control and configuration management.

•

Performed regression testing on the new builds using QTP.

•

Performed Manual Testing.

•

Extensively worked on Quality centre for bug reporting/tracking.

•

HCL Solutions, Hyderabad, India May 05 - Dec 05

Project: Financial Net Sales (FNS)

Jr. Programmer Analyst / PL SQL Developer

Environment: JAVA J2EE, Java script, Windows 2000, HTML, Oracle 9i, PL/SQL, TestDirector,

Ms-Excel.

The Financial Net Sales (FNS) web application is an Executive Information System (EIS)

application tool that enables users to view financial net sales and market basket information in an

easy to use, web-based interface. It is designed to serve the information needs of multiple user

roles ranging from executives, analysts, power users, and administrators. Users should be able to

take advantage of the following functionalities

• Using maintenance modules, users can upload and maintain the sales data, View Financial Net

Sales data in a centralized and secure web-based environment

• Utilize multidimensional canned views to consistently and accurately track business

Trends and measure business performance

Responsibilities:

Developed detailed Test Plan using High Level Scenarios, Functional Requirements,

•

System and Software requirements.

Wrote and executed test cases and wrote bug reports for failed test cases

•

Extensively used SQL for data integrity testing at the backend.

•

Investigated Software defects and interacted with Analysts to resolve technical issues.

•

Developed & maintained the traceability matrix between requirements and Test cases in

•

TestDirector.

Involved in analysis and study of functional specifications for the enhancement of existing

•

functionality.

Responsible for System Testing, and Acceptance Testing.

•

Recommending continuous process improvement, maintain QA standards and artifacts.

•

HCL Solutions, Hyderabad, India

Project: Employee Information System (EIS) Nov 04 – May 05

Jr. Programmer Analyst / PL SQL Developer

Environment: C++, Visual Basic, Oracle 8i, Windows 98, PL/SQL, UNIX, MS Access, MS Excel.

Employee Information System (EIS) project was developed for Reddy Laboratories, Hyderabad.

EIS provides the employees to view their paychecks, tax cuts, to update their personal

information and to search the information about the other employees working in that company.

Responsibilities:

• Wrote Stored Procedure, Function and Packages.

• Wrote Procedures using Oracle supplied Packages.

• Reviewed Software defects and interacted with Analysts to resolve technical issues.

• Involved in writing DB triggers to Analyze and Update the master tables

• Optimization and tuning of database Query.

• Performed database integrity check and data validation.

• Developed Unix Shell scripts to automate repetitive database processes

Contact this candidate