OBJECTIVE:

Software Developer/Programmer

SUMMARY:

Twenty one years of software design and development experiences which are focused on data processing and data management applications in Relational databases and Data Warehouse systems. Having experiences in all phases of data processing operations, which include data analysis, data loading, data extraction, data transformations, DML operations, batch processing, data Import/Export, data migration, data conversion, reporting, creating data files, and etc. My role of responsibilities are in all phases of application development, which include of receiving, understanding and collecting business requirements, high level and detail level design, coding, testing, deployment, documentations, maintaining existing systems, and handling production issues. I have working experiences with large data and handling performance issues. My major database experiences are in Oracle development, and I also worked with Sybase applications in the earlier years of my career. My major technical strength is in Oracle development using PL/SQL and SQL with UNIX shell scripting. I also have other programming experiences, which includes C++/C, Pro*C, and SAS.

SKILLS:

Oracle: 11g/10g/9i/8i/7.4, SQL, PL/SQL, Packages, Procedures, Functions, Triggers, Views, Oracle Sql - Loader, Oracle External Tables, Pro*C, Sqlplus and TOAD, UNIX Shell Script, Awk, Sed, Unix Syncsort, Cron job,C/C++, Sybase, DB-Lib, Stored Procedures, Funcations and Triggers, isql, SAS 8 & 9 (Base SAS, SAS Macros, SAS SQL).

UNIX Systems: (SunOs, HP, Sun Solaris, System V, AIX), LinuxWindows NT, 2000, XP and 95/98SUN Work Stations, HP Work Stations, NCR Systems, PC Work Stations.

Document tools: Microsoft Office, Visio, FrameMaker

Source control and project management systems: ClearCase, Visual Studio 2010 - TFS - Team foundational Server), ALM, PVCS, CVS, Sablime, and SharePoint

Job scheduler: Control-M, Autosys, Cron jobs

ETL Tools: Ascential DataStage 6.01, Informatica for data mapping and loadingOracle Oracle Developer 2000 (6i) /Forms/ReportsOthers JAVA, HTML, XML, Perl, BEA Tuxedo middleware.

EXPERIENCE:

Oracle Developer

Confidential

Responsibilities:

• Create new extract and export Technician Commmission process
• Create new extract and export Frozen Inventory process
• Create new extract and export Inventory Balance process
• Create new Batch program deployment utility
• Enhance the email utility
• Support change requests

Confidential

Senior Oracle Developer

Responsibilities:

• Product Life Management (for New and End of Life product)
• Allocation (Inventory and distribution)
• Item Eligibility (to build Eligible Items as part of Sales and Forecasting)
• Inventory Dashboard Uploading
• Audit reporting
• Interacted with functional owners to understand business requirements
• Design subsystems to provide the best business solutions in quality and performance
• Coding and development
• Unit and performance testing
• Application deployment
• Design documentations and Testing plans
• The daily development tasks are involved with creating PL/SQL packages and subprograms, writing complicate SQL queries, SQL scripts and Ksh scripts, creating database objects, testing, and performance tunings.

The major technologies are used for the application development: Oracle 11g, PL/SQL, SQL, Oracle External Tables, UNIX, and Ksh scripting in Hadoop and JDA environment.

Oracle Developer

Confidential

Responsibilities:

• Working on Data Warehouse and Real-Time Replication systems to create new Data Warehouse data loading and Replication applications, implement system enhancements, perform system migration, and handle production issues using Oracle 11g/10g PL/SQL, SQL scripts, Unix shell scripts, and Control-M jobs.
• All the projects require the full software development life cycle, which includes requirement, design, coding, unit/integration testing, and production deployment phases.
• The part of my responsibilities was to switch links and to participate integration testings on the new server.5).
• Production support and handling production issues and fixesIn turn to support data warehouse and replication systems (24/7) and handle and fix production issues.

Oracle Developer

Confidential

Responsibilities:

• Oracle development for Confidential applications using Oracle 11g, PL/SQL, SQL scripts and Unix shell scripts.
• Write PL/SQL package, procedures and functions to extract and transforming subscriber marketing data from analytical DB to load into staging tables
• Write PL/SQL package, procedures and functions to use staging data to update subscriber marketing dimensional table using slow changing dimension table techniques.
• Implemented AI IRDB Import/Export model to load data into Prevalence and Spotlight databases in Bi-directions.
• Write PL/SQL package to perform import/export tasks. The procedure and functions are generic to handle both sides of import and export (creating parameter files, validation, and pre-post import, and etc.)
• Write generic PL/SQL procedures to extract customer addresses from subscriber and house tables to load home address tables to support address matching and append process.
• Write SQL scripts, DDL scripts, create synonyms and Unix shell scripts to support above Oracle development tasks.
• Fix production issues.

Oracle Developer

Confidential

Responsibilities:

• Design and build LPS Confidential Migration Loan Origination process, which supports the vendor company to migrate their system from Confidential to Confidential platform.
• The LPS process extracts loan data from TRINITY database to create feeds and transmit to Loan Servicing company.
• The system has been designed in a generic interface for data dumping, creating outbound feeds and files transmission, and so forth.
• The process gives restart capability at any stage of failure.
• Implement Philly data migration programs, which support migration process from Confidential to PHH morgage loan system.
• The programs load PHH data files into staging tables using SQL-Loader and then perform DML operations on TRINITY DB loan tables using PL/SQL packages, SQL scripts and Shell scripts..
• Adding Private banker module into TRINITY database. To populate private banker data using both incoming feeds and internal data to load and updateTRINITY database.
• Modify Provider module and populate provider data to load and update TRINITY database.
• Implement Interleaf Replacement to create correspondence loan documentations for MSCC through MRG system.
• Implement Name Change project in both front end and back end.
• Modify FID loan extract file and create output feeds.
• Data analysis and reporting on customer data (Phone, employment, telecommunication, and etc) and provide programs to fix customer data issues.
• Implement work requests and bug fixes
• Handling production issues

Oracle Developer

Confidential

Responsibilities:

• Design and implemented new billing modules:
• Net Conferencing Storage usages
• Net conferencing credit adjustment for storage usages
• Invoice feed for International financial data
• Design and implemented bug fixes on existing systems using PL/SQL packages, procedures and functions
• Did data analysis using SQL queries
• Handling production issues
• Documentations on all above
• High level and detail designs
• Unit and system testing plans and results
• Data analysis
• Problem investigations

Oracle Developer

Confidential

Responsibilities:

• Designed and implemented PSUR Supplemental Analysis Reports using PL/SQL package (by drug and time range) and SAS program
• Designed and implemented SQL queries to create Adverse event data errors reports (in 35 data categories) to support the Daily and Summary Cleansing tasks for Adverse Event Database
• Design and implemented Caviar System performance analysis using PL/SQL package. The process will give high and low peak of Caviar users using the system by a given time frame.
• Designed and implemented Clinical Signaling Non-Adverse Events Reports using SQL queries and SAS program
• Designed and implemented Special Patient Population Reports (14 patients categories) using SQL queries and SAS program
• Design and implemented Ad-Hoc requests using SQL queries and SAS programs
• Design and implement a new subsystem to provide allocation data feed to reporting process. The process calls SQL queries to retrieve data, then calls Unix, Awk and Syncsort scripts to transform and format data for output.
• Design and implemented PL/SQL procedures and functions to support IDW data validation process.