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:

• Having years of experience in Confidential and Hyperion planning, Financial Data Quality Management, Financial Reporting, Web Analysis, and Smart view Spreadsheet (Excel Add in) template designing
• Extensive experience of SQL Server2000/2005 and Sybase development in writing SQL Queries, Stored Procedures, Indexes, Triggers, views
• Data Net ETL tool to store data into DEV, UAT and production environment.
• Expertise in reporting services and OLAP cubes( SSRS, SISS) Extensive experience in Years of GUI (VBA forms ) development in Excel VBA, user interactive templates, business tier and data access layer, including presentation layer using Ajax 2.0, Dundas Charts

PROFESSIONAL EXPERIENCE:

Confidential

Essbase Developer/Financial Forecast and Data Modeling

Responsibilities:

• Gathered and analyzed business requirements interacting with users
• Design, develop, and implement enterprise-wide budgeting, forecasting and financial cubes
• Responsible for day to day Essbase development and production support for existing application and databases and Optimizing cubes and performance tunes
• Writing Calculation scripts and MDX queries to calculate dynamic members in outline
• Verified member formulas did not break (formulas did not reference any of the decommissioned accounts)
• Build, maintain and troubleshoot Smart View ad-hoc reports and Financial templates
• Experience with calculation scripts, load rules, security filters, ESSCMD and MAXL commands.
• Writing Shell script for automation for data loading and DR backup
• Spreadsheet Modeling for Analytics to measure forecast member based revenue, acquisition and retention trends using historical data.
• Desigingin business Metrics Like Revenue, Retention, Acquisition etc. for business users using smart view and business templates
• Created Essbase groups and security filters in Hyperion Shared Services (HSS).

Confidential

Financial Data Analyst

Responsibilities:

• Conduct project requirement gathering sessions, document project requirements, define tasks, estimate timeline and identify resource requirements.
• Extensively involved in development of Essbase Cubes. Performed dimension build and data load for the Essbase cubes by developing OLAP models and META outlines using ETL tool.
• Developed complex calculation scripts and formulas for the existing ASO and BSO cubes to implement the business logic. This involved using complex functions like etc., "fixing" on sparse and applying conditional "if" statements on dense dimensions.
• Improved the Performance (Optimized the outline, Essbase system) by changing the dimension order using Hour glass method and working on configuration file including Cache design techniques.
• Created MAXL scripts and developed batches scripts to automate them.
• Developed Transparent partition with ASO & BSO cubes to leverage the advantages of both technologies and to manage historical data efficiently.
• Worked on cube enhancement process which involved discussions, designing, and documenting and adding new requirements to existing cube outlines.
• Migrate applications across environments utilizing LCM (Lifecycle Management).
• Developed rules files for data loading using Essbase Administration services(EAS) console
• Design system architecture, DFDs and BRDs for project and LDAP configuration for users.

Confidential

Compliance Specialist

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
• 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
• EXCEL/VBA, COBAM, Excel, Bloomberg API, Access 2000, SQL Server 2008

Confidential

System/Programmer Analyst, New York

Responsibilities:

• Responsible for managing all tactical applications and ensure day to day IT operation for US applications.
• Designing and creating tactical solutions using MS.
• Office tools and integrating third party data for management reporting.Project planning, cross-functional / Offshore team coordination and responsible to provide IT solutions for business initiatives.

Confidential, New York

Casualty Rating and Technical Pricing Model

Responsibilities:

• Model calculate technical rating based on consistently fundamental frequency and severity techniques using default industry parameters plus providing the feature of override-able premium actuaries based on account level data.
• Model also evaluate risk assessment process, accommodate Qualitative rating (Risk Factor) questions, each with fixed response answers and Risk assessment narrative.