Post Job Free

Resume

Sign in

Project Sql Server

Location:
Santa Ana, CA
Posted:
November 09, 2017

Contact this candidate

Resume:

MILIND KULKARNI 669-***-**** (ac28cp@r.postjobfree.com)

12+ years of Software Development experience in functional areas of Retail, Semiconductor, Maps, Banking, Healthcare, Credit Card, Digital Marketing, Life Science, BI Analytics

Developed applications in Java with middleware technologies - caching, load balancing, session replication, messaging

Excellent troubleshooting and debugging skills, able to analyze code, engineer responsive solutions

Ability to work in a team and an individual contributor, good communication, interpersonal skills, willing to learn new technologies

EDUCATION

Master’s Degree: MCIS, Cleveland State University, USA 2004

Bachelor’s Degree: Engineering, University of Pune, India 1997

SCJP Certification SE 6.0: Sun Microsystems, USA 2008

Diploma in Advanced Computing: CDAC, India 1999

SKILLS

Platforms Linux, Sun Solaris, Windows, Mac

Programming Languages Java(proficient), C++(prior experience), SQL, stored procedure, query tuning(prior experience)

Databases Oracle 11g/10g, SQL Server 2005, MySQL, PostgreSQL, Sybase, SQLite

Application/Web servers JBoss EAP, WebLogic, Tomcat, Apache, Resin

Frameworks/Tools Servlets, JSP, EJB 3.0, REST ws, Hibernate 3.0, Spring, Spring batch, Struts 1.2, Guice, JMeter, SOAP ws,

Mockito, PowerMockito, JUnit 3.8/4.0, Maven 2.2.1, ANT 1.6/1.7

Middleware Infinispan cache, JMS(prior experience), WebLogic load balancing(prior experience), Apache Axis (tcpmon)

EMPLOYMENT HISTORY

Cognizant Technology Solutions, US Architect San Ramon, CA, USA Apr 2016 Till

Cognizant Technology Solutions, India Technical Lead Pune, India Nov 2010 Apr 2016

Persistent Systems Ltd. Senior Software Engineer Pune, India Jun 2008 Oct 2010

DB Concepts Software Developer Woburn, MA, USA Dec 2005 May 2008

Integrated Informatics, Inc. Software Engineer Roswell, GA, USA May 2005 Dec 2005

CMS Computers Pvt. Ltd. Corporate Trainer Pune, India Mar 2001 Aug 2001

CyberMedia Software Pvt. Ltd. Knowledge Base Engineer Pune, India Feb 2000 Apr 2000

EXPERIENCE

Client: Apple Corporation, USA Apr 2016-Till, Sunnyvale, CA

Project Title: POS-Point of Sale

Tools: JDK 1.8, Guice, Gson, JAXB, REST ws, Apache Tomcat, JMeter, Oracle 11g, MySQL, JUnit, Linux

Description: POS is an internal product to facilitate iPhone sell in Apple store worldwide.

Responsibilities: Working on dynamic server pages project to produce runtime JSON from iOS input for next page to display in POS iPhone flow. Worked on JSON serialization, deSerialization for data conversion among iOS-POS-EPT using Gson TypeHierarchyAdapter. Designed workflow, front controller, view parser, view emitter. Identified & solved performance bottleneck cases in dynamic server pages. Test driven code development. Converted central module to use Guice DI & wrote JMeter load testing for it. Demonstrated how character encoding facilitates POSTing concurrent REST requests in load testing. Implemented QR code processing utility used in iPhone flow & web admin flow from a single jar. Implemented generic logger via method interceptor, custom annotations to log simple & complex method parameters, execution time across all modules. Identified correct SQL data type for storing component version data to support multiple geographic region.

Client: Global Foundries, Germany Jan 2015-Apr 2016, Pune, India

Project Title: FabGUI

Tools: JDK 1.6, EJB 3.0, JBoss EAP 7.5, JUnits for UI and DB Layer, Linux

Description: FabGUI provides input to siView system for doing parts conversion of semiconductor products.

Responsibilities: Solved problem of concurrent access to lot in distributed mode during parts conversion using infinispan cache & clustering for 11.9 release. Tuned cache parameters. Redesigned parts conversion code to process one lot at a time in distributed mode for more accurate error handling & error reporting. Designed & implemented reusable EJB component for downloading large excel file with memory constraint on client side. Worked & solved overall technical problems team has faced in multiple supporting applications including exception handling from EJB layer to UI layer, using correct EJB annotations to control transactions, forming JPA queries using criteria builder & predicates Involved in analysis of code quality issues in releases 11.9 & 11.10, and guided team on writing better code. Played a significant role in stabilizing code violations in 11.9 & 11.10 releases. Provided demo for functionalities developed in releases at end of each release cycle. Communicated effectively to client about overall progress of tasks assigned.

