Data Analyst Developer

RAVI KANT

E-Mail :- adcl12@r.postjobfree.com

Contact :- +91-989*******,807-***-****

Seeking assignments in Automation / SQL Development / Web Harvesting / Data Analysis / Developing Area. Also looking for challenging and rewarding opportunity which is in line with my professional and academic background and which effectively utilizes my analytical and technical skills

Professional Summery :-

Presently working as a System Developer in IBM India Pvt Ltd.

Worked exclusively on Automation and Reporting.

Proven expertise in performing data analysis & data management.

Good knowledge of WinAutomation, VBA, SQL Server, MS Access, MS Excel, SSIS, Visual Basic 6.0

Develop requirement specification and technical document.

A highly motivated, energetic individual, a team engineer and a team player with excellent analytical and problem solving skills and interpersonal skills.

Worked extensively on Production Support (including backend support).

Technical Skills :-

Platforms :- XP, Windows 7

Language :- Visual Basic 6.0

Application/Tools:- WinAutomation, VBA, SQL Server, MySQL, SSIS, MS-Access, MS-Excel, MS-Word, MS-Powerpoint,

Professional Qualification :-

Completed MCA from IGNOU University in 2016.

Completed BCA from IGNOU University in 2012.

Working Experience :-

1.Organization :- IBM India Pvt. Ltd., Gurgaon

Client :- Verizon (VZ)

Tools :- WinAutomation, VBA, SAP, Oracle 12, Sql Server, MS Access, MS Excel

Designation :- System Developer

Decision Support System :-

Designed, developed and implemented highly efficient and reliable test infrastructure. Design and develop tools and scripts for product and solution test automation. Indentifying improvement opportunities in the project/applications/proceses. Investigate and evaluate new techniques and tools for continuous improvement.

2.Organization :- GNAP Services Pvt. Ltd., Noida

Client :- Nokia Solutions And Networks India Pvt Ltd.

Tools :- VBA, Sql Server, MySQL, MS Excel, MS Word, MS PowerPoint, MS Access

Designation :- VBA Developer

Decision Support System :-

Improving Information Systems, Developing applications and handling quality assurance task. Create Dashboards and automate common spreadsheet task. Wrote a multitude of Excel VBA & Sql Scripts and queries to compile and standardize raw data into a clean enrty format. Generated code for Automation of Reports.

3.Organization :- Competent Software Pvt. Ltd., Noida

PROJECT1 :- Dragon (DATA EXTRACTION, TRANSFORMATION & LOADING)

Client :- First American (FA)

Tools :- ETL Tool Dragon, Sql Server, MS Access, MS Excel

Designation :- Data Analyst

Decision Support System :-

Designed, developed and implemented Dragon ETL jobs to process very high-volume data sources. Developed Dragon Parallel jobs using various built in stages such as Derived Column, Join, Multicast.

PROJECT2 :- RPData (DATA AGGREGATION)

Client :- Corelogic U.S.A.

Tools :- SQL Server, VB6, Visual Studio, MS Access, MS Excel, VBA

Designation :- Data Analyst

Decision Support System :-

Databases to extract data from different types of Property, Building, Transaction&Tax related websites. We provide the most current information related to the Properties, Transactions etc to the client as per the requirements of client.

PROJECT3 :- Web Scraping & Building Permit Project

Client :- Corelogic U.S.A.

Tools :- Visual Basic 6.0, MS Access, MS Excel

Platform :- Windows-07

Designation :- Data Analyst

Decision Support System :-

Web Scraping & Building Permit Project is a method to extract data and information from a website. Multiple tools and techniques are utilized to scrape hundreds of distinct websites. We provide the most current information related to the Parcel/Permit, Property, Tax etc to the client as per the requirements of client.

Responsibilities :-

Involved in Website analysis, code developmet, database management.

Involved in requirement gathering, created mapping documents, assisted in code debugging and documentation to the developers.

Creating and executing SQL checks required for high quality output. Managing the Quality Assurance team.

Created technical design documents and conducted code reviews within the team.

Work as team member in support and enhancement.

Report Preparation for business user.

Delivering quality output for shipment on the delnivery date.

Created technical design documents and conducted code reviews within the team.

Project4:- Core Logic Keying

Designation: - Process Associate

Responsibilities :- In this project, we have to key different types of Real Estate documents such as Mortgage, Deed, Deed of Trust, Lien, and Foreclosure and so on from different resource files.

Academic Details :-

Completed 12TH from C.B.S.E in 2008.

Completed 10TH from C.B.S.E in 2006.

Personal Details :-

Date of Birth - 16th Feb 1990

Contact No. - +91-989*******,807-***-****

Gender - Male

Email id - adcl12@r.postjobfree.com

Marital Status - Unmarried

Language - English & Hindi

Permanent Address - H.No-4C, Street No-2, East Guru Angad Nagar, Delhi – 110092.

Declaration :-

I hereby confirm that the information provided in this document is accurate and true to the best of my knowledge.

Date :- Ravi Kant

Place :-

Contact this candidate