We provide IT Staff Augmentation Services!

Data Specialist Resume Profile

PROFILE:

  • 12 years of Oracle experience
  • 12 years of PL/SQL Programming experience
  • 6 years of DW experience using Oracle Warehouse Builder/ Informatica

SUMMARY:

  • Total IT: 12 years of IT Experience with of Oracle Development experience including analysis, modeling, design, administration and maintenance of Oracle Database systems on both UNIX and NT platforms.
  • Oracle: 12 years of solid database experience on Oracle 10G/9i/8i/8.0/7.3, DBArtisan 5.1, SQL Loader, Physical database design, Logical database design, Data Modeling Designer 2000 , Gap Analysis, Data Mapping, Cleansing, Massaging, Transformations, Data Exports Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User Security Management, Oracle Tuning Optimization.
  • Reports: 6 years of strong front-end programming experience using Oracle Forms 6i/5.0/4.5, Oracle Reports 6i/3/2.5, Oracle Report Writer, Oracle Developer 2000, SQR 3.0, Crystal Reports and Oracle Discoverer.
  • Database: 12 years of Database experience working on Oracle Warehouse Builder, Oracle 10g/9i/8i/8.0/7.3, SQL Server 2000/7.0/6.5, IBM DB2 8.0/7.0, Teradata V2R5/V2R4, MS Access.
  • Programming: 12 years of strong back-end programming experience using PL/SQL, SQL, MS SQL, SQL Loader, SQL Plus, TOAD, T-SQL, Pro C, C, C , Java, VB, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
  • UNIX: 8 years of UNIX experience on Unix Shell Scripting, CGI/PERL, Pro C, Autosys, Clearcase, Sun Solaris, Windows 2000, Windows NT 4.0, Windows 98/95/3.1, MS DOS 6.22, Novell Netware, IBM Compatibles, Sun Classic, Sun Sparc Sun Ultra.

TECHNICAL SKILLS:

Oracle

Oracle 10g/9i/8i/8.x/7.x, Oracle Forms 4.5/5.0/6i, Reports 6i/3/2.5, Database Design both Physical and Logical , Database Modeling Designer 2000 , Data Exports Imports, Inbound/Outbound Interfaces, Performance Tuning, Administration, Software Maintenance, User Security Management, Query Optimization, Export/Import Utilities

Databases

MS SQL Server 2005/2000, Sybase SQL Server, DB2, Teradata

DW and BI tools

Oracle Warehouse Builder 10.1/9i, Manual ETL, UNIX Shell Scripting, Informatica power Center, Power Mart, Power Plug, Power Connect, Data Mining, Data mart, OLTP, OLAP, Main frames, Cognos Series 7.0/6.0 Impromptu PowerPlay , Business Objects 6.5/6.0/5.0.

Programming

SQL, PL/SQL, MSQL, Unix Shell Scripting, SQL Loader, SQL Plus, Discoverer, Pro C, Pro C , C, C , Java 2.0/1.2, XML, XSD, SOAP, WSDL, Siebel Prolog, Haskell, PASCAL, HTML 4.0, FORTRAN, Assembly Language 8085/8086

Environment

Sun Solaris 2.6, Sun OS, MS DOS 6.22, Windows 3.x/95/98/2000, Windows NT 4.0, IBM compatibles, Red Hat Linux, SUN Sparc, Sun Classic, Sun Ultra, DOS, Windows 98/NT/2000/XP, SUN Solaris 2.5/5.6 Unix and Linux

PROFESSIONAL EXPERIENCE:

Confidential

Data Specialist

Responsibilities:

  • Writing sql queries and PL/SQL code for updating the existing and new database tables.
  • Involves performance tuning of the existing code for improving performance of the scripts.
  • Writing custom PL/SQL code to for loading data, in initial load and incremental scenarios.
  • Created documents with step by step instruction for data archiving and masking the data.
  • Unit testing and promotion of code into QA and Production.
  • Uploading data into production using sqlldr scripts.
  • Writing korn shell scripts to execute different processes keeping dependencies in mind.

Confidential

Sr ETL Developer

