Summary

• 8 years of experience in Business Requirements gathering, Analysis, Design & Data Modeling, Development, Testing and Documentation of Banking and Financial Services
• 6 months of experience in Salesforce dot com (SFDC) implementation & Force.com platform.
• Experience in Salesforce.com configurations by creating custom objects, various types of custom fields, links, buttons, record types, page layouts, user profile, workflow approvals, triggers, data validation and Analytics.
• Hands on experience in Apex language and Visual force page design.
• Expertise in SFDC CRM , data migration, self service portal.
• Expertise in creating/using Apex classes, Standard Controllers, Custom Controllers.
• Experience in SOQL and SOSL.
• Expertise in COBOL, DB2,IMS, Syncsort, VSAM, CICS, Procs.
• Extensive knowledge in Insync and File Aid - file and data management solution in Mainframes
• Proficient in running batch jobs by creating Job Control Language (JCL)
• Expertise in scheduling batch jobs using CA-7
• Extensively worked on monitoring production batch jobs using SAR
• Excellent knowledge in data mapping, data migration and data integration on multiple environments
• Proficient in debugging COBOL and CICS programs using Tracemaster, Expeditor and Dumpmaster
• Expertise in Virtual Storage Access Method (VSAM) to process data efficiently
• Extensive experience in data conversion from various legacy systems
• Excellent proficiency in creating SQL Processing Using File Input (SPUFI) that supports online execution of SQL statements from a TSO terminal
• Knowledge of SAS code conversion into COBOL
• Basic knowledge in MQ series and Easytrieve.
• Extensively worked on Software Control Management and reporting tool for element turnover to various testing and production regions
• Worked on defect tracking Tool Remedy 7 to fix tickets/ issues raised in testing/Prod regions
• Expertise in Banking and Financial domain
• Excellent problem solving skills with good interpersonal skills, Quick learner and excellent team player
• Excellent Written and Verbal Skills

Education

• B-Tech in Computer Science & Engineering.

Skills Summary

Force.com:

Custom Objects, Custom tabs, Custom field, Security, Dashboard, Profiles, Page layouts, Validation Rule, Workflow rules, Apex Language, Apex Standard Controllers, Apex Custom Controllers, Apex triggers, Visual force pages, Force.com IDE, Eclipse, SOQL, SOSL,HTML, Reports

Languages:

COBOL, CICS, JCL, Procs, MQseries, VSAM,Syncsort

Web Technologies:

HTML, Javascripts

Databases:

DB2,IMS

Products/Tools:

Endevor, CA-7, Insync, Tracemaster, Dumpmaster, SAR

Domain:

Banking & Financial Services

Operating Systems:

Windows NT/2000/XP, Linux.

Reporting Tools:

SCM, Remedy 7

Professional Experience

Confidential,San Jose, CA Jun’11 till Date

Salesforce Developer :
Confidential,is a consulting firm that has marketing team that markets consultants to clients. Project involved in implementing marketing, support and tracking of marketing consultants to the job market and tracks the activities and time sheets of the employees. Worked on both SFDC standard and custom objects, fields, relationships, triggers, Workflow and analytics to create reports for weekly or monthly progress.

Responsibilities:

• Business requirement gathering with the consultants.
• Prepare functional design ER diagrams.
• Utilize standard Salesforce objects as much as possible for ease of implementation.
• Created user profiles, Security controls and shared settings.
• Worked on various SFDC standard objects such as Accounts, Contacts, Reports, Dashboard, Opportunity, Contracts, Cases, and Solutions.
• Implemented field level security, profiles.
• Created the workflows for automated task creation for employees, alerts and notifications.
• Created various reports (Summary reports, matrix reports, pie charts, dashboards) and setup report folders to authenticate users based on their profiles (permissions).
• Designed developed and deployed Apex classes and Apex triggers for various for various functional needs in the application.
• Migrated data from Excel to Salesforce using Apex Data loader.
• Provide training to the internal business users to use the application and develop their own custom reports.

Environment: Salesforce.com platform, Apex language, workflow & Approvals, Reports, Standard & Custom objects, Tabs, Security Controls

Confidential,CA April’11- Jun’11

Salesforce Developer :
Confidential,is a consulting firm that provides excellent services to clients. Client being a cable service firm involved in consolidating customer information company wide and streamline process. Implemented a system to track all the customer requests and issues and route the task to the right employee with the help of standard and custom objects, fields, triggers, workflow and validation rules.

Responsibilities:

