Resume - Data Analyst ,VBA,MIS , Reports , SQL


 
(Keywords : MS-Access , SQL 2000, 2005, VBA, VB6, Vb.net, MS-Excel (write & edit formulas, and Function as VLOOKUP, HLOOKUP, SUMIF,)
  
Home     Delhi Resumes   Gurgaon Resumes   Noida Resumes   BPO Call Centre Jobs

  Candidate Details
Position Sought :
Data Analyst ,VBA,MIS , Reports , SQL
Age :
29 years     Experience : 8.9
Qualification :
B COMM - PassDelhi University, Delhi 
Preferred Location :
Delhi, Greater Noida, Gurgaon, Noida
Job Category :
ITES/BPO/Call Centre
Expected Salary :
35000 PM

Resume



Data Analyst
Analyzing of data retrieved from Carrier and through our software and correcting of data in our Software
Role & Responsibilities

Process optimizations in all departments
Data maintenance, Analysis & Preparation of Monthly MIS Reports.
WD management MIS.
Commission Analyst report to payroll department
Daily bases Request and Fresh receipt Management report.
Daily bases pending open cases analysis and follow up to closed.
Looking Daily Dispatch activity.
Project wise Monthly stock Re-conciliation of in & out.
Data maintenance, Analysis & Preparation of Monthly MIS Reports.
Prepare weekly and monthly inventory report.
Handling Commission and Payroll Report
Reviewing All the Report they sent it to our client
Providing commission base analyst to the client, so that they know actual figure of the MIS
Making Work Easier(Using VBA, Marco, Vb6, Vb.net)
MIS preparation (In Excel)
Store MIS with Numbers of Activation, Returns, Accessory in $s, Feature in $s and Invoice Profit & Loss
This process is automated in Excel along usage of VBA.
Earlier Time Consumed = 45 Minutes
Now Time Consumed = 3 Minute
Extraction of Web-data from Webpage
Extraction of Each Mobile data from Cingular online database(POS)
like Customer Name, Address, Mobile Status, Total # of mobiles, Current rate plan, Years of Contract, Feature taken, IMEI and SIM in usage
Earlier time taken = 300 Seconds = 6 minute
Now Time Consumed = 10 Seconds = 0.16 minute
Extracting data from PDF Files
Extracting data from PDF Files like Agent Code, Mobile, Customer Name, Address, Mobile, Current rate plan, Years of Contract, Feature taken, IMEI and SIM in usage.
Consultant in Software Development of Commission Module
Consultancy to programmer regarding how to make software faster and accuracy. Providing logic to the developer
Commission module related to
Paid and Non paid mobiles in #s and in $s
Rate Plan Changes
Deactivation
Reconnect
Commission Summary Reports
Consultant in Software Development of Audit Module
Consultancy to programmer regarding how to make software faster and accuracy. Providing logic to the developer
Audit module related to
Correcting Mobile, Sim, IMEI, Customer Name, Address, Rate Plan, Term, Feature, Plan Type
Audit Reports
Projects in Access
CRM Software : for calling purpose review the account adding disposition and other
Payroll System Report : This software make the salesperson Payroll according to given criteria
Crosstab Queries To Retiring data from the Access to Excel
full reporting System and auditing system in access
Others Responsibilities
Communication to Client
Communicated to client regarding suggestion, changes and support. Troubleshooting
Providing Process deployments Suggestion to the client

Maintenance of computer hardware and software. Troubleshooting of software and hardware.
Solid understanding of the analysis/ software development process. Proficiency in analysis/ troubleshooting and understanding and implementation of system.
Strong Communication Skills
Coordination with manager and other departments for operations.
Excellent knowledge of VBA, Marco and Web browser Control to make work easy
Experience in workstation rollout and support in corporate environment.

Key Skills
MS-Access, MS-Excel (write & edit formulas, and Function as VLOOKUP, HLOOKUP, SUMIF, IF, AND, OR, COUNTIF, TRIM, CONCATENATE, PIVOT TABLE, etc. ) and Macros, Graphs. SQL 2000,2005, VBA, VB6, Vb.net
Technical Skills:
Operating System : Windows XP,2000, Linux 8.0
Languages : VB, Core Java, C, C++.
Database : SQL, SQL, Mysql 5.0,
MS Access
Web Technologies : HTML, JavaScript, Vb.net, Vb6, Vba

Packages : MS Office,2000, Front Page, Open
Office (Linux), Photoshop CS, Flash MX

Educational Qualification
Intermediate from C. B. S. E
Graduate From Delhi University(2007)
Advance diploma in software Technology From ET&T (ADCST)
Certified in Web designing from Arena Multimedia
Photoshop and Multimedia flash
Sound knowledge in networking desktop and network printer configuration.
Typing Speed 30 w. p. m. with 95 % accuracy 
Top