SUMMARY:

• Experienced in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using various data modeling tools like ERWIN, Toad Data Point.
• I am Data Modeler with strong Conceptual and Logical Data Modeling skills has involved in JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications and queries.
• Well versed in Normalization and De normalization techniques for optimum performance in relational and dimensional database environment.
• Expertise in querying the database using SQL and Toad.
• Strong experience in Logical/Physical, Relational and Multi - dimensional modeling, Data analysis for Decision Support Systems (DSS), Online transactional processing (OLTP) and Data warehouse/Business Intelligence (BI) applications, Data Transformation (ETL) and Reporting,
• Strong Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing.
• Strong working experience in Extract/Transform/Load (ETL) design and implementation using Informatica
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes
• Created and Modified PL/SQL Triggers, Procedures, Functions, packages and bulk collections.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Good working knowledge of building Reports using standard industry Reporting tools such as SSIS, Crystal Reports and Business Objects
• Experience documenting business cases and managed report development from design to release.
• Excellent experience with writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests
• Having a good understanding in ETL tools like Informatica.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow
• Self-starter, Multi-Tasking, Attention to detail, ability to work with minimal supervision and manage time and task efficiently.
• Effective team worker and can carry out individual tasks to meet the deadlines effectively.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows 8/7/XP/Vista/NT/2000, Ubuntu, MAC OS X.

RDBMS: Oracle 11g/ 10g / 9i / 8i, SQL Server 2005/2007/2012, DB2, Teradata, MySQL 4.x/5.x, MS-Access 2000/7/10

Modelling Tools: CA ERwin 7.1/7.2/8.2, ER Studio, Oracle Designer 2000,MS Visio, Crystal Reports

Languages: C, C++, Java, J2EE, Java Script, HTML, XML, SQL, PL/SQL, T-SQL

ETL & BI Tools: Informatica 6.x/7.x/8.x/9.x, SSIS, Crystal Reports, Business Objects, Cognos 8, Toad Point for data analysts

Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP), Agile, Rapid Application Development (RAD), Joint Application Development (JAD).

Others: MSOffice 2007/2013 (Word, Excel, PowerPoint, Access), MS Project, Rational Rose, UML.

PROFESSIONAL EXPERIENCE:

Confidential, Plymouth, MN

Data Analyst/ Data Modeler

Responsibilities:

• Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations. Involved in the entire System study, AnalysisandDesign.
• Conducted sessions with architects, business and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests.
• Maintained and updated Metadata repository based on the change requests
• Conducted walkthroughs with the DBA to convey the changes made to the data models.
• Utilized Rational Clear Quest to track change requests throughout the process.
• Implemented SQL Scripts to modify the data to resolve assigned defects.
• Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.
• CreatedEntity relationships diagrams, data flowdiagrams and enforced allreferential integrity constraints using Oracle Designer.
• Developed the data warehouse model (star schema) for the proposed central model. Also worked on normalizing star-schema to snow flake schema to fulfill requirement.
• Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
• Assist in semantic layer design and development of Semantic layer data model.
• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Developed source to target mapping documents to support ETL design.
• Created tables, views, sequences, indexes, triggers, table spaces, constraints and generated SQL scripts for physical implementation.
• Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
• Designed Informatica mappings, enabling the extract, transform and loading of the data into target tables.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

Environment: ERWIN Data modeler, Informatica Power Centre 9.x, Oracle Designer, IBM DB2,SQL server 2012, Oracle 11g, Teradata, Flat files, Rational Clear Quest, Toad, Business Objects, OBIEE.

Confidential, Houston, TX

