SUMMARY

• Senior IT Professional with 10+ years experience gathering requirements for, designing, building, and maintaining data warehouse/business intelligence environments.
• Adept to working at a strategic level to understand and support organizational goals while simultaneously collaborating as a key member of design and development teams.
• Eager to work, master and apply new and emerging technologies.
• Senior Information Technology professional with over Ten years of extensive career experience in providing solutions for Data Warehousing, business intelligence Systems.
• Over Eight years of Extensive experience in building Data Warehouses/Data Marts with ETL tool DataStage/IBM Information Server.
• ETL architecture - Prepare Data Flow diagrams, High level process flow, source to target mapping, cleansing, standardizing, de duping, Historical loads, Data Retention, Archival, Data Quality, Reconciliation and audit
• Four years experience in Datastage Administration in UNIX and Windows Environments (Software Installation, Configuration, Upgrading, Code Migration, Application Backups, Patch Installations, PMR tracking with IBM).
• Experience in Authoring, Updating Datastage Best practices and processes and Training and Mentoring Team members.

TECHNICAL SKILLS

ETL Tools: IBM Information Server 8.7/8.1, DataStage 7.5.x (Enterprise Edition) / 7.1/6.1/6.0/5.2, Quality Stage, Information Analyzer, Meatadata Workbench, Informatica 6.1

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema, Snow-Flake Schema, Physical and Logical Data Modeling, ERwin 7.3/7.1/3.5.2/3. x

OLAP/ BI Tools: Business Objects XI/6.5.1/6.1.b, Web Intelligence, Cognos 7.2

Databases: Oracle 11g/10g/9i/8i/8.0/7.3, Teradata V2R6/V2R12, DB2 9.1/9.7, Sybase 11.0.2, SQL Server 11.0

Languages: SQL, PL/SQL, C, C++, Data Stage Basic, Korn & Bourne shell scripting, XML

Environment: WindowsNT 4.0/2000/98/95, Sun Solaris 2.x/5.x/10.5 Sparc, AIX 6.1/5.3/4.2, HP-UX, Suse Linux, Java SE6/J2SE

Version Control: Rational Clear Case, Microsoft VSS, SVN Tortoise

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

Architect/Administrator

Responsibilities:

• Created Technical Design documents, Source to Target Data mappings based on Business requirements.
• Created ETL design documents adhering to design standards, and business requirements.
• Responsible for heading the code reviews and performance improvement techniques in DataStage
• Created ETL road map, long term ETL strategy and presented to upper management by understanding data needs to deliver consistent and reliable information, faster and cheaper.
• Created ETL best practices, trained and mentored the team members in Datastage to save training expenses to the company.
• Responsible for Administering the Datastage Environement and provide guidance to developers.
• Created and implemented an Upgrade plan for IBM Information Server 8.7
• Installed, and Configured IBM Information Server 8.7
• Perform Capacity planning and resource Utilization tasks on all IIS environments for future projects
• Worked extensively on Performance tuning the Queries and Datastage jobs.
• Created UNIX Shell scripts to handle code migrations between environments.
• Designed Quality Stage jobs to apply standardization, Scrubbing, Matching and Survivorship rules to cleanse the data and thereby saving around 2 hours of daily processing time.

Environment: IBM Information Server 8.1/8.7, AIX 5.3/6.1, DB2 9.7, Oracle 11g, TeradataV2R12, Maestro, Cognos 8.4

Confidential, Atlanta, GA

Architect/Administrator

Responsibilities:

• Installed, Configured and Administered IBM Information Server 8.1
• Worked with Project Managers, Business analysts to gather Business requirements.
• Created Source to Target Data mappings based on Business requirements.
• Created ETL design documents adhering to design standards, and business requirements.
• Mentored and trained ETL developers in best practices and ETL techniques.
• Responsible for heading the code reviews and performance improvement techniques in DataStage
• Resposible for preparing the Technical specifications for Data stage ETL jobs.
• Analyzed operational Metadata using Metadata workbench.
• Profiled various Data sources using Information Analyzer.
• Cleansed Names and Merchant address by creating standardization jobs using IBM Qualitystage.
• Served as IIS administrator, creation and maintenance of different projects, Code Migrations, Patch Installations and PMR tracking.
• Extensively worked on performance tuning of Datastage Jobs and Sql queries.
• Created Unix Shell scripts, Oracle Procedures, to handle large number of Input files from external vendor as well as Mainframe, and automate the process, which saved a lot of Maintenance hours.
• Designed and developed datastage before/after job sub-routines and shell scripts for implementing Audit and Control process, to Audit Datastage daily and weekly processes.

Environment: IBM Information Server 8.1, DataStage 7.5.2 (Enterprise Edition), Sun Solaris 10.5, Erwin 7.3, Windows XP, Oracle 11g, Toad 9.7, IBM DB2, BO XI R2, Cognos 8.4, Autosys.

Confidential, Delray Beach, FL

Lead Developer

Responsibilities:

• Responsible for developing the complex ETL processes to bring the data from various source systems (Oracle, SQL Server, DB2 OS390) and to load into a Global Data Warehouse (Teradata).
• Responsible for heading the code reviews and performance improvement techniques in DataStage
• Responsible for closely working with Data Modeler in creating the logical/physical data models.
• Responsible for creating DataStage shared containers (Re usable code) that are reusable in the project.
• Created source to target mapping documents based on the business requirements
• Identified the bottlenecks in DataStage jobs and optimized ETL jobs to increase the performance as part of Production support responsibilities (On call Support).
• Created Datastage sequencers for Batch processing.
• Administered and supported Datastage DEV and TEST environments as a level 2/3 resource.
• Built DataStage projects according to application team requirements.
• Created and administered best practices for Code migration between different environments and Version control.
• Involved in writing Unit and System test plans based on Functional Requirement and Business Requirement Documents.
• Improved efficiency of the jobs by developing shell scripts for running the jobs with Enterprise scheduler.
• Reduced processing time of SQL queries (Old Code) by tuning them using Teradata Explain.
• Reduced the cost of Mainframe by converting some of the Mainframe code to Datastage

