Candidates About

 

 

Pradeep Talla IBM

 

Certified Solution Developer Datastage V8.5 & V9.1

SME, Datastage Developer and Production Support Analyst, Vantiv Now Worldpay

Summary:

 

8 years of experience in IT industry especially in System Analysis, Design, Development, Testing implementation and Production Support in the fields of Enterprise Data Warehouse (EDW) using IBM Infosphere Information Server Datastage Suite (11.5/9.1/8.5), Teradata, Oracle, PL/SQL, DB2, SSIS, SQL, procedural language and Unix Shell Scripting and Linux Administration and BI reporting tools using   SAP Business Intelligence 3.1 and 4.0, IBM Cognos Reporting and Analytics, SSRS, Tableau (self Learning).  Industry experience in Banking & Financial Services which includes the following applications

 

Ø  Merchant  and Investment Banking

Ø  Human Resources and IT Management

Ø  Revenue Management and Billing (RMB)

Ø  Mercury Billing and partner payments

Ø  Payment Datawarehousing and Analytics (PDW)

Ø  Finance Data program (FDP)

Ø  Data Networking  and Analytics

 

•         Experience in all the phases of the Data warehouse life cycle involving Data analysis, design and development and testing using ETL, Data Modeling, Online Analytical Processing & reporting tools.

•         Real Time and hands on Experience on data integration experience in developing ETL jobs using Datastage 11.5/ 9.1/8.5/7.x (Designer, Director, Administrator, Web Console, Operations Console, Information Analyzer, Information Governance Catalogue ) and developing Parallel jobs using various Datastage stages such as Lookup, Join, Merge, Transformer, Aggregator, Funnel, Remove Duplicates, Oracle Enterprise, DB2, Sequential file, Hive, Impala

•         Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes

•         Hands on Experience in Data Governance Catalogue(Integrated Data Dictionary, Stewardship, Lineage, Rules and policies , End to end Information blue print, Metadata  Asset Management)

•         Expertise in Relational Database Modeling and Dimensional Modeling - Star schema, Snow-Flake schema, and hands on experience in data modeling tools Erwin / Microsoft Visio

•         Thorough understanding of RDBMS like Oracle,  DB2 and SQL Server and extensively worked on data Integration using Datastage for the Extraction transformation and loading of data from various source systems such as Mainframes, SAS, Direct, FICO, Vantiv IQ,  MDBS.

•         Experience in data warehousing concepts, ETL programming using Datastage Parallel Extender analysis, cleansing, transforming, debugging/testing, and data loading across source systems. Optimized Datastage jobs utilizing parallelism: Partitioning and Pipelining features of Parallel Extender

•         Experience in migrating ETL code to upgraded version from 8.5 to V 11.5 from Architecture design to Promoting jobs from Test to PROD and DR environments (1400-1500 jobs using Clear case Version Controlling tool /batch Scripts ) and troubleshooting all the technical issues related to Migration and documenting all the scenarios.

•         Experience in handling Data Vault (DV version 2.0) methodology too. Created   HUBS, LINKS and SATELLITES and involved in design in Specific for the Vantiv Billing Systems for all FI’s and Merchants.

•         Experience in executing commands using ISA Lite tool to gather trace files, Log files, Validate installation requirements and System health check.

•         Experience in gathering requirements, preparing functional/technical specifications documents and interacting with the users. 

•         Experience in working on Teradata and its utilities such as Fastload,MultiLoad,BTEQ,MultiLoad,TPT and Management of Data blocks, AMPS, Parsing Engine and Nodes, Hashing with Unique and Non Unique Primary Key Index, Distribution and Tactical queries, Partitioning etc

•         Has worked extensively with SQL & PL/SQL, including performing query optimizations.

•         Experience in writing UNIX scripts, Basic routines.

•         Experience in developing complex Jobs, Sequences and re-usable Parameter sets/jobs/containers.

