Post Job Free

Resume

Sign in

Property Preservation Data Scientist

Location:
Little Elm, TX
Salary:
130000
Posted:
January 11, 2022

Contact this candidate

Resume:

DEVI BALASUNDARAM

410-***-****

adpvy4@r.postjobfree.com

Profile Summary

Senior Business Intelligence Engineer with around 12+ years of experience in IT industry, proficient in providing Data Modeling, Data and Information Architecture solutions. A highly qualified Business Intelligence Engineer/Data Engineer combining a passionate commitment to delivering service excellence in Information Technology. Possess extensive knowledge of implementing business intelligence applications, utilizing the most contemporary data analysis tools within multiple industries, including financial, insurance, and healthcare. Leverages outstanding communication, interpersonal, and negotiation skills to assist in the achievement of business goals and objectives. Meticulous and detail-oriented with proven ability to accomplish tasks under minimal supervision and quickly grasp new technologies and best practices.

PROFESSIONAL HIGHLIGHTS

Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.

Proficiency in creating various types of Parameterized Reports such as Crosstab, Drill-down, Drill-Through, Summary, Graph, Chart, and formatting those using Tableau and Power BI.

Develop batch processing solutions by using Data Factory, Data Lake, Spark, Azure Synapse Pipelines, PolyBase, and Azure Databricks

Develop a stream processing solution by using Stream Analytics, Azure Databricks, and Azure Event Hubs

Implement logging used by Azure Monitor

Design metastores in Azure Synapse Analytics and Azure Databricks

Implement different table geometries with Azure Synapse Analytics pools

Design a folder structure that represents the levels of data transformation

Created complex stored procedures used for generating reports in SQL Server Reporting Services (SSRS)

Developed interactive dashboards using Tableau and SQL tools to provide on-demand reporting, powerful visualizations, and insights to business users

Experienced in designing and developing Tableau Reports, Documents, and Dashboards as per specified requirements and timelines and presenting them in a variety of formats to users

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers to be used in production

Defined constraints, indexes, views, and triggers to enforce data and referential integrity based on architect requirements. Used Execution Plan, SQL Profiler, and database engine tuning advisor to optimize queries and enhance the performance of databases

Strong experience in gathering and analysis of requirements

Work with Business partners to recommend data management best practices

Good knowledge in Performance tuning, SQL Tuning, Data optimization, query optimization, job scheduling

Created/Updated database objects like tables, views, stored procedures, function.

Education

Bachelors Degree in Electronics and Communication Engineering Amrita Institute of Technology, India.

Certification Awards / Recognitions

Microsoft Certified Azure Data Engineer Associate

Microsoft Certified Azure Data Scientist Associate

Microsoft Certified Azure Fundamentals

Tableau Desktop Specialist.

SAS Base Programmer for SAS 9.

Technical Skills

Azure Tools: DataBricks, Data Factory, Apache Spark, Azure Synapse, Data Lake Storage, Azure Stream Analytics,Azure Machine Learning

Reporting Tools: Tableau,Power BI,Cognos

Cloud : Azure

Database & Tools: Oracle 11g,PL/SQL, MS SQL Server 2008,SAS,Informix, DB2,SQL Server, Oracle 11g.

Languages: Python,SQL,C,C++,Perl, Informix 4GL,ESQL C, Keil C,TAT, Unix Shell scripts

Other Tool : VB 6.0, Powerbuilder 5.0, Lombardi Teamworks 6.0,Power System, JTag, CVS, Clearcase, WorkShare, Sharepoint 2010,TOAD.

Operating System: Unix, BREW, Linux,Windows.

Management Tools : Azure DevOps.

Version control Tools: Clearcase

TRAININGS

Azure Data Engineering

Azure Data Scientist

Databricks and Apache Spark

Python

NoSQL Database

Pursuing Azure Solution Architect

Work Experience

Augur IT Inc., Coppell TX May 2021 – Till Date

Sr. Business Intelligence Engineer /Data Engineer

Responsibilities

Instrumental in gathering, analyzing, and designing business requirements and needs

Creating new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production

Creating various ad-hoc SQL queries for customer reports

Designing and developing ETL workflows and datasets in Azure to be used in-reporting.

Proficiency in creating pipeline jobs, scheduling triggers, Mapping data flows using Azure Data Factory and using Key Vaults to store credentials

Worked on migration of data from on-prem SQL server to Cloud databases using Azure Synapse Analytics and Azure SQL DB.

Worked with Azure Blob and Data Lake storage and loading data into Azure SQL Synapse Analytics.

Proficiency in creating various types of Parameterized Reports such as Crosstab, Drill-down, Drill-Through, Summary, Graph, Chart, and formatting those using SSRS

Designed SSIS ETL packages to load data into the target database after performing data validation and error handling using execute SQL task, derived column, data conversion and conditional split transformations.

Develop an automated pipeline for the Data Scientist to be able to train, test and deploy their models.

Knowledge in creating Power BI Dashboards using maps, line charts, cards, ribbon charts, scatter plots and different reporting layouts from the Power BI Marketplace

Requirement gathering from Clients. Translated clients’ needs into useable mapping and coding instructions and created functional requirements documents and mockups for reporting.

Manage, Create, and assign work items to team members for Sprint using Azure DevOps.

Tableau dashboard creation and implementation using filters, parameters, and calculated datasets.

Validation and testing of Tableau dashboards created by team members, ensuring the dashboards are in line with the client requirement.

Dashboard migration into Tableau Server, user level access maintenance and Job schedule for refresh extracts.

