We provide IT Staff Augmentation Services!

Technical Lead Consultant Resume

5.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY:

  • Over 9 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing, Reporting and Software Applications.
  • Over 9 years of Exclusive Experience in Ab Initio (GDE, Co>operating system).

    Expertise in ETL tools using Ab Initio (GDE, Co>operating system), Ab initio products like Metadata Hub, Data profiler etc., Informatica and SQL Loader for data migration to Enterprise Data Warehouse.

  • 3+ years of strong Teradata along with SQL Assistant and BTEQ experience. Solid skills and expert knowledge of Teradata version 2R5.x/6.x/13.x and utilities including TPUMP, MLOAD, FASTLOAD and FASTXPORT.
  • Experience in Ab Initio EME/Sandbox to implement version control and impact analysis to manage various project across the organization.
  • Excellent knowledge on Business Rule Engine (BRE) and Application Configuration Environment (ACE).
  • Extensive knowledge of using Metadata Importer for importing metadata from an EME Technical Repository and other sources like ETL tools, Reporting tools (Business Objects etc.) and databases (Oracle, Teradata etc.) for building data lineage
  • Extensive experience on developing Ab Initio Batch and Continuous Flow applications.
  • Worked with MFS file system to implement MPP architecture for ETL process using Ab Initio tool.
  • Performance tuning the complex Ab Initio graph, worked with tuning the memory parameter and Ab Initio best practice approach to implement the ETL process
  • Ability to demonstrate command and use of industry accepted Ab Initio best practices and have completed terabyte level solutions preferably at multiple separate environments
  • Worked extensively in the GDE (Graphical Development Environment) configuring, connecting, and testing the components to produce executable flow graphs on UNIX environment, Proficient with various Ab Initio Data Cleansing, Parallelism, and Transformation and Multi File System techniques.
  • Thorough knowledge of DML (Data Manipulation Language), Unix Shell scripting (Korn and Bourne).
  • Developed various UNIX shell wrappers to run Ab Initio and Data base jobs. Practical experience with working on multiple environments like production, development, testing.
  • Excellent knowledge in Batch Jobs using UNIX CRON, AWK, UNIX Shell Script (csh, bash, ksh).
  • Designed/Created several Multiload / Fastload scripts to load the staging/target tablesConfigured Ab Initio environment to connect to the Teradata database using db config, Input Table and Output Table Components.
  • Strong skills in defining and implementing solutions, tools, processes and procedures to provide enterprise data integration and ETL services that meet business requirements
  • Knowledgeable/experienced in data warehousing Teradata utilities & MS Reporting, over 3 years experience in analysis, design, and development of SQL Server Working knowledge of RMI, CORBA and IDL generation and mapping Servlets, JSP, and web tools like HTML, Java script, VB Script, Perl and ASP for java language.
  • Conceptualized and implemented p - sets. Generic graphs and other ab-initio best practices.
  • Excellent Knowledge of Business Intelligence and Data Warehousing Concepts.
  • Worked extensively on Business Objects, Crystal Reports, Oracle and MS SQL Server.

    Good Experience in Analysis and Design of Logical and Physical Database Models by using Erwin tool and good understanding of Data Modeling Methodologies Star Schema and Snowflake Schema.

  • Good Experience working with various Heterogeneous Source Systems like Oracle, MS SQL Server, Teradata, DB2 UDB, Flat files and Legacy Systems.
  • Proficient in designing and developing database applications using Visual Basic as front-end and RDBMS (SQL Server, MS-Access, and Oracle) as backend using ADO, DAO and RDO objects.
  • Proficient in writing Stored Procedures, User Defined Functions and Triggers using T-SQL.
  • Generated p-sets for running generic graphs
  • Worked extensively on continuous flow applications.
  • Good experience working with very large databases and Performance tuning.

TECHNICAL SKILLS:

ETL Tools: Ab Initio (GDE 1.1x/3.x, Co>Operating System 2.1x,3.x), Informatica, SQL*Loader and Teradata utilities

Database: Sybase SQL, Oracle 9i/8i/7.x, MS SQL Server 2000/2005, DB2 UDB, MS Access 2000/7.0 and Teradata V2RX,13.10

Testing Tools: Win Runner, Load Runner, Test Director, and Quick Test Pro.

