Data Software Engineer

SUMMARY

. ** years experience as Architect, Project Lead/Senior

Analyst/Programmer Analyst/ Data Warehousing, Data Modeling at Fannie

Mae, Bank of America (MBNA), AOL, Fed Ex, Amex, Syntel and in this

capacity have been involved in various stages of Project Management,

Design, Development, Testing and Implementation of applications for

these clients.

. 10+ years of excellent work base experience on Unix O/S and Unix Korn

Shell Programming

. Over 8 years of strong data warehousing experience in Data

architecture, Data Modeling, Data Migration, Data Integration and Data

Mining as a Data Warehouse Lead using ETL and OLAP Tools, ORACLE,

TERADATA, SQL*Plus, SQL*Loader experience.

. Demonstrated 4+ years of progressive strong management and leadership

skills that are required to work with team members in managing the

execution of challenging business requests and interacting with a

diverse range of people in different levels and functions

. Sound understanding of the following design concepts/principles:

Planning, Development and implementation specifications, Scalability,

Performance, Response time, Benchmarking, Load Testing, Fail-over/High

Availability, Recoverability.

. Strong experience in disaster recovery, business continuity,

Reliability, Change-control, Version upgrade, revision and migration

. Functional experience includes: Project lead, Architect, Developing

Requirement definition, Structuring systems requirements, Process/Data

modelling, Detailing technical specifications, Interface design,

Process flow, Testing and validation, Development of Test scripts,

Systems Integration.

. Design, Development, Implementation involving Business/Technical

Architecture, Business Process charts, Application design, Functional

design, underlying technical aspects involved in creation of the

system and Interfaces with Utility Companies' EDI systems implementing

full life-cycle approach.

. Expertise in Logical and Physical Data Modeling using Erwin tool

including Star Schema and Snowflake Schema, designing of DATA MART,

FACT and Dimension Tables.

. Strong areas of expertise are in Ab Initio, Unix, Oracle, MS-SQL

Server

. Experience in Job Schedulers like Autosys, Maestro etc.

. Possess experience in configuration management tools like PVCS, VSS,

Clear Case, Clear Quest, Remedy PCM

. Very good understanding of Kalido architecture, development

methodologies and hands on experience in a Kalido environment

. Experience on software reporting tools like Business Objects, Actuate,

Oracle reports etc

. Strong analytical and problem solving skills with excellent

communication abilities.

. Certified as Software Quality Analyst (CSQA), worked in a CMM Level 5

Company and have gained experience in process knowledge. Self starter,

comfortable in multi-tasking and working in a dynamic culture.

Efficiently handled multiple projects simultaneously.

. Hands on experience working in financial data warehouse for various

Banking and Financial organizations.

TECHNICAL SKILLS

Programming Languages C, Pro*C, Visual C++, PL/SQL, SQL, UNIX

Shell Scripts, JavaScript, ASP, HTML,

XML

ETL Tools Ab Initio (2.8 ..2.15.32), GDE (1.08

.. 1.15.7.1)

Informatica 5.1/6.1, Datastage 7.0

Business Objects (R2/R3, Webi5),

Actuate.

Configuration Management EME, PVCS, Visual Source Safe 6.0 and

Clear Case 4.2 on UNIX

Database And Tools Oracle 10g/9i/8i/, SQL Server 6.5/7.0,

Oracle Application server

Operating Systems Sun Solaris 2.6/2.7, HP-UX, IBM AIX

4.2/5.2, Windows XP/2000/NT,UNIX

OLAP Business Objects R2/R3(Designer,

Business Objects, Supervisor, Webi and

Info view), Actuate.

WORK HISTORY

Organization Title Start End

Date Date

Fannie Mae Sr. Developer/Lead Aug 2005 Oct

Developer 2010

MBNA (Now Bank Of Sr. Technical Apr 2004 Aug

America) Architect 2005

AOL ETL Consultant Aug 2003 Apr

2004

Fedex Sr. Programmer Dec 2002 Aug

Analyst 2003

Syntel (Amex) Sr.Software Engineer Jun 2000 Dec

2002

