SQL Developer Resume Profile

Summary of Skills

About 15 years of experience with all phases of Software Development Life Cycle SDLC and development, enhancement and maintenance of complex OLTP, Data warehouse and multi-tier database driven web based projects.
Experienced relational/dimensional Data Modeller, designer using Erwin, Oracle technology
Hard core Oracle SQL, PL/SQL, Performance Tuning, UNIX shell script, SAS professional
Deep knowledge in data integration, data migration and warehousing concept and practices
Strong ETL experience in both dimensional and relational modeling concepts like star-schema modeling, snow flaking in Enterprise level environments
Good experience in both dimensional and relational modeling concepts like star-schema modeling, snow flaking, ER modeling at conceptual, logical and physical levels
Excellent understanding of dimensional modeling concepts and relational database concept normalization, de-normalization, ETL process and moving of data from source to target
Good Understanding of different change data capture approaches and implementations
Created and managed Oracle objects including tables, indexes, stored procedures, table spaces, views, users, roles, partitioning and materialized views.
Extensive knowledge of programming Oracle SQL and PL/SQL, SAS and UNIX Shell Scripts.
In-depth knowledge of PL/SQL and SAS programming, data processing, data collection, quantitative and qualitative data analysis
Proficient to implement business rules using Oracle 11g/10g database PL/SQL packages, stored procedures, functions, database triggers, indexing, query handling and reports.
Excellent coding, troubleshooting and complex problem solving skills in advance SQL and PL/SQL, SAS, SQL Loader, UNIX Shell Scripting and programming JAVA, J2EE, JSP, JDBC.
Expertise in performance tuning and SQL optimization using TKPROF, Explain Plan, Hints, DBMS PROFILER, restructuring query, materialized views, table partitioning and indexing.
Exposure to AWR/ADDM, SQL access/ tuning advisors, DBMS ADVISOR, DBMS SQLTUNE
Strong experience with Oracle Architecture, space management, physical data organization, memory structures and monitoring tools and techniques.
Experience in database design, data analysis, development, purging and data conversions.
Strong experience in BASEL-II US rules for bank's regulatory capital requirement and Risk foundation data mart and Moody's RWA Calculator.
Strong ability to translate business reporting specifications into complex matrix and interactive graphic reports with drill-down to detail reports on web front presentation layer.
Prepared documentation and user manuals and involved in validation and UAT
Demonstrated ability to respond to changing priorities, multiple tasks and demands within short timeframes and excellent client communication skills.
Team player, capable of working without supervision and effective communicator.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship