Sql Developer Olap

Banashree Dash

Email ID: **************@*****.***

Phone No: 940-***-****

PROFESSIONAL SUMMARY:

Having 5+ years of experience as MS-SQL Server Developer, involved in Design, Development and Support of MS SQL Server 2012/2014/2016/2017.

Experience in full phase of SDLC and Methodologies like Agile, Waterfall including Analysis, Design, Development, Testing and Implementation of client-server based applications.

Expert in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2014/2016/2017 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS).

Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL

Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all etc...

Well experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.

Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.

Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2014/2016/2017 across various environments.

Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2014/2016/2017) and Excel Pivot

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.

Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized (Cascading parameters), OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2014/2016/2017.

Extensive experience in SQLServer Analysis Services OLAP Cubes and Data Mining.

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.

Excellent skills in relationship management with clients and effective in guiding team during the project development life cycle and deliver the product within time line, cost and quality.

Strong communication, planning and problem-solving skills, with ability to work independently or with cross-functional teams.

TECHNICAL SUMMARY:

BI Tools

SSIS, SSAS, SSRS, Power BI, Business Intelligence Development Studio (BIDS), Visual Studio

Languages

T-SQL, PL/SQL, C/C++, HTML, XML, VBScript, C#.Net, VB.Net, ASP.Net, ADO.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

Application package

MS Office Suite, Visio

Tools

SQL Server Enterprise Manager, Management Studio

Protocol

FTP, TCP/IP, Named Pipes

Databases

SQL Server 2005/2008/2012/2014/2016/2017, Access, MySQL, Oracle

Operating Systems

Windows Server (All Variants), Red Hat Linux, Mac

PROFESSIONAL EXPERIENCE:

Client: PerfectServe Inc., Knoxville, TN Jun 2020 – PRESENT

Role: SQL Developer

Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle DB2, and SQL Server).

Extract and Transform data into Staging Database and load data into data warehouse to create fact table and dimension table

Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.

Used try-catch block to handle the errors and to store all the errors in a table to handle them later and to continue the flow of execution.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.

Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS).

Created and modified various complex Stored Procedures used in the application using T-SQL.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Wrote complex Expressions for SSRS with Conditional Formatting.

Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Tuned SQL query for better performance using SQL Profiler. Documented all work, so user can easily understand the flow of process.

Environment: Microsoft SQL Server 2016/2017, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, BIDS 2014/2016, MS Visio, Oracle, MS Excel, Windows Server.

Client: Colonial Penn, Philadelphia, PA Oct 2018 – May 2020

Role: SQL Developer

Responsibilities:

Participated in requirement gathering, cube design, application design and SSAS development.

Constructed cubes based on data volumes mostly adhering to Star Schema.

Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.

Implemented SQL Server OLAP services (SSAS) for building the data cubes.

Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data.

Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.

Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Designed and implemented fact, dimensions and SSAS cubes using dimensional data modeling standards in SQL server 2014/2016 Business intelligence development studio.

Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.

Created and designed SSAS cube and promoted to production using XMLA scripts.

Designed and implemented parameterized, drill-through, drill-down, and tabular reports on SSRS using SSAS cube for performance point.

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.

Created and scheduled SSIS package to nightly process the SSAS cube based on oracle data mart tables updates.

Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.

Implemented/Developed multi parameterized reports in Report Builder and SSRS using SSAS cube allowing users to make selections before executing the reports and making it more users friendly.

Worked with SQL profiler to improve and enhance the MDX query execution time as a part of performance tuning process.

Wrote several complex stored procedures for efficient handling of the application.

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

Involved in the designing, development, modification and enhancing the database structures and database objects.

Environments: SQL Server 2014/2016 R2, T-SQL, SSRS, SSAS, SSIS, MS Visio, performance point services, Power Pivot, Report Builder, Excel, Windows.

Client: Fannie Mae, Reston, VA Sep 2016 – Sep 2018

Role: SQL Developer

Responsibilities:

Extensive experience in Analysis, Design, Development and support of various applications using SQL Server 2012.

Create ETL packages to move data from feed files (XML, CSV and TXT) to database.

Create packages to migrate data from oracle to SQL Server 2012.

Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.

Proficient in Creating, Configuring ETL workflows designed in MS SQL Server Integration Services (SSIS).

Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL Server.

Maintaining the Log and Audit information in SQL tables, experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages

Used Agile SDLC approach to complete and track tasks on time.

Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.

Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce flat files at runtime.

Migrated data to transfer database objects among servers using different SSIS packages in Business Intelligence Development Studio (BIDS).

Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Sorting the data, defining data source and subtotals for the respective reports using SSRS.

Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports. Generated different reports such as parameterized reports, drill through reports, matrix reports, linked reports in SSRS.

Deployed reports on report manager and created different report models for the users to generate and customize ad-hoc reports.

Defined granularity within a measure group and drill through actions using SSRS.

Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Worked on with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.

Involved in designing and implementing Parameterized Reports for generating Ad-Hoc SSRS reports as per the client requirements.

Environment: T-SQL, Query Analyzer, SQL Server 2012 Enterprise Edition, SSIS, SSRS, C#, MS Access, Visual Studio, Windows, Windows Server.

EDUCATION DETAILS:

MSC from Berhampur university

Year of passed out: 2000

MCA from Biju Patnaik University and Technology

Year of passed out:2006

Contact this candidate