Data Modeler/Data Analyst

PROFESSIONAL SUMMARY:

• Seven years of extensive experience in the complete Software Development Life Cycle SDLC covering Requirements Management, Data Analysis, Data Modeling, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
• Strong Data Modeling experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, ERStudio.
• Created DDL scripts for implementing Data Modeling changes, Created ERWIN reports in HTML, RTF format depending upon the requirement. Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.
• Strong Knowledge in Conceptual and Logical Data Modeling skills has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Created, maintained and modified database design document with detailed level description of logical entities and physical tables as per the business requirements.
• Effective use of features like model mart, design layers, complete compare, split model, model sources and transforms sub type, super types and hierarchical layers .
• Performed system design with Entities, attributes, logical relationships identifying, non-identifying Preliminary database design, obligatory and non-obligatory analysis, and validation of a model using Normalization techniques.
• Excellent knowledge of waterfall, spiral and Agile methodologies of Software Development Life Cycle SDLC .
• Experienced in Financial / Finance, Retail and Health Care.
• Extensive Experience working with business users/SMEs as well as senior management.
• Strong understanding of the principles of Enterprise Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in creating schema and table design, Views, and Indexes.
• Possess a strong analytical, verbal, inter-personal skill that helps in communicating with developers, team members.
• Optim Proficient in using MS Office including MS Visio and MS Project
• Experience in working with ETL Extract, Transform, Load transactions
• Assisted developers, ETL, BI team and end users to understand and maintain change log for each data model. Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Designed the Partitioning for tables according to business logic. Creation of Local/Global indexes depending on the types of queries to be performed on the tables.
• Energetic and self-motivated team player with excellent communication, interpersonal, and leadership skills both independent and collaborative work environments.

TECHNICAL SKILLS:

Confidential

Data Modeler

• The New York Office of Mental Health promotes the mental health of all New Yorkers with a particular focus on Facilitating hope and recovery for adults with serious mental illness and children with serious emotional disturbances.
• Project was to design ''State Facility Enterprise Reporting Site for inpatient and outpatient data, Admission and discharge statistics, management indicators, staff reports and statistical reports. All OMH staff members will be using this site to review facility and statewide information based on admissions, discharges and census numbers at each OMH facility

Responsibilities:

• Analyzed existing logical data model LDM and made appropriate changes to be compatible with business logic.
• Created Physical Data Model PDM for the OLAP application using ER Studio.
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Worked at conceptual and physical using IE methodology database level to implement and build corporate enterprise information strategies.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Worked with DBA to create the physical model and tables.
• Reverse engineering old database and creating subject areas for each schema.

Environment: ER Studio, Informatica Power Center, Sybase, Windows, Toad, Oracle, SQL Server, Visio

Confidential

Data Modeler

• Columbia Sportswear Company is a leading innovator in the global outdoor apparel, footwear, accessories and equipment markets.
• Project was to develop Corporate Forecasting a view of CSC's projected Revenue and Inventory levels regionally and globally. Collaboration among Sales, Planning, Merchandising, Finance, Account Operations and Distribution utilize current Order Book data and historical statistics to forecast Revenue for up to three years into the future. The Revenue Forecast along with current Inventory levels drive CSC's Distribution Forecast and resulting Inventory Forecasts at a Regional and Global view. This end-to-end process allows for scenario planning and continuous tracking to assist CSC in achieving financial goals worldwide. This process feeds into the Global financial forecast and supports key stakeholders across the organization.

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Coordinated data profiling/data mapping with business subject matter experts, data architects, ETL developers, and data modelers.
• Worked on Retail Data ware house.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Normalized the database to put them into the 3NF of the data warehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments. Generate DDL scripts for database modification, Teradata Macros, Views and set tables.
• Worked with ETL to create source to target mappings and performed validation for source to target mappings.
• Worked with DBA on performance issues of the tables.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: Teradata, SQL Server 2008, Erwin 8.2.08, Windows XP, XML, Excel, Access, Visio.

Confidential

Data Modeler

• The purpose of the BCBS Foundation is to make a healthy difference in people's lives by improving the community conditions that have an impact on the health on children and families. The BCBS of Minnesota Foundation focuses on factors that determine health beyond genes, life style access to health care.
• Project was to develop Private Exchange Census Application to facilitate the data transfer back and forth between BCBSMN and e health. This application stores the membership data, group configuration information etc. Data extraction programs running on this application will perform the formatting of data in the required format before sent to e health. This application is also used to store supplemental data coming back from e health after open enrollment.

Responsibilities:

• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Created the conceptual model for the data warehouse using Erwin data modeling tool.
• Reviewed the conceptual EDW Enterprise Data Warehouse data model with business users, App Dev and Information architects to make sure all the requirements are fully covered.
• Analyzed large number of COBOL copybooks from multiple mainframe sources 16 to understand existing constraints, relationships and business rules from the legacy data.
• Worked on rationalizing the requirements across multiple product lines
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Implemented Agile Methodology for building an internal application.
• Created the logical model for the EDW with approximately 75 entities and 1000 attributes using Erwin. The logical model was fully attributed till 3rd normalization and contains both current and history tables. Data model is divided in number of sub models for the ease of understanding and comprehension.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Worked with ETL to create source to target mappings S2T .
• Worked with DBA to create the physical model and tables.
• Had brain storming sessions with application developers and DBAs to discuss about various
• De normalization, partitioning and indexing schemes for physical model.
• Worked on Requirements Traceability Matrix to trace the business requirements back to logical model.

Environment: Erwin 8.0,Teradata, Oracle 10g, COBOL, SQL Server 2008, Microsoft Excel, Visio.

Confidential

Data Modeler

• PNC is a global financial services company which provides Investment Banking, Asset Management, and Wealth Management services for private, corporate, and institutional clients worldwide.
• Project was Wealth Management services designed for high-net-worth and affluent individuals around the world, whether investing internationally or in their home country. Provides tailored, unbiased advice and investment services ranging from asset management to estate planning and from corporate finance to home financing. The goal of the project is Architect and populates the Enterprise Data Model EDM for UBS WMA. Provides a consistent, structured view of the data for front-end Applications. Build a foundation for Business Intelligence, leveraging the Target State Architecture.

Responsibilities:

• Analyzed existing logical data model LDM and made appropriate changes to business logic.
• Created Physical Data Model PDM for the OLTP application using ER Studio.
• Created Data Models using IDEF1X methodology.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Worked at conceptual and physical using IE methodology database level to implement and build corporate enterprise information strategies.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.

Environment: ER Studio, Informatica Power Center 7.1.2, Sybase, Windows, Toad, Oracle 9i, SQL Server 2000, SQL Loader, AIX 5.0, Windows 2000

Confidential

Data Modeler

• Key Bank Financial Corporation is specializing in credit cards, home loans, auto loans, and banking and savings products.
• Project was to develop financial analysis data warehousing for analyzing customers, their transactions, accounts, balances and their authorizations between accounts of its customers. This project is developed for research analysis of Finance Department to assist them in their business. This system provides accurate and timely information on their portfolios on a daily and monthly basis, regarding credit gains and losses for potential candidates so that they may take appropriate actions proactively

Responsibilities:

• Building Data Mart Conceptual, Logical and Physical for reporting environment.
• Creating Data Dictionary for user defined databases Collateral, Securities and Reporting in Oracle, SQL Server.
• In the role of Data Analyst performed analysis and design of extensions to an existing data warehouse/mart business intelligence platform
• Define enterprise data architecture vision, strategy, principles and standards get buy-in from stake-holders, management, business partners, and propagate throughout the company.
• Segregated data and organized the data for common subjects using ODS
• Generated operational reports from ODS as opposed to the transactional/ legacy system.
• Performed Data Architecture in Designing and implementing a Metadata Repository providing a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the merger with Wachovia
• Implemented Agile Methodology for building an internal application.
• Worked on Data Aggregation.
• Generating Discrepancy reports using Data Stage.
• Preparing Functional Specifications Document for the project.
• Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2 Reports, Designer, Web Intelligence, Info view , and Supervisor
• Universe designing, developing and generating complex, Adhoc, dashboard Reports.
• Analyzing data in both application and reporting databases and solving the discrepancies.
• Tracking Data Model Change Requests to closure.
• Reverse engineering old database and creating subject areas for each schema.
• Preparing High Level Data Flow for all the major Applications
• Fine-tuned Oracle SQL to be more efficient.

Environment: Oracle 9i/10g, SQL Server 2000/ 2005, Erwin 7.5.2, Power Designer 12.1, BO 6.5/ XIR2, Data Stage 7.5, Windows XP, XML, Excel, Access

Confidential

Database Developer

Britannia Products Pvt Ltd Company is one of India's biggest brands and the pre-eminent food brand of the country. It was equally recognized for its innovative approach to products and marketing.

Responsibilities:

• Responsible for accuracy of the data collected and stored in the corporate support system.
• Performed data review, evaluate, design, implement and maintain company database.
• Involved in construction of data flow diagrams and documentation of the processes.
• Interacted with end users for requirements study and analysis by JAD Joint Application Development .
• Performed gap analysis between the present data warehouse to the future data warehouse being developed and identified data gaps and data quality issues and suggested potential solutions.
• Participated in system and use case modeling like activity and use case diagrams.
• Analyzed user requirements and worked with data modelers to identify entities and relationship for data modeling.
• Actively participated in the design of data model like conceptual, logical models using Erwin.

Environment: Erwin 3.x, Oracle 9.x, and MS Excel and Access

• .