Syntel (Sud Chemie, Jet Software Engineer Jun1998 Jun

Airways) 2000

PROJECT EXPERIENCE

Fannie Mae, Washington DC, USA

Aug '05 to Oct '10

Position : Sr. Datawarehouse Developer/Team Lead

Environment : Unix, Ab Initio (GDE 1.15, Co>operating system

2.15), EME,

Oracle 10g, Business Objects, Webi, Autosys,

Clear Case.

Worked as Lead for the design, development and implementation of a

consolidated Financial Data Warehouse and operational data store(ODS) .

This successful project provided the Board of Directors, Investment analyst

and Line managers with detailed insights on various assets and liabilities.

The system was implemented using adaptive data warehousing techniques with

Kalido and Ab-inito as ETL. Worked as an architect to deliver a scalable,

flexible, and reliable data warehousing environment.

Role

- Lead, designed and developed complex datawarehouse with Data

Management and Architecture including Data Modeling, Master Data

Management, ETL (Ab-Initio), and Business Intelligence.

- Worked with business users to translate requirements into data

mappings, Conceptual data model, Logical data model and physical data

model and develop solutions to complex business problems using Data

Warehousing (Dimensional) and Adaptive Data Warehousing techniques.

- Experience is Enterprise data warehouse for Master data management,

meta data management and reference data management.

- Designed data models and ER Diagrams using Data Modeling tools

(Erwin).

- Lead developer for Loans and Portfolio applications of Financial

Datawarehouse ( Ab Initio, PL/SQL and Unix KShell)

- Worked on a Critical SLA project which required high performance

tuning to deliver the data on a timely fashion to Investment analyst

and line managers with detailed insights on various assets and

liabilities.

- Interact with Release Management, Configuration Management, Quality

Assurance, Architecture, Database Modeling Support, other Development

teams and Operations as required

Bank Of America (MBNA), Wilmington DE, USA

Apr '04 to Aug '05

Position : Sr. Technical Architect

Environment : Ab Initio GDE 1.13.1 Co>Op 2.13.1, EME on UNIX,

Oracle 9i, Maestro Job Scheduler.

This is a Consumer Finance Application for all MBNA Mortgage Accounts.

Develop new prototypes and proposals for the Mortgage Business Unit, to

implement different loan decisions. Worked in the role of an Architect to

design, implement, and execute the migration of bank's major data source

systems to AMEX.

Role:

- Design ETL application and develop Datawarehouse applications based on

the technical / functional specifications

- Create logical and physical design documents for each processes and

provide approved one to the Corporate DB Achitecture team and DB

maintain capasity plans

- Implement Re-startability, Recovery Options, Extract / Load Staging,

DIM / FACT loading, ETL Audits

- Implement Disaster recovery routines and documentions

- Work closely with the Business Analysts and Application Leads to get

the business/technical requirements and develop datawarehouse

applications using Ab Initio, Oracle PL/SQL and Unix Korn shell

scripts for BOA's Very Large Database ( VLDB )

- Design, develop and maintain MFS ( Multi File System ) and SFS (

Single File System )

- Conduct process status meetings with all stakeholders and publish

dashboards

- Lead developer, point of contact for data conversion processes ( COBOL

dataset from legacy system) and develop Ab Initio applications, PL/SQL

(Functions, Procedures and packages ) and Unix K shell scripts

- Load batch process data onto partitioned tables and its performance

tuning.

- Conduct functional / technical reviews, document presentations .. etc

- Worked closely, as a lead developer, with Bank's Privacy groups and

Enterprise data warehouse team for Enterprise privacy process to

facilitate the needs of Risk management and customer development group

( Ab Initio, PL/SQL and Unix KShell)

- Process XML input feeds and load into Oracle database tables.

- Perform crucial roles on system testing / QA implementation and

production jobs maintenance

AOL, Dulles Va, USA

Aug '03 to Apr '04

Position : ETL Consultant

Environment : AbInitio GDE 1.10, Co>Operating system 2.8.32,

Clear case

Red Hat, Autosys, Business Objects 4.1.6/5.1,

Oracle,

Sybase, Redbrick, Erwin Wang viewer

