Data Analyst Project

N S

Redmond, WA ***** • Home: 206-***-**** • *******@*****.***

Professional Summary

Dedicated and motivated data analyst seeking a position in a fast-growth company. Proven ability to drive process efficiency and data integrity as evidenced by 4+ years of experience leading teams in data mining and data warehousing solutions.

Authorized to work in US on H4 EAD.

Skills

SQL Report automation

VB Script (Macros) Data validation automation

Advanced Excel and MS Access Data validation

Shell Scripting Data analysis

Python Business needs analysis

Work History

Performance Management Engineer, 02/2016 to 01/2018 Altran

Responsible for Performance Management of 4G LTE of Network for UP East & West Circle and of 2G (GSM) of Network for Bihar Circle.

Automated the report generation process for critical reports by creating 8 macros and saving 2 headcount for Altran.

Automated the data quality checks on reports by creating 2 macros which saved 4 hours of effort each day.

Generation of 32 critical reports like Daily Peak VLR (Visitor Location Register) Report, 24 Hrs KPI report which contains 24 hrs KPI such as TRX Count, SD Block, SD Congestion, etc. of 2G Networks. Successfully led a team of 2 people to complete 2 projects. Achieved Excellent Performer of the Year Award from my employer. Created 12 macros and provided support for 27 macros. Data Analyst, 05/2014 to 02/2015

Apex Services

Responsible for Aadhaar Project as Data Analyst.

Integrated data from multiple sources for Unique Identification Authority of India (UIDAI) portal. Automated the process of data cleansing (deduplication, completeness) and formatting using macros. Also generated the report of records with inconsistencies. Generated a report to track the progress of 20+ field officers on a daily basis to be shared on UIDAI portal.

Installation and troubleshooting of Aadhaar Software. Briefing all the Supervisors and Operators in the field on daily basis by Phone and note down the production and update in the Production MIS.

Give the technical support to camp worker directly or give the support through team viewer, on-boarding the operators and supervise the kit.

Export the CIDR Packet after doing the enrollments and synchronize the kit and also manage the EOD report.

Register/ de-register the kit, check all the kits are working properly and identify the problems, if occur, in Aadhaar Software.

Maintain the records of Camp Kit, arranging the DMIS file date-wise and keep the record in excel sheet and all the excel details are shared to UIDAI Portal. Database Administrator, 02/2013 to 04/2014

ITI Limited (A Govt. of India Undertaking)

Responsible for National Population Registry Project (NPR-40 Project) as Database Administrator. Installation of Linux RHEL 6.1 and different applications (DTWS, PRE-ENROLLMENT DATA WIZARD, SFTP etc.) related to the Project.

Troubleshooting, Handling of Client-Server architecture for Data-Entry Applications. Collection of Data and verify data with different applications, creating Databases and separate each Database according to state, district, tehsil and village. Scheduling of backup of data, updating BME Report and report preparation according to different Data Packets status.

Uploading of Data Packets to the Unique Identification Authority of India (UIDAI) Server. I was deputed to ITI Limited, Palakkad (Kerala), a Govt. of India Undertaking, for checking and submission of NPR-40 Project related data during 13th March, 2014 to 1st April, 2014 (20 days). Developed software to detect duplicate records entered by the vendors of NPR-40 Project. Part-Time Counselor, 09/2012 to 01/2013

IGNOU Study Centre

Taken theoretical and practical classes of Bachelor of Computer Applications (BCA) and Certificate in Information Technology (CIT) students.

Education

B. Tech: Computer Science & Engineering, 2012

Gwalior Institute of Technology & Science - Gwalior (M.P.) India Graduated with 71.53%

Intermediate: Science, 2008

St. Michael's Convent School - ITI Mankapur, Gonda (U.P.) India Graduated with 55.40%

High School : Science, 2006

St. Michael's Convent School - ITI Mankapur, Gonda (U.P.) India Graduated with 67.60%

Contact this candidate