PROFESSIONAL SUMMARY:

• 12 years of total IT experience in the System Analysis, Design, Development, Implementation, Testing and Production support of Database, Data warehousing, Client/ Server/ Legacy applications for various industries. Strong Consulting experience in Implementing Full Life cycle Data Warehousing Projects.
• 12 years of strong Data Warehousing experience using Infosphere Datastage 11.5/9.5/8.x (Administrator, Quality, Designer, Director), Informatica, OLAP, OLTP, Control - M, PVCS, Tivoli Workload Scheduler
• 12 years of experience using Db2 11, Oracle 11g/10g/9i/8i/8.x/7.x, Teradata, Informix, Sybase 12.0/11.x, SQL Server 2016/2012, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Netezza
• Over 12 years of total IT experience in Analysis, Design, Development, Implementation and Testing of Client/Server and Data Warehousing applications.
• Working knowledge of Software Development Life Cycle (SDLC) and project methodologies, as well as tools and techniques within each phase.
• Twelve years of experience in Extraction Transformation and Loading (ETL) processes using Datastage 11.5/9.5/8.5/8.0/7.5. x EE (Parallel Extender) on Windows/Unix/Linux Platforms in Dev, QA and Prod environments.
• Experience in Extraction transformation of metadata directly from sources like flat files, XML Files, Oracle, Sql Server, Informix and other databases and perform data cleansing, data integration, operations and loading into their metadata repositories.
• Twelve years of combined experience in Teradata V2R5/V2R6/V2R7, Oracle 11g/10g/9i/8i, DB2 9.x/7.x, SQL Server, SQL and PL/SQL.
• Performed Debugging, troubleshooting, monitoring and performance tuning using DataStage.
• Loaded the data into dimension and fact tables in start and snow flake schemas.
• Excellent skills in preparing mapping and technical specification docs facilitate an understanding of the entire ETL process and in corporate changes as and when needed.
• Extensive experience in using and defining web services in data stage, created Datastage jobs to extract data from web services
• Experience in Converting the Business Logic into Technical Specifications.
• Demonstrated capabilities in developing an auditable data load process. Designed Documents for performing unit testing and string testing of developed code. Document the developed code for promotion to production environment
• Experienced in Quality Assurance for Data Warehousing projects. i.e., creating Test Plans, Test Objectives, Test Strategies, and Test Cases. Ensuring the Data in data warehouse meets the business requirements.
• Involved in migration of Datastage projects and jobs from previous versions into new versions
• Fixed errors and issues in design, compilation and execution of server jobs, parallel jobs and complex sequence jobs.
• Worked with Administrator on role setup, connectivity, security, configuration of projects, DSNs, parallel, compiler, reporting, operator and user-defined environment variables, backup Datastage and restart of services etc.
• Identified and installed patches, fix pack1 and rollup patch 1 for DataStage Engine, Parallel Engine, Node Agents, Connectivity and xmeta components.
• Extensive Knowledge on Information Analyzer, QualityStage, Metadata Workbench, Business Glossary and FastTrack products of Information Server suite.
• Provided Level 3 production support based on SLAs via Remedy and co-ordinate with offshore teams.
• Excellent team player with strong written, communication, interpersonal, analytical skills, with ability to interact with individuals at all levels. Capable of working under high stress environment with resource constraints.

TECHNICAL SKILLS:

ETL: IBM IIS (DataStage) 11.7/9.5/8.x (Administrator, Manager, Designer, Director, Parallel Extender/Orchestrate, Quality stage/Integrity, MetaRecon, Business Glossary, FastTrack, Metadata Workbench), SSIS, Informatica Power center 10.x, Cloudera Hadoop

Databases: DB2 UDB, Oracle 19g/10g/9i/8.x, MS SQL Server 2016/2012, Sybase 12.0/11.x, Tera Data, Netezza, PL/SQL, SQL*Plus, SQL*Loader

Analytics: Snowflake, Hive

Environment: Suse Linux, Python 3.x, Windows, MS-DOS

Web Technologies & web tools: XML,JSON, REST, HTTP,HTML 3.2/4.0,Servlets 2.0,JSP 2.0

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Senior Data stage Consultant

Responsibilities:

• Worked on migrating all the Datastage components from old environment to new environment
• Converting decommissioned stages in data stage to new stages and testing them.
• Worked on Unit testing, SIT testing and Business Acceptance testing all the interface project jobs as part of upgrade.
• Worked with Administrator Client to manage projects and set their properties
• Used Datastage Designer for importing metadata into repository, for importing and exporting jobs into different projects.
• Have addressed production, UAT issues, proper action was taken accordingly based on priority and requirement.
• Have worked on jobs for writing data into XML and load to web services.
• Worked on skybot for automating the individual jobs, job suites and member suites. Also worked on testing and switching skybot agents from old server to new server
• Worked on checking in and checking out data stage dsx in Dimensions CM for all code changes.
• Performance tuning of Data Stage jobs after moving to the new environment

