SUMMARY:

• 10+ years of IT experience working in D Confidential Analysis, D Confidential Warehouse/D Confidential Mart design, development, UNIX/SQL, D Confidential Analysis and documentation.
• Strong experience in Business and D Confidential Analysis, D Confidential Profiling, D Confidential Migration, D Confidential Integration and Metad Confidential Management Services.
• Experience in D Confidential Analysis & Integration efforts involving HADOOP along with ETL.
• Expert - level mastery in designing and developing complex mappings to extract d Confidential from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Terad Confidential .
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Experienced in System Administration, Analysis and Testing Implementation of client server applications.
• Expertise in Rational Unified Process (RUP) Best Practices methodology, Use Cases, Software Development Life Cycle (SDLC) processes and Object Oriented Design Technologies
• Hands on experience in development of D Confidential Warehouses/D Confidential Marts using Ab Initio Co>OP, GDE, Component Library, Oracle and UNIX Shell Scripting for mainly Banking/Financial/Credit Card industries.
• Experience in D Confidential Warehousing concepts like Dimensional Modeling/ Kimball Methodology, Star Schema, Snowflake Schema and ETL.
• Experience on Apache Hadoop technologies Hadoop distributed file system (HDFS), MapReduce framework, Pig, Hive
• Worked with Terad Confidential utilities like Fast Load, MultiLoad, etc.
• Worked in PVCS and EME D Confidential store for source control maintenance and analyzing dependencies within and between various graphs.
• Experience in migrating applications from one EME D Confidential store to another.
• Experienced in interacting with EME D Confidential store with several air commands.
• Hands on experience with code implementations on mainframe and unix.
• Well versed with various Ab Initio parallelism techniques and implemented number of Ab Initio Graphs using D Confidential parallelism and Multi File System (MFS) techniques
• Experience in integration of various d Confidential sources such as flat files, ASCII, EBCDIC files, XML files, DB tables etc.
• Also experienced in working with Mainframe D Confidential Files, COBOL Copybook
• Well versed in UNIX shell(ksh,bsh), Perl and wrapper scripts.
• Reasonable noledge in Stored Procedures, Functions, Triggers, Indexes and Cursors using SQL and PL/SQL.
• Excellent analytical, interpersonal and communication skills with aptitude to assimilate new technologies.
• Excellent ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS:

ETL Tools: Ab Initio Co>Os, Wherescape RED, Informatica 9.0, Talend 6.0

DSS/Reporting: Business Objects 5.x/6.x/XI, (Infoview, WebI), Crystal Reports

RDBMS: Tered Confidential V2R5, Oracle 8i/9i/10g, SQL Server, DB2, MySql Cluster

Tools & Languages: TOAD, Autosys, VB, SQL, PL/SQL, C, TSO Mainframe

Designing Tools: Microsoft Visio 2000, Erwin 4.1

Operating System: Windows 95/98/2000/NT, UNIX (Sun, SCO, AT&T), MS DOS

Methodologies: Dimensional modeling of STAR, SNOWFLAKE

PROFESSIONAL EXPERIENCE:

Sr. ETL Developer,

Confidential, Dallas

Responsibilities:

• Involved in building teh Impression application through incremental, Iterative work cadences using SCRUM Agile methodology based upon teh incremental, cooperative and Adaptive measures.
• Responsible for managing and maintaining teh quality of teh Analytics being generated using business intelligence provided by Impression Platform.
• Designed and Developed ETL Jobflows using Talend Enterprise edition.
• Handled importing d Confidential, performed transformations using Talend on Hive and loaded d Confidential into HDFS
• Created Oozie workflows to run multiple Hive and Pig Jobs which run independently with time and d Confidential availability.
• Involving in doing teh code check-in and check-out process in GIT version control tool.
• Documented ETL unit test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test d Confidential for testing, error handling and analysis.

Environment: Talend v 5.6, Hortonworks Cluster, Hive, Pig, MySQL Cluster, SQL Server, Oozie,

Confidential, Plano,

Responsibilities:

• Requirement gathering, analysis and designing technical specifications for teh d Confidential migration according to teh business requirement.
• Performed d Confidential mapping from source to target.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and documented them in a format dat can be reviewed and understood by both business people and technical people.
• Created D Confidential Model for teh application using MS-Visio.
• Extensively used SQL for accessing and manipulating d Confidential base systems
• Developed teh ELT flow with Wherescape RED Tool.
• Performed Acceptance Testing (UAT), Unit Testing and Documenting.
• Maintained a close and strong working relationship with team mates and management staff to achieve expected results for teh project team.
• Used Agile methodology for repeated testing.

Environment: Wherescape RED, Terad Confidential, Oracle 11g, MS-Visio, RED Scheduler.

