SUMMARY

• Over 8+ years of experience in Information Technology in Data Modeling, Data Analysis, Design and development of Databases for business applications in Data Warehousing Environments.
• Experience in Networking, Finance, Pharmaceutical, Healthcare and Insurance domains.
• Efficient in gathering requirements, analysing the business process and developing design specifications.
• Vast experience in developing Conceptual, Logical and Physical data models for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Experience in creating standard abbreviation document for naming logical and physical objects according to business standards.
• Strong hands - on experience in Data Modeling tools like Erwin, Power Designer and ER Studio for developing Entity-Relationship diagrams
• Worked extensively on XML data and XSD schema designing.
• Efficient in Data Warehousing/Data Mart design. Experience in identifying facts and dimensions from the Enterprise Architecture for designing Star and Snowflake Schema.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Experience in design reviewing and validation of final data models.
• Well versed with Normalization / Denormalization techniques in relational/dimensional database environments for optimum performance.
• Extensively worked on forward and reverse engineering processes for several projects.
• Experience in Extract, Transfer and load process using ETL tools like Informatica.
• Experience in Data mapping from source to target database schemas.
• Proficiency in databases using SQL server, Oracle, DB2 and Teradata.
• Experience in performance tuning by adding database objects like indexes, partitions etc.
• Good knowledge on writing SQL queries using stored procedures, views, indexes and joins.
• Good communication and presentation skills. Experienced in working with business users as well as senior management
• Well versed with various Software development methodologies like Water Fall and Agile.
• Exposure to Reporting tools like SQL Server Reporting Services(SSRS), and Business Objects.
• Personal strengths include strong leadership skills, solid organizational and collaboration skills, effective interpersonal/communication skills, and flexibility/adaptability to changes.

TECHNICAL SKILLS

Data Modeling Tools: Power Designer, Erwin 7.3/8, ER /Studio, MS Visio

Databases: Oracle 9i/10g/11g, MS SQL Server 2005/2008, DB2, MS Access, Teradata

Reporting Tools: Business Objects XI 3.1, Crystal Reports 9, SQL Server Reporting Services(SSRS)

Web Technologies: HTML, CSS, Java Script, XML

Operating System: Windows 98/2000/2007/ XP/Vista, UNIX

Languages: SQL, Visual Basic, C, C++, Java, .Net

ETL Tools: Informatica 8.X, Microsoft SSIS

Others: MS Office, Toad, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Indianapollis,IN

Business Analyst/Data Analyst/ Data Modeler

Responsibilities:

• Designed industry standard model specific to the CDISC Standards.
• Closely interacted with the Business Users and was involved in gathering, assimilation, organization, categorization and analysis of business requirements.
• Perform Data Analysis on the source data in order to understand the relationship between the entities.
• Extensively worked on XML/XSD Schema.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business user
• Developed Logical Data Model and Physical Data Model using Sybase Power Designer.
• Perform Logical data model design including Normalization and Denormalization
• Enforced Referential Integrity, appropriate constraints, foreign key assignments in the model for consistent relationship between tables and efficient database design.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database for Oracle.
• Perform Reverse engineering to a physical data model from existing physical database.
• Designed Process Flow Diagrams/Data Flow Diagrams using MS Visio.
• Conduct data modeling sessions with business users and technical staff which includes conveying complex ideas both verbally and in written form.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata
• Involved in designing data Marts by using Star Schema and Snowflake schema.
• Worked with development teams with loadingdata, extractingdata(ETL) etc.
• Generate DDL Scripts and communicated with DBA to implement changes.
• Followed Standards, procedures and guidelines for abbreviations, acronyms and applied Data Naming Standards, Class words to the Data Model.
• Assist Business Subject Matter Experts and data stewards to review and "scrub" their data in a timely manner and perform data audits, as necessary.
• Created Data Dictionaries, Source to Target Mapping Documents and documented Transformation rules for all the fields.
• Performed data analysis and data profiling using complex SQL on various sources systems.
• Developed Test Scenarios based on the requirements.
• Used SQL tools like TOAD to run SQL queries and validate the data in Warehouse.