Environment: IBM Websphere DataStage 7.5.2, Teradata V2R6, Sun Solaris 10.5, Erwin 7.1, COBOL, JCL, DB2 OS/390, Java SE6, Windows 2000/XP, Oracle 10g, Toad 8.5, SQL Server 2000, Cognos 8.2, Hyperion, XML.

Confidential, Durham, NC

Sr ETL Developer

Responsibilities:

• Installed and Configured Datastage, Profilestage and Metastage.
• Created common objects (reusable code) by creating shared containers to use in multiple jobs.
• Involved in design and development of data mart environment.
• Key resource to resolve Severity 1 DataStage issues
• Tasked to code review all DataStage jobs before they are allowed to promote to production
• Used MetaStage for synchronizing and integrating Meta data from Erwin, oracle and datastage
• Wrote DataStage basic routines to set the parameters or variables for jobs and sequencers from INI files.
• Responsible for implementing Logical and Physical Datamodels of Customer Datamart using Erwin 7.0.
• Developed Shell scripts to FTP the flat files from Remote server to local server and archive them after processing.
• Involved in writing the test plans based on Functional Requirement and Business Requirement Documents.
• Created Dos scripts for Datastage code Daily and weekly back-ups.
• Created Best practices in Design, development, testing and managing version control for using DataStage as the ETL tool.
• Trained and mentored other Developers of the team in using Datastage best practices.

Environment: Ascential DataStage 7.5.2 (Enterprise Edition), Cognos IWR 7.0, Oracle 9i, DB2, SQL, PL/SQL, ERwin 7.0, Win 2003, AIX 5.3.

Confidential, Houston, TX

Sr ETL Developer

Responsibilities:

• Published Best practices in Design, development, testing and managing version control for using DataStage as the ETL tool.
• Trained and mentored other Developers of the team in using Datastage best practices.
• Involved in designing and development of Datamart environment.
• Extensively worked on Error handling, cleansing of data, creating lookup files and performing lookups for faster access of data.
• Customized the Datastage delivered jobs provided by PeopleSoft EPM.
• Wrote Shell Scripts to run the SQl scripts and automated the process.
• Extensively used DataStage sequences to create and monitor batch processes.
• Used debugger to test the data flow and fix jobs.

Environment: Ascential DataStage 7.5.1, People Tools 8.45, Business Objects6.0, Oracle 9i/8i, SQL, PL/SQL, Toad, UNIX Shell Scripts, HP-UX, Putty, Win XP, MS Virtual Source Safe 6.0.

Confidential, Dallas, TX

Sr Developer

Responsibilities:

• Involved in the ETL design documents adhering design standards, and business requirements.
• Designed complex Data Stage mappings (Parallel Extender and Server) between sources (external files and databases) to the target-using Oracle as the target database.
• Converted PL/SQL Code to Data Stage Transformations.
• Designed, developed and tested ETLs for different Use cases for MATRIX.
• Developed Shell Scripts to automate the generation of Reports.
• Scheduled datastage sequences through IBM TWS (Tivoli Work Scheduler) in Test & Production.
• Used Unix Putty (Telnet) for FTP file handling process.
• Created different configuration files, based on the load jobs asserting on the server, in a 16 node architecture
• Extensively involved in Production support for various processes (MATRIX, RMP).
• Tested and Modified the RMP (Retail Market Price) as part of my production support responsibilities.
• Developed UNIX shell scripts to automate the scheduling of the DataStage jobs.

Environment: Ascential DataStage 6.1/7.5EE, Java J2SE 5.0,Microstrategy 7.5 Oracle 9i/8i, SQL, PL/SQL, Toad, UNIX Shell Scripts, Test Director 8.1, SUN Solaris 5.8, BEA WebLogic 8.4, Putty, Win XP, Rational Clearcase.

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Extensively used Ascential’s DataStage Manager, Designer, Director for creating and implementing jobs.
• Designed complex Data Stage mappings (Parallel Extender and Server) between sources (external files and databases) to the target-using Oracle as the target database
• Used DataStage to transform the data to multiple stages, and prepared documentation.
• Defined data base triggers & PL/SQL stored procedures for business validations.
• Extensively wrote Routines and Transforms.
• Created and Monitored sequences using DataStage sequencer.
• Tested if the data is seen correct in the User Interface (ICM).

Environment: Ascential DataStage 6.1 (PX and Server), Teradata V2R5, Java, Business Objects6.0, Oracle 9i/8i, SQL, PL/SQL, Toad, UNIX Shell Scripts, IBM AIX 4.2, Putty, Win XP.

Confidential

Sql Programmer

Responsibilities:

• Performed requirement analysis, feasibility study and prototyping for the acceptance of specifications.
• Integrally involved in creating a database to include sequence generators, indexes, and foreign key constraints to implement referential integrity.
• Stored procedures and database triggers were created using PL/SQL.
• Implemented code reusability and modularity by extensive use of property classes, libraries and procedures.

Environment: Oracle 7.x, Windows NT, Designer 2000, Developer/2000, PL/SQL, and SQL.