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)