Data Entry Project

CURRICULUM VITAE

Santhi.D Email id: *************@*****.***

Mobile No: +91-953*******

Proficiency in reports preparation by using Excel –VBA and using Excel functions, MS-Access Developing, Ms-Access Reporting, SQL Queries and Analysis in SPSS.

Knowledge of MIS, Designing performance reports of Out Bound and In Bound Department/ Mobile Channel Marketing Dept. Graphical Representation by using Charts. Preparing Invoices and sending the info to finance at the end of the month for raising final invoices on client for account receivables.

Four years of experience in medium and large applications that required client interaction, usability requirements, data analysis, design and development.

EXPERIENCE SUMMARY

Total work experience: 4+ years

4+ years of experience in Developing, Reporting & analysis, which includes the followings: -

1. Product – Implementation in Excel functions and Excel-VBA Macros, VBA Access Programming.

2. SQL Server 2005 Queries and MS Access developing(forms, tables, programming), reporting.

EDUCATIONAL QUALIFICATION

• Bachelor of Science (Mathematics, Physics and Computer Science) from Nagarjuna University in 2003.

SOFTWARE AWARENESS

Programming Knowledge : MS-Access developing using VBA, SQL Server

Reports : MS Access Reports, Excel-VBA Reports

TECHNICAL SUMMARY

• Developed the MS Access databases by using VBA.

• Developed and Customized the MS Access reports and reports preparing by using Excel-VBA macros.

• Preliminary analysis done by using Access Queries and SPSS.

• Fetching various logs from our interval servers by using SQL queries to prepare reports.

• Providing / preparing the reports as required by Operations Managers/Finance Department/Technical Dept based on various factors.

• Preparing Invoices and sending the info to finance at the end of the month for raising final invoices on client for account receivables.

Current status

• Worked as Sr. Data Analyst(MIS) in Voice gate Technologies PVT Ltd. (VGT), Hyderabad from Jul 2011 to Mar 2012.

• Worked as Data Associate in Public Health Foundation of India (PHFI), Hyderabad from Jan 2010 to Jul 2011.

• Worked as Data Associate in George Institute for International Health (GIIH), Hyderabad from Jul 2007 to Jan 2010.

PROFESSIONAL EXPERIENCE

Project #1

Client : Airtel, IDEA, Tata Docomo, Uninor

Team Size : 3

Platform : MS Access VBA, Access Reports, Excel, Excel –VBA macros

Role : Data retrieving from internal servers by using SQL queries and data analysis by using MS-access queries.

Reports preparation by using MS Access reports and data manipulations by using Excel-VBA macros.

Different type of reports preparation as per the client’s requirement by using excels functions like Pivot tables, Charts, graphs.

Raising invoices for finance departments and invoice reports preparation by using excel functions and macros for the preparation of individual Clint wise and operator wise revenue purpose.

Project Description: Voice Gate is a leading provider of auto outbound dialers, Interactive Voice Response System, Multi Level Music Solutions to almost every Indian Telecom operator. Auto Outbound Dialing (OBD) dial out calls to a list of mobile users provided by the Operators to promote and sell Value Added Services like, Caller Ring Back Tones (CRBT), News, Stock Market updates, Jokes and Health Tips, etc,.

Project #2 & Project #3

Title : HIV_Truckers & Roadsafety (HIV_Truckers & Cleaners) & HIV_Household

Client : PHFI, Hyderabad

Team Size : 2

Platform : MS Access VBA, Access Reports, Excel –VBA macros

Role : Perform to convert the data from Microsoft Access to SPSS software and done the preliminary analysis by doing frequencies, crosstabs, comparing means….etc

Develop research study data entry software in Microsoft Access by using VBA code, Quality checking of the research study data entry software with hypothetical data & data validations.

Perform data cleaning, data checking & data validations of research study by using excel functions like V lookup, Pivot tables, charts, and etc, reports preparation by using Excel-VBA macros, ms-access queries and reports.

Project Description: HIV_Truckers & Roadsafety (HIV_Truckers & Cleaners): HIV and herpes infections are very common in India. Herpes is disease that is transmitted sexually and it makes it easier to get HIV infection. Because there is currently no cure for HIV and herpes, the purpose of this study is to help develop methods that can reduce behavior that can increase the chances of getting HIV or herpes infection.

Project Description: HIV_Household: Household level HIV and herpes infections are very common in India. Herpes is disease that is transmitted sexually and it makes it easier to get HIV infection. Because there is currently no cure for HIV and herpes, the purpose of this study is to help develop methods that can reduce behavior that can increase the chances of getting HIV or herpes infection.

Project #4

Title : Population Health Metrics Research Consortium

Client : GIIH, Hyderabad

Team Size : 6

Platform : MS Access VBA, Access Reports, Excel –VBA macros

Role : Perform to convert the data from Microsoft Access to SPSS software and done the preliminary analysis by doing frequencies, crosstabs, comparing means….etc.

Review the research study questionnaires for data entry software’s development, Train the Data Associates for entry and checking of research study in data entry software’s, Perform receiving and checking of physical folders from field. Prepare the participations for research study.

Develop research study data entry software in Microsoft Access by using VBA code, Train the Data Associates for entry and checking of research study in data entry software’s, Perform receiving and checking of physical folders from field. Prepare the participations for research study.

Perform data cleaning, data checking & data validations of research study by using excel functions like V lookup, Pivot tables, charts, and etc, reports preparation by using Excel-VBA macros, ms-access queries and reports.

Project Description: The George Institute is a global health organization is Working to reduce the burden of deceases. The George institute conducted a Household census study in Andhra Pradesh to find measuring mortality and funded by Melinda and Bill Gates foundation. The object of this study was to develop and test new methods for measuring mortality lacking good civil registration data.

Personal Profile:

Full Name : Santhi . Dasari

Husband’s Name : Venkata Srinivas .V

Gender : Female

Address : Lake view colony, Nizampet road, Kukatpally, Hyderabad.

Declaration:

I hereby confirm that the above information is correct to the best of my knowledge.

Date

Place: Hyderabad

(SANTHI D)

Contact this candidate