SONAL SATAPATHI

E-Mail: acxhid@r.postjobfree.com

Contact No: +1-425-***-****

Highly motivated Business Intelligence Professional using MSBI, SQL Server and Microsoft Technologies, seeking consulting assignments in MSBI/SQL Server Technologies.

PROFILE SUMMARY:

9+ years of Total IT experience with immense exposure to the entire Software / Product Development Life Cycle right from analysis of business requirements, design, development, testing, final delivery of application and documentation.

5+ years of experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.

Working knowledge of Power shell scripts, IIS Web Server and .Net Framework 3.5.

Involved in Huge data migrations, transfers using utilities including SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, and Oracle.

Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel Power View.

Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.

Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon.

Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.

Extensive experience in Deploying and Consolidating Multiple Instances over Clustering Environment and Remote Installations.

Extensive experience in Installation, Configuration and Deployment of SSRS.

Involved in migration of SSIS Packages 2012 SP1 CU5 and troubleshoot migration issues.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, Functions, Triggers, and Distributed Transactions.

Organisational Experience:

Since Oct’12

Tech Mahindra Ltd., Redmond, WA as Software Engineer.

Oct’06 to Oct’12

Infosys Technologies., Hyderabad as Technology Analyst

Certifications:

70-432 (SQL Server 2008 Implementation and Maintenance),

70-450 (Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008),

PR 101 Open Systems Certification

IMS Certified Apps Engineer

Awards and Achievements:

Received multiple Pat on the Back (POB) in ECO for exceptional performance in Tech Mahindra.

Received Best Team award in ECO for exception performance in Tech Mahindra.

Received multiple appreciations from Clients\program managers of ECO Portfolio for critical applications like MSSOLVE, DETEGO & EWS.

Projects Handled:

Title: ECO

Client: Microsoft Corporation

Place: Redmond, WA

Role: MSBI Engineer

Responsibilities:

Involved in Staging Partitions and Usage Based Optimization ( UBO) mechanisms for SSAS 2014 and 2012 OLAP databases.

Involved in Tabular Data warehouse and DAX operations for SSAS 2014 and 2012 OLAP databases.

Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

Reviewed & Tested packages, fixing bugs (if any) using SQL 2014 Business Intelligence Development Studio.

Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.

Involved to planning and designing SSAS 2014 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.

SME for key applications (VRP, NEXTRA, O365 BI, SEAM, STAX and Detego operations)

Worked on Patching the Servers, deployments, Password change activities, Disk Space Issues for SQL & IIS Servers.

Hands-on experience in Server Upgrades, migrations and setting up databases for new applications.

Involved in Installation, Configuration and Administration of various SQL Server Products like SQL Server 2008,2012 and 2014.

Working in SQL Server 2012 & SQL Server 2014 environment and ensuring the data availability/quality 24*7

Administrating and Managing IIS 6.0 and 7.0 servers, creation of Virtual Directories and web sites on Cluster Environment.

Created various alerts for applications in Site scope & SCOM. Updated the alerts in Site scope & STAX and worked on the issues like analysing alert miss, repeated alerts etc.

Maintaining SSL certificate, X509 information sheet and working with upstream and downstream teams for certificate renewal. Worked in creating Azure Expired Certificate issues

Responsible for the SQL, Windows Server & application related issues and provided event viewer Logs, SQL error logs to Engineering in resolving critical issues.

Resolved various application issues which were caused by SQL authentication, Always On and Sync issues

Responsible for IIS cluster synchronization between Active and Passive Nodes.

Provided proactive and reactive SQL DBA support for Production and Pre-Production Test environments.

Created Disk space monitoring Job using SQL Server, SSIS Package and Power Shell Scripting to monitor the disk space across all the ECO Servers and alert Line 2 if Drives cross a certain threshold.

Excellent in performing Job trend analysis and SSIS package code review.

Worked on providing RCA to customers

Provided Ticket Analysis, Reporting and Problem Management. Provided solutions to reduce the Ticket Count for applications. Resolved number of Problems, automated and created number of KB articles which reduced manual efforts

Having good hands-on experience on optimizing TempDB performance and CPU Utilization

Creating, configuring, scheduling and troubleshooting of database backup and restoration plans.

Configuring and troubleshooting of High availability solutions like Log Shipping, Replication and Clustering & Database mirroring.

Automation of administration tasks like Index Management, Tempdb log file management, Disk space management, Configuration change alerts by creating DTS, SSIS packages.

Responsible for creating, Scheduling and troubleshooting of SQL server Jobs which contain SSIS, DTS Packages and Stored Procedures and Transact SQL Statement as Job Step.

Experienced in creating Basic SSIS packages for Data Transformation, Data Migration, and Data cleaning using Business Intelligence Development Studio.

Hands on experience in troubleshooting Database performance by understanding output of SQL profiler, Query Execution plan, Windows / SQL Performance Counters, DMV’s and DBCC commands.

Experienced in intermittent tasks like Upgrades & applying Hot fixes/Service Packs on SQL servers, updating SQL Server Agent Password, and moving SQL Server Database from one server to another server.

Basic networking and hardware load balancing experience. Worked with Network and GCO teams for various PORT, network issues

Environment: SQL Server 2012 and SQL server 2014,SSIS, SSAS, SSRS, SQL Server Agent, MS Access, T-SQL, ERWIN

Technical Forte:

Conversant with:

oMicrosoft Technologies:

SQL Server 2014 Integration Services, SQL Server 2014 Analysis Services, SQL Server 2014 Reporting Services, Microsoft office SharePoint Server 2010, Microsoft Visio.

oDatabases:

MS SQL Server 2014.

oSoftware:

SQL Server Business Intelligence Development Studio.

Education:

MSc. in Electronics from Andhra University, Vishakhapatnam, AP in 2005.

Contact this candidate