Post Job Free

Resume

Sign in

sql server,ssis,ssas,ssrs,power bi,sql,c#

Location:
Toronto, ON, Canada
Posted:
May 27, 2020

Contact this candidate

Resume:

SURAJ TAYAL

SUMMARY

BI/Data analyst with around 6 years of IT experience in developing Business Intelligence solutions using MS SQL Server 2016/2014/2012/2008r2 tools, including Reporting Services (SSRS), Analysis Services (SSAS), and Integration Services (SSIS).

Expertise in SQL DBA tasks like installation, upgrade, backup, recovery, restoration, administration and maintenance for MS SQL Server 2016/2014/2012/2008r2.

Strong knowledge of Data Warehousing methodologies and Business Intelligence concepts, including star schema, snowflakes, ETL processes and dimensional modelling.

Expert in Data and business analysis of the OLTP and OLAP data.

Made use of SSIS packages using different transformations to create complex projects involving the loading, transformation, and final output of data.

Expertise in creation and deployment of dimensions, partitions, aggregation and cubes on SSAS.

Developed & supported numerous complex reports.

Very good knowledge in scheduling and deploying SSRS reports on report manger.

Experience of Creation of dashboards in Power BI and Tableau.

Created Database Objects: Tables, Indexes, Views, Stored Procedures, Triggers and Functions.

Responsible for Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Experienced in installation, configuration, maintenance and optimization of SQL Server HA (High Availability) solutions.

Design database Backup and Restoration Strategy.

Experience in Disaster Recovery Planning and Security Management operations.

Expertise in writing complex SQL scripts for data analysis.

Profound understanding of SDLC (software development life cycle).

Work with data modeler or create data models optimized for consumption pattern.

Certified Scrum Master.

Research and recommend new database tools, services and protocols.

Liaised with management and development to improve overall access to information.

Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organizational goals.

Good ability to quickly grasp and master new concepts and technologies.

SKILLS

Platforms/OS: Windows Server, UNIX, Linux

RDBMS/Databases: SQL SERVER 2008/2008R2/2012/2014/2016, DB2, MS Access, SSMS

ETL Tools: SSIS, DATA STAGE, DTS, BIDS, SSDT

Analysis Tools: SSAS

Reporting Tools: SSRS, Tableau, Power BI, MS Excel, Cognos

Programming Languages: C# .NET, SQL, MDX, DAX

Development Tools: MS Visual Studio, Team Foundation Server (TFS), MS Office

EDUCATION

MCA 2011 - 2014

Maulana Azad National Institute of Technology, India

EXPERIENCE

Scotia Bank Nov 2019 - May 2020

BI Analyst

Collaborate with Project Manager & other team members for a wide range of campaigns to clearly define specific business needs, expectations, time-lines & execution methods, which are clearly communicated to specific business groups.

Designed and developed automated process by writing complex stored procedures in SQL for various campaigns. i.e. Insurance, Mortgage and Credit cards.

Designed and developed SSIS packages to run various stored procedures in a desired sequence.

Scheduled the SSIS package with the help of SQL Server Agent Jobs.

Create stored procedures and SQL queries to pull data into power pivot model.

Write calculated columns, measures query’s in Power BI desktop using DAX.

Weekly presentation to the business users about the reports and their changes as required.

Work on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Work on all types of transformations that are available in Power bi query editor

Creating and modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Review and test the work of other team members.

IBM India Pvt. Ltd. Jul 2014 - Jul 2019

Client: Apollo Munich Health Insurance Jul 2018 - Jul 2019

BI Developer

Designed databases including the physical/logical structures as per the requirements.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Extensively used SSIS tasks and transformations such as Lookup, SCD1, SCD2, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task.

Developed SSAS Cubes, partitions, aggregation from scratch with Star Schema.

Create business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

Collected, processed, analyzed and reported on metrics and quality control data to meet specific customer reporting requirements.

Wrote Parameterized Queries for generating Tabular reports, formatting report layout, creating reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and Data-sets, calculating subtotals and grand totals for the reports using Power BI.

Created Drill through, drill down, Matrix and Sub reports, added report mapping functionality to the reports using Power BI.

Tuning of Reports by validating SQL against database and troubleshoot reports that are not providing accurate data due to custom SQL codes.

Designed and Developed Ad-Hoc queries and trained the end users on how to develop reports.

Involved in data modeling for the SQL Server and for individual databases.

Created T-SQL objects & scripts used to maintain data integrity across all databases throughout database servers (Stored Procedures, Triggers, Functions).

Monitoring and Performance Tuning: Physical Server Level, Database level and query tuning.

Installation of replication server, configuration and monitoring the replication between two servers using Transactional Replication.

Contributed in Sprint planning and sprint retro meetings.

Client: Airtel Africa Apr 2017 - Jun 2018

Developed and maintained SQL queries and stored procedures for use in ad roc reporting or recurring reports. (MS SQL Server 2008, 2012)

Design SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.

Created complex ETL packages using SSIS to extract data from staging tables to ODS tables with incremental load.

Worked on change requests in production environment.

Designed and deployed reports for the End-User requests using SSRS.

Generated Monthly, Quarterly, Bi-Yearly and Yearly reports using different types of reports in SSRS.

Maintained the database using Procedures, Functions, Cursors and Triggers.

Created automation of day to day operations, critical SQL server alerts and repetitive tasks.

Monitored data activities like database status, logs, space utilization, locks and long running queries.

Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of the databases.

Recorded project changes on a weekly basis using change data to update the project plan and provide up-to-date information for project status reporting.

Wrote and maintained Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations.

Migrated MS Access Databases into MS SQL Server 2012.

Monitored team's ticket queue for compliance and appropriate prioritization.

On-call troubleshooting for SQL Server service outages.

Client: DHFL Pramerica Life Insurance Apr 2016 - Mar 2017

Built and maintained SQL scripts for data analysis and extraction.

Designing and scheduling complex SSIS Packages for transferring data from multiple data.

Use Transformations such as Union All, Merge and Breakpoints in SSIS.

Used reporting services (SSRS) generated various reports.

Optimized the indexes, added/deleted them when necessary for better performance.

Created always on availability group in SQL Server.

Profiled and optimized queries to ensure performance in a heavily utilized IBM production environment.

Worked with capacity planning, database sized and monitored using SQL Server.

Worked with SQL server profiler and Database Engine Tuning Advisor.

Worked on data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehouse application.

Worked on disaster recovery solution according to client needs.

Client: Henkel FMO Jul 2014 - Mar 2016

Created new tables, views, indexes and user defined functions in MS SQL Server.

Developed, deployed and monitored SSIS packages.

Created reports using Global Variables, Expressions and Functions using SSRS.

Documented major changes to the SQL Server.

Involved in performance tuning of slow running queries.

Actively designed the database to fasten certain daily jobs and stored procedures.

Wrote SQL queries in MS SQL Server 2008/2008R2.



Contact this candidate