SUMMARY

• Over Nine years of IT Experience in Software Analysis, Design and Development.
• Over Seven years of extensive experience in working on ETL Methodologies and building Data Warehouse/Data Marts using DataStage in Mortgage Industry.
• Experienced in writing shell scripts, SQL’s and designing complex datastage jobs.
• Extensive involvement in different phases of the project like Requirement Analysis, Systems Analysis, Data extraction, Data Cleansing, Data Conversion, Data Transformation and Data Loading.
• Strong Knowledge of Data warehousing concepts, Relational Database Management Systems and Dimensional modeling (Star schema and Snowflake schema).
• Involved in Logical & Physical Design, Backup, Restore, Data Integration and creating Database objects (tables, indexes, triggers, views and stored procedures).
• Experienced in troubleshooting of DataStage jobs and addressing production issues, performance tuning and enhancement.
• Experienced in using ClearCase/ClearQuest, PVCS for Versioning, Defect Tracking, Deployment request Tracking.
• Hands on experience as an integrator to create streams and baselines and deliver the code to upper environments.
• Experienced in Writing different types of documents like design document, Technical requirement specification document etc.
• Experienced in Scheduling the Batch Jobs using Autosys.
• Several years of experience in mentoring and leading a team of technical staff.
• Good analytical and problem solving skills, Team Player and also a very quick learner of new technologies.

TECHNICAL SKILLS

ETL and BI Tools: DataStage 8.5/7.x/6.0/5.2, Informatica, Abinitio

Operating Systems: Linux, Solaris, IBM - AIX 4.0/5.0/5.2, Windows NT/2000

RDBMS: Oracle 7.x/8.0/8i/9i, DB2, DB2UDB, Sybase, SQL Server

Languages: C, C++, Java, Visual Basic, Universe Basic, SQL, PL/SQLUNIX shell programming, HTML, XML

Database Tools: Rapid SQL, SQL Plus, SQL* Loader, TOAD, SQL Developer, ERWIN 4.2

Scheduling Tools: Autosys, Tivoli Scheduler

Versioning Tools: Clearcase, CVS

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Technical Analyst

Responsibilities:

• Extensively used DataStage to develop complex transformations based on the Business requirement specification and integrate the data from disparate sources to load data into Confidential ’s corporate data warehouse.
• Worked on SDLC, AMCP and Agile Methodologies - Involved in all phases of the software lifecycle Analysis, Design, Testing and Implementation.
• Developed many shell scripts, wrote new SQL’s and fine tuned number of existing SQL’s
• Extensively used Parallel Processing Stages- Join, Merge, Funnel, Filter, Aggregator, Sort, FTP, Transformer, File Stages- Lookup File Set, Dataset, Fileset, Sequential File, Database Stages- DB2/UDB API, DB2 Enterprise, Sybase OCI.
• To avoid Database Performance issues due to complex queries, designed DataStage ETL jobs with Lookup, Join criteria in order to overcome the Database complex join bottlenecks.
• Worked with pre-existing Server applications and transformed to operate in parallel processing.
• Extensively used DataStage- Manager to Export/Import DataStage Job components and Import Plug in Table Definitions from Mainframe DB2, DB2UDB, Sybase databases.
• Extensively worked on Autosys for Job Scheduling. Created Boxes, commands, File Watchers and Run books.
• Extensively worked on migration of the Autosys jils from One Environment to other (Dev/UAT/Prod).
• Wrote Unix Shell Scripts to run DataStage jobs in Dev/UAT/Prod environments.
• Developed SQL's to create Staging Tables in Delete Schema and to Run DCU'S (Data Corrections) in Production.
• Used FTP to transfer the files between the UNIX and Windows.
• Used ClearCase/ClearQuest for Version Control and Defect Tracking.
• Hands on experience as an Integrator to create streams and baselines and deliver the code to upper environments.
• Used GenMenu, a custom Freddie Utility to create Stored Procedure that maintains the history of Records.
• Assisted the Testing team in testing the ETL’s and helping them come up with testcases.
• Involved in fixing the L3 items and also acted as a member of Production support team.

Environment: Datastage 8.5/7.5/7.0/6.0 , Universe Basic, Autosys 4.5, Oracle 9i, Mainframes DB2, DB2 UDB, Rational- ClearCase/ClearQuest 2002.05.00 +, Rapid SQL, SQL * Loader, Korn Shell Scripts, IBM- AIX 5.2 and Windows 2000

Confidential, VA

Technical Analyst

Responsibilities:

