We provide IT Staff Augmentation Services!

Database Modeller, Data Architect, Tech Lead Resume

Seattle, WA

PROFESSIONAL SUMMARY:

  • 12+ Years of experience in analysis, Modelling, Design, Development, implementation and Production Support as SQL/PLSQL Developer/support person working on Oracle 9i/10g/11g platforms.
  • Intensely worked in ERWIN/Visio to generate ER diagram and data models based on the client requirements.
  • Well aware of Data structure, SDLC, DBMS, Data warehousing, Data modelling, BI concepts.
  • Extensive knowledge on PL/SQL components like Procedures, Functions, Cursors, Packages, Triggers and other features such as VARRAYS, Nested Tables, Index by tables, Bulk Collections, Database Triggers using features like Cursors, Collections, Exception Handling and Bulk binding.
  • Very strong in full suite of Oracle Tools PL/SQL etc.
  • Good experience in Business object XIR2 reporting tool along with strong knowledge in Crystal report.
  • Experience with oracle and other utilities like PLSQL developer, SQL Navigator and Toad.
  • Strong skills in developing applications using Oracle RDBMS 10g/9i and developing reports using reporting tool.
  • Very proficient in SQL tuning and optimization of queries.
  • Strong experience in database designing, database development, enhancement, migration projects.
  • Hands on experience working on UNIX platforms in developing shell scripts.
  • Proficient in Oracle Tools and Utilities such as TOAD, SQL Plus.
  • Experience in Designing and developing reports using BI/BO/crystal report Publisher.
  • Proficient in preparing technical documents based upon user requirement.
  • Have strong experience in Leading the team and handling production issues in crisis.
  • Strong team player with excellent communication skills.

TECHNICAL SKILLS:

Data Bases: MySQL,Oracle 11g/10g, Oracle 9i, Oracle 8i, SQL, Cassandra

Oracle Tools: SQL Developer, PLSQL Developer, SQL Navigator, TOAD, ErWin

Documentation: Small work document (SMW), Test design document TDD, Runbook, Functional specification Document(FSD)

Code Control Tools: CVS, VSS

Languages: Oracle, SQL, PL/SQL, Unix Shell Scripting, Crystal report, BUSINESS OBJECT XIR2

Office Tools: MS Office, MS Project

Development Tools: SQL*Plus, Enterprise Manager (Import/Export)

Other Tool: Appworx,Visio

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Database Modeller, Data Architect, Tech Lead

Responsibilities:

  • Build capability to let All retail stores, ship the returns ( Devices and Accessories ) across all programs to Confidential warehouse
  • Implement Distribution order process to reship the returns from Confidential to ARC / YORK
  • Build System of Aggregation (SOA) to capture:
  • Transfer Orders, Purchase Orders, Delivery Data, Inventory management New integration layer using SOA XML transfer to Confidential
  • Implement Controls of data transfer across SAP, SOA and Confidential WMS
  • UPS Carrier data: Build capability to track the UPS tracking data for traceability of transfers from Retail Store to DC
  • Improvements Confidential Confidential facility to receive returns from Retail Stores and capturing the post receiving events for better reporting system
  • Build new Event Repository System ( cloud version to existing OER ) to capture Device life cycle events
  • Involved in assessment of existing OER (Object event Repository) for Device life cycle.
  • Efficient in gathering requirement and writing plsql code.
  • Intensely worked in ERWIN/Visio to generate ER diagram and data models based on the client requirements.
  • Worked in preparing functional document, user document, process flow diagram and flow chart.
  • Involved in migrating existing data to new system by writing complex plsql blocks.
  • Involved in preparing complex queries as per client’s requirements.
  • Participated in meetings with business users to understand and explain Data requirements.
  • Interacted daily with business users and functional resource to gather facts for OER.
  • Efficiently working on cloud based Cassandra database.
  • Well aware and efficient to work in Agile model and work as per sprint releases.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in handling any issues related to YODA.
  • Efficient in gathering requirement and writing plsql code.
  • Intensely worked in ERWIN to generate ER diagram and data models based on the client requirements.
  • Worked in preparing functional document, user document, process flow diagram and flow chart.
  • Loading with SQL Loader and to base table with interface programs.
  • Involved in preparing complex queries as per client’s requirements.
  • Participated in meetings with business users to understand and explain Data requirements.
  • Interacted daily with business users and functional resource to gather facts of YODA.
  • Efficient in working on AOTS tickets as Confidential team.
  • As an Onsite co - ordinator, also worked as mentor for new team member.
  • Made good repo with client by being available for any issue Confidential any time.

Environment: Oracle 11g, TOAD, Appworx, UNIX, ErWin/Visio

Confidential

Tech Lead and Senior Oracle PL/SQL Developer

