Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
PROFESSIONAL SUMMARY
Download Resume Format
Kayla Kannan
kayla@yahoo.com · 215-237-9876
kayla@yahoo.com · 215-237-9876
PROFESSIONAL SUMMARY
·
19+ years of total IT experience in analysis,
design, development, testing, and production support of business applications
for Operational/Transactional systems and Data Warehousing systems.
·
10+ years of experience using Oracle 11g/10g/9i/8i,
SQL, PL/SQL, SQL*Plus, SQL*Loader, Sun Solaris, HP-UX, , Windows XP/2000/98 and
Windows NT.
·
8+ years of experience in ETL Design,
Development, Testing, and Production rollover with DataStage 8.5/8.1/7.5.2(Designer/Director/Administrator)
involving Star Schema, and Snow Flake schema with Fact, Dimension and Aggregate
tables.
·
Designed Mapping documents, ETL architecture
documents and specifications.
·
Analyzed the Source Data and designed the
source system documentation.
·
Participated in discussions with Project
Manager, Business Analysts and Team Members on any technical and/or Business
Requirement issues.
·
Performed and documented unit test plan and
test case scenarios of developed code.
·
Documented the developed code for promotion
to production environment.
·
Used the Data stage Designer to develop
processes for extracting, cleansing, transforming, integrating, and loading
data into data warehouse database.
·
Experience in Converting the Business Logic
into Technical Specifications.
·
Extensive experience in loading high volume
data, and performance tuning.
·
Hands on experience as ETL Architecture design, ETL process, mapping document.
·
Strong understanding of data warehouse
concepts and best practices including: Dimensional modeling Star schemas and Snow
Flake schema.
·
Clear understanding of relational databases
in a Business Intelligence context.
·
Strong analytical and organizational skills
with ability to work on multiple project/assignments.
·
Ability to troubleshoot,
debug, problem solve at the highest level, under pressure and across multiple
platforms
·
Expertise in UNIX Shell Programming
TECHNICAL
SUMMARY
Databases: Oracle 11g/10g/9i/8i/7.3,
MS SQL Server, DB2, Access
Tools IBM Info Sphere
DataStage and QualityStage 8.5/8.1, Ascential DataStage 7.5.2, Ascential
QualityStage 7.5, SQL Loader, Toad, PL/SQL
Developer, SQL Developer, Microsoft Office, Business Objects 6.5
Languages: SQL, PL/SQL, Korn Shell
Scripts, HTML, COBOL, CICS
Operating
Systems: Windows 2000/NT/XP, UNIX Sun Solaris,
DOS, MVS/XA, IBM 3090
Industries: Pharmaceutical, Financial Services,
Automotives
EDUCATION
AND TRAINING
Masters of Computer Science,
Bharathidasan University, India
Bachelors of Computer Science, Bharathidasan
University, India
Professional
Experience
Novartis & IMS
Health, East Hanover, NJ Jun 2011 – Present Senior ETL/DataStage Developer
The purpose of the US Reporting system is to provide
end-users with actionable information and insights in order to diminish the
volume of data that they have access to. The reporting tool will be developed
for the field force using reports and dashboards with summary information, lists,
graphs, alerts and will include various drill-downs. Solution has been developed on Cognos
10 Business Intelligence software, leveraged DataStage 8.5 for data
processing/ETL and Oracle 11g for database.
Responsibilities:
- Worked with Data
Modeler, Architects and Business Analysts to Understand the
Requirements.
- Developed ETL process for many tables includes Fact,
Dimensional, Lookup and Summary using Dimensional
Modeling.
- Project involves
huge volume of data (Facts in billions and Dimension in Millions) and
total size of the Database is about 22 TB.
- Used Client
components IBM InfoSphere DataStage Designer/Director/Administrator.
- Developed Parallel jobs using stages OCI, Funnel,
Join, Copy, Modify, Lookup, Sort, Aggregator, Transformer,Open Command, DataSet
and FileSet etc.
- Optimized
long running queries using Explain Plan, Oracle Hints to improve
performance.
- Tuned
Long Running DataStage Jobs for better performance.
- Developed
multiple DS routines for automation of the DataStage Jobs.
- Mapped the source and target databases by studying
the specifications and analyzing the required transformations.
- Planned and
implemented ETL and Database Object Migrations in a version controlled
environment.
- Involved
in Unit Testing, Integration Testing to compare and validate data between
source and target.
- Extensively
worked on migrating DataStage jobs from development to test and to
production environments.
- Gathered
requirements and analyzed data from various sources/groups for ETL Design.
- Created high
level design documents, technical/system architecture.
- Involved
with Design/Development of ETL components and mappings from source to
stage and stage to data mart.
- Reviewed
and updated technical specification documents for ETL process.
- Created
high level and low level design documents.
- Worked
closely with Business Users and DataQuality Analysts after loading data
for accuracy and consistency of data.
Environment: IBM InfoSphere DataStage 8.5, Oracle 11g,
Cognos10.1, PL/SQL Developer 7.11, SQL Developer,
Version Control, AIX
Version Control, AIX
Wawa
Inc,PA
Jul 2010
– Jun 2011
Senior ETL/DataStage Developer
The
Vista Replacement Program was created to upgrade from Wawa’s current 1.5.1
version of Vista to the latest version, Vista HRMS 4.1. This implementation
will help build a new foundation for Wawa’s Human
Resources enterprise system. It will allow for more structured operational
and support model methodologies, as well as the adoption of industry best
practices and standards.
Responsibilities:
- Gathered
requirements and Analyzed data from various sources/groups for ETL Design
- Created high
level design documents, technical/system architecture
- Involved with
Design/Development of ETL components and mappings from source to stage and
stage to data mart.
- Modified and
redesigned the existing ETL processes to increase performance to support
multiple batch
schedules and meet the SLA requirements. - Used Client
components DataStage Designer/Director/Manager/Administrator
- Developed Server jobs using stages ODBC, Link
Partitioner, Aggregator, Transformer, Link Collector, and Hash File etc..
- Mapped the source and target databases by studying
the specifications and analyzing the required transforms.
- Planned and
implemented ETL and Database Object Migrations in a version controlled
environment
- Involved
in Unit Testing, Integration Testing to compare and validate data between
source and target.
- Extensively
worked on migrating DataStage jobs from development to test and to
production environments.
- Reviewed
and updated technical specification documents for ETL process.
- Created
of high level and low level design documents.
- Worked
closely with Business Users and DataQuality Analysts after loading data
for accuracy and consistency of data.
Environment: IBM InfoSphere DataStage 8.1, Oracle
10g, MS SQLServer, Version Control, HP UNIX
GMAC, Fort Washington, PA Jan 2003 – Jun 2010
Senior ETL/DataStage Developer
Enterprise Customer
Repository
Enterprise
Customer Repository (ECR) was GMAC’s enterprise data warehouse that provided a
single, consistent, and standardized view of GMAC customers across multiple
concurrent or sequential product relationships. ECR data was sourced from
multiple core enterprise systems, external providers and internal sources. This
repository greatly enhanced the ability to manage, collect and analyze customer
information to increase retention and drive product sales.
Responsibilities:
- Served as
Technical Lead for the ECR ETL processes and managed offshore/onsite
resources
- Gathered
requirements and Analyzed data from various sources/groups for ETL Design
- Created high
level design documents, technical/system architecture & dimensional
data models
- Designed
the Oracle Table structures for data warehouse application that included
Staging, Partitioned, Dimension and Fact Tables.
- Involved with
Oracle Table structure modifications for Mortgage Data
- Involved with
Design/Development of ETL components and mappings from source to stage and
stage to data mart.
- Created several Oracle
PL/SQL stored procedures, views, materialized views and triggers.
- Used
Oracle database partitioning, partition exchange to load data quickly with little impact on
the users
- Used Explain
Plan and Oracle Hints to tune queries to improve system performance
- Responsible for UNIT, System and Integration testing.
Developed Test scripts, Test plan and Test Data.
- Monitored
and fixed issues with the daily/weekly/monthly data load.
- Loaded
data from flat files into the Mortgage database using SQL*Loader.
- Modified and
redesigned the existing ETL processes to increase performance to support
multiple batch
schedules and meet the SLA requirements. - Used Client
components DataStage Designer/Director/Manager/Administrator
- Used
the Data Stage Designer to design and develop jobs for extracting,
cleansing, transforming, integrating, and loading data into different Data
Marts.
- Planned and
implemented ETL and Database Object Migrations in a version controlled
environment
- Created several
Business Object Reports and provided needed metrics for business
management
- Performed Unit
Testing, Created Unit/System Test Plans and conducted system/integration
testing.
- Wrote
UNIX shell scripts and PERL scripts to run the jobs for automated batch
processing.
- Documented
implementation plans and system support guides
Equity Builder
Equity Builder (EB) was a specialized bill paying service that converts the payment flow of a traditional monthly mortgage to a biweekly payment schedule. Enrollment in the Equity Builder Program saved homeowner tens of thousands of dollars in interest expense while building equity at an accelerated rate. Data from the Equity Builder system and GMAC’s Customer Warehouse was used to target and segment various customers for GMAC’s product offerings and for marketing campaigns for enrollment into Equity Builder Program.
Equity Builder (EB) was a specialized bill paying service that converts the payment flow of a traditional monthly mortgage to a biweekly payment schedule. Enrollment in the Equity Builder Program saved homeowner tens of thousands of dollars in interest expense while building equity at an accelerated rate. Data from the Equity Builder system and GMAC’s Customer Warehouse was used to target and segment various customers for GMAC’s product offerings and for marketing campaigns for enrollment into Equity Builder Program.
Responsibilities:
·
Worked with business analysts and end users to
identify requirements and enhancements to existing functionality.
·
Involved with current state system/data
analysis from different sources
·
Created System Design documents and conducted
design reviews.
·
Involved in logical/physical database design
for slowly changing data dimension, FACT/Dimensional tables.
·
Designed/Developed various ETL mappings to
extract data from Equity Builder database
·
Created ORACLE PL/SQL stored procedures and
triggers.
·
Created Business Objects Universe/metadata
from EBdata warehouse databases.
·
Created various data marts from data
warehouse and generated reports using Business Objects report designer.
·
Created different types of reports like
Master/Detail, Cross tab and chart.
·
Developed object fields, attributes,
functions and triggers using Object designer.
·
Used analyzer and explorer to view reports
from different prospects (slice and dice and drill down).
·
Wrote UNIX scripts to perform various
operations and Scheduled UNIX shell scripts using Cron jobs
·
Involved with unit/system testing, user
acceptance testing and documentation of test plans.
·
Responsible for performance tuning,
implementation, production support and creation of support documents.
Environment: Ascential Datastage 7.5.2 (Server and EE edition) , Ascential
QualityStage 7.5 with CASS,
Version Control, Oracle 10g/9i, HP UX, Perl Scripts, Business Object 6.5, Windows NT
Version Control, Oracle 10g/9i, HP UX, Perl Scripts, Business Object 6.5, Windows NT
MASTECH SYSTEMS, Pittsburgh, PA &
Rochester, NY
Apr 1996 – Dec 2002
Information Analyst – Assigned
as consultant to various clients of Mastech Systems.
Clients
included:
Xerox Corporation, Rochester, New York (Sep
1999 – Dec 2002)
Served
as Information Analyst for the Marketing System
Responsibilities:
- Gather
requirements, design, develop, implement and support.
- Developed
PL/SQL modules and UNIX shell scripts.
- Enhanced Marketing System - Production
Support project including requirements gathering, technical specifications
(technical designs), Coding, Testing, and implementations.
- Analysis
and documentation of PL/SQL procedures within Marketing System.
- Used Explain Plan and Oracle Hints to tune
queries to perform better
- Created
views in Oracle to extract data from multiple fact and dimension tables
- Worked
on providing 24/7 Production Support
- Used
Informatica Designer to create simple to complex mappings, using various
transformations.
- Used
various active and passive transformations while loading data into data
marts.
- Created
and scheduled sessions and batches using server manager with various
options like run on demand, run once, run on time.
- Marketing data sourced from Enterprise Data Warehouse,
external provider and internal sources
Environment: Informatica
PowerCenter 1.6, Version Control, Oracle8i,
HP UX, UNIX, SQL PLUS, PL SQL
Moore, Chicago, IL (Sep 1997 – Aug
1999)
Involved on major enhancements to the existing Invoicing System
and WFMS (Warehousing Forms Management System and met aggressive deadline.
Responsibilities:
- Gather
requirements, design, develop, unit test and implement
- Worked with business analysts and end users in
identifying enhancements to existing functionality
- Used
system life cycle methodologies. Worked with clients to satisfy their
electronic invoicing needs.
- Wrote
Business requirements
- Project
Estimates
- Incorporated
work breaks down structure to PRIMAVERA (project tracking system).
- Prepared
run instruction for new jobs
- NIS
(National Invoicing System): Worked on Invoicing System to generate
electronic invoices for clients.
- Coded
tested implemented COBOL II /IMS/VSAM/ DB2/JCL programs for Moore’s NIS
system.
- WFMS (Warehousing
Forms Management System)
- Coded
and Tested Implemented enhancements using COBOL II /IMS /JCL/DB2 /CICS
(batch) to extract data and send the file to the customer-using FTP (File
Transfer Protocol).
Environment
: COBOL / IMS DB-DC / CICS / VSAM/ DB2 / JCL : IBM 3090
British Columbia Telephone Company, Vancouver, Canada (Jan 1997 – Aug 1997)
Coded and tested Y2K enhancements to a number of TAS batch COBOL
programs
Responsibilities:
- Gather
requirements, design, develop, unit test and implement
- Worked with business analysts and end users in
identifying enhancements to existing functionality
- Was
involved in the following systems for BCTEL (British Columbia Telephone
Company):
- TAS (Trouble Administration System)
Special COIN Report. Coded and tested
enhancements to a TAS COBOL - DB2 batch program to produce clearing time reports for COIN troubles. - This
included report request generation from file input and multiple report
production. TAS Y2K Enhancements.
- Coded
and conducted Y2K enhancements to a number of TAS batch COBOL programs
using new Y2K common date routines.
- TAS -
TRIHS (TRouble Information Hierarchy System) Interface
Enhancements/Subsequent Troubles.
- Coded
and tested enhancements to a TAS COBOL batch program to accept new fields
from a TRIHS - TAS interface file and report on subsequent troubles.
- CRIS3 (Customer Records Information
System) - Bill Move Fix. Analyzed, coded, tested, and
implemented CRIS3 changes required for F and T orders that are incorrectly
treated as bill move orders by billing systems.
Environment:
DB2, COBOL, JCL, IDMS, ADS/O, IMS, CICS, VSAM, IBM 3090
Ford Motor Company, Toronto, Canada (Apr 1996 - Dec 1996)
Involved in the development of a “Parts Integrated Pricing System
(PIPS)”. This system is used by Ford to establish the basic price levels
(retail and dealer) for 15 European countries and North America.
Responsibilities:
- Gather
requirements, design, develop, unit test and implement
- Worked with business analysts and end users in
identifying enhancements to existing functionality
- Converted
Pricing System to adapt to North American business practices.
- Modified,
tested and implemented approximately 115 dialogs, 30 DC-batch programs and
12 batch programs.
- Worked with business analysts and end users in identifying
new requirements and enhancements to existing functionality
- Rewrote
DC-COBOL and batch programs which utilized the IDMS database.
- Wrote
over 90% of the PIPS system in ADSO/On-Line. Converted European DOS/VSE
JCL to MVS JCL so that North American changes can be applied. Modified
approximately 105 on-line screens to accommodate the 24 digit part numbers
used by the North American system.
- In
Europe, the part number is only 7 digits.
- The
respected dialogs and/or programs that were associated with these screens
also had to be modified, tested and implemented.
- Maintain
and Support Production system
Environment: COBOL, JCL, IDMS, ADS/O, VSAM,
IBM 3090
RICHARDSON GREENSHIELD, Canada Aug 1995 – Mar 1996
Provides
offshore development in India – Mascot Systems
Information Analyst
Developed account books of stock brokerage and fund companies
which were kept in sync.
- Most
of the programs were newly developed and some existing programs were
modified to make the existing systems interact with a new Pending Control
System.
- Gather
requirements, design, develop, unit test and implement
- Worked with business analysts and end users in
identifying enhancements to existing functionality
- Environment: IBM
ES/9000, MVS/ESA, IDMS, ADS/O, COBOL
Other experiences
- Information Analyst, OM
SOFTWARE, Bombay, India Aug1994 – Aug 1995
- Information Analyst, BRAINS
& BITS, Chennai, India Jul 1992 – Aug 1994
- Programmer , CHOLAN
ROADWAYS CORP, Kumbakonam, India Jan 1992 – Jun
1992
Download Resume Format
.JPG)
.JPG)
0 comments:
Post a Comment