We provide IT Staff Augmentation Services!

Sr Ab Initio Developer Resume

SUMMARY

  • 10 years of IT experience in Software Development Life Cycle: Analysis, Design, Development, Testing, Evaluation and Implementation with extensive exposure in Database, Data warehouse and ETL process technology.
  • Extensive experience in utilizing ETL Process for designing and building very large - scale data OLAP and OLTP instance using ETL tools Ab-Initio.
  • Responsible for creating logical and physical data models then transforming the logical into physical according to the model supplied by the reporting team.
  • Provided second tier production support for Data Warehouse for internal and external data flows to Oracle DBMS from ETL servers via remote servers, Ab Initio remote access loading tables with a mix of Ab Initio graphs.
  • Worked with the Databases such as SQL Server, Oracle, Teradata and DB2. With VLDB instance for both OLTP and OLAP environment.
  • Worked closely with testing team and done AI testing including unit testing and system testing in both testing and pre-prod environment.
  • Hands on experience in System Testing, Unit testing and Integration testing.
  • Hands on experience in diverse fields like Financial, Retail andTelecom relational Databases with an extensive use of ETL techniques, Dimensional Modeling Design techniques, Data Management, Data Integration Techniques, Data Architect, Database Applications, Data warehouse, and Business Intelligence solutions.
  • Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
  • Effectively Tuned and Monitored RDBMS at both application and database level for better performance.
  • Hands on experience in end-to-end Data warehousing ETL routines, which include writing custom scripts, stress testing, data mining and data quality processes.
  • Extensive experience in writing efficient and well-tuned SQL Queries and UNIX (K-Shell) Scripts to provide reporting, process and validate data on Teradata, SQL Server and Oracle.
  • Code production changes, write monitoring, data recovery and repair routines. Write Support Documents and Clarify solutions.
  • Created requirement specification documents and mapping documents and participated in JAD discussions.
  • Hands on experience with IBM Optima.
  • Strong experience in implementing Data Warehouse applications.
  • Created Ab initio best practices and standards documents to the different clients.
  • Developed UNIX scripts for alarm point alerts for the various batch processes in case of failure.
  • In-depth experience in troubleshooting and problem resolution for batch related issues.
  • Involved in providing 24/7 pager production support.
  • Coordinating with various teams in the migration/deployment process for performing application migration/deployment to a higher environment. Enhancement and Defect Management.
  • Involved in scheduled changes, configure for automate batch processing and rollouts to technology operations.
  • Strong consultation and interaction skills with enterprise wide business partners.
  • Excellent Project Managing skills along with Data warehousing technical skill set.
  • Expert in Incident Management working through critical incidents. Manning command center and conducting Incident resolution bridge calls.
  • Supported Operational databases and legacy data ware house.
  • Hands on experience with Meta Data Hub.
  • Hands on experience with Control M.
  • Have good hands on experience with IBM ISAS Solution, DB2,SQL Server.
  • Highly adaptive to a team environment and proven ability to work in a fast-paced teaming environment with excellent communication skills.

TECHNICAL SKILLS

Data Warehousing: Ab Initio (GDE 2.14 to 3.0), Co>Operating System 2.14 to 3.0), EME

RDBMS: Teradata V2R5, Oracle 9i/8i, MS SQL Server 6.5/7.0/2000 DB2, Sybase, MS Access 7.0

Tools: SQL Assistant, MS Access Reports, TOAD,ACE, Autosys, Clear Case,Op Console

Programming: SQL, UNIX Shell Scripting, Korn Shell, SQL*Plus, PL/SQL

Operating Systems: Windows 95/98/NT, DOS, Solaris, Red Hat Linux, HP-UX

PROFESSIONAL EXPERIENCE

Confidential

Sr Ab initio Developer

