TECHNICAL SKILLS

Oracle Development: PL/SQL development using packages, functions, procedures, triggers, Oracle forms/Reports 6i, SQL Loader, import/export utility and SQL*Plus.

Languages: PL/SQL, C/C++, JAVA, PRO*C.

Scripting: Shell (ksh, bash and csh), PERL, AWK, and SED.

Operating systems: UNIX, AIX, Red Hat Linux, Sun Solaris, HP - UX9.0.

Databases: Oracle, MySQL, DB2, Informix.

Java Development: J2EE, JDBC, Servlet, Applets and NetBeans IDE or Eclipse.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

AML Implementation Support Analyst

Environment: NDM/MQ Setup, Oracle 11G, Red Hat Linux, Shell scripting

Responsibilities:

• Communicate with clients (with environments like Unix, Mainframe, Window) to collect technical details to configure NDM/MQ/triggers for transferring Batch files or Real Time messages to “ Confidential ” application.
• Confidential application checks “sanctioned” names, entities or transactions against regulatory lists, internal Citi lists, OFAC, World Check, Global Sanctions, etc.
• Configure/submit Object Request Forms (ORF) to MQ team to communicate with client’s server for transmitting Real Time messages to “ Confidential ” application.
• Analyze/Resolve issues with MQ connectivity between our server and client’s server by checking MQ logs, System logs.
• Work on NDM setup by editing existing NDM configuration files, NDM utility scripts, adding entries in database tables based on Clients requirements for screening batch files and generating alerts in Confidential workflow (GUI frontend for alert ingestion).
• Communicate with Data management team(CSA) to setup customized ruleset based on Client’s requirements and setup ignore list, local list that is required based on Client’s screening needs.
• On-boarded 25+ new clients to Confidential application for processing Daily/Weekly batch files as well as real time messages (ACH/SWIFT/MTn99).
• Migrated 60+ existing clients with NDM/MQ configuration from Solaris to Linux environment by contacting/communicating with technical counterpart and gathering existing technical details to complete “NDM/MQ setup” in Linux Environment. Conducted UAT testing to get sign off from respective clients to move NDM/MQ configuration to new PROD environment.

Confidential, IL

Senior Oracle Developer

Environment: PL/SQL, SQL*PLUS, Oracle 11g, Unix Shell Scripting, Agile Methodology.

Responsibilities:

• Write business requirements and technical specs for CAS system. Also analyze data, research multiple scenarios for customer rebates and then accordingly design, develop, perform unit testing/integration testing, fix defects that were raised by QA and then implement the code that was written in PL/SQL and JAVA.
• Work on PL/SQL packages, stored procedures, functions, views to calculate customer rebates based on volume, dollar amount and drop size.
• Also generate reconciliation reports for various departments based on locations, divisions and tracking program number.
• Performance tuning of PL/SQL code by analyzing the logic, making PL/SQL statement as efficient as possible and by using explain plan.
• Modified existing logic to use BULKCOLLECT, FORALL, MERGE and WITH clause to reduce the run time while calculating rebates or generating reports.
• Write Shell scripts to run batch processing to call stored procedures or functions and transfer (sftp) reports to various departments or customers.
• Write crontab files for scheduling jobs, and SQL*LOADER control files to load data using SQL*LOADER to staging tables or production tables.
• Work on Production defects for multiple projects that were raised by Business/Quality Analyst.

Confidential, IL

Senior Oracle Developer

Environment: PL/SQL, SQL*PLUS, Oracle 10g, Oracle Reports/Forms 6i, SQL Loader, Shell Scripting, HP-UX.

Responsibilities:

• Write and Update PL/SQL stored procedures, functions to manipulate data in staging tables according to Business logic then to load into Productions tables.
• Extract data stored in a multi-level hierarchy using Procedures and Connect-by-prior clause.
• Performance tuning of PL/SQL Queries using EXPLAIN PLAN or AUTOTRACE.
• Also used BULKCOLLECT and FORALL features to improve performance and use NOCOPY in procedure calls to avoid overhead of copying variables.
• Write Shell scripts to run batch processing, crontab files for scheduling jobs, AWK Scripts to manipulate data in flat files, and SQL*LOADER control files to load data using SQL*LOADER.
• Monitor data flow from public sector clients to our system and provide technical support while loading data into staging tables as well as production tables.
• Develop reports to search home ownership data based on a county that belongs to a state. Also worked on reports based on Driver license data that is being used by DMVs.

Confidential, IL

Senior Software Engineer

Environment: PL/SQL, Oracle 10g, Perl, Shell scripting, XML, TOAD and HP-UX platform.

Responsibilities:

