Saranya Mathi Email & Phone Number

Chapel Hill, Nc, Us

Nashville, Tn, Us

Currently working as a cross-functional developer supporting the business by providing data analysis, data mining, and creating business intelligence reports using Power BI.Analyze and synthesize data into actionable business insightsStrength in data visualization and UX design conveys meaning to the data you analyzeHands-on experience with visualization and data tools (e.g. Tableau, Alteryx) and applied knowledge of SQLA great believer in Agile practices and good practitioner agile methodologies.Strong knowledge in Business Intelligence tools, especially Microsoft Power BI.A passante data analysis with exposure in SSIS, Excel Macros to manupulate data for business reporting.

Bloomfield, Ct, Us

Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute-SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.Created tables, indexes, sequences, constraints, triggers & procedures. Used DDL & DML commands for writing triggers, stored procedures, and data manipulation.Designed stored procedures and triggers for automating tasks.Developed database objects such as Stored Procedures, CTE, Functions, Tables, Triggers and Indexes using T-SQL.Implemented Triggers for checking complex business conditions, providing security for the tables.Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.Designed ETL specification documents to load the data in target using various transformations according to the business requirements.• Performed testing, knowledge transfer and mentored other team members.

Calhoun, Georgia, Us

• Performed data scrubbing using Fuzzy lookup transformation before deploying to the data warehouse based on the project requirements. • Used various SSIS transformations such as Conditional Split, Merge Join, Data conversion, OLE DB Command, Derived Column on the data retrieved, performed Data Validation Checks during Staging, Used Data Flow task, execute package task, Execute SQL Task, in SSIS for transformation of data. • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various users using SQL mail agent• Used stored procedures, wrote new stored procedures and triggers, and modified existing ones. • Created sub-reports, drill down reports, parameterized reports, Drill-through, to get monthly client account details and profits using SSRS.

Us

• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute-SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.• Created tables, indexes, sequences, constraints, triggers & procedures. Used DDL & DML commands for writing triggers, stored procedures, and data manipulation