SUMMARY:

• Confidential has an overall 13+ year of experience in Information Technology in which he has dedicated Six years of expertise in financial services industry for Domestic and International Equity, Fixed Income, Derivatives, and Alternative Asset market
• Analytical and detail - oriented, able to identify and implement process improvements that results in increased accuracy, efficiency, and consistency
• An energetic leader, able to communicate effectively with people of all varying levels of expertise and experience, to work collaboratively to resolve problems, and to motivate team members to achieve personal and organizational objectives.
• Ability to manage large scale programs with aggressive timelines and efficiently manage cost and resources.
• Hands-on experience in translating business requirements in to detailed design, program specs, coding, testing and installation.
• Conduct requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Excellent knowledge in building data warehouse, downstream feeds, reconciliation and valuations/white labeled/regulatory/performance reports.
• Experience with RPA tools such as Blue Prism
• Proficient in developing VB macros for Automating Business Operation
• Assist QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Excellent knowledge in SQL queries and worked on different database like Oracle & DB2 Database
• Good knowledge in Hadoop Eco System (Pig, Sqoop, Flume, Hive etc) and with accomplished Hortonworks HDP certification.
• Proficient in developing complex reports using Crystal reports, Coric, Eglue.
• Experience in using tools like TRITUNE for optimizing the Code & SQL performance.
• Excellent technical skill in mainframe using COBOL, DB2, JCL,VSAM, Natural/ADABAS and mainframe tools and have IBM S/390 certification.

TECHNICAL SKILLS:

Hardware: S/390, Intel Pentium PCs

Operating System: IBM’s OS/390, MVS, and Microsoft Windows

Technology: Hadoop/Hadoop Ecosystem (Pig, Hive, Sqoop, Flume)

Programming Languages: COBOL,JCL,VB,NATURAL,FOCUS, REXX, CICS

Databases & Tools: VSAM, SQL Server, IMS DB/DC, ADABAS,DB2, Oracle

Reporting Tool: Crystal Report, Eglue, Coric

Other Utilities: Expediter, Panapt, SDFII,SCLM,FILE Aid, MQ Series, Peek, Endeavor, File Marvel,, Rapid SQL, XML editor, Intertest

RPA Tool: Blue Prism

PROFESSIONAL EXPERIENCE:

Confidential

Operating System: IBM’s OS/390, MVS, and Microsoft Windows

Tools: Crystal Report,Coric,COBOL, DB2, JCL, FILE AID, SCLM, MQ Series, REXXTeam Size 20

Business Analyst / Project Manager

Responsibilities:

• Analyze the Business Requirements provided by the business partner and prepare the detail technical design (DTD) for the same
• Work with business partners to clarify requirements and ensure that project design meets business requirement.
• Propose solutions that meets the agreements between the stakeholders.
• Conduct requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Studies the various internal system of the client along with a team of software professionals at Onshore/Offshore and provides estimation for the business requirements and calculate the fund required for the same
• Build reports using Crystal report, CORIC and schedule the reports.
• Assist the Support team in understanding the business queries and help them is analyzing the root cause.
• Prepare system test cases and review with business to evaluate the system’s compliance.
• Prioritizes the projects and assigns it to the resources.
• Review analysis done for critical projects to make sure business needs are met and review the deliverables before they are implemented in production.
• Make sure the team meets contractual level agreements for the CMR application - Service Level agreements like First Time Right, Effort Variance.
• Conduct team meeting and review the status of all ongoing projects and address the issues/concerns of the team..
• Manages the leave requests by approving/denying necessary leave requests to ensure coverage for the application is met.
• Prepares in the invoice at the end of every month and provides forecast to Senior management based on pipeline requirement and resource needs
• Conducts performance reviews and set up goals for the year for direct supervisees which will be in alignment with the organization goals.
• Identifies and recommends trainings for associates based on project needs and manages the performance of direct and indirect supervisees through performance feedback

Confidential

Operating System: IBM’s OS/390, MVS, and Microsoft Windows

Tools: COBOL, DB2, JCL, FILE AID, SCLM, MQ Series, REXXTeam Size 8

Team Lead

Responsibilities:

• Analysis of functional and business requirement provided by business analyst.
• Prepares the design models in Visio tool to diagrammatically represent the flow of the trades.
• Development of code as per the business requirements
• Unit Testing and System integration testing of the developed code
• Estimates the business requirements for calculating the fund needs
• Providing fixes to the issues identified in the testing phase.
• Modification or enhancement of the modules according to the change request or requirements.
• Impact analysis of the changes to minimize the risks involved in the code release.
• Guided the users for testing the requirements in User Acceptance Environment (UAT) through detail documentations.
• Mentors the offshore team members and guide them in translating the business requirement in to a detail technical design and thereafter to develop optimize code.
• Reviews the Design, Code done by the team members. SLA (Service Level Agreement) is processed behalf of the project, attends the Quality audits at the time of release.
• Use tool like Cognizant20 and Prolite in tracking the efforts for the project and reports the metrics and conduct Offshore/Onshore meeting
• Used crystal report to generate the trade reports and schedule them in the BOE (Business Object Enterprise).

Confidential

Operating System: IBM’s OS/390, MVS, and Microsoft Windows

Tools: COBOL, IMS DB/DC,FOCUS JCL, FILE AID, SCLM, MQ Series, REXXTeam Size 8

Developer

Responsibilities:

• Understood the scope of the project and prepared a Business Rule Extract (BRE) document.
• The prepared document was used to the set the HLBR (High Level Business Requirements) for the proposed system
• Use wide range of technology for analysis, debugging and coding.
• These included COBOL, FOCUS, VSAM, IMS DB/DC and JCL, for system programming.
• The Upstream and Downstream feeds were examined for their usability in the new system.
• Prepared the Sunset of the interfacing system based on the analysis document.
• Database architecture of the existing system was analyzed and documented, which was effectively used for migrating the mainframe application to new system Portfolio Genius.
• Map the database fields from IMS DB to the new system DB architecture.
• Develop code in extracting the data from IMS DB converts the data to the new schema.
• Enhancement and maintenance of the existing system based upon the request. involved in the induction process of new members to the team. He was successful in mentoring the team members through various phases of the system design.

Confidential

Operating System: IBM’s OS/390, MVS, and Microsoft Windows

Tools: Natural, JCL, ADABAS, VSAM,MQ Series

Developer

Responsibilities:

• Analysis of functional and business requirement provided by business partners.
• Application Development using Natural/Adabas as per the business requirements
• Unit Testing and System integration testing of the developed code
• Providing fixes to the issues identified in the testing phase.
• Modification or enhancement of the modules according to the change request or requirements.
• Impact analysis of the changes to minimize the risks involved in the code release.
• Prepare system test cases and review with business to evaluate the system’s compliance.
• Analyze long running job and propose improvement to reduce the run time
• Work on handling defects post implementation to ensure speedy closure of issues thereby bringing in stability to the system
• Application Maintenance was done to modification or enhancement the modules according to the change request or requirements

Confidential

Operating System: IBM’s OS/390, MVS, and Microsoft Windows

Tools: COBOL, JCL, CICS, VSAM

Developer

Responsibilities:

• Application development using Cobol code.
• Enhancements to the system
• Performance improvement of long running jobs.
• Modifications and support via Change requests, ADHOC requests and Production problem requests.
• Write VB Scripts, which are used to download data from LPC Server to Confidential .
• Long-term fix for recurring production defects.
• New Product Enhancements.
• Regular Application Maintenance tasks.
• Production fixes

Confidential

Operating System: Microsoft Windows

Tools: VB, SQL Server

Developer

Responsibilities:

• Application development using VB & SQL Server
• Analysis, test case preparation, coding, testing and documentation.
• Analyze and resolve problems during regression testing.-
• Handle Production problem requests
• Enhancements to the systems.
• Long-term fix for recurring production defects.
• New Product Enhancements.
• Regular Application Maintenance tasks.
• Production fixes