Professional Summary

• Over 27 years' of experience in analysis, design, coding, testing, debugging, profiling, tuning, deploying, training, documentation, conversion, migration and maintenance phases of serious Client/Server business applications and sophisticated/intuitive/user-friendly interfaces.
• Well versed with Class Libraries, Frameworks, Corporate Layers, Object-Development, SDLC, Test-Driven Development, Data Modeling, RAD/CASE tools Total PowerBuilder experience: 19 years.
• Exposed to Telecom, Investment, Automobile, Engineering, Retail, Paint, Micro-Financing, Oil Natural Gas, Courier, Entertainment, Staffing, Academic industries and Government in the areas of Scheduling, Project Tracking, Budgeting, Forecasting, Order Entry, Accounting, HR, Payroll, Sales, Purchase, Inventory, POS, Awards, commercial database management software
• Seasoned in high quality control with advanced programming techniques, fertile imagination, excellent written/verbal communication and multi-tasking skills. Ability to work independently, in a team environment, under pressure, learn from others, guide/mentor/train others. Self-starter, problem-solver, creative-thinker Quality/standards-conscious and detailed-oriented.
• Can simulate human-intelligence, automate and breathe life into the software with default data values, sane validations, control-focus, color-coding, precise status messages, micro-help, title-bars, toolbars, zebra-striping, dialogs, icons, exception-handling, error-tones, animation, cosmetics

Key Skills

Experience:

Confidential

Senior Software Engineer

• of Execute to open/launch any file with any application or by extension
• Child DataWindows in Composite Reports > Sort, Filter, Copy Graph, etc.
• Strip blank rows from saved Excel file using complex code due to layout flaws in DWs
• Dynamic workarounds when Excel is not installed at runtime in hosted environments
• Save nested reports as a single Excel/CSV/Text/Formatted file, etc
• Array Service -> Add, Delete, Find, Join, Merge, Move, Split, Switch for blazing performance
• Powersoft Report PSR Viewer with various options > Save As, Open, Email, Print, etc.
• Archive Databases -> Connect to any legacy database from within the app to run historical reports
• List, Form DataWindows, Theme Class Data Administration for dynamic deployment
• Dual-tone Themes with alternate header/detail/footer bands, convex, concave, etc.
• Gradients, Transparencies, BorderStyles, Animations, Live Preview
• My Themes, Favorite Themes, System canned Themes, Shared Themes
• Dynamic Application Themes with Point-n-Click administration of themes on various screens, Analytics, built-in Debugger, Incremental Caching for performance, Event recursion, Printing control no data, reset theme, etc :
• Save data as Excel using OLE Automation
• DataWindow Service -> Debug info, DiscardNewRows, SetRowStatus from-any-to-any, IsModified, IsNew, SlideBand with animation, SortIncremental, Switch, Toggle, control arrow/page keys in FreeForm/master-detail, IgnoreScrollWheel in FreeForm, etc.
• Database Service -> Connect, Disconnect, Production dB, Slave dB, Test connection, Check SQL Code, DSN List, IsDSNRegistered, RegisterDSN, Trace, etc.
• File Manager service:
• As Senior Software Engineer, have architected, developed and implemented the following features:
• Secondary/Slave Connection -> To offload traffic from the master dB and also automatic failovers to secondary databases using HA High Availability slave database nodes
• Asynchronous Retrieval of Reports -> With ability to Cancel while retrieval is in progress and simultaneous access to other parts of the application
• Ghostscript installation/setup runtime walk-through for users to Save data As PDF
• Object Info, Debug Info SQL, Stored Procedure , DisableBind for parameter monitoring
• Donations, Donor Level Sets, Dynamic Lists, Triggered Emails Email Marketing Management
• Testing Archtics on Windows 8
• Test Console for developers to debugging and monitoring
• Dynamic Dashboards suggestion to implement widgets, graphs, dynamic SQL, Teradata, etc.
• Currently working on asynchronous cancellation of Tickets posted for Resale on their sub-system, fixing bugs, etc.

Confidential

Senior Software Engineer

