*Srikanth For more details- [email protected]
<[email protected]>
*
- *IBM Certified for* *IBM InfoSphere Information Server 8.5*.
- *Teradata Certified Professional V2R5.*
*Professional Summary*
· Over 8* years* of experience in software industry including
requirement gathering, Analysis, Design, Development, Testing, Data
Analyzing, Implementation, Maintenance and Production Support of various
Data Warehousing and *OLAP* Applications using *ETL* Tools.
- 7 + Years of experience in IBM Info Sphere Information Server
9.1/8.7/8.5/8.1/7.5
and Ascential DataStage 7.x using components like DataStage/QualityStage
Designer, Director and Administrator, Information Analyzer.
- *IBM Certified for* *IBM InfoSphere Information Server 8.5*.
- *Teradata Certified Professional V2R5.*
- Involved in all the phases of the SDLC from *Requirement gathering,
Design, Development, Unit testing, UAT, Production, Maintenance* and
*support.*
- Worked with Business users to elicit business requirements and
formulating technical requirements.
· Experience in source systems analysis and data extraction from
various sources like *Flat files, Oracle 10g/9i/8.x, DB2 UDB, DB2 AS400,
Mainframe files/COBOL Copybooks, PeopleSoft and SAP systems*.
- Experience in Relational Database Modeling and Dimensional Modeling-*Star
schema*,* Snow-Flake schema*, and hands on experience in data modeling
tools like *ERwin *and* ER Studio.*
· Expertise in troubleshooting DataStage jobs, enhancement of jobs
and addressing post production activities like performance tuning and
enhancements.
· Experience in designing *Batch Jobs* and *Job Sequences* for
scheduling server and parallel jobs using DataStage Director, Enterprise
Scheduling tools, UNIX scripts.
· Experience in programming using *SQL, PL/SQL, *and* UNIX Shell
Scripting.*
- Extensive experience in *IBM DB2* UDB 9.7/9.0/8.0, *Oracle 10g/9i/8i*,
Microsoft *SQL Server* 2005/2000, *Teradata, Netezza* databases.
- Excellent understanding of *Teradata V12/V2R6/V2R5* Architecture and
expertise in using the utilities.
- Good knowledge of *Netezza database Architecture* and working
knowledge of utilities like *nzload, nzsql*
- Created frame work, best practice, standards and naming conventions
documents used in ETL environment.
- Excellent communication and interpersonal skills, teamwork, problem
solving skills, flexible, self-direct and energetic person
*Technical SKILLS:*
*Programming Languages*
*SQL, PL/SQL, Unix Shell Script, Perl* *Script*, *C++, Python, Java, HTML,
CSS*
*ETL Tool*
*Datastage 9.1/8.7/8.5/8.1/8.0.1/7.5.2/7.1 (Administrator, Manager,
Designer, Director, Parallel Extender/Orchestrate, Information Server,
Quality Stage*), *ClearCase 9.1*
*Reporting Tool*
*Micro Strategy 9.0/9.0.1, Cognos10.1, Business Objects*
*Tools & Utilities*
Microsoft Office Suites, Citrix, SQL Assistant, Advanced Query Tool, TOAD,
Control M, MS Visio,Oracle SQL Developer
*RDBMS*
*Teradata, Netezza TwinFin, Oracle11g/10g/9i/8i/7.3,SQL Server
2000/2005/2008, DB2. MSAccess*
*Operating Systems*
Windows 8/7/XP/ 2000, *Linux ,UNIX, Sun Solaris*
*Professional EXPERIENCE:*
*New York State Department of Labor, Albany, NY
Nov 2013 - Till
date *
*Sr. ETL Developer*
*Environment*: *IBM Infosphere DataStage and QualityStage 9.1, ClearCase
9.1, Oracle 11g, SQL, PL/SQL Developer, XML, Windows 7, UNIX (AIX
6.1/Solaris 9).*
Thanks
Ajay
Sr. Mgr - Business Development
Ph: 630-449-7840
[email protected]
--
You received this message because you are subscribed to the Google Groups
"American Vendor--IT Consulting" 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/sap-vendor.
For more options, visit https://groups.google.com/d/optout.
