SUMMARY

• 7+ years of experience that includes Business/Requirement Analysis experience in Data Warehousing, Development, Database design and administration, Report Writing, Technical writing.
• Over 7 years of Strong design/development/Testing experience with DataStage, OLAP tools and Data Warehousing (DW).
• Extensive experience in usage and developing strategies for Extraction, Transformation and Loading data from various sources into Data warehouse and Data Marts by using Ascential Data Stage (Designer, Director, Manager and Administrator)
• Worked as a part of a Data Warehousing team that implemented an ODS and Data Marts for storing of Enterprise wide data for the needs of critical reporting assessed by the Company.
• Strong experience in Data Warehousing, Data Architecture, Data Modeling, Data Mining, Data Analysis, Decision Support System (DSS) and GUI applications.
• Proficiency in using ERwin tool for creating physical and logical data modeling.
• Experience in integration of various data sources like Oracle, PeopleSoft, IBM DB2, Teradata and SQL Server2000/2005 into staging area.
• Worked with Teradata Loadutilitieslike MultiLoad, FastLoad,BTEQ, And Fast Export.
• Worked on extracting/loading data from/to SAP database using SAP R/3 Package
• Worked with Data Stage Server and Parallel Jobs of DataStage 7.1/7.5/8.1/8.5
• Extensively used parallel extender Joins, Merges, lookups and sorts, Modify, switch, row generator, column generator, funnel, pivot, copy stages etc. for the development of DataStage Jobs.
• Performed Debugging, Troubleshooting, Monitoring and Performance Tuning for DataStage Jobs (server and parallel).
• Experience in usage of Tivoli, Control M and AutoSys job scheduling
• Experience in usage of ProfileStage, QualityStage for maintaining, cleansing and Profiling of Source data.
• Production support for Server and PX jobs.
• Experience in usage of Clear Case and Microsoft visual safe source.
• Extensively tested the ETL’s and used Rally and Test Director for Defects and maintenance.
• Customized the delivered ETL’s from PeopleSoft as per the requirements.
• Created Technical Documents and Business Requirement Documents and Report Design Documents for Document Library.
• Extensively worked with DBA’s, Users, and Clients for issues.
• Experience in Data Mining through exposure to OLAP, OLTP, database administration, data warehouse development, System analysis, Design methods, development, maintenance and implementation.
• Experience in usage of Shell Scripting, perl scripting and loading the data by using SQL Loader.
• Excellent Knowledge of SQL, PL/SQL, Stored Procedures, Function, and Triggers.
• Excellent in communication, presentation and interpersonal skills.
• Excellent Knowledge on various domains.
• Worked co - coordinating with offshore team distributing the work, keep tracking development status and monitor day to day activities

TECHNICAL SKILLS

ETL Tools: IBM Information Server 9.1/8.5/8.1/7.5.2/7.5 (DataStage, Information Analyzer, Quality Stage, Profile Stage, MetaStage), Ascential DataStage EE/7.5x - (DataStage Manager, Designer, Director, Administrator, Parallel Extender)

Operating Systems: Windows 2000/NT 4.0 Server, Unix, AIX, HP-UX, Sun Solaris, Windows 95/98/2000/XP and DOS.

Database: Oracle 11g/10g/9i, UDB DB2 9.0, Teradata v2R6 (version 12), SQL Server, Sybase12.0/12.5 and PeopleSoft (HCM/EPM)

Languages: SQL, PL/SQL, SQL*Plus, UNIX Shell Scripting, Perl Scripting

Data Modeling Tools: ERwin 5.1 onwards, Microsoft Visio.

Web/App servers: Netscape Suite, HTML. WebFOCUS.

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Sr. DataStage Developer

Responsibilities:

• Responsible to work with Business users to understand the requirements.
• Responsible to design, develop and built DataStage parallel jobs using DataStage designer.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from disparate systems using DataStage Designer.
• Designed and developed Parallel jobs to extract data, clean, transform, and to load the target tables using the DataStage Designer
• Designed developed job sequencer to run multiple jobs with dependency and email notifications
• Used DataStage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Developed parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Implemented logical and physical data modeling with Star and Snowflake techniques using Erwin in Data warehouse.
• Extensively worked on Oracle Enterprise Stage, Oracle OCI Stage to extract, transform and load data.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Responsible to create Source to Target (STT) mappings.
• Responsible to create technical specification document.
• Involved in Performance tuning of complex queries.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.

Environment: IBM Infosphere Server Suite 8.7/8.5 (Designer, Director and Administrator, IIS Manager), Test Director, Control M, Oracle 11g, AIX 5.3, SQL Server, Toad for Oracle, Windows XP, Visio, ERwin.

Confidential, Boston, MA

Sr. DataStage Developer

Responsibilities:

