SUMMARY:

• Over 16 years of professional experience in USA in IT Industry exclusively on Client/Server architecture involving Data warehousing concepts.
• Worked extensively on analysis, design and development and administration of various applications using IBMInfoSphereDataStage 11.7.0.0/11.5.0.1/11.3.1.2/8.7.0/8.5.0/8.1.2/8.0.1/7.5. x/7.1.x/6.x,WebsphereDataStage8.1,Informatica 9.6/9.1/8.6/8.1 , InformationAnalyzer,QualityStage,IBMInfoSphereCDC,CPLEX - DOC,SPSS,Oracle12c/11g/10g/9i/8i,DB2UDB9.2,SQLServer, Teradata.
• Expertise in all the phases of Software Development Life Cycle (SDLC)
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Staging, Transformation, Preloading and Loading of data from multiple source Databases into Data Warehouse.
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, repository management and administration, implementation of Star & Snowflake Schemas, slowly changing dimensions and Change Data Capture.
• Analyzing the quality of data to determine its consistency and reliability, Documented detailed findings Developed strategies for Data Cleansing & Migration from various operational sources into data warehouse & data marts and Data Conversion.
• Expertise of working with Investment, Pharmaceutical, Insurance, Banking, Retail, Finance and Health together with recommendations for standardization and reconstructions using IBM QualityStage (integrity) System
• Used Data Stage Server, Parallel Extender Orchestrate/Enterprise Edition Environment for Job design, split the data into subsets and load data.
• Exposure working with Docker Containers.
• Expertise working on BigQuality BigIntegrate pertaining to InfoSphere Information Server for Hadoop.
• Strong experience in implementing procedures for maintenance, monitoring, backup and recovery operations for ETL environments (InfoSphere Information Server DataStage & Informatica) and experience in storage capacity planning for the projects.
• Experience in installing Apache Ambari and Hadoop and integrate them with InfoSphere Information Server
• Utilized the available processors to achieve job performance, configuration management of system resources in Orchestrate environment
• Experienced in integration of various data sources including Bigdata,,SQL Server,Oracle,Sybase,DB2 and Teradata into ETL Tools such as InfoSphere Information Server DataStage and Informatica.
• Extensive working experience in Production support of different Applications.
• Provided On call support to fix the Production issues on the fly to provide smooth running of Production Jobs.
• Expertise in performance tuning of the various ETL jobs & processes for better performance
• Performed Unit testing, Volume testing and performance testing.
• Experience in Predictive Analytics capability to identify potential performance and capacity problems
• Experience delivering timely reports for decision making to implement EPM.
• Familiarity with OLAP reporting and business intelligence tools like Business Objects
• Experience in writing, testing and implementations of triggers, procedures and functions using PL/SQL.
• Worked as a team member with good communication, interpersonal & analytical skills. Problem-solving and troubleshooting capabilities, Quick Learning, highly motivated and result oriented attitude.
• Ability to debug the job issues and see that the issue is fixed without missing any time lines.
• Mentored other teammates by providing them with Knowledge Transfer and enlighten them of client's policies.
• Involved in ETL installations and upgrade of InfoSphere Information Server DataStage suit components and Informatica.
• Implemented client's policies to the core.
• Always been team player by accepting any challenges that came my way.
• Expertise on both Informatica and DataStage tools.
• Worked on IBM CPLEX Decision Optimization Center for analyzing proposed activity schedules.
• Always been proactive and saw that no issue got escalated and resolved on time.
• Expertise in moving the DataStage code from one network to another network by designing and determining the aspects of the code move.
• Participated in all kinds of meetings and actively involved in the development processes thus enhancing company's standards.
• Worked on IBM SPSS Modeler, Analytics Server and Collaboration and Deployment Services Deployment Manager.
• Experience working on Metadata Workbench for extracting Data Assets and Data Flows.
• Experience working on IBM Metadata Asset Manager in extracting data from Database and moving onto InfoSphere Information Governance Catalog.
• Worked on IBM InfoSphere Information Governance Catalog by setting up roles to the users and exporting/importing the data into/from a csv or excel format.
• Experience using IBM Data Architect tool to convert data into Physical Data Model and further into Logical Data Model to be moved into InfoSphere Information Governance Catalog.

