PROFESSIONAL SUMMARY:

• Over 8+ years of experience in Information Technology in Data Modeling, Data Analysis, Design and development of Databases for business applications in Data Warehousing Environments
• Experience in various Insurance, Health Care, Financial and Banking domains.
• Expert in Business Requirement Document (BRD), Technical Specification Document (TSD), Customer Relationship Management (CRM), Business Rules Management (BRM), Business Rules Engine (BRE).
• Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Vast experience in developing Conceptual, Logical and Physical data models for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems
• Worked on projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments
• Expert knowledge inSDLC(Software Development Life Cycle) and was involved in all phases in projects process and familiar with Agile, Scrum, and Waterfall methodologies.
• Strong hands - on experience in Data Modeling tools like Erwin, Power Designer and ER Studio for developing Entity-Relationship diagrams
• Worked extensively on XML data and XSD schema designing
• Efficient in Data Warehousing/Data Mart design. Experience in identifying facts and dimensions from the Enterprise Architecture for designing Star and Snowflake Schema
• Experience in relational, dimensional, and multidimensional data modeling for creating conceptual data modeling
• Experience in design reviewing and validation of final data models
• Well versed with Normalization / De-normalization techniques in relational/dimensional database environments for optimum performance.
• Extensively worked on forward and reverse engineering processes for several projects
• Experience in Extract, Transfer and load process using ETL tools like Informatica
• Good knowledge on writing SQL queries using stored procedures, views, indexes and joins
• Conducted GAP analysis and User Acceptance Testing (UAT).
• Experience in data transformation, data profiling and data mapping from source to target database schemas and data cleansing and also keep track of data quality.
• A very good command over SQL queries, SQL Plus, PL/SQL Packages, Procedures, Functions and performance analysis indexes, creating partitions, aggregating tables when required
• Working closely with ETL/ Report Developers, Database administrators, Business Analysts and support teams.
• Strong communication and interpersonal skills with a proven track record of ability, adaptability, creativity and innovation along with demonstration of very strong technical and managerial skills and while successfully leading teams to strict project deadlines.

TECHNICAL SKILLS

Data Modeling Tools: Power Designer11.0/12.5, Erwin Data Modeler 7.1/7.2/8.2, ER /Studio 9.1/9.5, MS Visio, SQL Data Modeler

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008, DB2, MS Access, Teradata 13.10

Reporting Tools: Business Objects XI 3.1, Crystal Reports 9, SQL Server Reporting Services (SSRS)

Web Technologies: HTML, CSS, Java Script, XML

Operating System: Windows 98/2000/2007/XP/Vista, UNIX

Languages: SQL, PL/SQL, Visual Basic, C, C++, .Net

ETL Tools: Informatica 7.1.3 and 8, Microsoft SSIS

Others: MS Office, Toad, Tableau, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Data Analyst/Data Modeler

Responsibilities:

• Created the conceptual model for the data warehouse using ERwin data modeling tool.
• Designed logical and physical data models using data provisioning and consumption techniques.
• Developed scripts dat automated DDL and DML statements used in creations of databases, tables, constraints, and updates.
• Worked on reverse engineering on the existing data models and updates the data models.
• Participated with application developers and DBAs to discuss about various De-normalization, partitioning and indexing schemas for physical model.
• Created naming standards for data attributes and metadata to track data source, load frequency, generated key values, and data dictionary.
• Worked with the ETL team to ensure dat the company's data governing policy was adhered to generated extracts for multiple downstream users.
• Conduct data modeling sessions with business users and technical staff which includes conveying complex ideas both verbally and in written form
• Created Data Dictionaries, Source to Target Mapping Documents and documented Transformation rules for all the fields.
• Closely interacted with the Business Users and was involved in gathering, assimilation, organization, categorization and analysis of business requirements
• Created Mapping documents using the Metadata extracted from the Metadata repositories
• Isolate gap between technical requirements and business requirements. Understand database design - review and discuss pre-approved business requirements from the team and begin identifying and collecting specific system requirements (technology specs dat will meet the business needs).
• Perform Data Analysis on the source data in order to understand the relationship between the entities
• Continuously supported the production on-call support and resolved the tickets with short term and long term fixes.
• Worked with testing team to validate and review the test scripts, test cases, test results.
• BVR(Business Verification reports) as a part of production support.

Environment: ERwin 8.2, Oracle 11g, SQL Server 2012/2014, SQL Developer, SSIS, TOAD, Jira, DataAnalyst 3.1 and MS Office suite.

