Yyyyyy x. yyyyyy

Senior ETL / DataStage Developer

Data Warehouses ~ ETL Design, Development & Testing ~ Large-Scale Implementations

DataStage ~ Data Migration ~ Product Support ~ Requirements Gathering ~ Team Leadership

         Possess more than 15 years IT experience with specialization in client/server systems and analysis, design, development, testing, and implementation of cutting-edge decision support systems (DSS).

         Substantial talents in loading and maintaining data warehouses and data marts using IBM DataStage (Manager, Designer, Director, Administrator), and Extraction Transformation and Loading (ETL) processes via DataStage, Ab Initio, and Informatica.

         Well-versed in Hadoop technologies (HiveQL, Pig Latin, MapReduce), NoSQL databases (HBase, Cassandra, MongoDB), dimensional modeling, and loading extremely large volumes of data.

         Highly adept at writing, testing, and implementation of triggers, procedures, and functions at database level using SQL.

         Expert at defining derivations and business rules used by ETL for mapping source data to facilitate population of warehouse and data marts.

         Extensive experience in designing, compiling, testing, scheduling, and running DataStage jobs for broad-scope initiatives.

Clients & Project Highlights:

Fannie Mae, Reston, VA, Jul 2014 Present

Senior ETL Developer

         Currently developing ETL application and data warehouse applications for Servicers Reconciliation Facility project requiring extensive use of Ab Initio software to design graphs.

         Prepare detailed design document for necessary modules and automate batch processes via Unix shell scripting.

         Support testing efforts and strategically tune Ab-Initio jobs to enhance query performance.

Freddie Mac, McLean, VA, Oct 2012 Jun 2014

Senior DataStage Developer / Lead

         Played a lead role in developing Corporate Data Warehouse to centralize data from transaction processing and end-user systems into one relational database to streamline decision support function.

         Developed and implemented business logic and ETL mechanism to populate Corporate Data Warehouse.

         Generated data quality reports and optimized SQL queries to elevate performance.

         Spearheaded Parallel Extender jobs to improve job performance while working with bulk data sources.

         Leveraged Data Stage Director software to validate, administer, and monitor DataStage jobs.

         Participated in mainframe file conversions and closely partnered with testing team to achieve QA goals.

Fannie Mae, Herndon, VA, Apr 2010 Sep 2012

Senior ETL Developer

         Supported reengineering effort to transition several major legacy systems to a new architecture and platform.

         Proficiently used Ab-Initio as ETL tool to pull, cleanse, and transform data from source systems and load into databases.

         Applied sharp technical acumen toward developing graphs and extensively using Unix KSH scripting.

         Enhanced Ab-Initio jobs to improve query performance and developed interfaces to automate batch processes.

Continued ►

Professional Experience continued Yyyyyy x. yyyyyy Page 2 of 2

Freddie Mac, McLean, VA, Oct 2008 March 2010

Senior DataStage Developer

         Thoroughly analyzed requirements, functional specifications, and use case documents to produce test plans and test cases for Corporate Data Warehouse and Home Affordable Modification Program initiatives.

         Executed test cases, inputted defect status in Quality Center, troubleshot production issues, and liaised between technical and business team to drive cohesive efforts and deliver projects within defined schedule.

National Cooperative Bank, Crystal City, VA, Jan 2008 Sep 2008

Senior ETL Developer

         Prepared high-level and job-level design documents and created DataStage ETL programs for Enterprise Data Warehouse project.

         Handled multiple DataStage Admin tasks and served as primary point of contact for DataStage production.

         Seamlessly migrated projects from development stage to QA and to production environments.

         Conducted integration and system testing, and automated job execution by creating Jils (Job Information Language) and scheduling jobs in Autosys.

Fannie Mae, Herndon, VA, Dec 2005 Dec 2007

ETL Developer

         Supported Security Cost Basis Sub-Ledger and Security DataMart projects by designing and developing Ab Initio graphs for ETL process.

         Established and effectively maintained Ab Initio environment for all projects.

         Delivered 24x7 production support and application monitoring while ensuring rigorous SOX compliance.

         Prepared comprehensive mapping and analysis documents throughout development life cycle.

Freddie Mac, McLean, VA, Aug 2004 Nov 2005

DataStage Developer

         Clarified requirements, functional specs, and use case documents in support of Corporate Data Warehouse and PE (Project Enterprise) initiatives.

         Played a pivotal role in slashing defects and maintained up-to-date test results in Quality Center.

         Contrived Parallel Extender jobs to migrate data from transactional systems into data warehouse.

         Authored test cases, performed unit testing on ETL jobs, wrote SQL scripts to aid in verifying data, and created metadata definitions using DataStage Manager.

Wipro Technologies, Hyderabad, India, Sep 2000 July 2004

DataStage Developer

         Masterminded ETL processes using DataStage, Syncsort, Oracle SQL Loader, and UNIX shell programming for Alignment, Customer and MAPS subsystems as part of data warehouse initiative.

         Designed and developed ETL functions from legacy systems, implemented data staging, cleansing and transformation mechanisms, and normalized databases, Star/Snowflake schemas, and Business Intelligence delivery mechanisms including loading of data marts.

         Successfully coded UNIX shell scripts to automate data load processes to target data warehouse.

Bachelor of Science

IBM Certified Solution Developer - WebSphere IIS DataStage Enterprise Edition

IBM Data Stage Enterprise Edition 9.0,8.5.1/7.5.2 (Parallel Extender), IBM BigInsights, Hadoop, MapReduce, Hive, Pig Map Reduce, Eclipse, HBase, Oozie, Sqoop, C, C++ ,VB, VB Script, Java, HTML, XML, Sun Solaris, HP-UX, IBM AIX, Windows 2000/XP, AS/400, IBM MVS/ESA, OS/390, Oracle, SQL Server, Sybase12/11.9/10, DB2 UDB 7.5/8.0/9.0/9.5.3, Access, Erwin 3.5.2/4.0, Visio, SQL Plus, SQL Loader, Rapid SQL, SQL Navigator, Toad, Oracle Developer, Microsoft Micro Strategy, Business Objects, Autosys 4.5, ClearCase, ClearQuest, CM-CVS, Designer, Doors, Requisite Pro Visio, MS Office, Mercury Quick Test Professional 8.0, WinRunner, Test Director, LoadRunner