Environment: Info Sphere Information Server 11.3/11.7, Oracle 19 g, Sql developer, Putty, Dimensions CM, Skybot

Confidential, Rochester, MN

Senior Data stage Consultant

Responsibilities:

• Used the Datastage Designer to develop processes for extracting, cleansing, transforming and loading data into the Database.
• Participated in project planning workshops with project managers, Business users and team members to analyze business requirements and outline the proposed solution.
• Worked with Functional Managers / BA’s / End Users to gather reporting requirements satisfy the needs of business units and supplier partners.
• Used different stages of Datastage Designer like Lookup, Join, Merge, Funnel, Filter, Copy, Aggregator, Sort, Column Generator, Remove Duplicates, Modify, Transformer, Sequential files, DS files, CDC, Execute command, Nested loop, Email Notification, User Variables Activity, Sequencer, Exception Handler, Terminator Activity, Job Activity and Wait for file activity
• Developed several jobs to improve performance by reducing runtime using different partitioning techniques.
• Import the table definition for XML file, load the XML parcing code for the XML file, Name space declaration or XML file, Repetition element find out etc.
• Created Parameter sets and used them in the jobs and imported them into different environments for later use.
• Performed unit testing of all monitoring jobs manually and monitored the data to see whether the data is matched.
• Developed many sequencers to call the jobs and also used execute command to perform some operations on files.
• Developed technical specifications. For Data stage objects.
• Worked closely with testing people to resolve QA issues.
• Involved in creating reports using Business Objects.
• Good understanding/exposure using SSIS.

Environment: IBM Ascential Datastage 11.5/9.1/8.5 Enterprise Edition, DB2 UDB 10.x/9.x, SQL server, Rapid SQL, Informix, Quest, TWS Scheduler, UNIX, HP Quality Center, Business Objects, SharePoint, Agile Methodology, Agile Development, TFS(Microsoft Team Foundation Server), Service now, Python 3.3.

Confidential, Minneapolis, MN

Senior Data stage Consultant

Responsibilities:

• Used the Datastage Designer to develop processes for extracting, cleansing, transforming and loading data into the Database.
• Developed several jobs to improve performance by reducing runtime using different partitioning techniques.
• Used Datastage Director for validating, execution, monitoring jobs and check the log files for errors.
• Used Email notification activity in the sequence to notify the results after job execution
• Installed Datastage 8.5 and patches in the new machine after migration of jobs from 8.1 to 8.5 version.
• Worked with Administrator Client to manage projects and set their properties
• Used Datastage Designer for importing metadata into repository, for importing and exporting jobs into different projects.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Have addressed production, UAT issues, proper action was taken accordingly based on priority and requirement.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Environment: IBM Ascential Datastage 8.5, InfoSphere Information Server, Oracle 11 g, PL/SQL, Rational Lotus Notes, BMC Control M, Windows 2003 Server, SQL

Confidential, Sunnyvale, CA

Sr. Datastage Developer

Responsibilities:

• Analysis and design of ETL processes.
• Understood the technical specifications and developed Datastage Parallel jobs for Extraction Transformation and Loading process.
• Conducting ETL team meetings and explaining the requirements to team members.
• Involved in evaluating the scope of application, defining relationship within and between groups of data
• Interacted with Management to identify key dimensions and measures for business performance.
• Responsible for design of the Star schema and business rules required to populate the fact and dimension tables
• Developed jobs in PX for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance.
• Utilizing Datastage Administrator consolidated all of the data movement and cleansing processes to one central server.
• Mapping Data Items from Source Systems to the Target System.
• Unit tested the mappings to check for the expected results
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Responsible for preparation of HLD, LLD, Implementation plan and Migration check list.
• Hands on experience on Autosys job scheduler used for automating the monthly regular run of EDW cycle in both production and UAT and dev flow environments.
• Have addressed production, UAT issues, proper action was taken accordingly based on priority and requirement.
• Worked with Administrator Client to manage projects and set their properties

Environment: IBM Ascential Datastage 8.0.1, Oracle 10 g, AIX 5.3, Rational Data Architect, HP Quality center, ETI, Windows NT, HP Quality center, SQL, UNIX Shell Scripting, MS Visio, Business Objects.

Confidential, Chapel Hill, NC

Datastage Consultant/Administrator

Responsibilities:

