SUMMARY

• Information Technology Professional having good hands - on experience witha variety of software and technologies.
• Demonstrated problem solving and analytical skills that helped customers and end users in several business areas.
• Provided leadership in various roles (support, development and dba) and worked in teams of different sizes. Oracle Certified Professional

TECHNICAL SKILLS

Databases: Oracle (SQL Plus, PL/SQL, SQL loader)

Systems: HP-UX, Solaris, IBM-AIX, SunOS, Mac OS, Windows

Languages/Tools: UNIX Shell, Perl, Java, Pro C, Oracle Forms, Oracle Designer, Oracle Enterprise Manager, Oracle Reports, Autosys, PVCS, ClearCase, Informatica, Ab Initio, Microsoft Office (Excel, Word, PowerPoint) TOAD, SQL-Station, SQL Developer, ERwin, Cognos, dSeries, WebSphere, XML

PROFESSIONAL EXPERIENCE

Sr. Software System Engineer /Consultant

Confidential - Warren, NJ

Software used: Oracle 11g, Solaris, UNIX Shell, PL/SQL, SQL Plus, SQL Loader, Perl, Java, J2EE, dSeries, XML, WebSphere, MQ, IBM Data Grid, Lucene, SQL Developer, MS Excel, JIRA, Cognos Reports

Responsibilities:

• Coordinated and performed the application support activities for Mobile Content Solutions applications. The e-commerce system involved catalog publishing, order processing, and provisioning and interfacing with billing system.
• Developed scripts and programs to maintain/enhance application processes and automate the processing of vendor feeds. Created and edited XML for data refresh and for production validation and user tests.
• Provided leadership and support for enterprise releases and production deployments (Agile methodology). Proactively monitored production processes and prevented system issues.
• Interfaced with business and client teams and facilitated the resolution of problems/ incidents in the Operations organization.
• Collaborated with design/development team, QA team, middleware team, database administrators, server administrators and network teams for maintenance and troubleshooting activities and helped to improve system and database performance.
• Implemented technology optimizations, performance tuning and process improvements.
• Generated reports and data extracts, created documents and guided team members.

Sr. Programmer Analyst

Confidential - New York, NY

Software used: Oracle 10g/9i, Solaris, UNIX shell, PL/SQL, SQL Plus, SQL Loader, Pro C, Oracle Forms 6i, ClearCase, Autosys, Perl, SQL Developer, Remedy, MS Office, PVCS, ERwin, Visio, Project, SharePoint

Responsibilities:

• Functioned in a tech lead role acting as the main contact for equity derivatives system applications.
• Developed and maintained application programs for financial applications and enhanced user interface screens.
• Gathered business requirements and prepared technical specifications. Created and maintained use cases and functional requirement documents.
• Performed application database admin activities such as schema creation and maintenance, performance tuning and worked closely with infrastructure teams of data center for troubleshooting and system monitoring activities.
• Coordinated production releases, upgrades, migrations and secure transmission of system feeds.
• Managed production batch problems and incidents and delivered permanent resolution for business user issues.
• Stabilized the applications by identifying problem trends, automating processes and implementing batch enhancements. Generated reports for financial controllers.
• Led the corporate initiative to redesign and deploy packaging of application front end at various user locations.
• Analyzed, coded, tested and implemented the changes required to expand option symbols for OCC’s option symbology initiative.
• Trained consultants and off-shore team to help better understand the system.

DBA/Associate Consultant

Confidential - Piscataway, NJ

Software used: Oracle 9i/8i, Informix, SQL Plus, HP-UX, UNIX Shell, C++, WebLogic

Responsibilities:

• Installed and upgraded Oracle database software and applied patches in various environments.
• Performed general database administration tasks such as schema maintenance, database troubleshooting, and performance tuning.
• Created, configured and maintained Oracle databases used by many applications.
• Coded database monitoring scripts and tuned SQL statements hitting databases.

Software Engineer

Confidential - Edison, NJ

Software used: Oracle 8i/8/7, Solaris, IBM-AIX, UNIX shell, SQL Plus, PL/SQL, SQL Loader, Perl, Java, Sybase, Access, Oracle Designer, ERwin, OEM, LogMiner, Perfstat, RMAN, Autosys, Cognos, Informatica, Brio, TOAD, SQL-Station

Responsibilities:

• Worked as a DBA/back end database developer with responsibilities that included Logical and Physical Data modeling, Star schema design, Installation & upgrades, Creation and maintenance of stand by databases, Maintenance of partitions and materialized views, Data extraction, transformation and loading (ETL) of data into data warehouse, Tuning of SQL and databases, Logical and physical backups, Job scheduling, Database object sizing, Space management, Schema creation, Security and access control, Monitoring of database activity and Troubleshooting.
• Developed shell scripts, anonymous blocks, stored procedures, packages and triggers to perform data validations and implement business rules. Prepared program specifications and assisted with data conversions and database object design.