Project Title: Catalyst

Tools: C

Description: This project is to upgrade TCL/TK libraries upgrade from version 8.5 to 8.6.4

Responsibilities: Migrated TCL/TK to 8.6.4. Solved technical problems, provided solutions to client during migration.

Project Title: JCAP

Tools: JDK 1.6, EJB, JMS, SOAP ws, JUnits, Linux

Description: JCAP is an intermediate system between FabGUI and siView involved in parts conversion.

Responsibilities: Designed & coded application flows to handle lot processing from EI to Prepackage to OneErpShipment. Used object oriented features to share core logic of lot processing for timer based flow & EI flow with callbacks.

Client: TomTom Inc., India Jun 2014-Dec 2014, Pune, India

Project Title: Cartopia Points of Interest (POI)

Tools: Flex, ActionScript, MXML, PostgreSQL, FlexUnit test cases, Linux, Windows

Description: Cartopia editor display POIs within given longitude and latitude at a predefined zoom level on map. User can view POI attributes, edit attributes, view & edit POI relationships with entry points, road elements & with other POIs. POIs are comprised of 104 different features.

Responsibilities: Developed POI features such as displaying attributes, stacked points (first implementation in Cartopia editor), vicinity-to-vicinity relationship, repositioning on map, deletion of points. Resolved performance bottleneck issues in POI visualization.

Client: BMC software, India Apr 2013-May 2014, Pune, India

Project Title: BladeLogic Server

Tools: JDK 1.6, NSH, Shell Script, Oracle 11g, SQL Server 2008, Linux, Windows

Description: BladeLogic Server provides a comprehensive solution for initial provisioning & ongoing automated management of servers. It consists of functional components such as Application Server, Network Shell, RSCD agent, BLCLI, BMC Service Automation Reporting.

Responsibilities: As a Java Developer designed, automated and tested Database Maintenance (DBM) project. Helped automation team to find out product defects.

Project Title: Remedy Action Request System

Tools: JDK 1.6, WebLogic 10.3.2, Ajax, JavaScript, SQL Server 2008, SilkPerformer, Linux, Windows

Description: AR System provides a single platform for automating & merging business processes. It serves as foundation for IT service management (ITSM). It uses request-centric, form-driven, workflow-based architecture.

Responsibilities: Implemented clustering, HTTP session replication, Load Balancing on WebLogic. Configured session replication in midtier on local and remote clustering machines. Conducted session replication performance test on remote clustering machines. Configured load balancing on remote machines with WebLogic using Apache HTTP server. Resolved midtier defects for version 8.8.

Client: JPMC, USA Oct 2010-Feb 2013, Pune, India

Project Title: Market Data Maintenance Utility (MDMU)

Tools: JDK 1.6, Spring 2.0, Struts 1.1, Oracle 10g, Ajax, WebLogic 10.3.2, Linux

Description: MDMU is a critical tool used by JPMC Risk Management team to diagnose, analyze and modify market data related to various financial instruments. Market data is loaded from various source systems like Reuters, Bloomberg etc. on daily basis for various financial instruments. MDMU provides interface to JPMC middle office users to analyze data, diagnose anomalies and take corrective actions.

Responsibilities: Involved in development, Unit testing, SIT, issue identification and code reviews. Helped team members with their development items and coordinated development tasks among team members. Guided team when synchronization was crucial. Coordinated with testing team for testing and delivery. Simulated JNDI look-up for system objects factory for writing JUnit test cases for DAO layer. Resolved existing bugs from e-Packet module such as displaying duplicate rows and copying comments in source system reconciliation functionality. Resolved database errors due to sequence mismatch. Ensured adherence to code quality through tools like PMD, Check-style, Find-Bugs and organizational processes. Implemented CI for MDMU using Hudson.

Project Title: Equities Market Data

Tools: JDK 1.6, Spring Batch 2.1.7, Oracle 10g, Linux

Description: Market Data (MRI-CMENT) on-boards market data of several types for initial list of instruments and makes it available for MRI CALC Equity calculator usage. The project involves processing on-boarded instruments data for EDG, RDM and Bloomberg data provider. The project does ETL processing for DAILY and HISTORY load data based upon input parameters received from AUTOSYS.

Responsibilities: This project is developed as a configurable framework using Spring batch. Involved in development, SIT, UAT, issue identification and resolution. Created separate interfaces for EDG, RDM and Bloomberg, which are configurable. Found out the way to pass AUTOSYS input parameters to Spring Container to access it at run-time. Provided data filtering functionality as a plug-able component. Improved in INSERT/SELECT SQL query for populating Pricing table data using query hints such as parallel. Involved in testing the application for DAILY and HISTORY load for combinations of thread size, commits interval & grid size.

Project Title: Global Trading Workstation (GTW)

