Data Analyst

Areejit Banerjee

Sterling, Virginia *****

201-***-**** • ********@*****.*** • www.linkedin.com/in/areejit-banerjee-3137a111/

Business Analysis – Data Analysis – Business Intelligence

Solutions driven Senior Business & Data Analysis consultant with track record of success directing Business Analysis, Data Analysis, and Data Engineering solutions with strong capabilities in analysis, problem definition and requirements gathering aimed at improving data governance, data quality and data analytics capability. Experience implementing Business Intelligence, Advanced Analytics and Data Management solutions for large global clients. Software development life cycle (SDLC) experience including requirements and specifications definition, design, architecture, testing and support in an agile environment. Exceptional communication skills with the ability to maintain cohesive collaborative relationships across teams, management levels and clients. Repeated success in building, leading and mentoring high achieving highly diverse global technical teams.

Core Competencies:

Full Life Cycle Project Management

Data Integration / Data Governance

Agile Scrum Methodology

Business Transformation

Client Relationship Management

Data Lifecycle Management

BI Design

Business Requirements Analysis

Technology Direction

Team Building & Management

Professional Experience

HCL America, Charlotte, NC & Washington, DC 05/2014 - Present

Business Manager

Advisor, subject matter expert and point of contact to senior managers, developers, and analysts on data and business analysis. Interface with diverse range of clients to complete development of sophisticated projects within budget and ahead of schedule. Conceptualize, architect, design and develop data analytic solutions following industry best practices and processes, providing flexible customizations to integrate with process flow and business rules. Deliver custom application migrations, analyse information system needs, evaluate business requirements and design custom solutions for designated customers. Mentor and manage a global team of direct reports, consultants.

Key Projects:

International Finance Corporation / World Bank Group: Data and BI consultant chosen to modernize capabilities by establishing a data mart to facilitate portfolio reporting; implement dimensional data model and lead projects to support planning and implementing the future-state vision of business operations. Lead the scope definition workshops with multiple stakeholders, eliciting, analyzing and documenting complex business requirements and translating them to technical specifications. Develop data catalog with data dictionary, data lineage from source to target and data transformation rules.

Managed multiple projects including integrating multiple source systems into a dimensional data model establishing a data mart facilitating portfolio reporting; implementing self-service layer facilitating ad-hoc report creation and enabling canned reports in SAP BO for various departments.

Developed dashboard for debt and equity portfolio ensuring management reporting of World Bank’s exposure across various corporate dimensions.

Established Portfolio performance analytics capability from cash flow from debt and equity exposure and developed visualization reports on TABLEAU.

Integrated cash flow data to report on Portfolio performance using IRR, public market equivalent and total return matrices.

Leveraged expertise on securities asset class to establish accounting rules reconciling with ledger.

Deployed a fair value movement and portfolio performance reporting solution reducing workhours by over 200 per month and improving calibration of portfolio performance for management reporting.

TIAA Global & Asset Management Technology: Led the management, control and regulatory reporting through integration of securities account system data with operational data layer. Created dash board reports and self-service analytical capabilities on OBIEE platform. Oversaw data modeling, data mapping, data governance and data quality assurance. Transitioned the team from waterfall methodologies to Agile methodologies achieving 100% adoption among the team members. Integrated multiple source systems on time and budget.

Led the ePAM, EAGLE – PACE and EVERST security master data management system integration into investment reporting warehouse facilitating salutatory, control and management reporting.

Subject matter expert and technical advisor on fixed income securities and CAMRA to ePAM migration.

Spearheaded the migration project form CAMRA to ePAM enhancing the capabilities of TAX, GAAP and Management accounting with zero disruption to business operations.

Managed all phases of implementation of Bank Loans module on ePAM ensuring schedule, budget, scope and stakeholder expectations are met.

Incorporated Oracle Data Foundation in solution design allowing for a strong data-oriented perspective, consistent data at the right place and right time.

Prior Experience (2004 – 2014)

UBS, New Jersey, USA – Business Analyst

Deutsche Bank, Singapore – Business Analyst

Bank of Ireland, Dublin, Ireland – Business Process Re-engineering

ASGARD, Perth Australia - Business Process Re-engineering

UBS, Hyderabad, India – Functional Analyst – Investment Banking

Wipro Limited, Kolkata, India – Systems Administrator

Technical Proficiencies

Platforms:

UNIX, Linux, Windows, Mac OS.

Tools & Technologies:

MS Office, MS Visio, MS SharePoint, SQL, Tableau – Desktop, OBIEE, SAP-BO, Advanced Excel.

Business Analysis / Data Analysis Skills:

Requirements Gathering, Elicitation & Documentation; Data Analysis, Data Catalog, Data Dictionary; Preparing data lineage from source to target; Dimensional Data Modeling; Data Transformation, ETL, Data Quality, Data Governance, Business Logic, Reporting Solutions.

Functional Skills:

Portfolio Performance Analysis; Cash Flow Data, Portfolio Reporting, Integrating Securities Account System, Accounts Rules, Account Reconciliation with Ledger; Capital Markets, Fixed Income Securities.

Education and Credentials

Master of Business Administration, Concentration in Finance, Sikkim Manipal University, India

Graduate Certificate in Applied Finance, Colorado State University, Denver, CO, USA

Bachelor of Computer Application, Sikkim Manipal University, India

Certifications

Certified Scrum Master – Scrum Alliance (CSM)

Microsoft Certified Professional (MCP)

Certified CompTIA A+ System Administrator

Accolades

Appraised by Software Engineer’s Institute as Project Quality Analyst and Defect Prevention Analyst in SCAMPI A and SCAMPI B assessment for achieving cMMi Level 5 maturity in my organizational Units.

Awarded distinguished innovator for creating quantitative operational risk measurement framework in Investment Banking operations, IT operations and risk mitigation strategies.

Contact this candidate