SUMMARY

Seeking a database/application developer position in Dallas, TX. Database/application developer with over ten years of experience in database and data reporting environments. Experience in domains including Marketing services, Security Services, Financial, Telecom/Mobile Pharmacy.

TECHNICAL SKILLS

• Language: UNIX toolbox korn shell, sed, awk, grep, etc , UNIX shell, C, SQL, PL/SQL, Pro C, HTML, JaveScript, CSS, JQuery.
• Database: Oracle 10g, 11g, Netezza, MS SQL Server 2008 R2.
• Tools: SQL Loader, Oracle SQL Developer, TOAD, Oracle 6i, 10g Form, Oracle 6i, 10g Report, SQL Plus, SSIS, DTS
• Application Systems: Amdocs Customer Care and Billing System,
• Order Management System OMS ,
• Pharmacy Benefit Management PBM .
• Protocol: TCP/IP, SFTP, CGI, HTTP
• Middleware: Tuxedo, Ethernet, ADO
• Operating System: Unix/Linux, Windows, MS DOS
• Application server: Netezza, Bea Weblogic server.

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

• Wrote a PL/SQL Package to generate daily and periodic claim feed files. Created Active Batch Jobs so that files can be automatically sent to clients on daily basis and semi-monthly.
• Developed a complicate PL/SQL Procedure by using BULK COLLECT, FORALL for HMS project.
• Supported and maintained PBM system, worked on Oracle 6i form, Oracle 6i, 10g report changes and ad-hoc report.

Confidential

Senior Oracle developer

• Worked on Order Entry Service Package and insert job commission stored procedure.
• Modified commission feed to send all resale job request codes as resale transaction type.
• Wrote function to pull customer number for both Admin and MMB MasterMind Business , worked on stored procedure to call the function, modify file to accept the correct format for the converted customers from Admin system to MMB system.

Confidential

Senior Database developer

• Wrote triggers to perform validation on changes being made to tables, tune and optimize complicate SQL queries and scripts that used to generate Report.
• Designed DB tables structure for Security Network Walled Garden project.
• Worked on a project using KSH, Stored Procedure to convert IPv4 to IPv6.
• Tune and optimize PL/SQL package, enhance package, write scripts to execute stored procedure.

Confidential

IBM Consultant

• Analyzed report process flow and automate report.
• Tuned and optimized database objects, complicate SQL queries and scripts for speedy and efficiency in support of data related projects.
• Optimized database and performed code remediation, aligned and adjusted with root cause analysis.

Confidential

Senior Database developer

• Wrote SQL, stored procedure, developed and delivered numerous simple to complex queries of ad-hoc and marketing initiatives for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• ETL development include managed data file, performed data cleaning, data validation loaded data file to Oracle and Netezza database. Move tables between Oracle and Netezza.
• Designed, document and develop a process, wrote korn shell script to generate a report table that will run on Netezza with 4 columns--report date, table name, row count and max update date from 41 large Netezza tables, it also contains all of the standard logging and error handling. This process is capable of re-run each day and automatically count 41 large Netezza tables in 2 minutes.
• Worked closely with business system analysts and client on business requirements and functional specification, provided assistance to other team and client for all business areas to deliver timely projects.
• Participated in code review and provide on-call support on a rotating basis.

Confidential

Senior Analyst

• Provided a long term solution for the existing BAN Billing Account Number exhaustion problem by expanding the number of digit in the sequence from 9 to 12.
• Wrote a program in PL/SQL to provide a feed from the Telegence Billing system to the Horizon commission system for any customers who combine their Cingular Wireless and AT T land line bills.
• Ran all dealer jobs that produce extract files in dealer test environment.
• Used FOCUS data structure, procedures and various UNIX Shells to generate commission feed, extracts and reports.

Confidential

Senior Analyst/programmer

• Provided On Going Support OGS for Order Management System OMS , Customer Service Management CSM application of Ensemble Amdocs Customer Care and Billing System as part of OGS-CSM team.
• Wrote and tested SQL scripts for production implementation. Wrote batch job by using Perl. Created test cases for QA test according to the requests. Created ECD and checked in/out source code through Dimension to keep changes consistence.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server particularly to analyze the performance of the stored procedures.
• Developed process layer and data layer procedures on Unix/Oracle Platform. Created and Implemented procedures transfer business data between database and front-end application Using varies tools such as SQL, Oracle Pro C and C through TUXEDO.
• Performed analysis and research on current production issues. Provided technical solution for any CSM application related issues, including program debugging programming, testing code fixes and coordinating the change release using SQL, Pro C and C.
• Worked closely with other teams such as QA team, table team, SQL, PL/SQL script review team, etc to ensure all critical issues were resolved by timely fashion.
• Provided On-Call support.

Confidential

Software Tester

• Executed test cases by manual testing web-based software products-HP OpenView Select Identity A Context-Based Approach to Identity Management on Java application platform-WebLogic.
• Integration testing on different components such as audit and configuration report, admin function, resource, connector and attribute management for different User Interface in Window environment.
• Loaded test for new application, Set up application and load servers. Validated that the sites and systems meet design specifications and requirement. Create clear, concise detail oriented reports on bugs or quality issues based upon test plans and test cases.
• Reviewed and reports on test case results to team lead, as well as, cross-functional team members regarding any potential quality issues per build/release. Reported defects and verified defect fixes through QUIX Team track tool.
• Participated as part of the team in delivering a high quality product to customers.

Confidential

Developer

• Using UNIX Environment and Shell Scripts, Oracle SQL, Identifying general code issues and data issues. Providing data analysis, design and maintenance for company system.
• Analyzing real estate application. Developing for processing of the inputting, retrieving, updating data such as property's address, date that property were built from business database.
• Participating application processing, testing, investigation and correction of error conditions and verification that processing complies with new standards.

Confidential

Analyst

• Provided system and production support, worked on numerous SERF System Error Request Form and Defect, provided timely solutions to meet market needs using Pro C, Shell Scripts, SQL.
• Developed new functionality for the Client Server based systems in support of Telegence Billing and Customer Care telecommunications products using Pro C, Shell Scripts, SQL .
• Created scripts, shells and Perl program. Developed process layer and data layer procedures on Unix/Oracle Platform. Wrote function calls transferring business data between database and front-end application through TUXEDO Using C and Oracle Pro C, SQL. Implemented function calls to TUXEDO Middleware transferring business data to back-end application
• Provided detail design of system solutions, custom development, quality assurance, documentation, deployment, and production support, this also include business and technical requirement analysis, Transferred business data into table values, front-end and back-end application through TUXEDO Middleware.
• Maintained and enhanced Billing and Customer Care applications, Telegence API. Duties included application processing, coding, testing, test plan preparation, testing verification, program debugging, and development of job flow, implementation and coordination of program releases, investigation and correction of error message or application discrepancies, looked at CSM data layer and verified items that can be used to improve Telegence performance.
• Appointed as manager's first contact to do market upgrade spot check for different versions by using Telegence on-line test.
• Worked closely with Telegence QA team, CC team, ECA group and Amdocs CSM team in Israel etc., to resolve problems, provided On-Call support to application upgrade and market roll-out.