We provide IT Staff Augmentation Services!

Database Developer Resume Profile

Professional Summary:

  • Around 7 year's Professional experience in the IT industry which includes more than 5 years as an Ab Initio Developer using GDE version 3.0/1.15/1.14/1.13.
  • Involved in all phases of Life Cycle of one application from reverse engineering of Assembly programs to production implementation of developed Ab Initio graphs.
  • Extensive and expert level of experience on Ab Initio tools like Graphical Development. Environment, Co>Operating systems, EME Repository.
  • Extensive Unix Shell Scripting knowledge provided support for existing shell scripts and modified wrapper scripts as per the requirement
  • Involved in Performance Tuning of the Ab Initio graphs by using all the best practices such as Lookup, fine tuning the Memory parameters techniques etc.
  • Designed and built logical and physical models into catalogues and universes for end-user and management reporting needs.
  • In - Depth working knowledge in Oracle 10g and use of decode, joins, complex oracle statements.
  • Experience in complex AbInitio components using Normalize, Conditional Metadata, Rollup, Scan etc.
  • Extensively worked in creating Data marts using Ab Initio GDE 3.0/1.15/1.14/1.13, ETL Functions and related OLAP tools.
  • Experience with EME for Source control/Plan Creation in AbInitio.
  • Good working knowledge in designing Use Case, Class, Sequence, Collaboration, State, Component, Deployment, Activity diagrams using UML.
  • Experience in writing SQL Queries and data modeling.
  • Having experience in dealing data with different databases like Oracle, MS SQL Server/DB2 etc.
  • Expertise in creating documentation and end user training.
  • Ability to work well in a team environment or independently.
  • Good ability to quickly understand and master the new concepts and technologies.
  • Functional domain experience involves Financial, Investment Banking and Insurance industry.
  • Effective in working independently and collaboratively in teams.
  • Had worked on Ab Initio Data Profiler for examining the data available in an existing database and collecting statistics and information about that data.
  • Have Worked on BRE Business Rules Engine to create and deploy rule sets and also importing the datasets.
  • Strong skills in defining and implementing solutions, tools, processes and procedures to provide enterprise data integration and ETL services that meet business requirements.
  • Developed ETL mappings from source systems to target database using Ab Initio. Seasoned in data warehousing, data modeling, data marts, data migration and data analysis.
  • Used the Ab Initio web interface as a 3-tier approach to navigate in the EME.
  • Worked closely with Business users to collect the functional requirement for Decision support Data warehouse or Data Integration projects.
  • Had been responsible for mission critical high availability near 24X7 batch gateway using Ab Initio, Oracle, UNIX Ksh scripting, Autosys , Crystal reports, SQL.
  • Participated in development of detailed technical design for Account Build/Maintenance Service.
  • Had been responsible for developing data mapping routines using Ab Initio ETL for the conversion and interfacing of data between Legacy Systems and the Enterprise Data Warehouse and the ERP system.

Technical Skills:

ETL/Reporting

Ab Initio CO>OS 3.0/2.15/14/13/12/10, GDE 3.0/1.15/1.14/1.xx, Ab Initio Data Profiler 3.03/1.7.8, Ab Initio EME 2.15, Ab Initio Business Rule Engine BRE 3.0.2

Operating Systems

UNIX Sun Solaris, IBM AIX , Windows NT/98/ 2000/XP/2003/7, MVS Multiple Virtual Storage

Databases:

Oracle 7.x/8i/9i/10g/11g, SQL Server 2000/2005/2008, DB2 9.1, Sybase ASE 15.0

Languages

C/C , Java, SQL, PL/SQL, T-SQL, Shell Scripting Korn/C , JCL Job Control Language ,JIL Job Implementation Language

Tools/Utilities

Toad 7.5, Query man/SQL Assistant 6.1, Teradata Utilities, Win Runner, WinSCP, HP Quality Center 10.0, Oracle SQL Developer 3.2.09, Autosys v11.3./4.0/3.5, Toad for Oracle 9.5, Informatica Power Center v 8.6.1, MS office Tools 2007/2003 Word, Excel, Visio , Cognos 10,Cognos Report Studio, Cognos Framework Manager, Cognos Event Studio, PVCS Version Control Manager, Rapid SQL 7.5.4/8.6.0, Clear Quest, Clear Case

Professional Experience:

Confidential

Role: Sr. Ab Initio Consultant

Responsibilities:

  • Created loaders to read files from different vendors and format into a universal file format with generic dml.
  • Created process to load these universal file format files UFF's to load to staging tables. Also created new graphs and stored procedures to move data from staging tables to active tables after reconciliation.
  • Performed Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DML's.
  • Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
  • Developed graphs based on data requirements using various AB Initio Components such as Rollup, Reformat, Join, Join with DB, Scan, Normalize, Gather, Broadcast, Merge etc., making use of statements/variables in the components for creating complex data transformations.
  • Handled offshore team of four developers and have weekly meetings with the offshore team to discuss the status and production issues faced and what measures to resolve them and then report them to the Client manager.
  • Having track of the production issues and update the production issue log with the issues faced and resolution and steps performed.
  • Performed data cleansing using AB Initio functions such as is valid, is error, is defined.
  • Extensively used string functions, date functions and error functions for source to target data transformations.
  • Developed Unix Korn Shell script wrappers to run Ab Initio deployed scripts, perform audit checks/data reconciliation and error handling to ensure data accuracy.
  • Created autosys jils and scheduled jobs to ftp/http files and load them using generic loaders.
  • Used inquiry and error functions like is valid, is defined, force error and string functions like string substring, string concat and other string functions in developing Ab Initio graphs to perform data validation and data cleansing.
  • Space estimations and User maintenance on dev machine.
  • The graphs and other development related files are checked in/out of the sandbox repository to share them with other development team members.
  • Implementing Multi file system by using m commands to store the data in multiple files in multiple storage locations to implement the performance.
  • Performed data cleansing using AB Initio functions such as is valid, is error, is defined.
  • Used AB Initio Components like Sort, Partition, Rollups, Merge and created XFR's
  • Mostly used the Join, Join with DB, Reformat, Partition by Key, Partition by Expression, Run Program, Replicate, Dedup Sorted, Filter by Expression, Rollup, Generate Records components.
  • Working as a Rotation ON CALL production support to resolve production issues so that the data can be delivered on time to the client.

Environment: Ab Initio GDE 3.0.6, Co-op 3.0.11, EME, UNIX, PL/SQL, Sybase ASE 15.0, Rapid SQL, UNIX, Windows XP/7.

Confidential

Role: Ab Initio Consultant

Responsibilities:

  • Converted user defined functions and complex business logic of an existing application process into Ab Initio graphs using Ab Initio components such as Reformat, Join, Transform, Sort, Partition to facilitate the subsequent loading process and also created .psets to run the graphs.
  • Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
  • Used EME as Version control for the various DML, ksh, xfr, mp,pset files.
  • Had to create ad-hoc processes to parameterize the graphs.
  • Used Data Profiler to analyze statistics of the data.
  • Involved in creating detailed data flows with source and target mappings and convert data requirements into low level design templates.
  • Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.
  • Had weekly status meetings with the Data Architect/Leads and the Project Manager to discuss about the next phase of the project.
  • Had to create graphs to generate daily scorecards for the daily updated files.
  • Had to use wrapper scripts to generate scripts to run the daily process.
  • Created common graphs to perform common data conversions that can be used across the applications using parameter approach using conditional DML's
  • Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
  • Have worked on Business Rules Engine BRE 3.0.2 to import datasets and create new rulesets and deploying them and use of BRE functions like all same, sum if, min, any contains etc.
  • Deployed and ran the graphs as executable Korn shell scripts in the applications system.
  • Used Autosys to create jils and run the job box and also run the jobs according to a specific time and date.
  • Used Ab Initio EME to control and analyze the process of compiling terabytes of data from multiple sources which change frequently.
  • Used the reformat component and had extensive use of the transform functions to get the desired format in the output.

Environment: Ab Initio GDE 3.0.4.1 , Co>Op Sys 3.0.3.9 , BRE 3.0.2 , EME, Oracle 10/11g, UNIX, Sun Solaris, Autosys r11.3, SQL developer, Toad, MS SQL Server 2008, IBM Cognos Report Studio, Ab Initio Data Profiler v3.0.1, HP Quality Center 10.0.

Confidential

Role: Ab Initio Consultant