•         Expert knowledge of performance tuning source, mapping, target and sessions.

•         Excellent in Documentation, Knowledge Transfer and Production Support. 

•         As part of Production Support was involved on Supporting and Monitoring the jobs, debugging the errors for the batch jobs and carrying the required work around/Permanent fix to ensure Continuity without any disruption within the predefined SLAs.  Administrative activities like maintaining jobs logs, deploying jobs into PROD and DR  Environments and setting environment variables, Stop/Start of the servers, Engine Patching ,assigning data stage user roles using web console and administrator, creating the projects, configuring project, handling trace files and configuration file, unlock the ETL jobs(using Commands), etc.

•         Worked as TCS onsite coordinator with responsibilities such as providing solutions for the issues/troubles/technical difficulties and assist offshore team as needed and  Knowledge transfer on  top of design documents, source to target mappings, Business Flow and document as Run books

•         Excellent Knowledge on  cleaning up the bad/Duplicated Data in FACT, ODS layer during Production Support

•         Experienced in 24x7 on-call rotation to support the production issues.

•         Experience in Scheduling Datastage jobs using IBM Tivoli Work load scheduler, Control-M and Autosys

•         Extensive Knowledge on ITIL V3 practices and experience on Service now modules such as Incident Management, Change Management, Knowledge Management, CMDB, Service Catalogue

•         Extensive Knowledge on Reporting tools Administration, reports creation (Scheduled/Adhoc) for Business users, migrating reports from lower to Higher Versions, debugging report issues.

•         Good functional knowledge of the project Landscape and all interfacing systems, interact with end-users and to identify the information needs and business requirements.

•         Excellent communication and interpersonal skills and ability to work in a team as well as individually.

•         Innovative in approach, quick Learner and Strict adherence to the client Project guidelines.

 

 

Education:

Bachelor of Technology (B. Tech) in Electronics and Communication Engineering, Shanmugha Arts Science, Technology and Research Academy (SASTRA University) Thanjavur, India

 

 

 

 

 

TECHNICAL SKILLS:

 

ETL	IBM Information Server 11.5/9.1/8.5 (Designer, Director, Administrator, Web Operations Console, Governance  Catalogue), Teradata, SSIS, Informatica Power centre 9, IBM Web sphere Cast iron V 6.3.0
Data Modeling	Star  Schema, Snow-Flake Schema, Dimensions & Fact Tables, Physical and Logical Data Modeling, Erwin
BI Tools	SAP Business Objects XI 3.1 and 4.0 , IBM Cognos, SSRS and Tableau
Databases	Oracle 10g/11g, DB2 9.x, MS SQL Server 2005/2008 R2, My SQL
Environment &OS	Windows 2003/2000NT 4.0, Windows 7 2009/NT6.1, Sun Solaris 2.x/5.x, IBM AIX 5.1/4.3, Unix and Linux
Languages	C++, Java, XML, SQL, T-SQL, PL/SQL , Java Scripting, Shell Scripting

 

 

Professional Memberships/Certifications

 

Professional Society/Certification	Member Since/Date Certified
C2090-421 Infosphere Datastage V8.5 Developer	22 Dec,2014
C2090-421 Infosphere Datastage V9.1  Developer	28 Sep, 2015

 

 

PROFESSIONAL EXPERIENCE:

 

April 2016   – April 2018  

Vantiv-Now Worldpay, Cincinnati, OH

Sr. Datastage Developer

 

Vantiv- Now World pay is a leading integrated provider of payment processing strategies and advanced technology solutions for businesses and financial institutions. Vantiv's core products are debit, credit, prepaid, check, mobile services, compliance, fraud and data security, loyalty programs, payment terminals and gateways, and advisory services. The Company's merchant base includes customers in vertical markets such as retail, restaurant, government, e-commerce, and supermarket, business to business and consumer services. Its financial institution base includes diverse set of financial institutions, including regional banks, community banks, credit unions and regional personal identification number (PIN) debit networks. The Vantiv- Now World pay brand includes investments in areas such as fraud and security prevention, ecommerce, and mobile payment technology

 

 

