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