Bindhu V. Email & Phone Number

San Jose, CA, US

Brooklyn, NY

• Participated in requirement gathering with business users to understand and document the business requirements in alignment to the financial goals of the company.
• Designed logical and physical data models using data provisioning and consumption techniques.
• Developed scripts that automated DDL and DML statements used in creations of databases, tables, constraints, and updates.
• Worked on reverse engineering on the existing data models and updates the data models.
• Participated with application developers and DBAs to discuss various De-normalization, partitioning and indexing schemas for the physical model.
• Created naming standards for data attributes and metadata to track data source, load frequency, generated key values, and data dictionary.

Greater Atlanta Area

• Identify the business requirements by working with business users and create, maintain logical and physical data models using the Erwin Design Tool and Erwin Model Manager.
• Designed and developed Data Marts by following Snow Flake Schema and Star Schema. Excellent experience and knowledge on data warehouse concepts and dimensional data modeling using Ralph Kimball methodology
• Actively performed Data Analysis, Data Profiling & Validity, Data cleansing rules etc.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions
• Resourcefully participated in the Data Review Board (DRB) reviews as part of the Data Architecture Team by playing the role of a secondary and email reviewer

Woburn, MA

• Understand database design and gather system requirements - review and discuss pre-approved business requirements from the team and begin identifying and collecting specific system requirements (technology specs that.
• Perform source to target data mapping by identifying the source from existing databases.
• Ensure the ease of accessing the history of reference data changes by implementing Slowly Changing Dimensions Type 2 & Type 3 of reference data.
• Implemented different types of data strategies, Data Cleansing rules, Data Profiling and validity, built data flows.
• Implemented Snow-flak schema to ensure no redundancy in the database.
• Implemented Forward Engineering by using DDL scripts and generating indexing strategies to develop the logical data model using Erwin.

Reston, VA

• Used ER Studio to develop the logical model of the online processing system for a large financial institution.
• Involved in gathering user requirements along with the Business Analyst.
• Understood the company standards and developed the data models accordingly.
• Worked with DBAs to generate a physical model.
• Ensured company code standardization rule in the modeling.
• Hands on experience on slowly changing dimensions (SCD) and hierarchical dimensions.

Hyd, India