| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSwathi Veldurthy Email Id: EMAIL AVAILABLE Phone:PHONE NUMBER AVAILABLEProfessional SummaryData Modeler/ Data Engineer with over 7years of successful experience in Data Modeling, Data Migration, Metadata Management, Change Management, Monitoring Control-M Jobs, Fact and Dimensions Tables, Physical and Logical Data Modeling. Recognized consistently for performance excellence and contributions to success in Telecommunications, Financial services insurance industries. Strengths in Data-warehousing and Big Data Environment backed by foundation in SQL.SKILLSErwin Data Modeler 9.64 SQL Server Management StudioSnowflake 3.52.2 AWS Cloud Platform EC2, S3Talend Solution Environment 7.1 JIRAOracle Database Oracle SQL DeveloperTOAD Data Modeler 5.2 Microsoft ExcelSQL SVNSharePoint TableauOracle Exadata DB Teradata SQL AssistantBig Data components: HiveQLHDFS, Hive, Sqoop, Yarn, Map Reduce, ScalaSpark, Hue, Apache GitService Now WinSCPMySQL, PL SQL EclipseVS Code NetBeansUnix Control-MESP (CA WA workstation) Teradata UtilitiesViewpoint Easy PlannerPutty UDEPLOYCockpit viewPROFESSIONAL EXPERIENCEEmployer: Nic InfoTek Inc May 2023 July 2024Sr Data Modeler/ Data Engineer/Application Support Engineer Sept 2021 May 2022Client: JP Morgan ChaseProjects:Travel Data Project, Application Support, Exit Exadata Project Migration of data from Oracle to Teradata.Analyzed business requirements and developed a comprehensive project plan.Data quality checks, Data Profiling, comparing model and prod DB scripts.Designed Conceptual, Logical, and Physical Data Models (CDM, LDM, PDM) using Erwin.Co-ordinated with different teams in the organization.Design Source to target Mapping document.Assist junior team members and co-ordinate with India teams.Utilized Erwin Model mart for version control and management of data models through check in, check out processes.Use reverse engineering, frwd engineering techniques with Erwin tool.Track project status using JIRA agile methodology.Monitored Control M jobs and took necessary action in case of any failures.Give Demo to the entire team and higher management including stake holders.Submit all the artifacts and get approved by the Data Review Board.Write and execute create table /view DDL scripts in Teradata DB, Snowflake DB.Work independently with clear communication skillsManage time efficiently focusing on deliverables to meet targets.Follow standards set by Data Governance team to define business definitions.Complete understanding of change management using ServiceNow.Worked on successful deployments in Dev, UAT and Prod environments.Proficient in designing and implementing JSON Erwin models to streamline data management processes and enhance system interoperability.Extensive experience using Control-M to manage and support applications across multiple lines of business (LOBs).Monitored and analyzed YARN and Control-M logs to diagnose and resolve job failures, ensuring smooth operations.Proactively collaborated with Application Development (AD) and System of Record (SOR) teams to address and resolve data issues, minimizing disruptions and improving data integrity.Supported a range of data jobs including Perm, Informatica, Abinitio, Hadoop, and AWS Cloud environments.Proficient with the DPL (Data Pipeline) framework, enabling efficient data processing and workflow management.Experienced in deploying scripts in both relational and cloud database environments, ensuring effective data handling and application functionality.Hands-on experience with Unix shell scripting and various programming languages, enhancing automation and system integration.Engaged in pair programming with application teams to review and implement change requests submitted through the Incident Management System.Demonstrated strong troubleshooting skills and effective communication, contributing to timely issue resolution and project success.SKILLS: Erwin Data Modeler 2021.R1, Jira 8.2, Oracle Exadata Database, Data Pipeline (DPL), Unix Shell Scripting, Teradata, AWS S3, Snowflake, SharePoint, ServiceNow, Control M, Troubleshooting, Incident Management.Employer: Nic InfoTek Inc Data Modeler/ Business Data Analyst Nov 2019 May 2020Client: First Tech Federal Credit Union (FTFCU)San Jose, CaliforniaProjects: Target: Snowflake DB running on AWS, Sources: AKC, OSI, Eloqua and Google360.Analyze Business requirements, procedures, and problems to come up with solution by interacting with Solution Designer. Provide quality documentation, status updates.Work as a Data Modeler in Agile Environment and update the existing system files and data models.Create conceptual, Logical, physical data models based on the requirements and functional documents using ERWIN tool.Create and maintain data architecture, data management conventions and standards, naming and metadata standards.Knowledge on Snowflake for writing SQL queries to design a star schema.Worked with snowflake DB running on AWS Cloud platform.Involve in defining source to target data mappings (STTM).Assist ETL developers while data loading to understand the STTM, handle UAT bugs by coordinating with business team.Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.Created and altered tables in target Snowflake dev environment and made sure they are deployed in prod environment after getting approval from UAT using ServiceNow changes.Sound RDBMS concepts and worked with Snowflake, Oracle, SQL Server Management Studio.Give Sprint Demo during Product team meetings, handle stake holder interactions.Work with Erwin to do reverse engineering of database for reporting purpose.Create tables, indexes, views, snap shots, database links extracted from SQL.Generate reports from data model. Review the data model with functional and technical team.Generate DDL for data model and co-ordinate with DBAs.Check to see data models and database are in sync. Assist developers, ETL team, BI team and end users to understand the data model.SKILLS: Erwin Data Modeler 9.64, SQL Server Management Studio 17, Snowflake 3.52.2, AWS Cloud Platform, Talend Solution Environment 7.1, Jira 8.2, Oracle Database, Oracle SQL Developer 18.2.0183, SharePoint.Employer: Nic InfoTek Inc Data Modeler/ Business Data Analyst March 2016 Aug 2019Client: AT&T Chicago, ILProjects: MAC, Time warner MergerHands on experience with end-to-end data modelling skills, source to target mapping techniques, data flow diagrams using EA Erwin Diagrams and Visio Diagram.Provide analytics and insights in support of the TV & Digital advertising businesses Xandr.Operations and support of BI enablement outputs (reports, visualization, data feeds) for Media & Advertising Sales and Operations Customers.Participate in Scrum calls as well as sprint planning sessions to support development efforts.Experience with industry leading Analytical, Data Processing and Business Intelligence tools and techniques for application in a Big Data environmentThe outputs and data sets are used for campaign planning & post-campaign reporting, which include campaign data, audience data and impression data across multiple data sources.Assist in the day-to-day management, routine maintenance and forecasting of the companys linear television viewership.Manage work as a liaison between technical teams and end user stake holders to provide successful solutions.Supporting the team through the execution of reports and analyses for the organizations various product offerings.Taking on special projects and ad-hoc SQL queries as needed.Work with SVN repository tool to check in the data models to review with team, build and deploy.Responsible for deployments and co-ordination using ServiceNow.Exposure to Data Maturity Model. Used JIRA to plan, monitor and track work.SKILLS: TOAD Data Modeler 5.2, Oracle 11g, CA Erwin Data Modeler 9.6, Microsoft Excel 2013, SQL, SVN.JIRAEmployer: JNIT Inc Software Engineer Jr. Nov 2014 Jan 2015Client: Charter CommunicationsSt. Louis, MOExperience in Data modeling.Designed, modified database objects such as tables, views user defined data types.Work experience of SQL related to Oracle using Oracle SQL Developer tool.DWH ETL mapping documentsSupport development teams on all misc. needs including creating scripts for Dimension tables, assigning key constraints by writing alter statements.Conduct/attend requirements definition meetings with end users and document system/business requirements.EDUCATIONM.S. Mechanical Engineering (Mechatronics) May 2014Indiana University Purdue University Indianapolis, Indianapolis, IN GPA 3.2/4B.S. Mechanical Engineering (Mechatronics) May 2012Jawaharlal Nehru Technological University, Hyderabad, India GPA 3.2/4 |
