SUMMARY

• A Software Engineer wif overall experience of 20 plus years. Expertise in application design, database design, development, testing, implementation, and administration of Cloud, WEB, E - Commerce, B2B applications and GUI client-server applications.
• Have a long track record of delivering complex projects wif a global reach. Able to manage the project delivery through entire life-cycle. Excellent interpersonal skills. Have relevant industry experience in retail, manufacturing, banking, assessment, health care, medical device and financial brokerage.

TECHNICAL SKILLS

Operating systems: LINUX, UNIX, AIX, DNIX, Windows, Citrix Terminal Server

Languages: Python, Java, Java Beans, Servlets, JSP, WSAD, Websphere 5.0, JavaScript, HTML, ASP, Netdynamics, Peregrine, C, Power Builder 6.5, PFC, CornerStone 5.0, Korn Shell, CGI, Perl, Expect, Pascal, Prolog, Clips, PCL

Big Data: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Oozie, Flume

Database: MongoDB, NoSQL, Oracle 12c, Sybase 11, SQL Server, SQL, QUEL, POSTQUEL, Dbase, POSTGRES, Rbase, Paradox, XDB, Watcom, Ingres, MS Access

Systems: Sun Solaris, Peregrine Systems, CYBER(380), SUN SPARC, IBM PCs

Ancillary: ODI 11g and 12c, FMW, EMCC 13c, WebLogic Server 12c JetBrains, IIS, Front Page, Tomcat, Visual Interdev, Visual Source Safe, PVCS, DB Artisan, Rapid SQL, SQL Navigator, Ingres Reportwriter, SQL*Reportwriter, SQL Forms, SQL Plus, SQL Developer, PL/SQL, LAN, WAN, Sunview, MS-WORD, Microsoft Outlook, Exchange

PROFESSIONAL EXPERIENCE

Confidential

Principal Technical Support Engineer

Responsibilities:

• Trained in Intermediate and Advanced level ODI 12c, FMW, EMCC and WebLogic Server 12c.
• Analysis and Implementation of Data Warehousing test cases in ELT process using ODI 12c/11g/10.1.3.4/10.1.3.5.
• Developed ODI objects like interfaces, mappings, packages, variables, procedures and scenarios to ensure the successful execution of the data loading process. Used ODI in-built scheduler to schedule Scenarios/Load Plans.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Oracle database for simulating customer environment.
• Installed and configured (Master and Work Repositories, ODI agents). Involved in configuration of Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Load Plans, Scenarios, Filters -based on required condition, Physical, Logical architecture and Contexts.
• Experienced in setting up ODI standalone Agents and J2EE Agents on WebLogic server.
• Worked on smart export/import, migrating the mappings from ODI 11G to ODI 12C. Migrated the packages, scenarios from work repository to execution repository.
• Created numerous Interfaces to load data from Flat files, CSV files, and Oracle tables into staging tables and tan into respective FACT/DIMENSION/Look-up Tables.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Responsible for setting up/administering source and target connections in ODI.
• Provide user support in resolving data/configuration/process issues and apply quick fixes in case of failed ones.
• Supported Oracle Data Integrator (ODI) interfaces between Hyperion systems (Planning and Essbase) and external systems.
• Working knowledge of Knowledge Modules (LKM, IKM, JKM and CKM).
• Involved in configuration of topology, designer, operator navigator, configured models in oracle data integrator in order to reverse engineer the database objects.
• Implementation of security using Roles, Privileges, Grants, and Views.
• Extensive experience in developing the load plans, packages and job scheduling. Good knowledge in installing ODI11g, ODI12c and to create Master and Work repositories in different RDBMS products like Oracle databases on different platforms like UNIX, Linux and windows servers.
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
• Extensively involved in production issues. Keep customer informed on issue resolution progress.
• Trouble shoot the ODI connections in regard to JDBC, Network, TNS listener, Database logs, LDAP, SVN, GIT and DNS entries. Did error analysis for continued improvement by catching data anomalies and code issues.
• Researched various ODI issues to resolve complaints. Provided workarounds and outlined solutions outside of ODI.
• Worked customer through step by step process for troubleshooting ODI issues as well as in installation and upgrades.
• Resolved ODI related issues faced by the team members.
• Level headed and calm in stressful situation wif well-developed technical and people skills.
• Maintain composure, courtesy and patience in face of difficult customer. Build and maintain successful relationships wif customer.
• Achieved consistent ranking in monthly metrics, including call duration and customer satisfaction ratings.

