Satish Kumar T. Profile

JELAJAHI

4,6

(58 ulasan)

Sekarang Anda mengikuti

Kesalahan mengikuti pengguna.

Pengguna ini tidak mengizinkan pengguna mengikuti dia.

Anda sudah mengikuti pengguna ini.

Paket keanggotaan Anda hanya boleh punya 0 follow. Tingkatkan di sini.

Berhasil berhenti mengikuti

Kesalahan mengikuti pengguna.

Anda telah berhasil merekomendasikan

Kesalahan merekomendasikan pengguna.

Ada sesuatu yang salah. Silakan muat ulang halaman dan coba lagi.

Email berhasil diverifikasi.

$30 USD / jam

chennai,

india

$30 USD / jam

Saat ini 8:31 PM di sini

Bergabung Juni 9, 2014

3 Rekomendasi

Satish Kumar T.

@satishtl

4,6

(58 ulasan)

6,1

87%

$30 USD / jam

chennai,

india

$30 USD / jam

97%

Pekerjaan Selesai

68%

Sesuai Anggaran

68%

Tepat Waktu

11%

Tingkat Rekrut Ulang

Excel/VBA/Data Analysis/SSIS/Power BI/MSAccess/SQL

Bachelors in Engineering - Computer Science o Expertise In: (Excel, SSIS, Power BI,MS Access, VBA, Data Entry, Webscraping. o eCommerce Data Mapping - eBay, bigCommerce, SalePresenter o Excel - Excel Macros programming, automation, VBA, formulas using data extraction from file and data sources, consolidation, populating graphs, pivot table, lookup,, Excel - Formulas,. Data import/export. o Outlook, Word - Word Template automation, Outlook mails automation. o Data analysis, data extraction from website, populating data on to websites. o MS Access - Designing forms for user input, building reports, Databased designing. Build full fledged software for small institutions on their customized needs. o Database - MS Access, Database Programming, SQL, MYSQL, importing exporting, extraction and modifying data. o Dedicated and would complete to the timelines committed. o Would provide additional support for minor issues/changes to have customer satisfaction and build a long time relationship.

Lihat semua Excel Experts in India

Hubungi Satish Kumar T. mengenai pekerjaan Anda

Portofolio

- Need to generate the XML from the existing XSD file for the data provided in Excel.

- Based on the Number of Orders separate XML files needs to be generated for each of the Order with multiple Line Items
- The scriptiing logic
Checks for each order multiple lines items and creates on XML for each Order.
- The similar logic to generate Purhcase Order XMLs.

XML Generator from Excel Data

- Client needed to know the Contracts that are coming up for renewal.
- Based on the Current Quarter selected each Quarter will have the contracts that would be listed that are due to expire.
- Be able to calculate the summary - Best Case, (BC), Worst Case(WC) and Most Likely (ML)
- Able to filter the data based on different parameters like the AI Score, MRR low and High etc.
- View of the data in multiple formats ranked by AI, WRRr, EvA, SvA, Evp etc.

- Finally show the TopRanking accounts.by selecting the Account Executive and the cutoff parameters.

Contracts - Renewal and Analysis

- Required 50+ vendor files to be mapped to the bigCommerce template for bulk uploading to the site.
- Each vendor had different format, which was made consistent using the mapping and the Products were ported to the target file.
- Included additional logic during the data conversion like Foot to inches, KGs to LBs, dimension calculations, Cost price from List price with any additional charges, based on the vendor image files suit the best for the Big Commerce template image fields.
- Based on the Model, MPN or SKU the parent child relationship bought in the logic for bulk uploading.

- Attached are the samples of Vendors - OW, Nourison, Dimond the source and the target files.
- Have done similar for eBay Turbo Lister, Google Merchant, SalesPresenter

eCommerce Store : Vendor to Store mapping for Bulk Upload

- To create a Roster Coster - used to work out staffing cost and hours based on the projected occupancy of an accommodation camp.
- Based on the Staff Master for each individual site, the Rostering for a fortnight is done depending on the shifts worked.
- Each employee is assigned to a particular site, department, wage type(Salaried, Wage,Labour Hour)
- Depending on the Salary category they are assigned to the salary is calculated.
- Salary componenent is based on Number of hours worked, removing break hours, seeing its a Public Holiday, Sunday, Number of OT hours worked.
- Also the leave types PL, SL, RDO are considered for the salary calculations including Loadings.
- After finalising the Roster the Occupancy projection is calculated for each department.
- Actauls are recorded in Staff Attendance and the salary calculation is done again, adding or removing employee for the site based on the Actuals.
- Finally the report generated as Roster for the fortnight for staffs.

Roster / Staff Attendance - Wage Calculations

- Data points(48) across dynamic rows of date period of units consumption
- Calucations based on SheetA and SheetB and populating SheetC.
- Dynmically generating Bar, Pie charts for Monthly Totals, %Total.
- Scatter chart - with the axis and the Weekly color indicators being dynamically set.
- Surface charts having 10 legends, dynamically populating the color and the axis ranges, gridlines
- Depending on the total period the number of Surface Charts auto generated
- Couple of line Plots for special day, and the average of 48 data points.

- After the user input, and clicks the button the entire sequence of calcuations and Graph generations are done and shown in respective tabs.

Data Analysis and Dynamically generating charts.

- Getting the Calendar events Tasks, Appointments from Outlook including the Categories.
- Removing some of the events based on conditions.
- Also for the incoming mails, automatically detect certain verbiage in the mails and tracnform them to a modified content and have the mail forwarded to a different mail id.

Outlook Automation

XML Generator from Excel Data

Contracts - Renewal and Analysis

eCommerce Store : Vendor to Store mapping for Bulk Upload

Roster / Staff Attendance - Wage Calculations

Data Analysis and Dynamically generating charts.

Outlook Automation

Ulasan

Perubahan tersimpan

Menampilkan 1 - 5 dari 50+ ulasan

Filter ulasan menurut:

5,0

$20,00 USD

Conditional formatting, using Countif to find dupes in 2 worksheets

Excellent

Excel

Ernest B.

@Etbrown4

•

4 tahun yang lalu

5,0

$700,00 USD

Censo forestal - excel macro

His way of work, in fact, very organized and accomplish the project

Excel

Daniel C.

@danieldelta4

•

6 tahun yang lalu

5,0

$125,00 USD

Excel to XML

We presented a challenge to Satish to generate an excel spreadsheet that would export a multi layered piece of XML. The project was completed ahead of time and on budget. I have no hesitation in recommending or considering him for other opportunities.

XML

Excel

Michael H.

@mickhall23

•

6 tahun yang lalu

1,0

$30,00 AUD

Access DB Maintain and Update

Slow progress and job cancelled

Michael C.

@mclavien

•

6 tahun yang lalu

5,0

$625,00 AUD

Excel Data dashboard

Satish exceeded my expectations from the start. I had a complex project and during our hour long discovery call before I had agreed to award him the project he took the time to understand and make suggestions for the project. Satish worked tightly to our agreed timeline and delivered a great first version. We worked together to perfect the functions which has lead to a great document that will be heavily used on a daily basis. Hire him!

Kevin H.

@kevinjhillier

•

6 tahun yang lalu

Pengalaman

Freelancing, Blogs, Forums

Sep 2004 - Mar 2014 (9 tahun, 6 bulan)

Have extensive experience in Excel, VBA, Macro programming, automation. Created data consolidation, validation used for report generation. Have good handle on MS Access - Tables, Queries, Forms, Procedures. GUI Dedicated and would work for satisfaction of customers. WIll maintain timeline and quality of work. Would be a stand by person for supporting employees on the assignment completed.