DB Expert/QA Specialist/ETL Expert/Report Expert/Python,Django Expert
Last active: 2 months ago
HI, This is Suresh Naidu from India. I am working as an Database Developer.
I have more than 6 years of experience as DB Expert, ETL tools.
having solid experience in databases like POSTGRESQL, MYSQL, ORACLE,TERRA DATA,NETEZZA,SQL Server.
I have worked on ETL tools like Pentaho,Datastage, Informatica,SSIS etc.
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, Imports & UTL files based on file formats.
8. Created logical model including Entity-Relationship diagram .
9. Converted logical model into physical model
10. Developed over 1000 T-SQL stored procedures, functions, triggers and views.
11. Worked on optimization SQL Server performance, monitoring, and queries tuning using Microsoft tools Performance Monitor
12. Designed and implemented schema
13. Designed and implemented Warehouse
14. Designed production database maintenance schema
15. Designed release management procedures for Development
Customized MS Access database solution specialist.
I have developed MS Access applications that enhances the productivity of my clients.
My goal is to be known as a dependable and reliable oDesk professional delivering excellent quality of work on time to my clients.
My skills are well suited to jobs that include database design and development, data mining, medium to large data entry projects, software and hardware technical support, and other similar/related jobs.
I have worked Title Examiners, Title Companies, Appraisers, Mortgage Brokers, Real Estate Investors, Realtors,Lenders etc. As a result I have a very good understanding of the US Real Estate Industry.
Below are some of the projects that I have handled in the past for Real Estate professionals.
(i) Real Estate Investors : Searching for motivated sellers,searching for cash buyers, Analyzing deals, CMA , determining the ARV, making offers, posting ads on classified websites, market research, Freedomsoft, Raleflow, MLS Gorilla etc.
(ii) Realtors: CMA Analysis, Broker Price Opinion (BPOs), database management, uploading listings to various websites etc.
(iii) Real Estate Appraisers: Pulling comps, Analyzing comps, determining adjustments, determining the market conditions, data entry etc.
(iv) Real Estate Title Examiners: examination of public records to determine and confirm a property's legal ownership, determine outstanding mortgages, liens, judgements, property restrictions and easements, inputting all findings into a title report.
(v) Real Estate Title Companies / Attorney: Inputting new orders into the Title software, obtaining updated tax information, obtaining payoffs, ordering hazard insurance, ordering title searches, preparing title commitments, generating prelim HUDs etc.
(vi) Real Estate Mortgage Brokers / Lenders : Contract Loan Processing - inputting new loans into the loan origination software, ordering title, insurance, payoffs, verification of Employment, Verification of Deposits, Verification of Mortgage, Verification of Rent, gathering loan document, submitting file to lender, working on lender conditions, co-coordinating closings etc.