Confidential, Dallas

Responsibilities:

• Requirement gathering, analysis and designing technical specifications for teh d Confidential migration according to teh business requirement.
• Developed logical and physical dimensional d Confidential models using ERWIN.
• Designed, developed and improved complex ETL structures to extract transform and load d Confidential from multiple d Confidential sources into d Confidential warehouse and other d Confidential bases based on business requirements.
• Worked extensively on various Terad Confidential load utilities like FastLoad, MLoad & TPump to populate d Confidential into Terad Confidential tables.
• Planned and coordinated testing across multiple teams, tracked and reported status, created testing cycle plan, scenarios etc.
• Troubleshoot d Confidential issues, validated result sets, recommended and implemented process improvements.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of d Confidential extracts before loading it to D Confidential Warehouse

Environment: Informatica Power Center 8.5/9.1, Terad Confidential, Oracle 11g, Erwin, PL/SQL, Auto-Sys Scheduler.

Confidential, CO

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized d Confidential models for D Confidential warehouse supporting d Confidential from multiple sources on real time
• Involved in building teh ETL architecture and Source to Target mapping to load d Confidential into D Confidential warehouse.
• Created mapping documents to outline d Confidential flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of teh D Confidential warehouse and used Erwin to design teh business process, dimensions and measured facts.
• Extracted teh d Confidential from teh flat files and other RDBMS d Confidential bases into staging area and populated onto D Confidential warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Created complex mappings using Aggregator, Expression, Joiner, Filter, Sequencer, Procedure, connected & unconnected Lookup, Filter and Update Strategy transformations using Informatica PowerCenter Designer
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load d Confidential from flat files to teh d Confidential base tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test teh mappings and fixed teh bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move teh mappings from development to testing and tan to production repositories.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, D Confidential Analyzer 8.1, PL/SQL, DB2, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos 8.

Confidential, Atlanta

Responsibilities:

• Involved in requirement study, analysis and design of teh system.
• Involved in defining programming standards, d Confidential base design, program development and finally testing and implementing teh system
• Used EME for checking and checkout for graphs and also maintains graph versions.
• Designed and developed teh Ab Initio graphs to standardize teh d Confidential validation.
• Worked on Terad Confidential BTEQ scripts to load d Confidential into teh Tables.
• Created various UNIX Shell Scripts for scheduling various d Confidential cleansing scripts and loading process.
• Scheduled Maestro jobs for teh ETL graphs dat need to be run in production.

Environment: Ab Initio, Terad Confidential, Oracle, Unix, Maestro

Confidential, Tampa

Responsibilities:

• Involved in requirement study, analysis and design of teh system.
• Involved in defining programming standards, d Confidential base design, program development and finally testing and implementing teh system
• Used EME for checking and checkout for graphs and also maintains graph versions.
• Designed and developed teh Ab Initio graphs to standardize teh d Confidential validation.
• Written JIL scripts for teh corresponding graphs and deployed in teh Dev Environment.

Environment: Ab Initio, Oracle, Autosys, Excel-2003

Confidential, VA

Responsibilities:

• Involved in requirement study, analysis and design of teh system.
• Involved in defining programming standards, d Confidential base design, program development and finally testing and implementing teh system
• Used EME for checking and checkout for graphs and also maintains graph versions.
• Designed and developed teh Ab Initio graphs to standardize teh d Confidential validation.
• Stored Procedures and Triggers were written to implement teh business logic and auditing.
• Written JIL scripts for teh corresponding graphs and deployed in teh Dev Environment.
• Coordinated teh Development and Implementation of Strategic Plans

Environment: Ab Initio, Oracle, Autosys, Excel-2003

Confidential, NY

Responsibilities:

• Involved in requirement study, analysis and design of teh system.
• Involved in defining programming standards, d Confidential base design, program development and finally testing and implementing teh system
• Used EME for checking and checkout for graphs and also maintains graph versions.
• Designed and developed teh Ab Initio graphs to standardize teh d Confidential validation.
• Developed several stored procedures and functions to make teh existing code to be executed.
• Used Ab-Initio d Confidential profiler for d Confidential cleansing and analysis .
• Coordinated teh Development and Implementation of Strategic Plans

Environment: Ab Initio, BRE, Oracle, SQL Server, Excel-2003

Confidential, NY

Responsibilities:

• Involved in requirement study, analysis and design of teh system.
• Involved in defining programming standards, d Confidential base design, program development and finally testing and implementing teh system
• Used EME for checking and checkout for graphs and also maintains graph versions.
• Designed and developed teh Ab Initio graphs to standardize teh d Confidential validation
• Used Ab-Initio d Confidential profiler for d Confidential cleansing and analysis .
• Coordinated teh Development and Implementation of Strategic Plans

