SUMMARY

• Experience with conceptual, logical and physical modeling of Star schemas using Fact and Dimension tables.
• Part of the core team responsible for decision making, designing and modeling schemas according to SOA guidelines.
• Designed and worked with COMMON and MDS (Master Data Store) models and databases.
• In - depth knowledge of SDLC (Software Development Life Cycle) and development practices in agile projects & environments.
• Extensive experience with Requirements gathering & Analysis, System Design and Testing Methodologies & Techniques.
• Familiarity with preparingBusiness requirement documents, Use Case specifications, Functional specifications, Non-functional specifications, Systems design specifications and Business Case documents.
• Well acquainted with Unified Modeling Language (UML) and practiced at process modeling, creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, Context Diagrams, State Diagrams, Class Diagrams and process work-flows.
• Actively facilitated and participated in several Joint Application Development (JAD) sessions for requirements gathering and brainstorming sessions to ensure design coherence and project success.
• Thorough understanding of End-to-End testing, User Acceptance Testing, Integration testing, Performance testing and System testing.
• Familiarity with C, C++, VC++ and Java, with understanding of basic Object Oriented Programming concepts.
• Highly driven and disciplined with the ability to organize, multi-task and work with Agile project environments.
• Extremely motivated with strong analytical and problem solving skills and passionate towards learning new concepts.
• Excellent communication and interpersonal skills, and experience in mediating effectively between business heads, stakeholders and technical development teams.

TECHNICAL SKILLS

Data Modeling Tools: ERwin, ER Studio

Business Modeling Tools: MS Visio, Rational Rose, ER Studio, Snagit

Platforms: Windows, Linux, DOS, Legacy, TIBCO

Languages: C, Visual C++, SQL, PL-SQL

IDE: Microsoft Visual Studio, SQL Developer, Toad

Software tools: MS Project, MS Office Suite, Team Explorer, Team Pulse, MS Sharepoint

Database: Oracle

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Modeler

Responsibilities:

• Collaborated with Business Process Analysts and the BI team to build conceptual models.
• Translated business requirements from business stakeholders into modeling and system requirements.
• Reverse engineered all the Source Schemas using Erwin to perform analysis for switch over to new back-end structures.
• Developed logical data models and physical data models using ERwin and ER-Studio for Agile projects.
• Created and implemented ER models and dimensional models (star schemas).
• Generated SQL scripts and created data objects in the database using ERwin script configuration.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for development team.
• Made and used ERwin templates for effective standardization of model design and outlining.
• Created a relational model and dimensional model for various projects including Customs Document Exception Handling, MDT Truck Fax Processing, Web Based Work Order and Master Data Management.
• Assisted DBA’s in the development of physical database.
• Conducted data model reviews with project team members.
• Created and implemented extract and load scripts for data to undergo reformatting to the new model.
• Documented and enforced standards and best practices for data modeling projects and implementation team.
• Applied data cleansing/data scrubbing techniques to ensure consistency in data.

Confidential

Enterprise Data Analyst

Responsibilities:

• Performed data mapping, data analysis and research to identify and resolve data integrity issues in Source and Target systems
• Documented process flows to describe program development, logic, testing, and implementation & application integration.
• Worked with internal architects and assisted in the development of current and target state enterprise data architectures.
• Responsible for defining the source to target data mappings, data definitions and business rules, defining the key identifiers for each mapping/interface, defining the functional requirement documents for each source to target interface.
• Involved in creating change requests and coordinating deployment to Development and Staging with development team and project managers.
• Performed Development work for small enhancement projects which included data cleansing and ensuring data quality.
• Worked with development team and project manager to prioritize development milestones based on dependencies to handle Agile methodology.

Confidential

Quality Assurance Analyst

Responsibilities:

• Reviewed product requirement documents, functional design specifications and change management requests to formulate test plan and manage test strategy.
• Actively participated in Scrum meetings and discussion meetings to go over design issues, specific testing conditions and suggestions to improve efficiency and quality of software or application.
• Documented and analyzed Gaps when conducting System, performance, usability and integration testing while meeting project deadlines
• Developed and executed test scripts to provide testing coverage of critical and alternative paths, and regression impact coverage on dependent applications and databases.
• Performed Risk analysis, to provide testing emphasis on high risk areas while working in agile project environments.
• Performed defect tracking and management of projects assigned using Team foundation Server and Team explorer in MS Visual Studio and MS Sharepoint.
• Primarily responsible for testing and certifying software and applications on Legacy systems, TIBCO, Databases and Web platforms.

Confidential

Business/Systems Analyst

Responsibilities:

• Involved in System Study, Requirements Gathering and Analysis and System Design.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives on requirements, in order to resolve any issues and come to an agreement quickly.
• Participated in defining scope of the project, gathering business requirements, performing gap analysis and documenting use case scenarios, work flows and business processes, textually and with models.
• Translated the business needs into functional and technical requirements for Business users as well as IT Engineers.
• Prepared Software Requirements Specification document (SRSD), Functional Requirement document (FRD) and Business Requirements document (BRD).
• Facilitated reviews and walkthroughs with the SMEs and stakeholders.
• Involved in system design and designing test cases. Developed test scenarios and participated in implementation of test plan. Performed UAT testing before users reviewed system.
• Conducted project related presentations and assisted the PM in setting realistic project expectations and in evaluating the impact that changes will have on the system.