TECHNICAL SKILLS:

ETL Tools and Others: IBMInfoSphereDataStage 11.7/11.5/11.3/8.7/8.5/8.1/8.0/7.5 x/7.0x/6.x,IBMWebsphereDataStage,InformationAnalyzer,QualityStage,Informatica9.6.x/9.5.x/9.1/8.6/8.1,InformaticaMDM,IDQ Information Analyzer, IBM InfoSphere Metadata Workbench, IBM InfoSphere FastTrack, Information Governance Catalog, Information Governance Dashboard, Glossary Anywhere client, IBM BigIntegrate, CPLEX Decision Optimization Studio 3.9, SPSS Modeler18.1, SPSS C&DS, SPSS Analytics Server, IBM Metadata Asset Manager, IBM Data Architect, BigQuality BigIntegrate, Docker and InfoSphere CDC.

Application Server: IBM WebSphere Application Server, WebLogic, JBOSS

Web Server: Java Web Server, Apache Web Server, ANT, Tomcat, Proxy Server, TCP/IP.

Languages: COBOL, C, Java, Visual BASIC, SQL, PL/SQL, HTML, Java Script, Perl, XML

Databases: Oracle12c/11g/10g/8, DB2-UDB,MS SQL Server, MS Access, Teradata, BigData/Hadoop

Project Management Tools: Rational Rose, Rational Requisite Pro, HP-ALM Quality Center12

Operating Systems: Unix, Red Hat Enterprise Linux, AIX, Windows 95/ 98/2000/XP/7/10.

Reporting Tool: Cognos, Crystal Reports, Business Objects

Others: SQL Developer, SQLNavigator,Taod,VisualInterDev, MS Front Page, MS Office, Visual Source Safe (VSS), PowerPoint, MS-Project, SecureFX, Zena, Outlook, Lotus Notes, MS Team Foundation Server (TFS), Service Now, Myaccess

Version Control Tools: Serena, Star Team

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Informatica System Administrator Lead

Responsibilities:

• Currently working on InfoSphere Information Server 11.7.0.0 installation on production servers. Installation of InfoSphere Information Server 11.7.0.0 on Training Servers has been successfully completed and configured..
• Working on Information Governance Catalog which is a suite component of IIS v11.5.0.1. IGC work involves export and import of Catalog assets and Glossary Development from one environment to the other. Also provided roles to Data Stewards apart from cleaning up the unwanted folders in IGC.
• Used InfoSphere Metadata Asset Manager in conjunction with InfoSphere Data Architect tool data models that are delivered with the product can be imported into InfoSphere Information Server by using InfoSphere Metadata Asset Manager (IMAM), where you can browse them. This allows you to navigate backward and forward between the data model elements and the business vocabulary terms that they originate from by using Information Governance Catalog Web Client.
• Installed and configured Informatica 10.1 on Linux Servers.
• Supporting Informatica environments by providing on call rotation.
• Experience working on installation and configuration of IBM InfoSphere Change Data Capture
• Installed Apache Ambari and Hadoop and integrated them with InfoSphere Information Server.
• Managed different InfoSphere Information Server suite components using Ambari.
• Working on IBM SPSS Modeler which enables to quickly develop predictive models using business expertise and deploy them into business operations to improve decision making thus supporting entire data mining process for better business results.
• Working on IBM SPSS Collaboration and Deployment Services by upgrading and configuring the SPSS C&DS from version 7.0 to 8.0 in Development.
• Worked on IBM CPLEX- Decision Optimization Studio, which is an analytical decision toolkit that provides rapid development and deployment of Optimization models.
• Implemented successfully production installation of SPSS Modeler, SPSS C&DS, and CPLEX-DOC.
• Created stories for the work that is been in progress and moved stories to compete when the work has been completed as part of Agile Methodology.
• Installed BigIntegrate in Docker containers by building and deploying the Docker images that helps running BigIntegrate. The Information Server Engine tier, Services tier, and Repository tier are installed in Docker containers.
• Provided appropriate roles to Data Stewards and access has been requested for IGC through initially OUR and later changed it to Myaccess.
• Attended Scrum meetings, Sprint planning, retrospect and review by participating proactively.
• Completed all software installations such as IBM IIS/CPLEX-DOC/SPSS on production servers successfully.