Responsibilities:

  • Developed graphs for downstream applications according to the requirements and also load them into tables/files and then ndm it and also set up jils in dev/IST/UAT environment for the same.
  • Had developed graphs for different downstream applications like CITIFT, GMIC, CWS Datamart, AML E2E Anti Money Laundering and CMIS, to cut the feeds from the Project One database and do the transformations according to the requirements and send it across to the users.
  • Tuned the Graphs by creating Lookup files, Memory sort and Max-core parameters for maximum usage of cache memory and to enhance the performance
  • Replicate operational tables into Staging Tables, Transform and Load data into warehouse tables using Ab Initio GDE and responsible for automating the ETL process through scheduling.
  • Extensive use of EME related graphs and extensive knowledge of check-in and check-out of graphs.
  • Use of BRE to import data sets and generated components for use.
  • Extensive use of air commands and creating jils in autosys and use of Join, Reformat, string functions, introducing parallelism and increasing the performance.
  • Created scripts to cleanup unwanted files in DEV, IST and UAT environments.
  • Use of profiles and setting up jils and scheduler in autosys.
  • Well experienced in using Partition Partition by key, partition by round robin and Departition components Concatenate, Gather, and Interleave, Merge to achieve data parallelism.
  • Used BRE 1.15.2 to create rule sets and variables and assigning values to output variables and also join them and also including packages etc.
  • Implemented Lookups instead of joins, in-memory sorts to minimize the execution times while dealing with huge volumes of data
  • Created .save files and install instructions and released them to IST to promote the code and also the same to UAT and production.
  • Then do aggregation for those values and then load them into the datamart.
  • Extensive use of XFR's to apply Business logics and mapping validation.
  • Extracted data from DW analyzed and further cleansed data using UNIX and Business Intelligence. And also created monthly automated reports using UNIX.
  • Worked as primary support during the production phase.

Environment: Ab Initio GDE 1.15 , Co>Op Sys 2.15 , EME, BRE 1.15.2.3, Oracle 9/10g, UNIX, Sun Solaris, Autosys, SQL developer, Toad.

Confidential

Role: Ab Initio Consultant.

Responsibilities:

  • Created Ab Initio graphs to migrate data from CMW to Epsilon.
  • Used MVS to create an OFD Online File Delivery process to transfer the data from CMW to Epsilon.
  • Designed the detail design document and training document for the project.
  • Used DB2 as the database to get the data from the database and then had to create staging tables and then had to move the data from the staging table to the original table.
  • Converted user defined functions and complex business logic of an existing application process into Ab Initio graphs using Ab Initio components such as Reformat, Join, Transform, Sort, Partition to facilitate the subsequent loading process.
  • Had to work with the OFD team in establishing the receipt of the files.
  • Had to work with the QA team and the production team to make sure that they were able to create the process and then were able to migrate the data without any errors.
  • Had to create the preliminary design specification document based on the functional components and conceptual architecture given by the SME.
  • Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques like using lookup's instead of joins , In-Memory Joins and rollups to speed up various Ab Initio Graphs.
  • Had to use complex SQL Queries and also had to do unit testing to make sure that the graphs were running without any errors on the development server.
  • Performed Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DML's
  • Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
  • Used various Teradata utilities such as Mload, api and Fast load while using I-Table, O-Table components depending on the volume of data and status of the target database table.
  • Created generic graphs for loading and unload Teradata tables using pre and post Run SQL components to clean WEL tables that are created due to the intermediate process failures.
  • Performed bulk data load from multiple data source ORACLE 8i, legacy systems to TERADATA RDBMS using BTEQ, Fast load, Multiload and TPump.
  • Extensively used string functions, date functions and error functions for source to target data transformations.
  • Developed Unix Korn Shell script wrappers to run Ab Initio deployed scripts, perform audit checks/data reconciliation and error handling to ensure data accuracy.

Environment: Ab Initio GDE 1.14 , Co>Op Sys 2.14 , EME, DB2/UDB 7, Oracle, UNIX, IBM 390, Teradata, JCL, SQL, Micro Strategy.

Confidential

Role: Database Developer

Responsibilities:

  • Estimating Table sizes, Table spaces.
  • Identifying integrity constraints for tables.
  • Wrote Database Triggers.
  • Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
  • Creation, maintenance, backups and restoration of databases.
  • Job responsibilities include developing on-line screens using SQL Forms 4.5, creating database objects like tables, indexes, views etc. using SQL Plus, import and export of data using SQL Loader.
  • Reports were developed using Oracle Reports 2.5.

Environment: Oracle 7.x, Developer 2000, SQL Forms 4.5, SQL plus, SQL Loader, Oracle Reports 2.5, Designer2000, PL/SQL, UNIX and Windows

Hire Now