Tools: JDK 1.6, JBoss 4.0, Sybase 12.5, SQL, JPMC proprietary framework for Swing UI development (Flow files), Shell scripting, UNIX

Description: GTW is global front office trading platform for JPMC-IB Equities across US, UK and Asia regions. It provides order management, order routing and real-time risk management. GTW interfaces with external applications/vendor supplied products. Responsibilities: Enhanced middle-tier Mercury code to be in sync with DB store procedure changes for Agency Give-up functionality. Tested and Deployed Mercury code in UAT (tested 1000 events for a day to ensure seamless functionality). Developed newer version of GTW GUI incorporating compliance related market access rules. Tested and Deployed GUI on US, UK, Asia regions in UAT. Wrote shell script to purge data from archive DB server (purging 15 yr. old data).

Project Title: Securities Trade and Reporting Services (STARS)

Tools: JDK 1.6, Struts, Hibernate 3.0, JBoss 4.0, Sybase 12.5, SQL, UNIX

Description: Reports all trades happening with JPMC to trade reporting venues. When new trade comes to STARS, it sends to respective trade reporting venue based upon rules in STARS and then sends an acknowledgement of status of trade report back to source system to complete the cycle. The project is to automate trade search functionality using thin client like browser.

Responsibilities: Designed and coded UI, Controller, Business, Helper, DAO layers of application. Designed logging functionality. Documented UML diagrams and flow diagrams. Added functionality of dynamic configurable query search parameters and HQL generation. Fitted existing tables in hibernate framework and worked with user-defined data types in hibernate.

Client: Yahoo Inc., India Sep 2009-Oct 2010, Pune, India

Project Title: Yahoo-Microsoft Paid Search Transition (MSFT transition)

Tools: Oracle 10g, SQL, KSH scripting, UNIX

Description: The project is used to provide Ad-Hoc data to Microsoft for capacity planning during transition. The data pull involves anonymization of certain data fields, data encryption, pushing data to respective drop-boxes using FTP.

Responsibilities: Gathered and analyzed each Ad-Hoc data requirement. Generated Yahoo’s 1024 bit public and private keys for data

encryption. Handled full responsibility of generation and importing of public and private keys for Yahoo & MS. Used SQL query optimization techniques while pulling the data. Pulled ad-hoc data from RDBMS and flat file database (SAGE). Wrote KSH shell script and scheduled it as a CRON job to provide maximum spend amount data monthly.

Project Title: Partner Management Center

Tools: JDK 1.5, Servlets, ATG Dynamo, JHTML, Oracle 10g, Apache Tomcat 6.0, UNIX

Description: The project is used to allow Yahoo partners to view/download PDF payment invoice statements online for past 12 months. The project works as 2 different Java applications. The legacy code and payment statements download code works on different JVMs.

Responsibilities: Completed POC for downloading PDF payment statements using stats framework (implemented using .PROPS file, HTML templates in Perl). Extended POC to implement complete functionality in Java with session tracking, multithreaded support and logging events. Analyzed new tables to be created to include hierarchy Partner->Contract-> Account->SourceTag in database. Prepared Design document and Data Requirement document. Explored legacy ATG Dynamo build and deployment process. Solved problem of getting logged-in user from legacy code. Solved problem of putting links as per logged-in user role on PMC home page by reusing JHTML code with ATG Dynamo code snippets embedded in.

Project Title: Partner Management Center API

Tools: Mod Perl, web services, UNIX

Description: The project is used to expose external Yahoo partners to web services for accessing reports online. Received appreciation from Time Warner Cable (TWC):a Yahoo client, for resolving their API issue.

Responsibilities: Took responsibility of to push newly implemented changes to production through Change Management Request. Worked on tickets raised related to API production issues. Explored Perl web services code while working on API production issues.

Project Title: Partner Reporting Revamp

Tools: XML, PHP, Apache Server, AJAX, UNIX

Description: The project is used to automate manual task of adding a new partner, creating partner directory structure to add reports to and avoid adding new code when a new partner comes in.

Responsibilities: Implemented user management system, which involves adding user, disabling user access to certain reports, removing user. Explored Expat - an event based and DOM parsers in PHP.

Client: Cognos Inc., Canada Aug 2009-Sep 2009, Pune, India

Project Title: Business User Experience (BUXP)

Tools: JDK 1.6, OSGI, SWT (Standard Widget Toolkit), Eclipse RCP, Knoplerfish 2.3

Description: BI Analytics Project to facilitate downloading and uploading of reports. The project did not advance beyond an OSGI POC. Responsibilities: Implemented Employee Management System using OSGi bundles. Dynamic deployment of bundles on Knoplerfish, Equinox containers. Deployed native code DLLs using OSGi bundles.

Client: National Institute of Virology, India May 2008-Aug 2009, Pune, India

Project Title: NIV Virus LIMS