Environment: IBMInfoSphereDataStage 11.7.0.0/ 11.5.0.1/8.7.0 , InformationGovernancCatalog,SPSS,CPLEX-DOC, IBMInfoSphere Data Architect, QualityStage, Information Analyzer, Informatica 9.1/10.1, IBM InfoSphere Metadata Workbench, Cognos, IBM Metadata Asset Manager, IBM BigQuality BigIntegrate, IBM InfoSphere CDC, IBM InfoSphere FastTrack, Oracle12c/11g/10g, DB2 10.5, Apache Ambari, Hadoop/Big Data, Agile (scrum) methodology, Windows7/10, Linux/Unix, Microsoft Office 2013, Service Now, Outlook, SQL Developer and Lotus Notes

Confidential, Morrisville NC

Sr IIS DataStage Lead Administrator/Installation Expert

Responsibilities:

• Worked on IIS suite installation and upgrade of version 11.5.0.1 from 8.7.0 on various InfoSphere DataStage environments including DEV, INT, CAT, SAT, PRF and Production.
• Configured the InfoSphere DataStage 11.5 Suite on various environments and when any issues are encountered, resolve the installation and upgrade issues with extra efforts.
• Created new projects on InfoSphere DataStage 11.5.0.1 server, apart from existing projects on InfoSphere DataStage 8.7 which are moved into new version without executable and compiled in Development environment to be moved into INT and further into other non-production and production environments.
• Worked on setting up Database connection on InfoSphere DataStage parallel jobs with Oracle Database as Source and Oracle and SQL Server as target Database.
• Moved scripts and files onto InfoSphere DataStage server for parallel jobs to run smoothly without any issues.
• Worked on providing access to all developers which are requested through Team Track using InfoSphere DataStage Admin client and InfoSphere DataStage console.
• Other duties as a Sr IBM InfoSphere DataStage lead Administrator were to work and provide resolution to any issues that developers report on DataStage, working on Team Track, Change and Incident Requests.
• Looked into InfoSphere DataStage job issues to find out the root cause of the issues and fix it to ensure that the InfoSphere DataStage jobs are run smoothly without any further issues.
• Also provided on call production support for InfoSphere DataStage 8.7 and fix the issues on the fly to ensure smooth run of jobs on production without missing any Service Level Agreements.
• Unlocked DataStage jobs in both production and non-production servers by using available scripts.
• Managed whole project using Team Foundation Server (TFS)

Environment: IBMInfoSphereDataStage 11.5.0.1/8.7.0 , QualityStage,InformationAnalyzer,IBMInfoSphereMetadataWorkbench,IBMMetadata Asset Manager, IBM InfoSphere FastTrack, Oracle12c/11g/10g, DB2 10.5, SQL Server 2008, Hadoop/Big Data, Team Track, Agile (scrum) methodology, Windows7, Linux/Unix, Microsoft Office 2013, Service Now, Agility, Outlook and Lotus Notes.

Confidential, Charlotte, NC

Sr IIS DataStage Lead Administrator

Responsibilities:

• Worked on IIS suite installation and upgrade of version 11.5.0.1 from 8.7.0 on various InfoSphere DataStage environments including DEV, INT, CAT, SAT, PRF and Production.
• Configured the InfoSphere DataStage 11.5 Suite on various environments and when any issues are encountered, resolve the installation and upgrade issues with extra efforts.
• Created new projects on InfoSphere DataStage 11.5.0.1 server, apart from existing projects on InfoSphere DataStage 8.7 which are moved into new version without executable and compiled in Development environment to be moved into INT and further into other non-production and production environments.
• Worked on setting up Database connection on InfoSphere DataStage parellel jobs with Oracle Database as Source and Oracle and SQLServer as target Database.
• Moved scripts and files onto InfoSphere DataStage server for parallel jobs to run smoothly without any issues.
• Worked on providing access to all developers which are requested through Team Track using InfoSphere DataStage Admin client and InfoSphere DataStage console.
• Other duties as a Sr IBM InfoSphere DataStage lead Administrator, were to work and provide resolution to any issues that developers report on DataStage, working on Team Track, Change and Incident Requests.
• Looked into InfoSphere DataStage job issues to find out the root cause of the issues and fix it to ensure that the InfoSphere DataStage jobs are run smoothly without any further issues.
• Also provided on call production support for InfoSphere DataStage 8.7 and fix the issues on the fly to ensure smooth run of jobs on production without missing any Service Level Agreements.
• Unlocked DataStage jobs in both production and non-production servers by using available scripts.
• Managed whole project using Team Foundation Server (TFS)

Environment: IBMInfoSphereDataStage 11.5.0.1/8.7.0 , QualityStage,InformationAnalyzer,IBMInfoSphereMetadataWorkbench, IBM Metadata Asset Manager IBM InfoSphere FastTrack, Optimization Studio,Oracle12c/11g/10g, DB2 10.5, SQL Server 2008, Hadoop/Big Data, Team Track, Agile (scrum) methodology, Windows7, Linux/Unix, Microsoft Office 2013, Service Now, Agility, Outlook and Lotus Notes

Confidential, New York City, NY

Sr IBM InfoSphere DataStage Administrator Lead

Responsibilities:

• Worked on IIS suite installation and upgrade of version 11.5.0 from 11.3.0 on various InfoSphere DataStage environments including Development, QA and Production.
• Configured the IIS Suite on various environments and when run into issues, resolved the installation and upgrade issues with extra efforts.
• Created new IIS InfoSphere DataStage projects on IIS InfoSphere DataStage 11.5.1 apart from existing projects on IIS DataStage 11.3.1.2 which are moved into new version without executable and compiled in Development to be moved onto QA and further into production..
• Worked on setting up Database connection on IIS InfoSphere DataStage jobs pointing to Flat files and Oracle as Source and target Database.
• Moved scripts and files onto IIS InfoSphere DataStage server for DataStage jobs to run smoothly without any issues.
• Worked on providing access to all developers on IIS InfoSphere DataStage client through IIS Console.
• Other duties as a Sr IBM InfoSphere DataStage Administrator Lead included such as communicating to developers on the DataStage development, Change Request scheduling and Incident Requests.
• Worked on looking into IIS InfoSphere DataStage job issues to find out the root cause of the issues and fix it to ensure that the IIS InfoSphere DataStage jobs are run smoothly without any further issues.
• Also provided on call support for IIS InfoSphere DataStage11.3 and fix the issues on the fly to ensure smooth run of jobs on production without missing any Service Level Agreements

Environment: IBM InfoSphereDataStage 11.5.0/11.3.0 , InformationAnalyzer,IBMInfoSphere Metadata Workbench, IBM InfoSphere FastTrack, Oracle11g, SQL, Win SCP ServiceNow, Windows7, Rally, Linux/Unix, Microsoft Office 2010 and Outlook

Confidential, Chicago, IL

Sr DataStage Administrator Lead

Responsibilities:

