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.• Participated with application developers and DBAs to discuss various De-normalization, partitioning and indexing schemas for a physical model.• Conduct data modeling sessions with business users and technical staff which includes conveying complex ideas both verbally and in written form• Created Data Dictionaries, Source to Target Mapping Documents and documented Transformation rules for all the fields.• Closely interacted with the Business Users and was involved in gathering, assimilation, organization, categorization, and analysis of business requirements• Created Mapping documents using the Metadata extracted from the Metadata repositories• Perform Data Analysis on the source data in order to understand the relationship between the entities• Continuously supported the production on-call support and resolved the tickets with short term and long term fixes.• Worked with the testing team to validate and review the test scripts, test cases, test results.• BVR(Business Verification reports) as a part of production support.

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 will meet the business needs). • 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.• Reverse Engineered physical data models from SQL Scripts and databases.• Work with the various teams to identify and analyze the Orphan/duplicate objects from the Database and performed appropriate action over it.• Develop best practices for PL/SQL stored procedures, functions to implement alerts and data integrity after each ETL process to maintain a balance between target and source tables.

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.• Dealt with the data sources like flat files, Excel sheets, Teradata and performed the conversions into oracle tables.• Involved in Data Analysis for the data warehouse and data mart system.• Optimized and updated the existing data models to support the new as well as existing database environment.• Developed database backup and restore policy.• Created Summary tables by designing SQL functions, procedures, and packages.• Developed SQL queries to verify that data has been moved from the transactional system to DSS.

Hyd, India