• Installed, Configured and Administered InfoSphere Information Server 8.1 suite using different tiers on both UNIX and Windows environments.
• Involved in upgradation of Ascential DataStage 7.5 to IIS 8.1.
• Installed and Configured fix pack 1 on IIS 8.1 and resolved errors.
• Good knowledge of SAP R/3 pack processing stage.
• Changed DataStage project and engine configuration files and upgraded Branded ODBC/DataDirect Drivers. Unlocked jobs.
• Set kernel parameters and installed required packages on Unix/Linux OS.
• Set up ORB, EJB, Web Container, JVM and JAAS settings in WAS for IIS suite.
• Configured and Administered Custom and LDAP user registries in WAS and IIS.
• Configured Unix OS to support PAM to authenticate users and groups from LDAP Active Directory.
• Set all the communication ports for all tiers free.
• Installed and Configured 64-bit WAS 6.0.2.27 & Java SDK 1.4.2 SR 10 .
• Used DB2 9.5/Oracle 11g as a metadata repository.
• Assigned DataStage roles. DataStage disk usage - projects files, datasets & scratch.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.1.1 version.
• Installed WAS 6.0.2.11 and DB2 9.1 metadata repository automatically and configured LDAP user registry with IBM Tivoli directory server in both WAS & IS.CA.
• Enabled tracing and security in WAS administrative console.
• Designed using Information Analyzer and BO Universe Design and generated different types of reports.
• Used Information Analyzer ProfileStage to quickly discover condition of data in large volumes of data via analysis functions.
• Used QualityStage to design and test match records and to prepare complex information about business entities.
• Used Legacy System Migration Workbench LSMW to migrate data from legacy non-SAP systems into SAP WAS 6.10.
• Used SAP R/3 pack stage to integrate Non SAP to SAP systems.
• Worked on SAP objects like Asset Management, Order to cash, Material master, Vendors, Recipes, Purchase contract information, Inspection plans, Customer specs and Purchase information records.
• Managed LSMW load files in UNIX and Windows environment using FTP.
• Used Legacy System Migration Workbench LSMW to migrate data from legacy non-SAP systems into SAP WAS 6.10.
• Imported legacy data from spreadsheet and flat files and converted data into target format and imported data using SAP interfaces.
• Used FastTrack to automate multiple data integration tasks from analysis to code design and to integrate mappings and jobs into metadata repository.
• Used Business Glossary Anywhere to display the business definition of categories and terms without logging into IS web console and Business Glossary.
• Used Metadata Workbench to understand, analyze and explore the assets of business, technical and operational metadata and different metadata models.
• Prepared Data Interface Doc and Design Specs Docs for ETL process after discussions with business.
• Designed DataStage Server and Parallel Jobs using different processing stages.
• Performance tuning of DataStage jobs, IIS suite products and WAS.
• Stopped and Started IIS & WAS and managed logs.
• Prepared Installation Qualification IQ Document on IIS 8.1.1 suite and got it signed off.
• Created PMRs with IBM for refresh packs, patches and fix packs.
• 24x7 DataStage ETL support and resolution of errors related to all IIS suite products.
• Participated in meetings with Business users and Subject Matter Experts (SMEs) to understand the business requirements.
• Installed, Configured and Administered DataStage, QualityStage, ProfileStage, IS Manager and metadata Server of InfoSphere Information Server 8.1 suite in Dev, UAT and Prod Phases.
• Installed, Configured and Administered Oracle 10gR2 Metadata Repository Database and WebSphere Application Server 6.0.2.27.
• Unlocked jobs. Set up Configuration Files, Job Parameters, Environment Variables and Data connections across jobs in a project.
• Prepared disk, file, network resources and packages. Modified kernel parameters and user limits. Resolved incompatible JRE errors during upgradation.
• DataStage disk usage - projects, system files, datasets & scratch.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.1.1 version.
• Worked with Director Client to schedule, run and view the logs of jobs.
• Worked with Designer Client to analyze, debug & optimize server, parallel and sequence jobs using stages.
• Performance tuning of DataStage jobs and IIS suite products.
• Backup and Restore of IIS 8.1 Suite.
• 24x7 DataStage ETL support and resolution of errors in confidential tool.
• Developed batches and sequencers in designer to run and control set of jobs.
• Worked closely with lead in process of standardizing job parameters, job flows, audit process and rollback strategies that hold major attention for the successful implementation of DW Incrementals.

Environment: IBM InfoSphere Information Server V8.1.1 Suite, Oracle 11g/10gR2, Teradata V2R7, DB2 9.5, SQL Server 2005, BO, WAS 6.0.2.27, Java, J2EE, SQL, PL/SQL, Shell Scripts, Windows XP, LSMW 3.0, Unix (Solaris 10) and Red Hat Linux 5.2, SQL Server 2005, DB2 8.1 Z-OS, DB2 9.1.5 for Z-OS, IBM System-Z 10 Linux, AIX 5.3, Windows XP, SQL, UNIX Shell Scripting, Shell Scripts.