• Worked on various DataStage projects involving SDLC that includes Software Development Applications with Research, Design, Analysis, Development and Testing using IBM Information Server DataStage, IBM WebSphere
• DataStage, BigData, DB2, Teradata, SQL Server, Oracle, Lotus Notes, Unix, Windows7, Serena, Zena and Java.
• Worked on EDW Network migration from EDW1.0 to EDW2.0 to enable the Disaster Recovery to have a proper back up of the DataStage code in production.
• Worked on Job migrations using Serena tool which helps in moving the code in packages so that exact code is moved into higher environments.
• Worked on Unix to identify the scripts and files that needs to be moved onto new network server that is EDW2.0.
• Worked as a Sr DataStage Administrator Lead guiding the team mates and also helping the developers to do proper DataStage client set up and installation.
• Worked on DataStage job issues such as Job abort, long running jobs by resolving them in a timely manner thus helping developers to meet the SLAs.
• Other duties as a Sr.DataStage Administrator Lead involved such as communicating to developers on the DataStage developments, Change Order scheduling, Incident Requests and tickets.
• Worked on establishing Database connections for DB2, Oracle, Teradata and SQL Server.
• Worked on debugging issues to see that the jobs are run smoothly without any issues.

Environment: IBMInfoSphereDataStage8.5.0,IBMWebsphereDataStage8.5,InformationAnalyzer,IBMInfoSphere Metadata Workbench, IBM InfoSphere FastTrack,Oracle11g, SQL Server2005, Teradata V6, Secure FX, WS FTP, Win SCP, Serena,AIX6.1, Zena, Windows7, Access Now, CA Service Desk, Linux/Unix, Microsoft Office 2010

Confidential, Charlotte, NC

Sr ETL/DataStage Administrator

Responsibilities:

• Worked on different projects containing total life cycle of Software Development Applications involving Research, Design, Analysis, Development and Testing using IBM DataStage (IBM Information Server),IBM WebSphere DataStage, Informatica Power Center, Teradata, SQL Server, Oracle, asp.net,, Informatica, SAP, Business Objects, Cognos, Unix, Windows XP and J2EE (Java).
• Worked as a Lead Administrator providing Knowledge Transfer to other team mates and handled Offshore DataStage/Informatica developers and resolved their access, design and other issues.
• Worked on the projects such as DS EDW2, DS EDW2 EXTRACTS, DS MRA, DS RMW PUIT, DS MDM, DS OPS CNTL, DS EDSVG APPS, DS ODS, DS EDW PRF, DS EDW2, DS EDW ST2, S RMW MRA.
• Worked on all the administrative activities such as Code Migrations, Access issues, Project Setup, Project Allocations, Space Issues, Connectivity Issues, Data Base Password Reset, User Requests, Performance Tuning of the Jobs, TNS Entries, Clearing Job Locks, Installations of software, Server Recycling and User Issues.
• Expert in providing Production Support and resolving issues pertaining to Job design and Environment.
• As an On call person fixed production issues for smooth run of Jobs thus meeting SLAs.
• Looked into User issues and resolved using Service Now Requests, Change Requests and Incident Requests.
• Attended the Admin meetings and User conducted meetings to resolve their issues and provide guidance in better performance of the Jobs and standard practices.
• Experience in upgrading ETL tool from DataStage 8.0.1 to DataStage 8.1.2, DataStage 8.5.0, DataStage 8.7.0 and currently into DataStage 11.3.1.
• Experience in upgrading the Informatica Power Center from 8.6.1 to 9.5.1
• Installed and configured DataStage 8.1/11.3 on a Linux operating system.
• Installed and configured the Grid tool kit and load leveler to support the Grid architecture.
• Installed patches, Fix packs, and other software tools related to fixing and debugging issues in DataStage
• Installed and configured Information Analyzer 8.0, 8.1, 8.5, 8.7 & 11.3.
• Debugged issues in Information Analyzer and set up the required projects for profiling purposes.
• Established connections to various data sources for extracting and loading.
• Worked on automating the environment to stabilize and standardize it in order to reduce the time frame for simple activities like code promotion and project setup.
• Hands on experience with Informatica admin console and repository manger to perform daily Informatica admin tasks.
• Experience in managing day to day activities of the downstream work stream.
• Performed Informatica Administrative activities such as Project/User creation, roles management and deployment activities, DB configuration setup, dataset management; apply fixes, patches and Service Packs as required.
• Created technical documentation for Installation, Configuration, Upgradation, Migration and Administration of all products on DataStage & Informatica.
• Experience in migration of Informatica code between all repositories (Development, Test & Production) of projects using deployment groups and Scripts.
• Actively involved in Troubleshooting, Performance Tuning, Error handling, Product support on various Platforms in productions on Informatica and DataStage.
• Experience providing 24X7 on call production support and preparing procedures/documentation wherever required for both Informatica and DataStage.
• Debugged environment and code issues and documented the resolutions.
• Raised PMRs with IBM on Design, upgrade issues, long running Jobs, patches and fix packs.
• Helped developers in resolving all kinds of issues pertaining to Job design, Job performance, and Job abort.
• Configured parallel engine, database connectivity in parallel environment.
• Established Database connections such as Oracle, Teradata and SQL Server on DataStage and Informatica for successful connectivity.
• Worked on code and Script move from one environment to another and from one DataStage version to another version.
• Used Perl for Scripting purposes.
• Monitored the Jobs in production for any issues and ran the Jobs through server using a script.
• Worked on Change Requests to move code into Production environments.
• Worked on Disaster Recovery set up and synced the code with Production to be used as backup in case of any production disasters.
• Provided access to developers into all DataStage and Informatica environments including Production.
• Mentored new DataStage administrators by providing Knowledge Transfer upon Manager’s request.
• Strictly implemented TIAA policies without any favor to anyone.
• Extended support to all teammates by sharing the knowledge.
• Managed Users, Groups, active sessions, logs, schedules and licenses in IIS Web Console and Informatica Power Center Admin Console.

