• Over 16 years of experience of Database development, DataAnalysis,and Databasedesign.
• Worked 8 years in Health Care, 4 years Finance, 4 years manufacturing.
• Strong experience in developing Stored Procedures, Transact SQL queries, Triggers, rules, defaults and Performance tuning of SQL queries in T-SQLSybase ASE 11.9/12.0/12.5, SQL server 2005 and Oracle.
• Currently working on MongoDB , node.js Javascript , and MYSQL.
• Worked on various RDBMS ORACLE 11g, MYSQL, MS SQL Server 2005 and Sybase.
• Used SAS 8.0 and 9.0 to create data transfer files in SAS dataset format. Developed macro to create datasets and support other functionality.
• Expertise in developing scripts for automated data feed/ transform /querying using Perl, UNIX shell and awk.
• Worked on SFDC SalesForceDotCom as system administrator, developer and business analyst
• Supported and Enhanced BI application and created KPI reports usingSFDC and Excel.
• Enhanced and Supported Invoice system in SFDC.
• Ability to work independently as well as with teams in challenging environment.
• Demonstrated ability to quickly and accurately analyze, troubleshoot, and solve complex technical problems.
• Excellent understanding of business applications like Finance, Clinical Trial and MRP-II software packages.
• Worked on various RDBMS ORACLE 11g and SQL Server 2005. and versions of Sybase like 10.x AIX 11.x Sun Solaris , 12.x Sun .Solaris , 12.5.1 Linux ,
• Excellent understanding of OLTP/OLAP/Batch Processing application
• Good understanding of BI requirements and created various reports using Excel spread sheet and it features like Pivottables, lookups, data validation, formulas and Macros.
• Good understanding of Tools like SAP Business Object 3.0 4.0 universe, web rich client, IDT information Design tool , SAS 8.0 and 9.0 .
• Supported SYBASE and MS-SQL DBA role

• Databases: ORACLE PL SQL , SAS 8.0 , Sybase 12.0 / 12.5 T-SQL ,
• MS SQL Server 2005 Transact SQL , MYSQL, MongoDB
• Programming Tools: SFDC APEX, VisualForce Pages ,PERL, Unix Shell, AWK,
• Node.js Javascript , Excel, ASP pages, SAP Business Objects
• Operating System: Linux, Cygwin, Solaris 2.8, AIXUNIX
• Other: Working knowledge of C/C , Java, VB

Responsibilities:

• Analyze customer data and requirements.
• Create data mapping in Boomi ETL.
• Transform data and load into Boomi ETL.
• Perform data quality checks and create opportunities in Mongo DB.
• Develop script for data transformation and data quality check.
• Create automated process for daily data load and quality checks.
• Create report to reconcile data, automated booking report, data issues and quarterly revenue report.
• Coordinate with client on weekly basis and toresolve data issues.

Environment : Mongo DB, Node, Java script, MySQL, MSSQL,Boomi, and PERL.

Responsibilities:

• Understand existing process and develop utility scripts to automate process in UNIX and PERL.
• Develop SAS macro to convert data in SAS format.
• Developed macro to convert MEDRA data set in SAS dataset format.

Environment : SAS 9.0 and PERL.

Responsibilities:

Business Analyst Responsibilities

• Supported BIapplication on SALESFORCE using APEX, VisualForce and VBScript.
• DevelopedKPI analysis Study status, Manpower Utilization, Issue turnaround time, Site performance. Patient-visit turnaround report.
• Developedad-hoc queriesand provided reports in Excel using Lookups, Pivot Tables, data validation, VBA scripts, creating multiple tabs and references
• Used PERL and Shell script to extract data from various systems and upload into BI system SQL Server, SSIS .
• Supported Invoicing Systemin SFDC.
• Designed and developed module to convert Sales contracts into Fee Schedule in SFDC.
• Developed daily and monthly routine program to capture Work Perform all activities for each study on SYBASE and ORACLE databases and upload into SQL Server 2005 for Billing/Invoice system.
• Developed and Maintained BI SQL server 2005, VB Script and ASP pages application and SFDC SalesForce reports.
• Supported SalesForce Administration USER/ROLE/Privileges etc. .