• Performed extensive data analysis and provide technical guidance and support to a development team.
• Create Defects/DBMod requests using Rational ClearQuest.
• Create PCM tickets in Pre-Production and higher environments using Remedy.
• Triage/Analyze the defects usually from the lower environments (QA/UAT), find the resolution and finally closing the Tickets.
• Maintain list of issues and their status for specific business groups
• Assist in System/QA and UAT testing.
• Involved in the execution of the Application following the Runguide/Runbook steps.
• Monitoring the application, debugging errors, facilitating the internal and external escalation of issues, and making recommendations to management to improve application stability and efficiency
• Closely worked with the Development/Business Validation/Environment teams in Analyzing/Resolving the defects.
• Worked with the Release Management team for code migration.
• Perform Sanity testing on applications prior to execution.
• Used FTP to transfer the files between the UNIX and Windows.
• Wrote simple to complex SQL queries to validate the data between source and the target.

Environment: Abinitio, Oracle 9i/10G, SQL Developer, Remedy, ClearCase/ClearQuest, Microsoft VISIO, UNIX and Windows NT

Confidential, VA

DataStage Developer and Systems Analyst

Responsibilities:

• Involved in requirement collection, design and development of ETL process using Datastage 7.5
• Extensively used Parallel Processing Stages- Join, Merge, Funnel, Filter, Aggregator, Sort, FTP, Transformer, File Stages- Lookup File Set, DataSet, FileSet, Sequential File, Database Stages- Oracle etc.
• Involved in designing jobs and analyzing scope of application, defining relationship within & between groups of data using star schema.
• Assist in System/QA and UAT testing.
• Used Microsoft Visio to design and document the ETL processes.
• Communicate with Management and End Users.
• Provide technical guidance and support to a development team
• Used FTP to transfer the files between the UNIX and Windows.
• Wrote simple to complex SQL queries to validate the data between Source and the Target.
• Wrote Unix Shell Scripts to run DataStage jobs in Dev/UAT/Prod environments by parameterizing the jobs.
• Maintain list of system issues and their statuses for specific business groups
• As a Production Support Analyst Analyze the defects, find the resolution and finally closing the Tickets.

Environment: Ascential DataStage 7.5, Oracle 9i, Shell Scripts, ClearCase/ClearQuest, PVCS, Microsoft VISIO, UNIX and Windows NT

Confidential, DALLAS, TX

Data Warehouse Developer

Responsibilities:

• Developed Transformations using Ascential DataStage 6.x to load data from various source systems to target database.
• Worked on Data stage Designer to develop processes for extracting, clean, transforming, integrating, and loading data into data warehouse database
• Worked on ETL DataStage Manager for importing metadata from repository, new job categories and creating new data elements, and import & Export.
• Worked on ETL DataStage Director and the runtime engine to schedule, testing and debugging its components and monitoring the resulting executable versions.
• Developed user defined Routines and Transformations by using Universe Basic.
• Designed and developed Hashed files for Look up, External Procedures and Update transformation rules.
• Developed PL/SQL procedures to transform data from staging to Data Warehouse Fact and summary tables.
• Worked on parallel extender for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance.
• Extensively used Meta Broker for importing metadata from data modeling tools like Erwin.
• Extensively used Autosys for Job Scheduling. Created Boxes, Jils, File Watchers and Run books
• Created/generated various types of Reports right from simple to complex by making use of most of the Business Objects functionalities.
• Created Reports with Multiple data sources, Drill Down, Slice and Dice and Charts.
• Scheduled and Monitored reports using Broadcast Agent Server.
• Involved in writing UNIX shell scripts for DataStage ETL tool to run the Jobs.
• Used SQL*Loader to load the Oracle data into the table.
• Used FTP to transfer the files between the UNIX and Windows.

Environment: Datastage 6.0, Autosys, Business Objects 5.1.3, Universe Basic, Erwin, Oracle 9i, DB2, DB2 UDB, SQL * Loader, Korn Shell Scripts, UNIX and Windows 2000

Confidential

Special Technology Group Member

Responsibilities:

• Redesigning the GUI.
• Extensive coding in CVI for the functioning of Electronic devices like MDU’s and CCU’s.
• Testing the devices on the floor.

Environment: CVI, UNIX, Oracle and LabWindows

Confidential

Software Developer

Responsibilities:

• Involved in the development of both the client and server side application. Structured our design on the 3-Tier Client/Server architecture and used Java RMI to communicate between the client and the server.
• On the client side, the GUI was developed using the Swing API in Java 2. The front end was designed in terms of “Screens” and “Controllers”.
• Developed Servlet classes for performing business operations
• Involved in Unit and Integration testing of the application
• Mailing functionality was developed using Java Mail API in Java 2.
• Developed Java Classes for Exception handling

Environment: Java, AWT, Swing, JDBC, RMI, Servlets, HTML, Oracle7.x, JWSUNIX and Win NT