Manager Data
Resume:
Email:************@*****.*** RAJ PRANEETH Sr.Datastage Developer
Phone: 862-***-****
Please contact ****@************.*** for rates
SUMMARY:
• 7+ years of experience in Data Warehousing and ETL using IBM DataStage8.x/7.x(Data Stage Designer, DataStage Manager, DataStage Director, DataStage Administrator), Informatica Power Center 8.6.1/8.1.1/8.0/7.1.1/7.1.3, Informatica Power Mart 6.2/5.1/4.7, (Workflow Manager, Workflow Monitor, SourceAnalyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server), Power Connect, Power Plug, Power Analyzer, Power Exchange 5.1.1, ETL, Data mart, OLAP, OLTP,DSS.
• Strong background with ETL Design and coding for Data loading, Data cleansing, Data Validation and Data Integration for enterprise data migration systems.
• Extensive experience with ETL tools such as Ascential DataStage 8.7/8.5/8.1/7.5/7.1 (Datastage Administrator, Datastage Designer, Datastage Director).
• Experience in dealing with Datastage stages (Hash, Merge, Sort, aggregator, Transformer, join, remove duplicates, Change Capture, Filter, lookup etc.).
• Experience in integration and loading into various databases Oracle SQL, 10g, 9i, 8i, DB2 UDB, Teradata V2R6.2,SQL Server 2005/2000 and MS Access.
• Extensive experience in Database/Data Warehousing/Client/Server/Legacy applications for Reinsurance, Financial, Pharmaceutical, Banking and other industries using Data Analysis, Data Modeling, Data Extraction, Data Transformation and Data Loading.
• Proficient in the design and implementation of Star, Snowflake schemas and multi-dimensional modeling. People Soft EPM
• Strong Knowledge on PeopleSoft EPM
• Implemented Various Performance Tuning techniques on Sources, Targets, Mappings and sessions.
• Extensive knowledge of Shared containers,Configuration Files and Re-Usable components in Datastage.
• Strong skills in data mapping for the Slowly Changing Dimensions – SCD1, SCD2 (Flagging, Time Stamping and Version), and SCD3.
• Writing of PL/SQL stored procedures and functions, Packages, Database Triggers, oracle Collections and Cursor, Dynamic SQL that enhances the functionality of an application.
• Experience in Producing project design documents Mid-Level Platform Application design Document(MLPD), Detailed Platform Application Design Document (DPAD).
• Expertise in UNIX Shell Scripting with Korn Shell, Bourne Shell on different flavors of UNIX such as AIX, Solaris and Linux.
• Experience on Defect tracking tools like HP Quality Center.
• Involved in daily interactions with the Business Users to understand their requirements and act in a Business Liaison role.
• Excellent Communication and Interpersonal skills .Versatile team player with proven problem solving skills .Proven ability to quickly learn new technologies.
• Good analytical skills, able to work independently or in a team environment and a self-motivated learner.
EDUCATION QUALIFICATION: Bachelor Of Technology in Computer Science
TECHNICAL SKILLS
ETL Tools : IBM WebSphere DataStage 8.5/8.1/8.0/7.51A/7.5, Data Integrator
XI,Informatica
8.0/7.1.x/6.1x
Data Discover Tools : Information Analyzer 8.0, ProfileStage 7.5 and QualityStage 8.0(Hawk).
Reporting Tools : BusinessObjects XI 3.1/XIR2, Crystal Reports, Cognos, Logi
XML
Databases : Oracle 10g/9i/8i, DB2 8.1, SQL Server 2005/2000, Sybase,PeopleSoftEPM
ASE, Teradata, Netezza.
Operating Systems : UNIX, Sco-Unix, IBM-AIX 5.2, Sun Solaris 8.0, Red-Hat Linux8, Suse
Linux, MS-DOS, Windows 95/98/2000/XP/2003.
Languages : Universe Basic, SQL, PL/SQL, SQL*PLUS, SQL*LOADER, Import,
Export, Java/J2EE, Shell Scripting, C, C++.
Testing Tools : QTP, Load Runner 6 and Quality Center.
PROFESSIONAL EXPERIENCE:
Aditya Birla Minacs, MI Feb’11– Till Date
Sr. Datastage Consultant
Environment: DataStage 8.5, 8.1, Crystal Reports 2008/XIR2/XI, Business Objects XI 3.1/XIR2, People Soft EPM,Oracle 10g, SQL, Teradata,PL/SQL, and TOAD, Windows/Unix.
Responsibilities:
• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.
• Created Test Data studying the Business requirements and directly interacted with the customers for any changes in the requirement specs.
• Checked in code, ETL specs, Test cases into PVCS on a daily basis.
• Data Analysis of source data to meet the EDW requirements.
• Participated actively in the product based approach, which can be used to easily replicate to any new client in the related business.
• Used teradata utilities Fast export, fast load, and multi load in datastage
• Connected and extracted data from teradata database using teradataODBC stage for datastage
• Extracted from and loaded data into databases such as XML, Oracle, Teradata, DB2.
• Worked extensively in designing/Analysis of the DW tables /Aggregate tables, which are derived from the existing operational database.
• Defined business rules, aggregations and lookups.
• Extensively used Ascential Datastage Designer, Manager and Director for creating and implementing various jobs.
• Worked on People soft trees tree Manager, Tree Viewer and Extracted Data From Datastource using People soft Datastage Connector,
• Used Datastage to transform the data through multiple stages and prepared documentation.
• Extensively worked with various stages in parallel Extender like Sequential file, Dataset, lookup, peek, transformer, Merge, Aggregator, row generator and many more to design jobs and load into Dimension and Fact tables.
• Automated and fine-tuned Datastage jobs and sequences for loading source systems data into warehouse.
• Scheduled various Jobs using Autosys to run them at a specified deployment window.
• Used debug mode in datastage to test the data flow and fix jobs.
• Created process to generate data extracts, validation and QA process.
JPMORGAN CHASE, IL Dec’08-Jan’11
Datastage Developer
Environment: Datastage 8.1, MQ Connector Stage, XML Input Stage, Oracle 10g, People SoftEPM,DB2 IBM AIX Version 8.0, TOAD, Business Objects XI R2, Teradata,Java/J2EE.
Responsibilities:
• Involved in Gathering Business Requirement and producing inputs to MLPD and DPAD.
• Participated in all phases of project cycle including Requirement Analysis, Client Interaction, Design, Coding, Testing, support and Documentation.
• Responsible for preparing ETL Documentation for the developed processes, Investigation of possible Terrorist/Money laundering transactions happening in the system for the tickets raised by the business.
• Responsible for handling Production Support tickets.
• Automated SQL queries using UNIX scripts for loading large volume of data during data migration activities in AML Project.
• Export and import Teradata metatables using datastage manger using teradata plug-ins
• Developed processes for Extracting, cleansing, transforming, integrating and loading data into Teradata database using DataStage
• Involved in tuning many Oracle scripts and other ETL processes used in this project.
• Responsible for doing the peer reviews, Planning and estimating the project requirements and to report the status to business managers.
• Provided production support and bug fixing during various stages of the testing.
• Involved in Designing and Developing of Datastage Parallel Jobs, Sequencers and Shared Containers.
• Performance Tuning of Datastage jobs and Oracle SQL queries.
• Extensively used Job Stages like Datasets, Sequential file, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, SCD, Change capture, Copy, External filter, External Source, Pivot, etc.
• Used multiple invocation technique for running jobs in multiple instances to speed up the process.
• Involved in writing oracle PL/SQL Stored Procedures, SQL scripts.
• Developed Ksh shell scripts for automating Datastage jobs and Housekeeping activities.
• Created Shell Scripts to automatically notify Business Exceptions and Rejects during the Loads and file processing stages.
• Created Unix Shell Scripts to read the Parameter Files and passing these values to the job during runtime.
• Responsible for preparing Unit test cases and validating the data as per the business rules.
• Provided support to the testing team during System Testing, System Integration Testing and User Acceptance testing.
Federal Deposit Insurance Company, VA Jan’08- Nov’08
Datastage Developer
Environment: Datastage 8.1, Oracle 10g, Solaris,Windows 2003, TOAD, Business Objects XI, R2, Java/J2EE, WebSphere, Teradata.
Responsibilities:
• Created the Requirements Specification for both full loads and incremental loads.
• Developed and tuned BTEQ Scripts for loading data into Teradata Database.
• Created and verified quality stage jobs for Match and induplication.
• Used Quality stages built in wizards for parsing and removing duplicate records.
• Extensively worked on Ascential Quality Stage to clean up the data.
• Used quality stage jobs to validate the quality of output data generated.
• Match frequency stage was induced to process frequency data independently from executing a match.
• Used Teradata API stage to read and write data to and from any DataStage stage into a Teradata database.
• Handled reject rows using Teradata API Stage
• Worked on standardize stage to generate extra columns before pushing the data into the match stage.
• Extensively used Teradata MultiLoad Stage in Datastage.
• Worked on real time components in IBM Information Server – WISD Input, WISD Output and Web services Client stage for receiving and passing information to web services.
• Extensively Used the IBM Information Server Designer to develop jobs to extract, transform and load data from various source systems into the Data Warehouse.
• Extensively used IBM Information Server Director for scheduling the job to run in batch, emailing and online production support for troubleshooting from LOG files.
• Used Job Sequencers to run the jobs sequentially and reporting the Status of the Job through Email.
• Exported and imported the Datastage jobs between the production and the development servers.
• Involved in S.I.T (System Integration and Testing) and U.A.T (User Acceptance Testing).
• Involved in Exposing the Datastage jobs as Web Services using IBM Information Server Console.
• Used quality stage jobs to validate the quality of output data generated.
Cincinnati Financial Corporation, OH Jun’06-Jan’08
Datastage Developer
Environment: IBM Information Server Web Sphere Data Stage 7.5 (Server and Sequence jobs), QualityStage, DB2UDB 9.1, SQL, PL/SQL, UNIX Korn Teradata, Shell Script.
Responsibilities:
• Used IBM Web sphere Data Stage as an ETL tool to extract data from sources like DB2 and flat files and loaded to target tables.
• Developed Data Stage Server jobs for Daily Policy project which involves maintaining data of all Policy holders for Cincinnati Financial Corporation.
• Created Shared Containers for reusable calculations in various strings.
• Extensively used Data Stage Designer stages such as ODBC, Aggregator, Transformer, Filter, Join, Pivot, FTP and Merge.
• Extensively worked with Flat files using sequential file stage.
• Designed the data stage Integrity check jobs which check that each Dimension ID in a Fact table has a corresponding ID in a Dimension table.
• Extensively used Email Notification, Nested Condition, Sequencer and Terminator activities in Job Sequences.
• used datastage for writing data in to teradata tables using user defined SQLs
• Export and import Teradata metatables using datastage manger using teradata plug-ins
• Worked Extensively with Qualitystages like standardization,matching and survivorship.
• Developed Routines for Error handling and also developed before/after job subroutine.
• Updated the current design specs based on the changes that occurred during development process and was involved in writing new design specs.
• Was involved in full integration test of all jobs within each sequence before migrating the sequences to the test project from development project.
• Extensively worked with Data Acquisition and Data Integration.
• Extensively used Autosys scheduler tool to schedule Data stage jobs.
• Developed Hash files for performance improvement by reducing the reference lookup time.
• Extensively worked with Team to design complex Datastage jobs.
SOUTHTRUST BANK - IBM, Hyderabad, India Apr’05- May’06
Oracle/ETL Developer
Environment: Oracle 9i, SQL, SQL Developer, SQL Plus, Reports9i, Forms9i, Discoverer10g.
Responsibilities:
• Customized and developed Oracle Forms and Reports using Oracle Forms 9i and Reports 9i.
• Interacted with the business users and collected the requirements .
• Evaluated the feasibility of the requirements by analysing the source systems.
• Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements and ETL documents.
• Worked on physical Data Modelling .
• Prepared program specifications for PL/SQL Procedures and Functions.
• Run batch jobs for loading database tables from flat files using SQL Loader.
• Created Unix Shell scripts for automating the execution process .
• Performed the data migration using SQL loader.
• Developed new reports and customized existing according to the requirements.
Contact this candidate