Post Job Free

Resume

Sign in

Support Sql Server

Location:
Marlboro Township, NJ
Posted:
March 30, 2017

Contact this candidate

Resume:

Tanmay Sinha

732-***-**** aczj5r@r.postjobfree.com

Qualifications for IT/Software Management

Profile

Accomplished, detail-oriented professional with over 25 years of experience in the software industry.

1.Exhibit a solid background of managing all aspects of software design life cycles, including requirements gathering, functional analysis and design, technical enhancements, application delivery, and user-acceptance coordination.

2.Comfortable working in crisis-driven environments .

3.Managing Onsite and Offshore teams, responsible for work allocations and meeting the project defined timeliness.

4.Responsible for collating, analyzing and reporting the project metrics to the Senior management.

5.Deploy and coordinate with DBAs and other teams during QA and Production Releases.

6.Maintain data integrity by providing validation checks and the business rules.

7.15+ Years of Core experience in Sybase ASE 11/12.5, involvement in Databases Design for new and enhancement projects, review, finalize and approve the design.

8.Develop Stored Procedures, Triggers, Views, data manipulations scripts, UNIX shell scripts.

9.Fine-tune the queries, Stored Procedures, triggers and database design for optimum performance.

10.Able to effectively multi-task several responsibilities.

11.Support various processes on a UNIX/LINUX/Shell/PERL and RDBMS environment

Operating Systems: Windows, UNIX, LINUX

Programming Languages: C, T-SQL, PL/SQL, PowerBuilder 11.0, JAVA

Scripting Languages: PERL, UNIX Shell (KSH, CSH, BASH )

Databases: Sybase 15, MS SQL Server 2008, ORACLE 8.0, MySQL

Development Tools: DBArtisan 9.x, Sybase Central

Data Modeling: Erwin, TOAD, PowerDesigner

Internet Technologies: ASP.NET, Sybase EAS 5.5, Apache TomCat

Version Control: Perforce, GIT, SVN

Other Applications: 24 x 7 scheduler, FTP, ISQL, BCP, AutoTester, SYBASE Open-Client,, Sharepoint, DTS, ETL, SQL Delta, JIRA, Mercator, SSIS, HP QC, Control-M, Eclipse

Certifications: Six Sigma for IT ( Green Belt ) from Villanova University

Career Track

CREDIT-SUISSE ( New York, NY ) April 2016 TO PRESENT

Title : Consultant

Role: Sybase, Linux, SHELL and Powerbuilder support

1.Sybase T-SQL development and support

2.SHELL development and support

3.Release management

4.Powerbuillder 12.5 development and support

5.Use of PowerDesigner

6. Use of Control-M for job scheduling

FactSet research systems ( New York, NY ) February 2015 to April 2016

Title : Software Engineer

Role: Database, PERL and SHELL development and support

1.Part of a 3-man database engineering and support team.

2.Hold DBA responsibilities including 24/7 on-call support

3.Responsible for developing, enhancing, supporting various PERL and BASH scripts

4.Database development using MySQL including stored procedures

5.Use of MONYog for DB administration.

6.Participating in daily Scrum sessions

HSBC ( New York, NY ) Apr 2014 to January 2015

Title : Consultant

Role: Database and Windows Script support for Data Center migration

1.Developed stored procedures and performed performance tuning on SYBASE 15

2.Responsible for analysis, enhancement and support of various Control-M jobs .

3.Adaptation of various Windows scripts to the new environment

Moody’s investment services ( New York, NY ) Jan 2013- March 2014

Title: Senior Solutions developer

Role: Database Developer and Application support

1.Interface with end users and business analysts to help develop functional and technical requirements

2.Interface with QA team and track defects .

3. Deployed all development in QA and Production environments.

4.Playing SME role for the Rating Systems between various stakeholders.

5.Create the HLD and LLD technical design documents for delivered functions.

6.Was involved in development/enhancement of the AccuRate application, a 3-tier implementation utilizing Sybase.

7.Developed stored procedures and performed performance tuning on SYBASE 15

8.Performed data analysis and maintained metadata using IBM MetaData Workbench

9.Enhanced some JAVA code using Eclipse IDE.

10.Responsible for development and maintenance of various SHELL scripts, CRON jobs in a UNIX environment.

11.Responsible for analysis and enhancement of various Control-M jobs in a UNIX environment.

Morgan stanley ( New York, NY ) May 2012- Oct 2012

Title : Consultant

Role: Database developer

1.Interface with end users and business analysts to help develop functional and technical requirements

2.Interface with QA team and track defects ( using HP QC )

3.Deployed all development in QA and Production environments.

4.Developed stored procedures, triggers, views etc.

5.Performed performance tuning on SYBASE 12.5 by analyzing various stored procedures, indexes etc.

6.Enhanced JAVA code using Eclipse IDE.

Broadridge financial services ( New York, NY ) June 2011 to March 2012

Role : Application Support