Database Analyst Responsibilities:

• Created databases and setup studies depending on therapeutic area.
• Defined and wrote Triggers to maintain referential integrity and maintain audit log.
• Wrote Store Procedures in SYBASE, ORACLE, SQL SERVER2005 to support business logic, reports etc.
• Setup Cronjob for batch processing.
• Finalized Data transfer specification and developed Store Procedure to extract data from database.
• Developed code in SAS, PERL or UNIX shell script to create data transfer file in custom specific format.
• Modified data as per USER request, and documented changes by taking snapshot of database before changes and after changes.
• Developed Edit Checks to highlight discrepancy within data.
• Optimized performance of backend code and provided user support for their day-to-day activities.
• Supported and Maintained SYBASE server Backup, Create Device. Databases, User etc. DBA activities .
• Installed /upgraded /Supported SYBASE and SQL server.

Environment: Sybase 12.5.1 on Linux 3.2 and 11.9 Sun Solaris, ORACLE10gand 11g, SQL SERVER 2005, PERL, SALES FORCE VisualForce and APEX , SAS 8.0, ASP Pages, VBScript, Excel. Linux, UNIX, Cygwin.

Responsibilities:

• Created and developed database structure for Rebalance Application.
• Developed Stored Procedures to support GUI application.
• DevelopedPERL program to generate buy and sell orders using the strategy entered by the Analyst. Also wrote program to upload orders in Order Processing system which captures detail status of each order with exceptions/errors if exists.
• Involved in feasibility study of SunGard Risk Management software which includes data mapping and data feeds between SunGard and Barclay's applications.The data feed and data load programs were developed using SYB-PERL and Stored Procedures. I also wrote various data feeds and data extract programs to load FX rates, US Equity feed and International Equity Feeds.
• Supported revenue management application.
• Load global asset data at the end of month.
• Developed script to collect data from various FTP sites.
• Developed routine to validate data and identify data issues before processing month ends which help to streamline month end process.
• Developed process to update complex fee schedule and reconcile asset information.
• Developed KPI reports like Monthly, Quarterly, Region, country, client details reports for management.
• Wrote stored procedures for complex logic.
• Achieved significant performance gain by tuning SQL code, this was crucial for month endprocessing.
• Built interface programs to load data in Oracle finance.
• Developed Unix / PERL scripts extensively for data-feed into Sybase database and SQL server.

Environment: Sybase 11.5, 11.9, 12,PERL, UNIX.

Responsibilities:

• Migrated data from existing standalone systems to customized TXBASE modules and application.
• Studied existing system like Account Receivable, purchase order and sales order processing system.
• Gathered requirements from users and convert into specification and proposed suitable structure and design.
• Coordinated with various user groups and createddetail data mapping document.
• Developed script to extract data from various standalone systems.
• Developed script to transform data into required format using Unix shell scripting, PERL, and Stored Procedures.
• Setup hardware platform for development, test and production environment.
• Designed and created user management and security system.
• Wrote PERL and UNIX Shell programs to automate migration process
• Created and conducted test scenarios, perform multi user test, resolve locking issues.
• Developed programs using Perl and Sybase CT Lib for data manipulation, processing and validation.
• Provided training to end-users for operations on systems.

Environment:Sybase ASE 4.9 11.0 Solaris, PERL, Unix.

Responsibilities:

• Redesigned modules of Distribution Application to suite business needs.
• Wrote stored procedures to migrate and populate in new table structure, to purge orphan records and improve performance of the application.
• Upgraded database server from SYBASE 4.9 to 10.0.
• Developed user-friendly screens to ease user operations.
• Added referential integrity checks, indexes and re-wrote old code to improve performance.

Environment:Sybase ASE 4.9 10.0 AIX, APT, PERL, and Unix.