Manish Kumar

Project: -

Global BI: Hays are an integral part of the Hays-Recruitment experts worldwide. Hays provide HRO, Financial Accounting and Support services along with web application and IT Infrastructure solutions to Hays Businesses.

Handling the Hays Payroll system using SSIS ETL process which provides ANZ, EMEA, AMERICA & UK finance data for the Global BI project.

• ETL development with specifications, documentation, and development of data migration mappings and transformations for Data warehouse loading
• SSIS Packages and Project file Deployed on servers and use in a SQL Agent Job
• Worked with project managers, developers, quality assurance, and customers to resolve technical issues.
• Database export or copy, adding, modifying or viewing data masking rules
• Increased customer satisfaction rates through diligent collaboration with cross-functional teams on feature development and bug resolution.

Project: -

Global BI: Hays are an integral part of the Hays-Recruitment experts worldwide. Hays provide HRO, Financial Accounting and Support services along with web application and IT Infrastructure solutions to Hays Businesses.

Handling the SSIS ETL process which provides ANZ, EMEA, AMERICA & UK finance data for the Global BI project.

• Company Overview: Arch Insurance provides specialty risk solutions to clients worldwide across a range of industries from operations in North America, Europe and Australia
• T-SQL Created SQL Server Tables, Functions, Views, & Constraints
• Create and deploy ETL packages to achieve various task using SSIS and Azure Data Factory
• Designed star schema and snowflake schema in the process of data modeling
• ETL Loading using SSIS
• ETL development with specifications, documentation, and development of data migration mappings and transformations for Datawarehouse loading
• Packages and Project file Deployed on servers and use in a SQL Agent Job
• Data loading from SQL Azure to On-Premises and vice-versa
• Database export or copy, adding, modifying or viewing data masking rules
• Export to a BACPAC file
• Azure data factory, Pipelines Azure Trigger jobs
• Arch Insurance provides specialty risk solutions to clients worldwide across a range of industries from operations in North America, Europe and Australia

Project: -

Arch Insurance Systems : Arch Insurance provides specialty risk solutions to clients worldwide across a range of industries from operations in North America, Europe and Australia.

· Created data transfer pipelines between Azure services and on-premises systems, resulting in a 95% network throughput increase.