Senior member of the Client Support Group supporting various clients utilizing a Fixed Income - securities processing application. The application has a MOTIF GUI and is written using C, JAVA, SHELL,PERL and SYBASE. It also a Web component published using Apache TomCat.

1.Performed various deployments, installations on SOLARIS.

2.Handled various adhoc support requests involving databases, NDM requests etc., in a production and UAT environment.

3.Participated in migrating the data center/ servers to a different physical location.

4.Participated in DR tests.

5.Performed tuning on various stored procedures and/or physical design on Sybase Ver. 15.

6.Developed and enhanced several scripts in BASH-Shell and PERL on a UNIX platform.

PHILIP VAN-HEUSEN ( Bridgewater, NJ ) August 2010 to April 2011

Provided consulting expertise on support and enhancement for various client/server applications.

1.Developed and enhanced various POWERBUILDER 9.0 applications.

2.Developed and enhanced stored procedures and triggers on SYBASE 12.5

3.Performed performance tuning of stored procedures, physical design .

4.Captured performance metrics, if needed.

BANK OF AMERICA – MERRILL LYNCH ( Jersey City, NJ ) March 2010 to June 2010

Provided consulting expertise on development and QA for various client/server applications in order to move them from ML desktop configurations to Bank of America configurations.

1.Performed full QA cycle for all POWERBUILDER apps

2.Enhanced all POWERBUILDER applications

3.Performed SQL Server 2005 development and enhancements

Morris-Griffin Corporation, Technical Lead / Senior Systems Analyst ( Lanham, MD) April 2009 to March 2010

Provided consulting expertise on financial services, debt collection, and core loan servicing functions for residential, conventional, and government portfolios nationwide.

1.Manage all software development life-cycle stages and supported client-server applications built on SQL Server 2005 and PowerBuilder ver. 11 on a Windows XP Platform.

5.Migrated the application from POWERBUILDER ver. 9 to POWERBUILDER ver. 11.

6.Increased system performance, reducing response time in some cases to seconds from minutes

7.Worked with SSIS Export/Import Wizard and DTS to load data from text files .

8.Wrote and modified several stored procedures and triggers in SQL Server 2005.

9.Responsible for source code integrity and release management using Harvest.

10.Assisted with the generation of various reports using Crystal Reports

11.Used tool SQL Delta to assist with various releases.

12.Key contact for users for troubleshooting.

13.Key contact for a outside vendor ( AppLabs ) for Stress-testing.

Concentra Health Systems, Technical Lead / Senior Systems Analyst (Woodbridge, NJ) April 2007 to April 2009

Assumed responsibility for analysis, documentation, development, enhancements, delivery, and support of all existing and future applications.

1.Successfully managed the software development life-cycle of a complex three-tier application using ASP.NET, PowerBuilder 9.0 and SYBASE EAS 5.5 (Jaguar) for deployment of all middle-tier components.

2. Served as the Lead developer for all Powerbuilder development.

3. Acted as the lead troubleshooter of all application issues.

4.Schdeduled jobs using the 24 x 7 scheduler

5.Set up various .BAT files for scheduling

6.Developed on SYBASE ver. 12.5 . Sybase Central was the tool used.

7.Performed data maintenance using BCP.

8.Integrated a system developed by an outside vendor with mimimum support/documentation.

9.Increased system performance so users could finish tasks timely and comply with various regulations.

Thomson –Reuters, Senior Systems Analyst ( New York, NY) January 2006 to April 2007

Directed enhancement processes of various PowerBuilder ver 9.0 applications using SYBASE ver 12.

1.Analyzed and designed functional specs based on minimum user requirements.

2.Served as the primary support contact for all technical and non-technical issues.

3.Oversaw life cycle management, including user acceptance testing, systems analysis and design.

4.Wrote several stored procedures and triggers using DBArtisan tool.

International Flavor and Fragrances, Senior Systems Analyst( Hazlet, NJ) Sep 2000 to Nov 2005

Developed a core application on a client/server platform to do several formulations of foods/chemicals daily for a

global application used by over 5,000 users daily, leading to thousands of formulations per day.

1.Utilized PowerBuilder 9.0 (non-PFC) for enhancements.

2. Established functional requirements through constant interaction with users.

3. Developed stored procedures/triggers using SYBASE ver. 12.5 and DBArtisan.

4. Designed a internal system for generated weekly performance tracking reports using SYBASE, DBArtisan

5.Integrated a system developed by outside vendors with mimimum documentation and no support.

6.Made system performance acceptable by tuning the data model. Erwin tool was used.

7.Constructed EDI maps using Mercator

8.Managed all aspects of a software lifecycle using the Linear Sequential method including systems analysis and design.

9.Worked closely with Operations for all deployments and releases.

Prior experience available on request

Education

Six Sigma Green Belt, Villanova University

B.S. in Electronics and Communications Engineering, Indian Institute of Technology



Contact this candidate