SUMMARY:

7+ years of work experience in Investment Management/Asset Management//Real estate Data Analysis, Data Quality Management, Data Management, Data Governance, Metadata and Data Stewardship, Experience with Requirements management, user acceptance testing, Change Management, Reporting, SQL.

CORE COMPETENCIES:

• 7+years of experience in Investment IT Industry in the field of Data Governance, Data Analysis, Development and Business Analysis.
• Worked on Collibra 5.6.4 Integration Data Management Workflow Designs, Administration and Mule soft Development.
• Worked on Collibra administration by creating Communities, Domains, Custom Asset types Relations and managing users.
• Worked on Mulesoft Any Point Studio for data integrations from various source systems to Collibra. Used REST API, JSON and postman to support Data Integrations.
• Used Ataccama IDE for Data Quality Integrations and RDM for Reference Data.
• Worked on Eclipse to Develop workflows using Flowable Designer.
• Extensive data analysis in troubleshooting issues with various reports.
• Experience in designing dashboards and key measurement metrics for data governance and data quality programs.
• Experience with Informatica Data Quality (IDQ) developing matching and data quality solutions.
• Experience with budget cycle and the associated reporting.
• Worked on Hive Big data to do data Analysis using HQL queries.
• Prepared SQL’s to support adhoc customized program reports.
• Gather monthly program status and publish to the program stakeholders using SharePoint.
• Proficiency in AGILE and Waterfall delivery process of software.
• Mentor and coach junior team members, to achieve project milestones in a timely and efficient manner.
• Proficient in coordinating with cross - functional Teams for Data Governance Operations.
• Very strong with workflow diagrams, data flow diagrams using Visio.
• Extensive experience with business requirements, user requirements, functional requirements and nonfunctional requirements
• Experience Setting up interview sessions with various stakeholders like data Owners, data stewards, data custodians, Authoritative data originators and data consumers.
• Experience in test planning, schedule estimates, managing project risks and testing issues.
• Exceptional communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilizing the same in a productive manner.

SKILLS:

Productivity SW: MS Office including, Visio, Word, Excel, Access, Power Point, Internet Explorer, Outlook, Front Page, Change Point, Collibra, Mulesoft, flowable Designer, Ataccama IDE, RDM

Environment: s: Data Lineage, Bloomberg AIM, Eagle Pace, PAS, PAM, Charles River, Bloomberg Terminal, Collibra, Informatica Data Quality etc.

Databases: Oracle 10g, 11g, MS Access, SQL Server 2005/2008, DB2 etc.

Testing: ETL/DB Testing, Black Box, Functional, Integration, System, Regression, User Interface, etc

Testing Tools: HP-ALM, JIRA

Software’s: WINSCP, MS SQL server 2008 Management Studio, SQL Developer.

Data Aggregation: Requisite PRO, JIRA, Microsoft VSS, SharePoint, Uses Cases etc

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Collibra Architect/Analyst

Responsibilities:

• Worked on Collibra 5.6.4 Integration Data Management Workflow Designs, Administration and Mule soft Development.
• Worked on Collibra administration by creating Communities, Domains, Custom Asset types Relations and managing users.
• Experienced in creating metamodel/operating model in Collibra as per Confidential data governance council requirements.
• Worked on Designing and integrating custom workflows based on business needs into Collibra using Flowable Designer.
• Worked on creating /managing user groups assigning roles and permissions based on roles to user groups/users in Collibra.
• Worked on defining scopes for Custom Asset types and existing asset types based on Domain.
• Worked on Integrating reference data into Collibra from various source system’s like Ataccama reference data manager (RDM), PostgreSQL by developing mule flow using database and REST API’s.
• Worked on migration of Collibra DGC from 5.5 to 5.6.1 to 5.6.4.
• Worked on scheduling regular backups from DGC Console.
• Worked on Groovy scripts to perform custom user tasks in Collibra using API Documentation Java code API V2.
• Worked on REST API V2 for performing operations in Collibra using Rest PI.
• Worked on Atacama RDM for extracting reference data.
• Worked on Ataccama IDE to implement Data quality rules.
• Worked on Agile Methodology and Used JIRA for tracking work status based on user stories and tasks.

Confidential, IL

Data Analyst

Responsibilities:

