SUMMARY:

• Over 7+ years of work experience in Business Analysis and Data Analysis in Financial industry. Specialized in Implementation of Financial Tools, Data Governance, Data Lineage, Data Quality, Project Financials, Budgets, Forecasts, Costs, Benefits, Requirements management, user acceptance testing, Change Management, Reporting and SQL
• Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.
• Basel Committee on Banking Supervision (BCBS 239) Regulatory
• Intermediary Holding Company (IHC)
• Decomposition and documentation of Business Lineage and Technical Lineage.
• Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
• Highlighted Data Quality issues and areas of system control gaps
• Linked data lineage to data quality and business glossary work within the overall data governance program.
• Experience in Data Lineage using Excel and Collibra.
• Oversee the configuration of Collibra for reference and master data domains.
• Experience implementing Collibra to automate data management processes.
• Documented business requirements, user requirements, functional requirements and non - functional requirements on trading platform and data hub migration from Bloomberg AIM/Data License to Blackrock Aladdin suite.
• Experience with data conversion stream of trading platform migration.
• Extensive experience in creating data mapping specifications and interface documents.
• Strong in troubleshooting reporting and data issues in identifying the root cause.
• Experience working with Service Now and in supporting the production applications with 24x7 coverage.
• Extensive experience in implementing metadata, Business Glossary, Data Lineage and data quality.
• Exposure to implementation and operations of data governance, data strategy, data management and solutions
• Very Strong experience with order management systems Bloomberg AIM and Blackrock Aladdin
• Expertise in designing the ETL around Aladdin, Bloomberg AIM and accounting systems.
• Worked on implementation of Aladdin Green Package and Bloomberg interfaces.
• Experience in creating Service Level Agreements (SLA) for production support.
• Strong with data validation and data feed support.
• Involved in reviewing business requirements and analyzing data sources from Excel / Oracle / SQL Server for design, development, testing, and production rollover of reporting and analysis projects
• Extensive experience on CAMRA Accounting system.
• Experience with Bloomberg Data License & Terminal Services functions.
• Extensive experience with SharePoint, Visio, Power Point, Microsoft Project and Microsoft Office tools.
• Worked on Excel Macros, Data validation, Data Mapping and Crystal Reports.
• Coordinated with the stakeholders and project key personnel to gather functional and non-functional requirements
• Very good understanding of configuration and maintenance of Fixed Income, Equity, FX, Derivative workflows for Front office, Middle Office and Back office functions to include order management, trade executions, Matching, Confirm/Affirm and Settlement using Bloomberg, Omgeo, Liquidity applications (Tradeweb, Liquidnet, Market Axcess, FIX, BOOM, FIT, FXConnect).
• High proficient with SQL against SQL Server, Sybase, Oracle and DB2 databases using tools like Toad, SQL Programmer and Rapid SQL.
• Worked on upgradation of Eagle STAR
• Strong in leading meetings, preparing agendas, minutes and status reports.
• In depth knowledge, support and training of the complete trade life cycle to the team and the business users.
• Extensive training of trading systems training to all the portfolio managers, analysts, traders and IT.
• Very strong in using Excel API tools for Bloomberg market and reference data.
• Good Functional expertise on Trade Life Cycle of Equity, Fixed Income, FX and Cash.
• Experience with Program Trading, Rebalance of Equity portfolios and assist with other portfolio management functions using Bloomberg.
• Worked on CAMRA Accounting System.

TECHNICAL SKILLS:

• Data Governance
• Data Lineage
• Data Quality
• Collibra
• Project Management
• Business Analysis
• Requirements Management
• Data Analysis
• Investment Management
• Asset Management
• Microsoft Project Server
• Data Modeling
• Data Management & Reporting
• Change Management
• Database Development
• Share Point
• MS Excel
• Agile
• MS Word
• MS Access
• HP Quality Center
• ALM
• Clarity
• Extract
• ETL
• Eagle Star
• Informatica Power Center
• Informatica Data Quality
• Bloomberg
• Aladdin Blackrock
• MS Office suite
• MS Visio
• Oracle 11g
• OBIEE 11g Erwin
• Informatica MDM
• SQL developer
• Toad
• UNIX
• SSIS
• SSRS
• SSAS.

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Data Governance Analyst / Data Analyst

Responsibilities:

