Sql Server Manager

Rano G.

I am on a project and not able to take phone calls. To schedule an

interview please call Mehul from my company at 732-***-**** or email

*****@********-********.***

Summary

. More than 13 years of experience as a software technologist primarily

with Sybase in challenging roles including DBA, Data Architect, Project

Manager and lead developer.

. More than 6 years of US experience in client facing roles with Fortune

500 companies and excellent communication skills.

. Database Administration of very large size Sybase ASE database servers.

. Extensive experience in performance tuning and Query Analysis.

. Experienced with Migration of Sybase to SQL Server.

. Excellent working knowledge on ASE Replication server and IQ.

. Extensive experience with Capacity Planning, Database Infrastructure

Planning with Leading Telco, Cable TV MSO s and Financial

Companies.

. Good Experience in database modeling, data warehousing and Reporting.

. Strong experience in writing stored procedure and triggers.

. Excellent in system studies and SOW and project management for large

both in telecom and finance domain.

. Client/Server development experience using GUI tool PowerBuilder.

. Team Player and follower of Agile methodology and Scrum.

Technical Summary

Hardware: SUN/SPARC ULTRA 2, IBM AIX, HP 9000

Software: SYBASE ASE 11/12/12.5/15.0, IQ, SAS, ORACLE 8.X, POSTGRESQL,

POWERBUILDER, RUBY, ANT, UNIX SHELL SCRIPT, JAVA, SPING

HIBERNATE, SUBVERSION, PERFORCE, SAS, AUTOSYS, YAML, DAC6000,PREPAID AND POSTPAID TELECOM BILLING SYSTEM (COMVERSE RTBS,

UNICORN, LEAP PLUS) EXCEL, DB ARTISAN, X-WINDOWS, C, C++, UNIX

(SOLARIS, AIX, LINUX), WINDOWS PERL, ACTIVE PERL, DOCUMENTUM,

BCP, DDL GEN, CASE TOOLS ECLIPSE.

Professional Experience

Client : American Express Nov

2010 ~ Current

Working with Risk and anti Fraud group of AMEX credit card division that

deals with the linkage of American Express client base across the various

types of accounts, products and hierarchy and finally create one unique

identifier.

Another aspect of the project is to replace the Pitney Bowes account

matching system with an in house Global New Accounts (GNA) system. Once

completed this system will be responsible for the on-line fraud and

duplicate checking system, across the whole of American Express Credit Card

Division.

Role: Sybase DBA/Architect

. Analyze and recommend scalable n-tier architecture.

. Creation of Devices, Segments and Databases on SQL server

. Backup and restoring data on SQL server as well as on Unix file

Systems

. Provided analysis report of accounts that are similar but not linked

together or duplicates, using SAS data from mainframe and MS SQL

Server..

. Created correction scripts to update the data warehouse which was a

Sybase IQ system.

. Performed a lead role in re-validating accounts with Experian using

SAS scripts mainframe and Sybase IQ for more than fifty million

accounts.

. Sybase ASE and database administration including installation,

configuration, upgrade, backup/recovery, Security, Auditing etc.

. Created OLAP cubes using MS SQL Server SSAS for further analysis by

Risk and various other groups.

. Interact with developers and provide them DBA support

. Provide DB Solutions to various departments for their projects

. Automated report generation using existing .net architecture for

management using perl.

. Automated several SAS and archiving jobs using shell scripts and cron.

. Worked with Informatica team to generate and validate the Pitney Bowes

system for authentication, Fraud detection and removal of duplicate

account.

. Created various repositories for countries where American Express is

in the business of credit card.

Environment: Sybase ASE 12.5, Sybase IQ 12.6 MS SQLSERVER 2008, SSAS,

SAS, Linux, Perl, shell.

Client : Barclays Jan 2010 ~ Oct

2010

This project was a Sybase Exodus/Migration project, for Barclays Capital

for the acquired Mortgage business from Lehman Brothers.

I had a do a detailed analysis of the servers and databases that had to be

migrated from Sybase from a list of 1500 servers worldwide. I provided a

detail effort estimate for the migration of Data, related objects and also

the applications to MS Sql Server and Oracle, so that the client had a

