Project Coordinator Resume Foster City, CA - Hire IT People

SUMMARY

Over 5 years of IT consulting experience in analysis, design, development, testing and implementation of applications.
Hands on experience include developing Data Warehouse applications using Ab Initio Co>OS vs. 3.0.2, GDE vs. 3.0.2.2 in Banking, Retail.
Ab Initio Consultant with 5 years’ experience in Ab Initio ETL, Data Mapping, Transformation and Loading between Source and Target Databases in a complex, high - volume environment
Extensive in Ab Initio ETL, ORACLE, DB2 and UNIX Shell scripting having good experience with EME Concepts
Involved in analysis, design, development, implementation, and maintenance of various applications in all phases of project life cycle
Expertise and well versed with various Ab Initio components such as Round Robin, Join, Rollup, Partition by key, gather, merge, interleave, Dedup sorted, Scan, Validate, FTP
Well versed with various AB Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and MFS techniques
Involved in providing production on call support to various Ab Initio ETL jobs and Oracle Database programs and developing various UNIX shell wrappers to run Ab Initio and Database jobs 24x7.

TECHNICAL SKILLS

ETL: Ab Initio Co>OS vs. 3.0.2, GDE vs. 3.0.2

Databases: Oracle11i/9i/8i/7.3, DB2

Platforms: Win 2000/NT, Sun Solaris 8.0, HP-UX, OS/390

Version Control: CM Synergy, CVS, EME

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

Project Coordinator

Responsibilities:

Analyze and develop ETL applications using Ab Initio 2.14 or above.
Design, develop, document and implement new programs and subprograms, as well as enhancements, modifications, and corrections to existing software.
Develop testing and debugging routines and oversee execution.
Create documentation and procedures for installation and maintenance.
Build and maintain relationships with global and virtual teams and third parties on software development or support issues.
Lead development and oversee programming and testing functions to ensure that projects are securely delivered and fulfill expectations.
Understand the positioning of a solution within the company and to build a plan to effectively gain buy-in from all participants.
Identify opportunities for further enhancements and refinements to standards and processes.
Prepare ETL design documents; evaluate and recommend ETL solutions to meet user requirements; define and implement solutions to load and extract data from source data.

Confidential, Hoffman Estates, IL

Ab Initio Developer

Responsibilities:

Performing transformations of source data with Transform components like Join, Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by-Expression, Rollup etc.
Developed data validation Graph for validating 200 info usa source data files
Developed complex graphs which contains around 100 components
Responsible for the automation of Ab Initio Graphs using Korn shell scripts
Develop and modify several application scripts in UNIX in order to pass the environment variables and to implement run controls for various graphs
Involved in writing stored procedures to access data from Oracle 11I.

Environment: Ab Initio (GDE 3.0.2, Co-Op 3.0.2), EME, Linux, Unix, -Sql Developer Toad, UNIX Script (KShell), Oracle 9i, Oracle 11i

Confidential

Abinitio Developer

Responsibilities:

To ensure data is correctly loaded into the backend tables. Manually load the data into the tables as and when required.
To address and track any error that happens with the usages in the system process.
Priotorize the issues and solve them within the SLA.
Proper follow up if dependency is on the developer or the third party.
Keeps a record of the issues using a customized tool called TechExcel.
Maintain a issue tracker which contains all the description of the issues i.e. when the issue occurred, noted, solved, why it occurred and how was it resolved. Proper hand-over of the Issue Tracker Sheet during the change of shifts.
To understand of the end-to-end flow of the system and provide production support using the customized application i.e. the Event Engine through which all the production jobs status could be monitored and raise concern if there are any late feeds to the system or in case of any application failure.
Development/Coding of the changes required in case of any application failure in certain cases.
System Testing with the changed version of the code to verify and validate the requirement
Do proper follow up, send reminders for the issues wherein there is a dependency on third party (Data provider, user etc)

Environment: Abinitio 1.13.11/3.0.2, Mainframes, Oracle, Unix