SUMMARY

• 10+ years of overall IT industry experience, mostly in data warehouse environment
• 10+ years in Unix, Shell scripting
• 3+ years of Ab Initio developer
• 3+ years of SQL
• 2+ years in Perl programming
• 2+ years of PL/SQL

TECHNICAL SKILLS

Operation Systems: Windows NT/2000/XP/Server 2003, MS DOS, Unix, Aix, Linux

Databases/ Tools: Oracle 10g, Oracle SQL*Plus, Toad, MSSQL Server 2008 R2

Programing language: C++, Perl

ETL Tool: Ab Initio

Unix Scripting Language: Bourn, Korne, C shell, and Awk

Window Scripting: PowerShell.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Application Support Specialist

Responsibilities:

• Provide technical support for in house financial software.
• Troubleshoot and resolve production issue within SLA.
• Formulate,design, and test PowerShell script, SQL script to automate manual monitoring, manual validation process to reduce manual process and free up manpower.
• Using a combination of PowerShell, SQL to generate reports in Excel report and chart.
• Create ready to go SQL statement for the group to use to troubleshoot issues.
• Validate systems, applications and servers after maintenance window.
• Provide technical support after hour.

Confidential, Irving, TX

Ab Initio Developer

Responsibilities:

• Used Ab initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases
• Performed complex queries involving large data volumes
• Deploy and test run the graph as executable Korn shell scripts in the application system
• Modified the Ab initio component parameters, utilize data parallelism and thereby improve the overall performance to fine - tune the execution times
• Involved in modeling the business processes and business requirements resulting in process improvement
• Developed High level and Detail Designs
• Replicate operational tables into staging tables, Transform and load data into warehouse tables using Abinitio
• Gathered requirements using requisite
• Developed conversion functions for transformations
• Developed include files used in the transformations
• Developed numerous shell scripts to automate the file manipulation and data loading procedures
• Generated monk data to do the unit and system testing
• Developed test procedures to do the parallel system testing
• Developed mapping docs using Data Profiler
• Moved applications between Dev, Test and Production environments
• Developed DW applications using Star Schema
• Used Re-posit to do the dependency analysis and version control
• Interact with the business and technical analysts and DBA’s
• Developed process that load large file into a data warehouse that is still in encrypted which save time, secure

Confidential, Dallas, TX

Jr Ab Initio Developer

Responsibilities:

• All the Data staging and loading scripts are developed by using Abinitio, UNIX Shell
• The Ab initio graphs have been developed to read the sales data files and then reformat, filter, aggregate the data before loading them into an Oracle database
• Developed, designed, tested and implemented Abinitio graphs for all fact tables
• Ab Initio’s Co>Operating System to extract, transform and integrate data from multiple data source and performed parallel data cleansing and validations using Ab Initio
• Performed evaluation of vendors for selecting an appropriate ETL Tool

Confidential

Jr Ab Initio Developer

Responsibilities:

• Developed mapping documents for Inbound/Outbound Interfaces
• Developed 25 Ab Initio graphs for 13 outbound interfaces
• Handled complex data formats, which included Vector type of record format coming using AB INITIO Normalize and later on De-normalize component
• Developed graphs to Process Inbound XML files using AB INITIO
• Developed Ab Initio graphs for purging the data from using Flat files in the process
• Generated Korn shell scripts to monitor the Data warehouse processes
• Created the DML files to In Bound/ Out Bound Ab Initio Graphs
• Developed the Ab Initio graph to handle complex character Header and Trailer file
• Migrated the Ab Initio Graphs from Development to testing and testing in Production environments
• Administered Ab Initio Repository using Air utility command reference
• Created Sandboxes and Projects for different group of users on the Repository
• Developed UNIX shell scripts to automate the Data Load processes to the target Data warehouse

Confidential - Irvine, CA

Data analyst

Responsibilities:

• Production and analysis of both ad hoc and standard sets of utilization, financial and/or clinicaldatato assess clinical quality, service, and operational, organizational, and/or provider performance.
• Define requirements, performdataanalysis,datamapping, and assist in the design, testing, and implementation of automated systems
• Created automation process for manual, repetitive by using a combination of SQL, Perl, Shell scripts reduced processing time
• Write ad hoc report using SQL queries

Confidential, Richardson, TX

Production Analysis

Responsibilities:

• Responsible for any/all activities involved in the deployment and/or support of the Common Services (CS) middleware application components. The expectation is a 100 % uptime for all of these CS applications
• Working directly with the application developers and clients to troubleshoot prod problems
• Collect Capacity data, analyze statistics and develop trends, to develop/maintain appropriate monitoring, reporting tools.
• Use Oracle, SQL plus and TOAD to query/analyze data, run adhoc script and troubleshoot failed job
• Working with ETL tools Abinitio to load data to production environment.
• Write ad hoc SQL queries (using Oracle 10g) used to report
• Working with different application groups and deliver effective solutions
• Developed automation to reduce manually processes in SQL/Shell/Perl reduced hours of
• Investigated anomalies between two reports by using PL/SQL procedures and queries.
• Provide critical support during the monthly close of finance.
• Support and develop Abinitio graph to load data to the data warehouse

Confidential, Carrollton, TX

Jr Software developer

Responsibilities:

• Responsible for providing technical support for Network Operation Center and Internal Department
• Provide technical support to the production support group when their issue until Abinitio job in production
• Working under Senior developer on the new project.
• Created automation processes using Perl/Shell scripts
• Created PL/SQL scripts to pull data from Oracle database in conjunction with PERL scripts.
• Provide after hour on-call support.