Data Developer

Vamshi Naganaboina

Phone: 636-***-****

Email ID: ******.***********@*****.***

OBJECTIVE:

ETL developer in a Challenging Environment.

SUMMARY:

•Around 8 years of IT experience in developing software applications using Oracle 12c/11g/10g/9i and its products in wide range of applications including Manufacturing, Banking and Music Industry applications.

•Solid experience working on Oracle 12c/11g /10g/9i/8i/8.0/7.x, PL/SQL, UNIX.

•Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi-tier and client/server architectures.

•Experience in Data modeling, Data warehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM Web Sphere Data Stage 11.x/9.x/8.x/7.x.

•Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.

•Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.

•Used Query tuning techniques for better performance and execution through suitable indexes, primary-foreign key constraints.

•Designed Pragma Autonomous Transactions.

•Implemented External tables and created Sequences to generate numbers on the fly.

•Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.

•Extensively worked on IBM DataStage Components like DataStage Designer, DataStage Manager, DataStage Director, DataStage Administrator and Parallel Extender.

•Expert in working on various operating systems like UNIX and Windows and extensive experience in UNIX Shell Scripting.

•Experienced in tuning Oracle Database &DataStage environments and Proficient in creating containers, triggers, routines, functions and custom transformations.

•Experienced with legacy systems and good understanding of SQL, Object-Oriented technologies.

•Good experience in writing UNIX shell scripts and proven track record in troubleshooting of Datastage jobs and addressing production issues.

•Interacted with business users to analyze the business requirements and provide technical solutions

•Having excellent track record as a strong team player with effective communication, analytical and multi-tasking skills, resourceful, result driven and self-motivated.

•Excellent Interpersonal and Cross-functional skills, Strong Leadership and Motivational skills

•Effective verbal and written communication skills.

•Willing and able to adapt to new environments and learn new technologies quickly.

TECHNICAL SKILLS:

RDBMS

Oracle 11g/10g/9i/8i.

Operating Systems

Windows Server 2008/2003/2000, Windows Vista, Windows XP Windows 7.0, Mac OS, Linux (Red Hat), UNIX, AIX, SOLARIS.

Tools

TOAD, Oracle SQL Developer, SQL Loader, Oracle Designer, IBM Datastage, Informatica, Hadoop, Visual Studio,

Languages

SQL, PL/SQL, C, HTML,XML

Applications

Microsoft office 2003/2007/2010

EDUCATION

•Bachelors of Technology, JNTU, INDIA.

•Masters in Information Technology, University of North America.

Client: OnSemi Conductors, Phoenix, AZ Oct 2016-Current

Role: Oracle Developer/ETL Developer (Sr Systems Analyst)

Description:Onsemi is a Fortune 1000 semiconductors supplier company. Products include power and signal management, logic, discrete, and custom devices for automotive, communications, computing, consumer, industrial, LED lighting, medical, military/aerospace and power applications. ON Semiconductor runs a network of manufacturing facilities, sales offices and design centers in North America, Europe, and the Asia,Pacific regions. Headquartered in Phoenix, Arizona.

Responsibilities:

•Extensive ETL tool experience using IBM Infosphere/Websphere DataStage, Ascential DataStage.

•Worked on DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator.

•Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.

•Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.

•Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.

•Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding

•Familiar in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files.

•Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools.

•Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.

•Knowledge in using Erwin as leading Data modeling tool for logical (LDM) and physical data model (PDM).

•Extensive experience in design and development of Decision Support Systems (DSS).

•Assisted in development efforts for Data marts and Reporting.

•Technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

•Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.

•Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

•Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

•Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.

•Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

•Involved in the continuous enhancements and fixing of production problems.

•Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

•Developed PL/SQL triggers and master tables for automatic creation of primary keys.

•Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.

•Created scripts to create new tables, views, queries for new enhancement in the application using TOAD/SQL developer.

•Created indexes on the tables for faster retrieval of the data to enhance database performance.

•Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

•Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

•Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

•Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

•Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

•Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

•Partitioned the fact tables and materialized views to enhance the performance.

•Extensively used bulk collection in PL/SQL objects for improving the performing.

•Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

•Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

•Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

•Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

•

Environment:IBM DataStage 8.0.1,9.1,11.3,11.5 IBM AIX, Windows 7, Oracle 11g/10g/12c, Netezza, SQL*Loader, SQL Plus, TOAD, MS Visio, MS Access, MS Office, DB2, Shell, XML files, CSV files, Sequential files, UNIX, LINUX

Client: IBRAIN TECHNOLOGIES INC, MO Feb 2016-Oct 2016

Description:IBrain Technologies is one of the fastest growing IT companies in St.louis that provide Consulting and IT services to clients all across United States.

Role:PL/SQL Developer

Responsibilities:

•Installing database software and perform maintenance functions of the database.

•Compiling and debugging packages with in-house code, and assisting the developers.

•Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.

•Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.

•Created Users and maintained security with Roles and Privileges.

•Cloning/Refreshing databases from cold backups.

•Creating database objects such as tables, views, procedures and functions and executed them using SQL*Plus. Created indexes to improve the system performance.

•Involving in creation of triggers and handling exceptions.

•Various stored procedures were written to achieve the back end functionality.

•Analyzed performance bottlenecks and provides appropriate solutions.

Client: BMI, Nashville, TN Jan 2015-Jan 2016

Description:Broadcast Music, Inc. (BMI) is one of three United States performing rights organizations, along with ASCAP and SESAC. It collects license fees on behalf of songwriters, composers, and music publishers and distributes them as royalties to those members whose works have been performed.

