Data Developer
Resume:
Resume of
Sangeetha
**********@*****.***
**** (PHONE)
PROFESSIONAL SUMMARY
Having 8+ years of experience in software Industry which includes nearly 7
+ yrs of experience in data warehousing/reports generation using
Informatica Power Center, Business Objects,Cognos
. Strong in Data warehousing tools such as Informatica PowerMart &
PowerCenter on
ETL side and Cognos as Business Intelligence.
. Extensive Experience in Informatica for data Extraction Transformation
and Loading
. Experience in generating reports using BUSINESS OJECTS
. Extensive experience in Oracle Database - Design, Writing Stored
Procedures, Functions,Triggers and Queries
. Significant Experince in Data Modeling using Erwin.
. Proficient Programming in Visual Basic and ASP
. Experience in all phases of project life cycle including Performance
Tuning and Maintenance.
. Strong interpersonal skills and ability to work in a team environment
. Excellent team member with problem-solving and trouble-shooting
capabilities.
TECHNICAL skills
ETL : INFORMATICA POWER CENTER 5.0/5.1/6.1/7.1,
INFORMATICA POWERMART 4.5,
Data stage 7.1,Informatica Power Exchange
Databases : Oracle 9i/8i/7.x, Sybase 11.0, MS Access,MS SQL
server,DB2.
Reporting Tools : Cognos BI: Cognos Impromptu 5.2/6.0,7.x, Cognos
Transformer &
PowerPlay, Impromptu Web Reports (IWR),
Cognos Query, Cognos
Visualizer, Cognos Scheduler, Cognos
Architect, CognosScript Editor,
Cognos Upfront, Cognos Power Play
Enterprise Server.
ReportNet: Report Studio, Query Studio,
Framework Manager.
Seagate Crystal Reports 6.x/7.x, Business
Objects.6.1,Micro strategy
Data Modeling : ER/Studio 3.5/4.0, Erwin 4.1
Languages : C, C++,PL/SQL,Java,VBScript,Java Script, HTML, XML,
XSL,XSLT.
Client /Server : Visual Basic, Active Server Pages, Developer 2000
OS: Windows NT /95/98/2000/XP, Unix, .
EDUCATION
MASTERS IN COMPUTER APPLICATIONS (MCA) OSMANIA UNIVERSITY, INDIA
PROFESSIONAL EXPERIENCE
CLIENT:MEDTRONIC
OCT'06-TILL DATE
Sr ETL Developer
EFAS
EFAS was developed for product device tracking, analysis and reporting
system. This system is used to support notification, confirmation and
retrieval of products usually subject to a Field Action. Data form EFAS is
utilized by other applications. PMR (Patient Management Reporting) imports
the customer Facing Text while CRTS (Customer Response Team System) and
EPCR (Enterprise Product Comment Reporting) use the Product and Contact
data.
. Participating in the development and review of the architecture and
high level design of the
major projects
. Analyzed business requirements,performed source system analysis
prepared technical design
Document and source to target data mapping document.
. Developed mappings and mapplets extensively using Informatica Designer
tools - Source Analyzer,
warehouse designer, Mapping designer, Mapplet Designer,
Transformation Developer
. Worked extensively on different types of transformations like source
qualifier,
expression, filter, aggregator, router, lookup, stored procedure,
sequence generator
and joiner.
. Extracted data from ODS layer, transformed data as per the business
requirements and
loaded it into Oracle database tables/ Fixed width flat files
. Developed full load interfaces for one-time initial load and
incremental load interfaces
using oracle change data capture methodology for ongoing load.
. Used mapping parameters for the re usability of Informatica programs.
. Developed shell scripts to batch process Informatica workflows and ftp
the flat files and
compress the archive files to better use of file system space and
splitting up the flat files into
multiple files. Also developed the shell scripts to call the sqls
to drop and build indexes.
. Involved in Optimizing the Performance by eliminating Target, Source,
Mapping, and Session bottlenecks. Used partitioning techniques to
enhance the existing mapping performance.
. Involved in analyzing the data issues and fixing the problems in
production support
. Scheduled Informatica batch jobs using Tivoli Maestro scheduling tool
to run based
completion of upstream dependencies
. Developed migration plan for production move and migrated code from
test to production
. Involved in Co ordination with Off shore team for production support.
MODEL-N
MODEL-N is a leading 3rd party software package & proven tool for managing
pricing & quoting, contract development & management, etc. This is the
Integration Design for the interfaces between the Model N Application and
the Medtronic Atlas business management system at near real time.
. Involved in analyzing the business requirements for the interface
development from Staging Data Store(SDS) layer using Views to MODEL-N
Application
. Extracted data from SDS layer, transformed data as per the business
requirements and loaded it into XML files
. Worked extensively on different types of transformations like source
qualifier, expression, filter, aggregator, router, lookup, stored
procedure, sequence generator, xml transformations and JMS
. Developed full load interfaces for one-time initial load and
incremental load interfaces using oracle change data capture
methodology for ongoing load
. Performed sql tuning and Informatica mapping tuning to meet the
operational window
. Developed shell scripts to batch process Informatica workflows using
pmcmd and sftp the csv flat files
. Developed shell scripts to batch process Informatica workflows to
create xml files and put xml files into a JMS queue
. Developed shell scripts to maintain archive of both records in database
tables and flat files for a 4 day time period
. Scheduled Informatica batch jobs using Tivoli Maestro scheduling tool
both event-based and time-based to run every 15 minutes during the
business hours.
. Developed migration plan for production move and migrated code from
test to production
1
2 Getpaid
GetPaid is a robust 3rd party software package & proven tool for managing
collection activities. The purpose of this interface is a nightly process
where SAP sends Customer Master Data, Open & Closed AR as well as all new
Billing documents to GetPaid.
Responsibilities
. Involved in analyzing the business requirements for the interface
development from Operational Data Store(ODS) layer to Getpaid
Application
. Extracted data from ODS layer, transformed data as per the business
requirements and loaded it into oracle database tables to develop
fixed-width flat files and maintain archive for a period of 15 days.
. Extensively used Transformations like Router, Lookup (connected &
unconnected), Update Strategy, Source Qualifier, Filter, Stored
Procedure, Joiner, Union, Expression, Aggregator and Sequence
generator.
. Developed full load interfaces for one-time initial load and
incremental load interfaces using oracle change data capture
methodology for ongoing load
. Developed shell scripts to batch process Informatica workflows using
pmcmd and ftp the fixed width flat files to getpaid servers.
. Developed PL/SQL procedures, table and Index creation scripts
. Developed shell scripts to maintain archive of both records in
database tables and flat files for a period of 15 days and compress
the archive files to reduce the space..
. Scheduled Informatica batch jobs using Tivoli Maestro scheduling tool
based on upstream dependencies
. Developed migration plan for production move and migrated code from
test to production.
DRS
DRS (Device Registration System) was developed to track Medtronic's
implantable &
trackable devices.
. Involved in analyzing the business requirements for the interface
development from Operational Data Store(ODS) layer to DRS Application
. Worked extensively on different types of transformations like source
qualifier, expression, filter, aggregator, router, lookup, stored
procedure, sequence generator and joiner.
. Extracted data from ODS layer, transformed data as per the business
requirements and loaded it into oracle database tables or flat files &
AS/400 tables using Oracle DRDA Gateway
. Developed full load interfaces for one-time initial load and incremental
load interfaces using oracle change data capture methodology for ongoing
load
. Developed shell scripts to batch process Informatica workflows using
pmcmd,ftp the flat files, purge archive extract files and delete records
from oracle tables
. Developed shell scripts to load data from Oracle tables to AS/400 tables
using ORACLE DRDA gateway & FTP into library
. Scheduled Informatica batch jobs using Tivoli Maestro scheduling tool to
run every 1 hour during the business hours and event based after
completion of upstream SAP dependencies.
. Developed migration plan for production move and migrated code from test
to production.
.
Environment: Informatica Power Center 7.1.3,Informatica Power Center 8.6,
PL/SQL,Oracle10g, XML,UNIX,SQL Server, Windows XP, Clear Quest, Toad, IBM
Maestro Tivoli(Scheduler),JMS.
Client:Carlson Companies
Feb '06 - Sep'06
ETL Developer
EXL Insight
Carlson Companies is a global leader in the marketing,travel and
hospitality industries. It Ranked among the largest privately held
corporations in the United States . In EXL project Insight there are
seven general ledger processes are generating different GL interface files
which are getting transferred to Oracle Finance
Responsibilities:
. Involved in extracting the data from diverse data sources (Oracle
Tables,Excel Sheets and Flat Files).
. Used Informatica Power Center Designer to create complex mappings
using different transformations
. Tuning SQL queries for speedy extraction of data using various tools
like SQL Navigator, TOAD.
. Involved in importing repository objects to XML file and exporting the
objects from the XML file
. Creating sessions, batches and unit testing of the mapping/sessions
and batches.
. Used Pre and Post session emails to know the session failures and
success and scheduled jobs for loads on daily basis .
. Involved in performance tuning to improve the session performance
. Prepared the Unit test and system test documents for the developed
mappings
. Involved in writing the unix shell scripts to archive the files and to
transfer the files from one server to other server
. Involved in migrating repository objects from DEV Environment to TEST
and t hen from TEST to PROD repositories
. Handled various Production issues in the Production support period.
Environment: Informatica Power Center 7.1.3 PL/SQL,Oracle10g,Oracle
Financials, MS Excel, UNIX,Windows XP, Clear Quest,SQL Navigator,Toad,
Ctrl M(Scheduler).
Client: Metris Companies(HSBC),MN
Mar '05- Jan '06
ETL developer
Collection_Mis
Online Credit Report System
Metris Companies Inc. used to offer credit cards, credit protection and
insurance products to consumers nationwide. It was the 11th-largest
bankcard issuer and the sixth largest MasterCard issuer in the U.S. and was
acquired by the HSBC Finance Corporation in December 2005. The project
Online Credit Reporting (OLCR) was done as a solution that will provide
reporting showing for each online credit card application the end state
(approved, declined) as well as activity (when activated, credit line,
first transaction, etc). This data is critical to determine partner
reporting, compensation and performance.
Responsibilities:
. Involved in extracting the data from diverse data sources using
Informatics power center and power exchange (Main Frame Sources).
. Used Informatica Power Center Designer to create complex mappings
using different transformations
. Tuning SQL queries for speedy extraction of data.
. Involved in importing repository objects to XML file and exporting
the objects from the XML file
. Creating sessions, batches and unit testing of the mapping/sessions
and batches.
. Used Pre and Post session emails to know the session failures and
success and scheduled jobs for loads on daily basis.
. Involved in performance tuning to improve the session performance
. Prepared the Unit test and system test documents for the developed
mappings
. Involved in writing the unix shell scripts
. Involved in migrating repository objects from DEV Environment to
TEST and t hen from TEST to PROD repositories
. Handled various Production issues in the Production support period.
Environment: Informatica Power Center 7.1.3, Informatica Power Exchange,
PL/SQL,Oracle10g,Oracle Financials, MS Excel, XML,UNIX,Windows XP.
Client: Whirlpool, Benton Harbor, MI
Jan '04 -Feb'05
Informatica Developer
Whirlpool is the home appliances company, the client contains huge database
in DB2 (UDB) about customer information and product information and sales.
In this project the data is pulled from the legacy system and we developed
a data warehouse in oracle using informatica tool (ETL). Using Erwin 4.1
does the data modeling.
Responsibilities:
. Invloved in installing and configuring INFORMATICA
. Using Repository manager in power center created repository about
metadata
. Implemented proper Security of Repository by creating user groups,
users, privileges and short cut folders.
. Prepared software requirement specifications, business rules
interacting with business units and designed Star schema, logical and
physical database design for Domains
. Source data analysis, analyzing and Designing mappings for data
extraction
. Involved in importing stored procedures to compare data from source
file with Warehouse records if the data present in warehouse the
records are rejected.
. Tuning SQL queries for speedy extraction of data.
. Involved in writing the unix shell scripts
. Used Informatica Power Center Designer to create complex mappings
using different transformations to move data to multiple databases
. Creating sessions, batches and unit testing of the mapping/sessions
and batches.
. Involved in Importing and Exporting XML files using Informatica
Power Center Designer
. Involved in sending pre and post session Emails in case of session
failure and completion.
. Import XML data into Repository using Informatica Powercenter designer
Environment:Oracle9i, Erwin 4.1, Informatica - PowerCenter 7.1, XML,Unix,PL/SQL, Windows XP, Unix Shell Scripts
Client: ComEd, Chicago, IL
Apr '03 - Dec' 03
Role: Informatica Developer
Common wealth Edison is a nations largest electric utilities with a
customer base of five million people.. The project is based for the
financial accounting and corp taxes. Down sizing existing PortNet business
application on Mainframe to Oracle Data warehouse using informatica tool.
Using Erwin does the data modeling. Create the Universe Using business
objects 5.1.x Designer. Generated report templates using reporter in
business objects 5.1.2.
Responsibilities:
. Prepared software requirement specifications, business rules
interacting with business units and designed Star schema, logical and
physical database design for Domains.
. Created Transformations in informatica while converting data from
source database to Oracle Data Warehouse.
. Involved in importing stored procedures to load data into Warehouse
with business rules.
. Used Informatica Power Center Designer to create complex mappings
using different transformations to move data to multiple databases
. Creating sessions, batches and unit testing of the mapping/sessions
and batches.
. Involved in Importing and Exporting XML files using Informatica
Power Center Designer
. Involved in sending pre and post session Emails in case of session
failure and completion.
. Import XML data into Repository using Informatica Powercenter designer
. Installed and configured Business Objects designer, Supervisor with
secured user groups, users, privileges, universe and
importing/exporting
. Designed Class, Dimension, Detail, Measure Objects and organized these
objects in Universe designer with business logic.
. Discover Repository database was created to support new users with
select, insert and update permissions.
. Created reports in cross tab, master detail format and transformed
them in 2-D, 3-D Column, Line, Area, and Pie charts for graphical
analysis.
Environment: Oracle 8i, Erwin 4.1, Informatica-PowerCenter 6.1, Sql
Server, Business Objects 5.1, Windows NT
Client: Northern Trust Bank, Schaumburg, Chicago
Jan '02 - Mar '03
Role: Informatica/Business Objects Developer
the data will be organized according to requirements of the organization
such as by customer, transactions and accounts. The Data Warehouse will
be structured for rapid online queries, summaries and will contain both
summary and detail. The Main Process that is performed on then is
-Extraction, Transformation and Loading. The process on the warehouse
system periodically executes and loads the staging data files into
staging tables of the Warehouse system. Another process executes on a
schedule or on demand to check, transform, and load the staging data
records into facts tables of the warehouse star schema. The different
modules are designed to support tactical reporting requirements on
current data (Operational Data Source) and strategic reporting
requirements on historical data (Data Warehouse) .
Responsibilities:
. Prepared software requirement specifications, business rules
interacting with business units and designed Star schema, logical and
physical database design for Domains
. Extensively used Functions, Variables and Parameters in
Transformations.
. Import XML data into Repository using Informatica Powercenter designer
. Imported stored procedure to compare data from source file with
Warehouse records if the data present in warehouse the records are
rejected.
. Improved the Informatica Server performance by tuning the Shared
Memory, Buffer Block Size, Index Cache Size, Data Cache Size and
commit Interval.
. Designed multiple Universes and resolved Loops by creating aliases and
contexts.
. Experience in calculation of data in reports using Filters, Sorting,
Ranking and Highlighting data.
. The reports are generated in HTML format and added hyperlinks using
Web Intelligence.
.
Environment: Oracle 8i, SQL Server, MS Office,Erwin3.5, XML,
Informatica powerCenter5.1, XML, Business Objects4.1, Win NT,PL/SQL.
Verizon Inc. (Arlington, VA)
Jul ' 01- Dec '01
Cognos Developer
The main aim of this project is to generate the summary and detailed drill
down reports for the Trading analysis. Identifying key factors like
the total sales revenue in week wise, month wise, quarter wise and year
wise based on the region, sales channel and the sale amount. Analyzed how
many customers satisfied calls, dissatisfied calls when compared to earlier
business weeks.
Responsibilities:
. Extensively involved in data analysis
. Installed Cognos Power Play Transformer for Client, Cognos Power Play
Server
. Comprehensively involved in Data Extraction, Transformation and
Loading (ETL process) from Source to target systems using Power
Center of Informatica.
. Created Impromptu catalogs and reports based on business requirements.
. Involved in creating Multi-dimensional reports using Cognos Power
Play.
. Developing and Customization of Impromptu Reports
. Created Catalog and assigned joins grouped according to the user
requirements.
. Security provided for the catalogs by adding specific user class in
the Catalogs.
. Generated the reports using Cognos Impromptu tool by querying the
database
. Created List Reports, Cross-tab Reports and Drill through Reports.
. Created different types of prompts like catalog pick list, cascading
prompts.
. Created the reports in HTML format for easy navigation.
. Generated Top Ten Reports Rank & Sort Data on Percentage Growth
Environment: Oracle 8i, Cognos Power Play / Transformer, Cognos Impromptu,
Informatica 5.1 Windows
NT
Police Information System
Feb '01- Jun '01
Client: Andhra Pradesh Police
Programmer
Description : This system software is used in the police stations for the
effective utilization of the daily activities starts with Requirement
Documentation i.e. Requirement Module follows with Use cases, Data flow
diagrams, E.R. diagrams, Table design and Screen design development. This
Project includes computerization of police records generation of various
screens like First Information Report (F.I.R), Charge sheet, Investigation,
Arrest or Court surrender, Property Seizure etc. Reports are generated on
various cases like pending cases, number of cases disposed of by police or
by court etc.
Responsibilities:
. Involved in development of Data Flow Diagrams and ER Diagrams
. Involved in back End writing Stored Procedures, functions, Database
Triggers.
. Developed Stored procedure/Triggers in PL/SQL.
. Design and developed reports using Crystal Reports.
. Involved in Testing and Database designing
.
Environment :PL/SQL,Seagate Crystal Report 6.0, Oracle 7.3
International Voucher Administration System (IVAS)
Aug '00 - Jan
'01
Soni Software Pvt. Ltd., India
Programmer
Project Description:
IVAS is a sales system used for the sale of vouchers (such as gift, pre
paid vacation, hotels etc). Voucher sale can be performed through web
interfaces as well as through sales representatives. The system caters for
multi currency vouchers and is based on client/server technology.
These vouchers are used by corporate clients to give away promotions or to
staff as incentives and tax benefits. The voucher system also facilitates
multi currency and credit card transactions. Also a tracking voucher module
is incorporated.
Responsibilities:
. As an active team member contributed in analyzing the client's
requirements, determining the workflow and writing the design specs.
. Designed, developed and deployed the entire application using VB as
the main front-end tool and MS Office as a back end.
. Developed the voucher tracking module, the end users as well as the
corporate staff can know the status of any particular voucher based
upon the voucher ID. Also tested the module with simulated data.
. According to the requirement of the client generate reports using
CRYSTAL REPORT.
. Developed test plans, test cases and test reports.
Environment : Visual Basic 5.0,Segagate Crystal Report 5.0, MS Office.
Contact this candidate