Sales Data
Resume:
Avita Rebello
E-mail: ************@*****.***
Phone: 609-***-****
SUMMARY
Nearly 9 years as Systems Analyst/Programmer with experience in Software Design and
Development for OLTP and Data Warehouse solutions covering full life cycle development
including System analysis, design, development, implementation, maintenance, enhancement,
documentation and user training.
• Around 6 years experience in development of Database server side programming in Oracle
using SQL and PL/SQL for Functions, Stored Procedures, Packages and Triggers to
implement business logic
• Nearly 3 years experience as Data Warehouse Developer using Informatica Power
Center as the ETL tool with Oracle as the backend
• Experience in designing/developing/testing mappings and workflows to implement ETL
logic using Informatica.
• Experience with Informatica Designer, Workflow Manager, Workflow Monitor and
Repository Manager
• Experience with Oracle SQL * Loader to load data from Flat Files to Database Tables
• 2 years Reporting Experience with Cognos Report Studio/Report Net
• Experience in query Optimization/Tuning using Tkprof, Explain Plan and hints
• Knowledge of Dimensional Modeling using Star and Snow Flake Schema
• Experience in Logical and Physical Data Modeling using ERWIN 4.0
• Working knowledge of UNIX Shell Scripting
• Experience in gathering user requirements, defining specifications and Technical and
Functional Documentation
• Experience in writing Test Cases, Unit Testing, Integration Testing and System Testing
• Excellent analytical and troubleshooting skills
TECHNICAL SKILLS
Databases : Oracle 10g / 9i/ 7.x
ETL Tools : Informatica 8.x/ 7.1
Reporting Tools : Cognos 7.x, Crystal Reports 7
Development Tools : SQL, PL/SQL, SQL Loader, SQL Navigator 7.x
GUI : Visual Basic 6, Powerbuilder
Software Engineering Tools : ERwin 4.x, Visio
Version Control Tools : Serena PVCS Version Manager
Others : MS Access
Operating Systems : Windows - XP/2000/, UNIX
1
RECENT TRAINING
August 2009: Completed Informatica PowerCenter 8.6 Level II Developer Course
conducted by Informatica Corp. USA
The course covered : Incremental Aggregation, using mapping variables and Parameter files,
Dynamic Scheduling, Workflow looping, Transaction Control Transformation, Creating queries for
repository objects reporting, Performance Tuning and Partitioning.
PROFESSIONAL EXPERIENCE
Bristol-Myers Squibb, Plainsboro, NJ
Analyst/Senior Oracle PL/SQL Developer and Cognos Report Developer
February 2007 – June 2009
Bristol-Myers Squibb is a global pharmaceutical company that manufactures prescription drugs and
other healthcare products in several therapeutic areas.
Responsibilities:
• Supported Model N’s Contracts Management and Chargebacks system. Wrote
packages, functions, procedures using Oracle PL/SQL to find and fix data discrepancies.
This entailed a thorough understanding of - user requirements, the Model N system and
database schema relationships.
• Wrote SQL for Cognos Reports, ad-hoc end user requests, data extracts for internal audit
purposes and external wholesaler ad-hoc requests.
• Investigation and resolution of Bug ticket incidents and QA tickets which entailed
technical, analytical and problem solving skills.
• Extensive end user interaction to gather business requirements for extracting data for
internal audit purposes and external wholesaler ad-hoc requests.
• Used SQL Loader to upload external wholesaler provided data requests for specific
member hierarchies, sales submissions/invoice numbers.
• Wrote Functional Requirements and Technical Design Documents for Cognos Report
requests; Review and update of existing Functional and Technical Design Documents.
• Wrote SQL queries, designed, developed, tested and implemented Cognos reports using
Report Studio/Report Net.
• Tuned/optimized SQL’s for slow running Cognos reports by re-writing queries to either
use existing indexes, provided hints and utilized Oracle’s Analytics features for enhanced
query performance.
• Provided backup development support and code review for Manufacturing Price
Adjustment (MPA) Interface sub system which involved uploading data into staging
tables, transforming data as per business rules and finally inserting records into the Model
N Production tables.
Environment: Oracle 9i/10g, SQL Loader, Cognos Report Studio/Report Net ver. 7.x, SQL
Navigator 5, Serena PVCS 8.1, Remedy 6.x., Windows XP, UNIX
2
Software Galeria/CDC Global Services, Fairfield, NJ.
Oracle Backend PL/SQL - Data Warehouse Developer
(Jan 2006 – Oct 2006)
Software Galeria were providers of software solutions in cutting edge technology. With
partnerships with Sun Systems, Microsoft, Oracle, SAP and CDC Global they were providers of IT
infrastructure, e-Business, CRM (J.D Edwards & Pivotal) and ERP solutions in the areas of -
Manufacturing, Inventory, Supply Chain, Financials and Performance Management.
In addition to maintaining an in-house Sales System, I was a member of the Data Warehouse team
involved in ETL documentation, development and testing using Informatica PowerCenter 7.1 for
the ETL processes and wrote Oracle PL/SQL code to test data loads. The Warehouse tracked leads
and opportunities generated by the Sales Team – thus providing a basis for Performance Analysis
Responsibilities:
• Studied Source System and performed Code/Data Analysis
• Improved performance of Sales system by modifying code to use bind variables and
Oracle’s Bulk Collect feature
• Optimized existing code by using Explain Plan and hints to force usage of a particular
index
• Interacted with end users to analyze business processes and gather core requirements
for the Data warehouse
• Involved with the team responsible for designing the Warehouse Star Schema data
model using ERwin
• Created tables, indexes and sequences required for the Data Warehouse
• Developed Mappings and Workflows to load data into the warehouse Oracle Tables.
Used Informatica PowerCenter 7.1 to develop Transformations which included –
Expression, Stored Procedure, Filter, Router Lookups - Connected and Unconnected,
Update Strategy to implement Slowly Changing Dimensions
• Testing of Informatica Mappings using Oracle Stored Procedures.
• Source, Target, Transformation documentation of Mappings, Sessions and Workflows
used in the ETL process
Environment: Oracle 9i/10g, PL/SQL, Toad, ERwin, Informatica Power Center 7.1,
Unix, Windows
Fleet/Bank of America Leasing Healthcare Finance, Parsippany, NJ, USA
Systems Analyst - Senior Developer
Nov 1998 – Sept 2005
Project: Lease Management System (LMS)
With an asset base of over 500 million dollars, Fleet Capital Leasing was a leading provider of
leasing solutions to the healthcare industry in the US. The OLTP system - LMS was developed in-
house using Clipper 5.2. It covered all aspects of Leasing - ranging from Proposals, Origination,
Servicing of Lessees, Accounts Receivables and Accounts Payable.
3
In addition to an OLTP system there was a Corporate Data Warehouse which received feeds from
various leasing divisions across the country. It provided a means for consolidated reporting from a
financial perspective as well as a basis for Asset Management, Lessee and Vendor Analytics.
Role and Responsibilities:
• Responsible for maintenance, Design, Development, Testing and Implementation of
enhancements of LMS. Developed the Accounts Receivable sub-system, automated the
upload and application of Lockbox Checks to the Accounts Receivable sub-system.
• Documenting process flows using VISIO
• Team member for an in-house project to convert the Clipper based LMS to a RDBMS
system using Oracle as back-end and Crystal Reports for Reporting. I was a member
of the team responsible for :
- Data mapping and Oracle schema design using ERwin
- Loading legacy application data into Oracle tables using SQL Loader
- Wrote functional documents and program specifications for packages, triggers,
procedures and functions based on the legacy system code.
- Developed reports using Crystal Reports
• Development, Testing and Documentation for the Corporate Data Warehouse. The
responsibilities for the Data Warehouse project involved :
- Team member involved with design of the Star Schema dimensional model
using ErWIN.
- Data mapping and Data extraction from the Source LMS application into
staging tables using PL/SQL for Packages and Stored Procedures. Informatica
was then used to extract, transform and load records into an Oracle Target
Database
- Created and tested Informatica Mappings using transformations like
Expression, Router, Lookups, Filter, Stored Procedures and Update Strategy to
implement Slowly Changing Dimensions – Type 1 and 2 for data loading to an
Oracle Database
- Experience with Performance and Mapping Optimizations in Informatica
- Documentation of the Mappings, Sessions and Workflows
- Wrote UNIX pre-session scripts to sort source flat files and post session scripts
to move source files to archive folder
• Developed and implemented interfaces to provide nightly extracts and feeds to the
corporate mainframe based Centralized Accounting system.
• Designed, Developed, Tested and Implemented a stand-alone proprietary system
“RAPIDLEASE”. This system was a scaled down version of the main Lease
Management System that enabled the Sales Reps in the field to present various leasing
programs offered by Fleet to potential clients. This system was developed using MS
Access as backend, Visual Basic as front end and Crystal Reports was used for
reporting purposes.
• Extensive Interaction with business users in understanding and defining new
requirements
Environment: Oracle 9i, SQL, PL/SQL, Toad, Informatica Power Center 7.1, SQL
4
Loader, Visual Basic 6.0, Crystal Reports 7, Visio, ERwin, Clipper 5.2, Windows, UNIX
Lotus Learning, Bombay, India
Oracle / Powerbuilder Developer
Feb 1997 – Sept 1998
Lotus Learning with 21 offices country wide was the sole Indian distributor of Linguaphone
products and educational books for children ranging from Pre-K to Grade 4.
Project I: Sales Order Processing System
The system tracked product sales in 21 offices country wide. The client had a pyramidal
reporting structure. In addition to tracking product sales, the major component of the system
was the generation of commissions based on various performance criteria which were revised
every fortnight.
Role and Responsibilities:
• Interaction with business users to understand business processes
• Involved in design, development, testing and implementation
• Developed Packages/Triggers/Procedures and Functions for business requirements
using PL/SQL
• Designed tables for historical data that was used for analytics and MIS reporting and
wrote PL/SQL procedures to populate the same.
Project II: Accounts Receivable Module Interface
The Accounts Receivable Module served as the interface between the existing Sales Order and
Financial Accounting Systems. It involved a thorough understanding of both - the Sales Order
and the Financial Accounting System. The successful implementation of this module
eliminated the need for manual re-entry of Sales Order information into the Accounting
system, in the process saving time and achieving a high level of data accuracy.
Role and Responsibilities:
• Designed Table structures to be used in the staging area
• Wrote SQL Plus Packages & Procedures to extract applicable data from the Sales
Order System
• Used SQL Loader to load extracted data into staging tables.
• Wrote PL/SQL Packages, Procedures and Triggers to insert data into audit logs and
tables of the Financial Accounting System.
Environment: Oracle 7.2, PL/SQL, SQL*Plus, Powerbuilder 4/5, SQL Loader, ErWin
5
Contact this candidate