SUMMARY

• Around 8 years of experience in data modeling, analysis, design, and development of databases for business applications in Client/Server and Data Warehouse, had a practical understanding of Data modeling (Dimensional & Relational) concepts like Star - Schema, Snowflake Schema Designing, Fact and Dimension tables, Also expertise in Data analysis skills including data mapping from source to target database schemas, data cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse using Erwin.
• Experience working with Agile and Waterfall data modeling methodologies.
• Expertise with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Experience in Meta-data management to consolidate metadata from disparate tools.
• Experience in building reports using Crystal Reports, SSRS.
• Experience in modeling Transactional Databases and Data Warehouses using tools like Erwin and ER Studio.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Good working knowledge of building Reports using standard industry Reporting tools, and Business Objects.
• Having good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments.
• Familiar with Ralph Kimball and Bill Inmon approaches along with strong Database experience using Oracle 11g, XML, Teradata, SQL server.
• Good knowledge on TPump for loading data from source into Teradata tables.
• Experience in dealing with Slowly Changing Dimensions (SCD), Conformed Dimensions, Junk Dimensions, Status Dimensions and Role-Playing Dimensions.
• Strong experience working with conceptual, logical and physical data modeling considering Meta data standards.
• Extensive experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures, Triggers and Packages for business logic implementation.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Effective verbal and written communication skills supplement a proven aptitude and attitude to multi-task, sustained a classified access to ensure success, even in compressing and uncertain latitudes.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, MS Visio, Sybase Designer, ER Studio Software Architect, ER Studio Data Architect, Oracle Designer, SQL Navigator, Embarcadero DT/Studio.

ETL Tools: SQL*Loader, Fast Load, T Pump, Multi Load, SSIS.

Programming Languages: C, C++, Java, SQL, PL/SQL, HTML, UMLs

RDBMS: Oracle, SQL Server, MS Access, Teradata, Sybase

Reporting Tools: Crystal Reports, Business Objects, SSRS

Operating Systems: UNIX, LINUX, Windows

Others: Clear Quest, Clear Case, Toad, MS Office Suite(Word, Excel, PowerPoint, Access), Visio, MS Project, XML, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Sr. Data Modeler

Responsibilities:

• Worked with Business Analysts team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Performed the data source mapping.
• Created logical data model from the conceptual model and it’s conversion into the physical data models.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Review the data model with functional and technical team.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Assist developers, ETL, BI team and end users to understand the data model.
• Involved with Business Analysts team in requirements gathering and in preparing the Functional specifications and Technical specifications.
• Participated in integration of data from various Data sources like MS SQL Server, Teradata, etc...
• Involved in using “Complete-Compare” Technology to support iterative development by keeping the models and databases in synch.
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Building reports using SSRS.
• Prepared the test cases, test plan for testing the Programs.

Environment: Erwin, Oracle, Putty, TOAD, UNIX, SSRS.

Confidential, MONTVALE, NJ

Sr. Data Modeler

Responsibilities:

• Gathered business rules and information requirements from business partners
• Involved in preparing Conceptual Data Models and conducted controlled brain-storming sessions with project focus groups.
• Developed logical data models and their associated metadata based on the business rules and requirements
• Developed a review and approval process for the logical data models.
• Documented and published the data models and their associated metadata.
• Assisted the application teams with the data needs related to new releases or other changes and updated the data models as needed
• Involved in mapping data from one store to another as may be required for data migrations, data loads, data integration
• Resolved problems related to data quality or inconsistencies
• Identified possible sources for data population and promoted the use of shared data within a business area
• Helped in creating Source-Target Mapping document.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Identified and tracked slowly changing dimensions, Role-Playing and Multi-Valued Dimensions.
• Created/modified SQL Joins, sub-queries, and other T-SQL code to implement business rules.
• Worked with business analyst to design weekly reports using SSRS.
• Used Erwin tool as well for relational database and dimensional data warehouse designs.
• Knowledge in Data loading using PL\SQL Scripts and SQL Server Integration Services (SSIS).
• Performed data analysis and profiling using TOAD and SQL extensively.

Environment: Oracle, Toad, Lotus Notes, SQL Server, Visio, Visual Studio, Erwin, SSRS, SSIS.

Confidential, Winston-Salem, NC

Data Modeler/Analyst

Responsibilities:

• Gathered business requirements through several discussions and meetings with users and business analysts.
• Identified the Objects and relationships between the objects to develop a logical model in ERWIN 7.2 tool and later translated the model into physical model using the Forward Engineering technique in ERWIN tool.
• Used Model Marts to understand different versions of data models existing in the system.
• Extensively used Star and Snowflake Schema methodologies in building and designing the logical data model into Dimensional Models.
• Created and documented both business and technical Metadata documents from Metadata Repositories.
• Involved in dimensional modeling, identifying the Facts and Dimensions and different hierarchies.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Worked extensively on SQL querying using Joins, Alias, Functions, Triggers and Indexes.
• Managed all indexing, debugging, optimization and query optimization techniques for performance tuning using T-SQL.
• Denormalized the database to put them into the star schema of the data warehouse.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Extensively used SharePoint for version controlling.
• Worked with business analyst to design weekly reports using combination of Crystal Reports.
• Understood existing data model and documented suspected design affecting the performance of the system.
• Assisted Reporting developers in building Reports using SSRS.
• Conducted logical data model walkthroughs and validation.

Environment: SQL Server, Erwin, Crystal Reports, Windows, TOAD, SSRS.

Confidential

Data Modeler/Analyst

Responsibilities:

• Involved in gathering business requirements from the business by participating in various JAD sessions.
• 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.
• Analyzed existing Conceptual and Physical data models and altered them using ER Studio to support enhancements.
• Utilized SharePoint to track changes requests throughout the process.
• Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.
• Analyzed and synthesized the requirements gathered from multiple sources and documented the business process flow for the system.
• Involved in the entire System study, Analysis and Design.
• Created tables, views, indexes, triggers, table spaces, constraints and generated SQL scripts for physical implementation.
• Worked with the ETL team to document the transformation rules for data migration from source to target systems.
• Developed source to target mapping documents to support ETL design.
• Resolved the data type inconsistencies between the source systems and the target system using the Source-to-Target Mapping Documents.

Environment: ER Studio, Oracle, PL/SQL, MS Excel, Word and Access, Erwin

Confidential

Data Modeler

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.
• Analyzed the source system (JD Edwards) to understand the source data and JDE table structure along with deeper understanding of business rules and data integration checks.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created the dimensional logical model with approximately facts, dimensions with attributes using ER Studio.
• Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
• Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.
• Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.

Environment: Microsoft SQL Server, Microsoft SQL Management Studio, Microsoft SQL Integration Services, Microsoft SQL Reporting Services.