SUMMARY

• 9+years of IT experience in design, architecture, development, implementation and maintenance to support standard databases and data warehousing environments.
• Working experience as a Data modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Excellent experience in delivering Quality Conceptual, Logical and Physical Data models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Proficient in data mart design, creation of cubes, identifying facts& dimensions, star & snowflake schemes.
• Solid knowledge Master Data Management (MDM) data modelling using IBM Infosphere data architect
• Efficient in developing Logical and Physical Data model and organizing data as per the business requirements using Sybase Power Designer, Erwin, ER studio in both OLTP and OLAP applications
• Comprehensive knowledge and experience in process improvement, normalization/de - normalization.
• Expertise on Relational Data modeling (3NF) and Dimensional data modeling.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Expertise in documenting the Business Requirements Document (BRD), generating the UAT Test Plans, maintaining the Traceability Matrix and assisting in Post Implementation activities.
• Experience on Data profiling, Data Analysis, Data Cleansing and Data Masking.
• Experienced in theData Analysis, Design, Development, Implementation and Testing usingData Conversions, Extraction, Transformation and Loading ETL and SQL Server, ORACLE and other relational and non-relational databases.
• Experience in RDBMS (Oracle) PL/SQL,SQL, Stored Procedures, Functions, Packages, Triggers
• Worked in Data warehouseData&ETL Architecture, Oracle Database platform, ErwinData modeler, Informatica Power center and SSIS, End to End solutions architecting, Implementing for DWBI Engagements.
• Experience in Dimensional Modeling and Data Warehouse. ETL tools Informatica /Data Stage/BI tools such as Business Objects. Star& Snow Flake Schemas.
• Extensive experience in using ERmodeling tools such asErwinand ER/Studio.
• Excellent problem solving and analytical skills with a proven ability to learn and understand new technologies efficiently.
• Effective team worker and can carry out individual tasks to meet the deadlines effectively.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE Methodologies.
• Extensive experience with OLTP/OLAP System and E-R modeling, developing Database Schemas like STAR schema and Snowflake schema used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server14.0, Teradata 15.0, Oracle 12c/9i, and MS Access

SQL Interpreters: Erwin 9.x/7.x/4.x, Toad 9.6

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data extraction, Integration, transformation and Migration, ETL Architecture and Design Data Warehouse, OLTP, OLAP, Report Design and Development.

Data Analysis: User Requirement Gathering, JAD Sessions, Gap Analysis, Data Cleansing, Data Transformations, Source Systems Analysis, Data Relationships.

ETL Tools: SAP Business Objects, Informatica

Reporting Tools: Tableau8.2, Crystal Reports

MS Office Tools: Excel, Access, Word, PowerPoint, Project, Visio

Languages: VB, PL/SQL, Java Script, Java, Python

Operating Systems: Windows 10/7/ XP/00, Linux

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN

Sr. Data Analyst / Data modeler

Responsibilities:

• Involved in creating Physical and Logical models using Erwin.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in the data model.
• Used AWS Redshift Cloud.
• Involved in the creation, maintenance ofDataWarehouse and repositories containing Metadata.
• Designed different type of STAR schemas like detaileddatamarts and Plandatamarts, Monthly Summarydatamarts using ER studio with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Involved in creating Physical and Logical models using Erwin.
• Worked on building the data model using Erwin as per the requirements. Designed the grain of facts depending on reporting requirements.
• Defined and processed the facts, dimensions. Designed thedatamarts using the Ralph Kimball's DimensionalDataMart modeling methodology using Erwin.
• Worked with Teradata and/or Oracle in a multi terabytes environment.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Designed different type of STAR schemas like detaileddatamarts and Plandatamarts, Monthly Summarydatamarts using ER studio with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Used Model Mart of Erwinr9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Design Data models for development of new transactional systems.
• Design Data models for development of a data warehouse and data marts.
• Worked on building the data model using Erwin as per the requirements. Designed the grain of facts depending on reporting requirements.
• Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Worked on Columnar data models for AWS.
• Maintained expertise in the MPP / Hadoop / Big Data ecosystem, including industry trends, strategies, and products.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Created various PhysicalData models based on discussions with DBAs and ETL developers.
• Worked ondatamapping process from source system to target system.
• Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Extensively used Star and Snowflake Schema methodologies.
• Developed and maintainedDataDictionary to create Metadata Reports for technical and business purpose.

Environment: Erwin, PL/SQL, Business Objects XIR2, ETL Tools Informatica9.5/8.6/9.1 Oracle 11G, Teradata V2R13/R14.10, Teradata SQL Assistant 12.0, Netezza, Power Designer, Erwin, Hadoop, AWS.

Confidential, Minneapolis, MN

Sr. Data modeler/Analyst

Responsibilities:

• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in the datamodel.
• Developing the Conceptual Data models, LogicalData models and transformed them to creating schema using ERWIN.
• Translated business requirements into working logical and physical Data models for Data warehouse, Data marts and OLAP applications.
• Participate in biweekly technical huddle meeting with development and DBA team. Participate in weekly data analyst meting and submit weekly data governance status.
• Defined and processed the facts, dimensions. Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.
• As part of Data Masking / Data Privacy performing the Reverse engineering on the Data model to identifying the Schemas based on requirements.
• Gathering the business requirements from the respective application team (Data Architect's / Application Owner's).
• Prepared High Level Logical Data models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Responsible for defining the key identifiers for each mapping/interface.
• Reverse engineered all the Source Database's using Erwin.
• Used Data Analysis techniques to validate business rules and identify low quality missing data in the existing data.
• Reviewed requirements together with QA Manager, ETL leads to enhancing the data warehouse for the originations systems and servicing systems.
• Analyzing the requirement from application team i.e. Sensitive & Personal Information.
• Updating the existing Data models in all environments.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.

Environment: Oracle 12c, SQL Server 2005/2014, DB2, Microsoft Transaction Server, Erwin r9.6.1, Teradata 15, Crystal Reports, SSIS/SSRS, Informatica, MS-SQL server manager, Microsoft Access, SAP BW.

Confidential, Pittsburgh, PA

Sr.Data modeler/Analyst

Responsibilities:

• PerformedData Analysis anddataprofiling using complex SQL on various sources systems
• Used CA ErwinData/Modeler(Erwin) fordata modeling Perform Data Analysis & Profiling Activities to identify volumes, data quality issues to Solution Designers &ETLArchitects.
• Use a variety of information gathering techniques to gather complex business data requirements from internal business clients and development teams.
• Analyzed data requirements & provided conceptual and technical modeling assistance to developers.
• Reviewed Data models with Solution Designer to assess the impact of the new model on the enterprise model.
• Identified data sources and areas of overlap, and facilitated data sharing.
• Attended Data Governance Team (DGT) meetings to address data modeling changes to reviewed databases and the enterprise database.
• Created, Collected and maintained Metadata.
• Evaluate completeness and accuracy of Data models.
• Created Entity Relationships diagrams, data flow diagrams and implemented referential integrity using ERWIN.
• Walkthroughs with DBA were conducted to update the changes made to the data model.
• Successfully worked closely with the QA team, other developers and the DBA to ensure optimal performance of SQL scripts.

Environment: Erwinr7.1, OBIEE, Oracle9i, Oracle Warehouse Builder, Microsoft 2008, SQL Developer, SQL Manager, ER studio, DSS, SQL Developer Data modeler, Visio, Oracle Data Integrator (ODI), Informatica, Crystal Reports, SOA,OLTP.

Confidential, Hartford, CT

Sr. Data modeler/Data Analyst

Responsibilities:

• Designed both 3NFData models for ODS, OLTP systems and dimensionalData models using star and snowflakeSchemas
• Wrote ad-hocSQLqueries and worked with SQL and Netezza databases
• Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects.
• Staging and Target Schema Model Designed and Deployed DDL in Oracle10g Database
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business user.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using ERStudio.
• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization.
• Created conceptual & logical models, logical entities and defined their attributes, and relationships between the various data objects.
• Created a list of domains inErwinand worked on building up the data dictionary for the company
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
• Create and maintain Metadata, including table, column definitions
• Generated a separate MRM document with each assignment and shared it on SharePoint along with the PDF of updated Data models
• Created DDL scripts for implementing DataModeling changes. CreatedERWINreports 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.
• Used Model Mart ofErwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Assisted the ETL Developers and Testers during the development and testing phases
• Conducted User Acceptance Testing (UAT)
• Performeddatamanagement projects and fulfilling ad-hoc requests according to user specifications by utilizingdatamanagement software programs and tools like Perl, Toad, MS Access, Excel and SQL.

Environment: Oracle 10g, Microsoft SQL Server 2012, SQL Developer, SQL Manager,Erwinr9, SQL Developer Data modeler, Visio, Informatica, Crystal Reports

Confidential

Data modeler/Data Analyst

Responsibilities:

• Designed Logical & Physical Data model /Meta data/ data dictionary usingErwinfor development teams both offshore and on site.
• Provided conceptual /functional /business analysis assistance to developers and DBA's usingErwin/ ER - Studio. Validated Data models with client developers
• Created various PhysicalData models based on discussions with DBAs and ETL developers.
• Extensively used Star and Snowflake Schema methodologies.
• Designed Data models with GE- ERC standards up to 3rd NF (OLTP/ODS) and de normalized (OLAP) data marts with Star & Snow flake schemas.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Improved performance on SQL queries used Explain plan / hints /indexes for tuning created DDL scripts for database. Created PL/SQL Procedures and Triggers.
• Created more than 20 New Models and with more than 100 tables. Used STAR schema and Snow flakeSchema for datamarts / Data Warehouse.
• Created tables, views, sequences, triggers, table spaces, constraints and generated DDL scripts for physical implementation.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Performed data mining on data using very complex SQL queries and discovered pattern.
• Used SQL for Querying the database in UNIX environment.

Environment: Oracle 8i/9i, SQL, PL/SQL Developer 5.1,Sun Solaris8.0,Erwin4.0, ER- Studio6.0/6.5, Toad 7.6, Informatica 7.0, IBM OS 390(V6.0), DB2 V7.1.