working on the initiatives of AutoMation and Order Entry systems of CarMax's Store Sales Division IT . These systems offer customer maintenance, test-drives, sales, purchases, appraisals, auctions, credit applications, up-selling services/service plans/accessories/etc. These applications are developed using PowerBuilder 12, PFC, SQL Server Reporting Services, Sybase 15, SQL Server 2008, T-SQL, Oracle 10g, PL/SQL, dB Artisan 9, ClearCase 7, HP Quality Center and interact with other real-time hardware systems such as image scanners, gate openers, etc.Mr. Shekar has developed the Unarchive Stock screen in AutoMation with ability to batch-process stock using manual input or from large Excel data files and executing stored procedures that do all the heavy-lifting. CarMax archives data periodically and needed an intuitive interface to unarchive data. Mr. Shekar incorporated the ability to save/open/merge data files, search, highlight, auto-refresh, unarchive, etc giving users full mission-control. He automated features that enable users to put the Unarchive screen on auto-pilot mode with rinse-n-repeat the actions for various users/locations saving thousands of man-hours every month. He is currently working on the Order Entry system, developing slides/steps for Customer, Driver License Scan, Checkout, etc for Customer and Sales work-flow wizards using Agile with Scrum methodology story board, sprints, backlog, impediments, ready-to-start, work-in-progress, completed, testing, deployed, standups, burn downs, etc . Mr. Shekar is also involved in interacting with the end users heavily, communicating with the team members and the management. Team-size: 7.

Confidential

Senior Programmer

Development Tracking System DTS and Customer Information System CIS of the Water Utilities Department WUD . He was also involved with the merger of DTS-CIS efforts. CIP is the WUD's project-management system dealing with projects/contracts/authorizations/permits/etc while DTS is a legacy system dealing with plans/ agreements/lots/etc being merged with the CIS. These applications were on PowerBuilder 10 being ported to PowerBuilder 12 , PFC and Oracle 10g and PL/SQL.Mr. Shekar has developed the Director's Dashboard, several Gantt Charts with ability to save/open charts, generic/reusable Graphs with several configuration options with ability to copy/email and save/open graphs, data-based Bubble-Help System for controls/datawindows/columns/graphs, etc. He has worked on removing, extracting, transforming and loading data from the legacy DTS application writing backend procedures, writing to temp tables, generating discrepancy/mismatch/scoring reports to furnish them to users to reconcile/resolve. He created several complex reports, custom graphs for data-dashboards and wizard interfaces. The reusable Gantt Charts and Graphs he created offer historical-comparison features and can be placed on any window or userobject with minimal code. Team-size: 9.

Confidential

Application Developer

worked on the ClassMaster application at Palm Beach State College on PowerBuilder 10, PFC, SQL Server, T-SQL, SQL Server Reporting Services, Access, PantherNet, Ingeniux. also maintained departmental Web pages, gathered analytics, dealt with online vendors, offered user-training, created graphics, managed blogs/forum/wiki, implemented automation at various levels to reduce data-entry to zero, suggested improvements in software and procedures to reduce redundancy and enhance productivity.PBSC uses PantherNet a commercial application to track students, instructors, classes, etc. However, the management was unable to generate the kind of reports they were looking for through PantherNet even though it stores a plethora of data. The new ClassMaster application uses SQL Server views on existing tables, re-use as much of data from PantherNet as possible, store custom data in separate tables and generate quality-rich reports dealing with campuses, buildings, rooms, courses, classes, instructors, students, departments, categories, etc. Mr. Shekar developed the Manager's Dashboard, Financial Statements, forms, reports and graphs for the Provost, Manager and Coordinators. Further, Mr. Shekar created reports in SQL Server Reporting Services, hosted them on the Intranet and scheduled them to be automatically delivered by email to the team everyday at 8 AM.

Confidential

Software Engineer

worked on various client-projects for including State of using PowerBuilder 10, PFC, Oracle 9, Sybase Adaptive Server 12.5, PVCS and TOAD. Also, he has been working on his own project MATRIX Explorer a database explorer developed on PowerBuilder 10, PFC, ASA 8. He owns the US Copyright Registration for the work and Trademark Registration for the title. MATRIX Explorer is a DBA/Developer/User power-tool that enables us to explore, manipulate, create, alter, manage and administer DDL/DCL/DML various RDBMS in a GUI interface supporting direct and concurrent database connections. It is an alternative and similar to SQL-Navigator, TOAD, dB-Artisan, Rapid-SQL, etc. Team-size: 1. Screen-shots at: