Aplication specialist - Software developing

PRAVEENA ALLURI

Phone: 647-***-****

Email: ********.******@*****.***

Toronto, ON

LinkedIn: www.linkedin.com/in/praveena-alluri-950684189

PROFESSIONAL SUMMARY

Oracle certified Java associate developer with 5+ years of experience with various teams and customers mainly focused on detail-oriented, offering exceptional troubleshooting skills and a talent for developing innovative solutions. Experienced in object–oriented programming, developing, testing and debugging code. Quickly able to learn and understand new technologies with proven success working in both a team and self-directed setting.

SKILLS

Java, SQL, SHELL, PERL, JSP, HTML, CSS, XML, Oracle, MS SQL Server 2008, DB2, AQT, MS SQL Management Studio, Eclipse, Android Studio, Visual Studio, IBM WebSphere Studio Application Developer (WSAD), Rational Application developer (RAD), Visual SourceSafe, IBM Rational Rose for UML, GitHub, JIRA, Blue Prism, RDLC Reports, Jasper Reports, Windows 7, Vista, NT, 2000, XP, 10, LINUX

EDUCATION AND CERTIFICATIONS

Oracle certified Associate, Java SE 8 programmer (OCJAP – 1Z0-808) – 2019

Mobile Application Development course, CEGEP, Montreal - 2017

Masters in Computer Science, Osmania University, India - 2006

Bachelors in Computer Science, Osmania University, India – 2004

PROFESSIONAL EXPERIENCE

Alcohol Countermeasure Systems (ACS), Toronto, Canada

Jan’ 18 – Present

Application Specialist in Software Development

Clients: Law Enforcement and Government jurisdictions around the world

1. Project: Alcotrack

An ignition interlock or car breathalyzer prevents drunk drivers from driving their vehicle. The device is connected to the vehicle if the drivers convicted of drunk driving offenses, and it has a preset level for blood alcohol concentration (BAC) determined by the respective state.

ACS has introduced many types of Ignition interlock Devices. Alcotrack is one of the application that creates the client, program, transactions and stores the event logs and information of the users, machines, officers etc., in to the database. This data is used to generate the reports for the concerned user. The application communicates with the hardware using ALC.

Job Accomplishments:

Designed the Functional Spec and Design Document from the requirements.

Writing SQL queries for data entry, changes in the requirements as and when needed.

Create Perl scripts for automated reports.

Create and Modify the Reports (RDLC files) based on the requirements.

Provide support to all internal and external customers.

Involved in debugging, Unit Testing, System Testing and Integration Testing.

Creation of Zip files and deploying them on the IIS Application Server for QA.

Check the transaction logs as and when required.

Update the products and fix transaction data.

Technologies used: HTML5, CSS, jQuery, XML, ASP.Net, C#, Angular, MS SQL 2014, Visual Studio 2017, Internet Information Server, GitHub, JIRA.

2. Project: Intertrack

Intertrack is one of the age old application that creates the client, program, transactions and stores the event logs and information of the users, machines, officers etc., in to the database. This data is used to generate the reports for the concerned user. The application communicates with the hardware using the interface called SDP.

This application uses Java/J2EE Concepts and db2 as database. The application differs for QA, Staging and Production. It uses WebSphere as the application Server.

Job Accomplishments:

Writing SQL queries for data entry, changes in the requirements as and when needed.

Running the required reports for Internal and External Users.

Involved in debugging, Unit Testing, System Testing and Integration Testing.

Create and Modify the Reports (XML files) based on the requirements using Jasper Reports.

Check the transaction logs as and when required.

Update the products and fix transaction data.

Uses different file transferring protocols to transfer from one server to other.

Provide support to all internal and external users.

Technologies used: HTML5, CSS, jQuery, XML, Java, Angular, db2, AQT, Jasper, JIRA.

3. Project: AlcoFleet

Alcofleet is a Commercial Enterprise Application used for Ignition Interlocks for the safety for their Organization. Alcofleet consists the information about the Company Name, Vehicle, Driver, Transaction date and time etc.

The application helps in generating the logs, reports, change the settings, add the users and also can customize their requirements.

Job Accomplishments:

Update the manuals for the changes in the Application.

Writing SQL queries for data entry, changes in the requirements as and when needed.

Provide support to all internal and external customers.

Involved in debugging, Unit Testing, System Testing and Integration Testing.

Give access to the users and register their machines.

Technologies used: HTML5, CSS, jQuery, XML, ASP.Net, C#, Angular, MS SQL 2014, Visual Studio 2017, Internet Information Server, GitHub, JIRA.

4. Project: AlcoREMOTE

Application Overview:

