Bijay Rai

• Hold 5 plus years of experience in coveted diverse business and technical environments with main area of focus in design, development, implementation and support of relational databases, data analysis, business intelligence, ETL, and data visualization using RDBMS and Cloud databases and various reporting and visualization tools. • Thorough understanding of all the phases of SDLC including requirement gathering, analysis & design, implementation and delivery; versatility to work on different platforms and bring an innovative approach in designing solutions • Completely versed with Cloud methodologies and terminologies (IaaS, PaaS, SaaS, FaaS and DaaS), Cost optimization techniques, different types of Services, Server less Services, API programming using C#. • Well versed with MicroServices architecture using (CRON Jobs deployed in) Docker and Kubernetes container orchestration. • Implemented Data Orchestration using Apache AirFlow hosted by Azure Data Factory to prioritize and align Pipelines dynamically. • Good experience of On Prem ETL processes and tools and technical expertise in ETL (Extraction, Transformation and Loading) of data from multiple feeds & sources (Excel, CSV, Flat Files, SQL, Oracle, Json, Web Services, XML, SharePoint List and Third-party API's (WINSCP-SFTP and Newton soft-JSON) into Data Warehouse using SQL Server Integration Services (SSIS). • Conversant with Data Distribution algorithms like Round Robin, ASCII and Replicator, implemented Data Partitioning using Round Robin in Data Warehouse built using Azure MS SQL PaaS service. • Well experienced on Server less Azure Data Factory Author and Monitor features in order to build Cost efficient pipelines to port data from multiple sources. • Implemented Azure Data Factory Integration Runtimes to execute SSIS packages, collecting On Prem data scenarios, Parametrized Linked Services and re used existing Data Sets across most of the activities in a Pipeline. • Good knowledge in EMR (Elastic Map Reducing) to perform big data operations in AWS. Knowledge in working with Amazon Web Services (AWS) using EC2 for computing and S3 as storage mechanism. • Experience in dimensional data modelling and Cube development, partition, aggregation and optimization using SSAS. • Created & formatted Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports. • Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment. • Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration. Also created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency. • Excellent knowledge of DDL (CREATE, ALTER and DROP) and DML (INSERT, UPDATE and DELETE) in T-SQL and some experience in using SQL Profiler for Query Tuning and Optimization. • Experienced in Designing, Creating and processing of cubes using SSAS. Created and Configured Data Sources and Data Source Views, Cubes, and calculated measures for OLAP cubes. • Team player with the capability to motivate associates for delivering desired performance levels, strong communication, analytical and problem-solving skills.