Summary:

Applicant is in Information Technology field for over 17 years. She has experience with relational databases for over 17 years. Applicant has hands on, extensive experience with Oracle, Sql server, Netezza, T-SQ, PLSQL, stored procedure and all other data related developments. She also has intensive experience to design and implement N-Tier applications. Recently, her main responsibility is collaborating with the business to develop and deploy reporting and data analysis solutions that add value to the business. Her current responsibilities are data integration among different internal and external systems and data warehousing design and implementation using Informatica to help business with their reporting needs. Applicant worked for several companies as a consultant to help them find the best solution and technology, which suits the nature of their work.
Applicant has extensive background in the analysis, design, development and implementation of various business applications.

Education:B. S. in Computer Science

Certifications:

• Certified Microstrategy development with the focus of ETL
• Certified informatica (Power center development )
• Certified Oracle Tools
• Certified Unix operating system

Industry Experience

• HealthCare
• Telecommunication
• Oil Company
• Software
• Contracting companies
• Airline
• retail

Technical Summary

• Working with business analyst to find out the things of significance to the project and relationship between them and based on that design the logical data model and/or UML visual modeling which addresses business and functional requirements of systems development.
• Develop DB logical model: normalization, documentation, communication. (Create a well-documented, normalized data model to communicate and validate design elements with team members.)
• Transform logical model to physical model: conformance to database rules, resolution of many to many relationships, implementation of referential integrity.
• Working on performance by denormalization, indexing strategy and physical storage.
• Using Informatica for ETL developments.
• Using data model to define operational aspects of business and orient the team to goals and operations developing reports using crystal report, sql server reporting services and business objects.
• Developing complicated stored procedures, queries, triggers, functions, views, T_SQL, cursors developing backend processes using ADO.net, XML (generating xml documents, reading and writing XML in .NET, parsing xml documents inside stored procedures) creating web services
• Developing business layer of the application.
• Working with DTS packages to import/export data and for data mining purposes.
• Working with SqlServer integration services (SSIS)
• Writing Unix scripts and shell programming
• Teaching Unix operating system, oracle RDBMS and oracle tools
• N-tier, Component Based application designer
• Com/Dcom developer.
• Leading the team of developers utilizing Visual Basic, Visual InterDev, ASP and vb.net tools for different projects.

Skills

• Different relational databases including sql server, oracle, access , Informix and Netezza
• Unix and Windows operating systems
• Transact-SQL and PL/SQL
• ER/Studio and Erwin
• Informatica
• Toad
• Shell programming (Bourne shell, korn shell and C shell)
• Oracle tools (Sql Forms, Sql report Writer, Sql/Plus, Sql Load)
• XML
• ADO.NET
• Visual basic, VB.net and c#
• Active Server Pages
• ETL tools found in sqlserver 2000 and above
• Com/Dcom components
• C and pro*c programming

Professional and business history:

From 01/2002 Until now
Data warehouse (ETL) architect and developer/DB designer/Application Developer/
Confidential

• Interact with PetSmart business leaders in regards to current and future reporting. Seek to understand the business processes and problems; offer solutions based on leveraging the process, the data flow and the use of Business Information (data warehouse/reporting).
• Problem solve (out of the box thinking) in areas of performance, availability, access and other related issues related to the delivery of reporting and analytic content.
• Analyzing different databases on different platforms and design and implement ETL solution. In this role I need to know about all relationships between database objects of different business areas of company (including inventory, backorder, SAP, POS, services, people etc) to do ETL development based on the need of BI team. I utilize Informatica, toad, Erwin and Unix in my developments.
• Leading ETL projects containing the following steps:
• Working with business to gather their requirements. Helping them to clarify their requirements by doing intensive data analysis.
• Translate business needs to logical data model.
• Design ETL process to retrieve raw data to the data warehouse.
• Creating complicated queries and stored procedures to translate raw data to the information needed for business.
• Helping reporting people to utilize the data.
• Enforcing standardization.
• Creating design documentations.
• Working with DB administrator to create physical data base and defining table retentions.
• Working with business analyst and a team of 4 developers to develop new functionalities for customizing their existing package using Visual Basic v6.0, access and crystal report. This package is using in PetsMart stores to computerize all their grooming and boarding services they offer to their clients. This package uses VB 6, Sql Server and crystal report 8
• Developing new .NET application to centrally manage master data for the distributed TouchPoint applications. This application uses vb.net , c# , sql server and sql server reporting services. I was involved in the whole life cycle of this application (from data gathering to test), besides that I was responsible for all data base related parts of this application. I generated some complicated stored procedures and functions to gather XML files generated by application and files generate from SAP system, compile them and load them in different master tables.
• Writing utilities to run in store’s application servers for different tasks, including “roominteligentassignment”, perging, extracting information from access DB to be loaded in central database. The utilities are using c# under .NET framework.

