Software Engineer Design
Resume:
Rupal Patel
SUMMARY
. *+ years of total IT experience of Data Warehousing
tools & technologies (Informatica PowerCenter
8.x/7.x/6.x, Oracle 8i/9i/10g, PL/SQL, Teradata, PL/SQL
scripting and Business Object)
. Excellent Knowledge of Informatica PowerCenter design &
development, tuning ETL sources, mappings, targets and
sessions for better performance and improve usability
. Well versed in developing complex PL/SQL Queries,
Package, Functions, Nested table expressions, Unions and
Multi-table joins within an Oracle 8i/9i/10g
environment.
. Provided Technical Leadership to ensure optimization in
the design, development and implementation of the
delivery of ETL & BI solutions. Implementation of Best
Practices
. Excellent Communication skills, strong analytical skills
and Leadership qualities.
. Experienced in providing training to the team and also
willing to share knowledge.
. Expertise in performance tuning ETL sources, mappings,
targets and sessions for better performance and improve
usability.
. Proven ability to effectively and efficiently manage
time and resources and prioritize tasks in order to
consistently complete projects on time according to
specifications
. Good knowledge of UNIX Shell scripting and PERL
scripting.
. Successfully executed work in multiple roles in many
projects as a Team Member (Developer), Team Leader,
Defect Prevention Representative, Configuration Manager,
Informatica Administrator, Mission Critical Resource &
Data Analyst.
SKILLS
OS: UNIX, Windows 2000/NT, DOS
Languages: UNIX Shell Scripts, HTML, VB6
Databases: Oracle 8i/9i/10g, Teradata V2R5, DB2, MS Access
Tools/Utilities: PL/SQL, SQL*Plus, SQL * LOADER, TOAD,
Version Control: PVCS, VSS
Modeling: ER Win
ETL: Informatica 8x/7x/6x, Oracle ETL using PL/SQL
Reporting: Business Objects, Crystal Reports 7/8/9
EDUCATION
Graduation (B.E.): Bachelors Degree in Chemical Engineering
Post Graduate Diploma in Advanced Computing (PGDAC)
PROFESSIONAL AWARDS
2nd Runner up in ETL Design Contest in Accenture Services
Pvt Ltd., India delivery center. (Design Document created
for Restartability logic of Data Warehouse)
CERTIFICATIONS
. Informatica 7.x/8.x Certified in Architecture and
Administration
. Informatica 7.x/8.x Certified in Mapping Design
. Informatica 7.x/8.x Certified in Advanced Mapping Design
. Six Sigma Green Belt certified
. Post Graduate Diploma in Advanced Computing (PGDAC)
TRAINING & DEVELOPMENT
. Trained in Power Exchange from Informatica
. Training for Exeros (Data Mapping tool) from Accenture
Services Pvt Ltd
. Trained in Informatica PowerCenter 8.x/7.x, Business
Object 6, Cognos 7 by Patni Computer Systems BI-CoE
(Center of Excellence)
EXPERIENCE
December 2009 Blue Shield of California, San Francisco, CA USA
Till Date Sr Data Warehouse Consultant
. Involved in building Operational Data Store(ODS) from
various source systems.
. Designed and developed ODS using Informatica, Oracle,
PL/SQL & UNIX shell scripts.
. This project helps client to streamline all data to ODS
and give single version of truth to the organization.
. Overall Management, Communication & Coordination
o Interaction with business users and requirement
gathering
o Analysis of the requirements, define deliverables,
work breakdown, effort estimates and delivery
timeframes for database development and ETL work
o All data warehouse and data mart design was
performed in an Oracle 10g environment
o Knowledge sharing and discussion of technical
requirements with team.
o Interaction and coordination with business user
for user acceptance testing
o Interaction with software developers, DBA's,
project managers, and data analysts while leading
a team of ETL developers
o Conducting and participating in reviews.
o Identify and promote guidelines, standards, and
best practices for ETL solutions
. Architecting & Design
o Oversee Design of Informatica Mappings, oracle and
Unix shell scripts
o Detailed ETL flow design
o Functionality of mapping, transformations used in
mapping.
o Data flow.
o Target load order.
o Loading strategy and Restartability
o Error trapping methods
. Development
o Developing Informatica mappings, workflows and
schedules using Informatica.
o Development of Procedure, package, functions and
selection criteria design
o Development of reconciliation mappings and PL/SQL
code
o Development of UNIX shell scripts.
. Testing
o Test cases preparation, unit & integration testing
and reviews.
o Testing of workflows, scripts.
o Testing Procedures, functions and PL/SQL code.
o Unit & Integration testing,review of test and
evidence creation
. Support & Performance Tuning
o Performance tuning of Informatica mapping,
workflow and various ETL processes.
o Performance tuning of Database objects, SQL query
for ETL extraction
o Identify the bottle neck, analyze the code, Find
out the root cause and rectify the defect within
given time period.
o Enhancement of the code and worked on ad-hoc
requests.
Environment: Informatica 8.6, UNIX, Oracle 10g
June 2007 DBS Bank Singapore / USA / Hong Kong
To June 2008 Sr. Data Warehouse Consultant/Team Lead
. EDW is a migration project where Financial Services data
is migrated from Oracle 10g database to Teradata
Financial Services Logical Data Model (FSLDM). The main
objective of project is to ensure availability of the
Reporting data for financial reporting and reduction in
turn-around time.
. This is completely new development project where data is
extracted from different legacy systems and provides
consistent, single source data platform on a Private
Banking international level.
. It serves the needs of local and overseas head office
reporting incorporating financial control, risk
reporting, credit risk monitoring and compliance.
. Overall Management, Communication & Coordination
o Interaction with business users and requirement
gathering
o Analysis of requirements, estimation and
distribution of work among team.
o Knowledge sharing and discussion of technical
requirements with team.
o Interaction and coordination with business user
for user acceptance testing
o Conducting and participating in reviews.
. Architecting & Design
. Created complex PL/SQL queries within an Oracle 10g
environment
. Oversee Design of Informatica Mappings and Unix shell
scripts
. Detailed ETL flow design
o Including type of data model to be used.
o Server name, source, Target, database, Connection
string, loading frequency.
o Source and Target path/Database
o Functionality of mapping, transformations used in
mapping.
o Data flow.
o Target load order.
o Loading strategy and Restartability
o Error trapping methods
. Data model changes for new process and ETL enhancements.
. Oversee Design and Maintenance activities of Reporting
Modules.
. Development
o Developing Informatica mappings, workflows and
schedules using Informatica.
o Development of Procedure, package, functions and
selection criteria design
o Development of reconciliation mappings and PL/SQL
code
o Development of UNIX shell scripts.
o Development of FastLoad, FastExport, MultiLoad and
Multi-Export scripts.
o Development of BTEQ scripts for data definition
and data manipulations.
. Testing
o Test cases preparation, unit & integration testing
and reviews.
o Testing of workflows, scripts.
o Testing Procedures, functions and PL/SQL code.
o Testing of BTEQ scripts, FastLoad, FastExport,
MultiLoad and Multi-Export scripts.
o Unit & Integration testing,review of test and
evidence creation
. Performance Tuning
o Performance tuning of Informatica mapping,
workflow and various ETL processes.
o Performance tuning of Database objects, SQL query
for ETL extraction
Environment: Informatica 7.3.1 / 8.1.1, Teradata, UNIX,
Erwin, Oracle 10g
November 2006 American Express Bank, Phoenix, AZ, USA
To May 2007 Sr. Software Engineer/Team Lead
. Triumph mainly contains Non-product related data and
Product Manager Component (PMC) is a single source of
specific, standard product attributes for American
Express products.
. The Product Manager Component manages a consolidated
inventory of all products manufactured or sold by
American Express.
. It provides a central source of product/service rules
and attributes used to drive marketing, disclosure,
fulfillment, and product engines across the enterprise.
. This is completely new development project where data is
extracted from different legacy systems and provides
consistent, single source data platform for a Credit
Card Banking.
. Overall Management, Communication & Coordination
o Interaction with business users and requirement
gathering.
o Responsible for Managing & strong coordination
with the Data warehouse development team.
o Conducting and participating in reviews.
o Sharing knowledge among team members and provided
training.
. Architecting & Design
o Oversee high level and low level design of
Informatica Mappings, Oracle 9i procedures,
tables, indexes. Preparation of Load Strategy.
o Oversee Unix Shell script design.
o Estimation and distribution of the work among the
team members.
. Development
o Developing reusable components in Informatica and
Oracle 9i.
o Creating Informatica mappings, Mapplet, worklet
and workflows
o Procedure, package, functions and selection
criteria design.
. Testing
o Test cases preparation, unit & integration testing
and Conducting reviews
o Unit & Integration testing reviews of test and
evidence creation.
o Created Recon SQL queries
. Performance Tuning
o Performance tuning of Informatica mapping,
workflow and various ETL processes.
o Performance tuning of Database objects, SQL query
for ETL extraction
. Deployment
o Packaging and deployment of code
o Coordination with infrastructure team for
migrations of code in environments
Environment: Informatica 7.3.1, Oracle 9i, VSS, UNIX, Power
Exchange
April 2005 General Electric Financial Assurance, Richmond, PA, USA
To October 2006 Sr. Software Engineer/Team Lead
. HQ-BI project mainly contains 2 systems Travel and
Safari. Travel has all the information about Traveling
expenses and reimbursement of RBC (Reserve Bank of
Canada), Chase and Poorman (Hard Checks releases).
Safari contains all the head count of HR and all the
details about employees.
. This project involves maintaining and supporting
Employee data as well as Accounting Data Marts for GE
Head Quarter.
. A platform provides all expense related data to
managers. After approval it is forwarded for bank
transaction.
. The main objective of project is to ensure availability
of the daily expense data for financial reporting and
reduction in turn-around time and loading the marts with
billing data.
. Overall Management, Communication & Coordination
o Responsible for Managing & coordination with the
development team of datamart and reporting for new
requirements and enhancements
. Analysis
o Analysis of Requirements, Identification and
Estimation.
. Architecting
o Architecting the ETL using Oracle PL/SQL Package
and Procedures.
. Design and Development
o Design, Development and Maintenance of Oracle 9i
Financial Data warehouse
o Design, Development and testing of PL/SQL ETL
Mappings of Oracle 9i
. Testing
o Unit testing, Integration Testing and System
testing of PL/SQL Procedures and ETL Mapping
o UAT Testing of Discoverer reports.
. Deployment
o Packaging and deployment of code
o Coordination with infrastructure team for
migrations of code in environments
Environment: Informatica 7.3.1, Oracle 9i, Visual Source
Safe, UNIX, Crystal Reports
May 2004 General Electric Financial Assurance, Richmond, PA, USA
To March 2005 Sr. Software Engineer
. GEFA operates through its affiliates and subsidiaries as
a provider of insurance and other financial services to
individual and institutional customers. The Company
offers life insurance, annuities, property insurance and
mutual funds to individuals. GEFA also provides group
insurance, reinsurance, retirement and savings products
and services to corporations and other institutions.
. This project involves maintaining and supporting Finance
Data Marts, a platform meeting all Financial Reporting
requirements of GEFA.
. The main objective of project is to ensure availability
of the Finance Marts daily data for financial reporting
and reduction in turn-around time and loading the marts
with Billing data and Oracle Applications (AR) and Data
Warehouse.
. Analysis
o Analysis of requirement, Identification and
estimation.
. Design and Development
o Design and Development of Informatica mappings and
workflows
o Scheduling of Informatica workflows.
o Design and Development of PL/SQL code.
. Testing
o Unit testing, Integration Testing and System
testing of PL/SQL code and ETL Mapping.
o UAT Testing of reports generated by Magic.
. Performance Tuning
o Performance tuning of Oracle PL/SQL, Discoverer Ad-
hoc query.
. Deployment
o Packaging and deployment of code
o Coordination with infrastructure team for
migrations of code in environments
. Mission Critical Resource
o In case of any disaster like fire, earthquake or
power failure the MCR is responsible to run the
project from alternate location
. Defect Prevention Representative
o Identify and keep note of all the Defects found in
code.
o Conduct meeting among team members and find out
the root cause and preventive action.
o Keep track of all the open and closed defects
found in code to minimize defect at first time and
every time.
Environment: Oracle 9i, Informatica 6.2.1, Magic, PVCS,
UNIX, Crystal Reports
December 2003 ABN AMRO Services Company, Inc., Cincinnati, OH, USA
To April 2004 Software Engineer
. A Data warehousing project involved in developing
various Metrics for the ADSM (Analysis, Development,
Support and Maintenance) Management to monitor the
success of the IT Services Division which was
restructured to ADSM, using Business Objects.
. The purpose of Metrics Automation Project is to provide
ease to the higher management and to convert technical
terms in such a way that business user can understand
easily.
. It provides online reports to check the progress of the
company (Profit and loss of the selected year), yearly
revenue generated, money investment on different
projects (i.e. support, maintenance, development etc)
and customer satisfaction in different departments
through Business Object reports.
. Analysis
o Analysis of requirement, Identification and
estimation for reports.
. Design and Development
o Design and Development of Informatica mappings and
workflows
o Scheduling of Informatica workflows.
o Design and Development of business Object reports
o Publishing and scheduling reports
. Testing
o Unit testing, Integration Testing and System
testing of ETL Mapping, BO reports.
o UAT Testing of reports generated by Business
Objects.
. Defect Prevention Representative
o Identify and keep note of all the Defects found in
code.
o Conduct meeting among team members and find out
the root cause and preventive action.
o Keep track of all the open and closed defects
found in code to minimize defect at first time and
every time.
Environment: Informatica 6.x, BO 6.0, Crystal Reports, Web
Intelligence 6.0, PL/SQL
August 2001 Kothari Creations Private Limited, Mumbai
To October 2003 Software Engineer
. Payroll and HR Management Systems (HRMS) is developed
for overall payroll and HR management system. It
downloads daily attendance from swipe machine data.
Automatically calculate overtime, late and early exit
half days. All type of leaves calculation (PL, CL, SL
etc.), arrears and account report, salary calculation,
full and final generation for employees, recruitment and
training details. 30 different types of Crystal reports
are generated HRD & management.
. Inventory Management Systems (IMS) is developed for
managing inventory of material and accountings. It takes
care of items, customers/departments and supplier and
purchase orders.
. Design and Development
o Design and Development of Visual Basic Forms.
o Creation of functions and procedures in Oracle
PL/SQL.
o Design and Development of Crystal Reports as per
requirement
o Publishing and scheduling reports
. Testing
o Unit testing, Integration Testing and System
testing of Visual Basic code and Crystal Reports.
o UAT Testing of reports generated by Crystal
Reports.
Environment: Oracle 9i, PL/SQL, Visual Basic 6.0 and
Crystal Reports 8.5, NT
Contact this candidate