DOINA DORDEA

**** ******* **., *********, **

E-mail: acrg92@r.postjobfree.com

Mobile: 925-***-****

Professional Summary

Extended Experience in leading offshore teams, project management, reporting progress and estimate work

Extensive experience in data analysis, development, reporting, performance optimization and tuning

Expert level skills in Technical and Data Architecture

Extended experience in ETL tools- Informatica, AppWorx, SQL Oracle, Teradata, Java, C++, Visual Source Safe, Visual Basic, NET concepts, HTML, DAO, ODBC, real-time applications.

Experienced in several Operating Systems.

Skilled in Data Base Management Languages (oracle and Teradata) and performance tuning, as well as data modeling

Experienced in testing planning, scripting, execution (unit testing, quality testing, data integrity testing, performance testing)

Substantial experience in all phases of Software development – Over 15 years

Excellent verbal and written communication, very strong skills in critical thinking and technical analysis, troubleshooting, problem solving

Experienced in interfacing with clients/users to gather business requirements and preparation of Systems Requirements Specifications, System Design Document as per IEEE standards

Analyzed business processes to develop the system requirements, design and functional specifications

Tools

Operating systems

UNIX, LINUX, DOS and Windows

RDBMS

ORACLE, MS SQL Server, TOAD for Oracle, Teradata SQL Assistant, MS Access

ETL Tools

Informatica Power Center

Front Ends/High level languages

IBM WebSphere (Java), C, VB 6.0, PL/SQL, UNIX Shell scripts, NET, XML

Scheduling Tools

AppWorx, Informatica scheduler

Project Planning

Accenture estimating tools (for estimation) and MS Project (for planning and tracking), excel custom design forms.

Quality testing

Mercury Quality Center.

Projects – ACCENTURE 2005 to 2015

Project: Client Boston Scientific

Scope: Migrate the HR from Peoplesoft to Success Factors. Build new interfaces

Role Title: SuccessFactors Interfaces ETL Lead

Responsible for managing the development team as well as POC for testing, clint business teams, etc.

Accomplishments:

• Lead the development of new ETL interfaces using PLSQL coding.

• Review Functional documents and work with the Functional Designer to add the detail necessary required by the Technical Design.

• Work with the Client architect to define a consistent implementation solution across the interfaces.

• Develop the Technical Design document for assigned ETL interfaces

• Develop the PLSQL code required for assigned ETL interfaces

• Develop Informatica Workflows to run on schedule the interfaces

• Develop and execute Unit Testing for assigned ETL interfaces

• Participate in troubleshooting and support of ETL interfaces

• Provide best practice guidance to the team in order to implement a solid solution

• Provide technical assistance with performance tuning to the team developers to meet the business requirements for run time

•

Project: Client Kaiser

Scope: Provide input for Application improvement (features, performance), manage production operations

Role Title: Production Operations Manager

Responsible for managing production operations and production incidents on a large outsourcing project. In addition, perform an assessment of the applications and operations and provide an expert point of view and recommendations.

Accomplishments:

•Understand the application and provide an application assessment and recommendations for improvement

•Manage the production incidents

•Help the Kaiser accont with new projects contracting

Project: Client Symantec

Scope: Build 14 Universes for ODS (life reporting) and EDW (Teradata) universes for analytical reporting.

Role Title: Data Foundation ETL Team Lead

The Data Foundation ETL Team Lead will report to the Data Foundation Leads and will drive the development of the related Technical Detail Design for the ETL Universes and the build and unit test of all ETL code. Also will manage the ETL developers onshore and offshore.

Accomplishments:

•Design and model 14 universes for reporting (oracle Universes 12 – real time reporting, Teradata 6 universes – analytical reporting, 4 universes where both real time reporting and analytical)

•Manage, oversee, and communicate with a team of 24 onshore and offshore ETL developers

•Oversee the quality of the completed Technical Detail Design, Review the Technical detail design, data model and ETL code. Provide solution and feedback for improvement and standardization

•Write Technical Detail Design for the most complexe requirements

•Oversee the quality of the build of the ETL code (implementation, performance, maintainability, best practice standards- this is mandatory considering ETL will run ongoing) and develop code as implementation templates for offshore

•Determine and manage development strategy

•Review and provide feedback for unit test plan and review the execution and results of the unit testing

•Help with the execution of code for testing and unit testing

•Build the deployment plan, establish the tasks and validation procedures, manage the dependacies on other components part of deployment

•Review and work with the offshore ETL lead to create the migration documents in Perforce

•Work with the QA resources during break/fix and as incorrect data is identified

•Work with the conversion team to fix the conversion defects, so unit testing can be performed

•Manage sign off of Technical Detail Design, Build, and Unit Test

