AWEC

Posted on: 2010-05-06

Mandira Sanyal

Email : [email protected]

 

 

Employment History

4/2009 - Current; Wyoming State Geological Survey, Laramie, WY (Database Management)

9/2003 – 1/2009; Trihydro Corporation (Database Technician, Business Information Product and Services - Technical Support)

9/1995 – 8/1997; Temple University (Teaching Assistant)

Skills / Training
/ Experience

 

 

Software Development :

  • Requirement gathering and Analysis, use-case analysis and determination of functional
     requirements, layered architecture design
  • Documentation and User-Guide development geared towards providing user-support
     and training
  • Analyzed/designed (object-oriented programming) code for web application including
    developing Process-Data Flow diagrams
  • Knowledge of software development lifecycle
  • Data Modeling
  • Knowledge of object oriented programming
  • Visual Studio Web Developer and Visual Basic.NET
  • Providing feedbacks on software-tools to help make the software-tools meet the needs of end-user

 

Software :

  • MS Office 2007 including Microsoft Access, Microsoft Excel,Powerpoint
  • SQL Server including SQL Server Management Studio
  • Adobe Acrobat
  • Visio
  • ER Studio for data modeling

 

Database :

  • Client-Server database
  • Data Entry
  • Relational database design and implementation
  • Database Management including database-project requirement analysis, data modeling, schema design, data security, query
    designs, reporting in Microsoft Access
  • Migration of data from Microsoft Access to SQL Server ensuring/testing data integrity
     ok and data accuracy
  • Used SQL Server Management Studio to manage databases on SQL Server including
     writing SQL queries  and stored procedures in TSQL
  • Data modeling (using data modeling software) and related needs analyses
  • Analyzed and reported interactions between SQL Server and ER Studio on transferring schema information between the two applications
  • Providing database and reporting solutions for different Project Teams within the company

               

Business Process Modeling :

  • Business Process Modeling for analyzing business processes (and related information) including requirements for software-tools, communicating with team members – Context Diagrams, Workflow, Process Diagrams
  • Documentation of Business Processes and tasks
  • Software Used :  Visio

Client Relations :

  • Worked with plans on Client Relations
  • Following quality assurance procedures to ensure delivery of quality services

 

Training :

  • Project Management – Scrum
  • Verbal and Non Verbal Communication Skills                  
  • Geographic Information Systems (Certificate Of Completion from ESRI, December 2009) :-

                       Learning ArcGIS Desktop (for ArcGIS 9.0 – 9.1)

        Creating and Editing Geodatabase Features with ArcGIS 9.0 – 9.1 (for ArcEditor and
        ArcInfo)

        Basics of Geodatabase Data Model

        Creating and  Integrating Data for Natural Resource Applications (for ArcGIS 9.0 – 9.1) -
        Inprogress

 

Communication :

  • Communicating with clients on their specific needs including follow-ups on requests
  • Communicating via emails and verbally including phone conversation
  • Planned and created user-guides for software-product to aid with user-training and support, provided feedbacks for product improvements and enhancements
  • Conducted and attended meetings
  • Worked with software-development team in creating user-guides for user-support
  • Communication with supervisors and peers on carrying out tasks, training issues and goals
  • Worked with supervisor in preparing cost estimates
  • Project Management and Task Organization; Scrum; created agendas, set up weekly
     meetings
  • Determining the business-need for existing software with supervisors
  • Documented routine tasks to increase efficiency and to aid with the training of new employees

 

 

Research :      

  • Identifying an original research topic and field research site
  • Conducting field and lab experiments, literature searches and writing a master’s thesis, coordinating tasks and completing my thesis on the Effect of Trees on Acid Rain, coordinating with thesis advisor, preparation and presentation of my research results at a conference (American Geophysical Union)         

                    

Publications / Honors/ Memberships

  • Member Phi Kappa Phi
  • Abstract of Masters Thesis published in Geological Society of America, 1997
·          Outstanding Student Paper Award recognized by the American Geophysical Union, 1997 - Mandal, M, Grandstaff, D.E., 1997, Chemistry of Throughfall and Soil-Moisture and Their Role in Biogeochemical Cycling in the Pine Barrens, New Jersey: Spring Meeting of the American Geophysical Union, Baltimore, Maryland      

Education

  • Completion Date: 5/2003,  University of Wyoming,   Laramie, WY

 

Bachelors Degree, Management Information Systems (GPA : 3.91)

  • Completion Date: 8/1997,   Temple University,  Philadelphia, PA

          Masters Degree, Geology/Geochemistry (GPA : 3.80)