SUMMARY:

• 7 plus years of experience in Data Analysis, Data mining, Data Architecture, Data Modeling, NLP with large data sets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive modeling, Data Visualization.
• Strong experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Informatica Power Center Experience in testing, data validation and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/DataMart Design, ETL, BI, OLAP, Client/Server applications.
• Proficient in Data Analysis on Oracle, MS SQL Server & MS Access with sound knowledge in extraction of data from various database sources like Oracle, MS SQL Server, DB2 and Flat files into the Data Stage. Also, in Object Oriented data modeling using tools like ERwin, ER/Studio and Power Designer, for both forward and reverse engineering.
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Knowledge in provisioning virtual clusters under AWS cloud which includes services like EC2, S3, and EMR.
• Worked with Erwin, Power Designer Model in multi-user environment for normalized and dimensional data structure as well as Project planning and project management.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, BTEQ, MLDM and MDM.
• Knowledge on using SSRS in creating and managing reports for an organization.
• Expertise in business analysis, data analysis, project planning, design, development, testing and implementation of end to end data warehouse solutions.
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Well versed in SQL programming & fine tuning and designing the Relational (OLTP) and Dimensional databases using Star Schema and Snow Flake Schemas (OLAP and ROLAP) (Logical and Physical), Mainframe, Data Warehouse, Client-Server and Internet applications development and deployment.
• Extensive experience with Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.

PROFESSIONAL EXPERIENCE:

Data Modeler/ Data Analyst

Confidential, Eddyville, KY

Responsibilities:

• Involved in preparing and designing Logical Data Models/Physical Data Models using ER-Studio
• Created SQL Loader Scripts, table sizing, indexing, table partition, SQL tuning.
• Created DDL, DML scripts. Created and worked with X-Reference tables for data validation between difference data marts/Databases.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r9.
• Worked with Finance, Risk, and Investment Accounting teams to create Data Governance glossary, Data Governance framework and Process flow diagrams.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.
• Demonstrable knowledge in SSIS control and dataflow tasks and experience in scheduling package execution using Tidal Enterprise Scheduler.
• Translate business requirements to data mining requirements by using different data analysis tools such as R, Rapid miner and Tableau.
• Based on Business Requirements developed SSRS reports, used Datasets from SQL and Oracle connections to pull the data to Sub-report and Drill-down reports.
• Written complex SQL queries using joins and OLAP functions like CSUM, Count and Rank etc.
• 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, coordinated with DBAs' to apply the data model changes.
• Built a custom data quality tool/dashboard that is now used to perform proactive analysis for all domains in Data Governance to evaluate data quality across different measures: Completeness, Validity, Accuracy, Integrity and
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Defined the data sources, data loads and data transformation using ER Diagrams. Used MS-Visio for model diagrams, MS-Word for documentation and used Unified Modeling Language for visual modeling.
• Impact assessment to existing process and data model assessment for new initiative across enterprise.
• Writing new Pl/Sql Packages/procedures/Sql Queries to cleanse address via our services which are being invoked from JSON.
• Utilized Tableau to provide customer dashboards.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the aggregated level of detailed reports. Worked on the Snow-flaking the Dimensions to remove redundancy.
• Created mapreduce running over HDFS for data mining and analysis using R and Loading & Storage data to Pig Script and R for MapReduce operations and created various types of data visualizations using R, and Tableau.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Create and maintain Metadata, including table, column definitions.
• Synched up the models by reverse engineering, compare model and merge model from database to the original models.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Participated in the Master Data Management (MDM) effort; provide technical advice and support toward the development of strategic and tactical plans for client master data management strategy, data inventories, data governance, data management, storage, and distribution alternatives in support of client MDM strategy.
• Currently working on migration of 2008 SSIS packages to 2012 SSIS packages.
• Created PL/SQL procedures, triggers, generated application data,
• Designed data models with industry standards up to 3rd NF (OLTP/ODS) and de normalized (OLAP) data marts with Star & Snow flake schemas.
• Designed and proposed a roadmap for enterprise data warehouse (EDW) with multiple BI data marts by subject areas, such as: Party, Legal Entity hierarchies, Security Master with market data, Product offerings and hierarchy, and Product Research.
• Created SQL Workflow Systems, using Python created an adapter allowing communication between Sharepoint lists and SSIS packages. This system provides users the ability to create complex automation workflows.
• Provided conceptual and technical modeling assistance to developers and DBA's using Erwin and Model Mart. Validated Data Models with IT team members and Clients.
• Worked on Amazon Web Services (AWS) including RDS and EC2.
• Created ad hoc reports to users in Tableau, a data mining tool which is used for data visualization by connecting various data sources.
• Mining various data sources and providing visualization and analysis of complex data structures.
• Designed and implemented Master Data Management (MDM) solutions. Designed the Enterprise Canonical Data model to maintain customer data in a central repository for use by different segments
• Analyzed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance.
• Created Teradata SQL scripts using OLAP functions like RANK () to improve the query performance while pulling the data from large tables.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Designed the MDM application to ensure that it meets global requirements.
• Wrote and created data load scripts or stored procedures for data mapping document.
• Assisted the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Used SQL joins, aggregate functions, analytical functions, group by, order by clauses and interacted with DBA and developers for query optimization and tuning.
• Implemented Python scripts to import/export JSON file, which contains the customer survey information and/or asset information, to/from the database.
• Introduced the Change Data Capture (CDC) Mechanics from the earlier version as 'Truncate and Load' in EDW environments for the newly added fact tables in EDW.
• Responsible for gathering metadata information and creating Data Dictionary report.
• Created naming standards for data attributes and metadata to track data source, load frequency, generated key values, and data dictionary.
• Integrated the requirement into the Warehouse environment through the completion of the Information Requirement Definition, Data Relational Diagram, Entity Relational Diagram, and Functional specification document, Business and Data Quality rules, Mart, Cube and Report specifications.

