Suchandra Tapadar

(: 949-***-****

*: adlovt@r.postjobfree.com

PROFESSIONAL SUMMARY

●More than 14 years of experience as a Software Engineer with expertise in technical leadership, system analysis, designing, developing, testing, supporting, maintaining, and debugging software for supporting the maintenance and enhancement of a critical application which utilizes a two-tier architecture consisting of a PowerBuilder version 10,11,12.5, Appeon PowerBuilder 2017 Rx and PowerBuilder 2019 R3 as front-end and an Oracle/Sybase back-end.

●Designed and developed base and custom classes’ architecture frameworks using PowerBuilder Foundation Class (PFC) libraries for various projects and extended PFC and PFE hierarchical designs of visual and non-visual objects.

●Synchronized PowerBuilder objects with version control tools like Visual Studio Team Foundation 2012/ Perforce 2013.1/Git /Component Software RCS/SCCS/VCS for source control of the PowerBuilder code.

●Performed scripting via Oracle, Sybase, PL/SQL, embedded SQL in PB, SQL painter in PB, and database procedures, functions, and packages.

●Extensive experience in query optimization, data mining and data mapping.

●Single-handedly completed complex Application Modelling, Optimization, and Integration.

●Implemented knowledge of SQL Server 2008 and 2012 for various business and technical changes, complex queries and expertise in performance tuning using execution plans in SQL Server.

●Participated in assessment for new upcoming projects initiatives or engagements and helps in creating various technical plans, milestones and roadmap, Fishbone diagrams, SWOT Analysis diagrams and process and data flowcharts.

●Designed solutions or/and provided Proof of Concept by designing a solution with technologies such as Power Builder, MS-Visio, Microsoft tools, C, C++, SQL Server, SharePoint, Visual Basic 6.0, MS-Office, Open Office.

●Generate various client related, data and technical reports using SQL Reporting Server/Crystal Report 8/9/11.

●Identified technical solutions to solve business requirements and provided technical leadership during enhancements and development.

●Provided feedback and technical guidance on critical issues affecting business objectives. Analyzed and resolved data issues and support for emergency production issues.

●End to end support for technical and functional deliverables on time with adherence to schedule and quality mandates. Provided redesigning, day-to-day maintenance of the system and participated in regularly scheduled enhancements.

●Provided daily support to the various client server systems for approximately 1000 users in over 350 offsite locations with additional selected, secure interfaces to State and Internet networks.

●Participated in the full life cycle of development (define, develop, test, install, and maintain) of the existing system as well as new initiatives.

●Supported Object Oriented design processes, performed impact analysis on system and code to figure out overall impact on system from various change requests and initiatives in Waterfall/Agile methodologies.

●Attention to detail and strong organizational skills to demonstrate outstanding customer service.

●Worked closely with business analysts and project owners to translate requirements and prepare various design and technical specifications.

●Resolved and provided solutions to day-to-day problems reported by Town Clerks and assessed the source of the problems for their potential impact on the design of the new system

●Excellent interpersonal skills with demonstrated successes as Technical Lead, Onsite Coordinator, Technical Analyst, Assistant Software Engineer with hands-on Technical Leadership and Team Building, Release, packaging and Change Management, Software Configurations and building techniques.

●Worked in Git, Atlassian tools like Source Tree, Bamboo, Bitbucket, Confluence, Crucible, Fisheye and JIRA

●Good knowledge of n-tier architecture, SWIFT Messaging, distributed client-server.

●Good experience in various diversified sectors including Investment Banks, Corporate Actions, Trade Processing, Portfolio Management, Asset Setup and Maintenance, Retail Industry, Net Asset Value, Securities Lending, Insurance.

●Well versed in Object Oriented Analysis, Design Methodologies and Business Objects, Business Analytics, Resource Planning, requirement elicitation, resource allocation.

●Extensive years of experience in Agile Methodology, successful scrum master as well as SDLC project coordinator.

●Involved in auditing, quality assurance activities, Integrated Process Management activities, Defect Prevention and Casual Analysis, Disaster Recovery procedures, have helped in Final Inspection of projects and analyzed the Customer Satisfaction Survey Index of projects.

●Handled configuration management activities and provided planning for the project release and deployments to QA, staging and production environments.

Technical Expertise

Operating Systems

AIX 5.3 on RS-6000, Sun Solaris (UNIX), HP Unix, Linux, Microsoft Windows Family

Data Bases

Sybase, UDB 8.1, SQL Server 7.0, DB2, Oracle 9,10,11, and 18

Tools

Sybase PowerBuilder version 9,10,11,12.5, Appeon PowerBuilder 2017x and 2019x, IPMS, PPMC, Autosys, Informatica PowerCenter, SCCS, MS-Visio, Atlassian tools like Source Tree, Bamboo, Bitbucket, Confluence, Crucible, Fisheye and JIRA, Asset Control

Languages

PowerBuilder Foundation and Extension Classes, C, C++, Perl, ASP, VBScript, Embedded SQL, PL/SQL, XML

Applications

BMC Remedy, Lotus Notes

Software Packages

Visual Basic 6.0, MS-Office, Open Office

Scripting

Unix and Perl Scripting

Methodologies

OOPS, Client/Server

Version Control

VSS, TFS, Perforce 2013.1, Git

Reporting Tool

SQL Reporting Server, Crystal Report 8/9/11

Industries

Voting, RMV, Dental Insurance, Investment Banks, Corporate Actions, Trade Processing, Portfolio Management, Asset Setup and Maintenance, Retail Industry, Net Asset Value, Securities Lending, Insurance.

PROFESSIONAL EXPERIENCE

State Client of MA, Boston, MA Feb 2019- Present

Technical Lead PowerBuilder and PL/SQL Developer

Responsibilities:

●Involved in impact analysis and gap analysis of the requirements, designing technical solutions, development, unit testing of various enhancements and updates in voting software developed in PowerBuilder 12.5.

●Successfully migrated the application from Sybase PowerBuilder 12.5 to Appeon PowerBuilder 2017 R2 and R3 and then migrated from Appeon PowerBuilder 2017x to Appeon PowerBuilder 2019 R3 beta.

●Developed many Oracle tables, cursors, views, stored procedures, triggers, complex Oracle PL/SQL queries in for various enhancements and production support tickets.

●Involved in performance tuning of PowerBuilder and Oracle codes for better performance of the code and system.

●Involved in full build and deployment for PowerBuilder executables to different environments.

●Debugged any issues while development, testing, UAT testing, full build of application and deployment to various environments.

●Develop analysis and design documents, perform detail impact analysis, and create unit test cases and integration test cases before the code is delivered to Business analysts for testing.

●Involved in end-to-end testing in many upgrades like Oracle upgrade, enhancements, patch upgrades etc.

●Synchronized PowerBuilder with TFS for version control of PowerBuilder Code.

●Involved in regression testing and troubleshooting of PowerBuilder migration with Windows update.

●Singlehandedly coded and resolved many production tickets before SLA.

●Worked in PFC and PFE architectures.

●Integrating various runtime DLL’s and other web queries to coordinate with PowerBuilder application.

●Involved in creation of many feed programs to take data from RMV and other health agencies and parse them and store them in the application.

●Created scripts for various windows jobs to run on a schedule as desired by various downstream and upstream.

●Involved in aggressive trouble shooting of issues, design reviews, code reviews and requirement analysis and design sessions.

●Involved in analysing the existing error handling issues, fix and test them for future insecurities.

●Involved in converting the application from 2-tier to 3-tier application by using various Active Directories and Standard PowerBuilder security related classes.

●Modifying application to enhance security controls by implementing good error handling techniques, analysing on Microsoft AD groups implementation and Fortify tools.

Tools Used:

PowerBuilder, PowerBuilder Foundation and Extension Classes, Oracle SQL Developer (PL/SQL Tool), Microsoft Visual Studio Team Foundation Server, Microsoft Visual Studio++, Cherwell Ticket Management System, Notepad++, Microsoft Tools like Word, Excel, PowerPoint, Outlook and Snipping Tool

Children Youth and Families Department, Providence, RH Aug 2018- Jan 2019

Programmer Analyst Consultant

Responsibilities:

●Involved in development, testing of various enhancements, modifications client server architecture in Sybase PowerBuilder 12.6, Appeon PowerBuilder 2017R2 and 2017R3 and Oracle.

●End to end involvement in PowerBuilder migration from Sybase PowerBuilder 12.6 to Appeon PowerBuilder 2017 R2.

●Developed many Oracle stored procedures, triggers, complex PL/SQL queries in for various enhancements and production support tickets.

●Was involved in moving the client server PowerBuilder and Oracle Application to web-based application.

●Develop analysis and design documents, perform detail impact analysis, and create unit test cases and integration test cases before the code is delivered to QA.

●Developed migration and technical documents for PowerBuilder enhancements and deployments.

●Designing technical solutions, development in PowerBuilder and PL/SQL and involved in unit testing.

●Worked in TFS for version control of PowerBuilder code.

●Involved in aggressive trouble shooting of issues, design reviews, code reviews and requirement analysis and design sessions.

●Customized Microsoft word ribbons for reports and documents to be coherent with web-based security.

Tools Used:

PowerBuilder, PowerBuilder Foundation and Extension Classes, Oracle SQL Developer (PL/SQL Tool), Microsoft Visual Studio Team Foundation Server, Microsoft Visual Studio++, Notepad++, Microsoft Tools like Word, Excel, PowerPoint, Outlook and Snipping Tool.

Delta Dental Insurance, Naperville, IL Oct 2017- July 2018

Programmer Analyst Consultant

Responsibilities:

●Involved in development, testing of various Agile Jira stories in Sybase PowerBuilder 12.6.

●Developed many Oracle stored procedures, triggers, complex PL/SQL queries in for various enhancements and production support tickets.

●Develop analysis and design documents, perform detail impact analysis, and create unit test cases and integration test cases before the code is delivered to QA.

●Developed technical and design documents for PowerBuilder enhancements and deployments.

●Designing technical solutions, development in PowerBuilder and PL/SQL and involved in unit testing.

●Singlehandedly coded for many production tickets.

●Worked in PFC and PFE architectures.

●Calling of SOAP modules from PowerBuilder code.

●Worked in Microsoft Team Foundation Server for version control of PowerBuilder 12.6 code.

●Involved in many big projects like year-end closing projects, faxback, and vision projects.

●Created scripts for automate tool to create scheduled jobs.

●Involved in aggressive trouble shooting of issues, design reviews, code reviews and requirement analysis and design sessions.

●Solved production tickets before SLA.

Tools Used:

PowerBuilder, Oracle SQL Developer (PL/SQL Tool), Microsoft Visual Studio Team Foundation Server, Automate tool for job scheduling, JIRA, Notepad++, Microsoft Tools like Word, Excel, PowerPoint, Snipping Tool.

Capital Group of Companies, Los Angeles, CA May 2010- Sep 2017

Technical Lead and Onsite Coordinator

Responsibilities:

●Lead a technical team of 25 people offshore and 20 people onshore and supported end to end implementation, release management activities, defect fixing and SLA compliance and meeting the deadlines of the project.

●Worked on moving all the legacy applications like “Asset up and Maintenance”, “Trade Processing system”,” FORAS”, “Net Asset Value” etc. to Cirrus private cloud which include migration of all the legacy application from Sybase PowerBuilder 12.0/12.1 to Sybase PowerBuilder 12.6, from Unix to Linux, Sybase to Oracle.

●Developed code in Sybase PowerBuilder 12.6, customized the PFC code.

●Helped migration of various PowerBuilder projects from Sybase PowerBuilder 12.0 to 12.6, Sybase to oracle and Unix to Linux migration.

●Have created, tested, verified numerous PL/SQL queries, various objects of Oracle, stored procedures, packages, cursors for various projects I have worked on. Was extensively involved in performance tuning of various joins and stored procedures, triggers, queries.

●Have worked extensively on SQL queries, complex joins, stored procedures in Sybase to get the data mapping between various vendors and the system.

●Have developed many PERL scripts and shell scripts for Autosys job scheduler.

●End to end support and implementation of various Power Builder version 10 and above projects, C, C++, scripting projects to new platforms.

●Resolved production issues, critical defects, troubling issues in defined SLA. Involved in secondary and primary support for production issues handling in all my applications.

●Have worked in development and testing, defect fixing, releases and migration of all PowerBuilder version 10, 12 and above as GUI and Sybase as backend projects for more than 9 years.

●Responsible for deploying and testing the PowerBuilder application Package in multiple environments like Dev, ITE, QA, UAT and production.

●Coordinated and presented many workshops to many teams and projects on PFC as well as PowerBuilder custom libraries and Integrating APIs in PowerBuilder.

●Written manuals and documents on how to integrate PowerBuilder code with Crystal Reports and other OLE objects.

●Implemented many Perl scripts integrated with Autosys server for running the batch jobs.

●Worked in VSS tool for version control of Sybase PowerBuilder 12.6 code.

●Worked closely with business system analysts to analyze & understand business requirements; translated the stories to design documents, identified gaps in current process and analysed the root cause for existing system defects.

●Involved in writing Use Cases and Test Cases based on the Business narratives,

●Have also worked for various change requests involving change in workflows and creation of new workflows in ETL PowerCenter.

●Had extensive experience in analysing complex queries and stored procedures for data mapping between the current systems and various other vendors.

●Have worked in SOAP implementation with numerous PowerBuilder enhancements.

●Fixed and performed troubleshooting for many issues while migration of systems from lower PowerBuilder version to newer PowerBuilder versions, Soap calls, embedding soap calls and runtime DLLs issues etc.

●Facilitated Scrum planning meetings to coordinate between Clients, Product Owner, Dev, and QA teams.

●Supported business/functional requirement review, approval, and sign-off sessions.

●Handled production support and release management process for go-live in production.

●Worked in Atlassian tools like JIRA, Source Tree, GitHub, Bitbucket etc.

●Implemented many Perl scripts integrated with Autosys server for running the batch jobs.

●Worked in VSS tool for version control of PowerBuilder code.

●Lead development and testing team for various releases including requirements gathering, impact analysis, coding, testing, code reviews and various estimations for optimization.

●Involved in designing solutions to various requirements and was responsible for end-to-end implementation till it went live in production.

●Incorporated agile methodology and SCRUM techniques to manage requirements and enhance Reference Data Manager Application.

●Shadow and assist some of the Product Owner activities by providing high level estimates, prioritizing stories for the sprint, capturing user story points and maintaining backlogs and release plans and defects.

●Directly interacted with clients to elicit the requirements and translate them into terms that development team can comprehend.

●Due to constraints on developer resources, researched technical solutions, channelized team process improvements to ensure business continuity is maintained with optimal solutions.

●Gathered specifications and requirements, created demos, and developed workflow designs, lead initiatives to improve processes in business, organizational, and operational areas.

●Facilitate optimal internal communications by serving as liaison between services organization and product development, product management, and technical teams.

●Proactively contributed to several implementation projects; leveraged communications skills to establish and maintain successful client relationships.

●Worked closely with development team and business teams to scope projects and estimate / maximize utilization of human resources.

●Assisted with research and reviews of the projects’ scope in order to understand why the project has been initiated.

●Communicated requirements with direction and guidance from senior, consultant staff, and/or manager.

●Created basic models and user prototype interfaces to identify and validated business processes and solutions.

●Demonstrated a basic level of working knowledge with business methodologies and processes (i.e., Project Life Cycle, System Development Life Cycle and Change Management processes)

●Gathered detailed requirements and verified with team that requirements completely define the project, identified, and understood issues, problems, and business opportunities.

●Identified solutions to the development and technical team based on approved business and functional requirements.

Tools Used:

PowerBuilder, PowerBuilder Foundation and Extension Classes, Oracle SQL Developer (PL/SQL Tool), Sybase, Perforce, PPMC, Autosys scheduler, Informatica PowerCenter, SCCS, Unix and Perl Scripting, MS-Visio, Atlassian tools like Source Tree, Bamboo, Bitbucket, Confluence, Crucible, Fisheye and JIRA, Asset Control, Notepad++, Microsoft Tools like Word, Excel, PowerPoint, MS Office, Lotus and Snipping Tool, Microsoft SQL Reporting, GIT.

Bank of New York Mellon, IND Nov 2008- Apr 2010

Assistant Software Engineer

Responsibilities:

●Performed the role of lead with a team of 8-9 developers at offshore to support enhancement and maintenance of the existing Sybase PowerBuilder version 12.0 code of NAV and TPS.

●Performed Unit testing and coordinated with QA team and guiding them through new enhancements and bug fixes and trouble-shooting and fixing defects on PowerBuilder code.

●Created custom libraries and PB objects like windows, data windows, user objects and functions using PFC.

●Wrote interfaces between Oracle and Sybase ASE using PowerBuilder code.

●Worked in VSS tool for version control of PowerBuilder code.

●Translated business and technical requirements between the users and developers and participated in design sessions.

●Implemented many Perl and Unix scripts integrated with autosys server for running the batch jobs.

●Was involved in resolving critical Production issues, maintain SLA’s, have enormous knowledge in troubleshooting issues in Production in critical time constraint.

●Reviewed numerous codes for end-to-end implementations, upgrades and requirement changes for PowerBuilder projects as well as stored procedures, optimizing SQL queries, complex joins and designing new views and tables etc.

●Provided on call coverage and support to business operations.

●Have worked on 10 projects which are managed on Agile Methodology, creating stories, managing defects, creating epics, and creating agile reports.

●Motivated the team to move towards the completion of goals with efficiency and effectively using different tools.

●Supported communication activities with end-user and Production Support L2 training for system implementation.

●Appreciated and acknowledged by clients for my handling of ‘NAV’ project single-handedly while the application was being transitioned into another application called CSTAR.

●Coordinated various releases, deployments and have been involved in sketching the deadlines and SLA for various assignments.

●Involved in auditing and creation of various audit related documents for the projects I have been leading.

●Involved and responsible for many upgrades like Java patch upgrades and NAS Remediation Life Cycle Management projects.

●Critically involved in the end-to-end technology rationalization of applications like Linux Migration and have been part of the success stories of these applications.

●Meticulously performed development, testing, reviewing various codes, unit test cases and system test cases, fixing defects and finding optimized design solutions to support customer needs.

●Created numerous project related manuals and trained new employees in the applications I have been leading.

●Created various scheduling jobs in Autosys and maintained and coordinated the inter-dependencies between various schedulers in various environments.

●Created various sessions, mappings, and workflows for Informatica PowerCenter.

Tools Used:

PowerBuilder, PowerBuilder Foundation and Extension Classes, Sybase, Unix and Perl scripting, BMC Remedy Tool, Informatica PowerCenter, C, C++, VSS, MS-Visio, XML Notepad++, Microsoft Tools like Word, Excel, PowerPoint, Snipping Tool, Visual Basic 6.0, MS-Office, Open Office.

Fidelity Investments Ltd, IND Jan 2007- Oct 2008

Assistant Software Engineer

Responsibilities:

●Single-handedly developed many new requirements and updates as requested by business in my application which is Sybase PowerBuilder 12.0 and Sybase application.

●Ensured proper testing of new development objects in QA of various Change Management Requests before pushing to production environment.

●Created /updated many Sybase objects and complex joins and queries.

●Implemented many Perl and Unix scripts integrated with Autosys server for running the batch jobs.

●Interacted with clients and provided effective solution to their requirements.

●Developed, tested, and implemented SSL successfully for NCS banking software for Bank of New York Mellon single-handedly.

●Integral part of various Change Management Requests and maintenance tasks and Production Log changes (end to end solutions).

●Involved in creation of UTS and STS and fixing of bugs, unit testing and regressive system testing of all the changes and releases in the system.

●Maintained correct version of source codes using SCCS tool.

●Created many stored procedures, SQL queries, cursors and optimized various queries and stored procedures.

Tools Used:

PowerBuilder, PowerBuilder Foundation and Extension Classes, Sybase, Perl and Unix scripting, BMC Remedy Tool, SCCS, Unix scripting, MS-Visio, Crystal Report 8/9/11, Notepad++, Microsoft Tools like Word, Excel, PowerPoint, Snipping Tool, Visual Basic 6.0, MS-Office, Open Office.

Citibank, IND Jan 2006- Dec 2006

Assistant Software Engineer

Responsibilities:

●Involved in development and enhancement of my application on Sybase PowerBuilder 12.0, studying of bugs and unit, system, and regression testing of all the Change Management Requests and other enhancements in projects, created high level and low-level design documents like SS, STS, UTS, creation of induction manuals and release notes.

●Code walkthrough of various changes developed by team members.

●Development and maintenance of Bug Tracking Matrices, various monthly and status reports.

●Analysis of SLA, Client Satisfaction Surveys and providing corrective actions on low SLA.

●Attending teleconferences with the client to discuss development of ongoing assignments.

●Maintaining the correct version of source codes using SCCS tool.

●Involved in maintenance of Integrated Management tools and Quality Assurance and BCP activities of project.

●Worked in Sybase objects and various complex joins and queries.

●Coordinated various Final Inspections in various projects.

●Helped in increasing the SLA and Customer Satisfaction Index in my project.

●Presented various technical and functional seminars in various projects.

●Involved in development of enhancements and production logs in my project in Sybase PowerBuilder 10 and Sybase.

●Integral part of development of various client reports.

●Engaged in system and integration testing of various modules and enhancement in the system.

●Developed various scripts and low-level design documents.

●Attended various functional and technical presentations.

●Supported Sybase objects creation, updates for various changes and implementations.

●Coded for various retrieval and processing strategies for SWIFT messages.

Tools Used:

PowerBuilder, PowerBuilder Foundation and Extension Classes, SQL Server 7.0, DB2, BMC Remedy Tool, VSS, MS-Visio, Crystal Report 8, Notepad++, Microsoft Tools like Word, Excel, PowerPoint, Snipping Tool, Visual Basic 6.0, MS-Office, Open Office.

EDUCATIONAL QUALIFICATION

Master of Computer Applications, Rajasthan, India (2003 – 2006)

Bachelor of Science, Delhi, India (2000-2003)

Certifications

Certified in IBM DB2 UDB V8.1 Test # 700 Database Certification

Certified in Six Sigma - Introduction and DMAIC process

Certified in Securities and Debt instruments, Banking Fundamentals

Trained in Roadmap of NCS, Security Market, Trade Settlement, CICS, Defect Prevention and Causal Analysis, Relational Databases, C ++ Programming, Software Development Life Cycle, Software Quality Assurance, Review, Walkthrough & Inspection, Testing and Debugging, Six Thinking Hats, Database Management Systems, System Design Overview, Object Oriented Methodology, Lateral Thinking, Working in Team Effectively

Contact this candidate