SUMMARY

• Professional Consultant, with extensive experience in software design and development of client/server and Internet/Intranet Database applications, under Unix, Linux and Solaris, Digital, HP - UX, VMS, DOS, Windows 95/NT/2K/XP/Vista operating systems. Actively involved in Software Development Life Cycle (SDLC)
• Strengths: Independent, Responsible, Technical Decision-Maker, Fast Learner, Lead, Team player
• Extensive experience in analyzing Functional and Business Requirements, Designing Application, Development, Integration, Deployment, Maintenance, Production Support, and Documentation.
• Extensive experience in Sybase System 15/12/11/10 like writing of Stored Procedures, Triggers, Cursors, performance tuning etc and DBA Tools like ASE, DB-Artesian, SQL Advantage and Data modeling. Strong in using all teh Sybase utilities like BCP, ISQL, and open client connectivity like SYBPERL, DBI etc.
• Extensive experience with Oracle 11g/10g/9i/8i/7.x, PL/SQL, related Utilities like SQL*Plus and SQL*Loader, ETL and MS-SQL 2000/2005/2008 , SSIS, SSRS, Visual Basic .Net/6.0/5.0, Rapid SQL, TOAD, Visual Studio 2008 etc
• Extensive Experience in writing applications using Perl, DBI for data parsing and data loading and strong in developing Unix shell scripts, setting scheduling jobs like cron /Autosys.
• Excellent experience with Data Cleansing, Data Quality, Data Warehouse, Data Migration, preparing functional and technical specifications, Test plans, Creating and maintaining Project Plans, Coordination with teh teams in teh roll out and migration process and version control tools like perforce, clear-case etc.. Good experience with C/C++ applications development.
• A very fast learner of emerging technologies, Sense of Urgency and consistently recognized for outstanding performance with teh ability to work hard & effectively both in a team as well as with business clients

TECHNICAL SKILLS

OPERATING SYSYEMS: Linux, Unix, SunOS, HP/UX 10, Digital, SCO, Citrix client, WinXP, 2K/NT/98/95, Vista

RDBMS / DBMS: Sybase 15/12/10, Oracle 11/10g/ 9i/8i/7.0, MSSQL Server 2000/ 2005/2008. MS Access, Visual Foxpro3.0/5.0, DB2

LANGUAGES: SQL, Visual Basic, Perl, CGI, JavaScript, PL/SQL, T-SQL, HTML 4.0, PHP, ASP, C/C++, C#, XML, VB.net

WEB SERVERS: Apache, Oracle Web Server, Web Sphere, IIS, Sharepoint

PROTOCOLS: TCP/IP, ftp, telnet

REPORTING TOOLS: Crystal Reports, Oracle 9i Reports, Dev2000, SSRS, Cognos, Self Developed Tools

PROFESSIONAL EXPERIENCE

Confidential, Somers, NY

Sr. Tech Lead

Responsibilities:

• Requirement and Data analysis. Involved in teh business solution discussions
• Database design and modeling Co-ordinate with plant DBAs for database server maintenance work
• Stored procedure development for new business functionalities. ETL Process design/Development and Maintenance
• Involved in critical database development for SEN, ASP, ePAD included development of stored procedures & optimization
• Enhancement of BO reports. Resolve database performance / production issues
• Write complex queries for ad-hoc business data reporting. Unit testing and System integration Testing
• Enhancement of reporting Jobs developed in Perl

Environment: Sybase, DB2, ETL, Perl, Unix, Shell script, Java, Business Objects, Autosys, StarTeam, QC

Confidential, Jersey city NJ

Senior Sybase Consultant

Responsibilities:

• Production/Client Support to various Private Wealth Management (PWM) applications especially, Account performance which looks after high net-worth clients.
• Developed scripts/queries for using T-SQL, SYBASE, PERL, Unix shell scripts, GLOSS, to resolve teh issue raised through JIRA.
• Development of debug versions of complex Sybase stored procedures to handle data issues and performance tuning
• Data presentation using excel/vba.
• Creating scan reports for those accounts which are required for specific evaluation like fees, exchange rates, account activity date changes.
• Extracting data for daily returns, monthly returns, quarterly, yearly returns, wealth ratio, accruals, flow and market price etc. which are required for accounts performance.
• Monitoring End of Day (EOD) jobs on daily basis and re-queuing/force starting if required.
• Developed common queries required to address daily issues
• Enhancement of Performance Start API stored procedures to display EOD, Non-EOD, Trade Adjustment etc.
• Additionally, working on documentation of existing functions which runs as a part of EOD and creation of run book for common issues and uploading it to team’s Wiki page.