Environment: IBMInfoSphereDataStage 11.3.1/8.7.0/8.5.0/8.1.2/8.0.1 , IBMWebsphereDataStage8.1,Informatica 9.5.1/8.6.1 , InformationAnalyzer,IBM InfoSphere Metadata Workbench, IBM InfoSphere FastTrack, Oracle11g, SQL Server2005, Teradata V6, WS FTP, Win SCP, Borland StarTeam (Version Control), AIX6.1, Websphere7.0 and Autosys, Windows XP/7, Service Now, Linux/Unix, Microsoft Office 2010, MQ Series, Serena, Perl & Artifactory

Confidential, Kansas City, MO

Sr. DataStage Developer/Administrator

Responsibilities:

• During my tenure here I was involved in designing technical specification documents for different interfaces and participated in administrator activities..
• Performed ETL processes using DataStage and Informatica tools , used stage variables for source validations, capturing rejects and used Job Parameters for Automation of jobs.
• Used Lookup, Join, Funnel, Merge, Transformer processing stages to design server, parallel and sequence jobs .
• Also involved in developing User Defined Variable script for adding the variables into the administrator for using default values in the Job to connect to Databases etc.
• Supported Operations team during production implementation and for different production issues.
• Migrated and Deployed ETL code between the repositories using Deployment groups and creating the Relational and Application Connections based on the Requirements based on tickets from service manager.
• Coordinated with offshore teams on daily activities and assigned them tasks.
• Worked on Business Objects and Cognos to generate the reports needed for the users, used Unix shell script to kick off the jobs,
• Worked on Databases such as Oracle, SQL Server and Teradata using them as source and target Databases.
• Also used software tools such as asp.net, Java/J2EE and SAP to achieve desired output. The operating system worked on was Windows XP apart from Unix which were used exclusively.
• Projects worked included Marketing Enrollment Extract with further bifurcation into Gill Studios, Zywave, Script Save, University Of Michigan Extracts and Lockton.
• Performed administrative activities that included adding and updating user defined variables, aborting long running Jobs from Director Client and Unix Server.
• Used DataStage Designer to design the jobs, Director to run and monitor the jobs and Administrator to clear job locks and add users.
• Worked as team player by actively completing all assigned tasks with in the given time line.
• Backed up and restored InfoSphere Information Server suite .
• Configured NLS to support character maps and locales.
• Managed ASB Agent, Logging Agent, DSRPC, Telnet and Engine Resource services.
• Involved in migration of DataStage and Quality Stage projects and jobs from earlier version to 8.0 version.
• Added, deleted and moved projects and jobs.
• Purged job log files and traced server activity.
• Issued DataStage engine commands from Administrator. Started and stopped DataStage engine and managed logs.
• Created different type of reports like Administrative reports, IA Column Analysis reports, Metadata reports and Fast Track Mapping specification reports from IIS console.
• Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse.
• Defined and documented the required data validation rules on the source feed files that were used in ETL.
• Ran job sequences with restartability, check points and implemented proper failure actions.
• Responsible for building and loading dimension tables and fact tables for the target warehouse system.
• Used Partition methods and collecting methods for implementing parallel processing.
• Monitored the performance of Parallel jobs by turning on various environment variables.
• Used Job Control routines and Transform functions in the process of designing the job .
• Developed jobs using different stages like Transformer, aggregator, lookup, source dataset, external filter, row generator, and column generator.
• Validated and debugged the developed jobs.

