Resume

Sign in

DatabaseDeveloper

Location:
Sunnyvale, California, United States
Posted:
October 26, 2016

Contact this candidate

Nidhi Manish Shah

**** ********* ******** ** ***-6, Sunnyvale, California-94087

Phone: +1-623-***-**** E-mail: acw815@r.postjobfree.com

Education

§ Pursuing Master’s degree in Computer Science at Santa Clara University, CA Jan 2016 – Present

§ Bachelor of Engineering, Electronics & Communication Engineering Jul 2007 – Jun 2011 L.D. College of Engineering, Gujarat University, India GPA: 3.44/4.0 Related Coursework

§ Database Systems Data Structures Analysis of Algorithms

§ Operating Systems Data Mining Fundamentals of Programming Paradigm

§ Data Communication & Networking Software Engineering Advanced Microprocessors Technical Skills

§ Programming Language: SQL, PL/SQL, Java, C/C++(Basic)

§ Database: Postgres Plus Advance Server 9.1/9.2, Oracle 10g/11g, MySQL

§ BI and Reporting Tools: SAS Data Integrator 4.8 ETL Tool, SAS Visual Analytics reporting Tool version 7.2, BIRT Tool

§ Data Modeling: Data Warehouse Logical, Physical & Relational Modeling, ER Diagrams, Dimensional Data Modeling (Star Schema Modeling, FACT and Dimensional Tables)

§ Database Tools: PgAdmin III, Postgres Enterprise Manager, Oracle SQL Developer, TOAD

§ Web Development: CSS, JavaScript, HTML

§ Other Tools: WinSCP, Squirrel for SQL, Putty, SQL Power Architect, SVN

§ Operating System: Windows, HP-UNIX, LINUX, Ubuntu Work Experience

TATA Consultancy Services

Ahmedabad India

§ System Engineer at Tamil Nadu Value Added Tax Feb 2014 – Aug 2015

- Understand basic concept of data warehouse, data modeling and data integration

- Data migration, ETL process and basic concept of business intelligence.

- Worked on all major aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development and Data cleansing and Data migration, and reporting solutions).

- Installation of PPAS 9.1,9.2 at the Local Server

- Handled and managed offshore databases Servers

- Analyze and understand Business Requirements of all modules of Tamil Nadu VAT projects and developed corresponding objects i.e. Packages, Procedures, Functions, Triggers, Views and other DB objects.

- Used Dynamic SQL Queries, Database Links, and Cursors at different stages during development phase.

- Handled Exception in procedure as well as in function to make subprogram run flawlessly

- DB Patches and Database Scripts management at offshore and onsite

§ System Engineer at Kenya Revenue Authority Oct 2013 – Jan 2014

- Analyzed Business requirements and prepared design documents.

- Developed Packages, procedures, functions and other database objects.

- Maintenance and monitoring of all database environments available at offshore as well as onsite.

- Performed Database administration related task for example Database dump, Database restoration and DB patch management

- Analyzed, developed, tested and monitored front end reports using TCS MIS reporting framework

§ Assistant System Engineer at Vodafone India-Unify Operation Feb 2013 – Oct 2013

- Analyzed Business requirements and prepared design documents.

- Developed Packages, Procedures, Functions and other database objects.

- Maintenance and monitoring of existing logic in Database components and front end reports.

- Unit testing/System testing and UAT issue resolution.

- Designed and developed Frontend reports using BIRT Tool.

§ Training

Initial Learning Program (ILP) at TCS Gandhinagar, Gujarat Oct 2011 - Jan 2012

- BASE SAS coding practical training.

Leadership and Participations

§ Organized and managed inter-college robotics competition and other events

§ Imparted guest lectures to high school students in Public Schools on an honorary basis Academic Achievements and Scholarships

§ Stood among the top 10 students in all 4 years of Electronics & Communication Engineering (2007-2011)



Contact this candidate