Hi there! I'mPraveen Kumar Ningappaa passionate web designer and developer. Based in California and always excited to work on new projects
ANALYSE-DESIGN-TRANSFORM
Skill Sets
Programming Languages
JavaScript
Core Java
SQL, PL/SQL
Databases
SQL Server
Oracle 12c
MySQL
DB2
Web Technologies
HTML5
CSS3
JavaScript
ReactJS
Redux
Saga
SASS
SCSS
Node.js
Jest
Karma
Mocha
Chai
Sinon
jQuery
AJAX
Bootstrap
PHP
Velocity
WordPress
DI & Business Intelligence
Talend
Visual Studio
SSIS
Tableau
Qlik Sense
Qlik View
Power Pivot
Power BI
MicroStrategy
Tools and Utilities
Atom, IntelliJ, VS Code
Amazon Web Services
Jenkins
SourceTree
Bitbucket
JIRA
Confluence
Bamboo
Git
NPM
Yarn
Gulp
Babel
Splunk
Postman
MySQL Workbench
Selenium
Catchpoint
OS & Methodologies
Windows
Mac OSX
Unix
Linux
SDLC - Waterfall
SDLC - Agile
Projects
Work Related
Academic
About Me
Are you looking for a young, dynamic and skilled person to take your business to new heights? If yes, you are at the right place!
I'm a fast learning generalist with a remarkable creative and analytical skills. I have excellent design and development skills. I can bridge the gap between technology and your business needs. My decision making and problem solving ability is worth mentioning. Want to know more about me? Just Shoot me an e-mail below! Let's work together!
Main Problem - Most websites have accessibility barriers that makes it difficult or impossible for many people with disabilities to use them. And most web software tools are not sufficiently accessible to people with disabilities, making it difficult or impossible for them to contribute to the web. Solution - Design an User Interface that is simple and easy to use despite user's disabilities. For this, a simple Web application to book Doctor's appointment was Designed and Developed. The processes involved are Customer Interviews, Research, Analysis, Designing, Prototyping, Development, Testing and Evaluation. The Idea was to design a widget that handles all the accessibilty settings of the entire web application. -
Highlights
Created User Group Profiles, Personas and Information Architecture as part of Analysis Phase
Designed basic Sketches & Wireframes which eventually turned into Prototypes
Held Customer Interviews to analyse their thought process while interacting with the UI. A Card sorting Application was used to fine tune the Information Architecture
Followed WCAG Accessibility Guidelines and designed Style Guides for the application
Conducted Usability Testing and performed Heuristic Evaluation on the app
This Website is about creating an online album for a professional photographer. This project aimed at providing the customers, sample photographs such as portfolio and Candid images taken by the photographer. The website has increased business as it is easier for customers to view his profile before contacting. After viewing the photographer’s album a customer can directly contact him by filling out a form and submitting it.
Highlights
Designed web layout using HTML5 and CSS3. Transformed the website to be responsive by using media queries
Performed DOM manipulation using JavaScript & implemented jQuery plugins
such as accordion, navigation, image sliders, and infinite scrolling
Implemented an interactive AJAX live search using XML and PHP
Integrated Google Maps API to customize location and map information on website
Connected the website to MySQL database using XAMPP to retrieve information. Validated form elements with PHP
Web analytics is the measurement, collection, analysis and reporting of web data for purposes of understanding and optimizing web usage.This database design project dealt with the Analytics database. How it is modeled? How the tables are related? What is the data that is required? What data is required to send to the design application? How is the database maintained? What are the procedures for backup recovery and failovers? How is the database secured?
Highlights
Designed Conceptual, Logical and Physical Models for web analytics database system using ERwin data modeler
Identified Entities, relationship types and normalized the database
Created triggers, views, stored procedures and sequences on Oracle SQL developer to perform required actions
Planned the database maintenance by having backup and restore strategy. Ensured database security
The Coffee cup company Ltd. is a startup which aims at advertising on paper cups at coffee stations. The objective of this project was to prepare a budget for this startup company and predict the Return of Investment (ROI) for its potential investors. Based on the budget estimate for the starting year, detailed Financial Reports were generated using Quickbooks online.
Highlights
Journal Entries, Balance sheet, Income statement and Statement of cash flow was prepared
Analyzed performance ratios
Performed Breakeven Analysis to predict the future growth of the company
Project: MultiVin - For identification purposes, all vehicles have a unique Vehicle Identification Number (VIN). But the export and import vehicles from US have VIN as per the US format which is not compatible in other countries. After this project the system was able to handle NON-US VIN formats.
Project: Dragon as a Non-domestic Ordering Hub - DRAGON, a common web-based ordering application, functions as an ordering hub that is used by Nissan North America (NNA) to order vehicles from the new production sources in Korea and Europe. This project was about developing new interface files between the NNA ICON application and DRAGON so that US domestic orders can be transmitted to each new production source through DRAGON.
Project: ABS-AFE Replacement - Project was about modifying Retail and Lease ABS reports to assign and interpret the new 10 - Tier credit scoring structure. Previously the Tiers were from 0-4 for a particular score range. After this project new Tiers 1-9 were added for new score ranges.
Tools and Technologies:
COBOL, JCL, IBM DB2, Endevor, Panvalet, HP Quality Center
Data Warehousing & Business Intelligence
This project mainly dealt with data integration from various sources and visualizing the data using many BI tools. Adventure Works, a large multinational manufacturing company needed Dashboards to analyse its sales and profits. Using OLTP, OLAP, Data Integration and Business Intelligence tools Dashboards were created. These Dashboards helped in making important business decisions.
Highlights
Integrated data from multiple sources such as MySQL DB, SQL Server DB, Excel files, csv files using SSIS and Talend
Designed multi-dimensional data model consisting of Facts and Dimensions with star schema
Performed Error handling and Source to Target mapping
Implemented Slowly Changing Dimensions (SCD), Jobstats and Email notification using DI tools
Researched about the top BI tools available in the market including Tableau, MicroStrategy, Qlik Sense, Qlik View, Power Pivot and PowerBI
Created Dashboards with filters using all the BI tools mentioned and did a comparison of the tools
Clients:
Adventure Works; Contoso
Date:
August 2015
DB Used:
SQL Server, MySQL
DI Tools Used:
Talend, Visual Studio, SSIS
BI Tools Used:
Tableau, MicroStrategy, Qlik Sense, Qlik View, Power Pivot, Power Map, PowerBI
Amazon.com
Account:
Retail Business Services
Business Area:
e-commerce
Role:
Retail Catalog Associate
Date:
Feb 2012 - July 2012
Location:
Bangalore, India
Responsibilities:
Devising the list of inventory to reflect on Amazon website by coordinating with vendor managers
Enhancing the retail selection online to support vendors and buyers by utilizing Amazon’s Retail Systems Platform (RSP)
Managing the content and quality of the information on webpages which impacts user experience
The RBS group is an integral part of Amazon online product lifecycle and buying operations. The team is designed to ensure Amazon remains competitive in the online retail space with the best price, wide selection and good product information. My Primary role was to create and enhance retail selection on the worldwide Amazon online catalog. The tasks handled by me had a direct impact on customer buying decisions and online user experience.
Image Customization Modal
Team:
GoTo Webinar
Business Area:
Software product
Role:
Software Engineer Intern - Web
Date:
Sept 2015 - Dec 2015
Location:
California, USA
Responsibilities:
Requirement analysis
Research
Coding and Unit Testing
System Intergration Testing
Automation Testing
Deployment to live
Branding & Themes page - GoTo Webinar's organizers will have an option to use branding and themes page to personalize their webinar invites. Before this project, the organizer could not upload an image of any size or dimensions using the application. This project aimed at removing all the restrictions that a client-side image upload process had. Using an API a free-size image was converted to required size and dimensions on the fly.
Highlights
Created webpages using Citrix's Html boilerplate and ToGo css library
Researched about Third party API's to perform Image Customization
Implemented a Image Edit Modal feature which is compatible on all the major web browsers
Error handling and support for lower versions of Internet Explorer was taken care
Wrote testcases for this feature using Selenium WebDrivers and TestNG
Channel page - Webinar.com is a platform for G2W organizers to instantly provide their audience with a quick and simple way to browse and consume their best content. Organizers can post all their recordings to their personal channel page and easily share them with anyone, all from one web page.
Channel Grouping - The most highly requested feature based on customer interviews and feedbacks. Early version of the app had pre-defined categories to group the recordings. As the pre-defined categories had limitations there was continuous requests for custom categories. After this feature release, organizers could create their own groups/categories , change the order of the groups, Drag & Drop content between groups, Order the content within groups, Rename or Remove the groups
Learn more page - This page is a goto page for organizers to know more about their channel page, how to build and add recordings to it and how to personalize it by using all the available features. After releasing this feature there was a significant reduction of customer queries on Intercom
Registration Modal - Each and every recording is behind a rigistration modal to help the organizers to know who viewed their recordings. This includes error handling, UI design for different screen sizes, event tracking and logging. An attendee can either register by filling in the details or can SignIn by using Social logins. Registration Report captures all the registration details for organizers
Other features - Domain Change: Moving to a more SEO optimized domain name as part of Large Scale program. Configurations on AWS with help of DevOps to have a smooth transition from channel.webinar.com to webinar.com domain.Whitelisting our new domain with other services. Error state Modals: With this feature, webinar.com organizers will see a customized error message if there are any failures in update calls. The logic works well for all failure calls irrespective of services. Made the code modular & reusable so that it is easy to call the error message with any customized error message.
Default Thumbnail: A pre-state on catalog cards just before the default thumbnail load and a Notification modal for default thumbnail. With this there was an increased number of recordings with thumbnails. About Modal: A goto place for all the new webinar.com organizers to learn about their new channel page. Content Area: A view more view less option to display all the recordings on a particular category if it exceeds max content size based on screen size.
Home Page - One stop shop for all the recordings that our organizers have created. The page is designed in such a way that the webinars are displayed based on user preferences using Machine learning Algorithms.
GoToWebinar Redesign - Complete Redesign of the old webinar Portal with new designs using latest technology. Study shows that our customers love the new UI revamp and adoption rate is more than 70%.
Highlights
Building single page app to populate all the Webinar recordings on to channel page using React - Redux framework
Delivered constant feature releases based on high demand customer requests
Implemented monitoring & logging tools to track exceptions. Used Google Analytics & Mixpanel to track user’s usage data
Performed Web optimization using AWS CloudFront. Lead Domain Name changes using S3, Route53 and other services
Collaborated with UX Research & Design team to interview customers and to develop UI that are user-friendly