Environment :IBMInfoSphereDataStage 7.5.1/8.0.1 , Informatica8.1.0, DB2,Oracle10g,SQLServer2005,Unix, Java/J2EE, Information Analyzer, Teradata, WS FTP, Win SCP, Autosys, Windows XP & Microsoft Office.

Confidential, Confidential, NY

Sr DataStage Developer

Responsibilities:

• Implemented ETL DataStage for People Soft EPM 8.9 data mart deployments by delivering the jobs and build custom jobs according to the user requirements,
• Developed several DataStage jobs to improve performance by reducing run time using different partitioning techniques, performing ETL DataStage processes from OWS to MDW Data warehouse.
• Designed and developed DataStage jobs for loading data into star schema.
• Involved in development of Common Error Management process at Project level, performed testing, debugging of the jobs and migrating different projects into different environments.
• The project work was concerned to the DataStage jobs being customized in accordance with PeopleSoft jobs.
• Worked on the Windows and Unix Operating Systems and used all the technologies including Java, Cognos/Business Objects for reports, SAP, Informatica, asp.net, Oracle, SQL Server and Teradata.

Environment : DataStage EPM 8.9, DB2-UDB9.2, Oracle 9i, Teradata, SQL Server2005, AIX, WebSphere, Java, SAP

Confidential, Richmond, VA

Sr DataStage Consultant

Responsibilities:

• Job duties performed were unlimited ranging from developing Technical Design specification documents, developing several Server and Parallel jobs to improve performance by reducing run time using different partitioning techniques.
• Performed ETL processes using stage variables for source validations, capturing rejects and job parameters for automation of jobs,
• Developed the ETL jobs and combined all the jobs into one single job to send it to Frictionless database,
• Created Unix K Shell scripts to perform validations, run jobs on different instances and kick off the DataStage jobs.
• Used ETL Time stamp job to have a single time for all the jobs when the job runs from day 2 to day 11 every month or as and when required.
• Performed unit testing of all monitoring jobs and data manually to see whether the data is matched, if matched send it to the Frictionless database otherwise reject the data.
• Project worked was Spend Analysis and purpose was to evaluate the expenditure met by the company toward its vendors. The Source Database was SAP/R3 BW and target Database was Oracle, Teradata and SQL Server, the data to monitor was that of the Account Payee Info, Purchase Order Info and pCard Info. The above obtained info has to be output to the Zycus tool which does the UNSPSC classification and then from DataStage sent to the Frictionless database for final monitoring of data.

Environment : DataStage7.1, SAP/R3BW,DB2-UDB,Cobol,Oracle8,SQLServer2000,Teradata, Java, Windows XP