RADHAKRISHNA SARVEPALLI

E-Mail ID: acygha@r.postjobfree.com

Ph: +1-704-***-****

Summary:

Over 10+ years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and production support and Enhancement implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 9.1/8.5/8.0.1 and Business Intelligence tools like Cognos, OBIEE 11g.

DataStage Certified Professional with over 7 years’ experience analysis, design, testing, development and implementation of client/server applications.

Hands on experience on Admin activities like security, entitlements, clusters and high availability configurations, logs, schedules, and services, and back up data.

Both the IBM Info Sphere Information Server console and the IBM InfoSphere Information Server Web console provide administration capabilities.

Hands on experience on Cloud Migration DataStage and Cognos projects.

Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.

Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, flat file, Modify, Aggregator

Expert in working with Data Stage Manager, Designer, Administrator, and Director.

Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.

Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.

Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.

Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.

Academic Qualifications:

Master of Science in Computer.

Certificated Tools: IBM Data Stage 8.5, IBM Cognos 8

KEY SKILLS:

Operating Systems:

IBM-AIX 6/7, Windows 95/98/2000/ NT, Linux, MS SQL SERVER 2000/2005/2008

ETL Tools: Data Stage 9.1/8.5/8.1/7.5.2 PX, Quality Stage 8.5/9.1, Information Analyser, ODI

Business Intelligence tools: IBM Cognos 10/8/7, OBIEE 11g, Hyperion, Tableau

Database: Teradata, Oracle, and SQL Server 2005

Version Control: Star Team, HPQC, Service Now, Rational Clear case/Clear quest

Scheduling Tools: Autosys 11

Ticketing Tools: HP Service Manager, Service Now

Professional Experience:

ConvaTec – NJ - (Jan 2016 to Till date)

Domain: Pharmaceutical

Role: Sr. DataStage Developer/Data Quality Consultant

ConvaTec is a global company committed to serving healthcare professionals, hospitals and patients worldwide. ConvaTec specialize in the development, manufacturing and distribution of single-use devices to hospitals and healthcare sectors around the world. Operates in 43 countries with four manufacturing facilities - the UK, Dominican Republic, and Greensboro, NC, Slovakia and Belarus.

Responsibilities:

Currently working on Cloud migration for existing Legacy system infosphere moving to IBM Cloud.

Analyze existing Infrastructure and DataStage jobs, ensuring best practices are being followed,

And recommending short term and long term improvement roadmap.

Implement procedures for maintenance, monitoring, backup, and recovery operations for the ETL environment.

Reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.

Designed, coded, tested, and documented complete customized application solutions for Data Quality integration.

Profiling vendor supplied raw data using Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.

Extensively using Quality Stage components such as Reference Match, Standardize, Match frequency, Survivor and Unduplicated match for standardizing the data.

Delivered internal training and mentoring on QualityStage to the organizations.

Infrastructure optimization, troubleshooting, and debugging.

Maintain ownership of release activities which interact with ETL projects.

Work with Prod Support to maintain and administer the ETL deployment environment.

Worked on extensively support for Legacy production support for Datastage and Cognos 10 for Administration.

Worked on extracting the Legacy data source SAP to Flat files, MSSQL Server, performing placing the extract files to partner destination through FTP/ SFTP.

Worked on admin activities like Info sphere server maintenance and applications every month.

Migration of the project from Existing Datastage 8.5 to 9.1.2 in Cloud Environment.

Data Stage as an ETL tool to extract data from SAP systems, loaded the data into the ORACLE, Flat Files, MSSQL Server database.

Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.

Extensively worked with sequential file, dataset, file set and look up file set stages.

Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.

Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.

Creation of jobs sequences.

Analyze performance and monitor work with capacity planning.

Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.

Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

HBC – Chicago - (Aug 2013 to Dec 2015)

Domain: Retail

Role: Onshore DataStage Lead

Hillshire Brands is a company that has undergone a change in the past 2 years in its evolution from Sara Lee to Hillshire Brands. This evolution resulted in a number of new strategic initiatives and goals, paired with a large legacy data and systems environment developed to support its earlier goals, but not right sized or customized to meet the strategic. The Hillshire investment program (HiP), is a trade investment program that helps drive improved performance and stronger growth. Hillshire Brand’s information environment is fragmented and there are separate solutions for major business areas and business processes, each designed to meet a specific business need, but leading to duplication of data, redundant storage of data, potential for inconsistent Extract, Transform and Load (ETL) results across the different solutions.

Responsibilities:

Providing hands-on participation, technical guidance and leadership to support existing Data Warehouse applications, involving Data Stage, Reporting Analysis by using OBIEE 11g

Co-ordinate with on site and offshore Team in freezing the requirements.

Work on the P2, P3 & P4 Incidents and resolving in time to avoid the SLA’s.

Keep on monitoring Tivoli for our jobs loading and complete cycle in time to avoid the SLE’s

Enhancements as part of Incidents & RFC resolutions and redesign the jobs.

Migrate the code from production fix lower environment to prod environments.

Experience in building OBIEE Repository (.rpd file) at three layers (Physical Layer, Business Model and Mapping Layers & Presentation Layer).

Extensive experience in using OBI Answers for creating different Requests, Filters, Views, Charts, Interactive Dashboards with page and dashboard Prompts.

Involved in creating Ibots to send the reports to the Business users via mail.

Created DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.

Extensively worked with sequential file, dataset, file set and look up file set stages.

Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.

Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.

