Qualifications Summary
• 4 + years experience in Oracle PL/SQL, UNIX shell scripting, Database Management and Business Intelligence tools
• Good experience in C, C++, JAVA, PHP, ASP, Java/VB Scripting, CSS, Dreamweaver, ODBC Connection, MS SQL Server, MySQL and XML
• Expertises in all phases of the software development lifecycle, operating systems, object oriented concepts and Database Administration
Education
• Master of Science (Computer Science) GPA: 3.7/4.0
New Mexico State University, Las Cruces (May 2009)
• Bachelor of Engineering (Computer Science) GPA: 3.8/4.0
Anna University, India (May 2006)
Technical Proficiency
Database : ORACLE 8i/9i/10g/11g, MySQL, MS SQL Server
Languages : UNIX Shell, JAVA, C, C++, C#
Web Designing : PHP, ASP, Java Script, VB Script, XML/XSLT, HTML,
DHTML, CSS, Adobe Dreamweaver/Photoshop/Flash
Application Packages : TOAD 8.x/10.x, COGNOS ReportNet 7.x/8.x/Framework
Manager/Metric Studio, SCT Banner 8, Crystal Report,
UC4, FormFusion, Informatica
Platforms : Unix/Linux/Solaris, Windows 2000/XP/vista/7
Professional Experience
New Mexico State University, Las Cruces, NM August 2008 – Present
Systems Analyst (Technical Lead for NMSU Financial Aid Projects)
Environment : Oracle, PL/SQL, UNIX Scripting, Cognos, TOAD, UC4, PHP, ASP
SCT Banner, MS ACCESS, Formfusion
Database Management
• Gathering requirements, analyzing and designing data models using ERD diagram and Microsoft Visio
• Creating and altering oracle tables, indexes, primary/foreign key, triggers, grants, roles, views, synonyms, stored PL/SQL packages, procedures, functions, external tables, and exception handlers
• Providing assistance in data conversion from MySQL/MS SQL Server to Oracle
• Troubleshooting performance issues/errors using Explain Plan and TKPROF
• Providing assistance in installing/configuring Financial Aid Off-premise (SaaS) FM calculation (Service-oriented Cloud computing)
• Testing the data mapping and ETL results for SCT Banner student data against legacy system (vista)
Shell Scripting/UC4 (Automation Engine)
• Creating jobs, process flows, dependencies, prompts, schedules for automating Students and Financial Aid process (includes C, JAVA,UNIX Shell scripts)
• Creating Shell Scripts to query/update the oracle table, calling PL/SQL procedures, printing and registering output file in UC4
• Writing complex UNIX scripts, XSLT to import/export files from Federal Department of Ed, encrypting(PGP), manipulating data and loading to Banner
• Developing scripts for file transfer using SCP, FTP, WINSCP scripts, and windows scheduler. Providing assistance in installing TDCLIENT in Solaris
Cognos Report Studio/Framework Manger
• Developing complex list/crosstab reports with prompt pages, drill definitions, jobs, report views, master detail relationships, charts, repeater tables, SQL, packages, cubes and variables
• Troubleshooting and improving the performance of existing reports. Creating and deploying complex packages using Cogno...
Login or Register to view the full resume.
