Hello,

I am a  Sr. Informatica/Oracle Warehouse Builder Developer with good =
experience in mission critical software applications with a strong =
background in Data Warehousing and Oracle technology areas=2E

I hold a valid H1B visa=2E
I am available immediately=2E
I am ready to relocate depending on the nature of assignment=2E

At present i prefer to work on corp to corp contract assignments=2E

Thanks,
=20
Nisha
=20
                                                                           =
                            Resume
                                                                           =
                         Nisha Aggarwal
                                                                           =
                     nishaagwl@gmail.com
SUMMARY
"	An IT professional with good experience in mission critical software =
applications with a strong background in Data Warehousing and Oracle =
technology areas
"	Three years of strong experience in developing and maintaining Business =
Intelligence solutions in Data Warehousing/Decision Support Systems using =
ETL tools,=20
              Informatica PowerCenter 7.x, OWB(Oracle Warehouse Builder), =
Business objects 5.1, OLAP, ROLAP and MOLAP
"	Implemented data warehousing methodologies for Extraction Transformation =
and Loading using Informatica Designer, Workflow Manager, Workflow Monitor
"	Experience in Dimensional Data modeling techniques like Star Schema, =
Snowflake modeling, Fact and Dimensions tables
"	Good Data Processing experience in designing and implementing Data Mart =
applications, mainly transformation processes using Oracle Warehouse =
Builder and its=20
              relative components
"	Good knowledge in Data Modeling
"	Proficient in understanding business processes / requirements and =
translating them into technical requirements=2E
"	Expertise in extracting data from various data sources like flat files, =
Excel files, MS Access, SQL Server, Oracle
"	Strong working knowledge in RDBMS including Oracle 8i, 9i, SQL Server, =
MS Access, etc=2E
"	Expertise in writing complex SQL queries, PL/ SQL (Stored Procedures, =
Functions, Triggers)
"	Experience in Microsoft office PowerPoint, Word, Excel and Visio
"	Good interpersonal and communication skills

SKILLS
ETL tools		Informatica PowerCenter7.x (Source Analyzer, Data Warehouse =
Designer, Mapping Designer, Mapplets, Transformation Developer, Workflow =
monitor),=20
                            OWB - Oracle Warehouse Builder (Source Module, =
Target Module, Transformation Module, Control Center Manager, Job Monitor, =
Repository Browser,=20
                            Process Flow)
Reporting tools	Business Objects 5.1 (Designer)
Databases	Oracle 10g/9i/8.x/7x, MS Access, SQL Server
Languages 	C, HTML, SQL, PL/SQL, Visual Basic
OS 		Windows 98/2000/NT/XP, UNIX, DOS
Packages: 	SQL* PLUS, SQL Loader, Enterprise Manager Console,Toad 7.5

EDUCATION:
"	Masters in Computer Applications, Kurukshetra University, India=20
"	Bachelors in Application Sciences, Delhi University, India

EXPERIENCE:

Maersk Inc., Charlotte, NC           		 					     09/06 - Present=20
Informatica/OWB Developer
Description:
The A.P. Moller - Maersk Group is a worldwide organization with more than =
110,000 employees, offices in over 125 countries, and headquarters in =
Copenhagen, Denmark. They have container handling operations at 12 =
terminals in North America with through-put in millions of TEU each year=2E
Maersk Sealand is one of the child flagships of the AP Mollar group. There =
are three source systems COPS, PAYROLL and Express implemented across 13 =
geographical locations in US. The end objective of this project is to =
develop the APM Terminal BI system which will be accessible through a web =
based portal.   The portal will provide easy access to pre-run (automated) =
daily, weekly, and monthly reports. For the more sophisticated users, the =
BI application will provide end-users with the ability to perform ad-hoc =
analysis.  The Portal will be divided into several sections, including =
Corporate, Gate, Rail, Yard, Vessel and report warehouse screen=2E
Role:
"	Involved in analyzing source systems, business requirements and in =
complete system study
"	Worked on Oracle Warehouse Builder and Informatica as the existing =
system was on OWB and was later moved to Informatica=20
              While working on OWB:
              =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
"	Involved in creating strategy for incremental loads happening every 15 =
minutes for the EXPRESS system and daily load strategy for COPS and =
Payroll, creating and=20
              populating the time dimension
