Viji

540-***-****

ac6xlq@r.postjobfree.com

Visa: Green Card

SUMMARY,

Over 14 Years’ experience as a ETL/Report Tester. Involved in complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Client/Server and web based environments.

Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle SQL & PL/SQL database programming language.

Extensive testing ETL experience using Informatica 9.1/8.6.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor)

Experience in using Oracle Forms 10g/6i/5.0&4.5, Reports 10g/6i&2.5, Oracle designer 6i/4.7, Oracle discoverer 10g, Apex 4.1, XML Publisher for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, Toad, SQL Developer, SQL Loader

Analyzed and developed reports using OBIEE

Experienced in Health Care, Manufacturing, Financial Modules and workflows

Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.

Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating data to load data from staging tables to production tables.

Proficient in writing UNIX KORN Shell Scripting

Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and Denormalization of Tables.

Worked different version control tools PVCS and migration tools KINTANA

Very good experience in production support

Extensive experience with various test efforts like data validation, integrity testing and Unit testing.

Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.

Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

SKILL SET

Database Oracle 12c/11g/10g/9i/8i/7x, MS Access

Languages SQL, PL/SQL, Unix shell scripts

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server) Operating Systems Sun Solaris, Unix, Windows NT/2000/XP, Linux

ERP Modules Order management (OM), AP, AR, GL

Reporting Tools OBIEE12c/11g, Oracle Reports 10g/6i/2.5, Jasper ireports,

Oracle apex 4.1/4.0/3.2

Web Technologies ASP, HTML, DHTML, XML, VB 6.0

Tools SQL*PLUS, TOAD, Sql Developer, SQL*Loader, Oracle Forms 10g/6i/4.5,, Oracle Designer 6i/4.7,Oracle Discoverer 10g SQL Navigator, JDeveloper, Rational Clearcase, Rational Clear quest, Load runner, Win runner, Erwin 3.5, Test Director, Microsoft Visio, Rational Rose, XML publisher, Jira, Kintana, Pvcs, SVN

PROFESSIONAL SUMMARY

Gilead, Foster City, CA Oct17-Present

Project name: GPLM (Giled Product Life Cycle Management)

Role: Sr. ETL Test Engineer

Involved in project inception meetings and understand requirements

Prepare test approach/strategy document by understanding high level functional document and end to end documents provided.

Prepare test plan, test estimation for the complete module and manage resources with respect to the work load. Review Test cases and monitoring test execution.

Co-ordinate with different stake holders and get project timelines.

Understanding the requirements and mapping documents for all phases of the ETL, BI.

Organize a test approach walk through meeting held with business and stake holders and the support teams and get a sign off for the test plan and test approach.

Developing test cases for ETL based on the functional and technical requirements

Tested the validity of the data cleaning done by the ETL by writing SQL and Scripts.

Writing SQL queries to retrieve data from data warehouse and source databases.

Scripting SQL queries for DB Testing through Toad, Sql developer.

Capturing defects and tracking them to closure using HP Quality Center.

Analyzing the impact analysis for changes testing.

used SQL queries for back-end data validation in Oracle DB.

Executed SQL Queries to retrieve data from tables and to perform back end testing.

Executed the End-to-End data validation for ETL tool BI systems.

Strong experience in executing the complex queries in Data Mart.

Compared the data between Data Mart and OLTP systems.

Executed business scenarios with the help of SME.

Provide support to client during UAT.

Supporting Coexisting testing and AM release testing. (Post UAT).

Finding route cause to the defects raised during Jira and UAT.

Communicating status (Weekly & Daily) and progress of all the stake holders.

Efficiently mitigating risks faced during each release and handling carefully in next release.

Tested a custom Info Cube as per design specifications in order to meet the business user requirements.

Performed extraction, transformation, and loading of data (ETL) by Oracle Database, Informatica

Environment: Informatica Power Center 9.1, PL/SQL, Oracle 10g/9i, Erwin, Toad 9.0, Sql Developer, OBIEE

Xtime Inc., Redwood City, CA (Cox Automotive) Oct11-Sep17

Project name: Service Analytics

Sr. ETL Tester

Established QA methodologies and processes that resulted in establishment of complete traceability of requirements and enhanced test quality.

Working as primary liaison with Business, QA and Development teams for major releases.

Worked closely with business to ensure that QA has full understanding of business objectives.

Determine Milestone deliverables, Communicate changes to schedule, Determines impact of schedule changes on quality objectives, Co-ordinates schedule with dependent groups.

Co-ordinates the testing efforts of multiple projects executed from On Site and offshore.

Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.

Executed the workflows in the Workflow manager, to start the ETL process.

Used Informatica Power center Workflow Designer to understand the data mappings and dependencies between different entities.

Used Informatica Power Center Workflow Monitor to trigger master/stand-alone workflows

Extensively used UNIX to validate log files, error files, flat files etc.

Prepared the ETL test cases after thorough analysis of each requirement.

Prepared Test Data by modifying the sample data in the source systems, to cover all the Requirements and scenarios.

Wrote complex SQL scripts using joins, sub queries and correlated sub queries for back-end data validation