Responsibilities (Administrator- Data Governance Catalogue) :-

 

• Hands on Experience in Data Governance Catalogue(Integrated Data Dictionary, Stewardship, Lineage, Rules and policies , End to end Information blue print, Metadata  Asset Management)

·         Worked extensively on Models and Designs Data Structures  to Simplify and accelerate data and integration design for business intelligence, master data management(MDM) and service oriented architecture initiatives  such as:

 

1. Simplify and speed up warehouse design, dimensional modeling and change management by providing a tool to the warehouse data modelers and database administrators to design and manage the warehouse from an enterprise logical model

2. Increase efficiency and reduce time to market through greater understanding of current data assets.

3. Simplify and accelerate data and integration design for business intelligence, master data management(MDM) and service oriented architecture initiatives.

4. Leverage data-model value across the data lifecycle to promote cross-lifecycle, cross-role and cross-organization collaboration and to align process service, application and data architecture

 

As a Data Steward for Data Risk Management and Compliance Project I was responsible improving the value of Data assets and to handle a diverse set of Scenarios such as:

 

·         Collaborating across multiple lines of business to build information policies, Governance rules, supporting regulatory requirement.

·         Build Rules, Domain, Identifiers, Identify the terms and assign them to a class provided by IBM or to create a own Class based on the Domain.

·         Check Integrity of Data usage and Perform Data quality Assessment.

·         Assessing the cost of poor data quality and managing data quality issues to closure

·           Engaging subject-matter experts across the Data Domain teams through business processes to review and approve corporate glossary changes

·         Assisting business users to play an active role in information-centric projects and to collaborate with   IT team across the Enterprise.

·         Creating  well-documented, end-to- end information blueprint to ensure business requirements are aligned with the enterprise Standards

Responsibilities (Developer) :

 

·         Identifying business needs , evaluated business and technical alternatives , recommended solutions and participated in their implementation

·         Developing ETL design, development, implementation standards and procedures based on industry best practices. Recommend software upgrades for existing programs and systems

·         Created Datastage Parallel 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 Join, Look up (Normal and Sparse) and Merge stages.

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

• Created Error files and Log Tables containing data with discrepancies to analyze and re-process data.
• Migrated jobs from the development instance to testing environment.
• Performed Unit and Integration testing and validated the test cases by comparing the actual results with expected results.
• Worked on performance tuning and enhancement of Data Stage job transformations.
• Resolved data issues during the testing processes and reloaded the data with all the necessary modifications.

·         Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.

·         Developing Datastage jobs to do ETL Transformations with requirements provided and load respective Dimension and Fact tables.

• Extensive usage of AQT, SQL Developer for analyzing data and writing SQL Scripts, PL/SQL scripts performing DDL operations.

·         Extensively used slowly changing dimension Type 2 approach to maintain history in database.

• Extensively worked on Datavault 2.0 concepts (HUB, LINK and Satellite) for Data modeling
• Participated in Daily Stand up meetings as per agile process and updating the user story status to the Scrum master and product owner.
• Worked on 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.
• Worked on Metadata Definitions, Import and Export of Datastage jobs using Data stage Designer.
• Worked on Complex data coming from Mainframes (EBCIDIC files) to set the appropriate NLS and Record layout settings to read the data.

·         Worked on studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.

·         Managing and upgrading existing applications and/or integrating application with any new/existing applications and databases

·         Working with Datastage designer and Director to load data from source to target databases according to the requirements provided

·         Working in all phases of the software development lifecycle, coherent with Data Cleansing, Performance Tuning, Unit Testing, System Testing, and User Acceptance Testing. Design Application or systems, create models and diagrams to show the software code needed for an application.

·         Develop source to target mappings and specifications for data management scripts.

