Rahul Kumar Singh Email & Phone Number

Lowell, Ar, Us

Teaneck, New Jersey, Us

Roles and Responsibilities :<> Working as BI Lead (SQL, MSBI, PowerBI, Databricks, Azure) at client site, leading onshore-offshore team and responsible for offshore-Onshore deliveries at client.<> Working extensively on database and data migration projects using Azure-SQL, Microsoft SQL Server 2018, 2017 (and older versions) databases, MSBI tools (SSIS, SSRS, SSAS) ADLS, GCP.<> Working in Cloud technologies – Azure, Azure SQL, Databricks, Google Cloud Platform (GCP).<> Responsible for requirement analysis, requirement gathering and technical design development.<> Responsible for understanding reporting requirement and accomplish interactive business reports design using SQL Server Reporting Services (SSRS).<> Responsible for understanding ETL requirements in project and design advanced ETL packages using SQL Server Integration Services (SSIS).<> Taking care of project documentation (SOWs, Change Orders etc) for team.<> Worked on Data migration from Legacy system to new cloud/Azure system using MSBI ETL tools.ENVINORMENT: MS SQL Server 2008,Azure, ADLS, GCP , Power BI,ADF, SSIS, SSRS, Visual Studio 2017, T- SQL, Windows 10 Enterprise

Round Rock, Texas, Us

- Worked on healthcare domain projects.- Responsible for Application Developement, Maintenance and Support of application using SQL Server2008 and MSBI tools (SSIS, SSAS and SSRS)- Worked on other tools like iAvenue-CRM tool, Clarity - CPM tool, Harvest, OPAS-Remedy, VSS, TFS etc.- Have good onsite (USA) work experience.- Implemented SQL Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. - Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources. - Migrated data from SQL server 2000 to SQL server 2005 and worked with implementing data mapping, cap analysis to migrate hybrid environment.- Migrated data from SQL server 2005 to SQL server 2008 and worked with implementing data mapping, cap analysis to migrate hybrid environment. - Designed SSIS (ETL) Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2008.- Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.- Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS. Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.  - Analyzed and created Facts and Dimension Tables using SSAS.  - Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.  - Involved to develop Multi-dimensional Objects Cubes, Dimensions using SSAS.

Noida, Uttar Pradesh, In

- ENVINORMENT: SQL Server 2000/2005 SSIS, SSRS, Visual Studio 2005, Windows Enterprise Server 2003, ASP.NET,C# , ADO.NET, Visual Source Safe (VSS), XML, HTML, Crystal Report.- Responsible for design and develop web application based on business requirement documents and requirement discussion with clients. Technology used was ASP.NET, C#, SQL Server 2000/2005. - Created new tables, wrote stored procedures for application developers and some user defined functions. - Created SQL scripts for tuning and scheduling using T-SQL. Defined Check constraints, Indexes, Views, Created Triggers to enforce data and referential integrity.- Used the Control Flow and Data Flow Tasks and Transformations in Creating DTS/SSIS Packages.  - Worked on DTS/SSIS Packages, Import/Export for transferring data from Heterogeneous Databases to SQL Server.  - Used DTS/SSIS to create ETL packages to validate, extract, transform and load data to data warehouse.  - Enabled Logging, Database mirroring, Replication for the DTS/SSIS packages.- Configured Server for sending automatic mails to respective people on SSIS process failure or success. -  Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients and managers.  - Created various Weekly and Monthly reports showing detailed information in SSRS.  - Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using Report definition Language (RDL).  - Created the Data source views to analyze the metadata based on multiple data sources during development without an open connection to any underlying data source using SSAS.  - Modified the measures, dimensions, attributes, hierarchies, measure groups and deployed the changes to the deployed cube in SSAS.  - Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Advisor.- Worked on Crystal report too for creating some reports.

Noida, In

- Web Application developement using ASP.Net, SQL Server, Jave Script,HTML, XML etc.

- Web Application developement using ASP.Net, C#, SQL Server, Jave Script,HTML, XML etc.