System Analyst/technical Lead Resume
PROFESSIONAL SUMMARY:
- 10+ years of IT experience that includes 1.5+ years of US onsite experience and 2+ years of project management experience in the Financial services sector in Banking and Financial domain in Development, Maintenance and Support Mainframeand Java projects in Fund Accounting, Pricing checks, Corporate Actions Diary, Account Receivable Information system and Cards & Paymentsin areas of Performance Reporting, Client Reporting, Customer Relationship Management and Payments platforms for reputed US clients - American Express, Pfizer, Bank of New York Mellon.
- Experienced in project management, process mapping, business process review and design use cases, impact analysis, documentation, gap/fit analysis, impact assessment, & testing and application development
- Experienced in production support and resolving the Sev2 issues. Incidents are worked using the tool HP Service Center, ServiceNow etc.
- Extensive experience in projects like Business Event Qualifier, Pfizer Online Account receivables, Fund Accounting, migration to VS-Cobol, migration of legacy mainframe systems to distributed platforms.
- Supported DB2 application queries in production by handling and determining the root cause analysis for issues as they come up and conducted crisis control while addressing these issues as a key element for keeping customer satisfaction
- Experience in DB2, MS SQL server and Oracle databases.
- Expert in designing and developing COBOL-DB2 batch processes, for varying business requirements.
- Adept in DB2 Query optimization/Access path modification to save on Mainframe CPU consumption cost.
- Developed and maintained SAS scripts for the Data Analytics reporting.
- Developed Batch monitoring tool and production file extraction through REXX.
- Developed multiple reusable queries which created SPUFI and QMF, Created multiple reusable jobs throughEasytrieve.
- Experience working in an Agile scrum team& Kanban leading daily stand up calls and the traditional Waterfall methodology of Software Development Life cycle.
- Experience in all stages of the Software Development Life Cycle - Requirements Analysis, Preparation of High Level and Low Level Design documents, Coding, Unit, Integration, System and Functional Testing, Implementation and Warranty Support.
- Hands-On Experience in developing COBOL-DB2 Stored Procedures that can be accessed by Web Services Front-End developed using JAVA.
- Experience as a Business analyst developing Business Requirement documents, Functional requirement documents and Specification documents for the Portfolio Minder and Performance initiatives in Performance reporting
- Experience as a Technical lead and SME managing a team of up to25 direct reports including offshore and onsite.
- Data-Mining using SPUFI, QMFand developing statistical reports in Excel, Easytrieve, SAS.
- Expertise in DB2 system, Assisted in database and application tuning for optimal performance, SQL query tuning to improve performance,data mining, conversion,developing COBOL-DB2 Stored Proceduresthat can be accessed by Web Services Front-End using JAVA, COBOL-DB2 batch programs, CICS application programming, Loaded and refreshed non-production databases for application testing,.
- Overall Responsibilities include creating detailed design, working on development and perform code reviews, implementing validation and support activities in line with architecture requirements, participating in detail requirement analysis and knowledge management activities with the objective of ensuring the highest levels of service offerings to customers in the technology domain, Offshore-coordination and technical mentoring of the team, daily allocation of work to offshore, and review of work done, providing work and deadline estimates, status reporting to the client, experience of mentoring a team, ability to provide suggestions to the client for enhancing the process, exposure to critical path identification and planning
- Terrific objectivity, communication and client interfacing skills and experience of interaction with all stakeholders of the project
- Highly motivated team leader with good problem solving and troubleshooting abilities and the ability to work independently, Quick learner with tremendous interest in learning new landscapes and technologies.
TECHNICAL SKILLS:
Databases: DB2, DB2 UDB, Oracle, SQL, MS Access
DB2 Tools: SPUFI, QMF, FileAid-DB2, EXPLAIN, LOAD,UNLOAD, REORG, RUNSTATS
Languages/Areas/Tools worked on: COBOL 85/Enterprise Cobol, DB2 Application, Microfocus COBOL, JCL, VSAM, CICS, TMON, REXX, IBM Rationale developer, DB2/Native SQL Stored Procedures, DB2 Triggers, Database Design, Database Migration, Database Tuning, Eclipse IDE, JDK, Couch base, Cornerstone, Big Data Core Java, Microsoft Office Suite (Word, Excel, PowerPoint, Visio, Access), PUTTY
ISPF Tools: ChangeMan, Endevor, FileAid, MQMenu, Super-CE, Srch-For, StarTool
JCL Utilities: EasyTrieve, SAS, DFSort, ICETool, ICEMan, Comparex
Output Viewing and Archiving Tools: SAR, TOM, SDSF
File Transfer utilities: Connect Direct, SFTP, FTP, FTPS
Testing tools: Xpeditor, InterTest, IBM Debug
Ticketing tools: Service now, Quality Center, BMC Remedy IT service management, Kanban
Scheduling: CA-7, OPC
Middle Ware: MQ Series
Operating System: MVS z-OS/OS-390, WindowsMF User InterfaceISPF 6.1
PROFESSIONAL EXPERIENCE:
Confidential
System Analyst/Technical Lead
Responsibilities:
- Working as a Lead System Analyst for Business Response Team focusing on Technical and Functional (operational risk) aspect.
- Worked as product owner for the Scrum Team for the project Acquisition Incentive Control.
- Estimate solution costs (Technical & Functional) and benefits and build a business case for implementation
- Involved in project staffing and project management activities like assigning hours, creating DART report, representing team Change Authority Board and working on financials for assigning funds.
- Created Data Analytics report for the different campaign launch using SAS tool.
- Coordinate with offshore team.
- Participating in Business requirement discussion with all the stakeholders
- Daily meeting with all the business partners to understand their current business process
- Understanding, eliciting, documenting and providing solution for the business requirement.
- Worked as product owner for the Scrum Team for the project Acquisition Incentive Control.
- Acquire technical knowledge about their current system
- Preparing the technical approach and estimate the effort for resource allocation
- Creating and thoroughly reviewing design documents and presenting to the project team
- Creating the packages and production move of jobs using change man
- Coordinate with downstream systems to create overlays for different systems by providing necessary files and mapping details
- Scrum Methodology/Framework with carrying out day-to-day duties of Scrum
- Creating and Reviewing all deliverables like Code, Test scripts, Release preparation and documenting them
- Backlog, Sprint Planning, Daily Stand Up Meeting, Demo, Retrospective etc.
- Remove impediments/roadblocks, ensure timely delivery and team management.
- Testing Remediation
- Provide support for moving the code into production and also involve in post-production support
- Analyze any existing production issues that come up by following the entire life cycle process for the same.
- Coordinate with interface system for all data feed and testing coordination
- Create detail task schedule with all milestone activities for production implementation
Environment: Mainframe MVS, COBOL, JCL, Web services, DB2, SPUFI, QMF, CoreJava SORT, Easytrieve, REXX,SAS
Confidential
Technical Lead
Responsibilities:
- As a Lead System Architect I was responsible for end to end delivery for the project from Offshore. Starting from Functional handover of the requirement to the handover modules to production with below responsibilities -
- Planning for Functional design Handover and getting all the business requirement and Acquire technical knowledge about their current system
- Providing estimates based on the requirement and obtaining sign-off from client.
- Worked in Alchemy for Check image processing.
- As a Senior Technical member identify the gap analysis of all the business processes and applications for identification of functions impacted by validating reconciliation of daily reports by performing write-offs, reinstatement etc.
- Involved in Design, Build and Unit Testing of various modules.
- Writing complex reusable SQL queries and JCLs as asset creation.
- Develop and maintain use cases for Disaster recovery practice.
- Preparing the technical approach and estimate the effort for resource allocation
- Creating and thoroughly reviewing design documents and presenting to the project team
- Coordinate with downstream systems to create overlays for different systems by providing necessary files and mapping details
- Creating and Reviewing all deliverables like Code, Test scripts, Release preparation and documenting them
- Provide support for moving the code into production and also involve in post-production support
- As a Senior Technical member Identify and asses impact business processes and applications and provide document/artifacts current state and desired future state of process/application/system.
- Creating the packages and production move of jobs using change man
- Preparation of Test plan & carrying out, Functional testing, Regression testing, Back end testing and Smoke testing.
- Deliver of new and complex high quality solutions to clients in response to varying business requirements enhancements and developments.
- Tracking the changes given by the Client and updating the affected artifacts.
- Preparation of detailed estimates for the various projects scheduled and projects in pipe line for the offshore as well as for onshore resources.
- Perform Transition activities by overseeing the execution of Knowledge Transfer Plans for Offshore resources.
- Coordinate with interface system for all data feed and testing coordination
- Create detail task schedule with all milestone activities for production implementation
- Coding the SAS and COBOL program for generating daily, weekly, monthly, quarterly and annually reports according to the request.
- Preparation and execution of test scenarios/cases/data for System integration testing.
- Preparation and execution of test scenarios/cases/data for regression testing.
- Track and report testing status and defects.
- Validated and ensured Waterfall methodology has been carried out.
Environment: MVS, JCL,SAS, VSAM, DB2, COBOL,CICS, SAS,SPUFI,EASYTRIEVE, CA-7, CHANGEMAN
Confidential
Senior Software Developer
Responsibilities:
- Works on the Data amendment to in corporate the changes in the pricing application.
- Apart from regular BAU work, worked on the value creation like CIs, Automation etc.
- Actively monitor the application as all the applications are time critical.
- Actively worked on the Batch optimization, Query fine tuning and automating the manual process by developing the tool for Batch monitoring.
- During this design phase prepared High & Low Level Design Documents with Application Design Specification from the user.
- Analysis, Design, Coding, testing and implementation.
- Analyze the work request and prepare the detailed technical design document
- Code the COBOL, DB2 programs for extracting the CAD, pricing data.
- Analyze the work request.
- Preparation of Analysis document.
- Coding using COBOL,DB2
- Code review
- Unit testing, Testing and recording of test results
- Impact Analysis
- Writing procedures and JCLs for programs
- Creations of control cards for all type of jobs(FTP jobs and Extraction jobs)
- Submitting Jobs (JCLSs ) for extraction of data from DB2 Database
- Changing the procs according to new requests.
- Creating the packages and production move of jobs using change man
- Creating Easytrieve programs to generate report.
- Day-to-day client management - provide status, discuss queries and issues, seek resolution
- Participate in requirements gathering and analysis activities
- Participation in estimation
- Perform specific life-cycle activities as per plan
- Track post delivery defects and communicate to the project team
- Monitor customer satisfaction
- Escalate issues within client and organization if issues are unresolved
- Develop flowcharts using VISIO
- Coding, Peer code reviews, Unit Testing as per test plans.
- Track defects from code reviews and testing.
- Provide technical support during implementation.
- Ensure effective usage of project specific tools during coding and testing.
- Created tool using REXX for automation of Database load and Unload File comparison
Environment: MVS, JCL,SAS, VSAM, DB2, COBOL, SAS,SPUFI,EASYTRIEVE, CA-7, CHANGEMAN
Confidential
Software Developer
Responsibilities:
- As a Developer I was responsible for coding based on the Business requirements. Worked in migration of the application from COBOL-74 to Enterprise Cobol.
- Extensively writing Mainframe code, writing test cases and performing Unit testing and Assembly testing.
- Review of code.
- Perform specific life-cycle activities as per plan
- Participate in Business Meetings
- Prepare Technical design documents
- Co-ordination between Onsite team and offshore team.
- Client management, provide status, attend client meetings n behalf of offshore team, discuss queries and issues, seek resolution Obtain client sign-offs on project deliverables Monitor customer
- Coding, Peer code reviews, Unit Testing as per test plans.
- Track defects from code reviews and testing.
- Provide technical support during implementation.
- Escalate issues within client and organization
- Create detail task schedule with all milestone activities for production implementation
- If issues are unresolved Track defects from code reviews and testing.
- Provide technical support to the Team members.
- Environment: MVS, JCL,SAS, VSAM, DB2, COBOL, SAS,SPUFI,EASYTRIEVE, CA-7, CHANGEMAN