"Secure ID for Members" (SID) is a Premium Service targeted at security-

minded members. The SID service extends the RSA Secure ID technology.

Members will be able to order the service and associated Secure ID

device(s) to protect their screen name(s) and account(s).

Role:

- Participated in Logical and Physical Data modelling. Identified the

Entity types, their attributes and the relationship between the

Entities in the organization's business process.

- Worked on Data enrichment and Data Standardization for Quality check

data coming from

Various source systems (i.e, Oracle, Flatfiles.)

- Developed Complex metadata driven graph development using temporary

records, vectors, rollups, scans, input/output tables and many of the

other Ab Initio components.

- Common graph development for error handling, data extraction and data

loading.

- Designed solutions for complex problems based on business

requirements.

- Conducted code reviews and design sessions with junior team members.

- Performance tuning of older Ab Initio projects.

- Developed several Universes for Finance, Marketing, Inventory

departments using Business Objects 5.1

- Formatting the Reports to the Users requirements using all the

requirements in Business Objects like Slice and Dice, Drill Down,

Functions and Formulas.

Fedex, Memphis, TN USA

Dec 02 to Aug'03

Position : Senior Programmer Analyst

Environment : AbInitio GDE 1.10, Co>Operating system 2.8.32,

Sun Solaris 5.8, SSH

Secure Client 3.2.0, Oracle 9i PL/SQL and Tuxedo

This project involves design, development and testing of an application

called Non Transportation as a part of the Chronos. The Non-transportation

process will be responsible for the ratings and billing of Packaging Sales

(new) as well as the transition of the billing to a new engine. The goal

is to have these non-transportation items billed on the customer's

transportation invoice. Miscellaneous Billing and non-transportation items

being billed through a new application called "GAME". The size of the Data-

Warehouse was about 4 Tera-Bytes on an 18 CPU box with 32 GB RAM.

- Handle campaign processes, Data loading, Account Review Process,

Business Card process etc

- Create technical specifications and conduct review meetings

- Gather production issues, report to management and implement through

future releases

- ETL (Extraction, Transformation, Loading) process using Ab Initio,

PL/SQL and Kshell

- Transaction process routines using SQL, PL/SQL and Kshell (Korn Shell)

- Design, develop and maintain MFS ( Multi File System ) and SFS (

Single File System )

- Application development using SQL, PL/SQL and Korn shell scripts (

Korn Shell )

- Perform data analysis for "Database Marketing" and "Data In" teams.

(SQL, PL/SQL and Kshell (Korn Shell), Abinitio )

- Data scrubbing based on the process requirements (Ab Initio and PL/SQL

)

- Application development using PL/SQL batch process using collections,

bilk processing, hints.

- Load batch process data onto partitioned tables and tune its

performance.

- Production Verification process ( Version control, QA process and

maintenance )

- Disaster Recovery process and maintenance

Syntel, Mumbai, India

Jun'00 to Dec'02

Client : AMEX (American Express)

Position : Senior Software Engineer

Environment : Visual C++ (Non MFC) 6.0, C, C++, ATL Com,

Informatica Ver 5.0, Actuate Reporting tool,

SQL Server, Internet Information Server, Microsoft

Transaction Server Libraries, COM, DCOM

The Global Real Estate (GRE) organization of American Express is charged

with evaluating and recommending Real Estate related options for each of

American Express' business units. These recommendations can include where

to lease space, whether or not to renew a lease, the design and

construction of Capital Projects as well as others. A standardized

application was developed to analyze and communicate recommendations.

Role :

- Requirements study, analysis, design and coding of the business modules

and presentation logic.

- I was the SQA Engineer for the overall project involving in Project

planning, Test Design and automation of software application releases.

- Basic architecture followed MVC pattern. I was involved in the design and

development of Business Component, clearly demarcating the presentation

and business logic.

- Used Informatica for migrating data from various OLTP servers/databases.

The data migration included identifying various databases where the

information/data lay scattered, understanding the complex business rules

that need to be implemented, planning the data transformation

methodology, SQL tuning and troubleshooting and production support

issues.

- Used Informatica PowerCenter/PowerMart Server, Server Manager, Repository

