PROFESSIONAL SUMMARY

• 8+ years of experience in data management services in the areas of banking, corporate finance, insurance, investments banks and other financial institutions business verticals.
• Wrote the project charter for new engagements and addressed assumptions, in - scope and out-of-scope events.
• Worked with Program and Project management team to consolidate the project tasks and timelines for product releases.
• Wrote the business requirements for transactional systems and Data Warehouse initiatives.
• Worked in the areas Waterfall and Agile Project Development Methodologies.
• Actively involved in project inception, elaboration, construction, testing and deployment phases.
• Involved in System Development Life Cycle Phases (SDLC) - Feasibility, Design, and Testing Phases.
• Wrote the Proof-Of-Concept use cases and test scripts to validate the product features and functionalities.
• Build the Business Process Data Model and Translate into Logical Data Model.
• Delivered Normalized and Dimensional Data Model Business Requirements for ETL Projects.
• Captured Business Logic for SCD and CDC Logics to handle the Incremental and Historical Records.
• Created design documents for UML, ETL and POC Use Cases, Activity, Sequence, Structure and State Diagrams.
• 12 months of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst
• Developed data flow and process flow diagrams and wrote gap and impact analysis observation documents.
• Worked with structured, semi-structure and unstructured data formats to write source to target data element mappings.
• Designed and created Reporting Mockups, User Interface Application Screens/Wireframes, and Data Navigation Flows.
• Wrote the requirements on business rules, process rules, data rules, data profiling rules and data masking rules.
• Captured Data Architecture Principles such as Governance, Integrity, Lineage, Profiling and Purging requirements.
• Reviewed the requirement documents with various business units to get the documents final sign-off process.
• Validate the defined Use Cases in Integration and User Acceptance Testing Environments by building Ad-Hoc SQL Scripts.
• Responsible to organize the meetings, consolidating and circulating the meeting minutes with project stake holders.
• Responsible to maintain Issue Logs, Change Log Requests, Requirement Business Matrix, and Business Dependencies.
• Hands on experience in writing SQL and T-SQL, Schema Management Scripts using Oracle 10g, MS SQL Server Databases.
• Wrote the program units using Stored Procedures, Functions, Packages, and Database Triggers.
• Various reports designed and developed in MS Excel, MS Access, SS Reporting Services, SS Analysis Services and Tableau.
• Captured process requirements for error handling, exception handling, audit control, and restart recovery logic.
• Demonstrated ability to organize, prioritize and complete to work independently. Self-starter with excellent written and verbal communication skills. Passion for providing excellent service to internal clients and business users.

TECHNICAL SKILLS

Domain Expertise: Corporate Finance, Risk, Asset, Investment, and Mortgage Retail Management

Databases: SQL Server 2005/2008/2012 and Oracle 10g

Microsoft Product Suites: MS Word, MS Excel, MS Access, MS Power Point MS Visio, and MS Project

Operating Systems: Windows XP and 2000/2003/2008 Servers and Windows Batch Script Programming

Microsoft BIDS Suite: Reporting Services (SSRS) and Analysis Services (SSAS), Tableau

PROFESSIONAL EXPERIENCE

Data Analyst/ Data Modeler

Confidential, Charlotte NC

Responsibilities:

• Involved in collecting and understanding the requirements of the business users and corporate managers throughout the project
• Facilitated meetings with the different business lines to understand the business process.
• Analyzed the current business processes and data which are maintained in the different sources.
• Designed Conceptual, Logical and Physical Model based on normalization standards
• Conducted JAD session with application developers to determine and analyze the data flow.
• Created mapping document to load the existing data from flat file to the newly designed relational database.
• Entities and their attributes are defined with their name and definitions.
• A logical data model was designed and populated with all entity and their relationships.
• Worked with developers logical data model was transfer into physical data model.
• DDL generated from physical data model was used to create tables in database.
• Coordinate with DBA to execute the DDL to create the physical table in Database.
• MS Visio, Erwin were used to design database and SQL was database for this application.
• Periodic maintenance and changes in data base were done without violating data governance.
• Assisted testing team in developing test scenarios, test logic and test data to support unit and system integration testing and executed test plans.
• Performed unit testing on the applications and data to ensure the correct data flow.
• Data dictionary was maintained and documented for future use.

Technologies: SQL Server 2012, ER-Win 9.5, Jira, AML, MS Excel, MS Word, MS PowerPoint.

Business Data Analyst

Confidential, RidgewoodNJ

Responsibilities:

• Gathered the requirements, analyzed the gaps, and interacted cross functional teams to finalize the business needs.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML.
• Build and modified the Business Process Flows and Data Flow Diagrams to establish future state requirements.
• Analyze, create and maintain enterprise master data supporting quote to cash process. Communicate with internal & external customers to address issues and provide support on data quality and integrity improvements
• Manage the Master Data Management request tool for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turnaround time. Complete large database cleanup projects to insure data integrity.
• Perform the source system analysis and data profiling activities for multiple business domains.
• Created scalable data processing solution that stores user personalization financial data.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
• Actively participated in the strategic decisions on migration, implementation and release management.
• Experience with Callidus True Comp and Reporting & Analytics (For report development and security configuration)
• Define the data structures and constraints, standardized attributes, and reviewed information access paths.
• Build the source to target data mapping, defined standards, and business rules for ETL load process.
• Prepared Data Integration Loading Dependency traceability matrix sheet for development activities.
• Wrote the Test scripts to validate the application and data change requests.
• Extensively wrote the T-SQL scripts to validate the back end database and export the data into excel to analyze.
• Created dashboard and pivot reports to underwriters and loan officers to trace the loan process appropriateness.
• Involved in change control and release management process to move the code into various life cycle environments.

Technologies: MS Visio, MS Office, T-SQL, Toad, and SQL Server DV 2008, Tableau.