• Work on putting together Business logic requirements, analyze the business rules and write process flow (Flowcharts) of transferring data from clients, massage the data to loading into database.
• Work on analyzing on PERL modules with embedded PL/SQL codes/procedures from the third party that has not provided any documentation on extracting and formatting data.
• Manage to put together the process flow by going through several PERL Modules and PL/SQL packages according to Business rules.
• Rewrite the PERL modules to accommodate new Business rules and split several PERL modules to improve performance and to make maintenance easier.
• Develop ETL (Extract, Transformation, Load) processes on Oracle using PERL Scripts, PL/SQL procedures, Functions, Shell scripts, and utilities such as SQL*Plus, SQL*Loader, import/export.
• Used in house application (written in JAVA) to run modules that extracted and loaded large volumes of data (50+ million records) into Oracle database.
• Coded and executed Ad-Hoc requests using complex SQL, Shell scripts and AWK scripts.
• Develop and implement file sweeper, file checker and data quality checks for highly parameterized environment to configure, execute and restart-ability of ETL jobs.
• Created Test plans for this project and coordinated testing effort with different teams to complete the entire ETL cycle testing (from validating data to loading into tables).
• Resolved issues promptly and provided day-to-day status to management team.

Confidential, IL

Senior Software Engineer

Environment: C++, JAVA, HTML, PHP, PL/SQL, Oracle 9i, Linux, Sun Solaris.

Responsibilities:

• Work on detail Analysis/Requirements, project plans for enhancements and changes based on input from Business Units as well as retail units.
• Facilitate meetings to obtain the requirements and user sign off. Maintain document history to show what types of changes were required each time the requirements were reviewed/approved.
• Work on HTML, PHP with embedded PL/SQL functions to create a front-end for searching, adding and modifying Inventory for 500+ retail stores in OLTP environment.
• Also worked on front-end to create Movie Stock numbers, to create Game Stock numbers, to display details of Movie Information and synopsis to retail clients as well as management team.
• Keep track of data flow from client sites to master site. Monitored the scripts that validated the data, formatted the data and loaded data into Oracle database for reporting purpose.
• Work on Java/J2EE, Swing, Applets, Servlet, JDBC, and Multi-threading programming to develop front-end for Payroll Application, Employee Add/Delete Application, Shipping/Receiving and Rotate Movie Application.
• Develop, debug and test JAVA code using Net Beans IDE.
• Develop (JAVA) customized components like Calendar, Combo Boxes, Tables and Buttons.
• Write code for dynamic loading of Java Classes, event handlers utilizing multi-threads.
• Develop JAVA utility class (print server) that allows printing to LPD daemon and then to chosen printer on Linux, Mac OS or Windows. Used TCP/IP protocols to open sockets and write data for printing purpose.
• Work on C++ and PERL to add new functionalities to Payroll, Shipping/Receiving, Cash Register, Inventory Tracking, Labor Forecasting and Daily Sales Reports.
• Develop code in C++ for Credit Card Processing applications for E-Commerce Division and Retail units.
• Performed check on credit card balance, put hold on a balance for future transactions, keep track of transactions on a credit card and replaced VeriSign with RiTA gateway.
• Implement Point of Sale system in 10+ stores and trained other team members to install POS on rest of 500+ stores. On call support for Payroll application, Invoicing, Inventory tracking, Cash Resister. Duties included as remote login to retail stores, provide knowledge to navigate the several component of POS system. Analyze, detect and fix bugs in several modules of C++, JAVA and PL/SQL.

Confidential, IL

Senior Applications Developer

Environment: C/PRO*C, Oracle 9i, PL/SQL, SQL*Plus, Oracle Forms/Reports 6i, Shell Scripting, TOAD, UNIX and Production Support for billing system with International Zones.

Responsibilities:

• Designed, developed and implemented several billing applications for various different products (Audio, Video) offered by Confidential ’s Conferencing.
• These applications required developing new PL/SQL packages with Triggers, Procedures and Functions.
• Develop code in Pro*C and make changes to existing process in order to support new functionalities.
• Develop Oracle Forms to view order history, to create/maintain billing rate zones, on demand job, conference minute usage activity and government accounts activities.
• Work on Internal Oracle reports for Global Audio/Video conference, Open Order Summary Reports, Billing Rate Zone Reports.
• Created and modified several Oracle Forms for Conferencing Billing teams to be able to create/maintain Net Conferencing contracts and make database updates as required by the Business and Customer requests.
• Providing user access through front end speeded current process by 10 times and prevented repeated source code modifications. The result was- "Quick Customer Service.
• Production support for a very large multi-international Confidential conferencing billing system consisting of ~1000 database objects, a 1.3 Terabyte database consisting of tables up to 500 million rows.
• Roles and responsibilities required monitoring, analyzing, tracking, and validation of processes, system feed-ins from vendors and system feed-outs to internal groups, user request for data clarification, technical support and login issues for database access from international and domestic users.

Confidential, IL

Technical Architect/Developer

Environment: C++, PERL, Shell Scripts, MySql, Red Had Linux, CVS tracker, SUN Solaris and HP-UX platform.

Responsibilities:

• Design C++ Classes and work on C++ with Embedded SQL for Inventory module for Search ability, List ability, and to edit, add or update the Inventory table.
• Worked on stored procedures and triggers to process the Data according to Business Rules.
• Develop Payroll application, Shipping and Receiving Application and Labor Forecasting Applications in C++, PERL scripts and Shell Scripts.
• Write Shell scripts for running batch processes. Created crontab files and worked on Driver Shell script to automate Data loading process from the flat files to MYSQL database.
• Use Perl DBI module to connect to MYSQL database and to access information from different tables.