Confidential

IT Head / Program Manager

Responsibilities:

• Defined business requirements, wrote design specifications, set timelines and implemented identity management solutions at client sites.
• Wrote Java and Python components to integrate client systems wif LDAP and meta-directory products.
• Maintain and develop new features for comprehensive Python codebase dat supports over data properties wif content management, data management features, and front-end features.
• Created Python back-end to provide data to web front-end.
• Good understanding on NoSQL technologies like Couchbase and Mongo DB.
• Introduced MongoDB for a storing large amounts of data for background processing.
• Based on business requirements designed the Mongo Documents/Collections.
• Involved wif creating shards, replica sets, monitoring, and projections for Mongo Systems.
• Wrote services to store and retrieve user data from the MongoDB for the application on devices
• Wrote software in Python to monitor Mongo.
• On a daily basis, monitoring Mongo and MySQL (nagios, and MMS), setting up new systems, trying to debug why database queries are slow (MySQL and Mongo).
• Cluster maintenance, adding and removing cluster nodes, cluster monitoring and troubleshooting of Hadoop log files.
• Loading/processing Data on Hadoop clusters from Structured/Unstructured Data and conducting POCs.
• Installed and configured Hadoop Map Reduce, HDFS and developed multiple Map Reduce jobs in Java for data cleansing and preprocessing.
• Involved in loading data from UNIX file system to HDFS.
• Installed and configured Hive and also written Hive UDFs.
• Analyzed large amounts of data sets to determine optimal way to aggregate and report on it.
• Responsible for building scalable distributed data solutions using Hadoop.
• Handled importing of data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS.
• Extracted the data into HDFS using Sqoop. Analyzed the data by performing Hive queries and running Pig scripts to know user behaviors.
• Collaborated extensively wif Technical Managers, Network Analysts, Department heads and subject matter experts to deliver project wifin time/cost estimates and of quality dat meets standards.
• Achieved successful on-time and wifin budget to support the core activity of Hospitality industry by identifying the need, proposed and implemented a data storage strategy; directly resulted in an annual saving of $100K.
• Collaborated extensively wif Operation heads and Senior Management on initiatives to meet and /or exceed financial goals, SLAs and overall customer expectations.
• Generated high-level monthly metric reports geared to reflect monthly budget positions, day to day system performance and operational support in an effort to sustain continuous improvements for ongoing major projects.
• Played integral management role in development and executing of several key organizational initiative such as staff augmentation, Framework integration and Business developments.
• Leveraged every opportunity to motivate both operations team and management staff; greatly boosted morale and team focus.

Confidential

Principal Software Engineer

Responsibilities:

• Development and Implementation of Network Intrusion Mitigation system.
• This system relies on a commercial intrusion detection system to alert it dat an attack is underway. It tan can automatically locate the source of the attack and shut down the switch port it is connected to and remove the MAC address of the source from the appropriate DHCP servers. It also provides the ability to segment the network and/or suspend traffic on a protocol port being used by particular virus. It is a menu driven application which based on user input dynamically generates and deploys the mitigation configurations on Fidelity’s router in a multithread fashion.
• This system was developed on Linux OS using Websphere 5.0, JSP, Java, Perl, Expect wif Oracle database as the backend.
• Worked on a team to come up wif a process to detect total number of servers wifin Fidelity enterprise. This information was reconciled against Asset Center Inventory database to look for any discrepancy. Network tools like Foundscan, Ciscoworks discovery protocols, Nmap and Adlex, were used to accomplish this.
• Involved in the Design and Development of migrating the current Netflow system to Peregrine Service Center to become part of Fidelity integrated Infrastructure Management environment. Netflow is a service request/work management application dat is used to process and track the provisioning of telecommunications services. Specific modules wifin the application process Task Management, Project Management, Asset Management and Reporting. This application saves time, provides visibility, allow performers to automate everyday operations and provide enterprise-wide views of assets and integrate wif other application in the Fidelity network.
• Development of Business data objects & Business Services using EJBs, servlets and java classes. Developed both Entity and Session Beans. Entity Beans consist of items whereas Session Beans comprise the transactions. All transactions are maintained by bean-maintained transactions but persistence is maintained by both container and bean methods. The application was developed using Java, JSP, JDK 1.2.2, IBM Visual Age, Netscape Enterprise Server and IBM Websphere wif backend as Oracle.
• TDS is a process and configuration management system dat allows Fidelity to engineer, provision, and manage a continuously available network. TDS is based on the Visionael Studio of software.
• Products dat design, document and manage enterprise telecommunications network. Duties include Application support, UNIX, Citrix and NT System Administration, environment setup and configuration, software installs, coordination and incident resolution and system initiatives.
• Designed the ETOPS - Generic Web Order Entry database which captures customer request.
• Information needed by the field engineers to perform the work, product specific detail information and tan routing the order to the appropriate personnel. The application was developed in ASP as the front end and Sybase as the backend.
• Worked as a Technical Lead in the Server Transition project which involved moving the current applications of BTS group from unsecured Dell environment to secured Datacenter Compaq environment.
• Responsibilities include configuring the IIS, webhosting different applications, Adding front page extensions, giving access rights to developers, pushing content from Front Page and Visual Interdev. Installing SSL certificate, Creating DNS entries, Configuring Oracle and Sybase client, Loading and tuning Netdynamics environment.
• Worked as a Project Lead in the development of Circuit Order Tracking System application dat is used to enter circuit order information dat is required to place orders wif vendors, track status and confirmation information to facilitate the implementation and on-going maintenance of installed circuits. COTS provided an inventory of all currently installed circuits wif location and billing information and BTN repository. This system was developed in two part one part using client server Power Builder 6.5 and second part was web based using three tiers - Visual café Java as the front end, middle ware as Netdynamics and Oracle as the backend.

Confidential

Senior Consultant

Responsibilities:

• Designed and implemented Client Control System for (Seagate Corporation). This system was for an added security for all the overall application which had his own inbuilt security. The system checks for application and database versions. Keeps track of the logon and logout time. It removes the hung session from the server.
• Design and development of a time tracking and billing system for (York) consultant’s time and expenses. This system was used for generating billing work sheet, invoices for clients, storing clients project details, budget information and purchase orders. This full cycle project consisted of project scope definition, risk assessment, high level design wif a use case approach, a fully object oriented detail design using UML, a Microsoft SQL Server relational database and implementation in Symantec Visual Café Java. The system developed used features like Swing, Java Beans, JDBC and JDK 1.1.
• Technical Lead for the design and development of client/server based Assessment project for (York) for evaluating its employees. The Assessment process allows for capturing information on Behaviors and Competencies, Participants who are being assessed and Respondents evaluating the participants. The system had the capability of generating questionnaires, collecting responses, scoring participants, generating feedback reports, and maintaining standards. The Assessment tool was implemented using PowerBuilder 5.0.3 PFC wif CornerStone 5.0.11 and wif backend Sybase SQL Anywhere 5.5.01.
• Participated in the evaluation of Customer Set-up and Billing applications for a Fortune 500 Fraud Detection Financial Institution (Deluxe Corporation). The goal of the evaluation was to determine if their current system met the business requirements of the Verification RFP, and if they did not meet the requirements what modifications would be needed and an estimate of the effort. The findings of the analysis was used as input to a decision on doing further detailed analysis on modifying the current system versus other options such as vendor-supplied solution or custom built solution.
• Member of a team developing a customer and device tracking system for a major Fortune 500 medical device manufacturer (Guidant). The application built provides medical records information to the entire organization and is responsible for supporting the company’s FDA compliance commitments. The application supports gathering, storing, maintaining and reporting on medical records data to enable the tracking of manufactured devices, the patients, the physicians, and facilities surrounding their use, from shipment to return. The critical component to the system was integration wif, and data replication/conversion of, and migration effort to move all regulatory assurance and support applications from the mainframe to a client/server architecture. The project, based on newly reengineered processes, involved the entire lifecycle from Requirement gathering, Analysis and Design, Detailed QA review, Coding, Testing, implementation and extensive documentation. This mission-critical client/server application was implemented using Ingres RDBMS, PowerBuilder 5.0, C and UNIX shell scripting on a SUN platform.
• Responsible for Design and Development work for a Tracking Group subsystem, which involved generating reports for tracking devices in case of recall. The report would include the patients names who had dat devices, the implanting and follow-up physician, the facility where the implant was done and the sales rep information who sold the device.
• Developed non visual user object which can be referenced from anywhere in the application for rule validations.
• Involved in logical and physical design needed to modify device tracking system’s access to salesrep information. New access and view modules were written to access the sales rep information from the SAP system.
• Did database administrative work like modifying table, copying table, writing various rules and procedures for inserts, updates and deletes of record from the table.
• Enhanced the existing PowerBuilder PFC framework library for a storage system for a Health Care Facility (Mayo Clinic) for speeding up development work. Built generic window having capabilities of Master/Detail, generic static hierarchical data relationship, Added features to single datawindow and multi datawindow so dat descendant can be inherited from the ancestors.
• Did support, modifications and enhancement for SMART system dat contained modules for data entering components, setting of parameters, regression testing and quality analysis for building the devices.
• Developed screens using Oracle SQL*Forms 4.5.