Written several complex SQL queries for validating and verifying the data across different databases Oracle 10g and Oracle 11g

Used Soap UI to test the Web services.

Environment: UNIX, SQL developer, Toad, ETL – Informatica, QTP, HP QC and Team forge

Stanford University, Palo Alto, CA Oct11-Oct12

Project name: CADMS (Capital Accounting and Debt Management System)

Sr. Software Engineer

Description: CADMS, the Capital Accounting and Debt Management System, is an Oracle based application that tracks all capital project costs, bonds outstanding, and debt awards, and computes debt service for debt funded projects. In addition, CADMS provides customized management reports with roll-up and drill-down functionality and forecasting capabilities

Major Responsibilities:

Analysis of new business requirements and major developments.

Coded and debugged the stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.

Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA

Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.

Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.

Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression

Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.

Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools

Documented Informatica mappings in Excel spread sheet.

Tuned the Informatica mappings for optimal load performance.

Have generated reports using OBIEE 10.1.3 for the future business utilities.

Created, modified and reviewed Procedures, Packages and functions and cursors to suit business requirements

Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage

Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage

Created maintained and compared objects in multiple schemas for developers

Performed import and export of schemas, objects using data pump utility in 10g

Written shell scripts for rebuilding existing databases to keep up with the latest developments

Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance

Created indexes and partitions on various tables in order to enhance performance

Written shell scripts to load data into various subsystems using SQL loader

Provided production support and played a major role in debugging errors during implementation and deployment

Modified code to maintain user jobs running on regular intervals performing data transfer from staging area to log tables

Performed code reviews on PL/SQL and Unix/Linux developments

Created database objects like tables, views, synonyms, indexes, and sequences.

Used shell scripting to change and modify data.

Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and loadpackages for

data warehousing. Extracted data from the XML file and loaded it into the database.

Integrated, tested, debugged and implemented application systems.

Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.

Developed database triggers to enforce security. Also implemented materialized views for remote instances.

Responsible for application testing and support, version control, production staging and implementation planning, overseeing development efforts, support and training.

Environment:

Informatica Power Center 8.6.1, Oracle 11g/10g, Forms 10g, Reports10g, Designer 10g, SQL *Plus, Perl, XML, Oracle apex 4.1/4.0,TOAD, PL/SQL, HP-UX, Windows NT/2000, Oracle apex, sql developer, XML publisher, Kintana, Jira, PVCS

State Of California Public Utilities Commission (CPUC), SFO, CA Jan 11-Sep11

Project name: TUFFS(Telecommunications User Fees Filing system)

Sr. Software Engineer

Description: The CPUC regulates privately owned electric, natural gas, telecommunications, water, railroad, rail transit, and passenger transportation companies. The CPUC serves the public interest by protecting consumers and ensuring the provision of safe, reliable utility service and infrastructure at reasonable rates, with a commitment to environmental enhancement and a healthy California economy. We regulate utility services, stimulate innovation, and promote competitive markets, where possible. On this website you'll find information about the many initiatives underway at the CPUC.

Major Responsibilities:

Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.

Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling

Designed and developed Oracle Forms & Reports using Forms10g/6i/4.5 and Reports10g/ 6i/2.5. Including Forms based on stored procedures

Extensive experience with various test efforts like data validation, integrity testing and Unit testing.

Used Oracle designer to produce the ER diagrams, Dataflow, function Hierarchy.

Created and modified SQL*Loader scripts for migrating flat file data into target.

Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

Working Knowledge of MS Access advanced functions and VBA

Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.

Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.

Written shell scripts and executed them as Cron jobs on UNIX.

Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.

Used UNIX Shell (Korn) Scripts for Extraction, Transformation and Loading of data.

Responsible for analyzing, designing and coding of the applications by utilizing the Perl

Providing support for the EWB systems.

Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment:

Oracle 11g/10g, Forms 10g, Reports10g, Designer 10g, SQL *Plus, Perl, XML, TOAD, PL/SQL, HP-UX, Windows NT/2000, Oracle apex

Applied Bio System (Thermo Fisher Scientific), Foster city, CA Mar08-Dec10

Project name: Expanded Oracle Application (XPO)

Software Engineer

Description: Applied Biosystems has demonstrated its position as a technology leader and driving force in the changing dynamics of the life science marketplace. The Applied Biosystems business is focused on the following markets: basic research, commercial research (pharmaceutical and biotechnology) and standardized testing, including forensic human identification, paternity testing and food testing. The company has an installed base of approximately 180,000 instrument systems in nearly 100 countries. Basic research includes work at university, government and other non-profit institutions that focus on uncovering the basic laws of nature and understanding human disease. Pharmaceutical and biotechnology companies use Applied Biosystems' products to discover and develop new drugs more effectively.

Major Responsibilities:

Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.

Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling

Designed and developed Oracle Forms & Reports using Forms10g/6i/4.5 and Reports10g/ 6i/2.5. Including Forms based on stored procedures

Extensive experience with various test efforts like data validation, integrity testing and Unit testing.

Used Oracle designer to produce the ER diagrams, Dataflow, function Hierarchy.

