Sr SAS Developer & Analyst

Huseni Kathiria - http://www.linkedin.com/in/husenikathiria

Email: ******.********@*****.***

Cell: 425-***-****

Place: Burbank, CA

Skills/Experience levels:

Database development Expert

Unix Shell scripts AWK, SED Expert

Autosys Expert

Transact-SQL Expert

C++ Expert

Core java, PERL Intermediate

EDUCATION:

• B.E. Computer Science & Engineering from MSEC, MK University, Madurai.2003

Other Skills:

• Primary Skills: C++, Sybase Adaptive Server Enterprise 12.5, 15.03

• Client/Server Technologies: Sybase Open Client/Server 2.3 for C++, One Bridge Enterprise

Mobileware 5.5 and API’s, MobileDataForce PointSync 4.0, Application EAServer 4.2.2

• Framework: Data Palette architecture, .NET 7.0 CLR

• Operating Systems: Windows 2000/XP, Linux 10.0, Sun OS 5.8, Vx-Works 3.0, Qnx

• Programming Languages: C++, Core JAVA, SYBASE Transact-SQL, Autosys JIL

• Development Tools & Utilities: GNU, MS Visual 7.0, E-biz Impact Tran 10.0, X-Lite, SJPhone,

Alteris Virtualization Layer, FilZilla, CISCO VPN, Citrix, Active Sync, DBArtasian 8.5, Rapid SQL 8.0, PC Client 4.0, Advantage 12.5, Sybase central 4.5, MS Project Management 2003, Autosys 4.5, SYBASE Power Designer 12.5, GNU utilities, Tibco Hawk, Share point, Microsoft Visio 2003,Netcool,Falcon

• Scripting Languages: HTML, Java Script, Shell script, Awk, Sed

• RDBMS: Sybase ASE 12.5.4, 15.03, Oracle 9i, ASAnywhere 10.0

• Protocol Tools: SIP, SS7, MGCP, ISUP, TDS, Ethereal Protocol Analyzer 0.1

Summary:

• Professional with above 6 years of strong work experience in software development, enhancement, maintenance, implementation, coding, unit testing and performance tuning on UNIX/Solaris/AIX/LINUX Platforms.

• Work exposure on Sybase database modeling, integration, batch processing and scripting for DSS/OLTP environment.

• Contributing in database tuning, performance enhancement and report generation using Actuate/Business Objects tool

• Implementing kerberization for system security and integrating multiple CRM applications from backend in batch processing.

• Experience on Database re-engineering, designing for application data flow and architecting system integration for backend systems.

• Experience on system analysis, impact analysis, root cause analysis & debugging code for up gradation additional functionality.

• Deft at implementing DB maintenance activities including Archiving, backup and recovery, ASE server provisioning, EBF provisioning, Data sub-setting POC, UAT maintenance, Data centre Automation using Data palette framework.

• Involved in writing various monitoring tools including file watchers, data processing and log monitoring scripts, TIBCO Hawk rules based implementations.

• Review the batch failures and liaise with support teams on resolution of issues.

• Detail analysis of historical results on batch jobs to identify and escalate concerning trends.

• Scheduling up new release implementation in production environment.

• Carrying out pre/post implementation tests.

• Experience on Custom applications development, TIBCO Hawk micro agent implementation, and Remote DB access layer and proxy DB configurations.

• Conceptual understanding of Replication server 12.5(warm standby implementation).

• Hands-on experience on Prime brokerage, Prime financing, Capital markets applications, Equity/Quantitative analytics, Data maintenance, Rates/Credit Derivatives applications.

Job History:

Employer: CapGemini Dec 2009 – Oct 2010

Position: Senior Consultant

Clients Included: Morgan Stanley, US

Project Title: List Manager, Dashboard, Vote Gathering System, Client tracker

Details:

This project is targeted to create new database systems; integrating and synchronizing data from various upstream/downstream CRM applications, implementing data extract and load for reporting using process engineering through autosys jobs and controlling their data flow

Accountabilities:

• Involved in requirement analysis and database modeling for synching multiple apps integrations.

• Designing and coding database components & scripts for monitoring systems, generating alerts to any outage or failure to Dev/support team with the appropriate actions.

• Involved in creating DFD and process workflow for the scripts and provisioning of Sybase table/views to loader.

• Automating various activities for data reconciliation and building the system.

Environment: Sybase T-SQL, Falcon, IBM Netcool, Shell scripts Awk, Sed, Perl

Employer: Websym Technologies Sep 2009 - Dec 2009

Position: Senior Sybase Engineer

Clients Included: Stratavia Corp, US

Project Title: Data Centre Automation SOP implementation for Sybase ASE 12.5,15.0

Details:

The project is targeted to create the Standardization of Process and workflow which can help the enterprise systems to automate their daily routine task efficiently and potentially reduce the cost of adhoc infrastructure and systems setup, maintenance and offload the DBA dependencies in high volume, high volume transactional and critical trading system.

Accountabilities:

• Involved in creating the Sybase solution pack, which includes Sybase ASE provisioning, EBF installations and rollback, server startup/shutdown, transaction loads/dumps, transaction log management. Database login management, Device and space management on multiple OS.

• Experience in writing/debugging Stored Procedures to performing certain tasks, perform unit test deploying them in various test environment.