Operating Systems: Microsoft Windows XP/2003/2000/9i/NT, IBM AIX Unix 4.2, Red Hat Linux 8, IBM OS/390 version 2.8, Sun Solaris 8 and DOS

Languages: C, C++, Perl, SQL, PL/SQL, Transact SQL, Interactive SQL, UNIX Shell scripting, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Technical Lead Consultant

Responsibilities:

  • Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
  • Responsible for creating and executing development plans
  • Excelled guiding and managing technical resources within project schedule and.
  • Scheduling status meeting to get the status updates and discuss ongoing issue and blockers.
  • Responsible for updating project manager regarding status of development efforts.
  • Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
  • Handled the tasks of identifying system deficiencies and implementing effective solutions
  • Handled the responsibilities of managing technical risks throughout the project.
  • Drove impressive improvements across the business as a result of IT implementations.
  • Created cost-benefit analyses and ROI assessments that were used as the basis for decision-making on proposed IT implementation projects.
  • Developed Conduct>IT plans and sub-plans by integrating graphs, scripts and programs.
  • Worked on enhancement of existing Ab Initio applications also made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
  • Conducted and participated in design reviews to support Best Practices.
  • Performed code reviews and supervised junior developers
  • Performing Unit testing and involved in the System Integrated testing and regression testing to make sure downstream applications are not impacting.
  • Scheduled jobs using Control-M scheduler

Environment: Ab Initio 3.0.1 with Co>Op 3.0.1, SQL Server 2008, Teradata 13.10, UNIX, Windows 7, Control-M.

Confidential, Durham, NC

Ab Initio Lead Consultant

Responsibilities:

  • Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
  • Responsible for creating and executing development plans
  • Responsible for managing technical resources (Onshore and Offsite) within project schedule and.
  • Scheduling status meeting to get the status updates and discuss ongoing issue and blockers.
  • Responsible for updating project manager regarding status of development efforts.
  • Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
  • Handled the tasks of identifying system deficiencies and implementing effective solutions
  • Handled the responsibilities of managing technical risks throughout the project
  • Developed graphs using Ab Initio components such as join, rollup, lookup, partition by key, partition by Round-Robin, interleave, gather, dedup sorted, scan, reformat and validate on newer version of Ab Initio.
  • Developed Continuous Flow applications using Ab Initio continuous components like subscribe, MQ subscribe, Multipublish, Publish, Continuous join with DB, Continuous update table.
  • Developed Conduct>IT plans and sub-plans by integrating graphs, scripts.
  • Worked on enhancement of existing Ab Initio applications and made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
  • Extensively utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
  • Performed code reviews and supervised junior developers.
  • Performing Unit testing on dev box and involved in the System Integrated testing on test box.

Environment: Ab Initio 3.1.7 with Co>Op 3.1.7, SQL Server 2008, Teradata 13.10, UNIX, Windows 7, Control-M.

Confidential, Dallas, TX

Ab Initio Lead Consultant

Responsibilities:

  • Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
  • Responsible for creating and executing development plans
  • Responsible for managing technical resources within project schedule and budgets and involved in recruiting the resources.
  • Responsible for updating project manager regarding status of development efforts.
  • Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
  • Handled the tasks of identifying system deficiencies and implementing effective solutions
  • Handled the responsibilities of managing technical risks throughout the project
  • Developed graphs using Ab Initio components such as join, rollup, lookup, partition by key, partition by Round-Robin, interleave, gather, dedup sorted, scan, reformat and validate on newer version of Ab Initio.
  • Implemented Ab Initio Plans and continues flows for some applications.
  • Worked on enhancement of existing Ab Initio applications and made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
  • Extensively utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
  • Performed code reviews and supervised junior developers
  • Performing Unit testing on dev box and involved in the System Integrated testing on test box.

Environment: Ab Initio 1.14 GDE with Co>op 2.14 Version, Ab Initio 3.1.1 with Co>Op 3.1.2, Oracle Database, Teradata, UNIX, Windows XP, Tivoli Work Scheduler.

Confidential, Cleveland, OH

Lead Ab Initio Developer

