SUMMARY

• Seven plus years of diverse experience and demonstrated success in IT industry with specialization in Data Analysis, Database Design.and Data Modeling
• Well implementation knowledge of various SDLC Software Development Life Cycle methodologies.
• Develop detailed selection process from software database system.
• Identify,analyze and interpret trends or patterns in complex data sets
• Involved in requirement gathering, database design and implementation of Relational Model in Enterprise ODS and Dimensional Model in Data Ware House.
• Requirement gathering from the Clients. A series of meetings were conducted with the business system users to gather the requirements for reporting.
• Well versed with Normalization /De - normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Designed Informatica mappings, enabling the Extract, Transport and Loading of the data into a single data warehouse repository.
• Experience in Data Transformation and Data Mapping from source to target database schemas and also data cleansing.
• Well versed in data modeling tool concepts like forward and reverse engineering, model manager, complete compare and report generation.
• Exposure to data mining and also data like Clinical, Biological, Pharmaceutical and Bureau etc…
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Extensive experience in development of T-SQL, DML, DDL, DTS, Stored Procedures, Triggers, Sequences, Functions and Packages.
• Experience in performance tuning and optimization of the database for business logic implementation.
• Acquire data from primary or secondary data resources and maintain databases/data systems

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Visual Basic, HTML, CSS, Oracle 11g/10g/9i, TeraData

Operating Systems: Windows 98/2000/XP/7/8, UNIX, MS-DOS

Modeling Tools: Erwin r8.1, r7.3, Power Designer, Microsoft Visio

ETL Tools: Informatica 8.1/9.1

PROFESSIONAL EXPERIENCE

Confidential, MN

Senior Data Analyst/Modeler

Responsibilities:

• Develop and maintain authoritative data set.Communicate analysis in both written and oral format to wide range of audiences
• Write efficient SQL and store procedure against database tables on various platforms
• Developing database schemas like star schema and snowflake schema used in dimensional and multidimensional databases OLAP .
• Research, retrieve.design, troubleshoot and deliver organized analytics regarding healthcare data
• Forecast trends and identify trend drivers.Develop and communicate reports to support trend analysis, interpret and analyze claims, provider and membership data
• Develop programming specifications. Design code and Unit test application code using SDLC best practices for application services functions
• Developed multiple logical models per the requirements and validate it’s alignment with the enterprise logical data model (ELDM).
• Requirement gathering from the Clients. A series of meetings were conducted with the business system users to gather the requirements for reporting.
• Requirement analysis was done to determine how the proposed enhancements would affect the current system. Understood existing data model and documented the performance of the system.
• Responsible for maintaining and updating Data Mapping and Design documents and documenting the end-to-end process and the direct linkage of the processes to systems configuration.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases
• Created reference values, lookup tables, history and staging tables per requests from development teams and worked with them in developing the mappings.
• Participated in bi-weekly status calls to update the team on development status, work closely with system and business analysts to finalize the model and review the final model with the whole team for both educational and approval purposes.
• Worked extensively on legacy models that were reverse engineered from database to implement object naming standards in the logical model and completing definitions by working with respective application teams.
• Assisted other teams in integrating multiple data models when the respective systems were migrated from multiple databases into a single oracle schema.

Environment: Windows 7, Erwin r7.3,PL/SQL Developer 8.0.4, Oracle 11g/12c, Microsoft SQL Server 2008 R2, Informatica 9.1.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Involved in meetings with business users and business analysts to define and document the reporting requirements for various projects and validate the user stories and story cards created based on reporting requirements.
• Develop thorough understanding of business domain, data platforms and data strategy
• Identify the source systems and tables which contain the data required for reporting. Examples of sources systems are Oracle Financial Apps, PeopleSoft and Salesforce.
• Involved with the architect team to develop the architecture which can address the current reporting requirements as well as being able to scale to future reporting needs.
• In data staging area, data is cleaned, conformed and transformed to be available for integration in Data Mart using ETL tool Informatica.
• Designed Data Marts using Dimensional modeling technique (star schema & snowflake schema) to integrate the data from various sources and to enable management to make more fact based decisions.
• Developing database schemas like star schema and snowflake schema used in dimensional and multidimensional databases OLAP .
• Review Data Staging Model (Relational Model) and Data Mart Model (Dimensional Model) with ETL and Business Reporting (Microstrategy) Team to confirm that the model satisfies the reporting needs.
• Involved in meetings with Data Governance team to ensure proper exercise of authority and control over the management of data assets.
• As part of data Governance team, we dealt with various areas of enterprise data management such as Data quality, Metadata Management, Data Security (SOX).
• Design and develop the Data Dictionary, Business Glossary (to ensure the consistency of Business term across organization) and Meta data of the models and maintain them.
• Created DDL Scripts using ER/Studio for the IDR and Mart model and executed them in respective DEV environments so as to make sure the ETL can start the build.
• Analyze and anticipate data warehouse performance issues and address performance issues through various techniques such as indexing, partitioning and subpartitioning.
• Ensure Data Warehouse security by restricting access at object level and row level in Microstrategy.
• Constant effort to see how dimensional modeling and architecture can be improved to enhance the performance and better address business problems.

Environment: Windows 7, PL/SQL Developer 8.0.4, Oracle 11g, Microsoft SQL Server 2008 R2, Informatica 9.1.

Confidential

Data Modeler/Analyst

Responsibilities:

• Involved in several meetings with Business Analysts to gather data requirements from business and technical users for a data warehouse environment.
• Responsible for translating the business requirements into Conceptual/Logical/Physical Models for various work streams.
• Responsible for database design, integration and Data Modeling for various work streams.
• Involved in Design, Development and Standardization of Databases/Data warehouse for various work streams.
• Performed Source-to-Target Data Mapping and Created Data Flow Diagrams to depict the source-to-Target Mapping.
• Responsible for creating Source to Target data mapping documentation for various work streams.
• Gathered Source data information to design and build source staging tables.
• Responsible for Performing Requirement Analysis and Data Analysis for various work streams.
• Creating various forms of documentation like Data Design Documents/Conceptual Design Documents/DDL for various work streams.
• Responsible for maintaining and updating Data Mapping and Design documents and documenting the end-to-end process and the direct linkage of the processes to systems configuration.
• Utilized Erwin extensively to create Logical/Physical models and also the Forward/Reverse engineer techniques.
• Utilized several PL/SQL queries to load and analyze the data.

Environment: Windows XP, Erwin r7.3, SQL Server 2008, DB2, Toad for DB2.