# Asad Shirgaonkar > Staff Software Engineer at Visa Inc Location: San Francisco Bay Area, United States Profile: https://flows.cv/asadshirgaonkar • 5+ years of experience in software development with an extensive knowledge in Java , Scala and web development. • Hands on experience in developing Service Oriented Architecture - application programming interfaces and distributed systems frameworks with strong Software Development Life Cycle and Agile methodology practices. • Proficient in developing sophisticated communication among servers and databases using RDBMS, SQL, JDBC and RESTful web services. ## Work Experience ### Staff Software Engineer @ Visa Jan 2018 – Present | San Francisco Bay Area ### Senior Software Engineer @ Cerner Corporation Jan 2017 – Jan 2018 | Kansas City, Missouri Area • Core member of Data Extraction Services Team, which is responsible for the design and development of Java Service API, which is intended to retrieve data from Oracle database and return it in XML format to the end users. End users are basically consumers, who built front end application using these XMLs. • Lead a team of 3 engineers in an Agile, Scrum methodology to ensure quality code delivery. • Design, develop best practices and perform end to end testing for building Web based RESTful API services for Cerner HL7 FHIR (Fast Healthcare Interoperability Resources) for retrieving Patient information using JAX-RS (Java API for RESTful Web Services / Jersey). • Design, develop and test synchronous and asynchronous multi-threaded application in Java to improve performance and monitor the health of Cerner’s platforms and systems. • Automating testing using both Test Driven and Behavioral Driven Development in Java (Junit / Mockito / PowerMockito) & Scala. • Monitoring Performance tuning on the Java heap dumps using Java Mission Control and Flight Recorder and analyzing Java Garbage collectors. • Branch and merge code repository for SVN (Subversion), Git & Beyond Compare. • Developed Splunk infrastructure for the team, and wrote Splunk queries that continually monitors Client and Internal server logs and reports if any failure occurs to mitigate any risk. • Participate in peer to peer code review via Atlassian Crucible. • Oversee project workflow, mentor new associates, organize relevant issues and following team activities using JIRA. ### Software Engineer @ Cerner Corporation Jan 2013 – Jan 2017 | Kansas City, Missouri Area ### Software Engineer @ United Health Services (UHS) Jan 2011 – Jan 2013 • Created new processes & maintained existing database processes in an OLAP (DSS) datawarehouse. • Created and maintained ETL Tools, Tables/Views, Triggers, Functions, SQL stored procedures/queries/codes. • Developed and scheduled SQL Server Integration Service (SSIS) packages & jobs to update analytical Database Servers (MS-SQL Server 2008, MS Access, MySQL, Oracle) and extract information. • Wrote complex Adhoc / SQL queries with T-SQL & PL/SQL and integrated various systems using SQL Server Analytical Services & SQL Server Reporting Services to form a data warehouse or data marts. • Built and generated reports using Crystal Reports 2008 & PowerView using PowerPivot and MS Excel. • Extracted data from multiple data sources, transforming them via standardization, data mining, cleaning, data repair & matching and manage all technical aspects of ETL process using SQL Server Integration services (SSIS). • Built a true Dimension and Fact model (STAR / Snowflake) schema for various datawarehouse systems. • Built OLAP Cubes (Dimensional Table modeling) along with MDX queries facts to support UHS in decision making for the Healthcare Industry & Services. • Administered executive dashboard for the OLTP dataflow across the HIPAA compliant hospital. • Created and deployed SharePoint templates, master pages, workflows, sites, pages, lists, libraries, scopes, views, columns. • Trained and assisted the financial & clinical teams to use the Business Intelligence & Development tools. • Developed various web applications across the hospital department using OLAP / OLTP database (ASP.NET using C#). • Performed data replication & off-line backup protection through nightly updates ### Graduate Student @ State University of New York at Binghamton Jan 2010 – Jan 2012 | Binghamton , New York ### Software Engineer @ Atos Origin Jan 2008 – Jan 2010 | Mumbai Area, India • Delivered web development projects from the requirement gathering phase to deployment phase in an ISO 9001:2000 / CMMI Level 5 certified organization which adhered to an Agile & SDLC model. • Reviewed and analyzed Functional Requirements Specifications, High Level Design, Detail Level design and Business Functional Specification document to develop Object oriented design and form the building base for application, which required focused and diligent attention, and has provided me with extensive practical experience. • Built web-based applications from scratch on J2EE platform using client/server & Object Oriented technologies, which has provided me with extensive working knowledge of secure web, distributed & multi-threaded applications. • Developed, documented and reviewed the Database model (RDBMS – Oracle/MySQL) and, at the same time wrote Stored Procedures, Functions, Package Development & Triggers (PL/SQL) and SQL scripts to understand the entirety of the database design. (Constraints, Views, and CRUD functions). • Designed, documented & developed complex workflow functionalities (Registration, Login, Blogs, Forums and many Web 2.0 implementations) for user interaction on the P&G websites which has made me very confident with MVC (Model-View-Controller) application development and apply Design Patterns on them. • Designed & developed the project presentation layer using JSP as front-end, and layer interacting with Oracle 9i and MySQL at the back end. ## Education ### Master’s Degree in Computer Science Binghamton University ### Bachelor of Engineering - BE in Information Technology University of Mumbai ## Contact & Social - LinkedIn: https://linkedin.com/in/asadshirgaonkar --- Source: https://flows.cv/asadshirgaonkar JSON Resume: https://flows.cv/asadshirgaonkar/resume.json Last updated: 2026-04-12