"	Extracted data stored in Oracle 10g and loaded data into Oracle Data =
warehouse
"	Oracle Warehouse Builder 10g release 2 was being used as the ETL tool=2E
"	Worked with Source Module, Target Module, Transformation Module, Control =
Center Manager, Job Monitor, Repository Browser
"	Developed several complex mappings, transportable modules and pluggable =
mappings
"	Developed all the mappings for Payroll and Express systems using =
transformations such as splitter, joiner, table operators, aggregator, =
filter, deduplicator,=20
              expression etc. The mappings were connected using process =
flows and work flows=2E
"	Created Data Breakpoints and Error Breakpoints for debugging the =
mappings using Debugger
              While working on Informatica:
              =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
"	Involved in the evaluation of Informatica 7.1.3 as the ETL tool for =
migrating from OWB
"	Worked with Source Analyzer, Data Warehouse Designer, Workflow monitor, =
Mapping Designer, Mapplets, and Transformation Developer
"	Created Data Breakpoints and Error Breakpoints for debugging the =
mappings using Debugger
              While working on Backend RDBMS:
              =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
"	Worked with tables, indexes, constraints, views and synonyms
"	Created dimensions and fact tables
"	Created functions, procedures and triggers in PL/SQL
"	Worked extensively on complex SQL statements
"	Participated in reconciling data drawn from multiple applications across =
the company into Oracle data warehouse
"	Created and maintained various project related documents like high level =
design documents etc=2E
"	Created, executed and documented associated test cases
"	Reviewed the deliverables of peer group
Environment: Informatica 7.1, Oracle Warehouse Builder, Oracle 10g, =
Workflow Manager, Enterprise Manager Console, PL/SQL, SQL Loader, Windows NT

Comag Marketing Group, Charlotte, NC    					     09/05 - 08/06=20
Informatica Developer
Description:
CMG is a diversified international, sales and marketing organization for =
America's leading magazines, books and specialty products. CMG provides =
client publishers with comprehensive sales, marketing and promotional =
services through a network of domestic and overseas sales venues=2E
Involved in building and maintaining Data warehouse and Data mart using =
Informatica and Business Objects. These reporting system are built for =
internal as well as external user groups (Publishers, Wholesalers and =
Retailers) and the reporting is through Business Object Web Intelligence
Role:
"	Extensively worked on Informatica Designer, Workflow Manager, Workflow =
Monitor
"	Extracted data stored in Oracle 8i and Flat files and loaded data into =
Oracle Data warehouse
"	Worked with Source Analyzer, Data Warehouse Designer, Workflow monitor, =
Mapping Designer, Mapplets, and Transformation Developer in Informatica =
designer
"	Developed several complex Mappings, Mapplets and Reusable =
Transformations to facilitate daily weekly and monthly loading of Data
"	Extensively used transformations like Aggregator, Expression, Sorter, =
Sequence Generator, Joiner, Filter, Router, Rank, Look up and Update =
Strategy=20
              transformations to model various standardized business =
processes
"	Used Informatica features to implement Type I, II, and III changes in =
slowly changing dimension tables
"	Created Data Breakpoints and Error Breakpoints for debugging the =
mappings using Debugger
"	Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise =
and Email Task, scheduled Task and Workflow based on Client requirement
"	Worked with tables, indexes, constraints, views and synonyms
"	Created functions, procedures and triggers in PL/SQL
"	Participated in reconciling data drawn from multiple systems across the =
company like Oracle 9i, flat files into Oracle data warehouse
"	Created and maintained various project related documents like high level =
design documents etc=2E
"	Created, executed and documented associated test cases
"	Reviewed the deliverables of peer group
Environment: Informatica Power Center 7.1(Informatica Designer, Workflow =
Manager, Workflow Monitor), Oracle 9i, Flat files, ODBC, Windows NT, UNIX, =
Toad 7.5

