SUMMARY:

• 6 + years of extensive experience in Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Experience in various Pharmaceutical, Financial, Telecommunication and Banking Sector domains.
• Experience in gathering, analyzing the business requirements and creating Business Requirement Document (BRD).
• Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Experience in modeling OLTP and OLAP using tools likeErwin r8/r7.1/7.2, Sybase Power designer 12.1 and E - R Studio.
• Well versed in Kimball/Inmon data warehouse Philosophies. Experienced in Normalization/De-normalization techniques for optimum performance in OLTP and OLAP environments.
• Proficient in Software Development Life Cycle (SDLC), Project management methodologies and Microsoft SQL server database management.
• Expert in using Agile Data Modeling methodologies.
• Efficient in datamart design and creation of cubes using dimensional data modeling and identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Experience in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, SQL server. Experience in data cleansing, data transformation, data mapping from source to target database.
• Well versed with Data-Extraction, Transformation, Loading (ETL) techniques. Experience with ETL Tools like Informatica and leading the Informatica developers.
• Extensive experience in development of T-SQL, DTS, stored Procedures, triggers, functions, packages, performance tuning and optimization for business logic implementation.
• Facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams
• Experience with Teradata using database commands and Teradata utilities such as BTEQ, SQL Assistant, Fast Load, Multi Load, Fast Export etc. Worked extensively on XML Schema designs.
• Possesses strong Communication Skills always understood Business Requirements appropriately and quickly. Good in Time Management, highly Organized.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Transact SQL, C, Java, C#Markup Languages: HTML, XML, XSL

Data Modeling Tools: Oracle Designer 2000, Embarcardero ER Studio 6.6, ERWIN r7.1/7.2/r8, Embarcardero DBArtisan 5.4, Embarcardero Rapid SQL, Toad, SQL Navigator, Informatica 6.x/7.x, Embarcadero DT/Studio 2.3/3.0.

ETL Tools: Microsoft DTS/SSIS and Informatica 7.1.3

Operating Systems: Windows NT 4.0/98/2000/XP Pro, UNIX, Sun Solaris

Testing Tools: WinRunner7.6/7.0/6.0, Quick Test Pro, Load Runner 7.8/ 7.02, Quality center.

Databases: SQL server 2000/2005, Oracle 9i/10g/11g, Teradata12, DB2, Sybase ASE 12.0/12.5, MS-Access 2003/2007.

Others: MSOffice 2000 (Word, Excel, PowerPoint, Access), MS Project, XML, XSLT, Rational Rose, UML

PROFESSIONAL EXPERIENCE:

Confidential, York, Pennsylvania

Sr. Data Modeler / Data Analyst

Responsibilities:

• Gathered, analyzed and translated the business requirements into detailed reporting requirements for Data warehousing.
• Participated in JAD sessions involving the discussions of various reporting needs using AGILE methodology.
• Conducted Design discussions and meetings to come out with the appropriate Data warehouse at the lowest level of grain for each of the Dimensions involved.
• Designed STAR schemas by identifying the facts, dimensions, measures and involving shared dimensions (Conformed) in ERWIN.
• Involved in designing the star schema by reverse engineering the existing database.
• Implemented the Snow-flake schema by normalizing the existing star schema.
• Involved in preparing Logical Data Models/Physical Data Models.
• Generated the DDL scripts by forward engineering the physical model and interacted with DBA to implement the physical database.
• Conducted logical data model walkthroughs and validation.
• Identified source systems, their connectivity, related tables and fields and ensure data suitable for mapping.
• Developed data mapping documents between Legacy and User Interface Systems.
• Involved in mapping slowly changing dimensions (Type 2) to keep track of historical data.

Environment: ERWIN r8, Data Stage, DB2 UDB, SQL Server2008, Sun Solaris, Windows NT, MS Excel, MS Visio.

Confidential, Houston, TX.

Sr. Data Modeler / Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Developed Project Plan with Project manager’s assistance for the first two phases of the Project.
• Worked with DBAs to create a best fit physical data model from the logical data model using forward engineering in ERWIN.
• Performed Data modeling by transforming the date requirements in to data models using Erwin and maintaining the database schema.
• Widely used Normalization methods and have done different normalizations (3NF).
• Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Involved in the Database design and application development to support the creation and management of online business units for business users and customers usage.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms and documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Involved in the process of loading data into Teradata and in creating the Process Flow Diagrams using MSVISIO.
• Analyzed the performance of the job during the project. Utilized standard techniques for enhancing the performance.
• Authored User reference documents on all the deliverables created for future reference by Business Users and conducted training sessions.

