| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Oracle SQL and PL/SQL Developer and Teradata Developer PHONE NUMBER AVAILABLE EMAIL AVAILABLEProfessional Expertise:Over 5+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).3+ years of experience as a Data Analyst and Developer in Teradata database development and an excellent understanding of data warehousing, relational database structures conceptsInvolved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.Strong RDBMS concepts and well experience in creating database objects like Tables, Views, Sequences, triggers, Collections, etc taking the Performance and Reusability into consideration.Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD, PLSQL Developer and SQL*LOADER.Experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions. Adept at working on multiple projects simultaneously.Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, PLSQL Developer and SQL*LOADER.Experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions.Worked at conceptual/logical/physical data model level using Erwin according to requirements.Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.Good knowledge on logical and physical Data Modeling using normalizing Techniques.Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.Developed materialized views for data replication in distributed environments.Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.Loaded Data into Oracle Tables using SQL Loader.Partitioned large Tables using range partition technique.Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.Worked extensively on Ref Cursor, External Tables, Collections and Exception handling.Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.Experience with design and implementation of ETL/ELT framework for complex warehouses/marts. Knowledge of large data sets and experience with performance tuning and troubleshootingExperience in Test data Management and provide test data.Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.Skills & Abilities:Operating systemWindows, UNIX/Linux, MacIntoshToolsMS-Office Suite, T.O.A.D, Alteryx, Jira toolsDatabasesOracle-PL/SQL, TeradataConfiguration ManagementGitHub,BitBucket,SourcetreeEducation:Master in Computer ApplicationKIIT Bhubaneswar, India 2007Bachelor in Computer ScienceUtkal University, India 2004Work Permit: H4 EAD valid till May 2024Projects:Database Developer and Analyst .SEP 2022- Till NowCHARTER COMMUNICATIONResponsibilities:Design and maintain database systems. This includes creating, updating, reading, and deleting .Managing and designing the reporting environment, including data sources, security, and metadata.Supporting the data warehouse in identifying and revising reporting requirements.Supporting initiatives for data integrity and normalization.Generating reports from single or multiple systems.Troubleshooting the reporting database environment and reports.Providing technical expertise in data storage structures, data mining, and data cleansing.Work in multiple source data extraction and data transition from existing production system to test environment.Performing root cause analysis and providing recommendations for resolutionProviding data to Marketing, sales and Business Analyst.Environment: Teradata and ALTERYX tool.Test Data AnalystJUL 2011-Jan 2014SPRINT.Responsibilities:Developing and executing a long-term strategy for enterprise test data managementEstimating testing-related tasks, analyzing testing requirements, designing and developing supporting tools, testing, and implementing TDM processes and solutionsIdentifying the Type of Data required for Software TestingCreating consistent and repeatable processes to support multiple functions, such as identifying and masking test data for different applications and refreshing/updating test data as neededEnsuring compliance with IT security guidelines and data compliance regulationsProvisioning data for QA testing, user acceptance testing, and performance testing.Oracle DeveloperNCRAPRIL 2009 - JULY 2011Responsibilities:Works on different database management systems efficientlyHas a good command over data warehousing concepts to load the data effectivelyDesign, develop, and automate the dataDevelops data flow models for ETL applicationsTesting the storage system after transferring the dataPrepare documentation for the further referenceEnsure that the data is scalable and architectureWork with clients to deliver scalable and maintainable dataGather essentials and process them for business needs.Oracle DeveloperAIR CANADA, CANADASept 2008 - March 2009Responsibilities: Performed design and development of Oracle applications according to project requirements. Design, code, and maintain the Oracle systems based on established standards. Understand project requirements and develop design specifications. Perform initial design reviews and recommend improvements. Write clear codes and prepare coding documentations. Provide technical assistance to other Developers as needed. Analyze and troubleshoot system issues in a timely manner. Developed Oracle reports, database procedures and UNIX shell scripts. Modify existing codes to optimize Oracle applications. Assist in system integration and acceptance testing and perform bug fixes |