Responsibilities:

  • Developed mappings to capture the incremental changes and as well as store history.
  • Created mappings for extracting data from various Sources into Repository, Repository to Data mart/ ODS.
  • Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL Loader and PL/SQL.
  • Version Control and Code migration was performed.
  • Applied Day forward logic on Data mart for fact and Dimensions to capture the daily changes.
  • Worked with DBA for analyzing Performance tuning techniques such as indexes, partition etc.
  • Developed synonyms, Views and Materialized Views for transformation requirements.
  • Used functions and Procedures to cater to Business Requirements.
  • Created Workflows and sessions to run the mappings and send emails.
  • Used Workflow Monitor for monitoring.
  • Analyzed complex workflows and identified root cause and provide resolutions
  • Created shell scripts for integrating processes and adding pre and post processes to the workflow.

Confidential

Sr. DWH Informatica Developer

Responsibilities:

  • Used Oracle Data Masking pack for masking Sensitive data across the database.
  • Identify prioritize sensitive data within a table based on user input.
  • Implemented masking using Enterprise Manager 11g.
  • Created masking rules to be implemented across 8 databases.
  • Designing of schema included dimensions, relational and fact table.
  • In depth knowledge of Informatica 9.0 Powercenter architecture as a developer.
  • Experience in designing and developing of mappings, transformations, sessions and workflows in PowerCenter
  • Developed mappings to capture the incremental changes and as well as store history.
  • Created mappings for extracting data from various Sources into Repository, Repository to Data mart/ ODS.
  • Strong knowledge of coding in and troubleshooting SQL and PL/SQL.
  • Used Agile Development methodologies.
  • Did systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
  • Used the warehouse metadata, naming standards and warehouse standards for future application development.
  • Developed synonyms, Views and Materialized Views for transformation requirements.
  • Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL Loader and PL/SQL.
  • Coordinated with source system owners, monitored day-to-day ETL progress, performed Data warehouse target schema Design Star Schema and maintenance.
  • Used Maestro Tivoli Job Scheduling software to schedule jobs.
  • Used ITEAM for creating Maestro Stubbs used in the scheduling of Jobs.
  • Production support and off hours pager rotation.

Enviornment: Oracle 11g, IBM Netezza 6.0, Sql server 2008 R2, Informatica 9.0, Toad, IBM Tivoli Workload Scheduler 8.0 , ITeam, Unix, Cognos.

Confidential

Sr. BI/DWH Oracle Developer

Responsibilities:

  • Gathering Requirements and preparing Requirement Documents.
  • Did systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
  • Used the warehouse metadata, naming standards and warehouse standards for future application development.
  • Designing of schema included dimensions, relational and fact table.
  • Data cleansing and Data profiling using Trillium for better quality.
  • Developed mappings to capture the incremental changes and as well as store history.
  • Created mappings for extracting data from various Sources into Repository, Repository to Data mart/ ODS.
  • Data was extracted from Flat files, SAP, Oracle and Sql server and loaded into SAP environment.
  • OBIEE Repository design, development and maintenance.
  • Building Reports and Dashboards using Oracle Answers
  • Developed Fact for analyzing the measures.
  • Applied Day forward logic on Data mart for fact to capture the daily changes.
  • Used UNIX scripting to create a process flow for executing various steps to load data into the staging tables to Data mart.

Enviornment: Oracle 10g, SAP R/3 Enterprise Release 4.6C, Sql server 2006, Informatica 8.6, Toad, Red hat Linux, OBIEE.

Confidential

LEAD ETL DEVELOPER

Responsibilities:

  • Installed and configured OWB Client Server architecture for POC, Development, UAT and Production
  • Worked with the DBA to setup OHS connectors for connecting to HS sources using third party connectors for accessing SQL Server, AS400 and Sybase.
  • Extracted data from heterogeneous data sources such as AS400, SQL Server, Oracle, Excel sheets, Flat files for loading them into target tables.
  • Did systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
  • Used the warehouse metadata, naming standards and warehouse standards for future application development.
  • Designing of schema included dimensions, relational and fact table.
  • Data cleansing and Data profiling for better quality.
  • Developed mappings to capture the incremental changes and as well as store history.
  • Created mappings for extracting data from various Sources into Repository, Repository to Data mart/ ODS.
  • Worked on several complex mappings.
  • Developed Fact for analyzing the measures.
  • Applied Day forward logic on Data mart for fact to capture the daily changes.
  • Worked with DBA for analyzing Performance tuning techniques such as indexes, partition etc.
  • Developed synonyms, Views and Materialized Views for transformation requirements.
  • Used functions and Procedures to cater to Business Requirements.
  • Created process flows and added procedure to populate tables.
  • Installed Workflow server 2.6.4 and monitor for thorough monitoring of process flows.
  • Created scripts for scheduling Job using DBMS Job Scheduling.