Role: PL/SQL/Datastage Developer

Responsibilities:

•Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.

•Used Quality Stage to check the data quality of the source system prior to ETL process

•Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.

•Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the SQL Server database.

•Imported table/file definitions into the Datastage repository.

•Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign DataStage jobs for performing the required integration.

•Used DataStage Designer for developing various jobs for Cleansing, Transforming, Integrating and Loading data into the data marts.

•Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

•Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

•Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).

•Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

•Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)

•Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

•Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

•Involved in migration from SQL Server 2005 to SQL Server 2008.

•Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

•Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAS cubes.

•Developed ETL programs using Informatica to implement the business requirements.

•Communicated with business customers to discuss the issues and requirements.

•Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

•Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

•Developed shell scripts which can be used to load data from staging area.

•Developed user defined subroutines in BASIC to implement some of the complex transformations, date conversions, code validations and calculations using different DataStage supplied functions.

•Used Aggregator stages to sum the key performance indicators used in decision support systems.

Environment:IBM DataStage 8.0.1,9.1,11.3, IBM AIX, Windows 7, Oracle 11g/10g, Netezza, SQL*Loader, SQL Plus, TOAD, MS Visio, MS Access, MS Office, DB2, Shell, XML files, CSV files, Sequential files, UNIX, LINUX

Client: WELLSFARGO, West Des Moines, IA Dec 2012 – Dec 2014 Role: Oracle PL/SQL Developer / Datastage Developer

Description:Wellsfargo is an American multinational banking and financial services holding company. It is the fourth largest bank in the U.S. by assets and the largest bank by market capitalization.

Responsibilities:

•Used PL/SQL procedures to load huge data using Bulk Insert and Bulk Collect.

•Developed complex SQL queries and fine-tuned the SQL queries for performance.

•(PL/SQL) Created materialized views to pre-compute joins and store aggregated data.

•Involved as a key team member for Requirement Analysis during the design phase and developed various Design documents according to the user requirements.

•Involved in writing backend Packages extensively in PL/SQL.

•Involved in Code Reviews and preparing Unit test cases.

•Maintained the data integrity and security using Integrity Constraints and Triggers.

•Optimized and enhanced the existing procedures and SQL statements for the better performance.

•Defining and reviewing the coding standards besides reviewing the code.

•Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.

•Extensively involved in preparing Detailed Technical Documents from the functional specifications.

•Rule writing in a way to avoid any maintenance inside Configurator structure in future.

•Resolving all Bugs and Publishing (Remote and Local) issues

•Preparation of Checklists, identification of Test Cases and preparing Test Plans.

•Actively Involved in Integration and Deployment in Production Environment.

•Separating Tables and Indexes on different locations for reducing Disk I/O Contention.

•Used Bulk Binds and Bulk Collect.

•Designed Pragma Autonomous Transactions.

•Implemented External tables and created Sequences to generate numbers on the fly.

•Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

•High proficiency in developing Oracle PL/SQL packages.

•Tested and debugged Oracle PL/SQL packages.

•Built database objects like Tables and Views.

•Optimized and Tuned SQL queries and PL/SQL blocks to eliminate full table scans to reduce Disk I/O and Sorts.

•Handled PL/SQL Compile-Time and Runtime Errors.

•Migrated from 8.1 to 8.5 which were 40 percent faster in opening a job, running a job and runtime performance also improved.

•Analyzed the various sources and designed and developed DataStage jobs for extracting data from different databases such as SQL Server, IBM DB2 mainframe, Teradata, flat/CSV files and sequential files.

•Used DataStage Designer for developing various jobs for Cleansing, Transforming, Integrating and Loading data.

•Designed parallel jobs using stages like Aggregator, Transformer, cdc, cdr, Filter, Funnel, Modify, lookup, join, merge, surrogate key generator and remove duplicates etc.

•Excellent expertise in Shell and Unix scripting.

•Using shard containers created reusable components for local and shared use in the ETL process.

•Designed XML stages for reading XML log files for capturing data stage jobs audit data.

•Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.

•Analyzed data with discrepancies through error files and log files for further data processing and cleansing.

•Extensively used Autosys for automated scheduling of UNIX shell script jobs on daily, weekly monthly basis with proper dependencies.

•Worked on performance tuning and enhancement of DataStage job transformations.

Environment:Oracle PL/SQL, SQL, Shell Scripting, TOAD,SQL Developr,IBMDataStage 8.0.1, Debugger, IBM AIX, Windows 7, Oracle 11g/10g, SQL*Loader, SQL Plus, Teradata,,Netezza TOAD,MS Visio, MS Access, MS Office, DB2, XML files, CSV files, Sequential files, Solaris UNIX, Windows NT, LINUX.

Client: IBRAIN TECHNOLOGIES INC, MO Jun 2012-Dec 2012

Description:IBrain Technologies is one of the fastest growing IT companies in St.louis that provide Consulting and IT services to clients all across United States.

Role: Internship Jr.PL/SQL Developer (unpaid)

Responsibilities:

•Creation of Tables with table and column level constraints, views, synonyms.

•Involved in coding and testing of the system.

•Coding of PL/SQL procedures, functions, packages

•Unix Shell scripting

•Data Porting from Legacy applications to this application using SQL*Loader.

•Designed various automated batch process and manual batch process for user-friendly interface using SQL Scripts.

•Unit testing

Environment: Oracle, SQL, PL/SQL, UNIX shell scripts, Windows NT.

Contact this candidate