Confidential, IL

Technical Architect/Developer

Environment: SQL, PERL, Shell scripts, Informix, i2’s OLAP, Sun Solaris.

Responsibilities:

• Architect of Daily, Monthly, Weekly batch processes for FAR on UNIX as well as Mainframe environment.
• Involved in design of Forecast, Assortment and Replenishment (FAR) application, business requirements, data analysis, project planning, walk through of unit and integration test cases as well as code review.
• Also set the standards to develop code in PC, SQL, and Perl for FAR.
• Extensively used Perl to automate batch processing and reporting, to format flat files according to definition of tables for loading purpose, to create dynamic SQL scripts, to extract and transform the data for further analysis or reporting.
• Written SQL scripts with use of stored procedures and triggers to extract the Data according to business Logic and to apply business rules to the Data for further processing.
• Worked on complex Shell script drivers to integrate all FAR processes, to execute Perl scripts. Written Crontab files to run the processes to load data to i2’s Parts Storage Optimizer as well as Demand Planner.
• Written Filters and ADF files for i2’s OLAP database applications. Also scheduled update statistics scripts or purging of data by using Cron utility.
• Involved in Quality Assurance Testing for 28 modules for Unit, Integration and Acceptance testing.
• Monitored batch processes for FAR and system performance. Identified production issues and recommended solutions.
• Educated and trained several team members in overseas team to co-ordinate production support.

Confidential, IL

Senior Developer

Environment: C, DB2, AIX, SYNCSORT Utility, PostalSoft Software from FirstLogic

Responsibilities:

• Involved in the process of Data Conversion for 52 states on multiple servers.
• Converted three years of Data (100 Million records) into a particular format that was accepted by Autoloader Utility.
• Responsibilities included Loading/Analyzing the data into National Vehicle Database that was created in DB2 environment.
• Attended extensive Training in Postal Software from FirstLogic to apply complex Business Rules to Correct and Standardize address components that allows capitalization, abbreviations, assignment or correction or verification of Postal Zip code.
• Received training to customize API’s for Postal Software for merging/purging of unwanted duplicate records, correcting mailing addresses as well as Person’s First and Last names.
• Written Shell scripts to run batch processes and SYNCSORT scripts to sort and to delete exactly same records. Developed C code to read flat files, to clean data and to format that was required by Postal Software.
• Also generated the Error report for the Records that did not pass validation criteria. Written and modified DB2 SQL Scripts to extract the Data that was used for further analysis.

Confidential, IL

Programmer/Analyst

Environment: C/C++, UNIX, Informix, Procedures, Triggers, Shell scripting, AWK, Sequent

Responsibilities:

• Developed ‘Date shift module’ and the test plan for Y2K testing.
• Executed Daily/Monthly batch processes for Y2K Testing.
• Analyzed the Demand/Supply data for three years and studied the business logic to write C++ Classes.
• Created tables with required integrity and developed the C++ code for ‘Group Pricing Day codes’ for 104 hotels.
• Involved in Unit/Integration testing, Implementation and generation of group booking report.
• Analyzed the existing SQL programs, Shell Scripts and C++ code to improve efficiency, better performance with added functionality.
• Responsible for improving data quality, performance, reliability, and maintainability of the pipeline software and process. Responsible for Data Analysis and Data Integrity.

Confidential, IL

Team Lead/Programmer

Environment: C++, PRO*C, GUI (OIT), Packages, Oracle7.2, LINUX, SUN Solaris.

Responsibilities:

• Responsibilities included Scheduling/Tracking Activities, Assigning task, and communicating schedules to rest of Team members. Also got updates from the Team members and reported details of tasks to Superiors.
• Developed and implemented user friendly GUI by using Open Interface tool on LINUX. Developed back-end modules in C++, PRO*C on Sun Solaris.
• Worked on design for Front-end of Point of sale system and implementation of software methodology to the development of the Project tasks/functionality and productions/technical support issues.
• Talked to client (360 Communications) to gather requirements, Business Rules and written High Level specifications to add new functionality or create new process for POS system.
• Also involved in Technical Support for 280 Stores that included carrying pager, cell phone and Laptop for 16 hrs/day.
• Analyzed and designed the classes for Promotional Rates for cellular industry, Phone Inventory, and Seasonal Promotions.
• Used Packages, Stored procedures and triggers to build Billing module for approx. 10,000 customers.

Confidential, IL

Programmer

Environment: C++, SQL, Oracle, HP9000 UNIX, LBMS Methodology.

Responsibilities:

• Analyzed the data from APOLLO and Business rules to design Classes for Demand/Reservation Categories.
• Written HLDs, DLDs, pseudo code, C++ Classes using Standard Template Libraries.
• Involved in code review, writing test plans, unit testing, and implementation.
• Used AWK, SED to write Shell scripts to analyze and research extracted data and to create Data files for testing and loading purpose.