Sql Server Business Intelligence

RAJ KAMAL VERMA

**************@*****.*** +91-801*******

Page 1 of 4

Profile

Overall 14 years of IT experience including 13 Years of SQL Development in Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), SQL Server, SQL Server Integration, and Reporting Services.1 years Fundamental experience in Azure Database. Profile Summary

I have Total 13 Years of SQL Development experience. 3 Years of MSBI(SSRS,SSIS) experience.

Achieving organizational goals by defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases.

Database architecture designing, sizing, and costing,Indexing, Table Partitioning,Log Shiping.

Defines infrastructure for design and integration of database by analyzing information requirements, studying business operations and user-interface requirements, and directing development of physical database.

Improves architecture by tracking emerging technologies and evaluating their applicability to business goals and operational requirements, Responsible for Release and deployement.

Migrate data from legacy systems to new solutions.

Design conceptual and logical data models and flowcharts. Database documentation.

Improve system performance by conducting tests, troubleshooting, and integrating new elements.

Optimize new and current database systems.

Define security and backup procedures.

P r o v i d e o p e r a t i o n a l s u p p o r t f o r Management I n f o r mation S y s t ems ( M I S ) .

ZOHO Analytice,Zoho CRM and Flow,Dash Board,Zoho Creator, Reports and Pivot and KPI development for Client-Amazon. Query optimization. In MySql.

Involved End to End Ramco ERP Implementation Full Cycle Process, Gap Analysis identify,User Training, developymen and Documentation.

6 Years experience on ASP.net,C#,XML,XSSLT CSS,HTML,Jquery, Java Script,OOPS Concept .

Integration of commercial invoice With Webtel S/W for GST-Einvoice,Eway Bill,Purchase and Sale Register,Tracking on TMS/PMS system for Tool and Pattern.

Auto ASN API Implementation for TML Customer.

Tecnno Functional on Purchase, Inventry,Quality,Production,Sales,Finance, HRM Module.

SQL Query Like Store Proc, Trigger,function,View and ERP Technical.Data Migration.

Experience Case Register(Ticketing) and Change Management Process and Quality gate 5.

Screen Customization in Canias and RAMCO ERP.

Development of D-Cube, SSRS and Excel Refreshable and Zoho Analytics Reports.

Kaizen and KPI process Implementation.Change Management, PBS Tracking.

Full Cycle of production Module like BOM, Rotues, Production order, Job Card Entries.

4 Years of experience M365(Teams, Power App,Share point, planner, One note, One drive, power automation)

Professional Experience

Currently Working in ElectreeFi Software PVT .LTD. Noida as a Data Architect Engineer since, 10 March 2023 to till date.

Ghaziabad Precision Products PVT .LTD. Ghaziabad as an ERP Assistant Manager since, 07 March 2018 to 9th March 2023.

RAJ KAMAL VERMA

**************@*****.*** +91-801*******

Page 2 of 4

Tenon Property Services India PVT .LTD (Tenon Group). Gurgaon as an ERP Assistant Manager since, 22 August 2015 to 06 March 2018.

PMAM IT Services Pvt. LTD. Mumbai as an Technology Speciliast since, 09 March 2014 to 09 March 2015.

Riding House Infotech Pvt. LTD. Gurgaon as an Web Developer since, 03 June 2012 to 07 March 2014.

Pseudo Technology Pvt. Ltd. NOIDA as an Web Developer since, 01 Jan 2010 to 30 June 2012. Education

MCA (Computer Application) from HBTI (KANPUR) Passed 2009.

BSc. (PMC) from HCPG (VARANASI) Passed 2006.

ERP Project Experience

Customer Amazon, Ghaziabad Precision Products.

Industry Production Support

ERP Solutions RAMCO 5X, RAMCO 3X,CANIAS ERP, Zoho Analytics, Zoho CRM Duration 07 March 2018 To till date

Technology C#, Asp.Net, SQL Server, XML,XSSLT, CSS, HTML, Java Script, MSBI(SSRS,SSIS) Team Size 6

Role Business Analyst

Current Project

ElectreeFi Charging Software

ElectreeFi is a generation IoT platform for electric vehicles. This platform includes solutions like EV charging, battery swapping solutions, EV fleet management solutions, and Park N Charge solutions. Their vision is to be one of the largest Mobility as a Service (MaaS) software platform provider realising the dream of providing easily accessible, convenient, connected, clean and green mobility solutions to different businesses and end users.

Responsibilities

Analysis of Functional Specs and Preparing Tech Specs.

Involved End to End CRM Full Cycle Process, Gap Analysis identify,User Training, developymen and Report and Dashboard development.

Charging Station Log shiping.Database backup, and restoration.

Query optimization using Indexing, Table partioning,execution plan.

Developments in areas of reports,Dashboard and screens.

Responsible for Performance Optimization .

Preparing Delivery documents.

RAJ KAMAL VERMA

**************@*****.*** +91-801*******

Page 3 of 4

Worked on below Objects:

Zoho Analytics, CRM, Reports and Dashboad,Develope and developemt.

Purchase Request and Purchase Order Cycle.

Inventory and W/H management Support.

Quality Control Process manage throught ERP.Stock Reco.Bank Reco.

Creation of BOM, Routing, Production Order,Bar Code scaning and Job Card Enteries.

Credit Memo, Debit Memo, credit memo date, debit memo date and amount.

Working with Financial Modules like AP, AR, GL Payments and HRM.

Worked on Service Order to validate fields Service type and defect type values.

Debugging for finding issues why Interco Form not displayed Sending and receiving entities properly

Analyzing the dump issues update failures reported by users.

Performing code reviews for PCR’s.Hands on experience on incident management,Service request management and also Problem management

Improving the performance of the existing development programs which gives faster output. Customer Tenon Property Service Pvt. Ltd.

Industry Service Provider

Technology C#, Asp.Net, SQL Server, XML,XSSLT, CSS, HTML, Java Script, MSBI(SSRS,SSIS) ERP Solutions RAMCO 5X

Responsibilities

Full Cycle of Ramco ERP Implementaion

Developments in areas of reports and screens

Responsible for Performance Optimization

Preparing Delivery documents.

Analysis of Functional Specs and Preparing Tech Specs .

Developments in areas D-Cube and reports .

Preparing Delivery documents.

Customer Argo Insurance

Industry Service Provider

Technology C#, Asp.Net, SQL Server, XML,XSSLT, CSS, HTML, Java Script, MSBI(SSRS,SSIS) Duration 9 March 2014 to 9 March 2015

Responsibilities

Property & Casualty Report and deployment

Customer and Contract creation.Reports and Dashboard Creation.

Responsible for Performance Optimization.

CERTIFICATION

Certificate Name Company Name Duration

Asp.net Hewlett Packard(HP) 15th Jan-2009 to 15th May-2009 MSBI Edureka 21st August-2018 to 22 August-2018

Advanced Excel Multisoft Sstems(Microsoft Partner) 10th Dec-2019 to 15th Jan-2020 RAJ KAMAL VERMA

**************@*****.*** +91-801*******

Page 4 of 4

PERSONNAL PROFILE

Name : RAJ KAMAL VERMA

Date of Birth : 01 /06/ 1983

Passport NO : Z3172968

Languages Known : English, Hindi

Permanent Address : Saurabh Vihar Colony AValeshpur Varanasi -221106 DECLARATION

I hereby declare that the above furnished details are true to the best of my knowledge. Place: Ghaziabad

Date:

Raj Kamal Verma

(Signature)

.

Contact this candidate