We provide IT Staff Augmentation Services!

Tech Lead Resume

0/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • Over 8 years of professional experience in IT Industry involving in various phases of Software development including system analysis, design, development, testing, implementation and production support
  • More than five years of experience in all teh phases of teh Datawarehouse life cycle involving Design, Development, Analysis and testing in teh various areas of Datawarehousing, ETL working wif Ab - Initio.
  • Worked extensively in teh GDE (Graphical Development Environment) configuring, connecting, and testing teh components to produce executable flow graphs on UNIX environment, Proficient wif various AbInitio Data Cleansing, Parallelism, and Transformation and Multi File System techniques.
  • Worked in Defects & Enhancement team, involved in Design, Development, Testing and Production Support for Various applications.
  • Extensive hands on experience on Oracle Stored procedures. Worked on database tools such as TOAD and SQL Loader.
  • Excellent analytical, oral, written, communication, and trouble shooting skills
  • TEMPHas flair to adapt to new software applications and products, self-starter, TEMPhas good communication and understanding of business workflow.
  • Effective team player wif excellent problem solving abilities, a willing and quick learner wif strong technical and communication skills.

TECHNICAL SKILLS

ETL Tools: AbInitio GDE 1.13, 1.14, 1.15, 3.1.4 Co-Operating system 2.13, 2.14, 2.15, Abinitio

Databases: Oracle 10g/9i/8i, SQL Server 7.0, DB2, and MS-Access.

Data modeling: Erwin 4.1 and Visio.

Operating Systems: Sun Solaris, HP-UX, UNIX, and Windows 9X/2000/NT/XP.

Languages: C, C++, COBOL, JAVA.

Web Design Tools: HTML, DHTML, XML, JAVA SCRIPT, VB SCRIPT, JSP and Apache

Server’s: Java Web server, Web Logic, Web Sphere.

SQL Interfaces: TOAD, SQLPLUS and Teradata SQL Assistance

Job Schedulers: Autosys, control - M, CA-7

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Tech Lead

Responsibilities:

  • Worked as teh onshore Tech Lead developer on SDP2 project.
  • Involved in analysis of DIME 1 and DIME2 projects before starting migration.
  • Implemented plans and psets as per DIME3 standards for old version code in DIME1/DIME2.
  • Involved in refactoring teh graphs by implementing resource pool changes and by using variousperformancetechniques.
  • ImplementedMulti-File Systemto store teh data in multiple files in multiple storage locations to improve teh performance
  • Enhancements tothe existing DMLs by adding new fields
  • Involved in Data Validation, Data Conversion and Data Reconciliation TestingusingSQL's
  • Designed and developedUNIX shell scriptsas part of teh ETL process and wrote wrapper scripts.
  • Involved in code review, QA turnover and bug fixes.
  • Implementing teh production, production parallel runs and cutover of lower DIME’s.

Environment: AbInitio GDE 3.1.4.1, AbInitio co>operating system 2.15, DB2, Toad, shell scripts (K-Shell), Oracle 10g,CA-7.

Confidential, Billerica MA

Sr Abinitio Developer

Responsibilities:

  • Designed data flows for staging and distribution process to load customer and account related information in Operational Data store.
  • Customer load process goes thru a trillium process which identifies teh Customer and loads it onto Database. Trillium Custom components are used in teh Abinitio graph to parse these records
  • We support teh system end to end. Complete Production support is taken care.
  • Implemented ETL staging (Serial and multi) and loading applications using Abinitio.
  • Scheduling of teh jobs is done wif teh help of Control M. Created many Control M Jobs to meet teh requirements
  • Accommodated Error Handling of rejected data by making provision for capturing and analyzing teh message and data separately.
  • Loaded operational data into Staging Tables, warehouse tables using Abinitio GDE and responsible for automating teh ETL process through scheduling.
  • Analyzed teh data flow and run statistics from Web EME.
  • Created wrapper scripts to execute teh graphs. Incorporated features for restart ability and rollback in case of a failure.
  • Involved in unit testing, System Testing and UAT for teh Abinitio applications.
  • Drafted detailed design document, coded and tested Data flows.
  • Implemented Rollouts for Production Releases.

Environment: AbInitio GDE 1.15, AbInitio co>operating system 2.15, PL/SQL, Toad, shell scripts (K-Shell), Oracle 10g

Confidential, Memphis TN

Abinitio developer