• Business requirement gathering with the consultants.
• Design database using Microsoft Vsio.
• Prepare functional design ER diagrams.
• Involved in Salesforce.com application and customized apps to match the functional needs of the client.
• Migration of data from excel to Salesforce using Apex data loader.
• Created page layouts to organize fields, related list and other details on a record detail and edit page.
• Implemented pick lists, dependent pick lists, lookups, junction objects, master details relationships, validation and formula fields to the custom objects.
• Worked on various SFDC standard objects such as Accounts, Leads, Contacts, Reports, Dashboard, Opportunity, Contracts, Cases, Solutions.
• Created the workflows for automated task creation for employees, alerts and notifications.
• Created various reports (Summary reports, matrix reports, pie charts, dashboards).
• Designed developed and deployed Apex classes and Apex triggers for various for various functional needs in the application.
• Developed Visual force pages, Visual force Custom Controllers Components.
• Provide training to the internal business users to use the application and develop their own custom reports.
• Performed the role of support engineer and helped them in getting used to the application, generate reports and save them for further access to the users.

Environment: Salesforce.com platform, Apex language, workflow & Approvals, Reports, Standard & Custom objects, Tabs, Security Controls.

Confidential,CA Feb’11 - April’11
SalesforceTrainee :
Salesforce implementation for recruiting firm. Extensive training on Salesforce objects, custom objects, fields, validation rule, workflow approvals, triggers, Apex and visual force. Training involved in making an application for a recruiting firm using the standard objects in Salesforce and create custom objects to support additional functionalities.

Responsibilities:

• Business requirement gathering and Design of process flows and objects.
• Migration of data from excel to Salesforce using Apex data loader.
• Created page layouts to organize fields, related list and other details on a record detail and edit page.
• Implemented pick lists, dependent pick lists, lookups, junction objects, master details relationships, validation and formula fields to the custom objects.
• Worked on various SFDC standard objects such as Accounts, Leads, Contacts, Reports, Dashboard, Opportunity, Contracts, Cases, Solutions.
• Automate creation of tasks to the recruiting employees.
• Developed Visual force pages, Visual force Custom Controllers Components.
• Developed Apex triggers to create complex workflow rules.
• Created user profiles for HR, hiring manager and recruiting employees.

Environment: Salesforce.com platform, Apex language, workflow & Approvals, Reports, Standard & Custom objects, Tabs, Security Controls.

Confidential,, NY Aug’11 -Feb ’11
Senior Mainframe Analyst
Confidential, is one of the largest banking and financial services organizations in the world. HSBC\'s international network comprises around 7,500 offices in 87 countries and territories in Europe, the Asia-Pacific region, the Americas, the Middle East and Africa. HSBC provides a comprehensive range of financial services to around 100 million customers through four customer groups and global businesses: Personal Financial Services (including consumer finance); Commercial Banking; Global Banking and Markets; and Private Banking. Worked on the Decision Analysis team to create credit data repository to support the Basel II architecture for retail banking services.

Responsibilities:

• Business requirement gathering by involving in meetings with the customers.
• Prepare of functional design and technical design specifications
• Business analysis, Coding and Unit testing.
• Monitor jobs using SAR and report and fix issues in case of any abends.
• Scheduling of jobs using CA-7
• Coordination with data quality center team(Trillium)
• Conversion of SAS code into COBOL

Environment: Mainframe
Skill/Tools : COBOL, JCL, Syncsort, VSAM, CICS, DB2, MQ, Endevor, CA-7, SAR, File-Aid, SAS and Expeditor.

Confidential,NJ May ’09 – Jul ‘11
Senior Application Analyst
Confidential,the nation’s oldest operating bank and one of the worlds leading providers of securities services. Pershing helps financial service firms IBD’s by providing the technology, operational, trading, investment and practice management. This billing system in Pershing is based on “Thin Client architecture” with data residing in backend Mainframes. This service model was developed for integrating 12 different billing applications under one umbrella for arresting all financial leakages. This delivers a consolidated, flexible, and comprehensive billing platform; and provides an on-line reporting tool to manage respective businesses for International Broker Dealers and Pershing.

Responsibilities:

• Business requirement gathering by closely interacting with customers and Subject matter Expert.
• Prepare functional design and technical design specification.
• Analysis, Coding, Unit testing, Regression Testing.
• Onsite and offshore coordination and code review.
• Analysis and development of enhancement requests.
• Scheduling of jobs using CA-7
• Worked on Production Fixes – Tickets
• Prepare Develop the Test cases Test scripts & Test plan
• Coordinated with Front end and Testing team in regression and integration testing of the application

Environment: Mainframe
Skill/Tools : COBOL, JCL, VSAM, Syncsort, CICS, DB2, MQ, Endevor, CA-7, SAR, InSync, Trace Master & Dumpmaster

