Photo

TINKU SUNIL BSND Application Support Project Lead

CANADA
Bottomline-FORMSCAPEBottomline-WebseriesCrystal Reports 8.5Datastage 11.5ERWIN – Data ModelETIIFCHInformatica 6ION tradingITILJIRALinuxMPP BMC RemedyMS VisioOracle 12cPL/SQLServiceNowSQL Server 2000/2005SVNTableau 9UnixVERTICAVSS(Visual Source Safe)
Contact

Send Message

To contact this candidate email tinkusunil.bsnd@gmail.com

Contact using webmail: Gmail / AOL / Yahoo / Outlook

tinkusunil.bsnd@gmail.com   00919884281838

Note: Hold a Canadian PR and Open to work anywhre in Canada – no location constraints and willing to travel within canada if required

 

OBJECTIVE
Effective implementation of knowledge, technical and project management skills and experience towards optimizing                  processes, fostering growth and enriching the value of a progressive organization and thereby to emerge as an innovative and resourceful professional

 

PROFILE HIGHLIGHTS
IBM Datastage Support Lead – Data warehousing Operations and Delivery, Application Value Management

 

Seasoned professional with 12.3 years’ experience and a wealth of hands-on experience leveraging exceptional process direction and an expertise to propel corporate performance and profitability, currently working with Cognizant Technology Solutions since 2006

 

•   Around 12+ years of IT experience in managing/working different projects predominantly in Application/Production Support and Project Management and other projects like Development and Testing with varied technologies and tools

•   Services include Application support, Application development, client operations, Customer relationship management, day-day event monitor management and client service requests

•   Project delivery (end to end) including Program Governance, Stakeholder management, Risk management, Scope, Quality, Capacity and Change management

• Leadership: Hands on experience building and leading project teams and stakeholder groups from project initiation through project operations.

• Collaboration and Integration: Routinely collaborates with a diverse group of subject matter experts during project initiation, scope development, and project execution.

• Change Management: Direct experience with managing and representing the change for every sprint and design change processes.

• Multi-tasking: Managing multiple scopes, schedules, budgets, and stakeholder communications

• Communications: Excellent communicator with verbal, writing and presentation skills attuned to project goals and stakeholder needs

• Negotiation and Problem Solving: Conversant across multiple technologies and tools, understands complex problems and capable of negotiating mutually acceptable solutions

• Team Building: Hands on experience building and leading project teams from project initiation through project operations.

• Designed and implemented design change-control process involving tracking, documentation, and communication of design changes

• Reviewed work packages for compliance with engineering principals, company standards, and contract requirements.

•    Ensures accomplishment of Support Service Level Objectives and Key Performance Indicators working in partnership with Service Providers and Software Vendors

•    Ensures and promotes ITIL best practices for Incident, Problem, Change, Release management within IS and Service Providers

•    Jointly with Partner, establishes, collaborates and monitors a Continuous Improvement plan to identify and remove the service delivery gaps

•    Involved in internal and external audit reviews and related discussions for all the applications supported and solely responsible for the coordination and collection of all audit evidences across the project and interfacing with auditors

•    Ensured SLA’s are met and executed all critical situations with proper protocols

•   Responsible for the management and delivery of on-site and off-shore IT service management services

•   Responsible and involved for maintaining the Knowledge Management repository, Self-Service and coordination of Disaster Recovery testing that requires broad oversight and coordination

•   To coordinate and involved escalation and resolution of major service issues by initiating a Bridge call and involving all parties involved

•   To report promptly to management and business partners regarding critical outages until resolution

•   Hands on end to end of ETL Development and Implementation with leading Canadian Banking client during Datastage development and Migration projects

•    Adept in end-to-end support of various applications from requirement analysis to system study, designing, documentation, maintenance and support, process quality and management

•    Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing

•    Develop and deliver progress reports, proposals, requirements documentation and presentations

•   Hands on end to end of Testing of Regulatory reports developed using Tableau tool with leading Canadian Banking

•   Hand on in different Client tools like MAISIE, WEBSERIES and FORMSCAPE (Bottomline technologies), ION Trading, ETI extract

•    Establishes weekly and monthly service status review meetings with key stakeholders (Business, IS and Service Providers)

•   Direct and manage project development from beginning to end and define project scope and deliverables that support customer goals

•   Effectively communicate project expectations to team members in a timely and clear fashion and communicate with customers on an ongoing basis

•    Plan and schedule project timelines and milestones using appropriate tools and track project milestones and deliverables

•    Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.

•    Issue status reports to the project team, analyze results, and troubleshoot problem areas

•    Conduct project retrospective meetings and create a recommendations report in order to identify successful and unsuccessful project elements

•    Experience in a variety of software development approaches and methodologies including Agile and Waterfall

 

TOOLS AND TECHNOLOGIES
Tools / Technology / Operating Systems Used
Description
Datastage 11.5, Informatica 6, ETI, ERWIN – Data Model
ETL tools and Data Modeler
Unix, Linux
Operating Systems used
Oracle 12c, PL/SQL, VERTICA, SQL Server 2000/2005
Worked on the database environment for support projects
Bottomline-FORMSCAPE, Bottomline-Webseries, ION trading, IFCH
Applications supported Client Tools
Crystal Reports 8.5, Tableau 9
Reporting Tools
VSS(Visual Source Safe) and SVN
Source Controller
MS Visio, MPP
SLA governance decks and monthly project support status reports
BMC Remedy, JIRA, ServiceNow
Service Management Tools used for application support process
CERTIFICATIONS
·         Certified Scrum Master

·         Prince2 Practitioner

·         Prince2 Foundation

·         ITIL Foundation

·         IBM Certified Solution Developer – InfoSphere DataStage v8.5

 

ONSITE EXPERIENCE
·         Rendered onsite project support and deliveries from both Toronto in Canada (September 2013 – February 2015) and London in UK (March 2010 – June 2010) – served leading UK and Canadian banks and provided vast support for IT division seamlessly

 

WORK EXPERIENCE
Production Support Analyst and Project Lead                                                                                                            Chennai – India

Ally Bank – Auto Finance                                                                                                                                                   JUL 2016 – OCT 2018

·         Manage end to end of the service delivery of Support project with zero escalations, project execution and control and Lead resources, risk, quality, scope, budget and project deliverables

·         Monitor the Daily Batch loads and make sure the loads are complete without any issues

·         Perform daily Health checks on the Daily batch loads and stats reports are delivered

·         Coordinate escalation and own resolution of major service issues

·         Ensure the team maintains focus on quality and continuous delivery

·         Track and ensure visibility of historical issues and progress of the each with root cause analysis and solutions

·         Report promptly to management and business partners regarding critical outages until resolution

·         Own the Problem Management Process

·         Documentation of all issues and the resolution with the SLA. This can be used as a knowledge portal or all the information for future reference

·         Prioritize issues raised and resolve it accordingly as per the SLA

·         Implement appropriate procedures and policies (i.e. change control, security and auditing, release, configuration, problem and incident management)

·         Work with Development teams and Business Analysts during Business releases and ensure necessary KT has been provided to the Support team to handle issues after implementation with transparency and coordinate with change management board

·         Provide 24×7 operational support to all production practices on holidays and weekends

·         Facilitate project status meetings with the project team on a regular basis and provide status to my clients which include project activity, milestones, risk mitigation, etc.

·         Seeking out, establishing and maintaining relationships with operational contacts for each client.

·         Involved in day-to-day management of the service area, Disaster Recovery testing and Business continuity situations in times of emergency

·         Implement the derivation of standards related to process and operations management

·         Implement continual service improvement themes and script-based automation in addition to the customer deliverables yielding ticket count reduction, improved performance and reduced manual efforts

·         Enthusiastically identify impediments and appropriately resolve issues with permanent fixes and root cause analysis

·         Collaborate with project leads to aggressively address issues, risks and mitigation plans

·         Provided value additions on DSX Search Utility and Change Report and Outlook Integration with the effort saving of hours 1183.84 and been uploaded in ISpace

TECHNOLOGIES USED IN THIS PROJECT

Datastage 11.5, Oracle 12c, Putty, Control-M, ServiceNow, LINUX, Putty

 

Application Support Analyst and Project Lead                                                                                                            Chennai – India

LLYODS Bank – Payments Division                                                                                                                                   MAR 2015 – JUL 2016

·         Manage end to end of the service delivery of Support project with zero escalations, project execution and control and Lead resources, risk, quality, scope, budget and project deliverables

·         Ensure the team maintains focus on quality and continuous delivery

·         Track and ensure visibility of historical issues and progress of the each with root cause analysis and solutions

·         Supported customer related applications like Webseries (Bottomline technologies) and IFCH ( Vendor : Polaris)

·         Monitor Daily batch loads and make sure the loads are complete without any issues

·         Perform daily heath checks and send status reports

·         Resolved Batch loads issues with in SLA

·         Engaged Development, Business Analysts and Vendor teams for assistance for resolution of issues by initiating the Bridge calls

·          Communicated immediately to internal management and Clients on issues and application downtime and share RCA report on the same

·         Provide 24×7 operational support to all production practices on holidays and weekends

·         Implement the derivation of standards related to process and operations management

·         Own the Problem Management Process

·         Conducted and represented Project meetings on weekly and monthly basis, HAYLEYS Report (SLA) and Demand and Supply reports

·         Prioritize issues raised and resolve it accordingly

·         Own the Problem Management Process

·         Documentation of issues and maintain knowledge repository

·         Effectively scheduled , planned and transitioned the project to the other Vendor in different phases

·         Enthusiastically identify impediments and appropriately resolve issues with permanent fixes and root cause analysis

TECHNOLOGIES USED IN THIS PROJECT

Bottomline technologies – Webseries, IFCH, Oracle 10g, BMC Remedy, UNIX, Putty

 

Senior ETL Tester and Lead                                                                                                                                              Toronto – Canada

Royal Bank of Canada – Capital Markets                                                                                                                         SEP 2013 – MAR 2015

·         Manage and coordinated Software Testing Team of 5 personnel through all phases of application development of Regulatory Reports across all geographies; ensured that information systems and services met or exceeded organization/industry quality standards and end user requirements

·         Prepared and designed the Test Strategy document of Regulatory Reports and conducted review along with Clients for approval

·         Performed Requirement Analysis and participating in the Review Process

·         Preparation of Test Plans and ensuring timely execution of the same and performed Internal Reviews and Peer Reviews for each sprint

·         Preparation of SIT test cases and Performed testing on the same

·         Performed Regression testing, Smoke Testing, Functional / Non Functional testing

·         Preparation of Test Data for each sprint and validated the same

·         Execution of test cases and logging defects in the Defect Management Tool – ALM (HPQC)

·         Conducted User Acceptance Testing (UAT); supported clients during Testing Weeks to build and strengthen their confidence in Applications

·         Involved in Release planning, application backlog meetings, application reviews and deciding upon further course of action

·         Provided QA feedback for review retrospectives

·         Maintenance of Automated Test Harness Scripts used for Automated Regression testing

·         Interaction with upstream and downstream systems for any Dataload activities

TECHNOLOGIES USED IN THIS PROJECT

ION trading (tool), Tableau, VERTICA, ALM, JIRA, UNIX, Putty, Confluence

 

Senior ETL Developer and Lead                                                                                                                                      Chennai – India

Royal Bank of Canada – Capital Markets                                                                                                                         JAN 2011 – SEP 2013

·         To understand and Analyze the end user requirements and business rules of the Projects – Position & Trade Data warehouse , ETI Migration, Informatica 6 Migration

·         Worked closely with tech leads and Business analysts in understanding the current system

·         Preparation of the Mapping Documents for each given job by analyzing PRO*C code

·         Design and Develop the Jobs in DataStage based upon the mapping document along with best coding standards and practices

·         Perform Unit testing of code and document the test results

·         Designed scheduling of Autosys jobs using JIL scripts

·         Responsible for code review , unit testing and  Peer/System testing in the team

·         Coordinate with QA team on build management and release management procedures

·         Coordinate with Quality Assurance team in testing the application and immediately fix the reported bugs

·         Responsible in Project planning, Metrics Submission and Internal Auditing

·         Preparation of Project Documents like Technical Documents, process procedures and flow for the process

·         Assisted Business Analysts in Data Modelling in building Logical and Physical models

·         Involved in Project plan and track the progress against the prescribed baselines on completion and delivery of datastage jobs across the milestones and raised Alert in case of any delays to the management

·         Created Application Architecture using MS Visio as per the requirements being shared by the Business Analysts

TECHNOLOGIES USED IN THIS PROJECT

Datastage 8.1 and 8.5, Informatica 6, ETI tool, Oracle 10g, SQL Server 2005, Autosys, Putty, ERWIN Datamodeller, JIRA, MPP, Confluence

 

Production Support Analyst                                                                                                                                      London – UK /Chennai – India

Bank of NewYork Mellon – Asset Servicing                                                                                                             MAY 2006 – DEC 2010

·         Managed and Supported customer related applications like MAISIE (CRM application – TEAMPOINT), Formscape (Bottomline technologies), Oracle (database), Crystal reports

·         Monitor daily batch loads, perform health checks and send the status report

·         Involved in fixing the bugs with the specific period which involves enhancing stored procedures, Functions, Tables in SQL.

·         Responsible for enhancing/creating reports using Crystal report and link it to the CRM application.

·         Responsible for fixing issues in POP language.

·         Responsible for creating/changing process in the Formscape, POP, Database and Crystal reports.

·         To Represent CR meetings for any Code Change

·         Responsible for unit testing, Peer testing and code review in the team.

·         Mentored and guided a new ELT’s who is now taking care of MAISIE and Formscape work independently in the team.

·         Ensure effective interaction of Offshore and Onsite team

TECHNOLOGIES USED IN THIS PROJECT

Oracle PL/SQL, Oracle 10g, Toad, Crystal Reports, Remedy

 

ORGANIZATION DETAILS
Senior Associate at Cognizant Technology Solutions (May2006 to Present)

ACADEMIC QUALIFICATIONS
Course            College                                                                            Board/University  Year of passing

c-PGDBA (HR)  Symbiosis Center for Distance Learning                    Symbiosis                2009

BE (ECE)            Dr MGR Engineering College                                      Anna University     2005

XII                   Kaligi Ranganathan Montford Matriculation HSS       State Board             2001

X                     Kaligi Ranganathan Montford Matriculation HSS       State Board             1999

Education

2007/2009 HUMAN RESOURCE MANAGEMENT at SYMBIOSIS CENTER FOR DISTANCE LEARNING
2001/2005 ELECTRONICS AND COMMUNICATION ENGINEERING at DR MGR ENGINEERING COLLEGE

Experience

2006/2018 APPLICATION SUPPORT PROJECT LEAD at COGNIZANT TECHNOLOGY SOLUTIONS