Summary

Dynamic Oracle Expert, Solution Architect, Systems Analyst with 19 years 14 years in experience having strong analytical background excellent communication skills

professional Skills

Tools languages

• SQL, PL/SQL, T - SQL, Java, J2EE
• Oracle Forms Reports, Oracle Developer
• SQL Developer/ Data Modeler
• Stored Procedures, Triggers,
• Erwin, TOAD, SQL Navigator
• XML, CSS, HTML5, AJAX, JavaScript
• Oracle JDeveloper, ADF, Eclipse IDE
• Oracle Warehouse Builder
• C, PHP, JSP, ASP.Net, Dot Net
• Visual Studio 2005/2010

Databases

• Oracle 7/8/9/10/11
• SQL Server 2000/2005/2008
• MySQL, Access, Excel
• Database design / modeling
• DB Constraints, ERD diagrams / schema

Operating systems

• Windows Server 2008
• Windows XP/7/8, Mac, Ubuntu
• Oracle Linux, Red Hat Linux, HP Unix, Sun Solaris
• Oracle virtual box, virtual environments
• Cloud OS, Solaris 11, Azure

Portal middleware

• Oracle Web Center Portal
• BEA WebLogic Integration Portal
• Web Sphere Portal
• WCM Content Management
• Oracle Fusion Middleware
• Cloud Computing
• Business Analytics, Oracle Business Intelligence Suite
• Business Process Execution Language
• Service Oriented Architecture SOA
• Business Process Management BPM
• Identity Management, Apache,, LDAP
• Oracle Application Server
• Oracle Data Integrator
• Oracle Beehive Collaboration

Applications, ERp CRM

• Oracle ERP business suite
• Oracle fusion applications
• Oracle CRM

Industries

• Insurance
• Finance
• Healthcare
• Technology

Standards Processes

• MS Office, MS Project, Word, Excel
• Visio, PowerPoint, UML, flow charts
• Requirement gathering, functional design, Agile, SCRUM, MVC, Wireframes
• J2EE, Web 2.0, SOA, XML, XSD, SOAP, WSDL, Web Services
• Android mobile standards
• Social network trends, Facebook
• Ecommerce Systems, Payments Gateways
• Test Cases, QA, HP Quality Center
• Big Data, Data Warehousing, Database Migrations
• Database System Integrations
• Performance Tuning

Soft skills

• Highly self motivated directed
• Facilitate meetings
• Change management
• Excellent written verbal communication
• Handling customer accounts
• Onshore offshore delivery
• Joint application development JAD
• Rapid application development RAD
• Strong analytical capabilities

Professional Training

• Oracle BEA WebLogic Server Portal
• Oracle BEA WebLogic Integration
• SeeBeyond BPM
• Oracle SQL, PL/SQL
• Database Design, Forms Reports
• Oracle Application Server Portal, J2EE
• Scored 97 in brain bench on Oracle tests
• Presentation skills, business writing, Toastmasters
• Gave training on Oracle courses, Mentored Developers

Professional experience Details

Independent IT Consultant

Solution Architect / Systems Analyst

Responsibilities

• Analyzed, gathered requirements, architected, designed wireframes, mockups, managed delivered android applications for a corporate transport software company JSYSoftware.com based in IL.
• Analyzed, gathered requirements, architected, designed UI mockups, managed delivered cross browser compatible corporate online loan solutions company based in IL being used by more than 300 credit unions.
• Analyzed, gathered requirements, architected, designed, managed commercial insurance related project based on web services, SOA and Dot Net environment.
• Analyzed, gathered requirements, architected, designed, managed an online website / portal related to fashion industry based on latest web standards.
• Analyzed, gathered requirements, architected, designed, managed an online marketing initiative of an healthcare ecommerce. It involves complete web analytics with ecommerce goals.

Environments: Microsoft SharePoint, Dot Net, ASP.Net, Web Services XML, SOAP, WSDL, SQL, MS SQL Server, Mobile development, Android, HTML, AJAX, JavaScript, Cross Browser, CSS, Wireframe, UML, Visio, MS Project, MS Word, Excel, PowerPoint