Tools: JDK 1.5, Struts, Hibernate 3.0, MySQL 5.0, JBoss 4.0, Windows

Description: The project is used to perform various virology tests, store tests results, store specimen, assign specimen to tests.

Responsibilities: Took full ownership of product & stabilized earlier version. Carried code cleanup activities (PMD, CPD). Changed application flow/UI as per client’s requirement. Gathered requirements by visiting with each department head. Conducted demos of newly implemented features at client locations regularly. Built client’s confidence in product, which lead to NIV-Persistent contract sign-up. Conducted users’ training on newly developed features and solved queries during training. Handled concurrent access to selected specimen map using Java’s Lock feature. Deployed stable application at two client locations. Managed 4 resources.

Client: Digitas Inc., USA Oct 2006-May 2008, NY

Project Title: BIRMDW: Boehringer-Ingelheim Pharmaceutical, Inc.

Tools: JDK 1.5, Hibernate 3.0, JUnit 3.8, Oracle 10g, Resin Web Server 3.0.21, TOAD, Linux

Description: Data Warehouse Project to market Pfizer drug brands digitally through Direct Mailing (DM), IVR, and Web channels. Responsibilities: Created and executed SQL tuning task to analyze complex queries. Tuned SQL queries involving complex database operations. Pulled data to analyze effectiveness of marketing campaigns on monthly basis. Pulled data during different stages of a marketing campaign to make correspondence with active consumers in campaign. Used UNIX shell script for large Database inserts (approx. 1 million of records). Used Oracle’s analytical functions, hierarchical query operators while writing complex SQL queries. Modified existing Database schema, PL/SQL code, cursors as per campaign requirements. Used Oracle’s UTL_FILE to write query output to a file on Server. Used SAX parsing to process campaign data in XML format during ETL process. Created XML file containing mixed contents from XSD and parsed it during implementation of Profile Management Center PMC- a new feature added to existing project.

Client: CardinalCommerce Corporation, USA Dec 2005-Sep 2006, OH

Project Title: Cardinal Payment Authentication Platform for issuer (CPAPi)

Tools: JDK 1.4, Servlets, SQL Server 2005, Oracle 9i, Resin Web Server 3.0.21, Linux

Description: The project is about payment authentication by credit card issuing institution. This helps reducing online transactions payment frauds through Username/Password, Challenge Response, and RSA authentication techniques using 3D-Secure protocol.

Responsibilities: Migrated existing application code for Oracle 9i to SQL Server 2005. Wrote Java, PL/SQL code & Database Objects to work with SQL Server 2005. Developed BadBoy Scripts according to test plan for each module in CPAPi for Oracle 9i. Tested migration with BB Scripts to ensure consistent application behavior after migration to SQL Server 2005. Tested connection performance with using JDBC 3.0 for SQL Server 2000/20005 and JDBC 2.2.0 for Oracle 9i. Automated BB scripts using JavaScript, ANT, dynamically generated form and form fields to implement browser back and form submit automatically. Modified/Re-factored common Java code shared by CPAPi, Centinel and Mobile applications. Migrated table Data from Oracle tables to SQL Server 2005 tables.

Integrated Informatics Inc., USA May 2005-Dec 2005, GA

Project Title: Paperless Pharmacy Order Management System (POMS)

Tools: Java swing & applets, SQL Server 2000, Visual C++, Visual Basic ActiveX controls, Windows

Description: The project is used in hospitals for patient medication order processing by pharmacists. It helped turning paper work into paperless work. POMS is browser enabled and used to increase patient safety. POMS works in compliance with HIPAA.

Responsibilities: Implemented file handling and database operations using MFC in existing code to make POMS application work synchronously with other supporting applications. Used proprietary TIFF image processing APIs. Solved memory leak problem while manipulating TIFF images. Developed web based front end using Java applet/Swing and JavaScript, middleware using MFC DLL, VB ActiveX controls and backend operation using stored procedures. Converted existing C code into C++ code to include Database Operations using MFC database classes. Prepared project documentation for POMS Release 5.0. Supported the product 24x7.

CMS Computers Pvt. Ltd. India Mar 2001-Aug 2001, Pune India

Tools: C, Java

Responsibilities: Wrote employee time sheet tracking application using Java, XML and SQL Server 7.3. Conducted courses on C, C++, Java 1.1. Assisted by providing guidance to students’ projects (Database in C).

CyberMedia Software Pvt. Ltd. India Feb 2000-Apr 2000, Pune India

Project Title: Oil Change

Description: The purpose of system is to allow clients to install latest updates for software by logging to CyberMedia’s website. Responsibilities: Wrote Product Specification Files (PSF) and Update Specification Files (USF) to download product updates. Used oil change system to bind these files.

Academic courses: Compiler construction, Assembler, Artificial Intelligence



Contact this candidate