SUMMARY

• Worked independently in a fast paced team oriented agile environment and handled basic data model domain, logical, physical, MDM, star and snow lake scenarios and performed complex database queries and done FFGE data analysis and PAS RC database migration using SQL
• Worked as product owner to documents reinsurance Epic/ Stories under Agile environment, Testing Insurance Methodologies, Process and ability to review Functional Test cases
• Handled enterprise wide data modeling FCAP, FDH, Data Mart and R12 G/L business unit and integrating them into MIDF and reconciled resources across R12Hub, Data Mart Securities and settlement using research and analysis for production issues
• Handled planning, logical and physical, S2T Data Mapping, Identification of the right source for the standard out bounds, elimination of data redundancies, Data Profiling, TraceabilityData Quality, creating control scripts to identify data quality issues thru the operational control framework,Data Management
• Provide data design, data analysis and data quality control oversight for the TIR reporting initiatives which are functionally being merged
• Performed data analysis on source system data for documenting ETL mapping and transformation rules with the Technical Business Analyst within architecture and documenting inside and outside data flow
• Transformed business requirements into an efficient, scalable and flexible data model, developed and maintained data dictionary.,maintained and enforced data model design principles, techniques, standards and best practices adhering to the current framework
• Wrote and maintained ETL mapping specifications, Data Quality (DQ) rules and metrics for management team and development team.
• Interact closely with Business Analysis team, ETL team and BI Reporting teams to ensure understanding of proper use of data architecture. Conduct data model, data architecture and data integration design review sessions.
• Worked Business Analyst to review business requirements, understand business processes, data entities, data producers, consumers, and the data dependencies, data mapping and Data validation
• Deigned database, system design, and technical architecture documents for complex requirements and document via Visio and Created datamodeling for new relational database; collaborate with team lead/senior designer to createdatasolutions for business and systems requirements.
• Adhered and enforced datastandards and best practices and attended requirements gathering meetings with team lead, senior designer, application teams, and Database Administrators (Db As), and/or business partners to understand business needs
• Facilitated and led global meetings to discover and document business requirements and build consensus across the development teaming data integrity by working to eliminate redundancy in data sourcing and converted conceptual data models into logical data models from SQL Server to Netezza and supported reporting requirements in Cognos and SSRS
• Converted preliminary logicaldatamodel,physical model and data messaging model and performeddatamodeling for new relational database; collaborate with team lead/senior designer to createdatasolutions for business and systems requirements and development and architecture of the designs and document the same in Power designer

PROFESSIONAL EXPERIENCE

Confidential, NY

Data Analyst

Responsibilities:

• Responsible Logical and Physical Data Modeling and Gathering the requirements and provide an architectural support on database perspective, Maintained data integrity and eliminate redundancy, database concepts, standards, ETL patterns, PL/SQL scripting,Data Profiling, TraceabilityData Quality, creating control scripts to identify data quality issues thru the operational control framework Data Management
• Handled Data Analysis, wrote queries in PL/SQL and coding in Java, XML, Data modeling - and Agile Ceremonies, wrote User stories, Pre grooming sessions, Tracked stories for all iterations, Computed Burn up chart, Burn down chart,
• Accomplished database design and modeling through data flow diagrams at enterprise, conceptual, logical and physical levels, data dictionary and shared the risk and issues to the project team and planned usage of technical resources and provided technical solutions by validating technologies for the business needs using SQL, UNIX Power Designer Database Modeler
• Accomplished database design and modeling through data flow diagrams at enterprise, conceptual, logical and physical levels in Erwin
• Accomplished high level future and current state business process models and ensured that system solutions meet the business specification through testing strategies and reviewing reviewing test and implementation plans with global team as as SME and gather details for user functions, procedures
• Wrote Epics and decomposing them into User Stories and Handled components of small to medium sized projects/initiatives-interacting and negotiating with other departments and authored system gap analysis, system specifications,defining system requirements, identifying issues and recommending solutions.Business solutions aimed at investment process efficiency, data quality improvements and simplifying investor work flow for derivative securities
• Worked independently in a fast paced team oriented agile environment and handled basic data model in, star and snow lake scenarios and performed complex database queries and assisted product owners with backlog planning -handling history of business needs, capture priority, requirements decomposition, develop outcome based release plans)Wrote SQL queries for reporting and data manipulations for work flow systems, business rules and policies and conducted UAT, JAD Sessions