From 10/2001 To 01/2002

DB designer / Report Writer
Confidential
This company makes surveys for leasing companies and provides graphical and analytical reports for them based on the survey’s results. During this period I designed their Database on Sql Server and create several stored procedure for their reporting purposes and wrote several reports using crystal report. Also I converted their reports from access to crystal. I also wrote a user interface using Active Server Pages to enable the clients view, print the reports through the WEB. The clients also can convert their reports to excel spreadsheet and adobe acrobat software’s through the WEB.

From 5/2001 To 10/2001 
DB Designer / Application developer
Confidential
Develop the web application to be used by Flight Attendants and pilots. This is a bidding system which let the Flight attendants and pilots make their bid through the website for each bid period and then the in-flight administrator assign awarded line to them based on their seniority and the contract. The project consist of 3 parts 1_ Populating the data in DB based on scheduling of flights 2_ in certain time of each bid period the pilots go to this site and based on the scheduling select their preferences and make their bid 3_ there is another project for in-flight administrator for administrating purposes like assign awarded lines to each employee based on some rules, all actions should be taken for new hire, termination and transfer of each employee and other administration for support tables. This project use VB to develop Com component as a wrapper around business rules and all DB calls and also Active Server Pages and VB script for client site. The Db is Oracle Version 8 and most of the business rules applied through triggers and stored procedures. The project has 3 tier / component based architecture. Components run under Com+. The website now is up and running. 
During this period I conduct a team to develop templates for all 2tier and 3 tier applications to be sure that all of our further developments will use the consistent way of all development aspects (like error handling issues, documentation, call to Database.) and also to make sure that in our further developments we avoid the redundancy so we can do our developments much more faster. Also I prepare a template for developing triggers and stored procedures. I define the rules that we need to consider when we want to design the relational Data Base.
Other responsibilities, which I have in, this company is maintaining and enhancing their current developments Auto pay and Auto clean. Both of them use VB and Oracle and the main purpose of those programs is to based on some information which the program get from oracle DB, prepare some kind of word documents and email them to some receptionist. So they utilizing word and excel inside the VB application.

From 7/2000 To 12/2000
N-Tier, Component Based, Asp solution Application Developer
Confidential

Supervising a team of 3 to develop software, which manages customers, jobs and materials for a “subcontractor” company and also created necessary flat file inputs to run Quick-Pro package.

The architecture of project was N tier and component base. Business tier works under Microsoft Transaction Server using visual basic for making components. From the back end point of view the project uses stored procedures and triggers whenever it is possible. A separate DLL isolated all of the SQL commands.

Active X control was created to let users choose their reports based on certain conditions and set report parameters and also let users make queries.

This package uses asp, Visual Basic Version 6, Oracle version 8, ADO, Microsoft Transaction Server and Crystal Report Version 8.

From 7/99 To 7/2000
Object Model and architecture designer/ DB designer/Application developer
Confidential

Design the architecture; object model and Data model of the project as a 3tier and component based. The project is providing AM/FM packages, which is automated facility manager used by telecommunication companies to design/maintain and analyze their networks.

Gather database requirements from end users, which were telecommunication engineers to be used for the design of data model and object model of the system. 
Investigate which part of project could be done through stored procedures and triggers. Isolate them from business and user tiers.

Using ER/Studio to create logical data model of their database and represent that to the team and to the business.

Implemented Active X components which are shareable between all developers like DBManager.dll in data tier containing all of dB interactions and SQL statements, Some shared sections of object model and all global and error handling issues.
This package uses Visual Basic Version 6, Oracle 8.0, ADO and Crystal Report Version 8.

From 2/99 To 8/99
3-Tier, Component Based Application Developer
Confidential
Designed a 3-tier application using all of the Object Oriented features for customer return authorization process.
This application comprised of one executable as a user interface, 2 Active-x.exe file as business tier and data tier, 3 Active-x.dll to be used by all 3 tiers for error handling process and keep global constants. Also 2 Active-x controls to be used by user interface.
In this project Visual Modeler was used to design and Visual Basic V6, ADO and SQL SERVER V7 was used for implement and coding.

From 1/99 To 3/99
Application Programmer
Confidential

Wrote a Query Builder application to interface between user and Oracle databases. This query Builder retrieved information from Oracle database, and was build for users with no knowledge of SQL.
Allowed user to utilize Crosstab queries and export the result to excel for aftermath process.
Visual Basic 5, RDC (remote data control) and ORACLE Version 8 was used to generate this application.