Responsibilities:

  • Developed and implemented processes that apply business rules to the customer and revenue data.
  • Worked with different Sources such as Oracle, SQL Server.
  • Enterprise wide templates were created for handling SCD, Error handling etc.
  • Sometimes to prepare Design documentgathering requirementsfrom the clients.
  • Extensively worked on Production issuesto do code fix.
  • Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
  • Generated DML files, XFR files specifies the Record format, which are used in components for building graphs in Ab Initio.
  • Used Enterprise Meta Environment (EME) for version control.
  • Designed and developed complex Aggregate, Join, look upand Update strategy transformation based on the business rules.
  • Created Dynamic lookup transformation to increase the session performance.
  • Responsible for migrating the folders or mappings and sessions from development to production environment.
  • Involved in resolving the loops, cardinalities, contexts and check the integrity of the universes
  • Creating Test cases for Unit Test, System Integration Testand UAT to check the data quality
  • Created UNIX shell script to automate the stop/start the information servers.
  • Created and used UNIX shell script in the pre/post session Ab Initio process to create/drop index and collect statistics of the warehouse tables.
  • Created UNIX shell scriptsfor FTP, merge and send success/failure mails
  • Created different types of reports, such as Master/Detail, Cross Tab and Chart.
  • Good Hands on experience with Ab initio CDC data capture tool.
  • Good Hands on experience with trade data in ETL process.
  • Worked extensively on trades, risk, instruments and risk factors.
  • Trade Data is fully automated data integration of cleared trades, accounts and portfolios
  • Trade Data is Customized integration with CRM, Research Automation and Back-Office systems
  • Trade Data is for various performance metrics, compliance rules, business thresholds and custom criteria
  • Trade Data Delivered as fully contained, pre-configured server to be plugged into our network.

Environment: Ab Initio, Control-M, SQL, Unix.

Confidential, Freemont CA

Sr. Ab initio Developer

Responsibilities:

  • Analyzed the systems, met with users and business units in order to refine the requirements.
  • Translated requirements into system solutions and developed implementation plan and schedule.
  • Defined and documented the technical specification designs of all programming applications.
  • Ensured that proper development processes and standards are followed, conducted code reviews.
  • Implemented Data cleansing and created DML for the XML files to be used in Ab-Initio.
  • Used various Programs, conditional components and transform functions, sub graphs, most components like datasets, filter, join, and sort, Partition etc and used lookups.
  • Responsible for developing data extracts and transformation programs.
  • Extensively used Ab-Initio GDE editor - Record Format editor, Key Specifier Editor, Transform Editor, Expression Editor, and Package editor.
  • Extensively used Unix shell scripting, general file manipulations, ftp etc
  • Took care of Performance Tuning and loading tasks.
  • Interacted with Oracle, Teradata databases to extract multiple tables from the database.
  • Participated in various stages of SDLC meetings on behalf of ETL, to facilitate refined definition of specs and requirements, and suggested correction spec docs etc, which many times facilitated in fruition of projects I handled.

Environment: Ab-Initio GDE 3.0, Ab-Initio Co>Operating System 3.0, Oracle, Teradata, Control-M, UNIX AIX, UNIX Korn Shell etc.

Confidential

Sr Ab Initio Developer

Responsibilities:

  • Analyzed the systems, met with users and business units in order to refine the requirements.
  • Translated requirements into system solutions and developed implementation plan and schedule.
  • Defined and documented the technical specification designs of all programming applications.
  • Ensured that proper development processes and standards are followed, conducted code reviews.
  • Implemented Data cleansing and created DML for the XML files to be used in Ab-Initio.
  • Used various Programs, conditional components and transform functions, sub graphs, most components like datasets, filter, join, and sort, Partition etc and used lookups.
  • Responsible for developing data extracts and transformation programs.
  • Extensively used Ab-Initio GDE editor - Record Format editor, Key Specifier Editor, Transform Editor, Expression Editor, and Package editor.
  • Extensively used Unix shell scripting, general file manipulations, ftp etc
  • Took care of Performance Tuning and loading tasks.
  • Created functions, procedures, packages, triggers in PL/SQL, utilized bulk load, bulk collect, dynamic SQL. Used SQL*Loader to load data from flat files. Designed small application schemas in Oracle.
  • Created and configured Ab-Initio scripts and wrapper scripts as Autosys jobs. Reviewed the status of the jobs running.
  • Participated in various stages of SDLC meetings on behalf of ETL, to facilitate refined definition of specs and requirements, and suggested correction spec docs etc, which many times facilitated in fruition of projects I handled.
  • Familiar with cloud-based technologies, AWS etc.
  • Good Hands on experience with Control-M.
  • Worked extensively on Ab Initio Express>IT, Query>IT, Acquire>IT etc.
  • Good Hands on experience with Ab initio DQE.

Environment: Ab-Initio GDE 3.0, Ab-Initio Co>Operating System 3.0, Oracle 10g, SQL,PL/SQL, Oracle, AutoSys, UNIX AIX, UNIX Korn Shell.

Hire Now