Ishwarya V Email & Phone Number

Ontario, Canada

Ottawa, Ontario, Canada

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data. • As a key developer, delivered the best results to the developmental needs, accomplished successful outcomes by working with SQL, SSIS, Power BI, ADF2, SSAS, and other Azure tools.• Configured Azure platform for data pipelines, Azure Blob Storage, and data lakes. Build workflows to automate data flow using ADF• Recreated SSIS ETL architecture into more modern ELT (extract-load-transform) structure with ADF pipelines, like Copy Data and Data Flow activities.• Created SSIS packages to clean and load data to data warehouse.• Created SSIS Packages by using various Control Flow and Data Flow Tasks to execute SQL Task for each loop Container, Derived Column, and Data Conversion. • Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data into the tables from Text files, Excel files, CSV files and XML files. • Developed Power BI reports using query logic based on business rules, and visuals selected by united stakeholders. • Creating Power Pivot models and Power Pivot reports, publishing reports on SharePoint, and deploying models into SQL Server SSAS instance.• Designed various dashboards and score cards to support analysis utilizing Tableau desktop.• Deployed Tableau dashboards to Tableau Server and setup refresh schedules.• Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.• Merging and transforming data according to the requirements for ease of analysis in Excel by using Power Query in Power BI. • Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

India

• Migrated data from Heterogeneous Data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints. • Worked on Data Flow Transformations like Slowly Changing Dimension, Conditional Split, Data Conversion, Derived Column, Look-up & Script Component, Aggregate, Audit etc. • Created packages in SSIS with error handling and worked with different methods of logging in SSIS. • Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop). • Designed data model from the scratch to assist the team in data collection to be used for Tableau visuals. • Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports. • Creating new Documentation, DB Schema designing, creating new ERD's using Visio. • Proficient in creating, analyzing, and testing of OLAP cubes in SQL Server analysis services (SSAS) using MDX. • Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement. • Developed Query for generating drill down reports in SSRS. • Created Views and Synonym to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports. • Identified the Data Source and defining them to build the Data Source Views. • Experience in Backup and Restore databases by SQL Server Management Studio and writing T-SQL. • Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert scripts. • Generated Reports using Global Variables, Expressions and Functions for the reports. • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages. • Identified and worked with Parameters for parameterized reports in SSRS.

Hyderabad, Telangana, India

• Designed Dashboards with all kinds of charts (Gauges, Bar/Line charts, Maps, heat maps, Area charts). Designed ad-hoc reports, grouping and sorting using SSRS. • Involved in designing sub reports and linked reports depending on the user requirement and to limit the number of Data Sources.• SSRS reports to SharePoint Server for the end users to look at them.• Created SSIS packages to transfer data from various sources like Oracle 10g, Excel, flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment.• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.• Worked on creating calculated measures that fits business logic, using MDX queries.• Handling Initial and Delta loads and processing Cubes (Star Schema) across all environments.• Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS) involved in designing Data Marts.• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles.• Developed Windows User Controls using Win forms controls and custom controls using c#.• Configured application settings using the Configuration files.• Consumed and created XML Web Services.• Performed review of the business process, involved in requirements analysis, system design documents, flows, test plan preparations and development of business process and workflow charts.• Performed database design and implementation using SQL Server and data modeling tools.• Involved in various data transformation and cleaning techniques like cast, convert, trim etc.• Developed database objects like tables, views, indexes, stored procedures, common table expressions.• Involved in writing queries with join conditions, correlated sub queries, and nested queries for the business.

Master'S Degree, Electrical And Computer Engineering

Bachelor'S Degree