Software Engineer Data
Resume:
Viji
******@*****.***
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