Vani S

addlab@r.postjobfree.com

Mobile :984-***-****

PROFESSIONAL Summary:

Extensive experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2016/2014/2012/2008 with various business domains like Financial, Banking sector.

Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client-server-based applications.

Excellent T-SQL Development Skills to write Complex Queries involving Multiple Tables, great ability to Develop and Maintain Stored Procedures, Triggers, User Defined Functions, Views.

Experience in writing complex SQL queries involving Inner and Outer joins, Temp Tables, Global Temp Tables, Derived Columns.

Proven ability in Performance Tuning, Query Optimization Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Well versed with Tuning SQL Queries & Stored Procedures to improve performance

Extensive experience in T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data Warehousing.

Extensive experience in SQL Server Integration Services (SSIS) and Reporting Services (SSRS) and experience creating Drill-down and Drill-through Reports, writing Expressions in SSRS and Fine-tuning Reports.

Expert in creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular Reports, Matrix Reports, Charts, Graphs, and Sub-reports using SSRS in Business Intelligence Development Studio (BIDS)/Data Tools.

Experience in Creation, Configuration, Development, and Deployment on various servers of Reports using SSRS

Expertise in Extract Transform and Load (ETL) using SQL Server Integration Services (SSIS) Packages for integrating data using OLEDB connection from varied sources by using multiple transformations including Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.

Experience in Dimensional Data Modeling and Cube Development, Designing of STAR, SNOWFLAKE Schemas, Partition, Aggregation and Optimization using SSAS.

Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014) and Excel Pivot.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal Skills.

Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.

Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.

Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014/2016, calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions.

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.

Technical skills:

Databases Tools

Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service and SQL Server Management Studio

ETL Tools

DTS Data Transformation Services Export/Import and SQL Server Integration Service (SSIS)

Reporting Tools

Power BI, SQL Server Reporting Service (SSRS), Crystal Report and Tableau

Database

SQL Server 2016 /2014/2012 R2/2008 R2/2008/2005/2000, MS Access, ORACLE 10g/11g and My SQL

Web Technologies

HTML, DHTML, XML, XSL, Java Script and CSS

Operating Systems

Windows Server 2016 /2012 /2008/2003/2000/XP and Unix.

Other Tools

MS WORD, MS EXCEL, MS VISIO and MS Power Point, SVN and GitHub

Professional Project Profile:

First Command Financial Planning, Inc, Dallas, TX Jan 2020 to Present

Role: SQL/SSIS Developer

Responsibilities:

Created/maintain technical documentation for core system processes, break fix manuals, maintenance playbooks and runbooks

Worked in Agile environment sprints

Responsible to migrate all informatica ETL packages to SSIS

Responsible to create inventory mapping documents from Informatica to SSIS

Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle etc.) and then loaded the data into destination tables by performing various kinds of transformations using SSIS packages.

Implemented SSIS packages utilizing checkpoint, logging, breakpoint, and transaction options.

Deployed SSIS packages to multiple environments with the project deployment model.

Expert in Data Extraction, Transforming and Loading ETL using various tools such as SQL Server Integration Services SSIS

Formulated a multitude of reports and dashboards with SSRS and Power BI.

Developed user interactive Power BI reports utilizing charts, maps, matrices, slicers, tiles, gauges, and funnel.

Designed and developed data load jobs using SSIS package and scheduled in SQL Agent

Used various SSIS tasks such as Conditional Split, lookup, Derived Column, which were used for Data conversion, data validation check during Staging, before loading the data into the target database

Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).

Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).

Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.

Performance tuning of Stored Procedures and T-SQL Queries.

Worked with different methods of logging in SSIS.

creating complex SSIS DB packages using proper control and data flow elements.

Responsible for Troubleshoot SSIS packages to address critical production issues

Optimized data warehouse performance by dealing with any data conflicts that arise and keep data definitions up to date

Responsible for daily load procedures using SSIS, T-SQL, and SQL Agent jobs

Manage source code versioning and deployments using SVN and git

Deploying, configuring, and integrating GIT with SSIS packages

Responsible for Create git hub branches and merge the code for SSIS packages

Identify problem trends and corrective actions and documenting these through modification of existing best practices guidelines

Conducts unit testing and debugging along with system and integration testing

Environment: MS SQL Server 2017/ 2016, Informatica, PowerBI, SQL Server Management Studio, SSIS, SSRS, Oracle 11g, T-SQL, HTML, MS-Access, SQL Server Query Analyzer, Power Query, ETL, Azure, ODBC,SQL Source Control,Agile, SVN,Github

JM Family Enterprises Inc, Deerfield Beach, FL June 2016 to Dec 2019

Role: SQL/Power BI Developer

Responsibilities:

Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.

Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions.

Designed the Data warehouse and done the mappings from Source to the Target tables.

Worked extensively on SSIS packages to implement the data load strategy.

Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Proven Power BI development experience with desktop and Pro versions. Familiarity with Direct Query functionality within Power BI.

Worked on creating dynamic parameterized Power BI reports to filter the Data from One report To the Other.

Development of Microsoft Power BI dashboards and dashboard templates.

Provide analytical, complex and specialized client service analysis using PowerBI dashboards.

Experienced developing and supporting Microsoft BI and reporting capabilities (PowerPivot, PowerBI, Power View, SQL Server Reporting Services) Experience implementing enterprise software solutions.

