Senior Data Developer, Data Architect, Data Analyst

PUJA CHATURVEDI

Tel: +1-615-***-**** xtn - **** (US), E-Mail: ****.**********@*****.***

~ SYBASE 15.0.2 ~ SYBASE IQ 15.0.1 ~ Investment Banking Domain

Executive Summary

4.6 years Experience in Sybase ASE Database Development/ Sybase IQ/ Sybase Replication server administrations.

2 years Experience in Pentaho ETL Developement & Designing/ UNIX scripting.

Hands on experience in Installaing & configuring TIBCO Hawk.

participate in the development, enhancement and maintenance of database applications both as single contributor and as a team member

Expertise in writing jobs for uploading/extracting complex data into/from a global data environment

4 years of working with financial data on databases.

Trained in Excel and Word VBA

Attended Training on Sybase IQ Administration

NCFM Financial Module certified.

BSE (Bombay Stock Exchange) Foundation Four Day course attended in BSE – Mumbai

Prepare technical documentation for delivered functions.

Develop and unit test all the assigned code and help in the completion of system testing.

Experience of supporting a live data environment for a business critical application

Experience of working with 3rd party market data providers

Experience of complete project lifecycle execution from Requirements Analysis to Production Support

Experience of working with multi-cultural and geographically disparate teams

Documenting the data flows and business processes in order to prepare for a future re-engineering programme of the database and associated applications

Organisational Experience

Tenure Company Name Designation

20 Dec’10 – 20 May’11 EBusinessWare Senior Software Engineer

01 Jan’07 – 15 Dec’10 CLSA India Pvt Ltd - Pune Senior analyst – Research Tech

Core Competencies

Sybase ASE/IQ:

Understand, evaluate and implement tools and trends in database systems administration

Assist the project manager in preparing design specifications.

Installing Threshold Procedures for user defined and log segments

Creating and Extending user defined and log segments

Installing & Configuring ASE Server

Tuning Queries

Database Development

Perform maintenance on a weekly/monthly/ yearly basis.

Support non-production environments for both application and projects enhancements.

Worked with other departments to allow data sharing between systems

Worked with clients to determine requirements, then implemented the software and databases.

Creating and managing database objects

Monitoring and alerting

Support for User requests

Extending data, log and user segments

Troubleshooting for Database Objects

Determining cause of slow response time, Interface file Updates

Providing standardized solutions to recurring Problems/requests

Investigating the cause for job failure, Corrective action on the same

Sybase RS:

Administering DSI/RSI

Setting the table for replication

Replication from the tables

Installing & configuring Replication server

Adding Partition

Pentaho Data Integration Skills:

Creating Job which can decrypt/unzip/load the data from a file in the Sybase IQ database,

Perform any kind of ETL task,

Installing and Configuring Pentaho Kettle in UNIX/WINDOWS server, Pentaho Kettle 3.1.0 on on Red Hat Linux

ETL designing and development.

Understand Business Requirements to determine “in-scope” source data requirements

Analyze availability, quality and interdependencies of source data

o Data profiling

o Data quality analysis

o Data dependency analysis

Finance

Understanding of Middle Office and Research investment banking systems,

Good understanding of trade lifecycle.

Other Skills

Have experience in doing excellent documentation on business requirements.

Expertise in System design and development required for business process

Strong team management skill and immense ability to form and manage relationships.

Strong ability to give attention to detail and to prioritize tasks and meet deadlines.

Proven ability to analyze complex data and communicate and disseminate this information to laypeople clearly and accurately.

Great ability to plan, develop and implement research projects.

Exceptional ability to respond to information requests from management, posts and other key stakeholders as appropriate.

Initiative in keeping abreast of changing industry practices, analysis

Occupational Contour

EBusinessWare-Gurgaon Dec’10 – Dec’11

Senior Software Engineer

Project – ASE – IQ Migration

At Nomura Services Pvt.Ltd, Bombay

Nomura's Asia headquarters are located in Hong Kong.

The Asia network operates under Tokyo's strategic guidance, and co-operates with other geographical regions.

Nomura was the first Japanese securities company to establish an overseas office in 1927.

Assignment : The strategic middle office systems (SMO) support the core processing flows for the firm's business.

SMO is based on a distributed model and comprises of a number of sub systems. Reports are generated from both the main SMO system database environments. HOODINI_PRD, the main SMO database This database holds all core SMO data. This includes all transaction-related data, such as trades and positions, and all static data, such as financial instruments, accounts and organisations.

This database is replicated into PRD3 SMO_XFILES2, the 'XFiles' database This database holds key SMO data in a form more amenable for reporting.

The data is highly denormalised. The database is populated periodically through the day, with a final update during the early stages of the overnight batch.

So there was a requirement of a system which generates the report in no time and also helps in the distribution the Reports.

Job Responsibilities : To migrate all the Sybase ASE Database Objects to Sybase IQ

Tuning objects for faster Report Generation.

UNIT Testing of the Reports

Final Task is to get a sign off from a business user.

Occupational Contour

CLSA India Ltd., Pune Jan’07 – Dec'10

Senior Analyst – Research Tech

CLSA Asia-Pacific Markets is an independent brokerage and investment group. The company provides equity broking, capital markets, merger and acquisition, and asset management services to global corporate and institutional clients.

Founded in 1986 and headquartered in Hong Kong, CLSA has 1,350 staff located in 15 Asian cities, plus Dubai, London, New York and Port Louis (Mauritius). CLSA’s major shareholder is France's Credit Agricole, which merged in 2003 with Credit Lyonnais.

Project – Kettle Jobs Tuning