•Prepare and communicate weekly status (accomplishments, issues/risks, next steps) and drive relevant issues/risks to completion.

•Work with HP to replicate data through Golden gate from R12 to the ODS reporting environment as well as data availability for unit testing as needed

•Schedule the ETL (Informatica Jobs) through AppWorx – last minute client requirement change

•Performance tuning for the ETL jobs (Oracle to Teradata) – Client request to have their existing mappings using our design to improve performance on the existing Informatica jobs

•Implement very efficient Error Handling process for Informatica Jobs – part through Informatica standard Error handling tables, part through customized error handling for Orphans processing).Client appreciate the ETL job performance and switch the existing ETL jobs (managed by client IT) to our design.

Project: Symantec - Salesforce migration

Scope: Extract, transform and Load Symantec Accounts, customers, Entitlements, case, case task and activities from various platforms into SFDC.

Role Title: ETL and Test Lead

The ETL and test Team Lead will report to Project Leads and will drive the development of the related Technical Detail Design, Informatica coding and testing activities and data validation/reconciliation strategies for the loaded data in Salesforce. Also will manage the ETL developers onshore and offshore.

Accomplishments:

•Manage, oversee, and communicate with the onshore and offshore data conversion developers

•Work with the client business to gather the requirements (transformations that are required before loading the data in SFDC)

•Work with HP to validate the extract data file integrity, used as entry for the informatica mappings

•Oversee the quality of the build of the ETL code and develop code for the complexe area

•Oversee the quality of the unit testing performed by offshore and perform unit testing as necessary

•Determine and manage development strategy

•Help with the execution of the mock conversions and final load in SFDC

•Mentor Junior developers (onsite and offshore resources)

•Assign tasks; provide technical directions to offshore developers

•Hold daily status calls with offshore resources

•Investigate defects, fallout analysis, provide solutions

Project: Client VMware - Entitlements Assessment

Scope: Convert Entitlements from Oracle to Teradata. Build Teradata Entities for Entitlements management and reporting.

Role Title: ETL, configuration and conversion Lead

The Data Conversion Development Lead will report to the Data Conversion Delivery Leads and will drive the development of conversion related TDDs and the build and unit test of all ETL code. Also will manage the ETL developers onshore (Accenture and client resources) and offshore.

Accomplishments:

•Manage a mixt team of 19 members (client, onsite contractors and Accenture offshore), oversee, and communicate with the onshore and offshore data conversion developers.

•Build the team, conduct interviews with offshore ACN resources and outsource contractors for the onsite developers roles

•Provide work estimate, manage the team daily activities, assign tasks.

•Knowledge transfer and workshops with Offshore to build the missing skills

•Oversee the quality of the completed TDDs and provide feedback, as well as work on the most difficult TDD’s

•Oversee the quality of the build of the ETL code and develop code for the area that required more complexity

•Determine and manage development strategy – convert the client users, customers, entilements, service contracts, orders – create a new tool for Entitlements management.

•Create unit test plan and manage the execution of the unit testing

•Help with the execution of the mock conversions and final deployment

•Work with the Data QA resources during break/fix and as incorrect data is identified

•Work with the Data Cleansing resources to identify data requiring cleansing and/or remediation

•Work with the client IT and business to gather the requirements

•Manage sign off of TDDs, Build, and Unit Test

•Prepare and communicate weekly status (accomplishments, issues/risks, next steps) and drive relevant issues/risks to completion

•Manage the final conversion to production, support 2 weeks after the go live

Project: Client VMware – EDW Roadmap

Scope: Create the EDW data warehouse (Teradata) for VMware, using Informatica.

Role Title: EDW Application Lead

The EDW Application Lead will report to the Project Delivery Leads and will drive the development of EDW Teradata build, deployment and testing as well as will manage the ETL developers onshore(Accenture and client resources) and offshore.

Accomplishments:

•Provide communication between offshore team and the Delivery and Functional on site Leaders (delivery lead – client employee)

• Manage team project activities an a daily basis

omaintain the project plan

oTrack the progress of the project deliverable

oEstimate the work effort

oManage the project timelines and deliverables

•Work with the Delivery and Functional Leaders, as well as with the Offshore ETL Leader to finalize the design approach.

•Work with the client business to gather requirements for enhancements and new addition to the EDW teradata wharehouse

•Design the enhancement and new addition considering existing implementation standards, avoide any impact or duplicate to the existing EDW wharehouse

•Technical Support for the offshore team, weekly workshop meeting to discuss the solution approce and offer guidance for coding and industry standards implementation

•Obtain the sign off for the finalized design from the client

•Support the offshore team in using the ETL best practice in the project implementation

•Deployment planning, documentation and execution of the deployment tasks

•QA review the design and implementation

•Provide weekly status report