Manager and Designer.

- Coded the data handling component and the business logic components in

VC++ COM

- Deployed the components in MTS server.

- Wrote Unix /Perl shell scripts for code deployment in Unix environment.

- Created SQL Server Stored Procedures for accessing and manipulating data

from Oracle database

- I was involved in Project scheduling and coordinating the work with team

members as well as customer/UAT personnel.

- Wrote test cases and test scripts and online help for user manual

testing, unit testing, system testing, integration testing, security

testing, compatibility testing, usability and GUI testing

- I was responsible for functional testing, performance testing, Black Box

Testing, White Box Testing, Gray Box Testing for the modules I developed.

- Carried out integration testing of the entire site using Mercury

Interactive products suite - LoadRunner

Syntel, Chennai, India

Jun'98 to Jun'00

Client : Sud Chemie (Chemical Industry)

Position : Software Engineer

Environment : Forms 6i, Reports 6i, SER,MS Outlook 2000, MS

Excel 2000, Erwin Wang viewer. Oracle 8i

Enterprise, Oracle 9Ias Application Server

Sud Chemie AG is the center and basis of a worldwide chemical group active

in all five continents with over 60 manufacturing and sales companies and a

number of research centers. The S d-Chemie headquarter is located in

Munich, Germany. The Patent Administration System (PAS) is a standalone

Client / Server application with Oracle Forms and Reports as front end and

with Oracle as the back end database server. In addition the application

has to interact with other external systems like MS Excel, MS Outlook and

SER application server. The application has to be web enabled with Oracle

9iAS server environment. Web clients supported are Internet Explorer 4.5 or

above.

Role :

- Requirements study, analysis, design and coding of the business modules

and presentation logic.

- Thorough understanding of Patent Department and its internal business on

the whole to design, develop and deploy web applications on the

framework.

- Designed the Front End presentation using Oracle Forms

- Coded the data handling and business logic components.

- Developed SQL scripts for pulling data from database.

- Developed COM Component to retrieve data from Microsoft Excel and

Outlook.

- Unit tested the module and its framework.

- Implementation and documentation.

- I was involved in Project scheduling and coordinating the work with team

members.

- Extensively used SQL*Loader to load data into Oracle database from

external files.

- Written and modified existing PL/SQL procedures, functions, packages and

triggers.

- Tuned Application by tuning SQL statements and fixing proper indexes.

Syntel, Chennai, India

Jun'98 to Jun'00

Client : Jet Airways (Resource Management System)

Position : Software Engineer

Environment : Visual C++ (MFC) 6.0, Oracle 8I, MFC, ATL, ADO,

Pro*C, COM/ DCOM,

JavaScript, HTML, Rational Rose, PVCS, PL/SQL

This is a three Tier application .This is a part of the core system suite

for the airline industry and shares the database with the other products

in the core system suite. This product helps the Airline clients to plan

their budget, by simulating various flights on various new routes. This

application takes into account the Cost, Revenue, Sales values for the

Routes and Flights. This system works on the Budget and Ad-hoc calculations

of cost and Time tables. It also consists of Follow-up (Actual outcome

versus Budget) and Key Performance Indicator. Using these, the Airline

company can plan there budget and also compare them with previous account

period results. Also the application provides ways to import data from

various other systems in the RM core suit. Data can be imported in

spreadsheet as well as CSV format.

Role :

- Requirements study, analysis, design and coding of the business modules

and presentation logic.

- Designed the Front End presentation using HTML and Java Script.

- Coded the data handling component in VC++ and the business logic

components in MFC

- Created Oracle PL/SQL Stored Procedures for accessing and manipulating

data from Oracle database

- Data analysis and IT documentations.

- Development on SQL, PL/SQL, Pro*C 1.5, Forms 3.0 / 4.5, Unix Shell

Scripts

- System Analysis, testing and implementation

- Work with Mumbai IT head office for Application Migrations and Quality

Analysis

Education

M.S. in Computer Applications

B.S. in Mathematics

Honors Diploma in Software Technology & Systems Management

Certified Software Quality Analyst.

Contact this candidate