At CLSA India Ltd, Pune

Assignment : A data warehousing system that has its ETL process finishing right on-time is going to have a lot of problems simply because often the jobs do not get started on-time due to factors that is beyond the control of the data warehousing team. As a result, it is always an excellent idea for the data warehousing group to tune the ETL process as much as possible.

Use direct loads (e.g., place data into pre-formatted blocks, which are then written to the database),

Use parallel processes (i.e., use multiple processes to spread the CPU load amongst available CPUs)

Job responsibilities : Restructuring the hops which can increase the performance.

Log the alert message in the log file.

Inform the responsible team with the required Information only.

Try to use the inbuilt functions like unzip rather using shell scripts or Jscript.

Decouple file upload jobs from data refresh jobs.

----------------------------------------------------------------------------------------------------------------------------------------------------

Project - ASE DR Building

At CLSA India Ltd, Pune

Assignment : This involved deploying a remote failover architecture which allows a secondary datacenter to take over mission-critical operations in the event that a disaster strikes the primary datacenter.

Also a requirement of Sybase ASE as standby database which gets updated using the scheduling system to copy the production data at the DR site.

For the Easy connectivity for the applications we required the logical name for the server same as production.

Job responsibilities : Create similar mount points on the new server

Copy sybase binary files

Copy .profile file

Check connectivity to other server from the new server

Apply EBF patch for ASE

Apply EBF patch for RS

Test connectivity from WebMethods / Evaluator / Sybase Central / Local PC

Shutdown the old server

Test connectivity to Proxy tables

Copy sybase binary files from the old server to the new server

Apply License File

Then test the connectivity again and then following the same process go to the old server.

----------------------------------------------------------------------------------------------------------------------------------------------------

Project - WebMethod To Pentaho Kettle Migration

At CLSA India Ltd, Pune

Assignment : A Kettle is being used in Research IT to upload the market data sent by various vendors (Bloomberg, Reuters, MSCI...). The data transformation services mainly stored procedures executed in the database are run through Kettle.

Kettle is also used for data transfer between different databases. For example, the routine to transfer and update client data between CIS (Oracle Database) and www.clsa.com (MSSQL Server) is being done through Kettle.

Research Distribution, which basically deals with sending CLSA research to various distribution houses, is being developed in Kettle. The PDF documents send are being tagged and RiXML specification is used for sending the metadata.

Job responsibilities : Pentaho Kettle Installation and configuration

Implementing Daily Log Rotation using LOG4j.

Creating dashboard for monitoring running jobs.

Creation of Jobs & Transformations for data load.

----------------------------------------------------------------------------------------------------------------------------------------------------

Project - Implementing TIBCO HAWK

At CLSA India Ltd, Pune

Assignment : TIBCO Hawk is a tool for monitoring and managing distributed applications and operating systems.

The work required to monitor applications and systems is performed by TIBCO Hawk agents. An agent can be a rulebase, rulebase map, or schedules object.

An agent runs on each node on the network and monitors local conditions. Each agent uses collections of locally loaded rules organized into rulebases to apply monitoring logic.

A rulebases tells and agent how to monitor particular application or system resources and what actions to take when specific conditions are detected.

The TIBCO Hawk display application subscribes to alert messages generated by TIBCO Hawk rulebases and presents them in an organized view.

Job Responsibilites : TIBCO HAWK installation & configuration

At least 3 EMS should be installed and running per CLSA site on dedicated servers(Production, Monitoring & Dev/UAT)

HAWK Agent installation on each Research IT server which connects EMS server for Monitoring.

Creation of Rulebases

Setting up the TIBCO HAWK Monitoring server.

Configuration of the TIBCO EMS server

Configuration of TIBCO Repository

Configuration of TIBCO HAWK DBHMA adapter

Training & Certification

NSE Financial Module Certified;

Sybase ASE/IQ, 2007, Sybase

Advanced Excel for Financial Calculations;

Excel & Word VBA;

BSE (Bombay Stock Exchange) Foundation Four Day course attended in BSE – Mumbai;

Position Responsibilities

Provide unit tested code for all the assigned functions according to the company's IT Development & Methodologies and programming standards.

Created test environments and carrying out system testing tasks.

Execute design and detailed analysis tasks for the functions and subsystems assigned by the team lead.

Provide guidance, technical expertise and training to junior development team members.

Interfacing with clients for business gathering, conducting system analysis and finalizing technical / functional specifications and high level design documents for the project.

Coordinating system analysis for understanding internal client business processes & mapping them to required framework standards.

Suggesting appropriate as well as technology-based solutions for enhancing functional efficiency of the organisation and achieving business excellence.

Building relationships with internal clients. Engaging with them for addressing challenging issues.

Academic Credentials

2007,M.Sc. in Computer Application, Symbiosis Institute of Computer Studies & Research.

2003, B.A. in Computer Application, Rajasthan University. Majors in computers, Economics, Statistics and Psychology

2003,B.Sc.in Computer Application,Manipal University.

2000,12th,St.Edmunds[C.B.S.E].

1998, 10th, C.M.H.S[W.B.B.S.E]

Extra Activities

Member of the coordinating committee of GNUnify 2006 (National level Open Source Event organized by Symbiosis University).

Anchor of the coordinating committee of GNUnify 2006 (National level Open Source Event organized by Symbiosis University).

Won Many School level competition

Personal Dossier

Date of Birth : 22nd Aug 1982

Address : 9025, Church Street East, Brentwood, TN-37027

Languages Known : English, Hindi, Bengali, Marathi, and Tamil

Marital status : Married

Passport No. : G1081765

Contact this candidate