priyanka dawani

o Developed SSIS ETL packages using BIML scripts. o Created SQL tables using BIMLScript. o Defining the Data flow and Control flow using BIML. o Working on developing standard Smart connectivity interface using SQL and SSIS 2012, 2014 version. o Designed and implemented dashboards in tableau desktop

Database designing and ETL development with SQL queries & packages performance optimisations are the main responsibilities. Worked on database oriented applications in Microsoft SQL Server environment for data modelling (logical, conceptual & physical) with star & snowflake schema in Microsoft SQL Server versions 2012 Working with project owners and stack holders to implement the database oriented solutions for the business intelligence projects. Design and Developed Dashboard in Celonis Framework

o Provided 2nd level of support in SAP CRM7 inbox to resolve complex issues. o Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc. o Coordinating and tracking all projects for seamless releases using Project Management System JIRA, Source Code Management System SVN and Document Management System SharePoint.

• Designed database, tables and views structure for the application • Designing and developing Extraction, transformation and loading (ETL) processes using Microsoft standard tools to automate the collection of data from multiple source systems. • Work closely with business users and management to analyze, define and document technical requirements for client’s data need.

• Creating, monitoring and analyzing the Integration Services package executions, involved in managing and automating control flow, data flow, events and logging. • Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP. • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

 Experience in Database Design, Development and maintenance of database applications on SQL Server 2008 R2 in OLTP/OLAP/BI environment.  Experience in Logical modelling using the Dimensional Modelling techniques such as Star Schema and Snow Flake Schema.  Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.