SUMMARY

• Seven years of extensive experience in teh complete Software Development Life Cycle (SDLC) covering Requirements Management, Data Analysis, Data Modeling, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
• Strong Data Modeling experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snow - flake modeling using tools like Erwin, ERStudio.
• Created DDL scripts for implementing Data Modeling changes, Created ERWIN reports in HTML, RTF format depending upon teh requirement. Published Data model in model mart, created naming convention files, co-coordinated wif DBAs’ to apply teh data model changes.
• Strong Knowledge in Conceptual and Logical Data Modeling skills TEMPhas experience wif JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Created, maintained and modified database design document wif detailed level description of logical entities and physical tables as per teh business requirements.
• TEMPEffective use of features like model mart, design layers, complete compare, split model, model sources and transforms(sub type, super types and hierarchical layers).
• Performed system design wif Entities, attributes, logical relationships (identifying, non-identifying) Preliminary database design, obligatory and non-obligatory analysis, and validation of a model using Normalization techniques.
• Excellent knowledge of waterfall, spiral and Agile methodologies of Software Development Life Cycle (SDLC).
• Experienced in Financial, Banking Domain.
• Extensive Experience working wif business users/SMEs as well as senior management.
• Strong understanding of teh principals of Enterprise Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in creating schema and table design, Views, and Indexes.
• Possess a strong analytical, verbal, inter-personal skill that halps in communicating wif developers, team members.
• Optimum Proficient in using MS Office including MS Visio and MS Project
• Experience in working wif ETL - Extract, Transform, Load transactions
• Assisted developers, ETL, BI team and end users to understand and maintain change log for each data model. Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Designed teh Partitioning for tables according to business logic. Creation of Local/Global indexes depending on teh types of queries to be performed on teh tables.
• Energetic and self-motivated team player wif excellent communication, interpersonal, and leadership skills both independent and collaborative work environments.

TECHNICAL SKILLS

Data Modeling Tools: ER/Studio 8.5, Erwin 3.5/ 4.1.4/ 7.5.3, 8.2 Power Designer 12.1, and Visio

Database Systems: Teradata, Oracle (11g/10g/9i/8i/7.x), SQL Server (2005/2000/7.0 ), Microsoft Access 2007, DB2, MySQL

Data Warehousing: Informatica Power Center 8.1/8.0/7.1/7.0/6.2/6.1/5.2, Informatica PowerMart 4.7, PowerConnect, Power Exchange, Data Profiling, Data cleansing, OLAP, OLTP, SQL*Plus.

Software Engineering: UML using Visio

Office Applications: MS Office 2007 (Word, Excel, PowerPoint)

Configuration Management: Clear case, Visual Source Safe and Concurrent Version Control, Remedy

Operating Systems: Windows95/98/2000/XP, Solaris, Linux, AIX

Quality Assurance: Business and Software Process and Procedure Definition, Quality Models and standards (ISO, CMM,CMMI,TQM Principals, Six Sigma concepts), Quality tools (Ishikawa diagram, Pareto analysis, histogram Process), Measures and Metrics, Project Reviews, Audits and Assessments

Testing: QTP, Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

Data Modeler

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to be compatible wif business logic.
• Created Physical Data Model (PDM) for teh OLAP application using ER Studio.
• Involved in data model reviews wif internal data architect, business analysts, and business users wif in depth explanation of teh data model to make sure it is in line wif business requirements.
• Worked at conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
• Involved in dimensional modeling, identifying teh Facts and Dimensions.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing wif different source databases wif ETL team.
• Worked wif cross-functional teams and prepared detailed design documents for production phase of current customer database application
• Reviewed and implemented teh naming standards for teh entities, attributes, alternate keys, and primary keys for teh logical model.
• Worked wif DBA to create teh physical model and tables.
• Reverse engineering old database and creating subject areas for each schema.

Environment: ER Studio, Informatica Power Center, Sybase, Windows, Toad, Oracle, SQL Server, Visio

Confidential, Portland, OR

Data Modeler

Responsibilities:

• Interacting wif business users to analyze teh business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out teh deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by teh project team.
• Coordinated data profiling/data mapping wif business subject matter experts, data architects, ETL developers, and data modelers.
• Worked on Retail Data ware house.
• Developed logical/ physical data models using Erwin tool across teh subject areas based on teh specifications and established referential integrity of teh system.
• Normalized teh database to put them into teh 3NF of teh data warehouse.
• Involved in dimensional modeling, identifying teh Facts and Dimensions.
• Maintain and enhance data model wif changes and furnish wif definitions, notes, reference values and check lists.
• Worked very close wif Data Architectures and DBA team to implement data model changes in database in all environments. Generate DDL scripts for database modification, Teradata Macros, Views and set tables.
• Worked wif ETL to create source to target mappings and performed validation for source to target mappings.
• Worked wif DBA on performance issues of teh tables.
• An enthusiastic and project-oriented team player wif solid communication and leadership skills and teh ability to develop different solutions for challenging client needs.

