CAREER OBJECTIVE:

Seeking a position of Senior software engineer / Team leader

SUMMARY:

• Over 20 years of experience in software engineering following full Software Development Life Cycle
• Team oriented, highly motivated and able to adapt to rapidly changing conditions and technologies
• Three years of experience in investment banking domain and five years in financial instruments.
• Strong Oracle, PL/SQL, Pro*C/C++, UNIX skills
• Sound knowledge on Oracle server, Database design and Administration
• Good knowledge on Object Oriented Programming with C++/Java
• Experienced in project management and software engineering process modeling tools like RUP/SEI - CMM

SKILLS:

System Design & Development: Requirements Analysis, Design, Development, Coding & Testing, Application Support and Implementation

Languages: PL/SQL, Pro*C/C++, Java, JavaScript, Unix shell script, Perl, HTML, XML

Software & Tools: Toad, PL/SQL Developer, SQL Developer, SQL* Plus, SQL Loader, Confidential -SQL, Autosys, Rational Clearcase, Rational Clearquest, TCL/TK, XRUNNER, IBM MQ Series, Form 6i, Reports 6i, Remedy, Informatica, RapidSQL, DBArtisan, Composite , Aginity , Erwin

RDBMS: Oracle 11g RAC, INGRES 6.4, Sybase 12.5 , Netezza, MySQL

Operating Systems: UNIX, Linux, OpenVMS, X-Windows/Motif

Business Areas: Investment banking, Airlines, Pharmaceuticals, Telecom , Healthcare

Project Management: Project Planning, Effort estimation, Monitoring and Management, Quality Assurance, Client Interaction

PROFESSIONAL EXPERIENCE:

Confidential

Senior consultant

Responsibilities:

• Involved in maintenance of E-ZPass NY software.
• Designed and developed software solutions to meet ongoing enhancement requirements.
• Implemented batch and database solutions using Oracle 11g, PL/SQL, C/C++ and unix shell scripts.

Environment: Linux, C/C++, Oracle 11g, PL/SQL, Unix shell script, JIRA

Confidential, Manassas, VA

Senior consultant

Responsibilities:

• Involved in continuos maintenance of FIN software.
• Designed and developed software solutions to meet ongoing enhancement requirements.
• Enhanced existing application with Oracle's Edition Based Redefinition feature.
• Implemented database solutions using Oracle 11g, PL/SQL, C++ and unix shell scripts.
• Maintenance of test and development environments.

Environment: Linux, Oracle 11g, PL/SQL, Unix shell script, C++

Confidential, Houston, TX

Senior consultant

Responsibilities:

• Development and maintenance of automated reporting system that would help company to monitor and analyze Rig Drilling Performance based on KPIs identified by the Rig Operations management team. This reporting data has been identified as the source to monitor, analyze and track the activities occurring in a Rig while drilling. Involves database software development using MySQL, Oracle and PL/SQL.
• Maintenance and support of the existing software engineering platforms running MySQL and Oracle on Linux environments.
• Interact with business and translation of functional requirements to technical requirements.
• Migration of MySQL applications to Oracle 11g. This involves migration of MySQL db objects and scripts to Oracle 11g db objects and PL/SQL.

Environment: Linux, Oracle 11g, PL/SQL, MySQL, Unix shell script

Confidential, Lansdale, PA

Senior consultant

Responsibilities:

• Customization of ModelN's software product “Revenue Management System” as per the client's requirements.
• Involved in enhancements (J2EE), DB performance tuning (Oracle & Exadata), software build and testing
• Software maintenance and support
• Performance testing
• Interact with business and translation of functional requirements to technical requirements.
• Involved in change management and deployment process
• Maintenance of test and development environments

Environment: Linux, Oracle 11g, Unix shell script , J2EE, Autosys

Confidential, Collegeville, PA

Technical Lead

Responsibilities:

• Developed ETL framework that can automate extraction of data from multiple data source types (Netezza, Oracle, File etc), transform and load to data warehouse in Netezza. Used unix shell scripts, nzload, nzsql, nzplsql, sqlplus etc.
• Did analysis and data modeling to build a new data warehouse/datamarts for storing supplier reporting data in Netezza.

Environment: Linux, Netezza 6.0, Aginity, Unix shell script , Erwin

Confidential, Merrimack, NH

Technical Lead

Responsibilities:

• Batch cycles/jobs using Autosys
• ETL development using Informatica, PL/SQL, Perl and Unix shell scripts, NZPLSQL with heterogeneous databases Sybase/Oracle/Netezza
• Data Modeling using Power Designer
• Application and data migration from Sybase to Oracle and Netezza
• PL/SQL stored procedures performance tuning using Collections, Bulk Collect etc.
• Sybase/Oracle/ Netezza data quality check and certification
• Bloomberg ticker price request-response process enhancement
• SCM using Rational Clearcase and change management using HP OpenView Service Center, JIRA

