Haemonetics@ Inc Edmonton, Canada, May-05 to continue
Data warehouse Consultant /DBA
Developing & testing the reports using Business Objects, Customize BO reports, Maintain/Update Business Objects users and security profiles. Working with end-users to build reports from concept to implementation, Responding to ad-hoc reporting and data export requests, Output of reports to print, html, graphs, and spreadsheets , Supporting the Defense Blood Standard System (USA) , Siebel & SAP systems .
Maintain the scheduling, distribution, and refresh for reports, views, and OLAP Performance tuning and support of application servers Defining and managing database connectivity to multiple sources and target databases. Creating and running sessions & Batches using Server Manager to load the data into the target Database.
Extensively involved in creating and validating Integration test plans for reports and cubes by writing SQL scripts.
Sakatchwan Learning Regina , Canada Jan-05 – May-05
Data Warehouse consultant / DBA
Working in Application maintenance/support team. Involved in enhance an existing Oracle 11i Application GL & Learning production application systems, including fixing program bugs, preparing/modifying reports, and make changes to exiting programs. Defining and documenting business specifications. Defining technical specifications. Estimating time required for all stakeholders. Designing, coding, testing and producing documentation. Performing all work based on the department standards.
Developing PL/SQL code, day to day DBA activity including the monitor and allocate storage space for data, Creation of the different databases environments for development, Testing & productions & Audit database usage, Tune the database.
Using ETL tools Informatica power center, OALP tool business objects. Data extraction, Data cleansing, Data distribution, Data analysis, Data Processing Extracting data from different sources, Cleansing and transferring data, Distribution of data, Creating staging areas, using knowledge discovery management Data insert, update, delete, Mappings Creation, Debugging, Optimization, Parameters and variables, Reusable transformations, Mapplets, Slowly changing dimensions, Comparison of mappings, Designing the data mart for specific usages.
Defining and managing database connectivity to multiple sources and target databases using Informatica Repository Manager. Creating and running sessions & Batches using Server Manager to load the data into the target Database. Organized sessions in a batch to run the sessions in a batch in sequential order or start them concurrently by the server.
Extensively involved in creating and validating Integration test plans for reports and cubes by writing SQL scripts.
Accenture Inc Canada , Ottawa , Canada Nov-03 – Dec-04
Siebel Configurator’s / System Analyst
Hardware: HP & Sun Server
OS: HP UNIX & SUN Solaris
Oracle Database: Oracle 9i /8i /8.0 & replication server, SQL Server 2000, Siebel 7.5, MSMQ (Microsoft Message Queuing)
· Involved in preparation the Functional & Technical Design , Data mapping , DTS Process
· Worked on Siebel Tools & Created the Business Objects, Business Components, Business Services , Views , Screens, Applets, e-Scripting
· Worked in Customer Order Management and Quote module which include the configuration of order acceptance, order decomposition, order Distribution , order tracking and Order maintenance process
· Installation of Gateway server, Siebel Enterprise server, Siebel database server (Oracle & SQL server) and Siebel Client , Siebel tools
· Establishing the Development Environment , creation of complete development environment
· Actuate 6.0 reports development ,preparation of report functional & Technical design
· Repository Management , Backup ,objects export/import ,source control ,local database setup, prepared local development environments
· Workflow Manager, EAI , Assignment Manager ,Siebel tools , Mobile client, Desktop/Connected Clients and Thin client, EAI configuration
· Worked on data warehouse tools. Involved in defining staging area Metadata, Data Mart , defining & populating the Enterprise Model warehouse , Incremental Data loading
· Involved in extracting data from source & interface systems data warehouse system ( ETL process ) using DTS & SQL Loader
· Wrote UNIX Scripting, PL/SQL, EIM & EAI configuration file & table mapping & run/testing the EIM Process
·Siebel Application & Database Support including the enhancements
·Involved in interface Amdocs/Clarify CRM with Siebel CBP billing software integration which include Billing Accounts, Account creations ,Maintenance of account details ,Changes to account status ,Support Number Portability ,SIM Card Check/Validation, Service Instance, Change asset/phone number, dealer, credit limits, ,Create new orders, Change products/order details
· Creating the Problem reports & resolved the Problem reports in Siebel Application , Databases & Unix & Window
· Deploying & populating staging area objects ,add tables to a staging area warehouse module, created mapping ,binding & reconciliation generate mapping code ,incremental data loading & generated the scripts
· Worked on Informatica power center & Involved in creation of OALP tool business objects, Data extraction, Data cleansing, Data distribution, Data analysis ,Data processing Extracting data from different sources, Cleansing and transferring data, Distribution of data, Creating staging areas, using knowledge discovery management Data insert, update, delete ,Mappings Creation, Debugging, Optimization, Parameters and variables, Reusable transformations, Mapplets, Slowly changing dimensions, Comparison of mappings, Designing the data mart for specific usages.
Sprint Canada Inc , Toronto , Canada June-02 – Oct-03
Siebel Configurator’s / Siebel Administration
Siebel CRM System
·Created the Business Objects, Applets, Views & other objects of a Siebel application Siebel Configuration and Workflow development. Workflow design & monitoring workflow polices, Workflow performance tuning, Work Query te
|