clear picture which RDBMS platform to choose.

The client chose MS SQL server 2008 based on our effort estimate, and we

received the whole project for migrating the Securitized Product Group

including Commercial Mortgage Backed Security business, analytics and

research.

Role: Lead Sybase Consultant/DBA

. As a Sybase consultant I had to provide a detailed effort analysis of

all code and data that needs to be migrated.

. Tested and provided the client with tools to be used for migration.

. Provided database sizing for new hardware and hardware that could be

reused.

. Prepared automated data migration tools for 25 databases.

. Fine Tuning of Sybase ASE Servers to support Legacy users.

. Migrated all database objects using tools like SSMA and SQL ways.

. Introduced freetds to run client applications on Linux connecting to

MS Sql Server without major code changes.

. Migrated 100s of perl and shell scripts to connect to MS SQL server.

. Customized datacopy to run in memory, instead of bcp saving time and

hardware usage.

. Guided the client to write ANSI standard SQLs

. Created version controlled repositories for all pre migration and post

migration scripts and codes with Perforce.

. Wrote several scripts to compare Sybase databases with MS Sql server

databases.

. Testing all migrated objects in UAT environment.

Environment: Sybase ASE 12.5, MS SQLSERVER 2008, Linux, Perl, DB

artisan, SSMA, SQL Ways, Datacopy, freebcp, shell script(Awk, Sed,

Grep), freetds, Perforce.

Client : Motorola April 2007 ~ Dec

2009

This project is on Digital Access Control of Video and Set Top Box

Provisioning in a Cable Television Environment.

The DAC6000 provides secured access control for digital video distribution

systems. It supports a wide variety of addressable functions including

IPPV, Call Ahead PPV, subscription authorizations, and interactive

applications. Most service provider billing systems are compatible through

the WireLink protocol.I was interviewed and hired by Sybase and placed in

Motorola.

Role: Sybase Consultant/Dba

. As a Sybase developer/DBA my role included performance tuning of

existing modules to achieve provisioning 5 million Set top boxes.

. Provide database backup and restore support to clients of Motorola

clients including Verizon, Comcast and Time Warner Bros.

. Installation of Adaptive Servers and Oracle Instances and their

configuration

. Creation of Devices, Segments and Databases on Adaptive Server

. Provided database resizing procedures to MSO s. and working on MOP s

with various operators.

. Automating ASE Replication agents between 2 nodes through Unix shell

scripting.

. Providing automated scripts for database maintenance and upgrade.

. Provided executive report from multiple DAC6000 systems for auditing

and revenue assurance.

. Verifying database codes submitted by developers, and performing query

optimization using SYBASE MDA tables wherever possible.

. Wrote build scripts with ANT and Maven.

. Created the infrastructure code in Ruby and YAML to check the system

health (both the OS and DB)

. Worked on enhancements and bug fixes with C code for the legacy

product.

. Working with Java, Spring and Hibernate for the next generation DAC

6000 product.

. Testing and generating performance numbers of various applications on

ASE 12.5 vs ASE 15.0.

. Used Sybase Security feature to audit event such as logins, logouts,

server boot operations, remote

. Testing and validating other RDBMS including My SQL and PostgreSql.

Environment: Sybase ASE 12.5, Sybase Replication Server, MDA, Linux,

Ruby, PostgreSql, Java, Spring, Flex, Hibernate, SVN.

Client : Telkom SA(Nigeria) April 2004 ~ March 2007

Telkom SA formerly known as Multilinks telcom operates in a rapidly growing

dynamic and vibrant wireless telecom market in Nigeria. The company started

its CDMA operation as early as 1996 but till 2004 it had a subscriber base

of less than 100k, while its competitors had subscribers in millions.

I was hired as a billing/rating manager to find avenues of increasing

revenue, and support the aggressive growth plan.

The subscriber base at the time of leaving was 1.2 million.

Role: Manager Database

. To Support end users as well as developers

. Maintain the data integrity in Adaptive Server

. Installation of Adaptive Servers and Oracle Instances and their

configuration

. Creation of Devices, Segments and Databases on Adaptive Server

. Backup and restoring databases on Adaptive Server

. Upgrading servers and migrating database in different versions of

Sybase