Utilized power query in BI to pivot and un-pivot the data model for data cleansing.

Created U-SQL scripts to migrate data from SQL server to Azure Data Lake.

Involved in designing new Modern Enterprise Data Warehouse Architecture using Azure platform and used Azure Analysis Services as Ad-hoc reporting Solution and Data visualizations through Power Bi on-Premises Report Server as well as Power Bi Cloud Services.

Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.

Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.

Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.

Created Reports and Dashboards using Power BI Desktop.

Created dynamic data visualizations in Power BI and integrated custom visuals based on business requirements using Power BI.

Embedded Power BI reports on Salesforce portal page and managed access of reports and data for individual roles using user Roles.

Identified the dimension, fact tables and designed the Data-Mart using Star schema.

Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.

Worked with SQL queries using MS Access for data manipulations.

Wrote T-SQL queries, Stored Procedures and used them to build packages.

Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.

Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012.

Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.

Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly.

Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.

Created and Maintained various database in MS Access to track activities and progress.

Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.

Optimized the queries by creating various clustered, non-clustered indexes and indexed views.

Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution.

Involved in testing, bug fixing and documenting the work for the project at each phase.

Environment: MS SQL Server 2017/ 2016/ 2012/2008/R2, DTS, PowerBI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), Oracle 11g, T-SQL, HTML, MS-Access, SQL Server Query Analyzer, Power Query, ETL, Azure Data Lake, ODBC, Erwin, Red Gate SQL Source Control,SVN,Github

Frosty Acres Brands, Atlanta, GA Aug 2015 to May 2016

Role: MS SQL Server SSRS /SSIS/SSAS Developer

Responsibilities:

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Successfully migrated data from CRM Saratoga to Pivotal component using SSIS.

Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2012 using SSIS.

Created and when required, modified already existing stored procedures, triggers, views, indexes.

Designed and created views for security purposes, implemented rules, defaults, and user defined data types.

Used MS Power BI for creating various data visualizations charts, dashboards, KPI and reports.

Involved in designing and implementing Change Data Capture techniques like Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2) simple pass through mapping.

Used Advanced Power BI Functionalities like Ranking Running Totals, Creating Parameters and using in calculations and formuals.

Designed and Developed simple to complex level Power BI Dashboards for meeting visualization needs of business users.

Created data integration and technical solutions for azure data lake analytics, Azure data lake.

Implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.

Worked on publishing and maintaining Power BI dashboards and Database connections on Power BI Server.

Worked in Power Query for data cleansing in Power BI desktop query editor.

Involved in loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Created SSIS packages to retrieve data from Legacy sources, retrieve user data from the Flat files on monthly and weekly basis, File Transfer from one location to the other using FTP task.

Used Kimball methodology to create data warehouse using SSIS.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008 R2.

Environment: MS SQL Server 2008R2/2012, SQL server Reporting Services 2008R2, SSIS, SSAS, PL/SQL, VSS, Microsoft Visual Studio, Power Query, SQL Server Management Studio, ODBC, Azure Data Lake, HTML, MS Excel, T-SQL, TFS, CRM Saratoga and Pivotal.

Alden State Bank, Alden, NY Jan 2015 to Jul 2015

Role: SQL BI Developer (T-Sql/SSRS/SSIS)

Responsibilities:

Developed data models based on the BA’s and the reporting Team using SSAS, SSRS.

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase).

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Experience in creating complex SSIS packages using proper control and data flow elements.

Building UAT and Test environments using Production backups.

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

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.

Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.

Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services (SSRS).

Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008 via SQL Server Integrated Services.

Querying and manipulating multidimensional cube data through MDX Scripting.

Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Wrote store procedures to generate account statements for different types of accounts.

Involved in migration of SSRS from SQL 2005 to SQL 2008.

Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 R2/2012 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, ODBC, MS Access, HTML, Oracle 9i, Sybase.

Sabre Inc., Southlake, TX Feb 2013 to Dec 2014

Role: MS SSRS/SQL BI DEVELOPER

Responsibilities:

Worked extensively on installation, upgrade and configuration of MS SQL Server 2005/2008 databases servers.

Excellent report creation skills using Microsoft Reporting Services (SSRS).

Worked with business/functional analysts to determine reports and analytical requirements.

Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.

Created SSIS packages to transfer data from different data sources load it to data warehouse.

Documented Report Models and Report Templates for other Team Members.

Created Prototypes of some complex reports and validated from the production.

Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team.

Categorized reports into batch reports and on demand reports and scheduled it according to that.

Configured and maintained Report Manager and Report Server for SSRS.

Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

Generated ad-hoc reports using MS Reporting services and Crystal reports.

Hands on experience with working on Microsoft dynamics and created reports based on the customer requirements.

Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.

Worked on SSIS script task, look up transformations and data flow tasks using T- SQL.

Experienced in loading data from the legacy systems into MS SQL server 2005 using SSIS packages.

Worked on Team Foundation Server (TFS) to maintain the web application portal for reporting services.

Created user variables, property expressions, script task in SSIS.

Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.

Business Objects: Responsible for Coordinating with Application Developers in the integration and utilization of Crystal Tools in the development of applications.

Environment: SQL Server 2005/2000, Business Intelligence Tool 2005, Visual Studio 2003, HTML, DTS/SSIS, T-SQL, Unix, Shell scripts, Oracle 10g.

Contact this candidate