Responsibilities:

  • Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
  • Responsible for creating and executing development plans
  • Responsible for managing technical resources within project schedule and budgets and involved in recruiting the resources.
  • Responsible for updating project manager regarding status of development efforts.
  • Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
  • Handled the tasks of identifying system deficiencies and implementing effective solutions
  • Handled the responsibilities of managing technical risks throughout the project
  • Developed graphs using Ab Initio components such as join, rollup, lookup, partition by key, gather, dedup sorted, scan, normalize, reformat and validate.
  • Extensively utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
  • Performed code reviews and supervised junior developers
  • Performing Unit testing on dev box and involved in the System Integrated testing on test box.
  • Performance tuning the complex Ab Initio graph, worked with tuning the memory parameter and Ab Initio best practice approach to implement the ETL process.
  • Created SCLM members to schedule the Ab Initio jobs on Tivoli Workstation Scheduler.

Environment: Oracle Database, Ab Initio 1.14 GDE with Co>op 2.14 Version, UNIX - Solaris SunOS 5.10, Windows XP, Mainframe, Cognos.

Confidential, Phoenix, AZ

Application Architect Consultant

Responsibilities:

  • Had conceived data from sources, cleansed, transformed and loaded in to target databases using an ETL tool, Ab Initio.
  • Had developed shell scripts that customize Ab Initio graphs prepared using graphical interface, GDE that processes multiple queries on large data.
  • Had been responsible for replicating operational tables, transform and load data into operational data using ETL techniques.
  • Worked on modifying the Ab Initio component parameters utilized data parallelism and thereby improved the overall performance by optimizing the execution time.
  • Extensive experience working with branches in EME and co-ordinating with other teams to merge them
  • Designed and developed AI Graphs for large projects in the Retention Marketing Domain.
  • Had worked on modified DML and supported graph changes pertaining to Unix to Linux
  • Had worked on migration of Ab Initio based applications (migration effort).
  • Developed AI graph based fast-track ad-hoc projects marketing and legal support.
  • Conducted and participated in design reviews to support Best Practices.
  • Analyzed financial data reports intended for executive consumption.
  • Debugged shell scripts and Perl based code that worked in conjunction with the Event Engines.
  • Mentored recent hires in data warehouse operational and adhoc data extraction projects.
  • As a Team Lead in some of the critical IMC projects managed and worked with the team developers and DBA’s to meet the deadlines of the related projects.
  • Involved in the creation of Ab-Initio Graphs to extract, transform and load the data from mainframes.
  • Data cleansing operations were performed on the graphs using data cleansing functions.
  • Configured Ab Initio environment to connect to the Sybase database using db config, Input Table and Output Table Components.
  • Created test plans for all Ab Initio graphs.
  • Created and Performed reviews of all ETL designs, graphs, and test plans.
  • Tested the data using SQL on the database to check whether the abinitio graphs are doing what it's supposed to do.
  • EME and CVS both has been used for version control simultaneously.
  • Performed Unit testing on dev box and, System testing, and Integrated testing on test box.
  • Created Event Engine Scheduling jobs for Ab Initio graphs.
  • Designed/Created several Unix scripts with data transformations for loading the base tables data to Sybase database to apply the business rules manipulate and/or cleansing the data according to the requirements.
  • Working with the Microstrategy reporting team in ensuring the availability of data required for reporting needs and involved in developing Microstrategy reports for business reporting needs.
  • SLA (Service Level Agreements) for the new processes were identified and documented

Environment:: Sybase ISQL 9.0.1, Ab-Initio 1.13.22 GDE with Co>op 2.13.1, Unix - Solaris SunOS 5.10, Perl, Microstrategy, Windows XP, XML, COBOL,RCS Version 5.7, Mainframe.

Confidential, Summit, NJ

Senior Ab Initio Developer

