Manoj Kumar Sharma

Rue21 (From Nov 2022 Till Present)

Environment - Tableau, DWH, Sql server ,Salesforce-(CDP) ,Python, JIRA, gitlab, Windows

Client Project Abstract: Rue21 is an American specialty retailer that offers affordable fashion apparel and accessories for young men and women. The company targets customers aged between 15 and 25 and focuses on providing trendy and stylish clothing at competitive prices. Rue21 operates both brick-and-mortar stores and an online e-commerce platform.

Roles & Responsibility

• Architectural discussion and create DWH.

• Create and manage data flow with metadata information's.

• Define table's structure and level's of hierarchy.

• Create store procedure to load data from landing to enterprise data warehouse layer's.

• Push the code changes in gitlab.

• Create and schedule SQL server agent job to load data.

CBC - credit bureau of columbus (From Dec 2020 To Oct 2022)

Environment - Alteryx ,Salesforce ,Python, Sql server, JIRA, Windows

Client Project Abstract: CBC Companies is a privately held business, originally founded in 1948 as the Credit Bureau of Columbus. Today, CBC Companies is the holding company for a family of businesses which provide various risk management, data and lending support services.

Roles & Responsibility

• Create workflow for RPA.

• Add feature per sprint wise.

• Push the workflow in gitbucket.

• Workflow pushed into gallery.

• schedule workflow as per cron jobs.

Delta Dental of Virginia - (Now - North Wind) - (May 2018 To Nov 2020)

Environment - Qliksense , Sql server, JIRA, Windows

Client Project Abstract: Delta dental of Virginia works on dental insurance provider in Virginia State in USA.

created finance, billing, claims related app and reports for make better strategic business decisions.

Roles & Responsibility

• Involved in functional study of the Qlik application.

• Designing Data model based on requirement.

• Writing SQL scripts to load(QVD's) the relevant data in QlikSense application.

• Created reports using different components of QlikSense like table, charts, KPIs, and buttons etc.

• Interactions with BA & Operation teams to resolve the issues.

E2open (Zyme Solutions Pvt. Ltd.) (From Oct 2014 To April 2018)

Environment - DWH, Qlik sense, QlikView, JIRA, bitbucket, Windows

Client Project Abstract: E2open is a global supply chain management software company that provides cloud-based solutions to optimize supply chain operations and improve business efficiency. The company offers a comprehensive suite of software applications and services designed to address various aspects of supply chain management, including demand planning, inventory management, logistics, supplier collaboration, and overall visibility into supply chain operations.

Product: ZAP Global, Retail, Territory, Discovery, Production Tracker

Roles & Responsibility

• Involved in functional study of the Qlik application.

• Writing SQL scripts to load the relevant data in QlikSense Application

• Created app using different components of QlikSense like various types of chart, KPIs, master-items, visualizations etc.

• Performed testing of dashboards for functionality, data, performance, look and feel.

• Make sure the dashboards should be available in QA, UAT and Sendbox environment.

• Interactions with BA & Operation teams to resolve the issues.

• Push the code changes in gitlab.

Themis Group (Themis Lexsol Pvt. Ltd.) (From Aug 2011 To Aug 2014)

Environment – Informatica 8, DWH, Oracle, bitbucket, Windows

Client Project Abstract: Themis Group is an integrated legal solution provider founded in 2009. The group offers a one stop solution for clients seeking advice on legal, compliance, finance and tax matters. The group leverages use of technology in the conduct of their operations and also provide clients several online solutions and resources for efficient management of legal contracts, corporate compliances and legal data management through its collaborators.

Product: Legal Compliance Management, Portfolio Companies Management

Roles & Responsibility

• Involved in functional study of the application
• Running the Jobs/Workflow for ETL process
• Prepared and ran SQL queries
• Designed & Executed test cases
• Verifying the data in target database after ETL process
• Prepared test data for testing
• Defect Analyzing and Reporting in QC
• Interactions with BA & Dev teams to resolve the issues
• Reporting daily testing status report
• Interactions with BA & Dev teams to resolve the issues
• Reporting daily testing status report