ETL/EDW/Application development

Srinivas Gudlavalleti

Mobile: 703-***-**** Email: *******@*****.***

PROFESSIONAL SUMMARY

Having a total of over 18 years of hands on experience with

Large scale SOA/EDW implementations with Oracle, UNIX, DB2 UDB and OSS with advanced analytics with hands on SQL coding for EBS/application delivery process.

ETL Application development with IBM Websphere DS/QS v11.x technology, Enterprise Edition

-Administrator, Manager, Designer, Director, Parallel Extender/Orchestrate,Metastage MetaRecon,

-IBM InfoServer Job Designing, Development for Data Warehouse, CDI/MDM, OLAP and OLTP.

-Develop Proof-of-Concept models/prototypes to demonstrate approaches to technology and business problems, Real Time data acquisition and integration, data architecture/services, and SOA. Plug-In,Data Profiling/analysis using IBM IA tool suite

Create Data Models for Business processes as per system needs, Application architectures using DW appliances – Netezza.

Hands on with Data Modeling Tools for DW/Data Modeling, ETL (IBM Infosphere /DataStage tools v.8.x, v7.x (Server edition/Parallel Extender)- for ETL processes, large Data processing( > 1 TB), operational designs, Performance support for EDW applications and architectures.

Oracle SQL,PL/SQL, Data Warehouse, Unix/linux, Shell Scripting, HPQC Testing, Oracle VPD/DB performance tuning and query performance optimization. Analysis, design, technical specification writing, Triggers, Packages, Functions, Stored Procedures Complex SQL and SQL Performance Tuning/Optimization.

PL/SQL code tuning and Optimization support for Oracle DB 9i/10g, DB2 applications/DBA operations UNIX, Clearcase environments for Performance enhancements.

ETL Application/Process development, hands-on expertise in data management, data warehousing, Source-to-Target Mappings, data transformation, metadata and reference data management and business intelligence tools. Supporting the architectures and design of the data warehouse in complex, multi-application/layer environments.

Application development, administration, support and testing experience with UNIX(Sun Solaris & HP OS), platform applications(HPSC,HPOVO), (SOA, RDBMS, Client-Server Architectures and middleware /web applications (ECLIPSE)

Automation development, with HP test tool suite(HPQC), C,C++, Perl, Shell, UNIX/OSS for large and complex network SW releases, protocols.

TECHNICAL SUMMARY

Applications: IBM IIS – Datastage/Qualitystage 11.x, 8.x, DW appliances- Netezza, Data Modeling Tools- Sybase Power Designer v1.5, ETL tools – IBM Infosphere DS/QS v8.1.0, NMS,OSS,ETL application tools, Oracle RDBMS(METRICA), applications, Business Objects, Netcool, Tivoli, Netanalyst, Citrix, Remedy, Augur, Homer, Big-Brother, Eclipse IDE tools and web/Java applications.

DB/Tools: Visual Explain(IBM) for SQL tuning, APTUNE DB2 i/f, RDBMS,ORACLE (10g),DB2,PL/SQL,SQLPLUS, TOAD,SQL developer,SQL loader, ETL,OSS Tools, SQL Navigator.

Programming Languages C,C++, SQL, PLSQL, XML, Perl, HTML, TQL, TSL, MML, Protel,

Shell(csk,ksh,bash,awk,sed,ssh,scp),

Operating Systems/tools: UNIX (HP, SUN Solaris), linux, Windows. (XP/NT/2000/98/95).

Source/Version Control: PVCS,SVN(Subversion),Clearcase, RCS,Tortoise CVS,, ClearQuest.

Tools used SFTP,SSH,SCP, HPOVO, HPSC, HP test suite(HPQC)

Reports used : IBM Tivoli, Cognos, IBM Information Analyser applications.

Certifications : Online MIT Certification program for "Tackling Challenges of Big Data"

DETAILED EXPERIENCE

Client – Plano, TX, Bank of America Aug 2016 – Till Date

IBM IIS/DataStage ETL tools Designer/Developer.

MPP RDBMS(Teradata, Oracle) for streamed data integration process flows and data mappings.

ETL design mapping and specification, data integration platform requirements.

Implementation of complex ETL system solutions as per technical specifications/business requirements.

Client – KY State Government June 2012 – Aug 2016

Design & Development of EDW/ETL (IBM IIS -DataStage/QualityStage) Solutions for

•DW/OS platforms, CDI/MDMstandard operating procedures for data extraction, transformation, analysis and reporting, implementation and continual optimization of these mechanisms for large volume (>1TB) data warehouse environments/inter platform migrations.

•REAL-TIME (XML/BigData) DW - implementation of CDC solutions for Computing Deltas with continuous streaming “push” to deliver BI data. Capturing data changes as they occur and then immediately pushed to the target EDW using ETL engines for availability of near-instant data used in operational BI reporting and data analytics- XML/GIS data included

•Integrating multiple OS environments, CDI/MDM capturing metadata, structured data entities, classes, hierarchies, relationships, and logical/physical data models using Erwin for Infrastructure Design and Architecture, review application Data Flow Diagrams.

•Application Development for - ETL (Development/Production )

- Follow BEST practices to optimize DataStage/Quality jobs- version 11.x/8.x

-Troubleshoot application issues including components such as DataStage/QualityStage and other IBM suite tools CDI/MDM

-Provide application performance monitoring and tuning for improvements as per standards, data governance processes -Data quality (IBM IS/Quality Stage) & data profiling techniques including data cleansing and remediation for best practices.

•Working with Query/Analysis Tools (e.g. TOAD, SQL Navigator, IBM tool suite - IA, Fast Track etc). Expertise with BI tool suites, reporting using Oracle Business Intelligence Scripting with SQL, UNIX- including DDL and DML, data integrity and data normalization practices. Having knowledge of MDM.

Client – IMS Consulting, PA Nov 2011 – June 2012

Application Architect Netezza – Data Architect/ Modeling and lead teams working for

Data base development, process automation for end to end data loads and error reporting.

Translate Business requirements into Data Models, Data Flow Diagrams for BI architectures, to DW teams with source to target data mappings UNIX Shell (ksh) scripting/troubleshooting.

Oracle db System integration,Oracle Service Bus, Business Activity Monitoring.

Process Automation using Cybermation tools. Application Extensions

Code Migrations to multiple environments – DEV, QA, PROD.

Client – JPMC, OH Aug’11 – Nov11

Oracle Developer – Backend DB Analysis, Design and Data modeling for Oracle EBS/DW databases Oracle, Creating & executing SQL objects for large Oracle db with SOA Suite, complex architectures .- (PL/SQL queries, stored procedures, triggers..etc)

SQL queries for Oracle Application Development Framework

Create Logical Data Models, Data Flow Diagrams for BI architectures, Error reporting to DW teams with source to target data mappings for OBIEE.

Client – John Deere, IL Sept’10 – July 11

Oracle Developer/Analyst, - Design and Data modeling OLTP and DW databases (Oracle/VPD, DB2,UNIX ), implement logical and physical data models, Creating & executing SQL objects for large SOA,complex architectures,

Work with Sybase Power Designer v1.5 to define Physical Data Model from Logical data model, data migration planning and implementation on multi-phase projects core application and data warehouse with data modeling techniques.

Troubleshooting using tools like Visual Explain/TOAD/APTUNE,DB2/SQL coding for performance monitoring, data validation and monitoring of data flow in large dbs.

Operational support for RMS(Remote Management Systems) network/intelligent systems, Oracle Middlewares, web services.

Develop data warehouse architecture (e.g., ETL process, ODS, EDW, Data Marts)., define and validate the ETL process, including data quality, HPQC testing for subsystem levels (UT, UAT, IT)and feature level testing by creating SQL Triggers, Stored Procedures, Queries.

Responsible for designing, building and maintaining physical and semantic data models, data monitoring/supporting the development and implementation of the enterprise data warehouse and associated data marts.

Client – Cardinal Health, OH Apr’10 – July’10

ETL design/development, for Data Conversion (SDLC) using

- Datastage Enterprise Edition with ETL tool inner workings, designs to support restartability for high volume data load techniques.

- Datastage(DS) designing and developing ETL jobs using DS Designer, DS Director, DS Administrator and Parallel Extender.

- Development of Data Stage jobs using stages like Aggregator, Join, Transformer, Sort, Merge, Sequence, Filter, Funnel, Surrogate Key generator, Modify, Row-generator, Column generator, Lookup, ODBC, Link Partitioner, Link Collector, Hash File, Head, and Peek

- Experience in Tuning DataStage transformations and SQL queries for jobs to enhance their performance for DB2/ OBIEE/UNIX platforms., ETL Testing,

- Mapping data sources to target database, analyzing the business requirements as per Data Mapping Documents & specifications, ETL job code validations.

Design, write and test complex SQL queries(Oracle,DB2/UDB) for SOA support.

- Data validations for test case automation and test execution, white box testing-(UT,TUT,FUT,IT).

- Identify potential problems, Migration issues and, walkthrough the process/solutions.(Dev/QA/Prod)

Client – CapGemini, NJ Jul’09 – Apr’10

Development/Design using IBM WebSphere DataStage/QualityStage v.8.x tools (Server edition/Parallel Extender):

Design DW Architectures using ERD data modeling tools, develop, test, debug, implement and maintain ETL - Extract, Transformation and Load.

-workflows, mappings, shell scripts, and stored procedures to support the data warehouse and reporting with IBM Cognos BI Reporting tool, IBM-Information Analyser.

Create and execute unit tests on all solutions while optimizing ETL processes

OBIEE,PL/SQL, EBS/Data Warehouse, ETL, Unix, Shell Scripting, Testing, Oracle Database performance tuning and query performance optimization.

Analysis, design, technical specification writing, Triggers, Packages, Functions, Procedures Complex SQL and SQL Tuning/Optimization.

Perform source to target data mapping, data analysis, development support for existing systems using staging tables.

Monitor performance and support to production ETL processes and responds to errors and emergency problems, Working with Data Warehousing modeling concepts

Conversion Testing,Performance & Availability Testing

Test Plans,reports - analysis of errors/defects. Using HPQC, IA. Cognos.

Test scripts/checks, boundary values, normal path tests, white box & exception path testing.

DataStage/QualityStage (ver 8.1) development experience & administration

Detect and resolve data related problems Oracle/PL-SQL

SME guidance to developers and support teams on ETL job design optimization and ETL standards: transformations, joins, lookups, loaders

DataStage Administration support and troubleshooting problems in the HP-UX environment.

Data Warehousing solutions, including reporting tools, dashboard tools, query tools, ETL tools and relational database design and implementation strategies

Setup and configure links to extracting data from various sources (HP-UNIX, Oracle 10g, SAP R/3, flat files, etc) administering and migrating DataStage/ETL environments

UC4 – Job scheduling tools along with Unix Shell scripts are used for start/stop and admin operations to execute ETL jobs in Dev, QA and Prod environments

Client – T-Mobile, Parsippany, NJ & Bellevue, WA Jan 08 – Feb 09

Responsibilities: – Team Lead for onsite/offshore teams

ETL tools for business intelligence, data population, data management, metadata management, and warehouse administration for multiple transactions, working with source code management systems (ClearCase, RCS and Subversion)

Troubleshooting for SOA - PL/SQL query Performance Problems, indexes, execution plans, SQL traces, Oracle Traces, function calls, duplications, conditions, data types, memory overheads, exceptions, compilation issues, Triggers, Procedures, Packages, SQL loaders ..etc..

Administration of UNIX db changes in CPU, disk IO bandwidth, memory, network IO bandwidth. Monitoring Oracle db issue like Shared Pool Problems, Analysis of tables, indexes, Sort efficiency, Disk I/O analysis…etc.

OBIEE design and Performance Monitoring Oracle of Db,Response Time, User activity, Table Space Usage Details, SGA Performance Details, Data Files, session Details, Waits, Buffer Gets, Disk Reads. Rollback Segment, Queries, Locks ..etc..

Data architectures/business intelligence design for Enterprise applications(NMS/OSS), usage of Fact Tables and Dimension Tables, Data Warehouse Architecture and Modeling Operations, creating testing/install (technical )documentation.

Data warehousing support,, data transformation, metadata and reference data management and business intelligence tools for analytical query and reporting. Developed logical and physical data models in complex, multi-application environments.

Data validations and SW testing (UT,UAT,SDLC). Scripts for server health checks for error monitoring, report scheduling using HP tool suite(HPQC), UNIX,LINUX applications, Perl, Shell,Oracle,PLSQL queries and alongwith IBM reporter tools.

T-mobile Parsippany, NJ June’05 Jan’08

Job Role : Eng-2 SW Application development.

Client – T-Mobile, Parsippany, NJ

Responsibilities: SW application development/deployment/administration using PL/SQL, SQL Plus, SQL Loader, SQL developer and Toad with Oracle database release 9i/10g,XML,UNIX/Shell, Perl, C, Eclipse (IDE), Websphere.

ETL WebSphere DataStage v7.5,BI,Oracle Db development, testing, deployment. Implementing and upgrading Oracle apps (NMS applications), database administration.

Oracle SQL development (SQL, PL/SQL, ETL, Data Warehouse, Shell Script).- Oracle development and programming Oracle 10g database (performance tuning, index creation, materialized views and load scripts)..

PL/ SQL query creation, debugging, tuning, and generating reports for Data Analysts. Write scripts for database and server health checks for error monitoring.

Troubleshooting, monitoring overall database performance, application changes BI(business intelligence), Metadata, Data quality, migration, Data warehousing. Environment: Unix, Linux, Rational ClearCase Subversion, CVS, RCS.

Job skills included:

ETL Application development over database platforms -Oracle,RDBMS,SQL, PL/SQL, XML, Perl, data warehousing,database design and integration, DB partitioning, Parallel data processing on multiple servers for multiple incoming and outgoing data feeds.

Usage of FactTables and Dimension Tables, Data Warehouse Architecture and Modeling. For Data Staging, Data Quality, DB design and platform integration.

Oracle Application support using Oracle Partitioning,Real Application Clusters, Oracle ASM (Automatic Storage Management). creating testing/install (technical )documentation.

Monitor Database Performance- Contention, database locks, latches and wait events, operating system CPU, I/O and memory utilization. Monitor Disk I/O Tuning, Memory Tuning, database buffers (shared_pool, buffer cache, log buffer, etc).

Troubleshooting for PL/SQL query Performance Problems, indexes, execution plans, SQL traces, Oracle Traces, function calls, duplications, conditions, data types, memory overheads, exceptions, compilation issues, Triggers, Procedures, Packages, SQL loaders ..etc.

24x7x365 operations supporting multiple high volume OSS,NMS processes, Big-brother appl to monitor changes in CPU, disk IO bandwidth, memory, network IO bandwidth, RDBMS systems, trouble ticketing systems (HOMER, Remedy, Bugzilla, NTL Systems),UNIX Admin activities (Database Archiving and backups, etc.), Billing data,report scheduling.

Client – Nextel, VA (NMS/OSS Engineering group) Jan ‘04 June’05

Job Skills: Sr Consultant SW Testing/QA analyst

Tier 1,2 support to NMS,OSS,RDBMS systems(METRICA),Fault/Alarm monitoring- NETCOOL, AUGUR, Net analyst).- unit, integration and system testing.

Experience with large database environments, tuning databases and applications, Proficient in troubleshooting

Support complex high volume OLTP,UNIX, OSS databases as well as large DSS databases including backup and recovery methodologies, Oracle PL/SQL, UNIX scripting, tuning, and testing.

24x7x365 operations supporting multiple high volume OSS/NMS processes, Big-brother appl to monitor changes in CPU, disk IO bandwidth, memory, network IO bandwidth on Unix, windows systems (NTM),Version Control/Configuration Management tools- RCS and Subversion.

Tier1 support to Linux, Unix systems,UNIX Administration activities (Archiving, Operations, Monitoring servers, SW deployments,validation.), Perform database sanity checks and testing. Write scripts for database and server health checks for error monitoring, report scheduling.

Experience on Gateway development. Administration of Data Extraction, Transfer and Loading (ETL) technologies & processes, utility scripts for error/log checking, monitoring using Perl, C,UNIX,Linux shell scripting for NMS-PM data integration, migration.

Responsibilities:

Development of shell & TQL/TSL MML scripts for Nation wide Network diagnostic checks.

Network Admin support activities - error monitoring, detection & investigation for the METRICA Application tools including; S/W installations, system upgrades, configuration changes, system backups.etc.Network Error reporting /troubleshooting & data analysis for

ETISALAT, Dubai UAE. Oct’01 Nov’03.

Job Role: Senior Application developer

Job Skills include

OSS support & workcenter ops for fault management of large scale networks, alarm management with SNMP or TL1. Database administration, programming and systems analysis procedures.

RDBMS structures including: SGA, latches, system waits, resource allocation, table and index partitioning, parallel query option, database security and data archiving.

Worked with relational databases (RDBMS/oracle), UNIX system admin, shell scripting.Perform database sanity checks and testing and error investigations, data analysis for Telecom billing discrepancies (CDR info, AMA info). creating db audits(technical documentation).

Automating system administration tasks through scripting with Perl,MML, Shell (ksh, sh, csh, sed, awk, sh, ssh,scp,lsof) Builds, deployment, capacity planning of UNIX based applications/architectures, for real time network data extraction, Write scripts for database and server health checks for custom monitoring, report scheduling.

WIPRO, Bangalore, India July’97 Sept’01

Client – Nortel, Canada & UK

Systems Manager – SW Development-Testing/Systems analyst

C/C++/Shell Development Experience on Unix

Good Understanding of Data Structures, User-Oriented Design

Test case development for Unit/ Regression Testing - Test Director.

Worked with Version Control Systems - CVS, TCAR

Job Skills include:

Automated testing/validation and Testing (UT, UAT) for Nortel system software releases product features, variants, using TTF, UNIX (HP), C.C++ Writing SW release test cases, plans.SW feature-testing(technical) documentation, Telecom Billing(AMA,CDR) analysis.

Hands-on senior developer in C/C++, Unix (Shell scripting), Perl - backend Developer

Responsible for the investigation, design, development and implementation of mission critical projects aimed at achieving operational efficiencies.

Work on the full lifecycle of projects - distributed systems including relational databases.

Also require skills such as strong object oriented analysis, design and programming knowledge on the UNIX platforms as well as usage of standard protocols (such as TCP/IP). and MML scripts, TL1 messaging and connectivity methods, Data access protocols SNMP,X.25,TCP/IP.

Worked with Version Control Source Code/Configuration management tools(TCAR, RCS),trouble ticketing .Shell,C,C++ Scripting for database and server health checks, application testing, error monitoring.

Precision Electronics LTD, Noida, India Aug’93 July’97

Teknika Electronics Ltd, New Delhi, India Sept’92 Aug’93.

Duke Arnics Electronics Ltd, Hyderabad, India May’91 May’92

EDUCATION

Bachelor’s degree in Electronics/Telecommunication/Engineering - Nagarjuna University, 1986 - 1990

Affiliated College: S.V.H College of Engineering 1986 – 1990

Contact this candidate