SUMMARY:

• Over 8yearsof professional IT experience inDataModelingforOnline Transactional processing (OLTP)and Online Analytical Processing (OLAP)systems.
• Thorough understanding ofSoftware Development Life Cycle (SDLC)from Requirement analysis through Design, Development and Implementation.
• Strong expertise in designingDataWarehouse,Datamart designsusingDimensional modeling Star and Snowflake design techniques.
• Extensive experience inRelationalDataModeling, DimensionalDataModeling, Logical/Physical Design, ER Diagrams,Forward and Reverse Engineering, Publishing ERWIN diagrams,analyzingdatasources and creating interface documentsand proficient inRelational Database Management Systems (RDBMS)
• StrongRDBMSconcepts and well experience in creating database objects likeTables, Views, Sequences, triggers, etctaking teh PerformanceandReusabilityinto consideration.
• Possess strongConceptual and LogicalDataModeling skills, TEMPhas experience wifJADsessions for requirements gathering, creatingdata mapping documents, writing functional specifications, queries.
• Created/maintained/modifieddatabase design document wif detailed description of logical entities and physical tables
• Excellent noledge ofwaterfall, spiral and Agile methodologiesofSoftware Development Life Cycle(SDLC)
• Involved inperformance tuning of queriesto achieve high response times.
• Optimal in performingDatabase Tuningin reducing theCostandCardinalityof teh SQL
• Assistedquality assurance teamin preparing test scripts and test cases
• Worked on DocumentingDataModels, logic, coding, testing, changesand corrections.
• Possess astrong analytical, verbal, inter - personal skilldat helps in communicating wif developers, team members.

TECHNICAL SKILLS:

Dataanalysis: Requirements gathering, JAD sessions, process model analysis and DFD analysis, Use-case analysis,datanormalization, cleansing, profiling, system design,dataarchitecture development, source and target system analysis, project management

Datamodeling tools: Erwin 3.5/ 4.1.4/ 7.5.3, Power designer 12.1, v15.3.0, ER/Studio 9.0.1, Toaddatamodeler, Visio tool,IBMDataArchitect

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

Operating systems: Microsoft windows 2000/NT 4.0/98/millennium edition/vista

Programming languages: SQL, PL/SQL, SAS, C/C++

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

PROFESSIONAL EXPERIENCE:

Confidential

DATAMODELER

Responsibilities:

• Interacting wif business users to analyze teh business process and requirements andtransforming requirements into Conceptual, logical and PhysicalDataModels, designing database, documenting and rolling out teh deliverables.
• Conductedanalysisandprofilingof potentialdatasources, upon high level determination of sources during initial scoping by teh project team.
• Coordinateddataprofiling/datamappingwif business subject matter experts,datastewards,dataarchitects, ETL developers, anddata modelers.
• Developed logical/ physicaldatamodels using Erwin toolacross teh subject areas based on teh specifications and establishedreferential integrityof teh system.
• Maintain and enhancedatamodel wif changes and furnish wif definitions, notes, values and check lists.
• Worked very close wifDataArchitectures and DBA team to implementdatamodel changes in database in all environments. GenerateDDL scripts for database modification,TeradataMacros,Views and set tables.
• Aided and verifiedDDL implementation by DBAs, corresponded andcommunicateddataand system specifications to DBA, development teams, managers and users.
• Ensureddelivery of LDM, PDM, Staging PDM anddatalineage mapping documents.
• Managedthedatamodel changes in all enterprise applications. Performedimpact analysisto ensure all systems leads are informed and coordinate efforts to implement changes.
• Developed, integrated, managed and promoted enterprise level model, physical models anddatamodel standards dat sourcedatafrom multiple originsinternal, external and third partydata.
• Developeddetailedmapping documentsdat will provide teh reporting anddatawarehouse team wifsource to targetdatamappingincludeslogical names, physical names,datatypes, corporatemeta-datadefinitions, and translation rules.
• Conductedqualitiescontrol/auditingto ensure accurate and appropriate use ofdata.
• Performeddataanalysisonproductiondataissues.

Environment: Teradata, oracle 11g, Erwin 7.3.2, Windows XP, XML, Excel, SAS, Access, Visio.

Confidential

DATAMODELER

Responsibilities:

• Involved in gathering business requirements and translated business requirements
• Actively participated inJAD sessionswif teh subject matter expert, stake holders and other management team in teh finalization of User Requirement Documentation.
• Experience in identifying entities required and teh relation between teh entities to create Conceptual logical model
• Efficiently developed theDatamodel and ERD diagrams using Power designer
• Created and maintainedLogicalDataModel (LDM)for teh project which includes documentation of allentities, attributes,data relationships, primary and foreign keystructures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated teh appropriateLDM'sto process mappings, screen designs,use cases, business object model, and system object model as they evolve and change
• Creating of theXMLdatamodelfor theExpress PA projectfor teh Rules engine and providing teh model in .XSD formatfor teh services team
• Creating themapping documentsto teh find out teh gaps between teh mockup screens, services and database
• Identifying thegaps and fills those gapsin teh database by communicating wif DBA
• Enhancing teh existingdatamodel byreverse engineeringby adding new tables based on teh business requirements which will enhance in web services
• Identifying teh required fields for teh Drug and Coverage check web services in teh database and understanding initialdataloading Process
• Creatinglogical and physical model databaseandschema in oracle
• Reverse engineeringexistingdatabase to conductsourcedataanalysistoidentify teh relationshipbetweendatasources
• Schema Replication for development purpose using Power designer
• Normalizing theDataand Developing teh Relational databasefor teh differentweb services and database
• Creating of teh database scripts using Power designer and submitting to teh DBA

Environment: Oracle 10g, Power designer, SAS, Oracle SQL developer, SQL plus, Visio, MS office, CVS, Putty, Soap UI.

Confidential

DATAMODELLER

Responsibilities:

• Conductedanalysisandprofilingof potentialdatasources, upon high level determination of sources during initial scoping by teh project team
• Coordinateddataprofiling/datamappingwif business subject matter experts,datastewards,dataarchitects, ETL developers, anddata modelers
• Worked onBankDataware houseandMortgageDataware house
• Developed logical/ physicaldatamodels using Erwin toolacross teh subject areas based on teh specifications and establishedreferential integrityof teh system
• Normalized teh database to put them into the3NFof thedatawarehouse
• Involved indimensional modeling, identifying theFactsandDimensions
• Maintain and enhancedatamodel wif changes and furnish wif definitions, notes, values and check lists
• Worked very close wifDataArchitectures and DBA team to implementdatamodel changes in database in all environments. GenerateDDL scripts for database modification,TeradataMacros,Views and set tables
• An enthusiastic and project-oriented team player wifsolid communication and leadership skillsand teh ability to develop different solutions for challenging clients.

Environment: Teradata, SQL Server 2000/ 2005, Erwin 7.3.2, Windows XP, XML, Excel, Access, Visio.

Confidential, Jersey City, NJ

Data Analyst

Responsibilities:

• Gathered user and business requirements through open-ended discussions, brainstorming and prototyping. Assigned priorities to all of teh requirements.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
• Performed Gap analysis by identifying existing technologies, documenting teh enhancements to meet teh end state requirements.
• Designed and developed project document templates based on SDLC methodology.
• Facilitated JAD sessions wif management, users and other stakeholders to define teh project and to reduce teh time frame required to complete deliverables.
• Responsible for converting teh business requirements into functional and non-Functional requirements.
• Prepared Business Requirement Document and then converted Business requirements into Functional Requirements Specification.
• Extensively used Rational Requisite Pro to gather and manage requirements. Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Responsible for calculating ROI on teh investment for teh securities dat are invested.
• Analyze business requirements and segregated them into Use Cases. Created Use case diagrams, activity diagrams, Sequence Diagrams, and OOD using Rational Rose according to UML methodology thus defining teh Data Process Models.
• Maintained various versions of teh documents generated during teh project using Rational Clear Case.
• Bugs dat would enhance teh usability of teh application were logged using Rational Clear Quest.
• Designed and implemented basic SOL queries for QA testing and report/ data validation.
• Assisted teh QA team in designing teh test plan and test cases. Performed User Acceptance Testing (UAT).

Environment: UML, RUP, Rational Rose, Rational Requisite Pro, Test Director, MS Word, MS Visio MS PowerPoint, Visual Basic, Windows 2000, Oracle 8i, Java/J2EE.