Manaswini Devi

+1-512-***-****

ad4eff@r.postjobfree.com

Professional Summary:

8+ years of wide-ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting.

Strong experience with T-SQL (DDL & DML) in implementing and developing stored procedures, triggers, nested queries, joins, cursors, views, user defined functions, indexes, user profiles, relational database models.

Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.

Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.

Performance tuning of SQL queries and stored procedures using Index Tuning Wizard

Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).

Extracted data from multiple tables with joins, sub-queries, set operators.

Manipulated control flow functions such as data flow task, bulk insert task, script task, FTP task, and execute SQL task.

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, Validating 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).

Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.

Experience in debugging the SSIS packages using breakpoints and checkpoints.

Utilized multi-dimensional expressions (MDX) to customize KPI’s and calculated measures.

Created dashboards with Power BI to improve analyses and decisions.

Created row filters to secure data utilizing DAX in Power BI Desktop.

Technical Skills:

Server Operating System

Windows 2008, 2012.

Langages

C, Pl/SQL, T-SQL

Web Technologies

HTML, CSS, XML

Data bases

MS SQL Server 2016, Oracle 10g

BI Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL, Power BI, Power Pivot, Tableau.

Development Tools

Visual Studio 2015 Community Edition

Database Query Tools

SQL Server Management Studio (SSMS),Visual Studio 2015, SQL Profiler, SSDT

Power BI Developer

Client: Federal Home Loan Bank of Chicago

Sep ’21 - present

Responsibilities:

Experience in database programming in writing T-SQL Stored Procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.

Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.

Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.

Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.

Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.

Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server 2012

Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models.

Create reports in Power BI preview portal utilizing the SSAS Tabular.

Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull data into Power BI such as SQL Server, SSAS Cube.

Published Power BI Reports in the required originations and made Power BI Dashboards available in web clients.

Involved in creating data visualizations like Clustered Column Chart, Line Chart, Slicer, Gauge Visualization etc. with Power BI.

Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.

Developing visual reports, dashboards and KPI scorecards using Power BI desktop

Designed reports, graphs, charts to improve data clarity and analysis.

Developed reports and dashboard with Power BI.

Created dashboards with Power BI to improve analyses and decisions.

Created row filters to secure data utilizing DAX in Power BI Desktop.

Environment: MS SQL Server 2016, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS,Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, MS Excel.

SQL Developer

Client: State Board of Administration, Florida Aug ’16 to July ‘21

Responsibilities:

Participated in developing Logical design of database incorporating business logic and user requirement and building entity relationship (ER) diagrams.

Created Database Objects like Tables, Stored Procedures, Functions, Views, Constraints and user defined data types.

Identified relationships between tables, enforced referential integrity using foreign key constraints. Used Views, Triggers and Stored Procedures for updating and cleaning the existing data and the new data,

Written Stored Procedures and functions as per business requirement.

Created T- SQL objects & scripts used to maintain data integrity across all databases throughout database servers.

Defined Check constraints, Business Rules, Indexes and Views and wrote SQL procedures with optimized complex queries to extract data.

Assisted with any database related issues in software products.

Participated in system specification meetings, analyzed user requirements, coordinated with coders and team members.

Managing historical data from various heterogeneous data sources.

Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Environment: MS SQL Server 2016, Excel (pivot tables), SSIS, SSAS, SSRS, T-SQL, Visual studio 2012, MS Access.

Contact this candidate