·         Analyze user’s needs and then design, test and develop software to meet those needs.

·         Developed scripts in PL/SQL and also wrote scripts in UNIX for testing and for loading data into tables and also for migrating the files into different environments.

·         Working on complete Software Development Life Cycle (SDLC) cycle to meet the Business requirements.

·         Working with tracker to track all the different job issues which need to be resolved and the new jobs which need to be created and also to support production issues.

·         Worked on IBM Clear case to check in and check out the codes and built  batch scripts to reference the views created project wise  and migrate the code to corresponding project applications(EDW/RMB/MERCURY/PDW/FDP/DNA/HRIT)

·         Preparing detailed work flow charts, Data modeling Diagrams that describe input, output and logical operation and converting them into a series of instructions coded in a computer language.

·         Writing, updating and maintaining computer programs or software packages to handle specific jobs such as tracking inventory, storing and retrieving data or controlling other equipment.

·         Involved in cleanup of Data in Fact and Operational Data store layer as a part of Data Retention and performance tuning with the help of stored procedures and DBA’s.

·         Worked on collecting the artifacts of jobs resulting in multiple error records to error log table, analyzing the root cause and fix them accordingly.

·         Have Knowledge on using Hive and Impala connector stages in Datastage V 11.5

 

Environnent: IBM Infosphere Information Server 8.5/11.5 (Data Stage, Quality Stage), Oracle 11g, Oracle 10g, DB2, AQT, SQL Server 2008, Oracle 11g R2, Aix UNIX, Putty, WinSCP (FTP Tool),  Linux, Windows NT, Rally, Clear Case, TWS Scheduler, SAP Business Intelligence

 

 

November 2013   – April 2016  

Vantiv-Now Worldpay, Cincinnati, OH

Datastage Production Support Analyst

 

Responsibilities:

 

·         Monitoring the daily batch and troubleshooting the issues.

·         Providing quick response to the clients for the problems they face in production environment.

·         Involving at testing, log the defects, discuss the same with the developers on daily calls, and track them until completion.

·         Understanding technical challenges and providing efficient solutions

·         Coordinating between onsite and offshore team TCS Bangalore.

·         Peer to peer knowledge sharing.

·          Interacting with different Interfacing systems and preparing the mapping documents related to batch flow and interdependency between application jobs.

·         Design work flow diagrams and design project document.

·         Development (Strictly following code standards and specifications).

·         Guide Team members in Support work and other challenges.

·         Review Code to ensure accuracy, completeness and quality of the deliverable

·         Quality improvement processes like conducting requirement and design walkthroughs and reviews to ensure quality of the deliverables.

·         Report the progress made and lists the scheduled tasks on a day-to-day basis to both the client managers and TCS managers.

·         Actively participating in Process improvement techniques, gathering the requirements and driving it to closure.

·         Enhancement of the present functionality if required in alignment with standards

·         Provide post production support and user documentation.

·         Participation in Disaster recovery (DR) exercise to ensure systems is Business Continuity Plan (BCP) complaint.

·         Providing the reports for the Analysis and Research work carried out in the form of metrics

·         Converting recurring production failures into Problem ticket with Detailed Analysis, Root cause, and the corrective action required and drive them to closure in coordination with Development.

·         Validation and participation in production change walkthroughs. For any changes moving to production for fulfilling business requirements or for enhancing system performance. To ensure changes are moved to the system with Minimal impact to the services.

·         Participating in the Bridge/Incident calls for critical issues, Preparing root cause Analysis documents, and updating the same in SharePoint.

·         Scheduling the jobs though IBM Tivoli work load scheduler with appropriate dependencies.

·         Participating in Knowledge Management to document the steps carried out to restore the service or resolve an issue and upload them into IRIS (Service Management Repository tool)  so the articles can be reused.

·          Worked on Server patching which involves updating patches (Sales force, JDK, Web sphere Key SSL Certificates) and recycling  of Application Services (Node Agent , DS Engine , JObMonApp, Resource tracker) pre and post patching.

·         End user validation for all the patching activities which involves ensuring successful restoration of Application and validating the client tools Designer, Director , Administrator and Web console

·         Deploying the code into the corresponding projects through a batch script as a part of production release in alignment with Change Management process which involves comprehensive, Infrastructure and Standard changes.

·         Ensuring the vulnerabilities for the Server, WAS/HIS are remediated in coordination with Development Architect and Admin teams.

·         Nominated as the ITIL and Knowledge Management Champion for the team by the client Manager which involves ensuring the team is following the Service Management life cycle standards and publishing, reviewing the Knowledge articles content and quality.

 

Environnent: IBM Infosphere Information Server 8.5/11.5 (Data Stage, Quality Stage), Oracle 11g, Oracle 10g, DB2, AQT, SQL Server 2008, Oracle 11g R2, Aix UNIX, Putty, WinSCP (FTP Tool),  Linux, Windows NT, Rally, Clear Case, TWS Scheduler, SAP Business Intelligence

 

 

July 2013   –    November 2013 Tata Consultancy Services, Trivandrum, Kerala

Team Member, Role : Developer

Project/Stream – BIPM (Business Intelligence and Performance Management)

 

Project (TCS Internal):                                  

 

 Telecom Regulatory Authority of India was formed in 1997 to regulate telecom services, including fixation/revision of tariffs for telecom services which were earlier vested in the Central Government.

TRAI's mission is to create and nurture conditions for growth of telecommunications in the country in a manner and at a pace which will enable India to play a leading role in emerging global information society. One of the main objectives of TRAI is to provide a fair and transparent policy environment which promotes a level playing field and facilitates fair competition.

This project TRAI-Development of MIS was a step forward in doing so. Worked as a develop trainee to develop the Management Information System base on the Key Performance Indicators

 

Responsibilities and Activities during Training:

 

·         Training included, first 1.5 months of Java, SQL/PLSQL, ITIL, Unix and 1.5 months of Informatica and business objects.

·         Developed Java programs based on the Scenario provided using  Eclipse

·         Introduction RDBMS, SQL/PL SQL Commands.

·         Execute and Output the results during Diagnostics for the queries asked using SQL/PL SQL.

·         End to end Knowledge guidance from Trainer on DW Fundamentals, Dimensional Modeling, Normalization forms, Slowly Changing Dimensions, Data Modeling.

·         Presented DW Fundamental  Topics to other stream technologies as part of ILP Program

·         Introduction to ETL Tool Informatica power centre ,Installation its features and components

·         Developed work flow’s , Maplets and Scheduler tasks using the  Key performance Indicators  using various Data Cleansing  and transformation rules

·         Worked on Bugzilla Testing tool from Mozilla Foundation for ETL testing.

·         Introductory  Session from Trainer on BI Reporting  tools such as SAP Business Objects

·         As part of TRAI project team, identified the Key Performance Indicators and created Business Object Universe to cater specific needs as part of TRAI’s mission.

·         Created  reports using OLAP techniques like Slice & Dice, Drill Down features and designed cross tab and Master Detail reports, Dashboard.

·         Involved in the Runtime Improvements and tuning and optimization of the critical queries of the application.

Environment:   SQL, PL/SQL, ITIL, UNIX, INFORMATICA, and SAP Business Objects.

 

 

Videocon International Pvt. Ltd., Bangalore, India

IT Professional Program – SASTRA

November 2011-   June 2013                                      

SQL Developer

 

Videocon International Pvt. Limited engages in the manufacture, assembly, marketing, and distribution of consumer electronic products and home appliances in India. Financial Accounting System consists of data entry module for Master, Parameter and Daily transaction entry routine (i.e. Supplier, Customer, General ledger, Profit/Cost Center, Cash/b