SUMMARY

• Accomplished Programmer wif over ten years experience in Data Mining and Data Warehousing.
• Designed and developed processing software in batch data extraction, data analysis, and report generation.
• Worked on full life cycle multi - tier applications. Proficient in relational database such as Oracle.
• Solid programming skills in Shell Scripting in UNIX environments.

TECHNICAL SKILLS

Database: Oracle 11g, 10g, 9i, 8i, 8.0, SQL, PL/SQL, SQL Loader, JDBC.

Big Data: HDFS, Hive

Languages: Shell Scripts (csh, ksh, and bash), AWK, NT bat scripts, Perl, JAVA, Servlet, JSP, J2EE, JavaScript, HTML, JCL

Operating System: UNIX (Sun, Solaris, AIX), Windows 7 / XP / 2000 / 98 / NT, Mac 8.0 and 7.5, MVS.

Utilities/Softwares: Toad, SQL Developer, Eclipse, WebSphere/WSAD, SQL Plus, DBArtisan, AXYS, PVCS, autosys, vi, vim.

PROFESSIONAL EXPERIENCE

Confidential, Middletown, NJ

Applications Developer

Responsibilities:

• Preparing monthly actual postpaid and non-postpaid data for mobile devices reports, adjusting Oracle database codings to match teh data.:
• Daily and monthly extracting and processing VoLTE data, analyzing wif varies mappings and generated raptor reports for subscriber and usage histories wif market distribution.:
• Migrating daily and monthly mobility data processing from unix to HDFS/Hive system, setting up monitoring jobs and identifying root problems for various operating issues.:
• Automating daily and monthly data extraction from HDFS/Hive and loading results into Oracle database, wif testing and debugging shell scripts and Hive queries.:
• Generating various raptor reports based on forecasting reporting framework and users’ requests, which involved developing and tuning PL/SQL scripts.:

Confidential, Florham Park, NJ

Applications Developer

Responsibilities:

• Data mining from cell tower CPUs, aggregating data into database and producing reports for RNC usage forecasting for engineering department, using Unix shell scripting, awk, C, and Perl, Sqlldr, SQL and PL/SQL.
• Extracting data from various sources, modeling and generating Oracle tables, automating batch loading, using Unix shell scripting, Perl, python, Sqlldr.
• Developing various Raptor reports for front-end visualization.
• Gathering data from various databases and create reports for cell phone usages, using Unix shell scripting, SQL.
• Tuning SQL queries, optimizing stored procedure performance, using explain plan.
• Automating processes for AMPL modeling, mimicking real-life tracking area performance, using Java, Unix shell scripting, SQL.
• Gather data and produce reports for supply chain management to reduce inventory, using JDA, SQL and PL/SQL.

Confidential, Weehawken, NJ

Sr. Associate Programmer

Responsibilities:

• Initiated and developed user-friendly reconciliation tool by analyzing users’ problem patterns, provided web gadgets for users to compare results from book-keeping and Axys portfolio reporting results, enabled users to reduce unreconciliation rate from around 13% to 3%, using Unix shell scripting, Perl, Sqlldr, SQL, PL/SQL, Java, Servlet, JDBC.
• Trouble-shot numerous production emergencies, resolved various processing hangs on spot and conducted root cause analysis to eliminate production problems and data issues, provided L2-L3 production support, using Unix shell scripting, batch, AXYS, Autosys, CVS/PVCS. Optimized portfolio reporting programming scripts, generated performance monitors, which reduced daily transaction processing time from 7 to 5 hours, thus enhanced production support (L1-L3), using Unix shell scripting, AXYS, Batch, Autosys, CVS/PVCS.
• Designed and developed database model for portfolio reporting and data reconciliation. Developed and maintained data extracting (from various sources, such as mainframe, Axys reports and outside feeds), transformation and loading processes, using Unix shell scripting, Perl, Sqlldr, SQL and PL/SQL.
• Created tables wif constraints, generated and tuned queries for data extraction and reports, using SQL, PL/SQL.
• Generated database stored procedures, functions for web applications in different environments in development and in company’s new standard format.
• Tuned UNIX and Oracle applications in server and web environments, using Unix shell scripting, PL/SQL, Autosys, CVS/PVCS.
• Performed several system conversion/upscalings and database migrations that resulted in increased production data processing efficiency, using Unix shell scripting, SQL, Autosys, CVS/PVCS.
• Streamlined portfolio reporting processes for ultrahigh networth users, successfully performed multiple testing upon stringent deadlines, using Unix Shell scripting, AXYS, SQL, Java JDBC. Provided users and upper management teams wif business analysis reports according to their
• changing requirements, using SQL.
• Collaborated wif business users and developers, generated and maintained procedure documentations.
• Mentored coworkers for system understanding and problem solving guidance.

Confidential, Piscataway, NJ

Developer

Responsibilities:

• Designed and developed projects to centralize, analyze, and process data for order and billing data-mart for book-close, using Unix Shell scripting, AWK, SED, Perl.
• Provided data results in various formats (such as Oracle reports, flat data files, Excel spreadsheets, etc) suitable for different clients’ requests, using Unix Shell scripting, SQL. Designed reports efficiently for performance.
• Transformed business design documents to programming processes and developed UNIX and database applications, using Unix Shell scripting, SQL, PL/SQL.
• Modified and automated existing processes.
• Resolved various production problems.
• Coached coworkers to convert business requirements into programming script flowcharts and helped them troubleshooting.