Enviornment: Oracle 10g, OWB 10.2, AS400, Sybase , Sql server 2006, Informatica 8.6, Toad, Unix, ITeam, Cognos

Confidential

DW ETL ARCHITECT

Responsibilities:

  • Extracted data from heterogeneous data sources for loading them into target tables.
  • Used Change Data Capture and Partition Exchange for near real time data access thus enabling access to an updated Data Warehouse several times during a day
  • Designing of schema included dimensions, relational and fact table.
  • Data cleansing and Data profiling for better quality.
  • Developed mappings to capture the incremental changes and as well as store history.
  • Developed Fact for analyzing the measures.
  • Did systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
  • Used the warehouse metadata, naming standards and warehouse standards for future application development.
  • Developed synonyms, Views and Materialized Views for transformation requirements.
  • Procedures for creating udd's, udf's and udg's in the post mapping process of process flows.
  • Designed the mappings to capture multiple updates with the same business key in the same load from CDC for implementing SCD type 2 logic.
  • Created process flows and added procedure to populate tables according to the udd's, udf's and udg's.
  • Performance Tuning was done at mapping, session and workflow level.
  • Cache memory was
  • Setup smtp server service from Oracle 10g database for syncing it with the company's mailing system.
  • OBIEE Repository design, development and maintenance.
  • Building Reports and Dashboards using Oracle Answers
  • Installation of Delivers for iBots, Caching etc.
  • Creating scheduling iBots according to user requirements.
  • Cache Management using iBots and manual caching.

Enviornment: Oracle 10g, 9i, OWB 10.2, Sql server 2004, Informatica 8.6, 7, Toad, Unix, OBIEE, Revenue DM 1.0.

Confidential

DW PL/SQL Developer

Responsibilities:

  • Reengineer the Data Warehouse to enable new capabilities such as Change Data Capture and Partition Exchange for near real time data access thus enabling access to an updated Data Warehouse several times during a day.
  • Worked with IT staff to build 8 Star Schema's and 22 Dimensions using Oracle Warehouse Builder Release 2 for the implementation of client data warehouses. Provide Support during the migration of mappings from one environment to another.
  • Responsible for systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • ETL Migration process from legacy scripts to Oracle warehouse Builder 10.2/10.1.
  • Created Oracle PL/SQL queries and Stored Procedures.
  • Worked on data loads using Oracle PL/SQL and SQL Loader.
  • Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
  • Researched Sources and identified necessary Business Components for Analysis.
  • Involved in Data Quality Analysis to determine cleansing requirements.
  • Designed and developed Oracle Warehouse Builder mappings for data loads.
  • Writing PL/SQL code using the technical and functional specifications.
  • Implemented Explain Plan and SQL Trace for improving the performance of SQL queries.
  • Tuned most of the queries and drastically reduced the response time to less than 6 seconds.
  • Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL Loader and PL/SQL.
  • Coordinated with source system owners, monitored day-to-day ETL progress, performed Data warehouse target schema Design Star Schema and maintenance.
  • Generated reports using Crystal Reports.
  • Provided production support by monitoring the processes running daily.

Environment: Oracle Warehouse Builder 10.2/10.1, Oracle 10g/9i, PL/SQL, SQL Loader, Toad, Seibel Analytics, HTML, XML, SQL Plus, SQL Developer, SQL, Crystal Reports, JAVA, Visual Basic 6.0, Red hat Linux, Kintian, PVCS Version Management, Mercury Quality Center 6.0, Developer 2000 Forms5.0, Reports 3.0 , Control M

Hire Now