Environment: Teradata, SQL Server 2008, Erwin 8.2.08, Windows XP, XML, Excel, Access, Visio.

Confidential, Eagan, MN

Data Modeler

Responsibilities:

• Participated in JAD session wif business users and sponsors to understand and document teh business requirements in alignment to teh financial goals of teh company.
• Created teh conceptual model for teh data warehouse using Erwin data modeling tool.
• Reviewed teh conceptual EDW (Enterprise Data Warehouse) data model wif business users, App Dev and Information architects to make sure all teh requirements are fully covered.
• Analyzed large number of COBOL copybooks from multiple mainframe sources (16) to understand existing constraints, relationships and business rules from teh legacy data.
• Worked on rationalizing teh requirements across multiple product lines
• Reviewed and implemented teh naming standards for teh entities, attributes, alternate keys, and primary keys for teh logical model.
• Implemented Agile Methodology for building an internal application.
• Created teh logical model for teh EDW wif approximately 75 entities and 1000 attributes using Erwin. Teh logical model was fully attributed till 3rd normalization and contains both current and history tables. Data model is divided in number of sub models for teh ease of understanding and comprehension.
• Reviewed teh logical model wif application developers, ETL Team, DBAs and testing team to provide information about teh data model and business requirements.
• Worked wif ETL to create source to target mappings (S2T).
• Worked wif DBA to create teh physical model and tables.
• Had brain storming sessions wif application developers and DBAs to discuss about various De normalization, partitioning and indexing schemes for physical model.
• Worked on Requirements Traceability Matrix to trace teh business requirements back to logical model.

Environment: Erwin 8.0,Teradata, Oracle 10g, COBOL, SQL Server 2008, Microsoft Excel, Visio.

Confidential, Pittsburg, PA

Data Modeler

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to business logic.
• Created Physical Data Model (PDM) for teh OLTP application using ER Studio.
• Created Data Models using IDEF1X methodology.
• Reviewed and implemented teh naming standards for teh entities, attributes, alternate keys, and primary keys for teh logical model.
• Involved in data model reviews wif internal data architect, business analysts, and business users wif in depth explanation of teh data model to make sure it is in line wif business requirements.
• Worked at conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing wif different source databases wif ETL team.
• Worked wif cross-functional teams and prepared detailed design documents for production phase of current customer database application.

Environment: ER Studio, Informatica Power Center 7.1.2, Sybase, Windows, Toad, Oracle 9i, SQL Server 2000, SQL*Loader, AIX 5.0, Windows 2000

Confidential, Charlotte,NC

Data Modeler

Responsibilities:

• Building Data Mart (Conceptual, Logical and Physical) for reporting environment.
• Creating Data Dictionary for user defined databases (Collateral, Securities and Reporting) in Oracle, SQL Server.
• In teh role of Data Analyst performed analysis and design of extensions to an existing data warehouse/mart business intelligence platform
• Define enterprise data architecture vision, strategy, principals and standards; get buy-in from stake-holders, management, business partners, and propagate throughout teh company.
• Segregated data and organized teh data for common subjects using ODS
• Generated operational reports from ODS as opposed to teh transactional/ legacy system.
• Performed Data Architecture in Designing and implementing a Metadata Repository providing a centralized information source for teh data models, data maps, processes, documents, contact lists, project calendars and issues affecting teh merger wif Wachovia
• Implemented Agile Methodology for building an internal application.
• Worked on Data Aggregation.
• Generating Discrepancy reports using Data Stage.
• Preparing Functional Specifications Document for teh project.
• Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2(Reports, Designer, Web Intelligence, Info view, and Supervisor)
• Universe designing, developing and generating complex, Adhoc, dashboard Reports.
• Analyzing data in both application and reporting databases and solving teh discrepancies.
• Tracking Data Model Change Requests to closure.
• Reverse engineering old database and creating subject areas for each schema.
• Preparing High Level Data Flow for all teh major Applications
• Fine-tuned Oracle SQL to be more efficient.

Environment: Oracle 9i/10g, SQL Server 2000/ 2005, Erwin 7.5.2, Power Designer 12.1, BO 6.5/ XIR2, Data Stage 7.5, Windows XP, XML, Excel, Access

Confidential

Database Developer

Responsibilities:

• Responsible for accuracy of teh data collected and stored in teh corporate support system.
• Performed data review, evaluate, design, implement and maintain company database.
• Involved in construction of data flow diagrams and documentation of teh processes.
• Interacted wif end users for requirements study and analysis by JAD (Joint Application Development).
• Performed gap analysis between teh present data warehouse to teh future data warehouse being developed and identified data gaps and data quality issues and suggested potential solutions.
• Participated in system and use case modeling like activity and use case diagrams.
• Analyzed user requirements and worked wif data modelers to identify entities and relationship for data modeling.
• Actively participated in teh design of data model like conceptual, logical models using Erwin.

Environment: Erwin 3.x, Oracle 9.x, and MS Excel and Access