Environment: Sybase Power Designer 16.5, Informatcia Power Center, Altova XML Spy 2011, Oracle 11g, MS Office, Microsoft Visio 2010, TOAD

Confidential, San Jose, CA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Work closely with the Business Analyst to gather business requirements and specifications.
• Closely interacting with the end users to understand the reporting needs
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats..
• Developed Logical and Physical data model
• Conducted Design discussions and meetings to come out with the appropriate Data Model.
• Responsible for defining the naming standards fordatawarehouse.
• Create and maintainMetadata, including table, column definitions.
• Created Mapping documents using the Metadata extracted from the Metadata repositories.
• Responsible for different data mapping activities from Source systems to Teradata.
• Worked with ETL developer to load the data from source to target using Informatica.
• Identified and Defined entities, relationships and attributes in the data model.
• Normalized the database based on the new model developed to put them into the 3NF of thedata warehouse.
• Designed Data Flow Diagrams, E/R Diagrams and enforced all referential integrity constraints
• Identified the Objects and relationships between the objects to develop a logical model in ERWIN tool and later translated the model into physical model using the Forward Engineering technique in ERWIN tool.
• Reverse Engineered databases and then forward engineered them to Teradata using Erwin
• Used Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Generated the DDL Scripts by forward engineering the physical model and Interacted with the DBA to implement the physical database
• Involved in dimensional modeling, identifying the Facts and Dimensions, creating relationships between them, assigning Surrogate Keys, Alternate keys, Natural Keys and Foreign Keys.
• Analyzing, creating and maintaining Primary indexes (PI), Secondary Indexes (SI), Join indexes (JI) Partition Primary Indexes (PPI), Multilevel Partition Primary indexes (MPPI), and compression
• Developed Star schema based dimensional model to develop the data warehouse.
• Resolved thedatatype inconsistencies between the source systems and the target system using the mapping.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities
• Worked on various databases such as Oracle and Teradata.
• Involved in the critical design review of the finalized database model
• Created the ETL data mapping documents between source systems and the target data warehouse.
• Used SQL tools like Teradata SQL Assistant & TOAD to run SQL queries and validate the data in warehouse.
• Written requirements for Business Objects and assisted the developers in creating Universe Reports.

Environment: Erwin 8, Informatica Power Center 8.X, XML, Oracle 11g, DB2, Business Objects XI 3.1, WebI, MS Office.

Confidential, Fort Washington, PA

Data Modeler/Data Analyst

Responsibilities:

• Interacted with Business users to gather the related business requirements and to identify the data sources.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data- related standards.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Responsible for mapping business requirements and the new databases to the logical data model which defines the project delivery needs.
• Translated the Logical Data Model into Physical Data Model with Forward Engineering in Erwin tool.
• Also responsible for creating, documenting and maintaining the metadata.
• Involved in maintenance of models and loading models to Metadata Repository
• Generated DDL statements and scripts from Physical Data Model to create objects like table, views, indexes, stored procedures and packages.
• Coordinate with DBA's to create development, testing, regression and production database.
• Created the Dimensional Model by identifying the facts and dimensions.
• Designed Fact tables, Dimension and aggregate tables for Data warehouse.
• Implemented naming standards for facts and dimensions for Logical and Physical Data model.
• Worked on the conversion process of data which is stored in flat files into Oracle tables.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Worked extensively on forward and reverse engineering processes using Erwin.
• Used Reverse Engineering and Forward Engineering techniques on databases from DDL scripts and created tables and models in data mart, data warehouse and staging..
• Generated data mapping documents to define mapping from source to target.
• Designed dynamic SSIS Packages to transfer data across different platforms, validate data during transferring, and archived data files for different DBMS.
• De-normalized the database to put them into the star schema of the data warehouse
• Designed and developed reports in MS SQL Server Reporting Services (SSRS) under SQL Server

