SUMMARY:

• 7 Years of IT experience in System Analysis, Application Design, Dimensional Data Modeling, Implementation and Testing of Enterprise Data Warehousing and Enterprise Database.
• 7 years of experience in Data Modeling using Erwin 8.0/7.2.9/4.5/4.1.4/3.5.2 , ER/Studio7.1.1/7.5, Oracle Designer 2000 and SQL Designer.
• Extensive Experience in Relational Modeling, Dimensional Modeling, Conceptual, Logical Modeling, Physical Modeling, Star Schema, Snowflakes Schema, ERD(IDEF1X and IE notation) ER Diagrams, Granularity, Cardinality and Database Reengineering.
• Experience in developing data models which will serve both OLTP and OLAP functionality.
• Has a good experience in Pharmacy related Database design.
• Has a good knowledge on Tax domain.
• Expertise in working with business users as part of requirements gathering and converting them into technical solution.
• Designed databases involving complex views, triggers in Oracle 11g/10g/9i/8i/8, Microsoft Access, DB2, and SQL Server 2005/2000.
• Experience in creating, maintaining and designing database diagrams, setting table relationships and indexes.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies).
• Worked closely with ETL teams such as Informatica to extract data from Source system to target systems and created mappings, Data Reports.
• Deployed naming standard to the Data Model and followed company standard for Project Documentation.
• Has a good experience on Consolidating data from different data source and performing Data Analysis
• Expertise in Normalization techniques for data consistency and Flexible Database design.
• Expertise database normalization method defined by E.F CODD (3NF - Third Normal Form).
• Expertise in Creating UNIX Shell scripts.
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling.
• Designed the PL/SQL procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Expertise in creating Schema objects like Indexes, Views, and Sequences.
• Worked in a team environment and also coordinated with business/functional team.
• Excellent interpersonal and oral/written communication skills.
• Involved in the preparation of Detailed Design Documentation.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC and facilitated JAD sessions.
• Good interpersonal and human relation skills to interact with clients and co-workers

TECHNICAL SKILLS:

Analysis and Modeling Tools: Erwin 7.x/8.x/9.x, ER/Studio, MS Visio

ETL Tools/BI Tools: Informatica Power Center 9.x/8.x/7.x, clover ETL: Cognos 8, MicroStrategy, Business Objects, Qlikview, Tableau

Languages: SQL, PL/SQL, XML, HTML, UNIX Shell Scripting, C, C++, Java AWK

Databases: MS SQL Server 2012/2008/2005 , Oracle11g/10g/9i, MS Access 2000, IBM DB2.

Operating Systems: UNIX (Sun), Windows, GNU/Linux, IOS

Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP), Agile, Rapid Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE:

Confidential

Sr Data Modeler/App Analyst

Responsibilities:

• Created a logical design of the central relational database using Erwin9.6 worked on Multiple projects CHRDS, CLAIMS, PHARMACY, FINANCE, HEALTH CARE.
• Extensively worked with DTS to load the data from source systems, and run in periodic intervals
• Worked with data transformations in both normalized and denormalized data environments
• Worked on salesforce CRM tool to analyze the customer requirements.
• Involved in data manipulation using stored procedures and Integration Services.
• Worked on query optimization, stored procedures, views, and triggers.
• Assisted in OLAP and Data Warehouse environment when assigned.
• Created tables, views, triggers, stored procedures and indexes.
• KIMBALL and INMONN methodologies were used for architecture.
• Designed and implemented database replication strategies for both internal and Disaster Recovery
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Performed extensive data analysis and data validation on Teradata.
• Metadata repository was updated and maintained according to change requests.
• Developed several forms & reports using Crystal Reports.
• Experienced in master data management (MDM), Metadata management, data quality.
• Experienced in building Data marts, data structures, data storages, data warehouses, data archives, and data analysis
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: DB2, SQL, ORACLE, Teradata SQL assistant 12.0, Windows Server 2012, MS SQL 2012, UNIX, Erwin 9x, Crystal Reports8, Informatica 9x, TOOD.

Confidential, Raleigh, NC

Data Analyst/Sr. Data Modeler

Responsibilities:

• Built Conceptual, Logical and Physical model and implemented them on Care Synergy.
• Understanding the application and building the database accordingly.
• Participated in meeting with different teams of CMIS, MDM and CAREVIEW and took the requirements and implemented them on Care Synergy.
• Interacted with the business Analyst and getting the functional requirements
• Gathering accurate data by data analysis and functional analysis
• Provided 24/7 support on Database perspective in case of any issue raises
• As this project follows Agile Methodology, I will be working with the QA people closely and load the data for Unit Testing and Manual Testing
• Check to see data model and database are in sync.
• Data modeling, design & implementation based on established standards
• Done Data Loading using ETL for QA for testing and also worked closely with the developers and getting the requirement for the database side
• Forward engineer logical models into physical tables with Confidential naming standard class words.
• Data Quality, Data Migration while loading the data from one database to another.
• Has built a good knowledge on the application and gone through the each and every requirement clearly and implemented those on Database
• Review the data model with functional team and technical team
• Followed Data Standard Documents while building the database and participated in Database sessions for finalizing the database structure
• Created a Data Structure document for each table and column that is implemented on database
• Designed and developed Data Quality Reports, Chain of Trust Mechanisms for File processing.