Environment: Unix, Linux, Windows 2K/XP(Client), PERL, DBI, Sybase System 15/12.x, T-SQL, T-SQL, GLOSS, Aqua Studio, BCP, ISQL, MS Excel, MS-Office, ftp, JIRA, Autosys, CVS

Confidential, New York NY

Senior Sybase Consultant

Responsibilities:

• Actively involved in teh entire life cycle of teh project.
• Production Support to various CRM & Trading applications.
• Developed utilities of auto report creation from SYBASE database and Emailing using PERL script and Unix shell scripts. Automated jobs using AUTOSYS.
• Developed and set up MS-SQL SSIS/VB.net/ ETL jobs for data loading using Autosys.
• Developed T-SQL scripts and stored procedures, triggers and tune teh existing procedures for performances.
• CRM, One View Applications.
• Responsible for meeting with business clients, understand and interpret teh requirements, technical solutions and Production Support, guiding L2 Team and dealing with L1 team in resolving teh issues. Also worked with infrastructure teams such as DBA Ops, UNIX Ops, Autosys Ops, Win Ops etc.
• Developed / Enhanced procedures, functions, Triggers, views, for CRM contacts creation and validation.
• Developed many packages like Sales Comp Trade Adjustment, Pathfinder, Sales Entity, Soft Dollar Adjustment, SoftIR, GSS Security Master, and many more packages for setting up sync of teh data related to CRM.
• Created ETL Interfaces to send Soft Dollar Adjustment files to Sales Comp Application.
• ETL Feed Scheduler Interface for Auto Exhibition of Import files and Autosys set up for scheduling teh ETL package executions.
• Developed ETL to FTP.GZ (Zip) from UNIX to Windows environment, unzip and load to tables in SQL Server using SSIS packages.
• Actively involved in Data extract, Data Cleansing, Data Quality, Data Migration and Data Analysis
• Written scripts for data loading, table creation, data file scan, data bcp, data validations and migration of data
• Coordinated production releases, QA team, Ticket management HPSC, SN for necessary production deployment.
• Managed Level2 support team by providing technical guidance and direction.
• Shouldering teh responsibility of DQ Engine, data migration and Data Sync process.
• Enhancement/development of Sybase stored procedures to handle data issues and performance tuning
• Documentation of teh applications and troubleshooting/Run book document of production issues
• Developed and deployed SSIS packages to load data from heterogeneous sources.
• Developed VBA macros/ Pivot tables to handle data using Excel. Understanding of C# .Net, Java codes.
• Participation in running queries using DB2 databases for Market /WOD (Wall Street on Demand) feeds.

Environment: Unix, Linux, Windows 2K/XP(Client), PERL, DBI, Sybase System 15/12.x, T-SQL,MS SQL Server 2005/2008, Oracle 11g/10g/9i, T-SQL, PL/SQL, SSIS, SSRS, Infomatica, ETL, UDB-DB2, Visual Studio, Embarcado DBArtisan, Rapid SQL, SQL Advantage, Sybase Central, BCP, ISQL, MS Excel, Visual Basic, VB.net, C-Sharp, MS-VISO, MS-Office, MS-Access, ftp, Microsoft Projects, Scheduling tool, Autosys, HPSC incident management, Perforce version control, CRM, Microsoft Dynamics, Toad

Confidential, Secaucus, NJ

Senior Sybase Consultant

Responsibilities:

