SUMMARY

• Confidential has 7 years of professional IT experience with ETL Technologies & System Analysis, Design and Development of Data Warehouse applications using WebSphere Datastage 9.1/8.5/8.1/7.5.
• Identify a potential vision for how to build a data warehouse. As an Agile Model Driven Development.
• Experience with DataStage architecture, Parallelism and Large Scale implementations.
• Designed and developed parallel jobs in SMP architecture on DataStage Parallel Extender framework.
• Designed and developed server jobs on server edition.
• Expert at Data warehousing concepts, Relational Database Management Systems and Dimensional modeling (Star schema & Snowflake schema).
• Implemented the Star Schema Data Model by loading data into Dimension Table then to the Fact Table.
• Expert in working with DataStage client components - DataStage Designer, Director and Administrator.
• Experience in working with Korn and BASH Shells
• Developed database objects tables, views, materialized views, creating indexes to meet business requirements.
• Experienced in all phases of ETL Development Life cycle, ETL design methodology for Data warehousing, Business Intelligence reporting system and Dimensional modeling.
• Proficient in building staging environment, data warehouse and data marts, Integration of various data sources and automation of ETL processes.
• Implemented the best practice for Error Handling by using Reject Links in response to the Business Rules.
• Expert in working with Flat Files, Data Set and COBOL files using Copybook.
• Hands on experience with common enterprise data quality subjects, such as data cleansing, de-duplication, data profiling, master data management, gathering requirements and preparation of business view, identifying & resolving ETL performance issues.
• Migrated data from SQL Server 2008, Oracle, DB2, Flat files to Oracle, Oracle to SQL Server database.
• Performing administrative tasks such as DataStage installations, setting up users and privileges, creating and maintaining DataStage projects and scheduling project cleanup.
• Strong writing ETL design documents, testing document and documentation skills for the management, development and support.
• Excellent track record as individual and team player with effective communication skills.

TECHNICAL SKILLS

Operating System: Windows 7/XP/Windows2000, WinNT, UNIX, Linux.

Languages: C, C++, SQL, UNIX Shell Scripting

Data warehousing Tools (ETL).: WebSphere DataStage 9.1/8.5/8.1, IBM InfoSphere information server, Ascential DataStage 7.5.1/7.5, Informatica.

Data Modeling Tools: Erwin.

RDBMS: Oracle 11g/10g, SQL Server 2008, DB2

Script Languages: Unix Shell script, korn shell script (ksh).

Scheduling Tools: Control-M, Autosys, Crontab, Scripting.

Others: SQL* Loader, Putty, WinSCP, Toad, SQL Navigator, Autosys, Control - M.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. Data Stage Developer

RESPONSIBILITIES:

• Built prototype jobs for different environments for in-house developers to reference when developing new jobs as well as mentor and guide in-house developers.
• Developed several Parallel and Server jobs in Data Stage Designer.
• Involved in data analysis and assisted business users in UAT.
• Responsible for identifying the failure process and reporting to concern developer.
• Interacted with Unix Admin to setup Project Structure, estimate space required for the project.
• Developed SQL Scripts for extracts and upload data into Education department website when ED Dept. request the data in different levels/states
• Developed Spreadsheet to update all 52 states data every week when states send new files and load new updated data into database
• Used Data Stage Administrator to assign privileges to users or user groups to control purging of Repository and Data Stage client applications or jobs they run, move, and rename projects.
• Worked as a data stage admin to assign a username/passwords and maintain ODBC connections, all data stage admin issues.

ENVIRONMENT: DataStage7.5.2, Quality Stage, Congos, Oracle10g/9i, SQLServer 7.0, Toad, Autosys

Confidential, TX

Sr. Data stage Developer

RESPONSIBILITIES:

• Experienced in using IBM Data Stage (9.1, 8.7 and 8.5) Tools like IBM Info Sphere Data Stage Designer, Info sphere Data Stage Director for developing jobs and to view log files for execution errors.
• Extensively used IBM Data Stage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into target tables.
• Used Data Stage Director and its run-time engine to schedule, run, test and debug its components, and monitor the jobs.
• Performed ETL coding using Sequential file, Transformer, ODBC, Peek, Aggregator, Filter, Funnel, Copy, Change Capture, Merge, look up, Join, Sort, Complex Flat File, Data masking pack compiled, debugged and tested
• Worked with complex flat files in the process of extraction of data.
• Involved in performance tuning of the jobs and in unit performance and integration testing of Data Stage jobs.
• Enhanced the Data stage jobs which results in Zlinux space utilization and reduce cycle time.
• Used Partition methods and collecting methods for implementing parallel processing.
• Implemented Autosys Scheduling tool to Schedule the jobs and collect the Job Statistics.
• Proven track record in troubleshooting of Data Stage jobs and involved in creating functional and scope documents.
• Identified areas where the process can be automated to save cost and to improve efficiency.
• Automated the subset process by building skeleton JCL’s which reduced the human errors and saved the time.
• Used appropriate JCL’s to downsize the Mainframes files like Flat files, VSAM files, GDG files.
• Built skeleton JCL’s according to the requirement in the files.