Confidential, Irvine, CA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Working with business users to know the business requirements.
• Maintaining change logs, Sub models.
• Extensively using the Erwin design tool & Erwin model manager to create and maintain data models.
• Created documentation and test cases, working with users for new module enhancements and testing.
• Defined corporate metadata definitions for all Enterprise Data supported databases (operational source systems, data stores and data marts).
• Performed Data Analysis, Data Profiling & Validity, Data cleansing rules etc.
• Developed mapping spreadsheets dat will provide the Data Warehouse Development (ETL) team with source to target data mapping.
• Took a leadership role when working with the Data Warehouse Development (ETL) team to research and define existing source to target mapping for the corporate Data Warehouse.
• Has done proof of concepts on different ETL solutions using ETL tools like informatica power center, power exchange, MDM, Talend etc.
• Created a high-level industry standard, generalized data model to convert it into logical and physical model at later stages of the project using Erwin and Visio
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Created multiple custom SQL queries in Teradata SQL workbench to prepare the right data sets for Tableau dashboards.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Developed logical and physical data models dat document source data from multiple source application (Client's internal data systems, external source data systems, 3rd Party Data, Prospect Lists, etc.) like SAP, Mainframes, Java etc.
• Defined and developed designs to support departmental and functional data marts. Provided input to data modeling and physical database development standards with the Data Modeling Team.
• Assisted in the review of database structures of proposed business application purchases.
• Worked closely with analytical and reporting infrastructure teams to ensure operational and analytical data warehouses were able to support all business requirements for OLAP reporting across the organization.
• Assisted in the design and administration of the corporate Metadata Repository.
• Maintained Enterprise logical and physical data models, reflective of current environments.
• Conducted business-meeting sessions for addressing discrepancies and resolving them.
• Assisted the Interface Design Model (IDM) team in understanding the Business Model.
• Participated in the Data Review Board (DRB) reviews as a part of the Data Architecture Team by playing the role of a secondary and email reviewer.
• Provided recommendations as a part of the DRB review sessions, to see if the attributes at the physical and logical level abide by the naming standards.
• Strong understanding of the principals of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
• Excellent analytical, inter-personal and communication skills with a strong technical background

Environment: Sql Server 2012, DB2, ORACLE, Tableau, Toad for Oracle 9.1 Expert, Erwin Data Modeler r8.2, MS Visio, EAGLE Investment System Tool.

Confidential, SFO, CA

ETL Data Analyst

Responsibilities:

• Translate business requirements and models into feasible and acceptabledatawarehouse designs.
• Design and build appropriate datarepositories anddatamovements (dimensional databases) to ensure dat business needs are met.
• Create database models, which serve as blue prints for project engagements of all complexities.
• Experience modeling data in either for OLTP or Data Warehousing environments (if possible both) including conceptual, logical and physical models
• Gathering of ReferenceData, Business Rules, Transformation rules, statistical models supporting campaign identification and suppression target populations
• Document and extract the ETL information for Integration/Operational Data Store after validating the XML payload.
• Translate enterprise or business requirements into long-termdataarchitecture solutions including conceptual, logical and physical models
• Design and review logical and physicaldatamodels for OLTP and OLAP in compliance with corporate standards.
• Work with IT ETL and Report Developers to communicate database designs
• Responsible for design, build, and maintenance ofdataarchitectures for complex, highly visible business intelligence and analytic solutions dat are both flexible and scalable
• Design and oversees the implementation ofdatatransformation and change processing procedures to ensure datdatafrom multiple sources is aggregated, normalized and updated and tan published to multiple target environments
• Involve in the creation of naming standards file and data mapping documents.
• Involve in migrating the project related tables from one environment to the other.
• Document all technical requirements and design technical solutions utilizing enterprise architecture standards including documenting all solution components and configurations.
• Interact with developers, project managers and focus groups to minimize expenditure, avoid redundancy, and improve overall synergy within organization.
• Translate business requirements into detailed architectures and designs.
• Implement architectural designs while building solid relationships with stakeholders at all levels.
• Work with functional analysts, developers and development managers to ensure dat all solutions are deployed within agreed timelines and supported after delivery.
• Provide technical, solution development, and project management expertise to various projects throughout the firm.
• Develop reusable assets such as solution architectures, both physical and logical.
• Create solution architecture and planned the development effort.
• Lead and mentor the project team from both technical and functional perspectives including database development, data architecture, integration development, requirements identifications, testing, and project management.
• Analyzing, creating and maintaining Primary indexes (PI), Secondary Indexes (SI), Join indexes (JI) Partition Primary Indexes (PPI), Multilevel Partition Primary indexes (MPPI), and compression
• Work extensively on all phases of the project development life cycle of system analysis, design, development, testing and implementation.
• Analyze data for Marketing, Accounting, Finance, and Supply Chain teams.
• Create architecture solution designs and documentation to drive high-quality and feasible implementations.
• Create and manage Work Back Schedule (WBS) of Business intelligence teams.
• Responsibilities included but not limit to, interaction and gathering functional requirements from Business users.
• Provide solutions dat effectively meet the performance, extensibility, integration, capacity, and accessibility needs of applications.
• Responsible for transforming requirements into architecture and design documents dat was used by the team to implement solutions.
• Develop effective standards, best practices, procedures and key metrics to enhance operational stability of the tools supported.

Environment: Erwin, ER Studio, MS Office Suite Applications, MS Visio, Business Objects XIR2, Oracle, Toad, Teradata, Data Warehouse, SDLC, Informatica, RTAM, Rule Point

Confidential, Roseland, NJ

Data Modeler/Data Analyst

Responsibilities:

• Worked in close association with the Business Analysts and DBAs for gathering requirements, business analysis, and testing and project coordination.
• Interacted with end users and acquired the reporting needs.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Created logical, physical and dimension models.
• Created entity diagrams and relationship diagrams and modeled cascade to maintain referential integrity.
• Used Erwin to create tables using forward engineering.
• Generated Reports from data models.
• Reviewed the data model with the functional and technical team.
• Assisted the ETL staff, developers and end users to understand the data model.
• Maintained a change log for each of the data models created.
• Added database objects (like indexes, partitions in oracle database) for performance.
• Checked to see if the data models and the databases are in sync.
• Wrote store procedures and triggers.
• Created SQL codes from data models and interacted with DBA's to create development, testing and production database.

Environment: Erwin data modeler 7.2, Oracle 8i, SQL Server 2008, ER/STUDIO, Informatica, TOAD and UNIX.

Confidential, Alpharetta, GA

Data Modeler

Responsibilities:

• After discussions with BA's DA's and knowing the business requirement I used to design the Logical Data Model.
• After the designing of Logical Data Model and team review Logical Model were converted into Physical Data Model.
• Responsible for plans and schedules has EDW Data Architecture team to ensure timely & high quality project delivery.
• Designing and maintaining Logical & Physical data models, creating master data domains, maintaining the master Naming template and made a new Data Dictionary to make sure dat it's the same and used across the enterprise.
• Capturing and maintaining meta-data pertaining to data definitions, linage, rules, and taxonomy.
• Created Summary and Aggregate tables for better performance of the query
• Generated the DDL's from the Physical Data Model.
• I used to write and upload the Diagram documentation and PDF.
• Meeting with the DBA's and doing the capacity planning.
• I was single point of entry / exit for the teams Architectural Work.

Environment: Data Modeling Tool ER Studio(8.3.5/9.0), Database Systems Teradata 12.0 and 13.0meta-data repository, MS Office packages Word, Excel, Power point, Project.

Confidential

Data Modeler

Responsibilities:

• Designing Logical Data Models and Physical DataModels using Erwin.
• Developing the Conceptual Data Models, Logical Data models and transformed them to creating schema-using ERWIN.
• Developing the Data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Forward Engineering the Data models, Reverse Engineering on the existing Data Models and Updates the Data models.
• Database cloning to synchronize test and Developing Database to production database.
• Writing Procedure and Package using Dynamic PL/SQL.
• Created Database Tables, Views, Indexes, Triggers and Sequences and Developing the Database Structure.
• Data cleansing process on staging tables.
• Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process.
• Normalizing the Data and developing Star Schema.
• Reducing the CPU cost for the query by various hints and Tuning SQL queries.
• Extensively performed manual Test process.
• Extensively generated both logical and physical reports from Erwin.
• Involved in developing the Data warehouse for the complete Actuarial Information System Application.
• Worked with DBA's after generating DDL to create tables in database.

Environment: Erwin data modeler 7, Oracle 8i, SQL Server 2008, ER/STUDIO, Informatica, MS Office packages Word, Excel, Power point, Project, TOAD

Confidential

Business Analyst

Responsibilities:

• Conduct JAD sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Interacted with the Subject Matter Experts (SME's) and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Worked with Internal and External Users to define requirements and coordinated user management and developer expectations.
• Mapped the Source information to identify the Target information.
• Developed Use Cases using MS Visio, and a detailed project plan with emphasis on deliverables.
• Monitored Change Requests and documented requirements, integrating them with Use Cases.
• Developed and Implemented Test Strategies using the Test Director.
• Interact with stakeholders to understand client business processes and requirements.
• Gather business, functional and technical requirements
• Study and analyze data inventory List, Identify/Categorize/Classify into Business Areas.
• Perform attribute level gap analysis of the inventory to the data in Kalido EDW.
• Summarize gaps and categorize them by business unit, source systems, process type.
• Analyze complex data sets, performing ad-hoc analysis and data manipulation in Landing, Staging and Warehouse schemas using SQL.

Environment: Oracle, TOAD, Microsoft Visual Source Safe, IBM Rational Clear Case and Clear Quest, Microsoft Office.