Confidential

Lead Systems Analyst

Responsibilities

• Led and managed the projects from several point of view the complete successful deployment, time and budget using agile methodology.
• Prepared high level and detailed estimate hours and dollars stating risks and assumptions, work breakdown structure for complete project life cycle.
• Given presentation and mentored business folks, team members, project manager, business analysts and developers.
• Successfully completed several projects within and before schedule as a project manager, business analyst and systems analyst with ability to work on multiple tasks at once.
• Helped and mentored architects to explain the system concepts and requirements, which helped the project to finish on time. Got praise emails and internal Casper rewards for helping others.
• Main contributor in design doc template, standards and several training documents for analysts.
• Taken initiative and lead to implement automated build process when no standard tools were available.
• Technical owner of Anonymous estimation tool . Analyzed and designed UI and mockups in new quote 2, which is and agent website. Created process flow process flow, data flow, and technical / architectural diagrams / roadmaps, sequence diagrams using Visio. Gathered functional requirements, analyzed, documented technical requirements for developers.
• Gathered requirements, analyzed, designed, documented into technical requirements of new features in agency gateway a WebSphere portal for all state agents for all agent related tools.
• Managed, analyzed, design, and implemented an automated workflow system for the environments team so that all requests can be made using the web. this really helped increase developers efficiency by 50 .

Environment: SOA, Web Services XML, SOAP, WSDL, Microsoft SharePoint, Visio, Dot Net, C, MS SQL Server, WebSphere, Oracle, MS Project, TeamSite Content Management System, HP Quality Center, HTML, IIS, Apache, Cross Browser, CSS, UML, MS Word, Excel, PowerPoint

Lead Software Engineer

Salvage Management is the industry's first web based B2B solution that optimizes the salvage process by aggregating and managing the salvage disposal XML messages on total loss vehicles from several insurance companies regardless of salvage vendors via the Internet using web services, MQ.

Responsibilities

• Responsible for overall health of Salvage in production, monitoring 7 24 in BEA WebLogic, J2EE high volume, high interaction, high transaction environment, including setting up and communicating with new customers to implement web services to use our product.
• Conducted meetings with customers like nationwide insurance to get the requirements. Developed UAT test cases and plans to test and validate business requirements.
• Analyzed, designed, developed, tested, optimized, debugged, deployed salvage application in a multi tier, high quality environment using PL/SQL, SQL, Oracle 10g/9i, XML, XSLT, C, ASP.Net, web services. I have written complex SQL queries and developed PL/SQL packages to pull and present data for various business and reporting needs.
• Analyzed, designed the database table structures / schema for online data delivery mechanism to deliver latest files to customer using Mitchell application similar to windows update. developed the XML parsing Oracle database package using PL/SQL, XML to return the result to .net layer.
• Developed and scheduled the PL/SQL report package to analyze the CLOB XML in database to calculate and sum various image upload numbers by vendors. Developed and scheduled overnight MS SQL DTS package to copy data from Oracle to SQL Server database.

Environment: C, ASP.Net, Visual Studio.Net 2005/2003, IIS, PL/SQL, SQL, XML, XSL, IBM MQ, SQL Navigator, Web Services, Oracle 10g/9i, MS SQL Server 2000, Merant Tracker, VSS

Chief Software Architect

Portlet for Citrix on Oracle 10g app server, Sun Portal, BEA WebLogic and SAP NetWeaver portal is a cross platform Portlet which can be deployed to any JSR 168 compliant portal.

Responsibilities

• Facilitated meetings with Citrix stakeholders for Citrix on Oracle 10g app server. Analyzed, designed, developed web applications for hp select identity product for centralized management of user identities and access rights using JSP, JavaBeans, Servlets, and EJB, BEA WebLogic Workshop, MS SQL Server 2000.
• Developed Web services and portal for sun See Beyond financial demo.
• Installed, Administered, Configured Oracle 9i/10g, Oracle 10g Application/Portal server WSRP Edition, BEA WebLogic on Sun Solaris and Windows server 2003 platforms.

