Summary

Over 15 years of experience as Programmer Analyst with full SDLC of various projects, financial applications and databases in a variety of environments with expertise in client/server environment. My understanding of stimulating growth in the organization, identifying cost reduction opportunities, managing client expectations and business relationships are key strengths of my career. Expertise in financial tools like Bloomberg's API, Geneva TLM reconciliation and Intra-Day cash management makes me strong candidate to add value in company's growth.

Core Competencies

Professional Experience

Confidential

Data Modeling/Data Analyst

Responsibilities

• Spreadsheet Modeling for Analytics to measure forecast member based revenue, acquisition and retention trends using historical data.
• Developed forecasting models to examine company's projected short- and long-term growth based on key indicators, sales projections, cash flow analysis, valuation, assets, liabilities, and credit risks.
• Designing and normalizing of database tables, choosing keys and determining integrity constraints and identifying and enforcing relationship.
• Data analysis using Hyperion Essbase excel Add-in using cubes Measures Dimensions
• Designing customized Add-ins XLA and tool bars using VBA forms and macros to provide user friendly reporting capabilities and to apply security model for data access.
• Executed processes for identification and documentation of functional requirements and mapping.
• Writing queries and store procedure to aggregate data and generated sales and revenue reports for senior management.

Confidential

Financial Data Analyst/Report writer

• Data Analysis, gather requirements and formulated the functional reports for clients.
• XLA Add-in for all financial reporting to server financial reports.
• Designing Excel and Access applications using VBA, ODBC and MS-Query to integrate data from streams.
• Designing product master and historical pricing for products
• Close interaction with business user to understand and define business process.
• Designing spread sheets Models for rating methodologies and applying business rules based on their strategic and predefined policies.
• Designing Interactive spread sheet Models based on real time pricing to calculate Current, MTD and YTD PNL for different franchises
• Coordinating financial factors, reporting and calculating Trend Analysis based on historical and current year data.

Confidential

Responsibilities

• Monitored and review Suspicious Activity Report on client, updated Access database with CIP information and Performed risk score for business entities Searched for the existence of clients using Excel/VBA l spread sheet models
• Identify and report Money Laundering as required by Bank Secrecy Act and Anti-Money Laundering Legislation for Private Bank Consumer, Corporate Bank and /or Cash Letter Intl and Domestic relationships.
• Designing Business Templates Excel XLT for towers and applying business rules based on their strategic and predefined policies
• Financial reporting using data cubes, Pivot tables, Graphs and score card matrix
• Interact with Bank Management on suspicious transactions conducted by customers Review and investigate incoming and outgoing Wire Transfers and review accounts for AML/KYC and compliance policies.
• Examined account documents as well as using internet based websites for identifying institutional and retail clients

Confidential

System/Programmer Analyst

Responsibilities

• Responsible for day to day IT operations and production support for In-house applications.
• Building system Architect , database modeling and identifying risk and dependencies for project
• Resource allocation, distribution of work and tracking development activities for internal and offshore teams in India.
• Designing Excel and Access applications using VBA, ODBC and Ms-Query.
• Responsible for database design including determining various entities and their attributes, finding the relationships between different entities, designing and normalizing of database tables, choosing keys and determining integrity constraints and identifying and enforcing relationship.
• Maintaining over night batch reporting process including snapshot and spreadsheet output format.
• Production support and customer services for day-to-day operational activities.
• Standardizing multiple data sources and building methodologies to validate data integrity across multiple platforms to ensure the successful data delivery for different systems.
• TFS management and task oriented deployment for all projects

Confidential

Responsibilities

• Spreadsheet Modeling for Risk Analytics to calculate technical pricing for causality business
• Designing Excel and Access applications using VBA, ODBC and Ms-Query.
• Responsible for database design including determining various entities and their attributes, finding the relationships between different entities, designing and normalizing of database tables, choosing keys and determining integrity constraints and identifying and enforcing relationship.
• Importing and exporting XLS Templates files for different BAU using VBA
• Excel based app using Visual Basic for Applications VBA , building reports batch process package
• Maintaining reporting process including snapshot and spreadsheet output format.
• Production support and customer services for Underwriters day-to-day financial activities.

Confidential

Beehive is a client server application build on windows platform for capturing trade activities for fixed income, FX, futures and equities across the globe. Application enhanced operational control by securing all trade activities in Asia, EMEA and Europe. System also has the features of importing data from many different sources and creates dashboard reports for different investment types for top management.

Confidential

Forecast engine is a spread sheet model which enables entering and tracking forecasts for servers and storage cost for business streams and to give them an overview of their infrastructure cost over for next five years. Forecast engine interact with internal financial applications and provide approval status for each request made by forecast engine