Data Manager
Resume:
Suma Pavuluri
************@*******.***
PROFESSIONAL SUMMARY
. Over 8 years of IT experience that includes Data warehouse Design,
Development & Implementation, Dimensional Modeling, Client Server
Methodologies and Production Support.
. Over 4 years of strong experience in ETL methodologies like Data
Extraction, Transformation, and Loading using IBM Infosphere
Datastage,Qualitiy Stage,Information Analyzer, Informatica PowerCenter,PowerExchange.
. Excellent experience in multiple phases of SDLC from Requirement
Gathering, Analysis, Data Conversion, Data Extraction, Data
Transformation and Data Loading.
. Over 4 years of experience using DataStage parallel extender (DS-PX).
. Extensive experience in RDMS concepts using Oracle, Netezza, MSSQL
Server.
. Extensive experience in extracting data from various sources like
Oracle, Netezza, MSSQL Server, MS Access, MYSQL, Sequential files and
Complex Flat files.
. Experienced in writing System and Technical specifications.
. Experience in writing UNIX Shell Scripts using Korn and Bash
Scripting.
. Strong Experience in Analyzing, Troubleshooting and Documenting
issues.
. Strong inter-personal skills and ability to work effectively in cross-
functional environments to manage multiple tasks and assignments
concurrently.
. Good Team player and fast learner with strong analytical and
communication skills.
TECHNICAL EXPERIence
OPERATING SYSTEMS Languages BI
AIX 5.1, 5.2, 5.3 VBScript Business Objects 6.0
HP-UX C++ Cognos 6.5/7.0/7.5
Linux XML Microstrategy
Microsoft NT, XP, BASIC
2000, SQL GUI
JSP Visual Basic 6.0
Database ASP Dreamweaver
MSSQL Server AWK Developer 2000
2000/2005 MS Office
ORACLE ETL Tools
MS Access Ascential Datastage Data Modeling
Netezza 8.x/7.x/6.x/5.x Erwin
DT Studio (Embarcadero)
ERP Oracle Development Tools
Peoplesoft Scheduler Tools
Unicenter Autosys Job SQL Navigator
Management Toad
PL/SQL Developer
SQL Tools
EDUCATION
MS IN INFORMATION SYSTEMS
Eastern Michigan University, Ypsilanti, MI, U.S.A.
Professional EXPERIENCE
Employer: SuperMedia LLC,Dallas/Fortworth, TX
May 2005 - Current
Senior Datastage Developer:
SuperMedia is one of the nation's largest providers of yellow and white
pages directories. The company provides sales, publishing and other
related services for more than 1,200 distinct directory titles in 35
states with an approximate distribution of 130 million copies. Idearc
Inc. delivers a multi-dimensional platform of products that help
businesses attract the customers they want apart from helping consumers
in finding products they want.
Responsibilities:
. Designed ETL jobs to extract data from heterogeneous source systems
and load into Data marts. Used Staging area to cleanse and transform
the data.
. Worked with the business users in analyzing the requirements,
understanding functionality changes, designing functional
specifications and document accordingly.
. Developed Routines and Shared Containers to encompass common
functionality for use in multiple jobs across the project.
. Implemented validation techniques in transformer stages to process
incoming data from external sources. Validations were based on the
business requirements.
. Ensure data consistency and accuracy to facilitate reporting
efficiency.
. Converted Volume intensive and time sensitive batch jobs from Server
to Parallel Extender (PX) Jobs. Multi-Node configurations were used to
run these Jobs.
. Test and Validate ETL's in Datastage 8.0.1(IBM Information Server)
Environment to ensure code compatibility.
. Used Job Parameter sets in Datastage 8.0.1 to enable users to share
job parameters and their values across multiple jobs. Also, used
Connection object sets to access Table metadata information.
. Used the Resource Estimation functionality in Datastage 8.0 to predict
hardware resources needed to meet the processing time requirements.
Built Static and Dynamic Models to estimate resources based on varying
volumes of data.
. Used Stored Procedure stage in Datastage 8.0 to execute the stored
procedures in SQL Server.
. Used IBM Information Server web console to pull operational metadata
reports for critical jobs.
. Designed separate set of tables and defined rules, types of anomalies
and exception handlers that were used to validate the incoming data.
Classified various types of anomalies occurring in data that have to
be eliminated, and defined a set of quality criteria to cleanse the
data. Data anomalies were classified into syntactical (characteristics
concerning the format and values used for representation of the
entities), semantic (characteristics concerning Integrity constraint
violations, duplicates), and coverage (Missing values, null values in
non null able fields).
. Different cleansing methods such as Parsing, duplication elimination,
Referential integrity enforcement, data transformation were applied to
ETL Jobs to map the given format. The lookup tables were defined with
standardized data values to simplify the downstream data-handling
approach.
. Monitored and Maintained nightly jobs using Autosys scheduler. Support
and Troubleshoot nightly processes upon failure.
. Wrote UNIX shell scripts to call Jobs from Autosys and pass Variables
at runtime.
. Efficient use of Hash files and Datasets to improve lookup and
performance throughput.
. Used techniques such as indexing, partitioning, hints and execution
plan to optimize query performance in the jobs designs.
. Used several PX stages such as Change Capture, Change Apply, Look up,
Modify, Filter and Peek in building parallel jobs.
. SVN (Subversion) is used for version control of the Scripts developed.
Version control feature of DataStage is also used to maintain versions
of the DataStage jobs.
. Design Jobs using Embarcadero's DT studio to perform Extract,
Transform & Load from different sources.
. Test Track Pro is used on a day to day basis to effectively resolve
issues related to data and reports.
. Working on the conversion project from Oracle to Netezza Database.
Actively participated in the POC of the NZ Database.
. Performed POC on Informatica PowerCenter and PowerExchange.
. Used XML Pack of Datastage to Publish XML Documents from Tabular data
and to Parse XML document into tabular data.
. Used Web Services pack of DataStage to enable users to request reports
by invoking the Webservices designed in Datastage.
Environment: Data Stage 8.x/7.x, IBM AIX 5.x, Oracle 10g,Netezza Twinfin,
Toad, PL/SQL developer, SQL Navigator, Unix Shell Scripting, Autosys Job
Scheduling.
Employer: Clear Thought Solutions
Client: The Regence Group Blue Cross Blue Shield, Portland, OR
Dec 2004 -May 2005
The Regence Group is the Pacific Northwest's largest affiliation of
health care plans, including Regence BlueCross BlueShield of Oregon,
Regence BlueShield, Regence BlueShield of Idaho and Regence BlueCross
BlueShield of Utah. Collectively, the four Plans serve more than 3
million people in four states. The Scope of the "Hospital Reimbursement
Project" at Regence is to develop a common repository for hospital data
to support hospital contracting across all four Plans or the states ID,
OR, UT, WA. To develop a hospital claims repository, a hospital data-
mart, containing at least 3 years of claims experience data for all four
Plans; utilizing source data from REWARDS (The Regence Warehouse
Reporting and Decision Support); Oracle database, SQL, SAS, and Excel.
This project will help forecast hospital trends and stave off unplanned
increases in hospital reimbursements. Contracting staff in all four
plans will be in a strong competitive position during hospital
negotiations as they are armed with accurate, timely and relevant
hospital reimbursement data. This will also help management to make
relevant comparisons leading to well-informed decisions.
Responsibilities:
. Designed ETL jobs for extracting data from heterogeneous source
systems, transform and load into the Data Marts.
. Imported ODBC and Plug-in Meta data Definitions into the Project
through Datastage Manager.
. Migrated Jobs between DEV and UTS Environments
. Developed Server jobs using stages like OCI, Link Partition,
Aggregator, Transformer, Link Collector, and Hashed Files, etc.
. Pre-loaded Hashed Files into memory to enable faster lookups.
. Creation of re-usable components using shared containers for local and
global use inside the project.
. Wrote Routines to handle data validations as per the business rules.
. Troubleshooted problem jobs using the Datastage Debugger.
. Tuning DataStage transformations and jobs to enhance their
performance.
. Wrote PL/SQL and stored procedures for extracting as well as loading
data.
. Created job sequences for server jobs to enable a single trigger point
for a particular functionality.
. Used Datastage Scheduler as well as external scheduler to control the
Job flow stream.
. Used SDK Transforms, Data Elements and other built in capabilities
delivered by the tool in building jobs.
. Performance tuning of the SQL queries using the Explain Plan tool.
. Designed and developed reports for the data in the Datawearhouse using
Business Objects.
. Created Universe in the Business objects for easy access to data.
Environment: DataStage 7.5 (Designer, Director, Manager, Debugger,
DataStage BASIC language Expressions), Business Objects 6.0, Windows NT
4.0,IBM AIX 5, Oracle 9i, IBM IMS, OS/390, SQL SERVER 2000,TSQL,
Sequential Files, MS Access, Flat Files, SQL Navigator.
Employer: Eastern Michigan University
Oct 2001 - Nov 2004
Data Stage Developer
SingTel offers telecom, voice and data services such as International Toll-
Free Service (ITFS), International Private Leased Circuit, Frame Relay,
Asynchronous Transfer Mode (ATM), Internet Protocol Virtual Private Network
(IP-VPN), Internet access and Managed Hosting Services which connect US-
based corporate customers to Asia and beyond. The objective of the project
was to design a data warehouse to enhance the decision support system. This
warehouse is projected to assist Marketing department to categorize their
customers based on various services, geographical Area.
Responsibilities:
. Analysis and Design of ETL processes.
. Identified/documented data sources and transformation rules required
to populate and maintain data warehouse content
. Created Data stage Server jobs to load data from Sequential files,
Flat Files and MS Access.
. Used Data Stage Manager for importing metadata from repository, new
job categories and creating new data elements.
. Using the DataStage Designer to design and develop jobs for
extracting, cleansing, transforming, integrating, and loading data
into different Data Marts.
. Prepare Data Volume estimates.
. Define the data definitions, and create the target tables in the
database.
. Writing routines to schedule batch jobs to obtain data overnight from
various locations.
. Map the source and target databases by studying the specifications and
analyzing the required transforms.
. Troubleshooting jobs using the debugging tool
. Analyzing the performance of the jobs and project and enhance the
performance using the standard techniques.
. Standardize the Nomenclature used to define the same data by users
from different business units.
. Creating job sequences and schedules for automation.
. Used the DataStage Director and its run-time engine to schedule
running the solution, testing and debugging its components, and
monitoring the resulting executable versions (on an ad hoc or
scheduled basis)
. Used Data Stage to transform the data to multiple stages, and prepared
documentation.
. Provided data modeling support for numerous strategic application
development projects
. Analyzed business functionalities and building the fundamental blocks
. Created ETL execution scripts for automating jobs
. Worked on writing routines to read parameters from hash file at
runtime.
. The mappings were Unit tested to check for the expected results.
. Documented the job design mappings to facilitate maintainability.
Environment: Data Stage 6.0/5.1 Designer, Director, Manager, Windows NT
4.0, UNIX, Oracle 8i, PL/SQL, DOS and UNIX, Sequential Files, MS Access,
SQL Navigator.
Employer :Saara Systems Pvt. Ltd
Jun 2000 - Aug 2001
ETL Developer/ Database Developer
Telco was formed in 1945, originally to manufacture steam locomotives.
The main objective of the project was to provide a coordinated central
data repository for client data activity. The data warehouse will bring
together the multiple sources of data in a form that permits cross-
function analysis. Management reports, Ad hoc reports generated from this
data mart to provide more flexible analysis
Responsibilities:
. Wrote Stored Procedures according to specifications and control files
for input to SQL*Loader utilities for loading data from external files
into the Oracle database.
. Used the ETL Data stage Designer to develop processes for extracting,
cleansing, transforms, integrating and loading data into data
warehouse database.
. Debugging of the Data Stage jobs using Data Stage Debugger.
. Developed stored procedures, functions, triggers and packages in
PL/SQL.
. Utilized Star-Schema modeling in building new data marts for the
warehouse.
. Creation of new database to monitor the growth and performance of
different instances.
. Wrote shell scripts and updated the log for the back ups.
. Moving of the databases across various servers.
. Used Oracle interface manager to executing DBA related activities.
. Managing users including creation of users, creating and assigning
roles, monitoring activities, scheduling.
. Environment: Oracle 7i/8i, Oracle Enterprise manager, Windows NT 4.0.
DataStage 5.1
Contact this candidate