Vigneshuwari Nagasanthoshinee

Vigneshuwari Nagasanthoshinee

ETL/ DW || SQL-BI Developer

Suwanee, Georgia, United States.

About  

I am an ETL Developer with over 3 years of experience in Software Development Life Cycle (SDLC) within Design, Coding, Testing and Implementation of Data Warehousing/DataMart under Windows Environment. Extensive ETL experience with advanced knowledge in SSIS and excellent concepts in design and development of ETL Methodology for supporting data transformations and processing ETL Solutions.

Hours Available / Wk - 40 hrs

Portfolio 

0 Likes

Building Permits issued for the City of Miami

Being a developer can take a good amount of patience, but in Miami that virtue has long been put to ... ... More

Employment History 

  • ETL/DW|SQL|BI DEVELOPER

    COLABERRY INC
    March 2018 - Present

    *️⃣Created SSIS packages using various control flow and dataflow tasks to extract the data from multiple sources like Excel, XML, JSON and OLTP and consolidate them into staging tables.
    *️⃣Maintained SSIS packages for production and test environment for incoming source application files.
    *️⃣Implemented different Slowly Changing Dimension methodologies and
    Merge Statements to maintain and update data corresponding to
    Dimension tables in the Data warehouse.
    *️⃣Monitored SSIS packages validation, errors handling, optimization, and deployment.
    *️⃣Scheduling Jobs and Alerting using SQL Server Agent. Worked on Multidimensional Modelling Development using SSDT.
    *️⃣Designed, implemented, and maintained Database Schemas, Entity relationship diagrams, Data modeling, Tables, Store procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, and complex SQL statements.
    *️⃣SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
    *️⃣Create parameterized reports, drill down, and drill through reports using SSRS.
    *️⃣Held accountable for creating dashboards, Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirement using SSRS.
    *️⃣Troubleshoot data integrity issues, T-SQL code defects, SSIS and SSRS errors of varying complexity and address them as required.
    *️⃣Partner with Business Analysts and Developers on an assigned line of business project in the requirements definition and documentation of new customer reports/dashboards and oversee the maintenance and development of existing reports.
    *️⃣Served as a collaborative team member within both project management and software development life cycles (SDLC) including analysis of business functions, design, development, testing and documentation as required by end-users.