Confidential, CA

Software Consultant

Responsibilities:

• Presently involved in maintenance of banking branch Automation package for Citibank. The duties include writing shell scripts (korn and Perl), Pinnacle Plus and C code for performance testing and System Administration purpose. The Operating systems is DNIX (a real time OS) on an Olivetti hardware.
• Wrote C code for configuring parameter to network standards. The parameter included controlling netman buffers, window size, cdserver, macpad etc.
• Wrote shell scripts (Korn-shell) for distributing workstations load on DNP's (Olivetti hardware), at the same time taking care of Laser Printer, Doc Printer, and Embosser connected to the workstation.
• Wrote scripts to test system drivers used to automate the process of entering data into records in a database. The database maintained is dat of a simulated CITIBANK branch consisting of four servers and seventy workstations.
• Did performance testing, Bench marking and check pointing of upgraded software’s.
• Responsible for building and maintaining the Open Systems Pilot configuration.
• Responsibilities included security systems research, incorporation and integration of new software packages.
• Wrote software utilities and loaded on the network to be used by field engineers during installation.

Confidential, New York

Programmer Analyst

Responsibilities:

• Developed a customized payroll package for weekly payroll.
• Report generation of monthly payroll taxes.
• Developed an accounting system which handles accounts payable, receivable and inventory.
• Developed a Call maintenance system for customer support department in XDB wif front end user interfaces using Power Builder2.0. The system consist of a data file dat will store the date of call, the customer name, area of call, customer description of the problem, the name of the engineer assigned to solve the problem, and the status of the call. The system maintains a daily call register and produces a daily summary report of the call status. Used MDI frames wif micro halp for online reports.
• Data Entry Screen wif Dynamic Data Window Creation for adhoc query. Used other features like user object, menus, functions, and structures.

Confidential, SD

Graduate Assistant

Responsibilities:

• Designed and developed menu driven database in C for faculty members to maintain the records of students.
• Implemented a prototype distributed database using IPC on UNIX for bank transactions.
• Installed and implemented Postgres RDBMS on SUN SPARC for Departmental Store Application.
• Wrote a program in C to perform database operation in parallel, on a hypercube simulator.
• Developed a Back Propagation Neural Network on SUN for cloud classification.
• Restoration of blurred images using restoration techniques on SUN Workstation using C and UNIX.
• Developed a Knowledge based backward chaining Expert System for weather forecast using Clips version 4.2.
• Reconfigured the Kernel, Maintained the files, Disk space usage, Installed peripherals.

Confidential, New York

Technical Support Engineer

Responsibilities:

• Maintained PCs, installed hard disks, modems, printers, memory expansion cards, and installed software packages.
• Training and Tech support to customers and sales team.
• Production and Quality Control.

Confidential

System Analyst

Responsibilities:

• Developed an invoicing package in C. The main module was invoicing which goes and collect information based on a key value from the database. The information would be text describing the content wif the price tag. Based on users input the Inventory tables, Accounts tables gets modified. It included features like Status of product, Information and Warning, Payment Structure whether payment received or overdue and Inventory logs. It was also provided wif security password for editing and viewing the different screens based on the user identity.
• Developed customized accounting package, general office information system using C.
• Developed an inventory database system using Rbase.