We provide IT Staff Augmentation Services!

Data Architect, Oracle Pl/sql Developer Consultant Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • 11+ years of extensive experience in developing software applications using SDLC and primarily focus on Data Warehouse and ETL tools using Oracle PL/SQL, UNIX shell script, Oracle 11i/10g/9i.
  • 3+ years of experience in digital cable, advertising and telecom sector in business system analysis and Oracle data warehousing and data modeling and data analysis of Audience Measurement and Trigger Overlay data.
  • 4+ years of project leading and project management experience.
  • 4+ years of experience in PL/SQL development, performance tuning in Oracle RAC environment and Parallel Query server.
  • 1+ years experience in Informatica for ETL development.
  • 1+ years experience in Netezza database.
  • 2+ years of database administration experience
  • 5+ years of experience in business and data analysis of GSM Telecom Sector, IT specially Billing, Mediation, Provisioning, Roaming, Data Warehouse, Data Staging, ETL development, Oracle Financials, customized CRM Applications, Sales distribution and Commission system, Revenue Assurance, Finance Automation and HRM system.
  • 4+ years of experience in application development for customized ERP solution for Ready Made Garments, Textile, Manufacturing industries using Oracle 8i/9i, Oracle developer 6i (Forms/Reports), Oracle Application Server, Shell script.
  • 9+ years of experience of data modeling with Erwin, ER Studio, SD - PRO, Sybase Power designer, Visio.
  • 4+ years of experience of PVCS for version control.
  • 4+ years of experience of report development using XML/XSLT in web development.
  • 2+ years of experience in MS SQL server.
  • Experience in data warehousing such as dimensional modeling, star and snowflake schemas, datamart, fact and dimension tables identification, and OLAP.
  • 5+ years of experience in SQL performance tuning.
  • Extensive work exposure in Unix Korn Shell scripting, Perl scripting,.
  • 6+ years of experience in report development using Business Objects, Oracle Reports, Oracle Discoverer, and Crystal Reports.
  • 5+ years of experience in developing customized Oracle applications using Oracle Forms 10g Developer Suite.
  • 3+ years of expertise in developing secure Internet and Intranet applications using Struts, Ajax, JSP, Servlet, Jakarta Tomcat, Asp.Net, IIS, VB Script, JavaScript, CSS.

TECHNICAL SKILLS

Environment: s: UNIX (HP, Sun Solaris), Linux, Windows 2003

Advanced: Server, Oracle 11i RAC, Oracle 10g Application Server, Jakarta Tomcat 4.1.24 web server, IIS.

Languages: Oracle PL/SQL, Oracle Developer suite, Java, JSP, ServletXML, XSLT, C, C++, C#, VB.NET, ASP.NET, CSS.

Scripting: UNIX Shell script, Perl, JavaScript, VBScript.

Object Oriented Design: Rational Rose.

Database: Oracle 11i, Oracle 10g, Oracle 9i, MS. SQL Server, MYSQL, MS Access.

Database: Design, ModelingErwin, Oracle Designer, Sybase Power Designer, SD-Pro, Toad, PL SQL Developer, VisioAnalysis and PM ToolsBorland Caliber RM, SPSS, MS-Project.

Development Tools: Borland C builder, Visual Studio (Visual C++, Visual Basic, Visual Interdev, VB.NET, Visual C#, ASP.NET)JBuilder, JCreator. Editplus, Textpad

Reporting Tools: Microstrategy, Business Objects, Oracle Discoverer, Oracle Reports, Crystal Report

PROFESSIONAL EXPERIENCE

Confidential

Data Architect, Oracle PL/SQL Developer Consultant

Responsibilities:

  • Design dimensional data warehouse for star and snowflake schema.
  • Develop data model for slowly changing dimensions of production data by ER-Studio.
  • Develop data warehouse solution for demographic, geographic attributes.
  • Data Analysis and data quality control of setup box data and advertisement and event trigger data.
  • Develop Oracle pl/sql package, procedures, and functions for aggregation using oracle collections.
  • Use hints for select, insert and parallel query and hash join.
  • Design database objects (index, table) with parallel multiple degree and multiple instances for RAC environment.
  • Work with Oracle support for unpublished bug fix for oracle error in RAC environment.
  • Performance tuning of optimizing oracle sql query for Oracle 11g using TKPROF, trace file, explain plan, rebuilding and analyzing indexes.
  • Oracle objects creation using optimized tablespace configuration, PCTUSED, PCTFREE, logging, parallel mode.
  • Materialized view creation and maintenance for supporting microstrategy reports.
  • Use DBMS Scheduler and Appworx for scheduling jobs.
  • In depth experience in Business Analysis product and program management of tribune data for different channels and programs.
  • Deploy release notes and scripts into PVCS for version control.
  • Provide 2nd level production support. Analyze production problems and escalate with appropriate priorities.
  • Optimizing Microstrategy report query, testing and QA of reports.
  • Use Informatica 8.6 for data loading from Oracle 11g to Netezza database.
  • Develop complex business logic in informatica mapping using different transformations like source qualifier, expression, aggregator, lookup, joiner, router, sorters.
  • Create workflow from workflow designer using mapping parameters and variables for mappings.
  • Scheduled jobs for informatica workflow.
  • Export and import objects from xml file in repository managers in informatica.
  • Design and develop database objects, stored procedure by nzsql in Netezza database.

Environment: Linux, ER-Studio 7.6, Visio, Oracle 11i RAC, Informatica, Microstrategy, Oracle PL/SQL, Shell script, TOAD, SQL Developer, SQL Plus. PVCS, Netezza.

Confidential

Application Assistant Manager

Responsibilities:

  • Project plan, timeline communication, test plan.
  • Estimate project cost and risk analysis within timeline, budget and quality.
  • Conceptual, logical and physical data modeling using Erwin.
  • Database schema and object creation from physical models.
  • Implemented Type 1, Type2 and Type 4 concepts in physical model for historical record keeping.
  • Developed ASN.1 reader by Java API.
  • Extracted data from different sources like Oracle, ASN.1 files, XML files and Flat files implemented business logic and loaded into the target Warehouse (Oracle).
  • Created RAID Mappings with different transformations including Source Analyzer, Lookup, Filter, Normalizer. Expression, Rank, Aggregator, Stored Procedure, Look up Transformations and more.
  • Created macro and mapplets by XML for reusable transformations to use in multiple mappings.
  • Developed web interface by using XSLT and XML, CSS, JavaScript, HTML.
  • Used JSP/Servlet/ Ajax for web based search engine of configuration and reports.
  • Created data cube by RAID for pulling the data for online reporting and analysis.
  • Created different revenue control summary reports by Business Objects 6.5, such as; Master/Detail, Cross Tab and Chart (for historical and trend analysis).
  • Use of Prompts, filters, conditions, calculations, slice and dice etc.
  • Used Stored Procedures to drop/create indexes as well as disable/able constraints before/after loading the tables.
  • Implemented Materialized view for persistent data and for faster processing.
  • Implemented FTP file loader from MSC by perl script.
  • Command line coding using SQL PLUS.
  • Implemented awk, sed, grep command in shell scripting.

Environment: HP UNIX, ERWIN 4.1, Visio, JDK1.5, JSP/Servlet/Ajax, CSS, XML/XSLT, Oracle 10g, RAID ETL, Business Objects 6.1, Oracle PL/SQL, Oracle Reports, Shell script, Perl, TOAD, PL/SQL Developer, SQL Plus.Confidential

Application Assistant Manager

Responsibilities:

  • Requirement Analysis and convert into meaningful Use case using Rational Rose.
  • Logical and Physical data modeling using Erwin 4.1.
  • Design of advanced Model structures -- super/subtypes unbalanced hierarchies etc. for different level of summarized data.
  • Design and optimization of the transaction and reference data loads into the warehouse.
  • Data staging into intermediate platform before transformation.
  • Data cleaning according to business requirements.
  • Worked in bulk processing data using REF cursors, collections, DBMS packages.
  • Performance tuning - analyzing query plans and query tuning, partitioning using shell script.
  • Using Optimizer hints.
  • Working with SQL loader, Data pump, Exp/Imp, TKPROF, Oracle scheduler, Advanced Queue, Object management.
  • Used Stored Procedures to drop/create indexes as well as disable/able constraints before/after loading the tables.
  • Implemented Materialized view for persistent data and for faster processing.
  • Created reports using the Business Objects Universes, Stored Procedures as the data providers.
  • Generate pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard
  • Generated reports for web users using Web Intelligence.
  • Involved in Importing/Exporting the Universes to repository to make it available to the users
  • Used Slice and Dice, Drill Down, Filters, Master Details, Cross Tab and formulas and developed Hierarchies to support drill down reports
  • Used Web Intelligence for web based query and reporting.
  • Used XML/XSLT for customized web report
  • Scheduled the reports to be emailed to end users daily in PDF and TXT formats from Infoview
  • Gathering and analyzing user requirements, and documenting the same as per Software Development Methodology (SDM).
  • Fine Tune SQL statements for maximum efficiency using Oracle Explain Plan, SQL trace and TKPROF.
  • Dropping indexes before data insertion and creating B-tree and bitmap index after data insertion into Oracle transaction tables.
  • Dimension, fact and aggregate processing daily in the off-peak hour especially at night.
  • Creating shell script to deploy the oracle package of commission engine calculation into UNIX system.
  • Implemented Perl script for file extraction from different source systems.
  • Command line coding using SQL plus.

Environment: HP UX, Windows 2003 server, Erwin 4.1, Oracle 9i, Oracle Pl/SQL, Oracle Reports, XML, XSL, Erwin, TOAD, PL/SQL Developer, SQL Plus, Visio, Shell Script, Perl Script.

Confidential

Application Assistant Manager

Responsibilities:

  • Implemented Star Schemas while designing Universe by identifying Facts and Dimension Tables.
  • Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, apply Contexts and Alias Tables to remove cyclic dependencies
  • Created derived tables in Universe.
  • Extensively used Designer to design various universes for different business groups
  • Created Classes, Measure Objects, Dimension Objects, Detail Objects and applied Hierarchies based on Business logic.
  • Handled Embedded Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators.
  • Created complex variables, multiple breaks, sorts in the reports
  • Aided in setting up Multi-Dimensional Analysis, the Slice/Dice & Drill using the Hierarchies Editor.
  • Used Prompts in the reports as well as the Universe to create more interactive reports for the users.

Confidential

Application Assistant Manager

Responsibilities:

  • Conceptual, logical and physical data modeling by SD-PRO.
  • Gathering and analyzing user requirements, and documenting in Borland Caliber RM the same as per Software Development Methodology (SDM).
  • Converting the raw requirements into meaningful use cases, and documenting them using Rational Rose Enterprise edition and presenting in Visio.
  • Use LOV for lookup, created TAB page in Canvas for easy access.
  • Use Built-in packages for Canvas, Menu and Chart.
  • Created customized menu and wrote triggers for event handling.
  • Use form level, block level and item level triggers.
  • Use different library function of oracle forms.
  • Generating reports by Oracle Report Builder according to customized requirement from client.
  • Generating XML by Oracle PL/SQL for viewing the reports in web browser.
  • Writing test plans, test cases, and implementing test strategies.
  • Create conditional formatting reports by oracle reports.
  • Using a data model for complex query design and fitting the data into layout.
  • Created alarts and messages for error handling and warning.
  • Use parameter form for reports.
  • Design the complex layout for matrix report.
  • Created tabular, group above, group left, form like and matrix reports.
  • Used summary and formula in page and report scope.
  • Used different date and time format mask in both forms and reports.
  • Used conditional formatting in reports.
  • Wrote header and footer information in the report.

Environment: Windows 2000 server, SD-PRO, TOAD, PL/SQL Developer, Oracle 8i,Oracle Form 6i, Oracle Report 6i, Oracle Application Server, Oracle PL/SQL, SQL Loader, XML, XSLT.

We'd love your feedback!