Sybase ASE developer
Resume:
Gayathri Bhattaram
Business Analyst
ad4kre@r.postjobfree.com
Summary
Technical Project lead & Business Analyst with more than 17+ years in software engineering platform and has delivered many engineered solutions to business in banking domain. Expertise in program and Project leading, technical business analyst, driving core team to deliver the best-engineered solution in both waterfall and agile methodologies and best practices with alignment to business vision and helping customer to meet their business goal.
Review and analyze draft regulations as they evolve (e.g. Basel III) in parallel to project execution.
Collection and analysis of business requirements for all regulatory changes across different countries in EMEA regions business and development of appropriate business solutions.
Develops, plans and actively provides planning support for all design and development of Regulatory Reporting.
Develops, plans and actively provides planning support for all programs/projects in BUK regulatory management programs/projects.
Support communication with stakeholders, including Head of Regulatory Management Portfolio Lead, Business Unit Steering Committees, Operation Owners as required.
Experience in analyzing large volumes of data to identify anomalies.
Analyze datasets to identify affected or in scope populations for new Regulations and applying Legal guidance to date-sets to identify populations for further review.
Liaise with Technical Solutions Design to consider the most appropriate strategic, cost effective and deliverable solutions to problems.
Has extensive experience in project leading including, project task Planning, implementation, Progress tracking, resource allocations, monitoring, daily and weekly reporting, and stakeholder and customer communications.
Very good in building strong relationships between teams within IT Solutions and between IT Solutions and related business teams and maintains professional relationships with peers in other corporations and outside organizations.
Has strong communication and influence skills when interacting with all levels of the organization starting with senior leadership on down to the team members.
Core Competencies
Sybase
Unix & Perl Scripting
Leadership (Program and Project Management)
AWS Cloud
Autosys, Knime, Jenkins other CI Tools
HP Quality control
Agile methodology- Sprint planning, Scrum management, Spring reviews, Story decompositions, tacking and monitoring
Agile techniques like: User Stories, Continuous Integration, TDD, Continuous Integration, Automated Testing
Tools and Technologies
Operating System/Hardware: DOS, Windows 95/97/NT and 2000
Database: Sybase
Other Tools: ServiceNow, Visualizer, SQL Developer
Cloud Solution design and Architecture AWS
HP Quality control
Confluence, ServiceNow, JIRA
Jenkins, GIT
Scheduling Tools - Autosys
Scripting Language – Unix shell scripting
Version Control – Subversion, RTC (Rational Tool Concert) and Bit Bucket
Educational Qualifications
[MCA], [Completed], [Sri Venkateshwara University, Tirupati], [2005] [Full-Time]
Achievements & Certifications
Adaptive Server SQL Developer Associate - Sybase
AWS Certified Solutions Architect – Associate – Amazon
Certified in Knime L1 examination
GEM Award for Q1 FY22, Stellar Award Q4 FY22
Excellent contributor in the project award for 2017
Professional Experience:
Project 1:
Employer’s Name
Virtusa Corporation (CITI Bank)
Project
Edit Checks(Insight)
Role
Business Analyst
Duration
Oct 2022 – till date
Domain
Banking
Technology
Abinitio, Control Center, Java, Tableau, Mhub, Phyton, Parser/Antlr, Automation/RegEx, Mongo Db, Oracle, Hive, Impala
Project Description
Edit Checks refers to automated validations or checks performed on the data submitted by financial institutions in their regulatory reports. These checks are designed to ensure the accuracy, completeness and consistency of the reported information, helping maintain data integrity and compliance with regulatory requirements.
Roles &Responsibilities
Conducted requirements gathering and analysis for regulatory reporting project ensuring compliance with industry standards and regulations.
Collaborated with cross-functional teams in an agile environment to prioritize and deliver regulatory reporting enhancements with tight deadlines.
Facilitated stakeholder meetings to edit requirements, define user stories and refine acceptance criteria.
Participated in sprint planning, backlog grooming and daily stand-up meetings to track project progress and address any impediments.
Utilized the agile tool – JIRA, to manage project tasks, user stories and sprint backlogs.
Collaborate with the Product Owner, development team and other stake holders to refine the user stories as needed. Iterate on the stories based on the feedback and evolving requirements.
Carefully review each testcase to ensure they are clear, comprehensive, and aligned with the acceptance criteria of the user story. Verify the testcases cover all possible scenarios and edge cases.
Once satisfied with the test cases, approve them to indicate that they are ready for execution. Approval signifies that I endorse the test case as appropriate for validating the user story.
Providing constructive feedback to testing team if I identify any issues or areas of improvement in the test case. This feedback can help refine the test cases to enhance their effectiveness.
Communicate the approval of the testcases to relevant stakeholders such as Product Owner, Testing team and development team. Ensure everyone involved is aware of the approved testcases and their role in executing them.
Developed comprehensive user guide documents to facilitate user navigation of the application, delivered at the conclusion of each product increment. This document is served as essential resources for users, providing clear instructions and enhancing user experience.
Project 2:
Employer’s Name
Virtusa Corporation (CITI Bank)
Project
Data Diagnostics
Role
Business Analyst
Duration
Oct 2022 – till date
Domain
Banking
Technology
Abinitio, Control Center, Java, Tableau, Mhub, Phyton, Parser/Antlr, Automation/RegEx, Mongo Db, Oracle, Hive, Impala
Project Description
Data Diagnostics is a process comprised of automated data quality rules checking incoming reporting data elements supported with multiple reports or product specific dashboards to allow users to review and analyse data exceptions impacting the report accuracy. This project is involved in migrating the existing Power BI dashboards into Tableau.
Roles &Responsibilities
Conducted requirements gathering and analysis for regulatory reporting project ensuring compliance with industry standards and regulations.
Collaborated with cross-functional teams in an agile environment to prioritize and deliver regulatory reporting enhancements with tight deadlines.
Facilitated stakeholder meetings to edit requirements, define user stories and refine acceptance criteria.
Participated in sprint planning, backlog grooming and daily stand-up meetings to track project progress and address any impediments.
Utilized the agile tool – JIRA, to manage project tasks, user stories and sprint backlogs.
Collaborate with the Product Owner, development team and other stake holders to refine the user stories as needed. Iterate on the stories based on the feedback and evolving requirements.
Carefully review each testcase to ensure they are clear, comprehensive, and aligned with the acceptance criteria of the user story. Verify the testcases cover all possible scenarios and edge cases.
Once satisfied with the test cases, approve them to indicate that they are ready for execution. Approval signifies that I endorse the test case as appropriate for validating the user story.
Providing constructive feedback to testing team if I identify any issues or areas of improvement in the test case. This feedback can help refine the test cases to enhance their effectiveness.
Communicate the approval of the testcases to relevant stakeholders such as Product Owner, Testing team and development team. Ensure everyone involved is aware of the approved testcases and their role in executing them.
Developed comprehensive user guide documents to facilitate user navigation of the application, delivered at the conclusion of each product increment. This document is served as essential resources for users, providing clear instructions and enhancing user experience.
Project 3:
Employer’s Name
Virtusa Corporation (CITI Bank)
Project
Sybase Exit of LRR
Role
Business Analyst/ Project Leader
Duration
Feb 2022 – Sep 2022
Domain
Banking
Technology
Java, Unix, Hive, Autosys, Oracle, Knime
Project Description
Local Regulatory Reporting (LRR) application gets retired and al the reports should be migrated to Reginsight application.
LRR is built around Sybase and Power Builder technologies currently. Now we are migrating using Citi group’s internally developed ETL tool called “Data Transformation Services” – DTS as initial target and then we gradually migrate all regulator and control reports to the global system called REGINSIGHT.
Roles &Responsibilities
Interacting with clients to understand the new change request
Interact with clients, PA team & Development team to analyze issue and work towards the closure of JIRA’s.
Conduct daily meetings with our Development Team, QA Team and End Users to ensure performance efficiency and to discuss on Open requests.
Schedule regular status calls to keep stakeholders updated about project status.
Regularly monitor the jobs and database in production parallel environments.
Handle data ingestion using autosys, unix and hive technologies.
Logic (stored procedures) conversion from Sybase to Oracle.
Manage team, provide KT across the team and ensure project is delivered as per timelines.
Manage build creation and deployment.
Writing queries to generate required data.
Involved in fixing Production issues
Prepared root cause analysis and ensuring the action points.
Involved in resolving production problems for the applications and ensure all support service level agreement is met.
Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the specifications for the product
Project 4:
Employer’s Name
Virtusa Corporation (CITI Bank)
Project
LRR – Local Regulatory Reporting System
Role
Technical Team Leader & Business Analyst
Project start and end date (MM/DD/YY)
Jan 2019 to Sep 2022
Domain
BFSI/Banking
Technology
Sybase, UNIX scripting, Perl Scripting, JAVA and Autosys
Project Description
Local Regulatory reporting – It is the submission of raw or summary data needed by regulators to evaluate Citi bank’s operations and its overall health, thereby determining the status of compliance with applicable regulatory provisions. Governments across the world give prime importance to keep their banking systems updated.
Roles & Responsibilities
Project Technical Lead.
Understand the functional requirements directly from Client’s Business Analyst and convert them into Technical Designs.
Requirement analysis, High Level and low-level design for development.
Creating Technical work order documents.
Unit Test Case preparation, execution and getting the result verification done in SIT and UAT as well.
Involved in migrating code from Dev to SIT/UAT by creating a package which holds the codes changes using Jenkins and Bit bucket.
Acquiring data from primary or secondary data sources and maintaining databases.
Supporting the project in warranty.
Scheduling jobs via Autosys.
Writing Unix/Perl scripts to load the feed data shared by upstream sources into our LRR application.
Performance Tuning.
Handling the CCB meetings.
Created few automated scripts which reports us the daily free memory size available on both database and application servers.
Used to communicate the Client goals, safety practices and deadlines to team.
Acts a bridge between technical and business in translating the requirements.
Changes depending on the user requirement.
Project 5:
Employer’s Name
Polaris Consulting & Services limited (CITI Bank)
Project
CATE – GERS
Role
Development Team Leader
Project start and end date (MM/DD/YY)
July 2015 to Dec 2018
Domain
BFSI/Banking
Technology
Sybase, UNIX scripting, Perl Scripting, JAVA and Autosys
Project Description
GERS is a critical component of DSP (Data Solutions Portal). It extracts the DB entitlements data (Ex logins, roles, groups, permissions) from database systems across CITI and stores it into its central database. Meanwhile GERS feeds the logins, groups and roles to CISAR where the Application Managers can map them. When the logins are mapped, GERS feeds their database entitlements data to EERS for the manager or owner review. In addition, the entitlements data can be viewed in DSP portal and Virtual Reports.
Roles & Responsibilities
Technical Lead.
Understand the functional requirements directly from Client’s Business Analyst and convert them into Technical Designs.
Requirement analysis, High Level and low-level design for development.
Creating Technical work order documents.
Unit Test Case preparation, execution and getting the result verification done in SIT and UAT as well.
Involved in migrating code from Dev to SIT/UAT by creating a package which holds the codes changes using SVN and Hermes.
Acquiring data from primary or secondary data sources and maintaining databases.
Supporting the project in warranty.
Scheduling jobs via Autosys.
Writing Unix/Perl scripts to load the feed data shared by upstream sources into our LRR application.
Performance Tuning.
Created few automated scripts which reports us the daily free memory size available on both database and application servers.
Project 6:
Employer’s Name
Polaris Consulting & Services limited (CITI Bank)
Project
Intellimatch
Role
Team Lead/Senior Developer
Project start and end date (MM/DD/YY)
May 2011 to June 2015
Domain
BFSI/Banking
Technology
Sybase, UNIX scripting, Perl Scripting, JAVA and Autosys
Project Description
IntelliMATCH is a tool used for reconciliations in banking firms. CITI bank is using this tool for Derivative trades reconciliations. This tool needs GMI/Broker files to verify the transactions done on last trading day. Our team involves in setting up new or enhancing Broker file collection jobs and setting up new reconciliations in IntelliMATCH.
Roles & Responsibilities
Understand the functional requirements directly from Client’s Business Analyst and convert them into Technical Designs.
Requirement analysis, High Level and low-level design for development.
Creating Technical work order documents.
Unit Test Case preparation, execution and getting the result verification done in SIT and UAT as well.
Involved in migrating code from Dev to Testing by creating a package which holds the codes changes using SVN and Hermes
Acquiring data from primary or secondary data sources and maintaining databases.
Supporting the project in warranty.
Scheduling jobs via Autosys.
Writing Unix/Perl scripts to load the feed data shared by upstream sources into our LRR application.
Connecting with Regional Exchanges directly to discuss on the required feed data and establish a connectivity between the Exchanges and our application.
Performance Tuning.
Perform volume testing.
Project 7:
Employer’s Name
Polaris Consulting & Services limited
Project
ETD (Exchange Traded Derivatives)
Role
Team Lead/Senior Developer
Project start and end date (MM/DD/YY)
September 2010 to April 2011
Domain
BFSI/Banking
Technology
Sybase, UNIX scripting, Perl Scripting, JAVA and Autosys
Project Description
ETD (Exchange Traded Derivative) is a back office system, developed around Clearvision and GMI to capture, route trade executions from exchange to middle offices for trade allocations followed by trade-matching and confirmation (Clearing) to exchange and finally to GMI for trade position maintenance which is followed by feed distributions to other downstream systems in European, US and Asia-Pacific Markets.
Roles & Responsibilities
Understand the functional requirements directly from Client’s Business Analyst and convert them into Technical Designs.
Requirement analysis, High Level and low-level design for development.
Creating Technical work order documents.
Unit Test Case preparation, execution and getting the result verification done in SIT and UAT as well.
Involved in migrating code from Dev to Testing by creating a package which holds the codes changes using SVN and Hermes
Acquiring data from primary or secondary data sources and maintaining databases.
Supporting the project in warranty.
Scheduling jobs via Autosys.
Writing Unix/Perl scripts to load the feed data shared by upstream sources into our LRR application.
Performance Tuning.
Perform volume testing.
Monitoring the scheduled jobs on daily basis
Project 8:
Employer’s name
Future Focus Infotech Pvt. Ltd.
Designation
Software Engineer
Employment start and end date (MM/DD/YY)
Feb 2010 to August 2010
Domain
BFSI/Banking
Technology
Sybase, UNIX scripting, Perl Scripting, JAVA and Autosys
Project Description
Client TCS
NAPOLI is a central data repository for cash equity product. It positions trade data, delivers trade data to the settlement system (MOSS) and returns settlement results (dividends, coupons) to regional databases so that P&L processing in SCALA can be completed. NAPOLI contains 4 Databases, one consolidated and three regional which are in London, New York & Tokyo. Each regional Napoli contains all trades and value date positions for all books defined under that region.
Consolidated Napoli contains trade, value and physical positions for all equity books. Its responsible for the generation of trade and value date accounting events and for the recording of the settlement status of stock and cash.Key Features of Napoli are:
create positions – trade data and value data positions for P&L and accounting purposes
generate PFX trades for cross currency trades and route to Pyramid
feed MOSS with trades and receive settlement details from MOSS
generate dividends and coupons for all equity positions
Roles & Responsibilities
Senior Developer
Understand the functional requirements directly from Client’s Business Analyst and convert them into Technical Designs.
Requirement analysis, High Level and low-level design for development.
Creating Technical work order documents.
Unit Test Case preparation, execution and getting the result verification done in SIT and UAT as well.
Involved in migrating code from Dev to Testing by creating a package which holds the codes changes using SVN and Hermes
Acquiring data from primary or secondary data sources and maintaining databases.
Supporting the project in warranty.
Scheduling jobs via Autosys.
Writing Unix/Perl scripts to load the feed data shared by upstream sources into our LRR application.
Performance Tuning & Perform volume testing.
Monitoring the scheduled jobs on daily basis
Project 9:
Employer’s name
Teamware Solutions
Designation
Software Engineer
Employment start and end date (MM/DD/YY)
June 21st 2007, to April 31st 2008
Domain
BFSI/Banking
Technology
Sybase 12.5, Unix, ASE isql, Eclipse
Project Description
Client - TCS (JP MORGAN CHASE, COLUMBUS, Ohio)
NECTAR ( Net Equity Commission Generation) - NECTAR is one of the Data Warehousing application of the “Client Profitability” Project of JPMC. NECTAR receives data feeds from various source systems (spread across 3 regions: Asia-Pacific – AP, Europe/Middle East/Africa – EMEA and North America – NA) on various trades executed by the Sales Team of JPMC. The data feeds comprise of the trade level information and the salesperson commission level information. The commissions are calculated and stored in the database of NECTAR application. This data is further sent to a downstream application ARTEMIS as flat files and all reports are generated by the business users from ARTEMIS using Business Objects.
Sub Module - Data Validation Tool - DVT is an electronic tool available to a widely distributed geographic group of data validation participants that allows for a side by side comparison of converting one trust data to another trust and provides a mechanism for accepting or rejecting converted data and to note exceptions.
The focus of the DVT is to provide an electronic data validation tool for the test and live synoptic conversion events.
Roles & Responsibilities
Understand the functional requirements directly from Client’s Business Analyst and convert them into Technical Designs.
Requirement analysis, High Level and low-level design for development.
Creating Technical work order documents.
Unit Test Case preparation, execution and getting the result verification done in SIT and UAT as well.
Involved in migrating code from Dev to Testing by creating a package which holds the codes changes using SVN and Hermes
Acquiring data from primary or secondary data sources and maintaining databases.
Supporting the project in warranty.
Scheduling jobs via Autosys.
Writing Unix/Perl scripts to load the feed data shared by upstream sources into our LRR application.
Performance Tuning.
Perform volume testing.
Monitoring the scheduled jobs on daily basis
Project 10:
Employer’s name
Indian Space Research Organization
Designation
Programmer
Employment start and end date (MM/DD/YY)
June 2005 till June 18th 2007
Domain
Indian Space Research Organisation
Technology
SYBASE 11.0/12.5, Borland C++ Builder 6.0, Windows 98/XP
Project Description
COWAA (Computerized Working of Administrative Areas)
The COWAA project is aimed at computerizing various tasks carried out in areas like ACCOUNTS, ADMINISTRATION, DBA, FINANCE, PAYROLL, PURCHASE and STORES. The development of the project has been done with the end user’s minutest requirement carrying top priority. The overall structure of the project resides over certain standards, which are apparent in each of its functionality. The project has been implemented at all the centres of ISRO. It has one more module called LPGS which means - LAUNCH PASS GENERATION SYSTEM. This module is used to issue entry passes to different categories of people who visit the Centre for various purposes only for Launching day. Some of the categories are Employees, Contractors, Casuals labors, Apprentice, Project trainees, Visitors, Dependents of employees, etc. Pass ID is auto generated. Security has been built so that only authorized users can operate this system.
Reports: Some of them are total number of passes issued on a given day, for a given category, for a given contractor, etc. These reports can be viewed according to the user’s need.
Roles & Responsibilities
Understand the requirements from the ISRO COWAA team head directly and convert them into Technical Designs.
Creating Technical work order documents and Unit Test Case preparation, execution and getting the result verification done in SIT and UAT as well.
Involved in migrating code from Dev to Testing by creating a package which holds the codes changes using SVN and Hermes
Acquiring data from primary or secondary data sources and maintaining databases.
Performance Tuning.
Perform volume testing.
Monitoring the scheduled jobs on daily basis.
Create a release package and support the release.
Contact this candidate