Noonsavath Swami

I always want open and clear communication 11+ of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2016/2014/2012/2008 in Development, Test and Production Environments. In-depth knowledge of Database Management (RDBMS) concepts and expert knowledge of designing relational. Experience in ETL Tools like SSIS, Informatica PC , IICS , Azure Data Factory and other tools like Powerbi , sql , ssrs , ssas , azure databricks , python. Experience working with IICS concepts relating to Rest API ,data integration, Monitor, Administrator, deployments, permissions, schedules. Expertise in Informatica Power Center 10.2/10.1/9.5.1/9.0.1/8.6/7.1 extracting data from Oracle, SQL Server, Teradata, DB2 databases, Flat files, Web Services, API's, XML & Json files. Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, Union etc., Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions. Experience in Performance Tuning of sources, targets, mappings, transformations and sessions. Designed complex mappings to load into Snowflake & SQL. Expertise in SQL/PLSQL programming, developing & executing Packages, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views.Developing, Analysis, Implementation and post implementation support of DWBI applications. Extensive experience on Data Engineering field including Ingestion, Datalake, Datawarehouse, Reporting and Analytics. Strong knowledge and experience on Data Analysis, Data Lineage, Big Data pipelines, Data quality, Data Reconciliation, Data transformation rules, Data flow diagram including Data replication, Data integration and Data orchestration tools. Solid Experience and understanding of Implementing large scale Data warehousing Programs and E2E Data Integration Solutions on Snowflake Cloud, Informatica Intelligent Cloud Services (IICS - CDI) & Informatica PowerCenter integrated with multiple Relational databases (MySQL, Teradata, Oracle, Sybase, SQL server, DB2) Knowledge and experience on HIVE, azure databricks , event hub data , pyspark ,kafka. Hands on Experience on Python programming for data processing and to handle Data integration between On-prem and Cloud DB or Datawarehouse. Managed SQL Server instances, including installation, configuration, and maintenance, ensuring optimal performance and availability. Designed and implemented database schemas, tables, and indexes, optimizing for performance and scalability. Tuned SQL queries and optimized database performance, reducing query execution time and improving overall system efficiency. Implemented backup and recovery strategies, including full, differential, and transaction log backups, ensuring data integrity and disaster recovery readiness. Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, user-defined functions (UDFs), Common table expressions (CTEs). Experience in developing BI applications utilizing SQL server, BI stack, Power BI. Expertise in writing complex DAX functions in Power BI and Power Pivot. Have very good experience administering the Teradata database, Data Modelling and ETL. Cursors, relational database models, data dictionaries, and maintaining data integrity and indexes using T- SQL. A strong understanding of the SQL catalog is essential for effective database management. It involves knowing the structure and organization of the catalog, including tables, views, indexes, stored procedures, and other database objects. Involved in Creating and Updating database objects like tables, views, stored procedures, function, and packages. Worked on data extraction, data integration and loading from different data sources using SQL Server Integration Services (SSIS). Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end users to make filters. Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, Validation of data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS). Implemented Power BI gateway different source to match analysis criteria and further modeling for Power query and Power View. Created various SSRS Reports involving a variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill- Through, Multi-valued parameters, and also understanding of the Tablix control and Dashboard reporting, Share Point with Power View tool etc. Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. Extensive experience in leveraging Azure Data Factory (ADF) for designing, orchestrating, and automating cloud-based ETL solutions. Successfully integrated ADF with various Azure services, including Azure Storage, Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics, ensuring seamless data integration across the Azure ecosystem. Experience in both on-prem and cloud solutions. Extensive experience with Microsoft Azure ecosystem such as: Power BI Service, ADF2, Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL DW, Azure Blob, AKV Management. Also, hands-on Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files. Good Experience in working with APIs to access specific database features. Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages. Hands-on experience with Azure Data Factory V2, Data Flows, Snowflake, Azure Data Lake, Azure analysis services. Extensive experience in developing POWER BI reports, Power BI Dataflows,KPI Scorecards and dashboards from multiple data sources of BI (Online MPP, Azure Kusto, Web API, SharePoint Excel, SQL DB, SAP BW etc.) Worked on challenging scenarios, from which I learnt Power automate, Power apps, R-Script, using of Custom Connectors. Worked on On-Premises Gateway to refresh the data sources/creating a live connection with Tabular SSAS. Used various Default visuals (Table, Matrix, Bar, Pie, Card, Gauge, Slicer, Charts, Maps etc.) visualizations. Worked on Custom Visualizations like multi slicer, Timeline Storyteller, Infographic Designer, Scroller and Hierarchy slicer. Worked on AI Visuals like Decomposition Tree, Q & A and Key influencers, also on Python & R visuals. Worked on DAX expressions like Calculated Column and Measure, filters, Aggregate, Mathematical Functions etc. and used Connectivity modes (Import, Direct query & Live connections). Proficient in Data modeling (Transform operations like Pivot, Unpivot, Merge, append, Trim, Split, Transpose) and adding Custom, conditional, index column in query editor using M language too. Experience in Dimensional Modeling, Designing of STAR, SNOWFLAKE Schema’s and used composite model in Projects. Managed Team of 14+ members.

• Lean Six Sigma Green Belt Certified
• SEAL Certified(School Emerging Leader certification)