· Extract Transform and load data from sources systems to Azure Data Storage services using a combination of Azure Data factory, T-SQL, Spark SQL, and Azure Data Lake Analytics. Data ingestion to one or more services-(Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks.

• T-SQL Created SQL Server Tables, Functions, Views, & Constraints
• SSIS Packages Development, Monitoring and Deployment
• SSRS Reports Development and Scheduled
• Wrote stored procedures to create SSRS reports
• Packages and Project file Deployed on servers and scheduled by the job
• Troubleshoot various problems that arise in a day-to-day work and fix the issues
• Monitoring and Performance tuning; Database level (Database settings and options) and query tuning
• Load the data from MS Excel to SQL Server Table and SQL Server table to MS Excel
• Documenting major changes to the SQL Servers
• Data loading from SQL Azure to On-Premises and vice-versa
• Datawarehouse incremental load and SSAS tabular model
• ETL Loading using SSIS
• Perform data analysis, develop database design, share and get consensus on design, and then develop the stored procedures to fulfill the database design
• Provide support and participate with development team during the analysis, design, coding, development and testing processes
• ETL development with specifications, documentation, and development of data migration mappings and transformations for Datawarehouse loading
• Map sources to targets with Microsoft Business Intelligence Tools for design and develop ETL code to load and transform the source data from various formats into a SQL database
• Archiving Process through the SSIS on Production
• Create Simple Power Bi Reports Development and deploy/publish reports on production/workspace

Projects: -

1: - Implementing Data warehouse Project with different lines of business

Oct 2019 to May 2020 (8Months)

· Operations Team Performance Dashboard Agent wise of Personal Loan.

Providing the detailed summary on the dashboard with many forms like the business performance Nbfc wise and how much customers applied for the loan and how much out of them disbursed the loan Nbfc wise. Agent target, achieve goal, status applied for Nbfc percent, disbursed percentage.

· Pre-Qualified Loan Offers Generated For The Customers.

This project contains the information’s of businesses Products. And the offers generated for the New/Existing customers.

· Credit Score Report.

A credit report is a summary of how you have handled credit accounts, including the types of account and payment history, as well as certain other information that’s reported to the credit bureaus by the lenders and creditors. Its contains information in the forms :- Identifying information, credit account information, inquiry information, Bankruptcies, Collections accounts.

2: - Automation of Archiving

May 2019 to Oct 2019 (4Months)

· Implement the archive process functionality for the heavily transactional tables. Focus on ensuring the integrity of the archived data in its complete business context. Monitor, review and update documented archiving policies and procedures. Continue to improve the archive process to support ongoing business activities.

· Segregate historical business objects or transaction records from current activity safely move them to secure archive. Store archived historical records securely and cost-effectively.

3: - Credit Card

Dec 2018 to Jul 2019 (8Months)

· A credit card is a payment card issued to users (cardholders) to enable the cardholder to pay a merchant for goods and services based on the cardholder's promise to the card issuer to pay them for the amounts plus the other agreed charges. The card issuer (usually a bank) creates a revolving account and grants a line of credit to the cardholder, from which the cardholder can borrow money for payment to a merchant or as a cash advance.

4: - Line of Credit

Sep 2018 to April 2020 (1.8 Yrs.)

· A line of credit is essentially a reusable loan. You can borrow up to a certain limit, make minimum payments, pay interest, pay off your balance, and borrow again. You can repeat this process as many times as you like as long as your line of credit is open and in good standing. Personal Lines of Credit provide access to unsecured funds that can be borrowed, repaid and borrowed again. Opening a personal line of credit requires a credit history of no defaults, a credit score of 680 or higher and reliable income.

• T-SQL Created SQL Server Tables, Functions, Views, & Constraints
• Developing SSIS Packages which are automated
• Responsible for day-to-day tasks like re-indexing, checking integrity, backup and recovery
• Responsible for installation and configuration of SQL server 2012
• Fine tuning of database objects and server to ensure efficient data retrieval
• Designed and implemented incremental and full back up policies and procedures
• Design, Develop and Deploy SSIS Packages
• Identifying issues with the database and resolving them Developing database applications which are automated
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and derived Column
• Develop reports in SQL Server Reporting Services
• Created tabular and matrix reports in SSRS
• Wrote stored procedures and functions to create SSRS reports
• Loaded the data using the SQL loader, Imports & UTL files based on file formats
• Migrated MySQL Database language to Perl database language
• Daily Monitoring of SQL Server, Application Logs, Analysing the Logs, Database Performance and network issues
• Rebuilding the indexes at regular intervals for better performance

Projects: -

1: - Classing

Apr 2018 to Jul 2018 (4Months)

· This is the module of safeguard auto insurance company which offers the wide range for the customers. In this project design the functionality to find the missing class (contracts) for those contracts on which classing (means term duration) is pending or missing or updating is required. After set up the functionality easy to find the missing classing and setup classing is the very easy within a few steps.

2: - Xtracap-Fintech

Nov 2017 to Apr 2018 (6Months)

· Xtracap Fin-tech is a transformational business model which is designed to accelerate local GDP by moving small businesses in small town from unorganized to organized environment by enabling access to on demand liquidity and habit-forming technology applications. model is supported by a green field deep distribution managed by local partners who participates in profits & losses. The technology platform will be further be aided and enabled by Government of India initiatives of Digital India, thrust for lowing cash usage and Goods & Services tax.

3: - GST (Goods and Services Tax)

Feb 2017 to Oct 2017 (9Months)

· Accounts & Records to Maintained Under GST-Stock Register, Input tax credit availed, Output tax payable and paid, such other particulars as be prescribed.

· Return Submission-GSTR1, GSTR2, GSTR3, GSTR3B Upload and Submit all return using secure data network. Inputs Tax Credit Reconciliation-Match GSTR2A and GSTR2 to Minimize differences to maximize set of.

• Checking health of router, server, and switch and BSNL line on daily basis
• Performing the daily report generation and migrating data
• Maintaining both Dev and Production servers in sync
• Sample verification shared for migration with DC helpdesk
• Creation of user Databases and installation
• Performing form verification
• Fixing incremental data issue
• Provide the day-to-day support to client
• Resolve Feed backs and Tickets
• Troubleshoot Application Performance issues and functionality
• Co-ordinate to database teams for operational improvement and fix the issue