3121 Placid Springs Lane · Plano, · TX · 75025 · Cell: · 214-498-4638 · shjejurkar@yahoo.com
|
Objective
|
Seeking a challenging opportunity in Data Warehousing area where I can leverage my Oracle and Java experience to successfully deliver business solutions.
|
| | Experience
| e-Rewards International
|
November 2006 - Present |
Java Developer
|
Dallas, TX |
| · | Designed, developed and maintained internal tools for market research panel data collection using J2EE (Apache Tomcat, JSP, JSTL and Spring Framework) and Oracle 10g database
|
| · | Modified existing pages and reports using Perl.
|
|
| Electronic Transaction Consultants
|
August 2003 - November 2006 |
Senior Developer
|
Richardson, TX |
| · | Designed, developed and supported Customer Service Center and Violation Processing Center applications for clients in Electronic Toll Collection (toll road) industry.
|
| · | Developed logical and physical data models using Oracle Designer 9i and implemented them using Oracle 10g database.
|
| · | Migrated legacy applications from Oracle Designer and Web PL/SQL architecture to J2EE (Oracle 10gAS, JSP, Struts) and Web Services architecture.
|
| · | Developed PL/SQL packages for business logic
|
| · | Developed and modified reports using Oracle Reports 10g.
|
| · | Established guidelines for configuration management.
|
| · | Mentored team members during transition from Oracle to Java.
|
|
| Hencie Consulting (Client: Novation, VHA)
|
December 2000 - August 2003 |
Principal Consultant
|
Irving, TX |
| · | Led the technical team for the entire implementation – discovery through post-production support – of Oracle Applications 11i. Modules implemented were Contracts Core and Advanced Pricing.
|
| · | Performed requirements & gap analysis.
|
| · | Analyzed legacy DB2 application data (CDB and PRISM) using Brio Query to define data mapping and data migration requirements. Converted legacy data with over 4 million records.
|
| · | Developed logical and physical data models for custom module.
|
| · | Identified, documented, designed and developed customizations - views, forms, reports, PL/SQL and Oracle Workflow
|
| · | Performed application level query tuning.
|
| · | Provided post-production support and mentoring for client’s technical team.
|
| · | Developed data extraction and transformation processes for enterprise data warehouse and other downstream systems using SQL, PL/SQL and UNIX shell scripts.
|
| · | Used Oracle Application Implementation Methodology (AIM) for all documentation.
|
|
| Hencie Consulting (Client: Vertis Inc.)
|
July 1999 - December 2000 |
Principal Consultant
|
Irving, TX |
| · | Maintained, supported and enhanced a custom job tracking, invoicing and commissions application – using Oracle 8, Forms 4.5 and Reports 2.5
|
| · | Performed some database administration activities
|
|
| Hencie Consulting (Client: Remote DBA Group)
|
March 1999 - December 1999 |
Principal Consultant
|
Dallas, TX |
| · | Designed, developed and supported a web-based incidence logging and maintenance system to log and resolve problem tickets using Oracle Designer 6.0 and Web Server Generator (WSG), Oracle WebDB 2.1, Oracle 8i database server and Oracle Application Server 4.0.8.2
|
|
| Hencie Consulting (Client: Zurn Inc.)
|
December 1998 - April 1999 |
Principal Consultant
|
Dallas, TX |
| · | Designed and developed Rebates and Commissions system for a plumbing products manufacturer as a custom module for Oracle Apps 10.7 SC
|
| · | Prepared the design documentation and user documentation.
|
|
| Rapidigm Inc. (Client: General Engineering Labs)
|
March 1998 - November 1998 |
Software Engineer
|
Charleston, SC |
_ Designed and developed a web-based custom application covering all operational areas for GEL - a environmental testing and analysis laboratory - using Oracle8, Oracle Designer, Oracle Application Server 3.0, Oracle WebView 4.73 (later known as Oracle WebDB/Portal) and Oracle Reports 3.0.
|
| · | Developed design and development standards guidelines.
|
| · | Documented the processes and design using UML in Rational Rose98.
|
|
| TCS (Client: SEBI)
|
January 1996 - February 1998 |
Sr. Systems Analyst
|
Mumbai |
| · | For India's securities market regulator, SEBI, analyzed requirements and led the team that designed and developed a custom system for the Investigation, Enforcement and Market Surveillance department using Oracle Designer/2000 1.3, Developer/2000, and Oracle 7.2.
|
| · | Coordinated quality assurance activities in this and other projects. Generated design and development standards for the project. Represented the project during ISO 9000 certification audit.
|
|
| TCS (Client: EDS)
|
November 1994 - December 1995 |
Systems Analyst
|
Troy, MI |
| · | Customized Information Manager (IMAN) 3.2, a product data management tool that has Oracle7 based repository and Motif based user interface using C, IMAN 3.2 Integration Toolkit (ITK), Motif UIL
|
| · | Integrated Information Manager (IMAN) with Mentor Graphics’ Design Architect and Saber Analysis Tool using C, Bourne shell scripts, IMAN 3.1 ITK, Motif UIL
|
|
| TCS (Client: EDS)
|
February 1994 - October 1994 |
Assistant Systems Analyst
|
Mumbai |
| · | As a member of the offshore testing team, defined and developed test scenarios for Information Manager (IMAN) Integration Toolkit (ITK).
|
| · | Led the project during last half of the project, interacted with the client and monitored the internal quality assurance activities for the project.
|
|
| TCS (Client: Polyolefins Industries Ltd.)
|
March 1993 - January 1994 |
Assistant Systems Analyst
|
Mumbai |
| · | Developed forms and reports in the Finance (Accounts Payable) module for Polyolefins Industries Ltd. - a plastics manufacturing company - using Oracle 6.0, SQL*Forms 3.0 and SQL*Reports 1.1.
|
|
| Tata Consultancy Services
|
November 1992 - February 1993 |
Assistant Systems Analyst
|
Mumbai |
| · | Designed and developed the prototype for a tool that produced C language code from the flowchart using Borland C++ 2.0
|
|
| Education
| VJTI, University of Bombay
|
July 1992 |
Bachelor of Science
Computer Engineering
|
Mumbai |
|
Skills
|
| · | Logical and physical database modeling and design
|
| · | Requirements and gap analysis
|
| · | Oracle Applications 11i
|
| · | J2EE/Java, JSP, Spring, Struts, Ant
|
|
 |
Papers and Publications
|
Top Tips and Techniques for WebDB
|
ODTUG 2000 Conference, Ft. Lauderdale, FL
|
Top Tips and Techniques for WebDB
|
IOUG-A Live! 2000, Anaheim, CA
|
Generating a Knowledge Share System using Oracle Designer
|
SCOUG 2000 Conference, Houston, TX
|
Oracle8i and Oracle Designer: A powerful combination for data warehousing
|
Oracle OpenWorld 1999, Los Angeles, CA
|
Instant Validation with JavaScript and WebDB
|
Oracle Magazine Online (November, 1999)
|
Internal Presentations/Training Conducted
|
====================================
|
Developing Extensible Web Applications Using XML � August 2000
|
Introduction to JavaServer Pages � June 2000
|
Introduction to Systems Development using Oracle Designer � February 1999
|
| |