• Basel Committee on Banking Supervision (BCBS 239) Regulatory Requirement.
• Intermediary Holding Company (IHC MRA 193)
• Decomposition and documented of Business Lineage and Technical Lineage.
• Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
• Interview with Stakeholders (Subject Matter Expert) to document the transformation logic
• Highlighted Data Quality issues and areas of system control gaps
• Linked data lineage to data quality and business glossary work within the overall data governance program.
• Implemented Data Governance using Excel and Collibra.
• Overseen the configuration of Collibra for reference and master data domains.
• Experience implementing Collibra to automate data management processes.
• Performed an end to end Data Lineage assessment and documentation for select CDEs.
• Gathered requirements by working with the business users on Business Glossary, Data Dictionary, Reference data, and Policy Management.
• Participated in the Data Governance working group sessions to create Data Governance Policies.
• Configuration of Communities, Domains, Asset Model, Relations per MS Data Governance Approach & Requirements
• Custom extracts, reporting, metrics and dashboarding from Collibra
• One-off data loads to Collibra databases
• Collibra Workflow development and configuration based on MS Data Governance Approach & Requirements
• Production quality robustness, monitoring, scripting, auditing
• Collibra UI customization (e.g. page definition overrides)
• Acted as a Data Steward for Reference Data Management.
• Worked with Finance, Risk, and Investment Accounting teams to create Data Governance glossary, Data Governance framework and Process flow diagrams.
• Used Microsoft Visio and Igrafx to draw business process swim lane diagrams.
• Documented controls points, data enhancement processes, and transformation logic identified during stakeholder interviews
• Analyzed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance.
• Performed Dependency Analysis (by identifying any breaks in lineage), root cause analysis and remediation as part of the data lineage effort.
• Tracked metrics/KPIs that provide visibility to management into the lineage progress.
• Provided regular status reports to the management.
• Designed excel Pivot tables and V-Lookup tables to analyze large data.
• Reviewed incoming Data Streams for missing data, corrupt data, and tables/fields.
• Provided estimates to the project managers.
• Implemented the change management procedures.

Sr. Business analyst & Data analyst

Responsibilities:

• Worked on Treasury transformation project in migration of trading system from Bloomberg to Blackrock Aladdin.
• Gathered Requirements and business use cases for Reloading the Rejected Feeds into CAMRA.
• Worked on Bloomberg AIM to Retrieve the market data using BDP functions.
• Worked on Aladdin view and Aladdin security master to check the security data.
• Worked with the data feed requirements from Aladdin to CAMRA accounting system.
• Created the current state and future state diagrams using Microsoft Visio.
• Supported Bloomberg admin functions: Account / Group setup, Broker codes / commission setup, Access / Privileges.
• Worked with the data steward and data owners in creating metadata, Lineage, Data Quality rules and guidelines.
• Created data governance templates and standards for the data governance organization.
• Worked on UAT and parallel Testing on transferring feeds from Aladdin to CAMRA.
• Maintained metrics for the feeds processing into CMARA Accounting system.
• Developed Crystal reports for Operations team to run the daily reports.
• Managed and lead the implementation of data governance using Microsoft project, Visio, Power Point, SharePoint tools and multiple training programs.
• Worked on Excel Macros to transform and Automate the security master Reports.
• Extensive experience in using CAMRA views, Rex reports and uploading feeds into CAMRA.
• Worked on Comerica Automation process to process Comerica feeds to Aladdin.
• Worked on Data Mapping and Data Validation to transform the feeds from Aladdin to Camra Accounting System.
• Used sql server for validating the data using sql query's.
• Worked on Error logs to identify the errors in daily processed feeds.

Environment: JIRA, Aladdin Blackrock, Eagle, Share Point, MS Excel, Agile, MS Word, MS Access, HP Quality Center, UML, ETL, Informatica Power Center 9.X, Informatica Data Quality 9.X, Informatica MDM, Oracle 11g, Erwin, OBIEE 11g, Bloomberg, MS Office suite, MS Visio

Sr. Business analyst/Project coordinator

Responsibilities:

• Worked Wealth Management business process and application simplification initiative to coordinate multiple projects.
• Gathered requirements of PPC by working with the project portfolio managers.
• Participated in the Portfolio Governance and Data Governance working group sessions to create policies.
• Followed up monthly status on 80 programs to report it to the management.
• Documented the reporting requirements to implement new PPM tool.
• Conducted training sessions on governance policies and procedures.
• Used SQL to analyze data on Oracle database
• Created Source to target mapping Documents, business rules, and workflows
• Designed excel Pivot tables and V-Lookup tables to analyze large data.
• Used SQL to analyze data from PPM databases.
• Tested the applications along with the Quality Assurance testing teams.
• Used Microsoft Visio to draw business process swim lane diagrams.
• Crated estimates on the assigned project work streams.
• Provided regular status reports to the management.
• Managed the issues on HP Quality center (ALM).
• Used JIRA to plan and allocate resources
• Implemented the change management procedures.

Environment: Vestek, Extract PPM, Clarity PPM, Reference data, Eagle, Inbound/outbound interfaces, SQL, .Net, JIRA, SQL Server, PL/SQL, Informatica Power Center, Informatica Data Quality, Microsoft Access, Visio, Share Point, HP Quality Center

Sr. Business Analyst

Russell Investments,

• Worked on upgradation of Eagle STAR.
• Gathered requirements by working with the portfolio managers, traders, investment operations, investment accounting users on trade life cycle.
• Authored the Business Requirements (BRD), User Requirements and Functional Requirements (FRD).
• Used Microsoft Visio to draw business process swim lane diagrams and involved in various phases of data modeling process.
• Gathered securities data from various data providers for writing requirements document.
• Facilitated meetings with business users to create source to target data mappings, business rules and data definitions.
• Worked with Data analyst to analyze data elements, data flow and performed data mapping between the existing system and new system to be developed.
• Worked extensively on Eagle environment (UNIX, SQL, PL SQL…etc.,)
• Created events, jobs, workflows, and process initiators in Eagle platform.
• Used Autosys scheduler for scheduling jobs.
• Developed database objects like queries and stored procedures on Eagle environment.
• Involved in designing and developing data management application on with central operational database.
• Worked on designing the Data Warehouse model and the physical structure.
• Experienced in applying the ETL transformations.
• Prepared detailed reports and presentations using SQL and MS Access.
• Involved in the build process and code deployment from development to production.
• Provided regular status reports to the management.
• Tested the applications along with the Quality Assurance testing teams.
• Used ITIL process (Change Management, Issue Management) on HP tools.

Environment: Eagle Star, Aladdin, Bloomberg, Microsoft Project, IBM MQ Series, Reference data, Message Broker, Unix, Autosys Scheduling, Inbound/outbound interfaces, SQL, .Net, Sybase, SQL Server, PL/SQL, Microsoft Access, Visio, Share Point, HP Quality Center, MVC, C#, ADO.net

Business Analyst/Project Coordinator

Responsibilities:

• Define and document customer business requirements, functions, and processes.
• Provide support to technology teams serving as liaison between the business and IT.
• Capture, analyze, and document business and end user requirements.
• Assist in the preparation of the testing strategy and testing the execution plan.
• Document requirements, current status, and changes to existing configurations.
• Gather, analyze, and document practices and workflows to identify efficiencies, alternatives, and gaps.
• Create Use Case Documents, rules, and workflows.
• Facilitate and document QA test plans and specifications, UAT, and post-production roll out.
• Strong experience in conducting UAT and documentation of test cases.
• Provide detailed weekly executive updates.
• Developed Test cases to cover the entire functionality of the site.
• Identify bugs by performing functional and usability testing.
• Involved in requirement analysis, process analysis, design and development.
• Authored the Business Requirement (BRD), User Requirements, Functional Requirements (FRD)
• Gathered requirements by working with the relationship managers, wealth managers and field agents.
• Worked on Use Case diagrams in gathering requirements
• Used SQL to analyze data on data bases
• Performed Backend Testing by executing SQL queries.
• Generated Data Driven scripts that access the backend database.
• Involved in developing test plan for the entire application. Developed test cases after analysis of the Business requirements and Business Use cases.
• Participated in various meetings and discussed Enhancement and Modification Requests.
• Interacted with all the developers to report defects and to get the build status of the application.
• Wrote Microsoft Excel Macros. Worked with the share Point sites.

Environment: Java, JIRA, SharePoint, Power Point, Oracle 10g/11g, SQL*Plus, Shell Scripting, Windows-NT, Red hat Linux, Rational Rose, MS Office Suite, Oracle9i, Windows NT/XP, Business Objects, Web Services, UML, HTML, CSS, WSAD, Web sphere 5.1, .Net