SUMMARY:

• Over 9 years of experience as a Business Analyst in Financial Services industry.
• Worked on projects related to Data Analysis, Business Intelligence, Reporting, designing and building Dashboards and Scorecards.
• Very Strong Analytical Skills, Financial Domain Skills, Technical Skills, Communication Skills and Interpersonal Skills.

INFORMATION TECHNOLOGY EXPERTISE:

Industry Exposure: Financial Services, Banking

Reporting Tools & BI: Crystal Reports, Business Objects Universe, COGNOS, Xcelsius, Tableau

Databases: Oracle, DB2, MS - SQL Server

Statistical / Analytical Packages: SPSS, MS Excel

Programming: SQL, PL\SQL, VB, Java

Financial Skills: Financial / Statistical Analysis, MIS, Financial Modeling, Regulatory Reporting

Project Management: Microsoft Project, Microsoft Office

Business Modeling Tools: Microsoft Visio

Change Management Tools: HP Quality Center, Mercury Test Director

PROFESSIONAL EXPERIENCE:

Confidential, Mt Laurel, NJ

Business Analysis, Data Analysis, BI Developer

Responsibilities:

• Designed Universe and Business Objects Reports and worked extensively on Tableau, TOAD, SQL, Ms Excel
• Wrote complex SQL query for ESRR report and designed the various reports on Crystal reports
• Worked on Impact analysis and code review of current reports for ACBS to Loan IQ migration
• Analysis and Design requirements of reports used MS Excel for Loan IQ

Confidential, Hopewell, NJ

Data Analyst

Responsibilities:

• Analysis and Development of reports for client data for various regulatory agencies like Confidential.
• Designed and documented requirements for customer and accounts information reporting data warehouse
• Worked actively with clients for ad-hoc reporting, self-service training and converting ad-hoc reports to scheduled reports
• Analyzing financial and transactional data using SQL and MS Excel
• Documented High Level and Systems Specifications for data feeds to report Account and transaction data through web services
• Documented requirements for SQL and XML data feeds
• Project management, Systems Analysis and Testing of portfolio management application
• End to end SDLC coordination for database migration, re-design and new UI development

Confidential, Jersey City, NJ

Data Analyst

Responsibilities:

• Generate reports for the senior management for Liquidity Risk by consolidating trade data feeds
• Worked on large datasets with Trade and Position Data, ISIN, CUSIP and Reference data for Securities and Derivatives.
• Extensively worked on SQL queries and Excel worksheets for analyzing, drilling, grouping data by reference and master data elements.
• Wrote complex SQL queries with multi joins for grouping data and identifying duplicate records / erroneous data.
• Documented requirements for a data warehouse for global liquidity program and liquidity reporting.
• Identified and validated data feeds related to Securities and Derivative products.
• Worked on Business Objects Universe for Regulatory Reporting on Enterprise wide Liquidity and Exposure
• Data analysis using excel pivots and macros.
• Analyzed Data models and identified Classes, Objects and object types, defined filters and Multi Joins.

Confidential, NYC

Business / Data Analyst

Responsibilities:

• Extensively worked on Business objects universe for creating customized reports involving customer data.
• Worked on designing a data warehouse and components like Fact Tables, Reference tables and Master and transactional data for commercial banking products.
• Worked across product groups for derivatives, bonds and equities for various reporting needs such as regulatory reporting, risk analysis and performance monitoring.
• Involved in requirements gathering, business process analysis and documentation for building a data warehouse to facilitate regulatory reporting and risk exposure analysis.
• Documented high level and detailed functional requirements, business process workflows, use cases, data maps, data transformations, business rules and hierarchy organization.
• Wrote SQL queries for reporting and presentation requirements and Data Analysis using Pivot Tables, Lookups, and filters in MS Excel

Confidential, Northbrook, Illinois

Business Intelligence Analyst

Responsibilities:

• Designed a data warehouse and Business Intelligence Dashboard for marketing programs and campaign analysis.
• Utilized ETL processes to import and transform data from various sources Excel, Access, and SAS in SAP BW 3.5.
• Worked on Business objects universe and Cubes for data analysis using drill downs, roll ups, slicing and dicing.
• Extensively used Business objects universe for planning and forecasting market behavior, financials and revenue.
• Used Tableau software for designing customer concentration maps and demography analysis.
• Data Analysis in Excel Using Pivot Tables, Lookups, filters in Excel and designed reports in Crystal Reports.
• Implemented RAD for development of a data warehouse for tracking and allocating resources and results.
• Analyzed and documented Database Structures, Schemas and Stored Procedures.
• Created Dimensional Models, E-R Models and Star Schema Models for designing Data Warehouse and Data Marts.

Confidential, Illinois

Business Intelligence Developer

Responsibilities:

• Generated Excel based reports using advanced SQL queries, crystal reports and Business Objects Universe.
• Conducted Extensive Data Analysis on Excel using Models and advanced functions.
• Worked on creating synchronized Data Marts for Data Reporting and Analyzing needs.
• Managed all enhancements from start to completion and was responsible for the reporting of senior management.
• Extensively worked on Business objects Universe, Sybase, Excel, and Toad.
• Developed reporting and analytical functionality for the asset management application and optimized the Business Processes.
• The function of the application was to estimate market risk and measure performance of the asset portfolio.
• Analyzed various risk based models and scenarios as a part of risk estimation and measurement.