Tiaa _Cref – NC (Charlotte) - (July 2011 to July 2013)

Domain: Insurance

Role: Sr DataStage Developer

TIAA-CREF (Teachers Insurance and Annuity Association - College Retirement equities fund) is fortune 100 financial services organization that is the leading retirement providers for people who work in the academic, medical, governmental, research and cultural fields.

Tiaa-Cref is the client for which we are developing this project. Tiaa-Cref being an insurance company, there are several norms that has to be followed as per the USA government. In order to comply with the norms we are checking all the data that is loaded into data warehouse. For this we are using an ETL tool called DataStage to develop the jobs to validate the data. We collate the information from various departments of TIAA and then publish it.

Responsibilities:

24 X 7 support to the applications comprising the entire warehouse

Providing hands-on participation, technical guidance and leadership to support existing Data Warehouse applications, involving Data Stage, Quality Stage.

Co-ordinate with on site and offshore Team in freezing the requirements

Work on the P2, P3 & P4 Incidents and resolving in time to avoid the SLA’s.

Keep on monitoring Autosys for our jobs loading and complete cycle in time to avoid the SLE’s

Enhancements as part of Incidents resolutions and redesign the jobs.

Migrating the code from production fix lower environment to prod environments

Bank of America – NC (Charlotte) - (May 2009 to June 2011)

Domain: Financial

Role: DataStage Developer/ QualityStage Developer

Bank of America has acquired Countrywide Financials which operates Services like Home Loans, Home Equity (Home Equity Loans & Home Equity Line of Credits), Refinance, Mortgage Loans, and Reverse Mortgages etc. Property Mart project data warehouse maintains information by integrating property information from three sources, public data vendors, IDM, data quick, portfolio. These records will then be assessed and be associated with loan and event transactions using business and matching rules to generate property history. This data warehouse acts as upstream data mart for Value finder and other property assessment applications.

Responsibilities:

Providing hands-on participation, technical guidance and leadership to support existing Data Warehouse applications, involving Data Stage, Quality Stage.

Co-ordinating with on site and offshore Team in freezing the requirements

Worked on the P2,P3 & P4 Incidents and resolving in time to avoid the SLA’s

Worked on using stages, Standardization, Scrubbing, Matching and Survivor ship rules using Quality Stage

Profiling vendor supplied raw data using Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.

Extensively using Quality Stage components such as Reference Match, Standardize, Match frequency, Survivor and Unduplicate match for standardizing the data.

Additional activities like Disaster Recovery, jobs Upgrade, End of Month Activities and Manual Run also undertaken

Scottish Widows –Offshore, India (July 2008 to April 2009 )

Domain: Insurance

Role: ETL Developer

The Business intelligence part includes ETL process using IBM Data stage, Reports generation using Cog nos 8 and ETL process of the files to the corresponding systems and various locations which are viewed by End users

Responsibilities:

Designed and developed mappings between sources and operational staging targets, using Star and Snow Flake Schemas.

Provided data models and data maps (extract, transform and load analysis) of the data marts for systems in the aggregation effort.

Involved in Extracting, cleansing, transforming, integrating and loading data into data warehouse using Datastage Designer.

Developed various transformations based on customer last name, zip code for internal business analytical purposes, loaded warehouse based on customer credit card number with dynamic data re-partitioning.

Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.

Used the Datastage Director and the runtime engine to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions (on adhoc or scheduled basis).

Developed, maintained programs for scheduling data loading and transformations using Datastage and Oracle 8i.

Developed Shell scripts to automate file manipulation and data loading procedures.

Lloyds TSB –Offshore, India (April 2007 to June 2008)

Domain: Financial

Role: DataStage Developer

Lloyds TSB is to transfer control of its lending information and securities information from the current legacy system to a new system. This move will help consolidate current data and better meet business requirements.

Responsibilities:

Designed and developed mappings between sources and operational staging targets, using Star and Snow Flake Schemas.

Provided data models and data maps (extract, transform and load analysis) of the data marts for systems in the aggregation effort.

Involved in Extracting, cleansing, transforming, integrating and loading data into data warehouse using Datastage Designer.

Developed various transformations based on customer last name, zip code for internal business analytical purposes, loaded warehouse based on customer credit card number with dynamic data re-partitioning.

Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.

Used the Datastage Director and the runtime engine to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions (on adhoc or scheduled basis).

Developed, maintained programs for scheduling data loading and transformations using Datastage and Oracle 8i.

Developed Shell scripts to automate file manipulation and data loading procedures.

AIG DBG -Offshore, India (Aug 2006 to Mar 2007)

Domain: Retail

Role: Sr Cognos Developer

RDPS (Reinsurance Data Processing System) in the main Reinsurance information system for DBG Pro-Rata. Reinsurance Providing automated, Processing, Billing and Reporting Capabilities.RDPS Provides limited Functionality for Excess of Loss (XOL) such as subject base Premium. Reporting for XOL and Loss Reporting.

Roles and Responsibility:

Comprehensive Admin Review: Created multiple models to meet the need of adhoc and canned reports. Modified the existed model of Phase 1 and took care of all business needs for phase 2.

Back-end Development: Developed multiple SQL statements/files for exceptions management to exclude accounts based on complex business logic. The SQL statements were run in a batch using UNIX scripts.

Developed FM model for report studio developers

Created CPF (Project files) and Published projects from the FM Models

Created Query subjects, query items, Filters, Namespaces

Handled Complex Queries as separate Query Subjects.

Contact this candidate