Confidential

Data Analyst

Responsibilities:

• Wrote SQL queries and done business and data analysis, data modeling for conceptual, physical and logical models in Power Designer Database Modeler
• Gathered business needs and prioritized requirements from the business and presents these accomplished datamodeling s for MDM/BPM Work flow project development with MDM &DataDesign team lead in using SQL, UNIX Erwin for Asset Management, Portfolio Management, Research, and Trading, Java, PL/SQL, Data Profiling, TraceabilityData Quality, creating control scripts to identify data quality issues thru the operational control framework
• Integrated varied model requirements for Telescope Vendor Management System (VMS) and sourcing programs to implementations and/or upgrade projects
• Handled business requirements and delivered use stories, business process modeling or data modeling, like Business Flow Diagrams, Data Flow Diagrams, UI prototypes, portal redesign, Portal Remediation, Modeling, Test Cases, UAT, Functional Test cases for financial services
• Accomplished credit feedback and analysis on Fixed Income municipal bonds, Credit Analysis of Loan Asset Backed Securities, cash flow of fixed income (MBS, CMBS, Pools), View holdings by portfolio, account with Bloomberg for performance reporting, client reporting, fund accounting
• Handled requirements and modeled client and regulatory requirement and portfolio and back office accounting, regulatory, operational and client needs for portfolio management systems
• Accomplished high level future and current state business process models and ensured that system solutions meet the business specification through testing strategies and reviewing reviewing test and implementation plans with global team as as SME and gather details for securties and sett user functions, procedures,Asset identifiers,depositories, custodians, and sub-custodians and handled JAD sessions.Accomplished database models -functional, conceptual, and logical design specifications

Confidential

Data Analyst

Responsibilities:

• Accomplished database models -functional, conceptual, and logical design specifications
• Scheduled, coordinated, and facilitated requirements gathering sessions with the business to identify and drive complete requirement,logical and physical models
• Accomplished requirements MIS reporting, performance reporting, and budgeting and planning, conducting analysis in Data Warehouse development, banking core processing platforms, - DDA, TDA, Lending, and Securities, commercial banking for financial services
• Developed Business Requirement Documents and Functional Requirements Documents, Extraction, Transformation, and Load (ETL) developers, data modelers, and data warehouse
• Developed SQL, review PL/SQL, and reviewed and analyzed data schema

Confidential

Data Analyst

Responsibilities:

• Accomplished requirements and credit feedback and analysis on Fixed Income municipal bonds, Credit Analysis of Loan Asset Backed Securities, portfolio management and trading systems
• Handled complex issues that originate from our business or from other application teams for fixed-income analytics, report development, and portfolio management, Fidelity websites, mobile websites, mobile apps, emails, research Content life cycle management
• Handled issues on reports, portfolio management applications, fixed-income analytics, our investor-oriented data model, and other applications and processes for financial services
• Defined AS IS and TO BE process for change control, requirement gathering with solution delivery,Development, Digital Channel, Partners and Content Providers and Legal Team

Confidential, New York, NY

Data Analyst

Responsibilities:

• Wrote SQL queries and done business and data analysis
• Accomplished high level future and current state business process models and ensured that system solutions meet the business specification through testing strategies and reviewing reviewing test and implementation plans with global team as as SME and gather details for user functions, procedures
• Accomplished database models -functional, conceptual, and logical design specifications
• Defined AS IS and TO BE process for change control, requirement gathering with solution delivery,Development, Digital Channel, Partners and Content Providers and Legal Team
• Gathered business needs and prioritized requirements from the business and presents these requirements in measurable format