Data Developer
Resume:
RAJANI VENUGOPAL
*******@*******.***
SUMMARY
Over 11+ years of experience in software development life cycle including analysis, design, development,
testing and implementation of software applications.
7+ years of experience as a business analyst responsible for business blueprinting, functional and technical
specifications.
Strong Experience in design and implemen tation of Business Re-engineering projects (BRP).
Expertise in Oracle 10g/9i/8i, ETL /IBM Websphere Data Stage, PL/SQL, UNIX script, VB, VBA and
Vantive.
Experienced in integration of various data sources like Oracle, DB2UDB, SQL Server, Teradata and Flat
files into the target tables.
Strong knowledge in Star-Schema Modeling, Snowflake Schema Modeling, Fact, dimension tables and
Data modeling using Erwin tool.
Demonstrated Project Management skills against competitive deadlines.
Strong experience in using SAP (FS-RI/CD/GL) modules for reporting using Standard SAP reporting tool and
also testing the applications.
Excellent analytical and problem solving skills, with good interpersonal and communication skills.
SOFTWARE SKILLS
Databases : Oracle 10g/9i/8i, DB2, SQL Server 6.x, Informix, MS Access.
ETL/DataStage Tools : IBM Websphere DataStage 8.0.1/7.5.x/7.1/6x, Integrity 6.0, Erwin 7.2
Languages : VB5.0, SQL*Plus3.0, PRO*C, PL/SQL, VBA, Perl5, UNIX Shell Scripting,
Basic, Java, JSP.
Web Technologies : Web Services, XML, HTML, JavaScript
Web Servers : WebMethods, WebLogic, iPlanet Netscape
CRM : Vantive 8.x.
Operating Systems : UNIX (HP/Sun Solaris), Windows NT4.0, Novell NetWare 3.12,
MVS/ESA, TSO/ISPF, CICS.
Middleware : MQ Series 5.
Software Tools : TOAD, Sablime.
PROFESSIONAL EXPERTISE
Jan ’06 – Current
Munich Re-Insurance America
Team Lead / Business Analyst
GLORIA (Global Re-Insurance Application)
Project GLORIA (Global Reinsurance Application) is a conversion of Legacy Systems that have
different data structures and processes to FS-RI (Financial Services – Re Insurance customized module of
SAP ) with ORACLE / DataStage as Intermediate DB / ETL Tool during conversion across Munich Re
Groups. Gloria will replace these legacy systems with a common platform for the Group for contract
administration and processing. The PHASE1 (Basic System) - conversion of the Treaty Business, PHASE2
(Risk Manager) - conversion of the Facultative/Single Risk Business.
Responsibilities:
* As a team lead/SME for Claims conversion, responsible for the conversion of the Claims data for
Phase1 and Phase 2 of the project.
* Responsible for the claims blueprinting process for the Risk Manager Non -Life conversion.
* Liaised with business and functional owner during high-level review sessions to derive and execute
action plans, meeting deadlines and standards for conversion.
* Interfaced with business users to prepare and update business rules and system/functional requirements.
* Worked closely with the Business Group Management users to define the necessary cross-reference
tables, data cleanse the old legacy data to fit the new target FS-RI model .
* Responsible for the detailed legacy data analysis and preparation of technical specifications for the claims
data(data mapping).
* Responsible for identifying the entire scenario test cases to test all the documented transformation and
mapping rules using Test Director.
* Responsible for designing the Conversion Sign-off ( COSO ) reports, reconciliation DBs for the claims
Business Users to compare the legacy data and the converted target data.
* Extensively involved analyzing the data for each load(Monthly) and working with the Business group to
modify or re-define the transformation as well as data fixing rules due to discrepancies in the data.
* Responsible for the design/implementation of the DataStage code for conversion (Data cleansing,Fixing
and transforming the legacy data into the target structures.
* Implemented routines in DataStage, created batches to run the jobs in required order to load the data in to
the target DB.
* Implemented PL/SQL functions/Stored procedures for some complex data processing rules and
generating new accounts based on the legacy transactions.
* Involved in analyzing/debugging the FS-RI data load rejects along with the TBC(Technical Business
Coordination) team in the FS-RI system.
Environment: Oracle 10g/9i on HP, PL/SQL, UNIX Shell, SQL, IBM Websphere Datastage 8.0.1/7.51/7.1,
SQL*Loader, FS-RI ( customized module of SAP for Re-Insurance).
Jun ’05 – Dec’05
J&J Pharmaceuticals, Raritan, NJ
Technical Lead Developer
GALAXIAS
GALAXIAS is a data warehouse/data mart for some of the studies and trails for the J&J
pharmaceutical laborateries. The data is from the clinical trials, genotype data, and pharmacogenomics etc.,
Anonymized Clinical trail data from multiple studies across multiple areas was integrated for explorator y
analysis. The company collects DNA samples across all clinical trials. Consequently the anonymized
sample information (pharmacogenomics data) had to be merged with Clinical trials information.
Responsibilities:
* Responsible for the detailed data analysis, data mapping of the data before loading the data into the data
mart.
* Responsible for the design, modeling and implementation of the data mart(s).
* Input Data was available in a variety of different forms (Oracle, flat files).
* Implemented SQL *Loader Control routines to load the raw data in the database for analyzing.
* Interacted with different stakeholders to discuss the detailed data analysis.
* Implemented PL/SQL Functions/Stored Procedures, SQL scripts for data transformations for the data
loading Jobs.
* Implemented the automation of data loading into the data mart.
* Responsible for setting up the WABAN Explorer environment with all the metadata elements required for
reporting users.
* Responsible for writing and participating in the DIT (Deve lopment Integration Testing).
Environment: Oracle 9i, Sun Solaris, PL/SQL, UNIX Shell, SQL, SQL*Loader, WABAN.
Jan’ 04 – May’ 05
AT&T Labs, Middletown, NJ
Team Lead / Sr. ETL Developer
DBoR Platform
DBoR Platform provides a consistent and easily accessible customer centric view of data across
the AT&T Enterprise to establish and maintain credibility with customers. Create a sin gle logical model of
AT&T back-end systems across the AT&T Enterprise Improve data quality across AT&T systems .The
DBOR architecture has three layers EDB (Enterprise Data Bus ), DBOR cache (DB Cache ), Data Extract
/Data Stage Layer .
Responsibilities:
* As a Team Lead r esponsible for the design/development phase of all the critical DataStage (Extract
Transform and Load) projects.
* Liaised with the Business in defining the business rules, functional and technical specifications for all the
critical interfaces.
* Responsible for the design/implementation of the DataStage code to support the Disaster Recovery. The
DR implementation needed to support all the existing systems that are already running in production with
minimal impact.
* Implemented Multi-Instance DataStage Jobs, complex transformations/calculations.
* Implemented routines in DataStage, created batches to run the jobs in required order to load the data in to
data mart.
* Developed Unix Shell Scripts for pre-processing the Input Files, post-processing Extract/Output files and
for File transfers.
* Implemented PL/SQL functions/Stored procedures for some complex data processing rules.
* Implemented complete automation of data loading process.
* Worked with different data sources like Oracle, Informix and Flat files.
* Performance tuning of bulk load processing.
* Responsible for the DataStage Jobs deployment plan template that is to be used by the team.
* Lead for OAM implementation for all the DataStage system interfaces. Responsible for the
design/implementation of a common DataStage Job, that would be used to log the status of the DataStage
Jobs and also the same job used to collect the Audit Statistics for the DataStage Jobs in a DB table.
* Responsible for DataStage Design /Development Standards document. This document is to be used by all
the teams in DBOR doing ETL/DataStage development.
* Responsible for writing the Integration Test Plans, and participating in the DIT (Development Integration
Testing) and IST (Integration System Testing).
* Primary Tier 4 Support for any Production issues.
* Responsible for setting up the DataStage server for Production before turning it over to the PSO
(Production Support Organization)
Environment: Ascential DataStage 6x/7.1, Oracle 9i, Sun Solaris, PL/SQL, UNIX Shell, SQL, Integrity 6.0,
SQL*Loader, BO (Business Objects), XML, Java, JSP.
Feb’ 03 – Dec’04
AT&T Labs, Middletown, NJ
Team Lead/ Sr. Developer
BP3-Billing Pre Processor
This is a system used internally with interactions to AT&T provisioning/procurements systems
for pre processing the billing that needs to be done to the customer. Information comes to this system in
XML format with data containing the network components and its attributes being ordered by customer.
This system analyzes that data and generates Billing ID's (BEID's) depending on various business rules that
are offer specific. Once these BEID's are generated, the information is sent to a Global Billing Platform,
which generates the bills and sends it to customers.
Responsibilities:
* Contribution in defining the architecture of this billing system.
* As a project lead, was in charge of coordinating and overse eing the development efforts of the team
* Responsible for defining the business processes and creating the blueprint document for the BP3 system.
* Liaised with business and functional owner during high-level review sessions to derive and execute
action plans and meeting deadlines.
* Interfaced with business users to prepare and update Business Rules and System/Functional
Requirements.
* Implemented database PL/SQL stored procedures which does the lookup for Billing ID's based on the
input information and does post processing specific to offers such as EVPN, EVPN3+, GMIS.
* Implemented the parser logic, which parses the incoming XML information, formats it appropriately and
inserts it into the Oracle database using JDBC.
* Involved in the design/development of the Billing ID’s extract to be sent to the Billing platforms.
* Wrote Unix Shell scripts to automate the data extraction process including the FTP process to the clients.
* Implemented a mechanism for persistent storage of data in form of files incase the backend server is
down. The mechanism implemented periodically tries to post the information to the backend by picking the
data from the datastore if any.
* Involved in the implementation of web interface to view BEID's generated for a given ord er. This
interface provides the ability to add, delete and change BEID's as needed.
* Integrated into Corporate Web Services platform.
Environment: Oracle 8i,Sun Solaris, SQL, PL/SQL, UNIX Shell, XML, Java, WebMethods Integration Server
May’ 02 – Feb’ 03
AT&T Labs, Middletown, NJ
Business Analyst/ Sr. Developer
Electronic Commerce System (eCo)
This electronic interface to AT&T Provisioning system is used between AT&T and it's clients
/vendors to exchange change requests (Add, Change, Move, Disconnect) of network equipment. Helps in
realizing major cost savings by automation.
Responsibilities:
* Responsible for bringing a new client on board all the way from giving a overview of the system and its
functionalities, key person on developing the Interface agreement and defining the business process and
rules.
* Worked closely with the clients to document the Business Requirement Documents ( BRDs) and System
Requirement Documents for the development team.
* Implemented Stored procedures in Oracle to support the backend data validations.
* Implemented PL/SQL functions in Oracle in order to support the provisioning workflow interface.
* Implementation of provisioning eBond with Vantive as the backend which best suits the business model.
* Design and implementation of a Java/XML based middleware to support the business transactions.
* Was also involved in the development of the Web Interface for the iGEMS Provisioning System.
* Analysis of an industry open standard (CIM) for asynchronous
* Providing tech support to the operation personnel.
Environment: Oracle 8i, Sun Solaris, SQL, PL/SQL, UNIX Shell, Java, WebMethods Integration Server,
XML.
Nov’ 99- Dec’ 01
Telcordia Technologies, Piscataway, NJ
Team Lead /Sr.Developer
Telcordia Technologies Customer Manager (TCM)
The Web based Telcordia Customer Manager is an operational CRM syst em addressing the
integrated front office operation needs for telecommunications and Internet Service providers. It provides
Customer care, Order entry, Service negotiation, Sales/marketing support, Customer Self Service ad other
CRM capabilities such as Billing Inquiries and trouble reporting in a modular fashion. Its open architecture
provides for easy integration with existing systems. This system was initially implemented using the
Vantive 8.2 Sales and Support Module. The web version is being implement ed using Touch Point.
Responsibilities:
* Senior Developer /Team Lead, responsible for the design and development of the modules in TCM.
* Core Member of the Development Coordination Team whose primary responsibility is to review,
recommend, design and manage changes to the platform Software architecture.
* Design of application functionality and data structures, development of user interface functionality,
implementation of workflow rules etc.
* Implemented Stored procedures, triggers in Oracle to suppor t the backend data validations and
processing.
* Implemented client data validations in Vantive using VBA scripts, The Web pages were developed in
HTML.
* The Vantive Version of the application was running on HP UNIX Server.
* When we migrated to Touch point platform the application servers were running on sun solaris server.
Environment: Oracle 8i, Sun Solaris, SQL, PL/SQL, UNIX Shell, C++, Java, Vantive 8.x, VBA, Touchpoint,
HTML, JSP.
Nov’ 98 – Nov’ 99
AT&T Solutions /AT&T Labs, Florham Park, NJ
Senior Developer
Global Enterprise Management System (GEMS) Provisioning
GEMS Platform is used by AT&T Global Customer Support Centers to manage AT&T Solutions
customer's global networks and other assets.
GEMS Provisioning system allows AT&T Solutions Associates to enter a Client Request (CR), and track
that request as a Service Request (SR), through the procurement process to completion. The system focuses
on provisioning (especially MACD requests) and procurement, allowing users to create Purchase Orders
and Work Orders, and track fulfillment of POs and execution of work plans. The system also allows users
to capture Time and Materials (T&M) spent working a Service Request, then automatically route T&M
data to the Billing system. This system was implemented using the Vantive 8.0 Field Service application.
The system which was implemented on MS SQL Server 6.5 is currently migrated on to Oracle
8I(Vantive8.2).
Responsibilities:
* Senior Developer responsible for the design and development of Inventory and Provisioning System.
* Design of application functionality and data structures, development of user interface functionality,
implementation of workflow rules etc.
* Development of client-server applications using Vantive's Field Service Inventory and Provisioning
application, wrote stored procedures, triggers in MS SQL Server, VBA scripts and API's (VB5 for
Performance analysis) provided by Vantive products.
* Responsible for the migration of GEMS Provision ing System from MS SQL Server 6.5 to Oracle 8i.This
involved the migration of Stored Procedures, VBA Scripts, Tables (System and User) and Application
Data.
* Responsible for the performance analysis of the implemented Vantive system.
* Design, Code, Implementation, Deployment and User Training.
Environment: Oracle 8i,Sun Solaris, SQL, PL/SQL, UNIX Shell, Java, Vantive, VBA, MS SQL server
XML.
Apr’98 – Oct’98
MCI International, Pentagon City, Virginia
Developer
Tenx: 10-10-220
* Worked as an Oracle application developer and as a member of the DBA team.
* Designed, coded and tested the New and Recurring programs that give the customer account of
New_call/New_minutes of Recur_cust /Recur_call/ Recur_minutes on Call_date, Process date an d DMA.
The New and recurring Status is available on Daily, Weekly and Monthly basis. This program also takes
into account the NPA NXX Splits. Implemented using Pro *C and Oracle Report Writer .
* Also worked on project databases managing the files, segment s and the sizes of the databases, managing
system resources, controlling user privileges and routine database monitoring including starting up/shutting
down of the databases.
1-800-COLLECT:
* Responsible for the development of various modules to assist in investigating fraudulent use of Credit
Cards.
* Responsible for reporting the 1800-Collect summary. Monthly site summary statistics by domestic and
international flags. This data is downloaded from Main Frame to the Oracle Database Server, which is used
as input to reporting on the web.
* Wrote stored procedures, Triggers, Packages for various modules to retrieve and update data from the
Oracle Database.
* Worked on Backup procedures to do Full Backups and Partial Backups. Also created audit trail views for
critical databases.
* Created Customized Pivot table Reports on MS-Excel
* Responsible for various monthly summaries on terminating NPA, originating NPA and time of the day.
* Responsible for the design and Web development for 1800-Collect Reports.
Environment: Oracle, SQL, PL/SQL, UNIX Shell, COBOL, Pro *C, MSExcel, HTML, JSP, COBOL, JCL
Aug’ 97-Mar’ 98
General Electric, Retailer Financial Services, Stamford, CT.
Developer
Prospector Platform Migration
* Responsible in moving the current Prospector GUI from OS/2 platform to Windows 95 platform and
move the IDMS tables to a VSAM/IAM file structure.
The new GUI was developed using Visual Basic 5.0. MQ Series and CICS were used to communicate
between VB an d VSAM/IAM files.
* Responsible in designing and developing the necessary communication data packets. The new system has
exactly the same functionality as the current Prospector system.
* Developed Batch Statements System Interface (Daily and Monthly mod ules), Promotion Tracking
Interface, Posting System Interface, Embossing Interface and all existing reports. In addition to this the
rules and analyzer are made reliable.
Environment: OS/2, Windows 95, Visual Basic 5.0, MQ Series, CICS, VSAM/ISAM Files, Ba sic
Jul’ 96- Jul’ 97
Prosys, Queensland, Australia
Developer
Medicare DMA System
The project was developed to manage all the Service Providers' data, Patients' data and the Services
provided by Medicare and Payment Details.
* Worked as a member of the DBA team. Responsible for maintaining and managing users. Also worked
on database planning and design using E-R diagrams and Normalization techniques.
* Responsible for Converting ASCII to Oracle table and Oracle table to ASCII format.
* Periodic monthly reports like Medical history of the nominated Patients, Year -to-date payments by
medical practitioners, outstanding checks non -cashed totals were generated.
* Reports on demand like Medical history of the nominated patients, details of services provided by
nominated medical practitioners.
Marina Management System Oct `95 Jul '96
* Designed and Developed an application using Oracle as the database and Visual Basic for front -end to
hold the relational information of the Occupants, Details of th e stands, Total charges and Booking details.
* Involved in Design specifications (Data Flow Diagram, E-R Diagram and Physical Mapping) and
Program specifications of the proposed system.
* Involved in developing Stored Procedures, Triggers, Functions, and Packages for various modules.
* Implemented a Password Protection Program to detect three levels of users.
* Generated Daily reports to get all transactions details, Occupancy details, and Charge details of the
persons, booking status.
Environment: Oracle 7.0, Visual Basic 4.0, Basic
References Available on Request
Contact this candidate