BI Consultant
HCL TECHNOLOGIES; RLB UK
Keywords
SQL Server Integration Services
Cron
Extract Transform Load (ETL)
Data Warehousing
Unix Shell
Microsoft SQL Servers
Oracle SQL Developer
Power BI
SQL Databases
Active Directory
Skills
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
Project history
11/2018
-
04/2023
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
11/2018
-
12/2022
Technical Lead
HCL Technologies
* 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.
11/2018
-
12/2020
BI Lead
Customer Brightstar
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
10/2016
-
11/2018
Sr. Software Engineer
Wipro Limited
10/2016
-
11/2018
Senior Developer using MSBI and SQL Server
WIPRO Limited
Project Name: Aircel
Location: Gurgaon
Database: SQL Server, Unix/Linux
ETL/REPORTING Tool: Microsoft SSIS, SSRS and POWER BI.
Project Description: Developed the CRs of Credit and collection Management System which deals
in dunning activities of Aircel postpaid subscribers and was earlier handling team of Interconnect
billing for Aircel Project.
Responsibilities:
* Create the SSIS package and publish the SSRS report and
* Create Functions/Procedures/Trigger for Business Logic.
* Creating additional tables based on the requirement.
* Unit testing of the deliverables at developer's end.
* Create and modify UNIX shell scripts.
Location: Gurgaon
Database: SQL Server, Unix/Linux
ETL/REPORTING Tool: Microsoft SSIS, SSRS and POWER BI.
Project Description: Developed the CRs of Credit and collection Management System which deals
in dunning activities of Aircel postpaid subscribers and was earlier handling team of Interconnect
billing for Aircel Project.
Responsibilities:
* Create the SSIS package and publish the SSRS report and
* Create Functions/Procedures/Trigger for Business Logic.
* Creating additional tables based on the requirement.
* Unit testing of the deliverables at developer's end.
* Create and modify UNIX shell scripts.
02/2014
-
09/2016
SQL Server, UNIX, Informatica, Teradata and Tableau
HCL Noida; IBM India Pvt. Ltd.
Responsibilities:
* Experience in working with SQL Server,Oracle PLSQL and Sybase Performance Tuning.
* Wrote extensive SQL Server Stored Procedures, Triggers and Packages.
* Expertise in the creation of materialized views, global temporary tables, cursors,
indexes, functions.
* Experience in data loading techniques using scripts and SQL Loader utilities.
* Experience in Using Job Scheduler using CRON Job using Unix/Linux.
* Experience in database monitoring using SQL scripts, CRON and Database Job and scheduler.
* Experience in UNIX shell scripting.
* Additional responsibilities being Requirements gathering, Coding and Analysis, Testing.
* Experience in IT Software Development, Project Execution & Service Management.
Environment: SQL Server,DWBI Tools (Informatica 9.1),Unix Shell scripting.
Project Name: BHARTI Airtel-IDOC/DEDUPE/Ivoice (Apr 12- May 13)
Location: Noida
Role: Developer
Language: PL/SQL, Unix/Linux
Database: Oracle 10g
Company: IBM India Pvt. Ltd.
Project Description:
Bharti Airtel- IDOC an integrated document management solution powered by easy sharing and securing
of digital assets for maintaining documentation work flow.
Bharti Airtel- iVoice is a CRM tool provides an intelligent and intuitive solution to automate the
process of resolving non-voice queries, requests and complaints (QRC) of customers within the
defined TAT.
Bharti Airtel- iSpeed an integrated document management solution powered by easy sharing and
securing of digital assets for maintaining documentation work flow.
Bharti Airtel- Mcommerce an Integrated content management solution powered by Document Manager and
Business Process Manager Modules suites for easy sharing and securing of digital assets and
injecting process intelligence into enterprise DNA.
Key Responsibilities:
* Create Packages /Functions/Procedures for Business Logic
* Creating additional tables based on the requirement.
* Unit testing of the deliverables at developer's end.
* Create and modify UNIX shell scripts.
* Experience in working with SQL Server,Oracle PLSQL and Sybase Performance Tuning.
* Wrote extensive SQL Server Stored Procedures, Triggers and Packages.
* Expertise in the creation of materialized views, global temporary tables, cursors,
indexes, functions.
* Experience in data loading techniques using scripts and SQL Loader utilities.
* Experience in Using Job Scheduler using CRON Job using Unix/Linux.
* Experience in database monitoring using SQL scripts, CRON and Database Job and scheduler.
* Experience in UNIX shell scripting.
* Additional responsibilities being Requirements gathering, Coding and Analysis, Testing.
* Experience in IT Software Development, Project Execution & Service Management.
Environment: SQL Server,DWBI Tools (Informatica 9.1),Unix Shell scripting.
Project Name: BHARTI Airtel-IDOC/DEDUPE/Ivoice (Apr 12- May 13)
Location: Noida
Role: Developer
Language: PL/SQL, Unix/Linux
Database: Oracle 10g
Company: IBM India Pvt. Ltd.
Project Description:
Bharti Airtel- IDOC an integrated document management solution powered by easy sharing and securing
of digital assets for maintaining documentation work flow.
Bharti Airtel- iVoice is a CRM tool provides an intelligent and intuitive solution to automate the
process of resolving non-voice queries, requests and complaints (QRC) of customers within the
defined TAT.
Bharti Airtel- iSpeed an integrated document management solution powered by easy sharing and
securing of digital assets for maintaining documentation work flow.
Bharti Airtel- Mcommerce an Integrated content management solution powered by Document Manager and
Business Process Manager Modules suites for easy sharing and securing of digital assets and
injecting process intelligence into enterprise DNA.
Key Responsibilities:
* Create Packages /Functions/Procedures for Business Logic
* Creating additional tables based on the requirement.
* Unit testing of the deliverables at developer's end.
* Create and modify UNIX shell scripts.
02/2014
-
09/2016
Sr. Software Engineer
HCL Technologies
04/2012
-
02/2014
Associate Engineer
Bharti Airtel
Local Availability
Open to travel worldwide
