Sai Phanindra. Summary. Experience. SQL Server, SQL DBA and MSBI SQL School

Sai Phanindra

SQL Server, SQL DBA and MSBI Trainer @ SQL School

saiphanindrait@gmail.com

Summary

Having 8+ Years Working experience on SQL Server 2005, 2008 R2 and SQL Server 2012 Database Management and Business Intelligence competencies specifically into Marketing, Sales and Infrastructure domains. Holds MCP, MCDBA, MCITP and MCSA Certifications from Microsoft. Currently working for SequelGate Pvt. Ltd. (SQL School) as BI Consultant and Corporate Trainer. Also involved in Database Consulting services on SQL Server 2014 with Azure for an Infrastructure Client based at Hyderabad, India. Being proficient on SQL Server and related technologies in Health, Medicare and Sales-Retail Sector, I love sharing knowledge via Instructor Led LIVE Online / Classroom Trainings and offering training videos. Personally I enjoy answering doubts from the attendees and get involved in brain-storming sessions. All Trainings are completely practiical and real-time, paired with 24 X 7 LIVE Server Access and Real-time databases. Courses Offered: >> SQL Server Training >> SQL DBA Training >> MSBI Training >> SQL BI and DWH [SSIS/SSRS/SSAS] Training >> DAX and PowerView >> DQS and MDS with Powershell More details: www.sqlschool.com Mail Us: contact@sqlschool.com Call Us: 09666440801 or at 040 64577244 (India Code: +91)

Experience

Independent BI Consultant and Corporate Trainer (SQL Server, DBA and MSBI/DWH) at SequelGate April 2013 - Present (1 year 9 months)

Sai has been working on SQL Server for more than eight years. Started his technical journey with Microsoft (MSIT Team), Sai has a great passion for SQL Server. He always says: ‘I LOVE SQL Server!’ and

that shows his decent interest on the technology. Sai’s initial career is driven with major exposure to Production Database Administration activities including Capacity Planning, Query Tuning, Clustering Issues and Resource Management activities. Later part of Sai’s career (Deloitte) is into Business Intelligence world (and still continuing) with major exposure to SSIS Package Tuning, Data Modeling, Tabular and DAX programming, Multidimensional Cube Management and PowerView. Being a Microsoft Certified Professional and Solutions Associate (MCSA), Mr. Sai has a great passion to provide Knowledge Transfer on SQL Server Database Administration (DBA) and Business Intelligence (MSBI) technologies in an interactive environment. All his trainings are ENSURED to be completely practical, LIVE and Real-time. Currently continuing to work closely on SQL Server Independent BI Consultant and Corporate Trainer with SQL School and SQL International

Business Analyst (BI Vertical) at Infy April 2012 - March 2013 (1 year)

In Short.. • Migrated SQL Server 2008 R2 BI systems to SQL BI 2012 with DQS Monitors • Administered SQL Server High Availability and Disaster Recovery strategies • Implemented Data Compressions, Contained Databases and AAG • Worked extensively on Clustering and server consolidation • Worked on logical and physical data base modeling with UML and ERWIN tools • Cube Management and Reporting activities • Implemented Data Mining Strategies for accurate forecasts on Artificial • Data Analysis using Data Quality Services (DQS) and Imaging • Service Broker Implementation for SSIS and DQS • Configured SQL Databases over Windows Cloud (Azure Operations Center) • Proposed systems to collect electronic correspondence to increase client satisfaction • Created quality assurance systems to for project assets and quality benefit (delivery) • ODC Management and Process Management including Delivery site maintenance

Business Analyst (ETL and DW) at Deloitte June 2009 - February 2012 (2 years 9 months)

In short... • Handled Performance Tuning and Optimization in large-scale production environments • Involved in gathering business requirements from clients • Involved in creation/review of functional requirement specifications and supporting documents • Created Data-driven Packages in SSIS as part of Referral Process • Reviewed & Tested packages, fixing bugs using BI Dev Environments and Custom Code • Studied existing OLAP system(s) and created snowflake schema • Updated BI Functional specs and BI Technical Design documents • Identified Data Source and Data Source Views CUSTOM Mappings for ETL • Developed, deployed and monitored SSIS Packages for new ETL Processes • Migrated data from various data sources like Oracle, Flat-files and upstream into Staging • Monitored Full/Incremental/Daily Loads and support ETL jobs for batch processing • Developed Stored Procedures, Triggers and SQL scripts for performing automation tasks • Monitoring, Analyzing and Fine-tuning Cube Designs • Deciding Member Relations and Customization factors for Analysis • Arriving at best solutions for business level Data Mining and DMX clients • Forecast Application Design patterns and documentation best practice solutions

Data Base Administrator and SME at Microsoft Corporation September 2005 - June 2009 (3 years 10 months)

In short... • Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 • Involved in Technical decisions for Business Integration and Analysis • Planned, Configured and Maintained SQL Server in Multi-Node Active-Passive Cluster • Monitoring and troubleshooting MS SQL Server Databases, Oracle databases and DB2 • Setup and troubleshoot for Active/Active/Passive Clustering in SQL Server 2008 • Configured and Monitored Database Mirroring for Application Development

environment • Migration of DTS packages to SSIS packages implementing FAST LOAD options • Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out • Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting • Configured Disaster Recovery solution with Transaction Replication from Distribution Server • Controlled and coordinated installations with Security Patches and Service packs • Involved in daily code drops and archives on the production databases during maintenance • Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job • Performed Regular Database Maintenance process and disk mirror procedures • Used SQL

Profiler and PERFMON to monitor and resolve deadlocks and long running queries • Performed Database Refresh tasks from production to Development and Staging Servers • Performed Database consistency checks with DBCC, DEFRAG and Index Tuning • Database Performance of Index tuning with using Database Engine Tuning Advisor • Worked on exporting OLAP cube to Excel and used Pivot table feature • Performed in identifying the sub-optimal solution for code in production server with SQL Trace • Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning

Languages

English

Honors and Awards

Microsoft March 2013

MCSA: SQL Server Microsoft Certified Solutions Associate (MCSA) for SQL Server 2012 Associate level

Microsoft Certified Solutions Associate (MCSA)

Microsoft March 2013

Microsoft Certified Solutions Associate (MCSA) on SQL Server 2012 Querying Microsoft SQL Server 2012 Administering Microsoft SQL Server 2012 Databases Implementing a Data Warehouse with Microsoft SQL Server 2012

Skills & Expertise

Warehousing and MDX Tuning SSRS Development and Management MCTS Certification Guidance

MCITP Certification Guidance Database Administration SQL DBA and SQL Azure SSIS

SSRS

Microsoft SQL Server ETL

SQL Tuning T-SQL MDX

Performance Tuning Data Warehousing

Business Intelligence IIS Databases Data Modeling Analysis Services Data Mining Requirements Analysis Oracle DAX DQS Online Training Classroom Training Corporate Training Remote DBA Services BI Consulting

Project Planning - technical RFP Generation and Project Bids Replication

SSAS SSAS 2008 SSAS 2012

As Tabular Model and DAX MDX and Cube Reports Realtime Training

SQL Server Online Training SQl Server Classroom Training Integration Software Development SQL DB2 Software Documentation Cluster E-Learning

Education

Jawaharlal Nehru Technological University

B Tech with M Tech (Employment Program from IIT - R), Computers and IT, 2001 - 2005

Activities and Societies: Providing SQL Server Trainings - Corporate, Classroom and Online, Remote DBA activities, Database Consulting Services, Workshops and the like.

PPS, HYD 1993 - 1998

Honors and Awards

Interests

Providing SQL Server Online Training, Corporate Training - only during non business hours. No Full Time Trainings.

Sai Phanindra

SQL Server, SQL DBA and MSBI Trainer @ SQL School

saiphanindrait@gmail.com