• Involved in the high level design and had a major part in meetings for designing functional requirements, technical designs and worked with business to sign-off the requirement.
• Completely designed the projects and was involved in all the phases of SDLC.
• Extensively worked on designing the ETL process and creating source to target (STT) mapping.
• Maintained the log for all the ETL process flows and implementations that took place in the EDW.
• Extensively worked on developing ETL jobs using Parallel Extender and DataStage/QualityStage Designer using stages like Oracle and Teradata Connector Stages, Oracle Enterprise Stage, Oracle API Stage, Teradata Enterprise Stage, Tearadata MultiLoad Stage, Transformer Stage, Join and Lookup stages, Surrogatekey Generator Stage, Funnel and Peek etc.
• Worked on Change Capture and Slowly Changing Dimension (SCD) stages.
• Designed and developed DataStage jobs to extract Banking data from Siebel systems.
• Extensively worked developing ETL jobs to extract transactional data from FIS Systems.
• Worked on XML stages for reading data from XML files and converting the data into required format and apply transformations.
• Created and modified many Shell Scripts such as Job Archival scripts, Email notification Scripts, Record Mis-match/Match Scripts, etc. Also, worked on creating scripts that control the run of the Datastage jobs, etc.
• Extensively worked with DataStage Director to create and compile, run, schedule, monitor and reset DataStage and QualityStage jobs, importing/export objects.
• Created JIL files for running jobs through Autosys R11.
• Extensively worked on Autosys to schedule DataStage jobs, UNIX scripts. Also worked on creating file-watcher scripts.
• Involved in Production support and in migration of jobs, scripts from Dev- IT-QA-Prod.

Environment: IBM IIS 8.5 (Parallel Extender, Designer, Director, Administrator), IBM WebSphere DataStage 8.0 (DataStage and QualityStage Designer, Director, Administrator), Oracle 10g, Siebel, Cognos, Toad, PLSQL Developer, Windows XP, AIX, CA Autosys R11, Quality Center.

Confidential, Charlotte, NC

Sr. ETL Developer

Responsibilities:

• Interacted with end user community to understand the business requirements and in identifying data sources.
• Preparing the ETL templates, designing and developing documents, Technical Specification Documents used by the support team to maintain interfaces in production.
• Designing IBM Data Stage ETL jobs for extracting data from heterogeneous source systems then transform and finally load into the Data warehouse.
• Designed Data Stage Jobs to extract data from XML files, Message broker application using XML input stage, Used XML transformer stage and MQ connector stage to cleanse and transform the data to load it into the Data Mart.
• Using shared containers, created reusable components for local and shared use in the ETL process.
• Analyzing data with discrepancies through error files and log files for further data processing and cleansing.
• Creating BTEQ scripts to load data into History and SIM tables from stage tables.
• Performed Unit and Integration testing and validated the test cases by comparing the actual results with expected results and debugging and fixing the issues faced during the test cycles.
• Participated in daily status meetings and conducting internal and external reviews as well as formal walkthroughs among various teams and documenting the proceedings.
• Migrated jobs from the development instance to testing environment and took part in Migration of the project to production.
• Created Deployment and migration documents for application, script and job migrations to higher level repositories and boxes.
• Monitored Jobs and handled issues raised in production level.
• Extensively used Teradata Client 13.0 Sql Assistant for analyzing and validating the data in the database and creation of Bteq scripts and for testing the data in defect identification process.
• Working with the on-site and off-shore team for functional enhancements and application interface development and delivery.
• Performance Tuning of ETL programs to achieve better efficiency.

Environment: IBM InfoSphere Information Server 8.0(Data Stage, Quality Stage), Teradata client 13.0, Aqua Data studio 4.5, DB2, AIX UNIX, Windows NT.

Confidential, Cincinnati, OH

DataStage Developer

Responsibilities:

• Worked closely with the Business Analyst to gather the requirements for the EDW.
• Participated, designed the mapping logics for the tables in the warehouse.
• Developed DataStage jobs to pull data from Clarity and QCP systems to the EDW.
• Developed Data Stage jobs to pull the data from EPIC systems to Flat Files and automate them to target paths.
• Worked on creating the technical design and source to target mapping document for different subject areas.
• Designed jobs with different stages like ODBC Connector Stage, LookUp Stage, Join Stage, Transformer Stage, Remove Duplicate Stage, SCD Stage, Change Data Capture Stage, Sort Stage, Datasets, Peek and Funnel Stages.
• Used Quality Stage to developed jobs which involved converting the variable length record to fixed length records, parsing the fields to single domain data fields, identifying the most commonly used pattern for each field, selection of subset of records, standardizing the data by converting each field into a most commonly used format.
• Created shared containers to use in multiple jobs.
• Extensively worked on DataStage Job Sequences to Schedule Jobs to run jobs in Sequence.
• Migrated Data Stage jobs, UNIX scripts from DEV to QA to PROD. Involved in Production support.
• Completed the Unit Testing and UAT.
• Code migration to Test and Prod Environments
• Experience with Shell Scripts to automate the FTP process, Crontab entries
• Worked on the wrapper shell scripts for DataStage Job automated runs.
• Documenting the complete Project details and also the deployment checklists, access ad permissions.

Environment: IBM Information Server 8.0(Data Stage and Quality Stage),Ascential Datastage(Designer, Director,Administrator, Manager), Linux 2.6, SQL Server 2008 R2, Oracle 10g, SQL Server Management Studio, SQL Developer, Windows XP, Visual SourceSafe

Confidential 

Data Warehouse developer

Responsibilities:

• Maintenance of Data Warehouse, User Rights, Data Mining, Reporting, QC of Data.
• Worked closely with all levels of end-users to gather, document and develop reportsincluding recommending options and output formatting.
• Experience in using various tuning techniques to improve performance in Mappings, Sessions and Workflows.
• Debugged, maintained existing codes by SQL Query Tuning.
• Analyzed and designed source code documentation for investment Data Warehouse.
• Collaborated with database administrators, applicationdevelopers, and business users in order to ensure business requirements meet expected results.
• Generating of unique keys for composite attributes while loading the data into Data Warehouse.
• Developed documentation for the procedures.

Environment: Oracle 9i, SQL developer, MS SQL Server, MS Access, MS Office and Windows 2003.