Created and modified SQL*Loader scripts for migrating flat file data into target.

Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

Working Knowledge of MS Access advanced functions and VBA

Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.

Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.

Written shell scripts and executed them as Cron jobs on UNIX.

Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.

Used UNIX Shell (Korn) Scripts for Extraction, Transformation and Loading of data.

Responsible for analyzing, designing and coding of the applications by utilizing the Perl

Providing support for the EWB systems.

Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment:

Oracle 10g, Forms 10g, Reports10g, Designer 10g, SQL, PL/SQL, TOAD, Perl,

SQL *Plus, Windows NT

Department of transportation (CALTRANS),sacramento,ca Jan07- Feb08

Project name: Extra work billing system(EWB)

Software Engineer

Description:

Caltrans manages more than 45,000 miles of California's highway and freeway lanes, provides inter-city rail services, permits more than 400 public-use airports and special-use hospital heliports, and works with local agencies. Caltrans carries out its mission of improving mobility across California with six primary programs: Aeronautics, Highway Transportation, Mass Transportation, Transportation Planning, Administration and the Equipment Service Center. The department has been active in moving the people and commerce of California for more than 100 years from a loosely connected web of footpaths and rutted wagon routes to the sophisticated system that today serves the transportation needs of more than 30 million residents. My responsibility included creating and managing the data tables, developing the backend code for the screens and creating validation for all the fields.

Major Responsibilities:

Interacted with Business users, gathering and analyzing requirements

Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into the GL interface Tables.

Used UNIX Shell (Korn) Scripts for Extraction, Transformation and Loading of data.

Created staging tables necessary to store validated data prior to loading data into GL interface tables.

Created PL/SQL Packages, procedures and functions necessary for validations before loading records into GL interface table.

Validation includes Source, category, code combination. Also checked for duplicates and nulls.

Developed Database Triggers to enforce security.

Used Dynamic SQL (DBMS_SQL, DBMS_DDL) in functions and procedures also used UTL files for producing flat files.

Extensively used SQL and Pl/SQL queries to clean and filter the legacy data.

Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.

Providing production support for EWB systems.

Creating Test scripts for the generated final Reports.

Involved in writing Technical Specification Document.

Environment:

Oracle 9i, SQL, PL/SQL, TOAD, Erwin, SQL *Plus, Forms6i, Reports 6i, perl, Oracle Apps 11.5.8.

EDS, Madison, WI May06-Dec06

Software Engineer

Description:

EDS provides a broad portfolio of business and technology solutions to help its clients worldwide improve their business performance. The project provides solutions for several state health care benefit programs at for Wisconsin Division of Health Care Financing. My responsibility included creating and managing the data tables, developing the backend code for the screens and creating validation for all the fields

Major Responsibilities:

Associated and involved in different phases of System Development Life Cycle (SDLC)

Interacted with business analysts to develop entity relationship diagram

Created complex stored procedures and functions using PL/SQL.

Database performance tuning for achieving high scalability and speed.

Written SQL scripts, PL/SQL stored procedure, functions, triggers, and packages

Involved in developing front end screens using forms 6i and generated reports using reports 6i builder.

Written scripts to validate data in staging tables and developed SQL*Loader control files to load the data from flat files into the staging tables.

Support developers with database objects, including tables, views, triggers and stored procedures as well as DDL, DML SQL queries.

Provided technical support to end users like modifications in PL/SQL modules, User Interface based on the defects observed in testing and production phase

Responsible for coding and debugging and maintaining quality standards set by management.

Environment:

Oracle9i, SQL, PL/SQL, SQL*Loader, Toad, Windows NT/XP, HP UNIX, Perl, Forms 6i,Reports 6i

Tata steel(Tisco), Jamshedpur, India May02-APR06

Oracle Software Developer

Major Responsibilities:

Involved in Data Loading and Data Migration.

Used Erwin to produce the ER diagrams.

Written SQL scripts, PL/SQL stored procedure, functions, triggers, and packages.

Implemented materialized views for remote instances.

Involved in Query Optimization and Tuning tasks.

Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database.

Making whole process run through Custom built ETL (SQL*Loader, Shell Scripting, PL / SQL Stored Procedures).

Developed forms according to user requirements using Forms 6i.

Designed and developed several matrix and master-detail reports with Oracle report designer.

Developed Reports using Reports 6i based on client requirements.

Generate SQL Scripts and create views for reports.

Scheduled the jobs using cron jobs in UNIX.

Performed Shell scripting in UNIX to automate the various processes.

Prepare technical documents for all the programs developed & generated.

Responsible in coding, trouble shooting and debugging.

Developed stored procedures, packages and functions for the application that could be called by Forms & Reports.

Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance.

Developed new Data Input forms and Reports using Oracle Forms and Reports builder.

Written scripts to create Temporary tables in various schemas and Audit Transactions.

Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.

Environment:

SQL, PL/SQL, SQL * Loader, Windows 2000/XP, Oracle 9i, Forms 6i, Reports 6i, TOAD 6.4

EDUCATION

Bachelor of Engineering in Electronics, India.

Contact this candidate