• Involved in Data sub setting for Sybase ASE 12.5 and designed the Spec for deploying

• Involved in creating the workflow and provisioning of Sybase synchronous bidirectional Replication server with warm stand by setup.

• Involved in System enhancement, Design and Development activities, investigation and fixing of production problems.

• Involving in creating workflow for various DBA activities and test them in ASE 12.5, ASE 15.

• Involved in setting up Remote Proxy Database servers.

Environment: Sybase T-SQL, Data Palette Framework, UNIX Shell scripts, Awk, Sed

Employer: Lehman Brother May 2009 – Sep 2009

Position: Senior Developer

Clients Included: Lehman Brothers quantitative analytics, UK

Project Title: Pre-Post TradeSpex Execution Review trading system

Details:

This is the trading analytical application essentially used by traders to compute the profitability’s in their customized portfolio and make appropriate decisions for the trading on daily basis.

Accountabilities:

• Analyzing Slow running applications and query tuning, configuration and database schema changes.

• Involved in process Automation, job scheduling and implementation of Tibco Hawkrules for production systems.

• Requirement analysis, designing workflow, writing database components.

• Database modeling, backend application integration and maintaining batch code base.

• Analyzing Slow running applications and query tuning, configuration and database schema changes.

• Fixing various data integrity issues, Bloomberg data refreshes monthly and intra month index changes and any other issues raised or identified during overnight/intraday batch cycles and updating the code for stored procedures and relevant database objects

Environment: Sybase T-SQL, TIBCO Hawks, XML, Unix Shell scripts Awk, Sed, C++, Core Java, Autosys 4.5, CVS 1.11

Employer: Lehman Brothers Apr 2008 – Apr 2009

Position: Senior Developer

Clients Included: Lehman Brothers Prime Brokerage and security Landing, US

Project Title: PrimeDB, Prime Client Reporting, Geneva portfolio accounting system

Details:

• This is Data warehouse application, which essentially acts as a source of data provider for various down stream systems for calculating portfolio and generating the Prime client reports.

Accountabilities:

• Worked on various database related issues like concurrency, contentions database locking and query optimizing, concurrency and database consistency checks.

• Configuring and deploying various Autosys jobs for data massaging, portfolio profit/loss calculations and monitoring ongoing business applications.

• Supporting various business queries related to PrimeWareHouse, Prime transaction manager and Geneva Portfolio Accounting systems.

• Involved in System enhancement, Legacy system migration to support new applications.

Environment: Sybase T-SQL, Shell scripts Awk, Sed, Autosys, Perforce, Actuates 4.5

Employer: Syabse Inc Apr 2007 – Apr 2008

Position Sybase Consultant

Clients Included: Nielsen Media Research, Florida, US

Project Title: Add*Sentry, Add*Views

Details:

The project is to collect the data from different advertisement sponsored by different

Brand companies through various media like TV, News paper, Magazines, Internet, etc., for various products. These data’s are of different format stored in Shelton. These data will get processed and the relevant data will be extracted and supplied to Nielsen’s client for market research.

Accountabilities:

• Gathering & conducting requirement analysis for new media development and enhancement of the legacy facility in Adviews.Coding and debugging various data load process into backend systems & improving the efficiency of backend performance.

• Database modeling and application integration.

• Resolving the change request for the data validation/verification and modifying the to backend procedures.

• Monitoring weekly Loads and extract process.

• Generating weekly and monthly statistic reports for the Nielsen Client’s to identify the business in progress and impacts of advertisement in industry.

Environment: C++, Java, Sun OS 5.8, Unix Shell Scripts, SYBASE ASE 12.5, Autosys 4.5, CVS 1.11, CronTab utility

Employer : Syabse Inc Apr 2006 – Mar 2007

Position : Associate Consultant

Clients Included: GM Motors, UK

Project Title : GM Exchange Hub

Details:

Sybase has deployed its GM Exchange Hub to act as a data gateway and state engine to facilitate data exchange between the legacy dealership’s DCS2 communications server and See Beyond component. This an application level protocol which can help GM to receive details of inventories, warranties, accept the orders and draw different invoices from their various dealers across Europe and vice.

Accountabilities:

• State Engine design and development module for Exchange Hub.

• Production monitoring and writing log analyzer to track the Issues causing the wait for the next coming threads into a Run Queue and synchronize them.

Environment: C++, Solaris 5.8, Sybase ASE 12.5.2, EAServer 4.2.2(Apps server)

Research Project – Mindwell Solutions Feb 2004 – Mar 2006

Software Engineer

Message Redirection System

Details:

KMR (Kernel Message Redirection) is the core redirection & transaction application utility. The term redirection highlights the concept of kernel message redirection over serial (UART). The scope of the project is that Linux OS will be running on Xeon processor, which doesn’t possess any console, connected to another Linux machine

via serial. This module deals with analyzing, controlling and managing the system and querying the system’s health or related information. Each & every boot up messages is Used for debugging & monitoring it.

Accountabilities:

• Involved in developing the methods which setup’s the priority level of kernel message, finding the current priority level, redirection of kernel message.

• Reading the Message queue from the port and display the kernel messages.

• Worked on a module which separates the kernel-generated messages & Application generated messages.

• Regression testing, writing & running scripts & maintenance of code

Environment: C++, Linux Suse 12

Contact this candidate