. Fine Tuning and Troubleshooting on Sybase Servers

. ODBC and Open Client connectivity

. Security and recovery of databases in Sybase Adaptive Server

. Implement the physical database design and ensure structure &

databases comply with standards and conversion.

. Added processes to automatically detect and eliminate fraud customers.

. Created audit control processes for database access.

. Evaluated the legacy billing system and worked with other teams to

compile a phase out and new deployment plan.

. Led the data migration project from legacy to real time prepaid

system. All the scripts were automated and parameterized.

. In charge of new tariff plans and packages to support the aggressive

growth plan.

. Trained operation teams for new cities.

. Provided scripts to automate batch jobs for MIS reporting.

Environment: Sybase 12.5, Oracle 8i, Sql/PL sql, sql navigator, toad,

C++, AIX.

Mascon Communications Limited, India June 2003

~ Apr 2004

Mascon communications was the off shore development center of Comm Works

US, which was later bought by UTSTARCOMM.

Our project included development and support of the Back end Billing and

provisioning system for the VOIP system that interfaced with the soft-

switch. This system was extensively used by MCI World Comm.

Role: Senior Database Engineer

. Fixed numerous bugs and enhanced the legacy billing system.

. Provided on call support to clients including MCI.

. Developed bulk service provisioning routine to provide the extra

services in order to interface the with the prepaid platform.

. Implemented the Radius protocol for authentication of subscribers

prior to call maturity.

Environment: Oracle 8i, Sql/PL sql, sql navigator, toad, OCI, C++,

Solaris.

1

2

UshaComm, India Feb 1999 ~ Jun 2003

Usha communications developed a telecom billing and Mediation product,

which was capable of collecting Call Detail Recods (CDR) from the

telecommunivation switch, price and finally bill the subscribers. It was a

robust product with a client base all over the world including North and

Latin America, Africa, Europe and Asia.

I joined Ushacomm (foremerly Ubest) as a software engineer and was promoted

as a manager in the support and customization team. I was directly

responsible for delivery of Change Requests and fixes to various clients.

Role: Manager

. Directly supporting clients with project deliverables.

. Managed and worked with small team developing the software using Power

Builder and Sybase.

. Preparing detailed SOW for major enhancements, as per client's

requirement.

. Implemented near real time billing features to simulate prepaid

environments.

. Implemented the Roaming module, where in the subsribers from outside

network could be authenticated and billed without changing the SIM.

. Customized the system to provide multiple service provisioning

channels for faster credit control actions.

. I was a part of the on call support team and was a SME for Sybase and

billing.

. Played a major role at Compaq lab(now HP) to provide benchmarking

results for the system on Compaq hardware.

Environment: SYBASE 11.0, Windows NT4, PowerBuilder 6.0 Db library.

1

Aditya Birla Group division Jayshree Textiles Aug

1998 ~ Feb 1999

Jayshree textiles was a part of Aditya Birla group in India. The whole

manufacturing, inventory, Accounts and receivable and payroll system had to

be computerized. I was a part of the Payroll and weaving automation team.

Role: Programmer

. As a member of the team, developed the order entry screens, and

reports of the automated weaving system.

. Also developed various MIS reports and pay slip for factory workers.

. Responsible for payslip generation of all the workers.

Environment: APT work bench, Sybase 4.9, HPUX, C and DbLibrary

Siemens Limited

Jun 1997 ~ Jul 1998

I was a part of automating the MIS department specially for the marketing

team.

Role: Programmer

. I was involved in requirement gathering from the marketing team.

. I was involved in developing the marketing information tool kit, for

the use of marketing team. It had all the detailed entries for each

order in various states of order processing. It was a widely used

system, implemented over internal WAN, where orders could be tracked

and processed from remote sites.

. Various DOS batch files were written to pull out reports and storage

of data.

Environment: Visual Basic, MS ACESS, Win NT

EDUCATION

. Training in Sybase Tuning and Performance.

. Training in Oracle 8i

. Training in Comverse Real Time Billing System

. Training in Motorola Digital Access Controller 6000

. Advanced Java training with Spring Hibernate Jdbc and OSGI

. Trained in Agile Methodology and Scrum

Contact this candidate