SQL Developer Resume Profile

Summary:

Strong 14 years of experience in all phases of software development cycle with strong and extensive experience in Data warehousing projects.
Extensively involved in Design, Development Implementation of Data-Mart solutions.
Worked End-To-End implementation of Data warehousing and Strong understanding of Data warehouse concepts, Technology using Star Schema, Snowflake Schema's and Multi-Dimensional Model's in respective to query and analysis requirements.
As a Database consultant :
Have experience working and migrating with database program logic from Sybase ASE, Sybase IQ, INFORMIX and SQL SERVER, Access to ORACLE 7.X/8i/9i/10g.
Created Packages, Procedures and functions in Sybase ASE, Sybase IQ and Oracle.
Involved in Database migrations from Sybase to Oracle and Sybase to Sybase IQ.
Worked with data profiling and data cleansing creating rules used for analysis.
Created scripts for creating tables, views and synonyms.
Worked in creating script for migration from Development, Test and Production.

As a BusinessObjects XIR3/ XI R2 / 6.1/5.1.2/4 consultant :

Created and maintained Universes, linked Universes for various data marts for facilitating different departments for ad-hoc reporting.
Created, maintained Ad-hoc reports and complex Canned reports with complex logic, multiple data providers and calculations.
Creating Web Intelligence Info View reports to publish reports on the web server and also scheduling reports.
Worked with Supervisor creating groups and users, grating selected privileges.
Have experience in migration from 6.x/ BO XI R2// BO XI R3/BO4

As an ETL consultant :

Worked as an ETL Architect designing and coding using ETL Tools like Informatica, BusinessObjects Data Integrator/Data Services, Open Source Pentaho.
Involved in evaluating and creating proof of concepts for tools like Talend, Datastage.
Involved in Developing, Testing and validation of the mappings created using almost all the Transformations.
Handled the performance issues at each phase at Design, Coding and Automating and source and target database.
Scheduled the Jobs on Time based and event based in Server.
Worked on the pre and post coding scripts that get incorporated for better performance tuning and archival process.
Worked on automating the entire process of Archival DBA activities using shell scripts and PL/SQL programming.
Write Unix/Dos programming for automation and use cron/windows schedulers to schedule Job

As a Programming consultant :

Developed ASP pages using Visual InterDev 6.0. Server side and Client side scripts were written in VBScript / JavaScript.
Have experience in Core Java programming, wrote a parser to read a xml like files and load into database.
Worked in Federal, Banking, Manufacturing, Inventory, Telecom, Logistics and Clinical Services industries.
Have experience Documentation of Implementation plan, Data Definition, Functional Documentation and Reports specification.
Strong lead skills with in business analysis, applications programming and trouble shooting.
Self-motivated, excellent written/verbal communication, leadership and team work skills.

Skills:

Architecture: Data Migration, Data Conversion, Data Warehousing, Database
Design and Integration
Databases: Oracle, SQL Server, Informix, Sybase ASE, SyabaseIQ Access,
, Sybase IQ,MYSQL and Teradata
Operating Systems: Windows, UNIX
Programming Languages: SQL, Visual Basic, ASP, JavaScript, HTML, C, Java Core only
BI Tools: BusinessObjects, Informatica, Oracle Express, Pentaho, Cognos, Datastage,