Post Job Free

Resume

Sign in

Data Sql Server

Location:
Franklin, TN
Posted:
February 17, 2020

Contact this candidate

Resume:

Dhana Laxmi

MSBI Developer

Email: adbtaz@r.postjobfree.com

Ph #: 615-***-****

PROFESSIONAL SUMMARY:

4+ years of experience in IT with Database applications and Business Intelligence Design & development, and Data Analysis in Production, Development, Testing and Staging Environments.

Expertise in MS SQL Server 2016/2014, MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis services (SSAS).

Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services(SSIS).

Experience in designing, developing, deploying and scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP and Emails Alerts.

Experience in providing Logging, Error handling by using Event Handler.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Skilled in developing SSAS Cubes, Dimensions, Facts and data source views, SSAS-Data Mining Models and Deploying, Processing SSAS objects, and Creating named calculations and named queries.

Good experience with SSRS through deploying reports, creating report schedules and subscriptions, managing and securing reports.

Skilled in SQL Server Reporting Services (SSRS 2014/2012) in generating complex reports in cascaded reports, parameterized reports and Ad-Hoc reports.

Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions (UDF’s), Cursors and Indexes using T-SQL.

Expertise in creating/modifying Tables, Views, Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), Joins, Indexes, Triggers and Cursors scripting in T-SQL.

Expertise in writing Sub-Queries and Joins to simplify complex queries involving multiple tables and established relationships between tables using Primary Key and Foreign Key Constraints.

Expertise in creating, scheduling, monitoring, maintaining old and new SQL jobs, using SQL Server Job Agent.

Expertise in defining the business process flow and gathering business requirements.

Experience working in Agile and Waterfall methodologies in SDLC

Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2016/2014.

Good team player and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Databases

MS SQL server 2016/2014/2012, My SQL

Programming Languages

SQL, PL/SQL

BI Tools

MSBI

ETL Tools

BIDS/SSDT, SSIS, SSAS, SSRS.

OLAP/Reporting Tools

MS SQL Server Reporting Services 2016/2014/2012, SSRS, MS Excel, Tableau, Power BI.

SQL Server Tools

SSMS, Query Analyzer, SQL server profiler, SQL Server Agent.

Data Modeling Tools

Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).

Other Tools

MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio

Operating Systems

Windows 10/8/7/XP/Vista, MS-DOS, UNIX, LINUX.

Web Development

HTML, XML, Microsoft.NET framework, Visual Studio.

PROFESSIONAL EXPERIENCE:

Client: DSW, Columbus, OH Oct 2018 – Till Date

Role: MSBI Developer

Responsibilities:

Met with business users, gathered business requirements and prepared the documentation for requirement analysis.

Provided training to the business users on how to use new data warehouse, browsing cubes from Excel and assisted them in rewriting their existing queries to point to the new warehouse.

Created centralized data warehouse (ODS) and developed de-normalized structures based on the requirements and to improve the query performance for end users.

Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.

Worked with SSAS tabular model (BISM) and created dashboards and reports using power view, power pivot and SSRS.

Used data quality services (DQS) to cleanse the data, remove duplicates and improve the quality. Created domains in DQS and exported the activity results into SQL tables.

Did debugging using break points and data viewers and performance tuning of ETL data flows.

Created various SSIS packages to populate the data from flat files, Excel and Access into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction based data).

Created and configured SSIS package configurations using sql server table and environment variables and loaded data from XML, Flat files and SQL Server incrementally.

Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS packages.

Knowledge on OLAP Cubes (Star Schema) using SQL Server 2014 Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.

Created calculated columns, KPIs and custom hierarchies to accommodate business requirements and partitioned the cubes to improve the performance and to decrease the processing time.

Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.

Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.

Designed SSAS tabular models and created dashboards and reports using power view and deployed them in Share point server.

Created and Designed a Multi-Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star schema) using SQL Server Analysis Services (SSAS).

Developed various types of reports drill down, drill through, matrix and sub reports using SSRS.

Created multiple dashboards with calculations and KPIs using Tableau 9.3/10 and deployed them in tableau server

Used team foundation server for version controlling of all BI projects.

Environment: SQL Server 2016, SSMS, SSIS, SSAS Tabular, SSRS, Power View, Power Pivot, MDX, Report Builder 4.0, Team Foundation Server, MS Visio, Outlook, T-SQL, Windows Server 2012, Windows.

Client: Tennova Healthcare, La Follette, TN Jan 2017 – Sep 2018

Role: MSBI Developer

Responsibilities:

Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.

Installed SQL Server 2014 and Management tools using SQL Server Setup Program and upgraded existing databases from SQL Server 2012.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to load the shipping and customer data.

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

Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).

Created custom logging and package configurations to change connection strings and variables dynamically. Used all types of containers in SSIS.

Created package deployment utility and deployed packages into various environments. Involved in unit testing, SIT, UAT and data validations.

Designed, processed and partitioned cubes using SSAS.

Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.

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

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server 2008 reporting services.

Created and maintained SSRS reports for External Reporting and Internal Activity Based Costing (ABC) for shipments tracking. Outstanding knowledge in creating drill down reports, Graphical reports, ad-hoc reports and drill through reports using the ROLAP/MOLAP as sources.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.

Worked in agile methodology, participated in daily scrum meetings.

Environment: Agile, SQL Server 2014, SSIS, SSAS, SSRS, Power BI, Share point, Oracle, MDX, MS Office 2007, ER Win, T-SQL, Windows Server 2008.

Client: Farmers and Merchant Bank, Adamsville, TN Sep 2015 – Dec 2016

Role: BI Developer

Responsibilities:

Actively participated in the meetings between Business Users and Technical team to gather and discuss the business requirements and convert them into technical/functional requirements.

Initiated to implement technological solutions in a cost-effective way by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators and partners.

Designed SSIS Packages to perform the extract, transfer, and load (ETL) operations with existing data into SQL Server through OLTP database from different data sources.

Worked with SSIS Data flow task, Transformations, For-loop containers and Fuzzy Lookups, Data conversion and configured data in slowly changing dimension.

Worked with team to Develop and Extend the OLAP Cubes, Dimensions and data source view.

Designed and implement Data Mart, Facts, Dimensions and OLAP Cubes using dimensional modeling standards in SQL Server 2012 that maintained data.

Worked in the complete Data Warehouse development life cycle and actively supported business users for change requests during the project development.

Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).

Worked with the team in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Developed several drill down and drill through reports using SSRS as needed by clients.

Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases to integrate the data as business requirements

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2014, SSIS, SSAS, SSRS, visual studio, Import/Export tools, SQL Server Agent, MS Access, T-SQL, ERWIN and Windows10.



Contact this candidate