Environment: Sun Solaris, Linux, Oracle 11g, Sybase 12.5, Netezza 6.0, PL/SQL, NZPLSQL, Confidential -SQL, UTPLSQL, Informatica, Unix shell script, Perl, Rational Clearcase, Power Designer, JIRA, HP OpenView Service Center, Oracle APEX

Confidential, Middletown, NJ

Architect/Technical Lead

Responsibilities:

• Translated functional requirements to technical requirements
• Designed and implemented database objects and work flow
• ETL development using PL/SQL, Perl and Unix shell scripts, Informatica
• Data Modeling star schema, snowflakes schema, Inmon and Kimball, dimension modeling
• Developed and tested oracle packages, procedures and triggers to implement the project
• Co-coordinated UAT
• Technical support

Environment: Sun Solaris, Oracle 11g RAC, MS SQL Server 9.0, Unix shell script, Perl, PL/SQL, Informatica, Erwin

Confidential, Pennington, NJ

Programmer Analyst

Responsibilities:

• Did in-depth dependency analysis for each application. Identified objects that application specific objects uses and used by. Identified shared objects so that when database retires respective applications are modified to resolve those objects to their new locations.
• Identified a couple of design solutions like introduction of middle tier and web services (using Composite)
• Created an Implementation plan and Road map based on best possible solution

Environment: Sun Solaris, Linux, Oracle 10g, PL/SQL, Composite, HTML, JavaScript

Confidential

Senior System Analyst

Responsibilities:

• Involved in software development/enhancement, following complete SDLC, to meet security business needs of the bank
• Developed application in Pro*C/C++ to generate a feed files from FISS containing current day Bloomberg trades and send them to perform automatic Bloomberg-FISS trade reconciliation.
• Implemented JIL scripts to create Autosys jobs
• Implemented a generic PL/SQL package to send emails using UTL SMTP
• Used XML/DTD to interface with MQ series
• Co-coordinated UAT with business users and managed software releases
• Used Rational Clearcase, Clearquest for software configuration management and change management. Used MS project for project tracking.

Environment: Fujitsu PrimePower 850, Sun Solaris, Oracle 10g, PL/SQL, Pro*C/C++, Unix shell script, Perl, Sed, Awk, XML, Autosys, SQL Loader, Rational Clearcase, Rational Clearquest, Forms 6i, Reports 6i, IBM MQ Series

Confidential

IT Support Analyst

Responsibilities:

• Resolution of the production issues within the time frame as per service level agreement
• Propose ideas to improve the process efficiency and quality
• Involve in change management and quality control
• Interact with both internal and external business users to understand the scope of the issues and to guarantee uninterrupted service
• Produce monthly reports with the help of Incident management tool, to higher management

Environment: Sun Solaris, Oracle 9i, PL/SQL, Unix shell script, Perl, Autosys, SQL Loader, Informatica, Business Objects

Confidential

Systems Designer

Responsibilities:

• Worked with Exchange Data Administration (EDA), which is a sub system for Ticker-Quotes System, maintains a large volume of static data in Oracle repository. This updates real time Ticker database that receives real time feed from stock exchanges. Used Oracle 9i, PL/SQL, Pro*C/C++, Forms 6.0 extensively to execute the following projects.
• Software release management and Maintenance of the overall backend applications and processes. This includes development and release of software following the complete SDLC (Using SEI-CMM as the standard). These releases involve components running on VMS and Oracle components in SUN Machine, backend database jobs using Oracle scheduled jobs, PL/SQL packages, Triggers etc.
• Experienced in independently managing projects following entire SDLC. This includes preparation of project plan, requirement analysis, detailed and low level design specifications, development, preparation of test plans and test specs for SIT and UAT, preparation of release notes and after implementation support documents. Co-ordinated with SQA, end-users, developers and testers for carrying out projects.
• Development of Daemon processes (Duration: 12 months)
• Developed daemon processes using Pro*C/C++, that act as an interface between Oracle database (Sun Solaris) and Quotes real time database (VMS). These background processes fetch and process oracle data, convert into required format and call appropriate mechanism to apply those data files into Quotes real time database.
• Auto-Instrument creation project
• Automatic In-Feed Data Maintenance project (Duration: 24 months)
• Administering testing servers and making sure those changes are properly tested before applying to production database. This involves patches/upgrades apart from application related releases. This also involves standard change procedures and coordinating with systems administrator and operations team.
• Daily monitoring of application logs, alert/trace files, cron jobs, backup/export logs and file system space on production system.
• Documenting and testing of backup/recovery and contingency-plan procedures.
• Tuning and Troubleshooting

Environment: Sun Solaris, Oracle 9i, PL/SQL, Pro*C/C++, Unix shell script, Forms 6i, Java, JavaScript, HTML, SQL Loader