Mr Cooper., Irving TX July 2013 – May 2018

Senior Reporting Analyst

Responsibilities

Instrumental in gathering, analyzing, and designing business requirements and needs

Highly involved in the platform migration of the servicing system, thus analyzing the system change and the corresponding data migration.

Worked in an Agile Environment and involved in daily Scrum calls.

Involved in cash flow model, Securitization, Reporting layer implementation, develop, implement, and automate Reports requested by business user and modify existing reports to meet user’s changing needs.

Involved in REO and Property Preservation business process, created a cash inflow outflow model, and also involved in State wise performance thus reducing losses and improving business.

Interact with the business users on a day-to- day basis and assist the client during the user acceptance testing phase.

Implementation of existing reports in COGNOS environment

Involved in the conversion of existing reports in SAS programming to SQL Server 2008.

Created Dashboard across the various departments of Reverse Mortgage.

Implementation of reports in Power BI

Providing support to the customers in accessing the reports, and in meeting the business requirement on using the tools Microsoft Excel and Microsoft Access 2010.

Working on various stages from project development to project release and simultaneously testing the project on Development Server, Staging Server, and Production Server.

Risk management – Identify risks and communicate proactively.

Trained and acted as a mentor for new developers.

7-Eleven, Dallas, Texas Dec 2012 – July 2013

Sr. Associate

Responsibilities

Handled the staff augmented project individually and have been working closely with Stakeholders, WorkShare and Sharepoint teams, Testing team and 7-11 SEIs.

Organized and have led Project management meetings with Stakeholder, 7-11 Managers, QA Managers and Infrastructure team to ensure the project milestones are met.

Have led regular meetings with WorkShare and Sharepoint team regarding the ticket updates, migration of documents from Tsunami to Sharepoint. Legal AD Group creation, Permission and Access requests.

Actively involved in WorkShare testing, technical and understanding document, defects registration and creation of training plan for the legal document. Involved in the upgradation of the systems and coordinating with the Legal team regarding the performance of the Legal SharePoint Stabilization.

Understand the Client’s existing security policy & governance and provide the users with appropriate access to the SharePoint Sites.

Coordinating with offshore team daily and delegating work that can be carried out at their business hours and explaining the user requirement clearly and precisely to the team and get the deliverables timely and with Quality.

Prepare the documentation related to Software Requirements Specifications, Design & Technical Specifications, and Test Plans and get it reviewed from Project Manager and Client and help getting Sign-Off.

Involved in executing Proof of Concepts, Research & Analysis for any new development initiatives in the engagement.

Walmart Inc., Bentonville Arkansas Sept 2012 – Dec 2012

Programmer Analyst

Responsibilities

Involved in the analysis of requirement of the project, preparations of the technical design documents, coding, and implementation of program units in Linux.

Involved in the review of codes developed to ensure that the QA standards are met, and review of the unit test cases for the particular delivery.

Involved in the creation of Request for Proposal, various deliverable documents, and project plan tasks.

Involved in identifying the areas that are prone to risk and performed the programming process in a manner to restrict code and functionality break.

Did regressive testing and all the code versions were maintained using the Team forge tool.

Walmart Inc., Chennai, India Nov 2009 – Sept 2012

SQL Developer

Responsibilities

Worked as Technical Offshore Team Lead and was responsible for the support and maintenance of 17 financial standalone applications of Wal-Mart.

Actively involved in the resolution of production issues related to Payment, Application Down/Slowness issues, Job abend, Data transaction.

Involved in the automation of several reports which saved 40 hours of manual efforts per month.

Business documentation of issues were created to educate the customers on critical issues that can be handled at their end was done to reduce manual effort.

Involved in the automation of data rollout when the data transfer to the financial system has failed.

Involved in the training of offshore and onsite teams in the areas of business, programming languages and communication.

Motorola, Chennai, India March 2009 – Nov 2009

Programmer Analyst

Responsibilities

Involved in Requirement analysis, High level design development, Unit Testing, Environment Setup, Build and Release.

Involved in the messaging application screen development, image processing, and transmission of messages in packets. Was responsible for the technical design documentation for all the modules involved.

Involved in the Coordination with onsite and handled the offshore in Messaging/UI team for the five different mobile models.

Involved in screen generation using BREW, Feature Implementation, Debugging, Code Optimization, Unit Testing and Bug fixing.

Involved in Change Control Meeting for any changes. Experience in Incident Management, Change Management, and Problem management using Service Now Tool/Remedy.

Experience in using Microsoft Project Plan 2007 in designing the project plan, budget the effort in person hours and identify and allocate resources.

Toshiba, Chennai, India August 2006 – Feb 2009

Programmer Analyst

Responsibilities

Involved in the technical translation of the requirements in Japanese to English.

Involved in Requirement analysis, High level design development, Unit Testing, Environment Setup, Build and Release.

Involved in rectification of errors generated due to the translation tools by coordinating with the business and technical teams.

Responsible for maintenance of code using CVS repository.

Involved in the development of macros using VB for generation of reports. Involved in the regression testing on the products under development.

Involved in the creation of Blueprint on the architecture of the DGT/HIS module

Immigration Status

US Permanent Resident (Green Card)

Contact Details

Name : Devi Venkatalakshmi Podanur Balasundaram

Cell: 410-***-****

E-Mail * : adpvy4@r.postjobfree.com

Linkedin : HTTPS://WWW.LINKEDIN.COM/IN/DEVI-BALASUNDARAM-78A8A3114/

Gold award – 2018

Silver award– 2017



Contact this candidate