Confidential, Feb ’08 – April ’09
Senior Application Analyst

NTF (No Transaction Fee) reengineering & REDI2 integration system
Confidential,is a leading asset management and securities services company. The system processes the NTF billing through more robust EBS (Enterprise Billing System) billing application and minimizes manual intervention compared to the legacy application. It converts all Fund company/IBD NTF billing schedules to current EBS model. This calculates and manages billing associated with Managed Accounts in our current Enterprise Billing System (EBS) platform.
The system will provide BNY with the ability to reengineer and streamline the overall billing process. It will assist in maximizing BNY’s revenue potential , deliver a consolidated, flexible and comprehensive billing tool and provide BNY and its customers with management reporting to better manage their respective business. BNY has three billing systems and the goal is to create and use a single billing system. REDI2 is a vendor product that has been chosen to compliment EBS.

Responsibilities:

• Involved in meeting with business representatives for requirement analysis and to define business and functional specifications.
• Prepare System Requirement Design (SRD),
• Prepare System External Specification (SES) and System Internal Specification (SIS)
• Analysis, Coding, Unit testing, Regression Testing, Implementation of the new requirements.
• Coordination of activities between Onsite and offshore team.
• Worked on Production Fixes
• Created Test cases and recorded test results for new /enhanced requests.
• Set up the environments in QA and coordinate in testing.
• Monitored the performance during integration testing by viewing the job details with the knowledge of CA7.
• Worked on Screen changes in fields in CICS.
• Coordinated with the front end team in regression testing the Applications

Environment : Mainframe.
Skill/Tools : COBOL, JCL, VSAM, Syncsort, CICS, IMS, MQ, Endevor, CA-7, SAR, InSync ,Trace Master & Easytrieve

Confidential,New Jersey, USA Feb ’06 – Jan ’08
Application Analyst
The company\'s business includes corporate finance, mergers and acquisitions, institutional equities and fixed income sales, trading and research, private client services, derivatives, foreign exchange and futures sales and trading, asset management and custody services. Through Bear Stearns Securities Corp., it offers global clearing services to broker dealers, prime broker clients and other professional traders, including securities lending. Maintenance of the module Global Clearings Systems (GCS) which offers clearing services of funds information from broker dealers, prime broker clients and other traders and processes them and send the processed data for archiving and Database updating. GCS module also interfaces with various front end modules in Java and transfer the processed data to Java screens thru MQ-Series queues. The front-end modules displayed the received data from the MQ-Series directly to the users and clients.

Responsibilities:

• Understanding the Overall functionality of the application
• Monitoring the production jobs and resolving abends
• Working on Enhancements to the basic functionality of the application based on the problems encountered
• Created new procedures for processing of additional brokers and adding new reports
• Coded new Programs to support new functionality in the application using COBOL
• Coded Complex SQL queries to load data into DB2 tables
• Create test cases using only the business/functional and technical requirements as input
• Create test plan with test data requirements
• Test data was created that will trigger all executable statements.
• Scheduling of jobs using CA-7
• Execute unit test using executable components currently coded
• Create test summary report documenting test case, expected result, actual testing result
• Participated in IT testing and Support activities along with Quality Assurance Testing and Documentation.

Environment: Mainframe
Skill/Tools : COBOL, JCL, Syncsort, CICS, DB2, MQ, Endevor, CA-7, SAR, InSync, Trace Master, Dumpmaster & Easytrieve

Confidential,MA Jan ’03- Jan ‘06 Application Developer
Enterprise Billing System - Non-Trade Transaction
Enterprise Billing System is the comprehensive, flexible billing platform to provide billing for all trade and non-trade transactions executed by various IBDs (International Broker Dealer). The scope of this system is to develop core billing functionally for EBS and develop a non-trade fee transaction engine inclusive of the front and back-end components. The system must provide the mechanism to capture and display all components of the negotiated schedule online

Responsibilities:

• Analysis, Coding, Unit testing, Regression Testing, Implementation of the new requirements.
• Analyzed the entire Billing flow of Enterprise Billing System and the impact with other backend and front end system.
• Prepare HLD and LLD for all functional requirements.
• Prepare System Requirement Design (SRD),
• Prepare System External Specification (SES), and System Internal Specification (SIS),
• Develop the Test cases Test scripts & Test plan
• Documented the Flow of Application programs.

Environment: Mainframe
Skill/Tools : COBOL, JCL, VSAM, Syncsort, CICS, IMS, MQ, Endevor, CA-7, SAR, InSync, Trace Master & Dumpmaster