Responsibilities:

  • 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.
  • Had conceived data from sources, cleansed, transformed and loaded in to target databases using an ETL tool, Ab Initio.
  • Had developed shell scripts that customize Ab Initio graphs prepared using graphical interface, GDE that processes multiple queries on large data.
  • Had been responsible for replicating operational tables, transform and load data into operational data using ETL techniques.
  • Designed/Created several scripts to load the staging/target tables Configured Ab Initio environment to connect to the Teradata database using db config, Input Table and Output Table Components Had been responsible for scheduling and exception-handling routines on designed ETL processes.
  • Worked on modifying the Ab Initio component parameters utilized data parallelism and thereby improved the overall performance by optimizing the execution time.
  • Extensive experience working with branches in EME and co-ordinating with other teams to merge them
  • Designed and developed AI Graphs for large projects in the Retention Marketing Domain.
  • Had worked on modified DML and supported graph changes pertaining to Unix to Linux
  • Had worked on migration of Ab Initio based applications (migration effort).
  • Developed AI graph based fast-track ad-hoc projects marketing and legal support.
  • Conducted and participated in design reviews to support Best Practices.
  • Analyzed financial data reports intended for executive consumption.
  • Debugged shell scripts and Perl based code that worked in conjunction with AutoSys.
  • Involved in the creation of Ab-Initio Graphs to extract, transform and load the data from mainframes.
  • Data cleansing operations were performed on the graphs using data cleansing functions.
  • Configured Ab Initio environment to connect to the Oracle database using db config, Input Table and Output Table Components.
  • Created test plans for all Ab Initio graphs.
  • Created and Performed reviews of all ETL designs, graphs, and test plans.
  • Tested the data using Informix SQL on the database to check whether the abinitio graphs are doing what it's supposed to do.
  • EME and Harvest both has been used for version control simultaneously.
  • Performed Unit testing on dev box and, System testing, and Integrated testing on test box.
  • Created Autosys scheduling jobs for Ab Initio graphs.
  • Designed/Created several BTEQ scripts with data transformations for loading the base tables to Teradata database to apply the business rules manipulate and/or cleansing the data according to the requirements.
  • SLA (Service Level Agreements) for the new processes were identified and documented

Environment:: Oracle 8i/9i/10g, ERWIN, Ab-Initio 1.14.15 GDE with Co>op 2.13.1 patch level 40 built on AIX5-2-n32mt, Unix - Solaris, HP superdome/RP 8400, Perl, Brio/Hyperion, Windows NT/2000, XML, COBOL, DB2,RCS Version 5.7, Teradata Utilities (BTEQ, Fastload, Multiload, Tpump).

Confidential, Deerfield, IL

Data warehouse Consultant

Role and Responsibilities

  • Had conceived data from sources, cleansed, transformed and loaded in to target databases using an ETL tool, Ab Initio.
  • Had developed shell scripts that customize Ab Initio graphs prepared using graphical interface, GDE that processes multiple queries on large data.
  • Had been responsible for replicating operational tables, transform and load data into operational data using ETL techniques.
  • Had worked on huge graphs using Ab Initio components such as join, rollup, lookup, partition by key, partition by round robin, gather, merge, interleave, dedup sorted, scan, aggregate, reformat and validate.
  • Had been responsible for scheduling and exception-handling routines on designed ETL processes.
  • Had working on modifying the Ab Initio component parameters, utilized data parallelism and thereby improved the overall performance by optimizing the execution time.
  • Extensively used rollup, multi-reformat, aggregate components and created summary tables.
  • Had utilized various MFS techniques to achieve parallelism.
  • Had deployed graphs on to test & staging environments and scheduled batch-jobs.
  • Had developed and tested the warehouse application according to functional specifications using Ab Initio, UNIX shell scripts.
  • Worked on improving and enhancing the production environment and achieved performance.

    Responsible to create different Generic Graphs using the Ab-Initio components for ODS and DSS environment.

  • Responsible for creating Ab-Initio graphs for click stream analysis of data gathered by running web campaigns.
  • Implemented Ab-Initio configuration and well tuned setting up environment for Production and development environment.
  • Responsible for deploying Ab-Initio graphs and running them through the Cooperating systems mp shell command language.
  • Involved in optimizing and testing a database package, frequently used in isolating potential data-transformation needs prior to a PS engagement. Coded in Shell and SQL supported by an Oracle 9i and this program causes matching between a source and target warehouse.
  • Communication with the Data modeler and other Business Leads was of paramount importance, to analyze and implement the process.
  • Documented Production support guide, Release Management Plans and Technical Recovery Scripts for Integrated Production Support (IPS) applications

Environment: Ab Initio Co-Op 2.13, Ab Initio GDE 1.13, UNIX, Oracle 10g, DB2, Visio, Crystal Reports, Clear Case.

We'd love your feedback!