Data Sql

EXPERIENCE SUMMARY

Over *yrs of extensive experience using Oracle, SQL, PLSQL.

3+ years of experience in DataStage-ETL tool

Working knowledge of SQL Server T-SQL.

Knowledge of SSAS OLAP, SSIS ETL packages.

Knowledge of ODI.

Knowledge of ETL best practices and industry standards.

Experience in Data modeling, Data warehousing, Data Analysis.

Good in Data warehousing concepts-Dimensions, Facts, Datamart.

Supported the data requirements of the Data Scientists who are using analytics to achieve business outcomes including insights to accelerate our Connected Customer and Connected Vehicle initiatives.

Provided the data support for enterprise data integration tasks, including ingestion, standardization, enrichment, mastering and assembly of data products for downstream applications.

Drove the Data Strategy and align it with continuously changing business landscape.

Increased Data Coverage by working closely with the Data Scientists, understanding and evaluating their data requirements and delivering the data they need.

Worked on all the data types across the enterprise including Customer, Dealer, Vehicle, Manufacturing

Promoted the concept of data sharing, data reuse, data quality and data standards.

Performed necessary data mapping, data lineage activities and document information flows

Writing of SQL complex queries, PL/SQL stored procedures and functions, Packages, Database Triggers, oracle PLSQL Cursor, Collections.

Proficient in the design and implementation of Star, Snowflake schemas and multi-dimensional modeling.

Extensively worked in Client-Server application development using Oracle 9i, 10g, 11g,12c -PL/SQL and SQL *PLUS.

Extensive experience in application data modeling and building data warehouse architecture (Star &Snowflake schemas) and ER Diagrams and Erwin data model SSMS Data model.

Extensively worked in PL/SQL for creating Stored Procedures, Database triggers, Exception handlers, Cursors, Cursor variables.

Extensively Worked on Oracle Database stage in Data warehousing technologies and ODI.

Worked in Oracle Data Integrator and Oracle Business Intelligence Enterprise Edition.

Working knowledge Toad, SQL Loader for performance tuning and database optimization. Used Spooling.

Extensively worked in writing PL/SQL stored procedures, Database triggers, Exception handlers and cursors and PL/SQL test cases.

Performance Tuning.

Experienced in working with many complex SQL queries with Joins, Functions, Cursors, Tables, and Materialized Views, Views, Sub-queries and Analytical queries to generate reports.

Expert in maintaining Data integrity using various constraints and Database triggers.

Proficient in interpersonal relations, communication, outsourcing partner teamwork and organization with excellent communication and presentation skills.

In Depth knowledge in Life Cycle Development including requirement analysis, design, development, testing and implementation.

Provided support to the testing team during System Testing, System Integration Testing (SIT) and User Acceptance testing (UAT).

Experience with UNIX OS and shell scripting, FTP.

Strong Organizational and communication skills. Experience in Agile Working environment.

TECHNICAL SUMMARY

RDBMS Oracle 10g,11g,12c, SQL Server 2012,2008

ETL Tool DataStage 7.5, ODI, SSIS, SSAS

Operating Systems UNIX, MS Windows 7,

Database Tools PLSQL Developer, SQL Developer

Languages PLSQL, T-SQL, SQL, UNIX shell scripting

Learning Experience Cloudera Hadoop

ENGAGEMENT OVERVIEW

FIAT-CHRYSLER Automobiles Mar, 2014 - Aug, 2017

Oracle Developer

Environment

Oracle 11g, SQL Server, UNIX, PLSQL, T-SQL, DataStage, SSIS, SSAS

Responsibilities

Working with Business partners, Impact assessments on existing system and technical requirement gathering, requirements for the targets systems.

Supported the data requirements of the Data Scientists who are using analytics to achieve business outcomes including insights to accelerate our Connected Customer and Connected Vehicle initiatives.

Provided the data support for enterprise data integration tasks, including ingestion, standardization, enrichment, mastering and assembly of data products for downstream applications.

Data validations on source and target tables, Report designing by Adhoc queries

Database Designing & developing and Performance analysis.

Extensively used the External Tables for data conversion in staging area before loading the data into the respective dimensional tables and fact tables

Created different schemas and maintained schema objects.

Creating and editing database tables, views, Materialized views constraints, indexes on the tables for faster retrieval of the data to enhance database performance.

Defined data base triggers & PL/SQL stored procedures for business validations.

Writing PL/SQL Stored Procedures, Functions to enforce the business rules.

Extensively used Indexes for better performance of queries.

Extensively wrote UNIX Shell scripts to automate archival, purging, production and ODS and test server’s health checks and automatic Job Scheduling.

