Mamatha D Email & Phone Number

United States

Cincinnati, Ohio, United States

Collaborated with data engineers and operation team to implement ETL process, wrote, and optimized SQL queries to perform data extraction to fit the analytical requirements.Worked with the ETL team to document the Transformation Rules for Data Migration from OLTP to Warehouse Environment for reporting purposes.Developed normalized Logical and Physical database models to design OLTP system for insurance applications.Performed SWOT and risk analysis to better understand the potential impact of the product towards the betterment of the company.Created data transformation task such as BULK INSERT to import data from client.Created dimensional model for reporting system by identifying required dimensions and facts using Erwin.Created configuration packages in SSIS to move the packages from development server to production server. Transferred data from Oracle database as well as MS Excel into SAS for analysis and used filters based on the analysis.Used parallel processing in SAS to aggregate programs to significantly reduce the execution time of the applications that fetch aggregated and partitioned data. Created and maintained reports to display the status and performance of deployed model and algorithm with Tableau.Data type inconsistencies between source systems and the target system were resolved using Mapping Documents. Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.Exported data to AWS S3 and recorded the processes of work progress.Performed data analysis, Data Migration, and data profiling using complex SQL on various source systems including Oracle and Teradata. Tested the database to check field size validation, check constraints, stored procedures, and verify field size defined within the app with Teradata.

Boston, Massachusetts, United States

Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users.Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder.Linked data lineage to data quality and business glossary work within the overall data governance program.Utilized Alteryx analytics software to process sophisticated cost models and SQL data conversionsGuided the development of ETL processes for dynamic, automated data migration and validation by using Alteryx.Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Oracle,SQL SERVER and Teradata).Upgraded the present application by adding new functionalities and adding new reports.Wrote regression test cases, did smoke testing with users.Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.Utilized AWS Redshift for data warehousing, enabling fast and efficient querying and data analysis.Created Report-Models for ad-hoc reporting and analysis.Created Logical/physical Data Model in Erwin and have worked on loading the tables in the Data Warehouse.Created ad-hoc reports to users in Tableau by connecting various data sources.

Chicago, Illinois, United States

Worked on data transformation and accessed raw marketing data in varied formats with different methods for analyzing and processing.Translated business needs into data analysis, business intelligence data sources and reporting solution for different types of Clients.Performed requirements gathering and analysis including data analysis, GAP analysis (AS-IS to TO-BE), and documentation for end users. Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.Worked with Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic. Converted the logical model to Physical Model by giving accurate data types, created indexes on keys and forward engineered the DDLGenerated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis. Used complex query statements like, sub queries, correlated queries, derived tables, case functions to insert the data depending.Converted and loaded data from Flat Files to temporary tables in Oracle database using SQL*Loader.Handled Management tools as Cloud Watch and Cloud Trail.Managed, updated, and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.Worked with internal architects and assisting in the development of current and target state data architectures.Worked with other Teams to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.Collaborate with data modelers, ETL developers in creating the Data Functional Design documents.

Hyderabad, Telangana, India

Extensively worked on various database impacts on CMS applications once the impacted changes were known in the project requirements review. Extensively worked with Model maintenance projects where all the Data models were not up to standards making them standardized Writing implementation plans to implement the database changes into the QA and Production environment. Coordinating with DBA in implementing the Database changes and updating Data Models with changes implemented in development, QA, and ProductionCreated a Data dictionary using ERWIN modeler.Designed a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.Involved in Low-level Design for the scripts of the database sequences, constraints, triggers, and stored procedures. Knowledge of Merging several flat files into one XML file.Extensively worked on creating, Altering, and Deleting the Tables in different Development Environments and Production.Confured and worked with nodes Hadoop cluster, Installed Cloudera, Apache Hadoop, Hive, Pig, and Spark, and commissioning & decommissioning of datanode, namenode recovery, and capacity. Installed and configured Apache Hadoop to test the maintenance of log files in the Hadoop cluster.Continuous monitoring and managing the Hadoop cluster through Cloudera Manager.Managing SQL and Hadoop cluster, adding and removing cluster nodes, cluster monitoring and troubleshooting, managing and reviewing data backups, managing and reviewing Hadoop log files and manual failover to check cluster functioning.Querying Spark code using Scala and Spark-SQL for faster testing and data processing.Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc..