Dear All
Find enclosed below the professional summary of Subramani Mottana Basappa
(Data Warehouse, ETL Architect/System Analyst) available for immediate
placement. Kindly let us know if you have any suitable position. He is
looking for opportunities in NY/NJ/PA locations.
Subramani Mottana Basappa
Data Warehouse, ETL Architect / System Analyst
Summary of Qualifications:
. Fifteen years of IT experience in Architect, Analyst, design and
development of software applications with Eight years of experience in
implementing DataStage as an ETL tool and Business Objects reporting in a
dimensional model and Data Integrator Services for data warehouse
environment with Experienced in various capacities and designations from
Programmer, Project Leader to Architect.
. Full life cycle of Software Development (SDLC) experience
including Define, Analyst and Review of Software and Business Requirement
Specifications, Design, Development and Testing, to solidify client
requirements in conjunction with Software Developers.
. Experienced in integration and migration of various data sources
like Oracle, SQL Server, Sybase, DB2, Mainframe system and Complex Flat
files into the staging area.
. Involved in E-R modeling and dimensional data modeling, design of
Star Schema and Snow flake Schema. Used ERwin for physical and logical data
modeling
. Proficiency in data warehousing techniques for data cleansing,
slowly changing dimension phenomenon, surrogate key assignment.
. Extensively worked on PL/SQL programming like Packages,
Procedures, functions, Triggers and Cursors.
. Involved in doing DataStage administrative work.
. Extensively wrote shell scripts to do bulk load, mail
notification, handle SQL commands.
. Industry experience includes Finance, Banking Wholesale Banking,
Manufacturing, Cooperate Credit Risk Management, Telecommunication and
pharmaceuticals.
. Strong experience in the CMM Level 5 Quality process at
organizations such as JPMorgan Chase, Hewlett Packard, Standard Chartered
Bank Singapore.
. Experience in creating Business Object Reports, Crystal Reports.
. Experience in working with Business Objects modules Supervisor,
Designer, BO Reports and Broadcast Agent.
. Expert in doing Data Analysis by running SQL Queries to validate
databases do gap Analysis.
. Strong experience in interacting with business users, gathering
requirements through interviews, workshops, and existing system
documentation or procedures, defining business processes, identifying and
analyzing risks using appropriate templates and Analyst tools.
. Experience in the creation of Project Plan, Design Document, Test
Plan and Test Cases from the Requirements document. Documentation of the
Test Plans, Test Cases, Test Scripts, Test Procedures based on the Design
Document and User Requirement Document for the Unit, Integration,
Regression, Functional, Performance, and User Acceptance Testing (UAT).
Technical Competencies:
ETL Tools Ardent Datastage 3.6, IBM
Information Server 8.5 & IBM InfoSphere Data Stage & Ascential Data Stage
7.5 (PX) Ascential Suite(Profile Stage ,Quality Stage & Metastage)
Informatica
7.1.1, Ab initio 1.14.34, Talend Data Integration, SAP BO DS
Job Management Control M, AutoSys 6.1 Reflection for
Secure IT (Uni-center)
Reporting Tool Business Objects 6.5.1/Xi 4.0 Brio
Query6.6, Crystal Reports5/ 6/ 8, MicroStrategy 7i
Data Modeling Tools Erwin 3.5 / 4.1
Databases Oracle 7x/ 8i/ 10g, 11g, MS SQL
Server 7.0/6.5, 2000, 2005, 2008, MS Access 2000/97,
Sybase 11.9.2, DB2, UDB,
UDB, Teradata V2R4,
Tools TOAD 8.6, SQL*Plus 3.3/8.0
GUI tools Power Builder 4/ 5/ 6/ 7/8
Operating Systems DOS, Windows 2000/ NT/ XP/ 95, HP UNIX,
IBM AIX
Version Control Tool Visual Source Safe, ClearCase
Programming Languages SQL, PL/SQL, UNIX Shell Scripting, Korn Shell
Script, C, C++, Core Java, Basic, WinSQL
Other tools Visio, UML, Singsort
Protocols FTP, Telnet, TOAD
Thanks and Regards,
Sundaram
Millennium Infotech Inc.
101 Morgan Lane suite# 204
Plainsboro NJ 08536
609-378-3418 (P) 609-750-1114 (F)
Email: <mailto:[email protected]> [email protected]
URL: <http://www.mitiweb.com/> www.mitiweb.com
NJ Certified Minority Business | E-Verified Employer
--
You received this message because you are subscribed to the Google Groups
"oraapps" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/oraapps.
For more options, visit https://groups.google.com/d/optout.