Primary role in Implementing Data Warehousing strategies in various report modules for Chrysler.

Involved in Cron job monitoring and production support.

Working on tuning the SQL Queries for better performance.

Applying constraints and writing triggers to apply the business rules.

Performance tunings and Partitioning the fact tables and materialized views to enhance the performance.

Wrote many simple and complex ad-hoc reports using SQL Plus and PLSQL Developer for the business users. Data mapping, OLAP cube

MARKETING ASSOCIATES, Detroit Jul, 2013 – Feb, 2014

Oracle Developer

Environment

Oracle 11g, SQL Server, SSIS, ODI, UNIX, PLSQL, T-SQL

Responsibilities

Understanding the Business requirement document (BRD).

Involved in analysis and fixing tickets as part of production support.

Defined data base triggers & PL/SQL stored procedures for business validations.

Developed triggers, packages, procedures and functions using PL/SQL.

Involved on tuning the SQL Queries for better performance.

Undertook Change and Enhancements request. Applying constraints and writing triggers to apply the business rules.

Drove the Data Strategy and align it with continuously changing business landscape.

increased Data Coverage by working closely with the Data Scientists, understanding and evaluating their data requirements and delivering the data they need.

Worked on all the data types across the enterprise including Customer, Dealer, Vehicle, Manufacturing

promoted the concept of data sharing, data reuse, data quality and data standards.

Performed necessary data mapping, data lineage activities and document information flows,

Worked on Views, collections, complex stored procedures.

Database Designing & developing and Performance analysis. Developed Complex Stored Procedures.

Involved in Cron job monitoring and production support.

Automatic Job Scheduling.

Working with business partner in resolving business related issues/queries.

Database maintenance activities (Backup & Restore).

Used Oracle PLSQL.

UNIX Cron jobs for Automation.

Automated Application on Client’s request.

Created control file scripts and used SQLLDR to load data into the staging table.

Implemented complex Interface business rules using Oracle Database Triggers.

Extensively used Indexes for better performance of queries.

Extensively wrote UNIX Shell scripts to automate the data load from SQLLDR to staging table.

Used spooling

GAP INC. Apr’11-Jan’13

DataStage-Oracle Developer

Environment

IBM Information Server Web Sphere Data Stage 7.5 (Server and Sequence jobs), Oracle, SQL Server, SQL, PL/SQL, UNIX.

Responsibilities:

Used IBM Web sphere Data Stage as an ETL tool to extract data from sources like oracle and flat files and loaded to target tables.

Defined data base triggers & PL/SQL stored procedures for business validations. Used debugger to test the data flow and fix jobs.

Writing PL/SQL Stored Procedures, Functions to enforce the business rules.

Developing procedures and functions by extensive usage of Cursors and Exceptions.

Extensively used the External Tables for data conversion in staging area before loading the data into the respective dimensional tables and fact tables.

Worked on data modeling with the help of ERWIN which includes the designing of physical, logical and conceptual models.

Created different schemas and maintained schema objects. Creating and editing database tables, views, Materialized views constraints, indexes on the tables for faster retrieval of the data to enhance database performance.

Extensively wrote UNIX Shell scripts to automate the data load from SQLLDR to staging table.

Built and tested scripts, PL/SQL procedures, triggers, and functions. Used TOAD as an advanced SQL - PL/SQL editor.

Used oracle built in function DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.

As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.

Created Data Stage jobs using Designer and extracted data from various sources, transformed

Data according to the requirement and loaded into data warehouse schema.

Imported metadata definitions into the repository

Validated, scheduled, ran and monitored applications in Data Stage Director

Designed STAR Schemas using Dimensional Modeling and created fact tables and dimensional tables.

Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.

DataStage job monitoring and troubleshooting when job fails

Unit testing on enhancements

Developed new reports and customized existing according to the requirements.

Adhoc SQL Queries.

PRICOL PACKAGES Dec’09-Jan’11

DataStage Developer

Environment

Oracle 9i, DataStage 7.1, SQL

Responsibilities

Data stage job monitoring and troubleshooting when job fails

Unit testing on enhancements

Execution of reports from Crystal Enterprise.

Verification of report data from the corresponding tables

Logging the defects in Test Director.

Filtered and Loaded data from different formats of data sources into Database Tables.

Extracted required data from the database tables and exported the data to different sources in different formats.

Worked with several tools to access and perform several operations on database.

Experience in Generating Reports.

Developed Data entry, query and tuned the SQL queries.

Used joins effectively in where clauses for Query optimization.

Daily Report generation using excel macro.

EDUCATION

MASTERS IN COMPUTER APPLICATION

Contact this candidate