AlcoREMOTE is a cloud based application mainly used in US Government Jurisdictions for the Offenders who are in home arrest for the seriously convicted of drunk driving offenses. Through this application we can store all the client, officers, the program information and also can get the events from the device who are monitored at regular time periods.

MS SQL 2014 is used a backend database which is helpful in generating reports regularly to the government officials.

Job Accomplishments:

Writing SQL queries for data entry, changes in the requirements as and when needed.

Provide support to all internal and external customers.

Involved in debugging, Unit Testing, System Testing and Integration Testing before pushing to Production on QA.

Check the logs when required.

Running the reports as requested from users.

Update the products and fix transactions if required.

Technologies used: HTML5, CSS, jQuery, XML, ASP.Net, C#, Angular, MS SQL 2014, Visual Studio 2017, GitHub, and JIRA.

Spectra Smart Solutions, India

Jun’ 12 – Jan’ 16

Software Engineer

1. Project: Wiskey (Web Integrated Software Keys)

Philips Medical Systems (PMS) sells systems with increasing amount of software. System will have necessary software enabled and the optional software is not activated and will be activated only upon Customer requests. Special keys are generated to enable these software options on the systems. The keys can be generated either by the Service engineer or by Operations personnel.

WISKEY facilitates a web interface to generate Software License keys for the Software Options in new machines as well as new Ordered Software Options for the existing machines. This also facilitates easy update of the Install base information in SAP and helps in minimizing the number of manual transactions.

Job Accomplishments:

Prepared use cases, design class diagrams using Rational Unified Process and UML.

Designed and developed several JSPs for presentation layer using taglibs, JavaScript and Html.

Implemented the authorization and authentication process.

Involved in gathering the requirements from the end users and documenting it.

Implemented and managed the SQL database used for internal processes.

Communicate and follow the SRD from Technical Leads.

Writing SQL queries for search criteria and display the results.

Technologies used: Java, Rational Rose, HTML5, CSS, jQuery, MS SQL 2008, Visual Source Safe 5.0.

2. Project: IN Training

The Spectra Smart Solutions implemented the IN Training web application that can be accessed by the training providers (Application Support) to enter and update their information and programs. The staff also has access to this system to approve or reject the program application and manage accounts. This system is also designed to allow users to search for training programs for different outgoing applications available and other factors that will help them choose appropriate training.

Job Accomplishments:

Involved in gathering the requirements from the end users and documenting it.

Designed the application using the historical trading data.

Implemented and managed the SQL database used for internal processes.

Participated in code Validations and testing.

Documented the Use cases, Class diagrams and Sequence Diagrams.

Communicate and follow the SRD from Technical Leads.

Designed the application using the historical trading data.

Writing SQL queries for search criteria and display the results.

Technologies used: Java, HTML 5, CSS, JQuery, MS SQL 2008, Microsoft Visual Studio 2010.

3. Project: BTP (Breakthrough Plan)

The BTP application is a web-based application to be used with in the client intranet developed using Java, XML, CSS and oracle as the backend. It uses WebSphere 5.0 as the application server.

The client wants to have a common methodology for defining the plans to meet their business objectives and easy tracking of the plans across the organization. They have decided to web enable the process so that it can be easily accessed across them. The list of objectives and strategies has to be implemented in a Tree structure.

Job Accomplishments:

Involved in the Database Design of the application and creation of tables, views, triggers and stored procedures etc.

Designed the Functional Spec and Design Document as per the requirements.

Wrote several use cases, made design of classes using Rational Unified Process and UML.

Implemented the authorization and authentication process.

Designed and developed the front end using Xml, CSS for presentation layer using taglibs, JavaScript and Html.

Involved in debugging, Unit Testing, System Testing and Integration Testing before submitting to QA.

Preparation of test cases, code review and testing.

Technologies used: Java, Xml, CSS, Java Script, WebSphere 5.0, Oracle, Eclipse, Microsoft Visual Studio 2010.

4. Project: IT care and Helpdesk

IT Care and Helpdesk enables the employees to create and log tickets related to any problems/issues they have. On the other hand another application for the Helpdesk Team is developed to trace these tickets and respond.

All the information collected has to be entered into a database on a monthly and quarterly basis. This data is used to generate participation and monthly/quarterly reports in PDF and Excel format.

Job Accomplishments:

Involved in the Database Design of the application, table creation, stored procedures, etc.

Wrote several uses cases, design of classes using Rational Rose and UML.

Requirements gathering from the client.

Performance Tuning of the application by fine-tuning the SQL queries.

Involved in Unit Testing, System Testing and Integration Testing.

Created user documentation for the application.

Handled 4 months of post live support.

Technologies used: Java, HTML, CSS, Java Script, Eclipse2.0, SQL Server 2008, Rational Rose.

Contact this candidate