APS, Phoenix, AZ						    			            08/04-09/05  =20
Informatica Developer
Description:
APS is a utility company that generates and distributes electricity in =
Phoenix and it's surrounding area. It employs Informatica to maintain and =
process data for their Customer Information System (CIS). Within CIS =
application, worked in billing module.  Informatica was use to generate =
and store billing information for its customers. Involved in creating =
reports that were analyzed to determine trends in electricity consumption =
of personal and business customers
Role:
"	Imported various Sources (tables and flat files) and Targets, created =
transformations using Informatica Power Center 7.1 Designer (Extensively =
used - Source=20
              Analyzer, Warehouse designer, Mapping designer, Mapplet =
Designer, and Workflow Manager
"	Designed and developed Informatica mappings and sessions based on user =
requirements and business rules
"	Used transformations like Lookups, Aggregator, Update, Router and =
Expression
"	Developed and scheduled Workflows using task developer and monitored the =
results in Workflow monitor
"	Involved in the testing and debugging of the mappings
"	Creating test plans and executing test cases
Environment: Informatica Power Center 7.1(Informatica Designer, Workflow =
Manager, Workflow Monitor, SQL, PL/SQL, Oracle 9i, Flat Files, UNIX, =
Windows NT

T-Online International AG, Darmstadt, Germany				                    12/03 =
- 07/04
Oracle Developer
Order Management System
Role:
"	Single point of contact between the project team onsite and offshore
"	Understand the new business requirements and participate in the project =
meetings
"	Active participation in designing and reviewing the Functional and =
Technical Specifications and test plan and cases
"	Involved in business analysis and technical design sessions with =
business and technical staff to develop requirements document, and ETL =
specifications=2E
"	Designed and developed the ETL Mappings for the source systems data =
extractions, data transformations, data staging, movement and aggregation=2E
"	Worked with OWB - Used Source designer to import the source and target =
database schemas and to map the sources to the target=2E
"	Developed standard and re-usable mappings and mapplets using various =
transformations like expression, aggregator, joiner, source qualifier, =
lookup, and filter.=20
"	Scheduled and ran Extraction and Load processes.=20
"	Create functional and technical design documents=2E
"	Created the necessary stored procedures, packages for the project
"	Wrote necessary PL/SQL triggers and procedures for successful running of =
the programs
"	Fine tuning the SQL Queries to improve the speed of program execution
"	Testing of modified and newly written programs and Delivery of the =
completed programs to the client
"	Coordinated with users to ensure that the User Acceptance Testing is =
done successfully
Environment: Oracle 9.x SQL, PL/SQL, OWB, Windows NT, TOAD, UNIX, Shell =
Scripts, ERWIN, MS-Project, MS-Visio

Sakhatech Information Systems, India			    			      06/01 - 10/03
Oracle/Informatica Developer
Description:
Sakhatech is an IT service provider and its core business is in creating =
and maintaining software packages for small businesses across India. =
Worked as a software developer to develop, customize and maintain these =
software applications and to develop and maintain websites of various =
clients=2E
Role:
"	Responsible for system analysis, design, coding, testing, review and =
documentation
"	Responsible for developing PL/SQL procedures, packages, triggers and =
other database objects
"	Responsible for creating VB forms with oracle as backend
"	Maintain website of various clients
Environment: Oracle 8i, Informatica, MS Access, PL/SQL, SQL*Plus, VB 6, =
Windows NT, UNIX, C, HTML, SQL

National Informatics Center (NIC), India						     06/00 - 05/01
Oracle Developer
Description:
National Informatics Centre (NIC) provides network backbone and =
e-Governance support to central government, state governments, and other =
government bodies. It offers a wide range of IT services. Worked as a =
developer to create Billing System "E-Suvidha"
Role:
"	Responsible for coding, testing, review and documentation
"	Writing PL/SQL packages to achieve numerous tasks, writing shell scripts =
for batch processing
"	Writing DDL scripts to create tables, indexes, sequences and calculating =
the storage parameters both in development and production databases=2E
"	Documenting the whole process flow, PL/SQL packages, log files, =
locations and descriptions, log tables and possible error messages, =
process codes and=20
              descriptions=2E
"	Involved in developing front end screens, client side PL/SQL and SQL =
queries=2E
"	Involved in developing Oracle Forms and Oracle Reports
"	Created VB Forms with Oracle Backend to achieve the required business =
functionality
Environment: Oracle 8i, PL/SQL, SQL*Plus, Windows NT, MS Visual Basic 6.0, =
SQL