Ab Initio Developer Resume
Fort Worth, TX
SUMMARY
- 8+ years of IT experience in Administration, Analysis, Design, Development, Testing and Implementation of various data warehouse applications using Ab initio 3.0.2, EME Technical Repository, Teradata 12 & 14, Datastage 8.X, UNIX.
- Extensively worked in creating Data marts using Ab Initio GDE 3.2.3/ CO>OP 3.2.2.3, Express>It 3.3.2.0 ETL Functions. Designed and built logical and physical models into catalogues and universes for end - user and management reporting needs.
- Experience in teh different Source/ Target Systems like Flat files, Multi-file systems (MFS), Multiple files (Batch of files), Ab initio queues (Continuous flow Graphs), and Relational Database systems (RDBMS) - Oracle, Teradata.
- Extensive experience in conducting Data Analyses, Data Mapping, Gap Analyses, Risk Identification, Risks Analyses, and Risk management.
- Skilled in teh use of computer languages including JavaScript and SQL.
- Capable of using talent wif databases and operating systems to improve environments solve issues and prevent future problems.
- Experience in AGILE development methodologies.
- Hands on experience in creatingContinuous and Batch graphs.
- Have worked on XML processing wif Ab Initio, where XML files come to Ab Initio through Java UI.
- Implemented Plans (Conduct>It), component folding and Micrographs.
- Proficient in Developing dynamic lookups and dynamic DML.
- Worked wif Partition Components like Partition-by-key, Partition-by-expression, Partition-by-Round Robin to partition teh data from serial file.
- Well versed wif various Ab initio parallelism techniques, Multi file systems and implemented number of graphs using data parallelism.
- Sound experience in Shell scripting.
- Have good exposure in Performance tuning and troubleshooting methods.
- Have good knowledge of Data Warehousing Concepts.
- Having good exposure toAB INITIO (ETL), UNIX, Oracle 10g and MS SQL Server 2005.
- Involved in Developing Ab Initio Graphs in a MPP (Massively Parallel Processors) Environment for teh ETL process jobs in a High Volume and dynamically growing environments.
- Tuned teh Graphs by removing unnecessary components to enhance teh performance.
- Exposure to Conduct It, BRE, Data profiler products.
- Dexterous in handling Oracle and Teradata Databases.
- Having working experience in creating different korn shell scripts and handling graphs and plans at backend.
- Extensive experience in writing and tuning complex SQL queries, Sub-queries.
- Hands on experience on version control system (EME).
- Well versed in EME administration, Code migration and environment check out.
- Working knowledge of QC and ALM tools for bug tracking.
- Prepared Technical Specification Document (TSD), having details about pricing process.
- Worked wif Wrapper scripting wif UNIX Shell programming, Scheduling of Ab initio jobs wif Auto Sys.
- Exposure of Data Profiling and Metadata hub.
- Good experience in development of PL/SQL stored procedures, functions and packages.
- Good experience in development of various types of reports using Actuate. Report Designer Professional.
- Strong communication and inter personal skills wif ability to work in a team environment or individually.
- Excellent communication skills, good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.
TECHNICAL SKILLS
ETL Tools: AbInitio GDE 1.1x, 3.0x, CO>OP 2.1x,3.0, Metada Hub, Data profiler, Informatica,Erwin 4.1/3.7, Microsoft Visio 2007
Tools: Maestro, Auto Sys, Tivoli Work Load Scheduler
OS: UNIX, Windows 95/98/NT/ME/00/XP, MS-DOS, Linux 8x
Databases: Oracle 11i,10g,9i/8i/8/7.x, MS SQL Server 2008/2005/2000 , Teradata v2r6.1, MS Access, IBM DB2.
Languages: UNIX Shell Scripting, SQL, PL/SQL, T-SQL, C, C++, JCL, Perl.
Scripting: UNIX Shell (Ksh/Csh), JavaScript.
Web: HTML, DHTML, XML, ASP 2.0/3.
PROFESSIONAL EXPERIENCE
Confidential, Fort Worth, TX
Ab Initio Developer
Hardware/Software: Ab Initio GDE 1.14, Coop 2.14, Oracle 9i, Tera data, Autosys, Toad 7.6.0.11, HP UX 11.x, Korn Shell Scripting.
Responsibilities:
- Developed and Implemented extraction, transformation and loading teh data from teh legacy systems using Ab Initio
- Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs and written complex XFRs for implementing teh business logic transformation.
- Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
- Extensively Used Transform Components Aggregator, Match sorted, Join, Denormalize sorted, Reformat, Rollup and Scan Components
- Involved in Unix Korn shell wrapper scripts to accept parameters and scheduled teh processes using Crontab, Job Scheduler, Database Load Interface, and Denormalization using Ab Initio.
- Worked wif EME / sandbox for version control and did impact analysis for various Ab Initio projects across teh organization.
- Developed Ab Initio scripts for data conditioning, transformation, validation and loading.
- Gathering teh knowledge of existing operational sources for future enhancements and performance optimization of graphs.
- Assisted in developing various reports using PL/SQL Stored Procedures.
- Involved in writing wrapper scripts to run teh graphs, to load into Data Warehouse and to verify teh counts while loading.
- Experience in Ab Initio parallel and serial flow batch graphs, conditional components, other components like Transform, Read and Write XML, Read and Write Multiple files, Partition graphs.
- Worked in Mainframe by creating OUTPUTA of good records which will be used in downstream processing.
- Used Parallelism techniques to partition and process large data simultaneously
- Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
- Developed shell scripts to automate file manipulation and data loading.
- Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.
Environment: AbInitio GDE1.13, Co-Op2.13, UNIX, Oracle 9i, SQLServer Navigator 5.0,SQL Server2000, Cygwin, AMS Software,Maestro, DB2, Teradata, Windows2000, Crystal Reports 9.0
Confidential, Wilmington, DE
Ab Initio Developer
Hardware/Software: Ab-Initio 3.3.1 GDE wif Co>op 3.3.1.4, Express>It 3.3.2.0, Unix, Teradata, Windows.
Responsibilities:
- Understood teh business requirements wif extensive interaction wif users and reporting teams and assisted in developing teh low-level design documents.
- Worked wif product vendor to identify teh bugs in latest version while updating teh GDE, Express>It wif latest save files to fix them.
- Monitored Teradata systems TEMPeffectively using Viewpoint port lets and alerts
- Worked exclusively wif teh Teradata SQL Assistant to interface wif teh Teradata.
- Extensively used teh Teradata EXPLAIN facility to describe how teh database will perform teh query.
- Worked in a sandbox environment while extensively interacting wif EME to maintain version control on objects.
- Sandbox features like checkin and checkout were used for this purpose.
- Maintained locks on objects while working in teh sandbox to maintain teh privacy
- Built various utilities on Unix shell scripting to automate various phases of Unit test teh developed code.
- Used Auto Sys for Scheduling teh Jobs and setting up teh Jobs for execution.
- Used Anthill and udeploy to deploy and maintain various versions on different environments.
- Worked on Teradata Upgrade from Version 14 to 15.10
- Worked on Teradata Installation of servers like Viewpoint, PDCR & TARA GUI.
- Worked on Query optimization/Collect stats etc.
- Supported Teradata servers like Nodes, Viewpoint, PDCR, TARA GUI, Net Backup for Prod & Non-Prod servers.
- Worked on Monitoring & Trouble shooting of Backup, Restore & Copy of Teradata Objects.
- Developed Complex XFRs to derive new fields and solve various business requirements.
- Developed appconfs based on previously developed graphs.
- Maintained end to end lineage by using components like documentation in scenarios where lineage cannot be maintained.
- Set and managed development activities and project calendar
- Worked wif team of developers and other professionals throughout project lifecycle
- Generated and reported on DWH applications and its volume
Environment: Ab Initio GDE 1.15.7, Co>operating system 2.15, Teradata, Unix, Db2, Sql Assistant, Putty, SQL\PL-SQL, Windows 2000/XP, MS Office, Visio, Shell Scripts, XML, XSD, Maestro 8.5.
Confidential, Richmond, VA
Ab initio Developer
Hardware/Software: Ab Initio GDE 1.14.3 Co>Op 2.14, UNIX, SQL, Teradata, SQL Server, Windows NT.
Responsibilities:
- Developed and supported in extraction, transformation and load process (ETL) for a Data Warehouse from legacy systems using Ab Initio and provided technical support.
- Interpret transformation rules for all target data objects and developed Ab Initio graphs to support teh transformation.
- Created Database Configuration files (.dbc) and involved in creating SQL statements wif sql extensions, which will be used in Database transformations to extract teh data from different source tables and to load into teh target table.
- Developed UNIX shell scripts using SQL programs for daily and weekly data loads.
- Developed Data transformation, loading, scrubbing and extraction programs using Ab Initio ETL tool.
- Used various Ab Initio components of Partition, De-partition, Database, Datasets, Transform, FTP and Sort to build Graphs in GDE.
- Created XFRs during teh data transformation phase prior to creating load ready files.
- Implemented Partition techniques using Multi file system.
- Involved in creation of proper test data to satisfy all required test cases and performed unit testing on all deliverables also was part of teh code review team
- Involved in Ab-Initio Graph Design and Performance tuning to Load graph process.
- Documentation of complete graphs and its components.
- Used Autosys 4.5 as job scheduler, worked also as a production support, solved issues like missing files, storage and loading issues.
Environment: AbInitio GDE1.12,Co-Op2.12, UNIX, Oracle 9i, SQLServer Navigator 5.0, DB2, Teradata, Windows2000
Confidential
Ab Initio Developer
Hardware/Software: Ab Initio, Teradata, Oracle, UNIX, Linux, Shell scripting, Auto Sys
Responsibilities:
- Involved in project from scratch and participated in design and development.
- Gathering teh requirements, analyzing teh requirements and document (Business understanding Document/ Harmonization Document) them accordingly.
- Preparing teh design documents (HDD, TDD, and LDD).
- Involved in designing and development of different continuous and non-continuous services using Ab Initio.
- Developed teh calculation logic of products for teh different services in teh project.
- Involved in designing and development of Ab-Initio graphs using Ab-Initio Parallelism techniques, Data Parallelism and MFS Techniques.
- Implemented Star Schema models for teh above data warehouses by creating facts and dimensions.
- Extracted and loaded data from various data sources like Oracle/Teradata databases, Flat Files and XMLs.
- Involved in development of UNIX shell scripting and handled teh project from back-end.
- Carried teh performance tuning on teh Ab Initio graphs to reduce teh process time.
- Extensively used teh Teradata and Oracle SQL queries.
Environment: Ab Initio GDE1.12, Co-Op 2.12, UNIX, PL/SQL, Oracle 9i, SQL Server7.0, Windowing
