- Twenty years of total experience in Information Technology Industry as a SQL Developer in various phases of software development especially in Design, Development, Implementation, Testing and Documentation of business applications using Oracle and Sql Server Technologies significant experience in Banking, Financial services, Manufacturing and Utility applications.
- Experience with all phases of the Software Development Life Cycle SDLC including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance. Expert Skills in time management, prioritizing tasks. Experience in Agile Working environment.
Platforms : UNIX, Tibco 5.8, TradeFlow, Oracle 11g, SQL Server 2005, DB2 UDB, TCP/IP,
Software : Oracle SQL Developer, TOAD, Oracle APEX 4.1, Visual Basic 2010, PeopleSoft Application Engine, SQL Profiler, SSIS, Datastage, DTS, WinSQL, Cognos, Crystal Reports, MS Excel, Putty, IBM WebSphere MQ, VI Editor,TortosieSVN
Languages : Java 6, .net, Peoplecode, SQR, PL/SQL, T-SQL, SAS 9.1, DB2 SQL, C ,C
Java Script, HTML, XML, Visual Basic.
- Maintained Unix shell scripts to start, stop and execute programs while debugging and troubleshooting system errors.
- Created and modified complex PL/SQL scripts for tables, views, synonyms and Exception Handling using Oracle Sql Developer.
- Dropped XML trades in MQ's and used Tibco to map and post trades to accounting system.
- Debugged and tested Tradeflow enhancements using IDE Fiserv.
- Reformatted and enhanced MT540 and MT542 Swift messages using Tradeflow.
- Worked in Agile environment.
Environment: Agile,Oracle, Tibco 5.8, TradeFlow, PL/SQL,.Net, Cognos, VI Editor,TortosieSVN , Java 6
- Created Stored Procedures, Functions, Packages and Trigger using PL/SQL Programming.
- Used FORALL and BULK COLLECT to extract large volumes of data from oracle tables.
- Created Shell Scripts in UNIX environment to load batch processing data.
- Created and modified various PL/SQL scripts for tables, views, synonyms and Exception Handling using Oracle Sql Developer.
- Tuned SQL queries and optimized sql database using tools like EXPLAIN PLAN, TKPROF and SQL TRACE and HINTS..
- Enforced database integrity using primary keys and foreign keys.
- Used composite data types like ROWTYPE and TYPE.
- Loaded Data from other databases and Flat files into Oracle database using ETL Datastage.
- Created and maintained ftp VB scripts for transaction processing for Gl and Ar systems.
- Created database applications and reports using Apex application developer.
- Created materialized views,fuctions, procedures and packages using Apex query builder and Apex object browser.
- Create Apex triggers for different database tables and application reports.
- Developed authentication and authorization components using java 6.
- Trouble shouts production abends and resolve daily critical processing issues.
Environment: Oracle, PL/SQL, Apex 4.1,PeopleSoft, SQl Server 2010, .Net, C ,Cognos, Crystal reports, VB script, Java 6
- Converted Informix SQL code to DB2 UDB SQL queries.
- Created SAS programs using proc SQL to extract information and generate reports.
- Manipulated and converted data files using SAS Macros for input into oracle system.
- Imported files and created tables using MS Access and SAS data steps
Environment: SAS 9.1, SQL, DB2 UDB, MS access
- Developed and maintained database objects with SQL server 2000 Enterprise.
- Created table and corrupted data base fixes via BIDS SSIS.
- Developed stored procedures to build and import XML files for imaging system.
- Used DTS to import and export data to production tables.
- Developed and maintained system stored procedures and triggers.
- Performance monitored multiple servers take appropriate action when need.
- Created and maintained users using Active Directory.
- Monitored and scheduled daily backups and re indexing of SQL server databases.
- Created crystal reports from customer specifications.
- Created and maintained MS access data base for shipping and receiving clients.
- Developed all access SQL and VBA modules to run system.
- Developed weekly and monthly reports in Access, VBA for customer tracking systems.
Environment: SQL Server 2000/2005, SSIS, DTS, SQL, Stored Procedures, XML
- Worked on lockbox check processing systems.