Data Modeler

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Transformed project data requirements into project data models using Erwin.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Coded stored procedures, triggers, functions, indexes, views and packages.
• Utilized Erwin’s reverse engineering process.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed procedures for extracting the data from different data sources to the central data warehouse.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages.
• Used graphical Entity-Relationship diagramming to create new database design via easy to use, graphical interface.
• Involved in logical and physical designs and transforms logical models into physical implementations
• Utilized Erwin’s reverse engineering and target database schema conversion process.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
• Designed data flows that extract, transform, and load data by optimizing SSIS performance
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Developed business specific custom reports using PL/SQL procedures.
• Created DTS packages to loading data from various flat files and OLTP databases.
• Used DTS to load the data into the warehouse, process the cubes and coded scripts involving the transformation services.
• Involved in scheduling backups of databases and logs and restoring them when necessary.
• Performance tuning of the database and SQL queries.
• Provisions were made for ad hoc querying and reporting using Crystal Reports.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin, Informatica Power Center 9.x, SQL Server, Oracle 11g, PL/SQL, Flat files, Windows XP professional, Toad, Business Objects, Crystal Reports, SSIS.

Confidential, Greenville, NC

Data Modeler/Data Analyst

Responsibilities:

• Involved in all phases of SDLC including analysis, designing, developing, testing and maintenance.
• Performed in-depth analysis on the business objectives.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Developed integration and semantic layer according reporting requirements.
• Used class diagrams (UML) to model the logical data models and then to physical data model.
• Extensively used Normalization techniques (up to 3NF).
• Mapped the data between Source and Targets.
• Experience in Data Extraction and Conversion and in preparing the Gap Analysis.
• Used ER/Studio to generate SQL code for creating database.
• Worked on aspects of risk management, including economic capital, markets (distressed debt), derivatives (structured products), financial distress and bankruptcy.
• Maintained Design document and performed testing.
• Gathered user specifications and system requirements for development process.
• Converted Data stored in flat files into Oracle tables.
• Used MS Visio for Creating Process flow diagrams.
• Worked with the implementation team from the design to the implementation phase.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts to Teradata data warehouse.
• Good experience in data analysis querying and writing in SQL and TOAD.

Environment: CA Erwin, Informatica Power Centre 8.x, SQL Server, ER/Studio, UML, Oracle 11g, Teradata, Flat files, Toad, Cognos.

Confidential

Data Modeler

Responsibilities:

• The Data Mart (BMDM) system stores marketing data in an Oracle relational database and is interrogated using the end-user reporting tools.
• Responsible for data modeling and building a star schema model in Erwin.
• Identified the fact tables, dimensions and the key measures.
• Used star schema methodology for the modeling of the data.
• In creation of the data mart new functionality had to be added like Trend data Inclusion, Product Profitability Calculation \ Reporting, Concept Reporting, Size Of Line Reporting, Global Brand Grouping \ Reporting etc.
• Involved in Performance Tuning for the SQL, PL/SQL scripts.
• Assisted data warehouse project team in extracting business rules.
• Created an enterprise data dictionary and maintained standards documentation.
• Analysis of data requirements and translation of these into dimensional data models.
• Interacted with the end users and found out the performance of the database and also involved in developing test cases.
• Good knowledge in maintaining the database.

Environment: ERWIN, Informatica Power Centre 8.x, Oracle 9i, PL/SQL, Flat files, Toad, Business Objects.

Confidential

Data Modeler

Responsibilities:

• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Collected requirements from business users and analyzed based on the requirements.
• Designed and built Data marts by using Star Schema.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Serve as a member of a development team to provide business data requirements analysis services, producing logical and Physical data models using Erwin.
• Maintained current documentation for all primary and backup responsibilities.
• Worked as part of a team of Data Management professionals supporting a Portfolio of development projects both regional and global in scope.
• Applied organizational best practices to enable application project teams to produce data structures that fully meet application needs for accurate, timely, and consistent data that fully meets its intended purposes.
• Conducted peer reviews of completed data models and plans to ensure quality and integrity from data capture through usage and archiving.

Environment: Informatica Power Center 8.x, Erwin, SQL Server 2006, Oracle 8i.