We provide IT Staff Augmentation Services!

Data Warehousing Resume Profile

Summary:

  • Excellent written and verbal communication skills, has clear understanding of business procedures and ability to work as an individual and as a part of a team
  • Strong technical skills coupled with creative problem-solving skills.
  • Migration of Sybase 12.5.4 to Sybase 15.7
  • Expertise in Documentation of Design Specification documents, Requirements gathering and testing documentation
  • In-Depth Knowledge in Data Migration and Client-Server / Three-tier architecture
  • 2 years of experience in C GUI tool Presenter.
  • Over two years experience in ERWin CASE tool.
  • Experienced in Windows 2000/NT, Open VMS UNIX, HP/AIX, Sun Solaris and UNIX Shell environments.
  • 24X7 Production Database On Call Support.
  • Extensive experience with data loading BCP tool.
  • Extensive experience with Cron and Autosys job scheduler
  • Excellent skills in working with UNIX shell scripts. Developed shell scripts for process automation, feed file integrity checks, FTP activities using commands like find, grep, pipe, cut, redirection and utilities like awk and sed.
  • Expertise in writing SQL in Transact SQL.
  • Good knowledge in using Views, Indexes, JOINS and Sub-Queries, Cursors
  • Extensive experience in server level programming Triggers, Procedures in SYBASE ASE.
  • Extensive experience in Capacity planning, Disaster Recovery and Trouble shooting.
  • Extensive experience in space allocation, database migrations and database security.
  • Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, testing, training, production support and Project review with client.
  • Strong experience in working with large volume databases with involves performance tuning and transaction based processing.
  • Excellent knowledge in SYBASE Adaptive server enterprise.
  • Over twelve years of experience in Data-Analysis, Design, Development, Testing, Debugging, Documentation, Release Management, Production Support Databases.
  • Good exposure of performing Root Cause Analysis for the production issues and deliver fix for them.
  • Recognized for my professional excellence by my employer with Best Project Award.
  • Vast experience with Level 2 Level 3 production support, involving resolution of issues escalated to development team.
  • Experience with ITIL concepts and best practices
  • Experience with Agile development methodologies

IT Skills

Skill Type

Skill Name

Proficiency

Last Used

Years of Experience

Database

Sybase ASE 15.7 12.5

High

current

10

SQL Server

Medium

2 years

1

Data Modeling tool

Erwin

Medium

current

5

Language

Unix Scripting

High

current

5

C , Pascal

Medium

2 years

1

OS

Windows NT, Windows 95/98

High

current

7

Sun Solaris, HP-UX Open VMS

Medium

current

4

Version Controlling Tools

SVN VSS

Medium

current

5

Other

Ftp- Import/Export, AWK, APT Work Bench, DWB, Presenter, JIRA, Service Now, Change Point Remedy

Medium

current

5

DBA Tool

DBArtisan, TOAD, PL SQL Developer, ASE Isql

High

current

5

PROJECT UNDERTAKEN

Confidential

Job profile: Worked as Sybase developer cum DBA for The Publishing Control System, PCS is a distributed business system supporting the information needs of Marketing, Editorial, Art Design, Production, Inventory, Manufacturing, and Business Management. PCS contains 12 applications that automate various stages of publishing business flow. These applications process product and business information to support tactical and strategic functions of the target business unit.

RESPONSIBILITIES:

  • Writing Query's, stored Procedures, View, Triggers, Cursors and database objects.
  • 24 7 production support.
  • Performance tuning of existing SQL and Stored procedure running slow in production.
  • Daily job monitoring for feed received from different systems
  • Designed and developed T-SQL scripts to filter data from various sources.
  • Process automation using UNIX shell scripts for handling feed, pre-processing of data before importing or exporting of data in various downstream system.
  • Database performance monitoring using Ignite DBArtisan.
  • L2 L3 support of Applications.
  • Supporting on-site DBA Team in their day-to-day object mgmt
  • Design and development of the workflow program and handling various phases of application development.
  • Backup and Restore in Development as well as UAT Instances.
  • Responsible for Managing Development and UAT Database Servers.
  • Smooth implementation and testing of the application and extend post go-live application support.
  • Development of Module using scrum.
  • Point of contact for the offshore team.
  • Migration of Solaris server from one hardware platform to another higher version hardware platform.
  • Migration of Sybase server from 12.5.4 to 15.7.

Environment: Sybase 15.7, 12.5 Adaptive Server on Sun Machine, DBArtisan, SVN

Skills Developed: Sybase ASE 12.5 , ER-WIN, Project Management, Sql Server 2000

Confidential

Responsible for designing, development and deployment of applications. Interviewed the various users and collected the data and prepare the requirement document. Draw E-R diagrams and then normalized the database tables. Wrote scripts to initialize the database devices and created the databases and tables. Improve the system performance and remove the major bottlenecks. Developed user interfaces using Sybase APT and wrote several output report programs using db-lib,'C'.

RESPONSIBILITIES:

  • Responsible for the SYBASE 12.5 database administration
  • Installed Sybase test server.
  • Managed disk storage
  • Set up user accounts, granted permissions to users, created user DB's and granting ownership's Transferred data between SQL server and other programs
  • Backup and restore data in case of failures and crashes.
  • Diagnose system problems and fine tune the database.
  • Involved in creating database, tables, indexes, rules, triggers, and stored procedures
  • Developed and implemented the Payroll system which took care of all the process from time entry to leave management.
  • Normalized the database tables and developed the user interfaces.
  • Wrote several stored procedures and triggers.
  • Wrote scripts to create indexes defaults, rules and assigning roles to the different users.
  • Built the interface between this system and financial management system.
  • Implemented the system and gave training to the users and made changes according to the users' requirements after the implementation.
  • Developed user interfaces using APT and wrote several output report programs

SKILLS DEVELOPED: Sybase Developer/DBA, Sybase Performance Tuning, awk, db-lib, UNIX shell programming

OTHER PROJECTS

Confidential

  • Technologies : Sybase 12.5 , ASE ISQL Tool, Presenter, C
  • Scope : Automate the Purchase Order approval based on the Buyer's define limits.
  • Participate and prepare design documents for product development. Write Scripts, Stored Procedures, Rules, and Triggers

Confidential

  • Technologies : Sybase 11.5 under HP-UX 10.02. With T-SQL
  • Scope : Generate various kind of report required by the Business.
  • Sr Developer, involve in Analysis, Design, Coding, Testing and Implementation.

Confidential

  • Technologies : Sybase 11.5 Under HP-UX 10.02. with T-SQL
  • Scope : The PMS is divided into four categories, Staff Payroll System, Worker Payroll System, Leave System Workers Staff P.F. System Staff Workers .
  • Analysis, Design Development.

Confidential

  • Technologies : Sybase 11.5 under HP-UX 10.02. with T-SQL
  • Scope : Upload the data from various system for generation of different reports for Business and Quality reporting.
  • Design Development.

Confidential

  • Technologies : Sybase 11.5. with T-SQL
  • Description : D.P.S. basically deals with the packing of denim cloths and defects in final product. This system comprises daily, monthly, quarterly packing of denim.
  • Analysis, Design Development.

Confidential

Technologies : Sybase 11.5 under HP-UX 10.02 with T-SQL

Confidential

Technologies :Sybase 11.5 Under HP-UX 10.02. With T-SQL

Hire Now