Responsibilities:

  • Involved in building AbInitio graphs using Graphical Development Environment
  • Designed, developed and unit tested AbInitio graphs for Extraction, Transformation and Loading of data from source to target
  • Migrated teh data from Teradata EDW environment to Oracle
  • Worked on AbInitio multifile system and used partition components for better performance and when dealing wif large volumes of data.
  • Used AbInitio Components like Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, dedup, runsql etc
  • Involved in creating teh Generic graph for pulling teh Data from teh Teradata edw tables and load into oracle tables
  • Modified teh AbInitio components parameters, utilize data parallelism and theirby improve teh overall performance to fine-tune teh execution times
  • Converted all SAS scripts to UNIX shell scripts
  • Developed UNIX shell scripts and scheduled teh jobs using
  • Worked on creating PL/SQL queries to obtain data from teh database for AbInitio graphs
  • Designed, developed and deployed necessary stored procedures, Functions in Oracle using TOAD and in Teradata using teradata sql assistant
  • Involved in unit testing, integration testing and creating test case document

Environment: AbInitio GDE 1.15, AbInitio co>operating system 2.15, PL/SQL, Toad, shell scripts (K-Shell), Oracle 10g, Teradata Sql assistant

Confidential, Charlotte, NC

AbInitio Developer

Responsibilities:

  • Involved in development of AbInitio graphs for loading and extracting data from various schemas relating to Oracle databases.
  • Involved in creating sandbox in ab-inito through GDE and as well running teh shell script.
  • Involved in developing complex graphs based on teh business requirement and writing wrapper scripts for teh deployed scripts of those graphs.
  • Monitor teh daily/weekly/monthly jobs.
  • Responsible for creating a 12 way multi file system dat is composed of individual files on dat are partitioned and stored in distributed directories
  • Code migration from development to QA, QA to production environment using change man procedures.
  • Writing teh UNIX scripts, awk programming to deploy teh AbInitio graphs thru wrapper scripts.
  • Fixing teh Performance issues for teh AbInitio graphs
  • Review teh test results and get UAT sign off before promoting teh code to production environment.
  • Setup all ETL jobs thru OPC scheduler.

Environment: AbInitio (GDE 1.12.1, Co>Op System 2.15.8), Oracle 9i, UNIX, OPC scheduler.

Confidential, Seattle, WA

AbInitio Developer / Offshore Co-ordinate

Responsibilities:

  • Involved in creating Macro and Micro Level design documents.
  • Involved in design reviews of All ETL Modules for Business Planning project.
  • Involved in Design and Development reviews and provided Tuning Techniques on AbInitio Graphs
  • Involved in creating teh documents like Operation Instructions Document, Load Approach Process for Abinitio Application Support.
  • Used Reformat, Partition by key, Sort and Join Components extensively in AbInitio graphs.
  • Implemented MFS file system dat is composed of individual files on different nodes dat are partitioned and stored in distributed directories.
  • Loading teh Data by Using teh AbInitio tool. Used 4 ways, 8 way parallelism for processing teh AbInitio components.
  • Involved in Scheduling, Creating and running teh Jobs wif Autosys.
  • Build shell scripts to clean up teh files and other functions.
  • Wrote procedures, triggers etc to enhance teh performance by using PL/SQL.
  • Worked extensively in UNIX environment by accessing teh files, changing permissions to them and building scripts.
  • Involved in writing teh Unit Test Cases for teh applications.
  • Created Various Best Practices Documents for Development and Support Activities.
  • Closely Interacted wif SIT Team to perform various data validation, system test, Stress test or regression test process.

Environment: AbInitio GDE 1.13, AbInitio co>operating system 2.13, PL/SQL, SQL*Plus, Sun Solaris 8 UNIX, shell scripts (K-Shell), Oracle 9.2.

Confidential, Chicago, IL

J2EE Developer

Responsibilities:

  • Developed teh web application using Struts Framework.
  • Developed entire application based on STRUTS framework and configured struts - config.xml, web.xml
  • Implemented validation framework for creation of validation.xml and used validation-rules.xml.
  • Developed Classes in Eclipse for Java, using teh Class Specification provided in Rational Rose.
  • Developed Java code for teh Swing user interface down through calling of stored procedures
  • Designed, developed and deployed necessary stored procedures, Functions, views in Oracle using TOAD.
  • Developed Session Fa ade wif Stateless Session Beans for coarse-grained functionality.
  • Developed Stateless Session beans, and Entity beans.
  • Actively involved in deploying and performance tuning teh application on web logic 8.1 Application servers.
  • Developed test scripts for Integration testing, User case testing.
  • Developed JUnit test cases for EJB services.

Environment: Java 1.5, J2EE, Struts, Swing, UML/Rational Rose 2000, Web services (SOAP, WSDL, UDDI)Web Logic, Eclipse, JSP, JMS, XML, XSL, Ant, JNDI, EJB, Servlets, Oracle 8.1, Toad.

We'd love your feedback!