• Define roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company's principal information assets
• Used SQL to extract data for data cleansing
• Gather and report data quality metrics and its measures on a weekly basis.
• General Critical data elements using various methods
• Worked on data components of security master, pricing and XREF.
• Worked on MS Visio for data flow diagrams.
• Created meta data and data lineage for security master and ratings data.
• Create dashboards and publish data error reports for management
• Create Data Quality rules on Eagle Data management system.
• Create and update a data dictionary, with over 1,000 fields, of system and business standards.
• Gather monthly program status and publish to the program stakeholders using SharePoint.
• Worked on Hive Big data to retrieve data from Hive for data Analysis.
• Worked on source to target data mapping by doing Gap Analysis.
• Experience working on UAT and supporting system integration testing for trading system migration projects.
• Good Functional knowledge on Trade Life Cycle of Equity, Fixed Income, FX and Cash.
• Create data requirements for security master, pricing, ratings data domains between Trading, Accounting, performance and data warehouse.
• Used SQL to extract program level attributed to create ADHOC program reports from Microsoft SQL Server.
• Managed and lead the implementation of data governance using Microsoft project, Visio, Power Point, SharePoint tools and multiple training programs.
• Accurately document the current state and target state data and process flows
• Analyze and document the existing systems’ architecture to facilitate an accurate assessment of dependencies between different applications, databases, and impacted functionalities.

Confidential, Jacksonville, Florida

Data Governance Analyst

Responsibilities:

• Worked on Data management interface requirements.
• Creating the business case for the reference data platform and Data Governance.
• Develop enterprise-wide data governance policies, standards and Data Framework to govern full data life cycle including data creation, usage, retention and deletion
• Created data lineage for key performance indicator (KPI).
• Worked with data stewards to create Data Quality rules and Data Quality checks.
• Worked on uploading data using manual templates into Collibra.
• Worked on setting Reference data in Collibra by automating through MuleSoft
• Worked on Modifying Out of the box workflows in Collibra Aa per Business requirements.
• Experience in Informatica Data Quality for cleansing and formatting financial data.
• Used Informatica Metadata Manager and Metadata Exchange to maintain and document metadata.
• Worked extensively in Data analysis and quality assurance.
• Created data quality metrics and provided regular status reports to the management.
• Created Business requirements, user requirements and functional requirements documents.
• Created process flow and data flow diagrams.
• Used Collibra for Data Quality and lineage.
• Perform Reverse engineering on the legacy system and create requirement document for new platform
• Created Test Strategy Planning (TSP) and assisted testing team to implement test plans during UAT kickoff.
• Lead User Acceptance testing coordinated system integration testing.
• Creating data requirements for the feeds across various systems.

Confidential, Ohio

Data Analyst

Responsibilities:

• Worked on Advanced SQL to analyze data on the SQL Server databases.
• Authored the Business Requirement (BRD), User Requirements, Functional Requirements (FRD)
• Worked with development team to implement technical solutions for the investment managers and wealth managers etc.
• Collaborate with interfacing development team to analyze the impact of the requirement.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used JIRA to upload the unit test cases and executed them. And to track any defects in the project during different phases of testing, debugging, investigating and worked towards closure of the defects.
• Prepared time estimates and tracked each task against the estimated task and assisted in keeping project delivery deadline.
• Worked with the UAT team closely in determining both medium and high severity defects, and also fixed the defects before moving into production.
• Supported data quality team by trouble shooting and identifying the root cause issues.

Confidential

QA Analyst

Responsibilities:

• Assist the Program/ Project Manager in defining, documenting, and implementing success milestones for the Project's critical path, and target-dates for the complete SDLC.
• Collaborate with the QA and UAT teams for SIT/ UAT, and RT with QA Team (during STLC (Software Testing Life Cycle), Solutions Architect, and the Developers to prioritize activities revolving around the Data Model
• Data analysis and writing logic to retrieve the data from Centralized database for different types of Orders, Services & Inventory
• Interaction with client right from the requirements stage to delivery of the application.
• Interaction with client about the daily status of the project related activities
• Identify, and coordinate with the stake-holders to verify that the mapping document depicted the desired Requirements/functionalities.
• Collaborate with UI development team the development of User Interfaces, and secure sign offs from the business team in light of the validated Business/ System Use Cases achieving the most intuitive User experience.
• Assist UAT teams from multiple geographies to ensure smooth testing activities with best quality
• Create/ modify Use cases for the assigned projects (Order Management/ Price quoting/ exception, Learning Management System).
• Conduct analysis for change-requests, walkthroughs, advise the concerned Project Managers, BSAs and technical teams on the impacts of the changes
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Prepare and review functional specification (FSD) based on new and changing IT landscape.
• Coordinated the technical work of multiple project teams who are responsible for the development, integration, administration, and evolution of the data warehouse