Environment: Oracle 9i, DB2, Erwinr7.1, MS Visio, Teradata 12, SQL, PL/SQL, HTML, MS OFFICE.

Confidential, Glen Allen, VA

Data Analyst/Data Modeler

Responsibilities:

• Gathered various reporting requirements from the business analysts.
• Designed conceptual and logical data models of databases and tables.
• Identified entities and relationships and how those all fit together in logical model, these are then translated into physical model using ERWIN tool.
• Created databases for OLAP Metadata catalog tables using forward engineering of models in Erwin.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Developed system flow and data flow diagrams for the proposed systems. Involved in the critical design review of the finalized database model.
• Helped in migration and conversion of data from the TERADATA database into Oracle 8i database.
• Involved in Complete Compare in Erwin to make a difference between the existing model and the target database using forward engineering.
• Designed mappings using Informatica7.1 coming from different sources like databases, flat files into oracle staging area.
• Extensively worked on the naming standards which incorporated the enterprise data modeling standards and generated reports to verify the model against the pre-defined enterprise standards.
• Involved in test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Exposure to stored procedures, functions, database triggers and packages as per the business needs for developing adhoc and robust reports. Incorporated dynamic SQL for generation of the where clauses dynamically based on the lexical parameters passed.
• Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PERL shell scripts & SQL*Loader.

Environment: Oracle Database 8i, ERWINr7.2, Linux, Windows XP, Windows NT servers, SQL server, Informatica7.1, Teradata.

Confidential, Houston, TX

Data Modeler/ Data analyst

Responsibilities:

• Communicated with users and business analysts to gather requirements.
• Involved in business process modeling using UML through Rational Rose.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Designed a Star Schema based Data warehouse model to accomplish building the central Data warehouse.
• Involved in the data model changes in XML format.
• Normalized the database up to 3NF to put them into the snow flake schema of the data warehouse.
• Involved in developing the central repository, populated the metadata and also maintained the proper working of the system.
• Created entity process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Redefined many attributes and relationships in the reverse engineered model and removed the unwanted data as part of Data Analyst.
• Defined and processed the Facts and Dimensions.
• Performed data cleansing using PERL scripts and using the Informatica tool.
• Comprehended the existing data model and recognized design for improved performance of the system and documented it.
• Used Sybase Power Designer for creating tables using Forward Engineering.
• Arranged brain storming sessions with project focus groups.
• Identified KPI (Key Performance Indicators) for decision support making use of aggregator stage.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Worked with business analyst to design weekly reports using combination of Cognos Impromptu and Power play multidimensional.
• Validated the model with response to questionnaire from analysts.

Environment: Sybase Power Designer, Rational Requisite Pro, Crystal Reports, Cognos Impromptu and Power play Informatica Power Center/Power Mart, MS Office.

Confidential

Datamodeler/Data Analyst

Responsibilities:

• Worked with the Business Analyst and DBA for requirements gathering, business analysis, testing and project coordination.
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Analyzed and evaluated existing system for assessing how it supported functions.
• Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling techniques. Identified the Facts and Dimensions.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Created physical data models using forward engineering.
• Involved in creation of use cases using UML and managed the entire functional requirements life cycle using Rational Unified Process, Requisite Pro, Rational ClearCase, and Rational ClearQuest.
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements.

Environment: RUP, UML, IBM rational Rose, Clear Quest, Clear Case, Requisite Pro, Erwin r7, Model manager, Model navigator, Oracle 9i, Content db, SQL, PL/SQL, Toad, Business Objects

Confidential

Data Modeler / Data Analyst

Responsibilities:

• Facilitated the business workshops to understand and gather the business reporting requirements for the health of sales office reporting.
• Created Conceptual, Physical and Logical design for the model using Erwin tool.
• Reverse engineered the existing databases to identify the key data elements and data entities required to design the data warehouse.
• Developed Star Schema for the Health of Sales office (HOSO) Data mart after identifying the Facts and Dimensions such as (Associate, Product, Training, Time) using Erwin 7.1.
• Generated the DDL Scripts by forward engineering the physical model and interacted with the DBA to implement the physical database.
• Reverse engineering the existing source systems such as OPS (Mainframes Order Processing System) and STARS (Financial System) and Enterprise Horizon (HR System) and created the source to target mapping STM Documents.
• Created the Data Quality Assessment document after profiling the data from the Existing source systems.
• Involved in developing the Informatica mappings to load the data from the source systems (OPS, STARS, HR, and Manual feeds) to the Data mart.
• Created the reports using Crystal reports 10.

Environment: Oracle 9i, Informatica 7.1, Crystal Reports 10, Erwin, Windows XP Professional, SQL server 2005.