Responsibilities:

  • Involved in gathering requirements from business users, analysis and system design.
  • Intensely worked in ERWIN to generate ER diagram and data models based on the client requirements.
  • Created and managed data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.
  • Created the PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.
  • Extensively worked in tuning the queries and applying hints for faster and better performance of the SQL queries.
  • Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
  • Worked in preparing functional document, user document, process flow diagram and flow chart.
  • Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Loading with SQL Loader and to base table with interface programs.
  • Involved in Extraction, Transformation and Loading (ETL) of the data in the table for Oracle database.
  • Developed multiple views using Ref Cursor for reporting purposes on Order management system.
  • Created logical and physical database objects - tables, indexes, referential integrity constraints, and Triggers to development needs.
  • Worked for Performance tuning.
  • Worked on table partitioning (Range and List) and deploying various methods of indexing like local indexes and global indexes on portioned tables.
  • Used version control tools VSS/CVS to checking the scripts.
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
  • Review of the Technical Designs and Codes.
  • Participated in meetings with business users to understand and explain Data requirements.
  • Interacted daily with business users and functional resource to gather requirements for dashboard.
  • Worked to create Unix shell script for loading data from flat files to Oracle tables.
  • Hands on experience in scheduling batch jobs in unix CRONTABS.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application for Oracle procedures as well as Unix scripts.
  • Also worked on Migration from Unix to Linux for cloud environment, tested Linux scripts after migration.
  • Aware of Golden gate data synchronization process.
  • Created Deployment scripts to deploy changes in production environment.

Environment: Oracle 11g, Oracle 10g, SQL Developer, Informatica, TOAD, UNIX,LINUX, Windows XP,SQL Loader

Confidential, UK

Senior Oracle Developer - Module Lead

Responsibilities:

  • Involved in the Analysis, Design, Coding and Testing of the application.
  • Developed Technical design document for the business requirements.
  • Intensely worked in ERWIN to generate ER diagram and data models based on the client requirements.
  • Created and modified PL/SQL Triggers, Procedures, Functions and packages.
  • Developed SQL scripts to create database objects like tables, views and sequences.
  • Prepared requirement specification document that gives the comprehensive details about the Requirements.
  • Developed SQL and PL/ SQL scripts for transfer of data between databases.
  • Designed and developed complex reports to meet end user requirements and deployed using Oracle Reports.
  • Developed complex SQL queries, triggers for building different reports.
  • Developed complex triggers in reports before/after for validation of user input.
  • Worked in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using SQL Navigator and Toad as development tools.
  • Extensively worked on production issues with effective defect management.
  • Design and development of customizations, Reports and all technical design and solutions.
  • Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
  • Wrote ad hock SQL scripts to assist QA in back-end testing and data validation.
  • Developed custom reports and added columns in the existing reports according to the requirement.
  • Developed new BO/Crystal reports using Universe.
  • Involved in developing new reports as per Client Requirement.
  • Provided technical support to the user with regard to operational aspects.
  • Review of the Technical Designs and Codes along with leading team.

Environment: Oracle, PL/SQL, SQL, SQL Navigator, Crystal Report, Business Object XIR2.

Confidential

Oracle Developer

Responsibilities:

  • Developed Conceptual, Logical and physical data model and scripts to create users, roles and schema objects.
  • Developed customized several reports using BO to meet the client requirement and necessities.
  • Created Universe from scratch to build BO report environment.
  • Developed and designed the Reports that had complex SQL, PL/SQL code and Stored Procedures. The Filter condition for the Queries was dynamic in nature and it included Lexical parameters.
  • Wrote PL/SQL Database triggers to implement business rules.
  • Interacted with the Users for the Business requirements and designed the layout for the reports.
  • Involved in migrating the Business Object 8.5 to Business object XIR2. Solved Problems while doing Migration and corrected the Errors.
  • Customized the reports and scheduled to gather data and mail using Business object reporting tool.
  • Gathered and analyzed business requirements from end users.
  • Worked with applications specialists to understand the new data requirements.
  • Sometimes it includes online System & Regression Testing.

Environment: SQL, PL/SQL, Oracle, SQL Navigator, Business object 8.5 and XIR2

Confidential

Oracle Developer

Responsibilities:

  • Involved in understand new requirements.
  • Involved in database design for each requirement.
  • Developed several Procedures and Database Triggers as per Business requirement.
  • Worked with Synonyms, Sequences, Views and Materialized Views.
  • Documents the functionality into the form of business requirement document.
  • Developed Forms like Invoicing, Delivery Order, Quotation, Stock Inwards, Stock outwards, adjustments etc.
  • Developed Reports like Weekly reports, Daily Stock status report, Weekly, Monthly, and Periodical Reports.
  • Created various (Back-end) PL/SQL code to implement business rules through procedures, functions, and packages.
  • Code review for Logical errors.
  • Involved in the support and maintenance activities.
  • Testing and reviewing the programs.
  • Unit and Integration Testing.

Environment: PL/SQL, SQL*Plus, Oracle database version 8i, ASP.NET, VB.NET

Hire Now