04/30/2023 updated
KS
100 % available
Technical Lead, Senior consultant, Technical Lead
United Kingdom
Worldwide
Active DirectoryBusiness LogicUnit TestingMicrosoft AzureUnixDatabasesCronExtract Transform Load (ETL)Data MiningData WarehousingCursor (Graphical User Interface Elements)LinuxDocument Management SystemsDigital AssetsSAP IDoc
Active Directory, Business Logic, CRON Job, CRON, cursors, Data Extract, data feed, Data Warehouse, DWBI, database monitoring, Database, digital assets, document management, ETL, data loading, IDOC, Job Scheduler, Linux, AZURE, MSBI, SQL SERVER, Microsoft SQL Server, ORACLE, Oracle 10g, ORACLE PL/SQL, ORACLE PLSQL, PL/SQL, Performance Tuning, POWERBI, POWER BI, SQL, SQL scripts, SQL Server Agent, SSAS, SSIS, Microsoft SSIS, SSIS package, SSRS, Stored Procedures, Sage, Software Development, SQL Loader, Sybase, System testing, SDLC, Tableau, Teradata, Reporting tools, Unit testing, Unix, UNIX shell scripts, UNIX shell scripting, WMS, Windows 2008 R2
Experience
Professional experience10+ years
Freelancer since2016
Languages
EnglishFluent
Project history
Project Title RLB UK
Customer RLB
Period Apr 2021 - Till Date
Platform Windows 2008 R2 Server
Reporting & Dashboard Tools MSBI Stack [POWERBI]
Database Microsoft SQL Server
ETL Tool SSIS, SSAS, ADF,AZURE SYNAPSE
Description RLB is basically UK based organization and setup their entities in CRM. Here my work is
to develop a project using SSIS packages to migrate the data from
their legacy system to CRM (Customer Engagement system) and
developed the POWERBI dashboard, deployed on SANDBOX to evaluate the
data so that business can easily understand the P/L and take the
futuristics decision.
Role BI Consultant
Customer RLB
Period Apr 2021 - Till Date
Platform Windows 2008 R2 Server
Reporting & Dashboard Tools MSBI Stack [POWERBI]
Database Microsoft SQL Server
ETL Tool SSIS, SSAS, ADF,AZURE SYNAPSE
Description RLB is basically UK based organization and setup their entities in CRM. Here my work is
to develop a project using SSIS packages to migrate the data from
their legacy system to CRM (Customer Engagement system) and
developed the POWERBI dashboard, deployed on SANDBOX to evaluate the
data so that business can easily understand the P/L and take the
futuristics decision.
Role BI Consultant
* I have a Business Visa (B1/B2) of USA (Valid till Aug 2025).
* Qualified GATE 2012 with 94 percentiles.
* Qualified GATE 2012 with 94 percentiles.
Project Title Datawarehouse and Reporting Analyst
Customer Brightstar
Period Nov 2018- Dec 2020
Platform Windows 2008 R2 Server
Reporting & Dashboard Tools MSBI Stack [SSRS Reporting], POWERBI
Database Microsoft SQL Server, ORACLE PLSQL
ETL Tool SSIS
Description
Brightstar simplifies the wireless world, making mobile technology accessible to everyone. A
subsidiary of SoftBank Group Corp., Brightstar is the world's leading mobile services company for
managing devices and accessories across the wireless ecosystem. Brightstar serves 50,000+ carrier,
retail and enterprise customers across 100 countries, touches over 100,000 points of sale and
participates in every stage of a device's lifecycle, from when it's manufactured to the moment it's
time to trade it in and re-market it. It processes over 100 million devices every year, providing
innovative end-to-end services seamlessly integrated with our customers' businesses.
Team Size 14 Offshore, 4 Onshore
Role BI Lead
Responsibilities
Responsible for requirement gathering and analysis for new or change request related to the report,
cube or data feed.
Responsible for the Data Warehouse design and development. (Designing the database schemas for
Staging, ODS and DW)
Writing technical solution specification documents and time cost estimation for new or change
request related to the report, cube, ETL and database structure.
Manage the bugs tracking list related to database and reporting issues.
Work on Integration and Transformation using MSBI stack and SQL
Knowledge about BI and Warehouse Concept and Modelling knowledge
Highlights
1. Support the business for the operation systems like ERP, WMS, SSRS and POWERBI reports 2.
Generate adhoc Data Extract for operation Investigation purpose. 3. Develop/modify any new and
existing reports in Microsoft SSRS. 4. Support DW system for Data Load and Flat file data source
monitoring. 5. Maintain Active Directory for Domain users and system users 6. Providing day to day
operational support to the business & PLM Cubes. 7. Helped BI team in System testing.
Work Location Noida, India
Customer Brightstar
Period Nov 2018- Dec 2020
Platform Windows 2008 R2 Server
Reporting & Dashboard Tools MSBI Stack [SSRS Reporting], POWERBI
Database Microsoft SQL Server, ORACLE PLSQL
ETL Tool SSIS
Description
Brightstar simplifies the wireless world, making mobile technology accessible to everyone. A
subsidiary of SoftBank Group Corp., Brightstar is the world's leading mobile services company for
managing devices and accessories across the wireless ecosystem. Brightstar serves 50,000+ carrier,
retail and enterprise customers across 100 countries, touches over 100,000 points of sale and
participates in every stage of a device's lifecycle, from when it's manufactured to the moment it's
time to trade it in and re-market it. It processes over 100 million devices every year, providing
innovative end-to-end services seamlessly integrated with our customers' businesses.
Team Size 14 Offshore, 4 Onshore
Role BI Lead
Responsibilities
Responsible for requirement gathering and analysis for new or change request related to the report,
cube or data feed.
Responsible for the Data Warehouse design and development. (Designing the database schemas for
Staging, ODS and DW)
Writing technical solution specification documents and time cost estimation for new or change
request related to the report, cube, ETL and database structure.
Manage the bugs tracking list related to database and reporting issues.
Work on Integration and Transformation using MSBI stack and SQL
Knowledge about BI and Warehouse Concept and Modelling knowledge
Highlights
1. Support the business for the operation systems like ERP, WMS, SSRS and POWERBI reports 2.
Generate adhoc Data Extract for operation Investigation purpose. 3. Develop/modify any new and
existing reports in Microsoft SSRS. 4. Support DW system for Data Load and Flat file data source
monitoring. 5. Maintain Active Directory for Domain users and system users 6. Providing day to day
operational support to the business & PLM Cubes. 7. Helped BI team in System testing.
Work Location Noida, India