Environment: Ab Initio, Oracle, Mainframes, Unix, Sybase

Confidential, AZ

Responsibilities:

• Involved in requirement study, analysis and design of teh system.
• Involved in defining programming standards, d Confidential base design, program development and finally testing and implementing teh system
• Used EME for checking and checkout for graphs and also maintains graph versions.
• Developed High level and Detail Designs for teh application
• Developed standard process to extract teh d Confidential from mainframe to teh client server environment
• Designed and developed teh Ab Initio graphs to standardize teh d Confidential validation
• Used Ab-Initio d Confidential profiler for d Confidential cleansing and analysis .
• Developed Ab Initio graphs to load teh d Confidential into teh Terad Confidential d Confidential base
• Coordinated teh Development and Implementation of Strategic Plans
• Wrote teh JIL’s and Scheduled teh Job’s using Autosys.
• Compiled and wrote postmortem reports for internal and external parties for production issues and outages.
• Updated new logics in shell program and perl script.
• 24/7 Production Support.

Environment: Ab Initio, Oracle, Mainframes, Terad Confidential, SQL Server, DB2, Java, Autosys, ClearCase, ClearQuest, HTML/XML, MQ Series, AIX, Linux, Business Objects, Crystal Reports, ERWIN

Confidential, Virginia

Responsibilities:

• Helped with teh installation of Ab Initio Co-Operating system
• Set up Sandbox and teh configuration scripts for teh project
• Worked with teh implementation of metad Confidential with Ab Initio EME
• Used FTP, Compress and Uncompress components to transfer huge amounts of d Confidential between different nodes and graphs
• Used EME for all aspects of d Confidential processing system from design information to operations d Confidential .
• Implemented a multi-phase application for consolidating groups of records from different OLTP sources into an ODS
• Used terad Confidential for unconditional parallelism, with load distribution shared among several servers.
• Created Ab Initio multi-file system shell scripts on different nodes, which can process multiple partitions of d Confidential
• Created numerous Ab Initio graphs, utilizing Rollup, Join, Sort, Replicate, Partition components to speed up teh ETL process
• Handled Ab Initio Metad Confidential repository for technical and business information about teh warehouse.
• Developed system level and application level configuration scripts using Shell Scripting. Also developed shell scripts for Batch Processing and start and end scripts for invoking teh Ab Initio graphs
• Responsible for creating and expanding teh Ab Initio EME meta model in teh terad Confidential d Confidential base.
• Worked on EME for checking in and checking out of objects (graphs and related files) and updating teh DEV EME D Confidential store.
• Developed an ETL process to update teh ODS d Confidential base with teh new and changed records as a result of transactions at teh end of each month
• Improvised teh existing Ab Initio ETL process by identifying bottlenecks in teh graphs and modifying them to make better use of teh resources by utilizing teh capabilities of teh tool

Environment: Ab Initio GDE (1.08), Co>Operating System (2.08), Terad Confidential, HTML/XML, Oracle 8i, Business Objects, SQL Server, MQ Series, UNIX.

Confidential, NJ

Responsibilities:

• Developed d Confidential staging and loading scripts by using Ab Initio, UNIX Shell and Oracle SQL*Loader tools
• Performed evaluation of vendors for selecting an appropriate ETL Tool.
• Developed High level and Detail Designs for teh application.
• Set up teh EME environment and implement teh sandbox environment across teh EDW.
• Set up teh ETL environment (implementing parallelism, administer teh environment and developed teh wrapper to run teh application through teh scheduling tool).
• Responsible for ground up physical and logical design of select Oracle Staging D Confidential Warehouse.
• Developed Ab Initio graphs to read teh transaction d Confidential files and tan reformat, filter, aggregate teh d Confidential before loading them into Oracle d Confidential base.
• Developed, designed, tested and implemented Abinitio graphs for all fact tables.
• Involved in relational design, table design, and indexing strategy.
• Ab Initio’s Co>Operating System to extract, transform and integrate d Confidential from multiple d Confidential source and performed parallel d Confidential cleansing and validations using Ab Initio.
• Developed a D Confidential Manager tools dat read all teh day to day transactions related d Confidential from different Account type files and apply teh changes to teh centralized d Confidential base.
• Schedule different jobs in teh AppWorx software dat call PERL or UNIX Shell scripts run against teh central d Confidential base to change teh supplied d Confidential, purging old d Confidential, etc.
• Involved in defining programming standards, d Confidential base design, program development and finally testing and implementing teh system
• Worked with business unit VP’s for development, acceptance and implementation of strategic and technical business unit for plastics and pins applications

Environment: Ab Initio, Mainframes, Oracle, Java, HTML/XML, AIX, Microstrategy, Business Objects, Crystal Reports, ERWIN, Visio