•Work with Informatica resources to configure Informatica to work on the VMware cloud

Project: Clent GAP Inc. - Gap - China Growth. Intv Oracle

Scope: GAP China project need a custom Replenishment Tool and a custom Markdown tool.

Role Title: Application Designer

Gather requirement and build the Replenishment Tool and Markdown tool for the new Open GAP Warehouse in China and Japan

Accomplishments:

•Develops code and provides application code support (e.g., root cause, bug fixes) to meet business requirements.

•Develops, and re-engineers application components (replanisment tool and mark down tool)

•Integrates software packages, develops programs and reusable objects.

•Conducts unit test planning and unit testing/validation.

•Analyzes business problems, review High level technical design and develops solutions.

•Uses technical expertise to translate business requirements into detailed functional designs.

•Assists in architectural design efforts.

•Develops detail design specification and production specification of deliverables related to the project.

•Assists in the post-implementation support and enhancements of deliverables

•Creates user or technical documentation as appropriate.

•Provides subject matter expertise for the application and technology.

•Identifies and prioritizes application risks and issues, escalate to the leadership and monitors results.

•Designs technical IT architecture and provides support.

•Fully estimate the work effort for the project related tasks

Project: Client AT&T – CCPM Informatica

Scope: Build the Teradata Wharehouse for AT&T for Customers, sales, agents, orders.

Role Title: Informatica Development Technical Lead

Accomplishments:

•Develops and re-engineers application components to meet business requirements.

•Manages and updates Requirements Traceability Matrix for project.

•Uses technical expertise to translate business requirements into detailed functional designs, conducts walk-throughs, and obtains sign-off.

•Assists in architectural design efforts. Provides SME for the application and technology.

•Performance tuning for the Informatica mappings as well as for the Teradata Sql’s

•Provides technical leadership, estimate and assign tasks and review status.

•Identifies and prioritizes application risks and issues; develops application risk mitigation plans and monitors results.

•Perform codding and testing for the sale force module

Project: Client AT&T – Swot Proxy

Scope: Build and deploy a scalable architecture. Rationalize existing web shopping carts for Telco, Long Distance, Cingular and DSL services into a Single Web Ordering Tool, built on the new scalable architecture

Role Title: Onshore Application Management Lead for SWOT Proxy AT&T Partners interface

Accomplishments:

•Provide communication between offshore team and interfacing systems and support groups such as: content team, testing team, SCM, Web Ops, Project management and Release management

• Manage team projects activities:

• Receive business requests and requirements, decompose them into Technical requirements, investigate feasibility and present findings, estimate effort for designing, development, communicate requirements and explain details of request to offshore team.

• Review code for the developed software components that adhere to detailed design specifications and coding standards,

• Perform Unit Test scripts derived from detailed design, as well as defect management

• Perform root cause analysis for testing defects.

• Implement defect fixes to software components.

• Check code into source repository in preparation for software deployments.

• Provide status on defect fixes for testing teams

• Database scripts and code changes

• Assist in midnight release deployment.

• Perform ad-hoc research and investigate how the application works to assist requirements managers and end users in writing requests for new functionality or changes to current processes

• Partners Support - Investigate and provide a fix for their issues.

•Develop weekly status report for the client, provide SLA data for consolidation on a monthly basis, and provide the offshore monthly status and invoicing, manage the WMS and CM/PM.

Project: Client SBC - DSLIOT

Scope: Manage enhancements for DSLIOT tool, including development and releases

Role Title: Onshore Application Management Lead for Internet Ordering Tool for SBC.

Accomplishments:

•Provide communication between offshore team and interfacing systems and support groups such as: content team, testing team, SCM, Web Ops, Project management and Release management

• Manage team projects activities:

• Receive business requests and requirements, decompose them into Technical requirements, investigate feasibility and present findings, estimate effort for designing, development, communicate requirements and explain details of request to offshore team.

• Review code for the developed software components that adhere to detailed design specifications and coding standards,

• Perform Unit Test scripts derived from detailed design, as well as defect management

• Perform root cause analysis for testing defects.

• Implement defect fixes to software components.

• Check code into source repository in preparation for software deployments.

• Provide status on defect fixes for testing teams

• Database scripts and code changes

• Assist in midnight release deployment.

• Perform ad-hoc research and investigate how the application works to assist requirements managers and end users in writing requests for new functionality or changes to current processes

• Partners Support - Investigate and provide a fix for their issues.

•Develop weekly status report for the client, provide SLA data for consolidation on a monthly basis, and provide the offshore monthly status and invoicing..

Educational Background

University/College: Western University/Romania

Degree:

-M.Sc. Math with sp in Mathematical models & Operations Research

-M Sc. Computer Science with sp in programming languages and application architecture

Contact this candidate