Srikanth
I am available for Corp-Corp
opportunities only. Please reach out to my employer at 630-449-7840/ ajay@neoprisminc.com
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
|
0 comments:
Post a Comment