ENVIRONMENT: IBM Data Stage 9.1/8.7, Complex Flat files, UNIX, DB2, Autosys, Mainframes.

Confidential, Morristown, NJ

Sr. ETL Developer

RESPONSIBILITIES:

• Interacted with the business users to gather the requirements and involved in data analysis.
• Designed the mappings between sources (external files and databases) to Operational staging targets.
• Extensively dealt with change capture techniques for implementing slowly changing dimensions’ process.
• Modeled the Data marts using Star Schema.
• Involved in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions tables, Physical & logical data modeling.
• Netezza connector and Netezza enterprise to connect to data stage.
• Completed documentation in relation to detailed Job plans, Job documents and high-level data models.
• Extensively used ETL to load data using Data Stage Designer from heterogeneous source systems from Oracle and DB2 to target Oracle Database.
• Worked on the Stages like Lookup, Transformer, Join, Switch, Filter, Stored procedure and Pivot.
• Created Stage Variables, Parameter Variables and Environmental Variables
• Created reusable Containers to use in multiple Jobs.
• Extensively used various Performance Tuning Techniques to improve the session performance.
• Worked extensively to create, schedule, and monitor the Jobs and to send the notification messages to the concerned personnel in case of process failures.
• Used the Execute Command in Job Activity to run Different Commands
• Created and tested all the job run books for the release and transition to the production support team

ENVIRONMENT: Data Stage 8.5, 9.1 Cognos 8.4, DB2, Oracle 10g, SQL Server 2000, Mainframe DB2, Windows 2000, ERWIN 7.x and UNIX AIX 5.1, Netezza 7.0, Oracle 11g.

Confidential, Mount Laurel, NJ

Sr. ETL Developer

RESPONSIBILITIES:

• Developed jobs to load the external feeds from LOB’s (delimiter files, fixed length, XML files and Mainframe files) into database.
• Developed ETL jobs to extract data from SQL Server using ODBC Connector stage and load the data into internal DataMart using oracle connector stage.
• Used XML output and XML Transformer stages to generate XML output file.
• Extracted data from mainframeby using Change Data Capture (CDC) management console.
• Developed SQL scripts to Create/Modify tables and T-parameter at source and staging levels.
• Developed and assisted other developers to create complex Data stage jobs using Database, Development /Debug, Processing, file and Real time stages.
• Used Shared container for simplifying design and maintenance. Extensively dealt with Performance tuning of the jobs.
• Tuned data stage jobs to improve the performance and to reduce the load on database. Compiled technical documents as per the client standards.
• Prepared the deployment packages for the code and checking in code to repository.
• Involved in Writing Shell scripts to automate the ETL Process

ENVIRONMENT: IBM Information Server 8.X, Oracle 10G, Linux 2.6, SourceSafe, Microsoft SQL Server 2005, XML, VSS, 24X7 Scheduler.

Confidential, New York, NY

Data Stage Developer

RESPONSIBILITIES:

• Involved with Application and Database Support Teams to maintain system and database which supports current data scenarios and easily adapts to changing business needs.
• Used Parallel Extender extensively by using Processing, Development/Debug, File and Real Time Stages.
• Used database stage like DB2/UDB Enterprise, DB2 bulk load, DRS, Sybase, ODBC Connector,
• Oracle Enterprise and Oracle Connector stages
• Designed and developed the process for real time data movement of reference data from Sybase to DB2 using mix of Data Stage jobs.
• Developed Information service stages (WISD) for real time data movement between DB2 and Sybase.
• Worked on Integration testing of Application using Converted data to check for any discrepancies.
• Worked as admin, created new project information server 8.1, set the properties, permissions, project tunable, environment variables and worked with Unix admin to create roles and passwords.
• Involved in Generating an SOA service of data stage Quality stage job and deploy/Manage the services using IBM Console to receive service requests.

ENVIRONMENT: IBM Information Server 8.X, DB2 9.5, Linux 2.6, Sybase 12.5, Soap UI, Real-time (XML, WISD, WebSphere MQ), Clear Case, Clear quest, Shell Scripting, SharePoint, Hibernate, Flex, Cognos.