Data Modeler/Analyst

Confidential, Houston, TX

Responsibilities:

• Gather business requirements by conducting a series of meetings with business users.
• Create logical model from the conceptual convert into the physical database designs using Erwin.
• Worked on Basel, CCAR reporting and analysis for various requirements.
• Closely worked with Business Users and acted as the source for IT with the complete business knowledge of the Projects.
• Created, customized & shared interactive web dashboards using Tableau in minutes with simple drag & drop Expert in generating complex, dashboard reports, AdHoc, business views along with user acceptance test and data accuracy test.
• Prepared High-level logical data models and BRDs (business required documents) supporting the documents containing the essential business elements and the description between the entities.
• Worked on implementing data governance frame work, data lineage and data quality setup.
• Fulfilled the mapping document needed for different customers reports from the data source loaded thru. ETL-EDW process.
• Played an active role as a member of Project team to provide business data requirements analysis services, producing logical and Physical data models.
• Interacted with SSRS reporting team to gather reporting requirements, and review summary tables.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, managed the entire Tableau development lifecycle.
• Developed ETL code using Informatica Developer to bring data from different source systems and load into MDM staging tables.
• Map business needs/requirements to subject area model and logical enterprise model.
• Extensive experience in BI process using tools Cognos, Crystal Reports, BO, OBI, and SSRS.
• Involved with data analysis using Teradata SQL assist from data source.
• Extensive knowledge in Data loading using PL\SQL Scripts and SQL Server Integration Services.
• Worked with DBA's to create a best-fit physical data model from the logical data model.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Created Logical/Physical Data models in 3NF.
• De-normalized physical implementation data and information requirements analysis using Erwin.
• Analyzed and created business intelligence reports in both SSRS and MicroStrategy according to business requirements.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Prepared requirement documents, carried out couple of JAD sessions with data management, SME (Subject Matter Expertise), data vendors, and other stakeholders.
• Ensured production data being replicated into the ODS and the Data Warehouse without any data anomalies from the processing databases.
• Created Fact & Dimensions tables Erwin.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
• Designed, developed and implemented EDW data warehouse environment using Cognos data manager ETL tool to build full / daily refresh on data warehouse tables.
• Worked with MDM team in making changes to database to accommodate requirements and in capturing the demographic information from different applications by providing source application data dictionaries, identifying the demographic information and by providing DDL.
• Used Teradata Fast Load utility to load large volumes of data into empty Teradata tables in the Datamart for the Initial load.
• Created high-level ETL design documents and assisted ETL developers in the detail design.
• Conducted performance tuning of the database, which included creating indexes, collect stats optimizing SQL Statements & monitoring the servers.
• Assisted Reporting developers in building Reports using Crystal Reports.

Data Modeler/Analyst

Confidential, Atlanta, GA

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Worked on Basel, CCAR reporting and analysis for various requirements.
• Closely worked with Business Users and acted as the source for IT with the complete business knowledge of the Projects.
• Prepared High-level logical data models and BRDs (business required documents) supporting the documents containing the essential business elements and the description between the entities.
• Played an active role as a member of Project team to provide business data requirements analysis services, producing logical and Physical data models.
• Analyzed and created business intelligence reports in both SSRS and MicroStrategy according to business requirements.
• Designed the Data Marts using Ralf Kimball's Dimension data-mart modeling methodologies using ERWIN.
• Designed different type of STAR schemas using ERWIN with various Dimensions like time, services, customers and FACT tables.
• Worked with end users to collect business data quality rules and worked with the development team to establish technical data quality rules.
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Created Source to Target mappings and Transformations. Mapped data between Source and Targets.
• Widely used Normalization methods.
• Coordinated with DBA's and generated SQL code from the data models using.
• Worked closely with the ETL SQL Server Integration Services(SSIS) Developers to explain the Data Transformation.
• Supported UAT (User Acceptance Testing) by writing SQL queries.
• Created SQL tables with referential integrity and developed SQL queries using SQL Server and Toad.
• Performed extensive data analysis and data validation on Teradata.
• Worked with the Reporting Analyst and Reporting Development Team to understand Reporting requirements. Involved in Generating ad-hoc reports using crystal reports 9.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.
• Created and maintained Logical and Physical models for the data mart, which supports the Credit, Fraud and Risk Retail reporting for credit card portfolio.

Business/Data Analyst

Confidential, NY

Responsibilities:

• Reviewed functional requirements and use cases to determine the relevant data requirements.
• Assisted in creating realistic project plans with detailed tasks and ensuring their timely execution.
• Reversed engineered current system data model and subdivided it into work streams for analysis.
• Created process flows and data flow diagrams of the current and future systems.
• Performed dependency and gap analysis for data structure changes on other downstream applications and impact of new data elements on existing downstream processes.
• Created and maintained FSDM logical and physical data models for the financial platform and other in-house applications running on Oracle databases.
• Designed data movement strategies for data collection as well as the population of existing, new data stores and replicated environments.
• Worked closely with the Enterprise Data Architecture team, Database Services team and the project team on the creation of data models which can seamlessly integrate with existing data structures on multiple Oracle databases integrated by database links.
• Database design improvement documents.
• Database standards documents: Naming standards document, Data dictionary