Environment: Erwin 7.3, Oracle 11g, SQL Server 2008, Crystal Reports 9, XML, Windows 7, MS Office, SSRS 2008.

Confidential, New Jersey

Data Modeler/Data Analyst

Responsibilities:

• Worked extensively with business users on requirements gathering, analysis and documentation.
• Created the conceptual model for the Data Warehouse and got it reviewed from the business users.
• Analysed the source system to better understand the source data and the table structure with deeper understanding of business rules.
• Involved in generating, documenting and maintaining Metadata
• Developed the logical and physicaldimensional datamodel for the proposed solution.
• Identified the facts & dimensions, aggregate tables for Dimensional Models for the data warehouse
• Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
• Defined the naming standard conventions for the fact and dimension entities and attributes of logical and physical model.
• Generated the DDL Scripts for implement Data Modeling changes
• Responsible for creating the staging tables and source to target mapping documents for the ETL process
• Worked with DBA's to create physical model and tables.
• Scheduled brainstorming sessions with DBA's to discuss about the views, index and partitions for the facts and dimensions.
• Involved in generating Ad-Hoc queries as per the client’s requirements.
• Created Summary and Aggregate tables for better performance of the query
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Supported end users by participating in UAT sessions for educating business users about the reports, dashboards and the BI System.
• Generated reports using SQL Server Reporting Services( SSRS).

Environment: Erwin 8, SQL, SQL Server 2005, Mercury Quality Center 9, Oracle11g, Toad, SSRS, MS Excel

Confidential, Nashville,TN

Data Modeler

Responsibilities:

• Gathered the data warehouse requirements by conducting one-on-one sessions with business users
• Developed a Conceptual model, Logical and Physical database model
• Identified facts and dimensions and developed dimensional model for the reporting system
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation
• Generated ad-hoc reports using Crystal Reports 8.
• Worked and extracted data from various database sources like DB2, CSV, XML and Flat files into Informatica,

Environment: Erwin 7.1, Informatica 7.1.3, Windows XP/NT/2000, SQL Server 2005, SQL, Oracle10g,DB2, MS Excel, Crystal Reports, XML, MS Visio, Rational Rose

Confidential

Data Modeler

Responsibilities:

• Analyzed existingdatamodel and documented suspected design affecting performance of the system.
• Involved in gathering the requirement and documented them using Rational Request Pro.
• Worked on the Conceptual model and have created logical model and later derived into a Physical Model.
• Developed the data warehouse model (star schema/ Snow flake) for the proposed central model for the project
• Identified and processed the facts and dimensions.
• Designed an Oracle OLTP database in 3NF to handle the day-to-day needs of thebusiness, and database performance is tuned for those needs.
• Created summary tables and improved complex Join operation using denormalization methods
• Redesigned indexes and maintained large tables.
• Created Source to Target mapping document in excel spread sheet which contains the transformation logic and worked closely with ETL Team and developed various complex transformations
• Done analysis of resource intensive query and applied changes in existing back-end code (stored procedures, triggers) to speed up report execution.
• Maintained and supported reports developed in Crystal Reports.
• Involved with Business Intelligence team in preparing and delivered a variety of interactive and printed reports by using Business Objects.

Environment: Windows NT servers, Oracle 9i, SQL Server 2005, ERwin 6.5, Crystal Reports, Business Objects XI R1/R2, Designer, WebI, Informatica 6.0.

Confidential

Data Modeler

Responsibilities:

• Involved in gathering user requirements along with Business Analyst.
• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Created Entity relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Created a logical design and physical design of the relational database and dimensional data modeling.
• Designed the data model using Erwin
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Wrote Database packages, stored procedures, functions and database triggers.
• Developed several forms & reports using Crystal Reports.

Environment: SQL Server, Oracle, Windows NT, Windows 2000, Erwin, Crystal Reports, MS Office