HI, This is Suresh Naidu from India. I am working as an Database Developer. I have more than 6 years of experience as DBA and having good experience in ETL tools.I have worked on ETL tools like Datastage, Informatica,SSIS etc. and having solid experience in databases like MYSQL, ORACLE,TERRA DATA,NETEZZA,SQL Server .
Having good grip in Unix, have been worked with scheduling tools.
below mentioned are the key points in my carrier.
1. Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
2. Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
3. Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
4. Developed complex reports -- multi-functioned, leveled and grouped, summary functionality in main reports providing detailed drilldown through On Demand Sub-reports, dynamic link labeling, complex functions, cross-tabs, charts, shared variables, imported parameters and record sets from stored procedures, conditionally suppressed sections, error handling/messaging, clean and attractive designs, user friendly with instructional ToolTips.
5. Worked with team on customizing the abilities of Crystal Enterprise such as exporting, previewing, printing and emailing reports.
6. Load the data from MS Excel to Oracle Table and Oracle table to MS Excel.
7. Loaded the data using the SQL loader