Environment: Oracle Portal, BEA WebLogic, SAP NetWeaver, J2EE, JSP, EJB, SQL, Servlets, Java, JavaBeans, D/HTML, JavaScript, XML, XSL, JSR168, Oracle 10g/9i, Oracle Application Server, MS SQL Server 2000, Services, SOA, VSS, CVS, TOAD

Senior Developer

Impresa ERP software consists of a suite of integrated functional components for process management, decision-making and profitability throughout the lifecycle of complex assets like aircraft. scalable web-based collaboration among customers, supply chain partners and multi-site operations.

Responsibilities

• Analyzed, designed, developed Oracle Forms, JSP pages,
• I have written complex SQL queries and developed PL/SQL packages to pull and present data for various business and reporting need in several ERP modules.
• Smart Bench, work efficiency tool-Study, analyzed, documented, developed using J2EE, JSP, JavaBeans, Servlets, EJB.
• Developed UAT test cases and plans to test and validate business requirements.

Environments: Oracle Form, Reports, TOAD, Java, SQL, PL/SQL, SQL, Visio, Oracle, HTML, JavaScript, MS Word, Excel, PowerPoint

Senior Developer

HR Alumni Portal is Lucent ex employee portal for important lucent information and news, look up friends and coworkers, various job benefits.

Responsibilities

• Architected, developed and enhanced,30 database based Web portlets using PL/SQL, JSP, Java.
• Optimized system performance.

Environments: Oracle 10g Application Server, PLSQL Web toolkit, SQL, PL/SQL, Java, Visio, Oracle, HTML, JavaScript, MS Word, Excel, PowerPoint

Sr. Software Engineer

Compound Management System CMS is Robot Automated Drug Discovery web-based application. AKA UHTSS Ultra-High Throughput Screening System AMCS Automated Master Compound Store multi-user, multi-transport used by Pfizer, BMS, Merck and Vertex.

Responsibilities

• Robot Automated Drug Discovery multi-user, multi-transport web-based application based on Oracle used by Pfizer, BMS, Merck and Vertex.
• Architected, analyzed, designed database table structures/erd diagrams, developed, implemented, multiple level tested.
• Wrote complex SQL queries and developed PL/SQL packages to pull and present data for various business need in several modules.
• Developed UAT test cases and plans to test and validate business requirements.

Environments: Oracle App server, Oracle, TOAD, PLSQL Web toolkit, SQL, PL/SQL, HTML, JavaScript, MS Visio, Word, Excel, PowerPoint

Systems Analyst

RSA Revised System Architecture migration project was to effectively migrate and enhance functionality of the system on HP-UX and Windows NT platform. Led mentor team of 4 to design develop 80 new and migrated forms, reports, triggers, and packages.

Responsibilities:

• Mentored team of 4
• Designed developed 80 new and migrated forms, reports, triggers, and packages.

Environments: Oracle Forms, Reports, SQL, SQL Navigator, PL/SQL Visio, Oracle, MS Word, Excel, PowerPoint

Lead Software Engineer

Confidential Administration, Billing and Contract Update System has multi-lingual support, security, administration of users and groups leasing contract management system for Xerox Hong Kong, Malaysia Taiwan. analyzed, designed, developed and implemented for total reengineered ISO 9000 y2k replacement for legacy applications.

Responsibilities:

• Stayed in Hong Kong for several months implemented system in Xerox, Hong Kong. Final bug fixing during user acceptance testing.
• Led team of 5 to develop more than 80 complicated forms, library templates.
• Designed database, ERD diagrams for the whole project. Wrote complex SQL queries and developed PL/SQL packages to pull and present data for various business and reporting need in several ERP modules.
• Library Management system, Purchase Order System, Personal Information System, Inventory Control System Analysis, design, development using Designer 2000, Forms 4.5, Reports 2.5, PL/SQL, Unix.

Environments: Oracle Forms 4.5, Reports 2.5, SQL, PL/SQL, MS Word, Excel