Environment: SQL Server 2012, Windows Server 2003, Teradata, Windows XP, SQL Profiler, VSS, TFS, Erwin, DBTA, Initiate - IBM Tool for Person MDM, SQL Management Studio, DBTA, SSIS, Informatica

Confidential, Louisville

Data Analyst/Data Modeler

Responsibilities:

• Architected an enterprise solution and led a technical team of 6 to build the Person Master Data Management process and solution for Confidential 's insurance business.
• Person/Customer MDM Solutions
• Custom and Automated Maintenance Plans (Optimization, Integrity Checks etc.) for Very Large Databases. The first to be done in Confidential .
• Architected an enterprise solution that provides data isolation capabilities around co-located data. This ensures that data is provided based on appropriate security context.
• Data Modeling for OCH DB
• Performance Tuning of the SDR/OCH DB's
• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflows.
• To build new servers with an enhanced architecture solution to accommodate ETL, OLTP, Reporting requirements for SDR
• Has been working on Application Design for Data Isolation, Ps.
• Designed and developed Data Quality Reports, Chain of Trust Mechanisms for File processing.
• Built the system for non-functional activities like backup, restore, recovery, auditing and archival processes for the OCH DB.

Environment: SQL Server 2005, Windows Server 2003, Teradata, Windows XP, SQL Profiler, VSS, TFS, Erwin, Enterprise Architect Sparx 7.5, DBTA, Initiate - IBM Tool for Person MDM, SQL Management Studio, DBTA, SSIS, Informatica

Confidential, Wilmington, DC

Sr. Data Modeler/Analyst

Responsibilities:

• Involve in project kickoff meetings to understand the need and scope of the project.
• Attend cross team meetings with project business Analysts and technical leads to gather basic requirements to create a high level project diagrams.
• Perform data profiling in Production environment to analyze and collect the statistical information.
• Design the logical diagrams according to Barclaycard standards for initial review with Technical leads.
• Analyze the relationship between the entities based on the requirements and define STAR and Snowflake schema models in Erwin.
• Maintain metadata of all the new and existing models in Erwin to be readily available for business users.
• Apply normalization techniques on data set and embed them in the model
• Forward engineer logical models into physical tables with Barclaycard naming standard class words.
• Analyze the table structure based on the size and design indexes to boost the performance.
• Created new reports based on requirements.
• Created Report-Models for ad-hoc reporting and analysis.
• Maintain the script versions in WinCVS to deploy in QA environments.
• Coordinate with DBAs during deployments and troubleshoot the issues if any
• Document the work flow in high level and detail level for future and enhancements.

Environment: Oracle 10G/11G, TOAD, Teradata, Erwin 9.2, Windows, SQL plus, WinCVS, HP Quality Center 11, SDLC, UNIX, Windows XP

Confidential, Texas

Sr. Data Modeler/Analyst

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution
• Gathered and translated business requirements into detailed, production-level technical specifications, added new features and enhancements to existing technical business functionality
• Involved in gathering user requirements along with Business Analyst
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Extracted data from the databases (Oracle and SQL Server) using Informatica to load it into a single data warehouse repository
• Created data mapping documents from source to target systems
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part of Data Analysis responsibilities
• Used DB2 as the database for better analysis and for better performance.
• Identified and processed the facts and dimension tables
• Worked with report developers for building Data Marts for ad hoc reporting
• Analyzed, created and formatted the Reports as per Business Requirements.
• Analyzed and created variousadhoc Reportsfor users based on User Requirements.
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation phase
• Assisted end users, operations and testing teams by providing them with the necessary documents

Environment: Erwin r7.1, Informatica 8.x, Windows, Linux, SQL Server 2000/2005, SQL, IBM DB2, MS-Excel, MS Visio.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account
• Managers and UI (User Interface) of the existing Broker Portal system.
• Wrote Requirement and Design document for Master Data Entities. Used Corporate Modeler to design the Process
• Conducted controlled brain-storming sessions with project focus groups.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents)
• Supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Analyzed different source systems in order to come up with Source system which was generating the data.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in Rational Rose.
• Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other
• Stakeholders for open and pending issues to develop specifications.
• Participated in the Data Modeling to generate target database layout use for the data marts.
• Generated data mapping documents to define mapping from source to target.
• Reviewed the business requirements or use cases, do the analysis, and convert them to logical dataModels.
• Participated in high-level and low-level design sessions including writing technical project documentation.
• Identified/documented data sources and transformation rules required populating and maintaining dataWarehouse content.
• Defined the data definitions, and create the target tables in the database.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Provided data modeling support for numerous strategic application development projects.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and In corporate the changes as and when necessary.

Environment: Windows Server 2003, MS SQL 2000, UNIX, Erwin 5, Crystal Reports8