PRIYA VIJAYAKUMAR GOWDA

*** ******* *****

Chalfont, PA 18914

267-***-****

acr4j6@r.postjobfree.com

EDUCATION:

University of Alabama in Huntsville, Alabama, USA

MS in Computer Science. (May 2015)

Sapthagiri College of Engineering, Karnataka, INDIA

Bachelor’s Degree in Information Science and Eng. (Jun 2012)

CERTIFICATION:

Certified Selenium Professional (Oct 2015)

TECHNICAL SKILLS:

ETL TOOLS

Ab Initio GDE 3.0.4.2/2.14, Co>op 3.0.3/2.14,

IBM Info Sphere DataStage & Quality Stage Designer, Director, Manager for Version 8.5

Scripting

UNIX Shell Scripting, KSH

Languages

C, C++, HTML and XML, Python, Prolog, SAS, Java, JavaScript, VB.NET, ASP.NET

Operating Systems

UNIX, AIX, Solaris, Windows7, Windows 8

RDBMS and Big Data

IBM DB2 UDB Version 10.1, MS SQL Server 2000 and 2005,MS Access, MS-SQL, PL/SQL

Scheduling Tools

Zeke

Testing

Manual testing methodologies using SQL and Shell Scripting, HP QTP,Selenium

Packages

IBM DB2 Command Editor, Embarcadero Rapid SQL, IBM Rational Clear Case, SQL* PLUS, Toad 7.x, SQL Loader, SQL Developer, Microsoft Visio.

ABSTRACT:

Experienced with Ab Initio GDE & Co>operating System (Version 2.14/3.0.3). Extensively worked with most of the commonly used Ab Initio components like Rollup, Scan, Normalize and Read/Write multiple files, Partition & De-partition Components and proficient with various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism on Serial and Multi File Systems (MFS). Worked on several ETL Ab Initio assignments to extract, transform and load data into tables as part of Data Warehouse development with high complex Data models of Relational, Star, and Snowflake schema. Excellent coding and debugging techniques in Ab Initio, shell scripting, SQL.

Have an in-depth understanding and full life cycle ETL development for building a data warehouse and Business Intelligence concepts; and experience in implementing ETL applications in conjunction with DB2 UDB Data warehouse. Experienced in writing IBM DB2 UDB SQL’s for a year. Wrote several complex SQL queries using sub queries join types etc.

Experienced working with UNIX, AIX operating systems for two years. Good working knowledge writing UNIX & Shell Scripting, SQL and PL/SQL queries for ETL process.

Understand all phases of data warehousing including collecting BA specifications, ETL Design, Application & Component design, Development, Code review [WPI-work product inspection & WPR-work product review], Unit testing, Roll out to QA, Enhancements, Maintenance and Production Support.

Experienced in SAS programming, and manual testing concepts, as well as usage of IBM rational clear case to check in/out of documents. Also, have the knowledge of setting up jobs in Zeke for automated execution. Experienced in Python and Prolog during my school years.

Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage, designing and developing jobs using IBM Info Sphere DataStage & Quality Stage Designer, Director, Manager Version 8.5.

Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements. Designed and developed ETL processes using DataStage designer to load data from IBM DB2 tables, Flat Files (Fixed Width) to staging tables and from staging to the target Data Warehouse database IBM DB2.

Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.

Developed job sequencer with proper job dependencies, job control stages, triggers. Extensively used DS Director for monitoring Job logs to resolve issues.

Self-Motivated, punctual, dependable and fast; Flexible to adapt to changing priorities and deadlines. Systematic and organized approach. Ability to work independently and manage multiple task assignments. Willing to accept new challenges. Work well in a team environment.

EXPERIENCE:

Graduate Projects:

Online Food Ordering System (Feb 2015 - Apr 2015)

Developed a web-based application for accessing an online food ordering system that facilitated the ordering of food from restaurants registered to use the service

The web application had the flexibility to handle addition of new restaurants; where in the restaurant managers can manage the menus and food items for their respective restaurants.

Medical Transcription Database (Jan 2015 - Apr 2015)

Developed a website for administration of patient records. This website was mainly developed to assist hospital management and administrators to keep the track of patient’s record accurately and to increase hospital productivity. The medical transcription website provided detailed information on patient/doctor relations and other details like work assigned to the medical transcription.

The transcript record was maintained in the database. Technologies used in this application were a .NET platform and imported .NET packages that connected to MS SQL database through ADO.NET.

Smart Shopping Application (Sep 2013 - Dec 2013)

Managed the Smart Shopping Application by working as a Team lead; managing 4 team members by working in all steps of the project life cycle during software requirements and analysis phase. I also performed elicitation of requirements, analysis modeling and quality assurance steps to maintain the quality of the software.

Bluetooth Object Exchange File Transfer Attack (Blue jacking) (Feb 2014 - May 2014)

Developed a simple device discovery to identify discoverable devices by name. Perform a service discovery, which provides the service type and URL to the user. The content of the URL indicates whether a device requires authentication and encryption for a successful communication attempt. Allow the attacker specify the service URL of a device and transfer a simple text file to that particular device. Used Java as a tool to code the above requirement.

Secure Communication Mechanisms (Oct 2014 - Nov 2014)

Security communication mechanisms will support three essential functions:

1. Authentication – verify the client and/or the server.

2. Negotiation – discover the capabilities of the client and server, and then agree on the security parameters.

3. Secure communication – after the authentication, generate session keys to protect the communication.

Client requests for connection to server. Server generates cypher text using macid as the key and gives it to client. Client now decrypts the cypher text using its macid and sends the actual text for verification. Now the server verifies the cypher text and it would generate the session key for communication. Client uses this session keys for communication purpose. Once the session keys are generated successfully, any requests from the client will be encrypted using session keys. By this way communication goes on between server and client. Used AES(Rijndael), DES for encryption algorithms. Coded in java.

AJAX Web Application (Nov 2014)

Designed and developed a Student Course Check Application using Client side HTML form and Server side database in PHP. Used JavaScript, HTML, CSS, PHP.

Contact this candidate