• Actively involved in teh entire life cycle of teh project.
• Responsible for meeting with business clients, understand and interpret teh requirements and technical solutions
• Actively involved in Data extract, Data Cleansing, Data Quality, Data Migration and Data Analysis for data related to Account Receivable, Financial data, Customers data, Shipment data, Insurance Data, Geographic data, Port Data, Job Order data, Voyage data, Inbound-Outbound Custom data under Sybase, MS-SQL and Oracle databases
• Scripts for data loading, table creation, data file scan, data bcp, data validations and data migration to stage tables.
• Worked with DBAs and carried out some of database administration tasks.
• Developed SQL scripts and stored procedures, triggers and tune teh existing procedures for performances.
• Developed data loader utilities to Extract, Transformation and Load of data (ETL) from different format like flat files or legacy databases. Using T-SQL, PL/SQL, PERL, DBI, SQL*Plus, SQL*Loader, Excel, BCP, ISQL, windows scripts, ftp developed extract, transform and initial load of teh data.
• Developed Unix Shell Scripts and scheduled cron to run Database queries from UNIX servers under Sybase and Oracle DBs.
• Developed In-house ETL utility, In-house Reporting tools, In-house Report publishing Utilities and integrated all.
• Developed technical solution in establishing source to target mapping, interfaces and scenarios using ETL tools for data population to Data Warehouse / Data Mart by studying Logical and Physical data models.
• Developed Sharepoint administrator utilities for auto creation of folders and automated report publishing.
• Developed software using Visual Basic to automatically Create Excel Reports, Pivot Table, Charts and Graphs from teh data extracted from Sybase, MS-SQL, Oracle database servers using stored procedures / SQL queries
• Designed process diagrams using MS-Visio, presentations using PowerPoint.
• Provided guidance to QA teams in creating various unit test cases and integrated test cases.
• Used clear case source control for code check in/ check out, Test Director Mercury Quality center tools for defect handling, HP service desk for service calls and TRAC System for code deployment to different environments like test, stage, production
• Worked as DBA for deploying codes to production environment using RFC (Request for Change) of HP help desk.
• Developed Sybase Server Monitoring Tools (SYSMON) Used by Sybase DBAs and operations team
• Developed DBA utilities to reset identity values while data refreshes for Sybase and SQL servers
• Developed Perl utilities for Open View Monitoring System for System Operation.
• Business KPI reports creation tools from Unix based Sybase server to Excel and automating to Sharepoint
• Managing KPI database to load teh production data for creating various business reports.
• Developed scripts to send reports through automated Email using Lotus Notes to business user.
• Developed Process automation utilities, data deployment/roll out plans using Microsoft Project

Environment: Unix, HP, Solaris, Windows 2K/XP(Client), PERL, DBI,, Sybase System 15/12.x, T-SQL,MS SQL Server 2000/2005/2008 , SSIS, SSRS, Oracle 10g Oracle 9i,, ETL, ODI, Rapid SQL, Toad, SQL * Plus, SQL * Loader, SQL Advantage, Sybase Central, BCP, ISQL, MS Excel, Visual Basic, Visual Studio, MS-VISO, MS-Office, MS-Access, ftp, Microsoft Projects, Scheduling tool, Autosys, Citrix, Apache, Crystal Reports, Cognos, Lotus Notes, PHP, HTML, Clear Case, Test Director Mercury Quality Center Tool, TRAC Deployment system, HP Help desk for Service calls, work order and RFCs.

Confidential, Hopewell, NJ

Senior Consultant

Responsibilities:

• Actively involved in teh entire life cycle of teh project.
• Collected requirements and prepare specification for populating data. Designed process diagrams using MS-Visio.
• Developed modules for connecting different databases with perl using DBI
• Involved in Data modeled design, which includes E-R Diagrams, Logical & Physical Design using Rational Rose
• Written a system in PERL (DBI) to automate data loading processes, table creation, data file scan, data bcp and data massaging and data validations and migration of data to staging tables.
• Written Stored Procedures, to map data and populate staging table.
• Developed stored proc to calculate returns based on teh financial product performance data.
• EQUITY, FIXED INCOME, MARKET INDEX and Data with MUTUAL FUND, MFA, MLIM PI, INDEX, LIPPER INDEX, MFA, MONEY FUNDS and CONSULTS Manager Data by writing Stored Procedures Data extract, Data cleansing, Data extract, Data Migration and Data Analysis of Thomson Feed
• Responsible for ftp Equity and Fixed Income data from different feeds like Morning Star, MF Feed, Thomson
• Developed data analysis modules for UPTICK for creating reports. Job Scheduling using Autosys to automate teh process
• Developed error handlers and sanity checks process for data loading.
• Responsible for migrating data from Sybase, Oracle & MS-SQL server databases.

Environment: Windows 2K(Client), PERL, DBI, Sybase System 11.x, T-SQL, MS-SQL Server 2K, Oracle 9i, DB Artesian, Rational Rose, Autosys, SQL Advantage, Sybase Central, BCP, ISQL, MS Excel, MS-VISO, ftp, Solaris